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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 13th August 2006, 19:13
bruma bruma is offline
Member
 
Join Date: Aug 2006
Location: Slovenia
Posts: 33
Thanks: 4
Thanked 0 Times in 0 Posts
Send a message via ICQ to bruma
Default Could not connect to MySQL server!

Hi!

I've changed mysql server passwd (in shell). Then I change/adopt passwd in /home/admispconfig/ispconfig/lib/config.inc.php. But now when I restart ispconfig, I get error:
Quote:
root@madcow:/home/admispconfig# /etc/init.d/ispconfig_server restart
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd stopped
ISPConfig system stopped!
Starting ISPConfig system...
/root/ispconfig/httpd/bin/apachectl startssl: httpd started
Could not connect to MySQL server!ISPConfig system is now up and running!
What is wrong? Is there another file that should be updated?
I could normaliy login in mysql ($mysql -u root -p), my mysql passwd cointains just alphanumeric characters.
Reply With Quote
Sponsored Links
  #2  
Old 13th August 2006, 20:40
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,145
Thanks: 4
Thanked 55 Times in 51 Posts
Default

When you change the mysql password you need to either flush the privileges or restart the mysql server... the same goes if you alter the privileges altogether
Reply With Quote
  #3  
Old 13th August 2006, 21:36
bruma bruma is offline
Member
 
Join Date: Aug 2006
Location: Slovenia
Posts: 33
Thanks: 4
Thanked 0 Times in 0 Posts
Send a message via ICQ to bruma
Default

Yes, I did flush privileges and also restart mysql server.

I'm using ISPConfig 2.2.6. Will reinstall fix that problem? I don't want to lose current configuration and data.

Last edited by bruma; 13th August 2006 at 21:39.
Reply With Quote
  #4  
Old 14th August 2006, 17:55
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Please check your MySQL password in config.inc.php for typos.
Can you connect on the shell with
Code:
mysql -u root -p
using the same password?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 15th August 2006, 11:20
bruma bruma is offline
Member
 
Join Date: Aug 2006
Location: Slovenia
Posts: 33
Thanks: 4
Thanked 0 Times in 0 Posts
Send a message via ICQ to bruma
Default

Yes, passwd is exactly the same, I also double check for typos in config.inc.php.
Reply With Quote
  #6  
Old 15th August 2006, 11:40
sjau sjau is offline
Local Meanie
 
Join Date: Apr 2006
Location: Switzerland
Posts: 1,145
Thanks: 4
Thanked 55 Times in 51 Posts
Default

can you test this script and tell me the output?

Code:
<?

//Global variables:
$username = ""; // Username for database here
$password = ""; // Password for database here
$db_host = "localhost"; // DB Server
$db_name =  ""; //name of your database here

// Connect to DB
mysql_connect("$db_host","$username","$password")
	or die("Unable to connect to SQL server!");
mysql_select_db("$db_name")
	or die("Unable to select database!");

echo "Connection established to $db_name";

?>
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
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
php Apps email not going through palkat General 8 21st September 2011 05:35
Statistic not working mzo Installation/Configuration 49 20th April 2011 12:19
Email - Ueb-Miau mazhar Installation/Configuration 5 21st December 2005 10:01
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 02:30


All times are GMT +2. The time now is 17:25.


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