Authentication failure after debian upgrade

[tim@pcs-alaska.com]

I've been away from the forums for months becuase ZM has been running so great for me! Thanks Phil!

I did an upgrade to my Debian box last week and now I can't log into the ZM.php page. Can anyone advise me on how to troubleshoot my authentication problem?

Thank you!

[zoneminder]

Do you mean you just upgraded your distro, or you upgrade ZM on your distro?

If it's the former, my guess is that maybe you have a newer version of mysql on there. Newer versions of mysql use a different password system and you have to configure it to use old passwords. Google for 'mysql old_password' or something for more info.

Of course it may not be that at all!

[tim@pcs-alaska.com]

Hi Phil,

I meant I did and upgrade to the Debian system not ZM. I did research the mysql issue and found, by using MySQL Admin, that I no longer have an 'admin' account.

I tried to create a user named 'tim' and assigned it all the privileges to the ZM db, but I still can't log in.

Is there a better way to recreate an account that can log into ZM?

I tried the:
mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

But I get an error stating 'Can't find any matching row in the users table', which of course matches what I see in MySQL Admin.

Also, I see a www-data user account in MySQL Admin. Would I need to reset that users password for any reason?

Thanks again,

[zoneminder]

The sql you list would apply the changes to the users table in the mysql database and not anythign ZM specific. Are you sure that your upgrade hasn't just wiped (or moved) the whole zm database?

[tim@pcs-alaska.com]

I looks like the zm database is still intact:


mysql> show tables;
+--------------+
| Tables_in_zm |
+--------------+
| Config |
| Controls |
| Events |
| Filters |
| Frames |
| Groups |
| Monitors |
| States |
| Stats |
| TriggersX10 |
| Users |
| Zones |
+--------------+
12 rows in set (0.00 sec)

[tim@pcs-alaska.com]

I'm stumped. I can see that ZM is still recording. I just can't access it via the zm.php page.

I rebooted the server and now when I try to login I get a quick "login" msg then immediately I'm logged out. This is with the 'admin' account that MySQL says is not in the user table.

Phil, would you advise I upgrade to the latest version? Will this resolve the issue?

Thanks for your assistance!