Starting with Zend Tutorial – Zend_DB_Adapter throws Exception: “SQLSTATE[HY000] [2002] No such file or directory”

by

I would say that you have a problem connecting from PHP to MySQL…

Something like PHP trying to find some socket file, and not finding it, maybe ?

(I’ve had this problem a couple of times — not sure the error I got was exactly this one, though)

If you are running some Linux-based system, there should be a my.cnf file somewhere, that is used to configure MySQL — on my Ubuntu, it’s in /etc/mysql/.

In this file, there might be something like this :

socket = /var/run/mysqld/mysqld.sock

PHP need to use the same file — and, depending on your distribution, the default file might not be the same as the one that MySQL uses.

In this case, adding these lines to your php.ini file might help :

mysql.default_socket = /var/run/mysqld/mysqld.sock
mysqli.default_socket = /var/run/mysqld/mysqld.sock
pdo_mysql.default_socket = /var/run/mysqld/mysqld.sock

(You’ll need to restart Apache so the modification to php.ini is taken into account)

The last one should be enough for PDO, which is used by Zend Framework — but the two previous ones will not do any harm, and can be useful for other applications.

If this doesn’t help : can you connect to your database using PDO, in another script, that’s totally independant of Zend Framework ?

i.e. does something like this work (quoting) :

$dsn = 'mysql:dbname=testdb;host=127.0.0.1';
$user="dbuser";
$password = 'dbpass';

try {
    $dbh = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

If no, the problem is definitly not with ZF, and is a configuration / installation problem of PHP.

If yes… Well, it means you have a problem with ZF, and you’ll need to give us more informations about your setup (like your DSN, for instance ? )

More Related Contents:

  1. Sending variables to the layout in Zend Framework
  2. PHPExcel class not found in Zend Autoloader
  3. zend framework deployment in server
  4. How do I use ViewScripts on Zend_Form File Elements?
  5. Zend File Upload and Element Decorators
  6. Using ViewScript Decorator on Nested Subforms (Zend Form)
  7. Running MySQL *.sql files in PHP
  8. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  9. How to get client’s timezone? [duplicate]
  10. how to create virtual host on XAMPP [duplicate]
  11. Call to a member function on a non-object
  12. How to make PDO run SET NAMES utf8 each time I connect, In ZendFramework
  13. Can’t return a result set in the given context
  14. Add some html to Zend Forms
  15. Threads in PHP?
  16. How do detect that transaction has already been started?
  17. Running a Zend Framework action from command line
  18. Practical Zend_ACL + Zend_Auth implementation and best practices
  19. Selecting all fields except only one field in mysql [duplicate]
  20. How do I extend the Zend Navigation Menu View Helper?
  21. What is the difference between redirect and forward in Zend framework
  22. session_start() takes VERY LONG TIME
  23. php, mysql – Too many connections to database error
  24. How to add a view helper directory (zend framework)
  25. avoiding MySQL injections with the Zend_Db class
  26. DOMPDF doesn’t work with external css file
  27. Getting Zend_Navigation menu to work with jQuery’s Fisheye
  28. ZF2 – Get controller name into layout/views

Leave a Comment