[GENERAL] Unable to connect to PostgreSQL server : Could not get socket error status
Hi, Unable to connect to PostgreSQL server : Could not get socket error status: No such file or directory in index.php on line 5 Can any one help me on this ? I am getting the following error when I try to connect from PHP with PostgreSQL server. Operating System is HP-UX and I was able to connect through PostgreSQL server from psql, -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Unable to connect to PostgreSQL server : Could not get socket error status
On 12/22/11 1:31 AM, Shankar Palaniappan wrote: I am getting the following error when I try to connect from PHP with PostgreSQL server. Operating System is HP-UX and I was able to connect through PostgreSQL server from psql, what postgres connection parameters are you passing to the php connection function? if you specified host=localhost, or some such, then on psql use -h localhost to simulate this. -- john r pierceN 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
It was SELinux denying apache permission to make TCP connections!
I thought I had SELinux turned off but it wasn't. To be sure it is do
/usr/sbin/sestatus | grep SELinux
and if it comes back with anything other than SELinux status: disabled it's
still running.
While I was talking to the php board I discovered you can configure php to
run from the command line (mine was by default). So I wrote this bit of php
(obviously change the database name and you may need a user and passwd)...
?php
$dbconn=pg_connect(dbname=lumbribase);
if ( ! $dbconn ) {
echo Error connecting to the database !br ;
printf(%s, pg_errormessage( $dbconn ) );
exit(); }
else {echo connected, \n;}
?
saved it as test.php and at a shell prompt ran...
[john@ tmp]$ php test.php
connected
If you get 'connected' you know php and postgres are talking via tcp and
some secondary process (firewall/SELinux) is preventing the apache
connection.
Thanks for the help.
From: John Coulthard [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
Date: Mon, 13 Aug 2007 15:34:19 +
From: Tom Lane [EMAIL PROTECTED]
To: John Coulthard [EMAIL PROTECTED]
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
Date: Mon, 13 Aug 2007 10:09:15 -0400
John Coulthard [EMAIL PROTECTED] writes:
That's not my problem though this is could not connect to server:
Permission denied If it's denying permission I must have the
permissions
set wrong but where to I start looking for them?
Permission denied is a pretty strange error for a TCP connect failure,
as that is not a filesystem operation.
Are you able to connect with psql, or some other non-php client?
Use psql -h localhost to make sure it tries a TCP connection not
a Unix-socket connection.
Thanks. You mean like this? This connects without an error.
[EMAIL PROTECTED] john]# su webuser
[EMAIL PROTECTED] john]$ psql -h localhost lumbribase
Welcome to psql 8.0.8, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
lumbribase=
_
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
_
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
The part of the php code for the connection is
$dbconn=pg_connect( dbname=lumbribase host=localhost port=5432
user=postgres password=$PG_PASS );
if ( ! $dbconn ) {
echo Error connecting to the database !br ;
printf(%s, pg_errormessage( $dbconn ) );
exit(); }
This code works on zeldia
http://zeldia.cap.ed.ac.uk/Lumbribase/search_id.php
but not on xyala http://xyala.cap.ed.ac.uk/Lumbribase/search_id.php
So it's something to do with the way xyala is set up. I'm sure I'm missing
something obvious but what..?
It's not a firewall issue because it persists when the iptabes are off.
What does could not connect to server: Permission denied mean? Have I
done some something as root or me that I should have done as user postgres?
Thanks
From: Julio Cesar Sánchez González [EMAIL PROTECTED]
To: John Coulthard [EMAIL PROTECTED]
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
Date: Fri, 10 Aug 2007 22:50:47 -0500
El jue, 09-08-2007 a las 14:51 +, John Coulthard escribió:
Hi
I'm trying to set up a new webserver running php and pgsql. PHP was
connecting to postgres but I needed to install the php-gd module and now
I
get the error...
PHP Warning: pg_connect() [a
href='function.pg-connect'function.pg-connect/a]: Unable to connect
to
PostgreSQL server: could not connect to server: Permission denied\n\tIs
the
server running on host quot;localhostquot; and accepting\n\tTCP/IP
connections on port 5432?
and I'm at a loss can anyone tell me why it's not connecting?
Thanks
This bit's I know are...
http://xyala.cap.ed.ac.uk/php_info.php say's php's configured for pgsql
[EMAIL PROTECTED] telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
Connection closed by foreign host.
[EMAIL PROTECTED]
[EMAIL PROTECTED] less /var/lib/pgsql/data/pg_hba.conf
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
# local is for Unix domain socket connections only
#local all all ident sameuser
local all all trust
# IPv4 local connections:
#hostall all 127.0.0.1/32 ident sameuser
hostall all 127.0.0.1/32 trust
# IPv6 local connections:
#hostall all ::1/128 ident sameuser
hostall all ::1/128 trust
[EMAIL PROTECTED] grep 'listen' /var/lib/pgsql/data/postgresql.conf
# pg_ctl reload. Some settings, such as listen_address, require
#listen_addresses = 'localhost' # what IP interface(s) to listen on;
listen_addresses = '*'
[EMAIL PROTECTED]
[EMAIL PROTECTED] less /etc/php.d/pgsql.ini
; Enable pgsql extension module
extension=pgsql.so
the server I'm going to replace is running the same versions of PHP and
postgres http://zeldia.cap.ed.ac.uk/php_info.php
The /etc/php.ini files on the two machines are the same and the
/var/lib/pgsql/data/postgresql.conf files are only different because
I've
set listen_addresses = '*' on the new server (xyala) to see if I can
make it
work.
_
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
show your php source code for help you.
--
Regards,
Julio Cesar Sánchez González
www.sistemasyconectividad.com.mx
blog: http://darkavngr.blogspot.com
---
Ahora me he convertido en la muerte, destructora de mundos.
Soy la Muerte que se lleva todo, la fuente de las cosas que vendran.
_
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
On 8/13/07, John Coulthard [EMAIL PROTECTED] wrote:
The part of the php code for the connection is
$dbconn=pg_connect( dbname=lumbribase host=localhost port=5432
user=postgres password=$PG_PASS );
if ( ! $dbconn ) {
echo Error connecting to the database !br ;
printf(%s, pg_errormessage( $dbconn ) );
exit(); }
This code works on zeldia
http://zeldia.cap.ed.ac.uk/Lumbribase/search_id.php
but not on xyala http://xyala.cap.ed.ac.uk/Lumbribase/search_id.php
So it's something to do with the way xyala is set up. I'm sure I'm missing
something obvious but what..?
It's not a firewall issue because it persists when the iptabes are off.
What does could not connect to server: Permission denied mean? Have I
done some something as root or me that I should have done as
user postgres?
Hi John,
Had the same issue. Try the following steps:
1. PGHBA.CONF
This is an important file. Mine (on Linux CentOS 4) is located at
/var/lib/pgsql/data/pghba.conf. Make sure it looks like the
following.
local all all md5
hostall all 127.0.0.1 255.255.255.255 md5
2. POSTGRESQL.CONF
listen_addresses = 'localhost,*'
#port = 5432
other settings
3. PHP CODE
link = pg_connect(host=localhost dbname=MYDB user=MYUSER password=MYPASS);
--
That is all you need. Don't specify anything else in the connection
string. Let me know how it goes.
LB
---(end of broadcast)---
TIP 6: explain analyze is your friend
Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
From: Lim Berger [EMAIL PROTECTED]
To: John Coulthard [EMAIL PROTECTED]
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
Date: Mon, 13 Aug 2007 18:51:37 +0800
On 8/13/07, John Coulthard [EMAIL PROTECTED] wrote:
The part of the php code for the connection is
$dbconn=pg_connect( dbname=lumbribase host=localhost port=5432
user=postgres password=$PG_PASS );
if ( ! $dbconn ) {
echo Error connecting to the database !br ;
printf(%s, pg_errormessage( $dbconn ) );
exit(); }
This code works on zeldia
http://zeldia.cap.ed.ac.uk/Lumbribase/search_id.php
but not on xyala http://xyala.cap.ed.ac.uk/Lumbribase/search_id.php
So it's something to do with the way xyala is set up. I'm sure I'm
missing
something obvious but what..?
It's not a firewall issue because it persists when the iptabes are off.
What does could not connect to server: Permission denied mean? Have I
done some something as root or me that I should have done as
user postgres?
Hi John,
Had the same issue. Try the following steps:
1. PGHBA.CONF
This is an important file. Mine (on Linux CentOS 4) is located at
/var/lib/pgsql/data/pghba.conf. Make sure it looks like the
following.
local all all md5
hostall all 127.0.0.1 255.255.255.255 md5
2. POSTGRESQL.CONF
listen_addresses = 'localhost,*'
#port = 5432
other settings
3. PHP CODE
link = pg_connect(host=localhost dbname=MYDB user=MYUSER
password=MYPASS);
--
That is all you need. Don't specify anything else in the connection
string. Let me know how it goes.
LB
---(end of broadcast)---
TIP 6: explain analyze is your friend
Thanks for the sugestions but they don''t solve the problem. I do notice
that if I set listen_addresses='localhost,*' then I get the following when I
start postgres...
bash-3.00$ ps -ef | grep postgres
root 9669 8757 0 13:34 pts/500:00:00 su postgres
postgres 9670 9669 0 13:34 pts/500:00:00 bash
postgres 9673 9670 0 13:34 pts/500:00:00 ps -ef
postgres 9674 9670 0 13:34 pts/500:00:00 grep postgres
bash-3.00$ /usr/bin/pg_ctl -D /var/lib/pgsql/data start
postmaster starting
bash-3.00$ LOG: could not bind IPv4 socket: Address already in use
HINT: Is another postmaster already running on port 5432? If not, wait a
few seconds and retry.
bash-3.00$
it does start though. But if I just have localhost or * as the
listen_addresses it starts without error.
That's not my problem though this is could not connect to server:
Permission denied If it's denying permission I must have the permissions
set wrong but where to I start looking for them? All sub dirs in
/var/lib/pgsql are owned by postgres and seem to have the same permissions
on both systems.
Cheers
_
Find a local pizza place, movie theater, and more
.then map the best route!
http://maps.live.com/default.aspx?v=2ss=yp.bars~yp.pizza~yp.movie%20theatercp=42.358996~-71.056691style=rlvl=13tilt=-90dir=0alt=-1000scene=950607encType=1FORM=MGAC01
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
John Coulthard [EMAIL PROTECTED] writes: That's not my problem though this is could not connect to server: Permission denied If it's denying permission I must have the permissions set wrong but where to I start looking for them? Permission denied is a pretty strange error for a TCP connect failure, as that is not a filesystem operation. Are you able to connect with psql, or some other non-php client? Use psql -h localhost to make sure it tries a TCP connection not a Unix-socket connection. regards, tom lane ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
From: Tom Lane [EMAIL PROTECTED] To: John Coulthard [EMAIL PROTECTED] CC: pgsql-general@postgresql.org Subject: Re: [GENERAL] Unable to connect to PostgreSQL server via PHP Date: Mon, 13 Aug 2007 10:09:15 -0400 John Coulthard [EMAIL PROTECTED] writes: That's not my problem though this is could not connect to server: Permission denied If it's denying permission I must have the permissions set wrong but where to I start looking for them? Permission denied is a pretty strange error for a TCP connect failure, as that is not a filesystem operation. Are you able to connect with psql, or some other non-php client? Use psql -h localhost to make sure it tries a TCP connection not a Unix-socket connection. Thanks. You mean like this? This connects without an error. [EMAIL PROTECTED] john]# su webuser [EMAIL PROTECTED] john]$ psql -h localhost lumbribase Welcome to psql 8.0.8, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit lumbribase= _ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Unable to connect to PostgreSQL server via PHP
El jue, 09-08-2007 a las 14:51 +, John Coulthard escribió: Hi I'm trying to set up a new webserver running php and pgsql. PHP was connecting to postgres but I needed to install the php-gd module and now I get the error... PHP Warning: pg_connect() [a href='function.pg-connect'function.pg-connect/a]: Unable to connect to PostgreSQL server: could not connect to server: Permission denied\n\tIs the server running on host quot;localhostquot; and accepting\n\tTCP/IP connections on port 5432? and I'm at a loss can anyone tell me why it's not connecting? Thanks This bit's I know are... http://xyala.cap.ed.ac.uk/php_info.php say's php's configured for pgsql [EMAIL PROTECTED] telnet localhost 5432 Trying 127.0.0.1... Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. Connection closed by foreign host. [EMAIL PROTECTED] [EMAIL PROTECTED] less /var/lib/pgsql/data/pg_hba.conf # TYPE DATABASEUSERCIDR-ADDRESS METHOD # local is for Unix domain socket connections only #local all all ident sameuser local all all trust # IPv4 local connections: #hostall all 127.0.0.1/32 ident sameuser hostall all 127.0.0.1/32 trust # IPv6 local connections: #hostall all ::1/128 ident sameuser hostall all ::1/128 trust [EMAIL PROTECTED] grep 'listen' /var/lib/pgsql/data/postgresql.conf # pg_ctl reload. Some settings, such as listen_address, require #listen_addresses = 'localhost' # what IP interface(s) to listen on; listen_addresses = '*' [EMAIL PROTECTED] [EMAIL PROTECTED] less /etc/php.d/pgsql.ini ; Enable pgsql extension module extension=pgsql.so the server I'm going to replace is running the same versions of PHP and postgres http://zeldia.cap.ed.ac.uk/php_info.php The /etc/php.ini files on the two machines are the same and the /var/lib/pgsql/data/postgresql.conf files are only different because I've set listen_addresses = '*' on the new server (xyala) to see if I can make it work. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings show your php source code for help you. -- Regards, Julio Cesar Sánchez González www.sistemasyconectividad.com.mx blog: http://darkavngr.blogspot.com --- Ahora me he convertido en la muerte, destructora de mundos. Soy la Muerte que se lleva todo, la fuente de las cosas que vendran. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] Unable to connect to PostgreSQL server via PHP
Hi I'm trying to set up a new webserver running php and pgsql. PHP was connecting to postgres but I needed to install the php-gd module and now I get the error... PHP Warning: pg_connect() [a href='function.pg-connect'function.pg-connect/a]: Unable to connect to PostgreSQL server: could not connect to server: Permission denied\n\tIs the server running on host quot;localhostquot; and accepting\n\tTCP/IP connections on port 5432? and I'm at a loss can anyone tell me why it's not connecting? Thanks This bit's I know are... http://xyala.cap.ed.ac.uk/php_info.php say's php's configured for pgsql [EMAIL PROTECTED] telnet localhost 5432 Trying 127.0.0.1... Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. Connection closed by foreign host. [EMAIL PROTECTED] [EMAIL PROTECTED] less /var/lib/pgsql/data/pg_hba.conf # TYPE DATABASEUSERCIDR-ADDRESS METHOD # local is for Unix domain socket connections only #local all all ident sameuser local all all trust # IPv4 local connections: #hostall all 127.0.0.1/32 ident sameuser hostall all 127.0.0.1/32 trust # IPv6 local connections: #hostall all ::1/128 ident sameuser hostall all ::1/128 trust [EMAIL PROTECTED] grep 'listen' /var/lib/pgsql/data/postgresql.conf # pg_ctl reload. Some settings, such as listen_address, require #listen_addresses = 'localhost' # what IP interface(s) to listen on; listen_addresses = '*' [EMAIL PROTECTED] [EMAIL PROTECTED] less /etc/php.d/pgsql.ini ; Enable pgsql extension module extension=pgsql.so the server I'm going to replace is running the same versions of PHP and postgres http://zeldia.cap.ed.ac.uk/php_info.php The /etc/php.ini files on the two machines are the same and the /var/lib/pgsql/data/postgresql.conf files are only different because I've set listen_addresses = '*' on the new server (xyala) to see if I can make it work. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[GENERAL] Unable to connect to PostgreSQL server
hi, I have a problem with my postgresql database it always gives me an error: Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: sorry, too many clients already in ~/includes/DbConnector.php on line 27 Please advice how I can manage my database to handle enough connections please advice. +-+ | Martin W. Kuria (Mr.) [EMAIL PROTECTED] ++ _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Unable to connect to PostgreSQL server
Martin,please check out the server configuration documentation athttp://www.postgresql.org/docs/8.1/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS your configuration file of choice is postgresql.conf within the data directory.(btw: because the default is rather big, it is very likely that there is some not reusing connections or not closing connection when ready with usage bug in your application) best wishes,HaraldOn 4/20/06, Martin Kuria [EMAIL PROTECTED] wrote: hi,I have a problem with my postgresql database it always gives me an error:Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQLserver: FATAL: sorry, too many clients already in ~/includes/DbConnector.php on line 27Please advice how I can manage my database to handle enough connectionsplease advice.+-+| Martin W. Kuria (Mr.) [EMAIL PROTECTED]++_Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/---(end of broadcast)--- TIP 6: explain analyze is your friend-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstraße 202b70197 Stuttgart0173/9409607 -PostgreSQL - supported by a community that does not put you on hold
Re: [GENERAL] Unable to connect to PostgreSQL server
Look in data/postgres.conf You will find a line there such as max_connections = 50 you will also need to check that shared_buffers is at least twice the max_connections. You can also start Postmaster with -B nBuffers -N maxbackends On 20/4/2006 17:41, Martin Kuria [EMAIL PROTECTED] wrote: hi, I have a problem with my postgresql database it always gives me an error: Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: sorry, too many clients already in ~/includes/DbConnector.php on line 27 Please advice how I can manage my database to handle enough connections please advice. +-+ | Martin W. Kuria (Mr.) [EMAIL PROTECTED] ++ _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] Unable to connect to PostgreSQL server
You may also want to look into your php.ini settings. pgsql.max_persistent pgsql.max_links pgsql.auto_reset_persistent and PGSQL_CONNECT_FORCE_NEW are options you would want to check into. Look in data/postgres.conf You will find a line there such as max_connections = 50 you will also need to check that shared_buffers is at least twice the max_connections. You can also start Postmaster with -B nBuffers -N maxbackends On 20/4/2006 17:41, Martin Kuria [EMAIL PROTECTED] wrote: hi, I have a problem with my postgresql database it always gives me an error: Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: sorry, too many clients already in ~/includes/DbConnector.php on line 27 Please advice how I can manage my database to handle enough connections please advice. +-+ | Martin W. Kuria (Mr.) [EMAIL PROTECTED] ++ _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ---(end of broadcast)--- TIP 6: explain analyze is your friend ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
