- Koha - lists.katipo.co.nz

Additonal help needed on circulation reports solved.
by Scott Zollars 14 Jul '09

14 Jul '09

Thanks Joe for the report. It worked great and I was able to adapt it to make a Daily Circ Report by only adding AND DAY (datetime) = 9 It works great too. Thanks and my computer and staff thank you too. Scotty Zollars Director of Library Services Labette Community College 200 S. 14th Parsons, KS 67357 620-820-1168 620-421-1469 FAX

1 0

KOHA - cataloging doubts
by Sivasankari 14 Jul '09

14 Jul '09

Hi, I have installed koha with (Unimarc). But in Admin - system preference - I have changed to MARC21 format. Will it work out. Hope the koha system is changed to adapt the MARC21 format or will it retain the unimarc format, which i gave in koha installation - perl makefile.pl in linux. I have set no zebra. since I'm not using millions of records. I'm doing a sample. How to do cataloging. How to add the books to the library. IS there any sample file provided. I'm a techie ,totally ignorant of library systems, isbn etc. I would like to add some 50 books to the library . How should i do it? Thanks in advance Sivasankari M

2 1

custom logo for 3.0.03 - user.css
by ISM KIS 14 Jul '09

14 Jul '09

I had installed 3.0.01 and customized the logo size in opac.css. It worked fine. Now I have installed 3.0.03 and I did replace the opac.css file in the ../opac-tmpl/prog/en/css folder but the logo shows in the default size. Where or how do I change the logo in 3.0.03 ? Rudy Wuthrich Kodaikanal International School

2 1

Set permissions problem
by Vimal Kumar 14 Jul '09

14 Jul '09

Dear Friends, My question related with Setting staff permissions. I would like to limit “Set permission” only on Circulation module for a library staff. I assigned only “Circulation” from “Set Permissions” for the staff. But unable to login to Koha staff client using his id and password. It shows “*Error: *Unauthorized userclick to log out”.<http://localhost:8080/cgi-bin/koha/mainpage.pl?logout.x=1> Whats the solution for this problem?<http://localhost:8080/cgi-bin/koha/mainpage.pl?logout.x=1> Thanking you, <http://localhost:8080/cgi-bin/koha/mainpage.pl?logout.x=1> -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

Out of Office
by Wei Wei LEE 14 Jul '09

14 Jul '09

I will be out of the office starting 14/07/2009 and will not return until 22/07/2009. I will respond to your message when I return. For urgent matters, please contact Ms Ho Lam Fong at 6332 1812 for assistance.

1 0

all arguments must be marc
by Anna Kågedal 14 Jul '09

14 Jul '09

Dear excellent list members, I have a problem when trying to import from the z39.50 servers that comes as default in 3.0 When I try to import this message comes: The following fatal error has occurred: All arguments must be MARC::Field objects at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 146 Apache Server version: Apache/2.2.10 (Linux/SUSE) Server built: Dec 3 2008 10:04:51 Koha 3.00.02.012 Koha DB 3.0002012 MySQL mysql Ver 14.12 Distrib 5.0.67, for suse-linux-gnu (i686) using readline 5.2 OS Linux koha 2.6.27.21-0.1-pae #1 SMP 2009-03-31 14:50:44 +0200 i686 Perl 5.010000 Thing is, it sometimes work, and sometimes it doesn't but I can't see the pattern on when it works and when it doesn't. Has anyone else encountered this problem and hopefully solved it? Thanks a lot 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

1 0

Additonal help needed on ciruclation report
by Scott Zollars 14 Jul '09

14 Jul '09

The Circulation report that I requested help on is progressing, thanks to everyone who contributed help. This one is for daily circ but could also be adapted for monthly. I obviously am still having trouble with my Biographies (B) and Fiction (F). On this day, we had one biography and two fiction checked out. I have no idea where the other numbers are coming from. Currently my squl is as follows. I have cut and pasted and tried different variations that in my mind should work. So, I am back to have the collective eye tell me the obvious thing that I am missing. SQUL select substring(itemcallnumber,1,1) as 'Call# range', count(*) from items, statistics where statistics.itemnumber = items.itemnumber and type in ('issue', 'renew') and date(datetime) between '2009-07-09' and '2009-07-09' and itemcallnumber is not null and length(itemcallnumber) and substring(itemcallnumber,1,1) between '0' and '9' or substring(itemcallnumber,1,1) = 'F' or substring(itemcallnumber,1,1) = 'B' group by substring(itemcallnumber,1,1) This results in the following. Everything is fine but the F's and B's CIRC Total number of rows matching the (unlimited) query is 1. Call# range count(*) 0 1 1 1 7 1 B 145321 F 225423 Scotty Zollars Director of Library Services Labette Community College 200 S. 14th Parsons, KS 67357 620-820-1168 620-421-1469 FAX

2 1

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

13 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