Greetings, I figured I had not done a 32-bit install in a while, so I grabbed the Ubuntu 14.04.1 LTS ISO. I installed it in VirtualBox OpenSSH, LAMP, and Mail Server selected (even though I probably could have gone with nothing). I then followed the instructions http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages Now, I was expecting some apache2 issues to crop up, but strangely I had no problems whatsoever running: sudo apt-get install koha-common You should NEVER tinker with /etc/apt/sources.list, when you SHOULD ADD /etc/apt/sources.list.d/NEWFILE.list and sudo apt-get update. GPML, Mark Tompsett From: Christopher Nighswonger Sent: Wednesday, December 24, 2014 8:28 PM To: Paul A Cc: Koha Devel Subject: Re: [Koha-devel] koha-common install Something is broken with one of the dependencies of yaz on the latest LTS. I ran into this the other day on my Dev box. Haven't had time to chase it down yet. Kind Regards Chris On Dec 24, 2014 4:33 PM, "Paul A" <paul.a@navalmarinearchive.com> wrote: Happy Christmas, Happy Holidays all around, Having a look at latest releases of Ubuntu and Koha on a 32-bit 'sandbox' server, newly built with latest 14.04.1 LTS Ubuntu. Koha failed despite major attempts at fulfilling dependencies, including CPAN which cannot find yaz, idzebra nor libnet-z3950-zoom-perl. I started with 130-odd missing files, individually installed all but these, despite adding deb's for koha, and Debian wheezy and squeeze to /etc/apt/sources.list I'm *guessing* that i386 is no longer supported, but couldn't find any mention at koha-community. I should be able to get a 64-bit sandbox after staff leave for the holidays later today and will try again. Here's the gory details: paul@hallowell:/$ lsb_release -a Distributor ID: Ubuntu Description: Ubuntu 14.04.1 LTS Release: 14.04 Codename: trusty paul@hallowell:/$ sudo apt-get install koha-common Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help resolve the situation: The following packages have unmet dependencies: koha-common : Depends: libnet-z3950-zoom-perl but it is not going to be installed Depends: idzebra-2.0 but it is not going to be installed Depends: yaz but it is not going to be installed E: Unable to correct problems, you have held broken packages. br -- paul _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ -------------------------------------------------------------------------------- _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/

We have installed 3.18 using the koha-common package on Ubuntu 14.04 (amd64) flawlessly. The only caveat I have memory of, was setting mpm_itk *before* running sudo apt-get install koha-common (because of a mod_itk package bug, inherited from Debian). regards To+ El Fri Dec 26 2014 at 20:36:30, Paul A (<paul.a@navalmarinearchive.com>) escribió:

Hi Mark and Chris,

Thanks for your input. Just tried again on a brand new 64-bit Ubuntu 14.04.1 server, perl 5.18, apache 2.4.6, mysql 5.5, memcached, users/pwds, etc. This will be one of our new production servers, and I was hoping to upgrade Koha from our current 3.8.5.

Tried the package first:

paul@hood:/usr/share/koha$ sudo apt-get install koha-common /... snip .../ Errors were encountered while processing: libapache2-mpm-itk apache2-mpm-itk koha-common E: Sub-process /usr/bin/dpkg returned an error code (1)

So to get a bit more insight, used the latest tarball:

paul@hood:/usr/share/koha/koha-3.18.02$ perl koha_perl_deps.pl -m -u

Installed Required Module is Module Name Version Version Required ------------------------------------------------------------ -------------------------------- HTTPD::Bench::ApacheBench 0 * 0.73 No Module::Bundled::Files 0 * 0.03 No Readonly::XS 0 * 1.02 No Test::DBIx::Class 0 * 0.42 No Test::WWW::Mechanize 1.42 * 1.44 No

------------------------------------------------------------ -------------------------------- Total modules reported: 5 * Module is missing or requires an upgrade.

Now confused as to whether these are required or not??? In any case, perl Makefile.PL fails:

Warning: prerequisite HTTPD::Bench::ApacheBench 0.73 not found. Warning: prerequisite Test::DBIx::Class 0.42 not found. Warning: prerequisite Test::WWW::Mechanize 1.44 not found. We have 1.42. Writing Makefile for koha Unable to open MakeMaker.tmp: Permission denied at /usr/share/perl/5.18/ExtUtils/MakeMaker.pm line 1030.

Have tried (unsuccessfully) some attempts with CPAN, e.g.

paul@hood:/usr/share/koha$ sudo cpan HTTPD::Bench::ApacheBench Reading '/home/paul/.cpan/Metadata' Database was generated on Fri, 26 Dec 2014 08:53:17 GMT Running install for module 'HTTPD::Bench::ApacheBench' Running make for A/AD/ADIRAJ/ApacheBench-0.73.tar.gz Checksum for /home/paul/.cpan/sources/authors/id/A/AD/ADIRAJ/ApacheBench-0.73.tar.gz ok

CPAN.pm: Building A/AD/ADIRAJ/ApacheBench-0.73.tar.gz

Checking if your kit is complete... Looks good Writing Makefile for HTTPD::Bench::ApacheBench Writing MYMETA.yml and MYMETA.json Writing Makefile for HTTPD::Bench::ApacheBench Writing MYMETA.yml and MYMETA.json cp lib/HTTPD/Bench/ApacheBench/Regression.pm blib/lib/HTTPD/Bench/ApacheBench/Regression.pm cp lib/HTTPD/Bench/ApacheBench/Run.pm blib/lib/HTTPD/Bench/ ApacheBench/Run.pm cp lib/HTTPD/Bench/ApacheBench.pm blib/lib/HTTPD/Bench/ApacheBench.pm make[1]: Entering directory `/home/paul/.cpan/build/ApacheBench-0.73-hFvRj7/src' /usr/bin/perl /usr/share/perl/5.18.2/ExtUtils/xsubpp -typemap /usr/share/perl/5.18/ExtUtils/typemap ApacheBench.xs > ApacheBench.xsc && mv ApacheBench.xsc ApacheBench.c cc -c -D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -DVERSION=\"0.73\" -DXS_VERSION=\"0.73\" -fPIC "-I/usr/lib/perl/5.18/CORE" ApacheBench.c /bin/sh: 1: cc: not found make[1]: *** [ApacheBench.o] Error 127 make[1]: Leaving directory `/home/paul/.cpan/build/ ApacheBench-0.73-hFvRj7/src' make: *** [subdirs] Error 2 ADIRAJ/ApacheBench-0.73.tar.gz make -- NOT OK Running make test Can't test without successful make Running make install Make had returned bad status, install seems impossible

Any thoughts, pointers?

Thanks and br -- Paul

P.S. Mark: the additional repositories are in sources.list.d/koha.list, etc -- not in the main file.

...

Greetings,

I figured I had not done a 32-bit install in a while, so I grabbed the Ubuntu 14.04.1 LTS ISO. I installed it in VirtualBox OpenSSH, LAMP, and Mail Server selected (even though I probably could have gone with nothing). I then followed the instructions <http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages> http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages Now, I was expecting some apache2 issues to crop up, but strangely I had no problems whatsoever running: sudo apt-get install koha-common

You should NEVER tinker with /etc/apt/sources.list, when you SHOULD ADD /etc/apt/sources.list.d/NEWFILE.list and sudo apt-get update.

GPML, Mark Tompsett

From: <mailto:chris.nighswonger@gmail.com>Christopher Nighswonger Sent: Wednesday, December 24, 2014 8:28 PM To: <mailto:paul.a@navalmarinearchive.com>Paul A Cc: <mailto:koha-devel@lists.koha-community.org>Koha Devel Subject: Re: [Koha-devel] koha-common install

Something is broken with one of the dependencies of yaz on the latest LTS. I ran into this the other day on my Dev box. Haven't had time to chase it down yet.

Kind Regards

Chris On Dec 24, 2014 4:33 PM, "Paul A" <<mailto:paul.a@navalmarinearchive.com>paul.a@navalmarinearchive.com> wrote: Happy Christmas, Happy Holidays all around,

Having a look at latest releases of Ubuntu and Koha on a 32-bit 'sandbox' server, newly built with latest 14.04.1 LTS Ubuntu. Koha failed despite major attempts at fulfilling dependencies, including CPAN which cannot find yaz, idzebra nor libnet-z3950-zoom-perl. I started with 130-odd missing files, individually installed all but these, despite adding deb's for koha, and Debian wheezy and squeeze to /etc/apt/sources.list

I'm *guessing* that i386 is no longer supported, but couldn't find any mention at koha-community. I should be able to get a 64-bit sandbox after staff leave for the holidays later today and will try again. Here's the gory details:

paul@hallowell:/$ lsb_release -a Distributor ID: Ubuntu Description: Ubuntu 14.04.1 LTS Release: 14.04 Codename: trusty

paul@hallowell:/$ sudo apt-get install koha-common Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help resolve the situation:

The following packages have unmet dependencies: koha-common : Depends: libnet-z3950-zoom-perl but it is not going to be installed Depends: idzebra-2.0 but it is not going to be installed Depends: yaz but it is not going to be installed E: Unable to correct problems, you have held broken packages.

br -- paul

_______________________________________________ Koha-devel mailing list <mailto:Koha-devel@lists.koha-community.org>Koha-devel@

At 11:58 PM 12/24/2014 -0500, Mark Tompsett wrote: lists.koha-community.org

...

http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : <http://www.koha-community.org/>http://www.koha-community.org/ git : <http://git.koha-community.org/>http://git.koha-community.org/ bugs : <http://bugs.koha-community.org/>http://bugs.koha-community.org/

---------- _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/

--- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/

At 03:11 AM 12/28/2014 -0500, Mark Tompsett wrote:

Greetings, [snip]

Mark and all others, thanks. 3.18 now installed, OPAC and Staff pages appear as expected. "Web installer > Step 3 Updating database structure" appeared to go well (285 lines of updates) but with the five errors (minor?) at the end of this email. However, much more importantly, Zebra is non functional. Firstly, I tried the Wiki recommendation "koha-rebuild-zebra -v -f" but: Can't open perl script "koha-rebuild-zebra": No such file or directory [The file with it's dependences is still in the install directory, wasn't transferred during make install and will obviously not run from there: koha@hood:/usr/share/koha$ find -iname koha-rebuild-zebra ./koha-3.18.02/debian/scripts/koha-rebuild-zebra koha@hood:/usr/share/koha$ ./koha-3.18.02/debian/scripts/koha-rebuild-zebra -v -f Error: /usr/share/koha/bin/koha-functions.sh not present. ] So I reverted to the "old 3.8.5" method ./bin/migration_tools/rebuild_zebra.pl -b -r -v -x (with and without the '-x') and ./bin/migration_tools/rebuild_zebra.pl -a -r -v, and after fixing the missing ..LCK directories and files, reindexing appears perfect (right number of biblios and authorities, goes through all the stages "exporting biblio", 35301.................................................................................................... Records exported: 35379 REINDEXING zebra CLEANING But -- both Staff and OPAC get _No results found_ (Staff gives the added "No results match your search for 'kw,wrdl: smith' in NMA Catalog" whereas 3.8.5 has "568 result(s) found for 'kw,wrdl: smith' in NMA Catalog. Thoughts anyone? Update db errors: Version: mysql Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline 6.3 [Mon Dec 29 10:50:01 2014] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'SuspendHoldsIntranet' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5335. [Mon Dec 29 10:50:01 2014] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'SuspendHoldsOpac' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5336. [Mon Dec 29 10:50:01 2014] updatedatabase.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha18`.`message_transports`, CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDATE ) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5361. [Mon Dec 29 10:50:11 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 8424. [Mon Dec 29 10:50:11 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 8428. Best regards all round -- Paul --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

Paul A schreef op ma 29-12-2014 om 13:16 [-0500]:

However, much more importantly, Zebra is non functional. Firstly, I tried the Wiki recommendation "koha-rebuild-zebra -v -f" but: Can't open perl script "koha-rebuild-zebra": No such file or directory

I don't think you're pasting the commands/errors correctly, I can't imagine a scenario that would cause that message. 1. koha-rebuild-zebra requires a library name, 2. koha-rebuild-zebra should be run with sudo, 3. koha-rebuild-zebra isn't even a Perl script, so nothing should be referring to it as such. Without correct information, there's no way for anyone to give you meaningful assistance. However, as Chris said, if you stopped using the packages and instead did things the hard way, koha-rebuild-zebra isn't available to you in the first place. If you did end up with the packages (it's totally not clear), then you probably broke your permissions by doing it using the low-level scripts directly. The one thing you haven't told us though, which is the first thing to check if you get no search results, is if your zebrasrv daemon is actually running in the first place. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF