Please explain your problem with example. On 03-Oct-2014 3:57 AM, "Riley Childs" <[email protected]> wrote:
> Like I said it it is a database key (that should NEVER be edited and is > not public facing and is simply intended as a "constant") koha uses 2 > different numbers to identify patrons: A Card Number, which is used to > checkout books etc, and a Borrower number that is used as a table key to > identify patton in other tables. The only way to edit the borrower number > would be editing the database manually. Koha will figure out everything if > you use the import mechanism and the Skelton CSV provided. > > Riley Childs > Senior > Charlotte United Christian Academy > Library Services Administrator > IT Services > (704) 497-2086 > rileychilds.net > @rowdychildren > ________________________________ > From: Olawale Ilesanmi<mailto:[email protected]> > Sent: 10/2/2014 6:02 AM > To: Riley Childs<mailto:[email protected]> > Subject: RE: [Koha] Borrower's ID > > > Yes, Riley.I read somewhere else that it cannot be edited...Its a no go > area !. The thing is , our borrowers from CD/ISIS already have borrowers > number so , I am looking for a way whereby they can retain thier number in > KOHA. > > Cheers! > > > > Do you mean the card number? Barrower number is a database key used > internally by koha. Set the card number in the user profile. > > Riley Childs > Senior > Charlotte United Christian Academy > Library Services Administrator > IT Services > (704) 497-2086 > rileychilds.net > @rowdychildren > ________________________________ > From: Olawale Ilesanmi<mailto:[email protected]> > Sent: 10/1/2014 3:27 PM > To: [email protected]<mailto:[email protected]> > Subject: Re: [Koha] Borrower's ID > > > 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 > > [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<http://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<http://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<http://www.szabist-isb.edu.pk> [5] > [email protected] +92 514 863 363-65 > > -- > Electronic Resource Librarian > SZABIST Islamabad > www.szabist-isb.edu.pk<http://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<http://www.szabist-isb.edu.pk> [5] > [email protected] +92 514 863 363-65 > -- Electronic Resource Librarian SZABIST Islamabad > www.szabist-isb.edu.pk<http://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<http://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 > > > > -- > Olawale ILESANMI > Web/System Adminstrator > Websites and Online Services Department > Tel: (+234)-807-130-5163 > [ZODML LOGO]<http://www.zodml.org/> > 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<http://www.zodml.org/> | [email protected] > Follow Us: [Twitter] <http://www.twitter.com/ZODML> [Facebook] < > http://www.facebook.com/ZODML> [Pinterest] <http://pinterest.com/zodml/> > [LinkedIn] <http://www.linkedin.com/company/3189484> > [ZODML LAGOS AWARD]<http://www.zodml.org/> > Confidentiality Note: This email may contain confidential and/or private > information. If you received this email in error please delete and notify > sender. > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
