[W4os] Error while connecting to Database

  • Resolved phmaitre

    (@phmaitre)


    2 years, 3 months ago

    Hi !
    I’ve found your plugin, and I must say i’m impressed !This does most of the things Opensimulator lacks as web interface.

    Context : All linux environment ; I aim to setup an Opensimulator server using Robust and Hypergrid [Tho only my admins can go explore Hypergrid, and not accepting foreign visitors]
    Database (Mysql) and Opensimulator/Robust are on same server, and my wordpress is on another .
    All prerequisites have been met so far (WP extensions, user entry in database with permissions, WP pages for display/register)Also, I’ve verified the lower/upper case problem with database name

    Since W4os cannot connect to DB but its credentials exists, I suspect it has something to do with the hostname required for Robust Database
    I’ve been trying with IP of database host server, IP:port, DNS, and also what hostname:port database store in it’s variables

    I’m always encountering the same error saying it can’t connect

    Error :
    w4os – OpenSimulator Web Interface:

    Could not connect to the database server, please verify your credentials on OpenSimulator settings page

    Robust/opensim and Database are online and working. I can connect to my grid via viewer, and I can access DB via phpmyadmin
    However, I don’t have any Robust/opensim console feedback when I attempt to connect. I not sure if I should expect some

    If you have any ideas where’s the problem coming from

    I’ll be happy to provide more data/information if needed

    Thanks for your time

    phmaitre

Viewing 2 replies - 1 through 2 (of 2 total)
  • giang61

    (@giang61)

    2 years, 1 month ago

    Hi phmaitre,

    I saw your message on this forum. I’m interested in your experience with Robust and OpenSim running on Linux because I was never able to stay in the viewer for more than 3/4 mins. Robust + OpenSim on Windows worked fine for me. But on both Ubuntu and Debian, I would be able to log into my grid, play around with my avatar for 3/4 minutes, and then the viewer would stop abruptly and exit claiming an Internet problem. Just wonder if you ever seen anything like this?

    My configuration:
    OpenSim Grid mode with user access via the Internet
    Robust and OpenSim on the same server
    Latest version of mono running on Debian and Ubuntu

    Any help would be greatly appreciated.

    Thanks,
    Giang

    Plugin Author Olivier van Helden

    (@magicoli69)

    2 years, 1 month ago

    Hi phmaitre

    Mysql can be tricky for user permissions. I cannot tell for your specific configuration, but often users are configured by default for local access only. You might need to create specific credentials for access from your WordPress server, something like:

    
CREATE USER 'opensim'@'1.2.3.4' IDENTIFIED BY 'yourpassword';

    You might also want to check if your firewall settings (if any) allow external connections from your WP server to mysql port. Again, in most setup, mysql port is not open for external access.

    Currently, w4os connects only to the database, so it is normal you don’t have any message in your Robust console, but you could find helpful information in your mysql log.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[W4os] Error while connecting to Database’ is closed to new replies.