[Koha] Koha error/fatal error

[Joe Atzberger]

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 at 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 at localhost (using
> password: YES)
>
> Any ideas, thanks!
>
> Scott Kushner
> Information Technologies
> Middletown Public Library
>
> *From:* Joe Atzberger [mailto:ohiocore at gmail.com]
> *Sent:* Monday, October 20, 2008 10:47 AM
> *To:* Jesse Weaver
> *Cc:* Scott Kushner; koha at 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 at liblime.com>
> wrote:
>
> On Fri, Oct 17, 2008 at 2:28 PM, Scott Kushner <skushner at 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20081021/a1cdb95f/attachment.htm