ispCP - Board - Support
ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist (/thread-8020.html)

ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist - ooabcoo - 10-02-2009 06:19 PM

[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

RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist - joximu - 10-02-2009 08:00 PM

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

RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist - openzone - 10-11-2009 08:53 PM

same error Sad

RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist - joximu - 10-11-2009 09:42 PM

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

!!!

RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist - openzone - 10-12-2009 03:57 AM

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

RE: ERROR: Incorrect SQL Query -> Table 'mysql.servers' doesn't exist - mkreder - 02-02-2011 12:19 PM

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';