HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   ISPconfig 3.0.0.9 Mysql offline (http://www.howtoforge.com/forums/showthread.php?t=31921)

FransAlmere 28th February 2009 20:19

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 ?

Antennipasi 28th February 2009 22:55

Quote:

Originally Posted by FransAlmere (Post 172481)
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))

FransAlmere 1st March 2009 09:38

Thanks
 
Thanks for the quick answer did indeed the trick.


All times are GMT +2. The time now is 05:38.

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