VitaleBay

Tracker: Bugs

5 Database Port Settings - ID: 729212

Last Update: Comment added ( glyph78 )

Details:

Your documentation doesn't state what port the
PostgreSQL server needs to be running on in order to
accept connections. I've tried all the standard ones
and do not appear to get getting anywhere with it, so I
thought I'd ask. I keep getting connection failures
which indicates to me that the web server/php scripts
are not making connection to the database. I've pasted
in the error message below. I have verified that both
the user name and password are correct.

#!/usr/bin/php -q
Warning: pg_connect() unable to connect to PostgreSQL
server: FATAL 1: IDENT authentication failed for user
"password=base64_decode()" in
/var/www/html/auto/populateDB.php on line 13

Submitted:

Jimi Thompson ( jimit ) - 2003-04-28 22:14

Priority:

Status:

Closed

Resolution:

None

Assigned:

Scott Vitale

Category:

None

Group:

None

Visibility:

Public

Comments ( 2 )

Date: 2003-05-20 18:38 Sender: glyph78 Logged In: YES user_id=675816 If this corrects your problem, let me know and I'll add the changes to the documentation. -Scott
Date: 2003-05-20 18:35 Sender: glyph78 Logged In: YES user_id=675816 Hi, This software was built to run on the standard postgres TCP/IP port for all php connections. Couple things you might try...... 1. Check your pg_hba.conf file. I've pasted a copy of mine below. Essentially, mine is set up to allow all local connections either by TCP/IP or UNIX Socket. # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT local all trust host all 0.0.0.0 0.0.0.0 trust 2. Check that you're using "-i" when you start postgres. I use the following line in my startup script: su - postgres -c "/usr/local/bin/postmaster - D /usr/local/pgsql/data -i > /usr/local/pgsql/data/pgsql.log 2>&1 &" This starts postgres running as a process under user "postgres", sets stdin/stdout pointers, and enables TCP/IP socket connections. If this doesn't help, feel free to drop me an email. -Scott

Date: 2003-05-20 18:38
Sender: glyph78

Logged In: YES
user_id=675816

If this corrects your problem, let me know and I'll add the
changes to the documentation.

-Scott

Date: 2003-05-20 18:35
Sender: glyph78

Logged In: YES
user_id=675816

Hi,

This software was built to run on the standard postgres
TCP/IP port for all php connections. Couple things you might
try......

1. Check your pg_hba.conf file. I've pasted a copy of mine
below. Essentially, mine is set up to allow all local
connections either by TCP/IP or UNIX Socket.

# TYPE DATABASE IP_ADDRESS MASK
AUTH_TYPE AUTH_ARGUMENT

local all trust
host all 0.0.0.0 0.0.0.0 trust

2. Check that you're using "-i" when you start postgres. I
use the following line in my startup script:

su - postgres -c "/usr/local/bin/postmaster -
D /usr/local/pgsql/data -i > /usr/local/pgsql/data/pgsql.log
2>&1 &"

This starts postgres running as a process under
user "postgres", sets stdin/stdout pointers, and enables
TCP/IP socket connections.

If this doesn't help, feel free to drop me an email.

-Scott

Log in to comment.

Attached File

Changes ( 3 )

Field	Old Value	Date	By
close_date	-	2003-05-20 18:38	glyph78
status_id	Open	2003-05-20 18:38	glyph78
assigned_to	nobody	2003-05-20 18:38	glyph78

VitaleBay

Tracker: Bugs

Comments ( 2 )

Log in to comment.

Attached File

No Files Currently Attached

Changes ( 3 )

About SourceForge

Find Software

Develop Software

Community

Help