#1  
Old 5th November 2006, 21:51
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 3 Times in 3 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, 22:00
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,158
Thanks: 4
Thanked 58 Times in 54 Posts
Default

No backups?
Reply With Quote
  #3  
Old 5th November 2006, 22:02
edge edge is offline
Moderator
 
Join Date: Dec 2005
Location: The Netherlands
Posts: 2,044
Thanks: 269
Thanked 154 Times in 133 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, 22:11
fbnewtz fbnewtz is offline
Member
 
Join Date: Apr 2006
Location: Houston
Posts: 43
Thanks: 1
Thanked 3 Times in 3 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, 15:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 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 12:38
Unbearably slow access speeds CombatGod Installation/Configuration 5 30th May 2006 17:31
Can't receive mail burtathis Installation/Configuration 18 23rd March 2006 18:23
When attempting to login using https, I get a bad or corrupted certificate error drtrembath Installation/Configuration 1 9th March 2006 20:22
I made a bad choice during install, how do i change it? kidtriton Installation/Configuration 2 27th January 2006 17:55


All times are GMT +2. The time now is 17:25.


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