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 October 2011, 15:32
mistr_e mistr_e is offline
Junior Member
 
Join Date: Oct 2011
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default accounts can't login since resetting my MySQL root password

I am running ISPConfig 3 under CentOS and I had to manually reset my MySQL root account password yesterday. Since resetting the password I haven't been able to login to ISPConfig's web interface with any account including my admin one.

If I try to login with username: admin and my password I get Error Username or Password wrong.

I reset my MySQL root password.

Code:
mysqladmin -u root -p'oldpass' password 'roottest'
I logged into MySQL and reset admin password to test.

Code:
mysql -u root -p'roottest'
mysql> use dbispconfig;
mysql> database changed
mysql> update sys_user set passwort = md5('admintest') WHERE username = 'admin';
Query OK, 1 row affected (0.07 sec)
Rows matched: 1  Changed: 1  Warnings: 0
I changed my mysql_clientdb.conf to the new password.

Code:
vi /usr/local/ispconfig/server/lib/mysql_clientdb.conf
<?php
$clientdb_host                  = 'localhost';
$clientdb_user                  = 'root';
$clientdb_password              = 'roottest';
?>
I couldn't find a way to restart ISPConfig 3 after these changes, or if it's even possible.

The same error from the ISPConfig login page still shows up when trying to login with u: admin p: admintest.


Help me ISPConfig community, you're my only hope.
Reply With Quote
Sponsored Links
  #2  
Old 24th October 2011, 16:58
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,416
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
Default

The mysql root password is not used for user authentication in the ispconfig interface. ISPConfig connects to mysql with the user "ispconfig" and not root. The root user is only used to create new client databases. Have you changed the password of the ispconfig mysql user too?

Quote:
I couldn't find a way to restart ISPConfig 3 after these changes, or if it's even possible.
ispconfig is no daemon, so it has not to be restarted.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 24th October 2011, 17:10
mistr_e mistr_e is offline
Junior Member
 
Join Date: Oct 2011
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Quote:
The mysql root password is not used for user authentication in the ispconfig interface. ISPConfig connects to mysql with the user "ispconfig" and not root. The root user is only used to create new client databases. Have you changed the password of the ispconfig mysql user too?
I'm pretty sure I may have at some point.
Should I change the ispconfig mysql password using
Code:
 update user set Password=PASSWORD('mynewpassword') WHERE User='ispconfig';
Do I need to update an ISPConfig file somewhere when I do?

Last edited by mistr_e; 24th October 2011 at 17:27.
Reply With Quote
  #4  
Old 24th October 2011, 17:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,416
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
Default

Quote:
Should I change the ispconfig mysql password using
Code:
update user set Password=PASSWORD('mynewpassword') WHERE User='ispconfig';
Do I need to update an ISPConfig file somewhere when I do?
Thats the wrong way.

You should set back the password in mysql to the old value as it is stored in many files. You find the original password in the file /usr/local/ispconfig/interface/lib/config.inc.php
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 24th October 2011, 17:42
mistr_e mistr_e is offline
Junior Member
 
Join Date: Oct 2011
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default

OHHH, are you saying that long encrypted looking password on the line
Code:
$config['db_password']='LONGPASSWORDSTRING';
isn't an encrypted password? That it is the plain text password that should set for the ispconfig user?

So should I update the mysql ispconfig user with this?
Code:
 update user set Password=PASSWORD('LONGPASSWORDSTRING') WHERE User='ispconfig';
Reply With Quote
  #6  
Old 24th October 2011, 18:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,416
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
Default

Quote:
That it is the plain text password that should set for the ispconfig user?
Thats the plaintext password.
__________________
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:
mistr_e (24th October 2011)
  #7  
Old 24th October 2011, 17:35
mistr_e mistr_e is offline
Junior Member
 
Join Date: Oct 2011
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default

SOLVED

I updated the MySQL ispconfig user password by connecting to mysql and running the sql to change the password.

Code:
mysql -u root mysql
mysql> update sys_user set passwort = md5('isptest') WHERE username = 'ispconfig';
Then I typed the same password into an MD5 generator http://www.iwebtool.com/md5.

I pasted that MD5 password into my config.inc.php file.
Code:
vi /usr/local/ispconfig/server/lib/config.inc.php
$conf['db_password'] = 'PASTEDMD5PASSWORD';
I can now login to ispconfig.
Thank you for your help.
Reply With Quote
Reply

Bookmarks

Tags
centos, ispconfig, mysql, password, root

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
Webmail jacksmerv Installation/Configuration 13 12th January 2011 14:03
Perfect Server Ubuntu 9.10 ISPConfig2 AppArmor Issue dwtj01 HOWTO-Related Questions 9 18th November 2009 13:47
Postfix email server problems Access denied 554 554 5.7.1 state 14 AceRimmer Server Operation 4 19th June 2008 14:36
Apache2 Freezes celtic Server Operation 31 28th May 2007 17:18
cannot connect to ispconfig guidovanh Installation/Configuration 22 3rd March 2006 19:52


All times are GMT +2. The time now is 16:07.


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