Can't Connect after creating new datbase connection

Wappler General Bugs
1

I had a database connection that wouldn’t update and show new/edited tables from my MySQL database so I created a new database connection and switched all my server connects to using that one. I then deleted the old database connection and can no longer access my site. I’ve turned off debug now so my database password doesn’t show. I had no idea that the debug could expose login details!! Anyway - the bolded appData below is the database connection I deleted. I’ve also tried re-publishing and that didn’t help.

“code”: 1045,
“file”: “/home/triptakers/app.triptakers.travel/dmxConnectLib/lib/db/Connection.php”,
“line”: 105,
“message”: “SQLSTATE[28000] [1045] Access denied for user ‘USERNAME WAS HERE’@‘mi3-sr19.supercp.com’ (using password: YES)”,
“trace”: “#0 /home/triptakers/app.triptakers.travel/dmxConnectLib/lib/db/Connection.php(105): PDO->__construct(‘mysql:host=ftp…’, ‘USERNAME WAS HERE’, ‘PASSWORD WAS HERE’, Array)\n#1 /home/triptakers/app.triptakers.travel/dmxConnectLib/modules/dbconnector.php(12): lib\db\Connection->__construct(Object(lib\App), Object(stdClass), ‘appData’)\n#2 /home/triptakers/app.triptakers.travel/dmxConnectLib/lib/App.php(197): modules\dbconnector->connect(Object(stdClass), ‘appData’, NULL)\n#3 /home/triptakers/app.triptakers.travel/dmxConnectLib/lib/App.php(137): lib\App->execSteps(Object(stdClass))\n#4 /home/triptakers/app.triptakers.travel/dmxConnectLib/lib/App.php(163): lib\App->exec(Object(stdClass), true)\n#5 /home/triptakers/app.triptakers.travel/dmxConnectLib/lib/App.php(169): lib\App->execSteps(Object(stdClass))\n#6 /home/triptakers/app.triptakers.travel/dmxConnectLib/lib/App.php(137): lib\App->execSteps(Array)\n#7 /home/triptakers/app.triptakers.travel/index.php(19): lib\App->exec(Object(stdClass), true)\n#8 {main}”

2

Hi.
Have seen weird issues with DB and multiple targets before.
Make sure you are on the right target, and check the .wappler folder for any old DB reference.
Everything you see in the UI about your DB connection can be found written in some file in the .wappler/{{target}} folder.
Also, check the DB related files in the root of your application - which is again mantained by Wappler automatically, and contains the actual DB connection details that are used in runtime. Target stuff is just to manage the UI.

Will little manual intervention, you should be able to set the right values in the right files.Been quite some time since I worked on a PHP project in Wappler, so can’t share exact file names/paths.

3

Just make sure you have the right credentials per target and you are on the right target.

4

I only have one target which hasn’t changed and I’ve double checked it to make sure it’s all correct. The dmxConnect/modules/Connections/ still had files for the deleted database connections. Removing those removed the error but now I’m getting …

This page isn’t working

app.triptakers.travel is currently unable to handle this request.

HTTP ERROR 500

I turned debugging back on and still getting just this message.

5

I found those same files in .wappler/targets/Apps/files/dmxConnect/modules/Connections and removed them but same thing. I can’t find anywhere that would be pointing to the wrong db connection.

6

This is the error in the console. (index):6792 crbug/1173575, non-JS module files deprecated.

7

I got the site back up by restoring the database connection file and fixing the password that was wrong in that file. Would still like to get that fixed up!