Cakephp postgres - default database unrecognized when baking

Question

I have problem to baking in command line with console, only on Postgres Database.

I use :

Windows
Cakephp 2.3
PostgreSQL 8.4.8) My database is on an external server (unix), and the others components on my local computer.

For my App, the CakePhp check seems to be good :

Your version of PHP is 5.2.8 or higher.
Your tmp directory is writable.
The FileEngine is being used for core caching. To change the config edit APP/Config/core.php
Your database configuration file is present.
Cake is able to connect to the database.

When I code MVC manually, it's ok, the application retrieves data.

When I use the command line with consol, I have this message :

    D:\wamp\www\mobilite\app>cake bake
    Welcome to CakePHP v2.3.5 Console
    ---------------------------------------------------------------
    App : app
    Path: D:\wamp\www\mobilite\app\
    ---------------------------------------------------------------
    Interactive Bake Shell
    ---------------------------------------------------------------
    [D]atabase Configuration
    [M]odel
    [V]iew
    [C]ontroller
    [P]roject
    [F]ixture
    [T]est case
    [Q]uit
    What would you like to Bake? (D/M/V/C/P/F/T/Q)
    > M
    ---------------------------------------------------------------
    Bake Model
    Path: D:\wamp\www\mobilite\app\Model\
    ---------------------------------------------------------------
    Use Database Config: (default/components)
    [default] >
    Error: Database connection "Postgres" is missing, or could not be created.

thanks for your help,

Simon.

Please, provide your database.php or just try to use 127.0.0.1 instead of localhost or vice versa: localhost instead of 127.0.0.1 — Vadim
Thanks for your reply Vadim. I forgot to mention that my database is on an external server (unix), and the others components on my local computer. — Simon
@Vadim, your request add something to this post becauseI once had the same problem, but with MySql Database. I finally left side, and all the components manually generated. but I still have the problem. — Simon
maybe you have several dtabase servers on your server, for example: if you have linux, then it can be default mysql + some mysql from some package like XAMPP or something like this. in another words, please, describe your environment, which errors are you see — Vadim

squirreleo squirreleo · Accepted Answer · 2014-03-18T00:30:08

Simon, I had this exact issue. Ultimately, I came to realize that my web server was looking at the php.ini file in my MAMP installation which DID have the postgres PDO drivers installed, but my terminal was using my native php installation, which did not. This is why the CakePHP check page said the connection was okay, but the Bake Shell wouldn't work. The second answer to this question was my salvation after several hours of terrible frustration. All of this happened after an upgrade to my OS, by the way. Good luck!

Cakephp postgres - default database unrecognized when baking

3 Answers