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. 1.01 and DB Rules (John Begley)
2. Re: 1.01 and DB Rules (Carlos Vicente)
3. Re: Update hostnames in Netdot after DNS change (Carlos Vicente)
4. Re: 1.01 and DB Rules (John Begley)
5. Re: Update hostnames in Netdot after DNS change (Jeremy Bresley)
----------------------------------------------------------------------
Message: 1
Date: Sat, 23 Jun 2012 18:36:28 -0400
From: John Begley <[email protected]>
Subject: [Netdot-users] 1.01 and DB Rules
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset="iso-8859-1"
Hi folks,
I'm trying to add a GSR to a brand new 1.0.1-RC2 installation (on CentOS
6), and I get this.
**
*
updatedevice.html*produced the following error:
Error while inserting Product: Some values are duplicated
Error details: Can't insert new Product: DBD::mysql::st execute failed:
Duplicate entry '2' for key 'product1' [for Statement "INSERT INTO product
(part_number, manufacturer, name, type)
VALUES (?, ?, ?, ?)
" with ParamValues: 0='?. <;X
', 1='2', 2='?. <;X
', 3='12'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52, line 737.
I have no idea where to start with this... particularly since this is
the very first device I'm adding to the database.
I have two GSRs (Cisco 12000 series), and they both do this. Probably
fair to note that we run a 0.9.9 instance and it doesn't complain.
JB
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120623/5ce406aa/attachment-0001.html
------------------------------
Message: 2
Date: Sat, 23 Jun 2012 22:04:23 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] 1.01 and DB Rules
To: John Begley <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=UTF-8
Hi John,
It looks like the GSRs are returning non-ascii values when Netdot
requests module information. This is a problem because we now create
product entries for each module, which we didn't do before.
I've made some changes in the 1.0 branch to deal with this. It would be
great if you could test it and report back.
Steps in brief:
# cd /tmp
# git clone git://netdot.uoregon.edu/netdot.git
# git checkout -b netdot-1.0
# make lib && service httpd restart
Rediscover device.
Thanks.
cv
On 6/23/12 6:36 PM, John Begley wrote:
> Hi folks,
>
> I'm trying to add a GSR to a brand new 1.0.1-RC2 installation (on CentOS
> 6), and I get this.
> **
>
> *
> updatedevice.html* produced the following error:
>
> Error while inserting Product: Some values are duplicated
>
> Error details: Can't insert new Product: DBD::mysql::st execute failed:
> Duplicate entry '2' for key 'product1' [for Statement "INSERT INTO product
> (part_number, manufacturer, name, type)
> VALUES (?, ?, ?, ?)
> " with ParamValues: 0='?. <;X
> ', 1='2', 2='?. <;X
> ', 3='12'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52, line 737.
>
> I have no idea where to start with this... particularly since this is
> the very first device I'm adding to the database.
>
> I have two GSRs (Cisco 12000 series), and they both do this. Probably
> fair to note that we run a 0.9.9 instance and it doesn't complain.
>
> JB
>
>
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
cv
------------------------------
Message: 3
Date: Sat, 23 Jun 2012 22:10:25 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Update hostnames in Netdot after DNS
change
To: Jeremy Bresley <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Jeremy,
I'll need a bit more detail to understand your case.
* Did you add the reverse DNS entries in your DNS (not in Netdot)?
* Which DEVICE_IP_NAME_PLUGIN are you using?
* Do you intend to feed your DNS from what Netdot is generating, or are
you only interested in seeing the right names in the Netdot UI?
On 6/22/12 6:01 PM, Jeremy Bresley wrote:
> We recently went through and added reverse DNS entries for the vast
> majority of our internal network devices, this works great for
> traceroute and netdisco's interfaces, but it looks like Netdot uses
> whatever name or IP it found/discovered when the device was added. Is
> there an easy way short of dropping all the devices and rediscovering
> them to update the names on all of them to match either current sysName
> or reverse DNS entry?
>
> I'm in the process of upgrading to 1.0.1-rc2 currently, don't know if
> there's anything added in the new release to help with this or not.
>
> Thanks for any pointers or ideas on how to do this easier.
>
> Jeremy "TheBrez" Bresley
> [email protected]
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
cv
------------------------------
Message: 4
Date: Sun, 24 Jun 2012 10:01:08 -0400
From: John Begley <[email protected]>
Subject: Re: [Netdot-users] 1.01 and DB Rules
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=UTF-8; format=flowed
Hi Carlos,
Same error, I'm afraid.
I think I installed the tree correctly, particularly when I got a "1.0
DB version, 1.0.1 needed" error, and I corrected it by dropping the
netdot DB and doing the make installdb from the development tree.
However if you think it's likely I botched the install, I'm all ea...
um... eyes. The web page shows v.1.0 at the bottom.
I could arrange temp snmp access to the device(s) as well if it helps,
just e-mail me directly.
Just one more thing to add to the discussion, the reason I built a whole
new instance and was beginning to populate it was because I got very
similar errors trying to import our old 0.9.9 database onto a new box
and then upgrade it. I'm sorry that I don't still have the error log,
but it was something like...
Duplicate entry '<something something>-02' for key 'product1'.
The reason I was so lost was because I don't see any product1 table in
the DB... and the object it was referencing existed in the Model DB, but
without the -02 on it.
Anyway, hope that's enough info and not too much babble.
JB
On 6/23/2012 10:04 PM, Carlos Vicente wrote:
> Hi John,
>
> It looks like the GSRs are returning non-ascii values when Netdot
> requests module information. This is a problem because we now create
> product entries for each module, which we didn't do before.
>
> I've made some changes in the 1.0 branch to deal with this. It would be
> great if you could test it and report back.
>
> Steps in brief:
>
> # cd /tmp
> # git clone git://netdot.uoregon.edu/netdot.git
> # git checkout -b netdot-1.0
> # make lib&& service httpd restart
>
> Rediscover device.
>
> Thanks.
>
> cv
>
> On 6/23/12 6:36 PM, John Begley wrote:
>> Hi folks,
>>
>> I'm trying to add a GSR to a brand new 1.0.1-RC2 installation (on CentOS
>> 6), and I get this.
>> **
>>
>> *
>> updatedevice.html* produced the following error:
>>
>> Error while inserting Product: Some values are duplicated
>>
>> Error details: Can't insert new Product: DBD::mysql::st execute failed:
>> Duplicate entry '2' for key 'product1' [for Statement "INSERT INTO product
>> (part_number, manufacturer, name, type)
>> VALUES (?, ?, ?, ?)
>> " with ParamValues: 0='?. <;X
>> ', 1='2', 2='?. <;X
>> ', 3='12'] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52, line 737.
>>
>> I have no idea where to start with this... particularly since this is
>> the very first device I'm adding to the database.
>>
>> I have two GSRs (Cisco 12000 series), and they both do this. Probably
>> fair to note that we run a 0.9.9 instance and it doesn't complain.
>>
>> JB
>>
>>
>>
>>
>> _______________________________________________
>> Netdot-users mailing list
>> [email protected]
>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>>
>
------------------------------
Message: 5
Date: Sun, 24 Jun 2012 13:34:12 -0500
From: Jeremy Bresley <[email protected]>
Subject: Re: [Netdot-users] Update hostnames in Netdot after DNS
change
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Added to external DNS server separate from Netdot
UPDATE_DEVICE_IP_NAMES is set to 3, DEVICE_IP_NAME_PLUGIN is set to
Netdot::Model::Plugins::DeviceIpNamesFromDNS.
We want a way to change the names that Netdot is using, currently it's
using older DNS names which have been removed/updated. If there's a way
to force it to update to use sysName rather than DNS, that would work
fine for our needs as well. If there's no easy way to do it, we'll just
delete the devices and re-add/re-discover them, but I'd like to avoid
doing that if possible.
Jeremy
On 6/23/2012 9:10 PM, Carlos Vicente wrote:
> Hi Jeremy,
>
> I'll need a bit more detail to understand your case.
>
> * Did you add the reverse DNS entries in your DNS (not in Netdot)?
> * Which DEVICE_IP_NAME_PLUGIN are you using?
> * Do you intend to feed your DNS from what Netdot is generating, or are
> you only interested in seeing the right names in the Netdot UI?
>
>
> On 6/22/12 6:01 PM, Jeremy Bresley wrote:
>> We recently went through and added reverse DNS entries for the vast
>> majority of our internal network devices, this works great for
>> traceroute and netdisco's interfaces, but it looks like Netdot uses
>> whatever name or IP it found/discovered when the device was added. Is
>> there an easy way short of dropping all the devices and rediscovering
>> them to update the names on all of them to match either current sysName
>> or reverse DNS entry?
>>
>> I'm in the process of upgrading to 1.0.1-rc2 currently, don't know if
>> there's anything added in the new release to help with this or not.
>>
>> Thanks for any pointers or ideas on how to do this easier.
>>
>> Jeremy "TheBrez" Bresley
>> [email protected]
>> _______________________________________________
>> Netdot-users mailing list
>> [email protected]
>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>>
>
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 43, Issue 8
*******************************************
