Author Topic: Windows 2003 Dedicated server and ListMail (Read 1822 times)

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???

DW · « **Reply #1 on:** May 08, 2006, 04:41:50 pm »

A quick search 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.

Quote

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

dermot · « **Reply #2 on:** May 09, 2006, 02:30:40 am »

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.

DW · « **Reply #3 on:** May 09, 2006, 10:58:45 am »

What I quoted does appear to also affect v4.1.9, see exerpt below:

Quote

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

dermot · « **Reply #4 on:** May 10, 2006, 01:13:10 am »

im going to try setting up a local server to the same setup and try upgrading that and will let you know.