[Koha] Borrower's ID

Riley Childs rchilds at cucawarriors.com
Thu Oct 2 23:25:27 NZDT 2014


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:olawale.ilesanmi at zodml.org>
Sent: ‎10/‎2/‎2014 6:02 AM
To: Riley Childs<mailto:rchilds at cucawarriors.com>
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:olawale.ilesanmi at zodml.org>
Sent: ‎10/‎1/‎2014 3:27 PM
To: koha at lists.katipo.co.nz<mailto:koha at lists.katipo.co.nz>
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
> koha at 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-request at lists.katipo.co.nz
>
> You can reach the person managing the list at
> koha-owner at 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 <arslanone at gmail.com>
> To: Mohamed Fekry Negm <mfekry6 at hotmail.com>
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] active directory + koha
> Message-ID:
> <CAFqgOiKFL10PGtAC_O0RRd9M2q=WKV0t3GvVj=XGhs=bNXtFsg at 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 <mfekry6 at 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<http://www.szabist-isb.edu.pk> [5]
> arslan.farooq at szabist-isb.edu.pk
> +92 514 863 363-65
>
> ------------------------------
>
> Message: 2
> Date: Mon, 29 Sep 2014 05:05:23 +0000
> From: Mohamed Fekry Negm <mfekry6 at hotmail.com>
> To: Riley Childs <rchilds at cucawarriors.com>, "koha at lists.katipo.co.nz"
> <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] active directory + koha
> Message-ID: <DUB127-W80302F9938866A7ED924B7F7BA0 at 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 at 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 at 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 <heupink at merit.unu.edu>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] active directory + koha
> Message-ID: <54290DFB.7030409 at 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 at 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 at 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 at lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha [2] _______________________________________________ Koha mailing list http://koha-community.org [1] Koha at 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 <manucuest at gmail.com>
> To: koha at lists.katipo.co.nz
> Subject: [Koha] Mysql high cpu usage
> Message-ID:
> <CAAR2sqhpTQWpu4-hu5SrwKzcsqLncrE9kZQ=Xe-VqW74FfpjTA at 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*
>
> manucuest at gmail.com
> http://manucuesta.es [3]
>
> ------------------------------
>
> Message: 5
> Date: Mon, 29 Sep 2014 15:14:21 +0500
> From: Arslan Farooq <arslanone at gmail.com>
> To: Manuel Cuesta <manucuest at gmail.com>
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Mysql high cpu usage
> Message-ID:
> <CAFqgOi+jxCmtXMj4iq2rkTY0iouzAyXMRVNtFMSBJ9_DckVWSw at 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 <manucuest at 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* manucuest at gmail.com http://manucuesta.es [3] _______________________________________________ Koha mailing list http://koha-community.org [1] Koha at lists.katipo.co.nz 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]
> arslan.farooq at szabist-isb.edu.pk
> +92 514 863 363-65
>
> ------------------------------
>
> Message: 6
> Date: Mon, 29 Sep 2014 15:20:59 +0500
> From: Arslan Farooq <arslanone at gmail.com>
> To: Manuel Cuesta <manucuest at gmail.com>
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Mysql high cpu usage
> Message-ID:
> <CAFqgOi+FwJbJsPt4QDDAUQCrEx-Wst2fyDYvWjriWH7XScA5TA at 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 <arslanone at 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 <manucuest at 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* manucuest at gmail.com http://manucuesta.es [3] _______________________________________________ Koha mailing list http://koha-community.org [1] Koha at lists.katipo.co.nz 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] arslan.farooq at szabist-isb.edu.pk +92 514 863 363-65

--
Electronic Resource Librarian
SZABIST Islamabad
www.szabist-isb.edu.pk<http://www.szabist-isb.edu.pk> [5]
arslan.farooq at szabist-isb.edu.pk
+92 514 863 363-65

------------------------------

Message: 7
Date: Mon, 29 Sep 2014 15:41:54 +0500
From: Arslan Farooq <arslanone at gmail.com>
To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: [Koha] Posting Troubleshooting Questions on Mailing Lists
Message-ID:
 <CAFqgOiKU=-7O4Y0tW5=TXF3Db9fMdjGfQQE2doEqMdFyjF9trA at 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 <manucuest at gmail.com>
To: Arslan Farooq <arslanone at gmail.com>
Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Mysql high cpu usage
Message-ID:
 <CAAR2sqgQLzum8idRPzstbkAMxT7LajxfuJ5YSQ9n377D64j_UA at 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*

manucuest at gmail.com
http://manucuesta.es [3]

On 29 September 2014 12:20, Arslan Farooq <arslanone at 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 <arslanone at 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 <manucuest at 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* manucuest at gmail.com http://manucuesta.es [3] _______________________________________________ Koha mailing list http://koha-community.org [1] Koha at lists.katipo.co.nz 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] arslan.farooq at szabist-isb.edu.pk +92 514 863 363-65
 -- Electronic Resource Librarian SZABIST Islamabad
www.szabist-isb.edu.pk<http://www.szabist-isb.edu.pk> [5] arslan.farooq at szabist-isb.edu.pk +92 514 863
363-65

------------------------------

Subject: Digest Footer

_______________________________________________
Koha mailing list
Koha at 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<http://www.zodml.org> [9] | info at 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 at lists.katipo.co.nz
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/> | info at zodml.org
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.


More information about the Koha mailing list