Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008473opensim[GRID] Robust Serverpublic2019-02-06 04:402019-02-07 04:34
ReporterDanger Lytton 
Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Versionlatest release
Product Version0.9.0.1 
Target VersionFixed in Version 
Summary0008473: Robust and regions not connecting to mysql database
DescriptionMy Linux server is running Ubuntu 14 and Mono 5.18 (the latest stable release).
Robust and Opensim.inis do not connect to the mysql database

The Linux server is in all regards exactly the same as another server I am using except for the mono version. The other server is using mono 5.12 and Robust works on it with no issues.

So, it appears to me that the issue is Robust does not function correctly under mono 5.18.

 
Additional InformationAll of the servers are using the same grid code and the latest version. I compiled all of them using msbuild and all appeared to compile correctly. The new linux server used mono 5.18 to compile the software. I also tried using the release that Dan Banner posted. It also did not work.
TagsNo tags attached.
Git Revision or version numberlatest release
Run Mode Grid (1 Region per Sim)
Physics EngineOther
EnvironmentMono / Linux64
Mono Version5.x
Viewerfirestorm
Attached Files

- Relationships

-  Notes
(0034335)
Monamusa Kaliopov (reporter)
2019-02-06 05:11

I do not want to scream too loud now but that does not work quite well under Mono 5.18 seems familiar ... (freeze problem)
(0034336)
UbitUmarov (administrator)
2019-02-06 07:34

just telling "does not work" can only get a answer, "oh we are sorry for you"
we need more information to try to do better than that,
to start, what are the related errors on the log files..
(0034338)
BillBlight (developer)
2019-02-06 10:20
edited on: 2019-02-06 10:42

Ubuntu 14, I'm hoping that is a typo?? Not sure that level of mono is even "officially" supported on that old of Ubuntu ..

EDIT: (I guess it is actually)

(0034623)
Danger Lytton (reporter)
2019-02-06 15:56

not a typo - still use 14 on all my servers
(0034625)
BillBlight (developer)
2019-02-06 15:59
edited on: 2019-02-06 15:59

Well considering I use mono 5.18 and the latest code on my Robust and Regions, I find it hard to believe that it just "doesn't work"

(0034626)
Danger Lytton (reporter)
2019-02-06 16:00

I do not get any of those errors when running the exact same Robust.ini on my server with mono 5.12
(0034627)
BillBlight (developer)
2019-02-06 16:02

All that log is showing is that it is unable to connect to your mysql server ..
(0034628)
tampa (reporter)
2019-02-06 16:03

Are you able to connect to the database from within the server using the mysql command? Check my.cnf for the bind, it should 127.0.0.1, localhost may not always be resolved properly. Verify you can actually connect using that user and password from within the machine.
(0034629)
BillBlight (developer)
2019-02-06 16:05

Mono JIT compiler version 5.18.0.225
and running a whole grid on that server , so hard to call it a mono issue, did you recompile it under that mono?
(0034631)
BillBlight (developer)
2019-02-06 16:11
edited on: 2019-02-07 01:47

that is not the username and password it is trying to use ..

Data Source=localhost;Database=grid_main;User ID=****;Password=*****;

According to your log file ..

(0034632)
Danger Lytton (reporter)
2019-02-06 16:12

i compiled it with mono 5.18

the other servers are compiled with 5.12
(0034633)
Danger Lytton (reporter)
2019-02-06 16:18

and those are the password and user id that i entered when i set up mysql in the server. And i can access mysql on that server from workbench. also i have checked the schema for spelling and punctuation etc... all appears correct

Unless someone has a suggestion - i cannot see anything different on this server from my other 3 servers (where robust works fine) except the mono version
(0034634)
BillBlight (developer)
2019-02-06 16:19

Did you happen to upgrade your mysql on that server? what is the mysql version.
(0034636)
BillBlight (developer)
2019-02-06 16:24

I'm not sure what to tell you , have 6 servers all running mono 5.18 2 of them are robust servers and the region have no problem connecting to them, so find it really hard to believe that "Mono version is the ONLY difference" .

Recent mysql updates also caused issues ..
(0034637)
Danger Lytton (reporter)
2019-02-06 16:32

