- observium - lists.observium.org

Re: [Observium] observium Digest, Vol 60, Issue 59
by Johnston, Tom 09 Jul '15

09 Jul '15

Here is the results of the SNMPWalk. IF-MIB::ifIndex.107 = INTEGER: 107 IF-MIB::ifDescr.107 = STRING: TenGigabitEthernet2/1 IF-MIB::ifType.107 = INTEGER: ethernetCsmacd(6) IF-MIB::ifMtu.107 = INTEGER: 1500 IF-MIB::ifSpeed.107 = Gauge32: 4294967295 IF-MIB::ifPhysAddress.107 = STRING: 64:0:f1:ee:7c:0 IF-MIB::ifAdminStatus.107 = INTEGER: down(2) IF-MIB::ifOperStatus.107 = INTEGER: down(2) IF-MIB::ifLastChange.38 = Timeticks: (210732797) 24 days, 9:22:07.97 IF-MIB::ifLastChange.40 = Timeticks: (210732614) 24 days, 9:22:06.14 IF-MIB::ifLastChange.107 = Timeticks: (512227871) 59 days, 6:51:18.71 IF-MIB::ifInOctets.107 = Counter32: 0 IF-MIB::ifInUcastPkts.79 = Counter32: 3401610701 IF-MIB::ifInUcastPkts.107 = Counter32: 0 IF-MIB::ifInNUcastPkts.107 = Counter32: 0 IF-MIB::ifInDiscards.107 = Counter32: 0 IF-MIB::ifInErrors.107 = Counter32: 0 IF-MIB::ifInUnknownProtos.107 = Counter32: 0 IF-MIB::ifOutOctets.25 = Counter32: 2792331074 IF-MIB::ifOutOctets.107 = Counter32: 0 IF-MIB::ifOutUcastPkts.107 = Counter32: 0 IF-MIB::ifOutNUcastPkts.107 = Counter32: 0 IF-MIB::ifOutDiscards.107 = Counter32: 0 IF-MIB::ifOutErrors.107 = Counter32: 0 Thomas Johnston Network Administrator Edina Public Schools P: 952-848-4991 <tel:952-848-4991> On 7/9/15, 12:53 PM, "observium on behalf of observium-request(a)observium.org" <observium-bounces(a)observium.org on behalf of observium-request(a)observium.org> wrote: >Send observium mailing list submissions to > observium(a)observium.org > >To subscribe or unsubscribe via the World Wide Web, visit > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >or, via email, send a message with subject or body 'help' to > observium-request(a)observium.org > >You can reach the person managing the list at > observium-owner(a)observium.org > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of observium digest..." > > >Today's Topics: > > 1. Re: Configuring map interface on new observium installation > (Milton Ngan) > 2. Re: New 6500-E Module (Adam Armstrong) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Thu, 9 Jul 2015 17:15:45 +0000 >From: Milton Ngan <milton(a)valvesoftware.com> >To: Observium Network Observation System <observium(a)observium.org> >Subject: Re: [Observium] Configuring map interface on new observium > installation >Message-ID: <8D53F2A3-02D4-467F-B1D2-1467828C19E3(a)valvesoftware.com> >Content-Type: text/plain; charset="utf-8" > >The location_map maps the string retrieved from the sysLocation value of your devices and maps it to a location that can be geolocated via Google or Mapquest. > >This is useful if you have special location names which cannot be geolocated, or your device doesn?t support strings long enough to enter in the full address. It doesn?t map the device name to a location which it looks like what you are trying to do. Try configuring the devices? SNMP sysLocation with the string you have and it should work. > > > >From: observium on behalf of Andi Qirjazi >Reply-To: Observium Network Observation System >Date: Thursday, July 9, 2015 at 8:11 AM >To: Observium Network Observation System >Subject: Re: [Observium] Configuring map interface on new observium installation > >Hi, > >Sorry, this I didn't get it. Should be same location_map for both devices? > >Thanks, >Andi > > >On Thu, Jul 9, 2015 at 4:55 PM, Tom Laermans <tom.laermans(a)powersource.cx<mailto:tom.laermans@powersource.cx>> wrote: >Hi, > >The location_map maps locations from one to the other, it's not meant for specific devices, unless you have Device1 as location set for some devices... > >If you want to override a single device's location, go to the device properties and set it there. > >Tom > > >On 2015-07-09 16:53, Andi Qirjazi wrote: >Hi Rudolf, > >Yes, I'm still having problems. The Map shows only the green button in Atlantic ocean. >I have the following sysLocation at config file for each device: > >$config['location_map']['Device1']="HQ, Berlin, DE"; >$config['location_map']['Device2']="HQ, Rome, IT"; > >Please, correct me if I'm wrong. > >Thanks, >Andi > > >On Thu, Jul 9, 2015 at 1:30 PM, Rudolf Hoehler <rudolf(a)saicomvoice.co.za<mailto:rudolf@saicomvoice.co.za>> wrote: >Hello Andi, > >Are you still having the problem? What is the sysLocation string that you use? > >Rudolf > >From: Andi Qirjazi <aqirjazi(a)gmail.com<mailto:aqirjazi@gmail.com>> >Reply-To: "observium(a)observium.org<mailto:observium@observium.org>" <observium(a)observium.org<mailto:observium@observium.org>> >Date: Tuesday 07 July 2015 at 17:14 >To: "observium(a)observium.org<mailto:observium@observium.org>" <observium(a)observium.org<mailto:observium@observium.org>> >Subject: [Observium] Configuring map interface on new observium installation > >Hi, > >I have just installed & configured observium for the first time. The first two devices are added and seems working, but I'm having problem displaying these devices on the map. All the time there is a blue sign on the middle on Atlantic ocean, it doesn't matter what I configure as device location. > >Please any idea how to configure the map? >I have tried all the possible configurations at /opt/observium/config.php settings but with no success. >This installation is behind a proxy server, but I have allowed all the traffic from observium host and I don't see any traffic from this host towards proxy server. > >I did the following configuration on monitored devices for SNMP settings as follow: > >R_TR#sh run | s snmp >snmp-server community aaaaaaa RO >snmp-server ifindex persist >snmp-server location Berlin, DE >snmp-server contact bbbbbbbbbb > >at Observium main page, at location tab, is listed Berlin, DE (or Rome, IT another device) but no indication on the map for both devices. > >regarding proxy server configuration, at \opt\observium\config.php file I have the following settings: >//configure proxy server settings >$config['http proxy'] = "myproxy:8080"; >with no username and password, because I have allowed all the traffic from observium host and it has internet access, because I did manually update and it worked normally. > >Please could you send me a sample of a working map configuration? > >I have the following configuration regarding geolocation at config.php file: > > >// $config['frontpage']['map']['region'] = "https://developers.google.com/chart/interactive/docs/gall$ >$config['geocoding']['enable'] =TRUE; >$config['geocoding']['dns'] = FALSE; >$config['location_menu_geocoded'] = FALSE; >$config['geocoding']['api'] = 'www.googleapis.com/geolocation/v1/geolocate?key=aaaaaaaaaaaaaaaaaaaaa<http://www.googleapis.com/geolocation/v1/geolocate?key=aaaaaaaaaaaaaaaaaaaaa>'; > >I even tried with just 'google' as API, but it doesn't change anything. > >thanks in advance, >Andi Qirjazi > >_______________________________________________ >observium mailing list >observium(a)observium.org<mailto:observium@observium.org> >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > > > > >_______________________________________________ >observium mailing list >observium(a)observium.org<mailto:observium@observium.org>http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > >_______________________________________________ >observium mailing list >observium(a)observium.org<mailto:observium@observium.org> >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > >-------------- next part -------------- >An HTML attachment was scrubbed... >URL: <http://postman.memetic.org/pipermail/observium/attachments/20150709/8be1908…> > >------------------------------ > >Message: 2 >Date: Thu, 09 Jul 2015 18:54:06 +0100 >From: "Adam Armstrong" <adama(a)memetic.org> >To: "" <observium(a)observium.org> >Subject: Re: [Observium] New 6500-E Module >Message-ID: <4291bb7e-0f3d-43fa-80f8-4bc9fe010248(a)getmailbird.com> >Content-Type: text/plain; charset="utf-8" > >It's likely that your device isn't returning correct counters for this linecard's ports. > >Typical 6500 OIR :) > >Check what it's returning for this port in SNMP > >snmpbulkwalk -v2c -c <community> <hostname> ifEntry | grep \.107 > >adam. > >Sent from Mailbird [http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&ut…] >... >On 09/07/2015 18:15:44, Johnston, Tom <tom.johnston(a)edinaschools.org> wrote: >After adding a new 6500 module to multiple Cisco 6504-E (added WS-6816-10G) the module shows up in Observium after being polled as expected. > >The issue is the module isn?t being updated. Ports that are up are showing as disable/down it is also not drawing graphs as its not seeing it as up. > >The port is actually up and passing traffic but that is not being reflected in Observium. ?The only thing that fixes this is deleting/re-adding the device. I assume there is a more appropriate way to fix this. >------------------------------------------------ >Debug shows the following:? > >PERMISSIONS CHECK. Entity type: port, Entity ID: 92959, Device ID: 91, Allowed: TRUE. > >This is under Settings > Ports (Port Properties) >Port specifics are here > >$port/opt/observium/html/pages/device/port/data.inc.php:17 >array(71 >port_id => 92959 >device_id => 91 >port_64bit => 1 >port_label => TenGigabitEthernet2/1 >port_label_base => null >port_label_num => null >port_label_short => Te2/1 >port_descr_type => null >port_descr_descr => null >port_descr_circuit => null >port_descr_speed => null >port_descr_notes => null >ifDescr => TenGigabitEthernet2/1 >ifName => Te2/1 >portName => null >ifIndex => 107 >ifSpeed => 10000000000 >ifConnectorPresent => true >ifPromiscuousMode => false >ifHighSpeed => 10000 >ifOperStatus => down >ifAdminStatus => down >ifDuplex => fullDuplex >ifMtu => 1500 >ifType => ethernetCsmacd >ifAlias => Test >ifPhysAddress => 6400f1ee7c00 >ifHardType => null >ifLastChange => 2014-02-27 07:40:53 >date-1yr America/Chicago (UTC-5) >ifVlan => null >ifTrunk => null >ifVrf => null >ignore => 0 >disabled => 0 >detailed => 0 >deleted => 0 >pagpOperationMode => null >pagpPortState => null >pagpPartnerDeviceId => null >pagpPartnerLearnMethod => null >pagpPartnerIfIndex => null >pagpPartnerGroupIfIndex => null >pagpPartnerDeviceName => null >pagpEthcOperationMode => null >pagpDeviceId => null >pagpGroupIfIndex => null >ifInUcastPkts => 0 >ifInUcastPkts_delta => 0 >ifInUcastPkts_rate => 0 >ifOutUcastPkts => 0 >ifOutUcastPkts_delta => 0 >ifOutUcastPkts_rate => 0 >ifInErrors => 0 >ifInErrors_delta => 0 >ifInErrors_rate => 0 >ifOutErrors => 0 >ifOutErrors_delta => 0 >ifOutErrors_rate => 0 >ifOctets_rate => 0 >ifUcastPkts_rate => 0 >ifErrors_rate => 0 >ifInOctets => 0 >ifInOctets_delta => 0 >ifInOctets_rate => 0 >ifOutOctets => 0 >ifOutOctets_delta => 0 >ifOutOctets_rate => 0 >ifInOctets_perc => 0 >ifOutOctets_perc => 0 >poll_time => 1436461953 >poll_period => 237 >) > >Observium 0.15.7.6608 > >I?m running across multiple issues I haven?t encountered yet today so sorry for so many questions. > > > >-------------- next part -------------- >An HTML attachment was scrubbed... >URL: <http://postman.memetic.org/pipermail/observium/attachments/20150709/83173dc…> > >------------------------------ > >Subject: Digest Footer > >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > >------------------------------ > >End of observium Digest, Vol 60, Issue 59 >*****************************************

