- Koha - lists.katipo.co.nz

Re: [Koha] Enabling https only using SSL
by TechOut Solutions 15 May '19

15 May '19

Thanks for your inputs and response! Could you please provide a sample virtualhost file by providing a working copy or by referring to the template available from https://github.com/Koha-Community/Koha/blob/master/debian/templates/apache-… ? On Sun, May 12, 2019 at 7:26 PM Coehoorn, Joel <jcoehoorn(a)york.edu> wrote: > You must change the *:80 at the top to *:443. You will also want to copy > the original virtualhost section, before adding the sslengine settings, and > change it to redirect to the https url. > > On Sun, May 12, 2019, 5:18 AM TechOut Solutions < > techoutsolutions00(a)gmail.com> wrote: > >> Hi Joel, >> >> I couldn't find the four entries of virtual hosts but I did the following >> by searching for similar problems but others are using letsencrypt >> certificates. >> >> # OPAC >> <VirtualHost *:80> >> Include /etc/koha/apache-shared.conf >> # Include /etc/koha/apache-shared-disable.conf >> Include /etc/koha/apache-shared-opac.conf >> >> ServerName ssb >> SetEnv KOHA_CONF "/etc/koha/sites/ssb/koha-conf.xml" >> SetEnv MEMCACHED_SERVERS "" >> SetEnv MEMCACHED_NAMESPACE "" >> AssignUserID ssb-koha ssb-koha >> >> ErrorLog /var/log/koha/ssb/opac-error.log >> # TransferLog /var/log/koha/ssb/opac-access.log >> # RewriteLog /var/log/koha/ssb/opac-rewrite.log >> SSLEngine on >> SSLProtocol +TLSv1.2 +TLSv1.1 +TLSv1 >> SSLCipherSuite >> "ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA" >> SSLHonorCipherOrder on >> SSLCompression off >> >> SSLCertificateFile /etc/apache2/ssl/apache.crt >> SSLCertificateKeyFile /etc/apache2/ssl/apache.key >> </VirtualHost> >> >> I couldn't make the https protocol to load the OPAC using the above >> configuration. Do I need to use the letsencrypt certificate for it to work? >> >> Thanks! >> >> On Sun, May 12, 2019 at 10:43 AM Coehoorn, Joel <jcoehoorn(a)york.edu> >> wrote: >> >>> I'm not at a place where I can check, but if you look at your Apache >>> site .conf file, there will likely be 4 virtual host entries: an http >>> and https option for both the opac and staff client. You can remove most >>> everything from inside the http entries and replace them with Redirect >>> directives which point to the correct https urls. >>> >>> On Sat, May 11, 2019, 11:41 PM TechOut Solutions < >>> techoutsolutions00(a)gmail.com> wrote: >>> >>>> Hi there, >>>> >>>> I am trying to setup Koha OPAC and Staff-Client using https protocol >>>> only >>>> using SSL and want to disable http access to Koha. I'd appreciate if I >>>> could get the sample apache virtualhost site configuration to achieve >>>> the >>>> result. Thank you. >>>> >>>> Regards, >>>> Nirvana >>>> _______________________________________________ >>>> Koha mailing list http://koha-community.org >>>> Koha(a)lists.katipo.co.nz >>>> https://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>>

2 2

LiveDVD of Six Software Packages in 64 bits OS of Lubuntu 16.04.5
by mohan pradhan 15 May '19

15 May '19

