vb.org Archive - Database Error

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Database Error (https://vborg.vbsupport.ru/showthread.php?t=163886)

tobybird

11-29-2007 07:03 PM

Database Error

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

Quote:

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

11-29-2007 08:06 PM

Post the contents of your my.cnf

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

tobybird

11-29-2007 08:12 PM

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

/ect/my.cnf

Quote:

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

snakes1100

11-29-2007 08:13 PM

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

tobybird

11-29-2007 08:18 PM

Quote:

Originally Posted by snakes1100 (Post 1391902)

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

11-29-2007 08:22 PM

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

11-29-2007 08:35 PM

1 Attachment(s)

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

11-29-2007 08:44 PM

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

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

tobybird

11-29-2007 08:48 PM

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 [DATE]1196377105[/DATE] at [TIME]1196377105[/TIME] ---------------

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

11-29-2007 08:59 PM

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.

All times are GMT. The time now is 02:27 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01993 seconds Memory Usage 1,736KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: