Consultez la FAQ sur le ZF avant de poster une question
Vous n'êtes pas identifié.
Bonjour à tous,
Ayant développer sous Zend 1.5 j'essaye de me remettre à niveaux sur la 1.10. J'ai peu à peu compris la logique actuel du framework. Après avoir compris le fonctionnement de Zend_Application, Zend_Autoload ...
Cependant je n'arrive pas à établir de connexion avec ma basse de donnée MySQL alors que je peut m'y connecter via les fonctions traditionnel de php.
Voici les paramètres que j'envoie à l'adaptater
$db2 = new Zend_Db_Adapter_Pdo_Mysql(array( 'host' => 'localhost', 'username' => 'root', 'password' => 'root', 'dbname' => 'zf-zaProject' )); $sql = "SELECT * FROM Autors"; res = $db2->fetchAll($sql);
erreur retournée
exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' in /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:host=loca...', 'root', 'root', Array) #1 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Abstract.php(448): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT * FROM A...', Array) #4 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Abstract.php(706): Zend_Db_Adapter_Pdo_Abstract->query('SELECT * FROM A...', Array) #5 /usr/local/zend/apache2/htdocs/zf-zaProject/application/controllers/IndexController.php(37): Zend_Db_Adapter_Abstract->fetchAll('SELECT * FROM A...') #6 /usr/local/zend/share/ZendFramework/library/Zend/Controller/Action.php(513): IndexController->indexAction() #7 /usr/local/zend/share/ZendFramework/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('indexAction') #8 /usr/local/zend/share/ZendFramework/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #9 /usr/local/zend/share/ZendFramework/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch() #10 /usr/local/zend/share/ZendFramework/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #11 /usr/local/zend/apache2/htdocs/zf-zaProject/public/index.php(26): Zend_Application->run() #12 {main} Next exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' in /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Pdo/Abstract.php:144 Stack trace: #0 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Abstract.php(448): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT * FROM A...', Array) #3 /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Abstract.php(706): Zend_Db_Adapter_Pdo_Abstract->query('SELECT * FROM A...', Array) #4 /usr/local/zend/apache2/htdocs/zf-zaProject/application/controllers/IndexController.php(37): Zend_Db_Adapter_Abstract->fetchAll('SELECT * FROM A...') #5 /usr/local/zend/share/ZendFramework/library/Zend/Controller/Action.php(513): IndexController->indexAction() #6 /usr/local/zend/share/ZendFramework/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('indexAction') #7 /usr/local/zend/share/ZendFramework/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #8 /usr/local/zend/share/ZendFramework/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch() #9 /usr/local/zend/share/ZendFramework/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #10 /usr/local/zend/apache2/htdocs/zf-zaProject/public/index.php(26): Zend_Application->run() #11 {main}
Alors qu'une connexion traditionnelle comme celle-ci :
$sql = "SELECT * FROM Autors;"; mysql_connect('localhost', 'root', 'root'); mysql_select_db('zf-zaProject'); $rep = mysql_query($sql); var_dump(mysql_fetch_array($rep));
Configuration utiliser :
Zend Server CE sous mac OSX 10.6.4
Zend Framework 1.10.6
Merci d'avance pour vos lumières
Hors ligne
Hello,
Si c'est comme Ubuntu, mysql ne met pas le mysql.sock dans /tmp mais dans /var/run/mysqld/mysqld.sock donc soit lien symbolique soit recompilation pour affecter la bonne valeur.
@+
Hors ligne
Bon bah je ne sais pas d'où venez le problème avec Zend Server, j'ai dont configuré un Mamp et ça marche
Hors ligne