http://stackoverflow.com/questions/1172382/mysql-lowercase-table-names-in-windows-uppercase-names-on-unix
So: clean all yours DB, and restart everything. Respectfully, Tokeiito Imako On Wed, Mar 9, 2011 at 3:44 PM, Clive Gould <[email protected]> wrote: > It definitely looks as if there is a problem with the directive > lower_case_sensitive=1 in my.cnf with mysql-5.1.55-1 as I get the following > error message when trying to start mysql: > > [ERROR] /usr/libexec/mysqld: unknown variable 'lower_case_sensitive=1' > If I restart OpenSim with My SQL running it produces a rash of SQL errors. > > If I the choose yes instead of no when asked > > Do you wish to join an existing estate? [no]: > > it allows me to create a new Estate but once logins for the region are > enabled the simulator crashes with the following message > > Currently selected region is Bromley > 13:32:06 - [STARTUP]: Startup took 1m 14s > 13:32:06 - [WATCHDOG]: Started tracking thread "Incoming Packets (Bromley)" > (ID 8) > 13:32:06 - [WATCHDOG]: Started tracking thread "Heartbeat for region > Bromley" (ID 9) > 13:32:08 - [REGION]: Enabling logins for Bromley > 13:32:08 - [REGION]: Failed with exception System.NullReferenceException: > Object reference not set to an instance of an object > at OpenSim.Services.GridService.GridService.GetNeighbours (UUID scopeID, > UUID regionID) [0x00000] > at > OpenSim.Region.CoreModules.ServiceConnectorsOut.Grid.LocalGridServicesConnector.GetNeighbours > (UUID scopeID, UUID regionID) [0x00000] > at > OpenSim.Region.Framework.Scenes.SceneCommunicationService.InformNeighborsThatRegionisUp > (INeighbourService neighbourService, OpenSim.Framework.RegionInfo region) > [0x00000] > at OpenSim.Region.Framework.Scenes.Scene.Update () [0x00000] On Region: > Bromley > > Does > On Wed, Mar 9, 2011 at 12:22 PM, Clive Gould <[email protected]> wrote: >> >> Hi >> >> I've just solved the problem by triple checking the contents of >> StandaloneCommon.ini !!! >> >> But now I have a new problem, which I suspect is due to problems with case >> sensitivity in the SQL commands used with OpenSim. >> >> I have got round this with an install on another server >> using mysql-5.1.50-1 by inserting lower_case_sensitive=1 into my.cnf >> >> If I try to add this parameter to my.cnf with mysql-5.1.55-1 then MySQL >> refuses to start. >> >> Any suggestions please?? >> >> Thanks very much >> >> Clive >> Excerpt from start up of OpenSim with a clean database is appended below: >> >> 12:14:29 - [MIGRATIONS]: Cmd was Table 'GridUser' already exists in SQL: >> BEGIN; CREATE TABLE `GridUser` ( `UserID` VARCHAR(255) NOT NULL, >> `HomeRegionID` CHAR(36) NOT NULL DEFAULT >> '00000000-0000-0000-0000-000000000000', `HomePosition` CHAR(64) NOT NULL >> DEFAULT '<0,0,0>', `HomeLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>', >> `LastRegionID` CHAR(36) NOT NULL DEFAULT >> '00000000-0000-0000-0000-000000000000', `LastPosition` CHAR(64) NOT NULL >> DEFAULT '<0,0,0>', `LastLookAt` CHAR(64) NOT NULL DEFAULT '<0,0,0>', >> `Online` CHAR(5) NOT NULL DEFAULT 'false', `Login` CHAR(16) NOT NULL >> DEFAULT '0', `Logout` CHAR(16) NOT NULL DEFAULT '0', PRIMARY KEY >> (`UserID`) ) ENGINE=InnoDB; COMMIT; >> 12:14:29 - [MIGRATIONS]: An error has occurred in the migration. This may >> mean you could see errors trying to run OpenSim. If you see database related >> errors, you will need to fix the issue manually. Continuing. >> 12:14:29 - [MIGRATIONS]: Creating GridUserStore at version 1 >> 12:14:29 - [USER GRID SERVICE]: Starting user grid service >> 12:14:29 - [ACTIVITY DETECTOR]: starting >> 12:14:29 - [LOCAL GRID USER SERVICE CONNECTOR]: Local grid user connector >> enabled >> 12:14:29 - [SIMULATION CONNECTOR]: Local simulation enabled >> 12:14:29 - [LLLOGIN IN CONNECTOR]: LLLoginerviceInConnector enabled >> 12:14:29 - [GRIDINFO IN CONNECTOR]: GridInfo Service In Connector enabled >> 12:14:29 - [Concierge]: plugin disabled by configuration >> 12:14:29 - [VivoxVoice]: plugin disabled by configuration >> 12:14:29 - [SIMIAN ACTIVITY DETECTOR]: Started >> 12:14:29 - [LOADREGIONS]: Loading region configurations from filesystem >> 12:14:29 - [LOADREGIONSPLUGIN]: Loading region configurations... >> 12:14:29 - [LOADREGIONSPLUGIN]: Loading specific shared modules... >> 12:14:29 - [LOADREGIONSPLUGIN]: DynamicTextureModule... >> 12:14:29 - [LOADREGIONSPLUGIN]: LoadImageURLModule... >> 12:14:29 - [LOADREGIONSPLUGIN]: XMLRPCModule... >> 12:14:29 - [LOADREGIONSPLUGIN]: AssetTransactionModule... >> 12:14:29 - [LOADREGIONSPLUGIN]: Done. >> 12:14:29 - [LOADREGIONS]: Creating Region: Bromley (ThreadID: 3) >> 12:14:29 - [LLUDPSERVER]: Average Environment.TickCount resolution: 1ms >> Your region is not part of an estate. >> Do you wish to join an existing estate? [no]: >> 12:14:38 - [APPLICATION]: >> APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs >> Exception: MySql.Data.MySqlClient.MySqlException: Invalid attempt to >> access a field before calling Read() >> at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue (Int32 index, >> Boolean checkNull) [0x00000] >> at MySql.Data.MySqlClient.MySqlDataReader.GetValue (Int32 i) [0x00000] >> at MySql.Data.MySqlClient.MySqlDataReader.get_Item (Int32 i) [0x00000] >> at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) >> [0x00000] >> at OpenSim.Data.MySQL.MySQLEstateStore.DoLoad >> (MySql.Data.MySqlClient.MySqlCommand cmd, UUID regionID, Boolean create) >> [0x00000] >> at OpenSim.Data.MySQL.MySQLEstateStore.LoadEstateSettings (UUID >> regionID, Boolean create) [0x00000] >> at OpenSim.Region.Framework.Scenes.Scene..ctor >> (OpenSim.Framework.RegionInfo regInfo, OpenSim.Framework.AgentCircuitManager >> authen, OpenSim.Region.Framework.Scenes.SceneCommunicationService >> sceneGridService, OpenSim.Region.Framework.StorageManager storeManager, >> OpenSim.Region.Framework.ModuleLoader moduleLoader, Boolean >> dumpAssetsToFile, Boolean physicalPrim, Boolean SeeIntoRegionFromNeighbor, >> IConfigSource config, System.String simulatorVersion) [0x00000] >> at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo >> regionInfo, OpenSim.Region.Framework.StorageManager storageManager, >> OpenSim.Framework.AgentCircuitManager circuitManager) [0x00000] >> at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo >> regionInfo, Int32 proxyOffset, IConfigSource configSource, >> IClientNetworkServer& clientServer) [0x00000] >> at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo >> regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene) >> [0x00000] >> at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo >> regionInfo, Boolean portadd_flag, IScene& scene) [0x00000] >> at >> OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise () >> [0x00000] >> at OpenSim.OpenSimBase.StartupSpecific () [0x00000] >> at OpenSim.OpenSim.StartupSpecific () [0x00000] >> at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000] >> at OpenSim.Application.Main (System.String[] args) [0x00000] >> Application is terminating: True > > > _______________________________________________ > 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
