Nagios Support Forum

--001636ed734f022e4c0475298360
Content-Type: text/plain; charset=ISO-8859-1

Appears to be a bug open on this issue. Can someone advise on this issue.
Is it a ndoutils issue or nagios -3.2 issue. Please advise on this. Thanks

http://tracker.nagios.org/view.php?id=73


On Mon, Oct 5, 2009 at 5:08 AM, shadih rahman wrote:

> Can someone advise why was characterset change to latin1 ?
>
>
> On Mon, Oct 5, 2009 at 5:06 AM, shadih rahman wrote:
>
>> Here is an actual query which is coming as empty. Please advise on this.
>> Thanks
>>
>> INSERT INTO nagios_hostchecks SET instance_id='1', host_object_id='1501',
>> check_type='0', is_raw_check='0', current_check_attempt='1',
>> max_check_attempts='3', state='0', state_type='1',
>> start_time=FROM_UNIXTIME(1254718978), start_time_usec='231137',
>> end_time=FROM_UNIXTIME(0), end_time_usec='0', timeout='30',
>> early_timeout='0', execution_time='0.000000', latency='0.230000',
>> return_code='0', output='', perfdata='(null)', command_object_id='2',
>> command_args='', command_line='/usr/lib64/nagios/plugins/check_fping -H
>> xxxxx\.net\.xxxxxx -w 3000\.0,100% -c 3000\.0,100% -n 1' ON DUPLICATE KEY
>> UPDATE instance_id='1', host_object_id='1501', check_type='0',
>> is_raw_check='0', current_check_attempt='1', max_check_attempts='3',
>> state='0', state_type='1', start_time=FROM_UNIXTIME(1254718978),
>> start_time_usec='231137', end_time=FROM_UNIXTIME(0), end_time_usec='0',
>> timeout='30', early_timeout='0', execution_time='0.000000',
>> latency='0.230000', return_code='0', output='', perfdata='(null)' |
>> | 612 | root | localhost | nagios | Query | 0 | NULL | show full
>> processlist
>>
>>
>>
>>
>> On Mon, Oct 5, 2009 at 3:11 AM, shadih rahman wrote:
>>
>>> I used alter table for all table mentioned in the patch.
>>>
>>> cat mysql-upgrade-1.4b8.sql
>>> ALTER TABLE `nagios_hostchecks` ADD COLUMN `long_output` varchar(8192)
>>> NOT NULL default '' AFTER `output`;
>>> ALTER TABLE `nagios_hoststatus` ADD COLUMN `long_output` varchar(8192)
>>> NOT NULL default '' AFTER `output`;
>>> ALTER TABLE `nagios_servicechecks` ADD COLUMN `long_output` varchar(8192)
>>> NOT NULL default '' AFTER `output`;
>>> ALTER TABLE `nagios_servicestatus` ADD COLUMN `long_output` varchar(8192)
>>> NOT NULL default '' AFTER `output`;
>>> ALTER TABLE `nagios_statehistory` ADD COLUMN `long_output` varchar(8192)
>>> NOT NULL default '' AFTER `output`;
>>>
>>> ALTER TABLE `nagios_eventhandlers` ADD COLUMN `long_output` varchar(8192)
>>> NOT NULL default '' AFTER `output`;
>>> ALTER TABLE `nagios_systemcommands` ADD COLUMN `long_output`
>>> varchar(8192) NOT NULL default '' AFTER `output`;
>>> ALTER TABLE `nagios_notifications` ADD COLUMN `long_output` varchar(8192)
>>> NOT NULL default '' AFTER `output`;
>>>
>>>
>>>
>>>
>>> mysql> desc nagios_hostchecks
>>> -> ;
>>>
>>> +-----------------------+---------------+------+-----+---------------------+----------------+
>>> | Field | Type | Null | Key |
>>> Default | Extra |
>>>
>>> +-----------------------+---------------+------+-----+---------------------+----------------+
>>> | hostcheck_id | int(11) | NO | PRI |
>>> NULL | auto_increment |
>>> | instance_id | smallint(6) | NO | MUL |
>>> 0 | |
>>> | host_object_id | int(11) | NO | |
>>> 0 | |
>>> | check_type | smallint(6) | NO | |
>>> 0 | |
>>> | is_raw_check | smallint(6) | NO | |
>>> 0 | |
>>> | current_check_attempt | smallint(6) | NO | |
>>> 0 | |
>>> | max_check_attempts | smallint(6) | NO | |
>>> 0 | |
>>> | state | smallint(6) | NO | |
>>> 0 | |
>>> | state_type | smallint(6) | NO | |
>>> 0

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]