Moving datasources to new server

Report · Oct 10, 2011

I have an applications group who is hosting with CF9. At some point we'll be using the multi-server version and in the interest of setting up servers quickly and efficiently, my team is using Puppet and RunDeck to manage configuration files, installation of packages, etc. We'd like to cut out the Administrator Page of CF9 as much as possible. To that end, I know that if I use Puppet to copy neo-datasource.xml to a new server, the datasources will show up on the Admin page, but the connections fail. If I try to verify the (previously working) datasources, the Admin page shows driver failures. However, if I select "Edit" instead of "Verify" and just hit "Submit" (i.e., no changes to the datasource, just a lengthier version of "Verify"), the datasources come back OK and the connections come up. Can anybody explain this or what I need to do to get the datasources working in the first place without needing to go to the Admin page and hit "Edit" -> "Submit"?

Thanks!

Report · Oct 10, 2011

Hi,

I've tried that before and retried just now to refresh myself on that matter.

I took a neo-datasource.xml from CF8 Standard with multiple configured databases (tho all MS SQL type) and replaced a CF9 Enterprise

JRun4\servers\instance\cfusion.ear\cfusion.war\WEB-INF\cfusion\lib file and found the datasources to verify either individually or verify all

connections button. Oddly different to what your experiencing.

Not wanting to use CFadmin. What about use CF Server Manager?

CF Server Manager also verified copied neo-datasource.xml datasources.

HTH, Carl.

Report · Oct 10, 2011

PS

Still on CF Server Manager, this might be worth a try. Setup a CF9 host with desired datasources that verify. Apply the working datasources to another server in CF Server Manager.

HTH, Carl.