- Koha - lists.katipo.co.nz

koha on ubuntu!!
by Aren Olson 18 Sep '06

18 Sep '06

I have koha working on Ubuntu 6.06. The perl modules were a bit of a headache, but if you install them via CPAN at the command line it should work fine. Can you be more specific about why it isn't working? Aren -- "Whoever said sunshine brings happiness has never danced in the rain." - K. Jackson Ubuntu Linux - www.ubuntu.com

1 0

Koha 226RC2 on SuSE 10.1
by Beda Szukics 17 Sep '06

17 Sep '06

Hello I installed Koha 2.2.6RC2 on a SuSE 10.1 (perl 5.8.8, mysql 5.0.18) after applying the changes suggested here on the list some days ago. Everything went fine exept the following: DBD::mysql::st execute failed: Invalid default value for 'aqbudgetid' at scripts/updater/updatedatabase line 1691. DBD::mysql::st execute failed: Invalid default value for 'id' at scripts/updater/updatedatabase line 1691 Any suggestions? Greetings Beda

1 0

Barcodes required by Koha
by una simon 15 Sep '06

15 Sep '06

2 1

ldap in 2.2.6RC2
by mourik jan heupink 15 Sep '06

15 Sep '06

dear list, There has been some discussion on koha(a)lists.katipo.co.nz about the ldap authentication bit of koha. (mostly in december 2005) The outcome of that discussion was (as far as I understood it) that the actual checking of the password should be done by trying to connect (authenticate) to the ldap server with a specific username/password and see if ldap accepts the connection. What koha does: It tries to receive the password field from the ldap server, and compares that to the password the user has typed, to check if they are the same. There are some problems with this approach: - most (if not all..?) ldap servers will be configured NOT to provide a user's password to an anonymous connection. Meaning koha would have to logon with a rootdn (or use acl's) to be able to 'read' the users password. - if the ldap server uses a a way to encrypt the password, comparing the (encrypted) password with the plain text (or otherwise encrypted) plassword two values will not give the desired result. Anyway, a solution was provided on this list. To my surprise I noticed that in the new koha 2.2.6RC2 the old method was still in place. Is there anything I missed? Are there reasons NOT to use the trying to connect (authenticate) to the ldap server with a specific username/password approach? Does it break other things? The Auth.pm provided by KL Nasveschuk is quoted below, and works here. Kind regards, Mourik Jan ################################################## ### LOCAL ### Change the code below to match your own LDAP server. ################################################## # LDAP connection parameters # LDAP server my $ldapserver = 'ldap.server.com'; # Base DN for users my $name = "ou=users,dc=server,dc=com"; # Bind uses the users full DN, if uid doesn't work try "cn" my $binddn = "uid=$userid,$name"; my $db = Net::LDAP->new( $ldapserver ); # do bind my $res =$db->bind( dn =>$binddn, password =>$password); # check connexion, anything other code than LDAP_SUCCESS (0) # is a problem if($res->code != 0 ) { # auth refused warn "LDAP Auth failed server not responding or wrong user password combination"; return 0; # search user }else { my $userdnsearch = $db->search(base => "$name", filter =>"(cn=$userid)", ); my $userldapentry=$userdnsearch -> shift_entry; # build LDAP hash my %memberhash; my $x =$userldapentry->{asn}{attributes}; my $key; foreach my $k ( @$x) { foreach my $k2 (keys %$k) { if ($k2 eq 'type') { $key = $$k{$k2}; } else { my $a = @$k{$k2}; foreach my $k3 (@$a) { $memberhash{$key} .= $k3." "; } } } } # # BUILD %borrower to CREATE or MODIFY BORROWER # change $memberhash{'xxx'} to fit your ldap structure. # check twice that mandatory fields are correctly filled # my %borrower; $borrower{cardnumber} = $userid; $borrower{firstname} = $memberhash{givenName}; # MANDATORY FIELD $borrower{surname} = $memberhash{sn}; # MANDATORY FIELD $borrower{initials} = substr($borrower{firstname},0,1).substr($borrower{surname},0,1)." "; # MANDATORY FIELD $borrower{streetaddress} = $memberhash{postalAddress}." "; # MANDATORY FIELD $borrower{city} = $memberhash{l}." "; # MANDATORY FIELD $borrower{phone} = $memberhash{telephoneNumber}." "; # MANDATORY FIELD $borrower{branchcode} = "MERIT"; # MANDATORY FIELD $borrower{emailaddress} = $memberhash{mail}; $borrower{categorycode} = $memberhash{employeeType}; ################################################## ### /LOCAL ### No change needed after this line (unless there's a bug ;-) ) ##################################################

