Direct Database Connection error

Wappler General
1

unable to connect to my data base on website - i updated database and it was displaying new content on website page https://odessaantiqueshow.ca/vendor_list.php

  • but when i went into wappler to update page information and after the upgrade to W5 - i lost feed on webpage – so checked by Direct Database Connection settings and they were gone - either it broke or i messed it up. I tried to enter new connection profile but doing something wrong as test connection is failing. Originally set this up in 2019 and just now post covid the site needed an update — and my memory is weak
    connection
    connection1416×926 126 KB
    error
    phpomyadmin
    phpomyadmin994×858 124 KB
2

Take out the “/pma” on the host field

3

thanks but tried that as well changes error error2

4

Do you have a control panel you can check the database settings? Do you have SSH access? That error means it couldn’t contact the MySQL/MariaDB server, it’s either not running (which is not the case, as you can access it through phpMyAdmin), has a firewall in front blocking the port or it’s running in another port.

Most likely scenario it’s firewalled and you might need to use SSH to access it, but this is speculation tbh

5

thanks for your suggestions - i got rid of avast awhile back - i tried turning off windows defender firewalls and no difference
the connection does have SSH option but dont have a ssh user or passphrase for it - does this screenshot tell anything else ?

phpmyadmin
phpmyadmin949×685 56.9 KB

i tried local host and also user name n this page but no luck

6

I was talking about the firewall on the server, not the ones on your computer :slight_smile:

Sadly, the screenshot didn’t reveal what I wanted to see (I wanted to see which port the MariaDB server was running, but it seems phpMyAdmin is connecting via a UNIX socket instead of a port)

Let’s try another approach. Can you go check here the database credentials?

Screenshot
Screenshot822×396 26.6 KB

7

didn’t know how to check firewall on server so only tried what i did know to eliminate
doesn’t look like i have any DB credentials? (see screenshot) - but at a loss because everything was working and connecting to phmyadmin and tables were updating until i tried to edit the page - did not touch the database until had problems… if you are inclined and it would help i have no trouble sharing phmyadmin login info with you , but don’t

db
db432×550 21.3 KB
want to abuse your support

8

I think it’s better you contact the server administrator to give you the MariaDB credentials - or did you setup the server by yourself?

9

I did set it up but that was 2019 and forgot what i did (web design is a sideline for me) - i have emailed my server contact to verify login credentials and should hear back Monday. Thanks again for your help - will post when i get a result.