Hi Dennis, I just now noticed your email to the list and see that you have similar problems as I have with installing Koha. Did you solve the problem yet? The installer does manage to create the database and the mysql user but I'm not sure what's causing the error: ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using password: YES) I've tried using the same password for both the mysql user root and kohaadmin, but that doesn't work. when using mysqladmin it does accept my root password. I'm not really experienced with mysql other than installing it and using it on a few servers. When starting mysqld with --skip-grant-tables --user=root & the Koha installer does give a warning that mysqld is running with skip-grant-tables, but continues to populate the database and finish the installer. Hope someone on the list is able to give me some pointers and help me solve this problem. I'm trying to install Koha on CentOS 4.3 with mysql-server 4 -Jochum Mike Dalgity wrote:
Hi Dennis, I can confirm I got the same error message regarding PDF::API2. I don't know if it matters at all because I haven't tested any of the barcode stuff yet. There's one change I had to make in the koha.mysql file before installing. Search for return and change it to `return`. Not sure what's causing your Access Denied errors for kohaadmin. Looks like you were able to connect to MySQL the first time and create the Koha database however this will prevent successfully installing thereafter. Here's what I used to uninstall my partial install when I was still figuring it out.
# to remove koha config files: rm /etc/koha*
# to remove web sites: (default path is different) rm -rf /var/www/koha
# to remove koha database mysqladmin -f -uroot -p drop Koha mysql -uroot -p -Dmysql -e"delete from user where user='kohaadmin'" mysql -uroot -p -Dmysql -e"delete from db where user='kohaadmin'"
# reload mysql mysqladmin -uroot -p reload
#If doing a full uninstall don't forget to remove the "Include /etc/koha-httpd.conf" line at the end of apache config file.
Mike D.
-----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz]On Behalf Of Dennis B. Mendiola Sent: April 20, 2007 7:53 AM To: koha@lists.katipo.co.nz Subject: [Koha] Koha mysql error
I need help. I believe, anyone here could be my savior. I installed Koha 2.2.8 on a Fedora Core 5 with Apache 2.2.4, MySQL 5.0.37.
In the Perl Modules, I got this message in red:
PERL MODULES
Checking perl modules ...
Subroutine PDF::API2::Resource::Font::Postscript::O_RDONLY redefined at /usr/lib/perl5/5.8.8/Exporter.pm line 65.
at /usr/lib/perl5/site_perl/5.8.8/PDF/API2/Resource/Font/Postscript.pm line 46
The installation proceeded but when I got to the database portion, here's what I got:
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...
I logged in as root to the mysql server, and then repeated the process. Here's what I got:
ROOT USER PASSWORD
To create the koha database, please enter your mysql server's root user password:
Password:
CREATING DATABASE
Creating the MySQL database for Koha.../usr/local/mysql/bin/mysqladmin:
CREATE DATABASE failed; error: 'Can't create database 'Koha'; database exists'
ERROR CREATING DATABASE
Couldn't connect to the MySQL server for the reason given above. This is a serious problem, the database will not get installed.
Press <ENTER> to continue:
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...
What's the problem here? I used the same root password for mysql.
I'd appreciate anybody's help.
Thanks so much.
-- Dennis B. Mendiola Philippines _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jochum van der Heide IT Support OM Lifehope Little Cornbow Halesowen, West Midlands B63 3AJ United Kingdom Tel: +44 (0)121 585 5662 Extension: 110 Mobile: +44 (0)79 1014 7803 Fax: +44 (0)121 585 0271 Work: jochum.vanderheide@lifehope.om.org Personal: jochum@famvanderheide.com Jabber ID: jochum@jabber.om.org Skype ID: jochumvd http://www.lifehope.om.org http://www.famvanderheide.com