Thread: Authentification failed
Hello everybody!!
I'm trying in SUSE to connect to a postgres db and this is the error:
Ident Authentification failed for user <<root>>
I'm already created the user with createuser root, but the error
persist, I would aprecciate some help, thanks in advanced
> I'm trying in SUSE to connect to a postgres db and this is the
> error:
>
> Ident Authentification failed for user <<root>>
>
others will guide better, but for now, in pg_hba.conf
# "local" is for Unix domain socket connections only
local all all ident sameuser
also, as postgres user, createuser <your-login>
this will let you into pg as yourself
____________________________________________________________________________________
Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545433
On 8/1/07, Judith <jaltamirano@correolux.com.mx> wrote: > Hello everybody!! > > I'm trying in SUSE to connect to a postgres db and this is the error: > > Ident Authentification failed for user <<root>> > > I'm already created the user with createuser root, but the error > persist, I would aprecciate some help, thanks in advanced you need to change auth methods in your pg_hba.conf file: http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html basically identd means that you are who you are on the unix box. no -U flag, you can't log in as someone else. note that a "root" user is a bit of a mysqlism. The postgres user is the equivalent in postgresql. might you sudo su - postgres and try to connect?
On 02-Aug-07, at 2:49 AM, Judith wrote: > I'm trying in SUSE to connect to a postgres db and this is the error: > > Ident Authentification failed for user <<root>> > > I'm already created the user with createuser root, but the error > persist, I would aprecciate some help, thanks in advanced edit your pg_hba.conf file to allow tcp/ip access from localhost. And please dont try to access postgres as 'root' -- regards kg http://lawgon.livejournal.com http://nrcfosshelpline.in/web/
Judith wrote: > Hello everybody!! > > I'm trying in SUSE to connect to a postgres db and this is the error: > > Ident Authentification failed for user <<root>> > > I'm already created the user with createuser root, but the error > persist, I would aprecciate some help, thanks in advanced ...or just cheat and get in as the postgres root user: psql -U postgres Which on SUSE has no password. -- ---- Visit http://www.obviously.com/
<tt>Connecting as root may be ill advised (doing stuff as root is a bad idea unless one HAS to).<br /><br /> All that notwithstanding,you need to setup the correct permissions to allow the connections you want in pg_hba.conf, usually is /var/lib/pgsql/data/pg_hba.conf<br/><br /> Terry<br /><br /></tt> <pre class="moz-signature" cols="72">Terry Fielder <a class="moz-txt-link-abbreviated" href="mailto:terry@greatgulfhomes.com">terry@greatgulfhomes.com</a> Associate Director Software Development and Deployment Great Gulf Homes / Ashton Woods Homes Fax: (416) 441-9085</pre><br /><br /> Bryce Nesbitt wrote: <blockquote cite="mid46C16837.7020608@obviously.com" type="cite"><prewrap="">Judith wrote: </pre><blockquote type="cite"><pre wrap="">Hello everybody!! I'm trying in SUSE to connect to a postgres db and this is the error: Ident Authentification failed for user <<root>> I'm already created the user with createuser root, but the error persist, I would aprecciate some help, thanks in advanced </pre></blockquote><pre wrap="">...or just cheat and get inas the postgres root user: psql -U postgres Which on SUSE has no password. </pre></blockquote>