Dear all, HealthNet Nepal has configured LIve DVD of six software packages for library use in 64 bits OS of Lubuntu 16.4.5 version. This 64 bits contains the following software ( https://sourceforge.net/projects/livedvdvufindkohadspace/) Koha ILS (18.05.08), DSpace (6.3), SubjectsPlus(4.2.2), Vufind(5.0), WordPress(5.0.4). It has also configuration of Exim mail server. Through API SubjectsPlus data can be used in WordPress. A plugin is also developed in WordPress for use of VuFind search engine in WordPress for searching database of Koha, VuFind and SubjectsPlus databases. The software can be used by library professionals without having in-depth knowledge of computer skill. For installation in the hard disk, either right click in the Install Release and tick mark in the "Execute in terminal Emulator" then click ok. Now click ok in Install Release and the prompt password: type "healthnet" or go to the terminal with the command ctrl_+alt+t and type "sudo sh -c 'ubiquity gtk_ui'we and the prompt password : type "healthnet". Help file is included along with the software. For Downloading the the software go to the url : https://sourceforge.net/projects/livedvdvufindkohadspace Prof. Mohan Raj Pradhan, Ph. D. Chairman HealthNet Nepal web: https://www.mpradhan.com.np email: pradhmohan@gmail.com/mpradhan@healthnet.org.np

1 0

Call for News: May 2019 Newsletter
by kohanews 14 May '19

14 May '19

Hello all! I'm collecting news for the May newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Koha 18.11.05, 18.05.12 and 17.11.18 release
by Renvoize, Martin 14 May '19

14 May '19

The Koha community is proud to announce the release of Koha versions 18.11.05, 18.05.12 and 17.11.18. These are combined security and maintenance releases and we recommend you update your systems at your earliest convenience. Debian packages have been uploaded and are available as of now, and detailed release notes for each respective version can be found below: 18.11.05 - https://koha-community.org/koha-18-11-05-release/ 18.05.12 - https://koha-community.org/koha-18-05-12-release/ 17.11.18 - https://koha-community.org/koha-17-11-18-release/ My apologies for the delay in this release, we felt it pertinent to try and avoid as many of the bank holidays as possible. Many thanks to all who have contributed to these releases, *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

4 4

Re: [Koha] SQL Report - Authorities. List duplicate values based on 010$a
by Stefano Bargioni 14 May '19

14 May '19

Maybe a self join can help you. See https://www.w3schools.com/sql/sql_join_self.asp <https://www.w3schools.com/sql/sql_join_self.asp> However, your query could be very slow, since the match will not work on indexed data. If not sure, but try SELECT A.authid AS authid1, B.authid AS authid2, ExtractValue(A.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') AS dup FROM auth_header A, auth_header B WHERE A.authid <> B.authid AND ExtractValue(A.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') <> '' AND ExtractValue(A.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') = ExtractValue(B.marcxml,'/record/datafield[@tag="010"]/subfield[@code="a"]') ORDER BY A.authid; HTH. Stefano > Subject: [Koha] SQL Report - Authorities. List duplicate values based > on 010$a > Message-ID: > <CAP4tGF9Em5-4xiMHerf9B6sS+9ogzmh8_iMgKz-zJdtDJeBh6A(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi all, > > Koha 18.11 on Ubunti 16.04 > > May I request help for an SQL report that does the following, please: > > Identify and list by authid and main heading all authority records that > have a tag 010$a with duplicate values? > > I am attempting to located all authority records that can be merged (or > de-duped via merge). > > Many thanks! > > Craig Butosi, MA, MLIS, B Mus (Hons) > Library: library.craigbutosi.ca > > > ------------------------------ > > Message: 2 > Date: Sun, 12 May 2019 01:49:55 +0530 > From: vijay kumar <vijcrjbhu(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] upgrade from koha-17.05.06 to koha-latest > Message-ID: > <CACNt1H6pKRZsRJiQQSeoevwDbuMYRwDmxCOiMBksweSfPUbGCg(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Dear all, > We have koha-17.05.06, installed using tarball method. > > I have followed the following methods for upgrading from koha-17.05.06 to > koha-latest > 1. Updated koha-list source accordingly koha-stable > 2. Update all perl dependencies and cpan module > > vijay@debian:/usr/share/koha-18.11.04$ perl Makefile.PL > /usr/share/koha-17.05.06/misc/koha-install-log > /usr/share/koha/misc/koha-install-log > > and also > > vijay@debian:/usr/share/koha-18.11.04$ sudo perl Makefile.PL > /usr/share/koha-17.05.06/misc/koha-install-log > /usr/share/koha-18.11.04/misc/koha-install-log > > vijay@debian:/usr/share/koha-18.11.04$ sudo make > > vijay@debian:/usr/share/koha-18.11.04$ sudo make upgrade > ------------------------------------------------------------------------------------ > > Getting the following error during upgrade > Kindly suggest the proper method for up-gradation of koha-latest > > With regards, > Vijay Kumar > > > ::::error:::: > > vijay@debian:/usr/share/koha-18.11.04$ sudo make upgrade > Can't locate C4/Installer/UpgradeBackup.pm in @INC (you may need to install > the C4::Installer::UpgradeBackup module) (@INC contains: /etc/perl > /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 > /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 > /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 > /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base). > BEGIN failed--compilation aborted. > Makefile:22908: recipe for target 'make_upgrade_backup' failed > make: *** [make_upgrade_backup] Error 2 > > > ------------------------------ > > Message: 3 > Date: Sun, 12 May 2019 08:27:33 +1200 > From: David Nind <david.nind(a)gmail.com> > To: Craig Butosi <cbutosi(a)gmail.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] SQL Report - Authorities. List duplicate values > based on 010$a > Message-ID: > <CAK5OMPcJCLGVyOHFBubZ2-Et9-Tf-cTWyk+Ui21eYPXhxE-z6g(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi Craig. > > I'm not that great at reports, but you might be able to find something in > the SQL reports library that could help: > https://wiki.koha-community.org/wiki/SQL_Reports_Library > > > David Nind | david.nind(a)gmail.com > PO Box 12367, Thorndon, Wellington, New Zealand 6144 > m. +64 21 0537 847 > > > On Sun, 12 May 2019 at 05:46, Craig Butosi <cbutosi(a)gmail.com> wrote: > >> Hi all, >> >> Koha 18.11 on Ubunti 16.04 >> >> May I request help for an SQL report that does the following, please: >> >> Identify and list by authid and main heading all authority records that >> have a tag 010$a with duplicate values? >> >> I am attempting to located all authority records that can be merged (or >> de-duped via merge). >> >> Many thanks! >> >> Craig Butosi, MA, MLIS, B Mus (Hons) >> Library: library.craigbutosi.ca >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 163, Issue 12 > *************************************

2 1

koha for instrument
by martin007 14 May '19

14 May '19

Hi, I need help on Koha. I want to use it to carry out an inventory of laboratory equipment such as oscilloscopes, tools, voltage sources. I would appreciate any kind of information -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 1

Modifications in OPAC script not shown
by Camilo Freire 13 May '19

13 May '19

Salud: i'im triying to do some little modifications in the script that shows the MARC format of the record in Koha's OPAC (opac-MARCdetail.pl). I've found that any modification in the code is not shown inmmedialely on the screen, for example if I make print "Content-Type: text/html\n\n"; print "<html><body>something</body></html>"; exit; the message is not shown at all. Only if I change the name of the script and run it works, but again the new script seems to remain "frozen" in this initial step and doesn't show any further modification. I suppose that the problem is based in the existence of some cache anywhere, I would like to know how to avoid this behaviour in order to see in real time the effect of the modifications I'm doing. Thank you very much Camilo Freire Uruguay

2 1

Patron categories automatically reverting (3.18.11)
by TCC_Beth 13 May '19

13 May '19

We have an old installation (3.18.11), and have recently started seeing patrons who used to be listed as one category (Staff) all reverting to a different category (Student). We'll go in via admin and manually change them back, and then the next time we check them, it's reverted back to Student again. This is really messing up our stats and is also problematic because different categories have different borrowing privileges. Without a drastic update to the newest release of Koha (skipping many in between which I worry would cause a lot of problems), does anyone know if there were any bug fixes released for 3.18 that might fix this issue? Or is there some setting that might be causing this that we could tweak? I'm new to my position and to Koha, so I'm not sure how to remedy this issue. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 5

Error while using Acquisition Module vendors search (Koha 18.11.05 on Ubuntu 18.04 LTS)
by Ata ur Rehman 13 May '19

13 May '19

Dear All Ref to Bug: 22869 I got the following error message while searching a vendor (which is available) or adding a new vendor: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081. I've migrated database from an old version to 18.11.05 (Ubuntu 18.04 LTS). Intranet Error log says: [Thu May 09 01:31:31.751639 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: DBD::mysql::st execute failed: Out of sort memory, consider increasing server sort buffer size [for Statement ": /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.752809 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SELECT aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753108 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(aqorders.quantity) AS total_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753281 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753555 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF ( aqorders.orderstatus = 'cancelled', aqorders.quantity, 0 ): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753784 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS total_items_cancelled,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754027 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754164 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754361 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754741 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754920 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755064 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755235 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS expected_items: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755404 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: FROM aqbasket: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755786 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.756914 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: WHERE booksellerid = ? GROUP BY aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items HAVING (closedate IS NULL OR (: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757067 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757268 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757644 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757851 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757993 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762276 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) > 0))" with ParamValues: 0=1] at /usr/share/koha/lib/C4/Acquisition.pm line 705.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762667 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl Screenshot may please be found at: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89479 Any help/advice would be appreciated, pl. Regards, Ata ur Rehman NCP - Islamabad

3 2

Re: [Koha] Enabling https only using SSL
by TechOut Solutions 12 May '19

12 May '19

Hi Joel, I couldn't find the four entries of virtual hosts but I did the following by searching for similar problems but others are using letsencrypt certificates. # OPAC <VirtualHost *:80> Include /etc/koha/apache-shared.conf # Include /etc/koha/apache-shared-disable.conf Include /etc/koha/apache-shared-opac.conf ServerName ssb SetEnv KOHA_CONF "/etc/koha/sites/ssb/koha-conf.xml" SetEnv MEMCACHED_SERVERS "" SetEnv MEMCACHED_NAMESPACE "" AssignUserID ssb-koha ssb-koha ErrorLog /var/log/koha/ssb/opac-error.log # TransferLog /var/log/koha/ssb/opac-access.log # RewriteLog /var/log/koha/ssb/opac-rewrite.log SSLEngine on SSLProtocol +TLSv1.2 +TLSv1.1 +TLSv1 SSLCipherSuite "ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA" SSLHonorCipherOrder on SSLCompression off SSLCertificateFile /etc/apache2/ssl/apache.crt SSLCertificateKeyFile /etc/apache2/ssl/apache.key </VirtualHost> I couldn't make the https protocol to load the OPAC using the above configuration. Do I need to use the letsencrypt certificate for it to work? Thanks! On Sun, May 12, 2019 at 10:43 AM Coehoorn, Joel <jcoehoorn(a)york.edu> wrote: > I'm not at a place where I can check, but if you look at your Apache site > .conf file, there will likely be 4 virtual host entries: an http and https > option for both the opac and staff client. You can remove most everything > from inside the http entries and replace them with Redirect directives > which point to the correct https urls. > > On Sat, May 11, 2019, 11:41 PM TechOut Solutions < > techoutsolutions00(a)gmail.com> wrote: > >> Hi there, >> >> I am trying to setup Koha OPAC and Staff-Client using https protocol only >> using SSL and want to disable http access to Koha. I'd appreciate if I >> could get the sample apache virtualhost site configuration to achieve the >> result. Thank you. >> >> Regards, >> Nirvana >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >

1 0