Current time: 11-15-2024, 03:32 AM Hello There, Guest! (LoginRegister)


Post Reply 
ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
Author Message
ooabcoo Offline


Posts: 1
Joined: Oct 2009
Reputation: 0
Post: #1
ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
[root@www setup]# perl ispcp-setup


Welcome to ispCP '1.0.3 OMEGA' Setup Dialog.
This program will set up ispCP OMEGA system on your server.

Next you are asked to enter a "fully qualified hostname" (FQHN).
For more infos read http://en.wikipedia.org/wiki/FQDN.


Please enter a fully qualified hostname. [www.wlxx.net]: http://www.cnc.bz

Please enter system network address. [203.171.229.138]:

Please enter the domain name where ispCP OMEGA will run on [admin.www.cnc.bz]: admin.cnc.bz

Please enter SQL server host. [localhost]:

Please enter system SQL database. [ispcp]:

Please enter system SQL user. [root]:

Please enter system SQL password. [none]:
Please repeat system SQL password:

Please enter ispCP ftp SQL user. [vftp]:

Please enter ispCP ftp SQL user password. [auto generate]:
Please repeat ispCP ftp SQL user password:

Please enter ispCP phpMyAdmin Control user. [pma]:

Please enter ispCP phpMyAdmin Control user password. [auto generate]:
Please repeat ispCP phpMyAdmin Control user password:

Please enter administrator login name. [admin]:

Please enter administrator password:
Please repeat administrator password:

Please enter administrator e-mail address: admin@cnc.bz

IP of Secondary DNS. (optional) []:

Use MySQL Prefix.
Possible values: [i]nfront, [b]ehind, [n]one. [none]:

FastCGI Version: [f]cgid or fast[c]gi. [fcgid]:

Activate AWStats. [no]:

Starting Installation...

ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist

help me,thank
10-02-2009 06:19 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #2
RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
Hi

first (but I think not the problem):
do not use "www.cnc.bz" as the FQDN. I think you want to use the website cnc.bt - so do not use a hostname you want tu use for web/mail etc.

Better name your server eg. server1.cnc.bz (but then also set this correct in the linux - it seems that there is another domain). Then you can use admin.cnc.bz as ispcp-URL and maybe later setup a user for "cnc.bz" (including http://www.cnc.bz for the webpage).


Ok, to your problem: please give us more infors about operating system and exact version you installed (seems to be a trunk).

/J
10-02-2009 08:00 PM
Visit this user's website Find all posts by this user Quote this message in a reply
openzone Offline


Posts: 2
Joined: Oct 2009
Reputation: 0
Post: #3
MyBB RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
same error Sad
10-11-2009 08:53 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #4
RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
joximu Wrote:Ok, to your problem: please give us more infors about operating system and exact version you installed (seems to be a trunk).

!!!
10-11-2009 09:42 PM
Visit this user's website Find all posts by this user Quote this message in a reply
openzone Offline


Posts: 2
Joined: Oct 2009
Reputation: 0
Post: #5
RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
I use centos5.3
Linux openzone.org 2.6.18-164.el5xen #1 SMP Thu Sep 3 04:47:32 EDT 2009 i686 i686 i386 GNU/Linux


Welcome to ispCP '1.0.2 OMEGA' Setup Dialog.
This program will set up ispCP OMEGA system on your server.

Next you are asked to enter a "fully qualified hostname" (FQHN).
For more infos read http://en.wikipedia.org/wiki/FQDN.


Please enter a fully qualified hostname. [openzone.org]: irc.openzone.org

Please enter system network address. [192.168.0.250]:

Please enter the domain name where ispCP OMEGA will run on [admin.irc.openzone.org]:

Please enter SQL server host. [localhost]:

Please enter system SQL database. [ispcp]:

Please enter system SQL user. [root]:

Please enter system SQL password. [none]:
Please repeat system SQL password:

Please enter ispCP ftp SQL user. [vftp]:

Please enter ispCP ftp SQL user password. [auto generate]:
Please repeat ispCP ftp SQL user password:

Please enter ispCP phpMyAdmin Control user. [pma]:

Please enter ispCP phpMyAdmin Control user password. [auto generate]:
Please repeat ispCP phpMyAdmin Control user password:

Please enter administrator login name. [admin]:

Please enter administrator password:
Please repeat administrator password:

Please enter administrator e-mail address: openzone@gmail.com

IP of Secondary DNS. (optional) []:

Use MySQL Prefix.
Possible values: [i]nfront, [b]ehind, [n]one. [none]:

FastCGI Version: [f]cgid or fast[c]gi. [fcgid]:

Activate AWStats. [no]:

Starting Installation...
ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
10-12-2009 03:57 AM
Find all posts by this user Quote this message in a reply
mkreder Offline
Newbie
*

Posts: 8
Joined: Jan 2011
Reputation: 0
Post: #6
RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist
same error with same version of CentOS here, any update?
Here is the solution,

log into your mysql server, and run:

use mysql;

CREATE TABLE `servers` (
`Server_name` char (64) NOT NULL,
`Host` char (64) NOT NULL,
`Db` char (64) NOT NULL,
`Username` char (64) NOT NULL,
`Password` char (64) NOT NULL,
`Port` int (4) DEFAULT NULL,
`Socket` char (64) DEFAULT NULL,
`Wrapper` char (64) NOT NULL,
`Owner` char (64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8 COMMENT = 'MySQL Foreign Servers table';
(This post was last modified: 02-02-2011 12:27 PM by mkreder.)
02-02-2011 12:19 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)