Re: Automating data source password changes
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 one. If you log into the ColdFusion administrator, go to the page where you can update a data source. View the html source of the page and you will see that epassword is a hidden form field. They are passing the encrypted value of the soon to be old password. ~| 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:256256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 have to encode the password before you add it to neo. I can't imagine editing neo-query manually and adding an unencrypted password. If it works let us know. I assume CF decrypts the password before it is used anyway. Of course I know how to encrypt and in the right format, but I am not telling. Dan ~| 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:256073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://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 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 can't imagine editing neo-query manually and adding an unencrypted password. If it works let us know. I assume CF decrypts the password before it is used anyway. Of course I know how to encrypt and in the right format, but I am not telling. Dan ~| 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:256074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Automating data source password changes
I assume CF decrypts the password before it is used anyway. Of course I know how to encrypt and in the right format, but I am not telling. In CF6 or CF7? I know in 6, it is a piece of cake to get the key for encrypt/decrypt... Not tried in 7 yet, but I am sure it is achievable with a little work and Googling :-) This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://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 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 can't imagine editing neo-query manually and adding an unencrypted password. If it works let us know. I assume CF decrypts the password before it is used anyway. Of course I know how to encrypt and in the right format, but I am not telling. Dan ~| 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:256076 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Automating data source password changes
You can work with the Java Service Factory directly in CFMx6 which does the same thing albeit with more work. In fact I have still had to do things this way as the AdminAPI in CFMX7 doesn't work right. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 10 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, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://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 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 can't imagine editing neo-query manually and adding an unencrypted password. If it works let us know. I assume CF decrypts the password before it is used anyway. Of course I know how to encrypt and in the right format, but I am not telling. Dan ~| 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:256078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Automating data source password changes
I did a Web Service API that allows you to remotely setup DSN's, mappings and sandboxes, it is being used in HELM control panel. I could not solve this error so we reverted back to using the Java Service Factory. Russ -Original Message- From: Dan Parker [mailto:[EMAIL PROTECTED] Sent: 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,cfide.administrator.components.datasource) cfinvoke component=#setDSN# method=setOracle cfinvokeargument name=dsn value=parkerd/ cfinvokeargument name=host value=[IP removed]/ cfinvokeargument name=sid value=[SID removed]/ cfinvokeargument name=port value=1813/ cfinvokeargument name=username value=thisUser/ cfinvokeargument name=password value=howBoutThat/ cfinvokeargument name=epassword value=howBoutThat/ cfinvokeargument name=class value=macromedia.jdbc.MacromediaDriver /cfinvoke 11 The error occurred in E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 332 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 3 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 1 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\datasource.cfc: line 540 Called from E:\Inetpub\wwwroot\virt.parker\dsp\setMyDatasource.cfm: line 18 Called from E:\Inetpub\wwwroot\virt.parker\index.cfm: line 11 Stack Trace at cfsetdsn2ecfm2110276039._factor4(E:\Inetpub\wwwroot\CFIDE\administrator\comp onents\_datasource\setdsn.cfm:332) at cfsetdsn2ecfm2110276039._factor5(E:\Inetpub\wwwroot\CFIDE\administrator\comp onents\_datasource\setdsn.cfm:3) at cfsetdsn2ecfm2110276039.runPage(E:\Inetpub\wwwroot\CFIDE\administrator\compo nents\_datasource\setdsn.cfm:1) at cfdatasource2ecfc1645517805$funcSETORACLE.runFunction(E:\Inetpub\wwwroot\CFI DE\administrator\components\datasource.cfc:540) at cfsetMyDatasource2ecfm1566537573.runPage(E:\Inetpub\wwwroot\virt.parker\dsp\ setMyDatasource.cfm:18) at cfindex2ecfm919545483.runPage(E:\Inetpub\wwwroot\virt.parker\index.cfm:11) java.lang.ArrayIndexOutOfBoundsException: 11 at coldfusion.sql.TwoFishCryptor.toByte(TwoFishCryptor.java:162) at coldfusion.sql.TwoFishCryptor.decrypt(TwoFishCryptor.java:65) at coldfusion.sql.Executive.mapModified(Executive.java:258) at coldfusion.server.ConfigMap.setChanged(ConfigMap.java:64) at coldfusion.server.ConfigMap.put(ConfigMap.java:238) at coldfusion.runtime.Struct.StructInsert(Struct.java:409) at coldfusion.runtime.CFPage.StructInsert(CFPage.java:4091) at cfsetdsn2ecfm2110276039._factor4(E:\Inetpub\wwwroot\CFIDE\administrator\comp onents\_datasource\setdsn.cfm:332) at cfsetdsn2ecfm2110276039._factor5(E:\Inetpub\wwwroot\CFIDE\administrator\comp onents\_datasource\setdsn.cfm:3) at cfsetdsn2ecfm2110276039.runPage(E:\Inetpub\wwwroot\CFIDE\administrator\compo nents\_datasource\setdsn.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) at cfdatasource2ecfc1645517805$funcSETORACLE.runFunction(E:\Inetpub\wwwroot\CFI DE\administrator\components\datasource.cfc:540) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java: 250) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1587) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:331) at cfsetMyDatasource2ecfm1566537573.runPage(E:\Inetpub\wwwroot\virt.parker\dsp\ setMyDatasource.cfm:18) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) at cfindex2ecfm919545483.runPage(E:\Inetpub\wwwroot\virt.parker\index.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107
Re: Automating data source password changes
You don't even need to use the ServiceFactory in CF6 ... you can just use the underlying CFCs that the CFAdmin uses (yes, they DO exist in CF6). Saying that, they probably are missing some functionality just like those in CF7 (as Russ says) On 10/10/06, Snake [EMAIL PROTECTED] wrote: You can work with the Java Service Factory directly in CFMx6 which does the same thing albeit with more work. In fact I have still had to do things this way as the AdminAPI in CFMX7 doesn't work right. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 10 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, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://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 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 can't imagine editing neo-query manually and adding an unencrypted password. If it works let us know. I assume CF decrypts the password before it is used anyway. Of course I know how to encrypt and in the right format, but I am not telling. Dan ~| 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:256080 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Automating data source password changes
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. ~| 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:256163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Automating data source password changes
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
Re: Automating data source password changes
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. ~| 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:256194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Automating data source password changes
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 initiate B2B paradigms This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:255962 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Automating data source password changes
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 = createObject(component,cfide.adminapi.datasource); myObj.setOther(driver=oracle jdbc, name=dsnname, url=jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=hostname)(port=1521))(connect_data=(sid=oraclesid))), class=oracle.jdbc.driver.OracleDriver, username = username, password=newpassword); /cfscript We're looking for a way to automate our data source password changes. 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. Has anyone used datasource.cfc in MX7 to automate their password changes? ~| 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:255987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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,cfide.administrator.components.datasource) cfinvoke component=#setDSN# method=setOracle cfinvokeargument name=dsn value=parkerd/ cfinvokeargument name=host value=[IP removed]/ cfinvokeargument name=sid value=[SID removed]/ cfinvokeargument name=port value=1813/ cfinvokeargument name=username value=thisUser/ cfinvokeargument name=password value=howBoutThat/ cfinvokeargument name=epassword value=howBoutThat/ cfinvokeargument name=class value=macromedia.jdbc.MacromediaDriver /cfinvoke 11 The error occurred in E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 332 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 3 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm: line 1 Called from E:\Inetpub\wwwroot\CFIDE\administrator\components\datasource.cfc: line 540 Called from E:\Inetpub\wwwroot\virt.parker\dsp\setMyDatasource.cfm: line 18 Called from E:\Inetpub\wwwroot\virt.parker\index.cfm: line 11 Stack Trace at cfsetdsn2ecfm2110276039._factor4(E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm:332) at cfsetdsn2ecfm2110276039._factor5(E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm:3) at cfsetdsn2ecfm2110276039.runPage(E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm:1) at cfdatasource2ecfc1645517805$funcSETORACLE.runFunction(E:\Inetpub\wwwroot\CFIDE\administrator\components\datasource.cfc:540) at cfsetMyDatasource2ecfm1566537573.runPage(E:\Inetpub\wwwroot\virt.parker\dsp\setMyDatasource.cfm:18) at cfindex2ecfm919545483.runPage(E:\Inetpub\wwwroot\virt.parker\index.cfm:11) java.lang.ArrayIndexOutOfBoundsException: 11 at coldfusion.sql.TwoFishCryptor.toByte(TwoFishCryptor.java:162) at coldfusion.sql.TwoFishCryptor.decrypt(TwoFishCryptor.java:65) at coldfusion.sql.Executive.mapModified(Executive.java:258) at coldfusion.server.ConfigMap.setChanged(ConfigMap.java:64) at coldfusion.server.ConfigMap.put(ConfigMap.java:238) at coldfusion.runtime.Struct.StructInsert(Struct.java:409) at coldfusion.runtime.CFPage.StructInsert(CFPage.java:4091) at cfsetdsn2ecfm2110276039._factor4(E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm:332) at cfsetdsn2ecfm2110276039._factor5(E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm:3) at cfsetdsn2ecfm2110276039.runPage(E:\Inetpub\wwwroot\CFIDE\administrator\components\_datasource\setdsn.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) at cfdatasource2ecfc1645517805$funcSETORACLE.runFunction(E:\Inetpub\wwwroot\CFIDE\administrator\components\datasource.cfc:540) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:250) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1587) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:331) at cfsetMyDatasource2ecfm1566537573.runPage(E:\Inetpub\wwwroot\virt.parker\dsp\setMyDatasource.cfm:18) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1876) at cfindex2ecfm919545483.runPage(E:\Inetpub\wwwroot\virt.parker\index.cfm:11) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107) at coldfusion.filter.PathFilter.invoke(PathFilter.java:80) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at