Hi all, Please, I need info on how I can manually assigned borrower's number in KOHA. Cheers
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 [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 [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 [5] arslan.farooq@szabist-isb.edu.pk +92 514 863 363-65
-- Electronic Resource Librarian SZABIST Islamabad 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 [5] arslan.farooq@szabist-isb.edu.pk +92 514 863 363-65 -- Electronic Resource Librarian SZABIST Islamabad 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 [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