[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] Interchange remote Postgres TCP


On Thu, 19 Jul 2007, Stephen Peters wrote:

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...

It appears to me that your DSN setting is being overwritten somewhere else. I suggest grepping for it, like this:

cd /path/to/catalog
grep -ri 'dbi:pg:' .

and see where else the DSN may be getting set.

Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.