ISPConfig installation - ERROR: MySQL is not running!

Discussion in 'Installation/Configuration' started by sulphur9, Nov 25, 2008.

  1. sulphur9

    sulphur9 New Member

    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!
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Are there any errors in your logs?
     
  3. sulphur9

    sulphur9 New Member

    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
     
  4. falko

    falko Super Moderator ISPConfig Developer

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

    sulphur9 New Member

    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>
     
  6. falko

    falko Super Moderator ISPConfig Developer

    Looks good.

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

    That sounds strange. If this is still the case, I'd consider a reinstallation.
     
  7. sulphur9

    sulphur9 New Member

    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.
     
  8. sulphur9

    sulphur9 New Member

    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
     
  9. falko

    falko Super Moderator ISPConfig Developer

    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.
     
  10. sulphur9

    sulphur9 New Member

    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!
     
  11. falko

    falko Super Moderator ISPConfig Developer

    Yes.

    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


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

    sulphur9 New Member

    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.
     
    Last edited: Dec 8, 2008
  13. sulphur9

    sulphur9 New Member

    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.
     
  14. falko

    falko Super Moderator ISPConfig Developer

    It's the IP address of the box.

    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.
     
  15. sulphur9

    sulphur9 New Member

    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.
     
  16. falko

    falko Super Moderator ISPConfig Developer

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

    sulphur9 New Member

    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
     
  18. sulphur9

    sulphur9 New Member

    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
     
  19. falko

    falko Super Moderator ISPConfig Developer

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

    sulphur9 New Member

    Falko,
    my system was ok just before ispconfig installation.
     

Share This Page