Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:16143
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
	s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=rRp96kj+7SNKe9d/gWvDum9FxC5F1YgYwkDIcpZbPthCcA9nUs1vAuT4d/jaKBjQGoxcolVtsvy6/taVmEc95cH2Teij8vW+Z5AV5gFTfLgA+5eD46koxW1k0fuEXKH7o77gUcPOq/5FjJjOBvPYamJwdSDp5U42JEDODLyXFus=
Message-ID: <ea9da26c05042908266b815bf9@mail.gmail.com>
Date: Fri, 29 Apr 2005 10:26:17 -0500
Reply-To: Greg Donald <destiney@gmail.com>
To: Dan Scott <denials@gmail.com>
Cc: php-dev <internals@lists.php.net>
In-Reply-To: <fbb0d11d05042816205be7ed54@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <ea9da26c0504260731629db1a0@mail.gmail.com>
	<fbb0d11d05042812147257944d@mail.gmail.com>
	<ea9da26c05042812534f4b5fe@mail.gmail.com>
	<fbb0d11d05042816205be7ed54@mail.gmail.com>
Subject: Re: [PHP-DEV] help with backtrace/debuging
From: destiney@gmail.com (Greg Donald)

On 4/28/05, Dan Scott <denials@gmail.com> wrote:
> So three things:
> 1. If you print the results of get_loaded_extensions(), you'll see
> that pdo turns up as 'PDO', but you're looking for 'pdo' -- so the
> result of your first if() is FALSE.

Yup.  Confusing that the base extension is PDO, but the drivers are
lowercase like pdo_mysql for example.  I see what's going on now.

> 2. You then try loading pdo.so again, but it's already loaded by
> php.ini, therefore you get the Warning and your own error message.

Yup.  :)

> 3. You plan on connecting to MySQL, but don't appear to have loaded
> pdo_mysql.so anywhere. So you need to fix that.

I didn't realize I had to build pdo_mysql.so seperately.  Thanks.  In
the manual where it says "The following drivers currently implement
the PDO interface:" made me thing I got them all when I built PDO.


Now that I got all that worked out MySQL refuses my dsn string:

Connection failed: SQLSTATE[HY000] [2003] Can't connect to MySQL
server on '127.0.0.1' (111)

I can connect using this user and password using the mysql command
line client with no problems.  I have other PHP scripts connecting
successfully with this user as well.  See any problems with this code?

$dsn =3D 'mysql:host=3D127.0.0.1;dbname=3Dtest';
$user =3D 'root';
$password =3D 'changeme';

try
{
   $dbh =3D new PDO( $dsn, $user, $password );
}
catch( PDOException $e )
{
   echo 'Connection failed: ' . $e->getMessage() . "\n";
}


My MySQL user works otherwise:

> mysql -uroot -p
Enter password:=20
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Thanks,


--=20
Greg Donald
Zend Certified Engineer
http://destiney.com/