Re: [Koha] New Debian install - OPAC invisible

[Doug Dearden]

Hi Apparrish,

These commands should disable the default site, then restart apache.  I believe 
your OPAC will show up after that:

a2dissite default
apache2ctl restart

Best,

Doug


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Aparrish
Sent: Wednesday, October 7, 2015 12:40 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] New Debian install - OPAC invisible

Hey all,

I've got a latest-ed Koha install on Debian Jessie on which the staff client is 
displaying properly in the web browser, but the OPAC address is displaying the 
Apache2 default web server page (It Works!).

I followed (with some other help)   these

directions. This is all I want - a test server accessible from the local 
machine. 

Currently configured to accept http://127.0.1.1:8080 as staff and
http://127.0.1.1:80 as OPAC. 
I'm sure I'm doing something stupid, but I don't know quite what it is. I don't 
have a web error log for OPAC, will post code and .conf files as needed. I've 
gone through staff config as far as setting a library. 



--
View this message in context: 
http://koha.1045719.n5.nabble.com/New-Debian-install-OPAC-invisible-tp5856117.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Changing IP on Koha Server

[Doug Dearden]

Hi Greg,

You don't say which distro you are using.  On my Debian install, I have the IP 
addresses I use statically defined in /etc/network/interfaces .  I would check 
there first.

Best,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of G P Ashe
Sent: Friday, October 30, 2015 9:07 AM
To: koha-user 
Subject: [Koha] Changing IP on Koha Server

I need to change the fixed IP on Koha server.

What files need to be updated manually in order that everything will work as 
before but with new IP (different subnet).

Thanks

Greg

-- 


*Disclaimer Important*: ​
Information in this email (including attachments) is confidential. It is 
intended for receipt and consideration only by the intended recipient. If you 
are not an addressee or intended recipient, any use, dissemination, 
distribution, disclosure, publication or copying of information contained in 
this email is strictly prohibited. Opinions expressed in this email may be 
personal to the author and are not necessarily the opinions of *Glenstal Abbey 
School Ltd*. If this email has been received by you in error we would be 
grateful if you could immediately notify the sender, and thereafter delete this 
e-mail from your system.  You are requested to carry out your own virus check 
before opening any attachment. The author and *Glenstal Abbey School Ltd* 
accept no liability for any loss or damage which may be caused by viruses, 
malware or malicious software.
​ Please consider the environment before printing this email.​ 
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Changing IP on Koha Server

[Doug Dearden]

Hi Greg,

Always reply to the list when you post something.  You get more eyes reading 
the message and more brains working on the problem. ☺

As far as I know Ubuntu should have the IP addresses in the same place as 
Debian.  Did you check in /etc/network/interfaces ?

Doug

From: g...@glenstal.com [mailto:g...@glenstal.com] On Behalf Of G P Ashe
Sent: Monday, November 9, 2015 3:53 AM
To: Doug Dearden 
Subject: Re: [Koha] Changing IP on Koha Server

Hi Doug

Ubuntu 12.04
Koha 3.20.05

Greg



On 30 October 2015 at 20:27, Doug Dearden 
mailto:dear...@sarsf.org>> wrote:
Hi Greg,

You don't say which distro you are using.  On my Debian install, I have the IP 
addresses I use statically defined in /etc/network/interfaces .  I would check 
there first.

Best,

Doug

-Original Message-
From: Koha 
[mailto:koha-boun...@lists.katipo.co.nz<mailto:koha-boun...@lists.katipo.co.nz>]
 On Behalf Of G P Ashe
Sent: Friday, October 30, 2015 9:07 AM
To: koha-user mailto:koha@lists.katipo.co.nz>>
Subject: [Koha] Changing IP on Koha Server

I need to change the fixed IP on Koha server.

What files need to be updated manually in order that everything will work as 
before but with new IP (different subnet).

Thanks

Greg
--


*Disclaimer Important*: ​
Information in this email (including attachments) is confidential. It is 
intended for receipt and consideration only by the intended recipient. If you 
are not an addressee or intended recipient, any use, dissemination, 
distribution, disclosure, publication or copying of information contained in 
this email is strictly prohibited. Opinions expressed in this email may be 
personal to the author and are not necessarily the opinions of *Glenstal Abbey 
School Ltd*. If this email has been received by you in error we would be 
grateful if you could immediately notify the sender, and thereafter delete this 
e-mail from your system.  You are requested to carry out your own virus check 
before opening any attachment. The author and *Glenstal Abbey School Ltd* 
accept no liability for any loss or damage which may be caused by viruses, 
malware or malicious software.
​ Please consider the environment before printing this email.​ 
___
Koha mailing list  http://koha-community.org 
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> 
https://lists.katipo.co.nz/mailman/listinfo/koha


[http://www.glenstal.com/wp-content/uploads/2015/09/Glenstal-Abbey-School-sig.png]

Disclaimer Important: ​
Information in this email (including attachments) is confidential. It is 
intended for receipt and consideration only by the intended recipient. If you 
are not an addressee or intended recipient, any use, dissemination, 
distribution, disclosure, publication or copying of information contained in 
this email is strictly prohibited. Opinions expressed in this email may be 
personal to the author and are not necessarily the opinions of Glenstal Abbey 
School Ltd. If this email has been received by you in error we would be 
grateful if you could immediately notify the sender, and thereafter delete this 
e-mail from your system.  You are requested to carry out your own virus check 
before opening any attachment. The author and Glenstal Abbey School Ltd accept 
no liability for any loss or damage which may be caused by viruses, malware or 
malicious software.
​ Please consider the environment before printing this email.​
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] FW: Can only access OPAC or Staff client

[Doug Dearden]

Hi Kelsey,

For your OPAC use library.kohaesfl.org (defaults to port 80)
For your staff client use library.kohaesfl.org:8080 (forces use of port 8080)

Best,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Kelsey Lied
Sent: Thursday, May 12, 2016 10:36 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Can only access OPAC or Staff client

Hi,

I've got a new almost-up install with a weird happening -- only the OPAC or
Staff client is available.

I've split the two to be on different ports, 80 and 8080.  Both
library.kohaesfl.org and library-intra.kohaesfl.org will go to whichever
site is currently set to port 80.  (ie, right now, the OPAC is on 80 and
they both go to the OPAC.  If I flip the ports in
/etc/apache2/sites-available/library.conf and /etc/koha/koha-sites.conf so
that the intranet is on port 80, both URLs will give the staff side).

Both subdomains have valid DNS entries pointing them to the right server;
both will work if accessed via IP:port; both 80 and 8080 are being
"Listen"ed to in /etc/apache2/ports.conf

Has anybody seen this or does anybody have any ideas on what to try?

Thanks,
Kelsey Lied
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] FW: Can only access OPAC or Staff client

[Doug Dearden]

Hi Kelsey,

I think what you want is to make your OPAC and your staff client both listen on 
port 80, and use the ServerName directive to distinguish between the two.
https://httpd.apache.org/docs/current/vhosts/examples.html

Doug



From: Kelsey Lied [mailto:kal...@stkate.edu]
Sent: Thursday, May 12, 2016 2:50 PM
To: Doug Dearden 
Cc: koha-user 
Subject: Re: [Koha] FW: Can only access OPAC or Staff client

Thanks, Doug.

This'll work in a pinch and get us through.

I'm curious, though, why we'd have to force the port -- shouldn't the name 
matching in the virtual hosts make forcing the port unnecessary?  I think 
there's some hiccup in the configurations that's interfering with this working 
with standard-port-less URLs.  I shouldn't have had to move the staff client 
off of 80 at all if the name-matching was working...

On Thu, May 12, 2016 at 2:53 PM, Doug Dearden 
mailto:dear...@sarsf.org>> wrote:

Hi Kelsey,

For your OPAC use library.kohaesfl.org<http://library.kohaesfl.org> (defaults 
to port 80)
For your staff client use 
library.kohaesfl.org:8080<http://library.kohaesfl.org:8080> (forces use of port 
8080)

Best,

Doug

-Original Message-
From: Koha 
[mailto:koha-boun...@lists.katipo.co.nz<mailto:koha-boun...@lists.katipo.co.nz>]
 On Behalf Of Kelsey Lied
Sent: Thursday, May 12, 2016 10:36 AM
To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>
Subject: [Koha] Can only access OPAC or Staff client

Hi,

I've got a new almost-up install with a weird happening -- only the OPAC or
Staff client is available.

I've split the two to be on different ports, 80 and 8080.  Both
library.kohaesfl.org<http://library.kohaesfl.org> and 
library-intra.kohaesfl.org<http://library-intra.kohaesfl.org> will go to 
whichever
site is currently set to port 80.  (ie, right now, the OPAC is on 80 and
they both go to the OPAC.  If I flip the ports in
/etc/apache2/sites-available/library.conf and /etc/koha/koha-sites.conf so
that the intranet is on port 80, both URLs will give the staff side).

Both subdomains have valid DNS entries pointing them to the right server;
both will work if accessed via IP:port; both 80 and 8080 are being
"Listen"ed to in /etc/apache2/ports.conf

Has anybody seen this or does anybody have any ideas on what to try?

Thanks,
Kelsey Lied
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Handling student worker accounts

[Doug Dearden]

Hi Eric,

From a system admin viewpoint I never create generic logins for users.  The 
reason is that if you have to investigate something after the fact, and a log 
file indicates that "Librarian1" was the username you don't know who that is if 
it is shared amongst several people.  Better to create a separate user name for 
everyone that is going to be using the system.  You could create a second 
patron account for these work study students to use when they are working at 
the library, that would then be deleted at the end of the semester leaving 
their regular account intact.

Regarding your "roles" question, Koha does have a Duplicate function.  If you 
create a "work study" user, assign it all the appropriate permissions, you can 
then edit the user and use the Duplicate function to make a new user with the 
same permissions, and just fill in the necessary fields for individual 
identification.

Good luck, and welcome!

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Eric 
Phetteplace
Sent: Friday, June 3, 2016 1:27 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Handling student worker accounts

Hi all,

First of all, we are right now starting to migrate to Koha so I'm probably
going to ask a lot of questions on this list in the coming weeks. Bear with
me.

If you have low-level employees who perform basic circulation work—e.g.
work study students, volunteers—how do you handle their account
permissions? Do you have a shared internal account with a password you
periodically change? Do you edit their patron account to add necessary
permissions and then later revoke them?

We're trying to find a scalable way to handle this. Editing a half-dozen or
so patron accounts each semester doesn't seem wise to me. But internal
accounts like this are weird too, because they're not "real" patrons. For
instance, I'm filling in fake barcodes because they're required but this
patron will never check anything out.

Also, are is there no equivalent of user "roles" in Koha—sets of
permissions I can quickly apply to an account? It's one thing if I can just
add a student to a "work study" role and another if I have to click a bunch
of checkboxes.

Best,
Eric Phetteplace
Systems Librarian
California College of the Arts
libraries.cca.edu | vault.cca.edu
510.594.3660
2>/dev/null
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] New Kohaer question

[Doug Dearden]

Hi Jimmy,

I have installed Debian on a Mac, but not for use with Koha.  This is just a 
matter of matching the version of Debian you are installing with the processor 
that is in the Mac.  In my case it was an older Mac with the Motorola 
processor.  If you have newer hardware it probably has the intel processors.  
If you still have OS X installed you can get all the hardware info by clicking 
on the apple icon and choosing "About this Mac".  You may need to look at the 
advanced info to see everything.  When you have that info you can download the 
correct Debian install and follow the installation instructions on the Debian 
website.  

Best,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Zhimin Chen
Sent: Friday, July 1, 2016 11:44 AM
To: koha-de...@lists.koha-community.org; koha@lists.katipo.co.nz
Subject: [Koha] New Kohaer question

Dear Kohaers,

Do you have any experience to install Koha in Mac os x? no Debian no VM.

If no, How do I install Debian in Mac machine? I would like re-image mac os
x with Debian.

Thanks,

Jimmy
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Managing digital subscriptions

[Doug Dearden]

Hi Folks,

We have received notice from one of the journals we subscribe to that they are 
going to only be providing digital format in the future.  For copyright reasons 
I don't think we can just download this file then link to it using the 856u 
field as that would make it downloadable by anyone.  I looked through the 
manual but didn't find anything to address this.  I believe the ideal situation 
is for the document to be viewable at a workstation inside the library, but not 
through the public OPAC.

Is there a way to handle this?

We are on an older version (3.16) but I am quite prepared to update to the 
latest release as needed.

Thanks,

Doug Dearden
Director, IT
School for Advanced Research
505-954-7220

The School for Advanced Research has supported innovative social science and 
Native American artistic creativity for more than a century. Since we began 
offering fellowships in 1972, we have funded the work of more than 345 SAR 
scholars and artists, among whose ranks are six MacArthur Fellows and eighteen 
Guggenheim Fellows. Please join us in Santa Fe for insightful lectures or a 
tour of the School's historic campus. You can also follow the work of our 
resident scholars and Native American artists on our website at 
www.sarsf.org<http://www.sarsf.org>.


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha + Email Relay to Microsoft Exchange Server

[Doug Dearden]

Hi Craig,

What about white listing the sending address from your Koha install on your 
Exchange server?  If mail to x...@gmail.com gets through, then mail to 
x...@rcmusic.ca should get through.  Is the sending address also rcmusic.ca ?  
I know spam filters often stop those emails that have the same domain name but 
are coming from outside the network.  If you are utilizing a spam filtering 
service it could be happening there too.

Best,

Doug Dearden
Director, IT
School for Advanced Research
505-954-7220

The School for Advanced Research has supported innovative social science and 
Native American artistic creativity for more than a century. Since we began 
offering fellowships in 1972, we have funded the work of more than 345 SAR 
scholars and artists, among whose ranks are six MacArthur Fellows and eighteen 
Guggenheim Fellows. Please join us in Santa Fe for insightful lectures or a 
tour of the School's historic campus. You can also follow the work of our 
resident scholars and Native American artists on our website at www.sarsf.org.



-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Craig Butosi
Sent: Friday, September 30, 2016 3:01 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Koha + Email Relay to Microsoft Exchange Server

Hi all,

Koha 16.05.03 on Ubuntu 14.04 LTS (Amazon AWS)

We're running Koha on a separate VPS from our organization's network. We are 
using a our library's generic email address, which is a Microsoft Exchange 
server organization email address. We are trying to get our Koha VPS to 
successfully deliver notices to emails within our network domain. We are 
running Sendmail on our Koha box, and Gmail, Yahoo, and Hotmail accounts (after 
users whitelist our library email address) emails are being received 
successfully. Emails are not successfully delivered to our organization's email 
domain.

What we want to do is channel all email notifications coming from our Koha VPS 
through our Microsoft Exchange server, so that they are seen as coming from our 
network, do not get flagged as spam, junk, etc., and so that they are 
successfully delivered to inboxes.

Has anyone done this with their Koha set-up? Is this a sendmail config file 
modification, a sendmail Perl module configuration, or something else?

Thanks all!

Craig Butosi, MA, MLIS, B Mus (Hons.)
LIBRARY SERVICES MANAGER
the royal conservatory
TELUS Centre for Performance and Learning
273 Bloor Street West
Toronto, ON M5S 1W2
416.408.2824 x338
www.rcmusic.ca<http://www.rcmusic.ca/>



Note: This email message and any attachments are intended only for the use of 
the individual to which it is addressed, and may contain information that is 
privileged, confidential and exempt from disclosure under applicable law. If 
the recipient of this email is not the intended recipient (or the employee or 
agent responsible for delivering the email to the intended recipient), you are 
hereby notified that any review, dissemination, distribution or copying or 
other use of this message is strictly prohibited. If you have received this 
communication in error, please notify the sender immediately by return email 
and delete this message and attachments from your system, thank you.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Migrating to new server and need help

[Doug Dearden]

Hello all,

I am migrating to a new server and upgrading Koha at the same time.  I 
installed the latest stable release of Debian Jessie, and the latest version of 
Koha using the packages.  Using koha-restore  I successfully migrated 
two instances.  I did have to fix the koha-conf.xml files along with the zebra 
config files to get things working right for dom indexing.  I am getting errors 
when trying to install the third and final instance.  I checked the edits in 
the config files, tried doing a koha-remove followed by another koha-restore, 
and followed that up with koha-create-dirs just to make sure I didn't miss 
anything.  I keep getting this error when I hit the staff client:
Software error:
not well-formed (invalid token) at line 34, column 5, byte 1422 at 
/usr/lib/x86_64-linux-gnu/perl5/5.20/XML/Parser.pm line 187.
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Output.pm line 33.
Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl 
line 24.
BEGIN failed--compilation aborted at 
/usr/share/koha/intranet/cgi-bin/mainpage.pl line 24.

Here's the server info from one of the running instances:
Koha version:

16.05.05.000

OS version ('uname -a'):

Linux SAR122Linux 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u2 (2016-10-19) 
x86_64

Perl interpreter:

/usr/bin/perl

Perl version:

5.020002

Perl @INC:

/usr/share/koha/lib
/etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2
/usr/lib/x86_64-linux-gnu/perl5/5.20
/usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl/5.20
/usr/share/perl/5.20
/usr/local/lib/site_perl
.

MySQL version:

mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3

Apache version:

Server version: Apache/2.4.10 (Debian)

Zebra version:

Zebra 2.0.59 (C) 1994-2014, Index Data 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: 
c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU


Any  and all help appreciated.

Thanks,

Doug Dearden
Director, IT
School for Advanced Research
505-954-7220

The School for Advanced Research has supported innovative social science and 
Native American artistic creativity for more than a century. Since we began 
offering fellowships in 1972, we have funded the work of more than 345 SAR 
scholars and artists, among whose ranks are six MacArthur Fellows and eighteen 
Guggenheim Fellows. Please join us in Santa Fe for insightful lectures or a 
tour of the School's historic campus. You can also follow the work of our 
resident scholars and Native American artists on our website at 
www.sarsf.org<http://www.sarsf.org>.

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migrating to new server and need help

[Doug Dearden]

Thanks Magnus, good hunch.  There were errors.  I restored my backup of 
koha-conf.xml and redid it.  The web installer is now running.

Regards,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Magnus Enger
Sent: Friday, November 4, 2016 1:14 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Migrating to new server and need help

On 3 November 2016 at 21:58, Doug Dearden  wrote:
> Hello all,
>
> I am migrating to a new server and upgrading Koha at the same time.  I 
> installed the latest stable release of Debian Jessie, and the latest version 
> of Koha using the packages.  Using koha-restore  I successfully 
> migrated two instances.  I did have to fix the koha-conf.xml files along with 
> the zebra config files to get things working right for dom indexing.  I am 
> getting errors when trying to install the third and final instance.  I 
> checked the edits in the config files, tried doing a koha-remove followed by 
> another koha-restore, and followed that up with koha-create-dirs just to make 
> sure I didn't miss anything.  I keep getting this error when I hit the staff 
> client:
> Software error:
> not well-formed (invalid token) at line 34, column 5, byte 1422 at 
> /usr/lib/x86_64-linux-gnu/perl5/5.20/XML/Parser.pm line 187.

Just a hunch, but could it be that an edit of koha-conf.xml went
wrong, and the XML is no longer well formed?

Maybe try something like this, to see if you get any errors:

$ sudo xmllint --format --noout /etc/koha/sites//koha-conf.xml

If that gives no output my hunch is wrong. :-)

Best regards,
Magnus Enger
Libriotech
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Change in behavior after upgrade

[Doug Dearden]

Hello all,

We recently upgraded from version 3.16.03.000 to 16.05.05.000 and I migrated to 
a new server at the same time.  We have three catalogs including one where we 
have scanned archival items.  The link to these items was then placed in the 
856$u field and the electronic format in the 856$q field.  Typically this looks 
like 856$u  /directory1/directory2/foo.jpg  |  856$q jpg .  Somewhere along the 
line on the old system, the librarian cataloging these images found that she 
could put in the path to the file in 856$u as just /directory1/directory2/foo 
and put the mime extension in 856$q and the image would appear when the link 
was clicked on.  The actual file on the server is foo.jpg and there is no file 
just named foo .  After our migration and upgrade, this no longer works as 
before.  Since the old machine is still running, I verified that this was the 
case and indeed, a link on the old one that says /directory1/directory2/foo 
opens the scanned image.  The url in the browser address windows says 
/directory1/directory2/foo .  If I change the url to 
/directory1/directory2/foo.jpg the image also appears .  On the new machine 
things changed.  /directory1/directory2/foo returns the error "Not Found The 
requested URL /directory1/directory1/foo was not found on this server".  
Changing the url to /directory1/directory2/foo.jpg fixes things and returns the 
image.

Did something change in Koha?  I am suspicious that this is an Apache or Linux 
thing, but am baffled why this even works on the old one without the complete 
file name.  I am thinking I need to write some SQL to append the 856$q text 
onto the 856$u to fix this, but if there is a config I need to change somewhere 
to get back to the old behavior that would be easiest.  I am open to any 
suggestions.

Thanks,

