Hi,
I develope an aplication with DBF file in delphi 3. I'm think that if I use
a server like postgreSQL the program was powerfull.
To try it I instala the suse 5.2 with Postgresql and I use it with psql.
Then I find the drivers for Win95 and I check how it work and I never can
connect with the database.
The message was something like:
ERROR from backend during authentication: 'Failed to authenticate client as
Postgres user 'prueba' using <unknown authentication type>: be_recvauth:
unrecognized message type: 65536
I have the file pg_hba.conf like this:
host all 0.0.0.0 0.0.0.0 trust
Have any idea about what I don't do?
P.D. The odbc driver create this log:
conn=62785660, SQLDriverConnect(
in)='DSN=PostgreSQL;UID=prueba;PWD=prueva;DATABASE=dbprueba;',
fDriverCompletion=0
DSN info:
DSN='PostgreSQL',server='192.168.1.2',port='5432',dbase='dbprueba',user='pru
eba',passwd='prueva'
readonly='1',protocol='',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
conn=62785660,
SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=dbprueba;SERVER=192.168.1.2;P
ORT=5432;UID=prueba;PWD=prueva;READONLY=1;PROTOCOL=;FAKEOIDINDEX=0;SHOWOIDCO
LUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
Global Options: fetch=100, socket=4096, unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=0, use_declarefetch=1
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
ERROR from backend during authentication: 'Failed to authenticate client as
Postgres user 'prueba' using <unknown authentication type>: be_recvauth:
unrecognized message type: 65536
'
CONN ERROR: func=SQLDriverConnect, desc='Error from CC_Connect', errnum=10,
errmsg='Failed to authenticate client as Postgres user 'prueba' using
<unknown authentication type>: be_recvauth: unrecognized message type:
65536
'
------------------------------------------------------------
henv=63832196, conn=62785660, status=0, num_stmts=16
sock=63832212, stmts=63832252, lobj_type=-999
---------------- Socket Info -------------------------------
socket=34, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=62791952, buffer_out=62796052
buffer_filled_in=141, buffer_filled_out=0, buffer_read_in=141
___________________________________________
KAOS on-line
Tlf: +34 93 274 50 90 Fax: +34 93 346 28 90
mailto:david@kaos.es http://www.kaos.es
____________________________________________