Send Netdot-users mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."


Today's Topics:

   1. Re: FWT and ARP collection from Cisco ASA
      (Schroeder, AJ (GE Healthcare, consultant))
   2. Re: integer out of range for arp cache (Carlos Vicente)
   3. Re: FWT and ARP collection from Cisco ASA (Carlos Vicente)
   4. Re: integer out of range for arp cache (Karl Putland)


----------------------------------------------------------------------

Message: 1
Date: Wed, 5 Sep 2012 19:46:21 +0000
From: "Schroeder, AJ (GE Healthcare, consultant)"
        <[email protected]>
Subject: Re: [Netdot-users] FWT and ARP collection from Cisco ASA
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID:
        <[email protected]>
Content-Type: text/plain; charset="us-ascii"

Carlos,

So what I am seeing is that these ASA devices have ARP entries in the device 
page. I spot checked a couple of the ARP reports and saw some entries. The 
output that I sent you was from a device that is gets these errors when 
updatedevices.pl runs - it is also the device that I used for my testing.

What we are really after is the NAT tables on the ASA for our IPAM needs - 
should I also try collecting the FWT?

Thanks,

AJ

-----Original Message-----
From: Carlos Vicente [mailto:[email protected]] 
Sent: Wednesday, September 05, 2012 12:40 PM
To: Schroeder, AJ (GE Healthcare, consultant)
Cc: [email protected]
Subject: Re: [Netdot-users] FWT and ARP collection from Cisco ASA

Hi AJ,

I don't see the error you mentioned in the first e-mail. Is it perhaps from a 
different unit?

I do see this ASA returning some ARP entries, but no IPv6 neighbors.

Do you have a "ARP" tab in the device page for this particular device?
If so, does it show any entries?

cv

On 9/5/12 12:18 PM, Schroeder, AJ (GE Healthcare, consultant) wrote:
> Carlos,
> 
> Attached is the debug output from the CLI.pm debug output.
> 
> Thanks,
> 
> AJ Schroeder





------------------------------

Message: 2
Date: Wed, 05 Sep 2012 16:02:26 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] integer out of range for arp cache
To: Karl Putland <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1

OK, I see the problem.

See fix here:

http://goo.gl/L8zAe

Thanks for reporting it.

cv

On 8/22/12 7:39 PM, Karl Putland wrote:
> or that there's a problem with the prepared statement in Model::Arpcache
> 
> Executing the INSERT in psql and manually substituting the parameters
> seems to work.
> 
> --Karl
> 
> Karl Putland
> Senior VoIP Engineer
> 
> *SimpleSignal*
> 3600 S Yosemite, Suite 150
> Denver, CO 80237
> One Number Rings All My Phones: 303-242-8608
> 
> SimpleSignal.com <http://www.simplesignal.com/> | Blog
> <http://www.simplesignal.com/blog> | Facebook
> <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> <http://twitter.com/simplesignal>
> 
> 
> 
> On Wed, Aug 22, 2012 at 5:35 PM, Karl Putland <[email protected]
> <mailto:[email protected]>> wrote:
> 
>     At first glance this appears that 'id' columns should be bigserial
>     instead of serial.
> 
>     --Karl
> 
>     Karl Putland
>     Senior VoIP Engineer
> 
>     *SimpleSignal*
>     3600 S Yosemite, Suite 150
>     Denver, CO 80237
>     One Number Rings All My Phones: 303-242-8608 <tel:303-242-8608>
> 
>     SimpleSignal.com <http://www.simplesignal.com/> | Blog
>     <http://www.simplesignal.com/blog> | Facebook
>     <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
>     <http://twitter.com/simplesignal>
> 
> 
> 
>     On Wed, Aug 22, 2012 at 4:54 PM, Karl Putland <[email protected]
>     <mailto:[email protected]>> wrote:
> 
>         WARN - Problem inserting arpcacheentry: DBD::Pg::st execute
>         failed: ERROR:  value "3494759637" is out of range for type
>         integer [for Statement "INSERT INTO arpcacheentry 
>                                            
>         (arpcache,interface,ipaddr,physaddr)
>                                             VALUES (?, ?, 
>                                             (SELECT id FROM ipblock
>         WHERE address=? AND PREFIX=? AND version=?), 
>                                             (SELECT id FROM physaddr
>         WHERE address=?))" with ParamValues: 1='2', 2='108',
>         3='3494759637', 4='32', 5='4', 6='001955AB64AD'] at
>         /usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.
> 
>         --Karl
> 
>         Karl Putland
>         Senior VoIP Engineer
> 
>         *SimpleSignal*
>         3600 S Yosemite, Suite 150
>         Denver, CO 80237
>         One Number Rings All My Phones: 303-242-8608 <tel:303-242-8608>
> 
>         SimpleSignal.com <http://www.simplesignal.com/> | Blog
>         <http://www.simplesignal.com/blog> | Facebook
>         <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
>         <http://twitter.com/simplesignal>
> 
> 
> 
> 
> 
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
> 


-- 
cv


------------------------------

Message: 3
Date: Wed, 05 Sep 2012 16:07:26 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] FWT and ARP collection from Cisco ASA
To: "Schroeder, AJ (GE Healthcare, consultant)" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1

On 9/5/12 3:46 PM, Schroeder, AJ (GE Healthcare, consultant) wrote:
> Carlos,
> 
> So what I am seeing is that these ASA devices have ARP entries in the
> device page. I spot checked a couple of the ARP reports and saw some
> entries. 

