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 [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
----------------------------------------------------------- Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ 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 [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
----------------------------------------------------------- Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ 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 [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
