Could not connect to database

Support and queries relating to all previous versions of ZoneMinder
Locked
karlgoe
Posts: 2
Joined: Fri May 06, 2005 1:35 am

Could not connect to database

Post by karlgoe »

All went well installing Zone Minder 1.21.0 on RH 7.3 until - trying to access from the browser for the first time.

I receive the following error:

Warning: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/www/html/zm/zm_db.php on line 21
Could not connect to database: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I have search the forums, but have not been able to find any hints to help with this issue.

Anything help that you can provide would be greatly appreciated.

Thank you in advance,

Karl

Here is the MySQL version I have installed:
MySQL-server-4.1.11-0
MySQL-devel-4.1.11-0
MySQL-shared-4.1.11-0
MySQL-client-4.1.11-0
MySQL-shared-compat-4.1.11-0

I have the following PHP versions installed:
php-mysql-4.1.2-7.3.6
asp2php-0.76.2-1
php-4.1.2-7.3.6
php-ldap-4.1.2-7.3.6
asp2php-gtk-0.76.2-1
php-imap-4.1.2-7.3.6

Apache:
apache-1.3.27-4
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post by zoneminder »

I think this is a mysql issue rather than a ZM one. This page might be helpful.

Phil
karlgoe
Posts: 2
Joined: Fri May 06, 2005 1:35 am

Post by karlgoe »

Thank you Phil,

You are right, it is an issue with authentication to MySQL.

It is an issue with how ZM is trying to login / authenticate itself with MySQL. I can't seem to find what code / script specifies the login credentials. My preference would be to see if it can be changed there rather than start MySQL 4.1.1 with --old-passwords option.

Thank you for getting me a little further down the path.

Karl
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post by zoneminder »

You may need to update php. This thread discusses the same issue you are having.

Phil
Locked