HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   Error in Mysql (http://www.howtoforge.com/forums/showthread.php?t=251)

pontifex 13th August 2005 22:24

Error in Mysql
 
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

till 14th August 2005 08:48

Quote:

Originally Posted by pontifex
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.

falko 14th August 2005 15: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 02:37

Problem Sorted!
 
Quote:

Originally Posted by pontifex
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

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 09:31

Quote:

Originally Posted by pasaporte
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.


All times are GMT +2. The time now is 23:49.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.