[Opensim-users] Fresh standalone install wants table.GridUser

[Peter Petroff]

Hi Opensim-users,

    Wanting to get my feet and whole body wet back into OpenSim, it's
been some time. But something with the databasing is broken and I've
failed to work out what.

    OpenSim, a Standalone installation, is claiming there ought to be a
table in the MySQL database called "GridUser" that is not there.

    Devuan ASCII 2.0 like Debian Stretch 9, amd64; fresh install of
0.9.0.1 re-downloaded today. Trying to use MySQL (actually MariaDB),
also freshly remove --purged. Yes indeed I have mono-complete and not
mono-runtime.

    On attempting to log in (with latest Singularity alpha build 6994 "9
months ago"), OpenSim's console reports to me:

19:35:17 - [LLOGIN SERVICE]: Login request for Peter Petroff at last
using viewer 1.8.7.6994, channel Singularity Test 64, IP
aaa.bbb.ccc.ddd, Mac ________________________________, Id0
________________________________, Possible LibOMVGridProxy: False

19:35:17 - [AUTH SERVICE]: Authenticating for
64d77e28-7e5b-48a0-ae63-46a232787657, user account service present: True

19:35:17 - [LLOGIN SERVICE]: Exception processing login for Peter
Petroff: MySql.Data.MySqlClient.MySqlException (0x80004005): Table
'opensimdb.GridUser' doesn't exist
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in
<0004ab8b375b422f9000ac25a68089d9>:0
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32&
affectedRow, System.Int64& insertedId) [0x00000] in
<0004ab8b375b422f9000ac25a68089d9>:0    at
MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in
<0004ab8b375b422f9000ac25a68089d9>:0
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32&
affectedRow, System.Int64& insertedId) [0x00000] in
<0004ab8b375b422f9000ac25a68089d9>:0

19:35:17 - [PRESENCE SERVICE]: LogoutAgent: session
77a33b5d-0fac-4556-b881-e3ec7fee8042, user , region



    So, the account/user exists. The database exists and OpenSim is
communicating with it, but unlike the advice given in the
Troubleshooting page, this is NOT a migration (and the relevant table in
the database has null values anyway):



# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 58
Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]> use opensimdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [opensimdb]> show tables;
+---------------------+
| Tables_in_opensimdb |
+---------------------+
| AgentPrefs          |
| Avatars             |
| Friends             |
| UserAccounts        |
| assets              |
| auth                |
| bakedterrain        |
| estate_groups       |
| estate_managers     |
| estate_map          |
| estate_settings     |
| estate_users        |
| estateban           |
| inventoryfolders    |
| inventoryitems      |
| land                |
| landaccesslist      |
| migrations          |
| primitems           |
| prims               |
| primshapes          |
| regionban           |
| regionenvironment   |
| regionextra         |
| regionsettings      |
| regionwindlight     |
| spawn_points        |
| terrain             |
| tokens              |
+---------------------+
29 rows in set (0.00 sec)

MariaDB [opensimdb]> describe migrations;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| name    | varchar(100) | YES  |     | NULL    |       |
| version | int(11)      | YES  |     | NULL    |       |
+---------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

And there is very definitely no table in the database called "GridUser".
I thought I'd configured this for standalone.

I've had a look at the GridUser table structure at /wiki/GridUser. I can
see it's nothing obviously related to a Grid versus Standalone table (do
I have to manually SQL-build such a table?).

I haven't seen any references to other people having this issue, at
least not in the last four months of the OpenSim-users' mailing list.

And I can see others have been using MySQL or MariaDB with no problems.

Even though it's not a migration issue, I HAVE quit OpenSim, dropped the
migrations table and re-run, to no effect.

... not to mention (a separate problem?) I can make changes to MariaDB's
my.cnf and /etc/init.d/mysql reload them, but if I try to mysql stop and
mysql start them, MySQL/Maria fails and refuses to restart.

Have I misconfigured something? Or do I have to (for whatever
incomprehensible reason) revert to the "'out of the box' in standalone
mode - no code compilation or other installation required" of the SQLite
database?

Would greatly appreciate any advice and pointing to what I've missed please,


P.