Yes, the command-line client works fine that way.
Turns out the problem was SELinux permissions that had to be
specifically enabled.
Thanks for the suggestions and the help.
-- john
Scott Marlowe wrote:
On Mon, Mar 10, 2008 at 1:14 PM, John Cartwright
<[EMAIL PROTECTED]> wrote:
Hello A
On Mon, Mar 10, 2008 at 1:14 PM, John Cartwright
<[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
> version 8.2.3. I think that TCP connections are enabled correctly in
> the server's pg_hba.conf and I can successfully connect
On Mon, 10 Mar 2008, Tom Lane wrote:
I don't know much about how to fix it, other than the extremely
brute-force tool of "setenforce 0". On current Fedora it looks like the
way is probably "setsebool -P allow_user_postgresql_connect 1", but I'm
not sure if RHEL5 uses that approach or somethin
Thanks for your reply, Tom. Not sure exactly what you mean - this is a
php script executed via apache. php scripts w/in the same directory that
don't make database connections seem to work OK.
Your suggestion is a good one though - it may be an SELinux
configuration. I'll try to pursue that
John Cartwright <[EMAIL PROTECTED]> writes:
> I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
> version 8.2.3. I think that TCP connections are enabled correctly in
> the server's pg_hba.conf and I can successfully connect from the client
> using pgsql. However, tryin
Hello All,
I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
version 8.2.3. I think that TCP connections are enabled correctly in
the server's pg_hba.conf and I can successfully connect from the client
using pgsql. However, trying to use pg_connect() w/ a call like:
On Jul 17, 2007, at 3:13 AM, Vince wrote:
When this fails, I get a useful error print:
$dbconn = pg_connect($connection_str);
Ouput:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: password authentication failed for user
"postgres1" in ...
How do
On 17.07.2007 09:45, Hannes Dorbath wrote:
This is a PHP, not a PostgreSQL question.
Well, pg_last_error() might not return something in that case. You can
create a custom error handler if the message is important for you.
--
Regards,
Hannes Dorbath
---(end of broad
On 17.07.2007 09:13, Vince wrote:
When this fails, I get a useful error print:
$dbconn = pg_connect($connection_str);
Ouput:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: password authentication failed for user
"postgres1" in ...
How do I capture
When this fails, I get a useful error print:
$dbconn = pg_connect($connection_str);
Ouput:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: password authentication failed for user
"postgres1" in ...
How do I capture this error and handle the printing
10 matches
Mail list logo
