Please help
I did clean install observium subscription on Centos 7 and follow instruction from this link http://www.observium.org/docs/install_rhel7/ I choose php 7.0 to install, after installation complete I add user and device to manage, everything ok, but the graphs not shown only realtime graphs is show, I am waiting about 1 day but the data in the graphs in and out only give -nan, what I missed and how to solve this problem ?
see attachment
on the logs folder and I tail -f db.log I saw an error like this :
[2017/01/17 05:34:32 +0000] discovery.php(31631): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `device_id` = '1' AND `entPhysicalIndex` = '39'' at line 1), Query: UPDATE `entPhysical` set `ifIndex` = WHERE `device_id` = '1' AND `entPhysicalIndex` = '39'
only db.log give an error, on error_log is empty.
best regards
Aswin Triadhi
IT System Administrator PT Citratubindo Tbk Jln. Hang Kesturi KM4 Kabil - Batam Indonesia
Office : +62-778-711123 (ext 113) Speed Dial : internal *1112 HP : +628 1364405096
Hi,
this issue fixed in r8319 (4 days ago).
Update your install.
On Tue, Jan 17, 2017 at 3:51 AM, Aswin Triadhi aswin@citratubindo.co.id wrote:
Please help
I did clean install observium subscription on Centos 7 and follow instruction from this link http://www.observium.org/docs/install_rhel7/ I choose php 7.0 to install, after installation complete I add user and device to manage, everything ok, but the graphs not shown only realtime graphs is show, I am waiting about 1 day but the data in the graphs in and out only give *-nan, *what I missed and how to solve this problem ?
see attachment
on the logs folder and I tail -f db.log I saw an error like this :
*[2017/01/17 05:34:32 +0000] discovery.php(31631): Failed dbQuery (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `device_id` = '1' AND `entPhysicalIndex` = '39'' at line 1), Query: UPDATE `entPhysical` set `ifIndex` = WHERE `device_id` = '1' AND `entPhysicalIndex` = '39'*
only db.log give an error, on error_log is empty.
best regards
*Aswin Triadhi*
IT System Administrator PT Citratubindo Tbk Jln. Hang Kesturi KM4 Kabil - Batam Indonesia
Office : +62-778-711123 callto:+62-778-711123 (ext 113) Speed Dial : internal *1112 HP : +628 1364405096 callto:+628%201364405096
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Aswin Triadhi -
Mike Stupalov