- Koha - lists.katipo.co.nz

Unable to Access Koha # Critical
by SATISH 03 Sep '19

03 Sep '19

Hi, With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57 I am not able to access to Koha Server. however, I can connect to System (from SSH, putty). I am unable to connect to mysql database. I am not sure about any reason, because, it was running successfully and only during weekend (sunday), system was not accessed. but, when I tried to access Koha for Checkout and Checkin today, I am facing problem It is very critical for me to get this fixed, as it is a busy day for users and for me. Kindly help to fix this error. I am looking forward to hearing from you. #Critical Problem #Priority 1 So for I tried to know the status of MySQL: (as 'root' user) 1) mysql login ------------------------ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 2) Mysql Status --------------------------- service mysql start start: Job failed to start 3) System Log Verification ---------------------------- tail -f syslog Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init time plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Linux version 3.13.0-91-generic (buildd@lgw01-35) (gcc version 4.8.4 (Ubuntu 4.8.4-2ubuntu1~14.04.3) ) #138-Ubuntu SMP Fri Jun 24 15:58:13 UTC 2016 (Ubuntu 3.13.0-91.138-generic 3.13.11-ckt39) Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] KERNEL supported cpus: Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init alert plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] Intel GenuineIntel Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init thermometer plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] AMD AuthenticAMD Sep 3 11:07:42 gechlibrary bluetoothd[786]: Failed to init gatt_example plugin Sep 3 11:07:42 gechlibrary kernel: [ 0.000000] NSC Geode by NSC Sep 3 11:07:42 gechlibrary bluetoothd[786]: Bl 4) PID ps aux | grep mysqld root 3603 0.0 0.0 4688 832 pts/2 S+ 11:19 0:00 grep --color=auto mysqld 5) MySQL log ----------------- /var/log/mysql/error.log is empty 6) MySQL Status ------------------------------ # mysqld status 190903 11:30:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead. 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Note] mysqld (mysqld 5.5.57-0ubuntu0.14.04.1-log) starting as process 4036 ... 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Can't create test file /var/lib/mysql/gechlibrary.lower-test 190903 11:30:48 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 190903 11:30:48 [Note] Plugin 'FEDERATED' is disabled. 190903 11:30:48 InnoDB: The InnoDB memory heap is disabled 190903 11:30:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190903 11:30:48 InnoDB: Compressed tables use zlib 1.2.8 190903 11:30:48 InnoDB: Using Linux native AIO mysqld: Can't create/write to file '/tmp/ibg0My0n' (Errcode: 30) 190903 11:30:48 InnoDB: Error: unable to create temporary file; errno: 30 190903 11:30:48 [ERROR] Plugin 'InnoDB' init function returned error. 190903 11:30:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. mysqld: Too many arguments (first extra is 'status'). Use --verbose --help to get a list of available options 190903 11:30:48 [ERROR] Aborting 190903 11:30:48 [Note] mysqld: Shutdown complete -- *Satish MV* Librarian - Govt. Engineering College Opp. Dairy Circle, B.M.Road, Hassan 573 201 Karnataka, INDIA Mobile: +91 9449765737 Personal Email: lis4satish(a)gmail.com College Website: www.gechassan.ac.in Library OPAC: http://library.gechassan.ac.in Library Portal : https://librarygechassan.wixsite.com/library

3 4

Issue with email configuration_not able to send email to patron
by Library biet 03 Sep '19

03 Sep '19

Hi, This is Shashikiran M working as Asst Librarian, I installed KOHA live DVD on my new system and then it was updated to KOHA 19.05 at that time i'm able to send email to patron, after that I took backup from my old system and restored into the new system (PC) after restoring the database into the new system I'm not able to send email to Patron. Can you please help me out. Thanks and regards Shashikiran M Asst Librarian BIET

2 1

which is best ubuntu version to install koha
by Yatheesh lis 03 Sep '19

03 Sep '19

Hi which is best ubuntu version to install koha -- Y.Yatheesh Babu

1 0

[Debian][Buster] Can Buster be used in production?
by Father Vlasie 03 Sep '19

03 Sep '19

Hello Fellow Kohaers, Is anyone using Debian 10 (Buster) as a platform for Koha? My main attraction to it is native support for MariaDB 10.3 which fixes the AUTO_INCREMENT bug. I have a test install (Koha 19) that seems fine but I thought I would try for feedback before deploying it in production. Thank you, FV

1 0

Fwd: Help requied for koha installation in ubuntu 18.04
by Ramakant 02 Sep '19

