> Wanting to configure CFAdmin Datasource for MySQL which is located on a > remote server using SSH. I'm using Bitvise to run and > successfully login to the remote server using SSH, which then sits in the > system tray. The user credentials are setup in the remote > MySQL db and do work as I can use SQLYog to connect to this database. > > I was thinking that in CF8 Datasource area, I would call out the following: > > Database = mydb > Username = myusername > PWD = somepassword > Server = localhost > Port = 3306 > > But I get an access denied message. > > Is there something I'm missing here? Should SSH be configured within CF > Admin and not use Bitvise (which I would actually prefer). > Or can CF8 not handle remoting with SSH?
CF runs as a service, and it doesn't have access to other user's resources. You've logged in via Bitvise (or any other SSH client) in your own session. When you log out, your SSH session ends. CF has no way to get to that. If you want to use Bitvise or an ssh client, it will need to run in the CF user's session. Since you're on Windows, you'd have to configure CF to run as a local user (instead of SYSTEM) and you'd have to configure Bitvise to automatically run for that user. I'm not entirely sure that's possible, to be honest. You could probably have a login script for the user start a command-line SSH client. Alternatively, you could run the Bitvise SSH client as a service, which would presumably make it available for any other service to use. http://www.bitvise.com/ssh-client-as-windows-service CF doesn't natively support SSH tunnels to remote servers in order to connect to datasources, but this can be done in Java using JSch: http://www.jcraft.com/jsch/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:354057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
