MySQL connection issue when using custom domain

[vilmarci]

Dear Community,

I have an instance of OsCommerce on a NAS that works fine as long as I use it locally with the LAN IP address. But, when I try to access it from outside, with a custom domain, I get the following error:

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'xxxxx@'localhost' (using password: YES) in /volume1/web/oscommerce/catalog/includes/functions/database.php on line 20 Unable to connect to database server!

the whole chain looks like:

my domain -> router -> NAS -> Web station (SSL)

In the browser I can see that the connection to the website is successfully made, certificate is valid, browser happy, something goes wrong after. I tried to add the osc user permissions to log in from any host, but this didn't solve the issue. Anything else I can try?

[Thomas789]

Have you tried using

  define('DB_SERVER', '127.0.0.1:3306'); 

in includes/configure.php instead of localhost ?