Re: Problems installing Postgresql ODBC driver 32bits on Redhat 6.5

Hello, please

We are trying to do a postgre isql conexion . We tried to install several
RPM packages for postgresql-odbc 32bits, but we can't make a test using
isql.

We have the environment below:

SO:Redhat 6.5
unixODBC-2.2.14-12.el6_3.i686 (installed)
When the pkg postgresql-odbc-7.0.2-17.i386.rpm was installed, It returned
this error:

isql -v rep_teste

[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/psqlodbc.so' :
file not found
[ISQL]ERROR: Could not SQLConnect

When the pkg postgresql-odbc-7.2.5-1.i386.rpm was installed, the lib above
was installed, but we got the error:

isql -v rep_teste

[IM002][unixODBC]Missing server name, port, or database name in call to
CC_connect.
[ISQL]ERROR: Could not SQLConnect

We guess the /etc/odbc.ini is correct:

[rep_teste]
Description = PostgreSQL connection to SallyDB
Driver = PostgreSQL
Database = rep_teswte
Servername = vmhteste
UserName = teste
Password = 123456
Port = 5432
Protocol = 9.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ConnSettings =

We think there are a postgresql-odbc package mistake but we can't find the
correct package.

We'll apprecciate any help. Thank !!.

Att.
Laerte Antonio.
--------------------------------------------
"*When you make your mark in the world, watch out for guys with erasers.*"
The Wall Street Journal.

On 03/14/2016 11:49 AM, Laerte Antonio de Almeida Giraldelli wrote:
> Hello, please
>
> We are trying to do a postgre isql conexion . We tried to install
> several RPM packages for postgresql-odbc 32bits, but we can't make a
> test using isql.
>
> We have the environment below:
>
> SO:Redhat 6.5
> unixODBC-2.2.14-12.el6_3.i686 (installed)
> When the pkg postgresql-odbc-7.0.2-17.i386.rpm was installed, It
> returned this error:
>
> isql -v rep_teste
>
> [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/psqlodbc.so' :
> file not found
> [ISQL]ERROR: Could not SQLConnect

Did you check if the file existed at the above location or anywhere?

>
> When the pkg postgresql-odbc-7.2.5-1.i386.rpm was installed, the lib
> above was installed, but we got the error:

Where was it installed?

>
> isql -v rep_teste
>
> [IM002][unixODBC]Missing server name, port, or database name in call to
> CC_connect.
> [ISQL]ERROR: Could not SQLConnect
>
> We guess the /etc/odbc.ini is correct:
>
> [rep_teste]
> Description = PostgreSQL connection to SallyDB
> Driver = PostgreSQL
> Database = rep_teswte
> Servername = vmhteste
> UserName = teste
> Password = 123456
> Port = 5432
> Protocol = 9.4
> ReadOnly = No
> RowVersioning = No
> ShowSystemTables = No
> ConnSettings =
>
> We think there are a postgresql-odbc package mistake but we can't find
> the correct package.

What is in the odbcinst.ini file?

What are repo(s) are you using to get the unixODBC and postgresql-odbc
packages?

>
> We'll apprecciate any help. Thank !!.
>
> Att.
> Laerte Antonio.
> --------------------------------------------
> "/When you make your mark in the world, watch out for guys with
> erasers./" The Wall Street Journal.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

Thanks Adrian,

Here are the answers:

- odbcinst.ini content:

odbcinst -j

unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/apvmh79/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2

- I have downloaded the odbc packages from:

http://rpm.pbone.net/

unixODBC-2.2.14-12.el6_3.i686.rpm
postgresql-odbc-7.2.5-1.i386.rpm

- When I copied content file /etc/odbc.ini to /home/apvmh79/.odbc.ini

The error changed from:
[IM002][unixODBC]Missing server name, port, or database name in call to
CC_connect.

To:
[28000][unixODBC]FATAL: no PostgreSQL user name specified in startup packet

The postgre server is 9.4 version.

Att.
-------------------------------------------
Laerte Antonio de A. Giraldelli
Gerência de Implantação
CPqD - Diretoria de Suporte à Decisão e Aplicações
Fone: +55 19 3705-7215
laerteg(at)cpqd(dot)com(dot)br
www.cpqd.com.br

"*When you make your mark in the world, watch out for guys with erasers.*"
The Wall Street Journal.

2016-03-14 20:08 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> On 03/14/2016 11:49 AM, Laerte Antonio de Almeida Giraldelli wrote:
>
>> Hello, please
>>
>> We are trying to do a postgre isql conexion . We tried to install
>> several RPM packages for postgresql-odbc 32bits, but we can't make a
>> test using isql.
>>
>> We have the environment below:
>>
>> SO:Redhat 6.5
>> unixODBC-2.2.14-12.el6_3.i686 (installed)
>> When the pkg postgresql-odbc-7.0.2-17.i386.rpm was installed, It
>> returned this error:
>>
>> isql -v rep_teste
>>
>> [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/psqlodbc.so' :
>> file not found
>> [ISQL]ERROR: Could not SQLConnect
>>
>
> Did you check if the file existed at the above location or anywhere?
>
>
>> When the pkg postgresql-odbc-7.2.5-1.i386.rpm was installed, the lib
>> above was installed, but we got the error:
>>
>
> Where was it installed?
>
>
>> isql -v rep_teste
>>
>> [IM002][unixODBC]Missing server name, port, or database name in call to
>> CC_connect.
>> [ISQL]ERROR: Could not SQLConnect
>>
>> We guess the /etc/odbc.ini is correct:
>>
>> [rep_teste]
>> Description = PostgreSQL connection to SallyDB
>> Driver = PostgreSQL
>> Database = rep_teswte
>> Servername = vmhteste
>> UserName = teste
>> Password = 123456
>> Port = 5432
>> Protocol = 9.4
>> ReadOnly = No
>> RowVersioning = No
>> ShowSystemTables = No
>> ConnSettings =
>>
>> We think there are a postgresql-odbc package mistake but we can't find
>> the correct package.
>>
>
> What is in the odbcinst.ini file?
>
> What are repo(s) are you using to get the unixODBC and postgresql-odbc
> packages?
>
>
>> We'll apprecciate any help. Thank !!.
>>
>> Att.
>> Laerte Antonio.
>> --------------------------------------------
>> "/When you make your mark in the world, watch out for guys with
>> erasers./" The Wall Street Journal.
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

On 03/15/2016 05:52 AM, Laerte Antonio de Almeida Giraldelli wrote:
> Thanks Adrian,
>
> Here are the answers:
>
> - odbcinst.ini content:

The below shows where it is located(/etc/odbcinst.ini), not what is in it.

>
> odbcinst -j
>
> unixODBC 2.2.14
> DRIVERS............: /etc/odbcinst.ini
> SYSTEM DATA SOURCES: /etc/odbc.ini
> FILE DATA SOURCES..: /etc/ODBCDataSources
> USER DATA SOURCES..: /home/apvmh79/.odbc.ini
> SQLULEN Size.......: 4
> SQLLEN Size........: 4
> SQLSETPOSIROW Size.: 2
>
> - I have downloaded the odbc packages from:
>
> http://rpm.pbone.net/
>
> unixODBC-2.2.14-12.el6_3.i686.rpm
> postgresql-odbc-7.2.5-1.i386.rpm

Any particular reason you are not using the RH repos?

>
> - When I copied content file /etc/odbc.ini to /home/apvmh79/.odbc.ini
>
> The error changed from:
> [IM002][unixODBC]Missing server name, port, or database name in call to
> CC_connect.
>
> To:
> [28000][unixODBC]FATAL: no PostgreSQL user name specified in startup packet

And there is a UserName in /home/apvmh79/.odbc.ini?

>
> The postgre server is 9.4 version.
>
>
>
> Att.
> -------------------------------------------
> Laerte Antonio de A. Giraldelli
> Gerência de Implantação
> CPqD - Diretoria de Suporte à Decisão e Aplicações
> Fone: +55 19 3705-7215
> laerteg(at)cpqd(dot)com(dot)br <mailto:laerteg(at)cpqd(dot)com(dot)br>
> www.cpqd.com.br <http://www.cpqd.com.br/>
>
> "/When you make your mark in the world, watch out for guys with
> erasers./" The Wall Street Journal.
>
> 2016-03-14 20:08 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>:
>
> On 03/14/2016 11:49 AM, Laerte Antonio de Almeida Giraldelli wrote:
>
> Hello, please
>
> We are trying to do a postgre isql conexion . We tried to install
> several RPM packages for postgresql-odbc 32bits, but we can't make a
> test using isql.
>
> We have the environment below:
>
> SO:Redhat 6.5
> unixODBC-2.2.14-12.el6_3.i686 (installed)
> When the pkg postgresql-odbc-7.0.2-17.i386.rpm was installed, It
> returned this error:
>
> isql -v rep_teste
>
> [01000][unixODBC][Driver Manager]Can't open lib
> '/usr/lib/psqlodbc.so' :
> file not found
> [ISQL]ERROR: Could not SQLConnect
>
>
> Did you check if the file existed at the above location or anywhere?
>
>
> When the pkg postgresql-odbc-7.2.5-1.i386.rpm was installed, the lib
> above was installed, but we got the error:
>
>
> Where was it installed?
>
>
> isql -v rep_teste
>
> [IM002][unixODBC]Missing server name, port, or database name in
> call to
> CC_connect.
> [ISQL]ERROR: Could not SQLConnect
>
> We guess the /etc/odbc.ini is correct:
>
> [rep_teste]
> Description = PostgreSQL connection to SallyDB
> Driver = PostgreSQL
> Database = rep_teswte
> Servername = vmhteste
> UserName = teste
> Password = 123456
> Port = 5432
> Protocol = 9.4
> ReadOnly = No
> RowVersioning = No
> ShowSystemTables = No
> ConnSettings =
>
> We think there are a postgresql-odbc package mistake but we
> can't find
> the correct package.
>
>
> What is in the odbcinst.ini file?
>
> What are repo(s) are you using to get the unixODBC and
> postgresql-odbc packages?
>
>
> We'll apprecciate any help. Thank !!.
>
> Att.
> Laerte Antonio.
> --------------------------------------------
> "/When you make your mark in the world, watch out for guys with
> erasers./" The Wall Street Journal.
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

Guys, I've just solved the issue:

I informed the user on the isql line and the error changed to another one:

[22003][unixODBC]client encoding mismatch

I found a post that told us to change the driver in the /etc/odbcinst.ini,
and then I changed the Driver parameter:

from:
Driver = /usr/lib/psqlodbc.so

To:
Driver = /usr/pgsql-9.4/lib/psqlodbc.so

Note: in our case this lib is symbolic link:

/usr/pgsql-9.4/lib/psqlodbc.so -> /usr/pgsql-9.4/lib/psqlodbcw.so

After all, the odbc connection run succesfully...

$ isql -v rep_teste
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>

Thanks.

Att.
-------------------------------------------
Laerte Antonio de A. Giraldelli
Gerência de Implantação
CPqD - Diretoria de Suporte à Decisão e Aplicações
Fone: +55 19 3705-7215
laerteg(at)cpqd(dot)com(dot)br
www.cpqd.com.br

"*When you make your mark in the world, watch out for guys with erasers.*"
The Wall Street Journal.

2016-03-15 11:02 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> On 03/15/2016 05:52 AM, Laerte Antonio de Almeida Giraldelli wrote:
>
>> Thanks Adrian,
>>
>> Here are the answers:
>>
>> - odbcinst.ini content:
>>
>
> The below shows where it is located(/etc/odbcinst.ini), not what is in it.
>
>
>> odbcinst -j
>>
>> unixODBC 2.2.14
>> DRIVERS............: /etc/odbcinst.ini
>> SYSTEM DATA SOURCES: /etc/odbc.ini
>> FILE DATA SOURCES..: /etc/ODBCDataSources
>> USER DATA SOURCES..: /home/apvmh79/.odbc.ini
>> SQLULEN Size.......: 4
>> SQLLEN Size........: 4
>> SQLSETPOSIROW Size.: 2
>>
>> - I have downloaded the odbc packages from:
>>
>> http://rpm.pbone.net/
>>
>> unixODBC-2.2.14-12.el6_3.i686.rpm
>> postgresql-odbc-7.2.5-1.i386.rpm
>>
>
>
> Any particular reason you are not using the RH repos?
>
>
>> - When I copied content file /etc/odbc.ini to /home/apvmh79/.odbc.ini
>>
>> The error changed from:
>> [IM002][unixODBC]Missing server name, port, or database name in call to
>> CC_connect.
>>
>> To:
>> [28000][unixODBC]FATAL: no PostgreSQL user name specified in startup
>> packet
>>
>
> And there is a UserName in /home/apvmh79/.odbc.ini?
>
>
>> The postgre server is 9.4 version.
>>
>>
>>
>> Att.
>> -------------------------------------------
>> Laerte Antonio de A. Giraldelli
>> Gerência de Implantação
>> CPqD - Diretoria de Suporte à Decisão e Aplicações
>> Fone: +55 19 3705-7215
>> laerteg(at)cpqd(dot)com(dot)br <mailto:laerteg(at)cpqd(dot)com(dot)br>
>> www.cpqd.com.br <http://www.cpqd.com.br/>
>>
>> "/When you make your mark in the world, watch out for guys with
>> erasers./" The Wall Street Journal.
>>
>> 2016-03-14 20:08 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>:
>>
>>
>> On 03/14/2016 11:49 AM, Laerte Antonio de Almeida Giraldelli wrote:
>>
>> Hello, please
>>
>> We are trying to do a postgre isql conexion . We tried to install
>> several RPM packages for postgresql-odbc 32bits, but we can't
>> make a
>> test using isql.
>>
>> We have the environment below:
>>
>> SO:Redhat 6.5
>> unixODBC-2.2.14-12.el6_3.i686 (installed)
>> When the pkg postgresql-odbc-7.0.2-17.i386.rpm was installed, It
>> returned this error:
>>
>> isql -v rep_teste
>>
>> [01000][unixODBC][Driver Manager]Can't open lib
>> '/usr/lib/psqlodbc.so' :
>> file not found
>> [ISQL]ERROR: Could not SQLConnect
>>
>>
>> Did you check if the file existed at the above location or anywhere?
>>
>>
>> When the pkg postgresql-odbc-7.2.5-1.i386.rpm was installed, the
>> lib
>> above was installed, but we got the error:
>>
>>
>> Where was it installed?
>>
>>
>> isql -v rep_teste
>>
>> [IM002][unixODBC]Missing server name, port, or database name in
>> call to
>> CC_connect.
>> [ISQL]ERROR: Could not SQLConnect
>>
>> We guess the /etc/odbc.ini is correct:
>>
>> [rep_teste]
>> Description = PostgreSQL connection to SallyDB
>> Driver = PostgreSQL
>> Database = rep_teswte
>> Servername = vmhteste
>> UserName = teste
>> Password = 123456
>> Port = 5432
>> Protocol = 9.4
>> ReadOnly = No
>> RowVersioning = No
>> ShowSystemTables = No
>> ConnSettings =
>>
>> We think there are a postgresql-odbc package mistake but we
>> can't find
>> the correct package.
>>
>>
>> What is in the odbcinst.ini file?
>>
>> What are repo(s) are you using to get the unixODBC and
>> postgresql-odbc packages?
>>
>>
>> We'll apprecciate any help. Thank !!.
>>
>> Att.
>> Laerte Antonio.
>> --------------------------------------------
>> "/When you make your mark in the world, watch out for guys with
>> erasers./" The Wall Street Journal.
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>