PDA

View Full Version : Error in Mysql


pontifex
13th August 2005, 23:24
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:
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:

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

till
14th August 2005, 09:48
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:
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:

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:

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.

falko
14th August 2005, 16:08
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.

pasaporte
26th April 2006, 03:37
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:
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:

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

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.

till
26th April 2006, 10:31
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.