<div dir="ltr"><div>Now perform the mysql permissions grant step from 2.2 of the INSTALL.debian document:<br> </div><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
mysql -uroot -p<password> <br> </blockquote><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">mysql> grant all on <kohadatabasename>.* to '<kohadatabaseuser>'@'localhost' identified by '<kohadatabaseuserpassword>';<br>
mysql> flush privileges;<br></blockquote><div><br>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. <br>
<br>--Joe <br> </div><div class="gmail_quote">On Tue, Oct 21, 2008 at 9:40 AM, Scott Kushner <span dir="ltr"><<a href="mailto:skushner@mplmain.mtpl.org">skushner@mplmain.mtpl.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">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)<br></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Any ideas, thanks! </span></p><div class="Ih2E3d">
<p><span style="font-size: 10pt; color: rgb(31, 73, 125);">Scott Kushner</span><span style="font-size: 10pt; color: rgb(31, 73, 125);"><br>Information Technologies</span><span style="font-size: 10pt; color: rgb(31, 73, 125);"><br>
Middletown Public Library</span><span style="color: rgb(31, 73, 125);"></span></p>
</div><div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> Joe Atzberger
[mailto:<a href="mailto:ohiocore@gmail.com" target="_blank">ohiocore@gmail.com</a>] <br>
<b>Sent:</b> Monday, October 20, 2008 10:47 AM<br>
<b>To:</b> Jesse Weaver<br>
<b>Cc:</b> Scott Kushner; <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a><div class="Ih2E3d"><br>
<b>Subject:</b> Re: [Koha] Koha error/fatal error</div></span></p>
</div>
<p> </p>
<div>
<p style="margin-bottom: 12pt;">If the database is on the same
system, then the IP is typically something like localhost's <a href="http://127.0.0.1" target="_blank">127.0.0.1</a>. If the DB is on the same system,
try setting your <hostname> to "localhost" rather than an
external IP.</p><div><div></div><div class="Wj3C7c"><br>
<br>
>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:<br>
<br>
mysql -uMyUser -pMyPassword -h XXX.XXX.X.XXX my_databasename<br>
<br>
There are four (or five) values there that Koha pulls from your KOHA_CONF
file. </div></div><div><div></div><div class="Wj3C7c">
<div style="margin-left: 30pt;">
<p> <database><br>
<hostname><br>
<port><br>
<user><br>
<pass></p>
</div>
<p style="margin-bottom: 12pt;"><br>
This should simulate the kind of connection Koha is attempting and possibly
give you better detail about the error.<br>
<br>
--Joe Atzberger,<br>
LibLime</p>
<div>
<p> </p>
<div>
<p>On Sat, Oct 18, 2008 at 7:37 PM, Jesse Weaver <<a href="mailto:jesse.weaver@liblime.com" target="_blank">jesse.weaver@liblime.com</a>> wrote:</p>
<div>
<div>
<div>
<div>
<p>On Fri, Oct 17, 2008 at 2:28 PM, Scott Kushner <<a href="mailto:skushner@mplmain.mtpl.org" target="_blank">skushner@mplmain.mtpl.org</a>>
wrote:</p>
</div>
</div>
<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204); border-width: medium medium medium 1pt; padding: 0in 0in 0in 6pt; margin-left: 4.8pt; margin-right: 0in;">
<div>
<div>
<div>
<div>
<p>I had the following problem while trying to setup web installer…</p>
<p>Is this a rights issue? Can any one help. thanks</p>
<p style="line-height: 14.4pt;"><b><span style="font-size: 10pt; color: rgb(51, 51, 51);">Koha
error</span></b></p>
<p style="line-height: 14.4pt;"><span style="font-size: 10pt; color: rgb(51, 51, 51);">The
following fatal error has occurred:</span></p>
<p style="line-height: 14.4pt;"><span style="font-size: 13pt; color: rgb(51, 51, 51);">Can't
connect to MySQL server on 'xxx.xxx.x.xxx' (111) at
/usr/share/koha/lib/C4/Context.pm line 646.<br>
Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 25.<br>
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line
25.<br>
Compilation failed in require at /usr/share/koha/lib/C4/Overdues.pm line 24.<br>
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line
24.<br>
Compilation failed in require at /usr/share/koha/lib/C4/Members.pm line 27.<br>
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 27.<br>
Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 31.<br>
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 31.<br>
Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl
line 23.<br>
BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl
line</span></p>
<p><span style="font-size: 13pt; color: rgb(51, 51, 51);"> 23.</span> </p>
<p><span style="font-size: 10pt;">Scott Kushner<br>
Information Technologies<br>
Middletown Public Library<br>
732 671-3700 (x314)</span></p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<p><br>
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.<br clear="all">
<br>
-- <br>
Jesse Weaver<br>
Software Developer, LibLime</p>
</div>
<p> </p>
</div>
</div>
</div></div></div>
</div>
</div>
</blockquote></div><br></div>