No subject


Mon Jul 7 17:18:21 NZST 2008


e
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>wro=
te:

> 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=85
>>
>> 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 compute=
r
> set up to accept outside connections? Most aren't by default.
>
> --
> Jesse Weaver
> Software Developer, LibLime
>
>

------=_Part_82089_20397510.1224514015718
Content-Type: text/html; charset=WINDOWS-1252
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div dir=3D"ltr">If the database is on the same system, then the IP is typi=
cally something like localhost&#39;s <a href=3D"http://127.0.0.1">127.0.0.1=
</a>.&nbsp; If the DB is on the same system, try setting your &lt;hostname&=
gt; to &quot;localhost&quot; rather than an external IP.<br>
<br>From your batch of X&#39;s, it looks like that might not be the case.&n=
bsp; 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_database=
name<br>
<br>There are four (or five) values there that Koha pulls from your KOHA_CO=
NF file.&nbsp; <br><br><div style=3D"margin-left: 40px;">&nbsp;&lt;database=
&gt;<br>&nbsp;&lt;hostname&gt;<br>&nbsp;&lt;port&gt;<br>&nbsp;&lt;user&gt;<=
br>&nbsp;&lt;pass&gt;<br></div>
<br>This should simulate the kind of connection Koha is attempting and poss=
ibly give you better detail about the error.<br><br>--Joe Atzberger,<br>Lib=
Lime<br><br><div><br><div class=3D"gmail_quote">On Sat, Oct 18, 2008 at 7:3=
7 PM, Jesse Weaver <span dir=3D"ltr">&lt;<a href=3D"mailto:jesse.weaver at lib=
lime.com">jesse.weaver at liblime.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div dir=3D"ltr">=
<div class=3D"gmail_quote"><div><div></div><div class=3D"Wj3C7c">On Fri, Oc=
t 17, 2008 at 2:28 PM, Scott Kushner <span dir=3D"ltr">&lt;<a href=3D"mailt=
o:skushner at mplmain.mtpl.org" target=3D"_blank">skushner at mplmain.mtpl.org</a=
>&gt;</span> wrote:<br>
</div></div><blockquote class=3D"gmail_quote" style=3D"border-left: 1px sol=
id rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>=
<div></div><div class=3D"Wj3C7c">









<div link=3D"blue" vlink=3D"purple" lang=3D"EN-US">

<div>

<p>I had the following problem while trying to setup&nbsp; web
installer=85</p>



<p>Is this a rights issue? Can any one help. thanks</p>

<p style=3D"line-height: 14.4pt;"><b><span style=3D"font-size: 10pt; color:=
 rgb(51, 51, 51);">Koha error</span></b></p>

<p style=3D"line-height: 14.4pt;"><span style=3D"font-size: 10pt; color: rg=
b(51, 51, 51);">The following </span><span style=3D"font-size: 10pt; color:=
 rgb(51, 51, 51);">fatal error</span><span style=3D"font-size: 10pt; color:=
 rgb(51, 51, 51);"> has occurred:</span></p>



<p style=3D"line-height: 14.4pt;"><span style=3D"font-size: 13pt; color: rg=
b(51, 51, 51);">Can&#39;t connect to MySQL server on &#39;xxx.xxx.x.xxx&#39=
;
(111) at /usr/share/koha/lib/C4/Context.pm line 646.</span><span style=3D"f=
ont-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">Compilation
failed in require at /usr/share/koha/lib/C4/Circulation.pm line 25.</span><=
span style=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">BEGIN
failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 2=
5.</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">Compilation
failed in require at /usr/share/koha/lib/C4/Overdues.pm line 24.</span><spa=
n style=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">BEGIN
failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line 24.<=
/span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">Compilation
failed in require at /usr/share/koha/lib/C4/Members.pm line 27.</span><span=
 style=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">BEGIN
failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 27.</=
span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">Compilation
failed in require at /usr/share/koha/lib/C4/Auth.pm line 31.</span><span st=
yle=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">BEGIN
failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 31.</spa=
n><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">Compilation
failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 23.<=
/span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);"><br>
</span><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">BEGIN
failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl
line</span></p>



<p><span style=3D"font-size: 13pt; color: rgb(51, 51, 51);">&nbsp;23.</span=
><span style=3D"font-size: 11.5pt; color: rgb(51, 51, 51);"></span>&nbsp;</=
p>







<p><span style=3D"font-size: 10pt;">Scott
Kushner</span><span style=3D"font-size: 10pt;"><br>Information
Technologies</span><span style=3D"font-size: 10pt;"><br>Middletown
Public Library</span><span style=3D"font-size: 10pt;"><br>732
671-3700 (x314)</span></p>

</div>

</div>


</div></div></blockquote></div><br>This looks more like a network issue. Is=
 the MySQL server on that computer set up to accept outside connections? Mo=
st aren&#39;t by default.<br clear=3D"all"><br>-- <br>Jesse Weaver<br>Softw=
are Developer, LibLime<br>


</div>
<br></blockquote></div></div></div>

------=_Part_82089_20397510.1224514015718--


More information about the Koha mailing list