Re: Dave can you help ?

Hi Jim,

If you telnet to the local end of the tunnel and hit return a couple of
times what do you see? It should be something like:

EFATAL: invalid length of startup packet

Connection to host lost.

Regards, Dave.

-----Original Message-----
From: Doherty, Jim [mailto:Jim_Doherty(at)labs(dot)sbc(dot)com]
Sent: 19 August 2003 15:25
To: Dave Page
Subject: RE: Dave can you help ?


Dave,

Ok I have subscribed to both lists as you indicated. I should
have told you that the localhost 8889 is an
ssh tunnel which is port forwarded to remotehost:5432. The
client is w2k professional with odbc driver
V7.3.1

Jim

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

-----Original Message-----
From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Sent: Tuesday, August 19, 2003 9:04 AM
To: Doherty, Jim
Cc: pgadmin-support(at)postgresql(dot)org
Subject: RE: Dave can you help ?


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