Quick Links

Re: first time odbc

Lists:	pgsql-odbc

From:	"jsilberberg(at)mindspring(dot)com" <jsilberberg(at)mindspring(dot)com>
To:	Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>, pgsql-odbc(at)postgresql(dot)org
Subject:	Re: first time odbc
Date:	2011-03-29 18:12:40
Message-ID:	29054973.1301422360902.JavaMail.root@elwamui-little.atl.sa.earthlink.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

<HEAD>
<STYLE>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</STYLE>

<META name=GENERATOR content="MSHTML 8.00.7600.16722"></HEAD>
<BODY>
 
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 -- 
        <A href="http://www.postgresql.org/docs/9.0/static/ssl-tcp.html">http://www.postgresql.org/docs/9.0/static/ssl-tcp.html</A>
 
     JMS
 
    -----------------------------------
 
<BLOCKQUOTE style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 0px">-----Original Message----- From: Marc Fromm <MARC(dot)FROMM(at)WWU(dot)EDU> Sent: Mar 29, 2011 1:58 PM To: "pgsql-odbc(at)postgresql(dot)org" <PGSQL-ODBC(at)POSTGRESQL(dot)ORG> Subject: [ODBC] first time odbc <?XML:NAMESPACE PREFIX = [default] http://www.w3.org/TR/REC-html40 NS = "http://www.w3.org/TR/REC-html40" /><ZZZhtml xmlns="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml"><ZZZhead><ZZZmeta content="text/html; charset=us-ascii" http-equiv="Content-Type"><ZZZmeta content="Microsoft Word 14 (filtered medium)" name="Generator">
<STYLE><ZZZ!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:ZZZlink, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></STYLE>
<ZZZ!--[if 9] mso gte><xml><?xml:namespace prefix = o /><o:shapedefaults spidmax="1026" v:ext="edit"></o:shapedefaults></xml><ZZZ![endif]--><ZZZ!--[if 9] mso gte><xml><o:shapelayout v:ext="edit"><o:idmap v:ext="edit" data="1"></o:idmap></o:shapelayout></xml><ZZZ![endif]--></ZZZhead><ZZZbody lang=EN-US vlink="purple" link="blue">
<DIV class=WordSection1>
Before learning there was an odbc list, I sent this post to the admin list.<o:p></o:p>
<o:p> </o:p>
I am running postgres on a red hat linux server.<o:p></o:p>
postgresql-python-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-test-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-libs-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-docs-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-contrib-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-pl-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-odbc-08.01.0200-3.1<o:p></o:p>
postgresql-jdbc-8.1.407-1jpp.4<o:p></o:p>
postgresql-server-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-tcl-8.1.23-1.el5_6.1<o:p></o:p>
<o:p> </o:p>
User on windows computers would like to odbc to the postgres databases.<o:p></o:p>
I downloaded the windows postgres odbc drivers from the following site and installed version “psqlodbc-08_01_0200” on the windows computer.<o:p></o:p>
<A href="http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/" target=_blank>http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/</A><o:p></o:p>
<o:p> </o:p>
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?”<o:p></o:p>
The parameters entered are:<o:p></o:p>
Database: database_name<o:p></o:p>
Server: I entered the IP address of the server<o:p></o:p>
User Name: I entered postgres<o:p></o:p>
Password:<o:p></o:p>
SSL Mode: prefer<o:p></o:p>
Port: 5432 (which is the port used by postgres)<o:p></o:p>
<o:p> </o:p>
Do I need to configure the /etc/odbc.ini file? It is currently just a blank file.<o:p></o:p>
<o:p> </o:p>
Thanks for any help.<o:p></o:p>
<o:p> </o:p>
Marc<o:p></o:p></DIV></ZZZbody></ZZZhtml></BLOCKQUOTE></ZZZ![endif]--></ZZZ!--[if></ZZZ![endif]--></ZZZ!--[if></ZZZmeta></ZZZmeta></BODY>

Attachment	Content-Type	Size
unknown_filename	text/html	6.4 KB

From:	Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To:	"jsilberberg(at)mindspring(dot)com" <jsilberberg(at)mindspring(dot)com>
Cc:	"pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: first time odbc
Date:	2011-03-29 19:01:55
Message-ID:	93361C67E4EE844A80935863A4FF4B6C04E60CC8@Exch2010MB-2.univ.dir.wwu.edu
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

I updated the windows postgresql odbc drivers and now I get the message:
No connection could be made because the target machine actively refused it.

This sounds like something needs to be configured on the server to allow the odbc connection.

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

From:	Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To:	"jsilberberg(at)mindspring(dot)com" <jsilberberg(at)mindspring(dot)com>
Cc:	"pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: first time odbc
Date:	2011-03-29 20:21:44
Message-ID:	93361C67E4EE844A80935863A4FF4B6C04E60D02@Exch2010MB-2.univ.dir.wwu.edu
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

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

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.

Do I need to configure the /etc/odbc.ini file? It is currently just a blank file.

Thanks for any help.

Marc

From:	Frank Finner <postgresql(at)finner(dot)de>
To:	"pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: first time odbc
Date:	2011-03-30 04:18:06
Message-ID:	20110330061806.13f0a67f@isengard.finner.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-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

From:	Raymond O'Donnell <rod(at)iol(dot)ie>
To:	Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
Cc:	"jsilberberg(at)mindspring(dot)com" <jsilberberg(at)mindspring(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: first time odbc
Date:	2011-03-30 09:44:03
Message-ID:	4D92FB63.2030705@iol.ie
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

On 29/03/2011 21:21, Marc Fromm 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)

You need to grant permission on the table to the user:

GRANT SELECT ON summer_finaid TO [insert your user here];

See the docs here:

http://www.postgresql.org/docs/9.0/static/sql-grant.html

> 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 ‘*’

listen_addresses specifies the interfaces on which Postgres *listens*,
not the remote hosts which can connect - that's done in pg_hba.conf.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

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
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
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

From:	Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To:	Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
Cc:	"postgresql(at)finner(dot)de" <postgresql(at)finner(dot)de>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: first time odbc
Date:	2011-03-30 15:23:31
Message-ID:	4D934AF3.8040404@gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

On 03/30/2011 07:54 AM, Marc Fromm wrote:
> 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'?

listen_address refers to the addresses available on the host. More than
one assumes you have more than one IP address bound to the database
host. You will not get the result you want using the method you propose
above.

>
> 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.

pg_hba.conf works by first match wins. My guess is you have line above
your IP line that is more permissive and is allowing connections. Per a
previous post, you probably should spend some time with the manual to
fully understand the interaction between the various security,access
components of Postgres:)
>
> Thanks
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

From:	Raymond O'Donnell <rod(at)iol(dot)ie>
To:	Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
Cc:	"postgresql(at)finner(dot)de" <postgresql(at)finner(dot)de>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: first time odbc
Date:	2011-03-30 15:47:37
Message-ID:	4D935099.9090301@iol.ie
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

On 30/03/2011 15:54, Marc Fromm wrote:
> I only want the users to read data, thus I removed superuser and
> applied grant select.

Good stuff.

> 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'?

You're still misunderstanding listen_addresses - it has *nothing* to do
with client addresses.

Example: I have a server with two network interfaces, a.b.c.x and
a.b.c.y. If I want PG to listen on both interfaces, I can set
listen_addresses = '*' (or list the two addresses explicitly). If I want
it to listen *only* on a.b.c.x, then I set listen_addresses='a.b.c.x'.

> 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.

Can you show us your pg_hba.conf?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

From:	Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To:	"rod(at)iol(dot)ie" <rod(at)iol(dot)ie>
Cc:	"pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: first time odbc
Date:	2011-03-30 16:33:57
Message-ID:	93361C67E4EE844A80935863A4FF4B6C04E61359@Exch2010MB-2.univ.dir.wwu.edu
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Lists:	pgsql-odbc

This is my pg_hba.conf file. I replaced x's with my ip address.
If I comment line 74, then no one can odbc to postgresql.
Lines 1 - 67 are all just commented text.

68 # TYPE DATABASE USER CIDR-ADDRESS METHOD
69
70 # "local" is for Unix domain socket connections only
71 local all all trust
72 # IPv4 local connections:
73 host all all 127.0.0.1/32 trust
74 host all all xxx.xxx.xxx.xxx 255.255.0.0 md5
75 # IPv6 local connections:
76 host all all ::1/128 trust

-----Original Message-----
From: Raymond O'Donnell [mailto:rod(at)iol(dot)ie]
Sent: Wednesday, March 30, 2011 8:48 AM
To: Marc Fromm
Cc: postgresql(at)finner(dot)de; pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] first time odbc

On 30/03/2011 15:54, Marc Fromm wrote:
> I only want the users to read data, thus I removed superuser and
> applied grant select.

Good stuff.

> 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'?

You're still misunderstanding listen_addresses - it has *nothing* to do with client addresses.

Example: I have a server with two network interfaces, a.b.c.x and a.b.c.y. If I want PG to listen on both interfaces, I can set listen_addresses = '*' (or list the two addresses explicitly). If I want it to listen *only* on a.b.c.x, then I set listen_addresses='a.b.c.x'.

> 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.

Can you show us your pg_hba.conf?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie