Hello Everyone,

I have installed the NAV3.0.0 on a CentOS system[Linux version 2.6.9-22.0.1.EL (buildcentos@x8664-build)]

Originally I had installed most of the devices into the Database and everything seemed to be working well. The program did not see module 1 / port 1 on several devices. All of the other ports and modules showed up. After this I tried adding new devices to the database and they would not show up in the network explorer.

To try and fix this problem I decided to dump the databases and recreate them and try adding the devices again. This did not work. The devices showed up but the problem with missing ports was still there.

I then tried dropping the databases again, removing all of the files installed, and walked through the install process again.

Now only the first ip-device I installed shows up in the network-explorer, yet they are all in the report. I've tried all the cron jobs for navcron and still only the one shows up. All of the devices show that their gateway is the ip address of the first device added to the database.

Devices: #vendorid:typename:sysoid[:description:frequency:cdp=(yes|no):tftp=(yes|no)] nortel:bps2000:1.3.6.1.4.1.45.3.40.1:Business Policy Switch 2000:3600:no:no nortel:551024:1.3.6.1.4.1.45.3.52.1:BayStack 5510 24T:3600:no:no nortel:551048:1.3.6.1.4.1.45.3.53.1:BayStack 5510 48T:3600:no:no nortel:552048:1.3.6.1.4.1.45.3.59.2:BayStack 5520 48T PWR:3600:no:no nortel:46024:1.3.6.1.4.1.45.3.49.1:BayStack 460 24T PWR:3600:no:no nortel:nortelcore:1.3.6.1.4.1.2272.30:Nortel Core:3600:no:no The program can reteive the serial from all other devices.

First Ip Device: #roomid:ip:orgid:catid:[ro:serial:rw:function:subcat1:subcat2..] 1:172.20.8.13:baycrest:SW:snmp-read::snmp-write:switch 13:172.18.0.2:baycrest:GSW:$upp0rt::bcgc-SW:core #obtains type from sysObjectID and the active ports on the first module of 9, but nothing more.

This ip '172.20.8.13' becomes the gateway for all other devices discovered after adding this one.

1) How do I force an update for Network Explorer?

2) How do I get NAV to show the first port on the first module of a switch? (172.20.8.13)

3) How do I get NAV to reteive the correct gateway information for a device? (172.20.8.13)

4) What do I change to get the rest of the modules to show up in the core device? (172.18.0.2)

I know this is a lot to look at but I would greatly appreciate help with any of these questions. Adam

From perica at akton.com.mk Tue Dec 13 17:38:24 2005

From: perica at akton.com.mk (Perica Veljanovski) Date: Tue Dec 13 17:38:35 2005 Subject: [Nav-users] missing FROM-clause entry for table netboxcategory In-Reply-To: CARMENmRf6Ci6nx8dyD000000d0@carmen.akton.si Message-ID: CARMEN6pkNzPZrIkyPz00000157@carmen.akton.si

Hi again,

I changed php5 with php4 and the extensions you suggested. I double checked my setup against the post from Roar and the setup steps that Dru sent me. Everyting seems ok, but... The proglem persists!

So, let's thake a look at another problem, maybe will solve the problem by attacking another one :)

This is what happens when i clikc on the Network Explorer from my Toolbox: ----- Traceback (most recent call last): File "/usr/local/nav/lib/python/nav/web/pyproxy/proxy.py", line 61, in handler user=user, session=req.session.id) File "/usr/local/nav/lib/python/nav/web/pyproxy/proxy.py", line 124, in doRequest request.request(method, path, query, headers) File "/usr/local/lib/python2.4/httplib.py", line 801, in request self._send_request(method, url, body, headers) File "/usr/local/lib/python2.4/httplib.py", line 824, in _send_request self.endheaders() File "/usr/local/lib/python2.4/httplib.py", line 795, in endheaders self._send_output() File "/usr/local/lib/python2.4/httplib.py", line 676, in _send_output self.send(msg) File "/usr/local/lib/python2.4/httplib.py", line 643, in send self.connect() File "/usr/local/lib/python2.4/httplib.py", line 627, in connect raise socket.error, msg error: (61, 'Connection refused') ----- Any suggestions?!

Also to remind you, my posgres log file is filling up with "unexpected EOF on client connection". This is a subject I found in the mail archive but found no solution for.

Thanks alot for taking the tame!

Perica Vlejanovski

-----Original Message----- From: nav-users-bounces@itea.ntnu.no [mailto:nav-users-bounces@itea.ntnu.no] On Behalf Of Perica Veljanovski Sent: Sunday, December 11, 2005 10:43 To: 'Roar Pettersen' Cc: nav-users@itea.ntnu.no Subject: RE: [Nav-users] missing FROM-clause entry for table netboxcategory

Hi,

That is exactly what I did in my install of NAV, except of the edit in /usr/local/cricket/cricket/lib/RRD/File.pm.

I use php5, so maybe the problem is there. Also php5 doesn't have overload in the extensions.

Anyway, thanks for the post. It was nice to compare what I did to my poor nav install with someone else :P

Perica Veljanovski

-----Original Message----- From: Roar Pettersen [mailto:edprp@uib.no] On Behalf Of Roar Pettersen Sent: Friday, December 09, 2005 14:55 To: Dru Cc: Perica Veljanovski; nav-users@itea.ntnu.no Subject: Re: [Nav-users] missing FROM-clause entry for table netboxcategory

Hello !

...

I installed NAV 3.0.b10 on a FreeBSD 5.4 from ports. Had some trouble setting everything up :) and apparently still have some troubles.

The port doesn't install everything you need to get each module working.

I'm

working on a how-to as I've resolved most of the issues on a FreeBSD 6.0.

If

you want to send me a copy of your pkg_info we can start comparing systems

from there.

Please read my posting on this forum earlier regarding NAV and FreeBSD, read this info and maybe some info is still missing ?

http://desperados.itea.ntnu.no/pipermail/nav-users/2005-August/000912.html

Btw, the FreeBSD port of NAV is dead, but we are hoping that we have a new maintainer soon.

-- Med vennlig hilsen / Regards;

Roar Pettersen Universitetet i Bergen - The University of Bergen Nygardsgt. 5 - N-5020 BERGEN - Norway Tlf: +47 55 58 40 55 VIP: 81503 fax: +47 55 58 40 70 roar.pettersen@it.uib.no - IT-Avd, UiB - http://www.uib.no

_______________________________________________ Nav-users mailing list Nav-users@itea.ntnu.no http://mailman.itea.ntnu.no/mailman/listinfo/nav-users