Обсуждение: Unable to connect to Postgres database from email marketing software on the same host

Hi,

I have an email marketing software installed on the same server as
PostgresSQL database.
Am unable to connect  to the database from this application. The
database owner is dbadmin.

My pg_hba.conf has one  entry as:

local all dbadmin trust

What other setup is required for this?

Thanks

In response to Major Services :
> Hi,
>
> I have an email marketing software installed on the same server as
> PostgresSQL database.
> Am unable to connect  to the database from this application. The
> database owner is dbadmin.

Error-message?

>
> My pg_hba.conf has one  entry as:
>
> local all dbadmin trust
>
> What other setup is required for this?

Is your software trying to establish a connection via UNIX-Sockets or
via TCP/IP?

If TCP/IP, you needs a proper host - entry in your pg_hba.conf.


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

On 15/03/2010 11:24, Major Services wrote:

> I have an email marketing software installed on the same server as
> PostgresSQL database.
> Am unable to connect  to the database from this application. The
> database owner is dbadmin.
>
> My pg_hba.conf has one  entry as:
>
> local all dbadmin trust
>
> What other setup is required for this?

If the application is connecting via TCP/IP, I think you need a "host"
rule for that:

   host    all    dbadmin   127.0.0.1/32     trust

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

---------- Forwarded message ----------
From: Major Services <services.major@gmail.com>
Date: Mon, Mar 15, 2010 at 5:36 PM
Subject: Re: [GENERAL] Unable to connect to Postgres database from
email marketing software on the same host
To: rod@iol.ie


I have the following:

host    all    dbadmin    0.0.0.0/0     trust

Do I need to change it to
host    all    dbadmin   127.0.0.1/32     trust

There are other (JAVA) applications  connecting to the server with
user dbadmin remotely. Hope any change does not affect that.

Thanks

On Mon, Mar 15, 2010 at 5:25 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> On 15/03/2010 11:24, Major Services wrote:
>
>> I have an email marketing software installed on the same server as
>> PostgresSQL database.
>> Am unable to connect  to the database from this application. The
>> database owner is dbadmin.
>>
>> My pg_hba.conf has one  entry as:
>>
>> local all dbadmin trust
>>
>> What other setup is required for this?
>
> If the application is connecting via TCP/IP, I think you need a "host"
> rule for that:
>
>   host    all    dbadmin   127.0.0.1/32     trust
>
> Ray.
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod@iol.ie
>

Error message is "Server call failed for unknown reason"

The software doc does not mention whether trying to establish a
connection via UNIX-Sockets or
via TCP/IP?



On Mon, Mar 15, 2010 at 5:43 PM, Major Services
<services.major@gmail.com> wrote:
> ---------- Forwarded message ----------
> From: Major Services <services.major@gmail.com>
> Date: Mon, Mar 15, 2010 at 5:36 PM
> Subject: Re: [GENERAL] Unable to connect to Postgres database from
> email marketing software on the same host
> To: rod@iol.ie
>
>
> I have the following:
>
> host    all    dbadmin    0.0.0.0/0     trust
>
> Do I need to change it to
> host    all    dbadmin   127.0.0.1/32     trust
>
> There are other (JAVA) applications  connecting to the server with
> user dbadmin remotely. Hope any change does not affect that.
>
> Thanks
>
> On Mon, Mar 15, 2010 at 5:25 PM, Raymond O'Donnell <rod@iol.ie> wrote:
>> On 15/03/2010 11:24, Major Services wrote:
>>
>>> I have an email marketing software installed on the same server as
>>> PostgresSQL database.
>>> Am unable to connect  to the database from this application. The
>>> database owner is dbadmin.
>>>
>>> My pg_hba.conf has one  entry as:
>>>
>>> local all dbadmin trust
>>>
>>> What other setup is required for this?
>>
>> If the application is connecting via TCP/IP, I think you need a "host"
>> rule for that:
>>
>>   host    all    dbadmin   127.0.0.1/32     trust
>>
>> Ray.
>>
>> --
>> Raymond O'Donnell :: Galway :: Ireland
>> rod@iol.ie
>>
>

In response to Major Services :
> Error message is "Server call failed for unknown reason"

Okay, i know from the other post, you have also a proper host-entry.

Well, this error-message isn't helpfull, can you see in the server-log
for a more detailed error message?

Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

Not sure how to check the server-log? Please help.

New to Postgres & Linux!


On Mon, Mar 15, 2010 at 5:48 PM, Major Services
<services.major@gmail.com> wrote:
> Error message is "Server call failed for unknown reason"
>
> The software doc does not mention whether trying to establish a
> connection via UNIX-Sockets or
> via TCP/IP?
>
>
>
> On Mon, Mar 15, 2010 at 5:43 PM, Major Services
> <services.major@gmail.com> wrote:
>> ---------- Forwarded message ----------
>> From: Major Services <services.major@gmail.com>
>> Date: Mon, Mar 15, 2010 at 5:36 PM
>> Subject: Re: [GENERAL] Unable to connect to Postgres database from
>> email marketing software on the same host
>> To: rod@iol.ie
>>
>>
>> I have the following:
>>
>> host    all    dbadmin    0.0.0.0/0     trust
>>
>> Do I need to change it to
>> host    all    dbadmin   127.0.0.1/32     trust
>>
>> There are other (JAVA) applications  connecting to the server with
>> user dbadmin remotely. Hope any change does not affect that.
>>
>> Thanks
>>
>> On Mon, Mar 15, 2010 at 5:25 PM, Raymond O'Donnell <rod@iol.ie> wrote:
>>> On 15/03/2010 11:24, Major Services wrote:
>>>
>>>> I have an email marketing software installed on the same server as
>>>> PostgresSQL database.
>>>> Am unable to connect  to the database from this application. The
>>>> database owner is dbadmin.
>>>>
>>>> My pg_hba.conf has one  entry as:
>>>>
>>>> local all dbadmin trust
>>>>
>>>> What other setup is required for this?
>>>
>>> If the application is connecting via TCP/IP, I think you need a "host"
>>> rule for that:
>>>
>>>   host    all    dbadmin   127.0.0.1/32     trust
>>>
>>> Ray.
>>>
>>> --
>>> Raymond O'Donnell :: Galway :: Ireland
>>> rod@iol.ie
>>>
>>
>

In response to Major Services :
> Not sure how to check the server-log? Please help.
>
> New to Postgres & Linux!

Just read the logfile, it's usually somewhere under /var/log/postgresql.
On my machine for instance /var/log/postgresql/postgresql-8.4-main.log


>
>
> On Mon, Mar 15, 2010 at 5:48 PM, Major Services
> <services.major@gmail.com> wrote:
> > Error message is "Server call failed for unknown reason"

Your quoting-style is .... arduously.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99