Re: [pmapper-users] Nothing happens while trying to connect to MYSQL database

[Armin B. <arm...@gm...>]

just google for it and you will get lots of hits. Newer versions of 
Mysql need different client authentication.

I would try to use
$db_type = "mysqli" instead of the older "MYSQL" interface and see if it 
solves the problem.

from PEAR DB docs 
(http://pear.php.net/manual/en/package.database.db.intro-dsn.php)
mysqli -> MySQL (for MySQL >= 4.1) (requires PHP 5) (since DB 1.6.3)

Or use any of the suggested solutions from google, like this one
   http://dev.mysql.com/doc/refman/5.0/en/old-client.html

armin

Chris Beaart wrote:
> Wow, that's a quick answer.
> I tried your hints. Running the exact created SQL-string in the DB-console
> works perfectly.
> When I enter the more verbose logging code I get the following message:
> [nativecode=Client does not support authentication protocol requested by
> server; consider upgrading MySQL client] **
> mysql://root:password@localhost/dop
> 
> Do you have any further suggestions?
> Thanks,
> Chris.
> 
> 
> -----Oorspronkelijk bericht-----
> Van: pma...@li...
> [mailto:pma...@li...] Namens Armin Burger
> Verzonden: zondag 3 december 2006 16:37
> Aan: Chris Beaart
> CC: pma...@li...
> Onderwerp: Re: [pmapper-users] Nothing happens while trying to connect to
> MYSQL database
> 
> use some more verbose logging after connection and query, like
> 
> if (DB::isError($dbh)) {
>     error_log($dbh->getDebugInfo());
> }
> 
> 
> if (DB::isError($result)) {
>     error_log($result->getDebugInfo());
> }
> 
> 
> And try what happens when you want to run the created SQL string from a 
> DB console.
> 
> Armin
>