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@localhost identified by 'koha-password'; mysql> grant all privileges on Koha.* to koha@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@elvis koha]# rpm -ivh libyaz-2.0.2-2.i386.rpm [root@elvis koha]# rpm -ivh libyaz-devel-2.0.2-2.i386.rpm [root@elvis koha]# rpm -ivh yaz-2.0.2-2.i386.rpm [root@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@free.fr] Sent: Monday, 23 June 2003 7:44 PM To: Jones, Steven Cc: koha@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)