#1  
Old 5th November 2006, 20:51
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 2 Times in 2 Posts
Default FUBAR'd really bad

I over wrote my user table in MySQL. I have recreated all the users for my sites in there, so they can all access the database, but I don't know what potentially happened with the db_ispconfig table. I have the root user and password setup the same. I granted the permissions and I still cannot get it. For some reason the error I am getting does not match up with the problem I think I am having. I have not made any changes to MySQL or any libraries on my system, however, here are the error messages I am getting:

Code:
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77

Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php:77) in /home/admispconfig/ispconfig/web/login/login.php on line 60
What should I do to recover without having to recreate all of my sites?
Reply With Quote
Sponsored Links
  #2  
Old 5th November 2006, 21:00
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,145
Thanks: 4
Thanked 55 Times in 51 Posts
Default

No backups?
Reply With Quote
  #3  
Old 5th November 2006, 21:02
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,034
Thanks: 264
Thanked 151 Times in 131 Posts
Default

Try to set the MySQL password within SSH, this way.

type mysql -u root -p
On Enter password: .... enter your MySQL root password

Now type:
SET PASSWORD FOR
'web1_u1'@'localhost' = OLD_PASSWORD('the_password_you_like_to_use');

**** Change the web1_u1 to the correct user name!

Once done, type quit

I'm not sure if this will fix your problem, but give it a try!
Reply With Quote
  #4  
Old 5th November 2006, 21:11
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 2 Times in 2 Posts
Default Passwords

I can get to my sites and all that just fine, I just cannot get to my ISPConfig admin site.

I of course did not backup before I did this and do not want to risk losing more data.

Thanks,

Fred
Reply With Quote
  #5  
Old 6th November 2006, 14:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
 
Default

Quote:
Originally Posted by fbnewtz
Code:
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 77
Did you update your MySQL version?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
504 Bad gateway, Fedoracore 5 ISPconfig main3 Installation/Configuration 12 20th August 2006 11:38
Unbearably slow access speeds CombatGod Installation/Configuration 5 30th May 2006 16:31
Can't receive mail burtathis Installation/Configuration 18 23rd March 2006 17:23
When attempting to login using https, I get a bad or corrupted certificate error drtrembath Installation/Configuration 1 9th March 2006 19:22
I made a bad choice during install, how do i change it? kidtriton Installation/Configuration 2 27th January 2006 16:55


All times are GMT +2. The time now is 09:46.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.