Bug 30468: koha-mysql does not honor Koha's timezone setting
authorKyle Hall <kyle@bywatersolutions.com>
Wed, 6 Apr 2022 12:38:00 +0000 (08:38 -0400)
committerLucas Gass <lucas@bywatersolutions.com>
Thu, 29 Sep 2022 15:22:41 +0000 (15:22 +0000)
commit5e14e2c693e2382780f25c5fe8dc32b78d011d1f
tree65328a0bed45cf4148068368eca0d3ded4f5ceee
parent7dcbbb74372cd04cee2b94e93ee5798d3f62d8a2
Bug 30468: koha-mysql does not honor Koha's timezone setting

If I run a query like "SELECT NOW()" from a koha report, I will get a different answer than if I had run it from koha-mysql.
In Koha, we set the timezone for each database connection.
However, koha-mysql does not do this, so instead we are left using the default timezone of the database.

Test Plan:
1) Set your time zone to something other than the database time zone
2) run "SELECT NOW()" using debian/scripts/koha-mysql
   *not* /usr/sbin/koha-mysql
3) Note you get the database timezone's current time
4) Apply this patch
5) Repeat step 2
6) Now you get the correct time!

Signed-off-by: Michal Urban <michalurban177@gmail.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit e97b099d58e73be44354d2343c0f45077871b398)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
debian/scripts/koha-mysql