Hah, good catch, I didn't see that!

That'll be preventing that query, which shouldn't affect much.

His greater problem is... Greater. :)

Let me go fix that query...

Adam.

Sent with AquaMail for Android
http://www.aqua-mail.com

On 13 May 2015 10:43:29 Bruce Guthrie <Bruce@ictsecurity.com.au> wrote:

Hi,

 

The missing “`” after entPhysicalIndex might have something to do with it?

 

Regards,

 

Bruce

 

From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong
Sent: Wednesday, 13 May 2015 19:13
To: Observium Network Observation System
Subject: Re: [Observium] new obs server

 

You seem to have broken something pretty badly for WHERE statements to dislike having AND conditions so badly.

Install again on a clean Linux system following the install guide exactly, doing nothing not included in the install guide.

No special mysql packages, no rrdcached.

Adam.

Sent with AquaMail for Android
http://www.aqua-mail.com

On 13 May 2015 06:31:29 "Jeffrey d'Ambly" <jeffrey.dambly@jasper.com> wrote:

I just installed a new obs server using the professional edition. For some reason all my graphs are empty. I think this maybe due to rrdcached, but I have no idea why. Also when I run the poller in debug mode I saw some SQL errors? Is this something I should be concerned about?

 

Also found this in /var/log/messages

 

May 12 22:23:17 sjc-corp-net01 rrdcached[2470]: queue_thread_main: rrd_update_r (/opt/observium/rrd/nj-wan01/port-13.rrd) failed with status -1. (/opt/observium/rrd/nj-wan01/port-13.rrd: not a simple signed integer: '1.844674407371E+19')

May 12 22:25:03 sjc-corp-net01 rrdcached[2470]: queue_thread_main: rrd_update_r (/opt/observium/rrd/nj-wan01/port-13.rrd) failed with status -1. (/opt/observium/rrd/nj-wan01/port-13.rrd: not a simple signed integer: '1.844674407371E+19')

May 12 22:30:27 sjc-corp-net01 rrdcached[2470]: queue_thread_main: rrd_update_r (/opt/observium/rrd/nj-wan01/port-13.rrd) failed with status -1. (/opt/observium/rrd/nj-wan01/port-13.rrd: not a simple signed integer: '1.844674407371E+19')

 

 

SQL[SELECT * FROM `cef_switching` WHERE `device_id` = '63' AND `entPhysicalIndex = '7051' AND `afi` = 'ipv4' AND `cef_index` = '1']

RUNTIME[0.00008607s]

ERROR[Error in query: (1064) 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 'afi` = 'ipv4' AND `cef_index` = '1'' at line 1]

RRD /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv4-1.rrd already exists - no need to create.

 

SQL[UPDATE `cef_switching` set `drop` ='0',`punt` ='0',`punt2host` ='0',`drop_prev` ='',`punt_prev` ='',`punt2host_prev` ='',`updated` ='1431494692',`updated_prev` ='' WHERE `device_id` = '63' AND `entPhysicalIndex` = '7051' AND `afi` = 'ipv4' AND `cef_index` = '1']

RUNTIME[0.00063586s]

RRD[cmd[update /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv4-1.rrd N:0:0:0 --daemon unix:/var/rrdtool/rrdcached/rrdcached.sock

stdout[OK u:0.00 s:0.02 r:56.10

stderr[]]

 

 | |-2: RP LES

SQL[SELECT * FROM `cef_switching` WHERE `device_id` = '63' AND `entPhysicalIndex = '7051' AND `afi` = 'ipv4' AND `cef_index` = '2']

RUNTIME[0.00007796s]

ERROR[Error in query: (1064) 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 'afi` = 'ipv4' AND `cef_index` = '2'' at line 1]

RRD /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv4-2.rrd already exists - no need to create.

 

SQL[UPDATE `cef_switching` set `drop` ='0',`punt` ='395367',`punt2host` ='1150',`drop_prev` ='',`punt_prev` ='',`punt2host_prev` ='',`updated` ='1431494692',`updated_prev` ='' WHERE `device_id` = '63' AND `entPhysicalIndex` = '7051' AND `afi` = 'ipv4' AND `cef_index` = '2']

RUNTIME[0.00068498s]

RRD[cmd[update /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv4-2.rrd N:0:395367:1150 --daemon unix:/var/rrdtool/rrdcached/rrdcached.sock

stdout[OK u:0.00 s:0.02 r:56.11

stderr[]]

 

 |- ipv6 RRD /opt/observium/rrd/nj-wan01/cef-pfx-7051-ipv6.rrd already exists - no need to create.

 

SQL[UPDATE `cef_prefix` set `cef_pfx` ='' WHERE `device_id` = '63' AND `entPhysicalIndex` = '7051' AND `afi` = 'ipv6']

RUNTIME[0.00073409s]

RRD[cmd[update /opt/observium/rrd/nj-wan01/cef-pfx-7051-ipv6.rrd N:U --daemon unix:/var/rrdtool/rrdcached/rrdcached.sock

stdout[OK u:0.00 s:0.02 r:56.11

stderr[]]

 | |-1: RP LES

SQL[SELECT * FROM `cef_switching` WHERE `device_id` = '63' AND `entPhysicalIndex = '7051' AND `afi` = 'ipv6' AND `cef_index` = '1']

RUNTIME[0.00008082s]

ERROR[Error in query: (1064) 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 'afi` = 'ipv6' AND `cef_index` = '1'' at line 1]

RRD /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv6-1.rrd already exists - no need to create.

 

SQL[UPDATE `cef_switching` set `drop` ='0',`punt` ='0',`punt2host` ='0',`drop_prev` ='',`punt_prev` ='',`punt2host_prev` ='',`updated` ='1431494692',`updated_prev` ='' WHERE `device_id` = '63' AND `entPhysicalIndex` = '7051' AND `afi` = 'ipv6' AND `cef_index` = '1']

RUNTIME[0.00065994s]

RRD[cmd[update /opt/observium/rrd/nj-wan01/cefswitching-7051-ipv6-1.rrd N:0:0:0 --daemon unix:/var/rrdtool/rrdcached/rrdcached.sock

stdout[OK u:0.00 s:0.02 r:56.11

stderr[]]

 


_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium