In Docker non funziona l'healthcheck di MariaDB - Revision history

Gabriele.vivinetto at 12:45, 9 December 2025

2025-12-09T12:45:45Z

← Older revision		Revision as of 12:45, 9 December 2025
Line 31:		Line 31:

	* Ora funziona:		* Ora funziona:
			healthcheck.sh --connect --innodb_initialized
	healthcheck.sh --connect --innodb_initialized

	== Riferimenti ==		== Riferimenti ==

Gabriele.vivinetto at 12:32, 3 November 2025

2025-11-03T12:32:52Z

← Older revision		Revision as of 12:32, 3 November 2025
Line 14:		Line 14:
	CREATE USER healthcheck@'127.0.0.1' IDENTIFIED BY 'healthCheckConnectPassEscaped';		CREATE USER healthcheck@'127.0.0.1' IDENTIFIED BY 'healthCheckConnectPassEscaped';
	CREATE USER healthcheck@'::1' IDENTIFIED BY 'healthCheckConnectPassEscaped';		CREATE USER healthcheck@'::1' IDENTIFIED BY 'healthCheckConnectPassEscaped';
	CREATE USER healthcheck@~~'127.0.0.1'~~ IDENTIFIED BY 'healthCheckConnectPassEscaped';		CREATE USER healthcheck@localhost IDENTIFIED BY 'healthCheckConnectPassEscaped';

	QUIT		QUIT

Gabriele.vivinetto at 12:29, 3 November 2025

2025-11-03T12:29:00Z

← Older revision		Revision as of 12:29, 3 November 2025
Line 21:		Line 21:
	* Creare il config file:		* Creare il config file:
	<pre>		<pre>
	cat > /var/lib/~~mysq~~/.my-healthcheck.cnf <<EOFile		cat > /var/lib/mysql/.my-healthcheck.cnf <<EOFile
	[mariadb-client]		[mariadb-client]
	port=3306		port=3306

Gabriele.vivinetto at 12:27, 3 November 2025

2025-11-03T12:27:56Z

← Older revision		Revision as of 12:27, 3 November 2025
Line 12:		Line 12:
	mariadb -u root -p$MARIADB_ROOT_PASSWORD		mariadb -u root -p$MARIADB_ROOT_PASSWORD

	CREATE USER healthcheck@'127.0.0.1' IDENTIFIED BY '$healthCheckConnectPassEscaped';		CREATE USER healthcheck@'127.0.0.1' IDENTIFIED BY 'healthCheckConnectPassEscaped';
	CREATE USER healthcheck@'::1' IDENTIFIED BY 'healthCheckConnectPassEscaped';		CREATE USER healthcheck@'::1' IDENTIFIED BY 'healthCheckConnectPassEscaped';

	CREATE USER healthcheck@'127.0.0.1' IDENTIFIED BY 'healthCheckConnectPassEscaped';		CREATE USER healthcheck@'127.0.0.1' IDENTIFIED BY 'healthCheckConnectPassEscaped';

Gabriele.vivinetto: Created page with "Se l'healthcheck non funziona e se si prova da shell del container, e à errore:

 healthcheck.sh --connect --innodb_initialized  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Il problema è che il database è stato creato con una vecchia versione di mysql o mariadb, e non ha la configurazione corretta per eseguire il check. In particolare, ma..."

2025-11-03T09:53:12Z

Created page with "Se l'healthcheck non funziona e se si prova da shell del container, e à errore:<pre> healthcheck.sh --connect --innodb_initialized ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) </pre>Il problema è che il database è stato creato con una vecchia versione di mysql o mariadb, e non ha la configurazione corretta per eseguire il check. In particolare, ma..."

New page

Se l'healthcheck non funziona e se si prova da shell del container, e à errore:<pre>
healthcheck.sh --connect --innodb_initialized

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
</pre>Il problema è che il database è stato creato con una vecchia versione di mysql o mariadb, e non ha la configurazione corretta per eseguire il check.

In particolare, manca l'utente mariadb healthcheck ed il file di configurazione ..my-healthcheck.cnf da cui lo script legge i datio di autenticazione.

* Creare gli user:
<pre>
mariadb -u root -p$MARIADB_ROOT_PASSWORD

CREATE USER healthcheck@'127.0.0.1' IDENTIFIED BY '$healthCheckConnectPassEscaped';
CREATE USER healthcheck@'::1' IDENTIFIED BY 'healthCheckConnectPassEscaped';

CREATE USER healthcheck@'127.0.0.1' IDENTIFIED BY 'healthCheckConnectPassEscaped';

QUIT
</pre>

* Creare il config file:
<pre>
cat > /var/lib/mysq/.my-healthcheck.cnf <<EOFile
[mariadb-client]
port=3306
socket=/run/mysqld/mysqld.sock
user=healthcheck
password=healthCheckConnectPassEscaped
EOFile
</pre>

* Ora funziona:

healthcheck.sh --connect --innodb_initialized

== Riferimenti ==

* [https://stackoverflow.com/questions/76249051/mariadb-docker-access-denied-error-with-healthcheck-script-when-root-password-is MariaDB docker access denied error with healthcheck script when root password is set, even with MARIADB_MYSQL_LOCALHOST_USER? - Stack Overflow]
* [https://github.com/MariaDB/mariadb-docker/issues/512#issuecomment-1611018543 latest tag 1:11.0.2+maria~ubu2204 - mysql command is gone · Issue #512 · MariaDB/mariadb-docker]