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

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,

-----Original Message-----
From: Nick Gorham [mailto:nick(at)lurcher(dot)org]
Sent: Friday,July 17, 2015 10:38 AM
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 09:01, Stefan Viljoen wrote:
> Hi list
>
> I've got postges 9.4 installed on Centos 6.5. I have access to it from
> psql and I have set up and filled a database I now want to access via
> ODBC - all on the localhost, no remote access involved.
>
> If I do on my localhost machine on which postgres is running, while
> logged in as root:
>
> ---
> # psql -U mydbuser -d mydbname
> ---
>
> it works fine - I get asked for my password (which is "mydbpassword"),
> which I then enter and I can then interact with postgres in the psql
> commandline client - run queries, create databases and tables, etc.
>
> However, if I run
>
> ---
> # isql -v pgdb-cdr mydbuser mydbname mydbpassword

Hi,

From the unixODBC perspective, isql only takes three arguments (ignoring
options)

isql dsn user password

If you want to set the dbname it would normally be done in the DSN entry.

--
Nick