Problem Connecting to MySQL Database

This is a multi-part message in MIME format.

--===============0785148211==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0000_01CB5DBE.BD640810"

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01CB5DBE.BD640810
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I'm using a MacBook Pro running OS X 10.6.4 and I installed ActiveState Perl
- I'm using version 5.8.8 at the moment. I did this to make it easier to
install some of the modules I wanted but I'm not sure I wouldn't have been
better just to use the Perl that comes with the Mac OS!

The problem I have is that I can't connect to a MySQL database that I have
on the MacBook, set up using MAMP PRO. When I was running everything under
Windows I used to have the DBD::mysql driver installed but this doesn't seem
to be available for this build so I'm using DBD::mysqlPP which I assume
should work in the same way. However the connection string fails when I try
to connect using the following:

$dsn = "DBI:mysqlPP:host=localhost:database=$database";

$dbh = DBI->connect($dsn, $username, $database, {

RaiseError => 0,

PrintError => 0

}) || ($error = "Got error '$DBI::errstr' when connecting to $dsn\n");

and the error message is:

Got error 'Couldn't connect to localhost:3306/tcp: IO::Socket::INET:
connect: Connection refused at
/Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when
connecting to
DBI:mysqlPP:host=localhost:database=$database.

I've checked that I was using the correct username and password, setting up
and trying different ones, but without success. I have a feeling that I read
somewhere that there was a problem using Perl to connect to a database set
up under MAMP but can't recall what the problem was.

Can anyone suggest why this is not working.

Eric Robertson

------=_NextPart_000_0000_01CB5DBE.BD640810
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

I’m using a MacBook Pro running OS X =
10.6.4 and
I installed ActiveState Perl - I’m using version 5.8.8 at the =
moment. I
did this to make it easier to install some of the modules I wanted but
I’m not sure I wouldn’t have been better just to use the =
Perl that
comes with the Mac OS!<o:p></o:p>

<o:p> </o:p>

The problem I have is that I can’t =
connect to a
MySQL database that I have on the MacBook, set up using MAMP PRO. When I =
was
running everything under Windows I used to have the DBD::mysql driver =
installed
but this doesn’t seem to be available for this build so I’m =
using
DBD::mysqlPP which I assume should work in the same way. However the =
connection
string fails when I try to connect using the =
following:<o:p></o:p>

<o:p> </o:p>

$dsn =3D
"DBI:mysqlPP:host=3Dlocalhost:database=3D$database";<o:p></o:p>=


