- Koha - lists.katipo.co.nz

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint
by Jonathan Druart 26 Jul '17

26 Jul '17

I tried to add the "Listen" lines and it breaks everything for me. What is the behaviour if you remove them? Do you access the staff interface (login form) or the opac interface (maintenance screen)? On Tue, 25 Jul 2017 at 18:51 C.J.S. Hayward <cjsh(a)cjshayward.com> wrote: > Ok; I can clean that up. > > But let me see if the same symptoms appear next time I work on it; my > expectation is that the behavior is identical (i.e. I am not able to log in > through the web interface with credentials in library/koha-conf.xml), even > if I should move the Listen lines. > > > Thanks, > > On Tue, Jul 25, 2017 at 4:27 PM, Jonathan Druart < > jonathan.druart(a)bugs.koha-community.org> wrote: > >> I think the 2 "Listen" lines should go to ports.conf >> >> On Tue, 25 Jul 2017 at 18:11 C.J.S. Hayward <cjsh(a)cjshayward.com> wrote: >> >> > Thank you. This server is multipurpose and has multiple webapps that >> > listen on 8080 by default. My library entry in >> /etc/apache2/sites-enables >> > reads, with /etc/hosts assigning "opac" and "library" to 127.0.0.1: >> > >> > # Koha instance library Apache config. >> > >> > # OPAC >> > >> > Listen 7027 >> > <VirtualHost *:7027> >> > <IfVersion >= 2.4> >> > Define instance "library" >> > </IfVersion> >> > Include /etc/koha/apache-shared.conf >> > # Include /etc/koha/apache-shared-disable.conf >> > # Include /etc/koha/apache-shared-opac-plack.conf >> > Include /etc/koha/apache-shared-opac.conf >> > >> > ServerName opac >> > SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml" >> > AssignUserID library-koha library-koha >> > >> > ErrorLog /var/log/koha/library/opac-error.log >> > # TransferLog /var/log/koha/library/opac-access.log >> > # RewriteLog /var/log/koha/library/opac-rewrite.log >> > </VirtualHost> >> > >> > # Intranet >> > Listen 7028 >> > <VirtualHost *:7028> >> > <IfVersion >= 2.4> >> > Define instance "library" >> > </IfVersion> >> > Include /etc/koha/apache-shared.conf >> > # Include /etc/koha/apache-shared-disable.conf >> > # Include /etc/koha/apache-shared-intranet-plack.conf >> > Include /etc/koha/apache-shared-intranet.conf >> > >> > ServerName intranet >> > SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml" >> > AssignUserID library-koha library-koha >> > >> > ErrorLog /var/log/koha/library/intranet-error.log >> > # TransferLog /var/log/koha/library/intranet-access.log >> > # RewriteLog /var/log/koha/library/intranet-rewrite.log >> > </VirtualHost> >> > ~ >> > >> > >> > I had earlier tried to access opac:7027 and got the reported error. Now >> I >> > am trying to access intranet:7028 and I can't tell a difference. >> > >> > Do I need to be doing more if I reassign port numbers? >> > >> > >> > Thanks, >> > >> > >> > On Tue, Jul 25, 2017 at 11:47 PM, Jonathan Druart < >> > jonathan.druart(a)bugs.koha-community.org> wrote: >> > >> >> If you reach the "system maintenance" screen that means you are hitting >> >> the >> >> OPAC interface, not the staff interface. >> >> Try on :8080 >> >> >> >> On Tue, 25 Jul 2017 at 17:17 C.J.S. Hayward <cjsh(a)cjshayward.com> >> wrote: >> >> >> >> > Let me send off this email, and I'll report a bug. >> >> > >> >> > N.B. Koha is installed in some sense, but when I try to access the >> >> > webinstaller I got maintenance mode: >> >> > >> >> > System Maintenance >> >> > >> >> > The Koha online catalog is offline for system maintenance. We'll be >> back >> >> > soon! If you have any questions, please contact the site >> administrator >> >> > >> >> > A brief search turned up >> >> > https://lists.katipo.co.nz/public/koha/2013-December/038208.html >> which >> >> > picked up in a possible email typo specifying a port as 8008. This >> >> > suggestion appears to be irrelevant because if the OP had tried to >> >> access >> >> > Koha on 8008 and hadn't added anything else listening on that port, >> the >> >> > error would be "Connection refused", not "System maintenance". >> >> > >> >> > On Tue, Jul 25, 2017 at 10:02 PM, Jonathan Druart < >> >> > jonathan.druart(a)bugs.koha-community.org> wrote: >> >> > >> >> >> Try with --create-db: >> >> >> koha-create --create-db library >> >> >> >> >> >> The doc says that --create-db is the default value, but it does not >> >> seem >> >> >> to >> >> >> work. >> >> >> Could you report the bug? >> >> >> >> >> >> On Tue, 25 Jul 2017 at 15:36 C.J.S. Hayward <cjsh(a)cjshayward.com> >> >> wrote: >> >> >> >> >> >> > Thank you. I've used koha-remove, and uninstalled and reinstalled >> >> >> > koha-common, including setting an a2enmod. >> >> >> > >> >> >> > Right now I have an /etc/koha heirarchy that has a lot of stuff in >> >> it, >> >> >> but >> >> >> > /etc/koha/sites is an empty directory *after* trying to run >> >> "koha-create >> >> >> > library": >> >> >> > >> >> >> > toolchest sites # koha-create library >> >> >> > failed to load external entity >> >> "/etc/koha/sites/library/koha-conf.xml" >> >> >> > >> >> >> > How can I create or get an appropriate koha-conf.xml? I notice >> that >> >> >> there >> >> >> > is an /etc/koha/koha-conf-site.xml.in; what can or should I be >> >> doing to >> >> >> > ideally transform it to make /etc/koha/sites/library/koha-conf.xml >> >> (and >> >> >> > anything else that should be in /etc/koha/sites/library/)? >> >> >> > >> >> >> > On Tue, Jul 25, 2017 at 8:46 PM, Doug Dearden <dearden(a)sarsf.org> >> >> >> wrote: >> >> >> > >> >> >> > > If you installed using the packages I believe you can use >> >> koha-remove >> >> >> . >> >> >> > > See here: >> >> https://wiki.koha-community.org/wiki/Commands_provided_by_ >> >> >> > > the_Debian_packages#koha-remove >> >> >> > > >> >> >> > > Doug >> >> >> > > >> >> >> > > -----Original Message----- >> >> >> > > From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf >> Of >> >> >> C.J.S. >> >> >> > > Hayward >> >> >> > > Sent: Tuesday, July 25, 2017 11:18 AM >> >> >> > > To: koha(a)lists.katipo.co.nz >> >> >> > > Subject: [Koha] Wiping all partial or full Koha isntallation(s) >> and >> >> >> > > installing stable under Mint >> >> >> > > >> >> >> > > I have a virtual machine that may have two conflicting Koha >> >> >> > installations. >> >> >> > > >> >> >> > > What, if anything, can I do that will wipe all Koha >> installations >> >> >> > > completely, and install a new stable from scratch, following >> >> >> > > https://wiki.koha-community.org/wiki/Debian? >> >> >> > > >> >> >> > > I don't know if I *exactly* need to go so far as to delete >> details >> >> >> like >> >> >> > the >> >> >> > > Koha repository in aptitude... but I am willing to do so if I am >> >> >> > advised. I >> >> >> > > do think it would be better to wipe any Koha-created directory >> >> >> > heirarchies, >> >> >> > > and drop any Koha-related databases. >> >> >> > > >> >> >> > > (Note: My system doesn't contain any valuable information *in* >> >> Koha; >> >> >> the >> >> >> > > only loss would be the time and energy to delete and rebuild the >> >> >> > > installation.) >> >> >> > > >> >> >> > > -- >> >> >> > > christos Jonathan Seth Hayward, >> >> >> > > An Orthodox Christian author. >> >> >> > > Amazon <http://amazon.com/author/cjshayward> - email >> >> >> > > <christos.jonathan.hayward(a)gmail.com> - website < >> >> >> https://cjshayward.com/ >> >> >> > >. >> >> >> > > _______________________________________________ >> >> >> > > Koha mailing list http://koha-community.org >> >> >> > > Koha(a)lists.katipo.co.nz >> >> >> > > https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> > > >> >> >> > >> >> >> > >> >> >> > >> >> >> > -- >> >> >> > christos Jonathan Seth Hayward, >> >> >> > An Orthodox Christian author. >> >> >> > Amazon <http://amazon.com/author/cjshayward> - email >> >> >> > <christos.jonathan.hayward(a)gmail.com> - website < >> >> >> https://cjshayward.com/>. >> >> >> > _______________________________________________ >> >> >> > Koha mailing list http://koha-community.org >> >> >> > Koha(a)lists.katipo.co.nz >> >> >> > https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> > >> >> >> _______________________________________________ >> >> >> Koha mailing list http://koha-community.org >> >> >> Koha(a)lists.katipo.co.nz >> >> >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> >> >> > >> >> > >> >> > >> >> > -- >> >> > christos Jonathan Seth Hayward, >> >> > An Orthodox Christian author. >> >> > Amazon <http://amazon.com/author/cjshayward> - email >> >> > <christos.jonathan.hayward(a)gmail.com> - website < >> >> https://cjshayward.com/>. >> >> > >> >> _______________________________________________ >> >> Koha mailing list http://koha-community.org >> >> Koha(a)lists.katipo.co.nz >> >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >> >> > >> > >> > >> > -- >> > christos Jonathan Seth Hayward, >> > An Orthodox Christian author. >> > Amazon <http://amazon.com/author/cjshayward> - email >> > <christos.jonathan.hayward(a)gmail.com> - website < >> https://cjshayward.com/>. >> > >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > christos Jonathan Seth Hayward, > An Orthodox Christian author. > Amazon <http://amazon.com/author/cjshayward> - email > <christos.jonathan.hayward(a)gmail.com> - website <https://cjshayward.com/>. >

3 6

Reg: Request to get listed in Koha Paid Supporters Page
by Sivagaami Shanmugam 26 Jul '17

26 Jul '17

Dear Team, We are a company called as '2CQR Automation Private Limited' at Chennai, Tamilnadu. We are a good supporters of Koha and have been dealing with it for few years now. It would be really great if our company also gets listed in Koha paid supporters page. Please find below the details of our company: Company Name: 2CQR Automation Private Limited Contact Person: Sivagaami Shanmugam Contact email: sivagaami(a)2cqr.in Website: http://2cqr.in/solutions/koha-rfid-based-library-automation-system.html Telephone:+91 9362002002 -- ------------------------------- Thanks & Regards, Sivagaami 2CQR Automation Private Limited "Let me win, but if I cannot win, let me be brave in the attempt"

1 0

Bulk Patron Image upload zip file giving Error 500
by Sunil Sharma 26 Jul '17

26 Jul '17

Hello Friends, I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. Currently, I am facing a very strange problem while uploading a single patron image via Koha Bulk Patron image upload tool, the image file is uploading fine. But When I tried using *zip file* of all patron images with a mapped text file named as IDLINK.TXT, As soon as I browse the zip file and try to upload the file, the page will through error 500. I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha 16.11.x but same *error 500* will be the result. To troubleshoot the problem I had tested the same Koha versions with same zip file at my local virtual machine but the strange problem which I found, that* all Koha* versions with bulk patron upload feature *worked fine on Debian 8.2 *but *through error 500 with Debian 8.3 * I had tested with different Apache versions but on Debian 8.2 all things worked fine, but on Debian 8.3 no success (may be any security fetch or something wrong is there) As there are a lot of other application are running on my cloud server so I can't change the OS. Please guide me what will I do? The Koha error logs are as given below: *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x] AH02429: Response header name ' extracting' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>* Any pointers would be of help. -- Thanks & Regards Sunil Sharma

