- Koha - lists.katipo.co.nz

Re: [Koha] Koha Digest, Vol 40, Issue 35
by Library Guy 14 Jul '09

14 Jul '09

James, I'm running Koha 3.00.02 which includes the new <auth_by_bind>1</auth_by_bind> for Active Directory, but I still cannot authenticate against our M$ LDAP. The Koha OPAC reports "Error: Invalid Username or Password. Specifically I'm unsure what to do with the <password></password> tag because our Microsoft AD LDAP schema has no exposed "userpassword". Do I simply use <password = ""></password>? I wish to create and update Koha user records when they login to Koha, so I have: <ldapserver id="ldapserver" listenref="ldapserver"> <hostname>ldap://ldap.example.com:389</hostname> <base>dc=example,dc=com</base> <user>CN=KOHA_LDAP_USER</user>  <pass>secretpasswd</pass>  <replicate>1</replicate>  <update>1</update>  <auth_by_bind>1</auth_by_bind>  <mapping>  <firstname is="givenName" ></firstname> <surname is="sn" ></surname> <address is="streetAddress" ></address> <city is="l" ></city> <zipcode is="postalCode" ></zipcode> <userid is="sAMAccountName" ></userid> <password is="" ></password> <email is="mail" ></email> <phone is="telephoneNumber"></phone> </mapping> </ldapserver> After a failed login attempt, /var/log/koha/koha-error_log : [Mon Jul 13 15:56:11 2009] [error] [client] [Mon Jul 13 15:56:11 2009] mainpage.pl: LDAP Auth rejected : invalid password for user 'johndoe'. LDAP error #16: LDAP_NO_SUCH_ATTRIBUTE, referer: http://koha.example.com:8080/cgi-bin/koha/mainpage.pl [Mon Jul 13 15:56:11 2009] [error] [client] [Mon Jul 13 15:56:11 2009] mainpage.pl: # The request referenced an attribute that does not exist, referer: http://koha.example.com:8080/cgi-bin/koha/mainpage.pl [Mon Jul 13 15:56:11 2009] [error] [client] [Mon Jul 13 15:56:11 2009] mainpage.pl: , referer: http://koha.example.com:8080/cgi-bin/koha/mainpage.pl thank you! > 1. Re: FW: Koha 3.0 LDAP Question? (Winter, James) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 13 Feb 2009 09:52:45 -0500 > From: "Winter, James" <WinterJ(a)arcadia.edu> > Subject: Re: [Koha] FW: Koha 3.0 LDAP Question? > To: "Barry Cannon" <bc(a)interleaf.ie> > Cc: koha(a)lists.katipo.co.nz > Message-ID: > <195366CE4CF91245936298EEA68FEA980AE3C41E(a)BISHOP.arcadia.edu> > Content-Type: text/plain; charset="us-ascii" > > Did you comment out the two lines in Auth_with_ldap.pm? If so, it won't > update or replicate the data. If you didn't, I would make sure you have > the property names correct. I would start with the required fields > (surname, address, city, branchcode, categorycode). > > > > Try using default values by setting is="" for those properties and put > text between the tags. <address is="">123 Test Street</address> for > example. If a person is created successfully with default values then > it's a property name problem. If not, it's a Koha problem. > > > > James Winter > > 215.517.2588 > > > > From: Barry Cannon [mailto:bc@interleaf.ie] > Sent: Friday, February 13, 2009 7:31 AM > To: Winter, James > Cc: koha(a)lists.katipo.co.nz > Subject: RE: [Koha] FW: Koha 3.0 LDAP Question? > > > > James, > > Thanks for this info...I can now authenticate against my > LDAP server with no problems. However, when I start enabling <replicate> > and <update> to try and add the AD users into Koha the replication > doesn't occur. The authentication still works but the users information, > as per mappings, doesn't come across into Koha. There are no errors > either? > > > > Does anyone have any suggestions? > > > > Thanks > > Bar > > > > From: Winter, James [mailto:WinterJ@arcadia.edu] > Sent: 12 February 2009 17:35 > To: Barry Cannon > Cc: koha(a)lists.katipo.co.nz > Subject: RE: [Koha] FW: Koha 3.0 LDAP Question? > > > > Sure, it took me a while to get it working, but we have it working now. > > > > In our koha-conf.xml, we have this section in the config section > (between <config> and </config> near the end of the file): > > > > <useldapserver>1</useldapserver> > > <ldapserver id="ldapserver"> > > <hostname>LDAPSERVERNAMEHERE:389</hostname> > > <base>dc=DOMAIN,dc=COM</base> > > <user> CN=[USER THAT CAN BROWSE ACTIVE DIRECTORY],OU=[OU OF USER > (MULTIPLE ENTRIES IF NESTED OU)],DC=DOMAIN,DC=COM </user>  > > <pass>[PASSWORD OF USER]</pass> > > <replicate>0</replicate>  > > <update>0</update>  > > <mapping>  > >  > >  > >  > >  > >  > >  > >  > > <userid is="samAccountName" ></userid> > > <password is="" ></password> > >  > >  > >  > > </mapping> > > </ldapserver> > > > > Most of the attributes are commented out because we populate our users > in Koha from a different system and they only log in using their AD > password. We don't want to add new users or update existing users. > > > > Then in Auth_with_ldap.pm at line 102 (thanks to this thread > http://lists.koha.org/pipermail/koha-devel/2008-September/008355.html) > > > > Change these lines: > > > > my $userldapentry = $search->shift_entry; > > my $cmpmesg = $db->compare( $userldapentry, > attr=>'userpassword', value => $password ); > > if ($cmpmesg->code != 6) { > > warn "LDAP Auth rejected : invalid password for user > '$userid'. " . description($cmpmesg); > > return 0; > > } > > > > To this: > > > > my $userldapentry = $search->shift_entry; > > > > my $dbuser = Net::LDAP->new( [$prefhost] ); > > $res = $dbuser->bind( $userldapentry, password => $password ); > > unless ( $db && ! $res->code ) { > > warn "LDAP Auth rejected : invalid password for user > '$userid'"; > > return 0; > > } > > > > We had an additional problem with the Auth_with_ldap.pm automatically > updating the card number with the user's login. We have existing cards > with specific numbers that we're importing, so I had to disable a couple > of other lines (lines 116 and 117 in Auth_with_ldap.pm, before the first > edit.) > > > > #($config{update} ) and my $c2 = > &update_local($userid,$password,$borrowernumber,\%borrower) || ''; > > #($cardnumber eq $c2) or warn "update_local returned > cardnumber '$c2' instead of '$cardnumber'"; > > > > Hopefully this helps. > > > > James Winter > > 215.517.2588 > > > > From: Barry Cannon [mailto:bc@interleaf.ie] > Sent: Thursday, February 12, 2009 12:06 PM > To: Winter, James > Subject: RE: [Koha] FW: Koha 3.0 LDAP Question? > > > > Yes, I am using Active Directory. Do you have any tips? > > > > From: Winter, James [mailto:WinterJ@arcadia.edu] > Sent: 12 February 2009 17:06 > To: Barry Cannon > Subject: RE: [Koha] FW: Koha 3.0 LDAP Question? > > > > Are you using Active Directory? > > > > James Winter > > 215.517.2588 > > > > From: koha-bounces(a)lists.katipo.co.nz > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Barry Cannon > Sent: Thursday, February 12, 2009 9:17 AM > To: koha(a)lists.katipo.co.nz > Subject: [Koha] FW: Koha 3.0 LDAP Question? > > > > I have been trying to configure LDAP and have a couple of questions: > > > > The Wiki says: There are two parts of the KOHA_CONF file (default > location: /etc/koha.xml) relevant to LDAP authentication: the > configuration stanza itself, and the "switch" line that enables or > disables LDAP. The switch appears in the main <config> section, 0 for > "off" and 1 for "on",.... > > > > Should I take this to mean the koha-conf.xml file? There is no koha.xml > file on our installed server? If it is this file, do I simply add the > LDAP server options in the config file. > > > > I have assumed that is what is needed but I can't figure out where to go > from there? Is there an Admin tool to configure/test the LPAD > authentication? > > > > Thanks > > Barry > > > > > >