Doug Dearden, Director, IT
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504-2188
505-954-7220
www.sarweb.org<http://www.sarweb.org>
[http://sarweb.org/media/files/sar_email_logo.png]
Advancing innovative social science research and promoting Native American 
creativity.
Expand your understanding of the human experience at 
www.sarweb.org<http://www.sarweb.org>.

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Change in behavior after upgrade

[Doug Dearden]

Update: I am serving these images from the default apache server.  I compared 
my new 000-default.conf to my old one, and realized I had a lot of directives 
in the old that were not in the new.  I added them in and the new catalog is 
now behaving as the old one did.  So it's an apache configuration thing.  I 
don't have any rewriterule directives, so I am still not sure of the cause.  
Will dig further into the directives and see if I can figure it out.  Still 
open to suggestions.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Doug Dearden
Sent: Friday, November 11, 2016 3:14 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Change in behavior after upgrade

Hello all,

We recently upgraded from version 3.16.03.000 to 16.05.05.000 and I migrated to 
a new server at the same time.  We have three catalogs including one where we 
have scanned archival items.  The link to these items was then placed in the 
856$u field and the electronic format in the 856$q field.  Typically this looks 
like 856$u  /directory1/directory2/foo.jpg  |  856$q jpg .  Somewhere along the 
line on the old system, the librarian cataloging these images found that she 
could put in the path to the file in 856$u as just /directory1/directory2/foo 
and put the mime extension in 856$q and the image would appear when the link 
was clicked on.  The actual file on the server is foo.jpg and there is no file 
just named foo .  After our migration and upgrade, this no longer works as 
before.  Since the old machine is still running, I verified that this was the 
case and indeed, a link on the old one that says /directory1/directory2/foo 
opens the scanned image.  The url in the browser address windows says 
/directory1/directory2/foo .  If I change the url to 
/directory1/directory2/foo.jpg the image also appears .  On the new machine 
things changed.  /directory1/directory2/foo returns the error "Not Found The 
requested URL /directory1/directory1/foo was not found on this server".  
Changing the url to /directory1/directory2/foo.jpg fixes things and returns the 
image.

Did something change in Koha?  I am suspicious that this is an Apache or Linux 
thing, but am baffled why this even works on the old one without the complete 
file name.  I am thinking I need to write some SQL to append the 856$q text 
onto the 856$u to fix this, but if there is a config I need to change somewhere 
to get back to the old behavior that would be easiest.  I am open to any 
suggestions.

Thanks,

Doug Dearden, Director, IT
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504-2188
505-954-7220
www.sarweb.org<http://www.sarweb.org>
[http://sarweb.org/media/files/sar_email_logo.png]
Advancing innovative social science research and promoting Native American 
creativity.
Expand your understanding of the human experience at 
www.sarweb.org<http://www.sarweb.org>.

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Change in behavior after upgrade

[Doug Dearden]

I figured this out, just want to post in case anyone runs into this in the 
future and has the same problem.  The Apache directive controlling this is the 
Multiviews Option being declared on the Apache root directory, like this:

Options Indexes FollowSymlinks  Multiviews
AllowOverride None
Order allow,deny
allow from all

From the Apache web site:
"A Multiviews search is enabled by the Multiviews Options. If the server 
receives a request for /some/dir/foo and /some/dir/foo does not exist, then the 
server reads the directory looking for all files named foo.*, and effectively 
fakes up a type map which names all those files, assigning them the same media 
types and content-encodings it would have if the client had asked for one of 
them by name. It then chooses the best match to the client's requirements, and 
returns that document."

Doug

-Original Message-----
From: Doug Dearden 
Sent: Friday, November 11, 2016 4:45 PM
To: Doug Dearden ; koha@lists.katipo.co.nz
Subject: RE: Change in behavior after upgrade

Update: I am serving these images from the default apache server.  I compared 
my new 000-default.conf to my old one, and realized I had a lot of directives 
in the old that were not in the new.  I added them in and the new catalog is 
now behaving as the old one did.  So it's an apache configuration thing.  I 
don't have any rewriterule directives, so I am still not sure of the cause.  
Will dig further into the directives and see if I can figure it out.  Still 
open to suggestions.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Doug Dearden
Sent: Friday, November 11, 2016 3:14 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Change in behavior after upgrade

Hello all,

We recently upgraded from version 3.16.03.000 to 16.05.05.000 and I migrated to 
a new server at the same time.  We have three catalogs including one where we 
have scanned archival items.  The link to these items was then placed in the 
856$u field and the electronic format in the 856$q field.  Typically this looks 
like 856$u  /directory1/directory2/foo.jpg  |  856$q jpg .  Somewhere along the 
line on the old system, the librarian cataloging these images found that she 
could put in the path to the file in 856$u as just /directory1/directory2/foo 
and put the mime extension in 856$q and the image would appear when the link 
was clicked on.  The actual file on the server is foo.jpg and there is no file 
just named foo .  After our migration and upgrade, this no longer works as 
before.  Since the old machine is still running, I verified that this was the 
case and indeed, a link on the old one that says /directory1/directory2/foo 
opens the scanned image.  The url in the browser address windows says 
/directory1/directory2/foo .  If I change the url to 
/directory1/directory2/foo.jpg the image also appears .  On the new machine 
things changed.  /directory1/directory2/foo returns the error "Not Found The 
requested URL /directory1/directory1/foo was not found on this server".  
Changing the url to /directory1/directory2/foo.jpg fixes things and returns the 
image.

Did something change in Koha?  I am suspicious that this is an Apache or Linux 
thing, but am baffled why this even works on the old one without the complete 
file name.  I am thinking I need to write some SQL to append the 856$q text 
onto the 856$u to fix this, but if there is a config I need to change somewhere 
to get back to the old behavior that would be easiest.  I am open to any 
suggestions.

Thanks,

Doug Dearden, Director, IT
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504-2188
505-954-7220
www.sarweb.org<http://www.sarweb.org>
[http://sarweb.org/media/files/sar_email_logo.png]
Advancing innovative social science research and promoting Native American 
creativity.
Expand your understanding of the human experience at 
www.sarweb.org<http://www.sarweb.org>.

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[Doug Dearden]

Dan, I am confused also.  I thought we moved to the YY.xx.xx convention.  I'm 
not sure why we are still maintaining the 3.xx convention.  What am I missing?

Thanks,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Barton 
Chittenden
Sent: Wednesday, February 22, 2017 5:55 AM
To: Amit Gupta 
Cc: Koha-List 
Subject: Re: [Koha] Difference between 3.22 and 16.11

I think you'd want to look at the 16-11 release notes (posted by Amit
Gupta) as well as the 16.05 release notes:

https://koha-community.org/koha-16-05-released/

On Wed, Feb 22, 2017 at 3:44 AM, Amit Gupta  wrote:

> Hi Daniel,
>
> There are lot of new features in 16.11.x. Please see the below link
>
> Koha 3.22 release notes
>
> https://koha-community.org/koha-3-22-released/
>
> Koha 16.11 release  notes
>
> https://koha-community.org/koha-16-11-released-2/
>
>
> On 22 Feb 2017 11:43 am, "Walsh, Daniel (British Council)" <
> daniel.wal...@britishcouncil.org> wrote:
>
> Dear Colleagues,
>
> We are currently upgrading KOHA across our libraries.  Other than a change
> in naming convention, are there any technical differences between 3.22 and
> 16.11?
>
> Dan Walsh
>
>
>
> The British Council is the United Kingdom's international organisation for
> cultural relations and educational opportunities. A registered charity:
> 209131 (England and Wales) SC037733 (Scotland).
> This message is for the use of the intended recipient(s) only and may
> contain confidential information. If you have received this message in
> error, please notify the sender and delete it.
> The British Council accepts no liability for loss or damage caused by
> viruses and other malware and you are advised to carry out a virus and
> malware check on any attachments contained in this message.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difference between 3.22 and 16.11

[Doug Dearden]

Thanks Katrin, that clears it up.

Dan - your implied question of which version to go to in your update, sounds 
like it should be the latest 16.x.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Katrin
Sent: Wednesday, February 22, 2017 12:30 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Difference between 3.22 and 16.11

Hi Doug,

the last 3.xx version was 3.22, after that, we switched. So after 3.22 
was 16.05, then 16.11. We currently actively maintain the last 3 
versions, so 3.22 - 16.05. In May, when 17.05 is released, it's like 
that 3.22 will see its 'end of life'.

Hope that clears it up,

Katrin

On 22.02.2017 19:56, Doug Dearden wrote:
> Dan, I am confused also.  I thought we moved to the YY.xx.xx convention.  I'm 
> not sure why we are still maintaining the 3.xx convention.  What am I missing?
>
> Thanks,
>
> Doug
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Barton 
> Chittenden
> Sent: Wednesday, February 22, 2017 5:55 AM
> To: Amit Gupta 
> Cc: Koha-List 
> Subject: Re: [Koha] Difference between 3.22 and 16.11
>
> I think you'd want to look at the 16-11 release notes (posted by Amit
> Gupta) as well as the 16.05 release notes:
>
> https://koha-community.org/koha-16-05-released/
>
> On Wed, Feb 22, 2017 at 3:44 AM, Amit Gupta  wrote:
>
>> Hi Daniel,
>>
>> There are lot of new features in 16.11.x. Please see the below link
>>
>> Koha 3.22 release notes
>>
>> https://koha-community.org/koha-3-22-released/
>>
>> Koha 16.11 release  notes
>>
>> https://koha-community.org/koha-16-11-released-2/
>>
>>
>> On 22 Feb 2017 11:43 am, "Walsh, Daniel (British Council)" <
>> daniel.wal...@britishcouncil.org> wrote:
>>
>> Dear Colleagues,
>>
>> We are currently upgrading KOHA across our libraries.  Other than a change
>> in naming convention, are there any technical differences between 3.22 and
>> 16.11?
>>
>> Dan Walsh
>>
>>
>>
>> The British Council is the United Kingdom's international organisation for
>> cultural relations and educational opportunities. A registered charity:
>> 209131 (England and Wales) SC037733 (Scotland).
>> This message is for the use of the intended recipient(s) only and may
>> contain confidential information. If you have received this message in
>> error, please notify the sender and delete it.
>> The British Council accepts no liability for loss or damage caused by
>> viruses and other malware and you are advised to carry out a virus and
>> malware check on any attachments contained in this message.
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Routing with a FQDN

[Doug Dearden]

Hi Dave,

It sounds to me like you are trying to do this through a single public IP 
address.  We do this by paying for a range of IP addresses, then use a mapped 
IP function in our firewall to map incoming requests from an external address 
to an internal address.  It is similar to the virtual host idea, but not 
sharing an IP address and therefore the port can be 80.

I think you will have better luck figuring this out by going to Cyberoam 
support.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Contact 
Orielstar
Sent: Tuesday, March 21, 2017 8:48 AM
To: Koha@lists.katipo.co.nz
Subject: [Koha] Routing with a FQDN

Hi Folks,

Are there any networking guru's out there than can help us with routing, 
please? We have Koha installed in a school running a cyberoam (which is 
basically a big router). We have a domain (.peterhouse.co.zw), and we 
would like users on the WAN (Internet) to be able to access Koha from 
home by using *koha.peterhouse.co.zw*, and not have to add a colon and a 
port number. So how can we set this up so that instead of just mapping 
the koha bit to an ip address, we map it to the ip address:81?

We have tried setting up a virtual host on the cyberoam, but it's not 
working as it says port 80 (external) is already mapped. Well, all 
requests from the internet are going to come on port 80, so the mail 
server is mapped to this as well. So we've missed something very 
fundamental if they type mail.peterhouse.co.zw then the request 
should go to 10.10.10.5. If they type koha.peterhouse.co.zw then the 
request should go to 10.10.10.6*:81*. I can't see any way on our 
cyberoam to map an address to an ip/port, just to an ip only.

Any ideas you have would be most welcome. Even if you haven't got a 
cyberoam, how have you all done external routing on your installations?

Thanks for your help, and regards,
-- 

Dave Jury



rielstar
Business Solutions



Marondera Branch:
10A Tipperary
Marondera
Phone 0773 247 121

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Request for Information - reg...

[Doug Dearden]

Send any questions to the email list.  
koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> .

From: Paramasivam J [mailto:jparamasi...@ymail.com]
Sent: Thursday, July 20, 2017 3:12 AM
To: Doug Dearden 
Subject: Re: [Koha] Request for Information - reg...

Dear Sir,

Thanking you for your kind information

Koha  Ver. 3.20.03  is used by our office  Technical Information Centre (TIC) - 
Library.

We are facing bugs  related to Check-Check out

Error Message is appearing " SOFTWARE ERROR"

Please suggest me sir.

Regards

J Paramasivam
TIC, CABS, DRDO, Bangalore - 560 037


On Monday, 17 July 2017 10:54 PM, Doug Dearden 
mailto:dear...@sarsf.org>> wrote:

No officially authorized vendors, but look here: 
https://koha-community.org/support/paid-support/country/

-Original Message-
From: Koha 
[mailto:koha-boun...@lists.katipo.co.nz<mailto:koha-boun...@lists.katipo.co.nz>]
 On Behalf Of Paramasivam J
Sent: Saturday, July 15, 2017 3:39 AM
To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>
Subject: [Koha] Request for Information - reg...

Dear Sir,
Any authorised vendor for Installation & Maintenance for KOHA in India.
Please suggest me sir.
Regards
J ParamasivamCABS, DRDO

___
Koha mailing list  http://koha-community.org<http://koha-community.org/>
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

[Doug Dearden]

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-boun...@lists.katipo.co.nz] On Behalf Of C.J.S. Hayward
Sent: Tuesday, July 25, 2017 11:18 AM
To: koha@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  - email
 - website .
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SMS providers for Koha

[Doug Dearden]

This page might be what you are looking for: 
https://martinfitzpatrick.name/list-of-email-to-sms-gateways/ 

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Ashok Francis
Sent: Monday, August 14, 2017 6:40 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] SMS providers for Koha

Dear All,

I am looking for SMS providers in India for koha software. Can you please
help me to find koha supportable sms provider?

Any suggestion will be greatly appreciated. Thank you.
Ashok Francis
Librarian,
New Delhi
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Just did an update and have some questions

[Doug Dearden]

Hello all,

I just updated to the current stable release 17.05.02 running on Debian version 
3.16.36-1+deb8u2 (2016-10-19) x86_64 and I have some questions:
It looks like the fix for the DBMS auto increment problem is included in this 
release.  Do I still need to implement the solution from 
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix ?
I have 2 duplicates in one of my DB instances.  If I fix those are there any 
concerns going forward?
On the Perl Modules tab there are four modules reading Not Installed -  
HTTPD::BENCH::ApacheBench, Readonly::XS, Test::DBIx::Class, WebService::ILS .  
Are these modules needed on a non-dev install?  If so, why didn't they install 
with the koha-common package?  Do I need to install them via CPAN?

Thanks,

Doug Dearden, Director, IT
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504-2188
505-954-7220
[http://sarweb.org/media/files/sar_tag.png]<http://www.sarweb.org/>

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha supportable SMS providers in India

[Doug Dearden]

I am pasting an email announcement from Indranil Das Gupta below from last 
February.  Maybe this helps.

Dear all,

I'm happy to announce that the open source (Free Software) driver for
sending SMSes using the eSMS Kerala service has been released by L2C2
Technologies. The development cost was sponsored by State Librarian,
State Central Library, Thiruvananthapuram, Kerala and facilitated by
KELTRON (Govt of Kerala). Thanks also to individuals who worked behind
the scene to make this piece of FOSS possible. This is the second
India specific open source SMS Send driver released on CPAN.

The driver can be downloaded from
http://search.cpan.org/~indradg/SMS-Send-IN-eSMS-0.01/lib/SMS/Send/IN/eSMS.pm
as well as here https://github.com/l2c2technologies/sms-send-in-esms

More on the blogpost -
http://blog.l2c2.co.in/index.php/2017/02/09/opensource-sms-driver-released-kerala/

regards

Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW  : http://www.l2c2.co.in
Blog: http://blog.l2c2.co.in
IRC : indradg on irc://irc.freenode.net
Twitter : indradg

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Ashok Francis
Sent: Tuesday, August 29, 2017 3:51 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Koha supportable SMS providers in India

Dear All,

I am looking for Koha supportable SMS providers in India. Is it possible to
use SMS feature in Koha? If it is possible, Which SMS providers are best
for KOHA in India? Can anyone please suggest me?
I will be thankful to you.

Kind Regards,
W. Ashok Francis
Librarian
New Delhi.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] [Important] Update your MySQL|MariaDB configuration to avoid data loss

[Doug Dearden]

Hello list,

I have upgraded to 17.05.02 and taken care of two duplicate IDs on one of my 
instances.  Do I still need to make the changes to the /etc/myscl/my.cnf file?  
Or did the fix in 17.05.02 make that unnecessary?

Thanks,

Doug

From: koha-devel-boun...@lists.koha-community.org 
[mailto:koha-devel-boun...@lists.koha-community.org] On Behalf Of Jonathan 
Druart
Sent: Tuesday, August 1, 2017 7:23 AM
To: koha@lists.katipo.co.nz; koha-de...@lists.koha-community.org
Subject: [Koha-devel] [Important] Update your MySQL|MariaDB configuration to 
avoid data loss

Hello everybody,

This is an important email and you should not ignore it.
If you are a librarian and have no technical skills you should forward this 
email to the administrator of your Koha installation.

We have been dealing with circulation history loss in the last versions of 
Koha, and we ended up with a solution.
You should read the following wiki page attentively and set up the proposed 
solution: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix

Cheers,
Jonathan
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] I am missing some Perl modules

[Doug Dearden]

Hello list,

I just updated again to the latest release, 17.05.03.000 running on Jessie 
(Debian 3.16.36-1+deb8u2 (2016-10-19) x86_64).  I also ran apt-get install 
koha-perldeps to see if these missing modules would get installed but they are 
showing as Not Installed.  They are the following:
HTTPD::BENCH::ApacheBench
Readonly::XS
Test::DBIx::Class
WebService::ILS.

Do I need these on a non-dev install?

Are they missing from the packages and I need to file a bug report?

Thanks,

Doug Dearden, Director, IT
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504-2188
505-954-7220
[http://sarweb.org/media/files/sar_tag.png]<http://www.sarweb.org/>

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Just did an update and have some questions

[Doug Dearden]

Hi Jonathan,

Thanks for responding.  I thought maybe I asked too many questions in one post 
so decided to break them up.  I will be more patient in the future. ☺

When I execute perl koha_perl_deps.pl –a   it returns  Can’t open perl script 
“koha_perl_deps.pl”: No such file or directory .  I’m not sure why this is the 
case.  I have been using Koha since version 3.4.  My current install was 
originally done when I moved to new hardware.  I installed Debian Jessie and 
Koha 16.50.00 .  I moved the database from the old hardware and let things 
update.  All of that worked automatically.  I think these Perl Modules were 
probably missing then but I didn’t address it.  I recently upgraded because of 
the auto increment problem and decided to address the missing modules and other 
warnings highlighted on the About pages.

Thinking about a bug report I checked Bugzilla, and found some bugs relating to 
this that make me think it is by design that some of these are not included in 
the packaging.  https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16588 
is named “Remove the Readonly dependency (again)”.

Test::DBIx::Class is apparently not packaged in Debian - 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18851

We don’t use OverDrive so not having WebService::ILS installed is probably 
unimportant.

I’m not sure where the test suite is used.  Is this something needed on a 
regular production database, or only on a dev install?  In any case 
HTTPD::BENCH::ApacheBench didn’t get installed during the update or when I 
installed koha-perldeps .  Again maybe by design.

Everything is running OK so perhaps none of these missing Perl modules are 
important.

Thanks,

Doug

From: Jonathan Druart [mailto:jonathan.dru...@bugs.koha-community.org]
Sent: Thursday, August 31, 2017 12:45 PM
To: Doug Dearden ; koha@lists.katipo.co.nz
Subject: Re: [Koha] Just did an update and have some questions

Hi Doug,

Please wait a few days before reposting :)

The fix is for all Koha versions, yes.

The required module are listed as... 'required' when you execute `perl 
koha_perl_deps.pl<http://koha_perl_deps.pl> -a`

HTTPD::BENCH::ApacheBench and Test::DBIx::Class are for the test suite
WebService::ILS is for OverDrive
and Readonly::XS is an xs module for Readonly

With `apt show koha-common`, I see libreadonly-perl and libreadonly-xs-perl in 
the dependency list.

Regards,
Jonathan
On Mon, 28 Aug 2017 at 18:31 Doug Dearden 
mailto:dear...@sarsf.org>> wrote:
Hello all,

I just updated to the current stable release 17.05.02 running on Debian version 
3.16.36-1+deb8u2 (2016-10-19) x86_64 and I have some questions:
It looks like the fix for the DBMS auto increment problem is included in this 
release.  Do I still need to implement the solution from 
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix ?
I have 2 duplicates in one of my DB instances.  If I fix those are there any 
concerns going forward?
On the Perl Modules tab there are four modules reading Not Installed -  
HTTPD::BENCH::ApacheBench, Readonly::XS, Test::DBIx::Class, WebService::ILS .  
Are these modules needed on a non-dev install?  If so, why didn't they install 
with the koha-common package?  Do I need to install them via CPAN?

