Re: problem connecting to postgres via apache

From: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: problem connecting to postgres via apache
Date: 2014-01-24 02:18:27
Message-ID: CADp-Sm5Y3eKP5dkUwpCdQm34r9NRnp6w8xTd+ua7fwcbYr03hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 24, 2014 at 7:08 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> On 01/23/2014 02:55 PM, Susan Cassidy wrote:
>
>> I'm having a problem connecting to postgres via a CGI program. I can
>> connect just fine using the same connect string in a non-cgi perl
>> program as in the perl cgi program. The error I get is this:
>>
>>
>> ERROR: Unable to connect to dbname testdb2, err: could not
>> connect to server: Permission denied
>> Is the server running on host "jacensolo.red.dsic.com
>> <http://jacensolo.red.dsic.com>" (192.168.10.16) and accepting
>>
>> TCP/IP connections on port 5432?
>>
>
> FYI, in the future you might want to anonymize your host information. For
> example xxx.yyy.zzz.com
>
> Well from the above it looks like you where trying to connect using TCP/IP
> not a socket.
>
> What is your connection string?

In addition to what has been already asked, can you also check if your
firewall is running?

Best Regards,
*Sameer Kumar | Database Consultant*

*ASHNIK PTE. LTD. *101 Cecil Street, #11-11 Tong Eng Building, Singapore
069533
M : *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

[image: email patch]

This email may contain confidential, privileged or copyright material and
is solely for the use of the intended recipient(s).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2014-01-24 02:35:21 Re: Fully-automatic streaming replication failover when master dies?
Previous Message Sameer Kumar 2014-01-24 02:16:49 Re: Fully-automatic streaming replication failover when master dies?