Page 1 of 1

ZoneMinder failing to connect to mysql

Posted: Wed Oct 13, 2004 2:58 pm
by w@tcher
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

Posted: Wed Oct 13, 2004 3:29 pm
by fernando
is php_mysql installed?

what linux release you have?

Posted: Wed Oct 13, 2004 4:23 pm
by w@tcher
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.

Posted: Wed Oct 13, 2004 4:34 pm
by fernando
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.

Posted: Wed Oct 13, 2004 4:46 pm
by w@tcher
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?

Posted: Wed Oct 13, 2004 5:40 pm
by w@tcher
downgraded to 4.0 - no problems at all.....

thanks