Thanks,

Doug Dearden, Director, IT
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504-2188
505-954-7220
[http://sarweb.org/media/files/sar_tag.png]<http://www.sarweb.org/>

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 16.11.04 - Setting a template cache directory

[Doug Dearden]

Hi Prof,

Here is what I did.  I have multiple instances/sites running, if you have more 
than one instance do this for each one.
Login to a terminal session on your server as a regular user (koha, not root)
cd /etc/koha/sites/(instance name)
sudo nano koha-conf.xml   This brings up the editor nano and loads the 
koha-conf.xml file into it.  Use a different editor if you are more familiar 
with it.  Scroll down to the bottom of the file.  Near the bottom you should 
see the tag .  Add a line right above that that reads:
/tmp/yourinstancename 
replacing yourinstancename with the instance/site name.  Save the file (in 
nano, Ctrl-o then Ctrl-x to exit).  Repeat for each instance/site you have.
Using your browser go to the staff interface for the site in question.  Reload 
the About page.  The warning should be gone.  Check the OPAC also.
If things don't load normally or you get an error, go back and check your 
spelling.  A typo will break things. ;)
Back in your terminal session
cd /tmp
ls -all
You should see your instance names listed.  When you are happy that all is well:
exit

Best,

Doug Dearden, Director, IT
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504-2188
505-954-7220
www.sarweb.org 


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Prof. Lisandro 
Laura
Sent: Saturday, August 26, 2017 8:06 AM
To: Petter Goksøyr Åsen 
Cc: koha 
Subject: Re: [Koha] Koha 16.11.04 - Setting a template cache directory

Hello!
Could anyone please point me to a simple step by step instruction to
set  entry in my koha-conf.xml file?
Thank you in advance...

2017-03-03 4:12 GMT-03:00 Petter Goksøyr Åsen
:
> I would choose a path that's not on a spinning disc at least. Depending on 
> your OS setup, /tmp is
> often mounted to RAM, so that's what I would use.
>
> Petter Goksøyr Åsen
> Deichmanske bibliotek / Oslo Public Library
> 
> Fra: Koha [koha-boun...@lists.katipo.co.nz] på vegne av Mark Alexander 
> [ma...@pobox.com]
> Sendt: 2. mars 2017 21:53
> Til: Craig Butosi
> Kopi: koha
> Emne: Re: [Koha] Koha 16.11.04 - Setting a template cache directory
>
> Excerpts from Craig Butosi's message of 2017-03-02 13:42:07 +:
>> >You are missing the  entry in your koha-conf.xml file. 
>> >That will bring a performance boost to >enable it.
>>
>> Is there an expected, standard, or best directory path to use? The error is 
>> clear enough; however, I'd like to define the directory with an appropriate 
>> path.
>
> In this bug comment:
>
>   https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17951#c2
>
> it was suggested that we use /var/cache/koha//templates,
> so that was what I used, and it seems to work fine.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] DBMS auto increment fix

[Doug Dearden]

Hi Sitali,

In MariaDB the configuration files have been broken up.  I believe you will 
find the [mysqld] section in /etc/mysql/mariadb.conf.d/50-server.cnf .

Best,

Doug

Doug Dearden, Director, IT
School for Advanced Research
PO Box 2188
Santa Fe, NM 87504-2188
http://sarweb.org

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Chrispin 
Simasiku Sitali
Sent: Tuesday, September 26, 2017 8:23 AM
To: koha-user ; jonathan.dru...@bugs.koha-community.org
Subject: [Koha] DBMS auto increment fix

Greetings all,

I am trying to fix errors related to DBMS auto increment fix using:
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix

but when I come to

#Edit /etc/mysql/my.cnf
#Locate the [mysqld] section and add:

There is no [mysqld] section in this file

I am running Koha 17.05.04.000 on Ubuntu 16.04 LTS using mysql Ver 15.1
Distrib 10.0.31-MariaDB, for debian-linux-gnu (i686) using readline 5.2

Please any pointers as to where the /etc/mysql/my.cnf might be located that
has [mysqld] section in it.

I thank you in advance

Sitali CS


-- 
Charles Lwanga College of Education,
P. O. Box 660193,
Monze,
ZAMBIA.

Mobile: +26 0979 869471
+26 0966 869471
SKYPE: Libsitali
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] KOHA CMS

[Doug Dearden]

Hi Hughes,

This is a guess - check the owner and group assigned to the pages.pl file.  It 
should be the same as the opac-main.pl .  If not change it using chown and 
chgrp .

Best,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of hughes dimka
Sent: Wednesday, November 8, 2017 4:43 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] KOHA CMS

Hello All,

I have been trying for the past few days on trying to set-up a cms for a
small library here in Nigeria and i have used the following guide

https://wiki.koha-community.org/wiki/Koha_as_a_CMS
https://koha-community.org/manual/17.05/html/18_miscellaneous.html#using-koha-as-a-content-management-system-cms

I installed koha 17.05 on ubuntu, and after following the guide and i check
the page with  http://localhost/pages.pl?p=test , i keep getting "The
requested URL /pages.pl was not found on this server" i have given
read,execute and write permission, but still yet i keep getting erros

Any help, would be highly appreciative.

-- 
Hughes Dimka
Hopewell Solutions Services Nigeria Ltd
No.15 Adekunle Kuye Street, Off Agbonyin Street, Off Adelabu Street,
Surulere,Lagos State
Nigeria
tel: +2348066951910
email: hdi...@gmail.com


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to snapshot / restore a Koha Database?

[Doug Dearden]

Hi Chris,

I am thinking this works if you do koha-dump / koha-restore.  I think when you 
do the koha-remove that is when you lose your apache configs and some other 
stuff.  You would need a koha-create to put all those in place, then 
koha-restore.  Leave koha-remove out of the sequence and you don't need 
koha-create, everything will be there and a koha-restore puts the database back 
to where it was when you did koha-dump.

That's just off the top of my head.  I didn't test it.

Best,

Doug Dearden

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Chris Brown
Sent: Thursday, February 8, 2018 8:53 AM
To: koha 
Subject: [Koha] How to snapshot / restore a Koha Database?

Gentle Reader,

I need to deliver multiple Koha training sessions for several groups of
volunteers who work on our front desk. I'll be setting a specific series of
tasks and it will be much easier if I can "reset" the database to a
previous checkpoint before each session so we can re-run the same tasks.

So ... I've tried the sequence koha-dump / koha-remove / koha-restore; I
got a list of "File exists" errors when I did the koha-restore (mostly in
/var/lib/koha/stand, where "stand" is my instance name). These didn't
trouble me too much but I then had to fix a missing
/etc/apache2/sites-enabled/stand.conf and a missing /var/log/koha/stand
directory before apache would start up.

Now, when I try to log in I get a perl error about an unblessed reference
in /usr/share/koha/lib/Koha/Database.pm (line 56). This is getting too deep
into the code for me to have much hope of debugging it, so before I spend
more time on this (or give up entirely) does anyone have any advice on the
right command sequence (with the right options) that I can use to achieve
this in a clean, pain-free way?

Thanks and Best Regards,

Chris Brown
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Plugin Error

[Doug Dearden]

Hi Satish,

What user does Apache run under?  On my Debian system the default is www-data.  
If that is the case on your Ubuntu system then I would do:
su chgrp www-data plugins
su chmod 775 plugins

I think that addresses the indicated problem.

Best,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of SATISH
Sent: Tuesday, June 12, 2018 12:43 PM
To: Koha 
Subject: [Koha] Plugin Error

Hi,

With Koha 17.11.06.000 On L-Ubuntu 16,04 Desktop from package installation
method,

I am getting follwoing error while uploading .kpz file at  Home › Tools ›
Plugins.


*Cannot unpack file to the plugins directory.Please verify that the Apache
user can write to the plugins directory.*

What is the right permission ??
.
As a root user, I have created plugins directory

drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48 gechlibrary
drwxr-xr-x 2 root root 4096 Jun 12 17:28 plugins

I tried to change,
chown -R gechlibrary-koha:gechlibrary-koha /var/lib/koha/plugins/

drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun  8 22:48 gechlibrary
drwxr-xr-x 2 gechlibrary-koha gechlibrary-koha 4096 Jun 12 17:28 plugins


Alias /plugin/ "/var/lib/koha/plugins/" is updated in
/etc/apache2/sites-available/gechlibrary.conf

In both cases, I am not able to to perform upload plugin.

Please help.

Satish MV
Librarian
Govt. Engineering College, Hassan
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Enabling https only using SSL

[Doug Dearden]

Hey Nirvana,

I think you are looking for something like this, substituting a valid 
domainname in the right places.

Doug


# OPAC
 
Include /etc/koha/apache-shared.conf
 #  Include /etc/koha/apache-shared-disable.conf
Include /etc/koha/apache-shared-opac.conf

ServerName ssb
Redirect permanent "/" "https://yourdomainname";  #* This redirects 
from http to https *
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


  #* This checks for ssl module on Debian *
 # OPAC
  #* Note port 443 here *
Include /etc/koha/apache-shared.conf
 #  Include /etc/koha/apache-shared-disable.conf
Include /etc/koha/apache-shared-opac.conf

ServerName ssb
ServerAlias yourdomainname   #*  same as above *
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
 


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of TechOut 
Solutions
Sent: Sunday, May 12, 2019 11:39 AM
To: Joel Coehoorn 
Cc: Koha General Mailing-List 
Subject: Re: [Koha] Enabling https only using SSL

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-site-https.conf.in
?

On Sun, May 12, 2019 at 7:26 PM Coehoorn, Joel  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 <
> techoutsolution...@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
>> 
>>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
>> 
>>
>> 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!
>>
>

Re: [Koha] [EXTERNAL] Re: Order of display of 246 $i and $a fields

[Doug Dearden]

Heather, I just have one question.
Was there any pearl clutching necessary during this adventure?

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Hernandez, 
Heather
Sent: Friday, June 14, 2019 10:04 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] [EXTERNAL] Re: Order of display of 246 $i and $a fields

Hi!

The Koha community always makes me smile!!  And it's lovely to think that I
might be helping improve things, even through one small thing.

>...it's a slippery slope to your first code submission next 😉.

::hee!::  I may have been working on trying to convince my employer to let
me learn how to code...and North Coast Brewing's Old Rasputin imperial
stout may also be a lovely way to celebrate creating a new bug report!

Have a good weekend, all!  Cheerio!
h2
~~
Heather Hernandez (she, her, hers)
Technical Services Librarian
San Francisco Maritime National Historical Park Research Center
2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
415-561-7032, heather_hernan...@nps.gov
Library catalog: http://keys.bywatersolutions.com/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Suddenly can't check in items

[Doug Dearden]

Hey Drojup,

Look in /etc/mysql/mysql.conf.d 
You should find several files in there that end in .cnf, one of which will be 
server.cnf .  It might have a number or other characters before the server.cnf. 
 I am using mariadb instead of mysql, and mine says 50-server.cnf .  Check that 
file, I believe you will find the mysqld section in there. 

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of drojup
Sent: Wednesday, July 24, 2019 3:28 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Suddenly can't check in items

These are the contentes of the file: /etc/mysql/my.cnf

# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

I can't locate the [mysqld] section




--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] -intra.mydomain

[Doug Dearden]

Hey Victor,

I believe what you want is Name-based Virtual Host.  See the Apache article 
here: https://httpd.apache.org/docs/2.4/vhosts/name-based.html .

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Victor Barroso 
Oliveira
Sent: Wednesday, September 25, 2019 12:07 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] -intra.mydomain

Good afternoon,
I configured the koha admin interface to access on port 8080 but would like
to access the admin interface with one from biblio-intra.mydomain
How should I do this?
Thanks,
Victor
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Trying to figure out if I have Plack running right

[Doug Dearden]

Hey Everyone,

Our librarian has asked me to look into slowness when getting a response for 
patron lookups.  With a little investigation, it looked like Plack was supposed 
to help with that.  I thought I had it running but when I check the About page 
on the Bywater demos there is a line that says "PSGI: Plack (deployment)" that 
does not appear on my About page.  Here is my About info:

Koha version:
19.05.01.000
OS version ('uname -a'):
Linux SAR144Linux 4.9.0-8-amd64 #1 SMP Debian 4.9.144-3.1 (2019-02-19) x86_64
Perl interpreter:
/usr/bin/perl
Perl version:
5.024001
Perl @INC:
/usr/share/koha/lib
/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
MySQL version:
mysql Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu (x86_64) using 
readline 5.2
Apache version:
Server version: Apache/2.4.25 (Debian)
Memcached:
Servers: localhost:11211 | Namespace: kohamain | Status: running. | Config read 
from: koha-conf.xml
Zebra version:
Zebra 2.0.59 (C) 1994-2014, Index Data 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: 
c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU
Date and time:
11/05/2019 15:02
Time zone:
Used: America/Denver | Config: Undefined | Environment (TZ): Undefined

I noticed that my Apache version is 2.4.25 which I figured was fine, but I did 
notice a reference in the Wiki I believe to version 2.4.10, and that is what is 
running on the Bywater demo.  I thought since I was running a more recent 
version that I would be OK, but perhaps not.

When I run "sudo koha-plack --start "  I get back:
[FAIL] Error: Plack already running for : failed!

So it looks like Plack is running.

I did go back and restart things, doing:
sudo koha-plack -stop 
sudo koha-plack -start 
sudo service apache2 restart

Same result.

Hopefully I have missed something obvious.  Any help is appreciated.

Thanks,

Doug Dearden
Director / Information Technology
School for Advanced Research (SAR)
PO Box 2188 / Santa Fe / NM / 87504-2188
505.954.7220 / www.sarweb.org<http://www.sarweb.org/>

EXPLORING HUMANITY. UNDERSTANDING OUR WORLD.

Receive the SAR monthly E-News: SIGN UP HERE 
<https://sarweb.org/about/e-news-signup/>

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Trying to figure out if I have Plack running right

[Doug Dearden]

Hey Michael,

OK, this is weird.
(Instance is named main)

koha@SAR144Linux:~$ sudo koha-plack --enable main
Plack not enabled for main OPAC
Plack not enabled for main Intranet
koha@SAR144Linux:~$ sudo koha-plack --disable main
Plack already disabled for main OPAC
Plack already disabled for main Intranet
koha@SAR144Linux:~$ sudo koha-plack --enable main
Plack not enabled for main OPAC
Plack not enabled for main Intranet
koha@SAR144Linux:~$ sudo koha-plack --start main
[FAIL] Error: Plack already running for main: failed!

If it is disabled, and refuses to enable, how can it already be running?

H.

Doug


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Michael Kuhn
Sent: Tuesday, November 5, 2019 3:39 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Trying to figure out if I have Plack running right

Hi Doug

 > When I run "sudo koha-plack --start "  I get back:
 > [FAIL] Error: Plack already running for : failed!
 >
 > So it looks like Plack is running.
 >
 > I did go back and restart things, doing:
 > sudo koha-plack -stop 
 > sudo koha-plack -start 
 > sudo service apache2 restart

I'm not sure what commands you really executed, but if your Koha 
instance is called "abc" (for example) the commands would be:

1. First enable Plack:

sudo koha-plack --enable abc

2. Only then you can start Plack:

sudo koha-plack -start abc

See also: 
https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#Plack-related

Hope this helps.

Best wishes: Michael
-- 
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Trying to figure out if I have Plack running right

[Doug Dearden]

Hey Jonathan,

That command returns this:
   Include /etc/koha/apache-shared.conf
#  Include /etc/koha/apache-shared-disable.conf
   Include /etc/koha/apache-shared-opac.conf
#  Include /etc/koha/apache-shared.conf
#  Include /etc/koha/apache-shared-disable.conf
#  Include /etc/koha/apache-shared-intranet.conf

I have two other conf files that I ran this against, so:

koha@SAR144Linux:/$ sudo grep Include 
/etc/apache2/sites-available/mainintra.conf
   Include /etc/koha/apache-shared.conf
#  Include /etc/koha/apache-shared-disable.conf
   Include /etc/koha/apache-shared-intranet.conf

koha@SAR144Linux:/$ sudo grep Include 
/etc/apache2/sites-available/main-le-ssl.conf
   Include /etc/koha/apache-shared.conf
#  Include /etc/koha/apache-shared-disable.conf
   Include /etc/koha/apache-shared-opac.conf
#Include /etc/letsencrypt/options-ssl-apache.conf
#   Include /etc/koha/apache-shared.conf
#   Include /etc/koha/apache-shared-disable.conf
#   Include /etc/koha/apache-shared-intranet.conf
koha@SAR144Linux:/$

main.conf listens on port 80, and redirects / to port 443 so all connections 
are encrypted
main-le-ssl.conf listens on port 443, opac only .  This is the public facing 
OPAC at https://library.sarsf.org
mainintra.conf listens on port 8080, only available on the internal network

Thanks,

Doug

-Original Message-
From: Jonathan Druart [mailto:jonathan.dru...@bugs.koha-community.org] 
Sent: Wednesday, November 6, 2019 1:48 AM
To: Doug Dearden 
Cc: m...@adminkuhn.ch; koha@lists.katipo.co.nz
Subject: Re: [Koha] Trying to figure out if I have Plack running right

Hi Doug,

The koha-plack --enable command did not work.
Can you post the result of the following command:
  $ sudo grep Include /etc/apache2/sites-available/main.conf

Regards,
Jonathan

Le mer. 6 nov. 2019 à 01:00, Doug Dearden  a écrit :
>
> Hey Michael,
>
> OK, this is weird.
> (Instance is named main)
>
> koha@SAR144Linux:~$ sudo koha-plack --enable main
> Plack not enabled for main OPAC
> Plack not enabled for main Intranet
> koha@SAR144Linux:~$ sudo koha-plack --disable main
> Plack already disabled for main OPAC
> Plack already disabled for main Intranet
> koha@SAR144Linux:~$ sudo koha-plack --enable main
> Plack not enabled for main OPAC
> Plack not enabled for main Intranet
> koha@SAR144Linux:~$ sudo koha-plack --start main
> [FAIL] Error: Plack already running for main: failed!
>
> If it is disabled, and refuses to enable, how can it already be running?
>
> H.
>
> Doug
>
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Michael Kuhn
> Sent: Tuesday, November 5, 2019 3:39 PM
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Trying to figure out if I have Plack running right
>
> Hi Doug
>
>  > When I run "sudo koha-plack --start "  I get back:
>  > [FAIL] Error: Plack already running for : failed!
>  >
>  > So it looks like Plack is running.
>  >
>  > I did go back and restart things, doing:
>  > sudo koha-plack -stop 
>  > sudo koha-plack -start 
>  > sudo service apache2 restart
>
> I'm not sure what commands you really executed, but if your Koha
> instance is called "abc" (for example) the commands would be:
>
> 1. First enable Plack:
>
> sudo koha-plack --enable abc
>
> 2. Only then you can start Plack:
>
> sudo koha-plack -start abc
>
> See also:
> https://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#Plack-related
>
> Hope this helps.
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Trying to figure out if I have Plack running right

[Doug Dearden]

Hey Tomas,

Good tip.  I did as you suggested, and there were a number of additional lines 
in the  section of the koha-conf.xml file, including a couple of lines 
about the plack config.  I modified the config section of my main koha-conf.xml 
to match, changing the file paths and other references where appropriate.  I 
also took my three apache conf files and combined them into one with the three 
virtual host definitions in one file.  Plack enabled, started, and is showing 
on the About page.  The response time to look up a patron (which is what 
started this in the first place) seems much faster, a second or two compared to 
eight to ten seconds before.  I still need feedback from our librarian but I 
think everything is running as it should.

Thank you Tomas, Jonathan and Michael.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Tomas Cohen 
Arazi
Sent: Wednesday, November 6, 2019 7:26 PM
To: koha 
Subject: Re: [Koha] Trying to figure out if I have Plack running right

I recommend that you create an instance xxx and pick the generated xxx.conf
Apache config, and use it as a basis for rewriting your instance's files.

Looking forward to hear about the results!

El mié., 6 de noviembre de 2019 21:02, Doug Dearden 
escribió:

