password problem with PostgreSQL

[Frank D. Engel, Jr.]

Then I will assume that you have checked the correct order of 
parameters, and that all items are correctly capitalized (pgsql is 
quite case sensitive as far as the dbname, username, and password).

Concerning phppgadmin, am I correct in "guessing" that this is a local 
admin tool of some sort which is being run on the same machine as the 
db server, and accessed remotely through a web browser?

If so, it is possible that the server was not configured to allow 
remote authentication to the database, or possibly to the postgres 
account.  I would ask the ISP to check the pg_hba.conf file and make 
sure that unencrypted remote connections to the server are allowed.

It may be a matter of having the server configured to accept remote 
connections, but not set up to accept a compatible authentication 
scheme from a remote connection.

On Oct 7, 2004, at 8:27 AM, jbv wrote:

>
>
> Frank,
>
> Thanks for the reply, but I'm not using "ask password".
> I'm just using the pwd for postgres as a parameter for
> revopendatabase, and it doesn't work.
> And I know that the user & pwd are OK since I can login
> to the DB via phppgadmin...
>
> JB
>
>> If you are prompting for the password via "ask password", make sure 
>> you
>> specify the "clear" option (see the docs), otherwise the "ask" dialog
>> encrypts the password before returning it, and you give the wrong 
>> value
>> to revOpenDatabase.
>>
>> On Oct 7, 2004, at 4:36 AM, jbv wrote:
>>
>>> Hi list,
>>>
>>> I'm trying to connect to postgres via RR on an XP box.
>>> Postgres is installed and working (I can login via phppgadmin),
>>> and port 5432 is open on the firewall...
>>> When I try to open the connection (with revopendatabase or the
>>> query builder) I get the following message :
>>> Revdb error : FATAL authentication failed for user "postgres".
>>>
>>> I know that user & password are correct since I use them with
>>> phppgadmin... My isp says the problem comes from my Rev
>>> scripts...
>>>
>>> Any idea of what I should do / modify / try / look at to solve the
>>> problem ?
>>
>>> Thanks,
>>> JB
>>>
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>
>>>
>> -----------------------------------------------------------
>> Frank D. Engel, Jr.  <fde101 at fjrhome.net>
>>
>> $ ln -s /usr/share/kjvbible /usr/manual
>> $ true | cat /usr/manual | grep "John 3:16"
>> John 3:16 For God so loved the world, that he gave his only begotten
>> Son, that whosoever believeth in him should not perish, but have
>> everlasting life.
>> $
>>
>> ___________________________________________________________
>> $0 Web Hosting with up to 120MB web space, 1000 MB Transfer
>> 10 Personalized POP and Web E-mail Accounts, and much more.
>> Signup at www.doteasy.com
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
-----------------------------------------------------------
Frank D. Engel, Jr.  <fde101 at fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten 
Son, that whosoever believeth in him should not perish, but have 
everlasting life.
$



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com