Common simple settings wiki should include storage_plugin and storage_connection_string setting in OpenSim.ini

The following settings in OpenSim.ini appears not to be recommended in http://www.nsl.tuis.ac.jp/xoops/modules/xpwiki/?OpenSim%2FWEB%20Interface%20%28E%29%2FCommon%20Simple%20Settings. But I found that it is necessary even for Standalone mode.


storage_plugin="OpenSim.Data.MySQL.dll"
storage_connection_string="Data Source=localhost;Database=opensimdb;User ID=opensimdb_user;Password=opensimdb_password;"


The symptom when these settings are missing would be errors in the map, and region lists:

World Map


function loadmap() { mapInstance = new ZoomSize(128); mapInstance = new WORLDMap(document.getElementById('map-container'), {hasZoomControls: false, hasPanningControls: true}); mapInstance.centerAndZoomAtWORLDCoord(new XYPoint(1000, 1000), 1); Database error: Invalid SQL: SELECT PrincipalID,FirstName,LastName FROM UserAccounts,estate_map,estate_settings WHERE RegionID='710a5cc2-4a66-4cee-b38e-fcfe2688c3ee' AND estate_map.EstateID=estate_settings.EstateID AND EstateOwner=PrincipalID
MySQL error: 1146 (Table 'osim.estate_map' doesn't exist)
Session halted.


Region List


Database error: Invalid SQL: SELECT regions.uuid,regionName,locX,locY,serverIP,serverURI,serverHttpPort,owner_uuid,estate_map.EstateID,EstateOwner,firstname,lastname FROM regions LEFT JOIN estate_map ON RegionID=regions.uuid LEFT JOIN estate_settings ON estate_map.EstateID=estate_settings.EstateID LEFT JOIN UserAccounts ON EstateOwner=UserAccounts.PrincipalID LIMIT 0, 25
MySQL error: 1146 (Table 'osim.estate_map' doesn't exist)
Session halted.