> Hey Tomas,
>
>
>
> I did install using packages, but here’s what happened.  I had Koha
> running on a server, and the version running was a couple of years old.
> Our librarian asked me to upgrade to 19.05 and I did that.  Right after
> upgrading the server hardware failed.  I had another linux server running a
> couple of Apache sites unrelated to Koha.  I set the apt sources for Koha
> stable main and installed Koha using the packages.  I then restored using
> the database backups.  It’s been a few months so I don’t remember the order
> of things but I got the schema updated and everything working on version
> 19.05.01.  I think I copied the backed up versions of the various apache
> conf files, which may be where things went wrong.   I do see
> /etc/koha/apache-shared-opac-plack.conf and
> /etc/koha/apache-shared-intranet-plack.conf on the disk.
>
>
>
> I have now added the Include directives to the appropriate conf files.
> Still something wrong though.  BTW I have another instance named archive.
> Plack seems to be working now on that instance, but still has problems on
> main intranet.
>
>
>
> koha@SAR144Linux:~$ sudo grep Include
> /etc/apache2/sites-available/main.conf
>
>Include /etc/koha/apache-shared.conf
>
> #  Include /etc/koha/apache-shared-disable.conf
>
>   Include /etc/koha/apache-shared-opac.conf
>
> #   Include /etc/koha/apache-shared-opac-plack.conf  * I added this
> twice but it kept getting commented out.  I think because it is in the SSL
> config*
>
> #  Include /etc/koha/apache-shared.conf
>
> #  Include /etc/koha/apache-shared-disable.conf
>
> #  Include /etc/koha/apache-shared-intranet.conf
>
> koha@SAR144Linux:~$ sudo grep Include
> /etc/apache2/sites-available/main-le-ssl.conf
>
>Include /etc/koha/apache-shared.conf
>
> #  Include /etc/koha/apache-shared-disable.conf
>
>   Include /etc/koha/apache-shared-opac.conf
>
>Include /etc/koha/apache-shared-opac-plack.conf
>
> #Include /etc/letsencrypt/options-ssl-apache.conf
>
> #   Include /etc/koha/apache-shared.conf
>
> #   Include /etc/koha/apache-shared-disable.conf
>
> #   Include /etc/koha/apache-shared-intranet.conf
>
> koha@SAR144Linux:~$ sudo grep Include
> /etc/apache2/sites-available/mainintra.conf
>
>Include /etc/koha/apache-shared.conf
>
> #  Include /etc/koha/apache-shared-disable.conf
>
>Include /etc/koha/apache-shared-intranet.conf
>
>Include /etc/koha/apache-shared-intranet-plack.conf
>
> koha@SAR144Linux:~$ sudo koha-plack --enable main
>
> Plack enabled for main OPAC
>
> Plack not enabled for main
> Intranet*HMMM.  Not fixed
> yet*
>
> koha@SAR144Linux:~$ sudo koha-plack --enable archive
>
> Plack already enabled for archive OPAC
>
> Plack already enabled for archive Intranet
>
> koha@SAR144Linux:~$ sudo koha-plack --start archive
>
> [FAIL] Error: Plack already running for archive: failed!
>
> koha@SAR144Linux:~$ sudo koha-plack --start main
>
> [ ok ] Starting Plack daemon for main:.
>
> koha@SAR144Linux:~$ sudo koha-plack --stop main
>
> [ ok ] Stopping Plack daemon for main:.
>
> koha@SAR144Linux:~$ sudo koha-plack --disable main
>
> Plack disabled for main OPAC
>
> Plack already disabled for main Intranet
>
> main had a plack configuration error. Please confirm it is corrected.
>
>
>
> OK, that last line indicates somet

Re: [Koha] Problem with patron cards - no barcode or image

[Doug Dearden]

Hey Rick,

I don't have a solution to your patron card issue, but I think I can help you 
show your settings.  The way people have done it before on this list is to save 
the screenshot images on a cloud server, then put the link in the email you 
send to the list.  You will find many free options by searching for "free site 
to post screenshots" or something similar.

Best,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Rick Conrad
Sent: Tuesday, November 19, 2019 12:53 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Problem with patron cards - no barcode or image

Hi,

I’m trying to create patron cards that have barcodes as well as the library’s 
logo, but the barcode and the image never seem to show up. Can anybody see what 
I’m doing wrong? (It seemed like a bug to me, so I filed that here: 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23654 
.)

Thanks for any help!

-Rick Conrad

PS - In my first version of this email, I included screenshots of my settings 
so maybe somebody could see what the problem is. Unfortunately that put it over 
the size limit for the listserv, so it got held for moderation and, as far as I 
can tell, nobody ever looked at it.

So I sent a second version in which I wrote out all the details of my layout 
settings and template settings with the same goal. That email was rejected by 
the mailserver as spam….

So… I really want to provide all the details in case someone can help, but it 
appears to be impossible. The best I can do is humbly ask anyone who might be 
able to help to follow the link to the bug report where you can find all the 
details.

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] UPGRADING FROM KOHA 3.09 TO 19.11 UPGRADE ISSUES

[Doug Dearden]

Hey Josh,

Did you do koha-upgrade-to-3.4 ?

See this wiki entry: 
https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Upgrade_Instructions
 

Just a guess.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Josh Getanda
Sent: Thursday, February 20, 2020 10:39 PM
To: Koha 
Subject: [Koha] UPGRADING FROM KOHA 3.09 TO 19.11 UPGRADE ISSUES

Hi,

Please below errors when I try upgrading my database to the most current of
KOHA then advise what could be the issue. Thanks in advance.

Update report :

   - Status: 500
   - Content-type: text/html
   -
   - Software error:
   - Can't use an undefined value as an ARRAY reference at
   /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.
   - 
   - 
   - For help, please send mail to the webmaster (mailto:[no
   address given]">[no address given]), giving this error message
   - and the time and date of the error.
   -
   - 

Update errors :

   - Thu Feb 20 14:40:34 2020] updatedatabase.pl: DBD::mysql::db do failed:
   Table 'aqinvoices' already exists [for Statement "
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CREATE TABLE aqinvoices (
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: invoiceid int(11) NOT
   NULL AUTO_INCREMENT,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: invoicenumber mediumtext
   NOT NULL,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: booksellerid int(11) NOT
   NULL,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentdate date
   default NULL,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: billingdate date default
   NULL,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: closedate date default
   NULL,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentcost
   decimal(28,6) default NULL,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentcost_budgetid
   int(11) default NULL,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: PRIMARY KEY (invoiceid),
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CONSTRAINT
   aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES
   aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE,
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CONSTRAINT
   aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid)
   REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: ) ENGINE=InnoDB DEFAULT
   CHARSET=utf8
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: "] at
   /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
   line 5916.
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: DBD::mysql::st execute
   failed: Unknown column 'aqorders.booksellerinvoicenumber' in 'field list'
   [for Statement "
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: SELECT
   aqorders.booksellerinvoicenumber AS invoicenumber, aqbasket.booksellerid,
   aqorders.datereceived
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: FROM aqorders
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: LEFT JOIN aqbasket ON
   aqorders.basketno = aqbasket.basketno
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: WHERE
   aqorders.booksellerinvoicenumber IS NOT NULL
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: AND
   aqorders.booksellerinvoicenumber != ''
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: GROUP BY
   aqorders.booksellerinvoicenumber
   - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: "] at
   /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
   line 5941.
   - [Thu Feb 20 14:40:34 2020] updatedatabase.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.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Editing koha-sites.conf to allow for multiple instances

[Doug Dearden]

Hey Sterling,

I believe what you want are Apache name based virtual hosts.  See here for more 
info: 
 https://httpd.apache.org/docs/2.4/vhosts/examples.html 

Hope that helps.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Sterling Jenson
Sent: Tuesday, June 23, 2020 2:13 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Editing koha-sites.conf to allow for multiple instances

Greetings all,

I am experimenting with setting up a second instance of Koha on my server.
While I have the second one up running, including SSL, I cannot figure out
how to edit the koha-sites.conf file so that I can access the staff page
using https://[library1]-admin.[domain].org and
https://[library2]-admin.[domain].org
instead of https://www.[domain].org:[portnumber].  I have already tried to
copy and paste this block:

DOMAIN="[domain]"
> INTRAPORT="80"
> INTRAPREFIX=""
> INTRASUFFIX="-admin"
> OPACPORT="80"
> OPACPREFIX="opac"
> OPACSUFFIX=""
>

and change the ports that were used, but, alas, no luck.  Thoughts on what
step I am missing?  Or did I overlook the information in the Wiki?  Thanks
in advance.

Best,

Sterling
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Help debugging Internal Server Error

[Doug Dearden]

Hey Everyone,

I did an upgrade today on our server.  We were running version 19.05 on 
stretch, and we needed to upgrade to buster and I decided to get up to the 
latest stable Koha release at the same time.  The upgrade seemed to go OK but 
now when I go to our OPAC and do a search I get no results, and if I click on a 
link for recently added items I get an internal server error.  There are some 
Perl Modules showing as not installed -  Locale::XGettext::TT2 , 
Text::CSV::Unicode , Selenium::Remote::Driver , Test::DBIx::Class, 
HTTPD::Bench::ApacheBench .  There was a warning on the System Information tab 
about the  not being defined in koha-conf.xml so I added that to the 
config section in there and that warning is now gone.  I thought this might be 
related to plack.  If I enter
koha-plack -stop 
it returns
Stopping Plack daemon for 
When I enter koha-plack -disable 
it returns
Plack not disabled for  OPAC
Plack not disabled for  Intranet
With Plack stopped the error changes to Service Unavailable

I tried commenting out the Include /etc/koha/apache-shared-opac-plack.conf line 
from the apache config and restarting apache, but still got Service Unavailable 
.

/var/log/koha//opac-error.log shows this repeatedly
[Wed Feb 17 17:03:58.912977 2021] [proxy_http:error] [pid 4810] [client 
185.191.171.3:37140] AH01114: HTTP: failed to make connection to backend: 
httpd-UDS

I'm not really sure what logs I should be looking at to troubleshoot this.

Thanks,

Doug Dearden
Director / Information Technology
School for Advanced Research (SAR)
PO Box 2188 / Santa Fe / NM / 87504-2188
505-954-7220 (work) / 505-690-1535 (cell)
www.sarweb.org<http://www.sarweb.org/>

EXPLORING HUMANITY. UNDERSTANDING OUR WORLD.

Receive the SAR monthly E-News: SIGN UP HERE 
<https://sarweb.org/about/e-news-signup/>

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Help debugging Internal Server Error

[Doug Dearden]

ubtraction 
(-) at /usr/share/koha/lib/C4/Search.pm line 1759.
[2021/02/18 12:30:16] [WARN] Use of uninitialized value $times in subtraction 
(-) at /usr/share/koha/lib/C4/Search.pm line 1759.
#

# tail zebra-output.log
13:14:46-17/02 zebrasrv(425529) [warn] ir_session (exception)
13:15:10-17/02 zebrasrv(425530) [warn] ir_session (exception)
13:15:19-17/02 zebrasrv(425531) [warn] ir_session (exception)
13:15:22-17/02 zebrasrv(425532) [warn] ir_session (exception)
13:15:25-17/02 zebrasrv(425533) [warn] ir_session (exception)
13:15:30-17/02 zebrasrv(425534) [warn] ir_session (exception)
13:15:31-17/02 zebrasrv(425535) [warn] ir_session (exception)
13:15:35-17/02 zebrasrv(425536) [warn] ir_session (exception)
13:15:36-17/02 zebrasrv(425537) [warn] ir_session (exception)
13:15:39-17/02 zebrasrv(425538) [warn] ir_session (exception)
#

-Original Message-
From: Jonathan Druart [mailto:jonathan.dru...@bugs.koha-community.org] 
Sent: Thursday, February 18, 2021 7:57 AM
To: Doug Dearden 
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Help debugging Internal Server Error

Hey, Buster is Debian 10, not 11!
So we are supporting it and it's known to work correctly!

Le jeu. 18 févr. 2021 à 10:11, Jonathan Druart
 a écrit :
>
> Hello Doug,
>
> What do you see in the other error log files? (tail -f
> /var/log/koha//*.log)
>
> Our support for "buster" is buggy at the moment.
> Have a look at bug 26893 (New version of JSON::Validator (D11) breaks
> our REST API routes)
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26893
>
> Regards,
> Jonathan
>
> Le jeu. 18 févr. 2021 à 01:18, Doug Dearden  a écrit :
> >
> > Hey Everyone,
> >
> > I did an upgrade today on our server.  We were running version 19.05 on 
> > stretch, and we needed to upgrade to buster and I decided to get up to the 
> > latest stable Koha release at the same time.  The upgrade seemed to go OK 
> > but now when I go to our OPAC and do a search I get no results, and if I 
> > click on a link for recently added items I get an internal server error.  
> > There are some Perl Modules showing as not installed -  
> > Locale::XGettext::TT2 , Text::CSV::Unicode , Selenium::Remote::Driver , 
> > Test::DBIx::Class, HTTPD::Bench::ApacheBench .  There was a warning on the 
> > System Information tab about the  not being defined in 
> > koha-conf.xml so I added that to the config section in there and that 
> > warning is now gone.  I thought this might be related to plack.  If I enter
> > koha-plack -stop 
> > it returns
> > Stopping Plack daemon for 
> > When I enter koha-plack -disable 
> > it returns
> > Plack not disabled for  OPAC
> > Plack not disabled for  Intranet
> > With Plack stopped the error changes to Service Unavailable
> >
> > I tried commenting out the Include /etc/koha/apache-shared-opac-plack.conf 
> > line from the apache config and restarting apache, but still got Service 
> > Unavailable .
> >
> > /var/log/koha//opac-error.log shows this repeatedly
> > [Wed Feb 17 17:03:58.912977 2021] [proxy_http:error] [pid 4810] [client 
> > 185.191.171.3:37140] AH01114: HTTP: failed to make connection to backend: 
> > httpd-UDS
> >
> > I'm not really sure what logs I should be looking at to troubleshoot this.
> >
> > Thanks,
> >
> > Doug Dearden
> > Director / Information Technology
> > School for Advanced Research (SAR)
> > PO Box 2188 / Santa Fe / NM / 87504-2188
> > 505-954-7220 (work) / 505-690-1535 (cell)
> > www.sarweb.org<http://www.sarweb.org/>
> >
> > EXPLORING HUMANITY. UNDERSTANDING OUR WORLD.
> >
> > Receive the SAR monthly E-News: SIGN UP HERE 
> > <https://sarweb.org/about/e-news-signup/>
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Help debugging Internal Server Error

[Doug Dearden]

Hey Everyone,

Thank you Alvaro and Jonathan for your help, I wanted to report back that I got 
this fixed and what the problem was in case someone else runs into this.

An error in the plack-opac-error.log appears, and the same warning appears when 
I did koha-rebuild-zebra with the –v option:

DBD::mysql::st execute failed: Unknown column 
'me.exclude_from_local_holds_priority'

I created a new instance, and found that column in the items table on the new 
instance but not on the old instance.  I added the column with the SQL command:
ALTER TABLE items ADD exclude_from_local_holds_priority tinyint(1)
and that fixed it.

I’m not sure why koha-upgrade-schema didn’t fix this.
I have another instance that we stopped using and combined with an existing 
one.  I tried doing koha-remove, then koha-restore, the koha-upgrade-schema on 
that instance and it didn’t work.

I am concerned that there may be other database alterations between version 
19.05 and 20.11.02.000 that also didn’t make it into the database.  I found a 
reference to database changes on the wiki but it ends in the 3.x series.

How do I find out what other database schema changes have been implemented 
between 19.05 and 20.11.02.000?

Thanks,

Doug Dearden
Director / Information Technology
School for Advanced Research (SAR)
PO Box 2188 / Santa Fe / NM / 87504-2188
505.954.7220 / www.sarweb.org<http://www.sarweb.org/>

EXPLORING HUMANITY. UNDERSTANDING OUR WORLD.

Receive the SAR monthly E-News: SIGN UP HERE 
<https://sarweb.org/about/e-news-signup/>




___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Help debugging Internal Server Error

[Doug Dearden]

Hey Everyone,

A further update.  I dumped the schema to an xml file for both the new test 
database and the old database.  I then did a comparison using winmerge and 
there are multiple differences.  So the catalog is running but I am concerned 
because the database I am running is not up to the current version.

Any idea why koha-upgrade-schema wouldn't work?  Possibly a permissions issue?  

Thanks,

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Doug Dearden
Sent: Friday, February 19, 2021 12:22 PM
To: Alvaro Cornejo 
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Help debugging Internal Server Error

Hey Everyone,

Thank you Alvaro and Jonathan for your help, I wanted to report back that I got 
this fixed and what the problem was in case someone else runs into this.

An error in the plack-opac-error.log appears, and the same warning appears when 
I did koha-rebuild-zebra with the –v option:

DBD::mysql::st execute failed: Unknown column 
'me.exclude_from_local_holds_priority'

I created a new instance, and found that column in the items table on the new 
instance but not on the old instance.  I added the column with the SQL command:
ALTER TABLE items ADD exclude_from_local_holds_priority tinyint(1)
and that fixed it.

I’m not sure why koha-upgrade-schema didn’t fix this.
I have another instance that we stopped using and combined with an existing 
one.  I tried doing koha-remove, then koha-restore, the koha-upgrade-schema on 
that instance and it didn’t work.

I am concerned that there may be other database alterations between version 
19.05 and 20.11.02.000 that also didn’t make it into the database.  I found a 
reference to database changes on the wiki but it ends in the 3.x series.

How do I find out what other database schema changes have been implemented 
between 19.05 and 20.11.02.000?

Thanks,

Doug Dearden
Director / Information Technology
School for Advanced Research (SAR)
PO Box 2188 / Santa Fe / NM / 87504-2188
505.954.7220 / www.sarweb.org<http://www.sarweb.org/>

EXPLORING HUMANITY. UNDERSTANDING OUR WORLD.

Receive the SAR monthly E-News: SIGN UP HERE 
<https://sarweb.org/about/e-news-signup/>




___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Help debugging Internal Server Error

[Doug Dearden]

Hey Scott,

What version of Debian are you running?  I updated my 
/etc/apt/sources.list.d/koha.list file to point to stable and my 
/etc/apt/sources.list file to point to buster and did the upgrades at the same 
time.  A foolish move in retrospect, I think I should have upgraded to buster 
first and made sure everything worked there.  Unless someone else on the list 
has an idea of why the upgrade isn't working I am going to have to remove 
20.11/reinstall 19.05/restore the db and see what happens.  

Thanks,

Doug

-Original Message-
From: skaman...@gmail.com [mailto:skaman...@gmail.com] 
Sent: Friday, February 19, 2021 12:32 PM
To: Doug Dearden ; 'Alvaro Cornejo' 

Cc: koha@lists.katipo.co.nz
Subject: RE: [Koha] Help debugging Internal Server Error

Doug,

I would love to hear the same.  I have been unsuccessfully fighting an upgrade 
from 19.05 to 20.11.x for two months now.  All errors are missing SQL columns 
that are not fixed by koha-upgrade-schema.  Just doing an upgrade using the 
Debian package manager kills Koha altogether.  Hope someone can share this 
information.

Scott

-Original Message-
From: Koha  On Behalf Of Doug Dearden
Sent: Friday, February 19, 2021 1:22 PM
To: Alvaro Cornejo 
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Help debugging Internal Server Error

Hey Everyone,

Thank you Alvaro and Jonathan for your help, I wanted to report back that I got 
this fixed and what the problem was in case someone else runs into this.

An error in the plack-opac-error.log appears, and the same warning appears when 
I did koha-rebuild-zebra with the –v option:

DBD::mysql::st execute failed: Unknown column 
'me.exclude_from_local_holds_priority'

I created a new instance, and found that column in the items table on the new 
instance but not on the old instance.  I added the column with the SQL command:
ALTER TABLE items ADD exclude_from_local_holds_priority tinyint(1) and that 
fixed it.

I’m not sure why koha-upgrade-schema didn’t fix this.
I have another instance that we stopped using and combined with an existing 
one.  I tried doing koha-remove, then koha-restore, the koha-upgrade-schema on 
that instance and it didn’t work.

I am concerned that there may be other database alterations between version 
19.05 and 20.11.02.000 that also didn’t make it into the database.  I found a 
reference to database changes on the wiki but it ends in the 3.x series.

How do I find out what other database schema changes have been implemented 
between 19.05 and 20.11.02.000?

Thanks,

Doug Dearden
Director / Information Technology
School for Advanced Research (SAR)
PO Box 2188 / Santa Fe / NM / 87504-2188
505.954.7220 / www.sarweb.org<http://www.sarweb.org/>

EXPLORING HUMANITY. UNDERSTANDING OUR WORLD.

Receive the SAR monthly E-News: SIGN UP HERE 
<https://sarweb.org/about/e-news-signup/>




___

Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Need help with a couple of errors

[Doug Dearden]

Hey Everyone,

I posted earlier about trying to upgrade from 19.05 to 20.11 but was unable to 
solve all the issues after making the move.  I decided to just go back to 
19.05.  I had updated to Debian Buster from Stretch.  I installed 19.05 on 
Buster but ran into a problem with mojolicious not being the right version.  A 
little investigation made me conclude that Buster/19.05 and the version of 
mojolicious weren't going to work together, but Buster/19.11 might.  I 
installed 19.11 and passed the required prerequisites to do the  upgrade.

There was one error listed at the bottom of the install info when I hit the 
staff client during the upgrade:
"Update errors :
[Tue Feb 23 11:43:34 2021] updatedatabase.pl: Use of uninitialized value 
$INC[-1] in string eq at /usr/share/koha/lib/Koha/Plugins.pm line 37."

I am also getting this error when I rebuild zebra on two of the three instances 
I am running:
"Use of uninitialized value in subroutine entry at 
/usr/share/perl5/Module/Find.pm line 190."

Find.pm line 190 includes the value @INC which makes me wonder if these are 
related, and perhaps I am missing something in a config file.

I had some other strange things with Plack but was able to track them down, all 
instances do seem to be working.

Any insights to the above error messages are appreciated.

Thanks,

Doug Dearden
Director / Information Technology
School for Advanced Research (SAR)
PO Box 2188 / Santa Fe / NM / 87504-2188
505-954-7220 (work) / 505-690-1535 (cell)
www.sarweb.org<http://www.sarweb.org/>

EXPLORING HUMANITY. UNDERSTANDING OUR WORLD.

Receive the SAR monthly E-News: SIGN UP HERE 
<https://sarweb.org/about/e-news-signup/>

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Need help with a couple of errors

[Doug Dearden]

Hey Mason,

I got 19.05 to install on Buster and ran koha-restore successfully, but when I 
hit the staff client got a message that Mojolicious::Plugin::OpenAPI wasn't 
installed, but when I checked it was.  I found this post where Fred King had 
the same problem: 
https://lists.katipo.co.nz/public/koha/2019-November/053883.html .  His 
possible solutions didn't work for me so I decided to try 19.11 and the 
Mojolicious problem disappeared.  I had read something about the version 
installed with Stretch being different than Buster and that 19.05 was looking 
for the version that Stretch installs.  Your examples on gitlab show 19.11 
(old2stable) but not 19.05.

I did get 20.11 installed, but could not get the database to update correctly.  
See my earlier thread titled "Help debugging internal server error".  I'm not 
alone, Scott replied to me that he is having the same issue moving from 20.05 
to 20.11.  I have a working system now so am not going to mess with it, I will 
try and upgrade when I can reconfigure some hardware as a test bed.  If you 
have any insight regarding the database upgrade problem I welcome it.  I can 
file a bug but could not find anything in the logs to indicate where the 
database update went wrong, and don't want to file a bug that just says it 
didn't work without any details.

Thanks,

Doug

-Original Message-
From: Mason James [mailto:m...@kohaaloha.com] 
Sent: Thursday, February 25, 2021 3:11 AM
To: Doug Dearden ; koha@lists.katipo.co.nz
Subject: Re: [Koha] Need help with a couple of errors


On 25/02/21 12:23 pm, Doug Dearden wrote:
> Hey Everyone,
>
> I posted earlier about trying to upgrade from 19.05 to 20.11 but was unable 
> to solve all the issues after making the move.  I decided to just go back to 
> 19.05.  I had updated to Debian Buster from Stretch.  I installed 19.05 on 
> Buster but ran into a problem with mojolicious not being the right version.  
> A little investigation made me conclude that Buster/19.05 and the version of 
> mojolicious weren't going to work together, but Buster/19.11 might.  I 
> installed 19.11 and passed the required prerequisites to do the  upgrade.

hi Doug
all current Koha 19.05, 19.11 and 20.11 packages should install on Debian 9 and 
10, (and Ubuntu 16, 18 and 20)

you can see more details below...


stable-deb10 https://gitlab.com/mjames/ktd-test-pkgs/-/jobs/1054515221
oldstable-deb10 https://gitlab.com/mjames/ktd-test-pkgs/-/jobs/1054515231
old2stable-deb10 https://gitlab.com/mjames/ktd-test-pkgs/-/jobs/1054515240


stable-deb9 https://gitlab.com/mjames/ktd-test-pkgs/-/jobs/1054515222
oldstable-deb9 https://gitlab.com/mjames/ktd-test-pkgs/-/jobs/1054515232
old2stable-deb9 https://gitlab.com/mjames/ktd-test-pkgs/-/jobs/1054515241


cheers, Mason

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Search Produces No Results

[Doug Dearden]

Hey Gopalakrishna,

Make a new instance using koha-create.  Look at the /etc/koha/sites//koha-conf.xml file in the new instance.  There will be a  line 
in the file.  Add that to your old instance koha-conf.xml file, with the 
appropriate instance name.  You may also need to create the directory on the 
server, and chown and chgrp the directory to be owned and group assigned to 
your instance user name.

Also, check the About Koha page.  Do you have a warning that says Zebra is not 
running?  You may just need to start it.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of 
Gopalakrishna-BMSIT
Sent: Wednesday, February 24, 2021 10:27 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Search Produces No Results

Installation type: Package
OS: Ubuntu Server 18.04.5
Koha: Upgraded from 19.11 to 20.11
Problem: Search produces no result
Action Taken: Rebuilt full zebra index several times
System Information: XML configuration file  WarningYou are missing the
 entry in your koha-conf.xml file. Please add it, pointing to your
Koha instance's lock dir.
How to fix this?

*With Regards,*
*Gopalakrishna*




*Librarian, B.M.S Institute of Technology,Avalahalli, Doddaballapur Main
Road,Yelahanka, Bangalore-64Mob.:  861 853 1385*
*974 189 8674*
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Upgraded to 3.10 using the packages, and broke the OPAC

[Doug Dearden]

Hello all,

A couple of weeks ago I built a test machine from scratch, Debian Squeeze and 
installed the stable version on it (at the time 3.8.7).  I used the 
instructions on the wiki at 
http://wiki.koha-community.org/wiki/Koha_3.8_on_Debian_Squeeze and 
http://wiki.koha-community.org/wiki/Moving_an_installation_from_a_regular_install_to_the_Debian_packages
 to guide me.  All worked well, and I was pleased with the results.

Today I did the same on my production machine and things did not go as well.  I 
pointed to the stable version, and wound up with 3.10.0 (not unexpected).  I 
went through the same process per the wiki instructions and have a somewhat 
functioning catalog.  The issue is the way the OPAC looks.  You can see the 
result at http://library.sarsf.org .  You may need to reload the page once or 
twice before it breaks.  It looks a little better in IE, but is definitely 
wrong in Firefox or Chrome.

Checking the log in /var/log/koha//opac-error.log I see this 
every time the page is loaded:

[Tue Nov 27 15:38:03 2012] [error] [client 192.168.30.196] [Tue Nov 27 15:38:03 
2012] opac-main.pl: Use of uninitialized value in concatenation (.) or string 
at /usr/share/koha/lib/C4/Auth.pm line 390.
[Tue Nov 27 15:38:03 2012] [error] [client 192.168.30.196] [Tue Nov 27 15:38:03 
2012] opac-main.pl: Use of uninitialized value in concatenation (.) or string 
at /usr/share/koha/lib/C4/Auth.pm line 390.
[Tue Nov 27 15:38:03 2012] [error] [client 192.168.30.196] File does not exist: 
/usr/share/koha/opac/htdocs/opac-tmpl/lib/yui/reset-fonts-grids.css, referer: 
http://opac.main.library.campus.sarsf.org/
[Tue Nov 27 15:38:03 2012] [error] [client 192.168.30.196] File does not exist: 
/usr/share/koha/opac/htdocs/opac-tmpl/lib/yui/skin.css, referer: 
http://opac.main.library.campus.sarsf.org/
[Tue Nov 27 15:38:04 2012] [error] [client 192.168.30.196] [Tue Nov 27 15:38:04 
2012] 404.pl: Use of uninitialized value in concatenation (.) or string at 
/usr/share/koha/lib/C4/Auth.pm line 390., referer: 
http://opac.main.library.campus.sarsf.org/
[Tue Nov 27 15:38:04 2012] [error] [client 192.168.30.196] [Tue Nov 27 15:38:04 
2012] 404.pl: Use of uninitialized value in concatenation (.) or string at 
/usr/share/koha/lib/C4/Auth.pm line 390., referer: 
http://opac.main.library.campus.sarsf.org/
[Tue Nov 27 15:38:04 2012] [error] [client 192.168.30.196] [Tue Nov 27 15:38:04 
2012] 404.pl: Use of uninitialized value in concatenation (.) or string at 
/usr/share/koha/lib/C4/Auth.pm line 390., referer: 
http://opac.main.library.campus.sarsf.org/
[Tue Nov 27 15:38:04 2012] [error] [client 192.168.30.196] [Tue Nov 27 15:38:04 
2012] 404.pl: Use of uninitialized value in concatenation (.) or string at 
/usr/share/koha/lib/C4/Auth.pm line 390., referer: 
http://opac.main.library.campus.sarsf.org/

Auth.pm line 390 refers to the opaccolorstylesheet preference, which is set to 
"colors.css" .  I tried changing that to blank but it didn't make any 
difference.  Also, colors.css exists but is an empty file.  The two files that 
it says do not exist, skin.css and reset-fonts-grids.css indeed are not in that 
location, they are in /usr/share/koha/opac/htdocs/opac-tmpl/prog/en/css .

Any idea where I might have gone wrong?

Thanks,

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Upgraded to 3.10 using the packages, and broke the OPAC

[Doug Dearden]

Thanks Indranil, that helped.  

Instead of using Vimal's solution I copied the files in question to the correct 
location and that fixed it.  I had checked bugzilla when this happened but 
didn't find the bug.  Thanks for pointing me to the solution.

Doug

-Original Message-
From: Indranil Das Gupta [mailto:indr...@gmail.com] 
Sent: Tuesday, November 27, 2012 5:49 PM
To: Doug Dearden
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Upgraded to 3.10 using the packages, and broke the OPAC

Hi,

On Wed, Nov 28, 2012 at 5:11 AM, Doug Dearden  wrote:

> [Tue Nov 27 15:38:03 2012] [error] [client 192.168.30.196] File does not 
> exist: /usr/share/koha/opac/htdocs/opac-tmpl/lib/yui/reset-fonts-grids.css, 
> referer: http://opac.main.library.campus.sarsf.org/
> [Tue Nov 27 15:38:03 2012] [error] [client 192.168.30.196] File does not 
> exist: /usr/share/koha/opac/htdocs/opac-tmpl/lib/yui/skin.css, referer: 
> http://opac.main.library.campus.sarsf.org/

Looks like you been hit by
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9052

FWIW, Vimal faced the same bug earlier today. Here's how he fixed it -
http://lists.koha-community.org/pipermail/koha-devel/2012-November/038586.html

hth

--
Indranil Das Gupta

Phone : +91-98300-20971
Blog: http://indradg.randomink.org/blog
IRC  : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] New installation perl modules and Makefile issues

[Doug Dearden]

Hi Marty,

I recently did an install using the packages and found it easier to get through 
then using the tarball.  You will find the instructions here: 
http://wiki.koha-community.org/wiki/Koha_3.8_on_Debian_Squeeze .  If you do the 
"oldstable" release you will get the 3.08.07 version.  If you do "stable" you 
get the 3.10.0 version which has a bug in it that breaks the OPAC 
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9052 .  It is easy to 
fix if you want to get on the latest.

Take a look.  If you have Debian, Apache, and MySQL already done then a package 
setup might be the ticket.

Best,

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org

  

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Marty
Sent: Monday, December 10, 2012 4:11 PM
To: koha koha
Subject: [Koha] New installation perl modules and Makefile issues

Hi all,

It's been a while since I have been here, we had a nice up to date koha 
running, when our hard drive died. Luckily we made backups.
Now I am on a new machine, doing a new installatiion but I am running into 
things I have never seen.
Running Debian 6 on dual booted Lenovo box


First of all, perl koha_perl_deps.pl -m -u keeps saying that modules are not 
installed, even if they  are the requested version or later and there are five 
that will not install without force. so I used force, but it still will insist 
the modules are not installed;

DateTime                                       0 *    0.58    Yes    v0.78
DateTime::Event::ICal                   0 *    0.08    Yes    v0.11 (won't  
install without force)
DateTime::Format::DateParse0 *    0.04    Yes    v0.05
DateTime::Format::ICal                0 *    0.09    Yes    v0.09
DateTime::Set                               0 *    0.28    Yes    v0.31 (won't 
install without force)
DateTime::TimeZone                    0 *    1.26    Yes    v1.56
Test::Strict                                      0 *    0.14    No    v0.14 
(won't install without force)
Test::YAML::Valid         0 *    0.04    No    v0.04 (won't 
install without force)
XML::RSS         0 *    1.31    Yes    v1.49 (won't 
install without force)

Then, when I try to run perl makefile.PL I cannot even do that, this is what i 
get;

:~/koha-3.08.07$ perl Makefile.PL
Can't locate Class/Load.pm in @INC (@INC contains: 
/home/ccclibrary/koha-3.08.07 /etc/perl /usr/local/lib/perl/5.10.1 
/usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 
/usr/share/perl/5.10 /usr/local/lib/site_perl .) at 
/usr/local/share/perl/5.10.1/DateTime/TimeZone/Local.pm line 9.
BEGIN failed--compilation aborted at 
/usr/local/share/perl/5.10.1/DateTime/TimeZone/Local.pm line 9.
Compilation failed in require at 
/usr/local/share/perl/5.10.1/DateTime/TimeZone.pm line 13.
BEGIN failed--compilation aborted at 
/usr/local/share/perl/5.10.1/DateTime/TimeZone.pm line 13.
Compilation failed in require at /home/ccclibrary/koha-3.08.07/C4/Context.pm 
line 107.
BEGIN failed--compilation aborted at 
/home/ccclibrary/koha-3.08.07/C4/Context.pm line 107.
Compilation failed in require at /home/ccclibrary/koha-3.08.07/C4/Installer.pm 
line 24.
BEGIN failed--compilation aborted at 
/home/ccclibrary/koha-3.08.07/C4/Installer.pm line 24.
Compilation failed in require at Makefile.PL line 31.
BEGIN failed--compilation aborted at Makefile.PL line 31.

I  am starting to wonder how I ever got previous versions running... Any ideas 
are most welcome!

Thanks, Marty
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] indexing and cronjobs

