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. subnets not created on initial device discovery 1.0.1
(Karl Putland)
2. integer out of range for arp cache (Karl Putland)
3. Re: integer out of range for arp cache (Karl Putland)
4. Re: integer out of range for arp cache (Karl Putland)
----------------------------------------------------------------------
Message: 1
Date: Wed, 22 Aug 2012 16:14:04 -0600
From: Karl Putland <[email protected]>
Subject: [Netdot-users] subnets not created on initial device
discovery 1.0.1
To: [email protected]
Message-ID:
<ca+exwszz0b02e2qwoema-4npjhbe0rsyupaa48jt3-n+qki...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Subnets are not being create on initial device discovery. netdot 1.0.1
Steps to reproduce
Devices > new
enter IP
discover
set owner, userd by, site
Update
displays module and interface information.
click [Go to <devicename>]
on right of device table header... [refresh][snmp-update][delete]
click snmp-update
click Update
NOW shows subnets created.
--Karl
--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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120822/a5c608fd/attachment-0001.html
------------------------------
Message: 2
Date: Wed, 22 Aug 2012 16:54:59 -0600
From: Karl Putland <[email protected]>
Subject: [Netdot-users] integer out of range for arp cache
To: [email protected]
Message-ID:
<CA+EXWsyJEzAC=vvjrafut+bdvsd0wrrxc9h43t_il9ocm0r...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
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
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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120822/1d77560a/attachment-0001.html
------------------------------
Message: 3
Date: Wed, 22 Aug 2012 17:35:35 -0600
From: Karl Putland <[email protected]>
Subject: Re: [Netdot-users] integer out of range for arp cache
To: [email protected]
Message-ID:
<ca+exwsyynj42s7hfpuudpccd-oeekv08tupvujbfe4ue-qw...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
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
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]> 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
>
> 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>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120822/40f8b48b/attachment-0001.html
------------------------------
Message: 4
Date: Wed, 22 Aug 2012 17:39:52 -0600
From: Karl Putland <[email protected]>
Subject: Re: [Netdot-users] integer out of range for arp cache
To: [email protected]
Message-ID:
<ca+exwszeewy21uzjtgnuic3ia6mm3pdw7hzr0rsunmlixwz...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
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]> 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
>
> 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]>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
>>
>> 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>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120822/db48f288/attachment.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 45, Issue 18
********************************************
