Troubleshooting
Problem
While adding the lsf cluster under Grid > Clusters, no timezones were found under "Cluster Timezone" dropdown, when adding lsf cluster and under "License Services" in RTM 10.1.
Diagnosing The Problem
Time zones in the drop down comes from the table "time_zone_name" of the mysql database.
Verify, if the table is empty.
# mysql mysql
mysql >select * from time_zone_name;
Empty set (0.00 sec)
Resolving The Problem
To solve the issue, run the below command to populate the above table "time_zone_name" and other related tables under mysql db in mysql..
# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Sample output of the table "time_zone_name" and time zones in RTM GUI is given below:
>select * from time_zone_name limit 10;
+--------------------+--------------+
| Name | Time_zone_id |
+--------------------+--------------+
| Africa/Abidjan | 1 |
| Africa/Accra | 2 |
| Africa/Addis_Ababa | 3 |
| Africa/Algiers | 4 |
| Africa/Asmara | 5 |
| Africa/Asmera | 6 |
| Africa/Bamako | 7 |
| Africa/Bangui | 8 |
| Africa/Banjul | 9 |
| Africa/Bissau | 10 |
+--------------------+--------------+
If the problem still exist, please contact support.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
isg3T1024231