Symfony 2 Doctrine configuration for MySql database


This post provides a quick and dirty way to setup your doctrine configuration using Symfony v.20. 
I assume that you're using MySql database.

Step 1

First you need to enable your "pdo_mysql" driver in php.ini file. Just uncomment the following configuration in your php.ini. Restart your IIS and you're pretty much done.

extension=php_pdo_mysql.dll

Step 2


You need to have the following configuration in your symfony\app\config\parameters.ini file. 

    [parameters]
    database_driver="pdo_mysql"
    database_host="127.0.0.1"
    database_port="3306"
    database_name="testproject"
    database_user="root"
    database_password="root"
    mailer_transport="smtp"
    mailer_host="localhost"
    mailer_user=""
    mailer_password=""
    locale="en"
    secret="ThisTokenIsNotSoSecretChangeIt"


You might have noticed that the database_host "127.0.0.1". If you tried using "localhost" it won't work.


That's it and your website is Doctine enabled! :)

Comments

Post a Comment

Popular posts from this blog

The specified initialization vector (IV) does not match the block size for this algorithm

Image
If you're getting  exception when trying to assigned key to a symmetric key and getting error message below :- The specified initialization vector (IV) does not match the block size for this algorithm And your code probably look like something below :- Then you need to go into debug mode and start looking into the supported size for IV as shown in diagram below :- As you can see, IV is 16 bytes, so you need to provide 16 bytes. The same goes for Key field too, if you're adding anything to it. As long as you provide a valid key size, then we're good and you're code will be ready.
Read more