2 1

Dual Purpose Interface
by Johnston, Tom 09 Jul '15

09 Jul '15

2960X switches and newer styles of switches have dual speed SFP slots. On my 2960X I have switched from 1GIG SFP to a 10GIG SFP. This changes the ports from GigabitEthernet to TenGigabitEthernet. In the switch config now the GigabitEthernet ports are gone (they get removed from running config) and now TenGigabit Ports are present and in use. Observium still shows both types of interfaces present, and there is none to delete under ports. It also doesn’t show that the TenGig port is up even though it is up. Whats the best way to handle this? Delete/re-add switch? Te1/0/1 connected trunk full 10G SFP-10GBase-LRM (was the gigabit 1/0/49) Te1/0/2 notconnect 1 full 10G Not Present (was the gigabit 1/0/50) Po2 VV-6504 notconnect 1 auto auto Fa0 disabled routed auto auto 10/100BaseTX VV-IDF3-2960X01# 10149 GigabitEthernet1/0/49 VV-6504 G4/8 Ethernet enabled / down No Yes No Yes 64bit 10150 GigabitEthernet1/0/50 VV-6504 G4/9 Ethernet enabled / down No Yes No Yes 64bit 10201 TenGigabitEthernet1/0/1 Ethernet enabled / down No Yes No Yes 32bit 10202 TenGigabitEthernet1/0/2 Ethernet enabled / down No Yes No Yes 32bit Thanks in advance Thanks in advance

