Home > mailing lists

Thread: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

From

Joao Augusto Lima Ferreira

Date:

05 September 2018, 23:01:16

Dear,

First of all, thank you for your attention.

I have the following packages installed in my Linux OS Centos 3.10.0-514.el7.x86_64:

postgresql-libs-9.2.23-3.el7_4.x86_64

postgresql-odbc-09.03.0100-2.el7.x86_6

I already have a PostgreSQL ODBC connection configured and functional, but when trying to create the new connection below and use the Isql utility to perform a test I am getting the error below, I did not find much about it, would you like to know how to proceed in this case?

follows the odbc.ini conf:

[BHIP_PGSQL]

Driver=/usr/lib64/psqlodbcw.so

Description = Banco de dados BHIP

Database = xxx_xxx

Servername = xxx.xxx.xxx.xx

Port = 5432

DriverUnicodeType = 1

follows the Isql execution:

[pcenter@pcenterdev ~]$ isql -v BHIP_PGSQL user ****************

[28000][unixODBC]Communication closed during authentication;

Connection reset by peer.

[ISQL]ERROR: Could not SQLConnect

follows the execution trace:

[ODBC][6121][1536176591.163931][__handles.c][460]

Exit:[SQL_SUCCESS]

Environment = 0x1e11780

[ODBC][6121][1536176591.164096][SQLAllocHandle.c][375]

Entry:

Handle Type = 2

Input Handle = 0x1e11780

[ODBC][6121][1536176591.164158][SQLAllocHandle.c][493]

Exit:[SQL_SUCCESS]

Output Handle = 0x1e12080

[ODBC][6121][1536176591.164220][SQLConnect.c][3700]

Entry:

Connection = 0x1e12080

Server Name = [BHIP_PGSQL][length = 10 (SQL_NTS)]

User Name = [user][length = 4 (SQL_NTS)]

Authentication = [****************][length = 16 (SQL_NTS)]

UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

DIAG [28000] Communication closed during authentication;

Connection reset by peer.

[ODBC][6121][1536176591.321348][SQLConnect.c][4067]

Exit:[SQL_ERROR]

[ODBC][6121][1536176591.321419][SQLError.c][434]

Entry:

Connection = 0x1e12080

SQLState = 0x7ffc89f63280

Native = 0x7ffc89f6327c

Message Text = 0x7ffc89f63290

Buffer Length = 500

Text Len Ptr = 0x7ffc89f6327a

[ODBC][6121][1536176591.321471][SQLError.c][471]

Exit:[SQL_SUCCESS]

SQLState = 28000

Native = 0x7ffc89f6327c -> 210

Message Text = [[unixODBC]Communication closed during authentication;

Connection reset by peer.]

[ODBC][6121][1536176591.321549][SQLError.c][434]

Entry:

Connection = 0x1e12080

SQLState = 0x7ffc89f63280

Native = 0x7ffc89f6327c

Message Text = 0x7ffc89f63290

Buffer Length = 500

Text Len Ptr = 0x7ffc89f6327a

[ODBC][6121][1536176591.321588][SQLError.c][471]

Exit:[SQL_NO_DATA]

[ODBC][6121][1536176591.321629][SQLError.c][514]

Entry:

Environment = 0x1e11780

SQLState = 0x7ffc89f63280

Native = 0x7ffc89f6327c

Message Text = 0x7ffc89f63290

Buffer Length = 500

Text Len Ptr = 0x7ffc89f6327a

[ODBC][6121][1536176591.321669][SQLError.c][551]

Exit:[SQL_NO_DATA]

[ODBC][6121][1536176591.321738][SQLFreeHandle.c][284]

Entry:

Handle Type = 2

Input Handle = 0x1e12080

[ODBC][6121][1536176591.321782][SQLFreeHandle.c][333]

Exit:[SQL_SUCCESS]

[ODBC][6121][1536176591.321824][SQLFreeHandle.c][219]

Entry:

Handle Type = 1

Input Handle = 0x1e11780

system.out.println("Atenciosamente");

