current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

I encountered troubles when trying to connect to postgresql database within Zend framework application. In my application.ini I use

resources.db.adapter = PDO_PGSQL
resources.db.params.host = localhost
resources.db.params.username = root
resources.db.params.password = testtest
resources.db.params.dbname = testdb

But when I run the application, I got an error message Message: SQLSTATE[08006] [7] could not create socket: Address family not supported by protocol.

Could you please tell me what can be wrong?

Zend version 1.12.3., PostgreSQL version 9.0.7, PHP version 5.3.5.

Thanks, Marek .

share|improve this question

1 Answer 1

up vote 0 down vote accepted

localhost on your machine is (most likely) resolving to the IPv6 address of localhost (::1), but since the protocol/module used does not support IPv6 connections, your connection fails.

You could either;

  • Use 127.0.0.1 as a host instead, that will force a connection to the IPv4 localhost.

  • Remove the host line completely, that will force a connection via UNIX sockets.

share|improve this answer
    
Thank you for the answer, but after changing the host to 127.0.0.1, I got the message: Message: SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? I usually connect to the database via the psql client or pgAdmin, this works. Any outher ideas why it doesn't work. Thanks. –  Marek Hajžman Jul 18 '13 at 8:13
    
@MarekHajžman Then it seems your PostgreSQL is not listening to the network (at least localhost) at all. Try removing the host line completely, it should (unless it works unlike other PDO implementations) default to UNIX sockets instead. –  Joachim Isaksson Jul 18 '13 at 8:19
    
Works!!!! Thanks for help :) –  Marek Hajžman Jul 18 '13 at 8:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.