Hi all,
Please, I need info on how I can manually assigned borrower's number in KOHA. Cheers > Send Koha mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha [2] > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Koha digest..." > > Today's Topics: > > 1. Re: active directory + koha (Arslan Farooq) > 2. Re: active directory + koha (Mohamed Fekry Negm) > 3. Re: active directory + koha (mourik jan heupink - merit) > 4. Mysql high cpu usage (Manuel Cuesta) > 5. Re: Mysql high cpu usage (Arslan Farooq) > 6. Re: Mysql high cpu usage (Arslan Farooq) > 7. Posting Troubleshooting Questions on Mailing Lists (Arslan Farooq) > 8. Re: Mysql high cpu usage (Manuel Cuesta) > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 29 Sep 2014 09:37:38 +0500 > From: Arslan Farooq <[email protected]> > To: Mohamed Fekry Negm <[email protected]> > Cc: "[email protected]" <[email protected]> > Subject: Re: [Koha] active directory + koha > Message-ID: > <CAFqgOiKFL10PGtAC_O0RRd9M2q=WKV0t3GvVj=XGhs=bnxt...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi, > > Try this: https://www.google.com/search?btnG=1&pws=0&q=koha+ldap [4] > > Arslan > > On Mon, Sep 29, 2014 at 1:40 AM, Mohamed Fekry Negm <[email protected]> > wrote: > >> 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 > > -- > Electronic Resource Librarian > SZABIST Islamabad > www.szabist-isb.edu.pk [5] > [email protected] > +92 514 863 363-65 > > ------------------------------ > > Message: 2 > Date: Mon, 29 Sep 2014 05:05:23 +0000 > From: Mohamed Fekry Negm <[email protected]> > To: Riley Childs <[email protected]>, "[email protected]" > <[email protected]> > Subject: Re: [Koha] active directory + koha > Message-ID: <[email protected]> > Content-Type: text/plain; charset="windows-1256" > > 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: > [email protected] > > 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 [1] > > [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha [2] > > ------------------------------ > > Message: 3 > Date: Mon, 29 Sep 2014 09:44:59 +0200 > From: mourik jan heupink - merit <[email protected]> > To: [email protected] > Subject: Re: [Koha] active directory + koha > Message-ID: <[email protected]> > Content-Type: text/plain; charset=windows-1256; format=flowed > > Hi Mohamed, > > This config works here, with samba4 AD: > >> <ldapserver id="dc2"> <hostname>192.87.y.x</hostname> >> <base>CN=Users,DC=samba,DC=company,DC=com</base> <replicate>1</replicate> >> <update>1</update> <auth_by_bind>1</auth_by_bind> >> <principal_name>%[email protected]</principal_name> <mapping> <!-- >> match koha SQL field names to your LDAP record field names --> <firstname >> is="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> <email is="mail" ></email> <categorycode >> is="employeeType" >A</categorycode> <phone is="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: [email protected] 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 [1] [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha [2] >> _______________________________________________ Koha mailing list >> http://koha-community.org [1] [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha [2] > > ------------------------------ > > Message: 4 > Date: Mon, 29 Sep 2014 12:05:18 +0200 > From: Manuel Cuesta <[email protected]> > To: [email protected] > Subject: [Koha] Mysql high cpu usage > Message-ID: > <CAAR2sqhpTQWpu4-hu5SrwKzcsqLncrE9kZQ=xe-vqw74ffp...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > 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* > > [email protected] > http://manucuesta.es [3] > > ------------------------------ > > Message: 5 > Date: Mon, 29 Sep 2014 15:14:21 +0500 > From: Arslan Farooq <[email protected]> > To: Manuel Cuesta <[email protected]> > Cc: "[email protected]" <[email protected]> > Subject: Re: [Koha] Mysql high cpu usage > Message-ID: > <cafqgoi+jxcmtxmj4iq2rkty0iouzayxmrvntfmsbj9_dckv...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > 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 <[email protected]> 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* [email protected] http://manucuesta.es [3] >> _______________________________________________ Koha mailing list >> http://koha-community.org [1] [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha [2] > > -- > Electronic Resource Librarian > SZABIST Islamabad > www.szabist-isb.edu.pk [5] > [email protected] > +92 514 863 363-65 > > ------------------------------ > > Message: 6 > Date: Mon, 29 Sep 2014 15:20:59 +0500 > From: Arslan Farooq <[email protected]> > To: Manuel Cuesta <[email protected]> > Cc: "[email protected]" <[email protected]> > Subject: Re: [Koha] Mysql high cpu usage > Message-ID: > <cafqgoi+fwjbjspt4qddauqcrex-wst2fydyvwjriwh7xsca...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi, > > ...and reading here > http://forums.cpanel.net/f402/mysql-high-cpu-usage-374152.html [6] I think > have a look at MySQL logs as well, or better paste ~200 lines here > http://paste.koha-community.org/ [7] as well. > > Arslan > > On Mon, Sep 29, 2014 at 3:14 PM, Arslan Farooq <[email protected]> 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 <[email protected]> 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* > [email protected] http://manucuesta.es [3] > _______________________________________________ Koha mailing list > http://koha-community.org [1] [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha [2] -- Electronic Resource > Librarian SZABIST Islamabad www.szabist-isb.edu.pk [5] [email protected] +92 514 863 363-65 -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk [5] [email protected] +92 514 863 363-65 ------------------------------ Message: 7 Date: Mon, 29 Sep 2014 15:41:54 +0500 From: Arslan Farooq <[email protected]> To: "[email protected]" <[email protected]> Subject: [Koha] Posting Troubleshooting Questions on Mailing Lists Message-ID: <CAFqgOiKU=-7O4Y0tW5=txf3db9fmdjgfqqe2doeqmdfyjf9...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 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/ [8]) 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 ------------------------------ Message: 8 Date: Mon, 29 Sep 2014 12:55:53 +0200 From: Manuel Cuesta <[email protected]> To: Arslan Farooq <[email protected]> Cc: "[email protected]" <[email protected]> Subject: Re: [Koha] Mysql high cpu usage Message-ID: <caar2sqgqlzum8idrpzstbkamxt7lajxfuj5ysq9n377d64j...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 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* [email protected] http://manucuesta.es [3] On 29 September 2014 12:20, Arslan Farooq <[email protected]> wrote: > Hi, ...and reading here > http://forums.cpanel.net/f402/mysql-high-cpu-usage-374152.html [6] I think > have a look at MySQL logs as well, or better paste ~200 lines here > http://paste.koha-community.org/ [7] as well. Arslan On Mon, Sep 29, 2014 at > 3:14 PM, Arslan Farooq <[email protected]> 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 <[email protected]> > 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* >> [email protected] http://manucuesta.es [3] >> _______________________________________________ Koha mailing list >> http://koha-community.org [1] [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha [2] > -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk [5] > [email protected] +92 514 863 363-65 -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk [5] [email protected] +92 514 863 363-65 ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha [2] ------------------------------ End of Koha Digest, Vol 107, Issue 51 ************************************* -- Olawale ILESANMI Web/System Adminstrator Websites and Online Services Department Tel: (+234)-807-130-5163 [9] Zaccheus Onumba Dibiaezue Memorial Libraries 196 Awolowo Road | Ikoyi | Lagos State| Nigeria Community Library :(+234)-1-463-1787 | Corporate Office:(+234)-1-454-1941 www.zodml.org [9] | [email protected] Follow Us: [10] [11] [12] [13] [9] CONFIDENTIALITY NOTE: This email may contain confidential and/or private information. If you received this email in error please delete and notify sender. Links: ------ [1] http://koha-community.org [2] http://lists.katipo.co.nz/mailman/listinfo/koha [3] http://manucuesta.es [4] https://www.google.com/search?btnG=1&pws=0&q=koha+ldap [5] http://www.szabist-isb.edu.pk [6] http://forums.cpanel.net/f402/mysql-high-cpu-usage-374152.html [7] http://paste.koha-community.org/ [8] http://koha-community.org/support/koha-mailing-lists/ [9] http://www.zodml.org/ [10] http://www.twitter.com/ZODML [11] http://www.facebook.com/ZODML [12] http://pinterest.com/zodml/ [13] http://www.linkedin.com/company/3189484 _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
