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@zodml.org> Sent: 10/2/2014 6:02 AM To: Riley Childs<mailto:rchilds@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@zodml.org> Sent: 10/1/2014 3:27 PM To: koha@lists.katipo.co.nz<mailto:koha@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@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@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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@gmail.com> To: Mohamed Fekry Negm <mfekry6@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=bNXtFsg@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@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@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@hotmail.com> To: Riley Childs <rchilds@cucawarriors.com>, "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] active directory + koha Message-ID: <DUB127-W80302F9938866A7ED924B7F7BA0@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 <heupink@merit.unu.edu> To: koha@lists.katipo.co.nz Subject: Re: [Koha] active directory + koha Message-ID: <54290DFB.7030409@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 <manucuest@gmail.com> To: koha@lists.katipo.co.nz Subject: [Koha] Mysql high cpu usage Message-ID: <CAAR2sqhpTQWpu4-hu5SrwKzcsqLncrE9kZQ=Xe-VqW74FfpjTA@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@gmail.com http://manucuesta.es [3]
------------------------------
Message: 5 Date: Mon, 29 Sep 2014 15:14:21 +0500 From: Arslan Farooq <arslanone@gmail.com> To: Manuel Cuesta <manucuest@gmail.com> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Mysql high cpu usage Message-ID: <CAFqgOi+jxCmtXMj4iq2rkTY0iouzAyXMRVNtFMSBJ9_DckVWSw@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@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@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<http://www.szabist-isb.edu.pk> [5] arslan.farooq@szabist-isb.edu.pk +92 514 863 363-65
------------------------------
Message: 6 Date: Mon, 29 Sep 2014 15:20:59 +0500 From: Arslan Farooq <arslanone@gmail.com> To: Manuel Cuesta <manucuest@gmail.com> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Mysql high cpu usage Message-ID: <CAFqgOi+FwJbJsPt4QDDAUQCrEx-Wst2fyDYvWjriWH7XScA5TA@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@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@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@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<http://www.szabist-isb.edu.pk> [5] arslan.farooq@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@szabist-isb.edu.pk +92 514 863 363-65 ------------------------------ Message: 7 Date: Mon, 29 Sep 2014 15:41:54 +0500 From: Arslan Farooq <arslanone@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=TXF3Db9fMdjGfQQE2doEqMdFyjF9trA@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@gmail.com> To: Arslan Farooq <arslanone@gmail.com> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Mysql high cpu usage Message-ID: <CAAR2sqgQLzum8idRPzstbkAMxT7LajxfuJ5YSQ9n377D64j_UA@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@gmail.com http://manucuesta.es [3] On 29 September 2014 12:20, Arslan Farooq <arslanone@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@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@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@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<http://www.szabist-isb.edu.pk> [5] arslan.farooq@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@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<http://www.zodml.org> [9] | info@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 -- 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@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.
Please explain your problem with example. On 03-Oct-2014 3:57 AM, "Riley Childs" <rchilds@cucawarriors.com> 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:olawale.ilesanmi@zodml.org> Sent: 10/2/2014 6:02 AM To: Riley Childs<mailto:rchilds@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@zodml.org> Sent: 10/1/2014 3:27 PM To: koha@lists.katipo.co.nz<mailto:koha@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@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@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@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@gmail.com> To: Mohamed Fekry Negm <mfekry6@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=bNXtFsg@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@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@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@hotmail.com> To: Riley Childs <rchilds@cucawarriors.com>, "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] active directory + koha Message-ID: <DUB127-W80302F9938866A7ED924B7F7BA0@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 <heupink@merit.unu.edu> To: koha@lists.katipo.co.nz Subject: Re: [Koha] active directory + koha Message-ID: <54290DFB.7030409@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 <manucuest@gmail.com> To: koha@lists.katipo.co.nz Subject: [Koha] Mysql high cpu usage Message-ID: <CAAR2sqhpTQWpu4-hu5SrwKzcsqLncrE9kZQ=Xe-VqW74FfpjTA@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@gmail.com http://manucuesta.es [3]
------------------------------
Message: 5 Date: Mon, 29 Sep 2014 15:14:21 +0500 From: Arslan Farooq <arslanone@gmail.com> To: Manuel Cuesta <manucuest@gmail.com> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Mysql high cpu usage Message-ID: <CAFqgOi+jxCmtXMj4iq2rkTY0iouzAyXMRVNtFMSBJ9_DckVWSw@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@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@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<http://www.szabist-isb.edu.pk> [5] arslan.farooq@szabist-isb.edu.pk +92 514 863 363-65
------------------------------
Message: 6 Date: Mon, 29 Sep 2014 15:20:59 +0500 From: Arslan Farooq <arslanone@gmail.com> To: Manuel Cuesta <manucuest@gmail.com> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Mysql high cpu usage Message-ID: <CAFqgOi+FwJbJsPt4QDDAUQCrEx-Wst2fyDYvWjriWH7XScA5TA@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@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@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@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<http://www.szabist-isb.edu.pk> [5] arslan.farooq@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@szabist-isb.edu.pk +92 514 863 363-65
------------------------------
Message: 7 Date: Mon, 29 Sep 2014 15:41:54 +0500 From: Arslan Farooq <arslanone@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=TXF3Db9fMdjGfQQE2doEqMdFyjF9trA@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@gmail.com> To: Arslan Farooq <arslanone@gmail.com> Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: Re: [Koha] Mysql high cpu usage Message-ID: <CAAR2sqgQLzum8idRPzstbkAMxT7LajxfuJ5YSQ9n377D64j_UA@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@gmail.com http://manucuesta.es [3]
On 29 September 2014 12:20, Arslan Farooq <arslanone@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@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@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@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<http://www.szabist-isb.edu.pk> [5] arslan.farooq@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@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<http://www.zodml.org> [9] | info@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
-- 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@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. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Riley Childs -
vikram zadgaonkar