[Koha] 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server)
Hi all, On Mon, Jun 4, 2012 at 7:07 PM, Bernardo Gonzalez Kriegel wrote: > Hi, > >> cPanel only provides Perl 5.8, but Perl module Modern::Perl can only >> be installed on Perl 5.10 environment[1]. >> > Koha (last versions) can only be installed on Perl >= 5.10 > > >> What do you think? >> > In a situation like yours, I have downloaded and compiled Perl (on > /usr/local, 5.14), > then I installed all the required modules from CPAN (a long long work) > Then Koha. It works. > >> Get rid of cPanel and start providing Perl modules based on CentOS >> environment will simplify the installing process of Koha? >> > My advice would be not to touch anything in the system. > Only install what is needed by Koha in /usr/local I'm running Perl 5.16 now, installed manually in /usr/local directory: # perl -v | grep version This is perl 5, version 16, subversion 0 (v5.16.0) built for x86_64-linux Then trying to see whether all required Perl modules are already installed or not. But unfortunately something happened: There are 8 left, not detected by 'koha_perl_deps.pl' script [0], though these modules are already in place: cpan[1]> install CGI Reading '/root/.cpan/Metadata' Database was generated on Sat, 23 Jun 2012 16:47:04 GMT CGI is up to date (3.59). cpan[2]> install CGI::Carp CGI::Carp is up to date (3.51). cpan[3]> install Digest::SHA Digest::SHA is up to date (5.71). cpan[4]> install HTTP::OAI HTTP::OAI is up to date (3.28). cpan[5]> install Net::Z3950::ZOOM Net::Z3950::ZOOM is up to date (1.28). cpan[6]> install Template::Plugin::HtmlToText Template::Plugin::HtmlToText is up to date (0.03). cpan[7]> install Test::Harness Test::Harness is up to date (3.25). cpan[8]> install Test::More Test::More is up to date (0.98). [0] http://paste.opensuse.org/view/simple/94354226 Does it mean that the Perl environment is not configured properly? How to solve this issue? Any help will be very much appreciated. Thanks in advance. Best regards, -- Andi Sugandi. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Rebuild-zebra stops working very often...
Op 25-06-12 02:44, Sonia P. schreef: > So I don't know what to do... We are stuck. I can't restart zebra every two > hours. When you say that you are restarting zebra, what _exactly_ are you doing? Because, as Chris says, there seems to be some confusion: restarting zebra should not affect whether rebuild-zebra is doing its job or not. Also, rebuild-zebra fires up every 15 minutes or so do do things, does them, and then stops. There is something in your explanation that doesn't make sense that needs to be figured out before any useful suggestions can be made. > Would reinstalling everything help? Wouldn't it take two weeks to set up and > fix everything? No idea, it would depend on what the problem was. In theory, if you follow exactly the same steps that you did last time, you will have the same problems. -- 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
Re: [Koha] No errors, but no search results
Op 22-06-12 19:02, ShaneGreen schreef: > We ran zebra interactively and all sorts of problems showed up. There were > four errors to correct, a missing file and couple of permissions to change. > . .enough stuff that we can't remember the details exactly. But searches > are working now! It'd be great if you describe what errors you saw so we can determine if they need to fixed properly. At the least, then other people know what the solutions were. Also, where did you get 3.7 from using the packages? The currently available packaged versions are 3.6, 3.8, and 3.9. > We still need to set up the chron job, etc. but the All the cron jobs should be set up by the packages. I'm wondering if you stepped outside the package-provided utilities a bit and that caused permissions to get upset. > Thank you to everyone on the forum and the emails we received. We have a forum? -- 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
Re: [Koha] Spell-check/ Did you mean
Op 22-06-12 21:29, Paul schreef: > Searching for "nature defecit" *with* the double quotes fails -- this I > expect, as the quotes eliminate fuzziness. > > Searching for nature defecit (no quotes) works perfectly. > > Searching for "nature-deficit" (with quotes) fails; I am only > semi-surprised as the logic of the - (minus sign) is to search for the > phrase without the term after the minus. However +nature -deficit also > finds that title alone and in my opinion should not (but my opinion is > not definitive.) Koha doesn't understand "phrase searching" and +with -without operators by default. It's possible to construct queries that will, but in general it doesn't. -- 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
Re: [Koha] Excel to MARC - Marcedit 5.8
Op 23-06-12 13:21, SANDEEP BHAVSAR schreef: > system.data.oledb.oledbexception (0X80004005): Make sure that it does not > include invalid characters As marcedit is proprietary software, unfortunately the only person who is likely to be able to help is the marcedit author, unless someone else has seen and solved it before. -- 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
Re: [Koha] Rebuild-zebra stops working very often...
OK, thanks all for your help! I am sorry I don't know all the details and I am obviously not great with Koha. Rebuild-zebra is supposed to run every 15 minutes for us, and sometimes it doesn't. I know, because then I am contacted by librarians who say they can't find books which they have just entered (or I check myself, I run a few mysql queries and check if I can find them on the website). So I know it's because the search indexes are not up to date. Then, I restart rebuild-zebra with the following: sudo koha-rebuild-zebra -v -f library And then the problem is solved, but not forever. It stops again later, the same day or another day, sometimes one week later. If I had more time to work on Koha, I could check exactly how often it happens and things like that, but I don't have time. :( In << sudo tail /var/log/koha/ashs/zebra-error.log.1 >> is ashs the name of the library? On our server, the closest thing I could find is << sudo tail /var/log/koha/library/zebra-error.log >> and it doesn't give me any information. So, if I understand well "tail", it means that the file is empty. Same thing for zebra-output. When I look at the current processes (ps -aux), I can see that there is a zebrasrv process runing (it says << Mar26 2:02 zebrasrv -v none,fatal,warn -f /etc/koha/sites/library/koha-conf >>, March 26 being the day when we restarted the whole server). So all that probably means that there is no problem with Zebra, am I right? With the errors I have reported previously (DBIconnect...), what is it that can't connect to MySQL? that perl script you describe, Chris? I understand it's not Zebra itself, is it rebuild-zebra? Thanks a lot for all your explanations... Cheers, Sonia. > Date: Mon, 25 Jun 2012 10:20:57 +0100 > From: ro...@catalyst.net.nz > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Rebuild-zebra stops working very often... > > Op 25-06-12 02:44, Sonia P. schreef: > > So I don't know what to do... We are stuck. I can't restart zebra every > > two hours. > > When you say that you are restarting zebra, what _exactly_ are you > doing? Because, as Chris says, there seems to be some confusion: > restarting zebra should not affect whether rebuild-zebra is doing its > job or not. Also, rebuild-zebra fires up every 15 minutes or so do do > things, does them, and then stops. There is something in your > explanation that doesn't make sense that needs to be figured out before > any useful suggestions can be made. > > > Would reinstalling everything help? Wouldn't it take two weeks to set up > > and fix everything? > > No idea, it would depend on what the problem was. In theory, if you > follow exactly the same steps that you did last time, you will have the > same problems. > > -- > 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] 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server)
Andi, how are you executing koha_perl_deps.pl? koha_perl_deps.pl has as first line "#!/usr/bin/perl", then if you execute it like "./koha_perl_deps.pl" then the "old" interpreter could not find your modules. Try "/usr/local/bin/perl koha_perl_deps.pl" -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Mon, Jun 25, 2012 at 5:12 AM, Andi Sugandi wrote: > Hi all, > > On Mon, Jun 4, 2012 at 7:07 PM, Bernardo Gonzalez Kriegel > wrote: > > Hi, > > > >> cPanel only provides Perl 5.8, but Perl module Modern::Perl can only > >> be installed on Perl 5.10 environment[1]. > >> > > Koha (last versions) can only be installed on Perl >= 5.10 > > > > > >> What do you think? > >> > > In a situation like yours, I have downloaded and compiled Perl (on > > /usr/local, 5.14), > > then I installed all the required modules from CPAN (a long long work) > > Then Koha. It works. > > > >> Get rid of cPanel and start providing Perl modules based on CentOS > >> environment will simplify the installing process of Koha? > >> > > My advice would be not to touch anything in the system. > > Only install what is needed by Koha in /usr/local > > I'm running Perl 5.16 now, installed manually in /usr/local directory: > > # perl -v | grep version > This is perl 5, version 16, subversion 0 (v5.16.0) built for x86_64-linux > > Then trying to see whether all required Perl modules are already > installed or not. But unfortunately something happened: There are 8 > left, not detected by 'koha_perl_deps.pl' script [0], though these > modules are already in place: > > cpan[1]> install CGI > Reading '/root/.cpan/Metadata' > Database was generated on Sat, 23 Jun 2012 16:47:04 GMT > CGI is up to date (3.59). > > cpan[2]> install CGI::Carp > CGI::Carp is up to date (3.51). > > cpan[3]> install Digest::SHA > Digest::SHA is up to date (5.71). > > cpan[4]> install HTTP::OAI > HTTP::OAI is up to date (3.28). > > cpan[5]> install Net::Z3950::ZOOM > Net::Z3950::ZOOM is up to date (1.28). > > cpan[6]> install Template::Plugin::HtmlToText > Template::Plugin::HtmlToText is up to date (0.03). > > cpan[7]> install Test::Harness > Test::Harness is up to date (3.25). > > cpan[8]> install Test::More > Test::More is up to date (0.98). > > [0] http://paste.opensuse.org/view/simple/94354226 > > Does it mean that the Perl environment is not configured properly? How > to solve this issue? > > Any help will be very much appreciated. > > Thanks in advance. > > Best regards, > -- > Andi Sugandi. > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Rebuild-zebra stops working very often...
Op 25-06-12 14:18, Sonia P. schreef: > Rebuild-zebra is supposed to run every 15 minutes for us, and sometimes it > doesn't. I know, because then I am contacted by librarians who say they > can't find books which they have just entered (or I check myself, I run a few > mysql queries and check if I can find them on the website). So I know it's > because the search indexes are not up to date. Then, I restart rebuild-zebra > with the following: sudo koha-rebuild-zebra -v -f library OK, just to clarify, that command doesn't restart anything. It just forces everything to be indexed from scratch, that's where the confusion was coming in. You should be getting sent emails if something is going wrong with the regular index procedure, but if local mail hasn't been properly configured on your server, you might not be seeing them. It would be worth putting an alias in for the root user so that it goes to a real person. To do this: 1. edit /etc/aliases 2. add a line like: "root: your@email.address", save 3. run the 'newaliases' command This'll mean that you get sent any errors when zebra rebuilds. To see what's there now, run 'sudo mail'. Type the number of the message to read it, 'q' will exit and '?' will provide a small amount of help. If there's something there, maybe it'll give a clue. -- 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
Re: [Koha] Rebuild-zebra stops working very often...
Sonja, I just had similar symptoms - until I remembered that I had set preference NoZebra to "Don't use" for some testing purposes. It always should be set tu "Use". It's a little chance, but maybe you might want to check this preference. Marc Am 25.06.2012 15:18, schrieb Sonia P.: OK, thanks all for your help! I am sorry I don't know all the details and I am obviously not great with Koha. Rebuild-zebra is supposed to run every 15 minutes for us, and sometimes it doesn't. I know, because then I am contacted by librarians who say they can't find books which they have just entered (or I check myself, I run a few mysql queries and check if I can find them on the website). So I know it's because the search indexes are not up to date. Then, I restart rebuild-zebra with the following: sudo koha-rebuild-zebra -v -f library And then the problem is solved, but not forever. It stops again later, the same day or another day, sometimes one week later. If I had more time to work on Koha, I could check exactly how often it happens and things like that, but I don't have time. :( In << sudo tail /var/log/koha/ashs/zebra-error.log.1 >> is ashs the name of the library? On our server, the closest thing I could find is << sudo tail /var/log/koha/library/zebra-error.log >> and it doesn't give me any information. So, if I understand well "tail", it means that the file is empty. Same thing for zebra-output. When I look at the current processes (ps -aux), I can see that there is a zebrasrv process runing (it says << Mar26 2:02 zebrasrv -v none,fatal,warn -f /etc/koha/sites/library/koha-conf >>, March 26 being the day when we restarted the whole server). So all that probably means that there is no problem with Zebra, am I right? With the errors I have reported previously (DBIconnect...), what is it that can't connect to MySQL? that perl script you describe, Chris? I understand it's not Zebra itself, is it rebuild-zebra? Thanks a lot for all your explanations... Cheers, Sonia. Date: Mon, 25 Jun 2012 10:20:57 +0100 From: ro...@catalyst.net.nz To: koha@lists.katipo.co.nz Subject: Re: [Koha] Rebuild-zebra stops working very often... Op 25-06-12 02:44, Sonia P. schreef: So I don't know what to do... We are stuck. I can't restart zebra every two hours. When you say that you are restarting zebra, what _exactly_ are you doing? Because, as Chris says, there seems to be some confusion: restarting zebra should not affect whether rebuild-zebra is doing its job or not. Also, rebuild-zebra fires up every 15 minutes or so do do things, does them, and then stops. There is something in your explanation that doesn't make sense that needs to be figured out before any useful suggestions can be made. Would reinstalling everything help? Wouldn't it take two weeks to set up and fix everything? No idea, it would depend on what the problem was. In theory, if you follow exactly the same steps that you did last time, you will have the same problems. -- 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server)
Hi Bernardo, Thanks again to clear my mind and help my problems. On Mon, Jun 25, 2012 at 8:28 PM, Bernardo Gonzalez Kriegel wrote: > how are you executing koha_perl_deps.pl? > > koha_perl_deps.pl has as first line "#!/usr/bin/perl", then if you execute > it like "./koha_perl_deps.pl" then the "old" > interpreter could not find your modules. Yes, I was running: "./koha_perl_deps.pl -m" > Try "/usr/local/bin/perl koha_perl_deps.pl" Then I've got a lot additional messages there: http://paste.opensuse.org/view/simple/70367177 These 2 modules now are true not yet installed on my system (see link above) : DateTime::Format::DateParse Graphics::Magick So, I install this 'DateTime::Format::DateParse' Perl module vi cpan: http://paste.opensuse.org/view/simple/6342828 But cpan failed to install the other one, 'Graphics::Magick' : ---begin-of-script-- cpan[2]> install Graphics::Magick Warning: Cannot install Graphics::Magick, don't know what it is. Try the command i /Graphics::Magick/ to find objects with matching identifiers. ---end-of-script-- Then, how now to install 'Graphics::Magick' perl Module via cpan? Thanks in advance. Best regards, -- Andi Sugandi. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server)
Andi, On Mon, Jun 25, 2012 at 12:13 PM, Andi Sugandi wrote: > Then I've got a lot additional messages there: > http://paste.opensuse.org/view/simple/70367177 > > > Many of the messages are harmless, you only need to do something about them if they begin to fill you Koha logs. They are pehaps due to using a bleeding edge Perl interpreter. > Then, how now to install 'Graphics::Magick' perl Module via cpan? > > You can't. Download the source from (http://www.graphicsmagick.org/), inside the source tree is a PerlMagick directory. Compile from that. Bernardo ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server)
On Mon, Jun 25, 2012 at 10:13:35PM +0700, Andi Sugandi wrote: > > koha_perl_deps.pl has as first line "#!/usr/bin/perl", then if you execute > > it like "./koha_perl_deps.pl" then the "old" > > interpreter could not find your modules. > > Yes, I was running: "./koha_perl_deps.pl -m" > > > Try "/usr/local/bin/perl koha_perl_deps.pl" It might be ab idea to change that script's shebang line to #!/usr/bin/env perl which is a bit more portable > But cpan failed to install the other one, 'Graphics::Magick' : > > ---begin-of-script-- > > cpan[2]> install Graphics::Magick > Warning: Cannot install Graphics::Magick, don't know what it is. > Try the command > > i /Graphics::Magick/ > > to find objects with matching identifiers. > > ---end-of-script-- > > Then, how now to install 'Graphics::Magick' perl Module via cpan? > You can't install Graphics::Magick from cpan as its not been uploaded there. To get the perl library you have to compile it as part of a graphics magick install. But it is only used in a specific subsystem in koha so not having it should not be a problem. Cheers Colin -- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 800 756 6803 (phone) +44 (0) 7759 633626 (mobile) colin.campb...@ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server)
Bernardo, On Mon, Jun 25, 2012 at 11:11 PM, Bernardo Gonzalez Kriegel wrote: > On Mon, Jun 25, 2012 at 12:13 PM, Andi Sugandi > wrote: >> >> Then I've got a lot additional messages there: >> http://paste.opensuse.org/view/simple/70367177 >> >> > Many of the messages are harmless, you only need to do something about them > if > they begin to fill you Koha logs. > They are pehaps due to using a bleeding edge Perl interpreter. Thanks for pointing me out about it. >> Then, how now to install 'Graphics::Magick' perl Module via cpan? >> > You can't. Download the source from (http://www.graphicsmagick.org/), > inside the source tree is a PerlMagick directory. Compile from that. Is it necessary to remove these (installed RPM) package: # rpm -qa *\Graphics\* GraphicsMagick-1.3.14-1.el6.x86_64 GraphicsMagick-perl-1.3.14-1.el6.x86_64 Or it's safe to leave them untouched, then compile-install GraphicsMagick from: http://nchc.dl.sourceforge.net/project/graphicsmagick/graphicsmagick/1.3.16/GraphicsMagick-1.3.16.tar.bz2 ? Thanks. Best regards, -- Andi Sugandi. ___ 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 80, Issue 38
How is it that no one has added this kind of searching to the community version of Koha? It's a major omission. People are so used to using quote marks and those operators in search strings that they often try to use them in Koha even though they don't work as expected. One of the features in an "easy to use" OPAC is that the searching conforms to expected norms that the public knows from other common search interfaces. This feature was commissioned from the vendor our library uses, PTFS, but it doesn't work properly. (It kind of works, but if you turn this feature on, the boolean searching in Advanced Search stops working correctly. As a result, many of the libraries that have it as an option don't use it.) I'm astonished that no one in the world has added properly working code that would make the most widely understood phrase searching method (quotation marks) available in community Koha. As for the + and - operators, if anyone tries adding that, they have to code it as a two-character string (space+ or space-) to prevent confusion when users are looking for hyphenated words. Is anyone in the Koha-verse working on adding a search mode that uses quotation marks and + - operators? I mean, aside from the buggy version we have in Liblime's LAK. -- Stacy Pober Information Alchemist [speaking for myself, not representing any institution or group] Riverdale, NY 10471 stacy.po...@manhattan.edu On Mon, Jun 25, 2012 at 9:18 AM, wrote: From: Robin Sheat To: koha@lists.katipo.co.nz Subject: Re: [Koha] Spell-check/ Did you mean Message-ID: <4fe8322c.5050...@catalyst.net.nz> Content-Type: text/plain; charset=UTF-8 Op 22-06-12 21:29, Paul schreef: > Searching for "nature defecit" *with* the double quotes fails -- this I > expect, as the quotes eliminate fuzziness. > > Searching for nature defecit (no quotes) works perfectly. > > Searching for "nature-deficit" (with quotes) fails; I am only > semi-surprised as the logic of the - (minus sign) is to search for the > phrase without the term after the minus. However +nature -deficit also > finds that title alone and in my opinion should not (but my opinion is > not definitive.) Koha doesn't understand "phrase searching" and +with -without operators by default. It's possible to construct queries that will, but in general it doesn't. -- 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
Re: [Koha] 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS (was Re: Installing Koha on CentOS+cPanel Hosting Server)
Andi, > Is it necessary to remove these (installed RPM) package: > > # rpm -qa *\Graphics\* > GraphicsMagick-1.3.14-1.el6.x86_64 > GraphicsMagick-perl-1.3.14-1.el6.x86_64 > > Or it's safe to leave them untouched, then compile-install GraphicsMagick > from: > > http://nchc.dl.sourceforge.net/project/graphicsmagick/graphicsmagick/1.3.16/GraphicsMagick-1.3.16.tar.bz2 > > ? > > I think it's safe to leave them, if you install the new version on /usr/local/*. One more thing: when you do the installation of Koha there are some files that may have the wrong "shebang" line (#!/usr/bin/perl instead of #!/usr/local/bin/perl). Run (on /usr/share/koha) something like this # for i in $( egrep -Rl "/usr/bin/perl" * ); do perl -i -pne 's|\#\!\s*/usr/bin/perl|\#\!/usr/local/bin/perl|;' $i; done to fix them (there are a few files that are missed by fix-perl-path.PL) Bernardo ___ 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 80, Issue 38
Stacy, How is it that no one has added this kind of searching to the community > version of Koha? It's a major omission. > I think it's a matter of funding and interest. A lot of developers[1] would love to see better search lexing in Koha[2], but the cost would be rather high, as it requires a more-or-less complete rewrite of the searching code in order to work, and my impression is that the searching works well enough for most people that it just isn't a priority for most organizations funding Koha development. That said, I am in complete agreement that not having a flexible search lexer in Koha is a serious omission[3]. People are so used to using quote marks and those operators in search > strings that they often try to use them in Koha even though they don't work > as expected. One of the features in an "easy to use" OPAC is that the > searching conforms to expected norms that the public knows from other > common search interfaces. > I'm astonished that no one in the world has added properly working code > that would make the most widely understood phrase searching method > (quotation marks) available in community Koha. > Quotation marks for identifying longer strings in searches do work, actually, though not quite the way we might like. What we (as librarians) call a phrase search is (sorry for the tautology) a search for a phrase which comprises one or more words. What Zebra, the search engine the Koha uses, considers a phrase search is a search for a phrase consisting of one or more words that comprise the entire subfield in which they appear. The fallback is something closer to what we might consider a phrase search, but the results can sometimes be slightly skewed (fortunately for us, my experience has been that for the most part, the skewing is slight enough that patrons are able to find what they want). This causes all sorts of mind-bending confusion, particularly in the area of subject tracings[4]. > As for the + and - operators, if anyone tries adding that, they have to > code it as a two-character string (space+ or space-) to prevent confusion > when users are looking for hyphenated words. > Right now, depending on your settings, punctuation may either be ignored (in which case "+mice -computer" will return results about computer mice only) or considered to be letters (in which case the search will not return any results at all). This is an example of what I was talking about above: in order for + and - operators to really work, a lexer that can understand them would need to be available to Koha. Is anyone in the Koha-verse working on adding a search mode that > uses quotation marks and + - operators? I mean, aside from the buggy > version we have in Liblime's LAK. > There is work on incorporating solr into Koha, which is very promising, and will fix some of these problems[5]. Solr-based searching should be available in 3.10, I think. A patch[6] is currently undergoing QA to integrate BibLibre's work on Solr into Koha, and I don't imagine it will take too long for it to be pushed. :) Hope that helps. Regards, Jared [1] Well, I would love to see better search lexing in Koha, and a few other people have agreed with me that it would be a great idea (usually while backing away slowly and hoping I don't explain how I think it should work). [2] A lexer is the tool that takes the query a user enters and turns it into a data structure that tells the search engine "this is an unambiguous representation of what the user asked for, to the extent that the user provided an unambiguous query." Right now Koha uses the query lexer provided by Zebra. OCLC's query lexer understand query strings like "pd:moz,wol,a" and turns it into a query that could be expressed in English as "Search the derived personal name index for records where the first component [i.e. last name] starts with 'moz' the second component [i.e. first name] starts with 'wol' and the third component [i.e. middle name] starts with 'a.'" [3] I would love to correct the omission myself, but it's far too large a project to do for "fun" (also, the code in question is rather painful to look at, so it wouldn't even be that much fun!). [4] Galen Charlton and I have both been doing work relating to authorities and indexing recently that will help to resolve many of the issues with heading linking and searching. (see, for example, http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7284 and http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7818 though there are a number of other related bugs as well; most of C & P's authority-related developments are grouped under http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8212) [5] As I understand it, though, we will be trading Zebra's lexer for solr's slightly more capable lexer, which is still not the ideal. [6] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8233 -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-
Re: [Koha] No errors, but no search results
I have exactly them same problem. I did install sudo cpan, no error, test all ok. I make file ok, install zebra with no error... I created some records with Marc frameworks. I can check out, check in, and check mysql that i did have some items (books) in library. The only problem is that i can't search. When i type some things on "search the catalog", the result always is not found. So did i have problem with zebra index? I tried reinstall it, nothing happened. Help me please! Kindest Regards! Nguyen Quoc Uy On 25-06-2012, at 17:18, koha-requ...@lists.katipo.co.nz wrote: > 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: Rebuild-zebra stops working very often... (Sonia P.) > 2. Re: Rebuild-zebra stops working very often... (Chris Cormack) > 3. 8 Perl Modules are Not Detected by koha_perl_deps.pl on VDS > (was Re: Installing Koha on CentOS+cPanel Hosting Server) > (Andi Sugandi) > 4. Re: Rebuild-zebra stops working very often... (Robin Sheat) > 5. Re: No errors, but no search results (Robin Sheat) > 6. Re: Spell-check/ Did you mean (Robin Sheat) > 7. Re: Excel to MARC - Marcedit 5.8 (Robin Sheat) > 8. Re: Rebuild-zebra stops working very often... (Sonia P.) > > > -- > > Message: 1 > Date: Mon, 25 Jun 2012 03:44:12 +0200 > From: Sonia P. > To: > Cc: koha@lists.katipo.co.nz > Subject: Re: [Koha] Rebuild-zebra stops working very often... > Message-ID: > Content-Type: text/plain; charset="iso-8859-1" > > > Hi there > > Here is what our technician said in relation to your message : > << If Zebra cannot connect to the database, Koha itself will not work. >The database connection error is unrelated to the Koha search >problem. > >The Zebra logs are located under /var/log/koha/library, I >have looked at the zebra-output.log file contained within >the directory, there is nothing in it and it hasn't been written to >since April 24. The zebra-error.log in the same directory >hasn't been written to since the computer was installed. >> > > So I don't know what to do... We are stuck. I can't restart zebra every two > hours. Would reinstalling everything help? Wouldn't it take two weeks to > set up and fix everything? > If you have any idea about what's going on... > > Cheers, > > Sonia. > > > > Subject: Re: [Koha] Rebuild-zebra stops working very often... > From: chr...@catalyst.net.nz > Date: Sun, 24 Jun 2012 13:10:41 +1200 > To: sossola...@hotmail.com > CC: koha@lists.katipo.co.nz > > Ahh that is not the zebra error log. But the rebuild zebra one. I think you > may be confusing zebra with the job to rebuild the zebra indexes, they are 2 > quite different things. > > > > However not being able to talk to the database is a fatal error for the > rebuild zebra script. The database failing will also cause all sorts of other > errors. I would get your tech people to look at your database set up. > Something very bad is going wrong there. > > > > Chris > > "Sonia P." wrote: > > Dear all > > Thanks again for your help. > Here is (below) the content of the zebra error file. Would you please have a > look at it and tell me if there are things which could explain why > zebra-rebuild stops working now and then? There is that DBIconnect error, > but I am not sure it's related. And there is no time & day in the error > file, so I can't check what happened when zebra rebuild doesn't work > properly. (I have removed all the multiple duplicates...) > > Cheers, > > Sonia. > > > > > Wide character in subroutine entry at /usr/share/perl5/MARC/Charset/Table.pm > line 96. > DBI > connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) > failed: Can't connect to loc > al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at > /usr/share/koha/lib/C4/Context.pm lin > e 692 > Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l > ib/C4/Context.pm line 692. > DBI > connect('dbname=koha_library;host=localhost;port=3306','koha_library',...) > failed: Can't connect to loc > al MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at > /usr/share/koha/lib/C4/Context.pm lin > e 692 > Can't connect to local MySQL server through socket > '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/l > ib/C4/Context.pm line 692. > DBI > connect('dbname=koha_library;host=localhost;port=3306','koha_library',...)
Re: [Koha] Excel to MARC - Marcedit 5.8
There's an excellent support list for MARCEDIT called MARCEDIT-L. Terry Reese, the author of the program monitors the list, and he will often offer solutions along with some of the other list subscribers. http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L It's also a good way to give input on features you'd like to see or to find out whether someone already has solved a particular problem you're having. Stacy On Mon, Jun 25, 2012 at 9:18 AM, wrote: > As marcedit is proprietary software, unfortunately the only person who > is likely to be able to help is the marcedit author, unless someone else > has seen and solved it before. > -- Stacy Pober Information Alchemist Riverdale, NY 10471 stacy.po...@manhattan.edu ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Official Koha Newsletter: Volume 3, Issue 6: June 2012
Official Koha Newsletter: Volume 3, Issue 6: June 2012 [Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-3-issue-6-june-2012] Official Koha Newsletter (ISSN 2153-8328) Volume 3, Issue 6: June 2012 Edited by Daniel Grobani, Koha Community Newsletter Editor. Please submit news items to danielg.k...@gmail.com. Table of Contents Koha Development Koha 3.8.2 Released Koha 3.6.5 Released Koha 3.6.6 Released Koha Statistics Release Manager’s Newsletter MARC Records in PostgreSQL Adding VIAF Autosuggest for New NAME Authorities Koha Community New Koha Libraries Community Gossip Koha-Kobli News Past Koha Events June General IRC Meeting KohaCon12 Upcoming Koha Events July General IRC Meeting KohaCon13 Koha Development Koha 3.8.2 Released by Chris Cormack The Koha community is proud to release Koha version 3.8.2. This is a bugfix release, and contains a large number of fixes. You can obtain Koha 3.8.2 here. Release notes are here. Koha 3.6.5 Released by Jared Camins-Esakov The Koha release team is happy to announce the release of Koha 3.6.5. This is a stable release and contains bugfixes as well as updated translations. You can download Koha 3.6.5 here. Release notes are here. Koha 3.6.6 Released by Jared Camins-Esakov The Koha release team is happy to announce the release of Koha 3.6.6. This is a stable release and contains bugfixes as well as updated translations. You can download Koha 3.6.6 here. Release notes are here. Koha Statistics Chris Cormack, unofficial Koha Community Statistics Wizard, has posted statistics for Koha 3.6.5, May bugs & enhancements, Koha 3.8.2, and Koha 3.6.6. Release Manager Newsletter Paul Poulain, Koha 3.8 Release Manager, is publishing a monthly newsletter dedicated to Koha 3.8 development. It can be found on the Koha Community website in the Koha News category. The latest issue is here. Experimental Support for MARC Records as a Proper Datatype in the PostgreSQL Database by Marc Balmer Sitting in one of the nice pubs in Edinburgh during KohaCon, I had this idea to add MARC records as a proper datatype to the PostgreSQL database server. After a discussion with Marc Véron and Dobrica Pavlinusic about what that could mean, I decided to just try it and I have now a basic implementation (or, more a proof of concept). Here is some information on this: If MARC records are a proper datatype, that means they are stored right in the database, are backed-up, can be restored, replicated, etc., just with the standard database tools. If a function is provided to access individual fields of a MARC record, then this can be used in SQL expressions, e.g. for selects or to create views, etc. As PostgreSQL supports functional indexes, you can create indexes on individual MARC fields, giving you super fast access to your data. How does it look? There is a datatype called ‘marc’ for now: CREATE TABLE books ( id serial, sig varchar(16), marc_record marc ); MARC records are loaded into the database as raw, binary records, encoded in hexadecimal: INSERT INTO books (sig, marc_record) VALUES (‘a01b’, ’3030383830…..’); To access individual MARC fields, the function ‘marc_field()’ was created; it returns VARCHAR: SELECT id, marc_field(marc_record, ’020') AS isbn FROM books WHERE sig = ‘a01b’; Of course MARC fields can be used to search data: SELECT id, marc_field(marc_record, ’020') AS isbn FROM books WHERE marc_field(marc_record, ’245') like ‘whatever%’; An index on a specific field can easily be created: CREATE INDEX books_isbn_idx ON books (marc_field(marc_record, ’020')); As syntactic sugar, the expression marc_record@’020' is equal to marc_field(marc_record, ’020'). Marijana Glavica kindly let me use a MARC database of ~250,000 records to make some tests, here are some real world examples: books=# \d test_marc Table “public.test_marc” Column | Type | Modifiers ——–+———+——– id | integer | not null default nextval(‘test_marc_id_seq’::regclass) marc21 | marc | books=# select count(id) from test_marc; count ——– 246727 (1 row) How many Croatian books do they have? books=# select count(id) from test_marc where substring(marc_field(marc21, ’008'), 37, 3) = ‘hrv’; count ——- 52582 (1 row) Of course much more complex queries are possible with this, and using the right indexes it is really, really fast. One query I tested went from 8.4 seconds to 0.21 ms with the right index. That’s a speedup of 40,000 times. Thanks to Marijana, Dobrica, and Marc for feedback, interesting discussions and ideas! Feedback and suggestions are of course more than welcome at m...@msys.ch. Adding VIAF Autosuggest for New NAME Authorities by Stefano Bargioni The Pontificia Università della Santa Croce has written a script to enhance authority cataloguing usin
Re: [Koha] Koha Digest, Vol 80, Issue 38
> I think it's a matter of funding and interest. A lot of developers[1] > would love to see better search lexing in Koha[2], but the cost would > be rather high, as it requires a more-or-less complete rewrite of the > searching code in order to work, and my impression is that the > searching works well enough for most people that it just isn't a > priority for most organizations funding Koha development. That said, I > am in complete agreement that not having a flexible search lexer in > Koha is a serious omission[3]. I agree also. Ideally, we should define for Koha a query language syntax in BNF: http://en.wikipedia.org/wiki/Backus%E2%80%93Naur_Form and then, create a query parser, which would validate queries, and transform them into Zebra native syntax (3 indeed, PQF, CCL, CQL), or transform them into coming SolR query syntax. A standard Perl module like Regexp::Grammars could help to do the job. -- Frédéric DEMIANS http://www.tamil.fr/u/fdemians.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] No errors, but no search results
Did you check the system preference NoZebra? It should be set to: "Use" Regards Marc Am 25.06.2012 20:33, schrieb Uy: I have exactly them same problem. I did install sudo cpan, no error, test all ok. I make file ok, install zebra with no error... I created some records with Marc frameworks. I can check out, check in, and check mysql that i did have some items (books) in library. The only problem is that i can't search. When i type some things on "search the catalog", the result always is not found. So did i have problem with zebra index? I tried reinstall it, nothing happened. Help me please! Kindest Regards! Nguyen Quoc Uy ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha