Re: unixODBC vs postgeSQL driver on RHEL4?

From: Greg Martin <gamartin(at)shout(dot)net>
To: Rainer Hochreiter <rainer(at)hochreiter(dot)at>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: unixODBC vs postgeSQL driver on RHEL4?
Date: 2005-10-18 06:01:58
Message-ID: Pine.LNX.4.58.0510180056150.24258@duracef.shout.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Rainer,
I used the standard /var/lib/pgsql/data/pg_hba.conf provided
with the RHEL4/CentOS4 RPM's... the only non-commented line is:

local all all ident sameuser

I must confess I don't fully understand the entries here, but I didn't touch
them and the comments say this gives everyone local access. Also since
the unixODBC driver works it seems like pg_hba.conf can't be the problem...

Another possibility I don't understand at all is that this is some byproduct
of Security Enhanced Linux (SEL) preventing the 2nd driver from running...
anybody know enough to comment on this?

Greg Martin
gamartin(at)shout(dot)net

On Mon, 17 Oct 2005, Rainer Hochreiter wrote:

>
> > Hello,
> > I have utterly failed getting the postgreSQL ODBC driver working
> > with unixODBC on Red Hat Enterprise Linux 4 for Intel (actually CentOS4
> > but it's supposed to be the same thing) using the standard RPM packages.
> > However, the driver provided with the unixODBC package works fine.
> > I have tried lots of different tweaks in the config files and have
> > concluded
> > I must be missing something basic.
> > I would simply shrug and use the unixODBC-provided driver, except
> > that I'd like to use the most current ODBC driver and my understanding
> > is the unixODBC-provided driver is somewhat out of date. Plus it's
> > pretty damn annoying that I can't get it to work at all with the
> > PostgreSQL-provided driver.
> > Here's what I'm using:
> >
> > postgresql-server-7.4.8-1.RHEL4.1
> > postgresql-odbc-7.3-8.RHEL4.1
> > postgresql-libs-7.4.8-1.RHEL4.1
> > postgresql-7.4.8-1.RHEL4.1
> >
> > unixODBC-devel-2.2.9-1
> > unixODBC-2.2.9-1
> >
>
> hi,
> have the same problem the other way around?!
> here is what i have:
> postgresql-7.3.4-3.rhl9.i386.rpm
> postgresql-devel-7.3.4-3.rhl9.i386.rpm
> postgresql-libs-7.3.4-3.rhl9.i386.rpm
> postgresql-odbc-7.3-4.i386.rpm
> postgresql-server-7.3.4-3.rhl9.i386.rpm
>
> unixODBC-2.2.11-1.i386.rpm
> unixODBC-devel-2.2.11-1.i386.rpm
>
> BTW, how does your /var/lib/pgsql/data/pg_hba.conf look like?
>
> ;-) rainer

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Tom Hughes 2005-10-19 14:07:22 EN_Destructor bug?
Previous Message Greg Campbell 2005-10-17 12:59:31 Re: vb6 inquiry