- Koha - lists.katipo.co.nz

Re: [Koha] Changed IP - Can't connect to mysql server
by Robert Linebaugh 15 May '08

15 May '08

Mason - Thanks for all the help. Actually your previous email with those troubleshooting commands helped me find the problem. Once I discovered I could not telnet on port 3306 to the remote server I found that port 3306 on the database server was only open to one IP. I changed the IP to the new one and telnet worked. I then tried connecting to the remote database from a client using the mysql command you suggested and still could not connect. I looked to see if any linux firewall rules were enabled on the remote database server and found everything to be locked down to only allow communication from one server. I updated the rules with the appropriate IP and everything started working again. Thanks again for pointing me in the right direction. Rob From: Mason James [mailto:mason.loves.sushi@gmail.com] Sent: Monday, May 12, 2008 10:11 PM To: Robert Linebaugh Cc: koha-devel(a)nongnu.org Subject: Re: [Koha] Changed IP - Can't connect to mysql server On 2008/05/13, at 3:44 AM, Robert Linebaugh wrote: The my.cnf is located at /etc/my.cnf. Below is the info. I don't seem to have a bind-address. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid HI Rob Hmm, the 'bind-address' option is a mysql5-ism, i think.. Have a look here for info on your mysql4 issue http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html Cheers, Mason.

1 0

Re: [Koha] Using Koha for photo archive
by Jason Noble 15 May '08

15 May '08

I'm having this same problem but can't get it to work. I have the 856u field setup, the link pointing to the file, the image shows up if I access it directly the web browser. The 856u field shows the correct URI in the MARC view, but the normal view does not display the image. Is there something more I need to do? Does anyone else have this working on Koha3? Thanks, Jason

4 3

Data integrity testing
by Cab Vinton 14 May '08

14 May '08

Hi, All: Our new test database has just gone online (thank you, Liblime), and I'm wondering if there's a standard set of routines that we should apply to the database to check how smoothly our data migrated. I've been doing a number of title, author, subject, ISBN, etc. searches, for a variety of item formats, checking the appearance of the Results & Item displays, etc. But I'm wondering what I might be missing by using such a seat-of-the-pants process. Grateful for any suggestions that would help me identify whatever issues may be lurking. With thanks, Cab Vinton Sanbornton Public Library Sanbornton, NH

1 0

KOHA
by Suzanne Gilbert 14 May '08

14 May '08

Hello, I would like to get back on the list to submit questions, etc. about KOHA. We are using one of the oldest version and recently upgraded to the 3.0 version and are in the processing of trying to figure that out. Anyway, I'm not sure if this address is current or if I will have to try elsewhere. Suzanne Gilbert Immaculate Heart of Mary School Monona, WI sgilbert(a)ihm-school.org

2 1

Change default search to just one branch
by Scott Owen 14 May '08

14 May '08

Hi all, I have a working setup of Koha 2.2.9 on Windows, and I am planning on using it for 3 elementary (k-5th grade) libraries. I have several questions, but the first is regarding the default search page (OPAC). I have removed most of the page, and only left the search options (as my younger students probably have no need for much else...), and now I would like to provide them with a link directly to a search for their specific branch (school). Rather than the default being a search of all locations (branches) I would prefer that they have a default of their specific branch. Is there an easy http: link in the OPAC site, or some other way to accomplish this? TIA. -Scott Owen Alma Public Schools

1 0

loc search function not working
by Carmel Young 14 May '08

14 May '08

