ColdFusion MX 6.0 (up to and including 6.0 U3) did not provide a driver for connecting
to PostgreSQL databases, although the postgresql.cfm file that you found did exist
under the ColdFusion Administrator root. That page was not accessible in any way as a
link from the CFAdmin, so you must have discovered the page by exploring the docroot
and then manually requesting it.
ColdFusion MX 6.1 removed that page, as it was unused in the first place, and so you
got a page not found error. ColdFusion MX 6.1 also does not provide a driver for
PostgreSQL.
See the details on the System Requirements here:
System requirements for UNIX
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro6.htm
You can configure a PostgreSQL datasource through the recommended means described here:
ColdFusion MX: Enabling a JDBC data source for PostgreSQL
http://www.macromedia.com/support/coldfusion/ts/documents/tn18338.htm
-Steven Erat
-----Original Message-----
From: Tom Jones [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 5:20 PM
To: CF-Talk
Subject: postgresql.cfm not found in MX 6.1
>I've now run into a problem with a fresh install of MX 6.1 (RH 9,
>Apache 2.0.47, PostgreSQL 7.3.2). No problems with the basic install
>and CF and Apache are playing nice.
>
>Administrator, however, is causing problems. I am trying to configure a
>PostgreSQL datasource - CF Administrator allows me to provide the
>datasource details, but when I try to verify, edit, or delete the
>datasource, I get a file not found error for
>/CFIDE/administrator/datasources/postgresql.cfm!
Well, it turns out that I had PostgreSQL mis-configured--it wasn't accepting TCP/IP
connections.
The "-i" start up parameter was commented out in postgres/postmaster.conf (forget what
it was called at this point--it's been a long two-days), which is what enables the
TCP/IP connections to the db, apparently.
What is odd is that I still don't have a
/CFIDE/administrator/datasources/postgresql.cfm file, but the administrator doesn't
seem to mind anymore, though the datasources I had set up prior to the .conf update
still error out if I try to edit or remove them.
I don't know if this is truly the answer to the problem, but I will take it!
For the record, I am using the PostgreSQL 7.3 JDBC2 driver for JDK 1.2 & 1.3,
available at postgresql.org.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
