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. Re: [Netdot-users] Seeking feedback about DBMS support
(Ebo Thompson)
2. Re: [Netdot-users] Seeking feedback about DBMS support
(Carlos Vicente)
3. Re: [Netdot-users] Seeking feedback about DBMS support
(William Bulley)
4. Re: Exporter.pm Pg compat patch (Carlos Vicente)
5. Re: Asset search error (Carlos Vicente)
----------------------------------------------------------------------
Message: 1
Date: Tue, 25 Sep 2012 13:21:04 +0000
From: Ebo Thompson <[email protected]>
Subject: Re: [Netdot-devel] [Netdot-users] Seeking feedback about DBMS
support
To: Carlos Vicente <[email protected]>
Cc: netdot-users <[email protected]>, netdot-devel
<[email protected]>
Message-ID:
<CA+ojiv9RBUNHRgy+mHT18_K4a+iZ_Bjemyf=6rnsy2k4a9o...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi,
Postgres db. The overiding factor diafavouring mysql is simply oracle!?
On Sep 24, 2012 8:10 PM, "Carlos Vicente" <[email protected]> wrote:
> Dear Netdot community,
>
> One of our initial design goals for Netdot was to make it DB-agnostic.
> We aimed at supporting both MySQL and Postgres equally. However, our
> production systems at the University of Oregon have always been based on
> MySQL, so Pg support was somewhat lagging. It still is.
>
> The sad truth is that it takes considerable time and effort to support
> two backends.
>
> At a recent discussion we talked about the possibility of supporting
> only PostgreSQL in the future. There are a few things that make Pg
> attractive: native support for IPv4 and IPv6 addresses, table
> partitions, etc. Pg is also not owned by Oracle ;-)
>
> A decision like this can't be made lightly. We certainly do not want to
> alienate administrators out there.
>
> My hunch is that most people don't care about the backend, and if they
> do, they prefer Pg. Am I right?
>
> What do you all think?
>
> --
> cv
> _______________________________________________
> 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-devel/attachments/20120925/374da304/attachment-0001.html
------------------------------
Message: 2
Date: Tue, 25 Sep 2012 09:31:59 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-devel] [Netdot-users] Seeking feedback about DBMS
support
To: William Bulley <[email protected]>
Cc: [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Web,
On 9/25/12 9:22 AM, William Bulley wrote:
> Rather than debate the merits of MySQL and PostgreSQL, would it be worth
> talking about replacing Class::DBI with a more modern and thoroughly
> object oriented solution such as Rose::DB?
This is not a question of either/or. Yes, Class::DBI is outdated and
there are better Perl ORMs out there. But,
> All
> the variations in database types would vanish should NETDOT embrace > the
> Rose::DB suite of Perl modules
that's not true. I believe that Phil Regnauld explained it pretty well
in his recent message. It doesn't matter which ORM you use, you still
have the problems of native data representation, management of large
tables, schema upgrades, etc.
And another fact is that changing the backend is far easier than
changing the ORM at this point.
--
cv
------------------------------
Message: 3
Date: Tue, 25 Sep 2012 09:44:04 -0400
From: William Bulley <[email protected]>
Subject: Re: [Netdot-devel] [Netdot-users] Seeking feedback about DBMS
support
To: Carlos Vicente <[email protected]>
Cc: [email protected], [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
According to Carlos Vicente <[email protected]> on Tue, 09/25/12 at 09:31:
>
> This is not a question of either/or. Yes, Class::DBI is outdated and
> there are better Perl ORMs out there. But,
>
> that's not true. I believe that Phil Regnauld explained it pretty well
> in his recent message. It doesn't matter which ORM you use, you still
> have the problems of native data representation, management of large
> tables, schema upgrades, etc.
>
> And another fact is that changing the backend is far easier than
> changing the ORM at this point.
Okay. Thanks for the clarifications.
Regards,
web...
--
William Bulley Email: [email protected]
72 characters width template ----------------------------------------->|
------------------------------
Message: 4
Date: Tue, 25 Sep 2012 10:06:54 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-devel] Exporter.pm Pg compat patch
To: Karl Putland <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Karl,
The Pg doc you reference below mention that 0 and 1 are valid values.
I have just tested this on Pg:
netdot=> select id from device where monitored='1';
id
----
1
(1 row)
So, the only fix needed here is to use quotes '' around the value.
cv
On 9/13/12 11:56 AM, Karl Putland wrote:
> Sorry... There was a problem with the other patch. It never entered the
> Pg branch because of a typo... This works now.
> Reference for boolean comparison in Pg
> http://www.postgresql.org/docs/9.0/static/datatype-boolean.html
>
> --Karl
>
>
>
> --- Netdot.orig/Exporter.pm2012-08-22 20:22:42.175837081 +0000
> +++ Netdot/Exporter.pm2012-09-13 15:50:18.111837447 +0000
> @@ -58,6 +58,7 @@
> }
>
> $self->{_dbh} = Netdot::Model->db_Main();
> + $self->{_db_type} = Netdot::Model->config->get('DB_TYPE');
> return $self;
> }
>
> @@ -73,30 +74,54 @@
> =cut
> sub get_device_info {
> my ($self) = @_;
> + my $SQL = "";
>
> return $self->cache('exporter_device_info')if
> $self->cache('exporter_device_info');
>
> my %device_info;
> $logger->debug("Netdot::Exporter::get_device_info: querying database");
> - my $rows = $self->{_dbh}->selectall_arrayref("
> - SELECT d.id <http://d.id>, d.snmp_managed, d.community,
> - d.down_from, d.down_until, entity.name
> <http://entity.name>, contactlist.id <http://contactlist.id>,
> - target.id <http://target.id>, target.address,
> target.version, target.parent, rr.name <http://rr.name>, zone.name
> <http://zone.name>,
> - i.id <http://i.id>, i.number, i.admin_status,
> i.monitored, i.contactlist,
> - bgppeering.bgppeeraddr, bgppeering.monitored
> - FROM rr, zone, interface i, device d
> - LEFT JOIN ipblock target ON d.snmp_target=target.id
> <http://target.id>
> - LEFT JOIN entity ON d.used_by=entity.id <http://entity.id>
> - LEFT JOIN devicecontacts ON d.id
> <http://d.id>=devicecontacts.device
> - LEFT JOIN contactlist ON contactlist.id
> <http://contactlist.id>=devicecontacts.contactlist
> - LEFT JOIN bgppeering ON d.id
> <http://d.id>=bgppeering.device
> - WHERE d.monitored=1
> - AND i.device=d.id <http://d.id>
> - AND d.name <http://d.name>=rr.id <http://rr.id>
> - AND rr.zone=zone.id <http://zone.id>
> - ");
> + if ($self->{_db_type} eq "mysql") {
> +$SQL = " SELECT d.id <http://d.id>, d.snmp_managed, d.community,
> + d.down_from, d.down_until, entity.name <http://entity.name>,
> contactlist.id <http://contactlist.id>,
> + target.id <http://target.id>, target.address, target.version,
> target.parent, rr.name <http://rr.name>, zone.name <http://zone.name>,
> + i.id <http://i.id>, i.number, i.admin_status, i.monitored, i.contactlist,
> + bgppeering.bgppeeraddr, bgppeering.monitored
> +FROM rr, zone, interface i, device d
> +LEFT JOIN ipblock target ON d.snmp_target=target.id <http://target.id>
> +LEFT JOIN entity ON d.used_by=entity.id <http://entity.id>
> +LEFT JOIN devicecontacts ON d.id <http://d.id>=devicecontacts.device
> +LEFT JOIN contactlist ON contactlist.id
> <http://contactlist.id>=devicecontacts.contactlist
> +LEFT JOIN bgppeering ON d.id <http://d.id>=bgppeering.device
> +WHERE d.monitored=1
> + AND i.device=d.id <http://d.id>
> + AND d.name <http://d.name>=rr.id <http://rr.id>
> + AND rr.zone=zone.id <http://zone.id>
> + ";
> + } elsif($self->{_db_type} eq "Pg") {
> +$SQL = "SELECT d.id <http://d.id>, d.snmp_managed, d.community,
> + d.down_from, d.down_until, entity.name <http://entity.name>,
> contactlist.id <http://contactlist.id>,
> + target.id <http://target.id>, target.address, target.version,
> target.parent, rr.name <http://rr.name>, zone.name <http://zone.name>,
> + i.id <http://i.id>, i.number, i.admin_status, i.monitored, i.contactlist,
> + bgppeering.bgppeeraddr, bgppeering.monitored
> +FROM rr, zone, interface i, device d
> +LEFT JOIN ipblock target ON d.snmp_target=target.id <http://target.id>
> +LEFT JOIN entity ON d.used_by=entity.id <http://entity.id>
> +LEFT JOIN devicecontacts ON d.id <http://d.id>=devicecontacts.device
> +LEFT JOIN contactlist ON contactlist.id
> <http://contactlist.id>=devicecontacts.contactlist
> +LEFT JOIN bgppeering ON d.id <http://d.id>=bgppeering.device
> +WHERE d.monitored=TRUE
> + AND i.device=d.id <http://d.id>
> + AND d.name <http://d.name>=rr.id <http://rr.id>
> + AND rr.zone=zone.id <http://zone.id>
> + ";
> + }
> +
> + $logger->debug("Netdot::Exporter::get_device_info: SQL:\n".$SQL);
> +
> + my $rows = $self->{_dbh}->selectall_arrayref($SQL);
>
> $logger->debug("Netdot::Exporter::get_device_info: building data
> structure");
> + $logger->debug("Netdot::Exporter::get_device_info: processing
> ".$rows." rows");
> foreach my $row ( @$rows ){
> my ($devid, $devsnmp, $community,
> $down_from, $down_until, $entity, $clid,
>
>
>
>
> --Karl
>
> Karl Putland
> Senior VoIP Engineer
>
> *SimpleSignal*
> 3600 S Yosemite, Suite 150
> Denver, CO 80237
> One Number Rings All My Phones: 303-242-8608 <tel:303-242-8608>
>
> SimpleSignal.com <http://www.simplesignal.com/> | Blog
> <http://www.simplesignal.com/blog> | Facebook
> <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> <http://twitter.com/simplesignal>
>
>
>
> On Wed, Sep 12, 2012 at 4:29 PM, Karl Putland <[email protected]
> <mailto:[email protected]>> wrote:
>
> Exporter fails while using Pg.
> boolean to integer explicit cast required.
>
>
> > - WHERE d.monitored=1
>
>
> patch changes query for Pg to be
>
> > + WHERE d.monitored='true'
>
>
>
> --Karl
>
> Karl Putland
> Senior VoIP Engineer
>
> *SimpleSignal*
>
> 3600 S Yosemite, Suite 150
> Denver, CO 80237
> One Number Rings All My Phones: 303-242-8608 <tel:303-242-8608>
>
> SimpleSignal.com <http://www.simplesignal.com/> | Blog
> <http://www.simplesignal.com/blog> | Facebook
> <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> <http://twitter.com/simplesignal>
>
>
>
> On Wed, Sep 12, 2012 at 4:05 PM, Carlos Vicente
> <[email protected] <mailto:[email protected]>> wrote:
>
> Karl,
>
> It would be useful if you explain what the patch is about.
>
> Thanks,
>
> cv
>
> On 9/12/12 5:43 PM, Karl Putland wrote:
> > --- Netdot.orig/Exporter.pm2012-08-22 20:22:42.175837081 +0000
> > +++ Netdot/Exporter.pm2012-09-11 17:35:15.191837116 +0000
> > @@ -58,6 +58,7 @@
> > }
> >
> > $self->{_dbh} = Netdot::Model->db_Main();
> > + $self->{_db_type} = Netdot::Model->config->get('DB_TYPE');
> > return $self;
> > }
> >
> > @@ -73,28 +74,49 @@
> > =cut
> > sub get_device_info {
> > my ($self) = @_;
> > + my $rows;
> >
> > return $self->cache('exporter_device_info')if
> > $self->cache('exporter_device_info');
> >
> > my %device_info;
> > $logger->debug("Netdot::Exporter::get_device_info:
> querying database");
> > - my $rows = $self->{_dbh}->selectall_arrayref("
> > - SELECT d.id <http://d.id> <http://d.id>,
> d.snmp_managed, d.community,
> > - d.down_from, d.down_until,
> entity.name <http://entity.name>
> > <http://entity.name>, contactlist.id <http://contactlist.id>
> <http://contactlist.id>,
> > - target.id <http://target.id>
> <http://target.id>, target.address,
> > target.version, target.parent, rr.name <http://rr.name>
> <http://rr.name>, zone.name <http://zone.name>
> > <http://zone.name>,
> > - i.id <http://i.id> <http://i.id>,
> i.number, i.admin_status,
> > i.monitored, i.contactlist,
> > - bgppeering.bgppeeraddr,
> bgppeering.monitored
> > - FROM rr, zone, interface i, device d
> > - LEFT JOIN ipblock target ON
> d.snmp_target=target.id <http://target.id>
> > <http://target.id>
> > - LEFT JOIN entity ON d.used_by=entity.id
> <http://entity.id> <http://entity.id>
> > - LEFT JOIN devicecontacts ON d.id <http://d.id>
> > <http://d.id>=devicecontacts.device
> > - LEFT JOIN contactlist ON contactlist.id
> <http://contactlist.id>
> > <http://contactlist.id>=devicecontacts.contactlist
> > - LEFT JOIN bgppeering ON d.id <http://d.id>
> > <http://d.id>=bgppeering.device
> > - WHERE d.monitored=1
> > - AND i.device=d.id <http://d.id>
> <http://d.id>
> > - AND d.name <http://d.name>
> <http://d.name>=rr.id <http://rr.id> <http://rr.id>
> > - AND rr.zone=zone.id <http://zone.id>
> <http://zone.id>
> > - ");
> > + if ($self->{_db_type} eq "mysql") {
> > +my $rows = $self->{_dbh}->selectall_arrayref("
> > + SELECT d.id <http://d.id> <http://d.id>,
> d.snmp_managed, d.community,
> > + d.down_from, d.down_until, entity.name
> <http://entity.name> <http://entity.name>,
> > contactlist.id <http://contactlist.id> <http://contactlist.id>,
> > + target.id <http://target.id> <http://target.id>,
> target.address, target.version,
> > target.parent, rr.name <http://rr.name> <http://rr.name>,
> zone.name <http://zone.name> <http://zone.name>,
> > + i.id <http://i.id> <http://i.id>, i.number,
> i.admin_status, i.monitored,
> > i.contactlist,
> > + bgppeering.bgppeeraddr, bgppeering.monitored
> > + FROM rr, zone, interface i, device d
> > + LEFT JOIN ipblock target ON d.snmp_target=target.id
> <http://target.id> <http://target.id>
> > + LEFT JOIN entity ON d.used_by=entity.id <http://entity.id>
> <http://entity.id>
> > + LEFT JOIN devicecontacts ON d.id <http://d.id>
> <http://d.id>=devicecontacts.device
> > + LEFT JOIN contactlist ON contactlist.id
> <http://contactlist.id>
> > <http://contactlist.id>=devicecontacts.contactlist
> > + LEFT JOIN bgppeering ON d.id <http://d.id>
> <http://d.id>=bgppeering.device
> > + WHERE d.monitored=1
> > +AND i.device=d.id <http://d.id> <http://d.id>
> > +AND d.name <http://d.name> <http://d.name>=rr.id
> <http://rr.id> <http://rr.id>
> > +AND rr.zone=zone.id <http://zone.id> <http://zone.id>
> > + ");
> > + } elsif($self->{db_type} eq "Pg") {
> > +my $rows = $self->{_dbh}->selectall_arrayref("
> > + SELECT d.id <http://d.id> <http://d.id>,
> d.snmp_managed, d.community,
> > + d.down_from, d.down_until, entity.name
> <http://entity.name> <http://entity.name>,
> > contactlist.id <http://contactlist.id> <http://contactlist.id>,
> > + target.id <http://target.id> <http://target.id>,
> target.address, target.version,
> > target.parent, rr.name <http://rr.name> <http://rr.name>,
> zone.name <http://zone.name> <http://zone.name>,
> > + i.id <http://i.id> <http://i.id>, i.number,
> i.admin_status, i.monitored,
> > i.contactlist,
> > + bgppeering.bgppeeraddr, bgppeering.monitored
> > + FROM rr, zone, interface i, device d
> > + LEFT JOIN ipblock target ON d.snmp_target=target.id
> <http://target.id> <http://target.id>
> > + LEFT JOIN entity ON d.used_by=entity.id <http://entity.id>
> <http://entity.id>
> > + LEFT JOIN devicecontacts ON d.id <http://d.id>
> <http://d.id>=devicecontacts.device
> > + LEFT JOIN contactlist ON contactlist.id
> <http://contactlist.id>
> > <http://contactlist.id>=devicecontacts.contactlist
> > + LEFT JOIN bgppeering ON d.id <http://d.id>
> <http://d.id>=bgppeering.device
> > + WHERE d.monitored='true'
> > +AND i.device=d.id <http://d.id> <http://d.id>
> > +AND d.name <http://d.name> <http://d.name>=rr.id
> <http://rr.id> <http://rr.id>
> > +AND rr.zone=zone.id <http://zone.id> <http://zone.id>
> > + ");
> > + }
> >
> > $logger->debug("Netdot::Exporter::get_device_info:
> building data
> > structure");
> > foreach my $row ( @$rows ){
> >
> >
> > --Karl
> >
> > Karl Putland
> > Senior VoIP Engineer
> >
> > *SimpleSignal*
> > 3600 S Yosemite, Suite 150
> > Denver, CO 80237
> > One Number Rings All My Phones: 303-242-8608 <tel:303-242-8608>
> >
> > SimpleSignal.com <http://www.simplesignal.com/> | Blog
> > <http://www.simplesignal.com/blog> | Facebook
> > <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> > <http://twitter.com/simplesignal>
> >
> >
> >
> > _______________________________________________
> > Netdot-devel mailing list
> > [email protected] <mailto:[email protected]>
> > https://osl.uoregon.edu/mailman/listinfo/netdot-devel
> >
>
>
> --
> cv
>
>
>
--
cv
------------------------------
Message: 5
Date: Tue, 25 Sep 2012 10:22:28 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-devel] Asset search error
To: Karl Putland <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Thanks, this will be fixed in the next release.
cv
On 9/17/12 12:33 PM, Karl Putland wrote:
> Click Management/Assets,
> Click Search button
>
>
> This is likely a Pg query issue...
>
> *System error*
>
> *96:* local @CARP_NOT = $cgc ? $cgc->() :
> caller();*97:* shortmess_heavy(@_);*98:* }*99:* *100:* *101:* sub
> confess { die longmess @_ }*102:* sub carp { warn shortmess @_
> }*103:* sub cluck { warn longmess @_ }*104:* *...*
> *error:* Asset can't SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from, maint_until
> FROM asset
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number
> LIKE ? OR maint_contract LIKE ? ) )
> : DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
> unknown
> LINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...
> ^
> HINT: No operator matches the given name and argument type(s). *You
> might need to add explicit type casts*. [for Statement "SELECT id,
> serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until
> FROM asset
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number
> LIKE ? OR maint_contract LIKE ? ) )
> " with ParamValues: 1='%%', 2='%%', 3='%%', 4='%%', 5='%%', 6='%%',
> 7='%%'] at /usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.
>
> Stack:
> [/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]
> [/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]
> [/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]
> [/usr/local/netdot/htdocs/management/asset_tasks.html:240]
> [/usr/local/netdot/htdocs/management/autohandler:81]
> [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
> [/usr/local/netdot/htdocs/autohandler:76]
> at /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.
> *context:* *...* sub croak { die shortmess @_ }
> *code stack:* /usr/local/share/perl/5.14.2/Carp.pm:100
> /usr/local/share/perl/5.14.2/Class/DBI.pm:169
> /usr/local/share/perl/5.14.2/Class/DBI.pm:1143
> /usr/local/share/perl/5.14.2/Class/DBI.pm:1083
> /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33
> /usr/local/netdot/htdocs/management/asset_tasks.html:240
> /usr/local/netdot/htdocs/management/autohandler:81
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951
> /usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21
> /usr/local/netdot/htdocs/autohandler:76
>
> raw error
> <http://netdot.simplesignal.net/netdot/management/asset_tasks.html#raw>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Asset can't SELECT id, serial_number, product_id, inventory_number, physaddr,
> reserved_for, maint_from, maint_until
> FROM asset
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for
> LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
> maint_contract LIKE ? ) )
> : DBD::Pg::st execute failed: ERROR: operator does not exist: bigint ~~
> unknown
> LINE 3: ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...
> ^
> HINT: No operator matches the given name and argument type(s). You might
> need to add explicit type casts. [for Statement "SELECT id, serial_number,
> product_id, inventory_number, physaddr, reserved_for, maint_from, maint_until
> FROM asset
> WHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR reserved_for
> LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ? OR
> maint_contract LIKE ? ) )
> " with ParamValues: 1='%%', 2='%%', 3='%%', 4='%%', 5='%%', 6='%%', 7='%%']
> at /usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.
>
> Stack:
> [/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]
> [/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]
> [/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]
> [/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]
> [/usr/local/netdot/htdocs/management/asset_tasks.html:240]
> [/usr/local/netdot/htdocs/management/autohandler:81]
> [/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]
>
> [/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]
> [/usr/local/netdot/htdocs/autohandler:76]
> at /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.
>
>
> Trace begun at /usr/local/share/perl/5.14.2/HTML/Mason/Exceptions.pm line 129
> HTML::Mason::Exceptions::rethrow_exception('Asset can\'t SELECT id,
> serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
> LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J: DBD::Pg::st
> execute failed: ERROR: operator does not exist: bigint ~~ unknown^JLINE 3:
> ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...^J
> ^^JHINT: No operator
> matches the given name and argument type(s). You might need to add explicit
> type casts. [for Statement "SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from, maint_until^JFROM
> asset^JWHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ?
> OR maint_contract LIKE ? ) )^J" with Pa!
ramValues:
1=\'%%\', 2=\'%%\', 3=\'%%\', 4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] at
/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J at
/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33.^J') called at
/usr/local/share/perl/5.14.2/Carp.pm line 100
> Carp::croak('Asset can\'t SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from, maint_until^JFROM
> asset^JWHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ?
> OR maint_contract LIKE ? ) )^J: DBD::Pg::st execute failed: ERROR: operator
> does not exist: bigint ~~ unknown^JLINE 3: ...fo LIKE $5 OR po_number LIKE $6
> OR maint_contract LIKE $7 ) ...^J
> ^^JHINT: No operator matches the given name and argument
> type(s). You might need to add explicit type casts. [for Statement "SELECT
> id, serial_number, product_id, inventory_number, physaddr, reserved_for,
> maint_from, maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
> LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J" with ParamValues:
> 1=\'%%\', 2=\'%%\', !
3=\'%%\',
4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] at
/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J') called at
/usr/local/share/perl/5.14.2/Class/DBI.pm line 169
> Class::DBI::_croak('Asset', 'Asset can\'t SELECT id, serial_number,
> product_id, inventory_number, physaddr, reserved_for, maint_from,
> maint_until^JFROM asset^JWHERE ( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
> LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )^J: DBD::Pg::st
> execute failed: ERROR: operator does not exist: bigint ~~ unknown^JLINE 3:
> ...fo LIKE $5 OR po_number LIKE $6 OR maint_contract LIKE $7 ) ...^J
> ^^JHINT: No operator
> matches the given name and argument type(s). You might need to add explicit
> type casts. [for Statement "SELECT id, serial_number, product_id,
> inventory_number, physaddr, reserved_for, maint_from, maint_until^JFROM
> asset^JWHERE ( ( custom_serial LIKE ? OR inventory_number LIKE ? OR
> reserved_for LIKE ? OR description LIKE ? OR info LIKE ? OR po_number LIKE ?
> OR maint_contract LIKE ? ) )^J" with ParamValues: 1=\'!
%%\', 2=\'
%%\', 3=\'%%\', 4=\'%%\', 5=\'%%\', 6=\'%%\', 7=\'%%\'] at
/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm line 52.^J^JStack:^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:52]^J
[/usr/local/share/perl/5.14.2/DBIx/ContextualFetch.pm:32]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1139]^J
[/usr/local/share/perl/5.14.2/Class/DBI.pm:1083]^J
[/usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm:33]^J
[/usr/local/netdot/htdocs/management/asset_tasks.html:240]^J
[/usr/local/netdot/htdocs/management/autohandler:81]^J
[/usr/local/share/perl/5.14.2/HTML/Mason/Request.pm:951]^J
[/usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj:21]^J
[/usr/local/netdot/htdocs/autohandler:76]^J', 'err',
'HTML::Mason::Exception=HASH(0x7f67b8157c18)') called at
/usr/local/share/perl/5.14.2/Class/DBI.pm line 1143
> Class::DBI::sth_to_objects('Asset',
> 'DBIx::ContextualFetch::st=HASH(0x7f67b8162de0)', 'ARRAY(0x7f67fd32c490)')
> called at /usr/local/share/perl/5.14.2/Class/DBI.pm line 1083
> Class::DBI::retrieve_from_sql('Asset', '( ( custom_serial LIKE ? OR
> inventory_number LIKE ? OR reserved_for LIKE ? OR description LIKE ? OR info
> LIKE ? OR po_number LIKE ? OR maint_contract LIKE ? ) )', '%%', '%%', '%%',
> '%%', '%%', '%%', '%%') called at
> /usr/local/share/perl/5.14.2/Class/DBI/AbstractSearch.pm line 33
> Class::DBI::AbstractSearch::search_where('Asset', 'ARRAY(0x7f67b8090b70)')
> called at /usr/local/netdot/htdocs/management/asset_tasks.html line 240
> HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
> 'search_type', 'all', 'showheader', 1, 'page', 'ASSETS') called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f67b80a0f78)',
> 'search', '', 'submit', 'Search', 'search_type', 'all', 'showheader', 1,
> 'page', 'ASSETS') 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, undef, 'search', '', 'submit',
> 'Search', 'search_type', 'all', 'showheader', 1, 'page', 'ASSETS') called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 958
> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)',
> 'page', 'ASSETS') called at /usr/local/netdot/htdocs/management/autohandler
> line 81
> HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
> 'search_type', 'all', 'showheader', 1) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 160
> HTML::Mason::Component::run_dynamic_sub('HTML::Mason::Component::FileBased=HASH(0x7f67ac00d760)',
> 'main', 'search', '', 'submit', 'Search', 'search_type', 'all',
> 'showheader', 1) called at /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm
> line 951
> HTML::Mason::Request::call_dynamic('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)',
> 'main', 'search', '', 'submit', 'Search', 'search_type', 'all',
> 'showheader', 1) called at
> /usr/local/netdot/htdocs/masondata/obj/1292882063/management/autohandler.obj
> line 21
> HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
> 'search_type', 'all', 'showheader', 1) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f67ac00d760)',
> 'search', '', 'submit', 'Search', 'search_type', 'all', 'showheader', 1)
> 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, undef, 'search', '', 'submit',
> 'Search', 'search_type', 'all', 'showheader', 1) called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Request.pm line 958
> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)',
> 'showheader', 1) called at /usr/local/netdot/htdocs/autohandler line 76
> HTML::Mason::Commands::__ANON__('search', '', 'submit', 'Search',
> 'search_type', 'all') called at
> /usr/local/share/perl/5.14.2/HTML/Mason/Component.pm line 138
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7f67ac0377a8)',
> 'search', '', 'submit', 'Search', 'search_type', 'all') 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, 'search', '', 'submit',
> 'Search', 'search_type', 'all') 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(0x7f67ac037b50)')
> called at /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm line 168
> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x7f67ac037b50)')
> called at /usr/local/share/perl/5.14.2/HTML/Mason/ApacheHandler.pm line 825
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7f67fc594c78)',
> 'Apache2::RequestRec=SCALAR(0x7f67ac1c2fc8)') called at
> /usr/local/netdot/lib/Netdot/Mason.pm line 40
> Netdot::Mason::handler('Apache2::RequestRec=SCALAR(0x7f67ac1c2fc8)') called
> at -e line 0
> eval {...} at -e line 0
>
>
>
> --Karl
>
> Karl Putland
> Senior VoIP Engineer
>
> *SimpleSignal*
> 3600 S Yosemite, Suite 150
> Denver, CO 80237
> One Number Rings All My Phones: 303-242-8608
>
> SimpleSignal.com <http://www.simplesignal.com/> | Blog
> <http://www.simplesignal.com/blog> | Facebook
> <http://www.facebook.com/SimpleSignal?ref=ts> | Twitter
> <http://twitter.com/simplesignal>
>
>
>
> _______________________________________________
> Netdot-devel mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-devel
>
--
cv
------------------------------
_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel
End of Netdot-devel Digest, Vol 66, Issue 19
********************************************
