-----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
