Unable to connect to remote mysql database

philadcock · January 25, 2019, 2:02pm

Hi all, I am trying to connect wappler to a remote mySQL database using the instructions at https://github.com/Wappler/docs/wiki/Connecting-to-a-Database. I’m running v1.7.3 on Ubuntu 18.04LTS.

When I attempt create a database connection, I get the error “Invalid target configuration! Check your web server URL and the connectivity to it.” and see the following debug output in Wappler:

Start upload for dmxConnections/dmxDatabase.php
cd ok, cwd=/html
lftp: FileCopy.cc:876: virtual int FileCopyPeerFA::Do(): Assertion `!session->IsOpen()’ failed.
Uploaded /dmxConnections/dmxDatabase.php successfully

I have set up a PHP project with a SFTP target and the Test Connection button reports “Connection Successful!”. I am also able to upload files to the web server directory /var/www/html outside of Wappler using a SFTP client.

Is there any way of getting some further debug info from Wappler so I can work out what is going wrong?

Thanks!

Hyperbytes · January 25, 2019, 2:07pm

The invalid Target message suggests that you have not configured the target correctly on the below screen

Please check your settings and test the connection

Teodor · January 25, 2019, 2:13pm

Please check the URL you entered and the remote folder. Usually this is where the problem is.

bibi · January 25, 2019, 3:49pm

Have you tryied with a non “S” Ftp setting ? did it work ?
The following config gives succesfull result to a MySQL BD / only on a not-secured connection.

philadcock · January 28, 2019, 5:29pm

This seems to be an issue with my Ubuntu installation. It works fine using wappler on my mac with exactly the same target and database connection settings. I’ll try a reinstall as I’m starting to see frequent lftp crash reports. Thanks everyone!