[GRASS-user] PG Database Connection in GRASS 6.3

At Lorenzo’s suggestion, I updated by PostgreSQL to the current version. This added the missing library (libpq.5.dylib) to /usr/local/pgsql/lib.

Database connection from the command line now works properly. However, from the GUI (tcltk) I still get the error:

Bad file descriptor: dup r
dbmi: Protocol error

Unable to start driver

Perhaps a GUI issue?

Dave

Begin forwarded message:

From: William Kyngesburye <kyngchaos@kyngchaos.com>
Date: June 2, 2008 12:06:19 PM GMT-04:00
To: David Kindem <dkindem@chartermi.net>
Cc: Markus Neteler <neteler@osgeo.org>
Subject: Re: [GRASS-user] PG Database Connection in GRASS 6.3

On Jun 2, 2008, at 10:51 AM, Markus Neteler wrote:

(David, I meant to tell the list…)

William, any hint for David? I have no idea about Mac…

Markus

On Mon, Jun 2, 2008 at 11:50 AM, David Kindem <dkindem@chartermi.net> wrote:

In the GUI, I get the following when I try to list tables:

db.tables driver=pg database=grghm

Bad file descriptor: dup r
dbmi: Protocol error

Unable to start driver

From the command line, the response is a bit different:

GRASS 6.3.0 (GRGHM_UTM):~ > db.tables driver=pg database=grghm
dyld: Library not loaded: /usr/local/pgsql/lib/libpq.5.dylib
Referenced from:
/Applications/GrassGIS/GrassGIS.app/Contents/Resources/app/grass-6.3.0/driver/db/pg
Reason: image not found
dbmi: Protocol error
ERROR: Unable to start driver

Since this is Lorenzo’s binary, you’ll have to ask him for more details.

But generally, it doesn’t find libpq. Lorenzo may have forgotten to include libpq in the app bundle.


William Kyngesburye <kyngchaosatkyngchaosdotcom>
http://www.kyngchaos.com/

Theory of the Universe

There is a theory which states that if ever anyone discovers exactly what the universe is for and why it is here, it will instantly disappear and be replaced by something even more bizarrely inexplicable. There is another theory which states that this has already happened.

-Hitchhiker’s Guide to the Galaxy 2nd season intro