- Koha - lists.katipo.co.nz

Koha work slowly
by Arayik Manukyan 10 Apr '19

10 Apr '19

Dear list, So as we have a huge koha database with 7 million records on Koha 17.11.05 we always have such problem : during the day we noticed that koha began work slowly especially searching, we couldn't export data at that time and executed reports. We use MariaDB latest version and when execute this command "show status like Conn" we noticed that connections are very huge nearly 150 000.(See attached file)After restarted MariaDB the connections became 100. We,of course use documentation and added # key_buffer = 2000M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP max_connections = 500 max_user_connections = 500 #table_cache = 64 thread_concurrency = 300 table_cache = 30000 open_files_limit = 65000# # * Query Cache Configuration # query_cache_limit = 50M query_cache_size = 300M # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # You might want to disable InnoDB to shrink the mysqld process by circa 100MB. #skip-innodb innodb_buffer_pool_size=16777216 innodb_file_per_table We understand that it is opac search results which didn't reconnect after any search. Any suggestions? Thanks, Araik --- Это сообщение было проверено AVG на наличие вирусов. http://www.avg.com

2 1

how to generate a report on Medium (245$h) wise.
by Dixson Rodriges 10 Apr '19

10 Apr '19

Hi, I want to generate a report from koha library management software. The report should contain the following fields as well. Date Accessioned, Item Type , Title, Sub Title, Author, Barcode, Medium (245$h) Regards, Dixson

2 1

branch libraries
by Luisa Korodrau 10 Apr '19

10 Apr '19

Davuilevu Theological Library (DTCL) currently installing Koha version 18.11 and also in the process of including branch libraries in 3 different campuses of the Methodist Church in Fiji. what are the requirements in having the branches all linked up to access and use the system. Do we need to install Koha in these respective branch libraries as well? Please help thank you Luisa Korodrau DTC Librarian Nausori, Fiji

3 2

Development Idea - Improve functionality of macros in Advanced Cataloging Editor
by Johnson, Barbara 09 Apr '19

09 Apr '19

Hi everyone, Bedford Public Library is looking for other libraries to assist in sponsoring a development to improve the functionality of macros in the Advanced Cataloging Editor. The macros would be stored in the database and not lost when clearing the browser cache. And they would be private by default- for use by the person who created it. But, they have the option to make that macro public which means all staff could see it. ByWater gave us a quote of $3,000 for the development. Are there other libraries out there that would be interested in helping to sponsor this development? Thanks, Barbara -- Barbara Johnson Library Technical Services Manager Bedford Public Library 2424 Forest Ridge Drive, Bedford, TX 76021-4667 Office: 817-952-2360 | Fax: 817-952-2396 | Barbara.Johnson(a)bedfordtx.gov CONFIDENTIALITY NOTICE: This City of Bedford (CoB) email transmission is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you have received this email in error, please notify the sender immediately by return email and destroy all electronic and paper copies of the original message and any attachments immediately. --o365--

1 0

Development idea - Create digest option for auto renewal notices
by Johnson, Barbara 09 Apr '19

09 Apr '19

Hi everyone, Bedford is considering a development that would create a digest option for auto renewal notices in order to send only one digest notice instead of a separate renewal notices for every single title. ByWater provided a quote of $5,000. The development would be based on bug #18532 (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18532) which would create auto renewal notices as a patron messaging preference that would include a digest option. We'd love to hear from other libraries that could help fund this development, even if it is only a small amount. Thanks, Barbara -- Barbara Johnson Library Technical Services Manager Bedford Public Library 2424 Forest Ridge Drive, Bedford, TX 76021-4667 Office: 817-952-2360 | Fax: 817-952-2396 | Barbara.Johnson(a)bedfordtx.gov CONFIDENTIALITY NOTICE: This City of Bedford (CoB) email transmission is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you have received this email in error, please notify the sender immediately by return email and destroy all electronic and paper copies of the original message and any attachments immediately. --o365--

1 0

KohaCon19 Update
by Charles Quain 09 Apr '19

09 Apr '19

Dear Koha Community On behalf of the organising group, I am sending another update on the preparations for KohaCon19. We are delighted to announce the programme of speakers and workshops for KohaCon19 We are very excited to have Ken Chad making a Keynote talk on "Community, openness and directions for library technology" Ken is a Library Consultant of many years' standing ( https://www.kenchadconsulting.com/about/) Marshall Breeding will be talking on "Koha: Assessing the impact of the Global Community" Chris Cormack will be giving a talk titled "Kia kaha, kia kotahi rā Our strength is our unity" On top of that there will be 20 other talks and 13 workshops. You can download a pdf of the programme here ( https://docs.google.com/document/d/1POlIIKGQSBHhJKuafd9kzbXwF7LwP-euRYT2P58…) There are currently 144 delegates registered, promising a good international mix. <http://www.interleaf.ie/> *Charles S. Quain* Managing Director csq(a)interleaf.ie +353-1-286-5855 +353-87-978-5911 A98 YD30 www.interleaf.ie <http://www.interleaf.ie/products-services/Library-Applications/Scooter> <http://www.interleaf.ie/products-services/Library-Applications/Koha> <http://www.interleaf.ie/products-services/PC-Reservation-and-Print-Manageme…> We are hosting <https://www.interleaf.ie/kohacon19/> in Dublin in May 2019. (Click on the logo for more details) #kohacon19

