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[]]
Hi
I think the SQL errors are due to you have strict mode enabled.
Regards.
El 13/05/15 a las 07:31, Jeffrey d'Ambly escribió: 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[]]
________________________________ Este correo electrónico y, en su caso, cualquier fichero anexo al mismo, contiene información de carácter confidencial exclusivamente dirigida a su destinatario o destinatarios. Si no es vd. el destinatario indicado, queda notificado que la lectura, utilización, divulgación y/o copia sin autorización está prohibida en virtud de la legislación vigente. En el caso de haber recibido este correo electrónico por error, se ruega notificar inmediatamente esta circunstancia mediante reenvío a la dirección electrónica del remitente. Evite imprimir este mensaje si no es estrictamente necesario.
This email and any file attached to it (when applicable) contain(s) confidential information that is exclusively addressed to its recipient(s). If you are not the indicated recipient, you are informed that reading, using, disseminating and/or copying it without authorisation is forbidden in accordance with the legislation in effect. If you have received this email by mistake, please immediately notify the sender of the situation by resending it to their email address. Avoid printing this message if it is not absolutely necessary.
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
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.commailto: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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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.commailto: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.orgmailto: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
My issues with graphing were related to permissions on the rrd files. I had the wrong user setup for rrdcacehed. Once I made the change everything started wortking I also edited ./includes/polling/cisco-cef.inc.php And added the “`”, when I run the poller I’m not getting any errors.
Thanks for the help.
—Jeff From: Adam Armstrong <adama@memetic.orgmailto:adama@memetic.org> Reply-To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Date: Wednesday, May 13, 2015 at 2:48 AM To: Observium Network Observation System <observium@observium.orgmailto:observium@observium.org> Subject: Re: [Observium] new obs server
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.aumailto: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.commailto: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.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium _______________________________________________ observium mailing list observium@observium.orgmailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (4)
-
Adam Armstrong -
Bruce Guthrie -
Jeffrey d'Ambly -
Juan Asensio Sánchez