[Koha] RE: Installing Koha

Jones, Steven sjones08 at eds.com
Tue Jun 24 08:53:04 NZST 2003


Im not asking for a one click install, far from it.

What I am seeing is a broken installer, like I said Ive got further with
attempting a manual install than I have using the installer. What I do need
is a reliable install dependancy list in the manual, preferably backed up
with some links to the perl modules, or an adequate description of each
module so I can google it myself.

I have made some notes while attempting the install over many days, here it
is,


Setting up mysql on RH9 (DRAFT)

1)	Install the rpm.
2)	a) Start at /etc/init.d/mysqld start
      b) service mysqld start

3)	test with /usr/bin/mysqladmin version.

# /usr/bin/mysqladmin version
/usr/bin/mysqladmin  Ver 8.23 Distrib 3.23.56, for redhat-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          3.23.56
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 43 sec

Threads: 1  Questions: 1  Slow queries: 0  Opens: 6  Flush tables: 1  Open
tables: 0 Queries per second avg: 0.023


4)	a) Set mysql and apache to start on boot chkconfig --level 235 httpd
on
5)	b) chkconfig --level 235 mysqld on
c) check with chkconfig --list mysqld
mysqld          0:off   1:off   2:on    3:on    4:off   5:on    6:off

6)	change mysql root password with /usr/bin/mysqladmin  -u root
password <password>
7)	create a Koha database instance /usr/bin/mysqladmin -uroot
-p<password> create Koha
8)	login to mysql user mysql -uroot -p<password>
9)	create privs for the database mysql> grant all privileges on Koha.*
to koha at localhost identified by 'koha-password';
mysql> grant all privileges on Koha.* to koha at localhost identified by
'<koha-password>';
Query OK, 0 rows affected (0.00 sec)

10)	 Set up the script for koha, (from the install dir) mysql -ukoha
-<password> Koha < koha.mysql
11)	edit koha.conf to reflect the above changes,

database=Koha
hostname=localhost
user=koha
pass=<koha-pasword>

12)	chown apache:apache /etc/koha.conf
13)	chmod 0600 /etc/koha.conf
14)	run perl script from the install dir, perl -I modules/
scripts/updater/updatedatabase
Checking itemtypesearchgroups table...
Adding itemtypesearchgroups table...
Checking userflags table...
Adding userflags table...
Checking uploadedmarc table...
Adding uploadedmarc table...
Checking ethnicity table...
Adding ethnicity table...
Checking sessions table...
Adding sessions table...
Checking branchrelations table...
Adding branchrelations table...
Checking websites table...
Adding websites table...
Checking shelfcontents table...
Adding shelfcontents table...
Checking sessionqueries table...
Adding sessionqueries table...
Checking z3950results table...
Adding z3950results table...
Checking bookshelf table...
Adding bookshelf table...
Checking z3950queue table...
Adding z3950queue table...
Checking marcrecorddone table...
Adding marcrecorddone table...
Adding z3950servers table...
Check table reserveconstraints
  Check column reserveid
Adding reserveid field to reserveconstraints table...
Execute: alter table reserveconstraints
                add column reserveid int
Check table biblioitems
  Check column lccn
Adding lccn field to biblioitems table...
Execute: alter table biblioitems
                add column lccn char(25)
  Check column marc
Adding marc field to biblioitems table...
Execute: alter table biblioitems
                add column marc text
  Check column url
Adding url field to biblioitems table...
Execute: alter table biblioitems
                add column url varchar(255)
Check table statistics
  Check column borrowernumber
Check table deletedbiblio
  Check column abstract
Adding abstract field to deletedbiblio table...
Execute: alter table deletedbiblio
                add column abstract text
Check table aqorders
  Check column budgetdate
Adding budgetdate field to aqorders table...
Execute: alter table aqorders
                add column budgetdate date
Check table reserves
  Check column expires_date
Adding expires_date field to reserves table...
Execute: alter table reserves
                add column expires_date date
  Check column required_date
Adding required_date field to reserves table...
Execute: alter table reserves
                add column required_date date
  Check column id
Adding id field to reserves table...
Execute: alter table reserves
                add column id int auto_increment primary key
Check table aqbooksellers
  Check column nocalc
Adding nocalc field to aqbooksellers table...
Execute: alter table aqbooksellers
                add column nocalc int(11)
  Check column invoicedisc
Adding invoicedisc field to aqbooksellers table...
Execute: alter table aqbooksellers
                add column invoicedisc float(6,4)
Check table borrowers
  Check column password
Adding password field to borrowers table...
Execute: alter table borrowers
                add column password char(30)
  Check column flags
Adding flags field to borrowers table...
Execute: alter table borrowers
                add column flags int
  Check column userid
Adding userid field to borrowers table...
Execute: alter table borrowers
                add column userid char(30)
Check table itemtypes
  Check column publictype
Adding publictype field to itemtypes table...
Execute: alter table itemtypes
                add column publictype char(30)
Check table biblio
  Check column abstract
Adding abstract field to biblio table...
Execute: alter table biblio
                add column abstract text
Check table deletedbiblioitems
  Check column lccn
Adding lccn field to deletedbiblioitems table...
Execute: alter table deletedbiblioitems
                add column lccn char(25)
  Check column marc
Adding marc field to deletedbiblioitems table...
Execute: alter table deletedbiblioitems
                add column marc text
  Check column url
Adding url field to deletedbiblioitems table...
Execute: alter table deletedbiblioitems
                add column url varchar(255)
Check table branchtransfers
  Check column datearrived
Check table printers
  Alter printername in printers
Check table aqbookfund
  Alter bookfundid in aqbookfund
Check table aqbooksellers
  Alter id in aqbooksellers
Check table z3950servers
  Alter id in z3950servers
Setting maximum barcode length to 20 (was 9).
Setting type of datesent in branchtransfers to datetime.
Setting type of datearrived in branchtransfers to datetime.
Setting type of categorycode in branchcategories to varchar(4),
 and making the primary key.
Changing branchcode in branchcategories to categoryname text.
Replacing branchholding in branchcategories with codedescription text.
Checking for data required in table userflags...
Adding row to userflags:   flagdesc => Access to all librarian functions
bit => 0  defaulton => 0  flag => superlibrarian
Adding row to userflags:   flagdesc => Circulate books  bit => 1  defaulton
=> 0  flag => circulate
Adding row to userflags:   flagdesc => View Catalogue (Librarian Interface)
bit => 2  defaulton => 0  flag => catalogue
Adding row to userflags:   flagdesc => Set Koha system paramters  bit => 3
defaulton => 0  flag => parameters
Adding row to userflags:   flagdesc => Add or modify borrowers  bit => 4
defaulton => 0  flag => borrowers
Adding row to userflags:   flagdesc => Set user permissions  bit => 5
defaulton => 0  flag => permissions
Adding row to userflags:   flagdesc => Reserve books for patrons  bit => 6
defaulton => 0  flag => reserveforothers
Adding row to userflags:   flagdesc => Borrow books  bit => 7  defaulton =>
1  flag => borrow
Adding row to userflags:   flagdesc => Reserve books for self  bit => 8
defaulton => 0  flag => reserveforself
Adding row to userflags:   flagdesc => Edit Catalogue (Modify
bibliographic/holdings data)  bit => 9  defaulton => 0  flag =>
editcatalogue
Adding row to userflags:   flagdesc => Update borrower charges  bit => 10
defaulton => 0  flag => updatecharges
Checking for data required in table systempreferences...
Adding row to systempreferences:   variable => autoMemberNum  value => 1
Adding row to systempreferences:   variable => acquisitions  value => simple
Adding row to systempreferences:   variable => dateformat  value => metric

15)	add the following 3 lines to koha.conf. 

·	includes=/var/www/koha/htdocs/includes to /etc/koha.conf, where
/var/www/koha/htdocs/includes is indeed the path. (See the Hints file for
the syntax). 
·	opachtdocs=/var/www/koha/htdocs 
·	intrahtdocs=/var/www/koha/htdocs

16)	Once passwords have been set they will be required to get even basic
functions to work /usr/bin/mysqladmin -<password> version
17)	If faults occur locate check the logs install HTML-Template-2.6 (or
higher) if a missing Template.pm is reported, download it from
(www.cpan.org).
18)	Other missing modules can be Set-Scalar-1.17 and Net-Z3950-0.34 (or
higher) download, untar, make and install (In order) in the directory you
untarred to with,
·	perl Makefile.PL
·	make
·	make test
·	make install

19)	If Z3950 is needed yaz may need to be installed.
http://ftp.indexdata.dk/pub/yaz/RedHat9.X/   (change 9 to X for other RH
versions)
root at elvis koha]# rpm -ivh libyaz-2.0.2-2.i386.rpm
[root at elvis koha]# rpm -ivh libyaz-devel-2.0.2-2.i386.rpm
[root at elvis koha]# rpm -ivh yaz-2.0.2-2.i386.rpm
[root at elvis koha]# rpm -ivh yaz-2.0.2-2.src.rpm

20)	Even with apache running as user apache, directories owned by apache
seem to need a 0775 permissions (group write seems critical).?
21)	www.activestate.com and download active perl 5.8 and install (maybe
not this achieved nothing!)
22)	um...
23)	Get the perl support modules for koha off
http://search.cpan.org/author/KOHA/Bundle-KohaSupport-0.08
24)	Class-MakeMethods-1.003 from www.evoscript.org/Class-makeMethods or
later (broken wont make)
25)	Database.pm from  MySQL-Diff-0.33 or later, (cant install as
something is broken...)
26)	PAN.pm, cannot locate it.
27)	stop here

regards

Steven

-----Original Message-----
From: paul POULAIN [mailto:paul.poulain at free.fr]
Sent: Monday, 23 June 2003 7:44 PM
To: Jones, Steven
Cc: koha at lists.katipo.co.nz
Subject: Installing Koha


Jones, Steven wrote:

>I have to say this program is easily one of the worst to install Ive seen
in
>6 years of using open source.
>  
>
You never have build gnucash from sources... this one is a real pain. 
Koha has an installer, that works in most cases (hoped at least).

Note, also, that i've a problem with "one click install". Even if we 
could install Koha in 1 click, that would be (almost) useless imho.
why ? Because it requires some PARAMETERS setups (branches, budgets, 
z3950 server, MARC parameters tuning...) that MUST be done in order to 
see what Koha can do.
and this task CAN'T BE AVOIDED.
I think, it's the biggest caveat for Koha => helping setting up the 
software.
However, that's also why I think there is a place for commercial 
services on Koha too :-))

-- 
Paul POULAIN
Consultant indépendant en logiciels libres
responsable francophone de koha (SIGB libre http://www.koha-fr.org)




More information about the Koha mailing list