1 0

Koha plack is not working
by Bedanta Borah 09 Apr '19

09 Apr '19

I have installed koha on Ubuntu in VirtualBox. Following are my Koha Server Information. Server information Koha version: 18.11.03.000 OS version ('uname -a'): Linux StaticStudy 4.15.0-46-generic #49-Ubuntu SMP Wed Feb 6 09:33:07 UTC 2019 x86_64 Perl interpreter: /usr/bin/perl Perl version: 5.026001 Perl @INC: /usr/share/koha/lib /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.26.1 /usr/local/share/perl/5.26.1 /usr/lib/x86_64-linux-gnu/perl5/5.26 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.26 /usr/share/perl/5.26 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base MySQL version: mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper Apache version: Server version: Apache/2.4.29 (Ubuntu) Memcached: Servers: 127.0.0.1:11211 | Namespace: koha_library | Status: running. | Config read from: koha-conf.xml Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU Date and time: 04/09/2019 09:12 Time zone: Used: Asia/Kolkata | Config: Undefined | Environment (TZ): Undefined I try to start and eneble 'Plack' through following commands sudo koha-plack --enable library sudo koha-plack --start library sudo service apache2 restart Sometimes these commands work just fine and I get a significant boost in speed. But after I turn off the virtual box and try to access it later, koha stops working (nothing appears on 127.0.0.1:8080 & 8081) untill I disable Plack through the following commands sudo koha-plack --stop library sudo koha-plack --disable library sudo service apache2 restart. And the speed also reduces significantly. Restarting Plack doesn't work. Please guide me to solve this problem.

1 0

Development co-sponsors: normalize MARC strings to deduplicate facets in catalog search
by Sarah B. Cornell 08 Apr '19

08 Apr '19

Hi folks, Apologies for cross-posting... The Portsmouth Public Library is looking for co-sponsors for a development that should fix bug 17661<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17661>. If you're bugged by the fact that "Patterson, James," and "Patterson, James." show up separately in the author facet, this should fix it! Even though clicking on both instances run the same search, the display is misleading. The development would strip trailing spaces and punctuation, compare the normalized facets, and display each one only once. ByWater has quoted us $4000, and we'd like some co-sponsors to help make this happen. Let us know if you're interested. Thanks! Sarah Sarah B. Cornell Supervisor of Technical Services Portsmouth Public Library 175 Parrott Avenue Portsmouth, NH 03801 603-766-1730 http://www.cityofportsmouth.com/library

1 0

koha-US general meeting: Wednesday, April 10th, 2019
by Jason Robb 08 Apr '19

08 Apr '19

Date: Wednesday, April 10th, 2019 Time: 10:30 AM - 11:30 AM CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) Location: https://kslib.zoom.us/j/110290143 Agenda: *https://docs.google.com/document/d/1wjkO3uszOcojPDp9uD49wm-ohoEDwCJ8xtrIVCJM3xg/edit?usp=sharing <https://docs.google.com/document/d/1wjkO3uszOcojPDp9uD49wm-ohoEDwCJ8xtrIVCJ…>* On the agenda this month: more information about the upcoming koha-US conference, updates from various committees and, as always, time to discuss bugs and other Koha issues. If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops and Android and iOS on mobile devices. For help getting started, visit: *https://support.zoom.us/hc/en-us/categories/200101697 <https://support.zoom.us/hc/en-us/categories/200101697>* These meetings are free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Unable to configure Koha 18.11 on Ubuntu 16.04
by SATISH 08 Apr '19

08 Apr '19

Hi, I am trying to fresh install Koha 18.11 on L-Ubuntu 16.04 LTS, with MySQL server, After Koha installation, while web configuring, I am getting following error. ----- The following error occurred while importing the database structure: [Wed Apr 3 16:44:16 2019] install.pl: DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails at /usr/share/perl5/DBIx/RunSQL.pm line 273. Please contact your system administrator ---- could you please guide me how to complete the configuration process. With Thanks -- *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. <http://www.git.edu/>gechassan.ac.in Library OPAC: http://library.gechassan.ac.in Library Portal : https://librarygechassan.wixsite.com/library

2 1