Database Error

[tobybird]

I requested that my host upgrade our VPS from PHP 4.4.4 to PHP 4.4.7 and install Xcache v1.2.1, which they have completed.

I am now being flooded (over 2000 already) with db errors and have contacted my host regarding this..


Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Client does not support authentication protocol requested by server; consider upgrading MySQL client /home/mysite/public_html/forum/includes/class_core.php on line 274

MySQL Error :
Error Number :
Date : Thursday, November 29th 2007 @ 02:48:58 PM
Script : http://www.mysite.com/forum/index.php
Referrer : http://www.mysite.com/forum/index.php
IP Address : x.x.x.x
Username :
Classname : vb_database


I have still yet to hear from my host regarding the connect issue so I am trying to resolve this myself. I am running MySQL version 4.1.22-standard.

Does anyone have any ideas? I'm searching Google now, but thought I'd ask you guys, too.

Thanks much
:)

[snakes1100]

Post the contents of your my.cnf

Also, reset your password for your database user thru phpmyadmin.

[tobybird]

Hi, thanks for the reply.... goodness this doesn't look right, does it?

/ect/my.cnf

[mysqld]
set-variable = max_connections=500
safe-show-database

[snakes1100]

Thats a default my.cnf on a mysql install for some OS's

[tobybird]

Post the contents of your my.cnf

Also, reset your password for your database user thru phpmyadmin.

Love to. I'm in phpmyadmin...

grrr... where can I do this?

I'm sorry, thanks again for your help!

[snakes1100]

On the main page, click "privileges", then click the little pencil icon on the right of the user for your forum, type the new password in the provided boxes in the change password box.

[tobybird]

Oh well hell. I don't get it. For some reason I'm not logged in properly... I appear to be logged into phpmyadmin as my cpanel user.

This is the path I use to login.... is there another way?

http://xxx.xxx.xxx.xxx:xxxx/3rdparty/phpMyAdmin/index.php?db=xxxxxxx&token=......

[snakes1100]

If your using cpanel, change the forum user password using webhost manager.

http://x.x.x.x:2086/3rdparty/phpMyAdmin/index.php

[tobybird]

Anthony, thanks again for your help. I'll try that.

Question.... My host has asked if I have a backup, because apparently they've fubared my box. Ya, this polite girl is starting to speak like a sailor..:rolleyes:

Anyway! They asked for this an hour ago. Would it really take that long to restore a site via backup?

--------------- Added 1196377105 at 1196377105 ---------------

Ok, so I'm in.... see the password field, shall I just edit it because, of course, what I see is not the "actual" password.

[snakes1100]

It sounds like you have yourself a drunk sailor.

Import of your db depends on how much info is in it really, but if you db is only 100-200mb, it should be under 5 minutes to import it.

Your welcome.

[tobybird]

Well.... the change of the password, and I did modify the config.php, doesn't seem to be doing anything.

The sql file is only 222mb. I just keep getting canned: "Hello, We are working on your issue. We will get back to you with the updates." messages from my host. lol And no, I'm not pestering them. I'd rather they work on my site than spend their time messaging me.

Sad thing, until now my hosting company has been pretty great. It just seems like they are grasping at straws. This just bites.

[Marco van Herwaarden]

This is most likely not a corrupted database, but simply a badly configured PHP.

Tell your host to recompile PHP using "system mysql".

[tobybird]

This is most likely not a corrupted database, but simply a badly configured PHP.

Tell your host to recompile PHP using "system mysql".

In essence, you are correct. It was that coupled with a poor Xcache installation.

I need to send a huge thank you to Anthony. He took time out of his evening and corrected our problem in under an hour where my host took four with no resolution.

Anthony, thanks so much again!

[Marco van Herwaarden]

Not very good advertisement for your host if they can not locate such a simple problem to be honest. The error message was pretty clear and enough information to know what is failing.

PS I mean if i can "guess" what is causing it without server access, then......

[tobybird]

LOL you think? :p

I was itching to move as it was and this has pushed me over the edge. Sad thing....these guys have a great reputation, and I've been with them for over a year now. grr I hate having to move sites.

[snakes1100]

Unfortunately this was a tech issue and the bad recompile of apache/php, had nothing to do with the db itself, sometimes this can relate to old password issues from older versions of MySQL, but it was not the case here.

The drunk sailor strikes again! :D