Dokku qloapps mysql database connection troubles

qwerty

Hi, first off - very excited to having Qloapps up and running so a massive thank you to all of the developers and maintainers.

I have been struggling to establish the database connection between my qloapps instance (running as a dokku app), and my database (an instance of dokku-mysql).

I have the installation app up and running on my domain. But on the Configure your database by filling out the following fields page, I am unable to establish a connection.

I have tried populating the fields according to the database connection url ('DATABASE_URL') given its format:
mysql://username:password@dokku-mysql-hostname:3306/database-name.

I'm aware that the credentials provided by the DATABASE_URL differ from the credentials I set when I created my mysql database (USER_PASSWORD=qloappsuserpassword -e MYSQL_ROOT_PASSWORD=myrootpassword -e MYSQL_DATABASE=mydatabase). I don't quite understand why this is the case so if anyone could shed light on this it would be very much appreciated. Perhaps it is related to the problem. In any case, I have also tried these credentials with no success.

On the dokku-mysql side I have already linked the mysql database with the qloapps dokku app and all appears to be connected on that front. Could this linking be interfering with the linking through the installation app UI?

Please can someone point me in the right direction as I'm all out of ideas for debugging.

sumit201

@qwerty

It seems like you're experiencing MySQL connectivity issues, and your MySQL server and Qloapps server are on different hosts. If you're having trouble connecting to the MySQL server from the Qloapps server, here's what you should do:

1:- Check MySQL Connectivity: First, verify the connection to the MySQL server from the Qloapps server using the following command:

telnet your_mysql_ip 3306

If this works, proceed to the next step.

2:- Attempt Manual MySQL Connection: Try connecting to the MySQL server manually by running:

mysql -h your_mysql_ip -u your_mysql_user -p your_mysql_password

If you're still facing issues, it would be helpful for troubleshooting if you could provide screenshots or additional details about the error you're encountering.