[Koha] Check in time is behind system time

[Barton Chittenden]

Excellent!

On Wed, Jul 5, 2017 at 12:20 AM, Mubassir Ahsan <mahsandu at gmail.com> wrote:

> 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.*
>