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
Show quoted text
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
Import Notes
Reply to msg id not found: 375c2da1003150506r4fbc0bd5u5708a52afdfb15f3@mail.gmail.com
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:
Show quoted text
---------- 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.ieI 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 trustThere 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:
Show quoted text
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.ieI 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 trustThere 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