Re: [Koha] active directory + koha
Hi Mohamed, This config works here, with samba4 AD: ldapserver id=dc2 hostname192.87.y.x/hostname baseCN=Users,DC=samba,DC=company,DC=com/base replicate1/replicate update1/update auth_by_bind1/auth_by_bind principal_name%s...@samba.company.com/principal_name mapping !-- match koha SQL field names to your LDAP record field names -- firstnameis=givenName /firstname surname is=sn /surname address is=streetAddress Keizer Karelplein 19/address city is=l Maastricht/city zipcode is=postalCode 6211 TC/zipcode branchcode is=branch MERIT/branchcode userid is=uid /userid password is=userPassword /password emailis=mail /email categorycode is=employeeType A/categorycode phoneis=telephoneNumber/phone /mapping /ldapserver Unfortunately the only thing that doesn't seem to be implemented is multiple dc's - failover. (or am i missing it?) Hope that helps, MJ On 09/29/2014 07:05 AM, Mohamed Fekry Negm wrote: hi all thanks for replay Few questions: Koha version 3.16 OS Version Ubuntu 14.04 Active Directory Version Windows Server 2008 Riley Childs Senior Charlotte United Christian Academy Library Services Administrator IT Services (704) 497-2086 rileychilds.net @rowdychildren From: Mohamed Fekry Negm Sent: 9/28/2014 4:41 PM To: koha@lists.katipo.co.nz Subject: [Koha] active directory + koha Hi all i want to making integration between koha and my active directory , i searched many on web but didn't got links guide me to LDAP configuration wit koha , could any body help me to start that thank you all ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Mysql high cpu usage
Hello everyone, in a Debian Squeeze installation Koha works slow and I can see cpu usage is mysql is 100%. Recently the site was down for too many connections and I change max_connections=500 and OK. Now there are 20 connections (sleep) from same kobli user to DB. How could I reduce this cpu usage? Thanks in avance _ *Manuel Cuesta Álvaro* manucu...@gmail.com http://manucuesta.es ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Mysql high cpu usage
Hi, What are your basic hardware specs: RAM, Processor for example. And what is your MySQL version? How was Koha installed: package or source tarball? Someone more knowledgeable in performance related stuff may require the above information to help you. Arslan On Mon, Sep 29, 2014 at 3:05 PM, Manuel Cuesta manucu...@gmail.com wrote: Hello everyone, in a Debian Squeeze installation Koha works slow and I can see cpu usage is mysql is 100%. Recently the site was down for too many connections and I change max_connections=500 and OK. Now there are 20 connections (sleep) from same kobli user to DB. How could I reduce this cpu usage? Thanks in avance _ *Manuel Cuesta Álvaro* manucu...@gmail.com http://manucuesta.es ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.far...@szabist-isb.edu.pk +92 514 863 363-65 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Mysql high cpu usage
Hi, ...and reading here http://forums.cpanel.net/f402/mysql-high-cpu-usage-374152.html I think have a look at MySQL logs as well, or better paste ~200 lines here http://paste.koha-community.org/ as well. Arslan On Mon, Sep 29, 2014 at 3:14 PM, Arslan Farooq arslan...@gmail.com wrote: Hi, What are your basic hardware specs: RAM, Processor for example. And what is your MySQL version? How was Koha installed: package or source tarball? Someone more knowledgeable in performance related stuff may require the above information to help you. Arslan On Mon, Sep 29, 2014 at 3:05 PM, Manuel Cuesta manucu...@gmail.com wrote: Hello everyone, in a Debian Squeeze installation Koha works slow and I can see cpu usage is mysql is 100%. Recently the site was down for too many connections and I change max_connections=500 and OK. Now there are 20 connections (sleep) from same kobli user to DB. How could I reduce this cpu usage? Thanks in avance _ *Manuel Cuesta Álvaro* manucu...@gmail.com http://manucuesta.es ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.far...@szabist-isb.edu.pk +92 514 863 363-65 -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.far...@szabist-isb.edu.pk +92 514 863 363-65 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Posting Troubleshooting Questions on Mailing Lists
Hi, I was wondering if we should add a note/paragraph/section on our Mailing Lists page (http://koha-community.org/support/koha-mailing-lists/) requesting users to always mention their Koha version, install method, Linux distribution and version etc when they ask a troubleshooting question. It'll be useful, no? Arslan ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Mysql high cpu usage
Here more info - SO Debian wheezy1 (not Squeezy, sorry) - MySQL version 5.5.38-0 - Koha is installed as package I found strange too many connections of user kobli mysql show processlist; +--+---+---+---+-+--+---+--+ | Id | User | Host | db| Command | Time | State | Info | +--+---+---+---+-+--+---+--+ |1 | kobliuser | localhost | kobli | Sleep | 1117 | | NULL | |2 | kobliuser | localhost | kobli | Sleep | 3323 | | NULL | |3 | kobliuser | localhost | kobli | Sleep | 2900 | | NULL | |4 | kobliuser | localhost | kobli | Sleep | 1643 | | NULL | |5 | kobliuser | localhost | kobli | Sleep | 1058 | | NULL | |6 | kobliuser | localhost | kobli | Sleep | 2277 | | NULL | |7 | kobliuser | localhost | kobli | Sleep | 1516 | | NULL | |8 | kobliuser | localhost | kobli | Sleep | 1336 | | NULL | |9 | kobliuser | localhost | kobli | Sleep | 1197 | | NULL | | 10 | kobliuser | localhost | kobli | Sleep | 1400 | | NULL | | 12 | kobliuser | localhost | kobli | Sleep | 2813 | | NULL | | 114 | kobliuser | localhost | kobli | Sleep | 3553 | | NULL | | 126 | kobliuser | localhost | kobli | Sleep | 3424 | | NULL | | 140 | kobliuser | localhost | kobli | Sleep |0 | | NULL | | 142 | kobliuser | localhost | kobli | Sleep | 3204 | | NULL | | 144 | kobliuser | localhost | kobli | Sleep | 3076 | | NULL | | 170 | kobliuser | localhost | kobli | Sleep | 2917 | | NULL | | 208 | kobliuser | localhost | kobli | Sleep | 485 | | NULL | | 276 | kobliuser | localhost | kobli | Sleep | 2747 | | NULL | | 346 | kobliuser | localhost | kobli | Sleep | 2605 | | NULL | | 422 | kobliuser | localhost | kobli | Sleep | 102 | | NULL | | 483 | kobliuser | localhost | kobli | Sleep |0 | | NULL | | 553 | kobliuser | localhost | kobli | Sleep | 2254 | | NULL | | 621 | kobliuser | localhost | kobli | Sleep | 2137 | | NULL | | 696 | kobliuser | localhost | kobli | Sleep | 2022 | | NULL | | 777 | kobliuser | localhost | kobli | Sleep | 1892 | | NULL | | 843 | kobliuser | localhost | kobli | Sleep | 1780 | | NULL | | 913 | kobliuser | localhost | kobli | Sleep | 1655 | | NULL | | 981 | kobliuser | localhost | kobli | Sleep | 1538 | | NULL | | 1050 | kobliuser | localhost | kobli | Sleep |0 | | NULL | | 1109 | kobliuser | localhost | kobli | Sleep |0 | | NULL | | 1175 | kobliuser | localhost | kobli | Sleep | 1190 | | NULL | | 1248 | kobliuser | localhost | kobli | Sleep | 1076 | | NULL | | 1318 | kobliuser | localhost | kobli | Sleep |0 | | NULL | | 1415 | kobliuser | localhost | kobli | Sleep | 844 | | NULL | | 1490 | kobliuser | localhost | kobli | Sleep | 722 | | NULL | | 1558 | kobliuser | localhost | kobli | Sleep | 602 | | NULL | | 1620 | kobliuser | localhost | kobli | Sleep | 479 | | NULL | | 1693 | kobliuser | localhost | kobli | Sleep |0 | | NULL | | 1698 | admin | localhost | NULL | Query |0 | NULL | show processlist | | 1769 | kobliuser | localhost | kobli | Sleep | 227 | | NULL | | 1833 | kobliuser | localhost | kobli | Sleep | 108 | | NULL | | 1870 | kobliuser | localhost | kobli | Sleep |1 | | NULL | +--+---+---+---+-+--+---+--+ 43 rows in set (0.00 sec) I know a lot about koha, sorry for that. _ *Manuel Cuesta Álvaro* manucu...@gmail.com http://manucuesta.es On 29 September 2014 12:20, Arslan Farooq arslan...@gmail.com wrote: Hi, ...and reading here http://forums.cpanel.net/f402/mysql-high-cpu-usage-374152.html I think have a look at MySQL logs as well, or better paste ~200 lines here http://paste.koha-community.org/ as well. Arslan On Mon, Sep 29, 2014 at 3:14 PM, Arslan Farooq arslan...@gmail.com wrote: Hi, What are your basic hardware specs: RAM, Processor for example. And what is your MySQL version? How was Koha installed: package or source tarball? Someone more knowledgeable in performance related stuff may require the above information to help you. Arslan On Mon, Sep 29, 2014 at 3:05 PM, Manuel Cuesta manucu...@gmail.com wrote: Hello everyone, in a Debian Squeeze installation Koha works slow and I can
[Koha] My laptop is hot to the touch, should I be worried? What Can I Do About It?
1. *Check (and Clean) Your Fans* http://3.bp.blogspot.com/-Yz1Z6DDJSoA/VCkxygi4uMI/AJU/Kyq4foepXW0/s1600/laptop-clean-fan.jpg Make sure the air vents aren't blocked. And the fan is working properly. A blast of compressed air once in a while helps blow out the dust bunnies. A fan cooler under the laptop could help too to prevent from high temperature. Click here to continue reading complete article http://tech-dig.blogspot.com/2014/09/my-laptop-is-hot-to-touch-should-i-be.html -- If you have knowledge, let others light their candles in it. Regards *Maqsood Ahmad* Database Administrator / Coordinator* Lincoln Corner Bahawalpur* The Islamia University of Bahawalpur Cell: 0092 333 6359133 http://library.iub.edu.pk , d...@iub.edu.pk , www.facebook.com/maqsood.dba -- -- If you have knowledge, let others light their candles in it. Regards *Maqsood Ahmad* Database Administrator / Coordinator* Lincoln Corner Bahawalpur* The Islamia University of Bahawalpur Cell: 0092 333 6359133 http://library.iub.edu.pk , d...@iub.edu.pk , www.facebook.com/maqsood.dba ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Posting Troubleshooting Questions on Mailing Lists
requesting users to always mention their Koha version, install method, Linux distribution and version etc when they ask a troubleshooting question. It probably won't help, but it can't hurt to try. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Posting Troubleshooting Questions on Mailing Lists
Greetings, Arslan Farooq wrote: I was wondering if we should add a note/paragraph/section on our Mailing Lists page (http://koha-community.org/support/koha-mailing-lists/) requesting users to always mention their Koha version, install method, Linux distribution and version etc when they ask a troubleshooting question. +1 I think it is a great idea. However... Arslan Farooq wrote: It'll be useful, no? Owen Leonard wrote: It probably won't help, but it can't hurt to try. I share Owen's doubt about people actually reading it and following through with providing enough details up front. GPML, Mark Tompsett ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Posting Troubleshooting Questions on Mailing Lists
+1 Very usefull indeed : Koha version and install method at least Le 29/09/2014 14:59, Mark Tompsett a écrit : Greetings, Arslan Farooq wrote: I was wondering if we should add a note/paragraph/section on our Mailing Lists page (http://koha-community.org/support/koha-mailing-lists/) requesting users to always mention their Koha version, install method, Linux distribution and version etc when they ask a troubleshooting question. +1 I think it is a great idea. However... Arslan Farooq wrote: It'll be useful, no? Owen Leonard wrote: It probably won't help, but it can't hurt to try. I share Owen's doubt about people actually reading it and following through with providing enough details up front. GPML, Mark Tompsett ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.som...@biblibre.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Posting Troubleshooting Questions on Mailing Lists
I make an effort to include the Koha version (and know where to find it) But as the non technical half of the team, I'm not so sure I could tell you what the install method is. It is often the librarians who discover the problem in their day to day working. If you ask for this information, please let us know where to find it. Thanks On Mon, Sep 29, 2014 at 4:23 PM, Fridolin SOMERS fridolin.som...@biblibre.com wrote: +1 Very usefull indeed : Koha version and install method at least Le 29/09/2014 14:59, Mark Tompsett a écrit : Greetings, Arslan Farooq wrote: I was wondering if we should add a note/paragraph/section on our Mailing Lists page (http://koha-community.org/support/koha-mailing-lists/) requesting users to always mention their Koha version, install method, Linux distribution and version etc when they ask a troubleshooting question. +1 I think it is a great idea. However... Arslan Farooq wrote: It'll be useful, no? Owen Leonard wrote: It probably won't help, but it can't hurt to try. I share Owen's doubt about people actually reading it and following through with providing enough details up front. GPML, Mark Tompsett ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.som...@biblibre.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler 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 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Comment: Koha Community Code of Conduct
Would that it was as simple as: Play nicely with others; no name-calling, teasing, or bad language. . . Sadly, we're not five years old anymore. I would like to plea for clear, concise language. Especially given the large number of Koha users whose native tongue is not English. I might even offer to help edit it. . . though I'm not usually known for my brevity! On Fri, Sep 26, 2014 at 10:34 PM, glaws glaw...@rhcl.org wrote: I wish I knew the background better, but a lot of the recent discussion on Codes of Conduct I think stems from some recent problems in the gaming community. Again, I admit my knowledge is limited, but I think it had something to do with male gamers putting down female gamers; very offensive words and actions were used in that situation, and the outing of personally identifying information was one of the problems. I think any reasonable person applying a reasonable standard would realize the CoC wording as is currently stands wouldn't apply to the examples I cited, nor to yours. It's the unreasonable factors we have to be concerned with, and just a little modding of the wording will fix things. Greg On 09/26/2014 04:12 PM, viktor.sa...@regionhalland.se wrote: I highly agree with the spirit of the CoC, but with this discussion I realize that taking the following part literally would forbid me to give people credit when listening to them during a KohaCon: Harassment includes, but is not limited to: […] • Posting (or threatening to post) other people’s personally identifying information. […] Names are the mother of personally identifying information and since a good reputation is sort of the currency in a FOSS-community not being able to publicly give people credit seems counter productive :) I guess the paragraph is ment to cover giving credit, but as I read it that may be the effect(?) Kind regards/Viktor Viktor Sarge Utvecklingsledare Regionbibliotek Halland Kultur i Halland TFN: 035-17 98 73 E-POST: viktor.sa...@regionhalland.se BESÖKSADRESS: Södra vägen 9, 30180 Halmstad WEBB: www.regionhalland.se/regionbibliotek 26 sep 2014 kl. 21:49 skrev glaws glaw...@rhcl.org: I have some concerns about the Koha Community Code of Conduct posted here: http://koha-community.org/about/policy/code-of-conduct/ http://koha-community.org/about/policy/code-of-conduct/ My specific concern is the second bullet point: Harassment includes, but is not limited to: * ---snip--- * Verbal, graphic or written comments related to gender, gender identity, sexual orientation, disability, physical appearance, body size, race or religion which seems overly broad. Examples If, during a conference breaking for lunch, I say to a group of attendees I'm Buddhist, is there a vegetarian restaurant near here?, I would seem to have violated this point (verbal...comment...religion). Or if I'm a presenter, and I make a comment for illustrative purposes, like Just as people come in all sizes, libraries also vary in size and Koha is great for all of them, have I violated the code? Or if I'm with a group of attendees planning on going out somewhere, and I say I have insert any health problem, and I can't walk with you that far, is that a violation? I would like to suggest that the wording for this particular point include something to the effect that the references must be obviously negative in nature or perhaps intended to give offense to to an average person _based_on_some_reasonable_standard_. -- Greg Lawson ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Greg Lawson Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506 816-232-5479 x2303 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler 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 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Re: [Koha] delete bibs
There's a report that will help you find the biblionumbers without items: http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_bibs_without_items On Fri, Sep 26, 2014 at 4:49 PM, Fridolin SOMERS fridolin.som...@biblibre.com wrote: Hie, Export biblionumbers from database and use script misc/ batchdeletebiblios.pl Le 26/09/2014 07:25, Monisa Aslam a écrit : i want to delete all bibs without item.. is there any way Monisa Aslam ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.som...@biblibre.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler 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 --- Writing about music is like dancing about architecture --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Improving Search Results
Coehoorn, Joel schreef op vr 26-09-2014 om 08:34 [-0500]: I see that the koha-common file in the /etc/cron.d folder, which includes the command to rebuild indexes, did not have execute permissions. It probably won't help, as that file is not a script and so doesn't need execute permissions. I'd look at your logs. Both syslog to make sure that the relevant cron tasks are running: Sep 30 11:10:01 server /USR/SBIN/CRON[24746]: (root) CMD (test -x /usr/sbin/koha-rebuild-zebra koha-rebuild-zebra -q $(koha-list --enabled)) (are there related errors directly following that?) and /var/log/koha/instancename/zebra*.log, which ideally should be empty. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha