[Koha] The best way to implement multiple databases

[Krishnan Mani]

All you ask for is very much do-able.

The cleanest way is to have multiple databases, and more than one Koha install on the same box, and virtual hosts (or NamedVirtualHost) directives that refer to each Koha install. During the install, Koha will ask you for the database name and the database user credentials.

There is an administrative preference that disallows patron logins to OPAC that you can tweak once you are installed.

You need to get your DNS right, and perhaps, you can also make sure that your box has multiple network interfaces, and that your virtual hosts bind Apache to different ones for campus/off-campus traffic. This may help keep your firewall rules simple.

You also probably want to visually differentiate between the two OPACs and maybe, perhaps, add your own splash screens to each install (and a corresponding change to the configuration in the default VirtualHost directives that come with Koha) that indicates which site is for whom with other suitable disclaimers. (just as with under-age people that may have strayed onto an adult site)

Thanks and regards,



krishnan mani

Pune, India

--- On Tue, 21/10/08, Doug Dearden <dearden at sarsf.org> wrote:
From: Doug Dearden <dearden at sarsf.org>
Subject: [Koha] The best way to implement multiple databases
To: koha at lists.katipo.co.nz
Date: Tuesday, 21 October, 2008, 1:34 AM

Hello all,

I am installing Koha 3.0 to catalog multiple databases for the same location. 
We are a small non-profit educational institution, where scholars come for
advanced study.  We have a collection that is only available to those on campus
residents, and one that is available more widely to our members.  I would like
to set up the two databases on the same server, and configure Apache to listen
on different ports or IP adresses for access to each of the catalogs.  I want
users to be able to browse via the OPAC without logging in.  I can filter the
traffic at the firewall to only allow access from off campus to the more widely
available collection.  I have read the doc online about the IndependentBranches
option in the Global Preferences section, but am unclear on how this is
implemented for each Library if it is turned on.  I see that there is an IP
option in the Libraries screen.  If I fill that in with a different address for
each Library, is it then a matter of adding a VirtualHost directive in the conf
file?  Or is there more config that needs to take place?  Or am I better off
installing this multiple times with separate databases for each catalog? 
Should
I choose a Standard install, or are multiple Single installs the way to go?

Just trying to get it right the first time.

I am posting this a second time, as after a couple of hours the first post has
not appeared and there is nothing in my email.

Thanks,

Doug



_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20081021/5d6675a4/attachment.htm