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

Re: ODBC first time 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" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC first time odbc
Date: 2011-03-29 22:34:12
Message-ID: 16057942.1301438053137.JavaMail.root@elwamui-polski.atl.sa.earthlink.net (view raw or flat)
Thread:
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>
<P><FONT color=#000000><FONT size=2><FONT face=arial,sans-serif></FONT></FONT></FONT>&nbsp;</P>
<P><FONT size=2 face=Arial>Okay, </FONT></P>
<P><FONT size=2 face=Arial></FONT>&nbsp;</P>
<P><FONT size=2 face=Arial>&nbsp;&nbsp; You may want to start at the index and read the manual.&nbsp;&nbsp; </FONT></P>
<P><FONT size=2 face=Arial></FONT>&nbsp;</P>
<P><FONT size=2 face=Arial>&nbsp;&nbsp;&nbsp; But I think you need to "grant select ................" to your ODBC user for your permissions issue.</FONT></P>
<P><FONT size=2 face=Arial></FONT>&nbsp;</P>
<P><FONT size=2 face=Arial>&nbsp;&nbsp;&nbsp; <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>
<P><FONT size=2 face=Arial></FONT>&nbsp;</P>
<P><FONT size=2 face=Arial>&nbsp;&nbsp;&nbsp; JMS.. </FONT></P>
<P><FONT color=#000000><FONT size=2><FONT face=arial,sans-serif></FONT></FONT></FONT>&nbsp;</P>
<P><FONT color=#000000><FONT size=2><FONT face=arial,sans-serif>&nbsp;</P>
<P><BR></P></FONT></FONT></FONT>
<BLOCKQUOTE style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 0px">-----Original Message----- <BR>From: Marc Fromm <MARC(dot)FROMM(at)WWU(dot)EDU><BR>Sent: Mar 29, 2011 5:13 PM <BR>To: "pgsql-odbc(at)postgresql(dot)org" <PGSQL-ODBC(at)POSTGRESQL(dot)ORG><BR>Subject: [ODBC] ODBC first time odbc <BR><BR><?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=utf-8" http-equiv="Content-Type"><ZZZmeta name="Generator" content="Microsoft Word 14 (filtered medium)">
<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>
<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" bgcolor="white">
<DIV class=WordSection1>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">By changing the user that I login with to a super user, everything works. I don’t get the permission denied error.<o:p></o:p></SPAN></P>
<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 the data.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">My problem is now down to two security points:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">How do I have a user with only read access (not a super user) and not be denied viewing the table data?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">How do I control access with listen_address=’localhost, specific.ip.addresses’ and not use ‘*’?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">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<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Thanks<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<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(at)mindspring(dot)com'<BR><B>Cc:</B> pgsql-odbc(at)postgresql(dot)org<BR><B>Subject:</B> RE: [ODBC] first time odbc<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p>&nbsp;</o:p></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">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. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">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)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Any ideas?<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Also in the postgresql instead of listen_address=’*’ I tried listen_address=’localhost, my.ip.address’ but that failed to work.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">How can I keep local host and only allow specific address? I don’t want to open it up to all with ‘*’<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Thanks<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p>&nbsp;</o:p></SPAN></P>
<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(at)mindspring(dot)com [mailto:jsilberberg(at)mindspring(dot)com] <BR><B>Sent:</B> Tuesday, March 29, 2011 11:13 AM<BR><B>To:</B> Marc Fromm; pgsql-odbc(at)postgresql(dot)org<BR><B>Subject:</B> Re: [ODBC] first time odbc<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p>&nbsp;</o:p></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">Why, <o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;&nbsp;&nbsp; That's a vintage 02-Feb-2006 driver.<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;&nbsp;&nbsp;&nbsp; I use 8.04 from Dec-2009 and even that's getting a little stale.&nbsp; Why not try the 9.n drivers.<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Could the port(s) be blocked / restricted between you and the server and is PostgreSQL SSL support enabled -- <o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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><o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JMS<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">&nbsp;&nbsp;&nbsp;&nbsp;-----------------------------------<o:p></o:p></SPAN></P>
<P><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"><o:p>&nbsp;</o:p></SPAN></P>
<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 style="MARGIN-BOTTOM: 12pt" class=MsoNormal><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(at)postgresql(dot)org" target=_blank>pgsql-odbc(at)postgresql(dot)org</A>" <BR>Subject: [ODBC] first time odbc <BR><BR><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Before learning there was an odbc list, I sent this post to the admin list.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">&nbsp;<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">I am running postgres on a red hat linux server.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-python-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-test-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-libs-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-docs-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-contrib-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-pl-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><B><SPAN style="COLOR: black">postgresql-odbc-08.01.0200-3.1</SPAN></B><SPAN style="COLOR: black"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-jdbc-8.1.407-1jpp.4<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-server-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">postgresql-tcl-8.1.23-1.el5_6.1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">&nbsp;<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">User on windows computers would like to odbc to the postgres databases.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">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></SPAN></P>
<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><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">&nbsp;<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">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></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">The parameters entered are:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Database: database_name<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Server: I entered the IP address of the server<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">User Name: I entered postgres<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Password:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">SSL Mode: prefer<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Port: 5432 (which is the port used by postgres)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">&nbsp;<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Do I need to configure the /etc/odbc.ini file? It is currently just a blank file.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">&nbsp;<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Thanks for any help.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">&nbsp;<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE: 10pt">Marc</SPAN><SPAN style="COLOR: black"><o:p></o:p></SPAN></P></BLOCKQUOTE></DIV></ZZZbody></ZZZhtml></BLOCKQUOTE></ZZZ![endif]--></ZZZ!--[if></ZZZ![endif]--></ZZZ!--[if></ZZZmeta></ZZZmeta></BODY>


Attachment: unknown_filename
Description: text/html (14.7 KB)

Responses

pgsql-odbc by date

Next:From: Marc FrommDate: 2011-03-30 03:01:10
Subject: Re: ODBC first time odbc
Previous:From: Marc FrommDate: 2011-03-29 21:13:22
Subject: ODBC first time odbc

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