Status: Koha 2.2.9 Installed on a Windows platform. When I use the search funtion with both amicu and loc ticked, I get the following error message. <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"><html><head> <title>500 Internal Server Error</title> </head><body> <h1>Internal Server Error</h1> <p>The server encountered an internal error or misconfiguration and was unable to complete your request.</p> <p>Please contact the server administrator, webmaster@dummy-opac and inform them of the time the error occurred, and anything you might have done that may have caused the error.</p> <p>More information about this error may be available in the server error log.</p> </body></html> 2. If I only use amicus (i.e. untick loc) I am able to get a return, but not for the specific ISBN. A general title, Introduction to teaching, Principles and practice, yields results. It is just not the book I am looking for. And this 'success' is erratic. Sometimes I only get a result - Ignored: for a well known fiction - Huckleberry Finn, or Jane Eyre. In Malawi, we have a working group trying to help each other, and I know Z39.50 works on Windows. Late in one workshop, we put in "Malawi's lost Decade" and presto - biblio was there!!! I have added two other z39.50 targets, one a voyager data base (Monash Uni), the other an ADVANCE data base(Griffith Uni). Could it be that I have stuffed up something in configuration so that only the NL(amicus) database works? Thanks for listening, Carmel.

1 0

Re: [Koha] Koha Barcode Question
by Stephen Hedges 13 May '08

13 May '08

Hello, Emmanuel - I'm copying my reply to the Koha mailing list; the Koha community is the best place to get answers. I do know of a document discussing CDS/ISIS migration: http://www.kohadocs.org/CDS_ISIS_to_Koha.html As for accession numbers as barcodes, they won't break anything in the Koha code (that I know of). I think that decision has to be based entirely on the procedures within your library. If it's easier to use accession numbers and it won't cause problems for you, then why not? Stephen On Tue, May 13, 2008 at 12:04 PM, Emmanuel Mulo <muloem(a)gmail.com> wrote: > Hello Stephen, > > I skimmed through your Koha diary and was wondering whether you are > able to help me out with a pointer. I am working at a university in > Uganda (East Africa) and we would like to transfer from CDSISIS to > Koha as a library management system. I have done the installation and > a number of tests already. At the moment I am moving to generate > barcodes for the library books. I was wondering what your advice is > on the use of accession numbers to generate barcodes. Please advise. > > Thanks > Emmanuel Mulo >

1 0

step 3 loop in installer, and a long story
by Tim Middleton 13 May '08

13 May '08

