Re: Dave can you help ?

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Doherty, Jim" <Jim_Doherty(at)labs(dot)sbc(dot)com>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Dave can you help ?
Date: 2003-08-19 14:04:29
Message-ID: 03AF4E498C591348A42FC93DEA9661B844B4C8@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Jim, please use the mailing list for support in future:
pgadmin-support(at)postgresql(dot)org

My guess is that the port number 8889 or the server 'localhost' is
incorrect. The ODBC driver appears to be connecting to something, but
not PostgreSQL. As you are running a Redhat system, it seems unlikely
that pgAdmin II would be running on the same machine as your database
:-)

Regards, Dave.

-----Original Message-----
From: Doherty, Jim [mailto:Jim_Doherty(at)labs(dot)sbc(dot)com]
Sent: 19 August 2003 15:00
To: 'dpage(at)pgadmin(dot)org'
Subject: Dave can you help ?


conn=59783184, PGAPI_DriverConnect(
in)='DRIVER={PostgreSQL};UID=jmd;PWD=;SERVER=localhost;PORT=8889;DATABAS
E=template1;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVE
RSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOW
NSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;
USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHA
R=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=0;DEBUG
=0;', fDriverCompletion=0
Global Options: Version='07.03.0100', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=0, max_longvarchar_size=0
disable_optimizer=0, ksqo=0, unique_index=0,
use_declarefetch=0
text_as_longvarchar=0,
unknowns_as_longvarchar=0, bools_as_char=0 NAMEDATALEN=64
extra_systable_prefixes='', conn_settings=''
conn_encoding='OTHER'
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from
CC_Connect', errnum=210, errmsg='Unexpected protocol character during
authentication'

Dave any idea what is going on here ? I have never seen this
error before. I am running Linux V9 (redhat) and

postgres V7.3. I keep getting this error and cannot connect.
When I connect to my Linux V7.2 maching and

postgres V7.2 all works just fine.

Jim Doherty
An IRISH Proverb
"There is no success without discipline"
Phil 3: 13 - 15 ("Press On")

Office: 512-372-5443 Fax: 512-241-5443
EMAIL: james_doherty(at)labs(dot)sbc(dot)com
Principal Member Technical Staff <mailto:jim_doherty(at)email(dot)com>
SBC Laboratories, Inc.

This e-mail and any files transmitted with it are the property
of SBC, are confidential, and are intended solely for the use of the
individual or entity to whom this e-mail is addressed. If you are not
one of the named recipient(s) or otherwise have reason to believe that
you have received this message in error, please notify the sender at 512
372-5443 and delete this message immediately from your computer

Browse pgadmin-support by date

  From Date Subject
Next Message Doherty, Jim 2003-08-19 14:13:31 Unexpected protocol character during authentication
Previous Message Doherty, Jim 2003-08-19 14:02:37 errmsg='Unexpected protocol character during authentication'