- Koha - lists.katipo.co.nz

Installing Mysql 4 on Fedora Core 6 or getting Mysql 5 to work with Koha
by Krsnendu dasa 02 Feb '07

02 Feb '07

Please help. I have been stuck for a long time and really want to get koha going on my Fedora Core 6 system. How do I install Mysql 4? I went to rpm webite and downloaded the rpm, but it complained about dependencies. Do I just use --nodeps and hope or what? It seems that openssl is what is holding things up the dependencies are libssl.so.0.5 and libcrypto.so.0.5 Alternatively, how can I get Koha going with mysql 5? Will there be a new version soon with this compatability? Please help. School is starting soon and I want to get this rolling. Thanks. Krsnendu dasa

3 2

tmpl_process3.pl script not running
by arnab 02 Feb '07

02 Feb '07

Dear All, When trying to run the script tmpl_process3.pl getting an error - Can't locate Locale/PO.pm. Could any body tell what perl module I've to install for running the script - tmpl_process3.pl With Regards, Arnab -- View this message in context: http://www.nabble.com/tmpl_process3.pl-script-not-running-tf3160497.html#a8… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Apache Default Page
by Lawrence Bean 02 Feb '07

02 Feb '07

I posted this problem to the list last May, and someone *must* have helped me solve it because I had this working for the last nine months. I had to migrate to new hardware and the same puzzle has resurfaced. I checked the archives, but cannot find the helpful reply anywhere so I assume the respondent must have re'd me only. I simply cannot remember what the fix was, so I post it again in hopes the answer may appear once more. ---------- Hello folks. I just successfully finished setting up KoHa on a Macintosh running 10.4 Tiger. When at the koha computer, I open a web page and type http://localhost and up pops the opac main page just like it should. However, accessing from a remote machine with http://172.16.1.11 brings up the Apache default page. To test locally, I went to the koha machine and double-checked the IP address, which is correctly 172.16.1.11, then tried http://172.16.1.11 right at the koha machine, and up came the Apache default page. Switching to the loopback IP, though, http://127.0.0.1 brings up KoHa. I even tried: http://172.16.1.11/cgi-bin/koha/opac-main.pl at the koha machine and got the "Not Found" response. So, it seems there is a setting in Apache that I missed. Any help, or pointing me in the right direction to help myself, would be greatly appreciated.

2 3

STMP port configuration
by arnab 31 Jan '07

31 Jan '07

Dear All, When patrons are sending some suggestion to the library staff, they are not geting the message. Is the message are send as e-mail. Then is there any other configuration to be made for getting the mail. With Regards, Arnab -- View this message in context: http://www.nabble.com/STMP-port-configuration-tf3147951.html#a8726726 Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Re: [Koha] Can't locate Locale/PO.pm
by Rob Weir 31 Jan '07

31 Jan '07

Hi Arnab, I think you need the Locale-PO module. If your box has an internet connection, it should work to open a command prompt window and type: ppm install Locale-PO I will add this module to my windows install package in the near future. Rob > -------Original Message------- > From: arnab <arnabsadhukhan(a)kolkatacdac.in> > Subject: [Koha] Can't locate Locale/PO.pm > Sent: 30 Jan '07 12:05 > > > Dear All, > > When trying to run the script tmpl_process3.pl getting an error - Can't > locate Locale/PO.pm. > Could any body tell what perl module I've to install for running the script > - tmpl_process3.pl > > With Regards, > Arnab > > -- > View this message in context: http://www.nabble.com/Can%27t-locate-Locale-PO.pm-tf3142000.html#a8708257 > Sent from the Koha - Discuss mailing list archive at Nabble.com. > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

3 3

Accessing intranet page over network (again)
by Peter Scott 31 Jan '07

31 Jan '07