$dbh =3D
DBI->connect($dsn, $username, $database, =
{<o:p></o:p>

 =
RaiseError
=3D> 0,<o:p></o:p>

 =
PrintError
=3D> 0<o:p></o:p>

}) || ($error =
=3D "Got
error '$DBI::errstr' when connecting to =
$dsn\n");<o:p></o:p>

<o:p> </o:p>

and the error message =
is:<o:p></o:p>

<o:p> </o:p>

Got error =
'Couldn't
connect to localhost:3306/tcp: IO::Socket::INET: connect: Connection =
refused at
/Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when =
connecting
to 
DBI:mysqlPP:host=3Dlocalhost:database=3D$database.<o:p></o:p></fon=
t>

<o:p> </o:p>

I’ve checked that I was using the =
correct
username and password, setting up and trying different ones, but without
success. I have a feeling that I read somewhere that there was a problem =
using
Perl to connect to a database set up under MAMP but can’t recall =
what the
problem was.<o:p></o:p>

<o:p> </o:p>

Can anyone suggest why this is not =
working.<o:p></o:p>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<o:p> </o:p>

Eric Robertson<o:p></o:p>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

<o:p> </o:p>

</div>

</body>

</html>

------=_NextPart_000_0000_01CB5DBE.BD640810--

--===============0785148211==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
--===============0785148211==--

This is a multi-part message in MIME format.

--===============0216709024==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0037_01CB5E7A.D45C4930"

This is a multi-part message in MIME format.

------=_NextPart_000_0037_01CB5E7A.D45C4930
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

On Mon, Sep 27, 2010 at 3:06 AM, Eric Robertson <ericrob [at] blueyonder.co.uk>
wrote:

I'm using a MacBook Pro running OS X 10.6.4 and I installed ActiveState Perl
- I'm using version 5.8.8 at the moment. I did this to make it easier to
install some of the modules I wanted but I'm not sure I wouldn't have been
better just to use the Perl that comes with the Mac OS!

The problem I have is that I can't connect to a MySQL database that I have
on the MacBook, set up using MAMP PRO. When I was running everything under
Windows I used to have the DBD::mysql driver installed but this doesn't seem
to be available for this build so I'm using DBD::mysqlPP which I assume
should work in the same way. However the connection string fails when I try
to connect using the following:

$dsn = "DBI:mysqlPP:host=localhost:database=$database";
$dbh = DBI->connect($dsn, $username, $database, {
RaiseError => 0,
PrintError => 0}) || ($error = "Got error '$DBI::errstr' when
connecting to $dsn\n");

and the error message is:

Got error 'Couldn't connect to localhost:3306/tcp: IO::Socket::INET:
connect: Connection refused at
/Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when
connecting to
DBI:mysqlPP:host=localhost:database=$database.

I've checked that I was using the correct username and password, setting up
and trying different ones, but without success. I have a feeling that I read
somewhere that there was a problem using Perl to connect to a database set
up under MAMP but can't recall what the problem was.

Can anyone suggest why this is not working.

Eric Robertson

_____

From: Tim Bolshaw [mailto:timothybolshaw [at] gmail.com]
Sent: 27 September 2010 16:02
To: Eric Robertson
Subject: Re: Problem Connecting to MySQL Database

$dsn="DBI:mysqlPP:host=localhost;database=$database";

(i.e, replace colon with semicolon after localhost)

--
Tim Bolshaw

timothybolshaw [at] gmail.com
Mobile: +66-(0)87 072 5009

Tim

I'm afraid this didn't work - I got the same error message. In fact I had
tested the connection string with the colon on the live server and this
worked OK but I need to use my own server for testing so that I can debug my
code in Komodo.

Eric.

------=_NextPart_000_0037_01CB5E7A.D45C4930
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>

<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue>

<div class=3DSection1>

<div>

<div>

On Mon, Sep =
27, 2010 at
3:06 AM, Eric Robertson <<a =
href=3D"mailto:ericrob [at] blueyonder.co.uk">ericrob [at] blueyonder. co.uk</a>>=

wrote:<o:p></o:p>

<div link=3Dblue vlink=3Dpurple>

<div>

I’m using a MacBook Pro running OS X =
10.6.4 and
I installed ActiveState Perl - I’m using version 5.8.8 at the =
moment. I
did this to make it easier to install some of the modules I wanted but
I’m not sure I wouldn’t have been better just to use the =
Perl that
comes with the Mac OS! <o:p></o:p>

The problem I have is that I can’t =
connect to a
MySQL database that I have on the MacBook, set up using MAMP PRO. When I =
was
running everything under Windows I used to have the DBD::mysql driver =
installed
but this doesn’t seem to be available for this build so I’m =
using
DBD::mysqlPP which I assume should work in the same way. However the =
connection
string fails when I try to connect using the =
following:<o:p></o:p>

$dsn =3D
"DBI:mysqlPP:host=3Dlocalhost:database=3D$database";</fo=
nt> 
$dbh =3D DBI->connect($dsn, $username, $database, =
{ 
RaiseError =
=3D> 0, 
PrintError =
=3D> 0}) ||
($error =3D "Got error '$DBI::errstr' when connecting to =
$dsn\n");<o:p></o:p>

 and the error message =
is:<o:p></o:p>

 Got error 'Couldn't connect to
localhost:3306/tcp: IO::Socket::INET: connect: Connection refused at
/Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when =
connecting
to 
DBI:mysqlPP:host=3Dlocalhost:database=3D$database.<o:p></o:=
p>

 I’ve checked that I was using the =
correct
username and password, setting up and trying different ones, but without
success. I have a feeling that I read somewhere that there was a problem =
using
Perl to connect to a database set up under MAMP but can’t recall =
what the
problem was.<o:p></o:p>

 Can anyone suggest why this is not =
working.<o:p></o:p>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

 Eric =
Robertson<o:p></o:p>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

<div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:36.0pt;text-align:center'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</div>

From:</spa=
n> Tim
Bolshaw [mailto:timothybolshaw [at] gmail.com] 
Sent: 27 September 2010 =
16:02 
To: Eric Robertson 
Subject: Re: Problem =
Connecting to
MySQL Database<o:p></o:p>

<o:p> </o:p>

$dsn=3D"DBI:mysqlPP:host=3Dlocalhost<s=
pan
style=3D'font-weight:bold'>;database=3D$database";<o:p></=
o:p>

(i.e, replace =
colon with
semicolon after localhost)<o:p></o:p>

-- 
Tim Bolshaw 
 
<a =
href=3D"mailto:timothybolshaw [at] gmail.com">timothybolshaw [at] gmai l.com</a> =

<st1:place w:st=3D"on"><st1:City =
w:st=3D"on">Mobile</st1:City></st1:place>:
+66-(0)87 072 5009<o:p></o:p>

</div>

<o:p> </o:p>=


Tim<o:p></o:p></s=
pan>

<o:p> </o:p>=


I’m afraid =
this
didn’t work – I got the same error message. In fact I had =
tested
the connection string with the colon on the live server and this worked =
OK but
I need to use my own server for testing so that I can debug my code in =
Komodo.<o:p></o:p>

<o:p> </o:p>=


Eric .<o:p></o:p><=
/span>

<o:p> </o:p>

</div>

</body>

</html>

------=_NextPart_000_0037_01CB5E7A.D45C4930--

--===============0216709024==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
--===============0216709024==--

This is a multi-part message in MIME format.

--===============1886945993==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0015_01CB5E9D.2BE7D080"

This is a multi-part message in MIME format.

------=_NextPart_000_0015_01CB5E9D.2BE7D080
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

_____

From: Eric Robertson [mailto:ericrob [at] blueyonder.co.uk]
Sent: September 27, 2010 2:33 PM
To: 'Tim Bolshaw'
Cc: activeperl [at] listserv.ActiveState.com
Subject: RE: Problem Connecting to MySQL Database

On Mon, Sep 27, 2010 at 3:06 AM, Eric Robertson <ericrob [at] blueyonder.co.uk>
wrote:

I'm using a MacBook Pro running OS X 10.6.4 and I installed ActiveState Perl
- I'm using version 5.8.8 at the moment. I did this to make it easier to
install some of the modules I wanted but I'm not sure I wouldn't have been
better just to use the Perl that comes with the Mac OS!

The problem I have is that I can't connect to a MySQL database that I have
on the MacBook, set up using MAMP PRO. When I was running everything under
Windows I used to have the DBD::mysql driver installed but this doesn't seem
to be available for this build so I'm using DBD::mysqlPP which I assume
should work in the same way. However the connection string fails when I try
to connect using the following:

$dsn = "DBI:mysqlPP:host=localhost:database=$database";
$dbh = DBI->connect($dsn, $username, $database, {
RaiseError => 0,
PrintError => 0}) || ($error = "Got error '$DBI::errstr' when
connecting to $dsn\n");

and the error message is:

Got error 'Couldn't connect to localhost:3306/tcp: IO::Socket::INET:
connect: Connection refused at
/Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when
connecting to
DBI:mysqlPP:host=localhost:database=$database.

I've checked that I was using the correct username and password, setting up
and trying different ones, but without success. I have a feeling that I read
somewhere that there was a problem using Perl to connect to a database set
up under MAMP but can't recall what the problem was.

Can anyone suggest why this is not working.

Eric Robertson

_____

From: Tim Bolshaw [mailto:timothybolshaw [at] gmail.com]
Sent: 27 September 2010 16:02
To: Eric Robertson
Subject: Re: Problem Connecting to MySQL Database

$dsn="DBI:mysqlPP:host=localhost;database=$database";

(i.e, replace colon with semicolon after localhost)

--
Tim Bolshaw

timothybolshaw [at] gmail.com
Mobile: +66-(0)87 072 5009

Tim

I'm afraid this didn't work - I got the same error message. In fact I had
tested the connection string with the colon on the live server and this
worked OK but I need to use my own server for testing so that I can debug my
code in Komodo.

Eric.

_____

From: Czarnowas, Andrew [mailto:Andrew.Czarnowas [at] thebeerstore.ca]
Sent: 27 September 2010 20:56
To: Eric Robertson
Subject: RE: Problem Connecting to MySQL Database

$dsn = "DBI:mysqlPP:host=localhost:database=$database";
$dbh = DBI->connect($dsn, $username, $database, {
RaiseError => 0,
PrintError => 0}) || ($error = "Got error '$DBI::errstr' when
connecting to $dsn\n");

Should this be password?

Andrew

Yes, it should - I did use an actual password here but had meant to replace
it with $password, so that isn't the problem unfortunately.

Eric.

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.856 / Virus Database: 271.1.1/3160 - Release Date: 09/26/10
08:01:00

------=_NextPart_000_0015_01CB5E9D.2BE7D080
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>

<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue>

<div class=3DSection1>

<div>

<o:p> </o:p>

</div>

<div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:36.0pt;text-align:center'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabIndex=3D-1>

</div>

From: Eric
Robertson [mailto:ericrob [at] blueyonder.co.uk] 
Sent: September 27, 2010 =
2:33 PM 
To: 'Tim Bolshaw' 
Cc:
activeperl [at] listserv.ActiveState.com 
Subject: RE: Problem =
Connecting to
MySQL Database<o:p></o:p>

<div>

<div>

On Mon, Sep =
27, 2010 at
3:06 AM, Eric Robertson <<a =
href=3D"mailto:ericrob [at] blueyonder.co.uk">ericrob [at] blueyonder. co.uk</a>>=

wrote:<o:p></o:p>

<div vlink=3Dpurple link=3Dblue>

<div>

I’m using a MacBook Pro running OS X =
10.6.4 and
I installed ActiveState Perl - I’m using version 5.8.8 at the =
moment. I
did this to make it easier to install some of the modules I wanted but
I’m not sure I wouldn’t have been better just to use the =
Perl that
comes with the Mac OS! <o:p></o:p>

The problem I have is that I can’t =
connect to a
MySQL database that I have on the MacBook, set up using MAMP PRO. When I =
was
running everything under Windows I used to have the DBD::mysql driver =
installed
but this doesn’t seem to be available for this build so I’m =
using
DBD::mysqlPP which I assume should work in the same way. However the =
connection
string fails when I try to connect using the =
following:<o:p></o:p>

$dsn =3D
"DBI:mysqlPP:host=3Dlocalhost:database=3D$database";</fo=
nt> 
$dbh =3D DBI->connect($dsn, $username, $database, =
{ 
 RaiseError =
=3D> 0, 
 PrintError =
=3D> 0}) ||
($error =3D "Got error '$DBI::errstr' when connecting to =
$dsn\n");<o:p></o:p>

 and the error message =
is:<o:p></o:p>

 Got error 'Couldn't connect to
localhost:3306/tcp: IO::Socket::INET: connect: Connection refused at
/Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when =
connecting
to 
DBI:mysqlPP:host=3Dlocalhost:database=3D$database.<o:p></o:=
p>

 I’ve checked that I was using the =
correct
username and password, setting up and trying different ones, but without
success. I have a feeling that I read somewhere that there was a problem =
using
Perl to connect to a database set up under MAMP but can’t recall =
what the
problem was.<o:p></o:p>

 Can anyone suggest why this is not =
working.<o:p></o:p>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

<div>

 Eric =
Robertson<o:p></o:p>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

<div style=3D'margin-left:36.0pt'>

<div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:36.0pt;text-align:center'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabIndex=3D-1>

</div>

</div>

From:</spa=
n> Tim
Bolshaw [mailto:timothybolshaw [at] gmail.com] 
Sent: 27 September 2010 =
16:02 
To: Eric Robertson 
Subject: Re: Problem =
Connecting to
MySQL Database<o:p></o:p>

<o:p> </o:p>

$dsn=3D"DBI:mysqlPP:host=3Dlocalhost<s=
pan
style=3D'font-weight:bold'>;database=3D$database";<o:p></=
o:p>

(i.e, replace =
colon with
semicolon after localhost)<o:p></o:p>

-- 
Tim Bolshaw 
 
<a =
href=3D"mailto:timothybolshaw [at] gmail.com">timothybolshaw [at] gmai l.com</a> =

<st1:place w:st=3D"on"><st1:City =
w:st=3D"on">Mobile</st1:City></st1:place>:
+66-(0)87 072 5009<o:p></o:p>

</div>

<o:p> </o:p>=


Tim<o:p></o:p></s=
pan>

<o:p> </o:p>=


I’m afraid =
this
didn’t work – I got the same error message. In fact I had =
tested
the connection string with the colon on the live server and this worked =
OK but
I need to use my own server for testing so that I can debug my code in =
Komodo.<o:p></o:p>

<o:p> </o:p>=


Eric .<o:p></o:p><=
/span>

<div class=3DMsoNormal align=3Dcenter =
style=3D'margin-left:36.0pt;text-align:center'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</div>

From:</spa=
n>
Czarnowas, Andrew [mailto:Andrew.Czarnowas [at] thebeerstore.ca] 
Sent: 27 September 2010 =
20:56 
To: Eric Robertson 
Subject: RE: Problem =
Connecting to
MySQL Database<o:p></o:p>

<o:p> </o:p>

$dsn =3D
"DBI:mysqlPP:host=3Dlocalhost:database=3D$database";</fo=
nt> 
$dbh =3D
DBI->connect($dsn, $username, $database, =
{ 
 Rais eError
=3D> 0, 
 Prin tError
=3D> 0}) || ($error =3D "Got error '$DBI::errstr' when =
connecting to
$dsn\n");<o:p></o:p>

 <o:p></o:p>

Shou ld this&=
nbsp;be password?<o:p></o:p>

 <o:p></o:p>

Andr ew</fo=
nt><o:p></o:p>

<o:p> </o:p>

Yes, it should – I did use an actual password =
here but
had meant to replace it with $password, so that isn’t the problem
unfortunately.<o:p></o:p>

Eric.<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

</div>

</body>

</html>
No virus found in this incoming =
message. 
Checked by AVG - www.avg.com 
Version: 9.0.856 / Virus Database: 271.1.1/3160 - Release Date: 09/26/10 =
08:01:00 

------=_NextPart_000_0015_01CB5E9D.2BE7D080--

--===============1886945993==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
--===============1886945993==--

> -----Original Message-----
> From: Bill Luebkert [mailto:dbecoll [at] roadrunner.com]
> Sent: 27 September 2010 21:54
> To: Eric Robertson
> Subject: Re: Problem Connecting to MySQL Database
>
> On 9/26/2010 1:06 PM, Eric Robertson wrote:
> > I'm using a MacBook Pro running OS X 10.6.4 and I installed ActiveState
> Perl - I'm using version 5.8.8 at the moment. I did this to make it easier
> to install some of the modules I wanted but I'm not sure I wouldn't have
> been better just to use the Perl that comes with the Mac OS!
> >
> > The problem I have is that I can't connect to a MySQL database that I
> have on the MacBook, set up using MAMP PRO. When I was running everything
> under Windows I used to have the DBD::mysql driver installed but this
> doesn't seem to be available for this build so I'm using DBD::mysqlPP
> which I assume should work in the same way. However the connection string
> fails when I try to connect using the following:
> >
> > $dsn = "DBI:mysqlPP:host=localhost:database=$database";
> >
> > $dbh = DBI->connect($dsn, $username, $database, {
> >
> > RaiseError => 0,
> >
> > PrintError => 0
> >
> > }) || ($error = "Got error '$DBI::errstr' when connecting to $dsn\n");
> >
> > and the error message is:
> >
> > Got error 'Couldn't connect to localhost:3306/tcp: IO::Socket::INET:
> connect: Connection refused at
> /Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when
> connecting to
> > DBI:mysqlPP:host=localhost:database=$database.
> >
> > I've checked that I was using the correct username and password, setting
> up and trying different ones, but without success. I have a feeling that I
> read somewhere that there was a problem using Perl to connect to a
> database set up under MAMP but can't recall what the problem was.
> >
> > Can anyone suggest why this is not working.
>
> That sounds like the SQL server isn't listening on 3306. Do you have
> a utility program on OSX that can list the programs listening on a
> port (like netstat on Windoze) and see if 3306 has a listener attached ?
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.856 / Virus Database: 271.1.1/3160 - Release Date: 09/26/10
> 08:01:00

Many thanks for this comment. I'm afraid I don't know how to do this on the
Mac but will try to find out.

Eric.

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Mac is basically unix, use `netstat -an`

________________________________________
From: activeperl-bounces [at] listserv.ActiveState.com [activeperl-bounces [at] listserv.ActiveState.com] On Behalf Of Eric Robertson [ericrob [at] blueyonder.co.uk]
Sent: Monday, September 27, 2010 3:44 PM
To: 'Bill Luebkert'
Cc: activeperl [at] listserv.ActiveState.com
Subject: RE: Problem Connecting to MySQL Database

> -----Original Message-----
> From: Bill Luebkert [mailto:dbecoll [at] roadrunner.com]
> Sent: 27 September 2010 21:54
> To: Eric Robertson
> Subject: Re: Problem Connecting to MySQL Database
>
> On 9/26/2010 1:06 PM, Eric Robertson wrote:
> > I'm using a MacBook Pro running OS X 10.6.4 and I installed ActiveState
> Perl - I'm using version 5.8.8 at the moment. I did this to make it easier
> to install some of the modules I wanted but I'm not sure I wouldn't have
> been better just to use the Perl that comes with the Mac OS!
> >
> > The problem I have is that I can't connect to a MySQL database that I
> have on the MacBook, set up using MAMP PRO. When I was running everything
> under Windows I used to have the DBD::mysql driver installed but this
> doesn't seem to be available for this build so I'm using DBD::mysqlPP
> which I assume should work in the same way. However the connection string
> fails when I try to connect using the following:
> >
> > $dsn = "DBI:mysqlPP:host=localhost:database=$database";
> >
> > $dbh = DBI->connect($dsn, $username, $database, {
> >
> > RaiseError => 0,
> >
> > PrintError => 0
> >
> > }) || ($error = "Got error '$DBI::errstr' when connecting to $dsn\n");
> >
> > and the error message is:
> >
> > Got error 'Couldn't connect to localhost:3306/tcp: IO::Socket::INET:
> connect: Connection refused at
> /Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when
> connecting to
> > DBI:mysqlPP:host=localhost:database=$database.
> >
> > I've checked that I was using the correct username and password, setting
> up and trying different ones, but without success. I have a feeling that I
> read somewhere that there was a problem using Perl to connect to a
> database set up under MAMP but can't recall what the problem was.
> >
> > Can anyone suggest why this is not working.
>
> That sounds like the SQL server isn't listening on 3306. Do you have
> a utility program on OSX that can list the programs listening on a
> port (like netstat on Windoze) and see if 3306 has a listener attached ?
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.856 / Virus Database: 271.1.1/3160 - Release Date: 09/26/10
> 08:01:00

Many thanks for this comment. I'm afraid I don't know how to do this on the
Mac but will try to find out.

Eric.

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--===============1512044859==
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature";
boundary="------------enig2031407EF0C9A70281FE852A"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig2031407EF0C9A70281FE852A
Content-Type: multipart/alternative;
boundary="------------070808070607020106060606"

This is a multi-part message in MIME format.
--------------070808070607020106060606
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

First things first:
a)locate mysql's configuration file my.cnf normally under /etc , make
sure that the lineskip_networking does not appear in it !
b)comment it out if it's in the file.
c) Restart mysql
d)telnet to port 3306 manually and see if the server answers the connecti=
on.

if all of the above works then you are go !

On 27/9/2010 9:33 ??, Eric Robertson wrote:
>
> On Mon, Sep 27, 2010 at 3:06 AM, Eric Robertson
> <ericrob [at] blueyonder.co.uk <mailto:ericrob [at] blueyonder.co.uk>> wrote:
>
> I'm using a MacBook Pro running OS X 10.6.4 and I installed
> ActiveState Perl - I'm using version 5.8.8 at the moment. I did this
> to make it easier to install some of the modules I wanted but I'm not
> sure I wouldn't have been better just to use the Perl that comes with
> the Mac OS!
>
> The problem I have is that I can't connect to a MySQL database that I
> have on the MacBook, set up using MAMP PRO. When I was running
> everything under Windows I used to have the DBD::mysql driver
> installed but this doesn't seem to be available for this build so I'm
> using DBD::mysqlPP which I assume should work in the same way. However
> the connection string fails when I try to connect using the following:
>
> $dsn =3D "DBI:mysqlPP:host=3Dlocalhost:database=3D$database";
>

--------------070808070607020106060606
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content=3D"text/html; charset=3DISO-8859-1"
http-equiv=3D"Content-Type">
<title></title>
</head>
<body text=3D"#000000" bgcolor=3D"#ffffff">
First things first: 
a)locate mysql's configuration file my.cnf normally under /etc ,
make sure that the lineskip_networking does not appear in it ! 
b)comment it out if it's in the file. 
c) Restart mysql 
d)telnet to port 3306 manually and see if the server answers the
connection. 
 
if all of the above works then you are go ! 
 
On 27/9/2010 9:33 μμ, Eric Robertson wrote:
<blockquote cite=3D"mid:A8ABEA56D7924E8AAB876414C65FD6E0 [at] macbookXP"
type=3D"cite">
<meta http-equiv=3D"Content-Type" content=3D"text/html;
charset=3DISO-8859-1">
<meta name=3D"Generator" content=3D"Microsoft Word 11 (filtered
medium)">
<o:smarttagtype
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City">
<o:smarttagtype
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place">

<style>

</style>
<div class=3D"Section1">
<div>
<div>
<font=

size=3D"3" face=3D"Times New Roman">On Mon, Sep 27, 2010 at
3:06 AM, Eric Robertson <<a
moz-do-not-send=3D"true"
href=3D"mailto:ericrob [at] blueyonder.co.uk">ericrob [at] =
blueyonder.co.uk</a>>
wrote:<o:p></o:p>
<div link=3D"blue" vlink=3D"purple">
<div>
<=
font
size=3D"2" face=3D"Arial">IR=
17;m
using a MacBook Pro running OS X 10.6.4 and
I installed ActiveState Perl - I’m using
version 5.8.8 at the moment. I
did this to make it easier to install some of
the modules I wanted but
I’m not sure I wouldn’t have been b=
etter just
to use the Perl that
comes with the Mac OS! <font=

