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: Netdot 1.0.2 install help (Carlos Vicente)
2. Device Discovery VLAN Error (Chris Wathan)
----------------------------------------------------------------------
Message: 1
Date: Fri, 26 Oct 2012 16:37:05 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Netdot 1.0.2 install help
To: Matt Elliott <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
$ perl -MSQL::Translator -e 'print "$SQL::Translator::VERSION\n" '
I see that the problem line is:
UNIQUE INDEX `accessright1` (``),
which has to do with the fact that etc/netdot.meta has the following for
AccessRight:
unique => [ [ ] ],
However that didn't use to be a problem until now.
Can you tell me which version of SQL::Translator you have? i.e.:
$ perl -MSQL::Translator -e 'print "$SQL::Translator::VERSION\n" '
0.11010
Thx
cv
On 10/26/12 4:25 PM, Matt Elliott wrote:
> Thanks Carlos. The schema is attached. I also took a capture of the
> installdb output, and there are errors creating some of the tables.
>
> -----Original Message-----
> From: Carlos Vicente [mailto:[email protected]]
> Sent: Friday, October 26, 2012 4:15 PM
> To: Matt Elliott
> Cc: [email protected]
> Subject: Re: [Netdot-users] Netdot 1.0.2 install help
>
> Hi Matt,
>
> You are the second person this week that reports problems with the schema.
>
> I'm puzzled because I've installed 1.0.2 on Ubuntu many times now without
> problems.
>
> Can you send me the schema file produced during installation? It should be in
>
> /your-path/netdot-1.0.2/etc/schema.mysql
>
>
> also, if you re-create that file with
>
> make genschema
>
> do you see any errors?
>
> cv
>
>
> On 10/26/12 3:51 PM, Matt Elliott wrote:
>> Hello. I just finished the installation process on a Ubuntu 12.04 VM.
>> There were a couple pain points getting all the required modules
>> installed, but nothing too terrible.
>>
>> After I followed all the steps in the manual, I can access the login
>> page but I receive an error upon login.
>>
>> DBD::mysql::db selectall_arrayref failed: Table 'netdot.accessright'
>> doesn't exist [for Statement "SELECT accessright.object_class,
>> accessright.object_id, accessright.access FROM contact,
>> contactlist, accessright, groupright WHERE contact.person=1 AND
>> contact.contactlist=contactlist.id AND
>> groupright.contactlist=contactlist.id AND
>> groupright.accessright=accessright.id"] at
>> /usr/local/netdot/lib/Netdot/Model/Person.pm line 145.
>>
>>
>> Trace begun at /usr/local/share/perl/5.14.2/HTML/Mason/Exceptions.pm
>> line 129 HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::db
>> selectall_arrayref failed: Table \'netdot.accessright\' doesn\'t exist
>> [for Statement "SELECT accessright.object_class,
>> accessright.object_id, accessright.access^J FROM
>> contact, contactlist, accessright, groupright^J
>> WHERE contact.person=1^J AND
>> contact.contactlist=contactlist.id^J AND
>> groupright.contactlist=contactlist.id^J AND
>> groupright.accessright=accessright.id"] at
>> /usr/local/netdot/lib/Netdot/Model/Person.pm line 145.^J') called at
>> /usr/local/netdot/lib/Netdot/Model/Person.pm line 145
>> Netdot::Model::Person::get_allowed_objects('Person=HASH(0xa5171778)')
>> called at /usr/local/netdot/lib/Netdot/UI.pm line 2454
>> Netdot::UI::get_allowed_objects('Netdot::UI=HASH(0xa648f28c)',
>> 'Apache2::Request=SCALAR(0xa4f454ec)',
>> 'Apache2::SiteControl::User=HASH(0xa5171494)') called at
>> /usr/local/netdot/htdocs/header.mhtml line 31
>> HTML::Mason::Commands::__ANON__('title', 'Network Documentation Tool',
>> 'section', 'Main', 'user',
>> 'Apache2::SiteControl::User=HASH(0xa5171494)', 'showheader', 1,
>> 'onload', '', 'meta_refresh', undef) called at
>> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x
>> a6a57bcc)', 'title', 'Network Documentation Tool', 'section', 'Main',
>> 'user', 'Apache2::SiteControl::User=HASH(0xa5171494)', 'showheader',
>> 1, 'onload', '', 'meta_refresh', undef) called at
>> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 1305 eval
>> {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line
>> 1295 HTML::Mason::Request::comp(undef, undef, 'title', 'Network
>> Documentation Tool', 'section', 'Main', 'user',
>> 'Apache2::SiteControl::User=HASH(0xa5171494)', 'showheader', 1,
>> 'onload', '', 'meta_refresh', undef) called at
>> /usr/local/netdot/htdocs/autohandler line 59
>> HTML::Mason::Commands::__ANON__ at
>> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x
>> a69f1d48)') called at
>> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line
>> 1300 eval {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm
>> line 1295 HTML::Mason::Request::comp(undef, undef, undef) called at
>> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 484 eval {...}
>> at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 484 eval
>> {...} at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line
>> 436
>> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0
>> xa520a624)') called at
>> /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm
>> line 168
>> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::Apach
>> eHandler=HASH(0xa520a624)') called at
>> /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm
>> line 825
>> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler
>> =HASH(0xa6169af0)',
>> 'Apache2::RequestRec=SCALAR(0xa83b0014)') called at
>> /usr/local/netdot/lib/Netdot/Mason.pm line 59
>> Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0xa83b0014)')
>> called at -e line 0 eval {...} at -e line 0
>>
>> I tried the query from mysql and it says the table netdot.accessright
>> does not exist. Here are the tables in the netdot database...
>>
>> mysql> show tables; +-----------------------+ | Tables_in_netdot
>> | +-----------------------+ | arpcache | | arpcacheentry
>> | | asset | | availability | | backbonecable
>> | | backbonecable_history | | bgppeering | | cablestrand
>> | | cablestrand_history | | cabletype | | circuit
>> | | circuit_history | | circuitstatus | | circuittype
>> | | closet | | closetpicture | | contact
>> | | contact_history | | contactlist | | contacttype
>> | | datacache | | device | |
>> device_history | | deviceattr | | deviceattrname
>> | | devicecontacts | | devicemodule | | dhcpattr
>> | | dhcpattrname | | dhcpscope | | dhcpscopetype
>> | | dhcpscopeuse | | entity | |
>> entity_history | | entityrole | | entitysite
>> | | entitytype | | fibertype | | floor
>> | | floorpicture | | fwtable | | fwtableentry
>> | | groupright | | horizontalcable | | interface
>> | | interface_history | | interfacevlan | | ipblock
>> | | ipblockattr | | ipblockattrname | | ipblockstatus
>> | | ipservice | | maintcontract | | monitorstatus
>> | | oui | | person | |
>> person_history | | physaddr | | physaddrattr
>> | | physaddrattrname | | product | |
>> product_history | | producttype | | room
>> | | rr | | rraddr | | rrcname
>> | | rrds | | rrhinfo | | rrmx
>> | | rrns | | rrptr | | rrsrv
>> | | rrtxt | | savedqueries | | schemainfo
>> | | service | | site | | site_history
>> | | sitelink | | sitelink_history | | sitepicture
>> | | sitesubnet | | splice | | stpinstance
>> | | strandstatus | | subnetzone | | userright
>> | | usertype | | vlan | | vlangroup
>> | | vlangroup_history | | zone | | zonealias
>> | +-----------------------+ 94 rows in set (0.00 sec)
>>
>> I tried to drop the database and run make installdb again but it
>> didn't help. I didn't get any errors when creating the tables.
>> Anyone have any ideas?
>>
>> Thanks, Matt Elliott
>>
>>
>> CONFIDENTIALITY NOTICE: This e-mail is confidential and may be
>> protected by legal privilege. If you are not the intended recipient,
>> be aware that any disclosure, copying, distribution, or use of this
>> e-mail is prohibited. If you have received this e-mail in error,
>> please notify us immediately and delete any and all copies. Thank
>> you.
>>
>> _______________________________________________ Netdot-users mailing
>> list [email protected]
>> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>>
>
>
> --
> cv
>
> CONFIDENTIALITY NOTICE: This e-mail is confidential and may be protected by
> legal privilege. If you are not the intended recipient, be aware that any
> disclosure, copying, distribution, or use of this e-mail is prohibited. If
> you have received this e-mail in error, please notify us immediately and
> delete any and all copies. Thank you.
>
--
cv
------------------------------
Message: 2
Date: Fri, 26 Oct 2012 16:52:17 -0400
From: "Chris Wathan" <[email protected]>
Subject: [Netdot-users] Device Discovery VLAN Error
To: <[email protected]>
Message-ID:
<A37F0143600FAC4ABA69A8BE98D499F102BC7593@chapman.ercbroadband.local>
Content-Type: text/plain; charset="us-ascii"
I received the following error when attempting to discover a Cisco 7609.
Could you tell me if this is resolved in 1.0.2 or if this is actually
causing any problems? We have noticed that one of our VLANs are not
being reported in the VLAN page even though it has been detected. Are
these perhaps related?
System error
error:
no value sent for required parameter 'action'
context:
...
77:
<%perl>
78:
79:
if ( my $next = $m->fetch_next ){
80:
if ( $page ){
81:
$m->call_next(page => $page);
82:
}else{
83:
$m->call_next();
84:
}
85:
}
...
code stack:
/usr/local/netdot/htdocs/management/autohandler:81
/usr/share/perl5/HTML/Mason/Request.pm:948
/usr/local/netdot/htdocs/masondata/obj/1249759374/management/autohandler
.obj:21
/usr/local/netdot/htdocs/autohandler:76
no value sent for required parameter 'action'
Trace begun at
/usr/local/netdot/htdocs/masondata/obj/1249759374/management/updatedevic
e.html.obj line 25
HTML::Mason::Commands::__ANON__('showheader', 1, 'page', 'DEVICE')
called at /usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f
e700b00520)', 'showheader', 1, 'page', 'DEVICE') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'showheader', 1, 'page',
'DEVICE') called at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HAS
H(0x7fe70098ca18)', 'page', 'DEVICE') called at
/usr/local/netdot/htdocs/management/autohandler line 81
HTML::Mason::Commands::__ANON__('showheader', 1) called at
/usr/share/perl5/HTML/Mason/Component.pm line 157
HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBas
ed=HASH(0x7fe7008db4d0)', 'main', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 948
HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=
HASH(0x7fe70098ca18)', 'main', 'showheader', 1) called at
/usr/local/netdot/htdocs/masondata/obj/1249759374/management/autohandler
.obj line 21
HTML::Mason::Commands::__ANON__('showheader', 1) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f
e7008db4d0)', 'showheader', 1) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'showheader', 1) called
at /usr/share/perl5/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HAS
H(0x7fe70098ca18)', 'showheader', 1) called at
/usr/local/netdot/htdocs/autohandler line 76
HTML::Mason::Commands::__ANON__ at
/usr/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f
e7008fe1d8)') called at /usr/share/perl5/HTML/Mason/Request.pm line 1297
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef) called at
/usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7
fe70098ca18)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm
line 165
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheH
andler=HASH(0x7fe70098ca18)') called at
/usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=H
ASH(0x7fe700512f08)', 'Apache2::RequestRec=SCALAR(0x7fe700768320)')
called at /usr/local/netdot/lib/Netdot/Mason.pm line 40
Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7fe700768320)')
called at -e line 0
eval {...} at -e line 0
Regards,
Chris Wathan
Senior Network Adminstrator
ERC Broadband
http://www.ercbroadband.org/
P (828) 350-2415 F (828) 350-2008
24hrs (866) 372-7110
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20121026/8931eacb/attachment.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 47, Issue 11
********************************************
