forum : You have an error in your SQL systax

You must be logged in to post Login Register

You have an error in your SQL systax

UserPost

11:49 am
February 4, 2010


burgo.mark

New Member

posts 1

1

Just configured two host and began getting these errors.  Log as follows…


Nothing gets updated to the system at this point


 cd /var/www/kontrollbase/bin/ && /var/www/kontrollbase/bin/kontroll-reporter-5.0.x_linux-x86-2.0.1.pl
Useless use of private variable in void context at /var/www/kontrollbase/bin/kontroll-reporter-5.0.x_linux-x86-2.0.1.pl line 138.     
Useless use of private variable in void context at /var/www/kontrollbase/bin/kontroll-reporter-5.0.x_linux-x86-2.0.1.pl line 138.     
2010-02-04 14:11:36 | DEBUG | reporter-5.0.x_linux-x86: #### reporter process start                                                   
2010-02-04 14:11:36 | DEBUG | reporter-5.0.x_linux-x86: working on Mark Burgo,12, burgo-755                                           

Argument “Host: burgo-755 User:root,Host: 127.0.0.1 User:root,” isn't numeric in numeric eq (==) at /var/www/kontrollbase/bin/kontroll-reporter-5.0.x_linux-x86-2.0.1.pl line 1931.                                                                                                                                                               
2010-02-04 14:11:38 | DEBUG | reporter-5.0.x_linux-x86: truncating tmp/kontrollbase-reporter-2010-02-04141136.log                                                        
######################ENTERED report                                                                                                                                     
2010-02-04 14:11:38 | DEBUG | reporter-5.0.x_linux-x86: working on Mark Burgo,13, mysql1                                                                                 

2010-02-04 14:11:38 | DEBUG | reporter-5.0.x_linux-x86: #### reporter process end
kontrollbase@burgo-755:/var/www/kontrollbase/bin$ cd /var/www/kontrollbase/bin/ && /var/www/kontrollbase/bin/kontroll-server_loop-5.0.x_linux-x86-2.0.1.pl
2010-02-04 14:13:21 | DEBUG | server-loop-5.0.x_linux-x86: LOG TRUNCATED                                                                                  
2010-02-04 14:13:21 | DEBUG | server-loop-5.0.x_linux-x86: #### server-loop process start                                                                 

EXEC kontroll-client-5.0.x_linux-x86-2.0.1.pl client script for host: burgo-755 kontrollbase@127.0.0.1
EXEC stats gather script for host: burgo-755 kontrollbase@127.0.0.1 active: 1
2010-02-04 14:13:22 | DEBUG | stats-gather-5.0.x_linux-x86: ## process start
2010-02-04 14:13:22 | DEBUG | stats-gather-5.0.x_linux-x86: burgo-755 [starting]
2010-02-04 14:13:22 | DEBUG | stats-gather-5.0.x_linux-x86: burgo-755 xml datetime = 2010-02-04 14:13:22
2010-02-04 14:13:23 | DEBUG | stats-gather-5.0.x_linux-x86: burgo-755 queries/sec=0.0151061077598904
2010-02-04 14:13:23 | DEBUG | stats-gather-5.0.x_linux-x86: total ram='4021026816'
2010-02-04 14:13:23 | DEBUG | stats-gather-5.0.x_linux-x86: burgo-755 Collection time: 0.063227 seconds
2010-02-04 14:13:23 | DEBUG | stats-gather-5.0.x_linux-x86: burgo-755 [success]
2010-02-04 14:13:23 | ERROR | stats-gather-5.0.x_linux-x86: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.0.1.xml,
'#\n# The MySQL database server configuration file.\n#\n# You can copy' at line 503
2010-02-04 14:13:23 | DEBUG | stats-gather-5.0.x_linux-x86: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.0.1.xml,
'#\n# The MySQL database server configuration file.\n#\n# You can copy' at line 503

EXEC kontroll-client-5.0.x_linux-x86-2.0.1.pl client script for host: mysql1 kontrollbase@10.98.2.147
EXEC stats gather script for host: mysql1 kontrollbase@10.98.2.147 active: 1
2010-02-04 14:13:26 | DEBUG | stats-gather-5.0.x_linux-x86: ## process start
2010-02-04 14:13:26 | DEBUG | stats-gather-5.0.x_linux-x86: mysql1 [starting]
2010-02-04 14:13:26 | DEBUG | stats-gather-5.0.x_linux-x86: mysql1 xml datetime = 2010-02-04 14:13:24
2010-02-04 14:13:28 | DEBUG | stats-gather-5.0.x_linux-x86: mysql1 queries/sec=288.01863368317
2010-02-04 14:13:28 | DEBUG | stats-gather-5.0.x_linux-x86: total ram='4154224640'
2010-02-04 14:13:28 | DEBUG | stats-gather-5.0.x_linux-x86: mysql1 Collection time: 2.133478 seconds
2010-02-04 14:13:28 | DEBUG | stats-gather-5.0.x_linux-x86: mysql1 [success]
2010-02-04 14:13:28 | ERROR | stats-gather-5.0.x_linux-x86: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2.147.xml,
'#\n# The MySQL database server configuration file.\n#\n# You can co' at line 503
2010-02-04 14:13:28 | DEBUG | stats-gather-5.0.x_linux-x86: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2.147.xml,
'#\n# The MySQL database server configuration file.\n#\n# You can co' at line 503
2010-02-04 14:13:28 | DEBUG | server-loop-5.0.x_linux-x86: #### server-loop process end

Any ideas  these are mysql 5.1 servers  Just localhost was working until I added the second host…..

11:59 am
February 4, 2010


themattreid

Admin

Nevada

posts 48

2

You cannot use spaces in the hostnames, client names, or usernames when setting up a host in Kontrollbase. Remove the space on your host settings and try again. 


http://kontrollsoft.com http://themattreid.com

12:30 pm
February 4, 2010


themattreid

Admin

Nevada

posts 48

3

For reference, this has been fixed in revision 284 – new vtypes have been added to the forms on all add and edit view pages so that you cannot put spaces in places where no spaces are allowed. in addition new vtypes have been added to control IP address fields, port fields, password, and hostname fields.

http://kontrollsoft.com http://themattreid.com

 

About the kontrollsoft forum

Most Users Ever Online:

9


Currently Online:

1 Guest

Forum Stats:

Groups: 3

Forums: 12

Topics: 33

Posts: 79

Membership:

There are 425 Members

There has been 1 Guest

There is 1 Admin

There are 0 Moderators

Top Posters:

xstar – 16

Prabhat – 3

christian.keil – 2

massoo – 2

j2ict – 2

chaq – 1

Administrators: themattreid (48 Posts)