1. To your another follow-up question. -> yes.
- The configuration from source system was deployed to target system, which implicitly means
postgresql.conf was retrieved in ja_JP.UTF-8 locale on target system.
- restore tool expects English message in the log but Japanese message with same context was logged.
2. so we will enhance the installer to make sure that.
Original Message:
Sent: Tue October 31, 2023 11:57 AM
From: Gilbert Liao
Subject: Support for RHEL 8 Update
Hi Yohji,
Thanks for your details investigation.
We don't expect postgresql to be configured in non-english locale so we will enhance the installer to make sure that.
Another follow-up question. Is the postgresql in your source system (the one soarSystemBackup running on) also configured in 'ja_JP.UTF-8'?
------------------------------
Gilbert Liao
------------------------------
Original Message:
Sent: Mon October 30, 2023 01:44 AM
From: Yohji Amano
Subject: Support for RHEL 8 Update
Hi Gilbert
Thanks for your follow up.
Please disregard my previous messages since they may include my misunderstandings.
Through further investigations, I've got why I failed to restore:
The problem was that postgres log (/var/lib/pgsql/12/data/log/postgresql-<weekday 1st 3 letters>.log) was written in Japanese.
11228 2023-10-28 05:14:22.929 JST > LOG: リカバリ処理は復元ポイント"postgresql-backup-2023-10-28-050839"、時刻2023-10-28 05:09:15.134505+09 に停止します
This was because I installed SOAR at ja_JP.UTF-8 locale.
Then postgres configuration file (/var/lib/pgsql/12/data/postgresql.conf) was configured like lc_messages = 'ja_JP.UTF-8', lc_monetary = 'ja_JP.UTF-8' and so on. Due to these settings the log messages were logged in Japanese. (They may suppress the locale settings in the scripts.)
On the other hand resRestoreDatabaseToRestorePoint was invoked during soarSystemRestore command execution. Then I noticed that resRestoreDatabaseToRestorePoint suppose that the log message was ouput in English since grep is used like "recovery stopping at restore point".
Due to mismatch, resRestoreDatabaseToRestorePoint determined that something wrong happened during execution and stopped furthers.
Based on the above results and with the workaround which may not be proper ways, I could complete soarSystemRestore command with the same backup file.
------------------------------
Yohji Amano
Original Message:
Sent: Sun October 29, 2023 08:34 AM
From: Gilbert Liao
Subject: Support for RHEL 8 Update
Hi Yohji,
Can I clarify with you what organization data created under ja_JP.UTF-8 locale mean? Does that mean
a) the org is created using resuitl with ja locale. e.g., resutil neworg -name "テレビ" -orglocale "ja"
or
b) the backup file is generated using soarSystemBackup when VM's locale is set to ja_JP.UTF-8?
Thank you.
------------------------------
Gilbert Liao
Original Message:
Sent: Fri October 27, 2023 04:32 PM
From: Yohji Amano
Subject: Support for RHEL 8 Update
Hi Gilbert, thank you for clarifying the conditions.
The reason why I posted this article was I actually failed to restore the organization data created under ja_JP.UTF-8 locale while I successfully restored the data created under en_US.UTF-8. I have tried two VMs with ja_JP.UTF-8. (Backup was OK. But Restore fail) and both cases were NG. (Error seemed to be observed with postgres connection.)
So I wonder whether or not there may be some restrictions regarding locale settings.
------------------------------
Yohji Amano
Original Message:
Sent: Thu October 26, 2023 11:32 AM
From: Gilbert Liao
Subject: Support for RHEL 8 Update
Hi Yohji,
I'd like to clarify that b) organization data created under en_US.UTF-8 in your previous comment is not a mandatory requirement for RHEL8 migration.
Thanks.
------------------------------
Gilbert Liao
Original Message:
Sent: Wed October 25, 2023 08:30 PM
From: Yohji Amano
Subject: Support for RHEL 8 Update
Hi Gilbert
Thank you for your quick answers.
I'll take your affirmation would include the conditions listed in my previous post.
------------------------------
Yohji Amano
Original Message:
Sent: Wed October 25, 2023 11:07 AM
From: Gilbert Liao
Subject: Support for RHEL 8 Update
Hi Yohij, you are correct.
You can use 1) soarSystemBackup and soarSystemRestore tools to migrate your SOAR from RHEL7 to a new RHEL8 instance and this is our recommended approach.
Instead of 1), you can also choose 2) to in-place upgrade your OS and then reinstall SOAR, but please noted the OS upgrade process is not supported by IBM SOAR team.
More details for migrating a v50 BYOR SOAR to RHEL8 can be found here:
https://www.ibm.com/docs/en/sqsp/50?topic=8-migrating-standalone-software-installation
------------------------------
Gilbert Liao
Original Message:
Sent: Wed October 25, 2023 10:26 AM
From: Yohji Amano
Subject: Support for RHEL 8 Update
Hello Martin
Thanks you for the guidance about SOAR-OS upgrade from RHEL7 to RHEL8.
I would like to confirm more explicitly what conditions determine which method to choose.
For Software (Bring-Your-Own-RHEL) deployment, two methods: "Backup and restore tools" and "In-place upgrade" are described.
My current understandings with some experiments are:
a) LVM configuration is used for soar programs
(some free spaces in Volume Group to accomodate logical volumne for /crypt/attachments and logical volumes for snapshots)
b) organization data created under en_US.UTF-8
1) "Backup and restore tools"
conditions: both (a) and (b) are met
2) "In-place upgrade"
conditions: the other cases of (1)
Is this correct?
------------------------------
Yohji Amano