Re: [Netdisco] Error thrown during router discovery

[<er...@je...>]

The issue is that netdisco is attempting to insert the ATM address =20
into a database field which is typed as a macaddr, the database is =20
rejecting.

I modified the routine for the device MAC address to check that it was =20
a valid MAC or return null since it is not a mandatory field in the =20
database.  It looks like we need to do the same thing for the =20
interfaces.

Thanks,
Eric

Quoting j.v...@ut...:

> Hi,
>
> Recently we added a new router to our network, in order to terminate a
> couple of ADSL connections. It's a Cisco 7200 with both a FastEthernet
> and an OC-3 ATM port.
>
> At every discover or refresh run, it throws the following error:
>
> netdisco@discograph:~$ ./netdisco -C postgres.conf -d c7200.xxx.xxx.xx
> n e t  d i s c o
> --------------------------------------------------
> Discover(c7200.xxx.xxx.xx) :
>   Fetching Device Info           :
>   Fetching Interface Information : .........DBD::Pg::st execute failed:
> ERROR:  invalid input syntax for type macaddr:
> "47:00:91:81:00:00:00:00:30:71:b6:98:01:00:d0:c0:18:68:1c:00"
> insert_or_update(INSERT into device_port
> (ip,duplex_admin,name,up,vlan,port,duplex,descr,stp,lastchange,speed,up_
> admin,type,mac,mtu) VALUES ('130.89.xxx.xxx',NULL,'ATM2/0.0-atm
> subif','up',NULL,'ATM2/0.0-atm subif',NULL,'ATM2/0.0-atm
> subif',NULL,'0','OC-3','up','atmSubInterface','47:00:91:81:00:00:00:00:3
> 0:71:b6:98:01:00:d0:c0:18:68:1c:00',NULL);) ERROR:  invalid input syntax
> for type macaddr:
> "47:00:91:81:00:00:00:00:30:71:b6:98:01:00:d0:c0:18:68:1c:00"
>
>  at ./netdisco line 2120
> ....
>   Fetching Neighbor Information  : .
>
>
> I checked with snmpwalk and verified that the ifPhysAddress is indeed
> the full ATM address used by the port.
>
>
> The Sourceforge page and documentation for Netdisco don't seem to
> mention this issue; in the mailing list archives, I only found one
> reference ("[Netdisco] multilayer switch with atm-netdisco support", 22
> jan 2007) without any follow ups.
>
> Is this a known problem? We're running Netdisco 0.94 (heavily patched
> for Oracle support), is there a chance that is issue is (or will be)
> fixed in a newer version?
>
>
> Best regards,
>
> Jeroen van Ingen
> ICT Service Centre
> University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands
> Telephone +31 53 489 2526, Fax +31 53 489 2383
> J.v...@ut...; http://www.utwente.nl/icts
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Netdisco mailing list
> net...@li...
> https://lists.sourceforge.net/lists/listinfo/netdisco-users
>