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