João Ferreira - Gerência de Engenharia e Processo de Software - GPAS-PB - Prodabel

PRODABEL | Av. Presidente Carlos Luz,1275

joaof@pbh.gov.br / (31) 3277-7114

Re: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

From

"Inoue, Hiroshi"

Date:

07 September 2018, 03:22:19

Hi Joao,

On 2018/09/06 5:01, Joao Augusto Lima Ferreira wrote:

Dear,

First of all, thank you for your attention.

I have the following packages installed in my Linux OS Centos 3.10.0-514.el7.x86_64:

postgresql-libs-9.2.23-3.el7_4.x86_64
postgresql-odbc-09.03.0100-2.el7.x86_6

I already have a PostgreSQL ODBC connection configured and functional, but when trying to create the new connection below and use the Isql utility to perform a test I am getting the error below, I did not find much about it, would you like to know how to proceed in this case?

follows the odbc.ini conf:

[BHIP_PGSQL]
Driver=/usr/lib64/psqlodbcw.so

What is the output of "ldd -r path_to_isql" and
the output of "ldd -r /usr/lib64/psqlodbcw.so"?

regards,
Hiroshi Inoue

Description = Banco de dados BHIP
Database = xxx_xxx
Servername = xxx.xxx.xxx.xx
Port = 5432
DriverUnicodeType = 1

follows the Isql execution:

[pcenter@pcenterdev ~]$ isql -v BHIP_PGSQL user ****************
[28000][unixODBC]Communication closed during authentication;
Connection reset by peer.
[ISQL]ERROR: Could not SQLConnect

follows the execution trace:

[ODBC][6121][1536176591.163931][__handles.c][460]
Exit:[SQL_SUCCESS]
Environment = 0x1e11780
[ODBC][6121][1536176591.164096][SQLAllocHandle.c][375]
Entry:
Handle Type = 2
Input Handle = 0x1e11780
[ODBC][6121][1536176591.164158][SQLAllocHandle.c][493]
Exit:[SQL_SUCCESS]
Output Handle = 0x1e12080
[ODBC][6121][1536176591.164220][SQLConnect.c][3700]
Entry:
Connection = 0x1e12080
Server Name = [BHIP_PGSQL][length = 10 (SQL_NTS)]
User Name = [user][length = 4 (SQL_NTS)]
Authentication = [****************][length = 16 (SQL_NTS)]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

DIAG [28000] Communication closed during authentication;
Connection reset by peer.

[ODBC][6121][1536176591.321348][SQLConnect.c][4067]
Exit:[SQL_ERROR]
[ODBC][6121][1536176591.321419][SQLError.c][434]
Entry:
Connection = 0x1e12080
SQLState = 0x7ffc89f63280
Native = 0x7ffc89f6327c
Message Text = 0x7ffc89f63290
Buffer Length = 500
Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321471][SQLError.c][471]
Exit:[SQL_SUCCESS]
SQLState = 28000
Native = 0x7ffc89f6327c -> 210
Message Text = [[unixODBC]Communication closed during authentication;
Connection reset by peer.]
[ODBC][6121][1536176591.321549][SQLError.c][434]
Entry:
Connection = 0x1e12080
SQLState = 0x7ffc89f63280
Native = 0x7ffc89f6327c
Message Text = 0x7ffc89f63290
Buffer Length = 500
Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321588][SQLError.c][471]
Exit:[SQL_NO_DATA]
[ODBC][6121][1536176591.321629][SQLError.c][514]
Entry:
Environment = 0x1e11780
SQLState = 0x7ffc89f63280
Native = 0x7ffc89f6327c
Message Text = 0x7ffc89f63290
Buffer Length = 500
Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321669][SQLError.c][551]
Exit:[SQL_NO_DATA]
[ODBC][6121][1536176591.321738][SQLFreeHandle.c][284]
Entry:
Handle Type = 2
Input Handle = 0x1e12080
[ODBC][6121][1536176591.321782][SQLFreeHandle.c][333]
Exit:[SQL_SUCCESS]
[ODBC][6121][1536176591.321824][SQLFreeHandle.c][219]
Entry:
Handle Type = 1
Input Handle = 0x1e11780

