Roche III, Edward | 1 Mar 2009 04:33
Picon
Favicon

Re: Staging of import stalls

how would you get the zebra server running as well as the daemans? I originally tries to use zebra but it was giving me issues so I decide to go the nozebra route.

Thanks
Ed

Edward Roche
Technology Support/Network Admin
Solanco School District
edward_roche-HWOlgRSOGTSTkWHzu1llofU/3Eu2kcEP@public.gmane.org
717.786.2151

The greatest mistake you can make in life is to continually be afraid you will make one.
Elbert Hubbard



-----Original Message-----
From: Koustubha Kale [mailto:kmkale-3aD4CAxKgr73oGB3hsPCZA@public.gmane.org]
Sent: Sat 2/28/2009 2:31 AM
To: Doug Dearden
Cc: Roche III, Edward; koha-MiqU8s9CcdeGg0aVt5PjEHTaI6DYlTYJ@public.gmane.org
Subject: Re: [Koha] Staging of import stalls

ED,
Do try Doug's suggestion.
I have also faced this problem. removing the problem record solves the
stall.
Also I have staged and imported more than 87000 records in one go, so
the batch process does work well.
 In case you are not using zebra, one  trick  i observed was to have the
zebra  server and queue daemons running during the import and put
nozebra to off even if you are not using zebra. this speeds up the
staging and import by orders of magnitude. after the import is over you
can run the rebuild_nozebra.pl to rebuild the index after turning on
nozebra setting. This little trick resulted in hours of time saving.

--
Regards,
Koustubha Kale
Anant Corporation

Contact Details :
Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w),
                Maharashtra, India, Pin : 400601.
TeleFax  : +91-22-21720108, +91-22-21720109
Mobile     : +919820715876
Website  : http://www.anantcorp.com




Doug Dearden wrote:
> Hi Ed,
>
> I had the same problem.  Take a look at the last import (Home > Tools > Manage Staged MARC Records > Batch
>
> Figure out the last record in the batch that went in, then edit the import file you are using and remove the record immediately after that one in the file.  It has some kind of problem.  Try again and see if you get further.  It is either that record, or the last one that actually worked, I can't remember exactly which.
>
> Also, there is a command line tool that you can use to import.   You will find it at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl
>
> >From the migration tools subdirectory enter: perl bulkmarcimport.pl and you will get the syntax and parameter info.  It has a test mode you can run against the file.
>
> Best,
>
> Doug
>
>  
>>>> "Roche III, Edward" <edward_roche-HWOlgRSOGTSTkWHzu1llofU/3Eu2kcEP@public.gmane.org> 2/27/2009 9:20 AM >>>
>>>>        
> Good Morning All
>

>
> I am trying stage my MARC import data but it keeps stalling. I broke it
> down into 4 individual files of about 4000 records each. But it still
> stalls at about 15%. Has anyone had this issue? Can it be done from the
> terminal instead of through the browser? Every time I start the process
> it pins my cpu at 95 to 100% which is why it is probably stalling but
> not sure why.
>

>
> My Config
>
> ----------------------------------
>
> Ubuntu 8.1
>
> 1.5gb memory
>
> Pentium 4 - 2.5ghz dual core
>
> Koha 3.0
>
> NoZebra
>
> Basic LAMP install
>

>
> Any thoughts would be great.
>

>
> Thanks
>
> Ed
>

>
> Edward J. Roche
>
> Network Administrator
>
> Solanco School District
>
> 717.786.2151 x2437
>

>

>
> "At the End of the Day, Did You Play to Win or Not to Lose?"
>

>
>                     
>

>

>
>
> _______________________________________________
> Koha mailing list
> Koha-MiqU8s9CcdeGg0aVt5PjEHTaI6DYlTYJ@public.gmane.org
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>  

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: Staging of import stalls

Ed,
I also had issues getting zebra working initially as we had most of the
biblios in Unicode Marathi.So while I was playing with zebra we used
nozebra to get the services off the ground and then switched to zebra once
we had solved the zebra search of Unicode Marathi.
1) Turn off noZebra from system preferences.
For testing Zebra you can run it from command line.
sudo -u ${KOHA_USER} zebrasrv -f /etc/koha/koha-conf.xml
adjust the path to koha-conf.xml if different.
The first time I ran this it refused to run as it was not finding some
directories. I had to create those and change ownerships to koha user. I
forget exact paths but a look at the output will tell you. 
Once its running, do your bulk import by staging and then importing. After
that in a separate terminal run misc/migration_tools/rebuild_zebra.pl -b -w

