New Database Error

[cmcadmin]

I go on Vacation for a week, come back and my Forum is down

I get the generic Database Error message. When I view the Page source I get:

Database error in vBulletin :

mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client
C:\XXX\XXXX\XXXX\webroot\forums\includes\class_core.php on line 279

MySQL Error  : 
Error Number : 
Date         : Tuesday, September 19th 2006 @ 09:44:41 PM
Script       : http://www.chicagolandmustang.com/forums/index.php
Referrer     : 
IP Address   : XX.XXX.117.30
Username     : 
Classname    : vb_database

[Steve Machol]

This is a server issue. PHP is not correctly installed with MySQL support. You need to contact your host about this.

[cmcadmin]

My host swears that PHP is correctly configured with MySQL support. They are now giving me the run around....

I have no idea what to do.

[Steve Machol]

Then ask them to explain why you are gettingt this error:

mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

That is not a vB issue, it's a server one.

[cmcadmin]

I stressed to them that it was a server issue. I know it is a server issue as well, because no one has changed any of my vB settings.

They keep telling me to check my connection strings. And that they were able to generate a PHP script to connect to my database. I will contact them again and see what they say this time.

[Steve Machol]

Ask them which versions of PHP and MySQL they are running.

Also you have a phpinfo.php file? If not create a text file with this content:

<?php
phpinfo();
?>

Name it 'phpinfo.php' then upload it to your forum directory and post the URL here. This will help us troubleshoot the problem.

[cmcadmin]

http://www.chicagolandmustang.com/forums/phpinfo.php

MySQL version 5.0.19

[Steve Machol]

Perhaps it's the client version they are using in PHP:

Client API version: 3.23.49

They should update this.

[cmcadmin]

What version should they be running?

And why wouldnt I have had a problem all along?

[Steve Machol]

MySQL version 5.0.19

[cmcadmin]

They are now telling me that I need to specify an adodb driver and that I need to change my connection string.

$connect = new COM('ADODB.Connection');
$connect->Open("DRIVER={MySQL ODBC 3.51 Driver}; SERVER=$mysqlServer;DATABASE=$mysqlName;UID=$mysqlName;PWD=$mysqlPass;");

I need to figure out where to make that change.

[Steve Machol]

Never heard of that before. Sounds pretty fishy to me.

[cmcadmin]

What do you suggest?

[Steve Machol]

This is still a server issue. I suggest you ask your host to fix this. There is nothing we can do from the vB end to fix this.

[cmcadmin]

What file would I need to modify to make the change to my Connection String?