2 1

New 6500-E Module
by Johnston, Tom 09 Jul '15

09 Jul '15

After adding a new 6500 module to multiple Cisco 6504-E (added WS-6816-10G) the module shows up in Observium after being polled as expected. The issue is the module isn’t being updated. Ports that are up are showing as disable/down it is also not drawing graphs as its not seeing it as up. The port is actually up and passing traffic but that is not being reflected in Observium. The only thing that fixes this is deleting/re-adding the device. I assume there is a more appropriate way to fix this. ------------------------------------------------ Debug shows the following: PERMISSIONS CHECK. Entity type: port, Entity ID: 92959, Device ID: 91, Allowed: TRUE. This is under Settings > Ports (Port Properties) [cid:69B8A256-5622-4D4D-BC96-28A8465ECDBF] Port specifics are here $port/opt/observium/html/pages/device/port/data.inc.php:17 array(71 port_id => 92959 device_id => 91 port_64bit => 1 port_label => TenGigabitEthernet2/1 port_label_base => null port_label_num => null port_label_short => Te2/1 port_descr_type => null port_descr_descr => null port_descr_circuit => null port_descr_speed => null port_descr_notes => null ifDescr => TenGigabitEthernet2/1 ifName => Te2/1 portName => null ifIndex => 107 ifSpeed => 10000000000 ifConnectorPresent => true ifPromiscuousMode => false ifHighSpeed => 10000 ifOperStatus => down ifAdminStatus => down ifDuplex => fullDuplex ifMtu => 1500 ifType => ethernetCsmacd ifAlias => Test ifPhysAddress => 6400f1ee7c00 ifHardType => null ifLastChange => 2014-02-27 07:40:53 date-1yr America/Chicago (UTC-5) ifVlan => null ifTrunk => null ifVrf => null ignore => 0 disabled => 0 detailed => 0 deleted => 0 pagpOperationMode => null pagpPortState => null pagpPartnerDeviceId => null pagpPartnerLearnMethod => null pagpPartnerIfIndex => null pagpPartnerGroupIfIndex => null pagpPartnerDeviceName => null pagpEthcOperationMode => null pagpDeviceId => null pagpGroupIfIndex => null ifInUcastPkts => 0 ifInUcastPkts_delta => 0 ifInUcastPkts_rate => 0 ifOutUcastPkts => 0 ifOutUcastPkts_delta => 0 ifOutUcastPkts_rate => 0 ifInErrors => 0 ifInErrors_delta => 0 ifInErrors_rate => 0 ifOutErrors => 0 ifOutErrors_delta => 0 ifOutErrors_rate => 0 ifOctets_rate => 0 ifUcastPkts_rate => 0 ifErrors_rate => 0 ifInOctets => 0 ifInOctets_delta => 0 ifInOctets_rate => 0 ifOutOctets => 0 ifOutOctets_delta => 0 ifOutOctets_rate => 0 ifInOctets_perc => 0 ifOutOctets_perc => 0 poll_time => 1436461953 poll_period => 237 ) Observium 0.15.7.6608 I’m running across multiple issues I haven’t encountered yet today so sorry for so many questions.

