In the CF admin you can specify any location to a local or remote mysql
server.
You will need to install stunnel on both the database and cf boxes. The
site has the install instructions. Once set it up, you would route the
communication through it.
"If the server admin, needs to implement it, it will be pushed back
since he is swamped."
He will and they always are :) ,but seriously you don't want the backend
database communications to not be secured. If you are doing any
e-commerce or sensitive stuff you would be leaving it wide open on the
backend.
John
[email protected]
On 9/9/12 3:06 PM, Chris wrote:
Thanks John:
Can you please advice how I can implement option 2? I am new to this.
My development machine has MySQL, Coldfusion and IIS running on the
same box so I am not familiar with doing this.
Now, is using stunnel something I need to do or our server
administrator? If the server admin, needs to implement it, it will be
pushed back since he is swamped.
Thanks
------------------------------------------------------------------------
*From:* John Mason <[email protected]>
*To:* [email protected]
*Sent:* Sunday, September 9, 2012 12:02 PM
*Subject:* Re: [ACFUG Discuss] Communicating with a data source moved
to on another server
If you do option2, make sure that the datasource connection between
the two servers is secure in some manner. Probably one of the easiest
things to do is to use stunnel (http://www.stunnel.org/index.html) and
create a simple SSL wrapper for the calls. Takes about 5mins to set up.
John
[email protected] <mailto:[email protected]>
On 9/8/12 9:42 PM, Troy Jones wrote:
Chris,
I think what you’re asking is that you want a cfc that is hosted on a
remote server to access your datasource, hosted on your server? If
so, I do not know of a way to do that although it may be possible
and I’m just not aware of it. I’d recommend one of two things:
1). Move your local datasource and database to the remote server and
all will be good as before.
2). If this is not possible, then create a datasource on the remote
server and point the connection to your server’s MySQL database.
*From:*[email protected] <mailto:[email protected]>
[mailto:[email protected]] *On Behalf Of *Chris
*Sent:* Saturday, September 08, 2012 3:55 PM
*To:* [email protected] <mailto:[email protected]>
*Subject:* [ACFUG Discuss] Communicating with a data source moved to
on another server
Initially, we had on the same box, a MySQL server, a Coldfusion
server so when a MySQL database named "mydatabase" was referenced in
the Coldfusion component file, the application worked.
The application is a Flex front end, Coldfusion middle tier and MySQL
back end. The Flex component communicates with Coldfusion using
remoting services.
Now, the Coldfusion is provided by a off-site hosting provider to
avoid costs of a Coldfusion license. However, the datasource named
"mydatabase"
cannot be accessed by the Coldfusion component since it is on the
on-site server. The error message is "Unable to invoke CFC operation
failed on the orf2344_cfvars data source"
What needs to be done so that the Coldfusion component can access the
datasource named "mydatabase"? Our server administrator who changed
the servers does not
have time to look into this so I need to find out what could have
gone wrong and inform him how to fix it.
Any suggestions would be appreciated.
Thanks
------------------------------------------------------------------------
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com/>
Version: 2012.0.2197 / Virus Database: 2437/5256 - Release Date: 09/08/12
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
<http://www.acfug.org/?fa=login.edituserform>
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
<http://www.acfug.org/?fa=login.edituserform>
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com/>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
