- Koha - lists.katipo.co.nz

Re: [Koha] Defaulting to a specific branch and Serhold question
by Doug Dearden 24 Apr '09

24 Apr '09

Zachary, The way I did it was with different virtual hosts listening on different ip address and port combinations, and pointing to the individual databases for each catalog. One set of koha program files, but a different database and config files for each library. I have three databases running this way, I'm not sure how it will expand to 17. My notes on how to do this are pasted below. Doug To use multiple databases: Modify the /etc/network/interfaces file to bind multiple ip addresses to the ethernet interface. After much trial and error I wound up with this: -------------------------------------------------------------------------------------------------------- # This file describes the network interfaces available on your system # and how to activate them. For more information, see interfaces(5). # The loopback network interface auto lo eth1 eth1:0 eth1:1 iface lo inet loopback # The primary network interface allow-hotplug eth1 iface eth1 inet static address 192.168.1.133 netmask 255.255.255.0 gateway 192.168.1.10 iface eth1:0 inet static address 192.168.1.139 netmask 255.255.255.0 gateway 192.168.21.10 iface eth1:1 inet static address 192.168.1.140 netmask 255.255.255.0 gateway 192.168.1.10 ------------------------------------------------------------------------------------------------------ This creates three static addresses on the same interface eth1. Using phpmyadmin or the MySQL command line, login as kohaadmin and create the new database. You need to dump the structure of the koha database and then import it into the new databases. To dump the database use mysqldump . At the command line, create a new directory and cd into it. Then enter: mysqldump -u kohaadmin -p koha > kohaout.sql You enter the password for kohaadmin, and this creates an sql file of the koha database. Create the new databases using phpmyadmin or the mysql command line - example below. Start the mysql command line utility with: mysql -u kohaadmin -p After you enter your password, this gives you a mysql prompt. Then enter: show databases; to see the list of databases. To create one enter: create database <new db name>; Then change to that dataabase: use <new DB name>; This command will import all the koha structure into the new database: source kohaout.sql; quit gets you out of the MySql utility and back to the command line. Next you copy the config files. Change to the /etc/koha directory, and copy the koha-conf.xml and koha-httpd-conf files using the new name of your database. So if your database is named "book", you now have book-conf.xml and book-httpd.conf. Edit the book-conf.xml file, and change the name of the database. You should find this near the end of the file under the <config> section. Edit the book-httpd.conf file and make the following changes: Edit the VirtualHost entry and change the name to one of the IP addresses you bound to the network interface - using a different address for each configuration/database. So your entry looks like <VirtualHost 192.168.1.139:50180> for the OPAC and <VirtualHost 192.168.1.139:50188> for the staff client. The IP addresses need to be in the interfaces config file, and the ports (after the :) are from the address range 50000 - 63535. These are unassigned ports in the internet scheme, and since they will be used only on the internal network can be whatever you like. The normal koha ports are the standard http port 80 for the OPAC and 8080 for the staff client. Further down in each VirtualHost section find the SetEnv KOHA_CONF declaration. Change the file to the new one, in our example "/etc/koha/book-conf.xml". You need to change this in two places, one for each VirtualHost section. Change to the /etc/apache2 directory and edit the ports.conf file. Add the new ports you just put into the VirtualHost directives 50180 and 50188 in our example. If you want to use the default koha database, also add 8080 - the default staff client port. You need to add symbolic links for the httpd.conf file and enable the site, so as above you do: ln -s /etc/koha/book-httpd.conf /etc/apache2/sites-available/book a2ensite koha Then restart Apache - /etc/init.d/apache2 reload If you have done all your edits correctly, apache will reload without any errors. Browse to the new IP address - i.e. 192.168.1.139:50180 and you should see the koha opac screen. Browse to the staff client - 192.168.21.139:50188 and you should get that screen. Login as kohaadmin. For each new database you should create a new library in the staff client, with the IP address that goes with the library filled in. DONT turn on IndependentBranches, it causes other problems and had to be turned off. It is not needed anyway with the different catalogs running on different virtual servers. That should get you multiple databases, with appropriate defaults when connecting to the staff client or the opac. >>> Zachary Spalding <spalding(a)senylrc.org> 4/6/2009 1:51 PM >>> I am just starting out with Koha and was hoping someone on the list may be able to answer these questions? 1. Is there a way to default to a specific branch library, I have about 17 libraries that our separate institutions that need to default to a search for only their stuff. If it could be done via a parameter in the URL that would be perfect. I just don't want to run 17 instances of Koha if I can avoid it. 2. Has anyone tryed to import Serhold data from National Library of Medicine and can you tell me how did you get that process started with NLM? Thanks -- Zachary Spalding Systems Manager 21 S. Elting Corners Rd. Highland, NY 12528 Phone: 845-883-9065 Fax: 845-883-9483 Email: spalding(a)senylrc.org

