Re: Automating data source password changes

2006-10-11 Thread Dan Parker
How are getting an encrypted value before it gets placed in neo-query? I'm using the encrypted password that's currently in the neo-query.xml file. I think it takes the epassword value and compares it to what's in neo-query.xml to make sure it matches before it changes the password to the new

Re: Automating data source password changes

2006-10-10 Thread Dan Plesse
Dan, First CF 6 does not have the admin stuff only CF 7. (I am not sure if that was because I was selling lots admin software and add ons or not) Second the password attribute in cfquery overrides the datasource password and lastly you have to encode the password before you add it to neo. I

Re: Automating data source password changes

2006-10-10 Thread Robertson-Ravo, Neil (RX)
://www.reedexpo.com -Original Message- From: Dan Plesse To: CF-Talk Sent: Tue Oct 10 08:29:57 2006 Subject: Re: Automating data source password changes Dan, First CF 6 does not have the admin stuff only CF 7. (I am not sure if that was because I was selling lots admin software and add ons

Re: Automating data source password changes

2006-10-10 Thread Robertson-Ravo, Neil (RX)
2006 Subject: Re: Automating data source password changes Dan, First CF 6 does not have the admin stuff only CF 7. (I am not sure if that was because I was selling lots admin software and add ons or not) Second the password attribute in cfquery overrides the datasource password and lastly you

RE: Automating data source password changes

2006-10-10 Thread Snake
October 2006 08:32 To: CF-Talk Subject: Re: Automating data source password changes Lol you reckon that Macromedia didn't ship any stuff like this because you had developed other means already?! This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN

RE: Automating data source password changes

2006-10-10 Thread Snake
: 09 October 2006 19:32 To: CF-Talk Subject: Re: Automating data source password changes For our MX 6 server, I've been working with the following code. It keeps giving a numerical error. The number seems to be based on the password that I pass to the component: cfset setDSN=createObject(component

Re: Automating data source password changes

2006-10-10 Thread Andy Allan
2006 08:32 To: CF-Talk Subject: Re: Automating data source password changes Lol you reckon that Macromedia didn't ship any stuff like this because you had developed other means already?! This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN

Re: Automating data source password changes

2006-10-10 Thread Dan Plesse
Whoops cfide.administrator.components.datasource is around in 6 I assumed incorrectly he was talking about the Admin API. Still the password has to be a special format I think that was a pain. Neil the truth is out there. Go google and post the solution.

Re: Automating data source password changes

2006-10-10 Thread Dan Parker
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

Re: Automating data source password changes

2006-10-10 Thread Dan Plesse
How are getting an encrypted value before it gets placed in neo-query? If you pull out an encrypted value from neo-query then you are getting the old value since neo is your backup file. What you need to do is create new value and place those values into neo.

Re: Automating data source password changes

2006-10-09 Thread Tom Chiverton
On Monday 09 October 2006 14:50, Dan Parker wrote: Does anyone know of a way to to change the passwords without logging into the CF Administrator? We are on MX 6.1 and use Oracle data sources. You could load, parse and update neo-query.xml yourself. -- Tom Chiverton Helping to adaptively

Re: Automating data source password changes

2006-10-09 Thread Steve Moore
Dan, This script can be scheduled, is does require the CF admin password to be used, hardcoded here. This one uses JDBC Oracle connection. cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(adminpassword); myObj =

Re: Automating data source password changes

2006-10-09 Thread Dan Parker
For our MX 6 server, I've been working with the following code. It keeps giving a numerical error. The number seems to be based on the password that I pass to the component: cfset setDSN=createObject(component,cfide.administrator.components.datasource) cfinvoke component=#setDSN#