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: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
                CC: [email protected]

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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to