i can:

ask the data center to reinstall the OS

provide me with a new server given the possibility that this server has a hardware issue which we cannot see

try to reinstall mysql

or?

what is your guess as to the best course of action?
(0034638)
tampa (reporter)
2019-02-06 16:33
edited on: 2019-02-07 01:47

When in doubt, install MariaDB 10.3
You can get that from https://downloads.mariadb.org/mariadb/repositories/# [^]
MariaDB is a drop-in replacement for mysql and will work just as well if no better.

sqldump your current databases using the workbench, then install MariaDB. On most distros the actual data will be untouched, but you may have to create the users again.

According to your log it is unable to connect and there is usually a reason for that. Try mysql -u mysqlusername -pmysqluserpassword with mysqlusername and mysqluserpassword the values you have defined in your config. If that gives back an error while you are logged in on the server then you have your answer.

Generally setting up databases for OpenSim you will want to create a user that is not root to use for OpenSim. This user is only given permissions on the databases it needs to, root would have access to everything, massive security risk.

The fact that mysql is not bound locally means anyone can just connect to it from the outside, brute force the password and kill your data in the blink of an eye.

(0034639)
Danger Lytton (reporter)
2019-02-06 16:37

clewis@localhost:~$ mysql -u root -pmybuddie
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 64
Server version: 5.6.33-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql>
(0034640)
Danger Lytton (reporter)
2019-02-06 16:38

i do not use root to run the regions or robust - i have a user name and password - as i have done with the other servers

no error when entering the commnd u asked me to try
(0034641)
BillBlight (developer)
2019-02-06 16:43

I'm at a loss, I know the code works perfectly fine all the way up to the current preview release of mono, test on just about every version.

I know that it builds fine ..

If this was "an issue with mono" it would not run for anybody.

So that takes it back to something on your specific config.
(0034642)
Danger Lytton (reporter)
2019-02-06 16:49

so i am starting to lean towards the server might have a hardware configuration issue - there are 2 hard drives using raid to run them - is it possible that my regions are somehow running on one drive and mysql is on the other - so therefore even tho i can access mysql - the Robust server cannot? Just a wild guess......
(0034643)
tampa (reporter)
2019-02-06 16:51
edited on: 2019-02-07 01:48

That does not make sense. Where things are installed on a single system makes no difference, the service is running and accepting connections otherwise.

"i do not use root to run the regions or robust "

Data Source=localhost;Database=grid_main;User ID=****;Password=*****;Old Guids=true;

Then why did you configure it to use root in your config?
The reason I asked you to run that command is because the error you posted says you are using root as user to connect OpenSim to the database.

If your database is running and allow login, but OpenSim is unable to the chances of that being an issue with mono or OpenSim are fairly slim. The more likely case is that your configuration is not proper.

(0034644)
Danger Lytton (reporter)
2019-02-06 16:54
edited on: 2019-02-06 16:55

ok - i misunderstood your question - i thought u meant a user on the server - yes u are right i am using root for all databases

and that is how i access mysql in workbench when i create schemas

(0034645)
Danger Lytton (reporter)
2019-02-06 16:59

see if this helps - i have created the schema - i run Robust.exe - normally as soon as it runs then the schema is populated (if that is correct term) with all the tables etc... when i run it on this server - the schema remains empty - zero tables
(0034646)
tampa (reporter)
2019-02-06 17:07

Create user grid%localhost with a password
Create database grid
Give all privileges for database grid to user grid

Point Robust database configuration to User ID grid, database grid and supply password.

This is the most basic of setups and should work. You can be more selective with permissions if you want to prevent potential security breaches from breaking the tables.

I personally use Navicat for db maintenance, but there is a free equivalent called DBeaver, which works with most database providers similarly well. If you still cannot figure out how to setup OpenSim properly I suggest contact an OpenSim service provider and ask them to help you with setup on your servers directly, we can only give you advice on how to do it correctly, you still have to do the work on the machines yourself.
(0034647)
BillBlight (developer)
2019-02-06 17:08

when you create your database, what collation are you setting it to .. it must be utf8mb3 or utf8_general_ci, if it is utf8mb4 opensim will fail to create the tables .. Not sure what the workbench is defaulting to these days, don't use it ..
(0034648)
Danger Lytton (reporter)
2019-02-06 17:19