1 0

Wrong Due Date - upgrade questions
by Matthew Metzger 15 Sep '06

15 Sep '06

Hello, We have Koha 2.2.4 installed and working in our library. Recently it stopped giving the correct due date and it has to be manually edited for each issue. I haven't been able to find a setting that changes the amount of time a book is issued for. I'm planning on upgrading the system to 2.2.5 soon. Should I just wait to see if that resolves my problem? Before I update, I want to create a complete clone of our Koha library system on another server (for redundancy and backup). What is the best way of going about this.

1 0

Re: [Koha] Follett guidance..
by Steven F.Baljkas 15 Sep '06

15 Sep '06

Thursday, September 14, 2006 17:47 CDT Hey, Huck! (always wanted to be able to say that) In quick response to your e-mail question, the problem is neither bad data nor bad user. :-D The data just isn't quite MARC yet. The examples you provided are what are usually called a tagged MARC format. That is, the field tags are more or less easily identifiable and readable. What Koha needs to be able to import is a different format, for sake of distinction let's call it true MARC. In true MARC, records are alphanumeric strings and are significantly less easy for us to read. The first of the two records you gave would probably look something like this (begging pardon, because if I try to include a sample of true MARC, it'll integrate into the message in weird ways): 0####pam||2200###|a|4500<directory follows next>2D9864EF82F011D39D6900902791E909 OrP1AA20030402121324.0741003s1975 nyua j 001 0 eng 74022464 /AC0531008339(IMchF)fol00141393DLCDLCICrlFP91.B66001.56Bolian, Polly. Symbols : the language of communication / written and illustrated by Polly Bolian.New York :Watts, 1975 60 p. :$ill. ;$22 cm A First book Defines symbols, describes their evolution and meaning, and discusses their importance in the communication of ideas. 3-6 Communication Juvenile literature Signs and symbolsJuvenile literature Communication Signs and symbols OrP1AA 001.5 BOL T0025935 FSC@aR p10.00 001.5 B63 (The directory, BTW, is the part of the MARC record that makes it possible to put into a matrix or table, telling how many spaces of data belong to each fixed and variable field (fields and counts).) Anyway, Huck, see if you can find something that looks more like this textstring in your file outputs. You should be able to open it to check in a simple text editor (Notepad, Wordpad, etc.). It may be possible -- and necessary -- to use other tools to transform your MicroLif file into true MARC. If you need more help, feel free to write me off listserv and I'll see what I can do quickly to assist. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: Huck <dhuckaby(a)paasda.org> Date: 2006/09/14 Thu PM 04:05:35 CDT To: koha(a)lists.katipo.co.nz Subject: [Koha] Follett guidance.. The server that housed our Follett system..has died.. I was able to keep it up long enough to do the MARC21 export... which gave me a Microlif.001 file. When I attempt to upload this into Koha it goes to http://<servername>/cgi-bin/koha/import/breeding.pl and gives a The Connection was reset while the page was loading. I have also tried doing a Lif-Marc conversion with 'MarcRTP'... which gives me output such as this: ST=p, TY=a, BL=m, EL= , DCF=i, LRR= 001 $ $2D9864EF82F011D39D6900902791E909 003 $ $OrP1AA 005 $ $20030402121324.0 008 $ $741003s1975 nyua j 001 0 eng 010 $ a $ 74022464 /AC 020 $ a $0531008339 035 $ a $(IMchF)fol00141393 040 $ acd $DLC$DLC$ICrlF 050 0 $ ab $P91$.B66 082 $ a $001.56 100 1 $ a $Bolian, Polly. 245 10 $ abc $Symbols :$the language of communication /$written and illustrated by Polly Bolian. 260 $ abc $New York :$Watts,$1975. 300 $ abc $60 p. :$ill. ;$22 cm. 490 0 $ a $A First book 500 $ a $Includes index. 520 $ a $Defines symbols, describes their evolution and meaning, and discusses their importance in the communication of ideas. 521 2 $ a $3-6 650 0 $ ax $Communication$Juvenile literature. 650 0 $ ax $Signs and symbols$Juvenile literature. 650 1 $ a $Communication. 650 1 $ a $Signs and symbols. 852 $ ahpx9 $OrP1AA$001.5 BOL$T0025935$FSC(a)aR$p10.00 900 $ a $001.5 B63 ST=n, TY=a, BL=m, EL=1, DCF= , LRR= 001 $ $2D9864F082F011D39D6900902791E909 003 $ $OrP1AA 005 $ $20030402121107.0 008 $ $730102s1959 nyu 000 0 eng 010 $ a $ 59006359 /L 035 $ a $(IMchF)fol01371277 040 $ ac $DLC$DLC 050 0 $ ab $HM258$.H3 082 $ a $301.243 100 1 $ ad $Hall, Edward Twitchell,$1914- 245 14 $ a $The silent language. 250 $ a $[1st ed.] 260 $ abc $Garden City, N.Y.,$Doubleday,$1959. 300 $ ac $240 p.$22 cm. 650 0 $ a $Intercultural communication. 852 $ ahpx $OrP1AA$001.54 HAL$T0025936$FSC@aR 900 $ a $001.54 HAL but attempting to upload this file...ends in the same error page coming up. Is it bad data or bad user =) ?? _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ============================================================

1 0

Follett guidance..
by Huck 14 Sep '06

14 Sep '06

The server that housed our Follett system..has died.. I was able to keep it up long enough to do the MARC21 export... which gave me a Microlif.001 file. When I attempt to upload this into Koha it goes to http://<servername>/cgi-bin/koha/import/breeding.pl and gives a The Connection was reset while the page was loading. I have also tried doing a Lif-Marc conversion with 'MarcRTP'... which gives me output such as this: ST=p, TY=a, BL=m, EL= , DCF=i, LRR= 001 $ $2D9864EF82F011D39D6900902791E909 003 $ $OrP1AA 005 $ $20030402121324.0 008 $ $741003s1975 nyua j 001 0 eng 010 $ a $ 74022464 /AC 020 $ a $0531008339 035 $ a $(IMchF)fol00141393 040 $ acd $DLC$DLC$ICrlF 050 0 $ ab $P91$.B66 082 $ a $001.56 100 1 $ a $Bolian, Polly. 245 10 $ abc $Symbols :$the language of communication /$written and illustrated by Polly Bolian. 260 $ abc $New York :$Watts,$1975. 300 $ abc $60 p. :$ill. ;$22 cm. 490 0 $ a $A First book 500 $ a $Includes index. 520 $ a $Defines symbols, describes their evolution and meaning, and discusses their importance in the communication of ideas. 521 2 $ a $3-6 650 0 $ ax $Communication$Juvenile literature. 650 0 $ ax $Signs and symbols$Juvenile literature. 650 1 $ a $Communication. 650 1 $ a $Signs and symbols. 852 $ ahpx9 $OrP1AA$001.5 BOL$T0025935$FSC(a)aR$p10.00 900 $ a $001.5 B63 ST=n, TY=a, BL=m, EL=1, DCF= , LRR= 001 $ $2D9864F082F011D39D6900902791E909 003 $ $OrP1AA 005 $ $20030402121107.0 008 $ $730102s1959 nyu 000 0 eng 010 $ a $ 59006359 /L 035 $ a $(IMchF)fol01371277 040 $ ac $DLC$DLC 050 0 $ ab $HM258$.H3 082 $ a $301.243 100 1 $ ad $Hall, Edward Twitchell,$1914- 245 14 $ a $The silent language. 250 $ a $[1st ed.] 260 $ abc $Garden City, N.Y.,$Doubleday,$1959. 300 $ ac $240 p.$22 cm. 650 0 $ a $Intercultural communication. 852 $ ahpx $OrP1AA$001.54 HAL$T0025936$FSC@aR 900 $ a $001.54 HAL but attempting to upload this file...ends in the same error page coming up. Is it bad data or bad user =) ??

1 0

Re: Fwd: [Koha] MARC tag structure problem, Dewey problems & Possible to create items when importing MARC?
by Steven F.Baljkas 14 Sep '06

14 Sep '06

Thursday, September 14, 2006 23:32 CDT Hi, Aren, I think I am understanding what Stephen H. is saying, but I am not 100% on what your current MARC tag structure is. I have time to take a look at this if you like. Could you provide 1-2 tagged MARC examples of records with the 852, 952, etc., either on listserv or off? Stephen could confirm, but my understanding is that each MARC record could hold more than one 952, -- which is where Koha holds Item Information, right? --, so then the problem would be moving the data from wherever your current structure holds that info to where Koha expects it? I think MARCEdit should be able to do that. Anyway, I'm willing to give it a look-see. Get back to me if you want. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: "Aren Olson" <reacocard(a)gmail.com> Date: 2006/09/13 Wed PM 09:36:46 CDT To: koha(a)lists.katipo.co.nz Subject: Fwd: [Koha] MARC tag structure problem, Dewey problems & Possible to create items when importing MARC? On 9/13/06, Stephen Hedges <st.hedges(a)gmail.com> wrote: > > On 9/11/06, Aren Olson <reacocard(a)gmail.com> wrote: > > I am helping a public library switch to koha, and have a few problems > that > > have come up while importing the old data. > > > > First, on the "MARC Check" page, It says > > > > item fieldsALL items fields MUST : > > > > be mapped to the same tag, > > and they must all be in the 10 (items) tab > > > > Item tagThere is more than 1 MARC tag related to items tab (10) : > 852,952, > > This is correct, the previous ILS's MARC setup puts some item data on > each > > tag. Is it safe to leave it like this? > > No, Koha will not work until you get the MARC check to return no errors. Then how am I to make it work? There is data on both tags. If I use this setup for import, then change it later, would that work? [snip...] > > > Thirdly, is there any way to have koha automatically create items from a > > > MARC import? The records import, but I have to manually create an item > for > > each record before I can use it. This is impractical, since there are > > thousands of records. > > I believe the best way to do this is still to use the bulkmarcimport.plscript. > > Stephen > That's what I used. the records import fine, but no items are created. -- "Whoever said sunshine brings happiness has never danced in the rain." - K. Jackson Ubuntu Linux - www.ubuntu.com ============================================================

2 1

Fwd: [Koha] MARC tag structure problem, Dewey problems & Possible to create items when importing MARC?
by Aren Olson 14 Sep '06

14 Sep '06

On 9/13/06, Stephen Hedges <st.hedges(a)gmail.com> wrote: > > On 9/11/06, Aren Olson <reacocard(a)gmail.com> wrote: > > I am helping a public library switch to koha, and have a few problems > that > > have come up while importing the old data. > > > > First, on the "MARC Check" page, It says > > > > item fieldsALL items fields MUST : > > > > be mapped to the same tag, > > and they must all be in the 10 (items) tab > > > > Item tagThere is more than 1 MARC tag related to items tab (10) : > 852,952, > > This is correct, the previous ILS's MARC setup puts some item data on > each > > tag. Is it safe to leave it like this? > > No, Koha will not work until you get the MARC check to return no errors. Then how am I to make it work? There is data on both tags. If I use this setup for import, then change it later, would that work? [snip...] > > > Thirdly, is there any way to have koha automatically create items from a > > > MARC import? The records import, but I have to manually create an item > for > > each record before I can use it. This is impractical, since there are > > thousands of records. > > I believe the best way to do this is still to use the bulkmarcimport.plscript. > > Stephen > That's what I used. the records import fine, but no items are created. -- "Whoever said sunshine brings happiness has never danced in the rain." - K. Jackson Ubuntu Linux - www.ubuntu.com

1 0

z3950 daemon ends abruptly
by fr0zen 14 Sep '06

14 Sep '06

I've been trying to get the z3950 daemon to launch (and stay launched) and am having some trouble. The log file says: promethium# cat /usr/local/koha/log/z3950-daemon-20060912-2105.log Bareword "Net::Z3950::RecordSyntax::USMARC" not allowed while "strict subs" in use at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 260. Bareword "Net::Z3950::RecordSyntax::UNIMARC" not allowed while "strict subs" in use at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 261. Execution of /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue aborted due to compilation errors. I've looked through processz3950queue and nothing obvious pops out at me, but that's not a suprise. Any suggestions? Thanks! carla

1 0