color=3D"navy"><o:p>=
</o:p>
<=
font
size=3D"2" face=3D"Arial">The
problem I have is that I can’t connect to=
a
MySQL database that I have on the MacBook, set
up using MAMP PRO. When I was
running everything under Windows I used to
have the DBD::mysql driver installed
but this doesn’t seem to be available for=
this
build so I’m using
DBD::mysqlPP which I assume should work in the
same way. However the connection
string fails when I try to connect using the
following:<o:p></o:p>
<=
font
size=3D"2" face=3D"Arial">$dsn =
=3D
"DBI:mysqlPP:host=3Dlocalhost:database=3D$database"; 

</div>
</div>
</div>
</div>
</div>
</o:smarttagtype></o:smarttagtype></blockquote>
 
</body>
</html>

--------------070808070607020106060606--

--------------enig2031407EF0C9A70281FE852A
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJMoYGmAAoJEAa9bq/jDq5leJAH/iyKqgGWNV+NsRdTkMtm 2vx/
3Ia86N42+B7h6OpH1lu/SMgKH1a0o4pO98sY6dFmFKdD61Tdhei1mofDz7nN XnFW
CME3bjD4nzHSHejZTWefCfLfrSZr6ZRbR2paR3lFN/DuCvydtgaMKxh2jZ4K g7Ee
Q1iHuDLf5X3OvbYGDoxLtralAFOEWDzN9p6s3jWhQbB8YppfNBjRsNZasZN5 r5CZ
0dlFXcoDU3yKlTb0gC7q3guT935EzQA/MgLN1ur/cvEhvPlU8Hf1EqpCrzV+ BNh0
y9h0CLKuegsdgyajOSg009SR3AP2NZweUem9IrNgLU65kaKbYaNT85Of/moY gYc=
=yyhw
-----END PGP SIGNATURE-----

