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

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">


charset=3Dus-ascii">

RE: Problem Connecting to MySQL Database

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@blueyonder.co.uk]
Sent: September 27, 2010 2:33 PM
To: 'Tim Bolshaw'
Cc: activeperl@listserv.ActiveState.com
Subject: RE: Problem Connecting to MySQL Database

On Mon, Sep 27, 2010 at 3:06 AM, 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.

Eric Robertson

_____

From: Tim Bolshaw [mailto:timothybolshaw@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@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@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

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">


charset=3Dus-ascii">

namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"place"/>
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>

type=3D"cite">
charset=3DISO-8859-1">
medium)">
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City">
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place">

size=3D"3" face=3D"Times New Roman"> style=3D"font-size: 12pt;">On Mon, Sep 27, 2010 at
3:06 AM, Eric Robertson < moz-do-not-send=3D"true"
href=3D"mailto:ericrob@blueyonder.co.uk">ericrob@=
blueyonder.co.uk>
wrote:

<=
font
size=3D"2" face=3D"Arial"> e:
10pt; font-family: Arial;" lang=3D"EN-GB">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! 
color=3D"navy">=

<=
font
size=3D"2" face=3D"Arial"> e:
10pt; font-family: Arial;" lang=3D"EN-GB">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:

<=
font
size=3D"2" face=3D"Arial"> e:
10pt; font-family: Arial;" lang=3D"EN-GB">$dsn =
=3D
"DBI:mysqlPP:host=3Dlocalhost:database=3D$database";

RE: Problem Connecting to MySQL Database

> -----Original Message-----
> From: Jeff Saxton [mailto:jeff_saxton@bigfix.com]
> Sent: 28 September 2010 00:46
> To: Eric Robertson; 'Bill Luebkert'
> Cc: activeperl@listserv.ActiveState.com
> Subject: RE: Problem Connecting to MySQL Database
>
> Mac is basically unix, use `netstat -an`
>
> ________________________________________
> From: activeperl-bounces@listserv.ActiveState.com [activeperl-
> bounces@listserv.ActiveState.com] On Behalf Of Eric Robertson
> [ericrob@blueyonder.co.uk]
> Sent: Monday, September 27, 2010 3:44 PM
> To: 'Bill Luebkert'
> Cc: activeperl@listserv.ActiveState.com
> Subject: RE: Problem Connecting to MySQL Database
>
> > -----Original Message-----
> > From: Bill Luebkert [mailto:dbecoll@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@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

RE: Problem Connecting to MySQL Database

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
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@unix.gr]
>Sent: 28 September 2010 06:48
>To: Eric Robertson
>Cc: activeperl@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

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">


charset=3Dus-ascii">

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

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.
>
> -----Original Message-----
> From: Czarnowas, Andrew [mailto:Andrew.Czarnowas@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@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs