Excellent! On Wed, Jul 5, 2017 at 12:20 AM, Mubassir Ahsan <mahsa...@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 < > bar...@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 <mahsa...@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.* > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha