https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38759 Bug ID: 38759 Summary: koha-mysql doesn't work with timezone set in koha-conf.xml Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs@lists.koha-community.org Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org CC: robin@catalyst.net.nz 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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.