From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 25437 invoked by alias); 18 Sep 2003 08:15:33 -0000 Mailing-List: contact rhdb-help@sources.redhat.com; run by ezmlm Precedence: bulk List-Subscribe: List-Post: List-Help: , Sender: rhdb-owner@sources.redhat.com Received: (qmail 25422 invoked from network); 18 Sep 2003 08:15:30 -0000 Received: from unknown (HELO web15311.mail.bjs.yahoo.com) (202.3.77.186) by sources.redhat.com with SMTP; 18 Sep 2003 08:15:30 -0000 Message-ID: <20030918081527.39162.qmail@web15311.mail.bjs.yahoo.com> Received: from [211.93.110.146] by web15311.mail.bjs.yahoo.com via HTTP; Thu, 18 Sep 2003 16:15:27 CST Date: Thu, 18 Sep 2003 08:15:00 -0000 From: =?gb2312?q?huwang=20wang?= Subject: Re: I can't connect to Redhat database administrator graphical tool To: Patrick Macdonald Cc: rhdb@sources.redhat.com In-Reply-To: <3F6862BE.5010807@redhat.com> MIME-Version: 1.0 Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 8bit X-SW-Source: 2003-q3/txt/msg00019.txt.bz2 Hi, According to your instruction,I have successfully connected to the server using the graphical tool. Thank you. --- Patrick Macdonald µÄÕýÎÄ£º> 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 > µÄÕýÎÄ£º> > > 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 > > > > > > > > _________________________________________________________ Do You Yahoo!? ÆôÓõçÓÊÕʺţ¬Áì»áÑÅ»¢Í¨[ÉíÁÙÆä¾³ÁĵçÓ°]µÄ¶¯¸Ð÷ÈÁ¦£¬»¹ÓÐÍøÂçÉãÏñÍ·+ÑÅ»¢Í¨ÊÕÒô»úµÈÄãÀ´Äà http://cn.rd.yahoo.com/mail_cn/tag/?http://cn.messenger.yahoo.com