[Opensim-users] Database issues after server crash

[Justin Clark-Casey]

On 06/09/10 06:36, Chris wrote:
> Oh I see... I am not sure other than using a pose script with animation
> or just simply scripting in a sit target in the prim that was meant to
> be sat on. Sorry :) But if there is such a setting in the configuration
> I would like to know as well.

There do seem to be some bugs currently associated with sitting (e.g. the recently submitted 5015 by Chris). 
Unfortunately I don't know if there are any settings that can currently be tweaked, though that might be something to 
think about exposing if there are any parameters that could reasonably be fiddled with.

>
> On 9/6/2010 12:18 AM, Ben Faust wrote:
>> Importing objects such as chairs and other things meant for sitting.
>> Even the scripts often don't work correctly. If they don't have
>> scripts (and no scripts are desired), then all the individual prims
>> would need to be rotated, resized, re-textured, IF that would even
>> work; however, on a default-sized box, the avatar sits sideways and in
>> the ground, not on any side of the box. I was hoping there was a
>> setting in the server itself so sitting works in a reasonable way for
>> everyone.
>>
>> On 9/6/2010 1:11 AM, Chris wrote:
>>> You could try putting a script in said prim and fiddle with the
>>> llSitTarget function ( llSitTarget(<0.0, 0.0, 0.5>, ZERO_ROTATION);
>>> for instance) I don't know if this will accomplish what you are
>>> trying to do though. Just curious, what does it have to do with
>>> importing objects?
>>>
>>> On 9/5/2010 11:20 PM, Ben Faust wrote:
>>>> Please disregard this. I discovered the database files had simply
>>>> become corrupted, and I had to delete them physically (from the
>>>> server files) and start over. Another question though: does anyone
>>>> know how to change the sit settings so they line up with Second Life
>>>> or even OSgrid? I can't just create a box and sit on it, but sit low
>>>> and sideways, and not even on the box at any rotation. This makes
>>>> importing objects from elsewhere nearly impossible in some cases.
>>>>
>>>> On 9/5/2010 3:21 PM, Ben Faust wrote:
>>>>> My server crashed (ran out of disk space), and it took awhile to
>>>>> figure out how to get innoDB running again with MySQL... The
>>>>> database appears to be in tact, except the `migrations` table is
>>>>> missing... Now, when trying to start OpenSim, the following is part
>>>>> of the startup logs. Anyone know how to fix this, or perhaps have
>>>>> the mysql for recreating that table?
>>>>>
>>>>> Exception: System.Exception: Table 'migrations' already exists in
>>>>> SQL: create table migrations(name varchar(100), version int)
>>>>> at OpenSim.Data.Migration.ExecuteScript
>>>>> (System.Data.Common.DbConnection conn, System.String[] script)
>>>>> [0x00000] in <filename unknown>:0
>>>>> at OpenSim.Data.Migration.ExecuteScript
>>>>> (System.Data.Common.DbConnection conn, System.String sql) [0x00000]
>>>>> in <filename unknown>:0
>>>>> at OpenSim.Data.Migration.ExecuteScript (System.String sql)
>>>>> [0x00000] in <filename unknown>:0
>>>>> at OpenSim.Data.Migration.InitMigrationsTable () [0x00000] in
>>>>> <filename unknown>:0
>>>>> at OpenSim.Data.Migration.Update () [0x00000] in <filename unknown>:0
>>>>> at OpenSim.Data.MySQL.MySQLEstateStore.Initialise (System.String
>>>>> connectionString) [0x00000] in <filename unknown>:0
>>>>> at OpenSim.Region.Framework.StorageManager..ctor (System.String
>>>>> dllName, System.String connectionstring, System.String
>>>>> estateconnectionstring) [0x00000] in <filename unknown>:0
>>>>> at OpenSim.OpenSimBase.CreateStorageManager (System.String
>>>>> connectionstring, System.String estateconnectionstring) [0x00000]
>>>>> in <filename unknown>:0
>>>>> at OpenSim.OpenSimBase.CreateStorageManager () [0x00000] in
>>>>> <filename unknown>:0
>>>>> at OpenSim.Region.ClientStack.RegionApplicationBase.StartupSpecific
>>>>> () [0x00000] in <filename unknown>:0
>>>>> at OpenSim.OpenSimBase.StartupSpecific () [0x00000] in <filename
>>>>> unknown>:0
>>>>> at OpenSim.OpenSim.StartupSpecific () [0x00000] in <filename
>>>>> unknown>:0
>>>>> at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000]
>>>>> in <filename unknown>:0
>>>>> at OpenSim.Application.Main (System.String[] args) [0x00000] in
>>>>> <filename unknown>:0
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Opensim-users mailing list
>>>> Opensim-users at lists.berlios.de
>>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>>
>>>
>>> _______________________________________________
>>> Opensim-users mailing list
>>> Opensim-users at lists.berlios.de
>>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>>
>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>


-- 
Justin Clark-Casey (justincc)
http://justincc.org
http://twitter.com/justincc