Skip site navigation (1) Skip section navigation (2)

Re: problema sql

From: "raul garcia_quintana" <ragal(at)hotmail(dot)com>
To: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
Subject: Re: problema sql
Date: 1998-09-08 18:39:34
Message-ID: 19980909013937.26092.qmail@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Perdona, has intentado inicializar el servidor con la opcion -I para que 
trabaje por tcp-ip

>From pgsql-ayuda-owner(at)tlali(dot)iztacala(dot)unam(dot)mx Tue Sep  8 11:27:55 1998
>Received: (from majordom(at)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(at)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(at)campus(dot)iztacala(dot)unam(dot)mx>; Tue, 8 Sep 1998 18:04:30 +0200
>Message-ID: <00d301bddb42$583c1920$0b01a8c0(at)david(dot)kaos(dot)es>
From: "david toribio" <david(at)kaos(dot)es>
>To: <pgsql-ayuda(at)campus(dot)iztacala(dot)unam(dot)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(at)tlali(dot)iztacala(dot)unam(dot)mx
>Precedence: bulk
>Reply-To: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)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(at)kaos(dot)es                  http://www.kaos.es
>____________________________________________
>
>
>
>
>
>--------- Pie de mensaje -------------------------------------------
>Archivo historico: http://tlali.iztacala.unam.mx/maillist/pgsql-ayuda
>Cancelar inscripcion:
>mail to: majordomo(at)tlali(dot)iztacala(dot)unam(dot)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(at)tlali(dot)iztacala(dot)unam(dot)mx
text   : cancelacion pgsql-ayuda

pgsql-es-ayuda by date

Next:From: Carlos Costa PortelaDate: 1998-09-09 12:46:19
Subject: Re: problema sql
Previous:From: david toribioDate: 1998-09-08 16:04:22
Subject: problema sql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group