02 Sep '19

Dear sir, I am facing the below error while launch koha client. which is installed in ubuntu 18.04.How to resolve the problem. Software error: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 107. Thanks Ramakant On 1 Sep 2019, 10:00 PM, at 10:00 PM, ramakant(a)iitk.ac.in wrote: >Dear sir, > >I am facing the below error while launch koha client. which is >installed >in ubuntu 18.04.How to resolve the problem. > >Software error: > >DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: >Access >denied for user 'koha_library'@'localhost' (using password: YES) at >/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at >/usr/share/koha/lib/Koha/Database.pm line 107 > >For help, please send mail to the webmaster ([no address given]), >giving >this error message and the time and date of the error. > >Thanks > >Ramakant

2 1

Koha 18.04 problem
by ramakant＠iitk.ac.in 02 Sep '19

02 Sep '19

Dear sir, I am facing the below error while launch koha client. which is installed in ubuntu 18.04.How to resolve the problem. Software error: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Access denied for user 'koha_library'@'localhost' (using password: YES) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1520. at /usr/share/koha/lib/Koha/Database.pm line 107 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Regards, ============== Ramakant

1 0

Rancor macros
by Carlos Lopez 01 Sep '19

01 Sep '19

Hi all We've been happily using Rancor for bibliographic MARC editing for close to a year. We also have a few simple macros (for example to add RDA 33X tags, or to move system numbers from 001/003 to 035). Does anyone know whether we can write a macro that will (for example) delete tags with a specific value in the 2nd indicator? (for example, 650 tags with indicators _7). With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | library.dmlibrary.org.au

2 1

Koha calculating but not showing overdue fines
by muiru james 01 Sep '19

01 Sep '19

