Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3D53D6325DC for ; Thu, 4 Mar 2010 07:32:27 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 46622-10 for ; Thu, 4 Mar 2010 11:32:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 1B8406322B5 for ; Thu, 4 Mar 2010 07:32:15 -0400 (AST) Received: by wya21 with SMTP id 21so1361619wya.19 for ; Thu, 04 Mar 2010 03:32:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :x-goomoji-body:date:message-id:subject:from:to:cc:content-type; bh=mI1aiuwqotq+hAuJPlWy02j+HiB0y8/eF7RKVi91INs=; b=RSEI6noNRvjuTNnwhn8yKOYconmS2Jw5LTED3QzsUc+ysyYCZaF3OiB8s/kBWZeQ5G RcuUh6aLzlvgMk4MQqNKWdmvF2DFsp0jtq8vcpgBqz3vI/untzTegNdYxfLesfho/1Xf lpPdxKtKuYo0+CDMV8uUTz8Dr8TYQ4ItkwH6g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:x-goomoji-body:date:message-id :subject:from:to:cc:content-type; b=G4KoPEUEU0jZdf4akIX1ctnN+6r0RNYf0P+woDkcqrSCBw0lc0e0H093KHI4RdX+ZH HBq2Rcvpp+r8QYeroeWq2CtqA5x0hpciNSE8zfIxMfMO1WHfCutRA/saBe/oPhVr94eF qKEcKPNsBqDZ/PA6Zk47U6KlSpKx2Pnw+XhfQ= MIME-Version: 1.0 Received: by 10.216.90.21 with SMTP id d21mr740433wef.159.1267702334159; Thu, 04 Mar 2010 03:32:14 -0800 (PST) In-Reply-To: <1267691098.17535.243.camel@deimos> References: <375c2da1003020043v4c32fa69ga9ce937cf2c47f51@mail.gmail.com> <1267521253.2942.55.camel@deimos> <375c2da1003030637k6c3ffca6ma65651f1927c02eb@mail.gmail.com> <1267629985.17535.175.camel@deimos> <375c2da1003030911o526a14f0hb9ee1cfcf99db6fa@mail.gmail.com> <1267636749.17535.192.camel@deimos> <375c2da1003031010p603441b6l37ed1d33a6516412@mail.gmail.com> <1267691098.17535.243.camel@deimos> X-Goomoji-Body: true Date: Thu, 4 Mar 2010 17:02:14 +0530 Message-ID: <375c2da1003040332p14fde480v6a1aef06d21cd1a5@mail.gmail.com> Subject: Re: password authentication failed for user postgres From: Major Services To: =?ISO-8859-1?Q?I=F1igo_Martinez_Lasala?= Cc: pgsql-admin@postgresql.org Content-Type: multipart/related; boundary=0016e6d77fa04efd350480f7f36a X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.35 tagged_above=-10 required=5 tests=AWL=0.248, BAYES_00=-2.599, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 201003/39 X-Sequence-Number: 33838 --0016e6d77fa04efd350480f7f36a Content-Type: multipart/alternative; boundary=0016e6d77fa04efd300480f7f369 --0016e6d77fa04efd300480f7f369 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I see. I have pgAdmin III on my local system and have been able to create database and tables through it. I hope this is fine? Thanks once again; though I am sure I'll be back with some query for you an= d the community.[?] On Thu, Mar 4, 2010 at 1:54 PM, I=F1igo Martinez Lasala < imartinez@vectorsf.com> wrote: > dbadmin is a database user, not a Linux user. > You cannot use dbadmin in order to get logged to your machine. Only to > access database. > > Why are you using dbadmin to login to unix? Use root. > > Configure your web app using your root user to login to postgresql with > dbadmin. You will have to modify a config file somewhere in the path of this > app. Read INSTALL or README files of your web app. > > Use phppgadmin as alternative. It's also free and it will be probably at > RedHat/CentOS repos. "yum install phppgadmin" or "up2date install > phppgadmin" > Or webmin if you want to admin all server without having to use command > line. http://www.webmin.com/ > > > > > -----Original Message----- > From: Major Services > To: I=F1igo Martinez Lasala > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] password authentication failed for user postgres > Date: Wed, 3 Mar 2010 23:40:39 +0530 > > When I try to login as dbadmin through shell, I get 'access denied'. > > What could be wrong? > > On Wed, Mar 3, 2010 at 10:49 PM, I=F1igo Martinez Lasala > wrote: >> OK, it's a web app installed locally... >> >> Modify config file for this app (I don't know about it, so you will have >> to >> search by yourserlf) and point to 127.0.0.1 instead of use unix sockets, >> and >> also change use postgres for user dbadmin. >> >> Or modify your pg_hba.conf like this >> local all postgres trust >> >> I don't suggest to revert to "local all postgres password" since you wil= l >> have to enter password for any local operation in your server, but anyway, >> it's your decision. >> >> -----Original Message----- >> From: Major Services >> To: I=F1igo Martinez Lasala >> Cc: pgsql-admin@postgresql.org >> Subject: Re: [ADMIN] password authentication failed for user postgres >> Date: Wed, 3 Mar 2010 22:41:47 +0530 >> >> Thanks. >> I already have created a user. >> And can connect to the server through the PgAdmin on my local system. >> >> My query now is : >> Now when I try to connect to the server through DBWebAdmin (in >> Parallels Plesk Panel); I get the following : >> Error: FATAL: Ident authentication failed for user "postgres" >> >> (earlier, with this link I could reach the login screen for PgAdmin ) >> >> Do I need to remove the following from pg_hba.conf now? >> local all postgres ident sameuser >> >> Thanks for all your help & support. >> >> >> >> On Wed, Mar 3, 2010 at 8:56 PM, I=F1igo Martinez Lasala >> wrote: >>> Great. You managed to start server. :-) >>> >>> You are using user postgres and you shoudn't use it.I suggest you to >>> create >>> your own dbadmin... >>> >>> In your linux box, as root user: >>> >>> su - postgres >>> createuser -s dbadmin -P >>> >>> You will create a new user called dbadmin. It will ask you for a password >>> for this user and some extra options. Response YES to all. >>> >>> Now you can connect remotely with this dbadmin user. >>> >>> >>> >>> -----Original Message----- >>> From: Major Services >>> To: I=F1igo Martinez Lasala >>> Cc: pgsql-admin@postgresql.org >>> Subject: Re: [ADMIN] password authentication failed for user postgres >>> Date: Wed, 3 Mar 2010 20:07:23 +0530 >>> >>> >>> Finally, I am able to create a user. >>> >>> Now when I try to connect to the server through DBWebAdmin (in >>> Parallels Plesk Panel); I get the following : >>> Error: FATAL: Ident authentication failed for user "postgres" >>> >>> (earlier, with this link I could reach the login screen for PgAdmin ) >>> >>> Do I need to remove the following from pg_hba.conf now? >>> local all postgres ident sameuser >>> >>> >>> >>> >>> >>> On Tue, Mar 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala >>> wrote: >>>> In order to lauch createuser you don't need to modify listen_address >>>> since >>>> you can use unix sockets. But anyway it's a requirement if you are goint >>>> to >>>> access remotely. >>>> >>>> Add this line in first place to your pg_hba.conf >>>> local all postgres ident sameuser >>>> >>>> >>>> Reload postgresql and launch createuser as postgres user. >>>> >>>> >>>> -----Original Message----- >>>> From: Major Services >>>> To: pgsql-admin@postgresql.org >>>> Subject: [ADMIN] password authentication failed for user postgres >>>> Date: Tue, 2 Mar 2010 14:13:10 +0530 >>>> >>>> Hi, >>>> >>>> 1. I have added listen_addresses =3D '*' ; in postgresql.conf >>>> >>>> 2. And have made the following changes to pg_hba.conf >>>> >>>> local DATABASE USER METHOD >>>> local samegroup all password >>>> host DATABASE USER CIDR-ADDRESS METHOD [OPTION] >>>> >>> >>>> hostssl all all 0.0.0.0/0 md5 >>>> >>>> 3. Have restarted the server >>>> >>>> 4. I can login to the server as user postgres. >>>> >>>> But while trying to createuser I get the following message : >>>> 'createuser: could not connect to database postgres: FATAL : >>>> password authentication failed for user "postgres" >>>> >>>> This is on Redhat running Plesk also. >>>> >>>> I am new to Linux as well as PostgreSQL. Help would be much appreciated. >>>> >>>> Thanks >>>> Viv >>>> >>>> >>>> >>> >>> >> >> > > --0016e6d77fa04efd300480f7f369 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I see.