[Doug Dearden]

Hi Tom,

I recently did an install from the packages and I find the cronjobs in three 
places: /etc/cron.d/koha-common , /etc/cron.hourly/koha-common , and 
/etc/cron.daily/koha-common .  I think you will find what you are looking for 
in those three files.

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Tom Obrien
Sent: Tuesday, December 18, 2012 2:42 AM
To: koha
Subject: Re: [Koha] indexing and cronjobs

Hi,
I am new to Koha and need some help. have installed koha 3.10 on ubuntu
server 12. 04 using packages. Indexing is now working. Kindly advice me on
how i should set cronjobs. should i set it under crontab -e or
/etc/cront.d/koha-common?
Secondly can somebody help with tested cronjobs which i can use.
Thanks in advance.
Tom
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Importing records from Koha 3.01 into 4.02

[Doug Dearden]

David,

Judging by the version number I think you got the proprietary fork from 
Liblime.  I would suggest you install the oldstable release from 
koha-community.org.  Instructions can be found here: 
http://wiki.koha-community.org/wiki/Koha_3.8_on_Debian_Squeeze 

If you are not installing on Debian or one of its variants (like Ubuntu), there 
are installation instructions for other linux distros on the wiki here: 
http://wiki.koha-community.org/wiki/Category:Installation 

Hope that helps,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of David M. Bucknell
Sent: Tuesday, December 18, 2012 12:45 AM
To: Koha
Subject: [Koha] Importing records from Koha 3.01 into 4.02

Dear Koha Friends,

We have tried to bring the records in by two methods, first to point  
at the old database when installing 4.02; secondly, to do a fresh  
installation and then using tools > marc staging to import the files  
already exported from the old system.

The first installation seems to work, but searching finds no records.
Using the second method, we can see a list of records, but only one of  
them (the first one) has a Bib number and after clicking on "Import"  
the progress bar never advances.

Sorry for such a clueless question.  Does anyone have some clues for us?

We are using Marc 21, by the way.

Thank you,

David
-- 
http://intknowledge.com
91 Suthisan, Dindaeng, Bangkok 10400
Thailand: 084 329 1183; 02 693 8144
Outside Thailand: +66 84 329 1183 (cell); +66 2 693 8144


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] cloning 856 $u

[Doug Dearden]

Hello Haik,

Try creating multiple 856 fields with an $u and $y subfield for each.  Don't 
make a single 856 field and multiple subfields.  I think that will display the 
way you want.

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Haik Zargaryan
Sent: Sunday, December 23, 2012 11:00 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] cloning 856 $u

Dear friends,

We want to attach several URLs to the MARC record. Since the 856 $u field is 
repeatable, we have decided to clone the subfield several times. Yet, when we 
search for the record in the OPAC, only the first link is displayed in the 
results' page, meanwhile the other ones are not visible at all. 

We have a similar problem with the 856 $y field as well. All subfields are 
concatenated in one field and are displayed as a one text. 

We want to have all links each one with its appropriate text value, and of 
course, displayed separately. Is it possible?

Thank you in advance,
Haik.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Ouput koha report in PDF

[Doug Dearden]

Hi Moumie,

Since you mention excel I suspect you are using a Windows PC as your 
workstation.  If so, I can recommend cute pdf.  A free download from 
cutepdf.com .  You will also need to install ghostscript.  This installs like a 
printer, and you just choose it instead of printing from any application.  

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of soulemane moumie
Sent: Friday, March 08, 2013 10:33 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Ouput koha report in PDF

Hi all!
Please I need some directions on how to output koha report in PDF.
Till now I have only been able to get the excel file, make some external post 
processing in the spreadsheet to get what I want.

But I have a logo and header of the library that I want to embed in the report,
 then output in pdf directly out of the box from koha.
Question:
1. Is there any option in koha that a user to directly output the report in PDF 
?
2. If not , it is any third party software to do this ?
3. If not is there any better way to do this ?


System:
Koha 3.08.06
Ubuntu 12 LTS

Thanks.



Moumié Soulémane
Assistant Programmer, OCP, MCTS, JCP
Department of Computer Science Engineering
Islamic University of Technology(IUT)
Board Bazar, Gazipur-1704, Bangladesh.
Cellular: +880192-1628880,+8801921628880
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] SQL runs outside of staff client but not inside it

[Doug Dearden]

Hello all,

I am working on some SQL to get a report for last month's acquisitions, and 
worked up the following code to do it:

SELECT MONTH(CURDATE()) INTO @curmonth;
SELECT MONTH(CURDATE())-1 INTO @lastmonth;
SELECT YEAR(CURDATE()) INTO @reportyear;
SELECT YEAR(CURDATE())-1 INTO @lastmnthyear;
SELECT IF (@curmonth=1, 12, @lastmonth) into @lastmonth;
SELECT IF (@curmonth=1, @lastmnthyear, @reportyear) into @reportyear;
SELECT CONCAT(@reportyear,"-",@lastmonth,"-01") into @begindate;
SELECT LAST_DAY(@begindate) into @enddate;
SELECT
EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') as "Title:",
EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="b"]') as subtitle,
EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="c"]') as 
"statement of responsibility",
EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="b"]') as 
Publisher,
EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="c"]') as Date,
EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="a"]') as "Call 
Number first part",
EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="b"]') as "Call 
Number second part",
items.dateaccessioned as "Date Accessioned"
FROM biblioitems LEFT JOIN items on 
(biblioitems.biblioitemnumber=items.biblioitemnumber)
WHERE items.dateaccessioned BETWEEN @begindate and @enddate
ORDER BY items.dateaccessioned asc

If I put this in a text file on the server, and call it using mysql it runs 
fine.  When I put it into an SQL report on the staff client it fails with this 
error:  "Can't use an undefined value as an ARRAY reference at 
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 766"

Looking at that line in guided_reports.pl it is where the column headings are 
being loaded into an array.

The problem definitely lies in the first half of the code where I am loading 
date information into variables to build the begin and end dates.  If that code 
is removed and actual dates entered for the BETWEEN values the report runs fine 
in the staff client.

If the answer here is that it isn't going to run in the staff client, I can set 
it up to run on the server and create a cron job to automate it.  If that is 
the case should I open a bug for this, or am I getting outside of the scope of 
the guided reports tool to begin with?

Koha 3.10.0 on Debian Squeeze .

Thanks,

Doug Dearden
Director, IT
School for Advanced Research
sarweb.org

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL runs outside of staff client but not inside it

[Doug Dearden]

Thanks Robert, that did it.  A much more elegant solution than mine also.  I 
checked the wiki before I started this but didn't find that report.

Best - Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Robert Williams
Sent: Wednesday, March 20, 2013 10:19 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] SQL runs outside of staff client but not inside it

Doug:

You wrote:
>I am working on some SQL to get a report for last month's acquisitions, and 
>worked up the following code to do it:

[...snip...]

A couple of the SQL Reports posted on the wiki have a WHERE clause that 
purportedly limits to the previous month. Would something like the following 
work?

SELECT
EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="a"]') as "Title:",
EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="b"]') as subtitle,
EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="c"]') as 
"statement of responsibility",
EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="b"]') as 
Publisher,
EXTRACTVALUE(marcxml,'//datafield[@tag="260"]/subfield[@code="c"]') as Date,
EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="a"]') as "Call 
Number first part",
EXTRACTVALUE(marcxml,'//datafield[@tag="092"]/subfield[@code="b"]') as "Call 
Number second part", items.dateaccessioned as "Date Accessioned"
FROM biblioitems LEFT JOIN items on 
(biblioitems.biblioitemnumber=items.biblioitemnumber)
WHERE items.dateaccessioned >= concat(date_format(LAST_DAY(now() - interval 1 
month),'%Y-%m-'),'01') 
AND items.dateaccessioned <= LAST_DAY(now() - interval 1 month) 
ORDER BY items.dateaccessioned asc;