Hi, My system is now calculating overdue fines after setting the homelibrary field but its only after checking in the overdue item that you can see the amount of fine. On the patrons account, its only showing the user as having overdue items but not showing what amount of fine has accrued. What can I do for the amount accrued to be shown even while the item is still checked out? Someone please help Thank you Best Regards On Wed, 21 Aug 2019 10:59 muirunyeri <muirunyeri(a)gmail.com wrote: > Hi, > > While Koha is now calculating fines, its only possible to see the fine > after item checkin. Its only showing a user as having overdue items but no > amount of fine accrued before checkin. What can be done to show on the > screen the amount accrued even while the item is still checked out? > > Best Regards > > > > Sent from my Samsung Galaxy smartphone. > -------- Original message -------- > From: muirunyeri <muirunyeri(a)gmail.com> > Date: 16/08/2019 14:12 (GMT+03:00) > To: Alvaro Cornejo <cornejo.alvaro(a)gmail.com>, koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Koha Not calculating and charging overdue fines > > Hi, > > Thanks Alvaro. The code worked and now overdue is calculating > > Best regards > > > > Sent from my Samsung Galaxy smartphone. > -------- Original message -------- > From: Alvaro Cornejo <cornejo.alvaro(a)gmail.com> > Date: 15/08/2019 16:42 (GMT+03:00) > To: muirunyeri <muirunyeri(a)gmail.com> > Cc: Carlos Lopez <clopez(a)dml.vic.edu.au>, koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Koha Not calculating and charging overdue fines > > Hi Muirunyeri > > You can access mysql and run a command like: > > > UPDATE `items` SET `homebranch` = `YourHomeBranchID' [WHERE homebranch is NULL]; > > As you will be editing your database directly, you should backup your > system before. > > Regards, > > Alvaro > > > |-----------------------------------------------------------------------------------------------------------------| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > y GPRS online > Visitenos en www.perusms.com > > > Le jeu. 15 août 2019 à 01:54, muirunyeri <muirunyeri(a)gmail.com> a écrit : > >> Hi Carlos, >> I ran the report which returns a single column with item numbers. It >> indeed confirms all items are without home branch. However, no batch >> editing option. >> Any assistance to solve this is highly appreciated. >> Thanks >> >> Sent from my Samsung Galaxy smartphone.-------- Original message >> --------From: Carlos Lopez <clopez(a)dml.vic.edu.au> Date: 15/08/2019 >> 02:02 (GMT+03:00) To: muirunyeri <muirunyeri(a)gmail.com>, >> koha(a)lists.katipo.co.nz Subject: RE: [Koha] Fwd:Re: Koha Not >> calculating and charging overdue fines >> Hi Muirunyeri >> If the homebranch field is empty, you could run a report from this query: >> SELECT itemnumber >> FROM items >> WHERE homebranch is NULL >> >> You should even get a little "Batch modify" button at the top of your >> results. >> >> With kind regards from the Dalton McCaughey Library Team >> >> Carlos Lopez >> >> Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 >> Ph: 03 9340 8888 ext.1 | library(a)dml.vic.edu.au | >> library.dmlibrary.org.au >> >> -----Original Message----- >> From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of muirunyeri >> Sent: Thursday, 15 August 2019 5:56 AM >> To: koha(a)lists.katipo.co.nz >> Subject: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines >> >> >> >> >> >> Sent from my Samsung Galaxy smartphone.-------- Original message >> --------From: muirunyeri <muirunyeri(a)gmail.com> Date: 14/08/2019 22:54 >> (GMT+03:00) To: katrin.fischer.83(a)web.de Subject: Re: Re: [Koha] Koha >> Not calculating and charging overdue fines >> Hi, >> >> I have around 44,000 items that were imported from excel. The homebranch >> field is blank and this might be the cause if the non-calculating overdue >> fines. How can i edit items to fill this field (batch)? The homebranch >> field is not available on the items form. If its hidden, how can I unhide >> it? >> >> You could also give me an SQL code if it'll get the > > >> Sent from my Samsung Galaxy smartphone. >> >> >> -------- Original message -------- >> From: Katrin Fischer <katrin.fischer.83(a)web.de> >> >> Date: 06/08/2019 19:14 (GMT+03:00) >> To: koha(a)lists.katipo.co.nz >> Subject: Re: [Koha] Koha Not calculating and charging >> overdue fines >> >> >> >> >> Hi all, >> >> >> >> I think what Caroline described would work well for a dev (git) >> or >> >> standard (tarball) installation, while things with the packages >> work a >> >> little differently like Michael describes. So it might depend on >> your >> >> installation type on what you should do. >> >> >> >> For package installations the fines.pl should be scheduled by >> default to >> >> run daily. >> >> >> >> Have you checked everything else that might prevent fines from >> calculating? >> >> >> >> - finesmode systempreference? >> >> - Holidays in the calendar? >> >> - Circulation rules correct? For example sometimes it's easy to >> miss >> >> that rules for 'all libraries' might have been overwritten by >> branch >> >> specific ones. >> >> >> >> Hope this helps, >> >> >> >> Katrin >> >> >> >> On 06.08.19 17:07, Michael Kuhn wrote: >> >> > Hi >> >> > >> >> > >> I think this' where my solution lies however the >> cron -l command >> >> > >> replies no cron command for my user account. I >> have 2 accounts >> >> > >> showing i.e. the admin account and the >> koha_instance account. >> >> > >> >> >> > >> I hope i was supposed to run it thru the main >> account coz thats where >> >> > >> I log in. >> >> > >> >> >> > >> Or what might I be doing wrong? I believe the cron >> list should have >> >> > >> something. Please advise. >> >> > >> >> > I'm not sure if this is of any help, but in the Koha 19.05 >> standard >> >> > the script "fines.pl" is executed in file >> >> > "/etc/cron.daily/koha-common" as follows: >> >> > >> >> > koha-foreach --chdir --enabled >> /usr/share/koha/bin/cronjobs/fines.pl >> >> > >> >> > Thus not in any user controlled crontab. Also the path is >> not >> >> > "misc/cronjobs/fines.pl". >> >> > >> >> > Best wishes: Michael >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> >> Koha(a)lists.katipo.co.nz >> >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> -- >> >> Click here to report this message as spam: >> https://console.mailguard.com.au/ras/1WjDFG6Rrm/6w1jxU3YIDrNJIQQ56V7oe/0.4 >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >

2 1

Error message while Staging MARC records
by Elaine Bradtke 01 Sep '19

01 Sep '19

Can anyone tell me what this might mean? Software error: /usr/share/koha/intranet/cgi-bin/tools/stage-marc Elaine Bradtke VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

2 4

Koha upgrade from 3.2 to 19.05
by Sultan Qaboos Cultural Center Library 01 Sep '19

01 Sep '19

Hello, Our library is planning to upgrade Koha from the version 3.2 to 19.05 (latest). Could you please give us a complete tutorial, system requirements, and the things we have to do (backup ?, etc,) before starting the upgrade. Is it possible to upgrade directly from 3.2 to 19.05 ? or we have to upgrade to lower versions before? Best regards, Walid -- *Sultan Qaboos Cultural Center Library* 1100 16th St, NW Washington, DC 20036 library(a)sqcc.org 202-677-3967, x104

4 6