It might be something that's changed recently, with adding sorting.

Interesting that it claims you have zero devices/ports in the header too.

adam.

On 24/12/2012 22:29, Mark Kamichoff wrote:
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



      

      

      

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