2 1

Mailing List
by Johnston, Tom 09 Jul '15

09 Jul '15

The online mailing list isn’t showing any updates since 2015/06/27 if I sort by date. Shouldn’t there be more content? I’m Looking at messages sorted by date for this information. Most recent I see: * 2015/06/27 Re: [Observium] Installing JpGraph blanks out bills page<https://www.mail-archive.com/observium@observium.org/msg09849.html> Rudolf Hoehler * 2015/06/27 Re: [Observium] Installing JpGraph blanks out bills page<https://www.mail-archive.com/observium@observium.org/msg09848.html> Adam Armstrong * 2015/06/27 [Observium] Installing JpGraph blanks out bills page<https://www.mail-archive.com/observium@observium.org/msg09847.html> Rudolf Hoehler * 2015/06/26 Re: [Observium] alerts<https://www.mail-archive.com/observium@observium.org/msg09846.html> Jeffrey d'Ambly * 2015/06/26 Re: [Observium] alerts<https://www.mail-archive.com/observium@observium.org/msg09845.html> Jeffrey d'Ambly Thomas Johnston Network Administrator Edina Public Schools P: 952-848-4991<tel:952-848-4991>

1 0

Smokeping tab missing from Observium
by Nate Mellendorf 08 Jul '15

08 Jul '15

