[Opensim-dev] MySQL on CentOS 5

Thu Mar 6 03:07:00 UTC 2008

I have installed mono from http://www.mono-project.com/ using their
installation binary and when using that installation (in /opt/mono-1.2.6),
OpenSim runs the first time with no problems.  So, that seems to indeed be
the problem.  And, since FC, RHEL, CentOS, and several others are basically
based on the same packages, this has to be some sort of problem either with
the RPM package created by RedHat -or- RedHat's version (1.2.4) is too old
to run OpenSim.  Either way, it seems to be a RedHat mono RPM package
problem.  I'm not sure what the problem could be, but if someone were to
figure out what was missing/incorrect from RedHat in relation to the OpenSim
source code, maybe a bug report could be filed with RedHat that would make
their RPM packages compatible with OpenSim.

On Wed, Mar 5, 2008 at 7:59 PM, John Ward <jward at uci.edu> wrote:

> 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
> >
> >
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080305/b8338037/attachment-0001.html>