--------------enig2031407EF0C9A70281FE852A--

--===============1512044859==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
--===============1512044859==--

> -----Original Message-----
> From: Jeff Saxton [mailto:jeff_saxton [at] bigfix.com]
> Sent: 28 September 2010 00:46
> To: Eric Robertson; 'Bill Luebkert'
> Cc: activeperl [at] listserv.ActiveState.com
> Subject: RE: Problem Connecting to MySQL Database
>
> Mac is basically unix, use `netstat -an`
>
> ________________________________________
> From: activeperl-bounces [at] listserv.ActiveState.com [activeperl-
> bounces [at] listserv.ActiveState.com] On Behalf Of Eric Robertson
> [ericrob [at] blueyonder.co.uk]
> Sent: Monday, September 27, 2010 3:44 PM
> To: 'Bill Luebkert'
> Cc: activeperl [at] listserv.ActiveState.com
> Subject: RE: Problem Connecting to MySQL Database
>
> > -----Original Message-----
> > From: Bill Luebkert [mailto:dbecoll [at] roadrunner.com]
> > Sent: 27 September 2010 21:54
> > To: Eric Robertson
> > Subject: Re: Problem Connecting to MySQL Database
> >
> > On 9/26/2010 1:06 PM, Eric Robertson wrote:
> > > I'm using a MacBook Pro running OS X 10.6.4 and I installed
> ActiveState
> > Perl - I'm using version 5.8.8 at the moment. I did this to make it
> easier
> > to install some of the modules I wanted but I'm not sure I wouldn't have
> > been better just to use the Perl that comes with the Mac OS!
> > >
> > > The problem I have is that I can't connect to a MySQL database that I
> > have on the MacBook, set up using MAMP PRO. When I was running
> everything
> > under Windows I used to have the DBD::mysql driver installed but this
> > doesn't seem to be available for this build so I'm using DBD::mysqlPP
> > which I assume should work in the same way. However the connection
> string
> > fails when I try to connect using the following:
> > >
> > > $dsn = "DBI:mysqlPP:host=localhost:database=$database";
> > >
> > > $dbh = DBI->connect($dsn, $username, $database, {
> > >
> > > RaiseError => 0,
> > >
> > > PrintError => 0
> > >
> > > }) || ($error = "Got error '$DBI::errstr' when connecting to $dsn\n");
> > >
> > > and the error message is:
> > >
> > > Got error 'Couldn't connect to localhost:3306/tcp: IO::Socket::INET:
> > connect: Connection refused at
> > /Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when
> > connecting to
> > > DBI:mysqlPP:host=localhost:database=$database.
> > >
> > > I've checked that I was using the correct username and password,
> setting
> > up and trying different ones, but without success. I have a feeling that
> I
> > read somewhere that there was a problem using Perl to connect to a
> > database set up under MAMP but can't recall what the problem was.
> > >
> > > Can anyone suggest why this is not working.
> >
> > That sounds like the SQL server isn't listening on 3306. Do you have
> > a utility program on OSX that can list the programs listening on a
> > port (like netstat on Windoze) and see if 3306 has a listener attached ?
> > No virus found in this incoming message.
> > Checked by AVG - www.avg.com
> > Version: 9.0.856 / Virus Database: 271.1.1/3160 - Release Date: 09/26/10
> > 08:01:00
>
> Many thanks for this comment. I'm afraid I don't know how to do this on
> the
> Mac but will try to find out.
>
> Eric.