This should build your index and then you should be able to search from
opac & stff client.

2) Once you have the search going you can run the zebra server and
zebraqueue in daemon mode and have them start on system boot. Here is how
to do it on Ubuntu, adjust according to your OS.

sudo ln -s ${SCRIPT_DIR}/koha-zebra-ctl.sh /etc/init.d/koha-zebra-daemon 
${SCRIPT_DIR} is /usr/share/koha/bin/ by default in a standard install.
sudo update-rc.d koha-zebra-daemon defaults
sudo /etc/init.d/koha-zebra-daemon start
Zebraqueue Daemon: 
sudo ln -s ${SCRIPT_DIR}/koha-zebraqueue-ctl.sh
/etc/init.d/koha-zebraqueue-daemon
sudo update-rc.d koha-zebraqueue-daemon defaults
sudo /etc/init.d/koha-zebraqueue-daemon start

Thats it. the zebraqueue will take care of indexing any subsequent
additions you make. If you bulk import any more biblios run
rebiuld_zebra.pl again as zebraqueue is slower in indexing. Also run
rebuild_zebra.pl for your authorities.
The daemons will log in /var/log/koha/ Have a look at files in there if
something doesn't work out.
-- 
Regards,
Koustubha Kale
Anant Corporation

Contact Details :
Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka,
Thane (w),
      	  	Maharashtra, India, Pin : 400601.
TeleFax  : +91-22-21720108, +91-22-21720109
Mobile     : +919820715876
Website  : http://www.anantcorp.com 

Original Message:
-----------------
From: Roche III, Edward edward_roche@...
Date: Sat, 28 Feb 2009 22:33:19 -0500
To: kmkale@...,
dearden@..., koha@...
Subject: RE: [Koha] Staging of import stalls

how would you get the zebra server running as well as the daemans? I
originally tries to use zebra but it was giving me issues so I decide to go
the nozebra route.

Thanks
Ed

Edward Roche
Technology Support/Network Admin
Solanco School District
edward_roche@...
717.786.2151

The greatest mistake you can make in life is to continually be afraid you
will make one.
Elbert Hubbard

-----Original Message-----
From: Koustubha Kale [mailto:kmkale@...]
Sent: Sat 2/28/2009 2:31 AM
To: Doug Dearden
Cc: Roche III, Edward; koha@...
Subject: Re: [Koha] Staging of import stalls

ED,
Do try Doug's suggestion.
I have also faced this problem. removing the problem record solves the 
stall.
Also I have staged and imported more than 87000 records in one go, so 
the batch process does work well.
 In case you are not using zebra, one  trick  i observed was to have the 
zebra  server and queue daemons running during the import and put 
nozebra to off even if you are not using zebra. this speeds up the 
staging and import by orders of magnitude. after the import is over you 
can run the rebuild_nozebra.pl to rebuild the index after turning on 
nozebra setting. This little trick resulted in hours of time saving.

-- 
Regards,
Koustubha Kale
Anant Corporation

Contact Details :
Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka,
Thane (w),
      	  	Maharashtra, India, Pin : 400601.
TeleFax  : +91-22-21720108, +91-22-21720109
Mobile     : +919820715876
Website  : http://www.anantcorp.com

