-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Wojciech Kozicki wrote:

...

I have not tested this package, nor included the database upgrade as part of the package, so you'll have to upgrade the database yourselves. ok, where I will found necessary sql statements?

I don't know where Morten Werner's Debian package puts it, but you can find it here (from the Subversion repository): https://svn.nav.ntnu.no/nav/navme/tags/3.0_beta10/doc/sql/upgrades/3.0_beta1... Also read https://svn.nav.ntnu.no/nav/navme/tags/3.0_beta10/doc/sql/upgrades/README if you haven't already :) - -- Morten Vold NTNU ITEA Integrasjonsgruppen -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCEH6mXxIl0kpcOkQRAoJFAKDIX2VIcfJDWiMmmLB03DPp92CWPQCfeih/ 5Qx2lWI3zXNo/YiLzH2sI7I= =MDh8 -----END PGP SIGNATURE-----

From woj at tstd.pl Mon Feb 14 12:36:25 2005 From: woj at tstd.pl (Wojciech Kozicki) Date: Mon Feb 14 12:37:00 2005 Subject: [Nav-users] vlan information from cisco switches Message-ID: <200502141236.26162.woj@tstd.pl>

Hi, I reported it earlier, I have problem with getting info about vlans from cisco 2900XL and 2950 switches, even if there is simple config: vlan trunk server------switch-------router Cricket stats for switches, mac info, switchports raport - everything is working, but there is no vlan information. On routers I specified vlan info via nav-style descriptions and it worked - in router port report I have vlan info. I think, that nav-style descriptions for switches interfaces won't fix it? regards -- Wojciech (Woj) Kozicki

From fredrik.holmberg at luh.hihm.no Mon Feb 14 12:57:12 2005 From: fredrik.holmberg at luh.hihm.no (Fredrik Holmberg) Date: Mon Feb 14 12:57:24 2005 Subject: [Nav-users] report-errors Message-ID: <20050214115720.326DB66CFE@royk.itea.ntnu.no>

After upgrading to beta 10 the following message appears when I access https://nav-server/report/netbox: Configuration error! The report generator is not able to do such things.ERROR: column "netboxid" does not exist SELECT roomid,sysname,ip,catid,sub,typeid,typename,orgid,netbox.up,modules,swport,g wport,'Mem',snmp,val AS Function,netbox.netboxid,prefixid FROM type RIGHT OUTER JOIN netbox USING (typeid) LEFT JOIN (SELECT netboxid,count(netboxid) AS gwport FROM gwport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr1 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS swport FROM swport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr2 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS modules FROM module GROUP BY netboxid) tempaggr3 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS sub FROM netboxcategory GROUP BY netboxid) tempaggr4 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS snmp FROM type GROUP BY netboxid) tempaggr1 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS swport FROM swport JOIN module USING (moduleid) GROUP BY netboxid) tempaggr2 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS modules FROM module GROUP BY netboxid) tempaggr3 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS sub FROM netboxcategory GROUP BY netboxid) tempaggr4 USING (netboxid) LEFT JOIN (SELECT netboxid,count(netboxid) AS snmp FROM netboxsnmpoid GROUP BY netboxid) tempaggr5 USING (netboxid) LEFT JOIN netboxinfo ON (netbox.netboxid=netboxinfo.netboxid AND var='function') ORDER BY roomid LIMIT 100 OFFSET 0 The same thing happens when I access "Routers" etc. Installed the rpm and applied the sql-files. Is there a "quick-fix" for this? :) Regards, Fredrik Holmberg