--Robert

*
Robert L. Williams
Open Source Services Manager
Amigos Library Services, Inc.
14400 Midway Road
Dallas, TX 75244-3509
800-843-8482, x2870
972-340-2870 (direct)
972-991-6061 (fax)




___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Weird textboxes in koha 3.10.4

[Doug Dearden]

Paul,

We are running 3.10.0, you can see it at http://library.sarsf.org .

Also, for a linux distro that will run on a Pentium box with 256k RAM check out 
puppy linux at puppylinux.org.  I haven't used this lately but several years 
back experimented with it when I was looking for a distro that ran on minimal 
hardware.

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Paul
Sent: Monday, April 15, 2013 5:06 PM
To: Sue McMillan; koha@lists.katipo.co.nz
Subject: Re: [Koha] Weird textboxes in koha 3.10.4

At 07:57 PM 4/15/2013 +, Sue McMillan wrote:
>We found we had 4 or five boxes displaying under each other when we 
>upgraded to Koha 3.10.03.001 last week.  Turns out that different versions 
>of Firefox displayed the home page differently.  Upgrading Firefox fixed 
>the issue.

We still have a number of work stations using a very old version of Firefox 
(3.6.13 -- the last to run on a buttoned-down Win 98SE -- terrible, but I 
haven't had time to find a Linux distrib that will work on a Pentium box 
with 256k RAM) and have no probs with them working quite brilliantly (and 
very fast in a kiosk environment) for Koha 3.8.x

Do you have a "live" example of a 3.10 server that I could look at?

Many thanks - Paul 

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Need some SQL help

[Doug Dearden]

Hello all,

I find myself once again confounded by an SQL problem.  I am trying to extract 
the value from field 245, ind2 .  I have used a variety of select statements 
without success, i.e.

SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"][ind2]') as "SkipArticle"
or
SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"]/subfield[@code="ind2"]') 
as "SkipArticle"

Those are two of the variations I have tried.  There are probably another 20 
along the way.

When I look at the marcxml field I see that ind1 and ind2 are on the same line 
as the 245 identifier, and not in a subfield line.  For instance:


Biology unmoored :
Melanesian reflections on life and biotechnology 
/

A number of my attempts have not returned a syntax error, they just never 
return a value.

So what would the SQL/Xpath syntax be to get the info out of ind2 ?

Thanks in advance for your help,

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Need some SQL help

[Doug Dearden]

Thanks Galen, that did it.

Seems so obvious now. :)

Doug

-Original Message-
From: Galen Charlton [mailto:g...@esilibrary.com] 
Sent: Friday, April 19, 2013 12:10 PM
To: Doug Dearden
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Need some SQL help

Hi,

On Fri, Apr 19, 2013 at 10:54 AM, Doug Dearden  wrote:
> So what would the SQL/Xpath syntax be to get the info out of ind2 ?

Here's the XPath:

//datafield[@tag="245"]/@ind2

Regards,

Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  g...@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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Cronjob errors

[Doug Dearden]

Hi Robin,

Thanks for the response.  To upgrade to the latest 3.10.x, is it just a matter 
of changing the line in /etc/apt/sources.list.d/koha.list to deb 
http://debian.koha-community.org/koha oldstable main and then doing

apt-get update
apt-get install koha-common 

or should that last line be something like

apt-get dist-upgrade 

I couldn't find anything in the wiki that mentioned updates.  But then I often 
have problems finding my answer in the wiki. ;)

Thanks,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Robin Sheat
Sent: Thursday, July 11, 2013 10:30 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Cronjob errors

Op 11/07/13 17:15, Doug Dearden schreef:
> Koha version:
> 
> 3.10.00.000

You are running quite an old version of Koha. I'd strongly recommend
upgrading, as there have been a lot of fixes on the 3.10 line since then.

Your particular issue was fixed in 3.10.1:

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9260

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] (no subject)

[Doug Dearden]

Richard,

This has to do with your network setup.  As it says in the Assumptions right 
above the Tweak Hosts File entry, you need some help from your network folks on 
this one.

The instructions add the two lines to the /etc/hosts file.  These point the 
names for the OPAC and the staff client to the local loopback address.  This 
allows you to connect to the web installer from the same machine you are 
installing on in the following "Web Installation" step.

Best,

Doug 

   


-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Richard Maileseni
Sent: Monday, August 26, 2013 1:55 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] (no subject)

hi guys!

Please can anyone explain the "Tweak Host File" step in

http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages

thanks.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] (no subject)

[Doug Dearden]

Richard,

If you have successfully installed Koha and can login to the staff client, then 
you have the basic installation done and are moving into the "librarian" steps. 
 Check out the documentation here: http://koha-community.org/documentation/ .

For migration you might need a tool like MarcEdit .  You will find it and 
supporting info here: 
http://people.oregonstate.edu/~reeset/marcedit/html/index.php

A couple of other things, when responding to posts make sure you include the 
email address of the list, as you are more likely to find the help you need 
from the group rather than from one person.  Also, include a Subject on your 
email.  It helps us identify those questions we might have some chance of 
answering as opposed to those that are out of our area of expertise.

Best,

Doug


From: Richard Maileseni [mailto:rmailes...@gmail.com]
Sent: Monday, August 26, 2013 5:17 PM
To: Doug Dearden
Subject: Re: [Koha] (no subject)

Thanks Doug. appreciate all the help! but could you direct me to where i could 
get the manual for setting up library in koha. Im quite new here and I have no 
library experience, im a student working on a project for our school.  my task 
is to do a migration and I have just finished installing koha on ubundu server. 
could you please direct me to what i might have to do next.
Cheers
Richard


On Tue, Aug 27, 2013 at 10:04 AM, Doug Dearden 
mailto:dear...@sarsf.org>> wrote:
Richard,

This has to do with your network setup.  As it says in the Assumptions right 
above the Tweak Hosts File entry, you need some help from your network folks on 
this one.

The instructions add the two lines to the /etc/hosts file.  These point the 
names for the OPAC and the staff client to the local loopback address.  This 
allows you to connect to the web installer from the same machine you are 
installing on in the following "Web Installation" step.

Best,

Doug




-Original Message-
From: koha-boun...@lists.katipo.co.nz<mailto:koha-boun...@lists.katipo.co.nz> 
[mailto:koha-boun...@lists.katipo.co.nz<mailto:koha-boun...@lists.katipo.co.nz>]
 On Behalf Of Richard Maileseni
Sent: Monday, August 26, 2013 1:55 AM
To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>
Subject: [Koha] (no subject)

hi guys!

Please can anyone explain the "Tweak Host File" step in

http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages
thanks.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
http://lists.katipo.co.nz/mailman/listinfo/koha



--
 Richard W. Maileseni

 Mob:  027-934-2039
 PH:042367222
 Email:lisiate.mailes...@tti.to<mailto:lisiate.mailes...@tti.to>
 facebook:   www.facebook.com/rmaileseni<http://www.facebook.com/rmaileseni>
 scype:   ma_richie

  ~\\~
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Full text document attachment

[Doug Dearden]

Hi Akhlaq,

We got around this by using the Redirect directive in our apache config.  I 
created a subdirectory for a local user, then created a symbolic link to it 
from /var/www.  In this way the cataloger can copy the file to the server as 
the local user and catalog using a string that apache redirects to the proper 
place.  If you later have to move the subdirectory, you just change the 
redirect in the config.

For example, our users login as "luser", and place the test files in a 
subdirectory called "lfiles".  There is a symbolic link in /var/www called 
textfiles -> /home/luser/lfiles .
In the apache config file for the Koha instance in both VirtualHost sections 
(OPAC and Intranet) is the redirect directive like this:  Redirect 
/libraryfiles http:///textfiles .
When we catalog, in the 856u field we put in 
/libraryfiles// .

The link is active, and if you need to change to a different address or DNS 
name in the future all you have to do is change the Redirect directive in the 
apache config.  It would also be possible to move all the files to another 
separate web server and just point to that server in the Redirect directive.

Note that /var/www is the DocumentRoot for the default site in Apache.  We have 
that running to serve up these documents.  /var/www is not the default 
DocumentRoot for Koha instances.

Hope that helps.

Doug


-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of akhlaq ahmed
Sent: Tuesday, December 10, 2013 10:18 PM
To: Koha@lists.katipo.co.nz
Subject: [Koha] Full text document attachment

Dear
Friends,
 
I am trying
to attach full text document with the koha bibliographical records. The marc
field 856 is used to give the local URL but on checking I realised one need to 
give
full path eg. http://192.168.0.1/abc.pdf
The pdf files
are stored in var/www directory. 
 
I need to
avoid the local machine numbers otherwise in future if the machine number is
changed or the data will be transferred it will cause the path problem. I need
to search only bibliographical details not the full text term.
 
Please
suggest the right way how the full text are handled in Koha. 
 
Looking forward
to hear from you.
 
Regads,
Akhlaq
Ahmed, New Delhi
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] koha home webinstaller page redirects to maintenance.pl page

[Doug Dearden]

Hi Ribin,

If this isn't a typo in your email - http://koha.domainname:8008 , then I think 
your problem might be the 8008 .  The default is 8080 .

Doug


-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of ribin.jo...@niist.res.in
Sent: Tuesday, December 17, 2013 3:18 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] koha home webinstaller page redirects to maintenance.pl page

Hi,

I am trying to install koha in CentOS. I was following the howto in 
http://wiki.koha-community.org/wiki/Koha_3.10_on_Centos_6.3_x86_64_en. 

Installation went on fine. At the end when I try to access koha page (web 
installer) from my pc (using http://koha.domainname:8008), it redirects me to 
the the maintenance.pl page with a message 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..

Where am I going wrong here? Any help is greatly appreciated...I am a newbie to 
koha.

Regards,

Ribin

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] sms configure with koha

[Doug Dearden]

I think the solution would be to use email.

Check out this site http://www.makeuseof.com/tag/email-to-sms/ 

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of vinod kumar
Sent: Saturday, December 21, 2013 5:36 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] sms configure with koha

 Hi all

how to enable sms service with koha
please suggest me
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Searching on 099

[Doug Dearden]

Hello all,

I received this query from our librarian "In the archive database we use the 
099 field for call numbers but the opac search option for call number doesn't 
seem to search this field.  Could we add it?  I can't find it in administration 
or the manual".  I dug around in the administration section and couldn't figure 
it out either.  In this database we don't use item records, only biblio 
records.  I am thinking that to make this happen I need to modify Zebra 
configuration file(s), but I am not sure.

Koha version 3.12.03.000 installed on Debian Squeeze using packages.  Zebra 
version 2.0.47.

Thanks!

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Activating SMS facility for koha in India

[Doug Dearden]

Mahesh,

I know you can use email to send an SMS to a phone.  Check out this page for 
examples, there is one Indian carrier listed: 
http://www.makeuseof.com/tag/email-to-sms/ 

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Mahesh Angadi
Sent: Tuesday, February 11, 2014 2:48 AM
To: koha@lists.katipo.co.nz
Cc: lis-fo...@ncsi.iisc.ernet.in
Subject: [Koha] Activating SMS facility for koha in India

Dear Members,

I have installed koha (3.8.6 version) on Ubuntu 12.04 LTS using liblivecd
developed by Dr. A. R. D. Prasad. Using postfix, we are able to relay
circulation email notices from gmail account.  Now we want to provide
circulation notices on patrons cellphone in form of SMS.

I searched through the mailing list, however, so far I could not get a
suitable solution.

I could locate file SMS.pm in C4 directory and files like Send.pm,
Driver.pm, Test.pm in /usr/share/perl5/SMS directory.

Kindly guide me in this reagrad.

-- 
Mr. Mahesh M. Angadi,
Librarian,
Model College, Dombivli (E).
Contact No. 9869120258, (0251) 2470010.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Sorting conundrum

[Doug Dearden]

Hello all,

I have a database that has no item records, only biblios.  We are using it to 
catalog some archival folders, and pointing to pdfs with scanned images using 
the 856u field.  We are using the 099a field as the call number field.  In 
Administration - System Preferences - Cataloging - Record Structure - 
itemcallnumber we have 099a filled in.  I just changed the Koha to MARC mapping 
so that items - itemcallnumber maps to 099a .  After doing a search the results 
page is sorted in Relevance order.  Changing the sort order to Call Number 
order, either Z-A or A-Z does not produce any change.  Changing the sort order 
to Title or Author works.  How do I get the sort working using the Call Number 
in the 099a field?

Thanks,

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Still working on sorting problem

[Doug Dearden]

Hello all,

I am still working on this sorting problem, and have looked a bit deeper into 
it.  I find the sorting routine in /usr/share/koha/lib/C4/ClassSortRoutine.pm , 
and it looks to me like it is driven by the variables $sort_routine, $cn_class 
and $cn_item .  This took me back to the system preferences, where I turned on 
the Classification source "z Other/Generic Classification Scheme" and turned 
off all others.  I then went to Koha to MARC mapping - biblioitems and set 
cn_class to point to 099a - which removed the mapping from items - 
itemcallnumber.  I am suspicious that my problem may be that these records do 
not have a cn_source field, though my reading of ClassSortRoutine makes me 
think it would fall back to a default routine that should work.  Or is there a 
perl program that needs to be run to update the records with the new system 
preferences?  My previous question is pasted below.  Any help is appreciated.


I have a database that has no item records, only biblios.  We are using it to 
catalog some archival folders, and pointing to pdfs with scanned images using 
the 856u field.  We are using the 099a field as the call number field.  In 
Administration - System Preferences - Cataloging - Record Structure - 
itemcallnumber we have 099a filled in.  I just changed the Koha to MARC mapping 
so that items - itemcallnumber maps to 099a .  After doing a search the results 
page is sorted in Relevance order.  Changing the sort order to Call Number 
order, either Z-A or A-Z does not produce any change.  Changing the sort order 
to Title or Author works.  How do I get the sort working using the Call Number 
in the 099a field?

Thanks,

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Sorting of accession numbers

[Doug Dearden]

Hi Manoj,

You might be able to parse out the pieces by using MySQL string functions: 
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html 

For instance, you could use the Left function to get the two characters at the 
beginning of the string, and the Mid function to get the rest of the 
characters, then sort on the first two, then on the rest.  

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of manoj382093
Sent: Sunday, March 30, 2014 9:54 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Sorting of accession numbers

Dear Friends,
Is there no way we can do it by SQL Command in report writing.

*Regards!*

*Manoj Kumar Misra*
M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.)
Deputy Librarian
SRMGPC
Lucknow
Mob. No.: 09415422579
Alternate E-mail: manojmisrasrm...@gmail.com


On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] <
ml-node+s1045719n5792600...@n5.nabble.com> wrote:

> Hi Manoj,
>
> Maybe what you are try to say,  you want to export your generated report
> arranged by barcode? Am I right?
>
> In that case you may edit your data through excel.
>
> *Steps*
>
> Step 1
>
> Highlight the whole column of the "barcode"
>
> Step 2
>
> click cnrt+H
>
> Step 3
>
> Find what = A
> Replace with = *note leave it blank
>
> click Replace All
>
> (so that you can remove the "A" symbol)
>
> Step 4
>
> Go to *Data* and sort your column to A - Z
>
> Step 5
>
> Make a new column beside the barcode column
>
> then type ="A"&(the column with the number 1) then press enter
>
> and then drag the formula to put A back
>
> Regards,
>
> - Jerwyn
>
>
>
>
>
>
>
>
>
> On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 <[hidden 
> email]>wrote:
>
>
> > Dear Friends,
> > I have used alphabets in barcode numerbers for different item types, now
> > when i have generated the accession register sorted by barcode it sort
> like
> > A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.
> >
> > Please help!
> >
> >
> > Manoj Kumar Misra
> >
> >
> >
> > --
> > View this message in context:
> >
> http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.html
> > Sent from the Koha-general mailing list archive at Nabble.com.
> > ___
> > Koha mailing list  http://koha-community.org
> > [hidden email] 
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
> --
> Jerwyn G. Fernadez
> Basic Education Librarian
> Southville International School and Colleges
> ___
> Koha mailing list  http://koha-community.org
> [hidden email] 
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> --
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p5792600.html
>  To unsubscribe from Sorting of accession numbers, click 
> here
> .
> NAML
>




--
View this message in context: 
http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p5792647.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Access Koha without port number

[Doug Dearden]

Hello,

Try pointing your browser at http://library.koha.shelf.books without any port 
number.  That should bring up the same page as with port number 80 .  Port 80 
is the default for http .

For your staff client you can create a different IP address, then change your 
apache configuration file so it is only listening on that address and on the 
default port 80.  For instance, you might have something like:

# OPAC

...

# Intranet

...

Substituting the correct IP addresses for your network in the above statements.

You would also need to add entries to your ports.conf or similar file to 
reflect the changes.
 
You then have to configure DNS settings to point the names to the different IP 
addresses.  For instance:
opac.library.koha.shelf.books 10.0.0.20
intranet.library.koha.shelf.books 10.0.0.21

Restart apache, and you should be able to access the OPAC and staff client 
using the form http://opac.library.koha.shelf.books and 
http://intranet.library.koha.shelf.books 

Hope that helps.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Chrispin 
Simasiku Sitali
Sent: Wednesday, April 02, 2014 10:22 AM
To: koha-user
Subject: [Koha] Access Koha without port number

Greetings to all,

I need help on how I can set up Koha without port number. Normally I access
my Koha installation using: xxx.xxx.xxx.xxx:80 or
library.koha.shelf.books:80 or :81 for staff client or opac

I future I dont want to use port numbers after  ip addresses or fqdn

Please help

Sitali Chrispin Simasku



-- 
Charles Lwanga College of Education,
P. O. Box 660193,
Monze,
ZAMBIA.

Mobile: +26 0979 869471
+26 0966 869471
SKYPE: Libsitali
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Errors during migration

[Doug Dearden]

Hello all,

I am migrating our installation to a new server, moving from version 3.14.03 to 
3.16.0.  During a test run I got the following errors during the update.  Do I 
have to be concerned about these?  If so, any idea what to do?

Thanks in advance.

