From: Frank Bax <fbax@execulink.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: pgAdmin problems
Date: Sat, 01 Apr 2000 17:29:26 -0500
Message-ID: <3.0.6.32.20000401172926.008f74f0@execulink.com> (raw)
In-Reply-To: <38E6641D.6E77A788@tm.ee>
References: <3.0.6.32.20000401152708.00978880@execulink.com>
I'm sorry, but I don't understand the examples in pg_hba.conf file.
The file contains only these non-commented lines:
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 0.0.0.0 0.0.0.0 password
When I change password to crypt or ident, then error message in Access
changes accordingly.
When I change the last line to:
host all xxx.xxx.xxx.xxx 255.255.255.255 trust
Where xxx.xxx.xxx.xxx is client's dynamically assigned IP address, I was
able to connect with Access, but pgAdmin still produced the same message
mentioned below in my first message.
Changing the last line to
host all xxx.xxx.xxx.xxx 255.255.255.255 password
gives the password authentication error in Access. In ODBC (on Win98
client side), I have username and password of the user that owns the
database I'm trying to access. Did I need to mention that the server is
running on OpenBSD?
Frank
At 12:03 AM 4/02/00 +0300, you wrote:
>Frank Bax wrote:
>>
>> Earlier this week I installed pgAdmin 6.5.5 and today upgraded to 7.0
>> I hope I installed all the components (for a Win98) install correctly.
>> The pg database is on a remote server, accessed across the internet.
>> I am new to this ODBC stuff, but the past few months have been using
>> psql and php3 interfaces (both local access) to 6.5.3 database.
>>
>> Anyway, I created a datasource in ODBC, but when I try to use it with
>> pgAdmin (either version), I get:
>> Error 3706, ADO could not find the specified provider.
>> function: frmODBClogon, cmdOK_Click.
>>
>> If I try to link to the same source with Access'97; I get this:
>> ODBC--call failed.
>> IDENT authentication failed for user 'gwacl' (#210).
>>
>> Are these both the same problem?
>
>probably.
>
>have you configured access from your client in pg_hba.conf to something
>like password (or possibly crypt). I doubt you have identd running on
>your ODBC client machine.
>
>-----------------
>Hannu
>
>
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-interfaces@postgresql.org
Cc: fbax@execulink.com
Subject: Re: pgAdmin problems
In-Reply-To: <3.0.6.32.20000401172926.008f74f0@execulink.com>
* 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