ZoneMinder Forums

The past 3 upgrade attempts in sequential order has produced this error on upgrade.

I have not upgraded Mariadb thus not over written my.cnf if it is the correct file name...cannot remember

I believe when I installed Mariadb root user had a password
Does this mean it is looking for no password ?
Jimmy

I don't have a running instance of a Debian based machine with mysql in front of me at the moment, so this is from memory.

Debian machines have a sql account called debian-sys-maint. This is what allows debian packages that need sql to configure sql during the package installation process w/o prompting for credentials.

Normally this gets setup for you automatically when you install mysql or mariadb. The magic to make this happen is in this file: /etc/mysql/debian.cnf.
If that file is missing, gets tampered with, or the credentials in that file don't match the credentials saved in the database, then you will get the error you posted.

This blog goes into detail of how to reset this account:
https://janjonas.net/2010-02-25/ubuntu- ... l-password

Good luck.

Is it possible to upgrade from 1.34 to 1.35 on debian? And then switch back to 1.35 stable when it gets out?

It's worth running zmupdate as a user with more DB privileges. Shouldn't have to, but I've done it in the 1.35.x series on Ubuntu.

warcanoid wrote: ↑Tue Jan 12, 2021 7:52 am Is it possible to upgrade from 1.34 to 1.35 on debian? And then switch back to 1.35 stable when it gets out?

1.34 is stable. 1.35 is not. 1.36 will be stable when released.

Apparently my root user somehow had a password enabled
I changed root password to no
1.35.16~20210112184157-focal upgraded without error

Jimmy