5 7

Wiping all partial or full Koha isntallation(s) and installing stable under Mint
by C.J.S. Hayward 25 Jul '17

25 Jul '17

I have a virtual machine that may have two conflicting Koha installations. What, if anything, can I do that will wipe all Koha installations completely, and install a new stable from scratch, following https://wiki.koha-community.org/wiki/Debian? I don't know if I *exactly* need to go so far as to delete details like the Koha repository in aptitude... but I am willing to do so if I am advised. I do think it would be better to wipe any Koha-created directory heirarchies, and drop any Koha-related databases. (Note: My system doesn't contain any valuable information *in* Koha; the only loss would be the time and energy to delete and rebuild the installation.) -- christos Jonathan Seth Hayward, An Orthodox Christian author. Amazon <http://amazon.com/author/cjshayward> - email <christos.jonathan.hayward(a)gmail.com> - website <https://cjshayward.com/>.

3 8

koha password recovery
by Suresh Kumar Tejomurtula 25 Jul '17

25 Jul '17

Hi, In koha password recovery, it asks for Login:, Email:. I want our members to enter only loginid and they should get email to the members registered email id their password without asking for entering their email. Is this option possible? -- Regards T. Suresh Kumar

3 2

Meeting reminder: Development IRC meeting 26 July 2017, 14 UTC
by Nick Clemens 25 Jul '17

25 Jul '17

Hi All, Tomorrow is our next Koha Development meeting: Agenda is here: https://wiki.koha-community.org/wiki/Development_IRC_meeting_26_July_2017 Local date and time here: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I… Please add anything you wish to discuss to the agenda and add your name to the apologies if you can't make it. Hope to see you all soon! -Nick

1 0

Cataloging
by Ambika C.A. 24 Jul '17

24 Jul '17

