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!
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
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 *op3s *:* LISTEN 2729/dovecot tcp 0 0 *op3 *:* 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>
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.
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.
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
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.
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!
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.
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.
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.
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.
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.
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
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