I'm attempting to get 3.0 beta 2 running to evaluate. I've had a few difficulties, but have it up and running far enough to get to port 8080 and run the web installer, however the web installer will not advanced past step 3 for me. The last page before the loop says "Success" and "Database tables created", but then the "Next>>" button just goes back to "Now we're ready to create the database..." I note that no tables have yet been created in the database. And first of the raft of errors submitting step 3 sends to the web log appears to be a database lookup: install.pl: DBD::mysql::st execute failed: Table 'koha.language_subtag_registry' doesn't exist at /home/x/koha/lib/C4/Languages.pm line 178. I in the logs that installer.pl seems to be trying to do a large number of lookups (presumably for configuration options) at every step, even step 1... so perhaps this is a red herring, and these lookups are logged and supposted to fail gracefully until the tables/data gets created. Googling found me: http://lists.koha.org/pipermail/koha-cvs/2007-July/014261.html A checkin which states step 3 loops if <kohaversion> does not exist in xml a loop like I am experiencing will occur. And indeed there is no <kohaversion> in my koha-conf.xml ... but surely this is an old bug which would no longer apply, and why would my generated koha-conf.xml not have the tag if it was needed? Any ideas? Anyhow, for the record, if anyone is interested, I also wanted to share my experience up to this point. I'll try to be as brief as I can. I'm doing this on a FreeBSD 7.0 amd64 machine. Apache 2.2.8, perl 5.8.8, Zebra 2.0.28. I'm a fairly experienced sysadmin. I read the INSTALL file, and hence ran the perl Makefile.PL. I chose the local install option, seeing the install directory to ~/koha. No problems. I noted the long list of warnings about missing perl modules at the end, but fired up the browser to 8080 anyhow to see what would happen. The errors were strange in the web logs, and nothing at all printed via browser, and i haven't really used perl for nearly a decade ... but i started hacking away anyhow trying to get a meaningful error message. The error message I was getting was: Can't locate object method "preference" via package "C4::Context" at /home/x/koha/lib/C4/Context.pm line 30. Commented some stuff out in Context.pm which eventually at least started getting the perl error messages dumped to the browser, where I could see the real error message was: Can't locate CGI/Session.pm in @INC And so I realised I am indeed going to have to install all those missing perl modules before getting any further. Now, what modules to install again? I looked on the wiki and see the install instructions for all sorts of platforms, but all of those instructions seem rather specific lists of commands, and assume various distros have some modules already installed, etc. Anyhow, i decided to try install-CPAN.pl, which I'd noticed mentioned in the INSTALL text. Didn't work at all for me. I have no idea why. I wasn't too disappointed, and didn't try too hard with it, because I really didn't want to spam my test system with a hundreds of perl modules anyhow. But next i searched through the source code to find whatever was generating the list of warnings the Makefile.PL had given me. I found the list of modules in (but surprise!) Makefile.PL. I then fiddled with "perl -MCPAN" until i figured out how to install modules using it to ~/koha rather than the system. A few false starts there trying to automate the process with shell script and the list ripped from Makefile.PL, but eventually i got all the modules and dependencies installed under ~/koha/lib (and did a bunch of fiddling with the apache SetEnv to get all the @INC paths needed) and the :8080 web interface seemed to work okay at that point. Now i should mention, I chose Pg for database driver when asked in Makefile.PL. I had my trusty postgresql database set up and ready to go. It was only later that I read in the mailing list that reportedly postgresql support doesn't really work at all. )-: I had been excited to read that postgresql would be supported. Maybe the Makefile.PL should be more clear than just saying it's "experimental"? I had tried installing using it anyhow, to see what would happen. I made it to the step 3 loop described above. Wondering if it was postgresql that was the problem there, I scrounged up a MySQL 5.0 instance and set it up for koha. I went into ~/koha/etc/koha-conf.xml and changed the driver name and port. And I ended up on the step 3 loop again. That's my story. Points to perhaps take away if you got this far: - Might be nice if the web installer script, as a very first step, simply checked dependency problems and gave a simple error if it found them (there seems to be a check at step 2 actually, but if some dependencies are missing (CGI::Session!) one never gets that far.) - weird how the languages in the dropdown on step 1 are seemingly in random order. - might want to discourage more strongly the use of postgresql if indeed it really doesn't work at all. - might be nice if install-CPAN.pl (whatever it does) could install CPAN modules locally as I did manually. Possibly this would be the case with the the .cpan/CPAN/MyConfig.pm i ended up using? I don't know. - are there generic install instructions anywhere? Something like an organized complete list of dependencies. A simple SQL file to set up the database? koha-conf.xml config file reference, which instructions on which settings absolutely needed to get the thing to run? I'll probably eventually look through install.pl and see if i can figure out what's going on. But hopefully it doesn't come to that. Sorry, somewhat failed in trying to be brief. <-;

2 1

Thank you
by Karina Tumon 13 May '08

13 May '08

Thank you all for your valued help regarding my query about 'Authorised Values' and setting up MARC framework. Your responses have made my work a little bit easier. I have just returned from holidays so I'm sorry for this delayed reply. Kind regards, Karina Tumon

1 0

Setting a global due date
by Marie Wardall 12 May '08

12 May '08

Is there a way to set a global due date in Koha? We are an elementary school using Koha 2.2.9 and we are nearing the end of the year. We usually pick a date that all books will be due back by---can we set that date somewhere and can we set the calendar for dates that we are not in session ie: holidays? Thanks, Marie Marie J. Wardall Library Media Specialist Mountain Bay Elementary School 8602 Schofield Ave. Weston, WI 54476 mwardall(a)dce.k12.wi.us Phone: 715-355-0302 ext. 5824 Change Today, Change Tomorrow, Keep Changing

3 2