Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 24th August 2012, 23:52
helly88 helly88 is offline
Member
 
Join Date: May 2011
Posts: 35
Thanks: 1
Thanked 0 Times in 0 Posts
Default I've screwed up! Password for admin panel etc

Ok.. Yesterday I changed my root MYSQL password.
Today just before I was going home from work, I decided to create a ned database using ISPconfig. All seemed fine but in phpmyadmin I could see that the DB hadn't been created. Even tough it was created in ISPconfig.

Then I got a couple of calls and I had to go. But I didn't.. I tried a couple of thing first (I messed up)...
I changed the mysql password in the : nano /usr/local/ispconfig/interface/lib/config.inc.php

That did not help.
Then I changed the password of ispconfig in users -> ispconfig db.

All wrong.. I know..

How the ..... do I go about fixing this? I don't want to screw up anything else.

Now I can't login to ISPconfig or my mail. I can login to phpmyadmin and via ssh..
Reply With Quote
Sponsored Links
  #2  
Old 26th August 2012, 20:40
helly88 helly88 is offline
Member
 
Join Date: May 2011
Posts: 35
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Please. Falco? Till? :-) Anybody?

I can't login to ISPconfig or any of my mails.. Getting kind of desperate.
Reply With Quote
  #3  
Old 26th August 2012, 23:45
Monotoba Monotoba is offline
Member
 
Join Date: May 2009
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think you can change it via phpmyadmin using MD5 encryption.... Try the sys_user table.
Reply With Quote
  #4  
Old 27th August 2012, 09:38
helly88 helly88 is offline
Member
 
Join Date: May 2011
Posts: 35
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Monotoba View Post
I think you can change it via phpmyadmin using MD5 encryption.... Try the sys_user table.
Yes, I've changed that password. No luck.
I can't login with any other users either. I think it's because I've changed the password in ISPconfigs config.inc.php file, both server and client.. So I guess ISPconfig (and my mail etc) can't connect to mysql to check if the username / password is correct)

Should this password also be MD5 encrypted?
Reply With Quote
  #5  
Old 27th August 2012, 09:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,083
Thanks: 826
Thanked 5,397 Times in 4,241 Posts
Default

Quote:
I can't login with any other users either. I think it's because I've changed the password in ISPconfigs config.inc.php file, both server and client.. So I guess ISPconfig (and my mail etc) can't connect to mysql to check if the username / password is correct)
Yes,you locked yourself out of the mysql database now. Never change the passwords in that files, they are managed by the ispconfig installer and the same password is used for many other servoces like postfix tc as well, so dont change it. You can find the corrrect password in the mysql*...cf config files in /etc/postfix/ directory. Take the password from one of these files and set it again inb the ispconfig config.inc.php file.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 27th August 2012, 10:20
helly88 helly88 is offline
Member
 
Join Date: May 2011
Posts: 35
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Ok. I've done this.

But I've also changed the password of the ispconfig user in the mysql database (users).
I guess I can't just copy the same passowrd into phpmyadmin? It looks too long..
Reply With Quote
  #7  
Old 27th August 2012, 10:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,083
Thanks: 826
Thanked 5,397 Times in 4,241 Posts
Default

Quote:
I guess I can't just copy the same passowrd into phpmyadmin? It looks too long..
Copy the password into phpmyadmin, then select "Password" as function for the password column before you save the record. mysql will then encode the password correctly.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
helly88 (27th August 2012)
  #8  
Old 27th August 2012, 10:45
helly88 helly88 is offline
Member
 
Join Date: May 2011
Posts: 35
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

haaaaaaaaaaaaaaaaaaaaaalleluuuja!


Thank you so much! I'll never ever try to make a quick edit before leaving work, ever again..
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
strange fail2ban behaviour > doesn't ban specific IP Djamu Server Operation 2 13th January 2012 02:29
MySQL Error Nolan Installation/Configuration 12 16th February 2011 02:15
Can't save username and password to Firefox when logging in ISPconfig panel binaryrogue Installation/Configuration 1 24th May 2010 14:41
Change the Mysql root password while runing the ISP panel gimhan90 Installation/Configuration 1 31st October 2006 09:42
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 22:40


All times are GMT +2. The time now is 02:55.


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