Dear Sir/Madam, Our cataloging is showing the following error. We are unable to search or add books. Please help us to rectify the error. Software error: Undefined subroutine &main::/var/lib/koha/library/plugins called at (eval 1479) line 2. ...propagated at /usr/share/perl/5.18/base.pm line 83. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/QueryParser/Driver/PQF/query_plan.pm line 20. Compilation failed in require at /usr/share/koha/lib/Koha/QueryParser/Driver/PQF.pm line 27. BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/QueryParser/Driver/PQF.pm line 27. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Software error: [Mon Jul 24 15:11:51 2017] addbooks.pl: Undefined subroutine &main::/var/lib/koha/library/plugins called at (eval 1479) line 2. [Mon Jul 24 15:11:51 2017] addbooks.pl: ...propagated at /usr/share/perl/5.18/base.pm line 83. [Mon Jul 24 15:11:51 2017] addbooks.pl: BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/QueryParser/Driver/PQF/query_plan.pm line 20. [Mon Jul 24 15:11:51 2017] addbooks.pl: Compilation failed in require at /usr/share/koha/lib/Koha/QueryParser/Driver/PQF.pm line 27. [Mon Jul 24 15:11:51 2017] addbooks.pl: BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/QueryParser/Driver/PQF.pm line 27. Compilation failed in require at /usr/share/koha/lib/C4/Search.pm line 1402. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. We are using: Koha version:16.05.05.000OS version ('uname -a'):Linux ubuntu 3.16.0-33-generic #44~14.04.1-Ubuntu SMP Fri Mar 13 10:33:29 UTC 2015 x86_64Perl interpreter:/usr/bin/perlPerl version:5.018002Perl @INC:/usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.18.2 /usr/local/share/perl/5.18.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.18 /usr/share/perl/5.18 /usr/local/lib/site_perl . MySQL version:mysql Ver 14.14 Distrib 5.5.53, for debian-linux-gnu (x86_64) using readline 6.3Apache version:Server version: Apache/2.4.7 (Ubuntu)Zebra version:Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU Regards, *______________________________* Mrs. Ambika C.A. Librarian K.S. School of Engineering & Management #15, Mallasandra, Off. Kanakapura Road, BENGALURU - 560062 Ph: (080) 28425012 Extn: 200 Mob : 9036486519 <http://www.rediffmail.com/cgi-bin/red.cgi?red=http%3A%2F%2Flibrary%2Epes%2E…>

2 1

Duplicate Biblio Records
by Tim Young 22 Jul '17

22 Jul '17

Every once in a while I help out with a Koha installation. At the moment, they have asked me to fix a bunch of duplicate biblio records. I have found two main ways to do this. A manual way where you are in control every step of the way: http://manual.koha-community.org/3.2/en/stafflists.html#mergebibrecs And a potentially destructive way where you just guess and see what happens: https://saturn.ffzg.hr/koha/index.cgi?action=revision_view;page_name=removi… As I understand it, the latter basically has you choose one of the biblio records, point all your identical items to the one biblio record, and delete the other biblio records. Then, one runs a script (sync_items_in_marc_bib.pl) to add any missing data to the biblio record by pulling the data from the items. Being a mysql guy and scripting guy, this latter approach seems to be the "easy" way to do it. If I were a librarian and understood the biblio data, I might be howling in anguish at the thought of randomly selecting the biblio record. But I have no idea what the information means. I am a sysadmin and have no real understanding nor ownership of the data. And, I am not sure the people asking me to do this job completely understand the nuances of this either. So, I ask the Koha community for advice. Should I make a little script that runs the duplicate biblio sql script, selects one of the biblio records to point all the items to, and delete all the other biblio records? One would need to sync the marc items and reindex when done. Or is that basically a terrible thing to do? And, if I make such a script, is there a place where I should put the script so others do not need to make the same thing? - Tim Young

3 3

Error borrowed book
by Luis Moises Rojas 21 Jul '17

21 Jul '17

Hello everybody, We got this error since one hour ago when we try to borrowed a book: "This book could not be borrowed, belong to this library" "El libro no puede ser prestado, pertenece a esta biblioteca" I only need to "block" that user from another branch can not borrowed from another branch -- *Luis Moisés Rojas P.*

1 0

BANQ server returning no results
by ILOBWeb 21 Jul '17

21 Jul '17

Hello everyone, I have some records for resources with titles in French. When I try to add them through Z39.50 using BANQ server, its returning no results. However, if I search in BANQ's library that resource is available. I found something related to this - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11297. But, I am unable to implement this in my Koha library. Can anyone help me with this. Regards, Gurpreet

2 1