Sending Japanese text in NRDP Output

mrochelle · Post by **mrochelle** » Tue Jan 18, 2022 10:53 am

Question - I'm attempting to send Japanese language text output via NRDP client commands. When I send the output with Japanese language text the Nagios GUI displays "è¦å‘Š:å±é™ºã‚¦ã‚£ãƒ«ãƒãƒ“ ãƒ³ã‚½ãƒ³" for the Japanese text "警告:危険ウィルロビンソン!". The English version is "WARNING: Danger Will Robinson!". If I view the NRDP monitor in nagios core the Japanese text is good. I have the option ""charset" => "utf8", set in /usr/local/nagiosxi/html/config.inc.php from my prior topic similar. You can easily recreate this under the menu item Admin => Check Transfers => Inbound Transfers.
Thanks in advance, Marcus

ssax · Post by **ssax** » Tue Jan 18, 2022 5:52 pm

I labbed this up in XI 5.8.7 with EL7 and it worked properly on mine.

Please PM me a copy of your profile.zip, you can download it from Admin > System Profile by clicking the Download Profile button.

mrochelle · Post by **mrochelle** » Tue Jan 18, 2022 6:19 pm

Profile attached.

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.

ssax · Post by **ssax** » Tue Jan 18, 2022 6:43 pm

What are the output of these commands?

Code: Select all

mysql -uroot -pnagiosxi nagios -e 'status;'
mysql -uroot -pnagiosxi nagios -e 'show create table nagios_servicestatus;'

You should also make sure you have the same "charset" => "utf8", under the nagiosxi and the nagiosql databases in your /usr/local/nagiosxi/html/config.inc.php as well. It should have that set on all three of the databases.

mrochelle · Post by **mrochelle** » Tue Jan 18, 2022 9:36 pm

Added recommended updates to config.inc.php.
--------------
mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1

Connection id: 30140
Current database: nagios
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 5.5.68-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 11 hours 44 min 6 sec

Threads: 50 Questions: 721875 Slow queries: 0 Opens: 2668 Flush tables: 2 Open tables: 32 Queries per second avg: 17.087
--------------

