Here is what I did
1. Modify the script, the 2 changes discussed already and one other change to write out to a .dot file, instead of a .png (notes at bottom). Also, this is just looking at cdp and whatever else is in the neighbors table, it is not looking or building a graph based on OSPF which I believe there is a table for as well, but I have not had time to investigate. 2. Per the documentation, I created a graph directory under html, so in my case /opt/observium/html/graph 3. Dropped the map.php and the viz.js file in that directory (I ended up grabbing it from here: https://github.com/mdaines/viz.js/releases, unknown if there are better locations, but developer on that seems to have stopped it). 4. Modified map.php to point at the .dot file that I generated, we'll say for example: myservers.mydomain.org_map.dot (It is CHANGEME or something like that in the original map.php). 5. Then ran the following command: sudo python /opt/observium/graph.py myservers.mydomain.org (where myservers.mydomain.org is a full DNS entry that exists in your setup for what you want to be the main node so to say).
6. Visit your server/new page: http://%5Bobservium server]/graph/map.php
#5 will generate a .dot output file that will be displayed when you visit the URL in #6. By default the script actually puts out .png files, which depending on your size, may be fine, but with 1100+ objects in ours, it was too hard to zoom in on.
So for changes for #1:
This will write out to .dot format instead of .png """graph.write_png('%s_map.png' % (this_device))""" graph.write_dot('%s_map.dot' % (this_device))
As for your issue, I believe it is based on this part: UPPER*(*d*.*hostname*) = *UPPER*(*'GEALICRDC03'*)*;
I had to use FQDN as noted in #5 above.
Eric
On Mon, Nov 7, 2016 at 9:27 AM, Vater, Wolfgang < wolfgang.vater@de.unisys.com> wrote:
Could you provide instruction show to get this to work, please?
This is the one addon I really would like to see working.
Wolfgang
*From:* observium [mailto:observium-bounces@observium.org] *On Behalf Of *Eric Kollmann *Sent:* Tuesday, November 1, 2016 21:44 *To:* Observium Network Observation System observium@observium.org *Subject:* Re: [Observium] Tables in the Observium DB
Once you verified it had to be changed and indicated links table is no longer there, think I got it updated to work now:
have to actually remove the 2 lines starting with //, but basically changed links to neighbours and updated l.local_port_id to l.port_id below. Running this with 1100+ devices in observium kicks out a really large map, but got to say great product!
SELECT
UPPER(d.hostname) AS local_hostname,
p.port_id AS local_port_id,
p.ifName AS local_port,
p.ifSpeed/1000000 as local_port_speed,
l.remote_port_id AS remote_port_id,
rp.ifName AS remote_port,
UPPER(l.remote_hostname) AS remote_hostname,
d.hardware AS hardware,
rd.hardware AS remote_hardware,
s.ifInErrors_rate AS local_in_errors_rate,
s.ifOutErrors_rate AS local_out_errors_rate,
s.ifInOctets_rate*8 AS local_in_octets_rate,
s.ifOutOctets_rate*8 AS local_out_octets_rate,
s.ifInOctets_perc AS local_in_octets_perc,
s.ifOutOctets_perc AS local_out_octets_perc
FROM
`devices` AS d,
`devices` as rd,
`ports` AS p,
`ports` as rp,
// `links` AS l,
`neighbours` AS l,
`ports-state` AS s
WHERE
// p.port_id = l.local_port_id AND
p.port_id = l.port_id AND
p.device_id = d.device_id AND
rp.port_id = l.remote_port_id AND
rp.device_id = rd.device_id AND
p.port_id = s.port_id AND
UPPER(d.hostname) = UPPER(%s);
"""
On Tue, Nov 1, 2016 at 12:50 PM, Eric Kollmann xnih13@gmail.com wrote:
Perfect, happy to test it out if/when you get a chance to send it on. If php stuff needs tweaked I'll see what I can come up with there.
Eric
On Tue, Nov 1, 2016 at 12:06 PM, Adam Armstrong adama@memetic.org wrote:
Hi Eric,
I rewrote the query that script uses and it's saved to a text file. I've not gotten around to rewriting the rest of the code in php yet,since I don't have a CDP network to test on.
I can dig out the SQL when I'm not driving :) (bathroom stop, I can't write email and drive! ;))
Adam.
Sent from BlueMail http://www.bluemail.me/r
On 1 Nov 2016, at 16:11, Eric Kollmann xnih13@gmail.com wrote:
First, I just took over our install of this, wasn't involved in the initial setup of observium and I understand the piece I'm asking about is not part of observium, just uses the data it collects and I want to verify if structure has changed since it was released or if there is something incorrectly setup with our system.
I'm looking to build out graphviz maps with the data observium has gathered, specifically using:
https://github.com/kedare/observium_map_generator
Going through their code, it queries the db for the links table and fails. Looking at the database I have a neighbours table, but not links. Google search I see links table discussed back in 2014, but nothing much recently.
So, did the links table go away in newer versions, or is the fact that the table is missing an issue with our setup? If it is supposed to be there and missing, I'll work on figuring that out next, if it did just go away I just want to verify that.
Thanks
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