[Koha] Intranet error after upgrade
Hello, I recently upgraded my library to the following and didn't notice any errors during the upgrade. Koha version: 17.11.01.000 OS version ('uname -a'): Linux ip-172-31-36-26 4.4.0-109-generic #132-Ubuntu SMP Tue Jan 9 19:52:39 UTC 2018 x86_64 Perl version: 5.022001 MySQL version: mysql Ver 15.1 Distrib 10.0.33-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Apache version: Server version: Apache/2.4.18 (Ubuntu) Memcached: Servers: undefined Zebra version: Zebra 2.0.59 However, when I tried to access the Intranet (https://library.sj.org.za:8080) Chrome gives an 'Err empty response'. I tried it in Safari and got a similar message. But I can see the OPAC (https://library.sj.org.za/) just fine. On the localhost I can access the Intranet (using lynx), which made me think perhaps the problem is with Apache to the outside? But Apache is running. I looked in the error logs and found: tail /var/log/apache2/error.log [Sat Jan 20 06:26:11.494741 2018] [mpm_prefork:notice] [pid 8277] AH00163: Apache/2.4.18 (Ubuntu) mpm-itk/2.4.7-04 OpenSSL/1.0.2g configured -- resuming normal operations [Sat Jan 20 06:26:11.494755 2018] [core:notice] [pid 8277] AH00094: Command line: '/usr/sbin/apache2' [Sat Jan 20 06:26:11.714372 2018] [mpm_prefork:notice] [pid 8277] AH00171: Graceful restart requested, doing restart [Sat Jan 20 06:26:11.720326 2018] [core:warn] [pid 8277] AH00111: Config variable ${instance} is not defined [Sat Jan 20 06:26:11.720339 2018] [core:warn] [pid 8277] AH00111: Config variable ${instance} is not defined [Sat Jan 20 06:26:11.724453 2018] [mpm_prefork:notice] [pid 8277] AH00163: Apache/2.4.18 (Ubuntu) mpm-itk/2.4.7-04 OpenSSL/1.0.2g configured -- resuming normal operations [Sat Jan 20 06:26:11.724460 2018] [core:notice] [pid 8277] AH00094: Command line: '/usr/sbin/apache2' My vhost configuration for the Intranet is: Include /etc/koha/apache-shared.conf Include /etc/koha/apache-shared-intranet.conf ServerName library.sj.org.za SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml" SetEnv MEMCACHED_SERVERS "" SetEnv MEMCACHED_NAMESPACE "" 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 ScriptAlias /coverflow.pl "/var/lib/koha/library/plugins/Koha /Plugin/Com/ByWaterSolutions/CoverFlow/coverflow.pl" Alias /plugin "/var/lib/koha/library/plugins" # The stanza below is needed for Apache 2.4+ Options Indexes FollowSymLinks AllowOverride None Require all granted SSLCertificateFile /etc/letsencrypt/live/library.sj.org.za/cert.pem SSLCertificateKeyFile /etc/letsencrypt/live/library.sj.org.za/privkey.pem Include /etc/letsencrypt/options-ssl-apache.conf ServerName library.sj.org.za SSLCertificateChainFile /etc/letsencrypt/live/library.sj.org.za/chain.pem I'm running this on an Amazon EC2 instance. Has anyone any ideas on why it would just stop working after a routine sudo apt-get upgrade ? I'd be grateful for any hints or help. Matthew ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Reconfiguring the Intranet from 8080 to a real domain.
Hello, I'd like to ask for some help. I have successfully created a Letsencrypt certificate for the OPAC side of my Koha domain opac.domain.com What I would like to do, is instead of having a non-https http://opac.domain.com:8080/ site for the Librarian Interface, I would like to have a Letsencrypt certificate for the https://intranet.domain.com/ Is that possible? To secure with https both the front-end and the back-end of Koha? (since I think port 8080, precludes the use of 443 for https?) Could someone share their Apache or koha-sites.conf configuration as to how that would work? I understand how to generate the Letsencrypt certificate - but it's just getting the domain pointed to what was 8080 but making it now 80 (step 1), and then forcing a redirect to 443 for the https... Presumably - and perhaps this is my mistake - the domain registration of opac.domain.com and intranet.domain.com (and I know they have to be 'real domains') has to be pointing to the same IP? Matthew. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Catalogue - SQL Report Help (Paul A)
Dear Paul, Heather and Kerrie, Thank you for the report. I've also tweaked it slightly to allow direct interaction with the records in the Staff Interface (using example of CONCAT with A HREF and TITLE codes). (NB Distinguish between ' and ). I attach it here in case you might find it useful. I'm stuck with trying to get a version of the report that only shows 0 copies or copies greater than 1 (or to use the input technique to specify by x number of Copies)... I've tried the WHERE Copies=0 clause but that doesn't seem to work... SELECT DISTINCT CONCAT('a title=Search for Title with Biblionumber: ',b.biblionumber,' href=/cgi-bin/koha/catalogue/search.pl?q=ti%3A',REPLACE (b.title, ' ', '+'),'Search/a') AS Search for Title, b.biblionumber, CONCAT('a href=/cgi-bin/koha/catalogue/detail.pl?biblionumber=',b.biblionumber,'',b.title,'/a') AS Item Title, b.author, t.editionstatement, t.publishercode, t.isbn, count(i.itemnumber) AS Copies FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) GROUP BY b.biblionumber ORDER BY Copies ASC Regards Matthew. -- Message: 4 Date: Thu, 11 Dec 2014 01:19:06 + From: Kerrie Stevens kstev...@harvest.edu.au Subject: Re: [Koha] Catalogue - SQL Report Help (Paul A) SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) WHERE i.ccode=Enter collection code GROUP BY b.biblionumber Thanks so much for your sharing of this report. Kerrie Stevens ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Perl module ReadOnly::XS
Dear Fridolin, Thanks for your help. Here are copies of the output. Date: Tue, 27 May 2014 09:41:01 +0200 From: Fridolin SOMERS fridolin.som...@biblibre.com What does koha_perl_deps.pl -n return ? koha_perl_deps.pl -m (-n returned help) Installed Required Module is Module Name Version Version Required Readonly::XS 0 * 1.02 No Total modules reported: 1 * Module is missing or requires an upgrade. Run also : dpkg -l 'libreadonly*' dpkg -l 'libreadonly*' Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/ trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ NameVersion Description +++-===- ===- == ii libreadonly-perl1.03-3 facility for creating read-only scalars, arrays and hashes ii libreadonly-xs-perl 1.04-2build2Faster Readonly implementation ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Ideas for Amazon Image covers
Hi everyone, (Running Ubuntu 12.04.4 LTS and Koha 3.1401000) I just thought I'd share that after every upgrade I run the following commands: sed -i 's/MZZZ/LZZZ/g' /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/catalogue/ detail.tt sed -i 's/MZZZ/LZZZ/g' /usr/share/koha/opac/htdocs/opac-tmpl/prog/en/modules/opac-detail.tt sed -i 's/TZZZ/MZZZ/g' /usr/share/koha/opac/htdocs/opac-tmpl/prog/en/modules/opac-results.tt that basically make the bookcover larger/better definition in both the Results and Opac/Intranet Detail pages... I was wondering if this was the right way to do this, and if people prefer the larger images, could it be possible to have this as part of the normal .tt files that come with every upgrade? Also - is there a downside to doing this? Or could we have a systems preference to choose the size of the various bookcovers? Regards Matthew http://library.hekima.ac.ke/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Thank you - Circulation Rules Help needed - 1) Hard Time Proposal - 2) Query on Overnight/Weekend Loans
Dear all, I used to use an earlier version of Koha in 2007/8 but then moved out of library work (though I worked with Chrispin Sitali in Zambia who sometimes posts here (wave)), and have always remained a fan of Koha - but recently after moving to Nairobi, I had the opportunity to install a Koha installation using the more updated version (what a lot of work has gone on behind the scenes in the interim! Well done). In the last month or two we transitioned approx. 90,000 records from InMagic and, beginning this academic year (August), have started using Koha as our main OPAC and staff client. So far, we are getting very positive results - thank you for creating such a wonderful product. I have two questions though and I don't know if I'm just not seeing it or if I must submit a bug or feature request? I thought I'd ask here before I do - perhaps someone could let me know how best to proceed. I am using Koha 3.12.03.000 on Ubuntu 12.04.3 LTS (for some reason I can't get apt-get update|upgrade to see the new 3.12.04 version - but perhaps it's because I'm in Kenya and it'll take a while to filter to whatever repositories are mirrored here). We have circulation rules that allow for students to keep books for 2 weeks and staff for a month. The email they receive correctly acknowledges check-out and check-ins with a date/time stamp, but always puts the time to 23:59. I do not want to have the Circulation Librarian manually enter the date and time (by sliding those indicators) depending on the patron; I would prefer for the system to automatically calculate, as it does, whether the check-out is for 2 or 4 weeks. But if our library closes at 17h30 I don't want the due-time to be at 23h59. Is there a way - or could there be a way created - to set a closing time for the library, so that hourly loans (for our Reserve Section) can still be calculated, but if it falls past closing-time, e.g. 17h30 (for instance 23h59 or 22h00) it is reduced to 17h30 (so the students don't tell our library staff that they came at midnight but no-one was around)? I hope you understand what I'm trying to say. Another way of wording it might be to think about it in terms of the current 'Hard Date' in the Circulation and Fine Rules section in Administration in the Staff client. There is an option in the rules for a 'Hard Date' - but I would like to propose a 'Hard Time', i.e. whatever day is arrived at by the rules - the latest possible time would be the 'Hard Time'. This would work for us as we have two branches, one whose books must be returned by 17h30 of that day, and another whose books must be returned by 11h00. If there was a hard-time preference in the circulation rule it would be possible to specify it on a branch-by-branch basis. My second question is not so much a feature request (or if it's already there, a plea to have it pointed out to me) as it is to ask for some guidance from someone who has more experience in setting the circulation rules. Our library has a reserve section. Currently we allow books to be borrowed for a short-term period - a few hours during the day, the book not to be removed from the library (but we want the book checked-out and checked-in from the Reserve section so we can track usage and which students are actually accessing the material); But the reserved books may leave the library if it is borrowed between 17h00-17h30 - then it may be kept overnight, to be returned by 08h30. Currently I'm setting the rules up so that books from the Reserve section (an itemtype) have a 16 hour loan period so that if it's loaned at 17h00 the system calculates that it must be due back by 08h00 (though they receive an email saying it's due back 16 hours later - which ideally I'd like it to be 3 or 4 hours). But I need it so that if it's loaned on Friday it will be due on Monday 08h00. If I set holiday dates in the Calendar of the Library - it will ignore weekends - but that means for our 'normal loans (as explained in the previous problem) the 14 or 28 day rules (which used to include weekends) becomes more of an 18 or 32 day rule - but if that's the only way to get the Reserve Section check-outs working, then I will request our Librarian to change the rules to exclude weekends from all circulation check-in calculations... (I have individual rules for each branch, itemptype, and patron category - with the only 'All' rule being for the Reserve section.) Another idea I had was that fines would not accrue for Reserved books until 3 days - (i.e. Sat 08h30-Sun-08h30-Mon-08h30) - but that means a book could be taken out on Monday and the patron only show up in our morning emailed fine report on Wed, which given that we only have 1 copy of every book, would badly inconvenience our students. I think the 'Hard Time' feature could be extended to have an option that if it falls on 'end of week' then it is due 'beginning of following week' might solve it - but I don't know if that would be of interest to the wider community - or