[Opensim-dev] MySQL on CentOS 5

[John Ward]

It would appear that adding a local copy of mono from 
http://www.mono-project.com allows OpenSim to run on FC8.  I'd bet it 
will for the other failing RedHat distributions.

John.


John Ward wrote:
> 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
> 
>