php with mysql-4.1

Griffith · Unread post by **Griffith** » Mon May 02, 2005 5:41 pm

Atomic:
does your rpms work with mysql-4.1? Just wondering because of the "new" authentication thing in mysql-4.1.. got problems while trying to connect to mysql-4.1 db. Got this error:
Client does not support authentication protocol

Got it working using old_passwords.. but I had to update the users password to get it working.. in the future.. might plesk-7.5.3.. will the cause a problem? ideas?

Unread post by **scott** » Mon May 02, 2005 10:27 pm

So PSA 7.5.3 is having issues with mysql-4.1 after all?

Griffith · Unread post by **Griffith** » Tue May 03, 2005 3:09 am

I'm not quite sure... only thing I've noticed was that I had to use old_passwords...

Unread post by **scott** » Tue May 03, 2005 3:38 am

Can you give me more details?

Griffith · Unread post by **Griffith** » Tue May 03, 2005 7:51 am

I'll try;):

I am running this testserver with centos-3.4

I have these mysql rpms:
MySQL-server-4.1.11-0
MySQL-client-4.1.11-0
MySQL-shared-compat-4.1.11-0

php:
php-imap-4.3.11-6.rhel3.art
php-odbc-4.3.11-6.rhel3.art
php-pgsql-4.3.11-6.rhel3.art
php-4.3.11-6.rhel3.art
php-mysql-4.3.11-6.rhel3.art
php-pear-4.3.11-6.rhel3.art

And I am running the plesk-7.5.3 beta1.

First I add a new db i plesk cp. Then I create a new user in the cp, and when I go into mysql db and check what it has stored on this user I get this:
localhost | user | *3055544BD641D0814B910C4ACA5799F51B80F460

But, when I try to connect to this db using this user, I get this error:
Client does not support authentication protocol requested by server; consider upgrading MySQL client

In my php-script I use this to connect:
$db=mysql_connect(localhost,$UserName,$Password) or die ("cant connect");
mysql_select_db("$Database") or die ("cant select db");

After searching at google, I found many places where they told us to run this:
set password for user@localhost = OLD_PASSWORD('password');

When I do that, it works.. and when I see what is stored in mysql, I get this:
localhost | user | 025a65095c7d62ed

You can see the password is stored in a quite "different way".. not sure how to explain it..but I guess you know what I'm talking about

jclawson · Unread post by **jclawson** » Sat May 21, 2005 2:52 am

hey if you want to run MySQL 4.1 just add the following line to your /etc/my.cnf

old_passwords=1

Then you don't have to alter any of your mysql queries and plesk won't complain. You may have to re-set your passwords if they were previously stored in the new format.

I am running PHP 5.0.4 and MySQL 4.1.1 and it works just fine with plesk. I have to enable PHP on each domain by hand.... but other than that, everything runs as normal.

Jason Lee · Unread post by **Jason Lee** » Sat May 21, 2005 10:28 am

I'm running MySQL 4.1 and it works fine with my 7.5.3 install

Traged1 · Unread post by **Traged1** » Wed Jul 06, 2005 1:31 am

I got , MySQL 4.1.12 on plesk 7.5.3 RHEL3 working really nice thanks to ART's RPMs. I have notice one problem; Mambo?

Upon installling Mambo from the application vault or pre-installed copies of Mambo 4.5.2 or lower I get the following error:

This site is temporarily unavailable.

Please notify the System Administrator

2

I think this is becuase of the password/hash change in MySQL which make it impossible for mambo to reach MySQL.

Does anyone have a possible solution for this?

[/code]

exi1ed0ne · Unread post by **exi1ed0ne** » Sat Nov 26, 2005 4:23 pm

Any passwords that were created between when mysql was updated and the old_passwords line was added to the my.cnf will need to be changed. There is a good way to find them in another thread on this topic: http://forum.sw-soft.com/showthread.php?threadid=28321