Olawale, Explain your problem with example. On 02-Oct-2014 12:57 AM, "Olawale Ilesanmi" <olawale.ilesa...@zodml.org> wrote:
> > > Hello Everyone, > > Please, I need link on how to manually assign Borrow's number. Our > borrowers already have number from CD/ISIS and we would like to maintain > this number. Is there a way I can manually set Borrower's number ??..I > noticed koha assign borrower's number automatically. > > Thanks > > > Send Koha mailing list submissions to > > koha@lists.katipo.co.nz > > > > 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 > > koha-requ...@lists.katipo.co.nz > > > > You can reach the person managing the list at > > koha-ow...@lists.katipo.co.nz > > > > 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 <arslan...@gmail.com> > > To: Mohamed Fekry Negm <mfek...@hotmail.com> > > Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > > 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 <mfek...@hotmail.com> > 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] > > arslan.far...@szabist-isb.edu.pk > > +92 514 863 363-65 > > > > ------------------------------ > > > > Message: 2 > > Date: Mon, 29 Sep 2014 05:05:23 +0000 > > From: Mohamed Fekry Negm <mfek...@hotmail.com> > > To: Riley Childs <rchi...@cucawarriors.com>, "koha@lists.katipo.co.nz" > > <koha@lists.katipo.co.nz> > > Subject: Re: [Koha] active directory + koha > > Message-ID: <dub127-w80302f9938866a7ed924b7f7...@phx.gbl> > > 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: > > 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 [1] > > > > Koha@lists.katipo.co.nz > > > > 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 <heup...@merit.unu.edu> > > To: koha@lists.katipo.co.nz > > Subject: Re: [Koha] active directory + koha > > Message-ID: <54290dfb.7030...@merit.unu.edu> > > 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>% > s...@samba.company.com</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: 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 [1] Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha [2] > _______________________________________________ Koha mailing list > http://koha-community.org [1] Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha [2] > > > > ------------------------------ > > > > Message: 4 > > Date: Mon, 29 Sep 2014 12:05:18 +0200 > > From: Manuel Cuesta <manucu...@gmail.com> > > To: koha@lists.katipo.co.nz > > 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* > > > > manucu...@gmail.com > > http://manucuesta.es [3] > > > > ------------------------------ > > > > Message: 5 > > Date: Mon, 29 Sep 2014 15:14:21 +0500 > > From: Arslan Farooq <arslan...@gmail.com> > > To: Manuel Cuesta <manucu...@gmail.com> > > Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > > 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 <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 [3] > _______________________________________________ Koha mailing list > http://koha-community.org [1] Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha [2] > > > > -- > > Electronic Resource Librarian > > SZABIST Islamabad > > www.szabist-isb.edu.pk [5] > > arslan.far...@szabist-isb.edu.pk > > +92 514 863 363-65 > > > > ------------------------------ > > > > Message: 6 > > Date: Mon, 29 Sep 2014 15:20:59 +0500 > > From: Arslan Farooq <arslan...@gmail.com> > > To: Manuel Cuesta <manucu...@gmail.com> > > Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > > 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 <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 [3] > _______________________________________________ Koha mailing list > http://koha-community.org [1] Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha [2] -- Electronic > Resource Librarian SZABIST Islamabad > www.szabist-isb.edu.pk [5] arslan.far...@szabist-isb.edu.pk +92 514 863 > 363-65 > > -- > Electronic Resource Librarian > SZABIST Islamabad > www.szabist-isb.edu.pk [5] > arslan.far...@szabist-isb.edu.pk > +92 514 863 363-65 > > ------------------------------ > > Message: 7 > Date: Mon, 29 Sep 2014 15:41:54 +0500 > From: Arslan Farooq <arslan...@gmail.com> > To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > 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 <manucu...@gmail.com> > To: Arslan Farooq <arslan...@gmail.com> > Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > 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* > > manucu...@gmail.com > http://manucuesta.es [3] > > 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 [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 <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 [3] > _______________________________________________ Koha mailing list > http://koha-community.org [1] Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha [2] > > -- Electronic Resource Librarian SZABIST Islamabad > www.szabist-isb.edu.pk [5] arslan.far...@szabist-isb.edu.pk +92 514 863 > 363-65 > -- Electronic Resource Librarian SZABIST Islamabad > www.szabist-isb.edu.pk [5] arslan.far...@szabist-isb.edu.pk +92 514 863 > 363-65 > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > Koha@lists.katipo.co.nz > 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] | i...@zodml.org > > 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 > 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