Doug Dearden wrote:
> Hi Ed,
>
> I had the same problem.  Take a look at the last import (Home > Tools >
Manage Staged MARC Records > Batch 
>
> Figure out the last record in the batch that went in, then edit the
import file you are using and remove the record immediately after that one
in the file.  It has some kind of problem.  Try again and see if you get
further.  It is either that record, or the last one that actually worked, I
can't remember exactly which. 
>
> Also, there is a command line tool that you can use to import.   You will
find it at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl 
>
> >From the migration tools subdirectory enter: perl bulkmarcimport.pl and
you will get the syntax and parameter info.  It has a test mode you can run
against the file.
>
> Best,
>
> Doug
>
>   
>>>> "Roche III, Edward" <edward_roche@...>
2/27/2009 9:20 AM
>>>
>>>>         
> Good Morning All
>
>  
>
> I am trying stage my MARC import data but it keeps stalling. I broke it
> down into 4 individual files of about 4000 records each. But it still
> stalls at about 15%. Has anyone had this issue? Can it be done from the
> terminal instead of through the browser? Every time I start the process
> it pins my cpu at 95 to 100% which is why it is probably stalling but
> not sure why.
>
>  
>
> My Config
>
> ----------------------------------
>
> Ubuntu 8.1
>
> 1.5gb memory
>
> Pentium 4 - 2.5ghz dual core
>
> Koha 3.0
>
> NoZebra
>
> Basic LAMP install
>
>  
>
> Any thoughts would be great.
>
>  
>
> Thanks
>
> Ed
>
>  
>
> Edward J. Roche
>
> Network Administrator
>
> Solanco School District
>
> 717.786.2151 x2437
>
>  
>
>  
>
> "At the End of the Day, Did You Play to Win or Not to Lose?" 
>
>  
>
>                      
>
>  
>
>  
>
>
> _______________________________________________
> Koha mailing list
> Koha@...
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>   

--------------------------------------------------------------------
mail2web LIVE – Free email based on Microsoft® Exchange technology -
http://link.mail2web.com/LIVE
john smith | 1 Mar 2009 11:52

Command not found

Hi to all
i try to install koha 3 on ubuntu 8.04 all ok but when run the command :

1- /usr/share/koha/bin/koha-zebra-ctl.sh start

2- /usr/share/koha/bin/koha-zebraqueue-ctl.sh start

not runing and the result

command not found

please if any body can help me send to me i cant install zebra

 

thnks


check out the rest of the Windows Live™. More than mail–Windows Live™ goes way beyond your inbox. More than messages
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha
Thommy M. | 1 Mar 2009 12:41
Picon
Gravatar

Re: Koha / Biblios, integration of batch searching?

Wade wrote:
> I realize that you can integrate Biblios into Koha.
> 
>  
> 
> Just wondering if is there currently a way to do a batch search/record
> download for a set of, say, ISBNs?

This sounds like something I like to do too. The only useful data I seem
to get from my 2.2.9 is ISBN and the corresponding bar codes we have
inserted for each item. I would like to find a way to z3950 search for
the ISBM, add the record to a fresh Koha 3 and add the barcode in batch.
Can that be done?
Thommy M. | 1 Mar 2009 14:45
Picon
Gravatar

Koha 3.0.1: make test errors

What am I missing this time???

$ make test
PERL_DL_NONLAZY=1 KOHA_CONF=blib/KOHA_CONF_DIR/koha-conf.xml
/usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/PERL_MODULE_DIR', 'blib/arch')" t/*.t
t/Amazon.......................ok
t/Barcodes_PrinterConfig.......ok
t/Bookfund.....................ok
t/Bookseller...................ok
t/Boolean......................ok
t/Branch.......................ok
t/Calendar.....................ok
t/Charset......................ok
t/Circulation_barcodedecode....DBD::mysql::db selectrow_array failed:
Table 'koha.systempreferences' doesn't exist at
/home/thommym/build/koha-3.00.01-stable/blib/PERL_MODULE_DIR/C4/Context.pm
line 485.
t/Circulation_barcodedecode....ok
t/Dates........................ok 1/126#
# In order to run without DB access, this test will substitute 'us'
# as your default date format.  Export environmental variable
KOHA_TEST_DATE_FORMAT
# to override this default, or pass the value as an argument to this
test script.
#
# NOTE: we test for the system handling dd=00 and 00 for TIME values,
# therefore you *should* see some warnings 'Illegal date specified'
related to those.
#
# Testing Legacy Functions: format_date and format_date_in_iso
#
Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
line 58
Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
line 61
#
# Testing 4 formats.
# Testing no input (defaults):
#
# Testing with valid inputs:
Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
line 80
Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
line 80
Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
line 80
Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
line 80
#
# Testing object independence from class
# done.
# Looks like you planned 126 tests but ran 9 extra.
t/Dates........................dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 127-135
        Failed 9/126 tests, 92.86% okay
t/Debug........................# BEFORE use:     $debug is not defined
# BEFORE use: $cgi_debug is not defined
t/Debug........................ok 1/3#  AFTER use:     $debug is 0
#  AFTER use: $cgi_debug is 0
# Done.
t/Debug........................ok
t/dummy........................ok
t/Input........................ok
t/Koha.........................ok
t/Languages....................ok
t/Maintainance.................ok
t/Output.......................ok
t/Record.......................ok
t/Review.......................ok
t/Scrubber.....................ok 1/10# Note: scrubber test output will
have whitespace collapsed for readability
# done.
t/Scrubber.....................ok
t/Stats........................ok
Failed Test Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/Dates.t    255 65280   126    9   7.14%  127-135
Failed 1/21 test scripts, 95.24% okay. -9/189 subtests failed, 104.76% okay.
make: *** [test_dynamic] Error 255
H.S. | 1 Mar 2009 15:21
Picon

specific version of mysql required on Ubuntu 8.10?

Hi,

I am going to install Koha on Ubuntu Intrepid in a few days time. I was
wondering if there is a restriction on the version of MySQL required.

Thanks.
--

-- 

Please reply to this list only. I read this list on its corresponding
newsgroup on gmane.org. Replies sent to my email address are just
filtered to a folder in my mailbox and get periodically deleted without
ever having been read.
Thommy M. | 1 Mar 2009 15:55
Picon
Gravatar

Re: Koha 3.0.1: make test errors

I went ahead and did make install but then the finish up part hangs on
starting the zebra server. How can I check that all prerequisites for
the zebraserver is in place?

I have followed the instructions on
http://wiki.koha.org/doku.php?id=koha_3_install_guide_ubuntu_hardy and
it reported no errors. The only difference is that I have 3.0.1

$ sudo zebrasrv -f /etc/koha/koha-conf.xml
15:46:11-01/03 [log] zebra_start /etc/koha/zebradb/zebra-biblios.cfg 1.3.50
15:46:11-01/03 [log] zebra_start /etc/koha/zebradb/zebra-authorities.cfg
1.3.50
15:46:11-01/03 [server] Adding dynamic listener on
unix:/var/run/koha/zebradb/bibliosocket id=1
15:46:11-01/03 [server] Adding dynamic listener on
unix:/var/run/koha/zebradb/authoritysocket id=2
15:46:11-01/03 [server] Starting server zebrasrv pid=8711

Here it just hangs until I bail out with ctrl-c

Thommy M. wrote:
> What am I missing this time???
> 
> 
> $ make test
> PERL_DL_NONLAZY=1 KOHA_CONF=blib/KOHA_CONF_DIR/koha-conf.xml
> /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
> 'blib/PERL_MODULE_DIR', 'blib/arch')" t/*.t
> t/Amazon.......................ok
> t/Barcodes_PrinterConfig.......ok
> t/Bookfund.....................ok
> t/Bookseller...................ok
> t/Boolean......................ok
> t/Branch.......................ok
> t/Calendar.....................ok
> t/Charset......................ok
> t/Circulation_barcodedecode....DBD::mysql::db selectrow_array failed:
> Table 'koha.systempreferences' doesn't exist at
> /home/thommym/build/koha-3.00.01-stable/blib/PERL_MODULE_DIR/C4/Context.pm
> line 485.
> t/Circulation_barcodedecode....ok
> t/Dates........................ok 1/126#
> # In order to run without DB access, this test will substitute 'us'
> # as your default date format.  Export environmental variable
> KOHA_TEST_DATE_FORMAT
> # to override this default, or pass the value as an argument to this
> test script.
> #
> # NOTE: we test for the system handling dd=00 and 00 for TIME values,
> # therefore you *should* see some warnings 'Illegal date specified'
> related to those.
> #
> # Testing Legacy Functions: format_date and format_date_in_iso
> #
> Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
> line 58
> Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
> line 61
> #
> # Testing 4 formats.
> # Testing no input (defaults):
> #
> # Testing with valid inputs:
> Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
> line 80
> Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
> line 80
> Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
> line 80
> Illegal date specified (year = 1952, month = 1, day = 00) at t/Dates.t
> line 80
> #
> # Testing object independence from class
> # done.
> # Looks like you planned 126 tests but ran 9 extra.
> t/Dates........................dubious
>         Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 127-135
>         Failed 9/126 tests, 92.86% okay
> t/Debug........................# BEFORE use:     $debug is not defined
> # BEFORE use: $cgi_debug is not defined
> t/Debug........................ok 1/3#  AFTER use:     $debug is 0
> #  AFTER use: $cgi_debug is 0
> # Done.
> t/Debug........................ok
> t/dummy........................ok
> t/Input........................ok
> t/Koha.........................ok
> t/Languages....................ok
> t/Maintainance.................ok
> t/Output.......................ok
> t/Record.......................ok
> t/Review.......................ok
> t/Scrubber.....................ok 1/10# Note: scrubber test output will
> have whitespace collapsed for readability
> # done.
> t/Scrubber.....................ok
> t/Stats........................ok
> Failed Test Stat Wstat Total Fail  Failed  List of Failed
> -------------------------------------------------------------------------------
> t/Dates.t    255 65280   126    9   7.14%  127-135
> Failed 1/21 test scripts, 95.24% okay. -9/189 subtests failed, 104.76% okay.
> make: *** [test_dynamic] Error 255
Thommy M. | 1 Mar 2009 16:00
Picon
Gravatar

