ISPConfig installation - ERROR: MySQL is not running!

[sulphur9]

Hello Everyone!
I am trying to install ISPConfig as a part of The Perfect Server - Fedora 9 tutorial (Falko, thank you so much for this tutorial!!!). However, I am getting "ERROR: MySQL is not running!" while running setup for ispconfig.
mysql has been installed and started:
netstat -tap | grep mysql
tcp 0 0 *:mysql *:* LISTEN 8260/mysqld

SELINUX is disabled:
cat /etc/selinux/config | grep disabled
# disabled - SELinux is fully disabled.
SELINUX=disabled

I have to say I noticed two problems:
1. system become slow after last reboot (after I disabled selinux) - it takes about 30min.!!! to log me in and few min for some commands to get me response.
2. I am not able to start named service correctly due to misconfiguration I have created before I discovered HowTos.

I was able however successfully start mysqld by following tutorial.
Is anyone could please help me here?

thank you in advance!

[falko]

Are there any errors in your logs?

[sulphur9]

Hey Falko.

well... I don't see anything horrible in mysql log:
tail -50
081124 14:02:33 InnoDB: Starting shutdown...
081124 14:02:33 InnoDB: Shutdown completed; log sequence number 0 43655
081124 14:02:33 [Note] /usr/libexec/mysqld: Shutdown complete

081124 14:02:33 mysqld ended

081124 14:02:34 mysqld started
081124 14:06:42 InnoDB: Started; log sequence number 0 43655
081124 14:06:42 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.51a' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution


here is tail -50 of ispconfig log:

Config setup again.
Mon Nov 24 13:50:19 PST 2008 - [ISPConfig] - installation directory: /tmp/install_ispconfig
Mon Nov 24 13:50:19 PST 2008 - [ISPConfig] - operating system: Fedora 9.0
Mon Nov 24 13:50:22 PST 2008 - [ISPConfig] - Neuinstallation eines ISPConfig-Systems. / Installation of a new ISPConfig system. / Installation d'ISPConfig sur un nouveau syst�me.
Mon Nov 24 13:50:27 PST 2008 - [ISPConfig] - selected language: en
Mon Nov 24 13:50:29 PST 2008 - [ISPConfig] - installation note accepted
Mon Nov 24 13:50:31 PST 2008 - [ISPConfig] - licence accepted
Mon Nov 24 13:50:34 PST 2008 - [ISPConfig] - installation mode: expert
Mon Nov 24 13:50:38 PST 2008 - [ISPConfig] - mail: postfix
Mon Nov 24 13:50:38 PST 2008 - [ISPConfig] - dist_mail=postfix ##
Mon Nov 24 13:50:52 PST 2008 - [ISPConfig] - dist_mail_log=/var/log/maillog ##
Mon Nov 24 14:01:42 PST 2008 - [ISPConfig] - dist_mail_virtusertable=/etc/postfix/virtusertable ##
Mon Nov 24 14:01:49 PST 2008 - [ISPConfig] - dist_mail_local_host_names=/etc/postfix/local-host-names ##
Mon Nov 24 14:01:53 PST 2008 - [ISPConfig] - ftp: proftpd
Mon Nov 24 14:01:53 PST 2008 - [ISPConfig] - dist_ftp=proftpd ##
Mon Nov 24 14:01:58 PST 2008 - [ISPConfig] - dist_ftp_conf=/etc/proftpd.conf ##
Mon Nov 24 14:02:08 PST 2008 - [ISPConfig] - dist_ftp_version=standalone ##
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - dist_ftp_log=/var/log/xferlog ##
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - procmail found: /usr/bin/procmail
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - quota found: /usr/bin/quota
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - mysql found: /usr/bin/mysql
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - openssl found: /usr/bin/openssl
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - named found: /usr/sbin/named
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - iptables found: /sbin/iptables
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - httpd found: /usr/sbin/httpd
Mon Nov 24 14:02:12 PST 2008 - [ISPConfig] - httpd syntax ok!
Mon Nov 24 14:02:33 PST 2008 - [ISPConfig] - dist_path_httpd_root=/var/www ##
Mon Nov 24 14:02:33 PST 2008 - [ISPConfig] - gcc found: /usr/bin/gcc
Mon Nov 24 14:02:33 PST 2008 - [ISPConfig] - make found: /usr/bin/make
Mon Nov 24 14:02:33 PST 2008 - [ISPConfig] - flex found: /usr/bin/lex
Mon Nov 24 14:02:33 PST 2008 - [ISPConfig] - g++ found: /usr/bin/g++
Mon Nov 24 14:03:34 PST 2008 - [ISPConfig] - ERROR: MySQL is not running! Please start your MySQL database and run the ISPConfig setup again.

