> > I have a remote Redhat 5.0 box running PostgreSQL 8.0 and it's set > to accept SSL connections only. I have the 3 root/cert files > necessary for > > the handshaking to occur between host and client. The datasource to > the box works fine when unencrypted: jdbc:postgresql://x.x.x.x/main > (with > > ?ssl=true to be appended for encryption). > > > > My question is where do I put these files? I am running CF8 > Enterprise on Windows 2003. On my local machine I would have them in > the > > %appdata%/postgresql folder but this is a production-level box that > access the internet. > > You'll have to add the server cert to the client's Java keystore as > described here: > http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php
Thank you for the direction! My only question with this is that the host box is creating this keystore, so how will it be moved to the remote client box? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