defaults to latin1_swedish_ci

i have always left it as the default but
I will change it to uft8_general_ci and try it again

same result
(0034651)
Danger Lytton (reporter)
2019-02-06 17:40

I am asking the data center to cancel the server and provide me with a new one - i will let u all know what happens - thank you for your time
(0034655)
Danger Lytton (reporter)
2019-02-07 04:32

I changed 'localhost' to 127.0.0.1 in the Robust.ini and also for all of the .inis for the regions and this solved the problem.

Data Center tech went into my server and looked at it for me and made the suggestion.

Everything works perfectly now
(0034656)
BillBlight (developer)
2019-02-07 04:34

check and make sure you don't have ipv6 enabled on your servers, willing to bet you do , and localhost was resolving to the ipv6 address ..

Best to disable IPV6 completely on opensimulator servers ..

- Issue History
Date Modified Username Field Change
2019-02-06 04:40 Danger Lytton New Issue
2019-02-06 05:11 Monamusa Kaliopov Note Added: 0034335
2019-02-06 07:34 UbitUmarov Note Added: 0034336
2019-02-06 10:20 BillBlight Note Added: 0034338
2019-02-06 10:20 BillBlight Note Edited: 0034338 View Revisions
2019-02-06 10:42 BillBlight Note Edited: 0034338 View Revisions
2019-02-06 15:56 Danger Lytton Note Added: 0034623
2019-02-06 15:58 Danger Lytton Note Added: 0034624
2019-02-06 15:59 BillBlight Note Added: 0034625
2019-02-06 15:59 BillBlight Note Edited: 0034625 View Revisions
2019-02-06 16:00 Danger Lytton Note Added: 0034626
2019-02-06 16:02 BillBlight Note Added: 0034627
2019-02-06 16:03 tampa Note Added: 0034628
2019-02-06 16:05 BillBlight Note Added: 0034629
2019-02-06 16:10 Danger Lytton Note Added: 0034630
2019-02-06 16:11 BillBlight Note Added: 0034631
2019-02-06 16:12 Danger Lytton Note Added: 0034632
2019-02-06 16:18 Danger Lytton Note Added: 0034633
2019-02-06 16:19 BillBlight Note Added: 0034634
2019-02-06 16:21 Danger Lytton Note Added: 0034635
2019-02-06 16:24 BillBlight Note Added: 0034636
2019-02-06 16:32 Danger Lytton Note Added: 0034637
2019-02-06 16:33 tampa Note Added: 0034638
2019-02-06 16:37 Danger Lytton Note Added: 0034639
2019-02-06 16:38 Danger Lytton Note Added: 0034640
2019-02-06 16:43 BillBlight Note Added: 0034641
2019-02-06 16:49 Danger Lytton Note Added: 0034642
2019-02-06 16:51 tampa Note Added: 0034643
2019-02-06 16:54 Danger Lytton Note Added: 0034644
2019-02-06 16:55 Danger Lytton Note Edited: 0034644 View Revisions
2019-02-06 16:59 Danger Lytton Note Added: 0034645
2019-02-06 17:07 tampa Note Added: 0034646
2019-02-06 17:08 BillBlight Note Added: 0034647
2019-02-06 17:19 Danger Lytton Note Added: 0034648
2019-02-06 17:40 Danger Lytton Note Added: 0034651
2019-02-07 01:42 UbitUmarov Note Edited: 0034624 View Revisions
2019-02-07 01:47 UbitUmarov Note Edited: 0034638 View Revisions
2019-02-07 01:47 UbitUmarov Note Edited: 0034631 View Revisions
2019-02-07 01:48 UbitUmarov Note Edited: 0034643 View Revisions
2019-02-07 04:32 Danger Lytton Note Added: 0034655
2019-02-07 04:34 BillBlight Note Added: 0034656
2019-02-07 05:04 Danger Lytton Note Deleted: 0034624
2019-02-07 05:04 Danger Lytton Note Deleted: 0034635
2019-02-07 05:05 Danger Lytton Note Deleted: 0034630


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker