Thread: ODBC first time odbc
By changing the user that I login with to a super user, everything works. I don’t get the permission denied error.
However, I only want the users to read. Being set as a super user allows the odbc user to change the data.
My problem is now down to two security points:
How do I have a user with only read access (not a super user) and not be denied viewing the table data?
How do I control access with listen_address=’localhost, specific.ip.addresses’ and not use ‘*’?
Setting listen_address=’localhost, specific.ip.addresses’ does not work, I get call failed errors asking if the server is accepting tcp/ip connections on port 5432
Thanks
From: Marc Fromm
Sent: Tuesday, March 29, 2011 1:23 PM
To: 'jsilberberg@mindspring.com'
Cc: pgsql-odbc@postgresql.org
Subject: RE: [ODBC] first time 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
From: jsilberberg@mindspring.com [mailto:jsilberberg@mindspring.com]
Sent: Tuesday, March 29, 2011 11:13 AM
To: Marc Fromm; pgsql-odbc@postgresql.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@postgresql.org"
Subject: [ODBC] first time odbcBefore 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
<p><font color="#000000"><font size="2"><font face="arial,sans-serif"></font></font></font> <p><font face="Arial" size="2">Okay,</font><p><font face="Arial" size="2"></font> <p><font face="Arial" size="2"> You may want to start at theindex and read the manual. </font><p><font face="Arial" size="2"></font> <p><font face="Arial" size="2"> But I thinkyou need to "grant select ................" to your ODBC user for your permissions issue.</font><p><font face="Arial"size="2"></font> <p><font face="Arial" size="2"> <a href="http://www.postgresql.org/docs/9.0/static/sql-grant.html">http://www.postgresql.org/docs/9.0/static/sql-grant.html</a></font><p><font face="Arial"size="2"></font> <p><font face="Arial" size="2"> JMS.. </font><p><font color="#000000"><font size="2"><fontface="arial,sans-serif"></font></font></font> <p><font color="#000000"><font size="2"><font face="arial,sans-serif"> </font></font></font><p><br/><blockquote style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px;MARGIN-LEFT: 0px">-----Original Message----- <br />From: Marc Fromm <br />Sent: Mar 29, 2011 5:13 PM <br />To: "pgsql-odbc@postgresql.org"<br />Subject: [ODBC] ODBC first time odbc <br /><br /><style><ZZZ!-- /* Font Definitions */ @font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 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;} p{mso-style-priority:99;margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman","serif";} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate{mso-style-priority:99;mso-style-link:"Balloon Text Char";margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma","sans-serif";} span.EmailStyle18{mso-style-type:personal;font-family:"Calibri","sans-serif";color:windowtext;} span.EmailStyle19{mso-style-type:personal;font-family:"Calibri","sans-serif";color:#1F497D;} span.EmailStyle20{mso-style-type:personal-reply;font-family:"Calibri","sans-serif";color:#1F497D;} span.BalloonTextChar{mso-style-name:"Balloon Text Char";mso-style-priority:99;mso-style-link:"Balloon Text";font-family:"Tahoma","sans-serif";} .MsoChpDefault{mso-style-type:export-only;font-size:10.0pt;} @page WordSection1{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1{page:WordSection1;} --></style><div class="WordSection1"><p class="MsoNormal"><span style="COLOR: #1f497d">By changing the user that I loginwith to a super user, everything works. I don’t get the permission denied error.</span><p class="MsoNormal"><span style="COLOR:#1f497d">However, I only want the users to read. Being set as a super user allows the odbc user to change thedata.</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR: #1f497d">Myproblem is now down to two security points:</span><p class="MsoNormal"><span style="COLOR: #1f497d">How do I havea user with only read access (not a super user) and not be denied viewing the table data?</span><p class="MsoNormal"><spanstyle="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR: #1f497d">How do I controlaccess with listen_address=’localhost, specific.ip.addresses’ and not use ‘*’?</span><p class="MsoNormal"><span style="COLOR:#1f497d">Setting listen_address=’localhost, specific.ip.addresses’ does not work, I get call failed errors askingif the server is accepting tcp/ip connections on port 5432</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><pclass="MsoNormal"><span style="COLOR: #1f497d">Thanks</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><pclass="MsoNormal"><span style="COLOR: #1f497d"> </span><div><div style="BORDER-BOTTOM: medium none; BORDER-LEFT:medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT:medium none; PADDING-TOP: 3pt"><p class="MsoNormal"><b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE:10pt">From:</span></b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"> Marc Fromm <br /><b>Sent:</b>Tuesday, March 29, 2011 1:23 PM<br /><b>To:</b> 'jsilberberg@mindspring.com'<br /><b>Cc:</b> pgsql-odbc@postgresql.org<br/><b>Subject:</b> RE: [ODBC] first time odbc</span></div></div><p class="MsoNormal"> <p class="MsoNormal"><spanstyle="COLOR: #1f497d">By editing postgresql.conf and changing listen_address = ‘*’ and editing pg_hba.confand adding host all all my.ip.address allowed me to connect to the postgresql data base with Microsoft access.</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR: #1f497d">Inaccess 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 anerror: permission denied for relation summer_finaid; error while executing the query (#7)</span><p class="MsoNormal"><spanstyle="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR: #1f497d">Any ideas?</span><pclass="MsoNormal"><span style="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR: #1f497d">Alsoin the postgresql instead of listen_address=’*’ I tried listen_address=’localhost, my.ip.address’ but that failedto work.</span><p class="MsoNormal"><span style="COLOR: #1f497d">How can I keep local host and only allow specificaddress? I don’t want to open it up to all with ‘*’</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><pclass="MsoNormal"><span style="COLOR: #1f497d">Thanks</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><pclass="MsoNormal"><span style="COLOR: #1f497d"> </span><div><div style="BORDER-BOTTOM: medium none; BORDER-LEFT:medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT:medium none; PADDING-TOP: 3pt"><p class="MsoNormal"><b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE:10pt">From:</span></b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"> jsilberberg@mindspring.com[mailto:jsilberberg@mindspring.com] <br /><b>Sent:</b> Tuesday, March 29, 2011 11:13 AM<br /><b>To:</b>Marc Fromm; pgsql-odbc@postgresql.org<br /><b>Subject:</b> Re: [ODBC] first time odbc</span></div></div><p class="MsoNormal"> <p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">Why, </span><p><span style="FONT-FAMILY: 'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black;FONT-SIZE: 10pt"> That's a vintage 02-Feb-2006 driver.</span><p><span style="FONT-FAMILY: 'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black;FONT-SIZE: 10pt"> I use 8.04 from Dec-2009 and even that's getting a little stale. Why not try the 9.n drivers.</span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> Could the port(s) be blocked / restricted betweenyou and the server and is PostgreSQL SSL support enabled -- </span><p><span style="FONT-FAMILY: 'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt"> <a href="http://www.postgresql.org/docs/9.0/static/ssl-tcp.html" target="_blank">http://www.postgresql.org/docs/9.0/static/ssl-tcp.html</a></span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black;FONT-SIZE: 10pt"> JMS</span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> </span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> -----------------------------------</span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE:10pt"> </span><blockquote style="BORDER-BOTTOM: medium none; BORDER-LEFT: blue 1.5pt solid; PADDING-BOTTOM: 0in;MARGIN-TOP: 5pt; PADDING-LEFT: 4pt; PADDING-RIGHT: 0in; MARGIN-BOTTOM: 5pt; MARGIN-LEFT: 0in; BORDER-TOP: medium none;BORDER-RIGHT: medium none; PADDING-TOP: 0in"><p class="MsoNormal" style="MARGIN-BOTTOM: 12pt"><span style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">-----Original Message----- <br />From: Marc Fromm<br />Sent: Mar 29, 2011 1:58 PM <br />To: "<a href="mailto:pgsql-odbc@postgresql.org" target="_blank">pgsql-odbc@postgresql.org</a>"<br />Subject: [ODBC] first time odbc <br /><br /></span><p class="MsoNormal"><spanstyle="COLOR: black">Before learning there was an odbc list, I sent this post to the admin list.</span><pclass="MsoNormal"><span style="COLOR: black"> </span><p class="MsoNormal"><span style="COLOR: black">I am runningpostgres on a red hat linux server.</span><p class="MsoNormal"><span style="COLOR: black">postgresql-python-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black">postgresql-test-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black">postgresql-libs-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black">postgresql-docs-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black">postgresql-contrib-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black">postgresql-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black">postgresql-pl-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><b><span style="COLOR: black">postgresql-odbc-08.01.0200-3.1</span></b><spanstyle="COLOR: black"></span><p class="MsoNormal"><span style="COLOR:black">postgresql-jdbc-8.1.407-1jpp.4</span><p class="MsoNormal"><span style="COLOR: black">postgresql-server-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black">postgresql-tcl-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black"> </span><p class="MsoNormal"><spanstyle="COLOR: black">User on windows computers would like to odbc to the postgres databases.</span><pclass="MsoNormal"><span style="COLOR: black">I downloaded the windows postgres odbc drivers from the followingsite and installed version “psqlodbc-08_01_0200” on the windows computer.</span><p class="MsoNormal"><span style="COLOR:black"><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></span><p class="MsoNormal"><spanstyle="COLOR: black"> </span><p class="MsoNormal"><span style="COLOR: black">When I configure a “FileData Source” connection in access, I cannot connect to the postgresql database. I get the message, “A connection couldnot be made using the file data source parameters entered. Save non-verified file DSN?”</span><p class="MsoNormal"><spanstyle="COLOR: black">The parameters entered are:</span><p class="MsoNormal"><span style="COLOR: black">Database:database_name</span><p class="MsoNormal"><span style="COLOR: black">Server: I entered the IP address of theserver</span><p class="MsoNormal"><span style="COLOR: black">User Name: I entered postgres</span><p class="MsoNormal"><spanstyle="COLOR: black">Password:</span><p class="MsoNormal"><span style="COLOR: black">SSL Mode: prefer</span><pclass="MsoNormal"><span style="COLOR: black">Port: 5432 (which is the port used by postgres)</span><p class="MsoNormal"><spanstyle="COLOR: black"> </span><p class="MsoNormal"><span style="COLOR: black">Do I need to configurethe /etc/odbc.ini file? It is currently just a blank file.</span><p class="MsoNormal"><span style="COLOR: black"> </span><pclass="MsoNormal"><span style="COLOR: black">Thanks for any help.</span><p class="MsoNormal"><span style="COLOR:black"> </span><p class="MsoNormal"><span style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 10pt">Marc</span><spanstyle="COLOR: black"></span></blockquote></div></blockquote>
I figured out the permissions problem, by removing superuser and granting select. Now the users can view the data and
notalter it.
I have one last step--locking access down by ip address.
Even though I set only one specific ip address in the pg_hba.conf file, I can odbc to postgresql database from a
varietyof ip addresses on different computers. The postgresql.conf file still has listen_address='*'. If I set
listen_address='one.ip.address'I get connection errors. Is setting listen_address='*' a security risk?
thanks
________________________________
From: jsilberberg@mindspring.com [jsilberberg@mindspring.com]
Sent: Tuesday, March 29, 2011 3:34 PM
To: Marc Fromm; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] ODBC first time odbc
Okay,
You may want to start at the index and read the manual.
But I think you need to "grant select ................" to your ODBC user for your permissions issue.
http://www.postgresql.org/docs/9.0/static/sql-grant.html
JMS..
-----Original Message-----
From: Marc Fromm
Sent: Mar 29, 2011 5:13 PM
To: "pgsql-odbc@postgresql.org"
Subject: [ODBC] ODBC first time odbc
By changing the user that I login with to a super user, everything works. I don’t get the permission denied error.
However, I only want the users to read. Being set as a super user allows the odbc user to change the data.
My problem is now down to two security points:
How do I have a user with only read access (not a super user) and not be denied viewing the table data?
How do I control access with listen_address=’localhost, specific.ip.addresses’ and not use ‘*’?
Setting listen_address=’localhost, specific.ip.addresses’ does not work, I get call failed errors asking if the server
isaccepting tcp/ip connections on port 5432
Thanks
From: Marc Fromm
Sent: Tuesday, March 29, 2011 1:23 PM
To: 'jsilberberg@mindspring.com'
Cc: pgsql-odbc@postgresql.org
Subject: RE: [ODBC] first time odbc
By editing postgresql.conf and changing listen_address = ‘*’ and editing pg_hba.conf and adding host all all
my.ip.addressallowed 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
towork.
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@mindspring.com [mailto:jsilberberg@mindspring.com]
Sent: Tuesday, March 29, 2011 11:13 AM
To: Marc Fromm; pgsql-odbc@postgresql.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@postgresql.org<mailto:pgsql-odbc@postgresql.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
thewindows 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
The listen_address is the server's listening address, not a filter for client addresses. This is only relevant, if the server has different addresses, maybe on different interfaces, and you want for example only one interface to listen to database access requests. IMHO it is usually not a security risk to set it to '*'. Regards, Frank. On Wed, 30 Mar 2011 03:01:10 +0000 Marc Fromm <Marc.Fromm@wwu.edu> wrote: > I figured out the permissions problem, by removing superuser and > granting select. Now the users can view the data and not alter it. > > > > I have one last step--locking access down by ip address. > > Even though I set only one specific ip address in the pg_hba.conf > file, I can odbc to postgresql database from a variety of ip > addresses on different computers. The postgresql.conf file still has > listen_address='*'. If I set listen_address='one.ip.address' I get > connection errors. Is setting listen_address='*' a security risk? > > > > thanks > > ________________________________ > From: jsilberberg@mindspring.com [jsilberberg@mindspring.com] > Sent: Tuesday, March 29, 2011 3:34 PM > To: Marc Fromm; pgsql-odbc@postgresql.org > Subject: Re: [ODBC] ODBC first time odbc > > > > > Okay, > > > > You may want to start at the index and read the manual. > > > > But I think you need to "grant select ................" to your > ODBC user for your permissions issue. > > > > http://www.postgresql.org/docs/9.0/static/sql-grant.html > > > > JMS.. > > > > > > > -----Original Message----- > From: Marc Fromm > Sent: Mar 29, 2011 5:13 PM > To: "pgsql-odbc@postgresql.org" > Subject: [ODBC] ODBC first time odbc > > By changing the user that I login with to a super user, everything > works. I don’t get the permission denied error. However, I only want > the users to read. Being set as a super user allows the odbc user to > change the data. > > My problem is now down to two security points: > How do I have a user with only read access (not a super user) and not > be denied viewing the table data? > > How do I control access with listen_address=’localhost, > specific.ip.addresses’ and not use ‘*’? Setting > listen_address=’localhost, specific.ip.addresses’ does not work, I > get call failed errors asking if the server is accepting tcp/ip > connections on port 5432 > > Thanks > > > From: Marc Fromm > Sent: Tuesday, March 29, 2011 1:23 PM > To: 'jsilberberg@mindspring.com' > Cc: pgsql-odbc@postgresql.org > Subject: RE: [ODBC] first time 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 > > > From: jsilberberg@mindspring.com [mailto:jsilberberg@mindspring.com] > Sent: Tuesday, March 29, 2011 11:13 AM > To: Marc Fromm; pgsql-odbc@postgresql.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@postgresql.org<mailto:pgsql-odbc@postgresql.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 > -- Frank Finner Köpfchenstraße 36 57072 Siegen