1 0

MySQL DB Location
by Roche III, Edward 13 Jul '09

13 Jul '09

I would like to change the location of my Koha db to a different drive. Can someone tell me the best way to do this? 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?"

2 1

Search by shelving location?
by Emrys Minnig 13 Jul '09

13 Jul '09

Are there any plans for a future release of Koha to include an option to refine/limit one's advanced search by shelving location ($952c)? Emrys

2 1

Export patrons
by Cab Vinton 13 Jul '09

13 Jul '09

Koha 3.0 has a tool for importing patron data, but no tool for exporting patron data. This would come in very handy for making batch edits to large or large-ish numbers of patrons: Export all data, edit as needed, then import. (I believe the Import tool only allows for over-writing the entire patron record, rather than just any fields that happen to be non-null.) If I have things right here, is there a canned report that will effectively export all the data? Is there any danger of de-linking circ data with the corresponding patron record? Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH

2 3

upgrade
by vinod kumar 13 Jul '09

13 Jul '09

hello how to koha 3.00.00 upgrade in 3.00.03 plz sugesst me Thanks & Regrds v Kumar

2 1

Koha to MARC links issue
by Marisa Wood 13 Jul '09

13 Jul '09

Hi again, We have just installed 3.0 and I've not touched the Koha to MARC links, but when I run the Framework test I get an error for a couple of fields. The message reads: "The biblio.biblionumber and biblioitems.biblioitemnumber fields be mapped to a MARC subfield." I'm not finding this sentence very helpful... They're currently mapped to 999$c and 999$d, respectively. . Any suggestions? Thanks a lot! Marisa Wood, MLIS Member Support Specialist BCR 14394 E. Evans Ave. Aurora, CO 80014 303.751.6277/800.397.1552

3 6

Problem in Installation of KOHA-3.00.03 in fedora 10
by Sivasankari 13 Jul '09

13 Jul '09

Hi All, I have asked a query mentioned below. The following fatal error has occurred: Can't locate ZOOM.pm in @INC Some of members have answered it. Thanks for those replies. Koha was already installed in my machine at /usr/shar/KOHA-3.00.03. - I have already ran the perl Makefile.PL from the /usr/share/koha-3.00.03 folder , then make,make test,make install and then web installer launched, which shows the error in browser , can't locate zoom.pm in @Inc in the web browser window while i gave http::/<ipaddress>:80/ . I started the process of installing the left over prerequisite module Net::Z3950::ZOOM 1.16. Which needs yaz and zebra to be installed. I searched and found the yaz rpm for fedora10, and installed yaz ( yaz-3.0.34-1.fc10.i386.rpm). But for idzebra i dont find the rpm for fedora10. it is available for fc6. Hence i downloaded idzebra-2.0.8.tar.gz. unzipped it and ran the ./configure,Make,Make install. After this , I called cpan > reload cpan . Now I gave cpan > force install Net::Z3950::ZOOM It shows the errors ====Screen output ========== cpan[2]> force install Net::Z3950::ZOOM Running install for module 'Net::Z3950::ZOOM' Running make for M/MI/MIRK/Net-Z3950-ZOOM-1.25.tar.gz Has already been unwrapped into directory /root/.cpan/build/Net-Z3950-ZOOM-1.25-zyzKPg '/usr/bin/perl Makefile.PL' returned status 512, won't make Running make test Make had some problems, won't test Running make install Make had some problems, won't install =======Screen Output================ What shall i do? Will there be problem with installation of this module with Fedora10. I'm unable to launch koha with web installer. Since this essential module is needed. Did i need to uninstall koha and start from beginning. Or else can i run once again /usr/shar/KOHA-3.00.03.>perl Makefile.PL - reinstalling koha directly. Kindly help me out on this. Thanks in advance Sivasankari

4 5

authority control and cataloging
by Anna Kågedal 13 Jul '09

13 Jul '09

Dear all, I am a librarian with hardly any cataloging experience since library school, and I am now trying to learn how to catalog in Koha 3.0 that we are implementing in our school library. (We are changing from an old follett system). I have some problems, one of my major problems is the authority control for example Personal names. I understand the value, but I can't get it to work? It is there as a default, but I don't understand how to add the authority to search in? And I read some instructions that if no authority record is found, I'm supposed to be able to enter the author name manually, but I can't do that. The 100 9 and 100 a continues to be grey and non-writable. Is there a database to upload for this authority control ? Since our catalog is quite messy to begin with, we already have the problem of names entered differently, but with the smart search in koha I don't find it as problematic as in our old system, so I am thinking of "turning" authority control off. Problem is I don't understand how to do that either. Anyone who can help out? Anna ++++++++++++++++++++++++ Anna Kågedal Kodaikanal International School Seven Roads Junction Kodaikanal 624101 Tamil Nadu, India home phone: +914542247269 cell phone: +919994535493 http://boxofbarfi.blogspot.com http://twitter.com/kislibrarian

2 1

Cataloguers level
by Hugo Agud 13 Jul '09

13 Jul '09

Dear all We re trying to creare diffferent cataloguers level, in order to let non librarían do a light cataloguong but we cant ser how Is for a school libeary, any suggestion Thanks in advance Enviado desde mi iPhone

3 4

Re: [Koha] [Koha-devel] duplicate items showing
by Jesse 13 Jul '09

13 Jul '09

Koha should pop up a duplicate warning when the entered ISBN or barcode already exists in the catalog. If it isn't, it might indicate a problem with your setup. 2009/7/12, Zico <mailzico(a)gmail.com>: > Hi, if any member of my team enters one item twice... my koha accept those > and when i searches for that item... it shows twice or thrice or something > like these. I want to close this duplication. > > I want two things. > > 1. If anyone adds same item second time, koha will show that, "it has been > already added" > 2. By mistake, if it occurs.... the searching will never show one item > twice. > > How can i do that? > > -- > Best, > Zico > -- Jesse Weaver

1 0