No database connection via doctrine in symfony

Question

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?

Does the /var/mysql/mysql.sock file exist? Try finding that file using locate if not. — greg0ire, Oct 01 '10 at 19:50
yes. it's an empty file in /Applications/XAMPP/xamppfiles/var/mysql/ — skanne, Oct 01 '10 at 19:59

score 14 · Accepted Answer · edited Nov 11 '12 at 08:29

14

Try to create a symlink in /var/mysql to your mysql.sock:

sudo ln -s /Applications/XAMPP/xamppfiles/var/mysql /var/mysql

edited Nov 11 '12 at 08:29

j0k

22,600
28
79
90

answered Oct 01 '10 at 20:12

0xPixelfrost

10,244
5
39
58

sudo ln -s /Applications/XAMPP/xamppfiles/var/mysql /var/mysql – anggriawan Feb 18 '12 at 16:15

score 13 · Answer 2 · answered Sep 04 '11 at 23:47

13

Or with MAMP

cd /var; sudo ln -s /Applications/MAMP/tmp/mysql mysql

answered Sep 04 '11 at 23:47

Lithium

1,132
11
10

score 3 · Answer 3 · edited Nov 11 '12 at 08:29

3

I had the same problem on my apple mac and did the following:

cd /var; sudo ln -s /Applications/XAMPP/xamppfiles/var/mysql/ mysql

Worked for me.

edited Nov 11 '12 at 08:29

j0k

22,600
28
79
90

answered Mar 31 '11 at 10:14

Conrad

803
1
10
14

score 3 · Answer 4 · answered Jan 15 '12 at 23:06

3

On Mac OSX Lion:

cd /var;
sudo mkdir mysql; cd mysql;
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock mysql.sock

answered Jan 15 '12 at 23:06

Aymeric

101
1
8

score 1 · Answer 5 · answered Nov 10 '13 at 15:17

This situation also happened to me and I use MAMP Pro. If you use MAMP Pro, its worth checking the main window. Look at "MySQL" tab, and then see "Allow local access only" checkbox. If it is checked, you should uncheck it. Finally, click, "Apply" button.

No database connection via doctrine in symfony

5 Answers5