--001636eee0fb45230e0475291ba7
Content-Type: text/plain; charset=ISO-8859-1
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
>> | |
>> | start_time | datetime | NO | MUL | 0000-00-00 00:00:00
>> | |
>> | start_time_usec | int(11) | NO | | 0
>> | |
>> | end_time | datetime | NO | | 0000-00-00 00:00:00
>> | |
>> | end_time_usec | int(11) | NO | | 0
>> | |
>> | command_object_id | int(11) | NO | | 0
>> | |
>> | command_args | varchar(255) | NO
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]