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. Moving hosts between subnets (Mattias Amnefelt)
2. Re: Netdot installation problem (Carlos Vicente)
3. Re: Error when updatedevices.pl -DFAT and updatedevices.pl
-DFA (Carlos Vicente)
4. Re: cannot delete device: foreign key constraint fails
(Carlos Vicente)
5. Re: Error when updatedevices.pl -DFAT and updatedevices.pl
-DFA (Michael T. Voity)
6. Re: Error when updatedevices.pl -DFAT and updatedevices.pl
-DFA (Carlos Vicente)
7. Re: Error when updatedevices.pl -DFAT and updatedevices.pl
-DFA (Michael T. Voity)
----------------------------------------------------------------------
Message: 1
Date: Mon, 16 Jun 2014 08:17:31 +0200
From: Mattias Amnefelt <[email protected]>
Subject: [Netdot-users] Moving hosts between subnets
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello!
I'm investigating using Netdot for our company. Our main aim at this
time is to drive provisioning of DNS and dynamically and statically
assigned DHCP. Our environment is almost entirely virtualized so
tracking physical locations, switch ports and cable plants are not
essential to us at this time.
Using Netdot for DNS/DHCP seems to work well except for one task, and
that is the ability to move a host from one subnet to another. Adding a
host to a subnet seems to work well when creating it, and I can use the
"Automatic assignment"-feature so users do not have to bother with
individual addresses. However, once I have created a host I find that a
user of type User cannot modify the address for that host or move it to
a different subnet (the add button for new addresses is limited to
Operators). A user of type Operator can add a new address from a
different subnet in the host modify section, but can only do so by
entering an explicit address and does not have access to "Automatic
assignment" for this task, opening up for the possiblity of duplicate
assignment.
I've had a quick look at the code and it doesn't look unfeasible to add
the ability for a user of type User to change an existing address to a
different subnet using Auto assignment. Would a patch that does this be
of interest or is there something in the design of Netdot that goes
against this that I'm not aware of?
Regards,
Mattias Amnefelt
Cantemo AB
------------------------------
Message: 2
Date: Mon, 16 Jun 2014 12:33:27 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Netdot installation problem
To: Ebo Thompson <[email protected]>
Cc: netdot-users <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Unfortunately the error below does not give me any useful information. Perhaps
the Apache logs would help.
BTW, I?m running 1.0.6 on Ubuntu 12.04 with no issues.
cv
On Jun 13, 2014, at 5:23 PM, Ebo Thompson <[email protected]> wrote:
> hi,carlos,
>
> experiencing the same error with netdot 1.0.6 on ubuntu 12.04. any fix for
> this issue yet?
>
> regards,
> ebo
>
>
> On Wed, Apr 16, 2014 at 2:25 AM, Siumafua Moala <[email protected]> wrote:
> I have tried to install several versions but all end up with the same
> error. I am running perl v5.14.2.
>
> thanks
>
> sudo service apache2 graceful
> Syntax error on line 31 of
> /etc/apache2/conf.d/netdot_apache2_local.conf:
> Attempt to reload Netdot/Model/Ipblock.pm aborted.\nCompilation failed
> in require at (eval 318) line 2.\n\t...propagated at
> /usr/share/perl/5.14/base.pm line 93.\nBEGIN failed--compilation aborted
> at (eval 317) line 1.\nBEGIN failed--compilation aborted at
> /usr/local/netdot/lib/Netdot/Model.pm line 381.\nCompilation failed in
> require at /usr/local/netdot/lib/Netdot/UI.pm line 5.\nBEGIN
> failed--compilation aborted at /usr/local/netdot/lib/Netdot/UI.pm line
> 5.\nCompilation failed in require at
> /usr/local/netdot/lib/Netdot/Mason.pm line 21.\nBEGIN
> failed--compilation aborted at /usr/local/netdot/lib/Netdot/Mason.pm
> line 21.\nCompilation failed in require at
> /etc/apache2/conf.d/netdot_apache2_local.conf line 32.\nBEGIN
> failed--compilation aborted
> Action 'configtest' failed.
> The Apache error log may have more information.
> ...fail!
> sysadm@mgmt:~/netdot/netdot-1.0.6>sudo make testdeps
> Testing for required Perl modules
> /usr/bin/perl bin/perldeps.pl test
> RRDs..............................................ok
> GraphViz..........................................ok
> Module::Build.....................................ok
> CGI...............................................ok
> Class::DBI........................................ok
> Class::DBI::AbstractSearch........................ok
> Apache2::Request..................................ok
> HTML::Mason.......................................ok
> Apache::Session...................................ok
> URI::Escape.......................................ok
> SQL::Translator...................................ok
> SNMP::Info 2.06...................................ok
> NetAddr::IP 4.042.................................ok
> Apache2::AuthCookie...............................ok
> Apache2::SiteControl..............................ok
> Log::Dispatch.....................................ok
> Log::Log4perl.....................................ok
> Parallel::ForkManager.............................ok
> Net::Patricia 1.20................................ok
> Authen::Radius....................................ok
> Test::Simple......................................ok
> Net::IRR..........................................ok
> Time::Local.......................................ok
> File::Spec........................................ok
> Net::Appliance::Session...........................ok
> BIND::Config::Parser..............................ok
> Net::DNS..........................................ok
> Text::ParseWords..................................ok
> Carp::Assert......................................ok
> Digest::SHA.......................................ok
> Net::DNS::ZoneFile::Fast..........................ok
> Socket6...........................................ok
> XML::Simple.......................................ok
>
> _______________________________________________
> 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
------------------------------
Message: 3
Date: Mon, 16 Jun 2014 12:39:15 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Error when updatedevices.pl -DFAT and
updatedevices.pl -DFA
To: "Michael T. Voity" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Michael,
The error is saying that the fwtable row with id 60022 does not exist. I would
check if that is the case (using the mysql client).
In any case, that?s odd because fwtable records are created before fwtableentry
records are inserted, so I?m not sure why that would happen.
I certainly have not experienced that error before.
cv
On Jun 11, 2014, at 11:04 AM, Michael T. Voity <[email protected]> wrote:
> Hello,
>
> I get this error when I run the above command.
>
> Ideas?
>
> I'm at version 1.0.4
>
>
> WARN - Problem inserting FWT entry: DBD::mysql::st execute failed:
> Cannot add or update a child row: a foreign key constraint fails
> (`netdot`.`fwtableentry`, CONSTRAINT `fk_fwtable` FOREIGN KEY
> (`fwtable`) REFERENCES `fwtable` (`id`)) [for Statement "INSERT INTO
> fwtableentry
> (fwtable,interface,physaddr)
> VALUES (?, ?, (SELECT id FROM
> physaddr WHERE address=?))" with ParamValues: 0='60022', 1='40659',
> 2='0022BD95B840'] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.
>
> -Mike
>
> --
> Michael T. Voity
> Network Engineer
> University of Vermont
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 4
Date: Mon, 16 Jun 2014 12:41:22 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] cannot delete device: foreign key
constraint fails
To: Alexander Bochmann <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
Alexander,
The DB schema in Netdot 1.0.6 should _not_ contain any *_history tables. The
error is suggesting that interface_history is still there.
Did you run the upgrade script when upgrading to 1.0.6?
cv
On Jun 6, 2014, at 4:22 AM, Alexander Bochmann <[email protected]> wrote:
> Hi,
>
> when trying to delete some of our switches from the netdot database,
> I get the following error:
>
>> Transaction aborted: Can't delete 4983: DBD::mysql::st execute failed:
>> Cannot delete or update a parent row: a foreign key constraint fails
>> (`netdot`.`interface_history`, CONSTRAINT `fk_interface_id` FOREIGN KEY
>> (`interface_id`) REFERENCES `interface` (`id`)) [for Statement "DELETE
>> FROM interface
>> WHERE id=?
>> " with ParamValues: 0='4983'] at /usr/share/perl5/DBIx/ContextualFetch.pm
>> line 52, line 4.
>
> I'm running 1.0.6 on a MySQL database.
>
> Any ideas?
>
> Alex.
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 5
Date: Mon, 16 Jun 2014 13:28:32 -0400
From: "Michael T. Voity" <[email protected]>
Subject: Re: [Netdot-users] Error when updatedevices.pl -DFAT and
updatedevices.pl -DFA
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252; format=flowed
Carlos,
That row does not exist. ideas on how to proceed?
-Mike
Michael T. Voity
Network Engineer
University of Vermont
(802) 656-8112
On 6/16/2014 12:39 PM, Carlos Vicente wrote:
> Michael,
>
> The error is saying that the fwtable row with id 60022 does not exist. I
> would check if that is the case (using the mysql client).
>
> In any case, that?s odd because fwtable records are created before
> fwtableentry records are inserted, so I?m not sure why that would happen.
>
> I certainly have not experienced that error before.
>
> cv
>
> On Jun 11, 2014, at 11:04 AM, Michael T. Voity <[email protected]> wrote:
>
>> Hello,
>>
>> I get this error when I run the above command.
>>
>> Ideas?
>>
>> I'm at version 1.0.4
>>
>>
>> WARN - Problem inserting FWT entry: DBD::mysql::st execute failed:
>> Cannot add or update a child row: a foreign key constraint fails
>> (`netdot`.`fwtableentry`, CONSTRAINT `fk_fwtable` FOREIGN KEY
>> (`fwtable`) REFERENCES `fwtable` (`id`)) [for Statement "INSERT INTO
>> fwtableentry
>> (fwtable,interface,physaddr)
>> VALUES (?, ?, (SELECT id FROM
>> physaddr WHERE address=?))" with ParamValues: 0='60022', 1='40659',
>> 2='0022BD95B840'] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.
>>
>> -Mike
>>
>> --
>> Michael T. Voity
>> Network Engineer
>> University of Vermont
>>
>> _______________________________________________
>> Netdot-users mailing list
>> [email protected]
>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 6
Date: Mon, 16 Jun 2014 13:46:27 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Error when updatedevices.pl -DFAT and
updatedevices.pl -DFA
To: "Michael T. Voity" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Do you get the error consistently when running the command? Does the fwtable ID
change?
The fwtable record gets created on each run, so I have no idea why that would
happen. Disk full? Corrupt mysql?
cv
On Jun 16, 2014, at 1:28 PM, Michael T. Voity <[email protected]> wrote:
> Carlos,
>
> That row does not exist. ideas on how to proceed?
>
> -Mike
>
> Michael T. Voity
> Network Engineer
> University of Vermont
> (802) 656-8112
>
> On 6/16/2014 12:39 PM, Carlos Vicente wrote:
>> Michael,
>>
>> The error is saying that the fwtable row with id 60022 does not exist. I
>> would check if that is the case (using the mysql client).
>>
>> In any case, that?s odd because fwtable records are created before
>> fwtableentry records are inserted, so I?m not sure why that would happen.
>>
>> I certainly have not experienced that error before.
>>
>> cv
>>
>> On Jun 11, 2014, at 11:04 AM, Michael T. Voity <[email protected]> wrote:
>>
>>> Hello,
>>>
>>> I get this error when I run the above command.
>>>
>>> Ideas?
>>>
>>> I'm at version 1.0.4
>>>
>>>
>>> WARN - Problem inserting FWT entry: DBD::mysql::st execute failed:
>>> Cannot add or update a child row: a foreign key constraint fails
>>> (`netdot`.`fwtableentry`, CONSTRAINT `fk_fwtable` FOREIGN KEY
>>> (`fwtable`) REFERENCES `fwtable` (`id`)) [for Statement "INSERT INTO
>>> fwtableentry
>>> (fwtable,interface,physaddr)
>>> VALUES (?, ?, (SELECT id FROM
>>> physaddr WHERE address=?))" with ParamValues: 0='60022', 1='40659',
>>> 2='0022BD95B840'] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52.
>>>
>>> -Mike
>>>
>>> --
>>> Michael T. Voity
>>> Network Engineer
>>> University of Vermont
>>>
>>> _______________________________________________
>>> Netdot-users mailing list
>>> [email protected]
>>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
------------------------------
Message: 7
Date: Mon, 16 Jun 2014 13:57:02 -0400
From: "Michael T. Voity" <[email protected]>
Subject: Re: [Netdot-users] Error when updatedevices.pl -DFAT and
updatedevices.pl -DFA
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset="windows-1252"
Plenty of disk space.
The error happens when ever the commands are run the error goes on for
miles with id number changing.
The DB appears to be fine as there are no other issues expect this.
But when i run mysqlcheck i get the following on all netdot tables -
*the storage engine for the table doesn't support repair*
ideas?
-Mike
Michael T. Voity
Network Engineer
University of Vermont
(802) 656-8112
On 6/16/2014 1:46 PM, Carlos Vicente wrote:
> Do you get the error consistently when running the command? Does the fwtable
> ID change?
>
> The fwtable record gets created on each run, so I have no idea why that would
> happen. Disk full? Corrupt mysql?
>
> cv
>
> On Jun 16, 2014, at 1:28 PM, Michael T. Voity <[email protected]> wrote:
>
>> Carlos,
>>
>> That row does not exist. ideas on how to proceed?
>>
>> -Mike
>>
>> Michael T. Voity
>> Network Engineer
>> University of Vermont
>> (802) 656-8112
>>
>> On 6/16/2014 12:39 PM, Carlos Vicente wrote:
>>> Michael,
>>>
>>> The error is saying that the fwtable row with id 60022 does not exist. I
>>> would check if that is the case (using the mysql client).
>>>
>>> In any case, that?s odd because fwtable records are created before
>>> fwtableentry records are inserted, so I?m not sure why that would happen.
>>>
>>> I certainly have not experienced that error before.
>>>
>>> cv
>>>
>>> On Jun 11, 2014, at 11:04 AM, Michael T. Voity <[email protected]> wrote:
>>>
>>>> Hello,
>>>>
>>>> I get this error when I run the above command.
>>>>
>>>> Ideas?
>>>>
>>>> I'm at version 1.0.4
>>>>
>>>>
>>>> WARN - Problem inserting FWT entry: DBD::mysql::st execute failed:
>>>> Cannot add or update a child row: a foreign key constraint fails
>>>> (`netdot`.`fwtableentry`, CONSTRAINT `fk_fwtable` FOREIGN KEY
>>>> (`fwtable`) REFERENCES `fwtable` (`id`)) [for Statement "INSERT INTO
>>>> fwtableentry
>>>> (fwtable,interface,physaddr)
>>>> VALUES (?, ?, (SELECT id FROM
>>>> physaddr WHERE address=?))" with ParamValues: 0='60022', 1='40659',
>>>> 2='0022BD95B840'] at /usr/local/share/perl5/DBIx/ContextualFetch.pm line
>>>> 52.
>>>>
>>>> -Mike
>>>>
>>>> --
>>>> Michael T. Voity
>>>> Network Engineer
>>>> University of Vermont
>>>>
>>>> _______________________________________________
>>>> Netdot-users mailing list
>>>> [email protected]
>>>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140616/7364769f/attachment.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 67, Issue 9
*******************************************