I have pgAdmin III on my local system and have been able to = create database and tables through it. I hope this is fine?

Thanks = once again; though I am sure I'll be back with some query for you and t= he community.




On Thu, Mar 4, 2010 at 1:54 PM, I=F1igo Martinez Lasala <= ;imartinez@vectorsf.com> w= rote:
> dbadmin is a database user, not a Linux user.
> You can= not use dbadmin in order to get logged to your machine. Only to
> access database.
>
> Why are you using dbadmin to login to= unix? Use root.
>
> Configure your web app using your root use= r to login to postgresql with
> dbadmin. You will have to modify a co= nfig file somewhere in the path of this
> app. Read INSTALL or README files of your web app.
>
> Use= phppgadmin as alternative. It's also free and it will be probably at> RedHat/CentOS repos. "yum install phppgadmin" or "up2= date install
> phppgadmin"
> Or webmin if you want to admin all server wit= hout having to use command
> line. http://www.webmin.com/
>
>
>
>
> -----Or= iginal Message-----
> From: Major Services <s= ervices.major@gmail.com>
> To: I=F1igo Martinez Lasala <imartinez@vectorsf.com>
&g= t; Cc: pgsql-admin@postgresql= .org
> Subject: Re: [ADMIN] password authentication failed for user postgres<= br>> Date: Wed, 3 Mar 2010 23:40:39 +0530
>
> When I try to = login as dbadmin through shell, I get 'access denied'.
>
> What could be wrong?
>
> On Wed, Mar 3, 2010 at 10:49 PM, = I=F1igo Martinez Lasala
> <imartinez@vectorsf.com> wrote:
>> OK, it's a web app= installed locally...
>>
>> Modify config file for this app (I don't know abou= t it, so you will have
>> to
>> search by yourserlf) and = point to 127.0.0.1 instead of use unix sockets,
>> and
>>= also change use postgres for user dbadmin.
>>
>> Or modify your pg_hba.conf like this
>> local= =A0=A0=A0=A0 all=A0=A0=A0=A0 postgres=A0=A0=A0=A0 trust
>>
>= > I don't suggest to revert to "local all postgres password&quo= t; since you will
>> have to enter password for any local operation in your server, but= anyway,
>> it's your decision.
>>
>> -----O= riginal Message-----
>> From: Major Services <services.major@gmail.com>
>> To: I=F1igo Martinez Lasala <imartinez@vectorsf.com>
>> Cc: pgsql-admin@postgresql.org
>> Subjec= t: Re: [ADMIN] password authentication failed for user postgres
>> Date: Wed, 3 Mar 2010 22:41:47 +0530
>>
>> Thank= s.
>> I already have created a user.
>> And can connect t= o the server through the PgAdmin on my local system.
>>
>>= ; My query now is :
>> Now when I try to connect to the server through DBWebAdmin (in
= >> =A0Parallels Plesk Panel); I get the following :
>> =A0Er= ror: FATAL: Ident authentication failed for user "postgres"
&g= t;>
>> =A0(earlier, with this link I could reach the login screen for PgA= dmin )
>>
>> =A0 Do I need to remove the following from p= g_hba.conf now?
>> =A0 local =A0 all =A0 =A0 =A0 =A0 postgres =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0ident sameuser
>>
>> Thanks for all your help & support.
>>>>
>>
>> On Wed, Mar 3, 2010 at 8:56 PM, I=F1igo M= artinez Lasala
>> <im= artinez@vectorsf.com> wrote:
>>> Great. You managed to start server. :-)
>>>
>= ;>> You are using user postgres and you shoudn't use it.I suggest= you to
>>> create
>>> your own dbadmin...
>&= gt;>
>>> In your linux box, as root user:
>>>
>>&g= t; su - postgres
>>> createuser -s dbadmin -P
>>>>>> You will create a new user called dbadmin. It will ask you f= or a password
>>> for this user and some extra options. Response YES to all.
= >>>
>>> Now you can connect remotely with this dbadmin= user.
>>>
>>>
>>>
>>> ----= -Original Message-----
>>> From: Major Services <services.major@gmail.com>
>>> To: I=F1igo Martine= z Lasala <imartinez@vectorsf.c= om>
>>> Cc: pgsql-admin@= postgresql.org
>>> Subject: Re: [ADMIN] password authentica= tion failed for user postgres
>>> Date: Wed, 3 Mar 2010 20:07:2= 3 +0530
>>>
>>>
>>> Finally, I am able to create a= user.
>>>
>>> Now when I try to connect to the ser= ver through DBWebAdmin (in
>>> Parallels Plesk Panel); I get th= e following :
>>> Error: FATAL: Ident authentication failed for user "postg= res"
>>>
>>> (earlier, with this link I could = reach the login screen for PgAdmin )
>>>
>>> =A0Do = I need to remove the following from pg_hba.conf now?
>>> =A0local =A0 all =A0 =A0 =A0 =A0 postgres =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0ident sameuser
>>>
>>&g= t;
>>>
>>>
>>>
>>> On Tue, = Mar 2, 2010 at 2:44 PM, I=F1igo Martinez Lasala
>>> <imartinez@vector= sf.com> wrote:
>>>> In order to lauch createuser you = don't need to modify listen_address
>>>> since
>&g= t;>> you can use unix sockets. But anyway it's a requirement if y= ou are goint
>>>> to
>>>> access remotely.
>>>>= ;
>>>> Add this line in first place to your pg_hba.conf
&= gt;>>> local=A0=A0 all=A0=A0=A0=A0=A0=A0=A0=A0 postgres=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 ident sa= meuser
>>>>
>>>>
>>>> Reload postgresql = and launch createuser as postgres user.
>>>>
>>>= >
>>>> -----Original Message-----
>>>> Fro= m: Major Services <services.= major@gmail.com>
>>>> To: pgsql-ad= min@postgresql.org
>>>> Subject: [ADMIN] password authen= tication failed for user postgres
>>>> Date: Tue, 2 Mar 2010= 14:13:10 +0530
>>>>
>>>> Hi,
>>>>
>>>= ;> 1. I have added =A0listen_addresses =3D '*' ; in =A0postgresq= l.conf
>>>>
>>>> 2. And have made the followi= ng changes to pg_hba.conf
>>>>
>>>> local =A0 DATABASE =A0 =A0USER =A0 MET= HOD
>>>> local =A0 =A0samegroup =A0 =A0 =A0all =A0 =A0 =A0pa= ssword
>>>> host =A0 =A0DATABASE =A0 =A0USER =A0 =A0CIDR-ADD= RESS =A0METHOD =A0[OPTION]
>>>>
>>>
>>>> hostssl =A0 =A0 =A0all =A0 =A0 =A0 =A0 =A0= =A0 =A0 =A0 all =A0 =A0 =A0 0.0.0.0/0 =A0= =A0 =A0 =A0 =A0 =A0md5
>>>>
>>>> 3. Have res= tarted the server
>>>>
>>>> 4. I can login to the server as user postgres.
>>= >>
>>>> But =A0while trying to createuser I get the fo= llowing message =A0:
>>>> 'createuser: could not connect= to database postgres: =A0FATAL :
>>>> password authentication failed for user "postgres&quo= t;
>>>>
>>>> This is on Redhat running Plesk = also.
>>>>
>>>> I am new to Linux as well as = PostgreSQL. Help would be much appreciated.
>>>>
>>>> Thanks
>>>> Viv
>= >>>
>>>>
>>>>
>>>
>= ;>>
>>
>>
>
>

--0016e6d77fa04efd300480f7f369-- --0016e6d77fa04efd350480f7f36a Content-Type: image/gif; name="330.gif" Content-Transfer-Encoding: base64 X-Attachment-Id: 330@goomoji.gmail Content-ID: <330@goomoji.gmail> R0lGODlhDAAMAKIFAF5LAP/zxAAAANyuAP/gaP///wAAAAAAACH5BAEAAAUALAAAAAAMAAwAAAMl WLPcGjDKFYi9lxKBOaGcF35DhWHamZUW0K4mAbiwWtuf0uxFAgA7 --0016e6d77fa04efd350480f7f36a--