When I run zend framework project from browser, everything is OK, it connects to DB.
When I run project from command line it can't connect to DB and it throws an error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in /usr/local/zend/share/ZendFramework/library/Zend/Db/Adapter/Pdo/Abstract.php:129
I have used Running a Zend Framework action from command line 's answers ( https://stackoverflow.com/a/4706966/457033 )
It's my application.ini
file's db part
phpSettings.mysql.default_socket=/usr/local/zend/mysql/tmp/mysql.sock
resources.db.adapter = "PDO_MYSQL"
resources.db.params.host = "localhost"
resources.db.params.port = 3306
resources.db.params.username = "root"
resources.db.params.password = "root"
resources.db.params.dbname = "iteam"
resources.db.isDefaultTableAdapter = true
resources.db.params.charset = "utf8"
To access a specific database, type the following command at the mysql> prompt, replacing dbname with the name of the database that you want to access: Copy use dbname; Make sure you do not forget the semicolon at the end of the statement. After you access a database, you can run SQL queries, list tables, and so on.
Connect to a SQL Server instanceStart SQL Server Management Studio. The first time you run SSMS, the Connect to Server window opens. If it doesn't open, you can open it manually by selecting Object Explorer > Connect > Database Engine. For Server type, select Database Engine (usually the default option).
Copy the content of application.ini in your php.ini file, this should work fine.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With