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.
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: [EMAIL PROTECTED]
Principal Member Technical
Staff 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
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.
conn=59783184, PGAPI_DriverConnect(
in)='DRIVER={PostgreSQL};UID=jmd;PWD=;SERVER=localhost;PORT=8889;DATABASE=template1;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=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: [EMAIL PROTECTED]
Principal Member Technical
Staff 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
|