Thank you both for that. The problem was indeed that the SQL server wasn't
listening on port 3306. Andrew Czarnowas pointed out that the MAMP control
panel allows you to change the ports and having made that change everything
works like magic!

Eric

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

This is a multi-part message in MIME format.

--===============1326709384==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0004_01CB5FC4.23A47400"

This is a multi-part message in MIME format.

------=_NextPart_000_0004_01CB5FC4.23A47400
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

>>On Mon, Sep 27, 2010 at 3:06 AM, Eric Robertson <ericrob [at] blueyonder.co.uk>
wrote:

>>

>>I'm using a MacBook Pro running OS X 10.6.4 and I installed ActiveState
Perl - I'm using version 5.8.8 at the moment. I did this to make it easier
to install some of the modules I wanted but I'm not sure I wouldn't have
been better just to use >>the Perl that comes with the Mac OS!

>>

>>The problem I have is that I can't connect to a MySQL database that I have
on the MacBook, set up using MAMP PRO. When I was running everything under
Windows I used to have the DBD::mysql driver installed but this doesn't seem
to >>be available for this build so I'm using DBD::mysqlPP which I assume
should work in the same way. However the connection string fails when I try
to connect using the following:

>>

>> $dsn = "DBI:mysqlPP:host=localhost:database=$database";

