No subject

Sat Apr 19 02:14:48 UTC 2014

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>

------=_Part_13453_26798329.1204580145997
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 = <a href="http://127.0.0.1:8001">http://127.0.0.1:8001</a> grid_send_key = null grid_recv_key = null user_server_url = <a href="http://127.0.0.1:8002">http://127.0.0.1:8002</a> 
user_send_key = null user_recv_key = null asset_server_url = <a href="http://127.0.0.1:8003">http://127.0.0.1:8003</a> inventory_server_url = <a href="http://127.0.0.1:8004">http://127.0.0.1:8004</a> [RemoteAdmin] 
enabled = false </snippet> My mysql_connection.ini file: <snippet> [mysqlconnection] hostname=localhost database=opensim username=opensim password=******** pooling=false port=3306 
</snippet>

------=_Part_13453_26798329.1204580145997--