#1  
Old 15th February 2013, 14:34
George7293 George7293 is offline
Junior Member
 
Join Date: Feb 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default ISPConfig 2 - Login Issue

As I am a beginner don't flame me too much, I have never worked with any Linux based machines until very recently so yet I'm learning. I work for a company, I'm mainly specialized in web designing but however, they bought a dedicated server to host their websites. Everything was good but a couple of days ago they asked for a certain site which I implemented MySQL for (for better managment). The guy who had set up the server with the ISPConfig, didn't told me the password for MySQL so I had to change it. I managed to change it but now, I get this error when I try to login at http://mymachineip:81/
(I believe it's called the Administrator Panel). Here's the error that's thrown:

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

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) 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 62
I've read your forums but as I am a beginner, I can't do it myself. I saw that I need to change the password elsewhere also (I've updated the MySQL table named sys_user with the query UPDATE sys_user SET "mypassword" WHERE username = "admin"). It worked but now I can't connect to that panel I used to connect fine. As far as I was concerned from the very beginning of the time that error was thrown, I knew that I had to change the password elsewhere to match the new MySQL pwd I've set through that query.

Now, I ask for your help because I'm really stuck and it's kinda urgent. Where and how I navigate to those other files that I must edit and update the MySQL password. I've saw that a lot of people suggested to navigate trough home/admispconfig/... but I have no idea where I can find this directory or how to edit that file.

Thanks, I appreciate a lot!

(This occured because I needed to install PHPMyAdmin to administrate the databases. PHPMyAdmin works fine, but that Admin Panel doesn't).

Last edited by George7293; 15th February 2013 at 14:36.
Reply With Quote
Sponsored Links
  #2  
Old 15th February 2013, 15:24
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,638
Thanks: 793
Thanked 4,998 Times in 3,909 Posts
Default

You have to set the new mysql root password in the file /home/admispconfig/ispconfig/lib/config.inc.php

There are no changes in the ispconfig mysql database required.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 15th February 2013, 15:37
George7293 George7293 is offline
Junior Member
 
Join Date: Feb 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
You have to set the new mysql root password in the file /home/admispconfig/ispconfig/lib/config.inc.php

There are no changes in the ispconfig mysql database required.
And how do I managed to go to that directory and change that password? I'm using PuTTY to SSH into the machine but I really have no idea how to navigate to that dir and change the pwd. Could you please point me in the right direction?
Reply With Quote
  #4  
Old 20th June 2013, 16:07
rcastro rcastro is offline
Junior Member
 
Join Date: Jun 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Till,
Thank you very much! I, like the orginal poster was handed legacy web server and just recently found it had ISPConfig installed. I was unable to login as no one had the password. After a couple of days of trying, I found this article and eureka, you gave me the answer. I'm now looking at the ISPConfig frontend. Now if I only knew what to do with it...
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
Need help with ISPConfig Mail and Squirrelmail m.xander Installation/Configuration 109 3rd February 2012 00:15
ISPconfig 3: can't send or receive messages zogthegreat Installation/Configuration 6 22nd May 2010 14:45
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 14:31
ISPConfig installation into multiple OpenVZ containers letezo Installation/Configuration 11 3rd March 2009 22:47
IspConfig login trouble scenic2 Installation/Configuration 9 28th January 2009 11:24


All times are GMT +2. The time now is 13:36.


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