[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