Thread: Unable to connect to Postgres database from email marketing software on the same host
Unable to connect to Postgres database from email marketing software on the same host
From
Major Services
Date:
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
Re: Unable to connect to Postgres database from email marketing software on the same host
From
"A. Kretschmer"
Date:
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
Re: Unable to connect to Postgres database from email marketing software on the same host
From
Raymond O'Donnell
Date:
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
Fwd: Unable to connect to Postgres database from email marketing software on the same host
From
Major Services
Date:
---------- 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 >
Re: Unable to connect to Postgres database from email marketing software on the same host
From
Major Services
Date:
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 >> >
Re: Unable to connect to Postgres database from email marketing software on the same host
From
"A. Kretschmer"
Date:
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
Re: Unable to connect to Postgres database from email marketing software on the same host
From
Major Services
Date:
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 >>> >> >
Re: Unable to connect to Postgres database from email marketing software on the same host
From
"A. Kretschmer"
Date:
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