[Koha] Koha Digest, Vol 107, Issue 51

Olawale Ilesanmi olawale.ilesanmi at zodml.org
Tue Sep 30 21:23:38 NZDT 2014


 

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 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


More information about the Koha mailing list