13th August 2005, 23:24
|
|
Member
|
|
Join Date: Aug 2005
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
14th August 2005, 09:48
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 19,805
Thanks: 285
Thanked 1,805 Times in 1,357 Posts
|
|
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.
|
14th August 2005, 16:08
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 31,853
Thanks: 781
Thanked 1,558 Times in 1,477 Posts
|
|
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.
|
26th April 2006, 03:37
|
|
Junior Member
|
|
Join Date: Apr 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|
26th April 2006, 10:31
|
|
Super Moderator
|
|
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 19,805
Thanks: 285
Thanked 1,805 Times in 1,357 Posts
|
|
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.
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT +2. The time now is 03:23.
|
English | 
Deutsch
Recent comments
18 hours 50 min ago
1 day 6 min ago
1 day 17 min ago
1 day 25 min ago
1 day 1 hour ago
1 day 3 hours ago
1 day 6 hours ago
1 day 6 hours ago
1 day 6 hours ago
1 day 7 hours ago