[Koha] Koha mysql error

Tue Apr 24 21:44:43 NZST 2007

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 at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz]On Behalf Of Dennis B. Mendiola
> Sent: April 20, 2007 7:53 AM
> To: koha at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 
> _______________________________________________
> Koha mailing list
> Koha at 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 at lifehope.om.org
Personal: jochum at famvanderheide.com
Jabber ID: jochum at jabber.om.org
Skype ID: jochumvd
http://www.lifehope.om.org
http://www.famvanderheide.com