[Koha] yet another installer problem

[Roger Horne]

I have had a version of Koha running on my home Suse system working for some
time. I do recall, however, that I did have difficulties in installing it,
mainly in relation to the z3950 stuff and Mysql.

I have been trying over the last few days to instal a system on a remote
virtual machine (from http://bytemark.co.uk ). This gives me full root
access to a Debian instalation.

When I ran ./installer.pl for the first time I got the usual errors about
Yaz and the Net::z3950 modules and various perl modules. I eventually got
Yaz unstalled with the help of the nice people at indexdata: they told me
that the latest Debian versions already include yaz but my version seemed
not to. With a bit of luck all distros will include it soon. The Net and
other Perl modules eventually installed from CPAN.

I also made alterations to httpd.conf (Apache 1.3) by uncommenting mod_env
and mod_include. 

Before starting I had ensured that MySql was working: mysql -p -u root
produces a request for my pw and when I enter it I get the mysql prompt.
However the installer does not like mysql. I get the following error
messages: (typed rather than copied since I am writing from a differnt
machine.)

Creating the Mysql database ...

ERROR 1062 at line 1: Duplicate entry 'localhost-kohaadmin' for key 1
256 ERROR 1062 at line 1: Duplicate entry '%-Koha-kohaadmin' for key 1

/usr/bin/mysqladmin: command to server at 'localhost' failed
error 'access denied for user: kohaadmin at localhost' (using password 'YES')'

ERROR CREATING Database Could not connect to Mysql server

[Then]
DBI connect ('koha:localhost','kohaadmin',...)
failed: Access denied for user 'Kohaadmin at localhost (Using PW: YES) at
/usr/local ...C4/Context.pm line 408
Cannot call method 'prepare' on undefined value at
scripts/updater/updatedatabase line 876 etc

Mysql on this machine *does* seem to be pernickety about how one logs on. ie
mysql -p -u root produces a prompt for the password while mysql -u root
-p="mypw" (or --password="mypw") claims that root at localhost cannot access
the db.

Any suggestions?


A small suggestion: would it be possible to make text entered into the
installer editable? It is annoying to make a typo and not to be able to
correct it.

Roger
-- 
Roger Horne, 11 New Square, Lincoln's Inn, London WC2A 3QB
mailto:roger at hrothgar.co.uk
http://hrothgar.co.uk/YAWS/