Re: SSL on CFquery

2013-04-19 Thread Richard White
Thanks Russ, ill take a look into this >You don't, afaik ypu simply need the client cert in the java keystore. >See this >http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-using-ssl.html > >There is a handu cfadmin extension on riaforge.org for managing your >keystore. > >Regards >Russ

Re: SSL on CFquery

2013-04-16 Thread Russ Michaels
You don't, afaik ypu simply need the client cert in the java keystore. See this http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-using-ssl.html There is a handu cfadmin extension on riaforge.org for managing your keystore. Regards Russ Michaels www.michaels.me.uk www.cfmldeveloper.co

Re: SSL on CFquery

2013-04-16 Thread Richard White
Hi, We have a further issue with this. The hosting company have installed the SSL certificate on the database and provided us with the details of where the certificate is stored. However, in the CF connection string it asks to provide the url of the certificate. I am confused about how to g

Re: SSL on CFquery

2013-04-16 Thread Richard White
Perfect! Many thanks Russ :) > Do the following to enable SSL connection: > > 1. > > In the ColdFusion Administrator, go to Data & Services > Data Sources. > > 2. > > Select the data source to enable SSL Connection. > 3. > > In the data source page, click Show Advance

Re: SSL on CFquery

2013-04-16 Thread Russ Michaels
Do the following to enable SSL connection: 1. In the ColdFusion Administrator, go to Data & Services > Data Sources. 2. Select the data source to enable SSL Connection. 3. In the data source page, click Show Advanced Settings. 4. In the Connection String text box, spec

SSL on CFquery

2013-04-16 Thread Richard White
Hi, We have a windows server for our CF application and a Linux server for our database. We are setting up a self-signed SSL between the two servers. Our hosting company have said we need to reference the SSL in the connection string but how can I do this in a cfquery? Many thanks Richard ~