pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpgAdmin problems
8+ messages / 4 participants
[nested] [flat]
* pgAdmin problems
@ 2000-04-01 20:27 Frank Bax <fbax@execulink.com>
0 siblings, 2 replies; 8+ messages in thread
From: Frank Bax @ 2000-04-01 20:27 UTC (permalink / raw)
To: pgsql-interfaces
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?
Frank
PS: The start-menu shortcut's created by pgAdmin install don't point to
anything!
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pgAdmin problems
@ 2000-04-01 21:03 Hannu Krosing <hannu@tm.ee>
parent: Frank Bax <fbax@execulink.com>
1 sibling, 0 replies; 8+ messages in thread
From: Hannu Krosing @ 2000-04-01 21:03 UTC (permalink / raw)
To: Frank Bax <fbax@execulink.com>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pgAdmin problems
@ 2000-04-01 22:29 Frank Bax <fbax@execulink.com>
parent: Frank Bax <fbax@execulink.com>
1 sibling, 0 replies; 8+ messages in thread
From: Frank Bax @ 2000-04-01 22:29 UTC (permalink / raw)
To: pgsql-interfaces
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
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: pgAdmin problems
@ 2000-04-03 08:17 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 8+ messages in thread
From: Dave Page @ 2000-04-03 08:17 UTC (permalink / raw)
To: pgsql-interfaces
> -----Original Message-----
> From: Frank Bax [mailto:fbax@execulink.com]
> Sent: 01 April 2000 20:27
> To: pgsql-interfaces@postgresql.org
> Subject: [INTERFACES] pgAdmin problems
>
>
> 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.
Make sure you have an up-to-date version of MDAC installed. You can get it
from http://www.microsoft.com/data/mdac2.htm.
>
> PS: The start-menu shortcut's created by pgAdmin install
> don't point to
> anything!
Yes they do, but they are not regular shortcuts. They point to hidden
'launcher' executables that run pgAdmin for you. They also deal with
'install on first use' and application advertising which are new Win2K
things (though aren't used by pgAdmin yet).
Regards,
Dave.
--
"I find an axe is the most satisfying, but really any good weapon will do."
- Sacha Roscoe, explaining basic systems administration.
http://www.vale-housing.co.uk/ (Work)
http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)
^ permalink raw reply [nested|flat] 8+ messages in thread
* pgAdmin problems
@ 2000-11-28 07:58 Bryan Bateman <batemanb@home.com>
0 siblings, 0 replies; 8+ messages in thread
From: Bryan Bateman @ 2000-11-28 07:58 UTC (permalink / raw)
To: pgsql-interfaces
I have sucessfully installed postgres on a Linux machine. I can us
phpPgAdmin running under Apache on the linux machine to manipulate the
database. I have created a DSN on a Win2K box and can link through it to
the database on the linux box.
I then start up PgAdmin to connect through the same DSN and get the
following error in the log file:
**********************************************************************
* Error - 11/28/2000 7:37:01 AM
**********************************************************************
Software
********
Program: pgAdmin
Version: 7.0.3
Sub or Function: frmMain, MDIForm_Load
Error Details
*************
Error No: 3021
Error Description: Either BOF or EOF is True, or the current record has been
deleted. Requested operation requires a current record.
Error Source: ADODB.Field
DLL Error Code: 0
Memory Details
**************
Total Physical: 267948032
Total Swap: 647651328
Total Virtual: 2147352576
Available Physical: 87109632
Available Swap: 461381632
Available Virtual: 2073526272
Percentage Free: 67
System Details
**************
Processor: 586
OEM ID: 0
No. Processors: 2
Page Size: 4096
OS Details
**********
Platform: Windows NT
Version: 5.0
Build: 2195
OS Info: Service Pack 1
Any ideas????????
What am I doing wrong???
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: pgAdmin problems
@ 2000-11-28 13:19 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 1 reply; 8+ messages in thread
From: Dave Page @ 2000-11-28 13:19 UTC (permalink / raw)
To: 'Bryan Bateman' <batemanb@home.com>; pgsql-interfaces
> -----Original Message-----
> From: Bryan Bateman [mailto:batemanb@home.com]
> Sent: 28 November 2000 07:59
> To: pgsql-interfaces@postgresql.org
> Subject: [INTERFACES] pgAdmin problems
>
>
> I have sucessfully installed postgres on a Linux machine. I can us
> phpPgAdmin running under Apache on the linux machine to manipulate the
> database. I have created a DSN on a Win2K box and can link
> through it to
> the database on the linux box.
>
> I then start up PgAdmin to connect through the same DSN and get the
> following error in the log file:
<SNIP>
This error is caused by records being missing from the pgadmin_param system
table. It should self-repair itself, however in some circumstances it may
not. To fix it manually (assuming you don't use revision tracking - if so,
please let me know your current version number) execute the following SQL
queries in an SQL dialogue:
DELETE FROM pgadmin_param
INSERT INTO pgadmin_param VALUES ('1', '1', 'SSO Version')
INSERT INTO pgadmin_param VALUES(2, 'N', 'Revision Tracking enabled?')
INSERT INTO pgadmin_param VALUES(3, '1.0', 'Revision Tracking version')
This bug has been fixed in the current development code.
Regards,
Dave.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pgAdmin problems
@ 2000-11-28 13:57 Bryan Bateman <batemanb@home.com>
parent: Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 8+ messages in thread
From: Bryan Bateman @ 2000-11-28 13:57 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; pgsql-interfaces
Almost there.
The inserts below worked like a charm.
I have one more problem and I know it is my lack of experience with
Postgresql. I have scanned the doucumentaion and can not figure this one
out. I have attached one more log file entry with the username and password
altered to protect the innocent (me). I got this error when trying to
execute system/users from the menu. When I created the user in question, I
gave it permission to create tables and new users. I then did an alter user
to assign a password.
Is there anything else I need to do to the user configuration to make it
work????
Thanks in advance.
Bryan
>
> > I have sucessfully installed postgres on a Linux machine. I can us
> > phpPgAdmin running under Apache on the linux machine to manipulate the
> > database. I have created a DSN on a Win2K box and can link
> > through it to
> > the database on the linux box.
> >
> > I then start up PgAdmin to connect through the same DSN and get the
> > following error in the log file:
>
> <SNIP>
>
> This error is caused by records being missing from the pgadmin_param
system
> table. It should self-repair itself, however in some circumstances it may
> not. To fix it manually (assuming you don't use revision tracking - if so,
> please let me know your current version number) execute the following SQL
> queries in an SQL dialogue:
>
> DELETE FROM pgadmin_param
> INSERT INTO pgadmin_param VALUES ('1', '1', 'SSO Version')
> INSERT INTO pgadmin_param VALUES(2, 'N', 'Revision Tracking enabled?')
> INSERT INTO pgadmin_param VALUES(3, '1.0', 'Revision Tracking version')
>
> This bug has been fixed in the current development code.
>
> Regards,
> Dave.
**********************************************************************
* Error - 11/28/2000 1:35:23 PM
**********************************************************************
Software
********
Program: pgAdmin
Version: 7.0.3
Sub or Function: frmUsers, cmdRefresh_click
Error Details
*************
Error No: -2147467259
Error Description: Error while executing the query;
ERROR: pg_shadow: Permission denied.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
DLL Error Code: 0
Memory Details
**************
Total Physical: 267948032
Total Swap: 647651328
Total Virtual: 2147352576
Available Physical: 76840960
Available Swap: 447901696
Available Virtual: 2069299200
Percentage Free: 71
System Details
**************
Processor: 586
OEM ID: 0
No. Processors: 2
Page Size: 4096
OS Details
**********
Platform: Windows NT
Version: 5.0
Build: 2195
OS Info: Service Pack 1
Environment Details
*******************
Datasource: remote
Tracking: False
TrackVer: 0
Connect: Provider=MSDASQL.1;Extended
Properties="DSN=remote;DATABASE=mydb;SERVER=widget;PORT=5432;UID=theuser;PWD
=thepassword;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=1;SHOWOIDCOLUMN=1;ROWVERSI
ONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS="
Version: 2.5
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: pgAdmin problems
@ 2000-11-29 08:28 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 8+ messages in thread
From: Dave Page @ 2000-11-29 08:28 UTC (permalink / raw)
To: 'Bryan Bateman' <batemanb@home.com>; pgsql-interfaces
> -----Original Message-----
> From: Bryan Bateman [mailto:batemanb@home.com]
> Sent: 28 November 2000 13:57
> To: Dave Page; pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] pgAdmin problems
>
>
> Almost there.
>
> The inserts below worked like a charm.
>
> I have one more problem and I know it is my lack of experience with
> Postgresql. I have scanned the doucumentaion and can not
> figure this one
> out. I have attached one more log file entry with the
> username and password
> altered to protect the innocent (me). I got this error when trying to
> execute system/users from the menu. When I created the user
> in question, I
> gave it permission to create tables and new users. I then
> did an alter user
> to assign a password.
>
> Is there anything else I need to do to the user configuration
> to make it
> work????
You need to logged into a superuser account - often this would be
'postgres'. Unfortunately this will still not work in PostgreSQL 7.0.X as
there was a change to the backend which prevented the execution of certain
queries within a transaction block which is alway the case via ODBC. This
has been fixed in the the current development code for PostgreSQL for USER
and VACUUM queries but CREATE/DROP DATABASE queries still seem to suffer the
same problem.
Regards,
Dave.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2000-11-29 08:28 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-01 20:27 pgAdmin problems Frank Bax <fbax@execulink.com>
2000-04-01 21:03 ` Hannu Krosing <hannu@tm.ee>
2000-04-01 22:29 ` Frank Bax <fbax@execulink.com>
2000-04-03 08:17 RE: pgAdmin problems Dave Page <dpage@vale-housing.co.uk>
2000-11-28 07:58 pgAdmin problems Bryan Bateman <batemanb@home.com>
2000-11-28 13:19 RE: pgAdmin problems Dave Page <dpage@vale-housing.co.uk>
2000-11-28 13:57 ` Bryan Bateman <batemanb@home.com>
2000-11-29 08:28 RE: pgAdmin problems Dave Page <dpage@vale-housing.co.uk>
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