Bug 38759 - koha-mysql doesn't work with timezone set in koha-conf.xml
Summary: koha-mysql doesn't work with timezone set in koha-conf.xml
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Command-line Utilities (show other bugs)
Version: Main
Hardware: All All
: P5 - low minor
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-12-20 10:26 UTC by Katrin Fischer
Modified: 2025-01-08 16:10 UTC (History)
5 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 Katrin Fischer 2024-12-20 10:26:46 UTC
When a timezone is set in the koha-conf.xml file, the koha-mysql command doesn't work. This seems to be due to missing quotes around the timezone value.

For the timezone configuration see:
https://wiki.koha-community.org/wiki/Time_Zone_Configuration

If you dump the created connection command, you will see something like:

mysql --host=<host> --user=XXX --password=XXX --init-command=SET time_zone='America/Sao_Paulo' koha_XXX

This will result in an error. Quoting the value for the init-command parameter appears to fix the issue:

mysql --host=<host> --user=XXX --password=XXX --init-command="SET time_zone='America/Sao_Paulo'" koha_XXX