Good.

The output that I sent you was from a device that is gets
> these errors when updatedevices.pl runs - it is also the device that
> I used for my testing.

Weird, because the presence of ARP entries in the database indicates
that the login via CLI was successful.

> What we are really after is the NAT tables on the ASA for our IPAM
> needs - should I also try collecting the FWT?

Currently Netdot does not collect NAT tables.

We also do not collect forwarding tables from the ASAs. They work at
layer 3, so in theory you should have all the MAC/port info in the ARP
caches, right?

cv


------------------------------

Message: 4
Date: Wed, 5 Sep 2012 14:23:15 -0600
From: Karl Putland <[email protected]>
Subject: Re: [Netdot-users] integer out of range for arp cache
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID:
        <ca+exwswqztx5yaeaptklgmmoifgvrtjd15wuwsfqcqior+w...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

ok...

I don't see errors about integer out of range... but now I have this...
which I haven't seen before.

--Karl




INFO - ss-6506-1den.simplesignal.com: Interface
ss-6506-1den.simplesignal.com [0] no longer exists.  Marking as removed.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI/CiscoIOS.pm line 249.
[...snip...]


INFO - ss-6506-1oc.simplesignal.com: Interface
ss-6506-1oc.simplesignal.com[0] no longer exists.  Marking as removed.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
[...snip...]



INFO - ss-3560-10c.simplesignal.com: FWT fetched. 42 entries in 20 sec
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
Use of uninitialized value $name in hash element at
/usr/local/netdot/lib/Netdot/Model/Device/CLI.pm line 162.
[...snip...]



--Karl

Karl Putland
Senior VoIP Engineer

*SimpleSignal*
3600 S Yosemite, Suite 150
Denver, CO 80237
One Number Rings All My Phones: 303-242-8608

SimpleSignal.com <http://www.simplesignal.com/> |
Blog<http://www.simplesignal.com/blog>
 | Facebook <http://www.facebook.com/SimpleSignal?ref=ts> |
Twitter<http://twitter.com/simplesignal>



On Wed, Sep 5, 2012 at 2:02 PM, Carlos Vicente <[email protected]> wrote:

> OK, I see the problem.
>
> See fix here:
>
> http://goo.gl/L8zAe
>
> Thanks for reporting it.
>
> cv
>
> On 8/22/12 7:39 PM, Karl Putland wrote:
> > or that there's a problem with the prepared statement in Model::Arpcache
> >
> > Executing the INSERT in psql and manually substituting the parameters
> > seems to work.
> >
> > --Karl
> >
> > Karl Putland
> > Senior VoIP Engineer
> >
> > *SimpleSignal*
> > 3600 S Yosemite, Suite 150
> > Denver, CO 80237
> > One Number Rings All My Phones: 303-242-8608
> >
> > SimpleSignal.com <http://www.simplesignal.com/> | Blog
> > <http://www.simplesignal.com/blog> | Facebook
> > <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> > <http://twitter.com/simplesignal>
> >
> >
> >
> > On Wed, Aug 22, 2012 at 5:35 PM, Karl Putland <[email protected]
> > <mailto:[email protected]>> wrote:
> >
> >     At first glance this appears that 'id' columns should be bigserial
> >     instead of serial.
> >
> >     --Karl
> >
> >     Karl Putland
> >     Senior VoIP Engineer
> >
> >     *SimpleSignal*
> >     3600 S Yosemite, Suite 150
> >     Denver, CO 80237
> >     One Number Rings All My Phones: 303-242-8608 <tel:303-242-8608>
> >
> >     SimpleSignal.com <http://www.simplesignal.com/> | Blog
> >     <http://www.simplesignal.com/blog> | Facebook
> >     <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> >     <http://twitter.com/simplesignal>
> >
> >
> >
> >     On Wed, Aug 22, 2012 at 4:54 PM, Karl Putland <[email protected]
> >     <mailto:[email protected]>> wrote:
> >
> >         WARN - Problem inserting arpcacheentry: DBD::Pg::st execute
> >         failed: ERROR:  value "3494759637" is out of range for type
> >         integer [for Statement "INSERT INTO arpcacheentry
> >
> >         (arpcache,interface,ipaddr,physaddr)
> >                                             VALUES (?, ?,
> >                                             (SELECT id FROM ipblock
> >         WHERE address=? AND PREFIX=? AND version=?),
> >                                             (SELECT id FROM physaddr
> >         WHERE address=?))" with ParamValues: 1='2', 2='108',
> >         3='3494759637', 4='32', 5='4', 6='001955AB64AD'] at
> >         /usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.
> >
> >         --Karl
> >
> >         Karl Putland
> >         Senior VoIP Engineer
> >
> >         *SimpleSignal*
> >         3600 S Yosemite, Suite 150
> >         Denver, CO 80237
> >         One Number Rings All My Phones: 303-242-8608 <tel:303-242-8608>
> >
> >         SimpleSignal.com <http://www.simplesignal.com/> | Blog
> >         <http://www.simplesignal.com/blog> | Facebook
> >         <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> >         <http://twitter.com/simplesignal>
> >
> >
> >
> >
> >
> > _______________________________________________
> > Netdot-users mailing list
> > [email protected]
> > https://osl.uoregon.edu/mailman/listinfo/netdot-users
> >
>
>
> --
> cv
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120905/30811666/attachment.html
 

------------------------------

_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users


End of Netdot-users Digest, Vol 46, Issue 6
*******************************************

Reply via email to