Now perform the mysql permissions grant step from 2.2 of the INSTALL.debian document:

mysql -uroot -p<password>

mysql> grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost'

identified by '<kohadatabaseuserpassword>'; mysql> flush privileges;

In this case you'll be using the same values from the KOHA_CONF file, though ideally your mysql root password should be different than the mysql password for the koha user. --Joe On Tue, Oct 21, 2008 at 9:40 AM, Scott Kushner <skushner@mplmain.mtpl.org>wrote:

Now I can connect as user root, but not as user koha. Must be a rights issue. Get error 1045 (28000) access denied for koha@localhost (using password: YES)

Any ideas, thanks!

Scott Kushner Information Technologies Middletown Public Library

*From:* Joe Atzberger [mailto:ohiocore@gmail.com] *Sent:* Monday, October 20, 2008 10:47 AM *To:* Jesse Weaver *Cc:* Scott Kushner; koha@lists.katipo.co.nz *Subject:* Re: [Koha] Koha error/fatal error

If the database is on the same system, then the IP is typically something like localhost's 127.0.0.1. If the DB is on the same system, try setting your <hostname> to "localhost" rather than an external IP.

From your batch of X's, it looks like that might not be the case. So if the DB is on another system, try the connection from the command line like:

mysql -uMyUser -pMyPassword -h XXX.XXX.X.XXX my_databasename

There are four (or five) values there that Koha pulls from your KOHA_CONF file.

<database> <hostname> <port> <user> <pass>

This should simulate the kind of connection Koha is attempting and possibly give you better detail about the error.

--Joe Atzberger, LibLime

On Sat, Oct 18, 2008 at 7:37 PM, Jesse Weaver <jesse.weaver@liblime.com> wrote:

On Fri, Oct 17, 2008 at 2:28 PM, Scott Kushner <skushner@mplmain.mtpl.org> wrote:

I had the following problem while trying to setup web installer…

Is this a rights issue? Can any one help. thanks

*Koha error*

The following fatal error has occurred:

Can't connect to MySQL server on 'xxx.xxx.x.xxx' (111) at /usr/share/koha/lib/C4/Context.pm line 646. Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 25. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 25. Compilation failed in require at /usr/share/koha/lib/C4/Overdues.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line 24. Compilation failed in require at /usr/share/koha/lib/C4/Members.pm line 27. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 27. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 31. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 31. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 23. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line

23.

Scott Kushner Information Technologies Middletown Public Library 732 671-3700 (x314)

This looks more like a network issue. Is the MySQL server on that computer set up to accept outside connections? Most aren't by default.

-- Jesse Weaver Software Developer, LibLime