Hi,
I have been trying to upgrade from OpenHAB2 to OpenHAB3. In doing so, I seem to have broken emonpi … I now get the following error when trying to connect:
Can’t connect to database, please verify credentials/configuration in settings.ini
Error message: Connection refused
I think this is something to do with the database not running, so logging on to the emonpi via a shell, and querying the db status, I get this:
pi@emonpi:~ $ systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.17 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: deactivating (stop-sigterm) (Result: exit-code)
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 2054 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 2055 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2057 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (co
Process: 2106 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 2106 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Tasks: 3 (limit: 2319)
Memory: 55.6M
CGroup: /system.slice/mariadb.service
└─667 /usr/sbin/mysqld
Oct 08 14:38:30 emonpi systemd[1]: Starting MariaDB 10.3.17 database server...
Oct 08 14:38:31 emonpi systemd[1]: mariadb.service: Found left-over process 667 (mysqld) in control group while starting unit. Ignoring.
Oct 08 14:38:31 emonpi systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Oct 08 14:38:31 emonpi mysqld[2106]: 2021-10-08 14:38:31 0 [Note] /usr/sbin/mysqld (mysqld 10.3.17-MariaDB-0+deb10u1) starting as process 2106 ...
Oct 08 14:39:08 emonpi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Could anybody offer any advice?
thanks,
JP.