>From: Angelos Karageorgiou [mailto:angelos [at] unix.gr]
>Sent: 28 September 2010 06:48
>To: Eric Robertson
>Cc: activeperl [at] listserv.ActiveState.com
>Subject: Re: Problem Connecting to MySQL Database

>

>First things first:
>a)locate mysql's configuration file my.cnf normally under /etc , make sure
that the lineskip_networking does not appear in it !
>b)comment it out if it's in the file.
>c) Restart mysql
>d)telnet to port 3306 manually and see if the server answers the
connection.
>
>if all of the above works then you are go !

Thanks Angelos - you'll see from my other posting that it was the listening
port that was the problem and that there was an easy way of fixing this
using the MAMP control panel.

Eric

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.856 / Virus Database: 271.1.1/3163 - Release Date: 09/27/10
18:56:00

------=_NextPart_000_0004_01CB5FC4.23A47400
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>

</style>

</head>

<body bgcolor=3Dwhite lang=3DEN-US link=3Dblue vlink=3Dblue>

<div class=3DSection1>

<div>

>>On Mon, Sep =
27, 2010
at 3:06 AM, Eric Robertson <<a =
href=3D"mailto:ericrob [at] blueyonder.co.uk"
moz-do-not-send=3Dtrue>ericrob [at] blueyonder.co.uk</a>> =
wrote:<o:p></o:p>

<u1:p></u1:p>

>><o:p> </o:p>

>>I<=
/font>’m
using a MacBook Pro running OS X 10.6.4 and I installed ActiveState Perl =
-
I’m using version 5.8.8 at the moment. I did this to make it =
easier to
install some of the modules I wanted but I’m not sure I =
wouldn’t
have been better just to use >></=
font>the
Perl that comes with the Mac OS! <o:p></o:p>

<u1:p></u1:p>

>><o:p>&=
nbsp;</o:p>

>></=
font>The
problem I have is that I can’t connect to a MySQL database that I =
have on
the MacBook, set up using MAMP PRO. When I was running everything under =
Windows
I used to have the DBD::mysql driver installed but this doesn’t =
seem to >>be available =
for this
build so I’m using DBD::mysqlPP which I assume should work in the =
same
way. However the connection string fails when I try to connect using the
following:<o:p></o:p><u1:p></u1:p>

>><o:p>&=
nbsp;</o:p>

>> &nb=
sp; $dsn
=3D =
"DBI:mysqlPP:host=3Dlocalhost:database=3D$database";</fo=
nt><o:p></o:p>

<o:p> </o:p>=

</u1:smarttagtype></u1:smarttagtype>

>From: Angelos Karageorgiou [mailto:angelos [at] unix.gr] 
>Sent: 28 September =
2010 06:48 
>To: Eric =
Robertson 
>Cc:
activeperl [at] listserv.ActiveState.com 
>Subject: Re: Problem
Connecting to MySQL Database<o:p></o:p>

</div>

><o:p> </o:p>=


>First things =
first: 
>a)locate =
mysql's
configuration file my.cnf normally under /etc , make sure that the
lineskip_networking does not appear in it ! 
>b)comment it out if
it's in the file. 
>c) =
Restart mysql 
>d)telnet =
to port
3306 manually and see if the server answers the connection. 
> 
>if all =
of the above
works then you are go ! 
 
<o:p></o:p>

Thanks Angelos – you’ll =
see
from my other posting that it was the listening port that was the =
problem and
that there was an easy way of fixing this using the MAMP control =
panel.<o:p></o:p>

<o:p> </o:p>

Eric<o:p></o:p>

</div>

</body>

</html>
No virus found in this incoming =
message. 
Checked by AVG - www.avg.com 
Version: 9.0.856 / Virus Database: 271.1.1/3163 - Release Date: 09/27/10 =
18:56:00 


 
------=_NextPart_000_0004_01CB5FC4.23A47400--

--===============1326709384==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
--===============1326709384==--

> > On 9/26/2010 1:06 PM, Eric Robertson wrote:
> > I'm using a MacBook Pro running OS X 10.6.4 and I installed
> > ActiveState
> > Perl - I'm using version 5.8.8 at the moment. I did this to make it
> > easier to install some of the modules I wanted but I'm not sure I
> > wouldn't have been better just to use the Perl that comes with the Mac
> > OS!
> >
> > The problem I have is that I can't connect to a MySQL database that
> > I
> > have on the MacBook, set up using MAMP PRO. When I was running
> > everything under Windows I used to have the DBD::mysql driver
> > installed but this doesn't seem to be available for this build so I'm
> > using DBD::mysqlPP which I assume should work in the same way. However
>
> > the connection string fails when I try to connect using the following:
> >
> > $dsn = "DBI:mysqlPP:host=localhost:database=$database";
> >
> > $dbh = DBI->connect($dsn, $username, $database, {
> >
> > RaiseError => 0,
> >
> > PrintError => 0
> >
> > }) || ($error = "Got error '$DBI::errstr' when connecting to
> > $dsn\n");
> >
> > and the error message is:
> >
> > Got error 'Couldn't connect to localhost:3306/tcp: IO::Socket::INET:
> > connect: Connection refused at
> > /Users/(myname)/Library/ActivePerl/lib/DBD/mysqlPP.pm line 109' when
> > connecting to
> > DBI:mysqlPP:host=localhost:database=$database.
> >
> > I've checked that I was using the correct username and password,
> > setting
> > up and trying different ones, but without success. I have a feeling
> > that I read somewhere that there was a problem using Perl to connect
> > to a database set up under MAMP but can't recall what the problem was.
> >
> > Can anyone suggest why this is not working.
>
> -----Original Message-----
> From: Czarnowas, Andrew [mailto:Andrew.Czarnowas [at] thebeerstore.ca]
> Sent: 28 September 2010 14:45
> To: Eric Robertson
> Subject: RE: Problem Connecting to MySQL Database
>
> MAMP & MAMP PRO uses Default port 8889 for mysql. You can also find the
> ports in MAMP application's Preferences Panel
>
> Here are some FAQs for MAMP & MAMP PRO
> http://www.mamp.info/en/documentation/faq.html#q6
>
> Andrew
>

Many thanks Andrew - I should have tried looking at the MAMP FAQs! I did as
you suggest and changing the server's listening port to 3306 has solved the
problem.

I can now get with debugging my code using the MySQL database on my local
server.

Eric

_______________________________________________
ActivePerl mailing list
ActivePerl [at] listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs