[Opensim-dev] MySQL on CentOS 5

[John Ward]

A colleague and I at UC Irvine have been trying to get this working on 
Fedora Core 8 for more time them I'm willing to admit ;-).  Your CentOS 
description is familiar when trying to get the UGAI servers running 
(most notably the Grid server) too.  We have gotten a configuration that 
works on both Widows and Ubuntu flavored OSes but will not on FC8.  I 
was going to try CentOS4 or RHEL4 but have decided to try FC7 next.  I 
think OSGrid servers run on FC6 without this trouble.  Does any one have 
opensim running on FC7, FC8, CentOS 4/5, or RHEL 4/5?

John.

coreone wrote:
> Hello,
> 
> I have been trying for the last several days to get OpenSim working on a 
> CentOS 5 box using MySQL.  It seems to work nicely with SQLite, but I 
> really would like to get MySQL working.  I have tried both with the 
> 0.5.0 release as well as a current SVN copy.  With both, I get MySQL 
> configured and it connects to the database fine.  The problem comes (I 
> believe) when it tries to create the tables the first time.  When I 
> start with 'mono OpenSim.exe', I get the following:
> 
> <snippet>
> OpenSim 0.4, SVN build
> 
> Performing compatibility checks...  Environment is compatible.
> 
> Starting...
> 
> Creating new local console
> Logs will be saved to current directory in ./region-console.log
> [DATASTORE
> ] [03-03 16:03:48] Attempting to load OpenSim.Framework.Data.MySQL.dll
> [DATASTORE
> ] [03-03 16:03:48] MySql - connecting: Data 
> Source=localhost;Database=opensim;User ID=opensim;Password=************;
> [DATASTORE
> ] [03-03 16:03:48] MySql Database doesn't exist... creating
> </snippet>
> 
> At this point OpenSim just sits there indefinitely.  If I log into MySQL 
> and look at the opensim database, only the 'prims' table is created. 
> 
>  From what I've read in the documentation, all the tables should be 
> created automatically by OpenSim.  So, since one table is created 
> correctly, I'm assuming connecting to the database is occurring 
> correctly since otherwise nothing would be created (i.e. in the case of 
> incorrect permissions).  I have also tested this on several other CentOS 
> 5 boxes as well as with several disparate MySQL servers on those boxes 
> with both local and remote connections (i.e. with OpenSim both on the 
> same box and on different boxes than the MySQL database).  I'm not sure 
> if it is my configuration or a bug, so I figured I would post here 
> first.  Any help would be appreciated.
> 
> Here are some of the system stats from the main machine on which I am 
> testing OpenSim as well as the OpenSim.ini and mysql_connection.ini files:
> 
> CentOS 5 (i686)
> MySQL 5.0.22
> Kernel 2.6.18 (53.1.13.el5)
> 512MB RAM
> GCC 4.1.2
> 
> My OpenSim.ini file:
> 
> <snippet>
> [Startup]
> gridmode = False
> physics = OpenDynamicsEngine
> verbose = True
> physical_prim = True
> child_get_tasks = False
> serverside_object_permissions = True
> storage_plugin = OpenSim.Framework.Data.MySQL.dll
> storage_connection_string="Data Source=localhost;Database=opensim;User 
> ID=opensim;Password=*******;";
> storage_prim_inventories = True
> startup_console_commands_file = startup_commands.txt
> shutdown_console_commands_file = shutdown_commands.txt
> script_engine = OpenSim.Region.ScriptEngine.DotNetEngine.dll
> asset_database = mysql
> [StandAlone]
> accounts_authenticate = true
> welcome_message = Welcome to OpenSim
> inventory_plugin = OpenSim.Framework.Data.MySQL.dll
> userDatabase_plugin = OpenSim.Framework.Data.MySQL.dll
> asset_plugin = OpenSim.Framework.Data.MySQL.dll
> dump_assets_to_file = False
> [Network]
> default_location_x = 1000
> default_location_y = 1000
> http_listener_port = 9000
> remoting_listener_port = 8895
> grid_server_url = http://127.0.0.1:8001
> grid_send_key = null
> grid_recv_key = null
> user_server_url = http://127.0.0.1:8002
> user_send_key = null
> user_recv_key = null
> asset_server_url = http://127.0.0.1:8003
> inventory_server_url = http://127.0.0.1:8004
> [RemoteAdmin]
> enabled = false
> </snippet>
> 
> My mysql_connection.ini file:
> 
> <snippet>
> [mysqlconnection]
> hostname=localhost
> database=opensim
> username=opensim
> password=********
> pooling=false
> port=3306
> </snippet>
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev