- Koha - lists.katipo.co.nz

Re: [Koha] apache configuration and login problem
by Carmel Young 01 Apr '09

01 Apr '09

Hi, there. Still having problems trying to reset the databaseuser password. We have authentication denied because of too many failed attempts. We tried your suggestion: Try checking /etc/koha/koha-conf.xml. Find following section. We got stuck here: Access denied/ .... <config> <db_scheme>mysql</db_scheme> <database>koha</database> <hostname>localhost</hostname> <port>3306</port> <user>kohaadmin</user> <pass>kohaadmin</pass> > .... On 27/03/2009, Abhishek Amberkar [अभिषेक] <abhishek.amberkar(a)gmail.com> wrote: > On Thu, Mar 26, 2009 at 6:24 PM, Carmel Young > <carmely.cunima(a)googlemail.com> wrote: >> Using Koha 3.0.0 on Linux NOT WINDOWS! We have two problems. > > That's really good. :) > >> >> 1. Follow up to the login issue; >> >> Using Koha 3.0.0 on Linux. >> >> We had trouble with a failed file - you sent us some advice to use >> gedit, and we recovered this file. Unfortunately, another problem has >> arisen - cannot log into "kohadbuser" because of too many >> authentication failures - the exact message reads "Access denied for >> 127.0.0.1. The host has been blocked because of too many >> authentication failures." > > Try checking /etc/koha/koha-conf.xml. Find following section. > .... > <config> > <db_scheme>mysql</db_scheme> > <database>koha</database> > <hostname>localhost</hostname> > <port>3306</port> > <user>kohaadmin</user> > <pass>kohaadmin</pass> > .... > In your case database, user, pass may be different. So using that > information try to logging in MySQL from command line > > $ mysql -u kohaadmin -pkohadmin -h localhost > > Note : there is no space between "-p" and "kohaadmin" > If you are not able to get mysql prompt, "mysql>", then there's the > problem with login information. > > Then you may try login as a root user to mysql > $ mysql -u root -p<root_user_password> > > You should get mysql prompt "mysql>". Now try adding user for koha. > 1) First create database for koha, if not created already > mysql> CREATE DATABASE <databasename>; > > 2) Now add user who will use newly created koha database > mysql> GRANT ALL ON <databasename>.* FOR '<username>'@'<hostname>' > IDENTIFIED BY '<password>'; > > Replace <databasename>, <username>, <password> with your choice. > Replace <hostname> with localhost, since your mysql and koha > installation resides on same system. Please note that username, > hostname and password are in single quotes. > > 3) mysql> FLUSH PRIVILEGES; > 4) mysql> QUIT; > > Now, remember that, fields in "GRANT ALL" command should match to > /etc/koha/kona-conf.xml file fields, then only you will get proper > connectivity. > > >> >> The advice you sent us was for a Windows platform, but we are using Debian >> Etch. > > Debian Rocks!!! > >> >> 2. We want to configure the apache IP address, but we can't get to >> sites-available. When we type in "cd/etc/apache2/sites-available", it >> tells us there is no directory >> >> I hope this is not too many problems for you to solve... > > As Joe rightly pointed there's space after "cd" command. > > But let's check if you have apache installed or not. From command line try > > $ aptitude search apache | grep ^i > $ ls /etc/apache2 > > Post the output of both commands and /etc/koha/koha-conf.xml file's > database connectivity section to this list. > > > -- > With Regards > Abhishek Amberkar > > Learn to appreciate a beauty within... >

2 1

Search By Corporate Name
by Rovin 01 Apr '09

01 Apr '09

Hello, When i search the database for a book, and i select search by corporate name and i put the corporate name, it doesn't find anything. However, when i search by corporate name by phrase, it works. WHY? Regards Rovin -- View this message in context: http://www.nabble.com/Search-By-Corporate-Name-tp22791973p22791973.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Fwd: re:koha and zebra
by arun kumar 01 Apr '09

01 Apr '09