mysql -uroot -pnagiosxi nagios -e 'show create table nagios_servicestatus;'
+----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| nagios_servicestatus | CREATE TABLE `nagios_servicestatus` (
`servicestatus_id` int(11) NOT NULL AUTO_INCREMENT,
`instance_id` smallint(6) NOT NULL DEFAULT '0',
`service_object_id` int(11) NOT NULL DEFAULT '0',
`status_update_time` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`output` text NOT NULL,
`long_output` text NOT NULL,
`perfdata` text NOT NULL,
`current_state` smallint(6) NOT NULL DEFAULT '0',
`has_been_checked` smallint(6) NOT NULL DEFAULT '0',
`should_be_scheduled` smallint(6) NOT NULL DEFAULT '0',
`current_check_attempt` smallint(6) NOT NULL DEFAULT '0',
`max_check_attempts` smallint(6) NOT NULL DEFAULT '0',
`last_check` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`next_check` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`check_type` smallint(6) NOT NULL DEFAULT '0',
`check_options` smallint(6) NOT NULL DEFAULT '0',
`last_state_change` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`last_hard_state_change` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`last_hard_state` smallint(6) NOT NULL DEFAULT '0',
`last_time_ok` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`last_time_warning` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`last_time_unknown` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`last_time_critical` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`state_type` smallint(6) NOT NULL DEFAULT '0',
`last_notification` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`next_notification` datetime NOT NULL DEFAULT '1970-01-01 00:00:01',
`no_more_notifications` smallint(6) NOT NULL DEFAULT '0',
`notifications_enabled` smallint(6) NOT NULL DEFAULT '0',
`problem_has_been_acknowledged` smallint(6) NOT NULL DEFAULT '0',
`acknowledgement_type` smallint(6) NOT NULL DEFAULT '0',
`current_notification_number` smallint(6) NOT NULL DEFAULT '0',
`passive_checks_enabled` smallint(6) NOT NULL DEFAULT '0',
`active_checks_enabled` smallint(6) NOT NULL DEFAULT '0',
`event_handler_enabled` smallint(6) NOT NULL DEFAULT '0',
`flap_detection_enabled` smallint(6) NOT NULL DEFAULT '0',
`is_flapping` smallint(6) NOT NULL DEFAULT '0',
`percent_state_change` double NOT NULL DEFAULT '0',
`latency` double NOT NULL DEFAULT '0',
`execution_time` double NOT NULL DEFAULT '0',
`scheduled_downtime_depth` smallint(6) NOT NULL DEFAULT '0',
`failure_prediction_enabled` smallint(6) NOT NULL DEFAULT '0',
`process_performance_data` smallint(6) NOT NULL DEFAULT '0',
`obsess_over_service` smallint(6) NOT NULL DEFAULT '0',
`modified_service_attributes` int(11) NOT NULL DEFAULT '0',
`event_handler` varchar(255) NOT NULL DEFAULT '',
`check_command` varchar(2048) NOT NULL DEFAULT '',
`normal_check_interval` double NOT NULL DEFAULT '0',
`retry_check_interval` double NOT NULL DEFAULT '0',
`check_timeperiod_object_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`servicestatus_id`),
UNIQUE KEY `object_id` (`service_object_id`),
KEY `instance_id` (`instance_id`),
KEY `status_update_time` (`status_update_time`),
KEY `current_state` (`current_state`),
KEY `check_type` (`check_type`),
KEY `state_type` (`state_type`),
KEY `last_state_change` (`last_state_change`),
KEY `notifications_enabled` (`notifications_enabled`),
KEY `problem_has_been_acknowledged` (`problem_has_been_acknowledged`),
KEY `active_checks_enabled` (`active_checks_enabled`),
KEY `passive_checks_enabled` (`passive_checks_enabled`),
KEY `event_handler_enabled` (`event_handler_enabled`),
KEY `flap_detection_enabled` (`flap_detection_enabled`),
KEY `is_flapping` (`is_flapping`),
KEY `percent_state_change` (`percent_state_change`),
KEY `latency` (`latency`),
KEY `execution_time` (`execution_time`),
KEY `scheduled_downtime_depth` (`scheduled_downtime_depth`)
) ENGINE=MyISAM AUTO_INCREMENT=7461 DEFAULT CHARSET=utf8 COMMENT='Current service status information' |
+----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

ssax · Post by **ssax** » Wed Jan 19, 2022 6:14 pm

That looks good.

Submit the result with this data again:

Code: Select all

TESTING123警告:危険ウィルロビンソン!

Then send the output of this command:

Code: Select all

mysql -uroot -pnagiosxi nagios -e "select * from nagios_servicestatus where output like 'TESTING123%' \G;"

mrochelle · Post by **mrochelle** » Wed Jan 19, 2022 7:54 pm

Using TESTING123警告:危険ウィルロビンソン!
Result TESTING123è¦å‘Š:å±é™ºã‚¦ã‚£ãƒ«ãƒãƒ“ãƒ³ã‚½ãƒ³!

mysql -uroot -pnagiosxi nagios -e "select * from nagios_servicestatus where output like 'TESTING123%' \G;"
*************************** 1. row ***************************
servicestatus_id: 7469
instance_id: 1
service_object_id: 1704
status_update_time: 2022-01-19 18:49:11
output: TESTING123è¦å‘Š:å�±é™ºã‚¦ã‚£ãƒ«ãƒãƒ“ãƒ³ã‚½ãƒ³!
long_output:
perfdata: perfdata=1;
current_state: 1
has_been_checked: 1
should_be_scheduled: 0
current_check_attempt: 1
max_check_attempts: 1
last_check: 2022-01-19 18:49:04
next_check: 2022-01-18 08:09:12
check_type: 1
check_options: 0
last_state_change: 2022-01-18 08:13:04
last_hard_state_change: 2022-01-18 08:13:04
last_hard_state: 1
last_time_ok: 2022-01-13 17:19:22
last_time_warning: 2022-01-19 18:49:04
last_time_unknown: 1969-12-31 18:00:00
last_time_critical: 2022-01-18 08:13:04
state_type: 1
last_notification: 1969-12-31 18:00:00
next_notification: 1969-12-31 18:00:00
no_more_notifications: 0
notifications_enabled: 0
problem_has_been_acknowledged: 0
acknowledgement_type: 0
current_notification_number: 0
passive_checks_enabled: 1
active_checks_enabled: 0
event_handler_enabled: 1
flap_detection_enabled: 0
is_flapping: 0
percent_state_change: 3.88158
latency: 0
execution_time: 0
scheduled_downtime_depth: 0
failure_prediction_enabled: 0
process_performance_data: 1
obsess_over_service: 1
modified_service_attributes: 0
event_handler:
check_command: check_dummy!2!"No Check Results Received in the Past 60 Seconds"!!!!!!
normal_check_interval: 1
retry_check_interval: 1
check_timeperiod_object_id: 139

ssax · Post by **ssax** » Thu Jan 20, 2022 5:19 pm

I'm thinking it's likely something in NDO2DB since Core shows properly.

Please run this command and attach the resulting /tmp/nagios_schema.sql file:

Code: Select all

mysqldump -uroot -pnagiosxi --no-data nagios > nagios_schema.sql

It will likely go to PrivateTmp so you can find it like this:

Code: Select all

find / -name nagios_schema.sql

mrochelle · Post by **mrochelle** » Fri Jan 21, 2022 4:53 pm

nagios_schema.sql file attached.

nagios_schema.sql

ssax · Post by **ssax** » Mon Jan 24, 2022 10:13 am

That all looks good.

Please create a ticket for this and include a link back to this forum thread so we can get a remote session setup to debug further:

https://support.nagios.com/tickets/

Thank you!

Nagios Support Forum

Sending Japanese text in NRDP Output

Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output

Re: Sending Japanese text in NRDP Output