[Koha-devel] 3.18 search speed

[Paul A]

Robin,

Many thanks for the suggestion. But late yesterday I got frustrated, 
ghosted 3.8.5 to the new server and put it into production -- my 
theoretical deadline was 31/12/14... ;={

However, I still want 3.18 if I can. I started over on a fresh 64-bit 
sandbox, got all the dependencies (and copied over an "archival" tarball of 
./etc/koha, ./var/lib/koha and ./usr/share/koha for history's sake) and am 
now trying the "package."  Followed the Wiki page, but so far, very limited 
luck. It seems to have set up an empty mysql db, under a new name (pw 
unknown), with new unknown zebra name/pw, and above all a new user on the 
system! again pw unknown. I probably misunderstood the very limited 
questions during the install trying to use existing names for "instance" 
(and all I want is one.) Not at all like the tarball, which allowed some 
granularity.

File permissions are all over the place, with root mixed in with group 
"koha318-koha" (whoever that is?)

I've got a staff-admin page but no db (it's there, but Koha is looking for 
it's own I suppose.)

No OPAC at all - apache reports "The requested URL 
/cgi-bin/koha/opac-main.pl was not found on this server." but it's there: 
-rwxr-xr-x 1 root root  2645 Dec 28 23:55 opac-main.pl ...

Onwards and upwards :)

Best regards -- Paul

At 11:01 AM 1/5/2015 +1300, Robin Sheat wrote:
>Paul A schreef op za 03-01-2015 om 20:17 [-0500]:
> > I'm really looking for some help here, please, my brain (whatever is
> > left!) is swimming in Perl code.
>
>I suggest that a holiday may not be the best time to ask :)
>
> > I'm getting the notion that maybe the db conversion (3.08 => 3.18,
> > which reported all done) missed something, or that after two years of
> > use, there's possibly something corrupt.  If not, there's maybe a
> > "config file" that's missing somewhere with some fine detail. All perl
> > modules are present (except 3.18 tells me that Readonly::XS (1.02) is
> > not installed, but I have 1.05), permissions have been verified, ps -u
> > koha shows the daemon and zebrasrv running, mysqlcheck is clean, etc.
>
>Try this:
>
>http://wiki.koha-community.org/wiki/Profiling_with_Devel::NYTProf
>
>if you're running things from the command line (which is generally
>fine), then you can run it as, for example:
>
>perl -d:NYTProf ./opac-search.pl ...
>
>rather than needing to edit the file.
>
>This should make it pretty obvious where all it's time is spent.
>
>Also, you can pass server variables through just as environment
>variables. So, SERVER_PORT could be filled in with:
>
>SERVER_PORT=80 perl -d....
>
>I've used this to feed cookies and client IP addresses in so that it
>thinks I'm logged in.
>
>--
>Robin Sheat
>Catalyst IT Ltd.
>✆ +64 4 803 2204
>GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
>
>_______________________________________________
>Koha-devel mailing list
>Koha-devel at 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>