Can't Log In after IP Address Change

[GlennG]

I changed the IP address of my Zabbix server, and now I can't log in to the web interface. I even reset the Admin password in the MariaDB database, but it just says, "Login name or password is incorrect." DNS has been updated, but I've also tried browsing to the IP address. What else can I check? Using 3.2.4-2 on CentOS 7.

[batchenr]

what do you see at mysql error log \ zabbix server log ?

[GlennG]

Nothing. There is no record corresponding to the time of login in messages, mariadb.log, or zabbix_server.log. Apache records the visit to the login page, but does not log any error. Zabbix is still sending notifications, but I can't log in on the web interface.

[ovas]

Hello!

have you tried to reset the password via md5 hashing?

update zabbix.users set passwd=md5('mynewpassword') where alias='Admin';

What if you leave it blank? What if you insert default hash for "zabbix" password: 5fce1b3e34b520afeffb37ce08c7cd66 ?

[GlennG]

Yes, I've tried changing the password and leaving it blank. I also changed it to "zabbix", and the hash corresponds to the one you noted. Still no luck. It's as if Zabbix is looking at some other password database, but the DB server is on localhost and has not changed.

[GlennG]

Never mind. I forgot that I had enabled LDAP authentication. So Admin does not work because there is no user named Admin in our LDAP directory. I needed to use my own user name with its current LDAP password. A page in Rihards Olups' book, "Zabbix Network Monitoring" gave me the clue. He writes about various ways that users can lock themselves out of the frontend. It had nothing to do with the IP address change, and everything to do with the fact that I hadn't logged in for a long time.