[Koha] Check in time is behind system time

[Mubassir Ahsan]

Dear Barton,
Thanks for the hint. It was mysql database server timezone
misconfiguration. I am using MariaDB. I have solved the problem as below:
command "date" returned right date and time
but in mysql

SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);

returned -7.00 UTC Time. But my time zone is +6.00 that was the problem.
The I have set the right timezone.

SET time_zone = "+06:00";

and restarted mysql server. The problems are gone. I have followed this (
https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql)
to set the timezone.

Thanks again for your help.


On Tue, Jul 4, 2017 at 10:05 PM Barton Chittenden <
barton at bywatersolutions.com> wrote:

> Log on to your koha server via SSH.
>
> Type
>
> date
>
> If this isn't correct, you'll have to change the date on the Linux server.
>
> I'm assuming that you've got a package install of koha. You'll need to
> know the instance name of your koha installation... replace INSTANCE with
> the actual instance name below.
>
> sudo koha-myqsql INSTANCE
>
> at the SQL prompt, type
>
> SELECT CURRENT_DATETIME;
>
> if these two do not agree, my guess is that you're running your database
> on a separate server. Exit mysql and type
>
> sudo grep '^..host' /etc/koha/sites/INSTANCE/koha-conf.xml
>
> if that shows a different server, SSH into that machine and type 'date'.
> Change the date there if needed.
>
> Hope that helps.
>
> --Barton
>
>
> On Tue, Jul 4, 2017 at 5:41 AM, Mubassir Ahsan <mahsandu at gmail.com> wrote:
>
>> Hello All,
>>
>> Recently I have got that checkin time is behind the system time. My
>> current
>> System is 04 July 3:39PM but when check in items it is showing 2.19AM
>> only,
>> even in notices time is printing like this. I have check the hardware and
>> system time, it is ok.
>> Check out time is ok.
>>
>> Thanks in advance.
>> --
>>
>> *Best wishes.*
>> *--------------------*
>>
>>
>>
>> *Md. Mubassir AhsanAssistant Librarian(Library In-Charge)Southeast
>> University*
>>
>> *-----------------------------*
>> *Mobile+Viber+IMO: 01916303060 <01916-303060>*
>> *Facebook:* mmahsan <http://facebook.com/mmahsan>
>> *Skype+Twitter*: mahsandu
>> Website: Mubassir.info
>> *"Proud to be a LIS Professional*"
>> *Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace,
>> Greenstone), N/W Admin, DBA.*
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
> --

*Best wishes.*
*--------------------*



*Md. Mubassir AhsanAssistant Librarian(Library In-Charge)Southeast
University*

*-----------------------------*
*Mobile+Viber+IMO: 01916303060*
*Facebook:* mmahsan <http://facebook.com/mmahsan>
*Skype+Twitter*: mahsandu
Website: Mubassir.info
*"Proud to be a LIS Professional*"
*Tag: Web Developer, CMS (Drupal, Joomla), ILS (Koha), IR (DSpace,
Greenstone), N/W Admin, DBA.*