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's <a href=3D"http://127.0.0.1">127.0.0.1=
</a>. If the DB is on the same system, try setting your <hostname&=
gt; to "localhost" rather than an external IP.<br>
<br>From your batch of X'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. <br><br><div style=3D"margin-left: 40px;"> <database=
><br> <hostname><br> <port><br> <user><=
br> <pass><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"><<a href=3D"mailto:jesse.weaver at lib=
lime.com">jesse.weaver at liblime.com</a>></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"><<a href=3D"mailt=
o:skushner at mplmain.mtpl.org" target=3D"_blank">skushner at mplmain.mtpl.org</a=
>></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 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't connect to MySQL server on 'xxx.xxx.x.xxx'=
;
(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);"> 23.</span=
><span style=3D"font-size: 11.5pt; color: rgb(51, 51, 51);"></span> </=
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'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