I don't see anything being wrong, do you? ...except mysql...
any other log you want me to look inside to?

thank you

[falko]

What's the output of netstat -tap?
Can you connect to MySQL using
mysql -u root -p?

[sulphur9]

Hey Falko,
I can see mysql running. please see below.

thank you.

netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:mysql *:* LISTEN 8260/mysqld
tcp 0 0 *:sunrpc *:* LISTEN 1984/rpcbind
tcp 0 0 192.168.122.1:domain *:* LISTEN 2985/dnsmasq
tcp 0 0 *:ssh *:* LISTEN 2405/sshd
tcp 0 0 localhost.localdomain:ipp *:* LISTEN 2881/cupsd
tcp 0 0 *:smtp *:* LISTEN 2793/master
tcp 0 0 *:53788 *:* LISTEN 2003/rpc.statd
tcp 0 0 192.168.2.2:41866 adfarm.mediaplex.com:http TIME_WAIT -
tcp 0 0 192.168.2.2:45101 www.howtoforge.com:http TIME_WAIT -
tcp 0 0 192.168.2.2:45105 www.howtoforge.com:http TIME_WAIT -
tcp 0 0 192.168.2.2:45104 www.howtoforge.com:http TIME_WAIT -
tcp 0 0 192.168.2.2:45531 cs114.msg.mud.yahoo.co:mmcc ESTABLISHED 4751/pidgin
tcp 0 0 192.168.2.2:52149 208.50.79.18:http ESTABLISHED 4805/firefox
tcp 1 0 192.168.2.2:58939 209.62.186.9:http CLOSE_WAIT 4805/firefox
tcp 0 0 192.168.2.2:58118 74.201.118.105:http TIME_WAIT -
tcp 0 0 192.168.2.2:39589 cf-in-f83.google.com:http ESTABLISHED 4805/firefox
tcp 0 0 192.168.2.2:55002 208.50.79.19:http ESTABLISHED -
tcp 0 0 192.168.2.2:55000 208.50.79.19:http ESTABLISHED -
tcp 0 0 192.168.2.2:45123 www.howtoforge.com:http TIME_WAIT -
tcp 0 0 192.168.2.2:39248 205.188.7.229:aol ESTABLISHED 4751/pidgin
tcp 0 0 *:imaps *:* LISTEN 2729/dovecot
tcp 0 0 *:pop3s *:* LISTEN 2729/dovecot
tcp 0 0 *:pop3 *:* LISTEN 2729/dovecot
tcp 0 0 *:imap *:* LISTEN 2729/dovecot
tcp 0 0 *:http *:* LISTEN 2811/httpd
tcp 0 0 *:ftp *:* LISTEN 2803/proftpd: (acce
tcp 0 0 *:ssh *:* LISTEN 2405/sshd
tcp 0 0 *:smtp *:* LISTEN 2793/master
tcp 0 0 *:https *:* LISTEN 2811/httpd


&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

[falko]

Looks good.

When exactly do you get the error message? Right at the beginning of the installation, or more towards the end?


1. system become slow after last reboot (after I disabled selinux) - it takes about 30min.!!! to log me in and few min for some commands to get me response. That sounds strange. If this is still the case, I'd consider a reinstallation.

[sulphur9]

when it starts and checks for all components I think:

.....................
########## lex ##########

/usr/bin/lex
OK

########## g++ ##########

/usr/bin/g++
OK

########## INSTALLATION ##########

ERROR: MySQL is not running! Please start your MySQL database and run the ISPConfig setup again.

[sulphur9]

Hey Falko,
I was trying to dig into installation scripts of ispconfig a little... My understanding that check is done in setup2 in this place:
netstat -ta | grep -i mysql > /dev/null
if [ $? != 0 ]; then
error "$q_mysql_running_check";

I ran this line manually on my machine and got good result:
netstat -ta | grep -i mysql
tcp 0 0 *:mysql *:* LISTEN

however, as i complaint in my first message, my machine became very slow. I don't know why but it takes sometimes several minutes to get a result of some commands. in this particular case it took about 2 min to get a response. could that be an issue? I mean script does not want to wait that long and simply exits with error? is any way to run this installation script with debug flag? is any chance to force installation? or what do you think if i just comment out this place and let script run?

thanks

[falko]

If you system is so slow, I guess a timeout is happening, and that's why the installer thinks that MySQL isn't running. I'd reinstall the system.

[sulphur9]

Hello Falko,
I did what you have suggested - reinstall the whole os. I think my system was misconfigured, but I could not find out what exactly i have set wrong. I am installing linux myself for the first time and I am not pro in network configuration.
what I am trying to achieve is to configure my linux box so it could be a server running all the services and accessible internally. I don't need it to be a public server, so my understanding that I can assign ip address to my box and as soon it used internally it will be ok and I should not have any DNS issues. Am I correct?
so I ran tutorial from the scratch - now I am having problem with mysql.
I am getting the following:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I have browsed forum and saw your suggestion to another user to see this thread:
http://www.howtoforge.com/forums/archive/index.php/t-2193.html
However it did not bring me any good - I am still having problem with mysql
I am able to connect to it as myself but not as root.

In user table seems to me everything is good for root - it has all the privileges, password... everything. I can see however entries in the table for localhost and domain name, which I have established, with no user for this entries. like below:
| localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 |

all privileges are 'N'. is it how it is suppose to be?
and the same thing for my domain name with no user/password - everything is set to 'N'
I have however:
| localhost | root | 39f4d3470233ff8a | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 |

the same for domain name with user name/password - everything set to 'Y'
I can see the same password stored for root everywhere in the user table...
I am really confused...
can you please suggest me something?
Your tutorial assumes that I have static ip which i can give to my linux box. In my case - I don't have it. isp provider is renewing it, so I cannot exactly follow your recommendations. Seems to me up to the current "mysql" issue I was doing ok. all services are running and my machine is not slow any more. I don't see any errors in logs either.

any help will be greatly appreciated.

Thank you!

[falko]

what I am trying to achieve is to configure my linux box so it could be a server running all the services and accessible internally. I don't need it to be a public server, so my understanding that I can assign ip address to my box and as soon it used internally it will be ok and I should not have any DNS issues. Am I correct?Yes.

so I ran tutorial from the scratch - now I am having problem with mysql.
I am getting the following:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I have browsed forum and saw your suggestion to another user to see this thread:
http://www.howtoforge.com/forums/archive/index.php/t-2193.html
However it did not bring me any good - I am still having problem with mysql
I am able to connect to it as myself but not as root.

In user table seems to me everything is good for root - it has all the privileges, password... everything. I can see however entries in the table for localhost and domain name, which I have established, with no user for this entries. like below:
| localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 |

all privileges are 'N'. is it how it is suppose to be?
and the same thing for my domain name with no user/password - everything is set to 'N'
I have however:
| localhost | root | 39f4d3470233ff8a | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 |

the same for domain name with user name/password - everything set to 'Y'
I can see the same password stored for root everywhere in the user table...
I am really confused...
can you please suggest me something?
It seems as if there's already a root password set. You can try this to reset it: http://www.howtoforge.com/reset-forgotten-mysql-root-password


Your tutorial assumes that I have static ip which i can give to my linux box. In my case - I don't have it. isp provider is renewing it, so I cannot exactly follow your recommendations. Seems to me up to the current "mysql" issue I was doing ok. all services are running and my machine is not slow any more. I don't see any errors in logs either.

Is your server behind a router? Then you can give it a static IP from your LAN.

[sulphur9]

Hello falko,


>> Is your server behind a router?
yes

>> Then you can give it a static IP from your LAN. I am sorry - not sure what did you mean. I assigned an ip address to this box and it did accept it. I have no problem accessing internet. when I am rebooting the box all the services are starting without complaints. I don't see anything wrong in the system log.
the instructions for mysql did not work for me :( . I was receiving error while trying execute commands. I was however able to connect to mysql as myself. so I decided to fix it in different way ( may be it was wrong?)
I connected to mysql as root and updated table user manually. I granted all the privileges like the rest users/hosts had it to 'Y' and set root passwords on this hosts to ' '. after that i restarted mysqld and I got mysqladmin working as in your tutorial, however now I can see this now... is it how it should be?
netstat -tap | grep mysql
tcp 0 0 *:mysql *:* LISTEN 3899/mysqld
tcp 0 0 myhost.mydomain.net:56228 myhost.mydomain.net:mysql TIME_WAIT -


thank you very much in advance.

[sulphur9]

Hello.
after manually fixing user table in mysql I was able to go further with installation. I was able to start ispconfig setup and successfully passed mysql point (thank you!!!!). it turned out however that also flex needs to be installed. so I downloaded and installed it.
now I have a question:
in ispconfig installation I am asked the questions below. for ip address is it my box ip or router's? ( my linux box is running behind the router). I am entering to the next two questions
www
and mydomainname.net

and I am getting:
The URL is not reachable!

Please enter the IP address of the ISPConfig web: E.g. 192.168.0.1
Please enter the host name: E.g. www
Please enter the domain: E.g. xyz.de

Falko, could you please tell me what is it now?
is it expecting url to be already running under apache? but, my understanding setup will destroy everything...
is www means apache's directory? some questions in setup are not so clear...

thank you very much in advance.

[falko]

in ispconfig installation I am asked the questions below. for ip address is it my box ip or router's?It's the IP address of the box.

I am entering to the next two questions
www
and mydomainname.net

and I am getting:
The URL is not reachable!

Please enter the IP address of the ISPConfig web: E.g. 192.168.0.1
Please enter the host name: E.g. www
Please enter the domain: E.g. xyz.de

Falko, could you please tell me what is it now?

You must type in an FQDN that is pointing to your server, ,and it must be pingable. If there's no such FQDN right now, you can make one up and add it to /etc/hosts and create a DNS record for it afterwards.

[sulphur9]

Hey Falko,
I reran setup for ispconfig in the hope to set domain name correctly but this time it did not asked me and just proceeded to the end. I got warnings below. it does not seem to me it is running.
:(


Warning: include(config.inc.php): failed to open stream: No such file or directory in /tmp/install_ispconfig/install.php on line 679

Warning: include(): Failed opening 'config.inc.php' for inclusion (include_path='.:') in /tmp/install_ispconfig/install.php on line 679

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in /tmp/install_ispconfig/install.php on line 706
Could not connect to db
chmod: cannot access `/home/admispconfig/ispconfig/tools/suphp/usr/bin/php-wrapper': No such file or directory
Restarting some services...
./setup2: line 1143: [: ==: unary operator expected
./setup2: line 1161: /etc/rc.d/init.d/ispconfig_server: No such file or directory
Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.

[falko]

What's the output of df -h? I guess you don't have enough free disk space.

[sulphur9]

Hey Falko,
no - I have plenty of space.
after this warnings/errors in ispconfig's setup i rebooted the system and:
got ispconfig administrator login
I was trying to use it by logining in as admin/admin - it never worked
I logged in as myself and now I am not even have local network - I don't have internet connection as I had before.
I don't know what to do at this point... is any config file for ispconfig, so I could fix the settigs manually?

thank you

[sulphur9]

here is the output:
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
145G 4.5G 133G 4% /
/dev/sda1 190M 20M 161M 11% /boot
tmpfs 2.0G 48K 2.0G 1% /dev/shm


thanks

[falko]

Hey Falko,
no - I have plenty of space.
after this warnings/errors in ispconfig's setup i rebooted the system and:
got ispconfig administrator login
I was trying to use it by logining in as admin/admin - it never worked
I logged in as myself and now I am not even have local network - I don't have internet connection as I had before.
I don't know what to do at this point... is any config file for ispconfig, so I could fix the settigs manually?

thank you

That sounds as if your system is really messed up. I'd set it up again.

[sulphur9]

Falko,
my system was ok just before ispconfig installation.

[falko]

I have no idea what's happening. I've never had any problems with the ISPConfig installation. :confused: