> -----Original Message----- > From: Jeff Saxton [mailto:jeff_sax...@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-boun...@listserv.activestate.com [activeperl- > boun...@listserv.activestate.com] On Behalf Of Eric Robertson > [eric...@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:dbec...@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
