[Koha] Borrower's ID

vikram zadgaonkar vikramczadgaonkar at gmail.com
Fri Oct 3 17:14:49 NZDT 2014


Olawale,
Explain your problem with example.
On 02-Oct-2014 12:57 AM, "Olawale Ilesanmi" <olawale.ilesanmi at 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 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 [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 [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 [5] arslan.farooq at szabist-isb.edu.pk +92 514 863
> 363-65
>
> --
> Electronic Resource Librarian
> SZABIST Islamabad
> 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 [5] arslan.farooq at szabist-isb.edu.pk +92 514 863
> 363-65
>  -- Electronic Resource Librarian SZABIST Islamabad
> 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 [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
>


More information about the Koha mailing list