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 27th December 2010, 14:47
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Question installing-a-web-email-and-mysql-database-cluster-on-debian-5.0-with-ispconfig-3

Hi,

I got a litle problem after a flawless installation:

"http://www.howtoforge.com/installing-a-web-email-and-mysql-database-cluster-on-debian-5.0-with-ispconfig-3-p2"

I try to enter the ISPconfig admin interface with http://192.168.250.14:8080
and i got this error in my webbrowser:

.................................................. ..............................................
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 72

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 72
.................................................. ..............................................

i dident get into any trouble under installation at all.
i also try to give 'ispconfig'@'localhost' more priveleges and then restart mysql but it dident work.

-------------
Debian Lenny 5
Latest ISPconfig
-------------

any sugestion?
rgds
Marcus
Reply With Quote
Sponsored Links
  #2  
Old 28th December 2010, 23:06
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 if the database details (password, etc.) are correct in /usr/local/ispconfig/interface/lib/config.inc.php.
__________________
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
  #3  
Old 28th December 2010, 23:12
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Default

This is whar i have inte the file:


------------------------------------------
//** Database
$conf['db_type'] = 'mysql';
$conf['db_host'] = 'localhost';
$conf['db_database'] = 'dbispconfig1';
$conf['db_user'] = 'ispconfig';
$conf['db_password'] = 'xxxxxxxxxxxxxxxxxxxxxx';
$conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-88
59-1" --> "latin1")

define('DB_TYPE',$conf['db_type']);
define('DB_HOST',$conf['db_host']);
define('DB_DATABASE',$conf['db_database']);
define('DB_USER',$conf['db_user']);
define('DB_PASSWORD',$conf['db_password']);
define('DB_CHARSET',$conf['db_charset']);


//** Database settings for the master DB. This setting is only used in multiserver setups
$conf['dbmaster_type'] = 'mysql';
$conf['dbmaster_host'] = '';
$conf['dbmaster_database'] = 'dbispconfig';
$conf['dbmaster_user'] = '';
$conf['dbmaster_password'] = 'xxxxxxxxxxxxxxxxxxxxxxxxx';
-----------------------------------

i have no clue what the ispconfig passwd is.

Last edited by falko; 29th December 2010 at 15:41. Reason: Removed the MySQL password...
Reply With Quote
  #4  
Old 4th January 2011, 09:51
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Default

Any suggestion about this problem, is the syntax correct for my setup ore wrong?
I looking forward to have this setup to work correctly =)

rgds
Marcus
Reply With Quote
  #5  
Old 5th January 2011, 13:36
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

Does connecting to MYSQL on the command line work?
Code:
mysql -u ispconfig -p
Does the MySQL password for the user ispconfig contain any special characters?
__________________
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
  #6  
Old 8th January 2011, 19:40
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Default

Yes yes its works connection but i dont got the passwd for ispconfig user.
but i can change it, but i dont know if i destroy some other things if i change, am i?

rgds
Marcus
Reply With Quote
  #7  
Old 9th January 2011, 20:02
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

You can change the password, but keep in mind that you have to add the new password in /usr/local/ispconfig/interface/lib/config.inc.php as well.
__________________
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
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
Version 1.3 of the ISPConfig 3 Manual is finally available! falko General 44 2nd December 2011 12:04
Multiserver Setup With Dedicated Web, Email, DNS And MySQL Database Servers On Debian jmh_fl HOWTO-Related Questions 3 25th September 2010 14:48
how does cluster on Debian with ISPConfig 3 work? mcarollo HOWTO-Related Questions 4 16th September 2010 17:03
ffmpeg Video support for ubuntu 7.10 [suphp-ispconfig] amaurib Installation/Configuration 13 16th February 2010 17:26
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16


All times are GMT +2. The time now is 09:57.


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