Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client

Hi Nick,

Ok, I added -v back, this gives

[root(at)jhbasterisk ~]# isql -v pgdb-cdr dbuser password
[S1000][unixODBC]The database does not exist on the server
or user authentication failed.
[ISQL]ERROR: Could not SQLConnect
[root(at)jhbasterisk ~]#

If I do

[root(at)jhbasterisk ~]# psql -U dbuser -d dbname

all works fine:

[root(at)jhbasterisk ~]# psql -U dbuser -d dbname
Password for user asteriskcdruser:
psql (9.4.4)
Type "help" for help.

dbname=> \d+
;
List of relations
Schema | Name | Type | Owner | Size |
Description
--------+----------------+----------+-----------------+------------+--------
-----
public | cdr | table | dbuser | 8192 bytes |
public | cdr_id_seq | sequence | dbuser | 8192 bytes |
public | cdr_leg | table | dbuser | 8192 bytes |
public | cdr_leg_id_seq | sequence | dbuser | 8192 bytes |
public | cel | table | dbuser | 8192 bytes |
public | cel_id_seq | sequence | dbusr | 8192 bytes |
(6 rows)

dbname=> ;
dbname=>

So Postgres itself does seem to know of the user and the database... but
accessing them via ODBC goes south somehow.

Is there any way I can raise the verbosity level (for example)? I've tried
isql -vvvvvv but I still just get "Database soed not exist on the server or
user authentication failed".

Thank you very much for your kind assistance.

Regards,

-----Original Message-----
From: Nick Gorham [mailto:nick(at)lurcher(dot)org]
Sent: Friday,July 17, 2015 01:02 PM
To: Stefan Viljoen
Subject: Re: [ODBC] Postgres 9.4 + unixODBC on Centos 6.5 problem connecting
localhost postgres instance with isql ODBC commandline client

On 17/07/15 12:00, Stefan Viljoen wrote:
> Hi Nick
>
> Thanks for the response - ok, I tried
>
> [root(at)jhbasterisk ~]# isql -v pgdb-cdr dbuser dbname password
> [28000][unixODBC]FATAL: password authentication failed for user
> "asteriskcdruser"
> [ISQL]ERROR: Could not SQLConnect
> [root(at)jhbasterisk ~]# isql pgdb-cdr dbuser password
> [ISQL]ERROR: Could not SQLConnect
> [root(at)jhbasterisk ~]#
>
> E. g. the 28000 error message is gone, but now I just get Could Not
> SQLConnect from isql...
>
> So maybe a step in the right direction?
>
> What can I try next?
>
> Thank you very much for the assistance.
>
> Kind regards,

The error has gone because you didn't have the -v option.

My point was you cant specify the database on the command line with isql

isql -v pgdb-cdr dbuser password

Will show you the error.

--
Nick