Re: specific version of mysql required on Ubuntu 8.10?

H.S. wrote:
> Hi,
> 
> I am going to install Koha on Ubuntu Intrepid in a few days time. I was
> wondering if there is a restriction on the version of MySQL required.

The latest I read was that Koha 3 is OK with the one that is default in
Intrepid (5.0 something). There were some fuzz on perl version but that
was also OK IIRC. Follow the instructions on
http://wiki.koha.org/doku.php?id=koha_3_install_guide_ubuntu_hardy
They will (hopefully) work for Intrepid too. Please report back...
Thommy M. | 1 Mar 2009 16:55
Picon
Gravatar

How to import non ascii characters with z3950

When I install Koha (3.0.1) on Ubuntu 8.04 following the instructions on
http://wiki.koha.org/doku.php?id=koha_3_install_guide_ubuntu_hardy I
almost manage to get everything working but Z39.50 import. I want to use
 this source for my MARC records
http://www.kb.se/libris/teknisk-information/libris-via-Z3950/ which
states these parameters:
Protokollversion: 3
IP-adress: z3950.libris.kb.se
Port nr: 210
Databas: libr
Services: INITIALIZE, SEARCH, PRESENT, CLOSE, SORT, NAMED RESULT SETS,
DELETE RESULT SET, EXPLAIN
Typ av sökning: 1 (RPN)
Attributset: Bib-1
Postsyntax:  MARC21, SUTRS
Teckenset: ISO 8859-1 (Latin-1)
Posttyper: Full, Brief

So I choose MARC21 in Koha. When i comes to look up an ISBN number I
find the book and I can import it, but when I look at the text the
characters outside ASCII does not look the way I expect. They are only a
black rectangle with a white question mark in it.

So, again, how can I make Koha import non ASCII characters? I've set
utf-8 everywhere in browser,locale,MySQL... Or do I have to make my
installation all Latin one as z3950.libris.kb.se says its charset is ISO
8859-1 (Latin-1) ???
Thommy M. | 1 Mar 2009 17:57
Picon
Gravatar

How to search an item in Koha 3

when I browse to http://myserver I get the search interface. I select
Search ISBN in the drop down and give a number that I have saved earlier
but Koha responds with

No Result found !

No results match your search for “nb,wrdl: 9175740192” in Catalog

How can I have Koha 3 to find my stored items?

_______________________________________________
Koha mailing list
Koha <at> lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Gmane