3 4

KOHA and GSDL
by mohan pradhan 24 Apr '09

24 Apr '09

Dear Anuradha, We are interested in integrating Greenstone with KOHA for full text searching. I would appreciate if you could kindly send me details about it. With regards, Sincerely yours, Dr. Mohan Raj Pradhan Member-Secretary HealthNet Nepal I have been working with Greenstone for quite time, details of which can be accessed at: http://vidya-mapak.ncsi.iisc.ernet.in/cgi-bin/library http://vidya-mapak.ncsi.iisc.ernet.in/bahubhashi/index.html and since last one year under a project sponsored by IDRC, a small team is working on integrated library automation packages including Koha, details can be accessed at: http://dharmaganja.ncsi.iisc.ernet.in I am glad to inform this list that we have successfully tested integrating Greenstone into Koha, for making Koha to search fulltext documents and also to work as a digital library. Also, we have almost tested making this possible with available backend in Koha itself, i.e., MySql and Zebra. We are planning to put on our project server, may be in a week or two. Regards, Anuradha

3 2

problem with pazpar2
by satyanarayana holenarsipur 24 Apr '09

24 Apr '09

Hi Guys, trying to configure pazpar2 to work with local koha and other z39.50 servers, but getting a strange error: I am able to connect to the local koha and do the pazpar search and the results are fine. When i try to connect to the loc or other z39.50 server, then it is gving a fatal error that it could not connect to the server. Initially i thought it might be firewall issues, but all the required ports seems to be open on the firewall. I guess it might be the Proxy issue in the apache conf files. But I am not able to figure it out. Can any one help me out. -- Regards, Satyanarayana H.S. Development Head (www.osslabs.biz) -- "A small group of determined spirits, with an unquenchable thirst for their mission, can alter the course of history." -Mahatma Gandhi

1 1

getting the global preference BiblioAddsAuthorities to work
by Ella Delaney 23 Apr '09

23 Apr '09

Greetings, I set this global preferences option to "on" but the system is not creating authority records on the fly as promised. Am I missing something? Is there another setting I need to change? Thanks! Ella Delaney Head Librarian Flashpoint Academy 28 North Clark Street, 5th Floor Chicago IL 60602 ella.delaney(a)flashpointacademy.com (312)506-0645

1 0

Re: [Koha] koha features
by Doug Dearden 23 Apr '09

23 Apr '09

Sebastien, Your answer might be to define item types for the different formats (pdf, daisy, etc) and then add an item record to the biblio for each item type. The item record includes a subfield u - universal resource locator - that can be used to point to the file. You then have one biblio with the bibliographic information and a copy record for each of the different types of formats you have for that title. Best, Doug >>> Sébastien Hinderer <Sebastien.Hinderer(a)snv.jussieu.fr> 4/23/2009 7:51 AM >>> Hi Galen, thanks for your quick reply. > The 856 (URL) field is a repeatable field in MARC21, so you can have a > single bib record for each title that links to all of the formats. Okay. We plan to use Unimarc rather than marc21, but I believe 856 is also repeatable in this marc dialect. However, I'd say that we need to store not only a link for each format, but also the type of ressource the link points to. But maybe this is easy to do and I can find out about that by myself. You guys already helped a lot. Cheers, Sébastien. _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