system.out.println("Atenciosamente");

--
João Ferreira - Gerência de Engenharia e Processo de Software - GPAS-PB - Prodabel
PRODABEL | Av. Presidente Carlos Luz,1275
joaof@pbh.gov.br / (31) 3277-7114

ウイルスフリー｡ www.avg.com

Re: UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

From

Joao Augusto Lima Ferreira

Date:

10 September 2018, 15:31:06

Hello, Hiroshi.

follow exits:

[root@pcenterdev ~]# ldd -r /usr/lib64/psqlodbcw.so

linux-vdso.so.1 => (0x00007fffa99f7000)

libssl.so.10 => /lib64/libssl.so.10 (0x00007f837133a000)

libpq.so.5 => /lib64/libpq.so.5 (0x00007f837110b000)

libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f8370eee000)

libodbcinst.so.2 => /lib64/libodbcinst.so.2 (0x00007f8370cdc000)

libc.so.6 => /lib64/libc.so.6 (0x00007f8370919000)

libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f83706ca000)

libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f83703e3000)

libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f83701df000)

libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f836ffac000)

libcrypto.so.10 => /lib64/libcrypto.so.10 (0x00007f836fbc2000)

libdl.so.2 => /lib64/libdl.so.2 (0x00007f836f9be000)

libz.so.1 => /lib64/libz.so.1 (0x00007f836f7a7000)

libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007f836f54b000)

/lib64/ld-linux-x86-64.so.2 (0x00007f8371836000)

libltdl.so.7 => /lib64/libltdl.so.7 (0x00007f836f341000)

libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f836f131000)

libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f836ef2d000)

libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f836ed13000)

liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007f836eb03000)

libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007f836e8e6000)

libssl3.so => /lib64/libssl3.so (0x00007f836e6a2000)

libsmime3.so => /lib64/libsmime3.so (0x00007f836e47b000)

libnss3.so => /lib64/libnss3.so (0x00007f836e155000)

libnssutil3.so => /lib64/libnssutil3.so (0x00007f836df28000)

libplds4.so => /lib64/libplds4.so (0x00007f836dd24000)

libplc4.so => /lib64/libplc4.so (0x00007f836db1f000)

libnspr4.so => /lib64/libnspr4.so (0x00007f836d8e0000)

libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f836d6b9000)

libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f836d481000)

librt.so.1 => /lib64/librt.so.1 (0x00007f836d279000)

libpcre.so.1 => /lib64/libpcre.so.1 (0x00007f836d017000)

libfreebl3.so => /lib64/libfreebl3.so (0x00007f836ce14000)

[root@pcenterdev ~]# ldd -r /usr/bin/isql

linux-vdso.so.1 => (0x00007ffd4f56d000)

libodbc.so.2 => /lib64/libodbc.so.2 (0x00007f5c135d5000)

libltdl.so.7 => /lib64/libltdl.so.7 (0x00007f5c133cb000)

libreadline.so.6 => /lib64/libreadline.so.6 (0x00007f5c13184000)

libdl.so.2 => /lib64/libdl.so.2 (0x00007f5c12f80000)

libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f5c12d64000)

libc.so.6 => /lib64/libc.so.6 (0x00007f5c129a0000)

libtinfo.so.5 => /lib64/libtinfo.so.5 (0x00007f5c12776000)

/lib64/ld-linux-x86-64.so.2 (0x00007f5c13845000)

system.out.println("Atenciosamente");

João Ferreira - Gerência de Engenharia e Processo de Software - GPAS-PB - Prodabel

PRODABEL | Av. Presidente Carlos Luz,1275

joaof@pbh.gov.br / (31) 3277-7114

2018-09-06 21:22 GMT-03:00 Inoue, Hiroshi <h-inoue@dream.email.ne.jp>:

Hi Joao,

On 2018/09/06 5:01, Joao Augusto Lima Ferreira wrote:
Dear,

First of all, thank you for your attention.

