John Begley | 24 Jun 2012 00:36

1.01 and DB Rules

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='�.
<div>
    Hi folks,<br><br>
    I'm trying to add a GSR to a brand new 1.0.1-RC2 installation (on
    CentOS 6), and I get this.<br>
    <p><br>
        updatedevice.html<span class="Apple-converted-space">&nbsp;</span>produced
      the following error:</p>
    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='&#65533;.</div>
Carlos Vicente | 24 Jun 2012 04:04
Favicon

Re: 1.01 and DB Rules

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
> Netdot-users <at> osl.uoregon.edu
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
> 

--

-- 
cv

_______________________________________________
Netdot-users mailing list
Netdot-users <at> osl.uoregon.edu
https://osl.uoregon.edu/mailman/listinfo/netdot-users
John Begley | 24 Jun 2012 16:01

Re: 1.01 and DB Rules

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
>> Netdot-users <at> osl.uoregon.edu
>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>>
>

_______________________________________________
Netdot-users mailing list
Netdot-users <at> osl.uoregon.edu
https://osl.uoregon.edu/mailman/listinfo/netdot-users
John Begley | 30 Jun 2012 03:06

Re: 1.01 and DB Rules

Hi Carlos,

Just wanted to check up and see if there has been any progress here or 
if there was anything else I could provide to help.  I've updated the 
repo tree again and still no change in behavior.

JB

On 6/24/2012 10:01 AM, John Begley wrote:
> 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
>>> Netdot-users <at> osl.uoregon.edu
>>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>>>
>>
>

_______________________________________________
Netdot-users mailing list
Netdot-users <at> osl.uoregon.edu
https://osl.uoregon.edu/mailman/listinfo/netdot-users

Gmane