ZoneMinder Forums

Hi All,

I am starting ZM for the first time and I am getting this error:

Stopping ZoneMinder: DBI connect('database=zm;host=localhost.localdomain','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /usr/local/bin/zmpkg.pl line 64
Can't call method "prepare_cached" on an undefined value at /usr/local/bin/zmpkg.pl line 66.
BEGIN failed--compilation aborted at /usr/local/bin/zmpkg.pl line 74.

Any ideas as to what I am doing wrong?

Thanks.

Sorry, I forgot a few details.

I am running version 1.20.1 of ZM, Fedora Core 3.

I have got everything else working (apache, php, mysql).

When I try and view http://localhost/zm/ I get the following error as well (similar to the command line error:

Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /usr/local/apache/htdocs/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

The only other strange thing that I had to do was (when installing MySQL from RPMs) was install a different shared library set.

So instead of installing:
MySQL-shared-4.1.9-0.i386.rpm

I had to install this:
MySQL-shared-compat-4.1.9-0.i386.rpm

Why does ZM use MySQL 3.x bits? (I think that is what it means)

Hi all,

Well as is usually the case with these things I found the solution myself.

From what I can gather ZM uses an old authentication method for MySQL.

For this to work (well in my case anyway) I had to set the password for the old method.

All I did was go into a mysql command prompt and typed:

SET PASSWORD FOR'root'@'localhost' = OLD_PASSWORD('newpwd');
(notice the OLD_PASSWORD part, this was the difference)

Now I am able to get to the web page, next thing is to get the camera working!

Love the package, keep up the great work.

Just wondering if you edited /etc/zm.conf and gave it a user name and password?
Which version did you install from source or RPM?
If RPM did you run /usr/lib/zm/bin/zminit after updating the user and pass in the config?