No database connection via doctrine in symfony

Question

Hi,

I'm working on the symfony tutorial jobeet and I have problems to get a database connection to the MySQL-database via doctrine. Development enviroment: Mac OS X and XAMPP.

The command 'php symfony doctrine:build-schema' gives me the following error message:

Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in /Users/xx/projects/myproject/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php on line 470

PDO Connection Error: SQLSTATE[HY000] [2002] No such file or directory

The database settings in the database.yml:

 all:
  doctrine:
    class: sfDoctrineDatabase
    param:
      dsn: 'mysql:host=localhost;dbname=my_project_db'
      username: root
      password: root

MySQl is running. Username and password are correct. The database 'my_project_db' exists.

Could anybody give me a hint what's going wrong!?

Answer 1

Hi, please try to create a symlink in /var/mysql to your mysql.sock like

sudo ln -s ...XAMPP/xamppfiles/var/mysql/mysql.sock