CDbException :: Windows 7 64x + WAMP + PHPUnit

DiegoToala · September 12, 2010, 9:35pm

Hi , I’m new with Yii and need some help.

I’m testing my app but I get this Exception:

CDbException: CDbConnection failed to open the DB Connection.

This is part of my configuration file in config/main.php

‘db’=>array(

		'class'=&gt;'CDbConnection',


		'connectionString' =&gt; 'mysql:host=localhost;dbname=yiidb',


		'emulatePrepare' =&gt; true,


		'username' =&gt; 'yiiuser',


		'password' =&gt; 'yiipass',


		'charset' =&gt; 'utf8',


	),

This is my unit test file:

class DbTest extends CTestCase

{

public function testConnection()


{


	&#036;this-&gt;assertNotEquals(NULL,Yii::app()-&gt;db);


}

}

I have all the requeriments installed.

I have a Windows 7 64x + WAMP 1.7.4 (PHP 5.2.5 , Apache 2.2.6 , MySql 5.0.45) , Yii 1.1.4.

Thanks for your help.

Regards,

Diego.

tri · September 12, 2010, 10:54pm

How To Use Mailto To Send Email To All Selected Rows In A Tbgridview?

…

This is part of my configuration file in config/main.php

‘db’=>array(

		'class'=&gt;'CDbConnection',


		'connectionString' =&gt; 'mysql:host=localhost;dbname=yiidb',


		'emulatePrepare' =&gt; true,


		'username' =&gt; 'yiiuser',


		'password' =&gt; 'yiipass',


		'charset' =&gt; 'utf8',


	),

…

What about config/test.php? Check which config you specify in bootstrap.php.

/Tommy

binkabir · September 13, 2010, 7:01am

hello,

be sure u have installed phpunit version 3.4 or higher and xdebug on ur system.

also make sure ur connection to the mysql db parameters are correct,

hint(try to use the administrator account to connect first, maybe the yiiuser account have too many restrictions )