- observium - lists.observium.org

DB update error
by Sholom Shapiro 21 Aug '15

21 Aug '15

Hi, I just updated for the first time in a couple of weeks, and got an error applying the updates. Here is the console message and update-errors log: /opt/observium# php ./discovery.php -h none ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.15.8.6911 http://www.observium.org -- Updating database/file schema 219 -> 220 ... (db) done. 220 -> 221 ... (db) done. 221 -> 222 ... (db) done. 222 -> 223 ... (db) done. 223 -> 224 ... (db) done (2 errors). 224 -> 225 ... (db) done. 225 -> 226 ... (db) done. 226 -> 227 ... (db) done. 227 -> 228 ... (db) done. -- Done. [2015/08/21 09:48:29 -0700] discovery.php(12283): ====== Schema update 223 -> 224 ============== [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` ADD `last_ok` INT NULL AFTER `last_recovered` ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1114) The table '#sql-42b4_3c28dc' is full [2015/08/21 09:48:29 -0700] discovery.php(12283): Query: ALTER TABLE `alert_table-state` CHANGE `last_checked` `last_checked` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_changed` `last_changed` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_recovered` `last_recovered` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_ok` `last_ok` INT( 10 ) NULL DEFAULT NULL , CHANGE `last_failed` `last_failed` INT( 10 ) NULL DEFAULT NULL ; [2015/08/21 09:48:29 -0700] discovery.php(12283): Error: (1054) Unknown column 'last_ok' in 'alert_table-state' Thank You Sholom Shapiro | Senior Systems Engineer Viking Technology Partners sholom(a)vikingtech.consulting 310.948.2438 Viking Technology Partners 10501 W. Gowan Road, Suite 170 Las Vegas, Nevada 89129 vikingtech.consulting <http://www.vikingtech.consulting> @vikingtechs <https://twitter.com/VikingTechs>

2 3

Re: [Observium] Link to device - Feature request
by Tom Laermans 21 Aug '15

21 Aug '15

I've actually come accross quite a few devices that specify configured telnet and http ports and the like in their snmp tree, we could definitely make use of those. So whoever decides to code this up (i'm on vacation this week) please leave room for custom ports in the database ;) Tom On Aug 11, 2015 2:15 PM, Jason Lixfeld <jason(a)lixfeld.ca> wrote: > > You know, I'm actually disgusted with myself for doing that. One of my biggest pet peeves is txt shorthand, in any sort of correspondence. It's lazy and insulting. Yet I just did it myself. > > Sorry Observium. I still love you :) > > Sent from my iPhone > > On Aug 11, 2015, at 8:02 AM, Adam Armstrong <adama(a)memetic.org> wrote: > >> Also, I think we might officially rename Observium to O, since its much easier to type :D >> >> Adam. >> >> Sent with AquaMail for Android >> http://www.aqua-mail.com >> >> On 11 August 2015 12:33:41 pm Jason Lixfeld <jason(a)lixfeld.ca> wrote: >>> >>> I agree, less is more, but how would O determine what to use on devices that were routers or switches or something that had WebUI and/or telnet and/or ssh CLI, where either one was user configurable? >>> >>> Perhaps a configurable default; an array that you could specify OS' and/or host names? Ya, fuck me too. That's getting complicated :) >>> >>> I guess as long as there is room for it in the database, it'd be trivial to run a post-discovery script to add whatever URL was appropriate if you wanted to overwrite whatever O thought was an acceptable default. >>> >>> /finding my rock again... :) >>> >>> Sent from my iPhone >>> >>> On Aug 11, 2015, at 7:11 AM, Adam Armstrong <adama(a)memetic.org> wrote: >>> >>>> I'd prefer if they were only shown on devices wo which they applied, so I think I'd make them an OS type attribute, so you'd only show rdp on windows, etc. >>>> >>>> Adam. >>>> >>>> Sent with AquaMail for Android >>>> http://www.aqua-mail.com >>>> >>>> On 11 August 2015 12:04:37 pm Attila Nagy <tylla_at_memetic.org(a)tylla.hu> wrote: >>>>> >>>>> The solution below is a really constrained (only on Windows, only IE, only with putty and only putty put on the root of the C: drive). >>>>> >>>>> I would think a simple ssh://host.domain.name link would suffice. >>>>> >>>>> And if possible rdp:// http:// vnc:// and maybe smb:// links should accompany the ssh entry. >>>>> >>>>> And the drop down menu would be perfect, it shouldn't take too much space, but be available. >>>>> >>>>> On 2015-08-11 12:49, chott(a)praha1.net wrote: >>>>>> >>>>>> Some idea from my colleague >>>>>> >>>>>> >>>>>> <html> >>>>>> <head> >>>>>> <script type="text/javascript"> >>>>>> function runProgram() >>>>>> { >>>>>> var shell = new ActiveXObject("WScript.Shell"); >>>>>> shell.Run("\"C:\\putty.exe\" 176.101.147.218"); >>>>>> } >>>>>> </script> >>>>>> </head> >>>>>> >>>>>> <body> >>>>>> <a href="javascript:runProgram()">Run program</a> >>>>>> </body> >>>>>> </html> >>>>>> >>>>>> >>>>>> >>>>>> Tomas Chott >>>>>> technický ředitel >>>>>> >>>>>> chott(a)praha1.net >>>>>> Phone: +420 245 004 005 >>>>>> Mobile: +420 604 930 119 >>>>>> >>>>>> Metropolitní síť Praha 1 z.s.p.o. >>>>>> Jindrisska 18 >>>>>> 110 00 Praha 1 >>>>>> Czech Republic >>>>>> www.praha1.net >>>>>> >>>>>> ________________________________ >>>>>> Od: observium [observium-bounces(a)observium.org] za uživatele chott(a)praha1.net [chott(a)praha1.net] >>>>>> Odesláno: 11. srpna 2015 12:43 >>>>>> Komu: Observium Network Observation System >>>>>> Předmět: Re: [Observium] Link to device - Feature request >>>>>> >>>>>> Yes :-) >>>>>> >>>>>> now we are using Observium for inventory and now i must find specific switch in Observium, copy link or opne NEw Tab and get Config. >>>>>> >>>>>> What about space nex to RAW DATA >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Tomas Chott >>>>>> technický ředitel >>>>>> >>>>>> chott(a)praha1.net >>>>>> Phone: +420 245 004 005 >>>>>> Mobile: +420 604 930 119 >>>>>> >>>>>> Metropolitní síť Praha 1 z.s.p.o. >>>>>> Jindrisska 18 >>>>>> 110 00 Praha 1 >>>>>> Czech Republic >>>>>> www.praha1.net >>>>>> >>>>>> ________________________________ >>>>>> Od: observium [observium-bounces(a)observium.org] za uživatele Jason Lixfeld [jason(a)lixfeld.ca] >>>>>> Odesláno: 11. srpna 2015 12:39 >>>>>> Komu: Observium Network Observation System >>>>>> Předmět: Re: [Observium] Link to device - Feature request >>>>>> >>>>>> Perfect timing. I was just recently thinking about how convenient it would be to be able to do one-click to connect to a device. >>>>>> >>>>>> :) >>>>>> >>>>>> Sent from my iPhone >>>>>> >>>>>> On Aug 11, 2015, at 6:25 AM, Adam Armstrong <adama(a)memetic.org> wrote: >>>>>> >>>>>>> We have limited space on the device navbar, but we could perhaps put these in a drop-down menu from an icon >>>>>>> >>>>>>>> On 11/08/2015 11:23:47, chott(a)praha1.net <chott(a)praha1.net> wrote: >>>>>>>> >>>>>>>> Hello team, >>>>>>>> >>>>>>>> i have question about create link in observium for open in new tab GUI of device config >>>>>>>> >>>>>>>> for example if iam in Device Overview, create some Icon or Text link to open New Tab for Device GUI configuration HTTP? Or SSH plugin https://addons.mozilla.org/EN-us/firefox/addon/firessh/ >>>>>>>> >>>>>>>> Tom >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Tomas Chott >>>>>>>> technický ředitel >>>>>>>> >>>>>>>> chott(a)praha1.net >>>>>>>> Phone: +420 245 004 005 >>>>>>>> Mobile: +420 604 930 119 >>>>>>>> >>>>>>>> Metropolitní síť Praha 1 z.s.p.o. >>>>>>>> Jindrisska 18 >>>>>>>> 110 00 Praha 1 >>>>>>>> Czech Republic >>>>>>>> www.praha1.net >>>>>>> >>>>>>> _______________________________________________ >>>>>>> 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 >>>>>> >>>>> >>>>> _______________________________________________ >>>>> 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 >>> >>> _______________________________________________ >>> 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

