the tcp port is still the same ?
how to verify ?
External TCP port of mariadb This port is necessary to connect a mysql client to the mysql server: mysql -u user -h host -P port -p: 20012
does piwigo use this port in its configuration
Ok, but piwigo is a virtual host of the eb server what should I check if something has changed?
your concern is not webserver, if you want you can restart it, but I bet you will not have a change.
You issue is the piwigo php application that cannot connect anymore to the mysql database
verify in the settings of piwigo what are the mysql setting to connect to the database, try to verify the port, try to change the user, try to verify the password
Ok, what do you think is the responsible package after the ns8 update that caused this? About an idea …
1 Like
I’m not sure, but I tend to believe that the interface, seat, and keyboard are always at the root of the issues on this planet.
I suppose I am as well, in a way.
Ok thanks you for support .
<?php
$conf['dblayer'] = 'mysqli';
$conf['db_base'] = 'piwigo';
$conf['db_user'] = 'piwigo';
$conf['db_password'] = '';
$conf['db_host'] = '192.168.3.76:20012';
$prefixeTable = 'piwigo_';
define('PHPWG_INSTALLED', true);
define('PWG_CHARSET', 'utf-8');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
?>
ip is the same ?
try to use the ip of the wiregard vpn of the server
so for the sake of sysadmin, what settings did you change
I’m changed this 
<?php
$conf['dblayer'] = 'mysqli';
$conf['db_base'] = 'piwigo';
$conf['db_user'] = 'piwigo';
$conf['db_password'] = '';
$conf['db_host'] = '10.5.4.1:20012';
$prefixeTable = 'piwigo_';
define('PHPWG_INSTALLED', true);
define('PWG_CHARSET', 'utf-8');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
?>
The vpn ip !
1 Like
yeah the vpn IP will never change, moreover it is encrypted over wiregard, so any node can contact mariadb under the vpn tunnel
magnifico !!!
Thanks to you and your suggestion. Anyway now I restore the snap, I check that there is an error and then I redo the modification to see if it works.
1 Like
question, your IP on your lan has changed ?
No the ip of server ns8 is equal
1 Like