Bug 33936 - timezone
Summary: timezone
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: About (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-07 10:03 UTC by Igor A. Sychev
Modified: 2024-07-04 20:38 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Igor A. Sychev 2023-06-07 10:03:40 UTC
If in koha-conf.xml set <timezone>Antarctica/South_Pole</timezone> and restart koha-common, then the error "Internal Server Error" comes out 
/cgi-bin/koha/about.pl
Comment 1 Katrin Fischer 2023-06-07 14:17:22 UTC
Hi Igor, are you sure about the text? I found Antarctica/McMurdo listed on Wikipedia for South Pole.
Comment 2 Igor A. Sychev 2023-06-08 03:22:56 UTC
Hi, Katrin!

This line <timezone>Antarctica/South_Pole</timezone> is taken from the wiki
https://wiki.koha-community.org/wiki/Time_Zone_Configuration

Initially I set 'Asia/Tomsk', but I got an error.

/var/log/koha/lib/indexer-output.log:
DBD::mysql::db do failed: Unknown or incorrect time zone: 'Asia/Tomsk' at /usr/share/koha/lib/Koha/Database.pm line 117.
Comment 3 David Cook 2023-06-08 05:50:08 UTC
That's a MySQL database error, so the problem is on the database side.

Take a look at something like this: https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html
Comment 4 Igor A. Sychev 2023-06-08 07:16:34 UTC
/var/log/koha/lib/indexer-output.log:
Invalid timezone in koha-conf.xml (Tomsk) at /usr/share/koha/lib/Koha/Config.pm line 205.
Comment 5 Katrin Fischer 2023-06-08 07:57:27 UTC
Have you tried setting it to the other value I suggested?
Comment 6 Igor A. Sychev 2023-06-08 08:38:20 UTC
DBD::mysql::db do failed: Unknown or incorrect time zone: 'Antarctica/McMurdo' at /usr/share/koha/lib/Koha/Database.pm line 117.
Comment 7 Katrin Fischer 2023-06-08 08:51:56 UTC
In the link David provided there is a paragraph about setting up the database for timezones. Maybe that's the cause? 

I think maybe this topic would also be better on the mailing list (more readers)
Comment 8 Jonathan Druart 2023-06-09 11:23:32 UTC
I've tried
  <timezone>Asia/Tomsk</timezone>

And about.pl shows:
Time zone: 	Used: Asia/Tomsk | Config: Asia/Tomsk | Environment (TZ): Undefined

Using 10.5.20-MariaDB-1.


What does return the following command?
  SELECT * FROM mysql.time_zone_name WHERE name="Asia/Tomsk";

Is this table empty? Did you read David's link?
https://dev.mysql.com/doc/refman/8.0/en/mysql-tzinfo-to-sql.html

Looks like the relevant command is
  `mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql`
Comment 9 Igor A. Sychev 2023-06-14 04:06:31 UTC
SELECT * FROM mysql.time_zone_name WHERE name="Asia/Tomsk";
+------------+--------------+
| Name       | Time_zone_id |
+------------+--------------+
| Asia/Tomsk |          323 |
+------------+--------------+
Comment 10 Igor A. Sychev 2023-06-14 04:10:32 UTC
After restarting memcached, the working.