HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   where mysql db information in ispconfig3 (http://www.howtoforge.com/forums/showthread.php?t=36030)

netmastan 6th June 2009 10:41

where mysql db information in ispconfig3
 
Hi Guys,

We forgot the root password of mysql datbase. So, we reset the password.
Now, isp config login is not working
Code:

Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 73

can someone tell me why the config.inc.php file is empty? Where ISP config keeps the datbase login and password. Even it tried manually typed password in db_mysql_inc.php file(Changed classes private variable) and change password in the database from phpmyadmin.. it didn't work.

We had debain-maint user login issue but managed to fix it by copying password from /etc/mysql/debian.cnf and put it in the mysql user database.


Regards

till 6th June 2009 10:47

You did not reset the root password, according to the error message you reset the password for the ispconfig user. This wa a very bad idea because this password is used in many config files all over the operating system. Take a look at the files in /etc/postfix, /etc/courier, /etc/pam.d/, /usr/local/ispconfig/server/lib/config.inc.php and /usr/local/ispconfig/interface/lib/config.inc.php

netmastan 8th June 2009 13:39

Thanks for the information. I managed get it fixed by copying the old password from php file and run sql query on the database.

m4l41k4t 27th October 2013 16:13

hi,
I need help.
The problem is I forgot the root password for my mysql ISPConfig.
I check the file:
/ usr / local / ISPConfig / server / lib / config.inc.php and
/ usr / local / ISPConfig / interface / lib / config.inc.php
but password enscript, how can I find out the password?

The following contents :

//** Database
$conf['db_type'] = 'mysql';
$conf['db_host'] = 'localhost';
$conf['db_database'] = 'dbispconfig';
$conf['db_user'] = 'ispconfig';
$conf['db_password'] = '55a1975966384afad53c2bb8f188b9bb';

My system :
OS : CentOS 6.4 64bit
ISPConfig Version : 3.0.5.3


All times are GMT +2. The time now is 15:29.

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