#1  
Old 13th August 2005, 22:24
pontifex pontifex is offline
Member
 
Join Date: Aug 2005
Posts: 78
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 14th August 2005, 08:48
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,413
Thanks: 834
Thanked 5,498 Times in 4,328 Posts
Default

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.
Reply With Quote
  #3  
Old 14th August 2005, 15:08
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,744 Times in 2,577 Posts
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 26th April 2006, 02:37
pasaporte pasaporte is offline
Junior Member
 
Join Date: Apr 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Red face 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.
Reply With Quote
  #5  
Old 26th April 2006, 09:31
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,413
Thanks: 834
Thanked 5,498 Times in 4,328 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql ejs Installation/Configuration 5 12th August 2005 07:01
Error in Instalation (mysql header) juampi Installation/Configuration 2 5th August 2005 22:37
MySQL Privileges mcfly Server Operation 4 26th May 2005 19:00
MYSQL and the perfect setup 9.2 Suse pkfrizzlefry HOWTO-Related Questions 7 21st May 2005 20:12
MySQL support in PHP tobi Installation/Configuration 3 2nd May 2005 22:20


All times are GMT +2. The time now is 09:16.


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