request
by Twinamatsiko Smith 23 Apr '09

23 Apr '09

Hey, Firstly thank you for the work u guys are doing.. I installed Koha3.0, does the call number item work? mine jammed What abt the Sms to the librarian by users? The e-mail module does t work properly? Do i need to change somethin help please Smith Uganda

2 1

New user account on wiki, no message received
by Ben Finney 23 Apr '09

23 Apr '09

Howdy all, A few days ago I attempted to create a new user account on the Koha wiki <URL:http://wiki.koha.org/>. The procedure ended with a page telling me an email message had been sent. I've not received auch an email message. I created two accounts: ‘bignose’ first, then (when I realised a WikiName was preferred) ‘BenFinney’. Both of them resulted in a web page telling me an email message has been sent, but neither of them ever arrived. Can someone with admin access on the wiki site please check the logs for error messages? (I'd rather not keep creating new accounts, nor changing the email address.) -- \ “He who allows oppression, shares the crime.” —Erasmus Darwin, | `\ grandfather of Charles Darwin | _o__) | Ben Finney

2 2

For multiple Database for koha to run in zebra server
by mohan pradhan 23 Apr '09

23 Apr '09

Dear all, I want to run the koha for two different databases in two different ip addresses in the same computer. I have two databases already which are "koha" and "book" and also two different xml and httpd-conf files for the same. Here, I can add the marc records into the second database "book" having configuration files as "book-conf.xml" and "book-httpd.conf"; which is also shown in mysql for the newly added biblio, but the problem is when i run the zebra server and try to search the added catalogue from the staff client, it doesnot show. It is showing the records from the first database "koha" only while it has to be shown from second database "book" instead. How can i run zebra server for two different databases "koha" and "book" addressed at two different ip addresses in the same computer. The procedure that i have done are mentioned below in detail. To use multiple databases: Modify the /etc/network/interfaces file to bind multiple ip addresses to the ethernet interface. After much trial and error I wound up with this: -------------------------------------------------------------------------------------------------------- # This file describes the network interfaces available on your system # and how to activate them. For more information, see interfaces(5). # The loopback network interface auto lo eth1 eth1:0 eth1:1 iface lo inet loopback # The primary network interface allow-hotplug eth1 iface eth1 inet static address 192.168.1.133 netmask 255.255.255.0 gateway 192.168.1.10 iface eth1:0 inet static address 192.168.1.139 netmask 255.255.255.0 gateway 192.168.21.10 iface eth1:1 inet static address 192.168.1.140 netmask 255.255.255.0 gateway 192.168.1.10 ------------------------------------------------------------------------------------------------------ This creates three static addresses on the same interface eth1. Using phpmyadmin or the MySQL command line, login as kohaadmin and create the new database. You need to dump the structure of the koha database and then import it into the new databases. To dump the database use mysqldump . At the command line, create a new directory and cd into it. Then enter: mysqldump -u kohaadmin -p koha > kohaout.sql You enter the password for kohaadmin, and this creates an sql file of the koha database. Create the new databases using phpmyadmin or the mysql command line - example below. Start the mysql command line utility with: mysql -u kohaadmin -p After you enter your password, this gives you a mysql prompt. Then enter: show databases; to see the list of databases. To create one enter: create database <new db name>; Then change to that dataabase: use <new DB name>; This command will import all the koha structure into the new database: source kohaout.sql; quit gets you out of the MySql utility and back to the command line. Next you copy the config files. Change to the /etc/koha directory, and copy the koha-conf.xml and koha-httpd-conf files using the new name of your database. So if your database is named "book", you now have book-conf.xml and book-httpd.conf. Edit the book-conf.xml file, and change the name of the database. You should find this near the end of the file under the <config> section. Edit the book-httpd.conf file and make the following changes: Edit the VirtualHost entry and change the name to one of the IP addresses you bound to the network interface - using a different address for each configuration/database. So your entry looks like <VirtualHost 192.168.1.139:50180> for the OPAC and <VirtualHost 192.168.1.139:50188> for the staff client. The IP addresses need to be in the interfaces config file, and the ports (after the :) are from the address range 50000 - 63535. These are unassigned ports in the internet scheme, and since they will be used only on the internal network can be whatever you like. The normal koha ports are the standard http port 80 for the OPAC and 8080 for the staff client. Further down in each VirtualHost section find the SetEnv KOHA_CONF declaration. Change the file to the new one, in our example "/etc/koha/book-conf.xml". You need to change this in two places, one for each VirtualHost section. Change to the /etc/apache2 directory and edit the ports.conf file. Add the new ports you just put into the VirtualHost directives 50180 and 50188 in our example. If you want to use the default koha database, also add 8080 - the default staff client port. You need to add symbolic links for the httpd.conf file and enable the site, so as above you do: ln -s /etc/koha/book-httpd.conf /etc/apache2/sites-available/book a2ensite koha Then restart Apache - /etc/init.d/apache2 reload If you have done all your edits correctly, apache will reload without any errors. Browse to the new IP address - i.e. 192.168.1.139:50180 and you should see the koha opac screen. Browse to the staff client - 192.168.21.139:50188 and you should get that screen. Login as kohaadmin. with regards, Mohan Raj Pradhan HEALTHNET NEPAL KATHMANDU, NEPAL