Hi Folks, I'm still having an issue on this :( I have a Ubuntu 6.06 server installation, and all my clients are W2K (network server is W2003 server, providing DNS, using hosts file on clients for testing) I followed the install instructions for Koha on Debian (supplimented by the installing koha on ubuntu notes) from the doc site. The instructions say "install Apache 2.2" and give the command "apt-get install apache2" to perform this. I have noticed (now) that this has installed apache 2.0.55, rather than 2.2. Is this release OK or do I really need apache 2.2? Is there anyone else out there running Koha on Ubuntu? I wouls like to talk to other users on this platform to discuss issues! I have tried all the permutations I can think of in the koha-httpd.conf, ports.conf and httpd.conf on the server and in the hosts file on the client, and still can't get the intranet page to open. Interestingly, I installed Koha on my W2K pc, so we could evaluate the package - with the intention of putting up on Linux if we decided to use koha - and had no problems getting the intranet page to open across the network. Thanks in advance, Regards, Peter Peter Scott IPPA, The Early Childhood Organisation Unit 4 Broomhill Business Complex Broomhill Road Tallaght Dublin 24 Tel: 01 4630010 DDI: 01 4630015 Fax: 01 4630045 Web: www.ippa.ie < http://www.ippa.ie/> IPPA, the Early Childhood Organisation, is funded by the Irish Government under The National Development Plan 2000-2006 and the European Union through the European Structural Fund. This e-mail and any files transmitted with it are confidential (and may contain privileged information) to the ordinary user of the e-mail address to which it was addressed and must not be copied, disclosed or distributed without the prior authorisation of the sender. Please notify the sender and destroy this e-mail immediately if you are not the intended recipient. Please also note that while our own software systems have been used to try to ensure that this e-mail has been swept for viruses, we do not accept responsibility for any damage or loss caused in respect of any viruses transmitted by the e-mail. Please ensure your own checks are carried out before any attachments are opened.

4 3

Koha newbie
by Jacqueline Barry 31 Jan '07

31 Jan '07

Hello everyone. I am a Koha newbie thinking about implementing Koha 2.2.7 in a small (about 2000, one room) special collections library. Our current interface is horrible but luckily, all our collection/catalog information can be exported to Excel. However, upon looking into Koha, I see that it uses MySQL, does this mean we would have to re-enter the entire collection??? Does anyone have any experience transferring from another ILS to Koha? Any input would be extremely helpful!! Thank you! -Jackie -- Jacqueline Barry jacqueline.barry(a)gmail.com

2 1

Cleaning characters from isbn data
by Noth 31 Jan '07

31 Jan '07

