ListMailPRO Email Marketing Software Forums
ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: dermot on May 08, 2006, 08:07:08 am
-
Ive been trying to install ListMail on our dedicated server and ive got a few issues. I suspect they are down to the versions we use of MySQL and PHP but can someone confirm this pls.
MySQL ver 4.1.9
php 4.3.11
The error I get is:
Could not connect to MySQL. Please check your MySQL database, username, password, and permissions and set up ListMail's config.php
MySQL Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have been through some trouble shooting using MySQL and defaulted to old password hashing but this just caused a user/password login failure.
Any ideas please???
-
A quick search (http://www.google.ca/search?hl=en&q=Client+does+not+support+authentication+protocol+requested+by+server%3B+consider+upgrading+MySQL+client+&btnG=Google+Search&meta=) came up with the following:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
You probably need to upgrade PHP and/or the PHP-mysql modules on your server.
Note: In older versions of PHP, the mysql extension does not support the authentication protocol in MySQL 4.1.1 and higher. This is true regardless of the PHP version being used. If you wish to use the mysql extension with MySQL 4.1 or newer, you may need to follow one of the options discussed above for configuring MySQL to work with old clients. The mysqli extension (stands for "MySQL, Improved"; added in PHP 5) is compatible with the improved password hashing employed in MySQL 4.1 and higher, and no special configuration of MySQL need be done to use this MySQL client library. For more information about the mysqli extension, see http://php.net/mysqli.
Hope that helps :)
DW
-
Id already seen this but this relates to MySQL 5 and im only using v4.1.9
Ive followed the steps described for resolution of this but this causes more problems again with authentication.
-
What I quoted does appear to also affect v4.1.9, see exerpt below:
Note: In older versions of PHP, the mysql extension does not support the authentication protocol in MySQL 4.1.1 and higher. This is true regardless of the PHP version being used.
Unfortunately I have not had the pleasure of experiencing the same problem so can't say exactly how to fix it. I should be able to come up with something using Google. Have you considered/tried upgrading to PHP 5?
Regards
-
im going to try setting up a local server to the same setup and try upgrading that and will let you know.