4 4

Sorting by OS
by chott＠praha1.net 21 Aug '15

21 Aug '15

Hello team today i can make list of my Mikrotik device and sort by Version and prepare upgrade but GUI doesnt sort :-) or i means if i set A-Z by OS, observim list device from Oldest to newest,,, Tom [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 604 930 119 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

2 3

Wireless Support Cisco WLC
by Basile Bluntschli 21 Aug '15

21 Aug '15

Hi Team a few ages ago there was a poll from Adam about which Wireless System should be supported. Since then I have not seen any progress on Cisco WLC. Is there anything in the works? Would SNMP access help? Thanks Basile

6 8

Show suppressed alerts only
by Andre Geißler 21 Aug '15

21 Aug '15

Hi In Alert Overview it is possible to select Failed Only. Could you add a Supressed Only too? Regards, Andre

2 2

Alert Contact and Observium User Management
by chott＠praha1.net 21 Aug '15

21 Aug '15

Hello team, are you plaining connection Alert to Observium User Management people? My idea is in attached screen lot of people which has access to Observium we can pair with some Alert, now we creating duplicate Contacts Tom [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 604 930 119 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

2 2

Billing bi-directional
by Chen Reshef 20 Aug '15

20 Aug '15

Hi, I'm checking the billing module now, and I wondered. Can I configure different commit value for each direction ? (outbound/inbound) Thanks, Chen --------------------------------------------------------------------------------------------------------------- This e-mail message may contain confidential, commercial and privileged information or data that constitute proprietary information of Cellcom Israel Ltd. Any review or distribution by others is strictly prohibited. If you are not the intended recipient you are hereby notified that any use of this information or data by any other person is absolutely prohibited. If you are not the intended recipient, please delete all copies. Thank You. http://www.cellcom.co.il

2 2

Reset interface counters
by David Hulth 20 Aug '15

20 Aug '15

Hi, If I reset the port-counters in a switch, would that throw off Observium port graphs in any way? Thanks -- David Hulth Lab Technician Procera Networks AB

3 4

VB: I broke my Observium when changing in the config, php file and now nothing works
by Simarpal Rooprai 20 Aug '15

20 Aug '15

Skickat: den 19 augusti 2015 15:20 Till: Observium Network Observation System Ämne: I broke my Observium when changing in the config,php file and now nothing works So as the title reads, my observium which was working 2 hours ago does not any more. I cant seem to find what the problem with the config file is so I need some help. Please note im not a PHP guy but a networking guy. When browsing to the site all that is shown is is the config file in txt form. See in attached files. I think I removed something fron the config frontpage but I cant seem to find what.... Also tried googling but did not find anything regarding this. Can someone please help ? Find the PHP.config attached. Thank you Best regards / Med vänlig hälsning Simarpal Rooprai Technical Service Engineer simarpal.rooprai(a)networkservices.se<mailto:simarpal.rooprai@networkservices.se> mobile +46 (0) 723 73 21 20. NETWORK SERVICES NORDEN AB Fosievägen 13, SE-214 31 Malmö, Sweden. Phone +46 (0)8-410 231 17. www.networkservices.se<http://www.networkservices.se/> "ENABLING EVERYDAY COMMUNICATION" [cid:EAE04F13-BA46-427C-A29B-F1425DF22D4F@ideon.se]

2 2

Definition of Device type
by chott＠praha1.net 20 Aug '15

20 Aug '15

Hi team, what is definition for Device type? For example now i adding NanoBeam and NanoBridge to Observium and Device type is Network, but for me ...NanoBeam is Wirelless Tom [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 604 930 119 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

4 9