unexpected protocol charactor during authentication - Mailing list pgsql-cygwin

From Nyo Maw
Subject unexpected protocol charactor during authentication
Date
Msg-id 20030302084512.83875.qmail@web14707.mail.yahoo.com
Whole thread Raw
List pgsql-cygwin
Hi

I have installed PeerDirect native Windows port of
PostgreSQL 7.2.1 on Windows XP professional. I have
set Env variables according to installation
instruction.
I can execute initdb successfully.
I can install the post_svc and I can run postmaster
successfully.

But when I tried to connect database,
psql template1
psql: server closed the connection unexpectedly
        This probably means the server terminated
abnormally
        before or while processing the request.

In Server Log:
DEBUG:  database system was shut down at 2003-03-02
00:30:12 Pacific Stan
DEBUG:  checkpoint record is in
pg_xlog/0000000000000000 at offset 2184924
DEBUG:  redo record is at 0/2156DC; undo record is at
0/0; shutdown TRUE
DEBUG:  next transaction id: 541; next oid: 16557
DEBUG:  database system is ready
FATAL 1:  getpeername() failed

When I tried to create new db (createdb), create new
user ( createuser )  I got the exactly the same error,
the same message in Server Log "FATAL 1:
getpeername() failed".



When I tried to connect with pgAdmin II, I got the
error saying that "unexpected protocol charactor
during authentication". On Server Log it shows the
same message " FATAL 1:  getpeername() failed".

In pgAdminII log file, I can see as follows:

2003-03-02 00:33:11 - Entering pgAdmin
II:frmMain.tb_ButtonClick()
2003-03-02 00:33:11 - Entering pgAdmin
II:frmMain.mnuPopupConnect_Click()
2003-03-02 00:33:11 - Entering pgAdmin
II:frmConnect.Load_Defaults(0)
2003-03-02 00:33:11 - Entering pgAdmin
II:basRegistry.RegRead(-2147483647, "Software\pgAdmin
II\Connections", "Connection 1")
2003-03-02 00:33:16 - Entering pgAdmin
II:frmConnect.cmdConnect_Click()
2003-03-02 00:33:16 - Connecting to localhost...
2003-03-02 00:33:16 - Entering pgAdmin
II:basRegistry.RegRead(-2147483647, "Software\pgAdmin
II", "Master DB")
2003-03-02 00:33:16 - Entering
pgSchema:pgServer.Property Let MasterDB("template1")
2003-03-02 00:33:16 - Entering
pgSchema:pgServer.Connect("localhost", 5432, "pauk",
"********")
2003-03-02 00:33:16 - Opening cnPostgreSQL:

SERVER=localhost;PORT=5432;UID=pauk;PWD=********;DATABASE=template1;DRIVER={PostgreSQL};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=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
2003-03-02 00:33:17 - Done - 0.36 Secs.

2003-03-02 00:33:17 -
*******************************************************************
2003-03-02 00:33:17 - Error(s)
2003-03-02 00:33:17 -
*******************************************************************
2003-03-02 00:33:17 - Error in pgAdmin
II:frmConnect.cmdConnect_Click: -2147217843 -
Unexpected protocol character during authentication;
Error while reading from the socket.

2003-03-02 00:33:17 - Windows Version: Windows XP v5.1
build 2600 Service Pack 1
2003-03-02 00:33:17 - pgSchema Version: 1.4.12
2003-03-02 00:33:17 - MDAC Version: 2.7
2003-03-02 00:33:17 - cnPostgreSQL.State =
adStateClosed


In mylog log file, ( I cannot paste the special
character ( a rectangle ) between single quote from
the line [516]auth got '' )

[516]CC_connect: entering...
[516]CC_connect(): DSN = '', server = 'localhost',
port = '5432', database = 'template1', username =
'pauk', password=''
[516]connecting to the server socket...
[516]connection to the server socket succeeded.
[516]sizeof startup packet = 292
[516]sent the authentication block.
[516]sent the authentication block successfully.
[516]gonna do authentication
[516]read -1, global_socket_buffersize=4096
[516]auth got ''
[516]CONN ERROR: func=PGAPI_DriverConnect, desc='Error
from CC_Connect', errnum=210, errmsg='Unexpected
protocol character during authentication'
[516][SQLError][516]**** PGAPI_Error: henv=0,
hdbc=16530904 hstmt=0
[516]**** PGAPI_ConnectError: hdbc=16530904 <512>
[516]enter CC_get_error
[516]enter CC_create_errormsg
[516]msg = 'Unexpected protocol character during
authentication'
[516]exit CC_create_errormsg
[516]exit CC_get_error
[516]CC_get_error: status = 210, msg = #Unexpected
protocol character during authentication;
Error while reading from the socket.#
[516]         szSqlState = '28000',len=89,
szError='Unexpected protocol character during
authentication;
Error while reading from the socket.'
[516]**** PGAPI_Error exit code=0
[516][SQLError][516]**** PGAPI_Error: henv=0,
hdbc=16530904 hstmt=0
[516]**** PGAPI_ConnectError: hdbc=16530904 <512>
[516]enter CC_get_error
[516]exit CC_get_error
[516]CC_Get_error returned nothing.
[516]**** PGAPI_Error exit code=100
[516][SQLError][516]**** PGAPI_Error: henv=0,
hdbc=16530904 hstmt=0
[516]**** PGAPI_ConnectError: hdbc=16530904 <512>
[516]enter CC_get_error
[516]exit CC_get_error
[516]CC_Get_error returned nothing.
[516]**** PGAPI_Error exit code=100
[516][SQLFreeConnect][516]PGAPI_FreeConnect:
entering...
[516]**** in PGAPI_FreeConnect: hdbc=16530904
[516]enter CC_Destructor, self=16530904
[516]in CC_Cleanup, self=16530904
[516]after CC_abort
[516]SOCK_Destructor
[516]after SOCK destructor
[516]exit CC_Cleanup
[516]after CC_Cleanup
[516]after free statement holders
[516]exit CC_Destructor
[516]PGAPI_FreeConnect: returning...
[516][SQLFreeEnv][516]**** in PGAPI_FreeEnv: env =
16530848 **
[516]in EN_Destructor, self=16530848
[516]exit EN_Destructor: rv = 1
[516]   ok

Can somebody can help me to fix this problem ? Am I
doing something wrong ?

Thanks
Nyo




__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

pgsql-cygwin by date:

Previous
From: Mary-Catherine Gerrey
Date:
Subject: Postmaster Service Fails
Next
From: "Agrawal, Manish"
Date:
Subject: rule question