Problem with mySQL DSN line.

[Anonymous]

Hi,

I'm trying to install PhpWiki 1.3.3 using mySQL with a "mySQL Unix Socket".

This is the error that I'm getting...
lib/WikiDB/backend/PearDB.php:31: Fatal[256]: Can't connect to database: wikidb_backend_mysql: fatal database error

DB Error: connect failed
( [nativecode=Access denied for user: 'wikiuser@localhost' (Using password: YES)] ** mysql://wikiuser:XXXXXXXX@:/tmp/mysql.eserve/wikidb)

Here is doco from the web hosting company...

Mysql settings
--------------
dbname: wikidb
dbuser: wikiuser
dbpswd: wiki009
MySQL Port Number 3306
MySQL Unix Socket localhost:/tmp/mysql.eserve
To access the database using PHP use the following command :-
mysql_connect( 'localhost:/tmp/mysql.eserve', wikiuser, wiki009);

As far as I can tell it is only the DSN line in index.php that is causing the problems. Independant PHP test code that Selects/Inserts/Deletes info in the database works fine.

This is current DSN line:
   'dsn' => 'mysql://wikiuser:wiki009@:/tmp/mysql.eserve/wikidb',

Have also tried
   'dsn' => 'mysql://wikiuser:wiki009@localhost:/tmp/mysql.eserve/wikidb',

I have also noticed that in the comment lines above this...
   // FIXME: My version Pear::DB seems to be broken enough that there
   //        is no way to connect to a mysql server over a socket right now.
Does this mean that connecting over a socket will not work??

Any help would be greatly appreciated.

Thank you,

Seong

[Jonathan Smith]

The password and user in your 'dsn' must be recognizable by MySQL.