I have been running a 3.x zabbix for a while and needed to upgrade it. I tried updating linux platform (Debian 8) but it then trashed the zabbix database setup..
So I installed a clean Ubuntu 22.04 / Zabbix 6.0 LTS system and then did a database backup (mysqldump) & restore to transfer the database to the new setup. The database update process seemed to complete without too many issue and the server appears to be running.
I then did the frontend setup which also went through without issues
HOWEVER
I am unable to login to the system - I get 'bad password or locked out' error.
When I look at the zabbix.users table the password column is blank....
I tried the 'old' trick of updating the entry for admin via mysql with an md5 hash for a known password but still not working.
I understand that the password hash function has been changed as MD5 is rubbish...
So can I still manually update the password field via mysql (& if so what hash function do I use) or can someone send me a hash value for a known good password (Eg the default zabbix password )
Thanks
David
So I installed a clean Ubuntu 22.04 / Zabbix 6.0 LTS system and then did a database backup (mysqldump) & restore to transfer the database to the new setup. The database update process seemed to complete without too many issue and the server appears to be running.
I then did the frontend setup which also went through without issues
HOWEVER
I am unable to login to the system - I get 'bad password or locked out' error.
When I look at the zabbix.users table the password column is blank....
I tried the 'old' trick of updating the entry for admin via mysql with an md5 hash for a known password but still not working.
I understand that the password hash function has been changed as MD5 is rubbish...
So can I still manually update the password field via mysql (& if so what hash function do I use) or can someone send me a hash value for a known good password (Eg the default zabbix password )
Thanks
David
Comment