Re: CF10 / SQL Server Windows Authentication
Thanks I'm going to go down with a SQL user and not use the windows authentication. It wasn't my choice to use more this is what I was given. Thanks for your help Sent from my iPhone On 11 Feb 2014, at 22:50, Russ Michaels r...@michaels.me.uk wrote: I would also point out that if you are currently running CF as system, then you obviously have not locked it down either, so you should consider doing that. You should also remember that if you run CF as a domain user who has access to network resources and all the databases on your sql server, then any code and any person with access to upload code on your cf server also has this level of access as well. On Tue, Feb 11, 2014 at 9:03 PM, Dave Watts dwa...@figleaf.com wrote: Im having difficulty in creating a datasource to SQL server that has windows authentication setup. When i create the datasource using the SA account it creates successfully, but when i try and use the windows account i get an error: 'Login failed for user'\domain\username' i have checked the security options for the server and the user is setup as db_owner and when i try and login using the SQL management studio with the windows details i can login successfully. it just wont work when creating the datasource. I have tried using different combinations in the username field: domain\username username username.domain.local usern...@domain.com uppercase and lowercase still i get the same error - 'Login failed for user' I'll second Russ' recommendation to use mixed mode authentication instead - it's generally just a lot easier. But if you absolutely, positively have to use Windows authentication, follow the steps described here: http://www.cfuser.com/windows-authentication-sql-server-and-coldfusion/ Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:357667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible time out
Is the form re-submitting each time you check a box? I bet it's the post parameter limit thing. The behavior you're describing (white screen) is exactly what happens when you hit that post param limit. Cutter did a great blog post on it http://www.cutterscrossing.com/index.cfm/2012/3/27/ColdFusion-Security-Hotfix-and-Big-Forms. -- Matthew Williams Geodesic GraFX ~| 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:357668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible time out - Not
Hi Matthew and Anthony It was the post param limit issue There were lots of hidden input variables associated with the check box. Bummer just getting a white screen without any error message. Thanks Rob On 13 Feb 2014 at 9:11, Matthew Williams wrote: Is the form re-submitting each time you check a box? I bet it's the post parameter limit thing. The behavior you're describing (white screen) is exactly what happens when you hit that post param limit. Cutter did a great blog post on it http://www.cutterscrossing.com/index.cfm/2012/3/27/ColdFusion-Securi ty-Hotfix-and-Big-Forms. ~| 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:357669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Upgrading CF9 Hotfixes
Hi, I am having a lot of problems trying to upgrade hot fixes. I currently have 9.01 installed. I have downloaded 9.01 hot fix as described here: http://helpx.adobe.com/coldfusion/kb/security-hotfix-coldfusion-8-8.html. However, after applying the changes the CF Admin stops working and just shows a blank page. I have followed the instructions diligently so wondered what else may be going wrong. I tried to apply the 9.02 update but again the CF admin stopped working and showed an error: 'Class not found: coldfusion.security.ESAPIUtils' I am lost as to what to try next and what the issue is. I think there were 4 hot fixes for 9.01? Do I need to load them one at a time in order, and then apply the 9.02 update? Thanks for any help or pointers, Richard ~| 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:357670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Possible to optimise CFHTTP Response Time?
I have an API running on my server where I can receive an average ping response to the host server of 1ms yet when I make a CFHTTP request to the host server it takes anywhere from 300-500ms to return a response. Anyone have any ideas what might be causing this latency, and how I could decrease it? ~| 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:357671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible to optimise CFHTTP Response Time?
a cfhttp is not the same as a ping a ping simply sends a packet to the server and gets a response. cfhttp is requesting a page from the server, that request goes to the web server, then to cf, the page has to execute and then return all data back to your server, so the time taken depends on how long the page takes to process On Thu, Feb 13, 2014 at 2:57 PM, Craig Brown craigpbr...@gmail.com wrote: I have an API running on my server where I can receive an average ping response to the host server of 1ms yet when I make a CFHTTP request to the host server it takes anywhere from 300-500ms to return a response. Anyone have any ideas what might be causing this latency, and how I could decrease it? ~| 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:357672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible to optimise CFHTTP Response Time?
a cfhttp is not the same as a ping a ping simply sends a packet to the server and gets a response. cfhttp is requesting a page from the server, that request goes to the web server, then to cf, the page has to execute and then return all data back to your server, so the time taken depends on how long the page takes to process On Thu, Feb 13, 2014 at 2:57 PM, Craig Brown craigpbr...@gmail.com wrote: I'm not claiming that it is but I'm surprised that it's taking so long to process such a simple request (which is returning json) and was wondering if there's a way of optimising the request... ~| 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:357673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
Hi Richard, Are you renaming any existing jar files or removing them completely? I have run into issues when the old hotfix files are just renamed, you should remove them from the folder completely (i.e. the ones in the UPDATES folder). Ensure that you have them backed up in another location though incase you need to restore them. Best Regards, Donnie Donnie Bachan Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. On Thu, Feb 13, 2014 at 2:52 PM, Richard White rich...@re-base.net wrote: Hi, I am having a lot of problems trying to upgrade hot fixes. I currently have 9.01 installed. I have downloaded 9.01 hot fix as described here: http://helpx.adobe.com/coldfusion/kb/security-hotfix-coldfusion-8-8.html. However, after applying the changes the CF Admin stops working and just shows a blank page. I have followed the instructions diligently so wondered what else may be going wrong. I tried to apply the 9.02 update but again the CF admin stopped working and showed an error: 'Class not found: coldfusion.security.ESAPIUtils' I am lost as to what to try next and what the issue is. I think there were 4 hot fixes for 9.01? Do I need to load them one at a time in order, and then apply the 9.02 update? Thanks for any help or pointers, Richard ~| 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:357674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
also, make double sure you are installing the right hotfixes. Most times when I have seen this issue it is because the wrong hotfixes were installed (9.0 instead of 9.0.1) On Thu, Feb 13, 2014 at 3:27 PM, Donnie Bachan (Gmail) donnie.bac...@gmail.com wrote: Hi Richard, Are you renaming any existing jar files or removing them completely? I have run into issues when the old hotfix files are just renamed, you should remove them from the folder completely (i.e. the ones in the UPDATES folder). Ensure that you have them backed up in another location though incase you need to restore them. Best Regards, Donnie Donnie Bachan Nitendo Vinces - By Striving You Shall Conquer == The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. On Thu, Feb 13, 2014 at 2:52 PM, Richard White rich...@re-base.net wrote: Hi, I am having a lot of problems trying to upgrade hot fixes. I currently have 9.01 installed. I have downloaded 9.01 hot fix as described here: http://helpx.adobe.com/coldfusion/kb/security-hotfix-coldfusion-8-8.html . However, after applying the changes the CF Admin stops working and just shows a blank page. I have followed the instructions diligently so wondered what else may be going wrong. I tried to apply the 9.02 update but again the CF admin stopped working and showed an error: 'Class not found: coldfusion.security.ESAPIUtils' I am lost as to what to try next and what the issue is. I think there were 4 hot fixes for 9.01? Do I need to load them one at a time in order, and then apply the 9.02 update? Thanks for any help or pointers, Richard ~| 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:357675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible to optimise CFHTTP Response Time?
if it is the page you are calling which is taking the time then no, because it is not the request which is the cause. A suggested you need to check how long the page you are requesting takes to execute before blaming the connection. On Thu, Feb 13, 2014 at 3:22 PM, Craig Brown craigpbr...@gmail.com wrote: a cfhttp is not the same as a ping a ping simply sends a packet to the server and gets a response. cfhttp is requesting a page from the server, that request goes to the web server, then to cf, the page has to execute and then return all data back to your server, so the time taken depends on how long the page takes to process On Thu, Feb 13, 2014 at 2:57 PM, Craig Brown craigpbr...@gmail.com wrote: I'm not claiming that it is but I'm surprised that it's taking so long to process such a simple request (which is returning json) and was wondering if there's a way of optimising the request... ~| 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:357676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible time out
I don't know if it was a great blog post... (Thanks Matt) ;) Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
Some of those updates in CF 9 were pretty tricky. I would checkout the cfUpdater project for RIAForge. It can handle a lot of that craziness for you. http://cfupdater.riaforge.org/ Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible time out
On Thu, Feb 13, 2014 at 11:08 AM, Steve 'Cutter' Blades wrote: I don't know if it was a great blog post... (Thanks Matt) ;) I am JUST dealing with the postparam problem with a client (yes that client) and came across this post from you about 10 minutes ago in my searching. It's a real tough problem to figure out sometimes. See also: http://www.petefreitag.com/item/808.cfm -Cameron -- 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:357679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible to optimise CFHTTP Response Time?
I have an API running on my server where I can receive an average ping response to the host server of 1ms yet when I make a CFHTTP request to the host server it takes anywhere from 300-500ms to return a response. Anyone have any ideas what might be causing this latency, and how I could decrease it? Do you control the API service? If so, it's like any other web program, and you can optimize it the same way you would any other web program - look for unnecessary work done at runtime, etc. If you don't control the API service, there isn't a lot you can do. There might be a problem with your machine's network connection. You could try making the request from another machine on a different network and see what happens. You don't need to use CFHTTP to test this kind of thing - you can use any HTTP client, including wget etc. And, as Russ mentioned, ping and HTTP times aren't connected in any useful way. Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:357680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
Thanks all. Yes I am installing the correct hot fixes and not renaming the jar files. I will try the cfupdater. Thanks again Richard Hi, I am having a lot of problems trying to upgrade hot fixes. I currently have 9.01 installed. I have downloaded 9.01 hot fix as described here: http://helpx.adobe. com/coldfusion/kb/security-hotfix-coldfusion-8-8.html. However, after applying the changes the CF Admin stops working and just shows a blank page. I have followed the instructions diligently so wondered what else may be going wrong. I tried to apply the 9.02 update but again the CF admin stopped working and showed an error: 'Class not found: coldfusion.security.ESAPIUtils' I am lost as to what to try next and what the issue is. I think there were 4 hot fixes for 9.01? Do I need to load them one at a time in order, and then apply the 9.02 update? Thanks for any help or pointers, Richard ~| 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:357681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
Just to double check, is it OK to install 9.02 update instead of all the 9.01 hot fixes. I am sure 9.02 will contain all the fixes but just wanted to make sure thanks Richard Some of those updates in CF 9 were pretty tricky. I would checkout the cfUpdater project for RIAForge. It can handle a lot of that craziness for you. http://cfupdater.riaforge.org/ Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading CF9 Hotfixes
9.02 is not an update - it is a full install (see Charlie Arehart's blog entry for an excellent explanation http://www.carehart.org/blog/client/index.cfm/2013/8/19/understanding_ColdFusion_9.0.2_a_FAQ). As such, it cannot be installed over the top of 9.0 or 9.0.1. -Carl V. On 2/13/2014 9:19 AM, Richard White wrote: Just to double check, is it OK to install 9.02 update instead of all the 9.01 hot fixes. I am sure 9.02 will contain all the fixes but just wanted to make sure thanks Richard Some of those updates in CF 9 were pretty tricky. I would checkout the cfUpdater project for RIAForge. It can handle a lot of that craziness for you. http://cfupdater.riaforge.org/ Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it ~| 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:357683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Possible time out
I find that it bites me every time I do a CF9 install (for instance, after rebuilding my dev laptop). So it happened in the last month or so to me, which is the only reason I even remember the cause ;). Though WHY there's no error output to the screen is highly annoying. -- Matthew Williams Geodesic GraFX ~| 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:357684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm