Hi Adam -
On Mon, Dec 24, 2012 at 07:09:42PM -0600, Adam Armstrong wrote:
Put /debug/ on the end of the URL.
Well, that certainly produced some extra information. I think it boils down to something happening between the MySQL query and getting the output to the web UI. Here's what /devices/debug gives me:
o http://www.prolixium.com/share/observium-devices-debug.pdf o http://www.prolixium.com/share/observium-devices-debug.html
I can run some of those queries directly on the MySQL command line and get results consistent with what should be displayed by the web UI:
mysql> SELECT COUNT(port_id) FROM `ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ignore` = '0'; +----------------+ | COUNT(port_id) | +----------------+ | 13 | +----------------+ 1 row in set (0.00 sec)
mysql> SELECT * FROM `devices` WHERE 1 ORDER BY hostname \G *************************** 1. row *************************** device_id: 3 hostname: dax sysName: dax.prolixium.com community: <omitted> [..output trimmed, but three devices are shown..]
There are some errors that may be important, although PHP flags them as warnings:
<b>Warning</b>: sort() expects parameter 1 to be array, null given in <b>/opt/observium/html/includes/functions.inc.php</b> on line <b>738</b><br /> <br /> <b>Warning</b>: Invalid argument supplied for foreach() in <b>/opt/observium/html/pages/devices.inc.php</b> on line <b>120</b><br />
The queries directly above these PHP messages in the debug output result in no rows returned:
mysql> SELECT D.device_id,location FROM devices AS D, devices_perms AS P WHERE D.device_id = P.device_id AND P.user_id = '1' GROUP BY location ORDER BY location; Empty set (0.00 sec)
mysql> SELECT attrib_type,attrib_value,device_id FROM devices_attribs WHERE attrib_type LIKE 'override_sysLocation%' ORDER BY attrib_type; Empty set (0.00 sec)
In the meantime, I'm going to add a few more random devices and see if I can get one to display correctly..
Thanks!
- Mark
Mark Kamichoff prox@prolixium.com wrote:
Hi -
Warning: Here's another one of the "I installed it but it doesn't work!" e-mails.
I recently setup Observium (SVN from Dec 23, 2012) on a Debian testing/unstable x86_64-based host. I followed all of the instructions with the exception of the installation of libvirt packages (I don't appear to have a need for it) and although I appear to have successfully added devices, none of them show up in the web UI.
The three devices I've added are the following:
o Juniper SRX100 o FreeBSD x86_64 Host o Linux x86_64 Host
According to observium.log the cron jobs are running fine and the devices are being polled:
(atlantis:16:44)# tail -n 8 observium.log /opt/observium/poller.php all December 24, 2012, 16:25 - 3 devices polled in 21.97 secs /opt/observium/discovery.php new December 24, 2012, 16:30 - 0 devices discovered in 0.001 secs /opt/observium/poller.php all December 24, 2012, 16:30 - 3 devices polled in 21.46 secs /opt/observium/discovery.php new December 24, 2012, 16:35 - 0 devices discovered in 0.002 secs /opt/observium/poller.php all December 24, 2012, 16:35 - 3 devices polled in 21.41 secs /opt/observium/discovery.php new December 24, 2012, 16:40 - 0 devices discovered in 0.002 secs /opt/observium/poller.php all December 24, 2012, 16:40 - 3 devices polled in 21.97 secs /opt/observium/discovery.php new December 24, 2012, 16:45 - 0 devices discovered in 0.000 secs
I'm not sure exactly what check-errors.php does (maybe it just checks the RRDs), but it seems to indicate that there aren't any glaring issues:
(atlantis:16:45)# ./check-errors.php Checked 80 interfaces 0 interfaces with errors over the past 5 minutes.
I even looked in the MySQL DB and the `devices` table seems to be populated correctly.
The problem is that the web UI doesn't show any devices:
http://www.prolixium.com/share/screens/observium-devices.png
However, if I navigate to System -> About Observium, the statistics table shows devices, interfaces, CPUs, etc.:
http://www.prolixium.com/share/screens/observium-stats.png
I've got to be missing something obvious. I thought the user I created might not have sufficient privileges, but I created the user "prox" with privilege level 10.
The only thing that did not go 100% as expected was the DB schema load. The instructions indicated that errors in the SQL revisions /up to/ 006 will be expected, but I saw two errors past revision 006:
(atlantis:18:06)# php includes/sql-schema/update.php -- Updating database schema 000 -> 001 ... done. 001 -> 002 ... done. 002 -> 003 ... done. 003 -> 004 ... done. 004 -> 005 ... done. 005 -> 006 ... done. 006 -> 007 ... done (1 errors). 007 -> 008 ... done. [..snip..] 031 -> 032 ... done. 032 -> 033 ... done (2 errors). 033 -> 034 ... done. [..snip..] 039 -> 040 ... done. -- Done
I'm not sure if this is minor or something to be concerned about. Here is some package information:
mysql-server-5.5 5.5.24+dfsg-9 libapache2-mod-php5 5.4.4-10 apache2-mpm-prefork 2.2.22-12
There appear to be no PHP errors in the Apache error log I setup for the Observium virtual host.
Is there anything else I should check?
Oh, I'm using Google Chrome 23.0.1271.101 on MacOS 10.8 (at the moment, at least).
Thanks!
- Mark
-- Mark Kamichoff prox@prolixium.com http://www.prolixium.com/
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