Send Netdot-devel mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
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-devel digest..."
Today's Topics:
1. [Netdot - Support #1769] Error when running make installdb
with PostgresQL 9.2 ([email protected])
2. [Netdot - Bug #1805] maxCount feature of select_lookup()
method in lib/Netdot/UI.pm ([email protected])
3. [Netdot - Bug #1806] select_lookup() method in
lib/Netdot/UI.pm fails to deal with NULLable columns
([email protected])
4. [Netdot - Feature #1823] Make topology graph an imagemap
([email protected])
5. [Netdot - Feature #1833] speedup - management -
host_tasks/dns records ([email protected])
6. [Netdot - Bug #1819] SNMP error for VLAN 1: Can't fetch data
as class method ([email protected])
----------------------------------------------------------------------
Message: 1
Date: Fri, 1 May 2015 04:08:52 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Support #1769] Error when running
make installdb with PostgresQL 9.2
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1769 has been updated by Awen Thomas.
DB_HOST => 'localhost',
If you're not running your database server on its default port,
specify the port the database server is running on below.
With mysql, it is usually safe to leave this blank.
With Pg, you will probably want to use '5432'
Thanks,
"Website":http://fixithere.net/sky-customer-service/
----------------------------------------
Support #1769: Error when running make installdb with PostgresQL 9.2
https://osl.uoregon.edu/redmine/issues/1769#change-3287
Author: Anonymous
Status: New
Priority: Normal
Assignee:
Category:
Target version:
Resolution:
When running make installdb on a 64 bit CentOS 6 machine with PG 9.2 and Netdot
1.0.4, I run into this error:
[root@vimes netdot-1.0.4]# make installdb
echo /usr/local/netdot > ./.prefix
Preparing to create netdot database
cd bin ; make installdb
make[1]: Entering directory `/home/jd/netdot-1.0.4/bin'
/usr/bin/perl initdb initdb
Creating Pg database netdot.
translate: Error with producer 'SQL::Translator::Producer::PostgreSQL': Can't
use an undefined value as an ARRAY reference at
/usr/local/share/perl5/SQL/Translator/Producer/PostgreSQL.pm line 340.
at ../lib/DBUTIL.pm line 267.
make[1]: *** [_installdb] Error 255
make[1]: Leaving directory `/home/jd/netdot-1.0.4/bin'
make: *** [installdb] Error 2
The section of my Site.conf relating to databases:
#
# Database setup
#
#################################################################
#
# DB_TYPE defines what sort of database NetDoT trys to talk to
# [mysql|Pg]
DB_TYPE => 'Pg',
# DB_HOME is where the Database's commandline tools live. $DB_HOME/bin
# should contain the binaries themselves, e.g. if "which mysql" gives
# "/usr/local/mysql/bin/mysql", $DB_HOME should be "/usr/local/mysql"
DB_HOME => '/usr/bin',
# Set DB_DBA to the name of a DB user with permission to create new databases
# Set DB_DBA_PASSWORD to that user's password (if you don't, you'll be prompted
# later)
# For mysql, you can try 'root'. For Pg, it is usually 'postgres'
DB_DBA => 'postgres',
DB_DBA_PASSWORD => 'obfuscated',
#
# Set this to the Fully Qualified Domain Name of your database server.
# If the database is local, rather than on a remote host, using "localhost"
# will greatly enhance performance.
DB_HOST => 'localhost',
# If you're not running your database server on its default port,
# specify the port the database server is running on below.
# With mysql, it is usually safe to leave this blank.
# With Pg, you will probably want to use '5432'
DB_PORT => '5432',
#
# Set this to the canonical name of the interface NetDoT will be talking to the
# database on. If you said that the DB_HOST above was "localhost," this
# should be too. This value will be used to grant NetDoT access to the database.
# If you want to access the NetDoT database from multiple hosts, you'll need
# to grant those database rights by hand.
#
DB_NETDOT_HOST => 'localhost',
# set this to the name you want to give to the NetDoT database in
# your database server.
DB_DATABASE => 'netdot',
# Set this to the name of the netdot database user
DB_NETDOT_USER => 'netdot_user',
# Set this to the password used by the NetDoT database user
# *** Change This Before Installation***
DB_NETDOT_PASS => 'obfusacated',
Please let me know what other info I can provide!
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
Message: 2
Date: Fri, 1 May 2015 04:12:18 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Bug #1805] maxCount feature of
select_lookup() method in lib/Netdot/UI.pm
To: [email protected], [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1805 has been updated by Awen Thomas.
while there are few direct calls to select_lookup(), any call to form_field()
might invoke
select_lookup() depending on the type of the column in questionIf you're not
running your database server on its default port,
specify the port the database server is running on below.
With mysql, it is usually safe to leave this blank.
With Pg, you will probably want to use '5432'
Thanks,
"Website":http://fixithere.net/sky-customer-service/
----------------------------------------
Bug #1805: maxCount feature of select_lookup() method in lib/Netdot/UI.pm
https://osl.uoregon.edu/redmine/issues/1805#change-3288
Author: William Bulley
Status: New
Priority: Low
Assignee: Carlos Vicente
Category: UserInterface
Target version: 1.0.6
Resolution:
the form_field() method calls select_lookup() on foreign key columns, but does
not provide
the maxCount argument when it calls select_lookup()
while there are few direct calls to select_lookup(), any call to form_field()
might invoke
select_lookup() depending on the type of the column in question
providing the optional @defaults argument to select_lookup() prevents the
"else" clause
to "provide tools to narrow the selection" feature
there is only one call to select_lookup() passing the @defaults argument (in
the "IPs"
section of htdocs/management/device.html) -- but this call does not use the
maxCount
argument -- this may explain why this bug has lain dormant for some time...
There are two changes (one on each line of 354 and 574 in the UI.pm file) to
correct this:
@@ -351,7 +351,7 @@ sub form_field {
if ( defined $f_table ){
$value = $self->select_lookup(object=>$o, table=>$table,
column=>$column, htmlExtra=>$args{htmlExtra},
lookup=>$f_table, edit=>$args{edit},
new_button=>$args{new_button},
- linkPage=>$args{linkPage},
default=>$args{default},
+ linkPage=>$args{linkPage},
default=>$args{default}, maxCount=>$args{maxCount},
defaults=>$args{defaults},
returnAsVar=>1, shortFieldName=>$args{shortFieldName});
}
################################################
@@ -571,7 +571,8 @@ sub select_lookup{
# if the selected objects are within our limits,
# or if we've been passed a specific default list,
# show the select box.
- if ( $count <= $args{maxCount} || @defaults ){
+# if ( $count <= $args{maxCount} || @defaults ){
+ if ( $count <= $args{maxCount} ){
if ( !$args{where} && !@defaults ){
@fo = $args{lookup}->retrieve_all();
}
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
Message: 3
Date: Fri, 1 May 2015 04:12:54 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Bug #1806] select_lookup() method in
lib/Netdot/UI.pm fails to deal with NULLable columns
To: [email protected], [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1806 has been updated by Awen Thomas.
+ if ( $o &x%x $o->$column ){
+ my $mtable = $table->meta_data;
+ my $mcol = $mtable->get_column($column);
+ if ($mcol->is_nullable() ){
$output .= sprintf('<option value="">[null]</option>');
Thanks,
"Website":http://www.fixithere.net/sky-contact-number/
----------------------------------------
Bug #1806: select_lookup() method in lib/Netdot/UI.pm fails to deal with
NULLable columns
https://osl.uoregon.edu/redmine/issues/1806#change-3289
Author: William Bulley
Status: New
Priority: Low
Assignee: Carlos Vicente
Category: UserInterface
Target version: 1.0.6
Resolution:
the select_lookup() method in lib/Netdot/UI.pm will insert a "[null]" select
<option> element under certain conditions when building an HTML <select>
pull-down menu
the "edit" argument controls whether the <select> menu is created when "edit"
is "true"
when showing the <select> box a "[null]" <option> is unconditionally added just
before
the closing </select> tag in both code paths when the "edit" argument is "true
--- UI.pm.orig 2014-04-10 16:24:50.000000000 -0400
+++ UI.pm 2014-05-07 08:09:02.000000000 -0400
@@ -610,11 +610,15 @@
next if ( $o && $o->$column && ($fo->id == $o->$column->id) );
my $selected = ($fo->id == $args{default} ? 'selected' : '');
$output .= sprintf('<option value="%s" %s>%s</option>',
$fo->id, $selected, $fo->get_label);
}
+ if ( $o && $o->$column ){
+ if ($o->$column->is_nullable() ){
$output .= sprintf('<option value="">[null]</option>');
+ }
+ }
$output .= sprintf('</select>');
}else{
# ...otherwise provide tools to narrow the selection to a managable
size.
my $srchf = '_' . $id . '_' . $column . '_srch';
$output .= '<nobr>'; # forces the text field and button to be on
the same line
@@ -630,11 +634,15 @@
$output .= sprintf('<option value="" selected>-- Select
--</option>');
if ( $o && $o->$column ){
$output .= sprintf('<option value="%s" selected>%s</option>',
$o->$column->id, $o->$column->get_label);
}
+ if ( $o && $o->$column ){
+ if ($o->$column->is_nullable() ){
$output .= sprintf('<option value="">[null]</option>');
+ }
+ }
$output .= sprintf('</select>');
}
if ( $args{new_button} ){
# show link to add new item to this table
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
Message: 4
Date: Fri, 1 May 2015 04:13:05 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Feature #1823] Make topology graph
an imagemap
To: [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1823 has been updated by Awen Thomas.
+ if ( $o &x%x $o->$column ){
+ my $mtable = $table->meta_data;
+ my $mcol = $mtable->get_column($column);
+ if ($mcol->is_nullable() ){
$output .= sprintf('<option value="">[null]</option>');where each graph node
links to the page for the relevant device.
Thanks,
"Website":http://www.fixithere.net/sky-contact-number/
----------------------------------------
Feature #1823: Make topology graph an imagemap
https://osl.uoregon.edu/redmine/issues/1823#change-3290
Author: Brian Candler
Status: New
Priority: Low
Assignee:
Category:
Target version:
Resolution:
It would be very cool if the whole topology graph was a clickable imagemap
where each graph node links to the page for the relevant device.
graphviz supports this:
http://stackoverflow.com/questions/15837283/graphviz-embedded-url
Indeed, the device-level 'topology' section does this already. Maybe this
toplogy tab of the device info should be the link target, i.e.
<code>/netdot/management/device.html?id=XXX&view=Topology</code>
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
Message: 5
Date: Fri, 1 May 2015 04:13:22 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Feature #1833] speedup - management
- host_tasks/dns records
To: [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1833 has been updated by Awen Thomas.
+ if ( $o &x%x $o->$column ){
+ my $mtable = $table->meta_data;
+ my $mcol = $mtable->get_column($column);
+ if ($mcol->is_nullable() ){
In our case the combined sum is 3720.
Thanks,
"Website":http://www.fixithere.net/sky-contact-number/
----------------------------------------
Feature #1833: speedup - management - host_tasks/dns records
https://osl.uoregon.edu/redmine/issues/1833#change-3291
Author: Wim Vandersmissen
Status: New
Priority: Normal
Assignee:
Category:
Target version:
Resolution:
Adding a new host using management/host_tasks.html?view=new is very slow
because of iterating over all the zones and ipblocks if you got a lot of those.
In our case the combined sum is 3720.
Loading this page takes 12.37 seconds!
Using mason cache, we can reduce after the second loadtime to 3.6 seconds (3.4
times faster) and every other subsequented load will be cached locally on the
browser (0.3 seconds loadtime) (10 times faster). So in total a 40 times speed
increase ;-)
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
Message: 6
Date: Fri, 1 May 2015 04:14:16 -0700
From: [email protected]
Subject: [Netdot-devel] [Netdot - Bug #1819] SNMP error for VLAN 1:
Can't fetch data as class method
To: [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Issue #1819 has been updated by Awen Thomas.
ERROR - 10.0.1.2: SNMP error for VLAN 60: Can't fetch data as class method at
/usr/local/netdot/lib/Netdot/Topology.pm line 445.
ERROR - 10.0.1.2: SNMP error for VLAN 30: Can't fetch data as class method at
/usr/local/netdot/lib/Netdot/Topology.pm line 549.
ERROR - 10.0.1.2: SNMP error for VLAN 44: Can't fetch data as class method at
/usr/local/netdot/lib/Netdot/Topology.pm line 4495.
Thanks,
"Website":http://www.fixithere.net/sky-contact-number/
----------------------------------------
Bug #1819: SNMP error for VLAN 1: Can't fetch data as class method
https://osl.uoregon.edu/redmine/issues/1819#change-3292
Author: Brian Candler
Status: New
Priority: Normal
Assignee:
Category:
Target version:
Resolution:
When adding a new device (discovered via neighbor detection):
<pre>
INFO - All Devices updated. 3 devices in 23 sec
INFO - Discovering Network Topology using sources: STP, FDB, P2P, DP. Min
score: 6
INFO - Topology::get_dp_links: Discovering unknown neighbor: 10.0.1.2
ERROR - 10.0.1.2: SNMP error for VLAN 60: Can't fetch data as class method at
/usr/local/netdot/lib/Netdot/Topology.pm line 595.
ERROR - 10.0.1.2: SNMP error for VLAN 30: Can't fetch data as class method at
/usr/local/netdot/lib/Netdot/Topology.pm line 595.
ERROR - 10.0.1.2: SNMP error for VLAN 44: Can't fetch data as class method at
/usr/local/netdot/lib/Netdot/Topology.pm line 595.
...
ERROR - 10.0.1.2: SNMP error for VLAN 48: Can't fetch data as class method at
/usr/local/netdot/lib/Netdot/Topology.pm line 595.
ERROR - 10.0.1.2: SNMP error for VLAN 1: Can't fetch data as class method at
/usr/local/netdot/lib/Netdot/Topology.pm line 595.
INFO - Inserted new RR: admin-core.example.net
</pre>
Maybe related:
http://stackoverflow.com/questions/8667079/dbixclass-find-or-create-error-cant-fetch-data-as-class-method-at
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://osl.uoregon.edu/redmine/my/account
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 98, Issue 1
*******************************************
