Hi everyone, i tried to install ISPConfig. Durring the installation process an error occured and after rebooting the server ISPCOnfig did not start automatically. Therefore i started the server manual: Code: linux:/etc/init.d # /etc/init.d/ispconfig_server restart Shutting down ISPConfig system... /root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running ISPConfig system stopped! Starting ISPConfig system... Apache/1.3.33 mod_ssl/2.8.23 (Pass Phrase Dialog) Some of your private key files are encrypted for security reasons. In order to read them you have to provide us with the pass phrases. Server 192.168.0.61:81 (RSA) Enter pass phrase: Ok: Pass Phrase Dialog successful. /root/ispconfig/httpd/bin/apachectl startssl: httpd started Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47 No results found!ISPConfig system is now up and running! linux:/etc/init.d # netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:filenet-tms *:* LISTEN - tcp 0 0 *:nfs *:* LISTEN - tcp 0 0 *:sanity *:* LISTEN 5990/rpc.rquotad tcp 0 0 localhost:10024 *:* LISTEN 5936/amavisd (maste tcp 0 0 *:5801 *:* LISTEN 5985/xinetd tcp 0 0 localhost:10025 *:* LISTEN 5772/master tcp 0 0 *:mysql *:* LISTEN 5590/mysqld tcp 0 0 *:5901 *:* LISTEN 5985/xinetd tcp 0 0 *:sunrpc *:* LISTEN 5127/portmap tcp 0 0 *:ndmp *:* LISTEN 5468/perl tcp 0 0 *:hosts2-ns *:* LISTEN 6113/ispconfig_http tcp 0 0 *:883 *:* LISTEN 5797/rpc.mountd tcp 0 0 *:ftp *:* LISTEN 5677/proftpd: (acce tcp 0 0 localhost:smtp *:* LISTEN 5772/master tcp 0 0 *:imaps *:* LISTEN 5476/couriertcpd tcp 0 0 *:pop3s *:* LISTEN 5632/couriertcpd tcp 0 0 localhost:10025 *:* LISTEN 5772/master tcp 0 0 *:pop3 *:* LISTEN 5614/couriertcpd tcp 0 0 *:www-http *:* LISTEN 5935/httpd2-prefork tcp 0 0 *:ssh *:* LISTEN 5800/sshd tcp 0 0 localhost:smtp *:* LISTEN 5772/master Uninstall was not able: Code: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47 No results found!linux:~/ispconfig # linux:~/ispconfig # what shoud i do now? Cheers PM
To uninstall ispconfig: Code: rm -rf /home/admispconfig rm -rf /root/ispconfig When you reinstall it, do not encrypt your SSL-Certificates, otherwise ISPConfig cant start automatically when your server boots! Please read the installation manual too.
Installation manual: http://www.ispconfig.org/manual_installation.htm Seems as if your ISPConfig MySQL database does not exist. Do what Till said before and re-install ISPConfig.
Problem Sorted! I had a similar problem and I found out the tables hadn't been loaded on mysql. What I did was manually upload the tables to the server as shown in db_ispconfig.sql and everything works fine with no long waiting removing and restarting and with ssl up and running. I hope this was of help.
That is not a good idea. If you load the SQL dump manually, all the settings from the installation process where missing and you wont be able to save your server settings. I guess you created the mysql database manually before you run the ISPConfig installer? The installation process will fail if the database already exists tht you enter in the ISPonfig installer.
