Thread: Erreur when testing connection

Erreur when testing connection

From

Pierre Couderc

Date:

29 January 2019, 01:57:45

Hi,

I have a problem on W7 (inside  a qemu/kvm vm) with last ANSI odbc 
driver (psqlodbc_11_00_0000-x86.zip) when trying  to connect to 
postgresql 11 (from buster debian package).

The db has been created but is empty.

I use the test button of psqlodbc_x86 with  odbcad32 (32bits version).

Sometimes the test successes, but most of the time, I get :

(...) could not send startup packet Connection reset by peer.

Thnks for any help

PC



Log here :

[2360-0.000]   mylog.c[logs_on_off]274: mylog_on=1 qlog_on=0
[2360-0.000]    start_logging:Global.debug&commlog=1&0
[2360-0.000]psqlodbc.c[DllMain]130: exe name=odbcad32
[2360-0.000]dlg_specif[CC_conninfo_init]1714: entering opt=2
[2360-0.000]   setup.c[ParseAttributes]618: aszKey='DSN', 
value='TOLfabDatabase'
[2360-0.000]dlg_specif[copyConnAttributes]777: key='DSN' 
value='TOLfabDatabase'
[2360-0.000]dlg_specif[CC_conninfo_init]1714: entering opt=3
[2360-0.000]dlg_specif[getDSNinfo]892: entering DSN=TOLfabDatabase 
driver=&PostgreSQL ANSI
[2360-0.000]dlg_specif[getCiDefaults]786: entering
[2360-0.000]dlg_specif[getDSNinfo]913: drivername=PostgreSQL ANSI
[2360-0.000]dlg_specif[getDriversDefaults]867: 003DAFA4 of the driver 
PostgreSQL ANSI
[2360-0.000]dlg_specif[get_Ci_Drivers]1430: comval=003DAFA4 
comval->extra_systable_prefixes = ''
[2360-0.000]dlg_specif[getDSNinfo]1064: force_abbrev=0 bde=0 cvt_null_date=0
[2360-0.000]dlg_specif[get_Ci_Drivers]1346: setting ODBC.INI position of 
TOLfabDatabase(003DAFA4)
[2360-0.000]dlg_specif[get_Ci_Drivers]1430: comval=003DAFA4 
comval->extra_systable_prefixes = ''
[2360-0.000]   setup.c[ParseAttributes]618: aszKey='DSN', 
value='TOLfabDatabase'
[2360-0.000]dlg_specif[copyConnAttributes]777: key='DSN' 
value='TOLfabDatabase'
[2360-3.198]dlg_specif[makeConnectString]295: makeConnectString 
row_versioning=0
[2360-3.198]   setup.c[test_connection]476: 
conn_string=DRIVER=PostgreSQL 

ANSI;DATABASE=tolfabdatabase;SERVER=192.168.163.65;PORT=;UID=;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;D6=-101;XaOpt=1
[2360-3.198]odbcapi30.[SQLAllocHandle]40: Entering
[2360-3.198] environ.c[PGAPI_AllocEnv]69: entering
[2360-3.198] environ.c[PGAPI_AllocEnv]88: leaving phenv=003C97A8
[2360-3.198]odbcapi30.[SQLSetEnvAttr]477: Entering att=200,3
[2360-3.198]odbcapi30.[SQLAllocHandle]40: Entering
[2360-3.198]connection[PGAPI_AllocConnect]87: entering...
[2360-3.198]connection[PGAPI_AllocConnect]90: **** henv = 003C97A8, conn 
= 003D36E8
[2360-3.198] environ.c[EN_add_connection]589: entering self = 003C97A8, 
conn = 003D36E8
[2360-3.198] environ.c[EN_add_connection]613:        added at 0, 
conn->henv = 003C97A8, conns[0]->henv = 003C97A8
[2360-3.198] odbcapi.c[SQLDriverConnect]209: Entering
[2360-3.198] drvconn.c[PGAPI_DriverConnect]119: entering...
[2360-3.198] drvconn.c[PGAPI_DriverConnect]130: **** 
fDriverCompletion=0, connStrIn='DRIVER=PostgreSQL 

ANSI;DATABASE=tolfabdatabase;SERVER=192.168.163.65;PORT=;UID=;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;D6=-101;XaOpt=1'
[2360-3.198]dlg_specif[CC_conninfo_init]1714: entering opt=2
[2360-3.198] drvconn.c[dconn_get_attributes]467: our_connect_string = 
'DRIVER=PostgreSQL 

