Thanks, that was partly helpful; I had completely forgotten about
OpenSim.ini -- I thought all the config files were in config-include!
But now that I have remedied that deficiency, I'm still having
connect problems; in fact it looks like the same problems.
I now have:
A. in OpenSim.ini:
[Startup]
...
storage_plugin="OpenSim.Data.MySQL.dll"
storage_connection_string = "Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;"
...
[StandAlone]
...
inventory_plugin = "OpenSim.Data.MySQL.dll"
inventory_source = "Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;"
...
userDatabase_plugin = "OpenSim.Data.MySQL.dll"
user_source = "Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;"
B. in config-include/StandaloneCommon.ini:
[DatabaseService]
;
;### Choose the DB
;
; MySql
StorageProvider = "OpenSim.Data.MySQL.dll"
ConnectionString = "Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;"
...
Now, I have recently figured out where the OpenSim log file is,
and here is the bottom of OpenSim.log (there is a little more detail here
than usual, because I have inserted some additional logging statements
in the code):
2010-06-27 20:39:25,982 INFO - OpenSim.Application [OPENSIM MAIN]: configured
log4net using default OpenSim.exe.config
2010-06-27 20:39:26,029 INFO - OpenSim.Application [OPENSIM MAIN]: Runtime
gave us 30 worker threads and 16 IOCP threads
2010-06-27 20:39:26,037 INFO - OpenSim.Application [OPENSIM MAIN]: Bumping up
to 500 worker threads and 1000 IOCP threads
2010-06-27 20:39:26,038 INFO - OpenSim.Application Performing compatibility
checks...
2010-06-27 20:39:26,074 INFO - OpenSim.Application Environment is compatible.
2010-06-27 20:39:26,248 INFO - OpenSim.ConfigurationLoader [CONFIG] Reading
configuration settings
2010-06-27 20:39:26,250 INFO - OpenSim.ConfigurationLoader [CONFIG] Reading
configuration file /home/gdweber/build/opensim-0.6.9-source/bin/OpenSim.ini
2010-06-27 20:39:26,295 INFO - OpenSim.ConfigurationLoader [CONFIG] Reading
configuration file
/home/gdweber/build/opensim-0.6.9-source/bin/config-include/Standalone.ini
2010-06-27 20:39:26,302 INFO - OpenSim.ConfigurationLoader [CONFIG] Reading
configuration file
/home/gdweber/build/opensim-0.6.9-source/bin/config-include/StandaloneCommon.ini
2010-06-27 20:39:26,316 INFO - OpenSim.ConfigurationLoader [CONFIG] StorageDll
= OpenSim.Data.MySQL.dll
2010-06-27 20:39:26,316 INFO - OpenSim.ConfigurationLoader [CONFIG]
StorageConnectionString = Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;
2010-06-27 20:39:26,316 INFO - OpenSim.ConfigurationLoader [CONFIG]
EstateConnectionString = Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;
2010-06-27 20:39:26,316 INFO - OpenSim.ConfigurationLoader [CONFIG]
StandaloneInventorySource = Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;
2010-06-27 20:39:26,316 INFO - OpenSim.ConfigurationLoader [CONFIG]
StandaloneUserSource = Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;
2010-06-27 20:39:26,316 INFO - OpenSim.ConfigurationLoader [CONFIG]
ConfigurationLoader.cs updated 2010 June 27 19:55
2010-06-27 20:39:26,319 INFO - OpenSim.OpenSim [LOGGING]: Logging started to
file /home/gdweber/build/opensim-0.6.9-source/bin/OpenSim.log
2010-06-27 20:39:26,339 INFO - OpenSim.OpenSim [OPENSIM MAIN]: Using
async_call_method SmartThreadPool
2010-06-27 20:39:26,339 INFO - OpenSim.Framework.Servers.BaseOpenSimServer
[STARTUP]: Beginning startup processing
2010-06-27 20:39:26,340 INFO - OpenSim.Framework.Servers.BaseOpenSimServer
[STARTUP]: Version: OpenSim 0.6.9 (Release)
2010-06-27 20:39:26,349 INFO - OpenSim.OpenSim
====================================================================
2010-06-27 20:39:26,349 INFO - OpenSim.OpenSim =========================
STARTING OPENSIM =========================
2010-06-27 20:39:26,349 INFO - OpenSim.OpenSim
====================================================================
2010-06-27 20:39:26,349 INFO - OpenSim.OpenSim [OPENSIM MAIN]: Running in
sandbox mode
2010-06-27 20:39:26,366 INFO - OpenSim.Region.Framework.StorageManager
[DATASTORE]: Attempting to load OpenSim.Data.MySQL.dll
2010-06-27 20:39:26,377 INFO - OpenSim.Data.MySQL.MySQLEstateStore [REGION
DB]: MySql - connecting: Data Source=localhost;Database=opensim;User
ID=opensimulator;Password=secretish;
2010-06-27 20:39:26,568 ERROR - OpenSim.Application [APPLICATION]:
APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs
Exception: MySql.Data.MySqlClient.MySqlException: Connection unexpectedly
terminated.
at MySql.Data.MySqlClient.MySqlStream.LoadPacket () [0x00000] in <filename
unknown>:0
at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000] in <filename
unknown>:0
at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename
unknown>:0
at MySql.Data.MySqlClient.Driver.Create
(MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in
<filename unknown>:0
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] in
<filename unknown>:0
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] in
<filename unknown>:0
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in <filename
unknown>:0
Application is terminating: True
Also, I've found out how to enable the general log file in MySQL.
While the error message "Connection unexpectedly terminated"
suggests that a connection was made and then broken,
perhaps because of a bad password, MySQL's log file
shows that OpenSim is not connecting at all
-- all the connections to MySQL are from the
command-line client 'mysql' program.
So I'm still stumped!
Greg
On 2010-Jun-27, Marck wrote:
> [email protected] wrote:
> >I have some trouble getting OpenSim to start using MySQL.
> >
> >OpenSim version: 0.6.9
> >Operating system: Arch Linux, Linux 2.6.33
> >MySQL version: 5.1.47-1
> >Mono version: 2.6.4-2
> >
> >Here's the problem: Every time I start opensim, it cannot get
> >(and keep) a connection to MySQL. This is the first line of
> >the error messages:
> >
> >22:13:11 - Error loading plugin from OpenSim.Services.AssetService.dll,
> >exception MySql.Data.MySqlClient.MySqlException: Connection unexpectedly
> >terminated.
> >
> >I have the default configuration files, except in
> >StandaloneCommon.ini, I have commented out
> >
> >; StorageProvider = "OpenSim.Data.SQLite.dll"
> >
> >and have uncommented and modified these two lines:
> >
> > StorageProvider = "OpenSim.Data.MySQL.dll"
> > ConnectionString = "Data Source=localhost;Database=opensim;User
> > ID=opensimulator;Password=********;"
>
> Have you also changed the configuration in OpenSim.ini to use MySQL? It is
> not sufficient to only do changes in StandaloneCommon.ini. You also need to
> adjust the settings for "storage_plugin" and "storage_connection_string" in
> the [Startup] section, and "inventory_plugin", "inventory_source",
> "userDatabase_plugin", and "user_source" in the [StandAlone] section of
> OpenSim.ini.
>
> >Now, I *do* have mysqld running!
> >
> >And I can connect to it with the shell mysql client using the same
> >database, user name, and password:
> >
> >$ mysql -h localhost -D opensim -u opensimulator --password=********
> >Welcome to the MySQL monitor. Commands end with ; or \g.
> _______________________________________________
> Opensim-users mailing list
> [email protected]
> https://lists.berlios.de/mailman/listinfo/opensim-users
--
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