hi friends . i am arun kumar ,now i am installing koha3 on ubuntu8.10 ,i have choosen *zebra* option ,and i created my library and order and received the books ,but if i made a search in opac it shows that result not found . try to rebuild the index root@ubuntu-laptop:~#* export PERL5LIB=/usr/share/koha/lib* root@ubuntu-laptop:~# export KOHA_CONF=/etc/koha/koha-conf.xml root@ubuntu-laptop:~#*/usr/share/koha-3.00.00/misc/migration_tools/rebuild_zebra.pl -a * it shows the result as Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/zebradb/biblios Zebra authorities directory = /var/lib/koha/zebradb/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 ==================== REINDEXING zebra ==================== skipping biblios ==================== CLEANING ==================== root@ubuntu-laptop:~#*/usr/share/koha-3.00.00/misc/migration_tools/rebuild_zebra.pl -b * Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/zebradb/biblios Zebra authorities directory = /var/lib/koha/zebradb/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 1 Records exported: 1 ==================== REINDEXING zebra ==================== 10:36:24-01/04 zebraidx(7149) [log] zebra_start /etc/koha/zebradb/zebra-biblios.cfg 1.3.50 10:36:24-01/04 zebraidx(7149) [debug][log] zebra_register_open rw = 1 useshadow=1 p=0x9369268,n=,rp=(none) 10:36:24-01/04 zebraidx(7149) [log] enabling cache spec=/var/lib/koha/zebradb/biblios/shadow:4G 10:36:24-01/04 zebraidx(7149) [log] cache_fname = /var/lib/koha/zebradb/biblios/shadow/cache 10:36:24-01/04 zebraidx(7149) [log] profilePath=/etc/koha/zebradb/biblios/etc:/etc/koha/zebradb/etc:/etc/koha/zebradb/marc_defs/marc21/biblios:/etc/koha/zebradb/lang_defs/en cwd=/root 10:36:24-01/04 zebraidx(7149) [log] dir /tmp/ccVUlA8ixY/biblio 10:36:24-01/04 zebraidx(7149) [log] add grs.marcxml.record /tmp/ccVUlA8ixY/biblio/exported_records 0 10:36:24-01/04 zebraidx(7149) [log] zebra_end_trans 10:36:24-01/04 zebraidx(7149) [log] sorting section 1 10:36:24-01/04 zebraidx(7149) [log] Iterations . . . 458 10:36:24-01/04 zebraidx(7149) [log] Distinct words . 195 10:36:24-01/04 zebraidx(7149) [log] Updates. . . . . 0 10:36:24-01/04 zebraidx(7149) [log] Deletions. . . . 0 10:36:24-01/04 zebraidx(7149) [log] Insertions . . . 195 10:36:24-01/04 zebraidx(7149) [debug][log] zebra_register_close p=0x9369268 10:36:24-01/04 zebraidx(7149) [log] Records: 1 i/u/d 1/0/0 10:36:24-01/04 zebraidx(7149) [log] user/system: 2/0 10:36:24-01/04 zebraidx(7149) [debug][log] zebra_stop 10:36:24-01/04 zebraidx(7149) [log] zebraidx times: 0.20 0.02 0.00 10:36:24-01/04 zebraidx(7150) [log] zebra_start /etc/koha/zebradb/zebra-biblios.cfg 1.3.50 10:36:24-01/04 zebraidx(7150) [log] enabling cache spec=/var/lib/koha/zebradb/biblios/shadow:4G 10:36:24-01/04 zebraidx(7150) [log] cache_fname = /var/lib/koha/zebradb/biblios/shadow/cache 10:36:24-01/04 zebraidx(7150) [log] commit start 10:36:24-01/04 zebraidx(7150) [debug][log] zebra_stop ==================== CLEANING ==================== *root@ubuntu-laptop:~# /usr/share/koha-3.00.00/misc/migration_tools/rebuild_zebra.pl -z Must specify -b or -a to reindex bibs or authorities Please do '/usr/share/koha-3.00.00/misc/migration_tools/rebuild_zebra.pl --help' to see usage.* AFTER THIS I MADE A SEARCH FOR BOOKS IN MY LIBRARY , BUT STILL IT SHOWS RESULT NOT FOUND what shall i do further ,please help me friends -- WITH BEST WISHES ARUNKUMAR.P

4 3

Error(s) in your MARC configuration
by Sheldon T. 01 Apr '09

01 Apr '09

Hello, I am from the University of Guyana and I am currently testing Koha v3.0 (installed on linux OS). There are five frameworks and whenever the MARC Bibliographic Framework Test is run, it shows an error. I want to know if there is anyway that I can detect which framework has the error. Here is the screen shot of the error observed: http://www.nabble.com/file/p22808373/koha_error.jpg Regards, Sheldon -- View this message in context: http://www.nabble.com/Error%28s%29-in-your-MARC-configuration-tp22808373p22… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 2

Switch over from Newgenlib to koha????
by Navin Soni 01 Apr '09

01 Apr '09

