Re: Dave can you help ? - Mailing list pgadmin-support

-----Original Message-----
From: Doherty, Jim [mailto:Jim_Doherty@labs.sbc.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@labs.sbc.com
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

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

Jim, please use the mailing list for support in future: pgadmin-support@postgresql.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@labs.sbc.com]
Sent: 19 August 2003 15:00
To: 'dpage@pgadmin.org'
Subject: Dave can you help ?

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: james_doherty@labs.sbc.com
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