Thread: Unable to fire up the server when modifying client authentication setting!
Unable to fire up the server when modifying client authentication setting!
From
"Verhaag Geert (GEN)"
Date:
Hi,
I’m currently using version 8.4, and installed everything seems to work properly.
However, I’m having trouble with setting client authentication properly!
Client authentication is controlled by the configuration file named pg_hba.conf.
When I add the option map=myname like this:
local all all trust map=myname
to the file mentioned above the server won’t fire up anymore! No messages in the log?
By the way I added myname to the pg_ident.conf file like:
# MAPNAME SYSTEM-USERNAME PG-USERNAME
myname systemusername pgusername
What is wrong here?
Regards,
Gerard
Re: Unable to fire up the server when modifying client authentication setting!
From
Albe Laurenz
Date:
Verhaag Geert wrote: > I’m currently using version 8.4, and installed everything seems to work properly. > > However, I’m having trouble with setting client authentication properly! > > Client authentication is controlled by the configuration file named pg_hba.conf. > > When I add the option map=myname like this: > > local all all trust map=myname > > to the file mentioned above the server won’t fire up anymore! No messages in the log? > > By the way I added myname to the pg_ident.conf file like: > > # MAPNAME SYSTEM-USERNAME PG-USERNAME > myname systemusername pgusername > > What is wrong here? I guess you want "ident" authentication. You should replace "trust" with "ident". By the way, you don't need to restart the server for such a change. Using "pg_ctl reload" to send a SIGHUP would do the trick. Yours, Laurenz Albe
Re: Unable to fire up the server when modifying client authentication setting!
From
"Verhaag Geert (GEN)"
Date:
Hi Laurenz, Thank you very much for helping me with this rather trivial issue, sorry! Of course, you are perfectly right about the ' ident' authentication, I missed that completely! Sorry!! Regards, Gerard -----Original Message----- From: Albe Laurenz [mailto:laurenz.albe@wien.gv.at] Sent: Tuesday, November 26, 2013 13:03 To: Verhaag Geert (GEN); pgsql-admin@postgresql.org Subject: RE: Unable to fire up the server when modifying client authentication setting! Verhaag Geert wrote: > I’m currently using version 8.4, and installed everything seems to work properly. > > However, I’m having trouble with setting client authentication properly! > > Client authentication is controlled by the configuration file named pg_hba.conf. > > When I add the option map=myname like this: > > local all all trust map=myname > > to the file mentioned above the server won’t fire up anymore! No messages in the log? > > By the way I added myname to the pg_ident.conf file like: > > # MAPNAME SYSTEM-USERNAME PG-USERNAME > myname systemusername pgusername > > What is wrong here? I guess you want "ident" authentication. You should replace "trust" with "ident". By the way, you don't need to restart the server for such a change. Using "pg_ctl reload" to send a SIGHUP would do the trick. Yours, Laurenz Albe