Dear Professionals, Goog Mrng.. We are from INMAS, DRDO, Delhi. Presently we are using newgenlib (OSS), we had tried a lot to give AMC to Newgenlib developers (M/s Verus Solutions) at normal rates but they did not responded positive. We library people are not expertise in JAVA and supporting softwares of Newgenlib therefore now it is not possible us to continue work without technical support. As this software constantly requires technical support which we are not able to find out who may take AMC of this Newgenlib software. Now may I request on this forum who can guide us how to overcome this problem of AMC. In alternative, we are planning to either switch over to KOHA and migrate our records into KOHA 2.2.9 ver. or wait for any agency who can undertake the AMC of Newgenlib. I request all my fellow professionals on this forum to guide me in this regard. Waiting for help and guidance. -- ================================= Navin Kumar Soni INMAS, DRDO, Min of Defence, Brig SK Mazumdar Marg Delhi-110054. Ph: 01123985466, 09868459805 http://www.drdo.org/labs/inmas/index.html Email: navinsoni22(a)gmail.com, navin(a)inmas.drdo.in ===================================

1 0

Error in the framework
by Sheldon T. 31 Mar '09

31 Mar '09

There are three frameworks and, an error is generated and cannot be found. That I know because the MARC Bibliographic Framework Test showed that there is one error and it didn't say where is the error. I want to know if there is anyway that i can detect where the error is. thank you in advance -- View this message in context: http://www.nabble.com/Error-in-the-framework-tp22805231p22805231.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

install koha on debian
by MATALDA CHARLES 31 Mar '09

31 Mar '09

Hi I'm runing koha 3.00.01 on debian 5.0 , whatever i have a problem messages" # Sudo dpkg --set-selections,install-misc/debian pakages .... no such file or directory # Make install pl .....no such file or directory >and how to execute the code checkout after install koha ?? Matalda(a)fr.net _________________________________________________________________ See all the ways you can stay connected to friends and family http://www.microsoft.com/windows/windowslive/default.aspx

2 1

Search error
by mohan pradhan 31 Mar '09

31 Mar '09

I am using KOHA 2.2.9. When searched through quick search and any word, then the search results are displayed. But when searched with title, author, subject search option then the search are not displayed. Let me know to solve this problem. Regards, Sincerely yours, Dr. Mohan Raj Pradhan Member-Secretary HealthNet Nepal

1 0

Re: [Koha] fines list is not generated
by Nicole Engard 31 Mar '09

31 Mar '09

I'm not sure how to help with that - maybe someone else on the list has an idea. --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Sat, Mar 28, 2009 at 2:58 AM, jksamyal <jksamyal(a)gmail.com> wrote: > Thanks very much nicole, its working now.. > > One more problem is there. > While working in Koha, it automatically comes out of login and i have > to log on again. > > please guide me further... > > Jatinder kumar > > > > On Fri, Mar 27, 2009 at 3:57 PM, Nicole Engard > <nicole.engard(a)liblime.com> wrote: >> Sounds like you need a custom report - I have one that gives me all >> the patrons with fines and the amount of the fine: >> >> SELECT borrowers.cardnumber,borrowers.surname,borrowers.firstname,FORMAT(SUM(accountlines.amountoutstanding),2) >> as due FROM borrowers LEFT JOIN accountlines on >> (borrowers.borrowernumber=accountlines.borrowernumber) WHERE >> accountlines.amountoutstanding > 0 GROUP BY borrowers.cardnumber ORDER >> BY borrowers.surname asc >> >> >> --- >> >> Nicole C. Engard >> Open Source Evangelist, LibLime >> (888) Koha ILS (564-2457) ext. 714 >> nce(a)liblime.com >> AIM/Y!/Skype: nengard >> >> http://liblime.com >> http://blogs.liblime.com/open-sesame/ >> >> >> >> On Thu, Mar 26, 2009 at 11:51 PM, jksamyal <jksamyal(a)gmail.com> wrote: >>> We are using Koha 3.0 version. Now we are closing the semester and >>> exam are on. we want to generate a list of fines of defaulted >>> students. >>> Please guide me for this. >>> jatinder kumar >>> _______________________________________________ >>> Koha mailing list >>> Koha(a)lists.katipo.co.nz >>> http://lists.katipo.co.nz/mailman/listinfo/koha >>> >> >

2 1

install koha3 on debian
by MATALDA CHARLES 31 Mar '09

31 Mar '09

_________________________________________________________________ See all the ways you can stay connected to friends and family http://www.microsoft.com/windows/windowslive/default.aspx

1 0