Nagios Truncated return string

[jeff vier]

On Thu, 2004-07-08 at 20:22 -0700, Al Smith wrote:
>         Using Nagios 1.2 with MySQL for data storage. I've written my
>         own check_snmp to get a value from a power strip that returns
>         Amps * 10, so a 0.8 amp reading is sent back by snmpget as 8.
>         In order to watch the actual amps, and history, I set Value =
>         Value / 10, and return the string
>         
>         OK: 0.8
>         
>         The problem is with the value stored in the MySQL database,
>         and displayed on the web page, is 0. So, when amp usage on the
>         unit is low, I get an alarm telling me it is zero!
>         
>         Has anyone else seen the trucated value like this? 

Sounds like you've set your column to INT (or SMALLINT, BIGINT, etc).

read http://dev.mysql.com/doc/mysql/en/Numeric_types.html carefully.



-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 - 
digital self defense, top technical experts, no vendor pitches, 
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null