I finally figured it out. The only piece that I was missing was the correct
value of the "epassword" attribute of the
"cfide.administrator.components.datasource" component. The epassword value is
the encrypted value of the current password.
For example, let's say the current password for the "parker" data source is
"myCoolPassword". The encrypted value for this password (the way it appears in
the neo-query.xml file) is "804E2F250FAFD1B75E7AE1DB4D95801F". So, in order to
change the password, I have to pass the encrypted password like this:
<cfset
setDSN=createObject("component","cfide.administrator.components.datasource")>
<cfinvoke component="#setDSN#" method="setOracle">
<cfinvokeargument name="dsn" value="parker"/>
<cfinvokeargument name="host" value="[IP removed]"/>
<cfinvokeargument name="sid" value="[SID Removed]"/>
<cfinvokeargument name="port" value="1813"/>
<cfinvokeargument name="username" value="parker"/>
<cfinvokeargument name="password" value="myNewPassword"/>
<cfinvokeargument name="epassword" value="804E2F250FAFD1B75E7AE1DB4D95801F"/>
<cfinvokeargument name="class" value="macromedia.jdbc.MacromediaDriver">
</cfinvoke>
The password changes as expected.
Now that I've figured that out, to automate the pw chages, I will need to get
the list of data sources, probably using <cfobject
component="cfide.administrator.components.datasource" name="ds"> and
ds.getdatasource(), loop over the data sources, and update them with the new
passwords .....I'll be back in about three years when I figure all that out :-)
Thanks for the replies!!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256185
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
