Subject: Question about auto discovery
Hi all,
I need some help!!!!!!!
In the release notes for the V3.1 date 30 June 2006:
Autodiscovery command line tool added to contrib. This tool will try to discover every managed network device within your network, and add them to NAV.
I really need some help about it!
For information we have about 10.000 nodes and about 300.000 ports to manage. Every routeurs and switches are CISCO devices. This for 130 locations around the world.
So you'll easily understand that autodiscovery is mandatory for us!
We're currently use HPOV NNM but we want to change for something else, the probleme is that there is no autodiscovery engine working "correctly" to discover our large network. Some softwares use range IP for discovery or use only 1 snmp community and so on....that's not the right way to discover a large network with a lot of subnets
I really think that NAV can be the right solution for us, but only if autodiscovery works fine! I hope!!!
Thanx before all for the support
Best regards from france.
Read you soon.
Patrice Pecriaux ppecriaux@auchan.fr
From kjartan.malde at uis.no Wed Aug 9 15:49:52 2006
From: kjartan.malde at uis.no (kjartan.malde@uis.no) Date: Wed Aug 9 14:50:00 2006 Subject: [Nav-users] postgres and arnold Message-ID: OFC43206AE.E452A279-ONC12571C5.00460912-C12571C5.00467BF5@uis.no
Hi
I've tried to configure Arnold, but get this error when trying the arnold-link in webinterface. Can anyone help me?
Mod_python error: "PythonHandler arnoldhandler"
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/arnold/arnoldhandler.py", line 95, in handler printBlocked(cur,page,sort, section)
File "/usr/local/nav/apache/webroot/arnold/arnoldhandler.py", line 277, in printBlocked cur.execute("SELECT DISTINCT identityid,orgid,ip,mac,dns,netbios,text as reason, multiple,starttime,lastchanged,swsysname as sysname, swmodule,swport,userlock,secret FROM identity LEFT JOIN blocked_reason USING (blocked_reasonid) WHERE blocked_status='disabled' ORDER BY " + sort)
ProgrammingError: ERROR: permission denied for relation identity
SELECT DISTINCT identityid,orgid,ip,mac,dns,netbios,text as reason, multiple,starttime,lastchanged,swsysname as sysname, swmodule,swport,userlock,secret FROM identity LEFT JOIN blocked_reason USING (blocked_reasonid) WHERE blocked_status='disabled' ORDER BY ip
mvh Kjartan Malde UiS
From stein.magnus at jodal.no Wed Aug 9 16:13:20 2006
From: stein.magnus at jodal.no (Stein Magnus Jodal) Date: Wed Aug 9 15:13:22 2006 Subject: [Nav-users] postgres and arnold In-Reply-To: OFC43206AE.E452A279-ONC12571C5.00460912-C12571C5.00467BF5@uis.no References: OFC43206AE.E452A279-ONC12571C5.00460912-C12571C5.00467BF5@uis.no Message-ID: 1155129200.11901.4.camel@localhost.localdomain
On Wed, 2006-08-09 at 14:49 +0200, kjartan.malde@uis.no wrote:
Hi
I've tried to configure Arnold, but get this error when trying the arnold-link in webinterface. Can anyone help me?
*cut*
File "/usr/local/nav/apache/webroot/arnold/arnoldhandler.py", line 277, in printBlocked cur.execute("SELECT DISTINCT identityid,orgid,ip,mac,dns,netbios,text as reason, multiple,starttime,lastchanged,swsysname as sysname, swmodule,swport,userlock,secret FROM identity LEFT JOIN blocked_reason USING (blocked_reasonid) WHERE blocked_status='disabled' ORDER BY " + sort)
ProgrammingError: ERROR: permission denied for relation identity
Hi,
It looks like the nav database user does not have permission to the identity table (and maybe other tables) in the arnold database.
This should fix it:
$ sudo -u postgres psql arnold ALTER TABLE identity OWNER TO nav;
Use '\d' in psql to check if the other tables and sequences also are owned by the nav database user. Sequences are altered with exactly the same syntax (ALTER TABLE).