From: | "Ligia Pimentel" <lmpimentel(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Problem connecting from pgadmin: CACHE LOOKUP FOR USER XX FAILED |
Date: | 2001-04-29 16:24:41 |
Message-ID: | 9chiqq$20lv$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I created a database on a linux server and I configured it so that on
pg_hba.conf that the server wouldn't, validate passwords, but later I
changed the security to validate passwords. But after that, I haven't been
able to view table definitions or other tasks on pgadmin, except SQL Querys.
I can connect on ODBC connections an open and use the tables an databases.
What could I do?
Below is the log on PGADMIN.LOG.
Thank you for your help.
Ligia
Error Details
*************
Error Number: -2147467259
Error Description: Error while executing the query (non-fatal);
ERROR: cache lookup for userid 516 failed
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Subroutine of Function: frmTables, cmdRefresh_Click
System Details
**************
Operating System: Windows 98 v4.10 Build 2222
Additional Info: A
Environment Details
*******************
Application Path: C:\PROGRAM FILES\PGADMIN
Datasource: chequesdegerencia
Tracking: False
TrackVer: 0
Connect: Provider=MSDASQL.1;Extended
Properties="DSN=chequesdegerencia;DATABASE=chequesdegerencia;SERVER=s-inform
atica;PORT=5432;UID=lmpimentel;PWD=******;READONLY=0;PROTOCOL=6.4;FAKEOIDIND
EX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS="
MDAC Version: 2.6
DBMS Version: 07.01.0003 PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by
gcc egcs-2.91.66
From | Date | Subject | |
---|---|---|---|
Next Message | Anuradha Ratnaweera | 2001-04-29 16:36:38 | disable wal |
Previous Message | Anuradha Ratnaweera | 2001-04-28 12:42:37 | Re: Restoring a pg_dump fails with |