RE: Password to Oracle datasource keep getting reset
The Coldfusion code, js, images etc that make up the intranet are controlled by sandbox security. The actual code that makes up the CF administrator (i.e. the stuff under CFIDE/) is not controlled by sandbox security. Does that make sense or are we talking at cross-purposes? -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 16 February 2012 15:11 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset sorry not sure what you mean by that? On Thu, Feb 16, 2012 at 2:28 PM, Moore, Nathan nathan.mo...@serco.comwrote: On the CFML of the website yes but not on the CFIDE stuff. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 16 February 2012 14:15 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset are you using sandbox security ? On Thu, Feb 16, 2012 at 2:05 PM, Moore, Nathan nathan.mo...@serco.comwrote: No that's not possible as I'm the only admin and the dev environment is hosted on secure list-x (UK) network. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 16 February 2012 13:56 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset is it possible that someone else might be restoring backups or cfadmin settings or perhaps copying them over from another server ? On Thu, Feb 16, 2012 at 1:13 PM, Moore, Nathan nathan.mo...@serco.comwrote: The password remains the same. It's the datasource in the CF admin that seems to 'forget' the password. All I do is reneter the same password and all is good. -Original Message- From: george.e...@ssa.gov george.e...@ssa.gov [mailto:george.e...@ssa.gov] Sent: 16 February 2012 13:09 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset It would appear that around about every 6 weeks the development version of an intranet I maintain goes down with a DSN username/password error. I verify the datasource in the CF admin and sure enough the password is somehow no longer valid. I refer back to the password I have manually recorded, reenter, verify it and it's fine. Maybe that particular password is set to expire 'around about every 6 weeks'? Have you checked with your DBA(s)? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349924 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Password to Oracle datasource keep getting reset
Yes but my point is the correct password never changes. It somehow BECOMES invalid after a certain period of time. I've spoken with my DBAs and there response is: the 1017 error shown in your screenshot is ONLY EVER produced because the credentials supplied are invalid. i.e. wrong user name or password -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: 16 February 2012 15:23 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset Have you eliminated the possibility of a saved password in browser I mentioned in my post? -Cameron On Thu, Feb 16, 2012 at 8:13 AM, Moore, Nathan nathan.mo...@serco.comwrote: The password remains the same. It's the datasource in the CF admin that seems to 'forget' the password. All I do is reneter the same password and all is good. -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Password to Oracle datasource keep getting reset
ok so you are using sandboxing which is the key point. when sandbox security is enabled I have seen this cause problems with the DSN's When you save the DSN it is then active in the session/context of the cfadmin, as soon as that connection times out then sites can no longer connect to the DSN. Re-saving the DSN in the cfadmin resolved it. It was a long time ago since I had this issue, but I think that explicitly allow connection to the database server and DSN in the sandbox for that site resolved this issue. On Fri, Feb 17, 2012 at 9:58 AM, Moore, Nathan nathan.mo...@serco.comwrote: Yes but my point is the correct password never changes. It somehow BECOMES invalid after a certain period of time. I've spoken with my DBAs and there response is: the 1017 error shown in your screenshot is ONLY EVER produced because the credentials supplied are invalid. i.e. wrong user name or password -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: 16 February 2012 15:23 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset Have you eliminated the possibility of a saved password in browser I mentioned in my post? -Cameron On Thu, Feb 16, 2012 at 8:13 AM, Moore, Nathan nathan.mo...@serco.comwrote: The password remains the same. It's the datasource in the CF admin that seems to 'forget' the password. All I do is reneter the same password and all is good. -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Password to Oracle datasource keep getting reset
That's an interesting post. However, Sandbox security is disabled in this case. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 17 February 2012 10:48 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset ok so you are using sandboxing which is the key point. when sandbox security is enabled I have seen this cause problems with the DSN's When you save the DSN it is then active in the session/context of the cfadmin, as soon as that connection times out then sites can no longer connect to the DSN. Re-saving the DSN in the cfadmin resolved it. It was a long time ago since I had this issue, but I think that explicitly allow connection to the database server and DSN in the sandbox for that site resolved this issue. On Fri, Feb 17, 2012 at 9:58 AM, Moore, Nathan nathan.mo...@serco.comwrote: Yes but my point is the correct password never changes. It somehow BECOMES invalid after a certain period of time. I've spoken with my DBAs and there response is: the 1017 error shown in your screenshot is ONLY EVER produced because the credentials supplied are invalid. i.e. wrong user name or password -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: 16 February 2012 15:23 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset Have you eliminated the possibility of a saved password in browser I mentioned in my post? -Cameron On Thu, Feb 16, 2012 at 8:13 AM, Moore, Nathan nathan.mo...@serco.comwrote: The password remains the same. It's the datasource in the CF admin that seems to 'forget' the password. All I do is reneter the same password and all is good. -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Need Oracle Service_Name but have SID
Hi all, I have a bit of a dilema, I need to connect to an oracle database, but I can't use a TNSNames file. However when I asked for the connection info they gave me a tnsnames.ora file and told me to figure it out from there. In the tnsnames file is a SID. However the software I am trying to use (SSIS) needs [host]:[port]\[service_name]. [host]:[port]\[sid] wont work and I can't find anything helpful through google on what I need to do to find the service_name. I know a couple of you are Oracle gurus, so I'm hoping you can help. Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Password to Oracle datasource keep getting reset
Nathan, there seems to be some conflict in your replies here. you already said in your previous reply that you are using sandbox security. now you are saying that sandbox security is disabled. both cannot be true. If you are using sandbox security as you originally stated, then it must be enabled. On Fri, Feb 17, 2012 at 2:04 PM, Moore, Nathan nathan.mo...@serco.comwrote: That's an interesting post. However, Sandbox security is disabled in this case. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: 17 February 2012 10:48 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset ok so you are using sandboxing which is the key point. when sandbox security is enabled I have seen this cause problems with the DSN's When you save the DSN it is then active in the session/context of the cfadmin, as soon as that connection times out then sites can no longer connect to the DSN. Re-saving the DSN in the cfadmin resolved it. It was a long time ago since I had this issue, but I think that explicitly allow connection to the database server and DSN in the sandbox for that site resolved this issue. On Fri, Feb 17, 2012 at 9:58 AM, Moore, Nathan nathan.mo...@serco.comwrote: Yes but my point is the correct password never changes. It somehow BECOMES invalid after a certain period of time. I've spoken with my DBAs and there response is: the 1017 error shown in your screenshot is ONLY EVER produced because the credentials supplied are invalid. i.e. wrong user name or password -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: 16 February 2012 15:23 To: cf-talk Subject: Re: Password to Oracle datasource keep getting reset Have you eliminated the possibility of a saved password in browser I mentioned in my post? -Cameron On Thu, Feb 16, 2012 at 8:13 AM, Moore, Nathan nathan.mo...@serco.comwrote: The password remains the same. It's the datasource in the CF admin that seems to 'forget' the password. All I do is reneter the same password and all is good. -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Password to Oracle datasource keep getting reset
I think you are missing my point (or maybe I am missing yours). Here's what I've seen happen 1) Log into the CFAdmin using your CFAdmin password, allow browser to remember password 2) Visit datasource 3) Browser auto-populates password field using previously saved password (your admin password, not the Oracle one) 4) Change a setting in the Datasource, leave the password alone (it changed but you didn't know) 5) Save datasource. Now you have changed the password in your datasource without realizing it. Or - this can also happen if you ever said yes to saving the password in the datasource page itself, even if it was a different datasource, since many browsers will remember the password based on URL and not context of what's on the page. This might not be what's happening to you, but it's definitely worth at least attempting to replicate. If error 1017 means bad password, then this is exactly what you'd see in the scenario I am outlining. Replicating it is easy - then fixing it is as easy as not remembering passwords in your browser (which I'd recommend against anyway). -Cameron On Fri, Feb 17, 2012 at 4:58 AM, Moore, Nathan nathan.mo...@serco.comwrote: Yes but my point is the correct password never changes. It somehow BECOMES invalid after a certain period of time. I've spoken with my DBAs and there response is: the 1017 error shown in your screenshot is ONLY EVER produced because the credentials supplied are invalid. i.e. wrong user name or password ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Fusion Reactor and Fusion Analytics Kick Ass
Hey people, I'm sure most of you already know this, but Fusion Reactor and Fusion Analytics for monitoring CF servers kick some serious ass. I've been a seefusion customer for years, and while it does a decent job its not in the same class as the Fusion Reactor/Analytics Products. This pair of products is phenomenal and give you incredible insight into your CF server. If you're a CF sys admin, you really want to check em out. I have absolutely zero affiliation with the company, I just bought and setup 3 licenses and am so happy with it, that I wanted to share how great they are. I've had them running for a few days and they have already helped resolve problems. Now for the load testing J Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Fusion Reactor and Fusion Analytics Kick Ass
+1 for FusionReactor. We've got but have not yet installed Fusion Analytics. But we're looking forward to that addition as well. Nick PS - also no affiliation with them. .. CitySoft, Inc. | http://www.citysoft.com Phone: (866) 751-1992 | Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less Do More - Community Enterprise combines great features with an affordable price. .. -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: Friday, February 17, 2012 12:19 PM To: cf-talk Subject: Fusion Reactor and Fusion Analytics Kick Ass Hey people, I'm sure most of you already know this, but Fusion Reactor and Fusion Analytics for monitoring CF servers kick some serious ass. I've been a seefusion customer for years, and while it does a decent job its not in the same class as the Fusion Reactor/Analytics Products. This pair of products is phenomenal and give you incredible insight into your CF server. If you're a CF sys admin, you really want to check em out. I have absolutely zero affiliation with the company, I just bought and setup 3 licenses and am so happy with it, that I wanted to share how great they are. I've had them running for a few days and they have already helped resolve problems. Now for the load testing J Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Fusion Reactor and Fusion Analytics Kick Ass
I just set up fusionAnalytics - its awesome. It really makes fusionReactor that much better. I have a new server setup I am working on, I was looking at the CPU and memory graph today and saw a spike at 3 am on all 3 of our servers. I right clicked on the memory spike and was able to choose from a ton of options from that time period I choice to show the logs (FusionAnalytics stores and indexes/aggregates all the CF logs..) and saw immediately that the CF server was doing a restart. Turns out windows update was set to do automatic updates and automatic restarts on our brand new out the box server. Simple example, and sure, I could have just went through the logs and found this manually, but to be able to see spike in memory/requests/response/jdbc/cpu and just right click the spike and get: JDBC requests at that exact time Threads at that time Log file entries CF Scope sizes System Metrics And more For that exact moment. Priceless :) Brook -Original Message- From: Nick Gleason [mailto:n.glea...@citysoft.com] Sent: February-17-12 2:14 PM To: cf-talk Subject: RE: Fusion Reactor and Fusion Analytics Kick Ass +1 for FusionReactor. We've got but have not yet installed Fusion Analytics. But we're looking forward to that addition as well. Nick PS - also no affiliation with them. . ... CitySoft, Inc. | http://www.citysoft.com Phone: (866) 751-1992 | Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less Do More - Community Enterprise combines great features with an affordable price. . ... -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: Friday, February 17, 2012 12:19 PM To: cf-talk Subject: Fusion Reactor and Fusion Analytics Kick Ass Hey people, I'm sure most of you already know this, but Fusion Reactor and Fusion Analytics for monitoring CF servers kick some serious ass. I've been a seefusion customer for years, and while it does a decent job its not in the same class as the Fusion Reactor/Analytics Products. This pair of products is phenomenal and give you incredible insight into your CF server. If you're a CF sys admin, you really want to check em out. I have absolutely zero affiliation with the company, I just bought and setup 3 licenses and am so happy with it, that I wanted to share how great they are. I've had them running for a few days and they have already helped resolve problems. Now for the load testing J Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
