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 (Matt Elliott)
2. Re: Netdot 1.0.2 install help (Carlos Vicente)
----------------------------------------------------------------------
Message: 1
Date: Fri, 26 Oct 2012 17:26:48 -0400
From: Matt Elliott <[email protected]>
Subject: Re: [Netdot-users] Netdot 1.0.2 install help
To: Carlos Vicente <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID:
<fd6d6b2975595445a245d87baff0a8b856776c0...@taiexchccr.taiamerica.com>
Content-Type: text/plain; charset="us-ascii"
root@ubuntu:~# perl -MSQL::Translator -e 'print "$SQL::Translator::VERSION\n" '
0.11016
:(
-----Original Message-----
From: Carlos Vicente [mailto:[email protected]]
Sent: Friday, October 26, 2012 4:37 PM
To: Matt Elliott
Cc: [email protected]
Subject: Re: [Netdot-users] Netdot 1.0.2 install help
$ 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(0
>> x 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(0
>> x
>> 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::Apac
>> h
>> 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::ApacheHandle
>> r
>> =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 22:14:22 -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
Well, that must be it. Did you install that via CPAN?
It looks like the Ubuntu package is 0.11010.
You could uninstall the current one and then do:
$ sudo apt-get install libsql-translator-perl
Or, the other option is to edit etc/netdot.meta and remove all the lines
that have empty unique constraints:
unique => [ [ ] ],
I'll try to push another release soon, but there are other priorities at
the moment.
cv
On 10/26/12 5:26 PM, Matt Elliott wrote:
> root@ubuntu:~# perl -MSQL::Translator -e 'print "$SQL::Translator::VERSION\n"
> '
> 0.11016
>
> :(
>
> -----Original Message-----
> From: Carlos Vicente [mailto:[email protected]]
> Sent: Friday, October 26, 2012 4:37 PM
> To: Matt Elliott
> Cc: [email protected]
> Subject: Re: [Netdot-users] Netdot 1.0.2 install help
>
> $ 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
>
>
>
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 47, Issue 12
********************************************
