[tech] Cacti, was Re: mySQL/MariaDB password reset for unisfa-koha

[David Adam]

On Mon, 12 Feb 2018, Nick Bannon wrote:
> On Mon, Feb 12, 2018 at 06:24:21PM +0800, Blair Johnson wrote:
> > Hi all,
> > Just a courtesy email regarding the mysql (MariaDB) server on Mussel.
> 
> There could be 70 or so database user accounts in that state.
> https://secure.ucc.asn.au/phpmyadmin/server_privileges.php?showall=1
> 
> ...possibly affecting:
> https://secure.ucc.asn.au/cacti/
> FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure
> you have specified a valid MySQL database name in 'include/config.php' 
> 
> mussel: ~>mariadb --user=cacti
> ERROR 1275 (HY000): Server is running in --secure-auth mode, but
> 'cacti'@'localhost' has a password in the old format; please change the
> password to the new format
> 
> Resetting that password to the one in mussel:/etc/cacti/debian.php
> seemed promising, and seemed to trigger an upgrade...
> Now https://secure.ucc.asn.au/cacti/graph_view.php works, but has no old
> data?

Cacti has been broken for 12+ months.

[DAA]