Mail Queue Error: Cannot connect to database

[djalig]

Hi, I am having trouble with Mail_queue

Here are my options:

$container_options = array(
'type' => 'db',
// 'dsn' => 'mysql://username:password@dbname',
'database' => 'localhost/dbname',
'phptype' => 'mysql',
'username' => 'username',
'password' => 'password',
'mail_table' => 'mail_queue'
);

$mail_options = array(
'driver' => 'smtp',
'host' => 'mail.xxxxxxxx.com',
'port' => 587,
'auth' => true,
'username' => 'xxxxxxxx',
'password' => 'xxxxxxxx');


When calling $mail_queue->put( $emailfrom, $to, $headers, $body );
I get the following message:

Mail Queue Error: Cannot connect to database

I am using MAMP on the Mac to run my db. Server is localhost port 8889 for mysql. I have tried both the dsn and db options, with localhost/dbname, localhost:8889/dbname and just dbname but none of the combinations work. The username and password are 100% correct!

Any help would be VERY grateful!

Thanks

[mark]

Mail_Queue doesn't seem to report back the full error message of the DB package.

To test your connection to the database, you can use the following lines of code:

[djalig]

Thank you so much.

I needed to use localhost/dbname in the dns string

Everything is now working!