MySQL configuration

For installations after November 11th, 2008 (via SVN) you can read below:

OpenSim.ini could look like this (substitute DDD with database, UUU with user and PPP with password for mysql user). Please note that the database should exist (without tables). Tables will be created automatically by OpenSim. Of course user should have access to create those tables in the database.

Please use this INI file as example and adapt to your installation!

OpenSim.ini

[Startup]

gridmode = false

storage_plugin = "OpenSim.Data.MySQL.dll"

storage_connection_string = "Data Source=localhost;Database=DDD;User ID=UUU;Password=PPP;";

storage_prim_inventories = true

appearance_persist = true

appearance_connection_string = "Data Source=localhost;Database=DDD;User ID=UUU;Password=PPP;pooling=false;"

asset_database = "local"

physics = basicphysics

meshing = ZeroMesher

verbose = false

startup_console_commands_file = "startup_commands.txt"

shutdown_console_commands_file = "shutdown_commands.txt"

serverside_object_permissions = false

physical_prim = true

[StandAlone]

accounts_authenticate = true

welcome_message = Welcome to test OpenSim

asset_plugin = "OpenSim.Data.MySQL.dll"

asset_source = "Data Source=localhost;Database=DDD;User ID=UUU;Password=PPP;"

inventory_plugin = "OpenSim.Data.MySQL.dll"

inventory_source = "Data Source=localhost;Database=DDD;User ID=UUU;Password=PPP;"

userDatabase_plugin = "OpenSim.Data.MySQL.dll"

user_source = "Data Source=localhost;Database=DDD;User ID=UUU;Password=PPP;"

default_location_x = 1000

default_location_y = 1000

dump_assets_to_file = False

[Network]

default_location_x = 1000

default_location_y = 1000

http_listener_port = 9000

remoting_listener_port = 8895

grid_server_url = http://127.0.0.1:8001

grid_send_key = null

grid_recv_key = null

user_server_url = http://127.0.0.1:8002

user_send_key = null

user_recv_key = null

asset_server_url = http://127.0.0.1:8003

inventory_server_url = http://127.0.0.1:8004

secure_inventory_server = true