Re: I can't connect to Redhat database administrator graphical tool

[Patrick Macdonald <patrickm at redhat dot com>]

Huwang,

Here's some information from a past post on this
mailing list:

Deepak Bhole wrote (on 04/08/2003):
> Hi José,
>
> You need to re-configure your Host Based Authentication (hba) file. This
> is located in /var/lib/pgsql/data/pg_hba.conf.
>
> It seems that in there, you have set authentication for postgres to pass
> only if the IDENT is correct (either postgres, or something else if you
> are using mapping. See
>
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=client-authentication.html
for more info). If you are aware that its using IDENT authentication and wish to continue
to use it, you must start rhdb-admin as user postgres in order to connect to the cluster
successfully.
>
> If you do not wish to start rhdb-admin as user postgres, you will have
> to configure the pg_hba.conf file to authenticate postgres on
> "password"/"trust"/etc.
>
> Regards,
> Deepak



huwang wang wrote:
> Hi,
> 
> When I installed the redhat database 2.1,I have chosen
>  to perform all the following tasks.  
> 
> Start Red Hat Database now.
> Configure Red Hat Database to start at system
> start-up. 
> Run the regression tests.
> 
> All of these tasks have completed successfully.
> 
> Then I started the graphical tool DataBase
> Administrator and followed the instructions in your
> tutorial,I fill the blanks with "tutorial","Unix
> Domain Socket","/tmp","5432".
> 
> As for the user name and pasword,No matter what I have
> provided ,such as postgres or other username and
> password I have created by command line,when I clicked
> the tutorial icon,the right pane showed that"status
> Not Connected Reason:Fatal 1:IDENT authenticatin
> failed for user "postgres"or other name I have
> created.
> 
> But in fact the redhat database server is
> running.Because when I use postgres or the name I have
> created to issue command createdb ***,the response is
> correct---CREATE DATABASE. 
> 
> Can you help me out?
> 
> 
> --- Patrick Macdonald <patrickm@redhat.com> 的正文：>
> Huwang,
> 
>>Yes, you should just able to leave the password
>>field
>>blank with the default user.  As for creating other
>>users and using the tool, what type of error message
>>is being returned when you attempt to connect?
>>
>>Cheers,
>>Patrick
>>
>>huwang wang wrote:
>>
>>>Hi,
>>>According to your tutorial,
>>>
>>
> http://www.redhat.com/docs/manuals/database/RHDB-2.1-Manual/guitools/x454.html
> 
>>>we need to provide the password of postgres when
>>
>>we
>>
>>>log in as 'postgres'.But as we know ,the default
>>>installation of postgresql has no password for
>>
>>User
>>
>>>'postgres'.
>>>
>>>I have also created several user using the command
>>>line to try to connect using the graphical
>>
>>tool,and it
>>
>>>also failed.
>>>
>>>Can you help me out? 
>>
>> 
> 
> 
> _________________________________________________________
> Do You Yahoo!? 
> 启用电邮帐号，领会雅虎通[身临其境聊电影]的动感魅力，还有网络摄像头+雅虎通收音机等你来拿
> http://cn.rd.yahoo.com/mail_cn/tag/?http://cn.messenger.yahoo.com
> 
> 
>