ROBUST database is not configured. To finish configuration, go to OpenSimulator

  • giang61

    (@giang61)


    2 years, 8 months ago

    Hello,

    Thank you for providing the Web interface to OpenSim. Just what I need to manage my OpenSim installation.

    I’ve got both Robust and OpenSim running on the same Windows server with Internet user access via a public adress. I’ve installed WordPress on my WAMP and have set up a WP DB. After downloading W4OS via WP, I tried to do the installation, but got stuck at the first step, with the error message in the title above.

    Login URI: Public_IP_Address:8002

    W4OS was able to reach my ROBUST server since it autofilled the name of my grid (the lost continent of hippo). But for some reason, it could not go any further because of a problem with the Robust configuration.

    The configuration of my ROBUST was done through Robust.ini and not Robust.HG.ini. Might this be a problem?

    Another problem I’ve got was the imagick.dll. When I tried to load that into PHP, got the following error:
    PHP Warning: PHP Startup: Unable to load dynamic library ‘imagick’ (tried: c:/wamp64/bin/php/php7.4.26/ext/imagick (The specified module could not be found.), c:/wamp64/bin/php/php7.4.26/ext/php_imagick.dll (The specified module could not be found.)) in Unknown on line 0

    Any help you could provide would be greatly appreciated.

    Thanks,
    Giang

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Olivier van Helden

    (@magicoli69)

    2 years, 8 months ago

    Hi Giang

    Usually this is a message appearing where the database is not or wrongly configured. Did you set the database in OpenSimulator > Settings with the same credentials as in your Robust.ini file?

    Using a Robus or Robust.HG should not make a difference, but I must admit I did not test a non-hypergrid setup, maybe some expected parameters or tables are absent.

    I think the error message should contain the explicit mention that the connection failed or, if connection worked, the name of the missing tables. If not, you might find it in your web server error log.

    For your PHP issue, I cannot help you (I use a linux setup), you should check on PHP-related forums.

    Thread Starter giang61

    (@giang61)

    2 years, 8 months ago

    Hi Olivier – thank you for your reply. The error message said it could not find the userprofile table. When I checked in MySQL DB, the table userprofile was there, but it was empty. Is this normal. It would be great if you could spare some time to help me with a direct chat and/or screen sharing of your choice. Please do let me know. All my thanks! Giang

    Plugin Author Olivier van Helden

    (@magicoli69)

    2 years, 8 months ago

    The table userprofile is not to be mandatory for w4os general functioning, and it should not hurt if it’s empty (although it might indicate user profiles are not properly activated in Robust.ini).

    Somme mysql installations are case-sensitive, could you tell me if the table is named userprofile (in lower cases) or UserProfile?

    I assume you installed the latest versions (the database check method was updated in 2.3.8)

    Thread Starter giang61

    (@giang61)

    2 years, 8 months ago

    Olivier,
    My table is named “userprofile” all in lower case.

    The MySQL version that I installed:
    Server version: 5.7.36 – MySQL Community Server (GPL)

    I activated UserProfileService in Robust.ini as follows:

    [UserProfilesService]
    LocalServiceModule = "OpenSim.Services.UserProfilesService.dll:UserProfilesService"
    ; Enabled = false
    ; Set Enabled to true for W40S
	Enabled = true
    ;; Configure this for separate profiles database - use by W40S
    ConnectionString = "Data Source=localhost;Database=robust;User ID=griduser;Password=griduserpasswd;Old Guids=true;"
    Realm = UserProfiles
    UserAccountService = OpenSim.Services.UserAccountService.dll:UserAccountService
    AuthenticationServiceModule = "OpenSim.Services.AuthenticationService.dll:PasswordAuthenticationService"
    Thread Starter giang61

    (@giang61)

    2 years, 8 months ago

    On the W4OS status page, here’s what I see

    [gridinfo] is empty
    [gridstatus] is empty
    [gridprofile] contains [gridprofile]

    PHP module missing imagick

    Verify pages now – checked
    Avatar profile – checked
    Search service – not OK
    Wev search – not OK
    message offline – not OK
    splash – not OK
    registration page – OK
    password retrieval – OK
    economy – not OK
    about grid – not OK
    help – not OK

    Thread Starter giang61

    (@giang61)

    2 years, 8 months ago

    I only have the Robust server running when I tried to activate W40S.
    I also tried to have OpenSim running, but did not change anything as far as W4OS was concerned.

    Plugin Author Olivier van Helden

    (@magicoli69)

    2 years, 8 months ago

    The user profile do not need to be stored in a separate user database, IMHO this option is only relevant for very large grids (and I mean very, very large).

    Anyway, w4os currently supports only one DB for all robust services.

    That said, I made a test grid with Robust.ini and I could reproduce the userprofile issue (I guess you don’t have read warnings anymore, only the mention under the web profile settings), so hopefully I will be able to make some test and fix it.

    I didn’t, however, get empty shordcodes for gridinfo and gridstatus, like you got. This might –or not– be related, I’ll explore that after having fixed userprofile stuff.

    Plugin Author Olivier van Helden

    (@magicoli69)

    2 years, 8 months ago

    BTW, could you tell me which versions you use for the plugin, PHP, WordPress and OpenSimulator?

    Thread Starter giang61

    (@giang61)

    2 years, 8 months ago

    Olivier,
    Here are the versions I use:
    OpenSim 0.9.21
    PHP 7.4.26
    WP 6.0.3
    W40S 2.3.10

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘ROBUST database is not configured. To finish configuration, go to OpenSimulator’ is closed to new replies.

Tags