Thread: problem to connect

The default behavior for postgres uses IDENT. So you need to log on as 
user nicolas to be able to use postgres user nicolas. You can look at 
/var/lib/pgsql/data/pg_hba.conf for configuration detail.

Wei

nicolas renie wrote:

> Hye
>  
> I use linux mandrack 9.0 and postgres 7.2
> I can't connect to postgresql (even in local) if I use a postgres user.
> I don't know what to do.
> I've started the daemon (root# etc/rc.d/init.d/postgresql start)
> logged under postgres I made a user (createuser nico) and a 
> database(createdb test)
> But I can't access to this database if I am logged under an other user.
> (su Eddy or anathor linux user)
>  
> When I try: psql test -h localhost -U nicolas I have the message :
> IDENT authentification failed for user nicolas.
> I can see the same message when I try to connect whith pgaccess.
>  
> If I try to start pgaccess with: "pgaccess test", the main PgAccess 
> window
>  comes up, (empty) but there is an error message box in front of it. 
> The message is:
>     
>  "Error trying to connect to database "test" on host localhost.
>    is the postmaster running (with -i) at
>     'localhost' and accepting connections on TCP/IP port '5432'?"
>  
> Therefore I stopped postgresql etc/rc.d/init.d/postgresql stop
> I started it logged under postgres with options ($ postmaster -h 
> localhost -i )
>  
> I logged under another linux user
> I tried : psql test -h localhost -U nicolas and received the message
>  
> No pga_hba.conf entry for host localhost, user nicolas, database test
>  
> I tryed to change the pg_dba.conf (trust) file but another message 
> appears.
>  
> I would like to know what to do especially to use pgaccess
>  
>  
> Please, help me !
> regards
>  
> Nicolas RENIE
>  
>  

On Tue, 8 Apr 2003, nicolas renie waxed:

8<'s

> I logged under another linux user
> I tried : psql test -h localhost -U nicolas and received the message
>
> No pga_hba.conf entry for host localhost, user nicolas, database test
>
> I tryed to change the pg_dba.conf (trust) file but another message appears.

In pg_hba.conf, do you have the following:

local        all                                           trust
host         all         127.0.0.1     255.255.255.255     trust

Also, you need to be either root or the postgres user to edit the file.

To work with PgAccess, you will need to give the user you want to login
as SELECT permission on the pg_user table (if it's a different user than
that which created the database.)

--Chris


-- 

Chris Maj <cmaj_hat_freedomcorpse_hot_info>
0xC0051F6A
5EB8 2035 F07B 3B09 5A31  7C09 196F 4126 C005 1F6A

Hello,   Has anybody done anything towards having ECPG produce 
ODBC code?  Or, has anybody seen an ESQL/C to ODBC
preprocessor?

Thank you

Bill Suetholz

On Thu, Apr 10, 2003 at 02:20:39PM -0500, William Suetholz wrote:
>   Has anybody done anything towards having ECPG produce 
> ODBC code?  Or, has anybody seen an ESQL/C to ODBC
> preprocessor?

I'm not sure it's that easily done, but the idea is interesting. Anyway,
I never though of it and never heard anyone else mentioning it.

Michael
-- 
Michael Meskes
Email: Michael@Fam-Meskes.De
ICQ: 179140304, AIM: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!