ANSI;DATABASE=tolfabdatabase;SERVER=192.168.163.65;PORT=;UID=;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;D6=-101;XaOpt=1'
[2360-3.198]dlg_specif[getDSNinfo]892: entering DSN= driver=PostgreSQL 
ANSI&(null)
[2360-3.198]dlg_specif[getCiDefaults]786: entering
[2360-3.198]dlg_specif[getDSNinfo]913: drivername=PostgreSQL ANSI
[2360-3.198]dlg_specif[getDriversDefaults]867: 003D3EFC of the driver 
PostgreSQL ANSI
[2360-3.198]dlg_specif[get_Ci_Drivers]1430: comval=003D3EFC 
comval->extra_systable_prefixes = ''
[2360-3.198] drvconn.c[dconn_get_attributes]467: our_connect_string = 
'DRIVER=PostgreSQL 

ANSI;DATABASE=tolfabdatabase;SERVER=192.168.163.65;PORT=;UID=;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;D6=-101;XaOpt=1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='DRIVER' 
value='PostgreSQL ANSI'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='DATABASE' 
value='tolfabdatabase'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='SERVER' 
value='192.168.163.65'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='PORT' value=''
[2360-3.198]dlg_specif[copyConnAttributes]777: key='UID' value=''
[2360-3.198]dlg_specif[copyConnAttributes]606: key='PWD' value='xxxxxxxx'
[2360-3.198]dlg_specif[copyConnAttributes]709: key='SSLmode' 
value='disable' set to 'disable'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='ReadOnly' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='Protocol' value='7.4'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='FakeOidIndex' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='ShowOidColumn' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='RowVersioning' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='ShowSystemTables' 
value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='Fetch' value='100'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='UnknownSizes' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='MaxVarcharSize' 
value='255'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='MaxLongVarcharSize' 
value='8190'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='Debug' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='CommLog' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='UseDeclareFetch' 
value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='TextAsLongVarchar' 
value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: 
key='UnknownsAsLongVarchar' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='BoolsAsChar' value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='Parse' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: 
key='ExtraSysTablePrefixes' value=''
[2360-3.198]dlg_specif[copyConnAttributes]777: key='LFConversion' value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='UpdatableCursors' 
value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='TrueIsMinus1' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='BI' value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: 
key='ByteaAsLongVarBinary' value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: 
key='UseServerSidePrepare' value='1'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='LowerCaseIdentifier' 
value='0'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='D6' value='-101'
[2360-3.198]dlg_specif[copyConnAttributes]777: key='XaOpt' value='1'

Re: Erreur when testing connection

From

Pierre Couderc

Date:

30 January 2019, 10:50:02

On 1/28/19 11:57 PM, Pierre Couderc wrote:
> Hi,
>
> I have a problem on W7 (inside  a qemu/kvm vm) with last ANSI odbc 
> driver (psqlodbc_11_00_0000-x86.zip) when trying  to connect to 
> postgresql 11 (from buster debian package).
>
> The db has been created but is empty.
>
> I use the test button of psqlodbc_x86 with  odbcad32 (32bits version).
>
> Sometimes the test successes, but most of the time, I get :
>
> (...) could not send startup packet Connection reset by peer.
>
> Thnks for any help
>
>
May I get some help ?

Is the driver maintained ? I use old versions of it without problem in 
XP VM in qemu since years.

I use only postgresql software in this test, I cannot get help elsewere !

Re: Erreur when testing connection

From

Clemens Ladisch

Date:

30 January 2019, 10:53:08

Pierre Couderc wrote:
> (...) could not send startup packet Connection reset by peer.

This is likely to be caused by a firewall or virus scanner.


Regards,
Clemens

Re: Erreur when testing connection

From

Pierre Couderc

Date:

30 January 2019, 11:23:31

On 1/30/19 8:53 AM, Clemens Ladisch wrote:
> Pierre Couderc wrote:
>> (...) could not send startup packet Connection reset by peer.
> This is likely to be caused by a firewall or virus scanner.
>
>
> Regards,
> Clemens
>
Thank you very much, I search that.

Re: Erreur when testing connection

From

Pierre Couderc

Date:

30 January 2019, 12:08:54

On 1/30/19 8:53 AM, Clemens Ladisch wrote:
> Pierre Couderc wrote:
>> (...) could not send startup packet Connection reset by peer.
> This is likely to be caused by a firewall or virus scanner.
>
Mmm, no, it is something else : on an internal nework I have disabled 
firewall  and I have no virus scanner.

And the the connection works : if I change the database name to none, it 
declares "database does not exist".

Re: Erreur when testing connection

From

Pierre Couderc

Date:

31 January 2019, 10:54:28

On 1/30/19 8:53 AM, Clemens Ladisch wrote:
> Pierre Couderc wrote:
>> (...) could not send startup packet Connection reset by peer.
> This is likely to be caused by a firewall or virus scanner.
>
Well, it is certainly a default in my WM. I have tried on another one, 
and it seems fine. I do no more searching.

Thank you very much.

PC