Nav-users

nav-users@lister.sikt.no

1 participants
1378 discussions

Urgent: SMS sending problem
by roger.aas＠hsh.no 05 Okt '05

05 Okt '05

I was planning to get NAV 3 into service soon. So the next thing I needed to test is that NAV sends SMS'es to the person that is on duty. But I do not get this to work. Everytime I start NAV I get an email like this: > From: navcron(a)nav3.hsh.no > To: roger(a)hsh.no > Subject: smsd database connection problem > > > Status: 03.10.2005 10:29:13 PG_conn=SCALAR(0x826d464) 1 Reset > > Error was: > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. The gammu program by itself works. I can do a command like this: echo Test | gammu nothing --sendsms TEXT 91799053 and I receive an SMS. If I use the test functionality of smsd.pl like this: /usr/local/nav/bin/smsd.pl -t 91799053 I do _not_ get an SMS and it prints just a "0" on the console. Can someone please help me with this. This is the function I need working to start using NAV 3. Best regards, Roger -- Roger Aas Stord/Haugesund College

1 1

Error in report tool "Trunked core switch ports"
by odd.hauge＠hiMolde.no 05 Okt '05

05 Okt '05

I'm having the same error messages as you Roger. I guess this can have something to do with the version of postgres we are using. I have installed Fedora Core 4 which comes with ver. 8.0.3 of postgres. I guess RHEL4 comes with ver 8 to. And I believe boolean expressions are handled in a different way in version 8 of postgres than in ver. 7. But I'm not a database expert. But if you edit /usr/local/nav/etc/report/front.html and replaces trunk=1 with trunk=t in line 80 the report works. The other "error" you reported earlier can be avoid by editing /usr/local/nav/etc/report/report.conf. Change line 290 from: GROUP BY roomid,sysname,host(ip),catid,orgid,val,netbox.netboxid,prefixid"; to GROUP BY roomid,sysname,host(ip),catid,orgid,val,netbox.netboxid,netbox.ip,prefix id"; Nice if someone of the devolpers can comment this. Cheers Odd Arne Hauge Molde University College > -----Original Message----- > From: nav-users-bounces(a)itea.ntnu.no > [mailto:nav-users-bounces@itea.ntnu.no] On Behalf Of Roger Aas > Sent: Monday, October 03, 2005 1:34 PM > To: nav-users(a)itea.ntnu.no > Subject: [Nav-users] Error in report tool "Trunked core switch ports" > > Nav version 3.0.0 > > "Toolbox -> Report -> Core Switches/Trunked core switch > ports" gives me this error: > > Configuration error! The report generator is not able to do > such things. > ERROR: operator does not exist: boolean = integer > HINT: No operator matches the given name and argument type(s). > You may need to add explicit type casts. > SELECT > b1.sysname,s1.interface,m1.module,s1.port,s1.link,s1.speed,s1. > duplex,s1.media,s1.trunk,vlan.vlan,s1.portname,b2.sysname > AS to_netboxid,m2.module AS > remote_module,s1.swportid,b1.netboxid AS netboxid,b1.catid > FROM swport AS s1 JOIN module AS m1 USING (moduleid) JOIN > netbox AS b1 USING (netboxid) LEFT JOIN netbox AS b2 ON > (to_netboxid=b2.netboxid) LEFT JOIN swportvlan ON > (s1.swportid=swportvlan.swportid AND (trunk=false OR trunk IS > NULL)) LEFT JOIN vlan using(vlanid) LEFT JOIN swport AS s2 ON > (s1.to_swportid=s2.swportid) LEFT JOIN module AS m2 ON > (s2.moduleid=m2.moduleid) WHERE s1.trunk = 1 AND b1.catid = 'SW' > ORDER BY b1.sysname,module,port LIMIT 100 OFFSET 0 > > I sent earlier an email about another error I got on another > report tool, when sorting on IP-address on servers. I have > not received any hints to what could be the problem there. > > httpd 2.0.52 > jakarta-tomcat 5.0.28 > java j2sdk1.4.2_08 > perl 5.8.5 > php 4.3.9 > postgresql 7.4.8 > python 2.3.4, mod_python 3.1.3 > > Regards, > Roger > > -- > Roger Aas > Stord/Haugesund College > > > _______________________________________________ > Nav-users mailing list > Nav-users(a)itea.ntnu.no > http://mailman.itea.ntnu.no/mailman/listinfo/nav-users >

3 2

Error in report tool "Trunked core switch ports"
by roger.aas＠hsh.no 03 Okt '05

03 Okt '05

Nav version 3.0.0 "Toolbox -> Report -> Core Switches/Trunked core switch ports" gives me this error: Configuration error! The report generator is not able to do such things. ERROR: operator does not exist: boolean = integer HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. SELECT b1.sysname,s1.interface,m1.module,s1.port,s1.link,s1.speed,s1.duplex,s1.media,s1.trunk,vlan.vlan,s1.portname,b2.sysname AS to_netboxid,m2.module AS remote_module,s1.swportid,b1.netboxid AS netboxid,b1.catid FROM swport AS s1 JOIN module AS m1 USING (moduleid) JOIN netbox AS b1 USING (netboxid) LEFT JOIN netbox AS b2 ON (to_netboxid=b2.netboxid) LEFT JOIN swportvlan ON (s1.swportid=swportvlan.swportid AND (trunk=false OR trunk IS NULL)) LEFT JOIN vlan using(vlanid) LEFT JOIN swport AS s2 ON (s1.to_swportid=s2.swportid) LEFT JOIN module AS m2 ON (s2.moduleid=m2.moduleid) WHERE s1.trunk = 1 AND b1.catid = 'SW' ORDER BY b1.sysname,module,port LIMIT 100 OFFSET 0 I sent earlier an email about another error I got on another report tool, when sorting on IP-address on servers. I have not received any hints to what could be the problem there. httpd 2.0.52 jakarta-tomcat 5.0.28 java j2sdk1.4.2_08 perl 5.8.5 php 4.3.9 postgresql 7.4.8 python 2.3.4, mod_python 3.1.3 Regards, Roger -- Roger Aas Stord/Haugesund College

1 0

[Nav-users] Alertengine email sender machine name != real machine name
by roger.aas＠hsh.no 29 Sep '05

29 Sep '05

I get this email from Alertengine: > X-Auth-No: > Return-Path: <navcron(a)nav3.hsh.no> > Received: from sentinel.hsh.no not authenticated [158.37.208.20] > by posthus.hsh.no with NetMail SMTP Agent $Revision: 3.22.1.16 $ on Novell NetWare; > Thu, 29 Sep 2005 10:41:26 +0200 > Received: from artifact.hsh.no ([158.37.35.10]) > by sentinel.hsh.no (SMSSMTP 4.1.7.33) with SMTP id M2005092910483300240 > for <roger(a)posthus.hsh.no>; Thu, 29 Sep 2005 10:48:33 +0200 > Received: from sentinel.hsh.no (sentinel.hsh.no [158.37.208.20]) > by artifact.hsh.no (8.9.3 (PHNE_28760)/8.9.3) with SMTP id KAA07954 > for <roger.aas(a)hsh.no>; Thu, 29 Sep 2005 10:48:33 +0200 (METDST) > Received: from nav3.hsh.no ([158.37.208.25]) > by sentinel.hsh.no (SMSSMTP 4.1.7.33) with SMTP id M2005092910483200238 > for <roger.aas(a)hsh.no>; Thu, 29 Sep 2005 10:48:32 +0200 > Received: from nav3.hsh.no (nav3.hsh.no [127.0.0.1]) > by nav3.hsh.no (8.13.1/8.13.1) with ESMTP id j8T8mWdi008206 > for <roger.aas(a)hsh.no>; Thu, 29 Sep 2005 10:48:32 +0200 > Received: (from navcron@localhost) > by nav3.hsh.no (8.13.1/8.13.1/Submit) id j8T8mWdW008203; > Thu, 29 Sep 2005 10:48:32 +0200 > Date: Thu, 29 Sep 2005 10:48:32 +0200 > Message-Id: <200509290848.j8T8mWdW008203(a)nav3.hsh.no> > From: alertengine(a)nav.hsh.no > To: roger.aas(a)hsh.no > Subject: Box haugesund-auditoriume-ap.hsh.no is up > > This is an automatically generated message from NAV: > > Box haugesund-auditoriume-ap.hsh.no (158.37.35.132) is up since 2005-09-29 10:48:09. As you can see it is only the "From:" header line that says "nav.hsh.no", the rest of the headers give the correct name for the server "nav3.hsh.no". Anyone know where this is happening? Some config I have missed? Or a small bug lurking somewhere? Or is it just a cosmetic thing since you are not supposed to answer such an email? Since I have called the NAV 2.1.5 server for nav.hsh.no it gave me a small moment of confusion... :-) - Roger -- Roger Aas Stord/Haugesund College

1 0

Error in report tool sorting on server ip
by roger.aas＠hsh.no 28 Sep '05

28 Sep '05

Nav version 3.0.0 "Toolbox -> Report -> Servers -> (Sort on) IP" gives me this error: Servers Configuration error! The report generator is not able to do such things. ERROR: column "netbox.ip" must appear in the GROUP BY clause or be used in an aggregate function SELECT roomid,sysname,host(ip),catid,orgid,count(distinct category) as subcats,count(serviceid) as services,val as function,netbox.netboxid,prefixid FROM netbox LEFT JOIN service USING (netboxid) LEFT JOIN netboxcategory USING (netboxid) LEFT JOIN netboxinfo ON (netboxinfo.netboxid=netbox.netboxid AND netboxinfo.var='function') WHERE catid='SRV' GROUP BY roomid,sysname,host(ip),catid,orgid,val,netbox.netboxid,prefixid ORDER BY ip,roomid LIMIT 100 OFFSET 0 This does not happen with the other categories like routers, core switches and wireless that I have in NAV now. - Roger -- Roger Aas Stord/Haugesund College

1 0

Upgrade guide?
by jsidwell＠perisys.net 19 Sep '05

19 Sep '05

Is there any documentation for upgrading from the beta to the 3.0 gold? Joshua Sidwell, CISSP 6021 S. Syracuse Way Suite 216 Greenwood Village, CO 80111 720-246-8953 office 720-222-0552 fax (303) 668 -3291 (Mobile) This email and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or proprietary material. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Perimeter Systems, Inc. Finally, the recipient should check this email and any attachments for the presence of viruses. Perimeter Systems, Inc. accepts no liability for any damage caused by any virus transmitted by this email.

1 0

Bugs?
by a.l.prois＠usit.uio.no 16 Sep '05

16 Sep '05

On Fri, 2 Sep 2005, Morten Vold wrote: > On 29/08/2005 13:11, Asbj?rn Pr?is uttered: > >> 4) LDAP auth >> I'm trying to get authentication through LDAP to work. Login fails >> with error message "unable to make contact with the DLAP server". >> Logs on the LDAP server doest show anything (seems like the NAV box >> doesnt make any contact at all), and since I'm no python coder I >> havent been able to reverse-engeneer the code to figure things out. >> Are there any documentation on the LDAP auth part somewhere? > > I assume you've entered the correct LDAP configuration in > etc/webfront/webfront.conf, and that your LDAP server is in fact > reachable from your NAV server? Does your LDAP server run on a > non-standard port? > > In retrospect, it's also clear that the LDAP authentication should be > even more configurable, as the code makes a few assumptions about which > attributes to use when binding to the LDAP server and to retrieve from > the LDAP user objects. Hello again. I finally made it work. UIOs ldap server doesn't accept uncrypted connections when authenticating a user/password. So after alot of testing it worked when openldap knew where to find the correct certificate. One problem occured though. If a person is hidden in the ldap-tree, the login-page return this error : --- snip --- Mod_python error: "PythonHandler mod_python.publisher" Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/usr/lib/python2.3/site-packages/mod_python/publisher.py", line 136, in handler result = util.apply_fs_data(object, req.form, req=req) File "/usr/lib/python2.3/site-packages/mod_python/util.py", line 361, in apply_fs_data return object(**args) File "/usr/local/nav/apache/webroot/index.py", line 136, in login fullName = ldapAuth.getUserName(login) File "/usr/local/nav/lib/python/nav/web/ldapAuth.py", line 97, in getUserName record = res[0][1] --- /snip --- -Asbj?rn- >From morten.vold at ntnu.no Fri Sep 16 17:19:47 2005 From: morten.vold at ntnu.no (Morten Vold) Date: Fri Sep 16 16:19:54 2005 Subject: [Nav-users] Release-notice: NAV 3.0.0 :-)) Message-ID: <432AD483.40701(a)ntnu.no> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 NAV 3.0.0 is now finally available for download at http://metanav.ntnu.no/ :-) CHANGES ======= Version 3.0.0 (released 16 September 2005) Improvements: * Fixed a bug in maintengine which prevented it from doing it's job when the database was busy/overloaded. * Fixed a bug in the integration between Alert Profiles (PHP) and the Cheetah templating system (Python), which would cause the Alert Profiles web interface to act up. * Character coding information added to all NAV-original Python programs. * Fixed a bug which cleared a user's password if the account editing form of Useradmin was submitted without changes. * NetworkDiscovery now only checks for closed vlans on active ports. * Fixed a NullPointerException in getDeviceData. * Fixed various problems with Cisco module/submodule translation in getDeviceData. * Fixed a AlertEngine/getDeviceData combination bug which caused AlertEngine to log loads of long error messages on events that lacked an alerttype suggestion. * New option to have AlertEngine log error messages to a separate error log. * AlertEngine now sends error alerts if an alerttype has no configured subject line in alertmsg.conf. * Added report shortcut to search for strings in prefix-netident (added to the front.html config file) * Added link from Report to the previously hidden feature "service matrix" of the IP Device Center (added to the front.html config file) - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDKtSDXxIl0kpcOkQRAn97AJ4kWvitADAuV5vXe3lyv3Y7AK3GQwCggq3h 1DjytJjsgjwDVoxX/NtOu14= =0fKm -----END PGP SIGNATURE----- >From roger.aas at hsh.no Sun Sep 18 03:56:55 2005 From: roger.aas at hsh.no (Roger Aas) Date: Sun Sep 18 02:57:03 2005 Subject: [Nav-users] NAV installation guide for Red Hat Enterprise Linux 4 changed to 3.0.0 release version Message-ID: <432CBB57.7030900(a)hsh.no> I have edited the step-by-step installation guide for NAV on Red Hat Enterprise Linux 4 to cover the 3.0.0 release version. You can find it here: http://metanav.ntnu.no/moin.cgi/InstallingOnRHEL4 Please give me feedback when you find errors or omissions so I can fix them. Or if you just want to comment it... :-) I hope this can be of help for someone. Regards, Roger -- Roger Aas Stord/Haugesund College

1 0

error editing device
by Pete.Hoffswell＠davenport.edu 14 Sep '05

14 Sep '05

I am trying to change the room on a device, and get the following error. It looks like a sql insert, shouldn't it be a modify? http://nav.davenport.edu/editdb/netbox/edit/52 Mod_python error: "PythonHandler editdb"Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 156, in handler output = editPage(req,pageList[table](),request,unicodeError) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 463, in editPage outputForm,action) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 2479, in add function) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 590, in insertNetbox ('netboxid','netbox_netboxid_seq')) File "/usr/local/nav/apache/webroot/editdb/editdbSQL.py", line 152, in addEntryFields executeSQL(sqllist) File "/usr/local/nav/apache/webroot/editdb/editdbSQL.py", line 39, in executeSQL database.execute(sql)IntegrityError: ERROR: duplicate key violates unique constraint "netbox_sysname_key"INSERT INTO netbox (sysname,rw,catid,ip,netboxid,prefixid,orgid,deviceid,ro,roomid) VALUES ('bay-wan.network.davenport.edu','youwish','GW','10.200.1.65','60','290','Davenport','129','itsasecret','17 ITS Office') Pete Hoffswell 616-732-1101 (Grand Rapids, x1101) University LAN/WAN Coordinator 616-510-1198 (Mobile) IT Services pete.hoffswell(a)davenport.edu Davenport University http://www.davenport.eduDavenport University. It's working.

1 0

error adding devices
by Pete.Hoffswell＠davenport.edu 14 Sep '05

14 Sep '05

I get the following when adding a device: It seems intermittent. http://nav.davenport.edu/editdb/netbox/edit/ Mod_python error: "PythonHandler editdb" Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 156, in handler output = editPage(req,pageList[table](),request,unicodeError) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 463, in editPage outputForm,action) File "/usr/local/nav/apache/webroot/editdb/editdb.py", line 2435, in add disabled=True)) TypeError: __init__() takes at least 2 non-keyword arguments (1 given) Looks like a bug maybe? Pete Hoffswell 616-732-1101 (Grand Rapids, x1101) University LAN/WAN Coordinator 616-510-1198 (Mobile) IT Services pete.hoffswell(a)davenport.edu Davenport University http://www.davenport.edu Davenport University. It's working.

1 0

AlertProfiles problem
by roger.aas＠hsh.no 13 Sep '05

13 Sep '05

Morten Vold wrote: > On 09/08/2005 10:31, Roger Aas uttered: > >> if VFFSL(SL,"user.preferences.hidelogo",1): >>NameMapper.NotFound: cannot find 'preferences' while searching for >>'user.preferences.hidelogo' >> >>Also in the lower left corner I get this message both with FireFox and IE: >> >>StyleSheets >>Your Internet browser do not support style sheets. We reccomend using a >>browser which support style sheets with Alert Profiles. >> > >>Someone know why I get this error? This is in RC2, I did not get this in >>RC1. > > > This bug was reported by Bulent Sarinc the same day RC2 came out. It was > fixed in the Subversion repository on July 27th (r3314). The fix will > be part of the next release. > > (Peder Magne Sefland also reported the same bug the day after you did). Hi Morten. Thanks for the answer. Using the subversion repository is not an option for me right now since I will only get the source there and will have to compile it, somethink I tried earlier with some beta version. There is just too much setup needed to get this to compile for me to have the time to make this work. So, I am instead hoping for the release version or maybe an RC3 version coming soon so I can start testing out the alert setup and the SMS alert system. Since I did not have the chance to attend the GigaCampus meeting in Trondheim this time I did not get any "inside information" to when to expect a new release of NAV. Anybody want to give me some hope? Regards, Roger -- Roger Aas Stord/Haugesund College

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

Nav-users