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
– greg0ire, Commented Oct 1, 2010 at 19:50
yes. it's an empty file in /Applications/XAMPP/xamppfiles/var/mysql/ — skanne
– skanne, Commented Oct 1, 2010 at 19:59

j0k · Accepted Answer · 2012-11-11 08:29:41Z

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, 2012 at 8:29

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Oct 1, 2010 at 20:12

0xPixelfrost

10.5k5 gold badges41 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

anggriawan Over a year ago

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

Lithium · Accepted Answer · 2011-09-04 23:47:56Z

13

Or with MAMP

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

answered Sep 4, 2011 at 23:47

Lithium

1,13211 silver badges10 bronze badges

Comments

Aymeric · Accepted Answer · 2012-01-15 23:06:32Z

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, 2012 at 23:06

Aymeric

1011 silver badge8 bronze badges

Comments

j0k · Accepted Answer · 2012-11-11 08:29:55Z

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, 2012 at 8:29

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Mar 31, 2011 at 10:14

Conrad

8031 gold badge10 silver badges15 bronze badges

Comments

yunhasnawa · Accepted Answer · 2013-11-10 15:17:13Z

1

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.

answered Nov 10, 2013 at 15:17

yunhasnawa

9651 gold badge15 silver badges30 bronze badges

Collectives™ on Stack Overflow

No database connection via doctrine in symfony

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related