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
I rewrote the koha-mysql script in Bug 38760. Could you check if it works with time zones?
I'm also curious what version this started in, since it works in older stable versions like 23.11.
Please see Bug 38760
(In reply to David Cook from comment #2) > I'm also curious what version this started in, since it works in older > stable versions like 23.11. It can't have worked unless someone deleted lines - the timezone was not used at all (see the changes Lukasz made)
*** This bug has been marked as a duplicate of bug 38760 ***
(In reply to Katrin Fischer from comment #4) > (In reply to David Cook from comment #2) > > I'm also curious what version this started in, since it works in older > > stable versions like 23.11. > > It can't have worked unless someone deleted lines - the timezone was not > used at all (see the changes Lukasz made) Hm ok, the lines were only moved, but it did not work when we tested.