sadly, not so smooth anymore

Feel like I'm abusing the forum here, need help again ! Everything worked, then I changed my password in phpmyadmin and I'm not allowed access anymore... I had this error before, but then I had mistyped (or so I think) during setup. Since then I've reinstalled and things where working, but no that error is back... after typing in username/password (I've tried every combo on the pc/in ISPconfig) it tells this error :

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'root@localhost' (Using password: NO) in /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php on line 76

Below is that file in case it helps !

/home/admispconfig/ispconfig/lib/classes# nano ispconfig_db_mysql.lib.php :

class db_mysql
{
var $dbHost = ""; // hostname of the MySQL server
var $dbName = ""; // logical database name on that server
var $dbUser = ""; // database authorized user
var $dbPass = ""; // user's password
var $linkId = 0; // last result of mysql_connect()
var $queryId = 0; // last result of mysql_query()
var $record = array(); // last record fetched
var $autoCommit = 1; // Autocommit Transactions
var $currentRow; // current row number
var $errorNumber = 0; // last error number
var $errorMessage = ""; // last error message
var $errorLocation = "";// last error location
var $show_error_messages = false;

// constructor
function db_mysql()
{

global $go_info;
$this->dbHost = $go_info["server"]["db_host"];
$this->dbName = $go_info["server"]["db_name"];
$this->dbUser = $go_info["server"]["db_user"];
$this->dbPass = $go_info["server"]["db_password"];
$this->connect();
}

// error handler
function updateError($location)
{
$this->errorNumber = mysql_errno();
$this->errorMessage = mysql_error();
$this->errorLocation = $location;
if($this->errorNumber && $this->show_error_messages)
{
echo('<br /><b>'.$this->errorLocation.'</b><br />'.$this->errorMessage);
flush();
}
}

function connect()
{
if($this->linkId == 0)
{
#mynote:line 76 --> $this->linkId = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);
if(!$this->linkId)
{
$this->updateError('DB::connect()<br />mysql_connect');
return false;
}
}
return true;
}

function query($queryString)
{
if(!$this->connect())
{
return false;
}
if(!mysql_select_db($this->dbName, $this->linkId))
{
$this->updateError('DB::connect()<br />mysql_select_db');
return false;


I removed the rest from here since it was over the 10000 characters limit

 

You have to put your new MySQL password into /home/admispconfig/ispconfig/lib/config.inc.php.

 

Sorry, I just have to get this straight :

ISPconfig login name/password can be different from Mysql ?

Cause Ispconfig login failed after I changed mysql password from blank to a password different than that to login to ISPconfig. Also ISPconfig defaults to user:admin and mysql to user:root , IF I got it right.

Anyway, I tried typing the password into config.inc.php, no success yet..

 

You have a login for the MySQL database, in this case root and a password, and you have a login for ISPConfig, admin and another password, and both logins are totally independent from each other.

You have to put your new MySQL password into the variable $go_info["server"]["db_password"] in /home/admispconfig/ispconfig/lib/config.inc.php. And the password must not contain special characters.

 

Hi again

I have set it like this :

$go_info["server"]["db_password"] = "mypasswordhere";

Can't reach phpmyadmin since I can't get past ISPconfig login.

But since (very glad to learn that) ISPconfig and MySQL password are separate, any idea why ISPconfig password isn't working anymore ?

Is there a file I can edit for this password too ?

 

thanks for the reply !

Please see the first post in this thread for the error message.

I used to be able to login to ISPconfig with admin + password, then I changed my MySQL password in phpmyadmin via the tools menu in ISPconfig, and when I clicked the little green exit button in phpmyadmin to logout, it asked for password for user root, probably since I changed it. I typed the newly added password (was blank before) and it refused saying it was the wrong password. I tried typing a blank password, like before, refused again. I closed the window, tried logging in to ISPconfig again just to see that error as typed in the first post.

 

I followed Falko's advice, and I'm sorry if I didn't made that clear.
By no means am I ignoring your advices

The error was this : MySQL needed to be restarted.

After restarting mysql on the server I could now log into ISPconfig with admin + ISPconfig password. Via phpmyadmin I could log into mysql with root + the new password.

When loging out of mysql, same happens, asks for password for user root, no password helps. I click cancel, get back to ISPconfig screen, all well, can log into phpmyadmin again, same exit problem.

But entering the password in the file mentioned helped !! I can now log in, just not log out "cleanly".

Summary : I did as told Results was delayed because mysql needed restart, but as said, that exit error still occurs. So this was a big leap in the right direction. Appreciated response indeed.

 

You mean from phpMyAdmin? It's normal that it asks for a user and password as soon as you click on "Exit", because at that point of time you're already logged out.

 

Yes from phpmyadmin !

Glad that it's normal, seems like a very good thing that you don't have that "cookie" feeling you can get when loging out of some apps..


To bad it doesn't recognize my password then, anyway, I can log in and do what I want so I guess I should be happy


You have done a great job answering my questions as they have come forth, I get flashbacks to my very first forum post (haven't been too many before ISPconfig) when totally new to linux.... friendly ppl indeed !

Call me emotional but I value these things

Now, it's off to web development !