[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: [Fri May 30 16:09:04 2014] updatedatabase.pl: DBD::mysql::db 
do failed: Duplicate key name 'surname_idx' at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
7841., referer: http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl
[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: , referer: 
http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl
[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: [Fri May 30 16:09:05 2014] updatedatabase.pl: DBD::mysql::db 
do failed: Unknown column 'ctId' in 'collections_tracking' at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
7863., referer: http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl
[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: , referer: 
http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl
[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: [Fri May 30 16:09:05 2014] updatedatabase.pl: DBD::mysql::db 
do failed: Can't DROP 'marc'; check that column/key exists at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
7881., referer: http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl
[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: , referer: 
http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl
[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: [Fri May 30 16:09:09 2014] updatedatabase.pl: DBD::mysql::db 
do failed: BLOB/TEXT column 'issn' used in key specification without a key 
length at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
8420., referer: http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl
[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: , referer: 
http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl
[Fri May 30 16:09:09 2014] [error] [client 192.168.30.196] [Fri May 30 16:09:09 
2014] install.pl: [Fri May 30 16:09:09 2014] updatedatabase.pl: DBD::mysql::db 
do failed: Incorrect prefix key; the used key part isn't a string, the used 
length is longer than the key part, or the storage engine doesn't support 
unique prefix keys at 
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
8424., referer: http://192.168.30.13:8080/cgi-bin/koha/installer/install.pl

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] After upgrading to 3.16 only get Apache "It Works" page

[Doug Dearden]

Hi Marty,

This probably has something to do with your Apache config.  First, just because 
it might work do "sudo apache2ctl restart" .  That will restart the apache 
server and load all the configs. If that doesn't fix it, then look at 
/etc/apache2/sites-enabled .  You should have a symlink pointing to all the 
sites that you have enabled .  If the only one in there is 000-default then you 
haven't enabled any of your apache sites.  The Debian site has this info about 
that: 
http://www.debian-administration.org/article/207/Maintaining_apache2_sites_and_modules_lists
 .

If you originally did a package install, then this wiki page might help, it 
also has info about enabling the sites:   
http://wiki.koha-community.org/wiki/Koha_3.x_on_Debian_Squeeze .  

Also, how are you connecting to your server.  Using an IP address or a DNS 
name?  Think about how you are connecting to the server, if DNS name how is 
that getting resolved?  Is it really pointing to the apache site that has Koha 
on it, or to the default?  If you can ascertain which IP address Koha is 
listening on then try connecting directly to that.

Hope that helps.

Doug


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Marty
Sent: Sunday, August 10, 2014 8:47 AM
To: koha koha
Subject: [Koha] After upgrading to 3.16 only get Apache "It Works" page

Running on Debian Wheezy it all worked fine until I upgraded.

I did have the same issue before with the previous release but I cannot 
remember how I solved it  or find the link that solved it anymore. Any help 
would be appreciated, but just a link to the solution will do fine, thanks!

Marty
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Regarding Hosting of Library OPAC on Internet using Amazon Web Services

[Doug Dearden]

Hi Sahaddeo,

If you don't need the default site running, how about just doing:
sudo a2dissite default
sudo apache2ctl restart

That disables the default site and restarts apache.

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Sahadeo Taware
Sent: Friday, January 9, 2015 3:28 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Regarding Hosting of Library OPAC on Internet using Amazon Web 
Services

Dear Members



I want to host our library OPAC on Internet for that I am using Amazon Web 
Services (AWS). I have install koha on Ubuntu 14.04 server successfully on AWS.


I am running successfully on putty programme.

In putty I used the site http://library.myDNSname.org:8080 
 for Staff Interface

& http://library.myDNSname.org:80  for Library 
Opac



 But when I used the browser (chrome or firefox)

with public IP with port no. It display the default webpage of apache.
(Please see the attachment)

It doesn’t display the staff interface as well as kohaopac page.



 I have tried many time but it not work. Please guide me solve the problem.



I have use the following configuration for the files







   1. *Koha-sites.conf*



#Apache virtual hosts creation variables

DOMAIN=".myDNSname.org"

INTRAPORT="8080"

INTRAPREFIX=""

INTRASUFFIX=""

OPACPORT="80"

OPACPREFIX=""

OPACSUFFIX=""



# SQL file to load into new instances

DEFAULTSQL=""



# Zebra global configuration variables

ZEBRA_MARC_FORMAT="marc21"  # or normarc or unimarc.

ZEBRA_LANGUAGE="en" # match with installation language

# (e.g. es for Spanish)

BIBLIOS_INDEXING_MODE="dom"

AUTHORITIES_INDEXING_MODE="dom"



# Memcached global configuration variables

USE_MEMCACHED="no"

MEMCACHED_SERVERS="127.0.0.1:11211"

MEMCACHED_PREFIX="koha_"



*2. ports.conf*



# If you just change the port or add more ports here, you will likely also

# have to change the VirtualHost statement in

# /etc/apache2/sites-enabled/000-default.conf



Listen 80

Listen 8080





Listen 443







Listen 443





# vim: syntax=apache ts=4 sw=4 sts=4 sr noet



*3./etc/hosts*



127.0.0.1 localhost

127.0.0.1 library.myDNSname.org

127.0.0.1 library-intra.myDNSname.org



# The following lines are desirable for IPv6 capable hosts

::1 ip6-localhost ip6-loopback

fe00::0 ip6-localnet

ff00::0 ip6-mcastprefix

ff02::1 ip6-allnodes

ff02::2 ip6-allrouters

ff02::3 ip6-allhosts



*4.library.conf*



# Koha instance library Apache config.



# OPAC



   Include /etc/koha/apache-shared.conf

#  Include /etc/koha/apache-shared-disable.conf

   Include /etc/koha/apache-shared-opac.conf



   ServerName library.myDNSname.org

   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/opac-error.log

#  TransferLog /var/log/koha/library/opac-access.log

#  RewriteLog  /var/log/koha/library/opac-rewrite.log





# Intranet



   Include /etc/koha/apache-shared.conf

#  Include /etc/koha/apache-shared-disable.conf

   Include /etc/koha/apache-shared-intranet.conf



   ServerName library-intra.myDNSname.org

   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





*Kindly help me to solve the problem*







--
Sahadeo D. Taware
Librarian, M.L.I.Sc., NET
Thakur College of Science and Commerce
Thakur Village, Kandivli(E), Mumbai 400101 Mob. No 9324912816 Office 28870627 
Extn. 126 ___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Troubleshoot file not found (856$u)

[Doug Dearden]

How did you install Koha.  From tarball, or did you use the packages?  What 
distribution are you installed on, Debian? Ubuntu? Something else?

Doug

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of 
Gopalakrishna-BMSIT
Sent: Friday, January 30, 2015 11:00 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Troubleshoot file not found (856$u)

I would like to load files in the folder /home/User/Downloads using the field 
856$u.  How to do it.

Thanks
Gopalakrishna
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Troubleshoot file not found (856$u)

[Doug Dearden]

Gopalakrishna,

/home/user/Downloads is not in a location that is accessible from the Apache 
web server.  On a default package install on Debian the document root for the 
OPAC is /usr/share/koha/opac/htdocs , and the document root for the staff 
client is /usr/share/koha/intranet/htdocs.  I believe it is the same on Ubuntu. 
 There are different ways to make files accessible via the url.  One is to 
create a directory in one of these locations, put the files there and then just 
point to them.  For instance if your server is at http://mylibrary.mydomain.com 
you create the directory /usr/share/koha/opac/htdocs/myfiles , and put the file 
test.pdf in there.  The url http://mylibrary.mydomain.com/myfiles/test.pdf 
should point to that file.

To use /home/user/Downloads you can use a symbolic link instead.  You put your 
files in /home/user/Downloads.  Instead of making the myfiles directory, you 
make a symbolic link from the OPAC document root:
ln –s /home/user/Downloads /usr/share/koha/opac/htdocs/myfiles

You put the file test.pdf into /home/user/Downloads .  The url 
http://mylibrary.mydomain.com/myfiles/test.pdf should point to the file the 
same as above.  The advantage to this method is you can give a limited user the 
ability to put files into /home/user/Downloads without ever having to see 
unneeded parts of the file structure.

Another trick that Galen Charlton pointed out to me was using the Apache 
redirect directive.  Instead of putting the full url into the 856u field, you 
can use a placeholder that Apache reinterprets into the full url.  If sometime 
in the future you run out of space for these files, you can move them to 
another server and just change the redirect reference in the Apache config 
file.  For instance, in our example you would use:
Redirect /filelocation http://mylibrary.mydomain.com/myfiles
The url you put into the 856u field would be /filelocation/test.pdf.  If you 
later move your files to a different server, rather than having to edit all of 
the 856u fields, you can simply change the Redirect directive to something else 
like:
Redirect /filelocation http://biggerserver.mydomain.com/myfiles

Best,

Doug



From: Gopalakrishna-BMSIT [mailto:gk.bm...@gmail.com]
Sent: Tuesday, February 3, 2015 9:49 PM
To: Doug Dearden
Subject: Re: [Koha] Troubleshoot file not found (856$u)

Dear Doug,
I have installed koha using packages on Ubuntu 12.04, also on Debian Squeezy on 
another system.
Regards,
Gopalakrishna

With Regards,
Gopalakrishna
Librarian,
B.M.S Institute of Technology,
Avalahalli, Doddaballapur Main Road,
Yelahanka, Bangalore-64
Ph: 080-65369469
Mob.: 97418 98674

On Mon, Feb 2, 2015 at 10:28 PM, Doug Dearden 
mailto:dear...@sarsf.org>> wrote:
How did you install Koha.  From tarball, or did you use the packages?  What 
distribution are you installed on, Debian? Ubuntu? Something else?

Doug

-Original Message-
From: Koha 
[mailto:koha-boun...@lists.katipo.co.nz<mailto:koha-boun...@lists.katipo.co.nz>]
 On Behalf Of Gopalakrishna-BMSIT
Sent: Friday, January 30, 2015 11:00 PM
To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>
Subject: [Koha] Troubleshoot file not found (856$u)

I would like to load files in the folder /home/User/Downloads using the field 
856$u.  How to do it.

Thanks
Gopalakrishna
___
Koha mailing list  http://koha-community.org 
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> 
http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unable to login

[Doug Dearden]

Ajesh,

This looks like a DNS issue to me.  Can you ping mykoha.org?  If not then you 
probably don't have this name pointing to the IP address of the server.

However, I would encourage you to abandon the idea of using Koha 2.2.9 on 
Windows, and install the latest stable release on Linux (or wait a few days and 
install version 3.4 when it is released).  I don't believe the 2.2.x branch is 
being updated in any way.  To keep up with bug fixes and enhancements, you 
really want to be on the version the Koha community is contributing to.  If 
this is a test box you are setting up then you could download the latest stable 
release now - version 3.2.7 available at  http://download.koha-community.org/ , 
then update to the 3.4 release later after you are comfortable with Koha on 
Linux.

Best,

Doug 

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of aj...@maxenna.com
Sent: Wednesday, April 20, 2011 2:25 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Unable to login

Hi,

 I have installed Koha 2.2.9 on Windows XP.

 Now, I am trying to login to Koha as admin using the below link
   http://www.mykoha.org:8080
or
   http://www.mykoha.org:8080/cgi-bin/koha/mainpage.pl

 But I am getting the below error message:
*
The connection has timed out

The server at www.mykoha.org is taking too long to respond.

  The site could be temporarily unavailable or too busy. Try again in a few
moments.
  If you are unable to load any pages, check your computer's network
connection.
  If your computer or network is protected by a firewall or proxy, make
sure that Firefox is permitted to access the Web.
*

 Firewall is not turned on and the computer's network connection is ok.

 However I see that I am able to login successfully as a user at
  http://localhost
or
  http://localhost/cgi-bin/koha/opac-user.pl

 Please let me know how to solve this issue.

OS: Windows XP
Mozilla
ActivePerl 5.8.9 Build 829
Apache 2.0.64
MySql Server 5.1

Thanks & Regards
Ajesh

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Zebra errors

[Doug Dearden]

Tom,

Are you starting your zebrasrv per the INSTALL. file, with the correct 
options?

For instance the INSTALL.debian one is something like:

sudo -u  -f 

You also want to have all of the zebra related directories owned by your koha 
user, and make sure you export the PERL5LIB and KOHA_CONF variables too.

I had a hard time getting zebra working, and it was all related to file 
permissions.  I don't have specifics for you there, I just remember I had to go 
back and make sure all the zebra related stuff had the koha user as owner.

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Tom Hanstra
Sent: Wednesday, April 27, 2011 9:52 AM
To: Koha listserv
Subject: [Koha] Zebra errors

I've successfully got indexing working without Zebra so now I'm trying 
to configure with Zebra.

I think I have Zebra installed (placed in my own /shared/zebra 
directory) and I ran the rebuild_zebra.pl and got resulting files:

./var/lib/zebradb/biblios/register
./var/lib/zebradb/biblios/register/isambA-0.mf
./var/lib/zebradb/biblios/register/isambC-0.mf
./var/lib/zebradb/biblios/register/isambD-0.mf
./var/lib/zebradb/biblios/register/recdA-0.mf
./var/lib/zebradb/biblios/register/gmatch-0.mf
./var/lib/zebradb/biblios/register/isambB-0.mf
./var/lib/zebradb/biblios/register/dict-0.mf
./var/lib/zebradb/biblios/register/reci-0.mf

And the zebrasrv starts and looks like it is running.

But, with searches now using the Zebra indexes, I get an ERROR 109 from 
zebrasrv:

11:30:34-27/04 zebrasrv(4) [request] Search biblios ERROR 109 1 1+0 RPN 
@attrset Bib-1 @not @or @or @attr 1=1003 @attr 4=1 @attr 6=3 @attr 9=32 
@attr 2=102 "twain, mark" @attr 1=1003 @attr 4=1 @attr 9=26 @attr 2=102 
"twain, mark" @attr 1=1003 @attr 5=1 @attr 4=6 @attr 9=26 @attr 2=102 
"twain, mark" @attr 1=9011 1

What is ERROR 109?  How can I track down what might be still missing?

Thanks,
Tom

-- 


-
  Tom Hanstra  Systems Administrator
  Hesburgh Libraries of Notre Dame Phone: (574)631-4686
  213 Hesburgh Library Email: t...@nd.edu
  Notre Dame, IN  46556

Any idiot can face a crisis, it is this day-to-day living that wears
you out.
 Anton Chekhov
-

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] DO i have to have zebra to search for Item under KOHA?

[Doug Dearden]

Yes, you should have zebra properly configured and running.  See the 
INSTALL. file for instructions on getting zebra up and running.  Also, 
there is an FAQ on the website regarding searching: 
http://koha-community.org/documentation/faq/searching/ 

In addition make sure that you don't have the NoZebra option set to Don't Use 
(this is deprecated, so even if it is an option you should get zebra running 
correctly).

The stumbling block for me when I set this up was making sure the user that I 
was starting zebrasrv under had permissions to all the necessary files.

Make sure you follow the INSTALL. instructions for getting a cron job 
set up to automatically run the rebuild_zebra.pl script also.

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of uknet80
Sent: Sunday, May 15, 2011 1:02 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] DO i have to have zebra to search for Item under KOHA?

Dear experts,

after installing KOHA, I added several records, but when i try searching for
record I get no results (book not found).  Do I have to have zebra search
engine to search for item under KOHA, or zebra's job is just to speed search
query?

I have sent several question on this site, no one ready to give an answer,
can anyone help please.

thanks

--
View this message in context: 
http://koha.1045719.n5.nabble.com/DO-i-have-to-have-zebra-to-search-for-Item-under-KOHA-tp4397229p4397229.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Zebra: to daemon, or not to daemon

[Doug Dearden]

Hello all,

The FAQ regarding searching found here: 
http://koha-community.org/documentation/faq/searching/  contains the following 
caution:

4. Be sure you are *not* running the zebraqueue daemon. Currently this
daemon has major problems and the recommended method of indexing is to
run rebuild_zebra.pl as a cron job. Running both causes more problems.

Is this still true with the latest 3.4.1 release?
(Another post in this list made me wonder).

Thanks,

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] cover images in koha

[Doug Dearden]

Caitlin,

See bug 5738 for a new feature in the 3.4 release that allows you to display 
the links in the 856$u fields as images.  If you scan your cover images as jpg 
(or any other image type file), you can put the link to the file in the 856$u 
field, and indicate with a valid mime type in the 856$q field that you want 
this particular file displayed as an image.  You have to turn on the 
appropriate xslt display options, and  set the OPACDisplay856uAsImage and/or 
the Display856uAsImage system preferences.  With all of that turned on, your 
scanned images appear.

One note, the system preferences default to "Both", but don't seem to be 
actually turned on to that option until you switch to another option, save, 
then switch back to "Both".

Also, see this thread where Joe Atzberger gave me some great tips on using the 
Apache "Redirect" to create the links to these images in a generic fashion so 
they can be moved in the future to another server.
http://koha.1045719.n5.nabble.com/URI-field-link-options-td3056466.html

Best,

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org



From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Caitlin McGurk
Sent: Wednesday, June 01, 2011 11:37 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] cover images in koha

Hey all-

Is there anyway to upload cover images for each book into Koha? We're currently 
importing covers from Amazon for our books with ISBNS. However, we're hoping to 
create records for our student work (comic books) and would like to scan and 
add these covers to be displayed in the record as well.

Any ideas?

CM

--
Caitlin McGurk
Librarian
The Schulz Library
The Center for Cartoon Studies<http://www.cartoonstudies.org>
mcg...@cartoonstudies.org<mailto:mcg...@cartoonstudies.org>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Field 856 not visible on opac

[Doug Dearden]

Daniel,

Try changing the 856$u entry to http://www.wgsn.com/content/section/home.html .

Also, do you have the XSLT preferences turned on?  I think the display you want 
may only work if those are on.  See the system preferences - OPAC area.  

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of schwitzd
Sent: Thursday, June 09, 2011 6:57 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Field 856 not visible on opac

Hi Nicole
Yes is in the biblio record, the marc view in the opac says this:

WGSN (Record no. 47)
000 -LEADER 
fixed length control field 00313nam a22001217a 4500 
003 - CONTROL NUMBER IDENTIFIER 
control field OSt 
005 - DATE AND TIME OF LATEST TRANSACTION 
control field 20110609134307.0 
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION 
fixed length control field 110609t xxu|  00| 0 eng d 
040 ## - CATALOGING SOURCE 
Transcribing agency 0 
245 ## - TITLE STATEMENT 
Title WGSN 
856 ## - ELECTRONIC LOCATION AND ACCESS 
Uniform Resource Identifier www.wgsn.com/content/section/home.html 
Link text WGSN Home Page 
Materials specified WGSN Home Page 
Public note WGSN Home Page 
942 ## - ADDED ENTRY ELEMENTS (KOHA) 
Source of classification or shelving scheme  
Koha item type Multimedia 

No copies available.

But there isn't a link... I means this:

http://koha.1045719.n5.nabble.com/file/n4472594/Online.png 


--
View this message in context: 
http://koha.1045719.n5.nabble.com/Field-856-not-visible-on-opac-tp4472424p4472594.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Brand new koha installation

[Doug Dearden]

Robert,

There is a great tool called MarcEdit available here: 
http://people.oregonstate.edu/~reeset/marcedit/html/index.php .

It will help you take whatever export you can get from your database and make 
it as MARC like as possible.  You can map your current fields into the 
appropriate MARC fields, insert defaults, etc.  Once you have all of your data 
in MARC format, you can then import it into Koha using one of the import tools.

Best,

Doug  

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of libhunter
Sent: Thursday, June 09, 2011 10:53 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Brand new koha installation

Hi all,

First of all, I would like to say I am a complete beginner on these forums
and also with koha itself.

I have been tasked with setting up a brand new koha installation. I am
wondering what is the best way to migrate my data from an in-house custom
database to the newly installed koha application. 

I was thinking to export from the databse, to MARC format and do a bulk
import of the records. I was also considering just running the import off
the ISBN numbers and performing some data cleansing by looking up the MARC
details using some cataloging service. Maybe I am being naive.

I would appreciate any helpful direction in order to set me off on the
correct path from the outset.

Many thanks,
Robert

--
View this message in context: 
http://koha.1045719.n5.nabble.com/Brand-new-koha-installation-tp4473428p4473428.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Migrating data from ABCD to Koha

[Doug Dearden]

Hello Admire,

Koha stores the data in MARC format, either MARC21 or UNIMARC, so you need to 
convert the data to that format in order to import it into Koha.

There is a free tool called MarcEdit that can help with this, it is available 
here: http://people.oregonstate.edu/~reeset/marcedit/html/index.php .

Hope that helps.

Doug

From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of amutsikiwa
Sent: Friday, June 17, 2011 12:50 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Migrating data from ABCD to Koha

Hi

There is an institution in Zimbabwe that have been using ABCD but are having 
challenges with the system. They are now contemplating going the koha root. 
However, they want their  bibliographic records to be migrated to Koha. They 
are saying they are not using  MARC format in their ABCD. Any idea on how to do 
the migration.

Regards,
Admire Mutsikiwa
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] newbie: items from Follet export

[Doug Dearden]

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Nigel Barker
Sent: Wednesday, June 29, 2011 8:41 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] newbie: items from Follet export

Dear All,

I am the IT teacher at a very small school. For several years we have
been running debian-edu/skolelinux on our servers and workstations. So
when the librarian (who is a part-time volunteer and doesn't know
anything about library systems) told me the ageing Follet system would
no longer allow her to add books, I naturally turned to Koha. I have a
test instance  running, and I can bulkmarcimport.pl the marc records
exported from Follet.

So here is my question:
Although the marc export from Follet had the "include copy info" box
checked, and I can see the barcodes in the microlif.001 file, the
catalogue on Koha has no items available for any record, and there are
no barcodes showing.
I am hoping someone with Follet migration experience will know what I
have to do.

Thanks!
-- 
nigel
Hiroshima International School
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Hi Nigel,

Follett puts item info in the 852 subfields.  Koha expects item info in the 952 
subfields.  MarcEdit can help you migrate the data  
(http://people.oregonstate.edu/~reeset/marcedit/html/index.php) .  MarcEdit has 
the ability to generate a Windows VB script, I took one and modified it to move 
our item info when we converted, you can find it here: 
http://contribs.koha.org/revision_view.php?rid=16 .  This is on the liblime 
site, I'm not sure why we don't have a contribs section on the koha-community 
site yet.  Anyway, have a look at that, I think it will do the trick.

Best,

Doug   
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Multiple opac on koha

[Doug Dearden]

Try this page from the wiki.
http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha 

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of lychnhi
Sent: Friday, July 22, 2011 4:43 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Multiple opac on koha

I want to build 2 opac on koha. anyone know how to make? please help me.
thanks

--
View this message in context: 
http://koha.1045719.n5.nabble.com/Multiple-opac-on-koha-tp4622620p4622620.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unable to save marc record

[Doug Dearden]

Hi Sheldon,

It sounds like your mysql engine isn't started.  Try /etc/init.d/mysql start 

And put a UPS on that server, don't leave yourself susceptible to power outages.

Hope that works.

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of sheldon_tappin
Sent: Thursday, August 11, 2011 6:57 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Unable to save marc record

Hi All,

 Recently we developed a problem whilst trying to enter bibliographic
records into koha. 
All along, the data-entry process was going fine until we got a power
outage. The systems shutdown immediately. When the electricity was back on,
we attempted to enter bibliographic records into the  system but we
couldn't. Whenever we try save a record the following error message showed: 


*Koha error*

The following fatal error has occurred:

Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) at /usr/share/koha/lib/C4/Context.pm line
666.


Can anyone tell me how to resolve this issue so that we can resume our
data-entry process. We are hoping to commence our online service soon, and
without the  following error fixed we cannot move forward.



Regards,
Sheldon
Asst Systems Librarian

--
View this message in context: 
http://koha.1045719.n5.nabble.com/Unable-to-save-marc-record-tp4689428p4689428.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Can't call method "id" on an undefined value at InstallAuth.pm line 278

[Doug Dearden]

Tanzeem,

Check out this link, I think it has your answer:

http://koha.1045719.n5.nabble.com/Installation-error-can-t-configure-td3057378.html
 

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of tanzeem
Sent: Wednesday, January 04, 2012 11:19 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Can't call method "id" on an undefined value at InstallAuth.pm 
line 278

Hi
I am installing Koha 3.2 on debian squeeze . I came across the following
error using the web
installer(http://127.0.1.1:8080/cgi-bin/koha/installer/install.pl)


Software error:

Can't call method "id" on an undefined value at InstallAuth.pm line 278.

Please help...


--
View this message in context: 
http://koha.1045719.n5.nabble.com/Can-t-call-method-id-on-an-undefined-value-at-InstallAuth-pm-line-278-tp5121873p5121873.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] How or maybe where are relevance rankings established?

[Doug Dearden]

Hello All,

I am trying to get a grip on how a search is ordered when "relevance" is 
specified.  Is there a place in the staff client where these results are 
controlled - i.e. which fields are given weight?

Or perhaps the question is where would I find the algorithm that is being used 
- assuming it is hard coded somewhere?

The "about" info pasted below my name in the event an update will make a 
difference here.

Thanks for the help,

Doug Dearden
Director, IT
School for Advanced Research
(505)954-7220
sarweb.org


Server information Koha version: 3.04.01.000 OS version ('uname -a'): Linux 
SAR75Linux 2.6.32-5-686 #1 SMP Tue Mar 8 21:36:00 UTC 2011 i686 GNU/Linux Perl 
interpreter: /usr/bin/perl Perl version: 5.010001 Perl @INC: 
/home/koha/koha-3.4.1
/etc/perl
/usr/local/lib/perl/5.10.1
/usr/local/share/perl/5.10.1
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.10
/usr/share/perl/5.10
/usr/local/lib/site_perl
.
MySQL version: mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) 
using readline 6.1 Apache version: Server version: Apache/2.2.16 (Debian) Zebra 
version: Zebra 2.0.47 (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: 
e4e44d1916c6e80e01aad163b487ee41c22272ba Using ICU
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How or maybe where are relevance rankings established?

[Doug Dearden]

Thanks Mason, you've put me on the yellow brick road.

I've looked at several config files in the /zebradb subdirectory, and am 
now surrounded by the flying monkeys. :)

Best,

Doug

-Original Message-
From: Mason James [mailto:m...@kohaaloha.com] 
Sent: Monday, January 30, 2012 6:50 PM
To: Doug Dearden
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] How or maybe where are relevance rankings established?


