Excellent! On Wed, Jul 5, 2017 at 12:20 AM, Mubassir Ahsan <mahsandu@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@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@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@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.*