1 0

Re: [Koha] Till Reconciliation - Create from SQL
by Joann Ransom 23 Apr '09

23 Apr '09

Hi Sandeep, Ahh ... another one of those wondeful things which were dropped out of 3.0. It is definitely in 2.9; can you extract the code from there somehow? So sorry, Jo. SANDEEP BHAVSAR wrote: > Dear Mr. Joann > > In my koha 3.01 version I am not having this till reconciliation > option and that' s why I would like to know the SQL command for it. > > Thanks and Regards > > Sandeep Bhavsar > Librarian > Dr.V.N.Bedekar Institute of Management Studies > Thane(W) 400601 > MUMBAI. INDIA > @@@@@@@@@@@@@@@@@@@@@@@@@@ > email : sandeep.bhavsar(a)gmail.com <mailto:sandeep.bhavsar@gmail.com> > Mob : 9987049099 > elibrary :http://www.vpmthane.org/im/elib/main.htm > @@@@@@@@@@@@@@@@@@@@@@@@@@

1 0

Till Reconciliation - Create from SQL
by SANDEEP BHAVSAR 23 Apr '09

23 Apr '09

Respected All I have gone through the previously posted messages on “ Report Generation- Till Reconciliation for each branch libraries” by Mr. Basu on *Wed, Dec 10, 2008 at 10:31 AM* and also read the views of Joe Atzberger , BWS Johnson, Joshua Ferraro and Henri-Damien I am sure that the each and every public library in India would like to know about how much money they have collected at the end of the day from their all category of patrons. Is it possible to generate the same Till Reconciliation Report with *Total amount paid* through *Home › Reports › Guided Reports Wizard › Create from SQL* . If yes, Please share the SQL Command. -------Advance Technology News for elibrarians http://sandeepbhavsar.blogspot.com/ ------ Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@@@@@@@@@@@@@@@@@@@@@@@@@ email : sandeep.bhavsar(a)gmail.com Mob : 9987049099 elibrary :http://www.vpmthane.org/im/elib/main.htm @@@@@@@@@@@@@@@@@@@@@@@@@@

2 4