- Koha-devel - lists.koha-community.org

Cleaning up...
by Mark Tompsett 18 Sep '15

18 Sep '15

Greetings, mysql> SELECT table_name, table_rows, round(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES where table_schema = "koha_library" and ((data_length+index_length)/1024/1024)>10 order by (data_length+index_length); +-------------------------+------------+------------+ | table_name | table_rows | Size in MB | +-------------------------+------------+------------+ | marc_subfield_structure | 48064 | 11.73 | | statistics | 26298 | 11.98 | | biblio | 96620 | 14.03 | | deleteditems | 27767 | 14.48 | | import_biblios | 136336 | 36.33 | | deletedbiblioitems | 19509 | 61.45 | | items | 122738 | 67.25 | | nozebra | 264699 | 76.66 | | import_items | 147630 | 130.19 | | biblioitems | 103188 | 343.14 | | import_records | 113028 | 659.55 | | biblioimages | 1176 | 919.47 | +-------------------------+------------+------------+ 12 rows in set (0.33 sec) So, I was looking to clean up the database a bit, so I figured I’d see what was taking up the most space. The import_{something} series of tables looked like promising clean up candidates. After all, who doesn’t want to free up 750MB or more when running in a 40GB VM? This led me to this pretty schema page: http://schema.koha-community.org/tables/import_records.html QUESTION: Would there be any problems if I deleted records associated with import_batch_id’s prior to a given date in these related import_{something} tables? Grace, Peace, Mercy, and Love, Mark Tompsett

7 11

About the dependency Test::CGI::Multipart
by Tajoli Zeno 17 Sep '15

17 Sep '15

Hi to all, I write to advice about the module Test::CGI::Multipart It is an optional module, connect with test. Attention that it is availabe only in whezzy as .deb, it is not presente in jessied (or in sid or in testing). It was added with bug 6874, this commit: http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=209faec1830… Probalby we need to create the package in koha repo. Bye Zeno Tajoli -- Zeno Tajoli /Dipartimento Sviluppi Innovativi/ - Automazione Biblioteche Email: z.tajoli(a)cineca.it Fax: 051/6132198 *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)

5 5

Kohacon 2016 location
by Mirko Tietgen 16 Sep '15

16 Sep '15

Hello everyone, the voting period is over and the preliminary results are in. Kohacon 2016 will be hosted by Aristotle University of Thessaloniki, Greece. Congratulations! The survey has been completed 1074 times. In some cases, people were overly enthusiastic and had to vote more than once, which lead to disqualification. The results are 80,35% Thessaloniki, Greece 08,10% Manila, Philippines [11,55% invalid] I'd like to thank the people behind both proposals for offering to host Kohacon 2016! See you all in Thessaloniki next May or June, Mirko -- Mirko Tietgen mirko(a)abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de

1 0

Ubuntu12.04+MariaDB Jenkins node removed
by Tomas Cohen Arazi 16 Sep '15

16 Sep '15

Hi, as current master is not supposed to support Ubuntu 12.04, I've just removed the tests on that node. We should set a Debian 8 + MariaDB node. If anyone has a spare VM that could be contributed for that purpose, just let me know. -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B76C 6E7C 2D80 551A C765 E225 0A27 2EA1 B2F3 C15F

1 0

Install master on debian jessie
by Tajoli Zeno 16 Sep '15

16 Sep '15

Hi to all, i'm try to install git master version on debian jessie. I installed modules using repo deb http://debian.koha-community.org/koha stable main [unstable doesn't work now] using the commands: sudo apt-get install koha-deps sudo apt-get install koha-perldeps sudo apt-get install liblog-log4perl-perl sudo apt-get install libplack-middleware-reverseproxy-perl sudo apt-get install memcached then I do git clone, checked and installed perl dependecies. For apache I installed sudo a2enmod rewrite deflate sudo a2enmod cgi sudo a2dissite 000-default sudo a2ensite koha Now there problem on apache. The intranet log says: [Tue Sep 15 17:25:04.573995 2015] [authz_core:error] [pid 7132] [client 10.0.2.2:54862] AH01630: client denied by server configuration It seems connect with this change from 2.2 to 2.4: http://httpd.apache.org/docs/2.4/upgrading.html -> Authorization I try to do the change from 2.2 configuration: Order deny,allow Deny from all to 2.4 configuration: Require all denied But it does't work. Do you have any more idea on the topic ? Bye Zeno Tajoli -- Zeno Tajoli /Dipartimento Sviluppi Innovativi/ - Automazione Biblioteche Email: z.tajoli(a)cineca.it Fax: 051/6132198 *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)

3 2

Call for development news: September Newsletter
by kohanews 16 Sep '15

16 Sep '15

Let the community hear what cool things you're working on! Bugs that need testing, sign-offs and user feedback? k o h a news AT gmail dot com Thank you! -- Chad Roseburg Editor, Koha Newsletter

1 0

Thoughts about timing and Koha schedules
by Brendan Gallagher 14 Sep '15

14 Sep '15

Hi All - ByWater is on its 7th year, so we have a solid set of data for analyzing, and recently I've noticed a few things. Let me try and paint the picture. Major Koha releases are every six months and usually the 22nd day of the month, with the target being November and May. (Please correct me if I am wrong) Library funding cycles in the US run either fiscal year (July to June), Calendar year (January to December), or some odd fiscal year close to the July~June year. Ok that being said from the time management situation with ByWater that introduces a few complexities. (Let me describe the workflow and maybe you'll see what I am talking about) Most of the time a library will sign a migration contract with us that dictates we must have them "go-live" before a certain fiscal date OR the library isn't really able to "sign" a contract for services until a certain fiscally motivated date (which places us into a similar roll-out). That being said we find that May and November (plus and minus a month) are our busiest times of the year. I've got 3 people on the road for education/training, 3 people heavily in the fields of migrations scripts, and 3 developers that are heavily in the field of meeting development expectations for lots and lots of go-lives (*note - plus additional staff to support an influx in tickets or other support needs during a go-live period). So if we slide the releases to say February and August - I would be able to dedicate more man power (9+ people from the above paragraph) around the heavy testing/ debugging / bug writing/squashing periods for a release. I know I know - there isn't really a time that Koha doesn't need more testing, but I've noticed that the volunteer effort is usually much greater/demanding the closer we are to major release date. I am wondering if others are finding the same with their work schedules (other support providers, academic institutions, public institutions, and my favorite volunteers). Are there certain times of the years where your day job is predictably busy that you aren't able to dedicate the resources that you want towards the greatest project in the world Koha. With the data set that we're sitting on here, we are constantly seeking ways that we can contribute more. Just a thought and was curious if others analyzed a similar aspect with their environment and perhaps maybe we should bring such a discussion into the open or a general IRC meeting. Especially any of us that are support providers we should be always be thinking about how we can do more for Koha. Thanks and Cheers (another sleepless night thinking about my favorite subject - Koha), Brendan -- --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Portland, OR - Office: Redding, CT Phone # (888) 900-8944 http://bywatersolutions.com info(a)bywatersolutions.com

11 19

Re: [Koha-devel] koha use percona xtradb cluster
by Kivilahti Olli-Antti 11 Sep '15

11 Sep '15

Thanks for the links! Olli-Antti Kivilahti Järjestelmäkeittäjä vaarakirjastot.fi +358 50 449 7763 --Powered by Kubuntu Linux! On 10.09.2015 12:30, long_sam.tw wrote: Hi, Kivilahti attached files DB cluster plus haproxy some info Installing Percona XtraDB Cluster on Ubuntu https://www.percona.com/doc/percona-xtradb-cluster/5.5/howtos/ubuntu_howto.… Load balancing with HAProxy https://www.percona.com/doc/percona-xtradb-cluster/5.5/howtos/haproxy.html keepalived https://www.howtoforge.com/setting-up-a-high-availability-load-balancer-wit… sysbench test tool https://www.percona.com/doc/percona-xtradb-cluster/5.5/howtos/virt_sandbox.… BR, longshan Kivilahti Olli-Antti <olli-antti.kivilahti(a)jns.fi><mailto:olli-antti.kivilahti@jns.fi> 於 2015/9/10 (週四) 4:45 PM 寫道﹕ Wow! I am really happy that it works with Koha. How does it perform for you? How big is your library/consortium? Olli-Antti Kivilahti Järjestelmäkeittäjä vaarakirjastot.fi +358 50 449 7763 --Powered by Kubuntu Linux! On 10.09.2015 10:01, long_sam.tw wrote: Dear koha folks , Recently , I use percona xtradb cluster plus haproxy. + keepalived It provides ha & load balancing, some ref : https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation/apt_rep… It support debian & ubuntu BR, longshan _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha-community.org<mailto:Koha-devel@lists.koha-community.org> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha-community.org<mailto:Koha-devel@lists.koha-community.org> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/

2 1

koha use percona xtradb cluster
by long_sam.tw 10 Sep '15

10 Sep '15

Dear koha folks , Recently , I use percona xtradb cluster plus haproxy. + keepalivedIt provides ha & load balancing, some ref : https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation/apt_rep… It support debian & ubuntu BR, longshan

2 1

Vote for the Kohacon 2016 conference location now!
by Mirko Tietgen 09 Sep '15

09 Sep '15

Dear list, we have opened the vote for the location of the Kohacon 2016 community conference. You can find the proposals in the Koha wiki at http://wiki.koha-community.org/wiki/KohaCon16_Proposals We decided on a simple form over a ranking at the IRC meeting a few minutes ago. The rules are simple: * everybody can vote * one vote per person The voting period is one week. The vote is open until 16 September 2015, 12 UTC. To vote, visit http://abunchofthings.net/limesurvey/index.php/639452?lang=en and follow the instructions. Happy voting, and thanks to both bidders for offering to host Kohacon 2016. Good luck! :) Mirko

1 1