Skip site navigation (1) Skip section navigation (2)

Re: first time odbc

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "postgresql(at)finner(dot)de" <postgresql(at)finner(dot)de>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: first time odbc
Date: 2011-03-30 14:54:45
Message-ID: 93361C67E4EE844A80935863A4FF4B6C04E612E0@Exch2010MB-2.univ.dir.wwu.edu (view raw or flat)
Thread:
Lists: pgsql-odbc
I only want the users to read data, thus I removed superuser and applied grant select. 

If the listen_address is not a client filter, would it still be better to only have it listen to localhost and the few ip addresses that will need to odbc to the postgres database? Is it just not possible to assign listen_address = 'localhost, 1.ip.address, 2.ip.address'?

One other thing still, if in the pg_hba.conf file I do not include any ip addresses I cannot connect to the database. If I enter just one ip address, any computer can connect to the database, even though some machines have static ip addresses and others have dhcp address from a completely different subnet. Do you know why this is? I figured the pg_hba.conf file controlled access by ip address, based on other googled articles.

Thanks

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Frank Finner
Sent: Tuesday, March 29, 2011 9:18 PM
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] first time odbc

Is the user you connect with allowed to see / modify data? 

Maybe it would be a good idea to increase the log level on the server and look in the logs, what happens. This can be done at runtime, no need to stop the database.

Regards,
Frank.

On Tue, 29 Mar 2011 20:21:44 +0000 Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
wrote:

> By editing postgresql.conf and changing listen_address = ‘*’ and 
> editing pg_hba.conf and adding host all all my.ip.address allowed me 
> to connect to the postgresql data base with Microsoft access.
> 
> In access I can see the table and it fields, but if I try to use the 
> table in a querry or view the table I get an error: permission denied 
> for relation summer_finaid; error while executing the query (#7)
> 
> Any ideas?
> 
> Also in the postgresql instead of listen_address=’*’ I tried 
> listen_address=’localhost, my.ip.address’ but that failed to work.
> How can I keep local host and only allow specific address? I don’t 
> want to open it up to all with ‘*’
> 
> Thanks
> 
> 
> From: jsilberberg(at)mindspring(dot)com [mailto:jsilberberg(at)mindspring(dot)com]
> Sent: Tuesday, March 29, 2011 11:13 AM
> To: Marc Fromm; pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] first time odbc
> 
> 
> 
> 
> Why,
> 
> 
> 
>     That's a vintage 02-Feb-2006 driver.
> 
> 
> 
>      I use 8.04 from Dec-2009 and even that's getting a little stale.  
> Why not try the 9.n drivers.
> 
> 
> 
>      Could the port(s) be blocked / restricted between you and the 
> server and is PostgreSQL SSL support enabled --
> 
>         http://www.postgresql.org/docs/9.0/static/ssl-tcp.html
> 
> 
> 
>      JMS
> 
> 
> 
>     -----------------------------------
> 
> 
> -----Original Message-----
> From: Marc Fromm
> Sent: Mar 29, 2011 1:58 PM
> To: "pgsql-odbc(at)postgresql(dot)org<mailto:pgsql-odbc(at)postgresql(dot)org>"
> Subject: [ODBC] first time odbc
> 
> 
> Before learning there was an odbc list, I sent this post to the admin 
> list.
> 
> I am running postgres on a red hat linux server.
> postgresql-python-8.1.23-1.el5_6.1
> postgresql-test-8.1.23-1.el5_6.1
> postgresql-libs-8.1.23-1.el5_6.1
> postgresql-docs-8.1.23-1.el5_6.1
> postgresql-contrib-8.1.23-1.el5_6.1
> postgresql-8.1.23-1.el5_6.1
> postgresql-pl-8.1.23-1.el5_6.1
> postgresql-odbc-08.01.0200-3.1
> postgresql-jdbc-8.1.407-1jpp.4
> postgresql-server-8.1.23-1.el5_6.1
> postgresql-tcl-8.1.23-1.el5_6.1
> 
> User on windows computers would like to odbc to the postgres 
> databases. I downloaded the windows postgres odbc drivers from the 
> following site and installed version “psqlodbc-08_01_0200” on the 
> windows computer.
> http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi
> /
> 
> When I configure a “File Data Source” connection in access, I cannot 
> connect to the postgresql database. I get the message, “A connection 
> could not be made using the file data source parameters entered. Save 
> non-verified file DSN?” The parameters entered are: Database:
> database_name Server: I entered the IP address of the server User
> Name: I entered postgres Password:
> SSL Mode: prefer
> Port: 5432 (which is the port used by postgres)
> 
> Do I need to configure the /etc/odbc.ini file? It is currently just a 
> blank file.
> 
> Thanks for any help.
> 
> Marc



--
Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

In response to

Responses

pgsql-odbc by date

Next:From: Adrian KlaverDate: 2011-03-30 15:23:31
Subject: Re: first time odbc
Previous:From: Raymond O'DonnellDate: 2011-03-30 09:44:03
Subject: Re: first time odbc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group