Hi All, I've imported my data using bulkmarcimport.pl and it looks as though the old system/librarian has added some garbage characters to the end of the isbn number. Nothing too serious but it means that the majority of the book searches fail. An example of a isbn: 0-958760-497 (pbk.-) Unfortunatly the characters arent all the same so a simple find and replace on the 4000+ records isn't going to do the trick. Its obvious that Koha already does some conversion on the isbn (since the "-" symbols weren't in there before) and I'm wondering where it does this, so that I can add some code to clean garbage characters (i'm thinking that removal of characters after a space is detected should do the trick) or if anyone has done something like this before? Great system by the way. Cheers, Noth -- View this message in context: http://www.nabble.com/Cleaning-characters-from-isbn-data-tf3146978.html#a87… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Indexing
by Lenora Oftedahl 31 Jan '07

31 Jan '07

Ok. An update on my indexing problem... I can use the other fields as long as I specify something other than 'contains'. So, I'm indexing complete fields, but not keywords. Which script do I look at to fix this one? Or is this a mysql problem? RUNNING: Koha version2.2.5 OS version ('uname -a')Linux maple 2.4.27-2-386 #1 Wed Aug 17 09:33:35 UTC 2005 i686 GNU/Linux Perl version5.008004 MySQL versionmysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386) Apache version Thanx. -- *************************************** Lenora A. Oftedahl, MLS MEPM StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission 729 NE Oregon St, Ste 190 Portland, OR 97232 503-736-3581 / ARIEL: 207.173.155.8 503-731-1260 FAX OFTL(a)critfc.org http://www.fishlib.org ************************************* "One by one, the penguins are stealing my sanity" ************************************** "Don't worry about the world coming to an end today. It's already tomorrow in Australia." --(Charles Schultz) ************************************** "The problem with adults is that they are contaminated by experience." --Kumi Naidoo, General Secretary and CEO of CIVICUS **************************************

1 0

Re: [Koha] Re: Error creating MySQL database during installation.
by Krsnendu dasa 31 Jan '07

31 Jan '07

I can uninstall 5 easily using yum. When I go to install 4 I get problems because of dependencies. It wants a different version of OpenSSL etc. On 30/01/07, Chris Hammond-Thrasher <hammondthrasher_c(a)usp.ac.fj> wrote: > Krsnendu, > > I would recommend getting rid of mysql 5 and putting on mysql 4. There is a > way to get mysql 5 to work, but it is troublesome and requires sql language > expertise. > > It has been a while since I used fedora, but can't you remove or uninstall > mysql 5 with the rpm tool? (I think the command is "rpm -e mysql" or > something similar.) Or did you compile mysql 5 yourself? > > -cht > > > Chris Hammond-Thrasher MLIS > Library Systems Manager > University of the South Pacific > Suva, Fiji > +679 3232233 > hammondthrasher_c(a)usp.ac.fj > -----Original Message----- > From: Krsnendu dasa [mailto:krsnendu108@gmail.com] > Sent: Monday, 29 January 2007 2:01 PM > To: Chris Hammond-Thrasher > Subject: Re: [Koha] Re: Error creating MySQL database during installation. > > HELP! > I still can't install Koha on my Fedora Core 6 (K12LTSP-6) machine > because of the mysql 5 incompatability. Can someone help me to get > around this? How can I uninstall mysql 5 and install mysql 4. Or is > there some other solution? > > > > On 25/01/07, Chris Hammond-Thrasher <hammondthrasher_c(a)usp.ac.fj> wrote: > > I have not tried out koha on fedora - my experience is limited to debian. > > However, you should be able to uninstall mysql 5 using the rpm tool then > > install mysql 4 - which is officially supported. Rumor has it that the > koha > > dev team knows how to make mysql 5 work, but they have not yet added the > > required code to a formal release. > > > > All the best! > > -cht > > > > > > Chris Hammond-Thrasher MLIS > > Library Systems Manager > > University of the South Pacific > > Suva, Fiji > > +679 3232233 > > hammondthrasher_c(a)usp.ac.fj > > -----Original Message----- > > From: koha-bounces(a)lists.katipo.co.nz > > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Krsnendu dasa > > Sent: Thursday, 25 January 2007 2:21 PM > > To: koha(a)lists.katipo.co.nz > > Subject: [Koha] Re: Error creating MySQL database during installation. > > > > Seems that Mysql 5 is incompatible with Koha. How can I downgrade to > > mysql 4.1 on Fedora Core 6? > > > > On 25/01/07, Krsnendu dasa <krsnendu108(a)gmail.com> wrote: > > > Below is the error message I get. The seems to be a problem with user > > > kohaadmin. Any clues what I need to do to fix this? > > > I am using Fedora Core 6 and the mysql version is 5.0.27 > > > > > > Creating the MySQL database for Koha... > > > > > > ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' > > > (using password: YES) > > > > > > DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied > > > for user 'kohaadmin'@'localhost' (using password: YES) at > > > /usr/local/koha/intranet/modules/C4/Context.pm line 411 > > > Can't call method "prepare" on an undefined value at > > > scripts/updater/updatedatabase line 1541. > > > Problem updating database... > > > [root@k12ltsp1 koha-2.2.7]# > > > > > _______________________________________________ > > Koha mailing list > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > >

1 0