ZoneMinder failing to connect to mysql

w@tcher · Post by **w@tcher** » Wed Oct 13, 2004 2:58 pm

Just installed everything it all appears to been installed ok. However when I try and connect to my webserver I receive the following message

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

Is there something I am missing. PHP was built with mysql support? Is there something that I can do to check connectivity.

perl zmconfig.pl -noi connects to mysql fine...

Thanks

fernando · Post by **fernando** » Wed Oct 13, 2004 3:29 pm

is php_mysql installed?

what linux release you have?

w@tcher · Post by **w@tcher** » Wed Oct 13, 2004 4:23 pm

Sorry -I am running Suse 9.1

I installed PHP 4.3.9 from the source with:

./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql

I am also running Apache2.

fernando · Post by **fernando** » Wed Oct 13, 2004 4:34 pm

iam sorry i dont have idea about suse..

that error came whitout php-mysql or when the mysql users dont have a host. like zm@localhost.

w@tcher · Post by **w@tcher** » Wed Oct 13, 2004 4:46 pm

doing a bit more reading problem may be because I have installed mysql 4.1.5 has anyone else got a working system based on mysql 4.1.5?

Is it worth downgrading to 4.0?

w@tcher · Post by **w@tcher** » Wed Oct 13, 2004 5:40 pm

downgraded to 4.0 - no problems at all.....

thanks