[ic] Interchange remote Postgres TCP

Mike Heins mike at perusion.com
Thu Jul 19 12:06:27 EDT 2007

Quoting Stephen Peters (speters at killbygayford.co.uk):
> On Thu, 2007-07-19 at 10:11 -0400, Mike Heins wrote:
> > I assume you can connect to that DSN from a standard Perl DBI call:
> > 
> >     perl -MDBI -le "DBI->connect( \
> > 	qq{dbi:mysql:dbname=test_found;host='my.postgres.server':5432} \
> > 	) and print qq{OK!}"
> > 
> When I tried to connect with a standard Perl DBI call (after I corrected
> my syntax) I can connect to the database. e.g.
> perl -MDBI -le 'DBI->connect( \
> 	qq{dbi:Pg:dbname=standard;host=my.postgres.server;port=5432;} \
> 	) and print qq{OK!}'
> > Why do you have single quotes in the DSN? Have you tried without them?
> This was an attempt to figure out why the error was truncating the DSN
> e.g.
> Configuring catalog standard...Using PostgreSQL,
> DSN=dbi:Pg:dbname=standard...
> > Why do you call out the port when 5432 is the standard for a remote
> > host?
> > 
> I could not see why the database access was trying to connect locally so
> I tried to explicitly name the host and port.
> With the following entry
> in /var/lib/interchange/catalogs/standard/catalog.cfg I still cannot
> connect to the database:
> ifndef SQLDSN
> Variable  SQLDSN
> dbi:Pg:dbname=standard;host='my.postgres.server';port=5432;
> Variable  SQLDB   standard
> Variable  SQLUSER standard
> Variable  SQLPASS lamepassword
> endif

Looks like you still have single quotes there -- why? You
haven't done what is suggested.

In any case, remote DSNs work fine with IC and there have been no
reports other than yours with doubtful syntax.

Suggest you start from scratch and use a standard DSN instead of trying
to specify port and single quotes when you don't need to.

Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

Unix version of an Outlook-style virus:
It works on the honor system. Please forward this message to everyone
you know, and delete a bunch of your files at random.

More information about the interchange-users mailing list