Observium team and community, My apologies if this has been pointed out, but I didn't see it in the most recent e-mails for the mailing list. We're running 0.15.7.6605 of Observium, and our smokeping tab has recently disappeared. We could rollback to see what version it vanished from, but I wanted to reach out first. Image: Config.php: // Smokeping config $config['smokeping']['dir'] = "/core2/smokeping/"; Has anyone else experienced this issue? Thank you.

2 1

Unsubscribing from the observium (and many other) mailing list(s) 101 (WAS: RE: Auto Discovery/Automate adding devices.)
by Phillip Baker 08 Jul '15

08 Jul '15

Dear today's person who asked to be unsubscribed from a mailing list that has an unsubscribe function baked into it, Don't be that guy, guy. Here's a handy dandy guide for you and everyone else who's brain is gradually formulating a thought about this topic, before we get another raft of "I TOO WOULD LIKE TO BE UNSUBSCRIBED FROM RECEIVING THESE MESSAGES IN MY COMPUSERVE I DO NOT WANT ANY VIAGRA" emails like last time this happened. Q1: Have you *tried* to unsubscribe yourself? If no: There's a link at the bottom of every email you've received from this list (hint: http://postman.memetic.org/cgi-bin/mailman/listinfo/observium ), and at the bottom of the page that results from clicking on that link is a section that you will likely find relevant to your interests. Like most sane/legitimate mailing lists, the List-Unsubscribe header is also set in the mail headers of every message you receive via this mailing list: List-Unsubscribe: <http://postman.memetic.org/cgi-bin/mailman/options/observium> - which takes you to a specific unsubscribe page. If you don't know your mailman password, reset it. The button to do that, is like, right there, maaaaan. If yes: Proceed to Q2, brave traveller. Steel yourself, the next step possibly requires reading message headers. Grab a Snickers (DISCLAIMER: Ask your doctor if Snickers is right for you). Q2: Have you checked you're trying to unsubscribe the address you actually are receiving mail for? Perhaps you're receiving mail for an alias rather than your pimary mailbox address? The message headers should tell you what this is if you can't see it any other way (look for "for <email(a)address.org>" in a "Received:" header close to you). If no: Check, and if necessary, unsubscribe again, but with the right address this time. If yes: Congratulations! You are possibly a special snowflake and possibly have an actual problem that possibly requires someone else's help, possibly, and you should have provided all this information up front to prevent being ridiculed... except you're still telling a bunch of people who can do nothing to help you. Mail the list administrator directly (who's contact email you can find on the above mentioned pages) telling them what you've tried to do, and what the email address is that is receiving the mails from the list, and then they can help you. Adam loves to help. It's practically his middle name. By now, you have now successfully unsubscribed from a mailing list.. unless Adam doesn't like you and is keeping you on the list just to torment you for some sick twisted reason (less common than you might think). A+ super great job! I'm just going to leave these here, from the thread you replied to, to make a point of some sort: > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium YES, I *HAVE* HAD A VERY ANNOYING DAY TODAY, WHY DO YOU ASK?

1 0

Auto Discovery/Automate adding devices.
by Rudolf Hoehler 08 Jul '15

08 Jul '15

Hello Team, Please can you assist me with the auto discovery. It's not working... :) I read in a mailing list archive dated Nov 2014, that it actually doesn't work? Is this still the case? Can I write my own script that adds devices from the backend? Should I use an API call or can I insert into the database directly? Further to that, 1. What happens if I try to add the same device again? Thinking from an automated system, the same hostname might have multiple interfaces that it is reachable on? 2. What happens if we change a device's host name - does observium create a new device? What is best practice when administering the system wrt device swop outs or hostname changes? Regards, Rudolf

5 6

Interface ifAlias change at every poll
by Nick Ryce 08 Jul '15

08 Jul '15

2 3

Forbidden Access Permissen Ubuntu 14.04.
by Florian Schnelle 08 Jul '15

08 Jul '15

Hi everyone, I can´t access our new test installation. I don’t have any Apache knowledge and I guess that´s where the problem lays. I tried to create a vHost, as well as I tried to follow the instructions from the how to page regarding /etc/apache2/sites-available/default <Directory /opt/observium/html/> Options Indexes FollowSymLinks MultiViews AllowOverride All Require all granted </Directory> Without any success. Help would be highly appreciated. Thanks and regards, Flo

3 5

Re: [Observium] observium Digest, Vol 60, Issue 37
by Mathias Giroud 08 Jul '15

08 Jul '15

Hello, Can you help me for this integration ? https://gist.github.com/arekinath/3384869 Cordialement, GIROUD Mathias Tél.: +41 (0)27 519 00 46 Email: hello <mailto:hello@giroudmathias.ch> <mailto:marketing@giroudmathias.ch>@giroudmathias.ch <mailto:hello@giroudmathias.ch> Site: www.giroudmathias.ch <http://giroudmathias.ch/> This e-mail (including any attached documents) is intended for the named recipient(s) only. If you are not the intended recipient, we kindly ask you not to review, retain, copy or distribute this message, and we ask you to notify the sender by reply e-mail immediately and delete this message from your system. Thank you. Le 07.07.15 13:00, « observium au nom de observium-request(a)observium.org » <observium-bounces(a)observium.org au nom de observium-request(a)observium.org> a écrit : >Send observium mailing list submissions to > observium(a)observium.org > >To subscribe or unsubscribe via the World Wide Web, visit > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >or, via email, send a message with subject or body 'help' to > observium-request(a)observium.org > >You can reach the person managing the list at > observium-owner(a)observium.org > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of observium digest..." > > >Today's Topics: > > 1. Re: mysql_fetch_array replacement? (Robert Williams) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Mon, 6 Jul 2015 11:50:29 +0000 >From: Robert Williams <Robert(a)CustodianDC.com> >To: "observium(a)observium.org" <observium(a)observium.org> >Subject: Re: [Observium] mysql_fetch_array replacement? >Message-ID: <fc447724ec8b486bb68bf179682629ea(a)CDC-EX2.cdc.local> >Content-Type: text/plain; charset="utf-8" > >Thanks guys, didn?t realise it was a php function ? > >Interestingly there were no errors at all, just a zero output from the function, which didn?t help! > >Anyway, the solution was indeed from the example given on here: > >foreach(dbFetchRows("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname") as $data) > >(Then the rest of the original code) > >So cheers for that! > > >Robert Williams >Custodian Data Centre >Email: Robert(a)CustodianDC.com >http://www.CustodianDC.com >From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong >Sent: 05 July 2015 18:54 >To: observium(a)observium.org >Subject: Re: [Observium] mysql_fetch_array replacement? > >I expect he's now using mysqli_* via the config option, which means mysql_* is no longer connected to a database :) > >adam. > >Sent from Mailbird<http://www.getmailbird.com/?utm_source=Mailbird&utm_medium=email&utm_campai…> > >On 05/07/2015 18:43:14, Phillip Baker <phil(a)lchost.co.uk> wrote: >In fact, I?d be surprised if mysql_query is working if you?ve switched Observium to mysqli. What?s the actual error output of the script when you run it? > >Phil > >From: observium [mailto:observium-bounces@observium.org] On Behalf Of Robert Williams >Sent: 05 July 2015 13:51 >To: Observium Network Observation System (observium(a)observium.org) >Subject: [Observium] mysql_fetch_array replacement? > >Hi, > >After the SVN up on the 18th July the script we use for generating the Smokeping targets stopped producing any data (the list of slightly reformatted hostnames). The script itself was taken from this mailing list about 2 years ago and is as follows: > >#!/usr/bin/env php ><?php > >include("/opt/observium/includes/defaults.inc.php"); >include("/opt/observium/config.php"); >include("/opt/observium/includes/definitions.inc.php"); >include("/opt/observium/includes/functions.php"); > >echo "*** Targets ***\n\nprobe = FPing\n\nmenu = Top\ntitle = Network Latency Grapher\nremark = Welcome to SmokePing\n\n"; > >$query = mysql_query("SELECT hostname FROM `devices` WHERE `disabled`=0 ORDER BY hostname"); > >while ($data = mysql_fetch_array($query)) { > $hostid = str_replace(".","_",$data['hostname']); > $hostname = $data['hostname']; > echo "+ $hostid\n\nhost = $hostname\n\n"; >} > >?> > >I can see that /includes/functions.php no longer exists but it?s replacement in functions.inc.php does not appear to have a function for mysql_fetch_array(). > >So my question is, can someone point me to the correct replacement function for this? I?ve had a look through it and can?t see what I?m looking for, but PHP is not my ?thing? so I?m missing it. > >Any assistance appreciated! > >Robert Williams >Custodian Data Centre >Email: Robert(a)CustodianDC.com<mailto:Robert@CustodianDC.com> >http://www.CustodianDC.com >

2 1