[Koha] OpenSolaris and kohaadmin rights at installation

Thommy M. thommym at at-hardeberga.com
Fri Jun 22 00:21:21 NZST 2007


I've done a Koha setup on Opensolaris (snv_65) with Koha 2.2.9.
After some fiddling with the prerequisites I finally came to

# perl installer.pl

Everyting seems to go smooth until kohaadmin wants to use the database.

...............
Creating the MySQL database for Koha...

ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' 
(using password: YES)

DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for 
user 'kohaadmin'@'localhost' (using password: YES) at 
/usr/local/koha/intranet/modules/C4/Context.pm line 411
Can't call method "prepare" on an undefined value at 
scripts/updater/updatedatabase line 1553.
Problem updating database...
root at schumi:/opt/local/src/koha-2.2.9#
................


Looks like there are some credentials for kohaadmin that are not set 
correctly by the install.pl script. Any hints???



Cheers,

/Thommy M.


Here's the whole listing...

# perl installer.pl

  WELCOME TO THE KOHA INSTALLER

This program will ask some questions and try to install koha for you. You
need to know: where most koha files should be stored (you can set the
prefix environment variable for this); the username and password of a mysql
superuser; and details of your library setup. You may also need to know
details of your Apache setup.

If you want to install the Koha configuration files somewhere other than
/etc (for installing not as root, or to have many Kohas on one system, for
example), you should set the etcdir environment variable. Please look at
your manuals for details of how to set that.

Recommended answers are given in brackets after each question. To accept
the default value for any question (indicated by []), simply hit Enter at
the prompt.

Note that you also can define an auto_install_file, that will answer every
question automatically. To use this feature, run ./installer.pl -i
/path/to/auto_install_file

Are you ready to begin the installation? ([Y]/N):
Great!  Continuing...





  PERL MODULES

Checking perl modules ...
Subroutine PDF::API2::Resource::Font::Postscript::O_RDONLY redefined at 
/usr/perl5/5.8.4/lib/Exporter.pm line 65.
  at /usr/perl5/site_perl/5.8.4/PDF/API2/Resource/Font/Postscript.pm line 46


  PERL MODULES AVAILABLE

All required perl modules are installed.

Press <ENTER> to continue:





  OPAC DIRECTORY

Please supply the directory you want Koha to store its OPAC files in. This
directory will be auto-created for you if it doesn't exist.

OPAC Directory [/usr/local/koha/opac]:




  LIBRARIAN DIRECTORY

Please supply the directory you want Koha to store its Librarian interface
files in. This directory will be auto-created for you if it doesn't exist.

Intranet Directory [/usr/local/koha/intranet]:




  LOG DIRECTORY

Specify a directory where log files will be written.

Koha Log Directory [/usr/local/koha/log]:




  DATABASE NAME

Please provide the name that you wish to give your koha database. It must
not exist already on the database server.

Most users give a short single-word name for their library here.

Database name [Koha]:




  DATABASE HOST

Please provide the mysql server name. Unless the database is stored on
another machine, this should be "localhost".

Database host [localhost]:




  DATABASE USER

We are going to create a new mysql user for Koha. This user will have full
administrative rights to the database called Koha when they connect from
localhost. This is also the name of the Koha librarian superuser.

Most users give a single-word name here.

Database user [kohaadmin]:




  DATABASE PASSWORD

Please provide a good password for the user kohaadmin.

IMPORTANT: You can log in using this user and password at any time.

Password for database user kohaadmin: kohaadmin
Use of uninitialized value in concatenation (.) or string at Install.pm 
line 1358, <STDIN> line 9.




  APACHE CONFIGURATION

Koha needs to write an Apache configuration file for the OPAC and Librarian
sites. By default this installer will do this by using one name and two
different ports for the virtual hosts. There are other ways to set this up,
and the installer will leave comments in /etc/koha-httpd.conf about them.

NOTE: You will need to add lines to your main httpd.conf to include
/etc/koha-httpd.conf (using the Include directive) and to make sure it is
listening on the right ports and host names (using the Listen directive).

Press <ENTER> to continue:




  WEB E-MAIL CONTACT

Enter the e-mail address to be used as a contact for Koha. This address is
displayed if fatal errors are encountered.

E-mail contact [webmaster@]: thommym at at-hardeberga.com




  WEB HOST NAME OR IP ADDRESS

Please enter the host name or IP address that you wish to use for koha.
Normally, this should be a name or IP that belongs to this machine.

Host name or IP Address [schumi]:




  OPAC PORT

Please enter the port for your OPAC interface. This defaults to port 80,
but if you are already serving web content with this hostname, you should
change it to a different port (8000 might be a good choice, but check any
firewalls).

Enter the OPAC Port [80]:




  LIBRARIAN PORT

Please enter the port for your Librarian interface. This must be different
from the OPAC port (80).

Enter the Intranet Port [8080]:




  UPDATING APACHE CONFIGURATION

Checking for modules that need to be loaded...




  INSTALLING FILES

Copying files to installation directories:Copying admin templates to 
/usr/local/koha/intranet/htdocs.
Copying admin interface to /usr/local/koha/intranet/cgi-bin.
Copying main scripts to /usr/local/koha/intranet/scripts.
Copying perl modules to /usr/local/koha/intranet/modules.
Copying OPAC templates to /usr/local/koha/opac/htdocs.
Copying OPAC interface to /usr/local/koha/opac/cgi-bin.






  MYSQL LOCATION

Koha can't find the MySQL command-line tools. If you installed a MySQL
package, you may need to install an additional package containing
mysqladmin. If you compiled mysql yourself, please give the value of
--prefix when you ran configure. The file mysqladmin should be in
bin/mysqladmin under the directory that you give here.

MySQL installation directory: /opt/csw/mysql4




  MYSQL ROOT USER PASSWORD

To create the koha database, please enter your mysql server's root user
password:

Password: mysqladmin




  CREATING DATABASE

Creating the MySQL database for Koha...

ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' 
(using password: YES)

DBI connect('Koha:localhost','kohaadmin',...) failed: Access denied for 
user 'kohaadmin'@'localhost' (using password: YES) at 
/usr/local/koha/intranet/modules/C4/Context.pm line 411
Can't call method "prepare" on an undefined value at 
scripts/updater/updatedatabase line 1553.
Problem updating database...
root at schumi:/opt/local/src/koha-2.2.9#



More information about the Koha mailing list