Hi,
I did an SSL renewal following AWS procedure and although the SSL has renewed I get an error saying: A configuration error occurred. Please return later.
I haven't had this before with the SSL renewals. Where can I start diagnosing?
Okay, I reviewed the debug log in zp-data and it's pointing to the database credentials not being right. I have never messed with the database credentials. The credential error only showed up in the log once the SSL renewal went through. What should I check for next?
Okay, I was able to log into MySQL using the same credentials in config.php. I'm not sure why Zenphoto is seeing it as wrong.
WARNING: mysqli_connect(): (HY000/2002): No such file or directory in /opt/bitnami/apache/htdocs/portal/zp-core/functions-db-MySQLi.php on line 30
mysqli_connect called from db_connect (functions-db-MySQLi.php [30])
from require_once (functions-basic.php [204])
from require_once (functions.php [18])
from include (index.php [14])
from index.php [56]
This is what the debug.log file is saying. I double checked the MySQL credentials in the zenphoto.cfg.php file. They are fine.
functions-db-MySQLi.php does not exist in Zenphoto 1.6 anymore. So you are not on the latest version. Please upgrade.
However SSL has not really anything to do with MySQL access The error is not really about a missing file but actually that some part of the credentials are missing or wrong. Are you really sure the host is really correctl? "Localhost" will most likely not work on a live server.
PHP 8+ is much more picky with this but if you are not on Zenphoto 1.6 that is not compatible anyway.
I checked my config file and the host was set to localhost which was working when we first setup zenphoto. I checked the mysql config and the bind address is set to 127.0.0.1
Also in the mysql log I see that I get these messages:
2023-07-05T14:54:56.717079Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-05T14:54:57.077415Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-07-05T14:54:57.210016Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-07-05T14:54:57.293594Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-07-05T14:54:57.293787Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-07-05T14:54:57.318300Z 0 [System] [MY-010931] [Server] /opt/bitnami/mysql/bin/mysqld: ready for connections. Version: '8.0.23' socket: '/opt/bitnami/mysql/tmp/mysql.sock' port: 3306 Source distribution.
The bind address has '::' in it. Is that accepting any IPV4 addresses?
I checked my config file and the host was set to localhost which was working when we first setup zenphoto.
Well, hosts may change (or forget) things on updates and not always tell that… Try the actual db server name instead.
The bind address is nothing that is set via Zenphoto. Perhaps contact the host as it also might be a server config issue with the update…?
Or perhaps the socket is wrong? With Zenphoto 1.6. you can also define that via the config file.
I'm using AWS Lightsail with a LAMP stack. I tried to use my public IP to the hostname and it won't work. It was working fine yesterday.
Kinda stuck.