Search Postgresql Archives

PostgreSQL 9.0.5 concat Issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm using a Perl script to take SNMP traps and send them to Zabbix on FreeBSD 8.2-RELEASE amd64.

The original Perl script can be found at http://www.zabbix.com/wiki/howto/monitor/snmp/snmp_traps_-_a_new_solution

This script works just fine under PostgreSQL 9.0.4.

I'm using the FreeBSD ports system to manage PostgreSQL and Zabbix and I noticed that a test upgrade to PostgreSQL server 9.0.5 causes the script to break in a predictable way.

The script debug log is showing this:

/usr/local/bin/zabbix_sender --zabbix-server 127.0.0.1 --port 10051 --host Template_Dell_OpenManage

This is incorrect as 'host' should be an actual hostname and not the name of a Zabbix template (the Template_blah_blah part).

/var/log/messages on my system has some output that takes me to the following line in the script:

$dbh->selectrow_hashref("SELECT itemid,description,key_ FROM items where hostid='$hostid' and \
'$keyoidvaluenum' like concat(key_,'%') order by length(key_) desc limit 1;");

And here is the /var/log/messages output:

ERROR:  function concat(character varying, unknown) does not exist at character 98
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT:  SELECT itemid,description,key_ FROM items where hostid='10022' and '.1.3.6.1.4.1.318.0.77' like concat(key_,'%') order by length(key_) desc limit 1;

There is only one line in the script which uses the concat function so I'm sure I'm in the right spot.

I'm guessing that the concat function changed between PostgreSQL 9.0.4 and 9.0.5 in a subtle way that is breaking this script by causing the wrong information to be returned from the database.

I can see the hint being offered but I'm unsure as to how to implement this in the given line of code exactly. I would be very grateful for any advice or direction as to how I might go about fixing this item.




-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux