October 2007 - Nav-users - lister.unit.no

deb woes
by prieheck＠iwu.edu 31 Oct '07

31 Oct '07

On Wed, 2007-10-31 at 17:42 +0100, Morten Werner Forsbring wrote: > Pat Riehecky <prieheck(a)iwu.edu> writes: > > > I have setup the mirror in the documentation to get the 3.3 nav package, > > but luck is not on my side. > > > > Setting up nav (2+3.3.0-2) ... > > dpkg: error processing nav (--configure): > > subprocess post-installation script returned error exit status 1 > > Errors were encountered while processing: > > nav > > E: Sub-process /usr/bin/dpkg returned an error code (1) > > > > > > any ideas? > > This was my fault with a typo in one of the maintainer scripts. Please > try again now with 2+3.3.0-4. > > > - Werner > Hurray!!! It dumped a few warnings, but nothing halted its progress. I have attached them if you care, if not it is on 12k of wasted space on the internets. Pat

1 0

Home > IP Device Center > Services - "We're terribly sorry"
by morten.brekkevold＠uninett.no 31 Oct '07

31 Oct '07

Ingeborg Hellemo <Ingeborg.Hellemo(a)cc.uit.no> writes: > morten.brekkevold(a)uninett.no said: >> Ingeborg, if you can, please try the attached patch for this problem (I have >> no Postgres 8.2 to test on). > > Nope. We are still sorry. This time because of one escape too many. [snip] > WHERE key='serviceid' and value IN (''1','6','2','8','4','5','3'') That doesn't make sense. I took a look at servicetable.py on po, and it doesn't match servicetable.py from the current trunk or NAV 3.3. A few lines below the patched line, it contains the following: WHERE key='serviceid' and value IN (\'%s\')""" % serviceIDs This extra quote must have been added by you or someone else; it breaks both my patch and the original functionality. -- mvh Morten Brekkevold UNINETT >From prieheck at iwu.edu Tue Oct 30 10:20:17 2007 From: prieheck at iwu.edu (Pat Riehecky) Date: Tue Oct 30 16:20:15 2007 Subject: [Nav-users] deb woes Message-ID: <1193757617.6102.20.camel(a)thales.iwu.edu> I have setup the mirror in the documentation to get the 3.3 nav package, but luck is not on my side. Setting up nav (2+3.3.0-2) ... dpkg: error processing nav (--configure): subprocess post-installation script returned error exit status 1 Errors were encountered while processing: nav E: Sub-process /usr/bin/dpkg returned an error code (1) any ideas?

2 2

AlertEngine - delayed alerts, something is not right
by Ingeborg.Hellemo＠cc.uit.no 31 Oct '07

31 Oct '07

(My mission this week is to keep you occupied with new bugs) I have made a nightly profile which is supposed to send alerts immediately via email and delayed (Daily queue) to my phone. Something is happening with queuing/deleting alerts which makes me receive two emails and I am not sure if I would have received any sms in the morning. (Today I wasn't supposed to because all downs were canceled by ups). >From alertengine.log: Wed Oct 31 04:08:57 2007 alertEngine NewAlerts-7-collectInfo: found 1 new alerts Wed Oct 31 04:08:57 2007 alertEngine QueuedAlerts-7-collectInfo: collecting info about queued alerts Wed Oct 31 04:08:57 2007 alertEngine User-7-checkAlertQueue: borge(1000); Checking queued alerts for user Wed Oct 31 04:08:57 2007 alertEngine User-7-checkNewAlerts: borge(1000); Processing new alerts for user Wed Oct 31 04:08:57 2007 alertEngine User-7-checkRights: borge(1000); Checking rights for user Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkAlert: checking to see if alertid 4819 is in equipmentgroup 71 Wed Oct 31 04:08:57 2007 alertEngine Alert-7-getInfo: collecting info from table alertq column severity Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkMatch: datatype=1 type=4 value=100 info=50 ret=1 Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkAlert: Alertid 4819 is in equipmentgroup 71 Wed Oct 31 04:08:57 2007 alertEngine User-7-checkActiveProfile: borge(1000); Checking active profile for user Wed Oct 31 04:08:57 2007 alertEngine User-7-collectTimePeriod: borge(1000); No time period available Wed Oct 31 04:08:57 2007 alertEngine User-7-checkAlertQueue: ingeborg(1001); Checking queued alerts for user Wed Oct 31 04:08:57 2007 alertEngine User-7-checkNewAlerts: ingeborg(1001); Processing new alerts for user Wed Oct 31 04:08:57 2007 alertEngine User-7-checkRights: ingeborg(1001); Checking rights for user Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkAlert: checking to see if alertid 4819 is in equipmentgroup 71 Wed Oct 31 04:08:57 2007 alertEngine Alert-7-getInfo: collecting info from table alertq column severity Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkMatch: datatype=1 type=4 value=100 info=50 ret=1 Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkAlert: Alertid 4819 is in equipmentgroup 71 Wed Oct 31 04:08:57 2007 alertEngine User-7-checkActiveProfile: ingeborg(1001); Checking active profile for user Wed Oct 31 04:08:57 2007 alertEngine User-7-collectTimePeriod: ingeborg(1001); Collected 2 alarm addresses Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkAlert: checking to see if alertid 4819 is in equipmentgroup 69 Wed Oct 31 04:08:57 2007 alertEngine Alert-7-getInfo: collecting info from table cat column catid Wed Oct 31 04:08:57 2007 alertEngine Alert-7-collecttable: collecting info from table: select c.* from cat c, netbox n where n.netboxid=136 and n.catid=c.catid Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkMatch: datatype=0 type=0 value=SRV info=SRV ret=1 Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkAlert: Alertid 4819 is in equipmentgroup 69 Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkAlert: checking to see if alertid 4819 is in equipmentgroup 69 Wed Oct 31 04:08:57 2007 alertEngine Alert-7-getInfo: collecting info from table cat column catid Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkMatch: datatype=0 type=0 value=SRV info=SRV ret=1 Wed Oct 31 04:08:57 2007 alertEngine EquipmentGroups-7-checkAlert: Alertid 4819 is in equipmentgroup 69 Wed Oct 31 04:08:57 2007 alertEngine User-6-sendEmail: ingeborg(1001); EMAIL ingeborg.hellemo(a)cc.uit.no Subject: Service http is down on adbweb.uit.no Wed Oct 31 04:09:08 2007 alertEngine User-6-queueAlert: ingeborg(1001); Queued alert 4819 to address 1005 Wed Oct 31 04:10:08 2007 alertEngine NewAlerts-7-collectInfo: found 0 new alerts Wed Oct 31 04:10:08 2007 alertEngine QueuedAlerts-7-collectInfo: collecting info about queued alerts Wed Oct 31 04:10:08 2007 alertEngine User-7-checkAlertQueue: borge(1000); Checking queued alerts for user Wed Oct 31 04:10:08 2007 alertEngine User-7-checkAlertQueue: ingeborg(1001); Checking queued alerts for user Wed Oct 31 04:10:08 2007 alertEngine User-7-checkAlertQueue: ingeborg(1001); Checking queued alert 0 Wed Oct 31 04:10:08 2007 alertEngine User-7-checkActiveProfile: ingeborg(1001); Checking active profile for user Wed Oct 31 04:10:08 2007 alertEngine User-7-collectTimePeriod: ingeborg(1001); Collected 2 alarm addresses Wed Oct 31 04:10:08 2007 alertEngine EquipmentGroups-7-checkAlert: checking to see if alertid 4819 is in equipmentgroup 69 Wed Oct 31 04:10:08 2007 alertEngine Alert-7-getInfo: collecting info from table cat column catid Wed Oct 31 04:10:08 2007 alertEngine Alert-7-collecttable: collecting info from table: select c.* from cat c, netbox n where n.netboxid=136 and n.catid=c.catid Wed Oct 31 04:10:08 2007 alertEngine EquipmentGroups-7-checkMatch: datatype=0 type=0 value=SRV info=SRV ret=1 Wed Oct 31 04:10:08 2007 alertEngine EquipmentGroups-7-checkAlert: Alertid 4819 is in equipmentgroup 69 Wed Oct 31 04:10:08 2007 alertEngine EquipmentGroups-7-checkAlert: checking to see if alertid 4819 is in equipmentgroup 69 Wed Oct 31 04:10:08 2007 alertEngine Alert-7-getInfo: collecting info from table cat column catid Wed Oct 31 04:10:08 2007 alertEngine EquipmentGroups-7-checkMatch: datatype=0 type=0 value=SRV info=SRV ret=1 Wed Oct 31 04:10:08 2007 alertEngine EquipmentGroups-7-checkAlert: Alertid 4819 is in equipmentgroup 69 Wed Oct 31 04:10:08 2007 alertEngine User-6-sendEmail: ingeborg(1001); EMAIL ingeborg.hellemo(a)cc.uit.no Subject: Service http is down on adbweb.uit.no Wed Oct 31 04:10:10 2007 alertEngine QueuedAlerts-7-deleteAlert: deleting queued alert 0 Wed Oct 31 04:10:10 2007 alertEngine Alert-7-delete: deleted alertqid=4819 --Ingeborg -- Ingeborg ?strem Hellemo -- ingeborg(a)cc.uit.no (Univ. of Troms?, Norway)

1 0

Home > IP Device Center > Services - "We're terribly sorry"
by morten.brekkevold＠uninett.no 30 Oct '07

30 Oct '07

Ingeborg Hellemo <Ingeborg.Hellemo(a)cc.uit.no> writes: > https://<nav-host>/browse/service/ looks like this: > > All services > dns (3) > ftp (1) > http (15) > https (4) > ... > > > If i click one of the services with a count larger than 1 i get [...] > ProgrammingError: ERROR: IN types character varying and integer cannot be > matched [...] > Please fix. This appears to related to the same problem reported in this bug: http://sourceforge.net/tracker/index.php?func=detail&aid=1792351&group_id=1… I.e. stricter type checking in PostgreSQL 8.2. I don't know whether there might be an option in postgresql.conf which allows you to reduce the strictness as a workaround, though. I've posted the bug here: http://sourceforge.net/tracker/index.php?func=detail&aid=1822760&group_id=1… -- mvh Morten Brekkevold UNINETT >From morten.brekkevold at uninett.no Tue Oct 30 14:42:23 2007 From: morten.brekkevold at uninett.no (Morten Brekkevold) Date: Tue Oct 30 14:42:28 2007 Subject: [Nav-users] Home > IP Device Center > Services - "We're terribly sorry" In-Reply-To: <yyl7il4vj1x.fsf(a)voldsminde.uninett.no> (Morten Brekkevold's message of "Tue, 30 Oct 2007 14:16:58 +0100") References: <200710291222.l9TCM0oV047496(a)barnetv.cc.uit.no> <yyl7il4vj1x.fsf(a)voldsminde.uninett.no> Message-ID: <yyl1wbcvhvk.fsf(a)voldsminde.uninett.no> Morten Brekkevold <morten.brekkevold(a)uninett.no> writes: > I.e. stricter type checking in PostgreSQL 8.2. I don't know whether > there might be an option in postgresql.conf which allows you to reduce > the strictness as a workaround, though. > > I've posted the bug here: > http://sourceforge.net/tracker/index.php?func=detail&aid=1822760&group_id=1… Ingeborg, if you can, please try the attached patch for this problem (I have no Postgres 8.2 to test on). -- mvh Morten Brekkevold UNINETT

1 0

PHP-errors from AlertProfiles
by Ingeborg.Hellemo＠cc.uit.no 30 Oct '07

30 Oct '07

morten.brekkevold(a)uninett.no said: > I think he based this on the fact that whatever error messages Alert Profiles > spat at us under PHP5, anything we did in the Alert Profiles interface would > still work as before. > Are your changes saved properly, despite the errors? Yes, I later found out that everything works, you just have to ignore the large yellow warning signs. --Ingeborg -- Ingeborg ?strem Hellemo -- ingeborg(a)cc.uit.no (Univ. of Troms?, Norway)

2 1

smsd is throwing exceptions at me
by Ingeborg.Hellemo＠cc.uit.no 30 Oct '07

30 Oct '07

morten.brekkevold(a)uninett.no said: > 1. Set loglevel: DEBUG >From etc/smsd.conf # Logging settings # Valid options are DEBUG, INFO, WARNING, ERROR, CRITICAL loglevel: DEBUG morten.brekkevold(a)uninett.no said: > 2. Restarted smsd? /#/usr/local/nav/bin/nav start smsd Starting: smsd morten.brekkevold(a)uninett.no said: > 3. Watched smsd.log until a message has been attempted dispatched? /#tail smsd.log [2007-10-30 12:09:27,590] [DEBUG] [pid=2062 nav.smsd] Starting loop. [2007-10-30 12:09:27,633] [INFO] [pid=2062 nav.smsd] Found 1 user(s) with unsent messages. [2007-10-30 12:09:27,636] [INFO] [pid=2062 nav.smsd] Found 12 unsent message(s) for 98668305. [2007-10-30 12:09:27,636] [CRITICAL] [pid=2062 nav.smsd] Sending failed permanently. Exiting. (No dispatchers available. None configured or all dispatchers failed permanently. After this smsd dies. Before i changed smsd.conf the [DEBUG]-line was missing. But nothing from dispatcher.py or gammudispatcher.py --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg(a)cc.uit.no (Univ. of Tromsø, Norway)

1 0

snmptrapd with ImportError
by morten.brekkevold＠uninett.no 30 Oct '07

30 Oct '07

Ingeborg Hellemo <Ingeborg.Hellemo(a)cc.uit.no> writes: > The module is where it is supposed to be, > PYTHONPATH=/usr/local/nav/lib/python. Other python-parts of NAV is > working as expected (or at least not complaining about missing > modules...). > > Morten, you have a user on po.uit.no. Feel free to poke around. Thanks, I had a poke, and now I know what the problem is. Your immediate fix is to do the following as root: touch /usr/local/nav/lib/python/nav/snmptrapd/__init__.py which will make Python actually recognize nav.snmptrapd as a proper Python package. The reason I was unable to reproduce the problem on my end was that I assumed this occurred when you started the daemon, but it seems it actually occurs every time a trap is received (and I had nothing configured to send traps to my daemon). The problem being that snmptrapd imports the handler modules every time it receives a trap, and not just once at the start of the process (which I think it should). I've filed this as two separate bugs in the tracker: 1. http://sourceforge.net/tracker/index.php?func=detail&aid=1822650&group_id=1… 2. http://sourceforge.net/tracker/index.php?func=detail&aid=1822651&group_id=1… -- mvh Morten Brekkevold UNINETT >From morten.brekkevold at uninett.no Tue Oct 30 11:07:04 2007 From: morten.brekkevold at uninett.no (Morten Brekkevold) Date: Tue Oct 30 11:07:07 2007 Subject: [Nav-users] Nagios+lampp In-Reply-To: <Pine.LNX.4.64.0710261910340.3828(a)tyholt.uninett.no> (Vidar Faltinsen's message of "Fri, 26 Oct 2007 19:11:39 +0200 (CEST)") References: <20071026092109.wzj2jfan2c08084s(a)charlie.vbnet.com.br> <Pine.LNX.4.64.0710261910340.3828(a)tyholt.uninett.no> Message-ID: <yylabq0x6ev.fsf(a)voldsminde.uninett.no> Vidar Faltinsen <vidar.faltinsen(a)uninett.no> writes: > On Fri, 26 Oct 2007, marcos.sandrini(a)embryo.com.br wrote: > >> Bom dia! > > Bom dia, to you, too! Hi Marcos, I think what Vidar is trying to say, is that nobody on this list can read Portugese, so if you really want an answer, you should try again in English :-) -- mvh Morten Brekkevold UNINETT >From morten.brekkevold at uninett.no Tue Oct 30 11:13:59 2007 From: morten.brekkevold at uninett.no (Morten Brekkevold) Date: Tue Oct 30 11:14:01 2007 Subject: [Nav-users] PHP-errors from AlertProfiles In-Reply-To: <200710260823.l9Q8N64N014697(a)barnetv.cc.uit.no> (Ingeborg Hellemo's message of "Fri, 26 Oct 2007 10:23:06 +0200") References: <200710260823.l9Q8N64N014697(a)barnetv.cc.uit.no> Message-ID: <yyl3avsx63c.fsf(a)voldsminde.uninett.no> Ingeborg Hellemo <Ingeborg.Hellemo(a)cc.uit.no> writes: > NAV 3.3.0 and php5 > > > If I try to add a new profile I get: > > AlertProfiles PHP Errorhandler [snip] > Any ideas? I had a chat with Arne, one of the original developers of the alert system (since I haven't touched PHP in many years now), as we tried to upgrade to PHP5. He suggested that these errors had been present all along, but that previous php versions suppressed them by default. I think he based this on the fact that whatever error messages Alert Profiles spat at us under PHP5, anything we did in the Alert Profiles interface would still work as before. Are your changes saved properly, despite the errors? -- mvh Morten Brekkevold UNINETT >From morten.brekkevold at uninett.no Tue Oct 30 11:35:18 2007 From: morten.brekkevold at uninett.no (Morten Brekkevold) Date: Tue Oct 30 11:35:43 2007 Subject: [Nav-users] smsd is throwing exceptions at me In-Reply-To: <200710300901.l9U91Pvl076327(a)barnetv.cc.uit.no> (Ingeborg Hellemo's message of "Tue, 30 Oct 2007 10:01:25 +0100") References: <200710300901.l9U91Pvl076327(a)barnetv.cc.uit.no> Message-ID: <yylve8ovqjd.fsf(a)voldsminde.uninett.no> Ingeborg Hellemo <Ingeborg.Hellemo(a)cc.uit.no> writes: > Ingeborg.Hellemo(a)cc.uit.no said: >> How can I turn on more debugging? > > I have put > loglevel: DEBUG > into etc/smsd.conf, but this only makes a difference in logging from > /usr/local/nav/bin/smsd.py. I still don't see any log messages from > dispatcher.py You have of course: 1. Set loglevel: DEBUG 2. Restarted smsd? 3. Watched smsd.log until a message has been attempted dispatched? I do get log messages from nav.smsd.dispatcher here when debug logging is turned on. -- mvh Morten Brekkevold UNINETT >From Ingeborg.Hellemo at cc.uit.no Tue Oct 30 12:01:08 2007 From: Ingeborg.Hellemo at cc.uit.no (Ingeborg Hellemo) Date: Tue Oct 30 12:01:14 2007 Subject: [Nav-users] snmptrapd with ImportError In-Reply-To: Your message of "Tue, 30 Oct 2007 11:03:16 +0100." <yylfxzsx6l7.fsf(a)voldsminde.uninett.no> Message-ID: <200710301101.l9UB18tK078731(a)barnetv.cc.uit.no> morten.brekkevold(a)uninett.no said: > Your immediate fix is to do the following as root: > touch /usr/local/nav/lib/python/nav/snmptrapd/__init__.py > which will make Python actually recognize nav.snmptrapd as a proper Python > package. Cool! Then we immediately move on to new interesting errors. Now we have a "TypeError": [2007-10-30 11:54:14,375] [DEBUG] [pid=1422 nav.snmptrapd.linkupdown] Module linkupdown got trap .1.3.6.1.6.3.1.1.5.3 LINKDOWN [2007-10-30 11:54:14,376] [DEBUG] [pid=1422 nav.snmptrapd.linkupdown] SELECT netboxid, vendorid FROM netbox LEFT JOIN type USING (typeid) WHERE ip = %s [2007-10-30 11:54:14,377] [DEBUG] [pid=1422 nav.snmptrapd.linkupdown] SELECT swportid, module.deviceid, module.module, swport.interface FROM netbox LEFT JOIN module USING (netboxid) LEFT JOIN swport USING (moduleid) WHERE ip=%s AND ifindex = %s [2007-10-30 11:54:14,379] [ERROR] [pid=1422 nav.snmptrapd] Error when handling trap with nav.snmptrapd.handlers.linkupdown: unsubscriptable object Traceback (most recent call last): File "/usr/local/nav/bin/snmptrapd.py", line 300, in trapHandler accepted = mod.handleTrap(trap, config=config) File "/usr/local/nav/lib/python/nav/snmptrapd/handlers/linkupdown.py", line 110, in handleTrap subid = idres['swportid'] TypeError: unsubscriptable object

1 0

Ranked Statistics: 12334963.32 percent
by Ingeborg.Hellemo＠cc.uit.no 30 Oct '07

30 Oct '07

12334963.32 percent is a nice number if you talk about increase in wages, but not if you talk about mortgage rates or CPU load. Something is wrong with our "Ranked Statistics". Top 20 CPU Routers show 6 boxes with impossible values, but if i click on the "Target"-link, the graph shows normal values (but not high enough to put it into Top 20). The rest of the boxes show normal values. The other views shows just as erroneous behaviour. Is this a result of us using RRDtool version 1.2.23? --Ingeborg -- Ingeborg ?strem Hellemo -- ingeborg(a)cc.uit.no (Univ. of Troms?, Norway)

2 1

snmptrapd with ImportError
by Ingeborg.Hellemo＠cc.uit.no 29 Oct '07

29 Oct '07

/#tail /usr/local/nav/var/log/snmptrapd.log [2007-10-12 09:49:46,546] [ERROR] [pid=6655 nav.snmptrapd] Module nav.snmptrapd.handlers.linkupdown did not compile - No module named snmptrapd.handlers.linkupdown Traceback (most recent call last): File "/usr/local/nav/bin/snmptrapd.py", line 293, in trapHandler mod = __import__(name, globals(), locals(), [parent]) ImportError: No module named snmptrapd.handlers.linkupdown [2007-10-12 09:49:46,547] [ERROR] [pid=6655 nav.snmptrapd] Module nav.snmptrapd.handlers.airespace did not compile - No module named snmptrapd.handlers.airespace Traceback (most recent call last): File "/usr/local/nav/bin/snmptrapd.py", line 293, in trapHandler mod = __import__(name, globals(), locals(), [parent]) ImportError: No module named snmptrapd.handlers.airespace Any ideas? NAV 3.3.0 FreeBSD 6.2-RELEASE-p7 /#pkg_info | grep py mod_python-3.3.1 Apache module that embeds the Python interpreter within the py24-cheetah-2.0.r7 HTML template engine for Python py24-forgethtml-20041021 Python module for object-oriented HTML generation py24-forgetsql-0.5.1 Python module for object-oriented access to SQL databases py24-ipy-0.55 A Python module for handling IPv4 and IPv6 Addresses and Ne py24-ldap2-2.3 An LDAP module for python, for OpenLDAP2 py24-mx-base-2.0.6 The eGenix mx-Extension Series for Python py24-psycopg-1.1.21 The high performance Python adapter for PostgreSQL py24-rrdtool_lgpl-0.2.1_1 Python interface to RRDTool, the graphing and logging utili py24-setuptools-0.6c7 Download, build, install, upgrade, and uninstall Python pac py24-snmp2-2.0.9 SNMP framework for Python python24-2.4.4_1 An interpreted object-oriented programming language --Ingeborg -- Ingeborg ?strem Hellemo -- ingeborg(a)cc.uit.no (Univ. of Troms?, Norway)

2 1

Nagios+lampp
by marcos.sandrini＠embryo.com.br 26 Oct '07

26 Oct '07

Bom dia! Por favor, alguem sabe se ? poss?vel usar o Nagios com o Lampp (ou xampp)? Gostaria tamb?m de saber se eu conseguiria com esta combina??o (Lampp+Nagios) usar o Oreon pra frontend. Obrigado a todos Marcos

2 1