<div>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:</div>
<div> </div>
<div>[ERROR] /usr/libexec/mysqld: unknown variable 'lower_case_sensitive=1'<br></div>
<div>If I restart OpenSim with My SQL running it produces a rash of SQL errors. </div>
<div> </div>
<div>If I the choose yes instead of no when asked </div>
<div> </div>
<div>Do you wish to join an existing estate? [no]: </div>
<div> </div>
<div>it allows me to create a new Estate but once logins for the region are enabled the simulator crashes with the following message </div>
<div> </div>
<div>Currently selected region is Bromley<br>13:32:06 - [STARTUP]: Startup took 1m 14s<br>13:32:06 - [WATCHDOG]: Started tracking thread "Incoming Packets (Bromley)" (ID 8)<br>13:32:06 - [WATCHDOG]: Started tracking thread "Heartbeat for region Bromley" (ID 9)<br>
13:32:08 - [REGION]: Enabling logins for Bromley<br>13:32:08 - [REGION]: Failed with exception System.NullReferenceException: Object reference not set to an instance of an object<br> at OpenSim.Services.GridService.GridService.GetNeighbours (UUID scopeID, UUID regionID) [0x00000]<br>
at OpenSim.Region.CoreModules.ServiceConnectorsOut.Grid.LocalGridServicesConnector.GetNeighbours (UUID scopeID, UUID regionID) [0x00000]<br> at OpenSim.Region.Framework.Scenes.SceneCommunicationService.InformNeighborsThatRegionisUp (INeighbourService neighbourService, OpenSim.Framework.RegionInfo region) [0x00000]<br>
at OpenSim.Region.Framework.Scenes.Scene.Update () [0x00000] On Region: Bromley<br><br>Does<br></div>
<div class="gmail_quote">On Wed, Mar 9, 2011 at 12:22 PM, Clive Gould <span dir="ltr"><<a href="mailto:cliveg@gmail.com">cliveg@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>Hi</div>
<div> </div>
<div>I've just solved the problem by triple checking the contents of StandaloneCommon.ini !!!</div>
<div> </div>
<div>But now I have a new problem, which I suspect is due to problems with case sensitivity in the SQL commands used with OpenSim.</div>
<div> </div>
<div>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</div>
<div> </div>
<div>If I try to add this parameter to my.cnf with mysql-5.1.55-1 then MySQL refuses to start.</div>
<div> </div>
<div>Any suggestions please??</div>
<div> </div>
<div>Thanks very much</div>
<div> </div>
<div>Clive<br></div>
<div>Excerpt from start up of OpenSim with a clean database is appended below:</div>
<div> </div>
<div>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;<br>
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.<br>12:14:29 - [MIGRATIONS]: Creating GridUserStore at version 1<br>
12:14:29 - [USER GRID SERVICE]: Starting user grid service<br>12:14:29 - [ACTIVITY DETECTOR]: starting<br>12:14:29 - [LOCAL GRID USER SERVICE CONNECTOR]: Local grid user connector enabled<br>12:14:29 - [SIMULATION CONNECTOR]: Local simulation enabled<br>
12:14:29 - [LLLOGIN IN CONNECTOR]: LLLoginerviceInConnector enabled<br>12:14:29 - [GRIDINFO IN CONNECTOR]: GridInfo Service In Connector enabled<br>12:14:29 - [Concierge]: plugin disabled by configuration<br>12:14:29 - [VivoxVoice]: plugin disabled by configuration<br>
12:14:29 - [SIMIAN ACTIVITY DETECTOR]: Started<br>12:14:29 - [LOADREGIONS]: Loading region configurations from filesystem<br>12:14:29 - [LOADREGIONSPLUGIN]: Loading region configurations...<br>12:14:29 - [LOADREGIONSPLUGIN]: Loading specific shared modules...<br>
12:14:29 - [LOADREGIONSPLUGIN]: DynamicTextureModule...<br>12:14:29 - [LOADREGIONSPLUGIN]: LoadImageURLModule...<br>12:14:29 - [LOADREGIONSPLUGIN]: XMLRPCModule...<br>12:14:29 - [LOADREGIONSPLUGIN]: AssetTransactionModule...<br>
12:14:29 - [LOADREGIONSPLUGIN]: Done.<br>12:14:29 - [LOADREGIONS]: Creating Region: Bromley (ThreadID: 3)<br>12:14:29 - [LLUDPSERVER]: Average Environment.TickCount resolution: 1ms<br>Your region is not part of an estate.<br>
Do you wish to join an existing estate? [no]:<br>12:14:38 - [APPLICATION]:
<div class="im"><br>APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs</div></div>
<div>Exception: MySql.Data.MySqlClient.MySqlException: Invalid attempt to access a field before calling Read()<br> at MySql.Data.MySqlClient.MySqlDataReader.GetFieldValue (Int32 index, Boolean checkNull) [0x00000]<br> at MySql.Data.MySqlClient.MySqlDataReader.GetValue (Int32 i) [0x00000]<br>
at MySql.Data.MySqlClient.MySqlDataReader.get_Item (Int32 i) [0x00000]<br> at MySql.Data.MySqlClient.MySqlDataReader.get_Item (System.String name) [0x00000]<br> at OpenSim.Data.MySQL.MySQLEstateStore.DoLoad (MySql.Data.MySqlClient.MySqlCommand cmd, UUID regionID, Boolean create) [0x00000]<br>
at OpenSim.Data.MySQL.MySQLEstateStore.LoadEstateSettings (UUID regionID, Boolean create) [0x00000]<br> 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]<br>
at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo regionInfo, OpenSim.Region.Framework.StorageManager storageManager, OpenSim.Framework.AgentCircuitManager circuitManager) [0x00000]<br> at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo regionInfo, Int32 proxyOffset, IConfigSource configSource, IClientNetworkServer& clientServer) [0x00000]<br>
at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene) [0x00000]<br> at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, IScene& scene) [0x00000]<br>
at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise () [0x00000]
<div class="im"><br> at OpenSim.OpenSimBase.StartupSpecific () [0x00000]<br> at OpenSim.OpenSim.StartupSpecific () [0x00000]<br> at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000]<br> at OpenSim.Application.Main (System.String[] args) [0x00000]</div>
</div>
<div>Application is terminating: True<br></div></blockquote></div><br>