I have the following packages installed in my Linux OS Centos 3.10.0-514.el7.x86_64:

postgresql-libs-9.2.23-3.el7_4.x86_64
postgresql-odbc-09.03.0100-2.el7.x86_6

I already have a PostgreSQL ODBC connection configured and functional, but when trying to create the new connection below and use the Isql utility to perform a test I am getting the error below, I did not find much about it, would you like to know how to proceed in this case?

follows the odbc.ini conf:

[BHIP_PGSQL]
Driver=/usr/lib64/psqlodbcw.so

What is the output of "ldd -r path_to_isql" and
the output of "ldd -r /usr/lib64/psqlodbcw.so"?

regards,
Hiroshi Inoue

Description = Banco de dados BHIP
Database = xxx_xxx
Servername = xxx.xxx.xxx.xx
Port = 5432
DriverUnicodeType = 1

follows the Isql execution:

[pcenter@pcenterdev ~]$ isql -v BHIP_PGSQL user ****************
[28000][unixODBC]Communication closed during authentication;
Connection reset by peer.
[ISQL]ERROR: Could not SQLConnect

follows the execution trace:

[ODBC][6121][1536176591.163931][__handles.c][460]
Exit:[SQL_SUCCESS]
Environment = 0x1e11780
[ODBC][6121][1536176591.164096][SQLAllocHandle.c][375]
Entry:
Handle Type = 2
Input Handle = 0x1e11780
[ODBC][6121][1536176591.164158][SQLAllocHandle.c][493]
Exit:[SQL_SUCCESS]
Output Handle = 0x1e12080
[ODBC][6121][1536176591.164220][SQLConnect.c][3700]
Entry:
Connection = 0x1e12080
Server Name = [BHIP_PGSQL][length = 10 (SQL_NTS)]
User Name = [user][length = 4 (SQL_NTS)]
Authentication = [****************][length = 16 (SQL_NTS)]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

DIAG [28000] Communication closed during authentication;
Connection reset by peer.

[ODBC][6121][1536176591.321348][SQLConnect.c][4067]
Exit:[SQL_ERROR]
[ODBC][6121][1536176591.321419][SQLError.c][434]
Entry:
Connection = 0x1e12080
SQLState = 0x7ffc89f63280
Native = 0x7ffc89f6327c
Message Text = 0x7ffc89f63290
Buffer Length = 500
Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321471][SQLError.c][471]
Exit:[SQL_SUCCESS]
SQLState = 28000
Native = 0x7ffc89f6327c -> 210
Message Text = [[unixODBC]Communication closed during authentication;
Connection reset by peer.]
[ODBC][6121][1536176591.321549][SQLError.c][434]
Entry:
Connection = 0x1e12080
SQLState = 0x7ffc89f63280
Native = 0x7ffc89f6327c
Message Text = 0x7ffc89f63290
Buffer Length = 500
Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321588][SQLError.c][471]
Exit:[SQL_NO_DATA]
[ODBC][6121][1536176591.321629][SQLError.c][514]
Entry:
Environment = 0x1e11780
SQLState = 0x7ffc89f63280
Native = 0x7ffc89f6327c
Message Text = 0x7ffc89f63290
Buffer Length = 500
Text Len Ptr = 0x7ffc89f6327a
[ODBC][6121][1536176591.321669][SQLError.c][551]
Exit:[SQL_NO_DATA]
[ODBC][6121][1536176591.321738][SQLFreeHandle.c][284]
Entry:
Handle Type = 2
Input Handle = 0x1e12080
[ODBC][6121][1536176591.321782][SQLFreeHandle.c][333]
Exit:[SQL_SUCCESS]
[ODBC][6121][1536176591.321824][SQLFreeHandle.c][219]
Entry:
Handle Type = 1
Input Handle = 0x1e11780

system.out.println("Atenciosamente");

--
João Ferreira - Gerência de Engenharia e Processo de Software - GPAS-PB - Prodabel
PRODABEL | Av. Presidente Carlos Luz,1275
joaof@pbh.gov.br / (31) 3277-7114

ウイルスフリー｡ www.avg.com