#1  
Old 28th February 2009, 21:19
FransAlmere FransAlmere is offline
Junior Member
 
Join Date: Feb 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default ISPconfig 3.0.0.9 Mysql offline

Dear people,

I do not know what goes wrong.

Try to install ISP on Ubuntu intrepid following the Howto from Falko and a little bit from the onze included with ISP. ISP is online but I do not get mysql working.

I am using a different port 3360.

During the install when ISP ask for MYSQL i kept the default ones and entered the correct password.

After install everything works fine. After logout and than back in monitor under ISPconfig tells me that mysql is offline ??

In the file /usr/local/ispconfi/server/lib/config.inc.php the values of MYSQL are ispconfig (when is this user created ?) and a scrambled password.

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

When I change db_user to root.

Mysql under ispconfig stays offline.

Under phpmyadmin I can see that mysql is working and there I find the user ispconfig again with

ispconfig localhost Yes USAGE No

and for root

root localhost Yes ALL PRIVILEGES Yes

Is I change the rights for user ispconfig here to the same as root also nothing changes and mysql stays offline.

in /usr/local/ispconfig/server/lib/mysql_clientdb.conf

$clientdb_host = 'localhost';
$clientdb_user = 'root';
$clientdb_password = '1234Banj';

So there it is root.

can anyone tell me what I am doing wrong ?
Reply With Quote
Sponsored Links
  #2  
Old 28th February 2009, 23:55
Antennipasi Antennipasi is offline
ISPConfig Developer
 
Join Date: Dec 2008
Location: Finland
Posts: 67
Thanks: 6
Thanked 13 Times in 12 Posts
Default

Quote:
Originally Posted by FransAlmere View Post
After install everything works fine. After logout and than back in monitor under ISPconfig tells me that mysql is offline ??

Under phpmyadmin I can see that mysql is working and there I find the user ispconfig again with
Monitor-module is currently hard-coded to check MySQL from port 3306.
you can change this from file /usr/local/ispconfig/server/mods-available/monitor_core_module.inc.php in line 441:
Code:
if($this->_checkTcp('localhost', 3306))
Reply With Quote
  #3  
Old 1st March 2009, 10:38
FransAlmere FransAlmere is offline
Junior Member
 
Join Date: Feb 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default Thanks

Thanks for the quick answer did indeed the trick.
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
ISPConfig 3.0.0.9 RC2 released till General 51 17th April 2009 18:12
MySQL5 client access to ISPConfig box vs plain centos5 pakogah Installation/Configuration 1 5th August 2008 19:47
ISPconfig after installation cannot reach www.xyz.de:81 Figth4Linux Installation/Configuration 23 6th March 2008 23:38
ISPConfig vs mysql 5 update Dy0nisus Installation/Configuration 9 29th May 2007 12:03
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 16:16


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


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