- Koha - lists.katipo.co.nz

Re: [Koha] Export Athena / import Koha
by RAC IT Department 03 Oct '14

03 Oct '14

Hi Vikram, It has been a busy week.,, So I found a program that allowed me to export a .mrc file into an .xml file which I opened in Microsoft Excel and then saved it to a .xlsx and .csv file. I converted all three files (one .mrc Athena export and two .mrc files that were converted for import to Koha) and placed them in the following folder so you can have a look... https://www.dropbox.com/sh/dqxe494bn2gzo9z/AABywSMDgEaylTHOJPenxqZGa?dl=0 I was able to open all three different types of each file in Microsoft Excel. I took a look and it seems to me that the barcodes are present and in the correct place for import into Koha. So the file seems to contain the correct information. Could the problem be with the way that Koha is handling the file? You mentioned something about mapping. Is there something in Koha that I need to tweak in order to import this file? Thank you for your time Thanks, Bill On Tue, Sep 30, 2014 at 4:29 PM, RAC IT Department <itdept(a)racsonline.org> wrote: > So I looked high and low in Athena and did lots of research online and > came up with nothing. The only way to export the Biblio from Athena is via > .mrc file. > > I did find a program called MARC_Utilities.exe that will change it to csv > but the file it outputs is odd... I put it in the dropbox folder i > referenced earlier. Here is it again... > > https://www.dropbox.com/sh/og906kpdsh96u27/AABfm9UpGlUzgL6KNC53tFmza?dl=0 > > I also added a txt file of the output from the mrc file exported from > Athena. It is also in that folder. > > Hope that helps. > > I am away from my PC tonight on the road so I cannot connect with you. > > Thanks! > Bill > > > > On Mon, Sep 29, 2014 at 3:35 AM, vikram zadgaonkar < > vikramczadgaonkar(a)gmail.com> wrote: > >> I checked the file. We have only 5 fields : >> >> 1. call >> 2. Title >> 3. Author >> 4. Barcode >> 5. cost >> >> I think you need much more detials like publishing details, item >> type(book/cd/serials). >> Please check with your librarian and confirm. >> >> Vikram Zadgaonkar >> >> On Mon, Sep 29, 2014 at 8:56 AM, RAC IT Department <itdept(a)racsonline.org >> > wrote: >> >>> https://www.dropbox.com/s/xgelmms3lminmmv/Biblio.pdf?dl=0 >>> >>> >>> >>> >>> Sent from my iPhone >>> >>> On Sep 28, 2014, at 11:22 PM, vikram zadgaonkar < >>> vikramczadgaonkar(a)gmail.com> wrote: >>> >>> Ok. I will check. >>> On 29-Sep-2014 8:51 AM, "RAC IT Department" <itdept(a)racsonline.org> >>> wrote: >>> >>>> Yes. Ubuntu opens it. I will convert it to a PDF. >>>> >>>> >>>> >>>> >>>> Sent from my iPhone >>>> >>>> On Sep 28, 2014, at 11:13 PM, vikram zadgaonkar < >>>> vikramczadgaonkar(a)gmail.com> wrote: >>>> >>>> Can you read this file? >>>> >>>> Vikram Zadgaonkar >>>> >>>> On Mon, Sep 29, 2014 at 8:34 AM, RAC IT Department < >>>> itdept(a)racsonline.org> wrote: >>>> >>>>> https://www.dropbox.com/s/6sf9r6hiczhf3ym/Biblio.xps?dl=0 >>>>> >>>>> >>>>> >>>>> Sent from my iPhone >>>>> >>>>> On Sep 28, 2014, at 11:02 PM, vikram zadgaonkar < >>>>> vikramczadgaonkar(a)gmail.com> wrote: >>>>> >>>>> I could not open this file. When I open in notepad data is corrupted. >>>>> >>>>> Vikram Zadgaonkar >>>>> >>>>> On Mon, Sep 29, 2014 at 7:58 AM, RAC IT Department < >>>>> itdept(a)racsonline.org> wrote: >>>>> >>>>>> I poked around in Athena for a while and was able to generate the >>>>>> attached file with a list of the holdings in Athena. Is this what you are >>>>>> looking for? >>>>>> >>>>>> In His Service, >>>>>> Bill Kingsley >>>>>> Rutland Area Christian School >>>>>> IT Department Director >>>>>> itdept(a)racsonline.org >>>>>> www.racsonline.org >>>>>> >>>>>> >>>>>> On Sun, Sep 28, 2014 at 9:30 PM, vikram zadgaonkar < >>>>>> vikramczadgaonkar(a)gmail.com> wrote: >>>>>> >>>>>>> Are you available ? >>>>>>> >>>>>>> Vikram Zadgaonkar >>>>>>> >>>>>>> On Mon, Sep 29, 2014 at 6:49 AM, vikram zadgaonkar < >>>>>>> vikramczadgaonkar(a)gmail.com> wrote: >>>>>>> >>>>>>>> Connecting. >>>>>>>> On 29-Sep-2014 6:42 AM, "RAC IT Department" <itdept(a)racsonline.org> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> 863 460 978 >>>>>>>>> 29c4sn >>>>>>>>> >>>>>>>>> >>>>>>>>> Sent from my iPhone >>>>>>>>> >>>>>>>>> On Sep 28, 2014, at 9:05 PM, vikram zadgaonkar < >>>>>>>>> vikramczadgaonkar(a)gmail.com> wrote: >>>>>>>>> >>>>>>>>> I will be available in next 15 min. >>>>>>>>> On 29-Sep-2014 4:42 AM, "RAC IT Department" <itdept(a)racsonline.org> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> I have loaded team weaver on to the PC with the Athena software >>>>>>>>>> on it >>>>>>>>>> and am at the location if you are available. >>>>>>>>>> >>>>>>>>>> Thanks, >>>>>>>>>> Bill >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Sent from my iPhone >>>>>>>>>> >>>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >> >

1 1

Re: [Koha] Borrower's ID
by Owen Leonard 02 Oct '14

02 Oct '14

> Please, I need link on how to manually assign Borrow's number. Yes, this is your third message about it, but you never responded to the information I replied with after your first message: > It's important to understand what you're referring to. If you're > referring to the borrowernumber automatically assigned to each patron > in the database (borrowers.borrowernumber) then you can't control > that. borrowers.borrowernumber is for internal Koha use and shouldn't > be changed. > > If you'r referring to card number then you might want to check the > autoMemberNum system preference (Administration -> System preferences > -> Patrons). If that preference is turned on then Koha will > auto-populate the card number field when adding new patrons. If you didn't understand this response then please reply and ask for clarification. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

possible bug in print summary
by eugene jose espinoza 02 Oct '14

02 Oct '14

In Koha 3.16.3 and 3.16.4 running in a Debian server, installed through Debian package. The 'Print Summary' in Circulation does not include the check out books, where in 3.16.1 and probably 3.16.2, it shows the list of checked out items. I have a Koha ILS in 3.16.1 wherein it's shown. In 3.16.3 and 3.16.4, it does not show. When I updated 3.16.1 to 3.16.4, alas, it does not show. Could this be a bug? Thanks and cheers! -eugene

1 0

Koha 3.16.4 released
by Galen Charlton 02 Oct '14

02 Oct '14

The Koha community is pleased to announce the release of version 3.16.4 of the Koha library automation system. Koha 3.16.4 is a bugfix/maintenance release. Some of the bugs fixed are serious; users of earlier releases of Koha 3.16.x are urged to upgrade as soon as possible. It can be downloaded from: http://download.koha-community.org/ Debian packages of Koha 3.16.4 will be available shortly. Full release notes can be found at http://koha-community.org/koha-3-16-4-released/ Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0

integrate with active directory
by Mohamed Fekry Negm 01 Oct '14

01 Oct '14

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

2 1

Posting Troubleshooting Questions on Mailing Lists
by Arslan Farooq 01 Oct '14

01 Oct '14

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

5 6

Koha users in Malaysia (Southeast Asia ) ...
by Karam Qubsi 01 Oct '14

01 Oct '14

Hi, Since October 2013 I've been living and working here in Malaysia. I met some people who have interest about Koha ... and I wish if I can meet more of them here :) .. If we met maybe we can do various activities together ;) Best wishes Karam -- *Karam Qubsi <https://www.linkedin.com/in/kqubsi>* *Shah Alam , Malaysia . *

1 0

Koha news not showing
by schnydszch 30 Sep '14

30 Sep '14

In Koha version 3.16.3 Debian package, news suddenly not does not show in our Koha ILS opac. Anybody experienced/experiencing this? The news are published and have not expired yet. Even in the admin/librarian interface, news aren't showing. The theme used is bootstrap. We've just experienced this just today. Thanks and cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-news-not-showing-tp5813100.html Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Re: [Koha] Koha Digest, Vol 107, Issue 51
by Olawale Ilesanmi 30 Sep '14

