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
Upgrade error
-
- Posts: 203
- Joined: Thu Jan 01, 2015 5:12 pm
- Location: Rhode Island
Upgrade error
Linux Mint 23 Cinnamon Mariadb 10.x using Master 1.37.x latest always
DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
- knight-of-ni
- Posts: 2406
- Joined: Thu Oct 18, 2007 1:55 pm
- Location: Shiloh, IL
Re: Upgrade error
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.
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.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
All of these can be found at https://zoneminder.blogspot.com/
Re: Upgrade error
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?
Re: Upgrade error
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.
-
-
- Posts: 203
- Joined: Thu Jan 01, 2015 5:12 pm
- Location: Rhode Island
Re: Upgrade error
Apparently my root user somehow had a password enabled
I changed root password to no
1.35.16~20210112184157-focal upgraded without error
Jimmy
I changed root password to no
1.35.16~20210112184157-focal upgraded without error
Jimmy
Linux Mint 23 Cinnamon Mariadb 10.x using Master 1.37.x latest always
DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier
DVB stands for Digital VIdeo Broadcasting , retired satellite downlink supplier