From: Guy Deleeuw <G.De_Leeuw@eurofer.be>
To: Marcelo Martins <pglists@zeroaccess.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: PQconnectdb question and md5 password
Date: Tue, 06 May 2008 19:58:48 +0200
Message-ID: <48209C58.6020000@eurofer.be> (raw)
In-Reply-To: <7A9FA81F-5F0F-4CD0-B42A-AE9CB7B3C941@zeroaccess.org>
References: <48202DE2.20805@eurofer.be>
<7A9FA81F-5F0F-4CD0-B42A-AE9CB7B3C941@zeroaccess.org>
Hello Marcelo,
Thanks for your respons
I have a password and is what I need.
My pg_hba.conf have 'md5' :
host all all 127.0.0.1/32 md5
My question are just how I can connect from the C api with an md5
password or it's not possible ?
Regards
Guy
Marcelo Martins a écrit :
> How do you have your pg_hba.conf file setup ?
>
> If on the shell as the postgres user, you can login into the
> "db_stats" database without a password being asked for than you should
> not need one.
> Try out:
>
> postgres$> psql db_stats
>
> and see if you can login without asking for a PW.. check your
> pg_hba.conf first though.
>
>
> On May 6, 2008, at 5:07 AM, Guy Deleeuw wrote:
>
>> Hello,
>>
>> I don't know how can I pass a md5 password to the password field ?
>> example :
>> connInfo = "host=localhost port=5432 dbname=db_stats user=postgres
>> password=secret";
>> pConn = PQconnectdb(connInfo);
>>
>> I try to replace the string 'secret' by the content of /etc/shadow
>> but without succès.
>>
>> Thanks in advance
>>
>> Guy
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
--
Guy De Leeuw
IT Manager
Eurofer
5, avenue Ariane
Building "Integrale" (3rd floor)
1200, Bruxelles
Belgium
Phone : +32 (2) 738 79 40
Mobile : 00 32 498 93 65 00
Fax : +32 (2) 736 28 22
E-Mail : mailto:G.De_Leeuw@eurofer.be
www : http://www.eurofer.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: G.De_Leeuw@eurofer.be, pglists@zeroaccess.org
Subject: Re: PQconnectdb question and md5 password
In-Reply-To: <48209C58.6020000@eurofer.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox