Skip to main content
dejank52055655
dejank52055655
Inspiring
February 19, 2024
Answered

How to update the connection string field in multiple datasources in cfadmin

  • February 19, 2024
  • 1 reply
  • 504 views

I have to update the connection string property in about 200 datasources in CF admin on mutiple servers. I'm looking for an easier wasy to do this instead of editing each datasource, perhaps editing a file or something. Does anyone have any suggestions on how to do that?

 

    This topic has been closed for replies.
    Correct answer Charlie Arehart

    Yes, you could.. And note that the json file does NOT have unencrypted passwords. It holds what the neo-datasource.xml file holds for the same passwords: they ARE encrypted, by cf.

     

    The issue (as I discuss in the talk and is discussed in the cf docs) is that the json file ALSO includes the encryption KEY. As such, someone who has the json file can import that into ANY cf instance (as that instance would use that key to decrypt it, then it would be encrypted by the key in the instance, to be saved in its neo-datasource.xml file) .

     

    And so that's why the cfsetup export offers an option to also choose a passkey, which encrypts that encrypted password in the file. 🙂 Then one can only import the json IF they provide that passkey.

     

    Honestly, if a global find/replace on the neo-datasource.xml file can be done (to change what you need--and ONLY what you need), that would be one step rather than a few. 🙂

     

    Either way, let us know how it goes. 

    1 reply

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    February 19, 2024

    There are at least a couple of options. You haven't said what cf version you're running. Cf2021 added a command line cfsetup tool that allows editing such admin settings. (See the docs on that, or a talk on did a few weeks ago, at carehart.org/presentations.)

     

    Or you can also directly edit the neo-datasource.xml file, in the cfusion/lib folder,.if a global find/replace might work. (Be sure to save a copy of the file before editing it.) Then restart cf for the change to take effect. 

    /Charlie (troubleshooter, carehart. org)
      dejank52055655
      dejank52055655Author
      Inspiring
      February 20, 2024

      Thank you for suggesting both options. I'm using CF2021.

      I watched your presentation Using Adobe's CFSetup tool to manage CF Admin settings for ANY CF version, C. Arehart--CFMeetup #299 and its super helpful on this subject! I'm especially interested in utilizing this tool and export/import with CF in Docker so I'll be watching your other presentations.

       

      Lets say I export datasources in json file. Can I edit this json file (No setup passphrase) and update the keySetting called args (connection string in CFadmin GUI) setting, save it, then re-import the file?  I think I would delete the json file since its not encrypted as suggested. I would like to explore this tool before editing the neo file.

      Charlie Arehart
      Community Expert
      Charlie ArehartCommunity ExpertCorrect answer
      Community Expert
      February 20, 2024

      Yes, you could.. And note that the json file does NOT have unencrypted passwords. It holds what the neo-datasource.xml file holds for the same passwords: they ARE encrypted, by cf.

       

      The issue (as I discuss in the talk and is discussed in the cf docs) is that the json file ALSO includes the encryption KEY. As such, someone who has the json file can import that into ANY cf instance (as that instance would use that key to decrypt it, then it would be encrypted by the key in the instance, to be saved in its neo-datasource.xml file) .

       

      And so that's why the cfsetup export offers an option to also choose a passkey, which encrypts that encrypted password in the file. 🙂 Then one can only import the json IF they provide that passkey.

       

      Honestly, if a global find/replace on the neo-datasource.xml file can be done (to change what you need--and ONLY what you need), that would be one step rather than a few. 🙂

       

      Either way, let us know how it goes. 

      /Charlie (troubleshooter, carehart. org)
        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices