DA MySQL Management, Error connecting to MySQL

I

ilan

Verified User
Joined
Feb 5, 2004
Messages
48
Location
Mexico City
We have been working fine for a very long time, but just now something happened and now the MySQL Management on DA doesn't work. With every user including the admin, we receive the same error message:

Error connecting to MySQL: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Our server has mysql 4.1.21 and php 5.2.5 compiled for client API version 4.1.21 (many posts mention a difference on the php client as a source for the problem, but apparently that's not our case) and we have DA ver 1.37.0, on a RH 7.3 server.

The strange thing is that php does communicate fine with mysql, all our clients' sites are up and running, and phpmyadmin lets us connect to all databases with no fuss, so apparently there's no problem with new/old passwords (all our passwords are under the new schema, which was also mentioned in some posts).

We are also able to connect to the database using the credentials at:
/usr/local/directadmin/conf/mysql.conf so that's also ruled out.

There are no error messages in the mysqld.log, /usr/local/directadmin/error.log and messages.log , and we haven't upgraded software lately.

The last thing we did before we noticed the error is that we ran the script change_database_username.php to change the username of one of our clients which didn't rename all the databases and that's how we discovered the problem with DA (when we tried to enter the administration to create the databases manually).

Any ideas?
Ilan
 
MySQL Management on DA doesn't work
Click to expand...

Maybe new version of Directadmin does not support MySQL 4.1.x anymore.... You'd better ask John then. But as it seems to me Direcadmin uses PHP-CLI to connect to MySQL.

You might want to write a simple PHP script that tries to connect to MySQL server and see will it work. Note, you should run this script from SSH (not apache).
 
Last edited:
Thanks for the ideas,

zEitEr said:
Maybe new version of Directadmin does not support MySQL 4.1.x anymore.... You'd better ask John then. ...
Click to expand...

How would I ask John? does he monitor this forums?


zEitEr said:
... But as it seems to me Direcadmin uses PHP-CLI to connect to MySQL.
Click to expand...

I only have PHP-CLI configured in this server, so we are Ok with that.


zEitEr said:
You might want to write a simple PHP script that tries to connect to MySQL server and see will it work. Note, you should run this script from SSH (not apache).
Click to expand...

I created a small php script and ran it from shell and it works fine (it had no problem reading the database).

Once again, thanks.
 
Here is the result:

# rpm -qa | grep -i mysql
MySQL-server-4.1.21-0
MySQL-devel-4.1.21-0
MySQL-client-4.1.21-0
MySQL-shared-4.1.21-0

This is so strange...

I'll send him a link to this post, hopefully he'll know of something.

Thanks
Ilan
 
Hello,
on a RH 7.3 server
Click to expand...
That's probably the first issue.. that's very.. very old. We do still have a build box for that, but it lives in it's own time, so doesn't get version updates of the services, to ensure it remains compatible with it's older era.

I believe our DA binaries (built on 7.2) are compiled against MySQL 4.0, so you could downgrade to 4.0 (not recommended, as password formats are all different).

We could try the binaries for an old version of Fedora, or CentOS 4.. as they may run, but may also work against the new MySQL versions (this is just a guess, may not work at all, but can be undone).

It would honestly be better to upgrade the box OS version, as I can't even start to imagine how many security fixes are available from the days of 7.3.

CentOS 6 would be the new generation of RedHat, if you do plan to upgrade.

John
 
We find that we have problems updating servers as new as RHEL, CentOS or WBEL as recently as version 3; I'd suggest that you really need to move off RHL 7.3 if at all possible.

Jeff
 
I agree, it's a very old server, but in our "archeology farm", we have another server with RH 7.3 and everything is working fine.

This other server has the following software:

MySQL 4.0.17
PHP Version 4.3.8
mysql client API version 3.23.49 (doesn't appear to matter that it's older)
Apache 1.3.31

# rpm -qa | grep -i mysql
MySQL-server-4.0.17-0
MySQL-devel-4.0.17-0
MySQL-client-4.0.17-0

DirectAdmin 1.37.0

This second server is going out of commission very soon, the problem is that the other one (the one with the problem) has installed some software that doesn't exist anymore so we can't upgrade or move...

I'm almost sure that we didn't have this problem until very recently, otherwise our clients would have screamed.

So if you have a compiled version of the last 2 or 3 DA upgrades, maybe we should give it a try.

What do you think?

Ilan
 
Unrgent Server problem

I have a server use to input data and recall for the data when needed the name of the software is BIGFOOT Software but just of recent after licensing some of the system it refuse to open the software from the Clients Computer after trying so many steps for more than 3days. Now i need your help from Admin Engrs. My Server is configure with SQL and working well before but just of recent begin to misbehave.....I need help.
Thanks.
Engr. Balogun Ayodeji
 
a.ydot2007 said:
I have a server use to input data and recall for the data when needed the name of the software is BIGFOOT Software but just of recent after licensing some of the system it refuse to open the software from the Clients Computer after trying so many steps for more than 3days. Now i need your help from Admin Engrs. My Server is configure with SQL and working well before but just of recent begin to misbehave.....I need help.
Thanks.
Engr. Balogun Ayodeji
Click to expand...
Are you running DirectAdmin on your server? If so follow DirectAdmin instructions for creating, the MySQL database, and be sure to open all firewalls between the client machine and your DirectAdmin server. Also be sure you're using those credentials when attempting to connect to MySQL.

If you're not running DirectAdmin on your server then you're asking in the wrong place.

Jeff
 
You must log in or register to reply here.
Back
Top