diva
commented
14 years ago I'm not familiar with that SQL server. The fact that it doesn't let you create an account other than 'root' is not a good sign...
Assuming you had been using 'root' previously -- you can check by looking at bin/config-include/MyWorld.ini in one of your previous versions -- you must continue to use it now.
It looks like you have encountered some sort of migration issue. Again, I have no idea how you login to that server. If you know how to, you can issuing the following SQL statement:
update migrations set version = 6 where name='AssetStore';
and then run the new diva distro again.
If it still doesn't work, your permissions on that DB aren't quite right.
The issue you're running into is not a diva issue, it's related to the DB changes that happened in opensim. The new version of OpenSim needs to change the DB schema to add a few more columns in the assets table.
mrjoyce
Diva,
Per your direction, I am posting my problem here.
I have been running Diva Distribution (up to r12751) in conjunction with a software program call USBWebserver http://www.usbwebserver.net/en/. It allows me to run a Web Server on a USB flash drive, which affords me portability of running my 4 regions on various computers. Up to now (before r13458), I have not encountered any problems running Diva Distribution and updating as new versions were available.
Here is the routine I have follow to upgrade my old Diva Distribution.
I start the USBWebserver program. In the server is my database for the opensim. It’s User ID is “root”. I have not found a way to change the User ID in the USB Webserver so it will read “opensim”.
To upgrade my old Diva Distribution, I ran the USBWebserver first. Then I ran the Update.exe. I then went to the new file for r13458 and ran the Configure.exe. Answered all the questions and ran the 32Bitlauncher to start the new Diva Distribution.
The command screen came on and ran for a few moments and then just terminated. The log for what it ran was this:
2010-08-09 18:58:07,207 INFO - OpenSim.Application [OPENSIM MAIN]: configured log4net using default OpenSim.exe.config 2010-08-09 18:58:07,223 INFO - OpenSim.Application [OPENSIM MAIN]: Runtime gave us 500 worker threads and 1000 IOCP threads 2010-08-09 18:58:07,223 INFO - OpenSim.Application Performing compatibility checks...
2010-08-09 18:58:07,239 INFO - OpenSim.Application Environment is compatible.
2010-08-09 18:58:07,270 INFO - OpenSim.ConfigurationLoader [CONFIG]: Reading configuration settings 2010-08-09 18:58:07,270 INFO - OpenSim.ConfigurationLoader [CONFIG]: Reading configuration file E:\diva-r13553\bin\OpenSim.ini 2010-08-09 18:58:07,317 INFO - OpenSim.ConfigurationLoader [CONFIG]: Reading configuration file E:\diva-r13553\bin\config-include\DivaPreferences.ini 2010-08-09 18:58:07,348 INFO - OpenSim.ConfigurationLoader [CONFIG]: Reading configuration file E:\diva-r13553\bin\config-include\MyWorld.ini 2010-08-09 18:58:07,379 INFO - OpenSim.OpenSim [LOGGING]: Logging started to file E:\diva-r13553\bin\OpenSim.32BitLaunch.log 2010-08-09 18:58:07,395 INFO - OpenSim.OpenSim [OPENSIM MAIN]: Using async_call_method UnsafeQueueUserWorkItem 2010-08-09 18:58:07,395 INFO - OpenSim.Framework.Servers.BaseOpenSimServer [STARTUP]: Beginning startup processing 2010-08-09 18:58:07,395 INFO - OpenSim.Framework.Servers.BaseOpenSimServer [STARTUP]: OpenSimulator version: OpenSim 0.7.0.1 (Release)
2010-08-09 18:58:07,395 INFO - OpenSim.Framework.Servers.BaseOpenSimServer [STARTUP]: Operating system version: Microsoft Windows NT 6.1.7600.0
2010-08-09 18:58:07,410 INFO - OpenSim.OpenSim ==================================================================== 2010-08-09 18:58:07,410 INFO - OpenSim.OpenSim ========================= STARTING OPENSIM ========================= 2010-08-09 18:58:07,410 INFO - OpenSim.OpenSim ==================================================================== 2010-08-09 18:58:07,410 INFO - OpenSim.OpenSim [OPENSIM MAIN]: Running 2010-08-09 18:58:07,441 INFO - OpenSim.Region.Framework.StorageManager [DATASTORE]: Attempting to load OpenSim.Data.MySQL.dll 2010-08-09 18:58:07,504 INFO - OpenSim.Data.MySQL.MySQLEstateStore [REGION DB]: MySql - connecting: Data Source=localhost;Database=opensim;User ID=opensim;Password=***;
In an effort to try to figure out a way to run the program, I then went into the MyWorld.ini file and tried substituting “root” for the User ID instead of “opensim”. When I ran the launcher again, it seemed to be run, but a new red lines (not seen in the older version) came up. The command screen ran much shorter as well.
The following is a part of the error lines which ran:
OpenSim.Services.AssetService.AssetService [ASSET]: Loading default asset set from assets/AssetSets.xml 2010-08-09 20:35:08,833 ERROR - OpenSim.Data.MySQL.MySQLAssetData [ASSET DB]: MySQL failure creating asset 8ceccb12-5aee-3584-e4a5-66973a844296 with name "place_marker". Error: Unknown column 'asset_flags' in 'field list' 2010-08-09 20:35:08,838 ERROR - OpenSim.Data.MySQL.MySQLAssetData [ASSET DB]: MySQL failure creating asset 01645eeb-8c51-60dc-58cc-b9512f05afc0 with name "tpose2". Error: Unknown column 'asset_flags' in 'field list' 2010-08-09 20:35:08,844 ERROR - OpenSim.Data.MySQL.MySQLAssetData [ASSET DB]: MySQL failure creating asset 53339f20-1811-f774-0768-0989f5e57df2 with name "bouncy_ball_left". Error: Unknown column 'asset_flags' in 'field list' 2010-08-09 20:35:08,848 ERROR - OpenSim.Data.MySQL.MySQLAssetData [ASSET DB]: MySQL failure creating asset 9e06424c-0178-82eb-ff21-6c0e4e5a7e6d with name "tpose". Error: Unknown column 'asset_flags' in 'field list' 2010-08-09 20:35:08,853 ERROR - OpenSim.Data.MySQL.MySQLAssetData [ASSET DB]: MySQL failure creating asset b22af34d-740a-286f-f20a-e0818d91735e with name "give_and_handshake". Error: Unknown column 'asset_flags' in 'field list' 2010-08-09 20:35:08,857 ERROR - OpenSim.Data.MySQL.MySQLAssetData [ASSET DB]: MySQL failure creating asset be7b9b16-5c88-2862-2d20-ec4b939d6a8e with name "bouncy_ball_walk". Error: Unknown column 'asset_flags' in 'field list' 2010-08-09 20:35:08,862 ERROR - OpenSim.Data.MySQL.MySQLAssetData [ASSET DB]: MySQL failure creating asset 9f2e3814-fc16-0b90-eeb8-5cf8a37fa3bd with name "bouncy_ball_run". Error: Unknown column 'asset_flags' in 'field list'
If needed, I can send the entire log for this 2nd attempt, using “root” as the User ID.
After this second attempt with the command screen, which ran to completion, I tried using a viewer (Imprudence) to access the sim. It ran as a standalone and I was able to rez the regions and assets on the regions. But the Avatar never rezed in and the Inventory (which was well over 30,000 items) was at 163 items.
What puzzles me is how well the past updates were for me. Even though I originally followed the steps as directed, the 32BitLauncher just crashed. And by changing the UserID, I could get the command screen to finish, but obviously the Avatar and Inventory were left behind.
I will admit to being as dense as a box of rocks, so please bear with my confusion. Perhaps there is a contact you could refer me to that can give me some personal guidance as to where I have gone wrong. I am in the Laguna Beach area and I am willing to seek additional help either in person or online.
Many Thanks
Mike Joyce mrjoyce@mindspring.com