On 2012-01-31, at 12:44 PM, Doug Dearden wrote:

> Hello All,
> 
> I am trying to get a grip on how a search is ordered when "relevance" is 
> specified.  Is there a place in the staff client where these results are 
> controlled - i.e. which fields are given weight?


afaik, the relevance is determined in zebra, internally


here's some doc..

http://www.indexdata.com/zebra/doc/administration-ranking.html
http://www.indexdata.com/zebra/doc/querymodel-zebra.html

> 
> Or perhaps the question is where would I find the algorithm that is being 
> used - assuming it is hard coded somewhere?


> 
> The "about" info pasted below my name in the event an update will make a 
> difference here.

yes indeed, good thinking :)



___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How or maybe where are relevance rankings established?

[Doug Dearden]

Hi Ian,

Thanks for the info.  Your comment that “exact matches in the title field are 
most relevant (in keyword searches, at least), then partial title matches, then 
regular matches” is the behavior that I expected, but doesn’t seem to always 
hold true.  If you go to our public catalog at http://library.sarsf.org  and do 
a Title search on “coming of age” (without the quotes), there are four hits 
returned, all of which have the phrase in either the Title or the Remainder of 
Title field.  If you do the same search as a Keyword search, the returned list 
is topped by an item that has the phrase “coming of age” in the Summary, Etc. 
field (520a).  The four hits that get returned when doing a Title search appear 
in positions 2, 4, 5, and 9.  We would like to get the books that have the 
exact phrase in the title at the top of the list.

Looking at the code in Search.pm it does look like it is trying to weight for 
title, but I also traced the system preferences it is calling at the beginning 
of the subroutine and they all say “REQUIRES ZEBRA” on them.  So I assume any 
final tweaking would include both zebra config and perhaps refining what is 
going on in the subroutine in Search.pm.

None of the above am I up to right now. ;)  We will live with things as they 
are.

Again thanks for the response.

Best,

Doug



From: Ian Walls [mailto:koha.sek...@gmail.com]
Sent: Wednesday, February 01, 2012 4:29 AM
To: Doug Dearden
Subject: Re: [Koha] How or maybe where are relevance rankings established?

Doug,


Relevancy weighting is determined in C4/Search.pm.  It's pretty complex, and 
not as rich as one might think.  The basic truth is that exact matches in the 
title field are most relevant (in keyword searches, at least), then partial 
title matches, then regular matches.  I'm simplifying quite a bit, but things 
like author matches or "newness" of publication year don't factor in.

The exact code  starts currently around line 757, in the internal subroutine 
_build_weighted_query().

Cheers,


-Ian
On Tue, Jan 31, 2012 at 11:57, Doug Dearden 
mailto:dear...@sarsf.org>> wrote:
Thanks Mason, you've put me on the yellow brick road.

I've looked at several config files in the /zebradb subdirectory, and am 
now surrounded by the flying monkeys. :)

Best,

Doug

-Original Message-
From: Mason James [mailto:m...@kohaaloha.com<mailto:m...@kohaaloha.com>]
Sent: Monday, January 30, 2012 6:50 PM
To: Doug Dearden
Cc: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>
Subject: Re: [Koha] How or maybe where are relevance rankings established?


On 2012-01-31, at 12:44 PM, Doug Dearden wrote:

> Hello All,
>
> I am trying to get a grip on how a search is ordered when "relevance" is 
> specified.  Is there a place in the staff client where these results are 
> controlled - i.e. which fields are given weight?

afaik, the relevance is determined in zebra, internally


here's some doc..

http://www.indexdata.com/zebra/doc/administration-ranking.html
http://www.indexdata.com/zebra/doc/querymodel-zebra.html

>
> Or perhaps the question is where would I find the algorithm that is being 
> used - assuming it is hard coded somewhere?


>
> The "about" info pasted below my name in the event an update will make a 
> difference here.
yes indeed, good thinking :)



___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Z39.50 pop-up box

[Doug Dearden]

Paul,

To restart Koha without restarting the server itself, I think you just restart 
Apache.

Sudo apache2ctl restart 

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Paul
Sent: Monday, February 06, 2012 9:44 AM
To: Garry Collum; koha@lists.katipo.co.nz
Subject: Re: [Koha] Z39.50 pop-up box

At 06:39 PM 2/5/2012 -0500, Garry Collum wrote:
>Ah!  My offlist reply was unintentional.  There is also an instance of the 
>PopupZ3950 function in addbiblio.tt.
>
>~/koha-tmpl/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tt

Many thanks Garry.  For the record in 3.6.1 it is at 
/usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/cataloguing/addbiblio.tt

One question remains from my original query:  Is there a quick CLI command 
to restart Koha without rebooting the server?

The .tt didn't need it, but the .inc did (maybe a quirk of my install of 
memcached.)

Again tnx and br,
Paul 

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problem with MARC View in OPAC Display

[Doug Dearden]

Hi Vimal,

Check out this section of the documentation: 
http://manual.koha-community.org/3.6/en/catadmin.html#marcbibframeworks 

Look at sub section 4.1.4 Edit Framework Subfields, and in particular the field 
labeled "hidden".  If you have a value in there greater than 0, it will cause 
the field to be hidden on the OPAC.

I suspect that may be the problem.

Best,

Doug  

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Vimal Kumar
Sent: Wednesday, February 15, 2012 10:00 AM
To: Koha-List; Zeno Tajoli
Subject: Re: [Koha] Problem with MARC View in OPAC Display

Dear Friends,

I followed the way suggested by Zeno Tajoli,

-- open in catalogiung one of the records with the problem
-- Chnage framework from your to 'Default'
-- Save the record
-- Go to Opac and see the result.

Now it works.
I think the problem with the BKS framework i customized.
What may be the problem?
Manual Cataloguing using Default Framework is not practical.
We want to customize to display necessary fields.

Regards,
-- 
Vimal Kumar V.
Mahatma Gandhi University Library
Kottayam, Kerala- 686 560
Web: http://www.vimalkumar.org
Blog: http://linuxhalwa.blogspot.com
---
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Issue - book cover

[Doug Dearden]

Vipul,

Check this out:

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1633 

Function added.  Pushed to Master, you may not have it available on your 
release depending on what version you have installed.

Best,

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of vipul
Sent: Friday, March 09, 2012 11:19 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Issue - book cover

I would like to ask you again that If we don't get any book cover from 
Amazon.com or Google jacket then can we put our own scanned book covers and 
What is the method for the same?

Looking forward for your reply.

Regards

Vipul

Library Incharge
Fountainhead School-Surat

--
View this message in context: 
http://koha.1045719.n5.nabble.com/Issue-book-cover-tp5552350p5552350.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Public access

[Doug Dearden]

Hi Paul,

Take a look at your koha-httpd.conf file.  This can be in a different location 
depending on what type of install picked.  As your staff client is working, 
this file is being read by apache, so hopefully you know where it is.  If you 
don't you can find it by going to the command line and entering "cd /", then 
"find -name koha-httpd.conf" .  You may need to put "sudo" in front of those 
commands.  I am used to doing all this while logged in as root, I'm not sure 
what kind of access you have on Amazon.  Anyway, look in that file, as it is 
probably something with your virtual host declarations that needs to be 
tweaked.  Also look at the INSTALL.debian file in your koha directory, and 
check the section under configuring apache.  Make sure you have the right 
entries in your /etc/apache2/ports.conf file.  If you can't figure it out paste 
your koha-httpd.conf file here for more help.

Best,

Doug 

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Paul Orkiszewski
Sent: Wednesday, April 04, 2012 12:37 PM
To: koha@lists.katipo.co.nz
Subject: [Koha] Public access

I can access the staff interface on an installation of 3.06 I've put on 
an instance of Debian Squeeze in Amazon:

http://ec2-23-20-95-197.compute-1.amazonaws.com:8080

but I can't figure out how to get into the public interface.  My guess 
is that it's something in the apache config files, but I don't know 
where to look.

Help?

Paul


-- 


*Paul Orkiszewski*
Coordinator of Library Technology Services / Associate Professor
University Library
Appalachian State University
218 College Street
P.O. Box 32026
Boone, NC 28608-2026

E-mail: orkiszews...@appstate.edu
Phone: 828 262 6588
Fax: 828 262 2797

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Digest, Vol 82, Issue 20

[Doug Dearden]

Hi Joel,

>From the command line do "df -h" .

It will show you the disk space used and what remains on each partition.

You are probably out of disk space.

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] 
On Behalf Of Joel Buleka
Sent: Monday, August 13, 2012 4:23 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha Digest, Vol 82, Issue 20

Hi

We have Koha 2.2.9 running on Fedora 5, recently the MySQL database is
not starting up and the server is giving us no disk space error.






-Original Message-
From: koha-boun...@lists.katipo.co.nz
[mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
koha-requ...@lists.katipo.co.nz
Sent: Tuesday, August 14, 2012 8:16 AM
To: koha@lists.katipo.co.nz
Subject: Koha Digest, Vol 82, Issue 20

Send Koha mailing list submissions to
koha@lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-requ...@lists.katipo.co.nz

You can reach the person managing the list at
koha-ow...@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: Suggestion on Amazon wish-list look-ups (Liz Rea)
   2. Re: Question on Z39.50 cross-format queries (Manos Petridis)
   3. Why are our borrowers being restricted? (Tim Hannah)
   4. help for debian partition for koha (ramverma)
   5. Re: Why are our borrowers being restricted? (Jared Camins-Esakov)
   6. Re: Why are our borrowers being restricted? (Chris Cormack)
   7. Re: Why are our borrowers being restricted? (Tim Hannah)


--

Message: 1
Date: Mon, 13 Aug 2012 09:22:13 -0500
From: Liz Rea 
To: Manos Petridis 
Cc: "koha@lists.katipo.co.nz" 
Subject: Re: [Koha] Suggestion on Amazon wish-list look-ups
Message-ID:


Content-Type: text/plain; charset=UTF-8

I added this as an enhancement request to bugs.koha-community.org - bug
8631.

Thanks for your idea!

Liz Rea
NEKLS

On Mon, Aug 13, 2012 at 2:10 AM, Manos Petridis
wrote:

> Ideas and suggestions for future development:
>
> Add the facility to look-up Amazon wish-lists and add their contents
> (conditionally if possible) as purchase suggestions.
> I don't know if I may be considered the norm, but have set-up several
> wish-lists myself in the various Amazon shops (US, UK, FR, IT, DE,
JP),
> roughly 8-12 lists per shop.
> It would therefore be useful to be able to paste the URLs of the
various
> lists to a window and have koha recurse/run through them, provide the
> aggregated result list for verification, and then add the selected
items as
> purchase suggestions to the library.
> I understand that this could be expanded to cover many other on-line
> shops, it's just that I'm a long-time Amazon customer and keep my
> wish-lists there.
>
> Thank you for your time and cnsideration
> Manos Petridis
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



--
Northeast Kansas Library System
l...@nekls.org
785-838-4090


--

Message: 2
Date: Mon, 13 Aug 2012 12:36:22 -0700 (PDT)
From: Manos Petridis 
To: "koha@lists.katipo.co.nz" 
Subject: Re: [Koha] Question on Z39.50 cross-format queries
Message-ID:
<1344886582.13600.yahoomail...@web110606.mail.gq1.yahoo.com>
Content-Type: text/plain; charset=iso-8859-1

Sorry, seem to have replied by mistake to the poster and not to the
list.


>
> From: Manos Petridis 
>To: BWS Johnson 
>Sent: Monday, August 13, 2012 3:24 PM
>Subject: Re: [Koha] Question on Z39.50 cross-format queries
>
>
>Thank you for your welcome Brooke, and for your prompt reply.
>?
>I do understand that my own installation can be either USMARC/MARC21 or
UNIMARC. What I was enquiring about is Z39.50 look-ups. Why I am
puzzled:
>?
>a) It it were simply a case of either/or, then why can?I select the
MARC flavour of the various Z39.50 origins set up at my installation?
What is the reason to let koha know of the MARC flavour/dialect, if it
not able to use the data that each server sends? There must be some
functionality behind the dropbox selections, even if it only defines the
query statement dialect.
>?
>b) From What I can see in the data presented (in the MARC form window)
it sometimes is just a matter of mapping. For example, it seems that?
>
>in SUTRS, information is stored in the following keys:
>Title:?200
>Author:700_a, 700_b, 701_a, 701_b...Editon
details210
>Physical descrition:???215
>DDC*:??676_a
>DDC description:???676_9
>Subjects:??606
>
>in USMARC, information is stored in the following keys:

Re: [Koha] Koha Digest, Vol 82, Issue 20

[Doug Dearden]

Hi Joel,

You are probably safe to get rid of some old system logs.  I am using a 
different distro than you but I think these are in the same place.  If I look 
in /var/log on my system, I see a number of files named syslog.N.gz (N being a 
number).  These go back a few days.  I believe at one point they were building 
up on my system and sucking down a lot of disk space, and I did something so 
they would automatically delete off after a week.  Wish I could tell you what 
that was, I don't remember. Make sure you don't delete the current one named 
syslog, or the one named syslog.1 but you can probably get rid of older ones 
just to give you some wiggle room. You should take a look at syslog.1 to get an 
idea of what is being recorded in there.  Mine are full of the cron job entries 
for Koha.

Something else that might help you is the "du" command.  You can find some info 
about that here: http://www.codecoffee.com/tipsforlinux/articles/22.html or 
just do "man du" .  I have used this in the past to find the directories that 
were particularly large, then figured out what was being stored there and if it 
was necessary.

Unfortunately I can't recommend anything else, as I don't know your system.  
Deleting the wrong file can cause havoc with Linux.  Linux will even let you 
delete the entire file system with one command when you are logged in as root, 
so be careful.  I would suggest you try for some more help on the Redhat forums.

Best,

Doug

-Original Message-
From: Joel Buleka [mailto:jbul...@mra.gov.pg]
Sent: Tuesday, August 14, 2012 6:28 PM
To: Doug Dearden
Subject: RE: Koha Digest, Vol 82, Issue 20

Hi Doug

Below are currently mounted file systems:



/dev/mapper/VolGroup00-LogVol00 on / type ext3 (rw)
proc on /proc type proc (rw)
sysfs on /sys type sysfs (rw)
devpts on /dev/pts type devpts (rw,gid=5,mode=620)
/dev/sda1 on /boot type ext3 (rw)
tmpfs on /dev/shm type tmpfs (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
automount(pid2184) on /net type autofs
(rw,fd=4,pgrp=2184,minproto=2,maxproto=4)






-Original Message-
From: Doug Dearden [mailto:dear...@sarsf.org]
Sent: Wednesday, August 15, 2012 12:31 AM
To: Joel Buleka
Subject: RE: Koha Digest, Vol 82, Issue 20

100% used on your primary partition.  Size 72G, Used 72G.  You need to
free up some disk space or add some.


-Original Message-
From: Joel Buleka [mailto:jbul...@mra.gov.pg]
Sent: Monday, August 13, 2012 7:30 PM
To: Doug Dearden
Subject: RE: Koha Digest, Vol 82, Issue 20

Hi Doug

below is the partion details


[root@libserver ~]# df -h
FilesystemSize  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
   72G   72G 0 100% /
/dev/sda1  99M   15M   80M  16% /boot
tmpfs 220M 0  220M   0% /dev/shm





Joel


-Original Message-
From: Doug Dearden [mailto:dear...@sarsf.org]
Sent: Tuesday, August 14, 2012 8:42 AM
To: Joel Buleka; koha@lists.katipo.co.nz
Subject: RE: Koha Digest, Vol 82, Issue 20

Hi Joel,

>From the command line do "df -h" .

It will show you the disk space used and what remains on each partition.

You are probably out of disk space.

Doug

-Original Message-
From: koha-boun...@lists.katipo.co.nz
[mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Joel Buleka
Sent: Monday, August 13, 2012 4:23 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha Digest, Vol 82, Issue 20

Hi

We have Koha 2.2.9 running on Fedora 5, recently the MySQL database is
not starting up and the server is giving us no disk space error.






-Original Message-
From: koha-boun...@lists.katipo.co.nz
[mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
koha-requ...@lists.katipo.co.nz
Sent: Tuesday, August 14, 2012 8:16 AM
To: koha@lists.katipo.co.nz
Subject: Koha Digest, Vol 82, Issue 20

Send Koha mailing list submissions to
koha@lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-requ...@lists.katipo.co.nz

You can reach the person managing the list at
koha-ow...@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: Suggestion on Amazon wish-list look-ups (Liz Rea)
   2. Re: Question on Z39.50 cross-format queries (Manos Petridis)
   3. Why are our borrowers being restricted? (Tim Hannah)
   4. help for debian partition for koha (ramverma)
   5. Re: Why are our borrowers being restricted? (Jared Camins-Esakov)
   6. Re: Why are our borrowers being restricted? (Chris Cormack)
   7. Re: Why are our borrowers being restricted? (Tim Hannah)


---

[Koha] Barcode info and maybe SQL/MARCXML help needed

[Doug Dearden]

Hello all,

We are running Koha version 3.4 - all the details are pasted below.  I am 
working on cleaning up our barcodes, as we mistakenly converted them from our 
old system (Follett) adding some characters to some of them, and have also 
input them incorrectly when cataloging since then.  The librarian doesn't have 
any problem checking things in and out right now as they are consistently 
wrong, so she knows how to reinterpret a barcode into the format that has been 
recorded in the database.  Our concern is for that future time when we want to 
do inventory using a scanner, and the barcode as scanned doesn't match what is 
in the database.

I have found barcodes in two places.  In the items table, barcode field and in 
the biblioitems table, marcxml field.  From what I can tell the latter location 
dates back to our conversion from Follett, as I left the information that 
Follett stored in the 852 record intact against that day when we might need it. 
 I have figured out how to update the items table using an SQL "Update" 
statement.  I have also figured out how to get a report out of the biblioitems 
table using a Select statement against the marcxml field like this:

SELECT
   ExtractValue (marcxml ,'//datafield[@tag="852"]/subfield[@code="p"]')
FROM biblioitems
WHERE marcxml RLIKE 'http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha