problem in connecting to Mysql

[pavanraj21 (Pavan Mailme)]

I am using gii and trying to generate Model class through Model Generator, unexpectedly i am not able to connect to MySql.

My connection string goes like this

‘db’=>array(

		'connectionString' => 'mysql:host=localhost;dbname=artist_paintings',


		'emulatePrepare' => true,


		'username' => 'root',


		'password' => '',


		'charset' => 'utf8',


	),

and i have 2 tables for the database.

When i type the table name in in Model Generator text field and then click on Preview, it showing the below message.

This webpage is not available.

The webpage at /artist/index.php?r=gii/model might be temporarily down or it may have moved permanently to a new web address.

I am also running different php applications on the same server which they are speaking to MySql.

I am not able to guess what the exact error is,Could some one guide on this.

Thanks in advance,

Pavan

[ahmed (Ahmed Henteti)]

look like all OK, think at the DB maybe server down

[outrage (Site Sense Web)]

This doesn’t look like a database connection problem.

Does your directory structure look like this?

<WEBROOT>

    --artist

        --protected

With DB error you would get something like this before you even see the gii interface:

DB Server down:

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘localhost’ (10061)

Wrong Access Details:

CDbConnection failed to open the DB connection: SQLSTATE[28000] [1045] Access denied for user ‘user’@‘localhost’ (using password: YES)

[Ikbel (Ikbel Mejri)]

check your gii configuration:

return array(

......


'modules'=>array(


    'gii'=>array(


        'class'=>'system.gii.GiiModule',


        'password'=>'pick up a password here',


        // 'ipFilters'=>array(...a list of IPs...),


        // 'newFileMode'=>0666,


        // 'newDirMode'=>0777,


    ),


),

);

[outrage (Site Sense Web)]

check your gii configuration:

return array(

......


'modules'=>array(


    'gii'=>array(


        'class'=>'system.gii.GiiModule',


        'password'=>'pick up a password here',


        // 'ipFilters'=>array(...a list of IPs...),


        // 'newFileMode'=>0666,


        // 'newDirMode'=>0777,


    ),


),

);

I thought the config may be wrong but I doubt the gii interface would show unless it was set.

I’m thinking a path/route problem.

[pavanraj21 (Pavan Mailme)]

My config file goes like below i am using Yii 1.1.6

return array(

'basePath'=>dirname(__FILE__).DIRECTORY_SEPARATOR.'..',


'name'=>'My Web Application',





// preloading 'log' component


'preload'=>array('log'),





// autoloading model and component classes


'import'=>array(


	'application.models.*',


	'application.components.*',


),





'modules'=>array(


	// uncomment the following to enable the Gii tool


	


	'gii'=>array(


		'class'=>'system.gii.GiiModule',


		'password'=>'pavan1',


	 	// If removed, Gii defaults to localhost only. Edit carefully to taste.


		//'ipFilters'=>array('127.0.0.1','::1'),


	),


	


),





// application components


'components'=>array(


	'user'=>array(


		// enable cookie-based authentication


		'allowAutoLogin'=>true,


	),


	// uncomment the following to enable URLs in path-format


	/*


	'urlManager'=>array(


		'urlFormat'=>'path',


		'rules'=>array(


			'<controller:\w+>/<id:\d+>'=>'<controller>/view',


			'<controller:\w+>/<action:\w+>/<id:\d+>'=>'<controller>/<action>',


			'<controller:\w+>/<action:\w+>'=>'<controller>/<action>',


		),


	),


	*/


	/*


	'db'=>array(


		'connectionString' => 'mysql:'.dirname(__FILE__).'/../data/testdrive.db',


	),


	*/


	// uncomment the following to use a MySQL database


	


	'db'=>array(


		'connectionString' => 'mysql:host=localhost;dbname=artist_paintings',


		'emulatePrepare' => true,


		'username' => 'root',


		'password' => '',


		'charset' => 'utf8',


	),


	


	'errorHandler'=>array(


		// use 'site/error' action to display errors


        'errorAction'=>'site/error',


    ),


	'log'=>array(


		'class'=>'CLogRouter',


		'routes'=>array(


			array(


				'class'=>'CFileLogRoute',


				'levels'=>'error, warning',


			),


			// uncomment the following to show log messages on web pages


			/*


			array(


				'class'=>'CWebLogRoute',


			),


			*/


		),


	),


),





// application-level parameters that can be accessed


// using Yii::app()->params['paramName']


'params'=>array(


	// this is used in contact page


	'adminEmail'=>'webmaster@example.com',


),

My directory structure is like this D:\xampp\htdocs\artist_new\protected\config

Could some one help me out on this.

[zaccaria (Matteo Falsitta)]

For xamp you have to specify the socket.

‘db’=>array(

‘connectionString’=>‘mysql:host=localhost;dbname=yiidb;unix_socket=/home/michael/lamp/mysql/tmp/mysql.sock’,

‘username’=>‘root’,

‘password’=>‘pw’,

‘charset’=>‘utf8’

)

Find where is your mysql.sock and change the config main accordingly.

[outrage (Site Sense Web)]

My directory structure is like this D:\xampp\htdocs\artist_new\protected\config

Could some one help me out on this.

The clue is in the directory strucure and the url being called.

Remember this error:

The webpage at /artist/index.php?r=gii/model might be temporarily down or it may have moved permanently to a new web address.

The url is really

http://localhost/artist_new/index.php?r=gii/model

and not

http://localhost/artist/index.php?r=gii/model

Note the ‘artist’ part.

Somehow the generated link is incorrect.

[pavanraj21 (Pavan Mailme)]

In Xampp i didn’t find any file like mysql.sock.

I have two application

1.artist

2.artist_new

i am getting the same issue in both applications

[zaccaria (Matteo Falsitta)]

I use Mamp on mac at home, and for work properly I have to configurate this unix-socket.

Make some search in the blog, maybe you will find something, if you cannot solve this evening at home I will post my configuration, how I can’t.

[besnik (Besnik78)]

I use Mamp on mac at home, and for work properly I have to configurate this unix-socket.

[font=“arial, verdana, tahoma, sans-serif”][size=“2”]When using xampp on Windows (as it seems to be the case here), you don’t need to specify a socket in the db connection.

I don’t think there is any kind of problem with routes since you don’t use them. In the case of a route error, you should see something like [color="#555555"][font=“Arial, Helvetica, sans-serif”][size=“2”]Unable to resolve the request “gii/model”.[/size][/font][/color])[/size][/font]

[zaccaria (Matteo Falsitta)]

In my config file for Mac I have:

	'connectionString'=>'mysql:host=localhost;dbname=mambo;unix_socket=/Applications/MAMP/tmp/mysql/mysql.sock;',

The problem here is that xamp/mamp/wamp uses a mysql server that is not the default of the sysrem, so you can have some problem.

Check if you have got the socket in

D:\xampp\tmp\mysql\mysql.sock

[pavanraj21 (Pavan Mailme)]

I am using xampp 1.7.0, i uninstalled and installed xampp 1.7.4, now i am able to generate model classes.

I am not sure what’s went wrong when i am using 1.7.0.

Thanks for every one who tried to help me on this.

[zaccaria (Matteo Falsitta)]

You are welcome!

Good that you solved it.