[Opensim-users] Help: No Connector defined in section Friends, or failed to load, cannot continue

Wed Mar 9 14:05:19 UTC 2011

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 <cliveg at gmail.com> 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 <cliveg at gmail.com> 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
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>