problema sql
raul garcia_quintana
ragal@hotmail.com
Tue, 08 Sep 1998 18:39:34 PDT
Perdona, has intentado inicializar el servidor con la opcion -I para que
trabaje por tcp-ip
>From pgsql-ayuda-owner@tlali.iztacala.unam.mx Tue Sep 8 11:27:55 1998
>Received: (from majordom@localhost)
> by tlali.iztacala.unam.mx (8.8.7/8.8.7) id LAA28172
> for pgsql-ayuda-outgoing; Tue, 8 Sep 1998 11:03:37 -0500
>X-Authentication-Warning: tlali.iztacala.unam.mx: majordom set sender
to owner-pgsql-ayuda using -f
>Received: from campus.iztacala.unam.mx (campus [132.248.79.80])
> by tlali.iztacala.unam.mx (8.8.7/8.8.7) with SMTP id LAA28168
> for <pgsql-ayuda@tlali>; Tue, 8 Sep 1998 11:03:36 -0500
>Received: from mx.kaos.es by campus.iztacala.unam.mx (SMI-8.6/SMI-SVR4)
> id LAA13955; Tue, 8 Sep 1998 11:07:15 -0600
>Received: from proxy.kaos.es (proxy.kaos.es [195.77.82.8]) by
mx.kaos.es (NTMail 3.03.0014/4c.adon) with ESMTP id aa290004 for
<pgsql-ayuda@campus.iztacala.unam.mx>; Tue, 8 Sep 1998 18:04:30 +0200
>Message-ID: <00d301bddb42$583c1920$0b01a8c0@david.kaos.es>
>From: "david toribio" <david@kaos.es>
>To: <pgsql-ayuda@campus.iztacala.unam.mx>
>Subject: problema sql
>Date: Tue, 8 Sep 1998 18:04:22 +0200
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Mailer: Microsoft Outlook Express 4.72.3110.5
>X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
>Sender: owner-pgsql-ayuda@tlali.iztacala.unam.mx
>Precedence: bulk
>Reply-To: pgsql-ayuda@tlali.iztacala.unam.mx
>Content-Transfer-Encoding: quoted-printable
>X-MIME-Autoconverted: from 8bit to quoted-printable by
tlali.iztacala.unam.mx id LAB28172
>
>Hola,
>
>He desarrollado una aplicaci=F3n en delphi para win95 basado en
archivos =
>dbf,
>para hacerla algo mas potente y rapida he pensado cambiar la base de
dato=
>s
>por un servidor como postgresql.
>
>Para ello he instalado suse 5.2 y el postgresql que trae de serie. con
el
>psql que trae me ha funcionado bien pero desde win95 no he logrado
>conectarme a la base de datos.
>
>El mensaje que me da es algo asi como:
>
>ERROR from backend during authentication: 'Failed to authenticate
client =
>as
>Postgres user 'prueba' using <unknown authentication type>:
be_recvauth:
>unrecognized message type: 65536
>
>El fichero pg_hba.conf:
>host all 0.0.0.0 0.0.0.0 trust
>
>
>=BFalguien tiene alguna idea de que es lo que hago mal?
>
>
>P.D. El driver odbc que uso me crea el siguiente fichero
>
>
>conn=3D62785660, SQLDriverConnect(
>in)=3D'DSN=3DPostgreSQL;UID=3Dprueba;PWD=3Dprueva;DATABASE=3Ddbprueba;',
>fDriverCompletion=3D0
>DSN info:
>DSN=3D'PostgreSQL',server=3D'192.168.1.2',port=3D'5432',dbase=3D'dbprueba=
>',user=3D'pru
>eba',passwd=3D'prueva'
>
>readonly=3D'1',protocol=3D'',showoid=3D'0',fakeoidindex=3D'0',showsystabl=
>e=3D'0'
> conn_settings=3D''
> translation_dll=3D'',translation_option=3D''
>conn=3D62785660,
>SQLDriverConnect(out)=3D'DSN=3DPostgreSQL;DATABASE=3Ddbprueba;SERVER=3D19=
>2.168.1.2;P
>ORT=3D5432;UID=3Dprueba;PWD=3Dprueva;READONLY=3D1;PROTOCOL=3D;FAKEOIDINDE=
>X=3D0;SHOWOIDCO
>LUMN=3D0;ROWVERSIONING=3D0;SHOWSYSTEMTABLES=3D0;CONNSETTINGS=3D'
>Global Options: fetch=3D100, socket=3D4096, unknown_sizes=3D0,
>max_varchar_size=3D254, max_longvarchar_size=3D4094
> disable_optimizer=3D1, unique_index=3D0,
use_declarefetch=
>=3D1
> text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0,
>bools_as_char=3D1
> extra_systable_prefixes=3D'dd_;', conn_settings=3D''
>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=3DSQLDriverConnect, desc=3D'Error from CC_Connect',
errn=
>um=3D10,
>errmsg=3D'Failed to authenticate client as Postgres user 'prueba' using
><unknown authentication type>: be_recvauth: unrecognized message type:
>65536
>'
>
------------------------------------------------------------
> henv=3D63832196, conn=3D62785660, status=3D0,
num_stmts=3D16
> sock=3D63832212, stmts=3D63832252, lobj_type=3D-999
> ---------------- Socket Info
-------------------------------
> socket=3D34, reverse=3D0, errornumber=3D0,
errormsg=3D'(null)=
>'
> buffer_in=3D62791952, buffer_out=3D62796052
> buffer_filled_in=3D141, buffer_filled_out=3D0,
buffer_read_in=
>=3D141
>
>
>___________________________________________
>KAOS on-line
>Tlf: +34 93 274 50 90 Fax: +34 93 346 28 90
>mailto:david@kaos.es http://www.kaos.es
>____________________________________________
>
>
>
>
>
>--------- Pie de mensaje -------------------------------------------
>Archivo historico: http://tlali.iztacala.unam.mx/maillist/pgsql-ayuda
>Cancelar inscripcion:
>mail to: majordomo@tlali.iztacala.unam.mx
>text : cancelacion pgsql-ayuda
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
--------- Pie de mensaje -------------------------------------------
Archivo historico: http://tlali.iztacala.unam.mx/maillist/pgsql-ayuda
Cancelar inscripcion:
mail to: majordomo@tlali.iztacala.unam.mx
text : cancelacion pgsql-ayuda