30 Sep '14

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(a)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(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)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(a)gmail.com> > To: Mohamed Fekry Negm <mfekry6(a)hotmail.com> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] active directory + koha > Message-ID: > <CAFqgOiKFL10PGtAC_O0RRd9M2q=WKV0t3GvVj=XGhs=bNXtFsg(a)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(a)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(a)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(a)hotmail.com> > To: Riley Childs <rchilds(a)cucawarriors.com>, "koha(a)lists.katipo.co.nz" > <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] active directory + koha > Message-ID: <DUB127-W80302F9938866A7ED924B7F7BA0(a)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(a)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(a)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(a)merit.unu.edu> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] active directory + koha > Message-ID: <54290DFB.7030409(a)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(a)samba.company.com</principal_name> <mapping>  <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(a)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(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha [2] _______________________________________________ Koha mailing list http://koha-community.org [1] Koha(a)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(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Mysql high cpu usage > Message-ID: > <CAAR2sqhpTQWpu4-hu5SrwKzcsqLncrE9kZQ=Xe-VqW74FfpjTA(a)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(a)gmail.com > http://manucuesta.es [3] > > ------------------------------ > > Message: 5 > Date: Mon, 29 Sep 2014 15:14:21 +0500 > From: Arslan Farooq <arslanone(a)gmail.com> > To: Manuel Cuesta <manucuest(a)gmail.com> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Mysql high cpu usage > Message-ID: > <CAFqgOi+jxCmtXMj4iq2rkTY0iouzAyXMRVNtFMSBJ9_DckVWSw(a)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(a)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(a)gmail.com http://manucuesta.es [3] _______________________________________________ Koha mailing list http://koha-community.org [1] Koha(a)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(a)szabist-isb.edu.pk > +92 514 863 363-65 > > ------------------------------ > > Message: 6 > Date: Mon, 29 Sep 2014 15:20:59 +0500 > From: Arslan Farooq <arslanone(a)gmail.com> > To: Manuel Cuesta <manucuest(a)gmail.com> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Mysql high cpu usage > Message-ID: > <CAFqgOi+FwJbJsPt4QDDAUQCrEx-Wst2fyDYvWjriWH7XScA5TA(a)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(a)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(a)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(a)gmail.com http://manucuesta.es [3] _______________________________________________ Koha mailing list http://koha-community.org [1] Koha(a)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(a)szabist-isb.edu.pk +92 514 863 363-65 -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk [5] arslan.farooq(a)szabist-isb.edu.pk +92 514 863 363-65 ------------------------------ Message: 7 Date: Mon, 29 Sep 2014 15:41:54 +0500 From: Arslan Farooq <arslanone(a)gmail.com> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: [Koha] Posting Troubleshooting Questions on Mailing Lists Message-ID: <CAFqgOiKU=-7O4Y0tW5=TXF3Db9fMdjGfQQE2doEqMdFyjF9trA(a)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(a)gmail.com> To: Arslan Farooq <arslanone(a)gmail.com> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Mysql high cpu usage Message-ID: <CAAR2sqgQLzum8idRPzstbkAMxT7LajxfuJ5YSQ9n377D64j_UA(a)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(a)gmail.com http://manucuesta.es [3] On 29 September 2014 12:20, Arslan Farooq <arslanone(a)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(a)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(a)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(a)gmail.com http://manucuesta.es [3] _______________________________________________ Koha mailing list http://koha-community.org [1] Koha(a)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(a)szabist-isb.edu.pk +92 514 863 363-65 -- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk [5] arslan.farooq(a)szabist-isb.edu.pk +92 514 863 363-65 ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)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(a)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

1 0

Re: [Koha] Improving Search Results
by Paul A 30 Sep '14

30 Sep '14

At 04:32 PM 9/25/2014 -0500, Coehoorn, Joel wrote: [snip] >The point of this is that, from our librarians perspective, without a >better search experience, Koha is "broken". > >Those are their words, not mine. Here's the thing: when I run a search in >Koha, I do get back lots of results from our catalog that are highly >relevant to the search terms. But these are exact title matches, and they >come back with "Not found". > >How can I improve this? How do you re-index Zebra? Are your cron jobs working properly and regularly? Do you do a complete re-index (manually) from time to time? As an aside, we have found that using the "library catalogue" search (not 'title', nor 'author') and just putting in a couple of keywords from the title and the author's surname works remarkably well... Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

3 2