Re: How to connect to a postgres database with CakePHP?

My postgres configuration goes below. I'm not specifying an encoding in the connection object. Thanks.

# Database administrative login by Unix domain socket
local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

On 6 January 2014 21:30, Stephen S <hellospeakman@gmail.com> wrote:

Hey Luis

Without posting any sensitive information, could you share your database config so we can see if the issue is there?

For example, are you using the correct datasource. If so have you written the connection details correctly, or it could even be something like the encoding parameter is written incorrectly. Check out this stack overflow answer to somebody with a similar mysql issue:

http://stackoverflow.com/a/19283913

Kind Regards

 Stephen

On 6 January 2014 10:53, Luís de Sousa <luis.a.de.sousa@gmail.com> wrote:

Hello again,

I've managed to install the Postgres module:

$ php -m | grep pg
pdo_pgsql
pgsql

But I am still getting the same error message:

CakePHP is NOT able to connect to the database.

Database connection "Postgres" is missing, or could not be created.
Selected driver is not enabled

Any other hints are welcome. Thanks.

On Sunday, 17 November 2013 11:45:32 UTC+1, John Andersen wrote:

Hi Luis

Please check that the PostGres module has been loaded/activated in your web server.
Or run phpinfo(); and check that you can see Postgres module has been loaded and is available.
Kindly inform us of the result.

Kind regards
John

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

--
Kind Regards

 Stephen Speakman

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to a topic in the Google Groups "CakePHP" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cake-php/f5aZP6M0SaA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.