cf query monitoring
Hi to all. I am looking for a way to monitor how many times non-cached queries hit the database, including the name of the query and performance times. Anyone have a suggestion? I looked at fusion reactor but it is expensive when you have multiple servers. -RR ~| 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:354342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looking for affordable Colocation
Hello, I am looking for 2 to 4 rack-spaces of affordable co-location on the east coast, with decent quality transit. Any suggestions? -RR ~| 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:353841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Fwd: New Security Issue with CF
I looked into this a bit more this morning, and have realized that I may have gotten very lucky. In going through the logs again, I see that there were no POSTs to h.cfm. So the hacker never logged into h.cfm. And I see no GETs with a fuseaction, as described in Charlie's post. I ran the hacker's script again to confirm that logging in shows a POST in my logs. I also tried a some of the non destructive actions he could take, and found that those caused either a POST or GET+fuseaction. I think I dodged a bullet here. -- Forwarded message -- From: Robert Rhodes rrhode...@gmail.com Date: Thu, Jan 3, 2013 at 12:00 AM Subject: Re: New Security Issue with CF To: cf-talk@houseoffusion.com Thanks. I saw that afterwards. I was freaking out a bit there. Still am. :( I have gone through the logs on that server (windows 2008 R2 server running IIS7.5 and CF9.02) and the hacker loaded his script 1 time each on 15 different sites. They all look like this: 2013-01-02 00:15:15 192.168.55.129 GET /CFIDE/h.cfm - 80 - 178.170.124.210 python-requests/0.14.2+CPython/2.7.3+Linux/3.2.0-32-generic 200 0 0 171 But on 3 of the sites, he also loaded: help,cfm, administrator.cfc, mappings.cfm, scheduleedit.cfm, and scheduletasks.cfm but there are no scheduled tasks showing in the administrator. I checked the CF Administrator log and found nothing. Fortunately, he missed the one site (none of his crap shows up in its logs) where there was sensitive information, so assuming he could not traverse directories, I am hoping I am ok there. I ran his file (after renaming it), and none of my datasources showed up (it was an empty select). I am hoping I am good there too. It looks like his script it needs to be driven by a human (a lot of it is a form). So I am hoping that the one hit I see on most of those sites is an automated hit to see if the script is there, then he was going to come around later and do his damage -- and he never did. Wishful thinking right? I don't see any other signs of trouble anywhere, but am very worried that something bad has happened that I have just not stumbled on yet. Any suggestions or advice? Any place else I should be looking? Am I fooling my self to think I got lucky here? I have shut down CF on that server and am now searching all other servers for h.cfm. So far nothing. Tomorrow, I will completely wipe that server and reload it. -RR ~| 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:353742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Security Issue with CF
Oh man I just looked and one of my standby servers got hit with this. Somehow we forgot to patch that one. It had a bunch of sites on it, but none of them were actually live (because it was a standby server). So I have questions. Does anyone know that this thing does? I can just wipe this box and reload it, but it was on the network with our other windows servers (some of which are SQL database servers). Is it possible this hacker could have accessed other other servers through this hack? Do we know the steps yet to clean up the mess? Any idea where to look for damage that the hacker has caused? I am a little lost here. :( -RR On Wed, Jan 2, 2013 at 3:52 PM, Russ Michaels r...@michaels.me.uk wrote: and also read the following article. http://www.michaels.me.uk/post.cfm/securing-your-coldfusionmx-installation-on-windows On Wed, Jan 2, 2013 at 7:47 PM, Larry Lyons larrycly...@gmail.com wrote: A new CF security issue was just discovered a few days ago. You may want to forward this information to whomever is your CF Admin. http://www.carehart.org/blog/client/index.cfm/2013/1/2/serious_security_threat To make a very long story short, the exploit allows a hacker to upload a file is put on the server. This gives a hacker pretty much unfettered access to a lot of things including reading/downloading/uploading/renaming and creating files, accessing datasource information, and more. ~| 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:353733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Security Issue with CF
Thanks. I saw that afterwards. I was freaking out a bit there. Still am. :( I have gone through the logs on that server (windows 2008 R2 server running IIS7.5 and CF9.02) and the hacker loaded his script 1 time each on 15 different sites. They all look like this: 2013-01-02 00:15:15 192.168.55.129 GET /CFIDE/h.cfm - 80 - 178.170.124.210 python-requests/0.14.2+CPython/2.7.3+Linux/3.2.0-32-generic 200 0 0 171 But on 3 of the sites, he also loaded: help,cfm, administrator.cfc, mappings.cfm, scheduleedit.cfm, and scheduletasks.cfm but there are no scheduled tasks showing in the administrator. I checked the CF Administrator log and found nothing. Fortunately, he missed the one site (none of his crap shows up in its logs) where there was sensitive information, so assuming he could not traverse directories, I am hoping I am ok there. I ran his file (after renaming it), and none of my datasources showed up (it was an empty select). I am hoping I am good there too. It looks like his script it needs to be driven by a human (a lot of it is a form). So I am hoping that the one hit I see on most of those sites is an automated hit to see if the script is there, then he was going to come around later and do his damage -- and he never did. Wishful thinking right? I don't see any other signs of trouble anywhere, but am very worried that something bad has happened that I have just not stumbled on yet. Any suggestions or advice? Any place else I should be looking? Am I fooling my self to think I got lucky here? I have shut down CF on that server and am now searching all other servers for h.cfm. So far nothing. Tomorrow, I will completely wipe that server and reload it. -RR On Wed, Jan 2, 2013 at 10:16 PM, Raymond Camden raymondcam...@gmail.comwrote: Charlie posted an update: http://www.carehart.org/blog/client/index.cfm/2013/1/2/Part2_serious_security_threat On Wed, Jan 2, 2013 at 9:00 PM, Robert Rhodes rrhode...@gmail.com wrote: Oh man I just looked and one of my standby servers got hit with this. Somehow we forgot to patch that one. It had a bunch of sites on it, but none of them were actually live (because it was a standby server). So I have questions. Does anyone know that this thing does? I can just wipe this box and reload it, but it was on the network with our other windows servers (some of which are SQL database servers). Is it possible this hacker could have accessed other other servers through this hack? Do we know the steps yet to clean up the mess? Any idea where to look for damage that the hacker has caused? I am a little lost here. :( -RR On Wed, Jan 2, 2013 at 3:52 PM, Russ Michaels r...@michaels.me.uk wrote: and also read the following article. http://www.michaels.me.uk/post.cfm/securing-your-coldfusionmx-installation-on-windows On Wed, Jan 2, 2013 at 7:47 PM, Larry Lyons larrycly...@gmail.com wrote: A new CF security issue was just discovered a few days ago. You may want to forward this information to whomever is your CF Admin. http://www.carehart.org/blog/client/index.cfm/2013/1/2/serious_security_threat To make a very long story short, the exploit allows a hacker to upload a file is put on the server. This gives a hacker pretty much unfettered access to a lot of things including reading/downloading/uploading/renaming and creating files, accessing datasource information, and more. ~| 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:353736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: r2 server (web edition(Can;t get CF installed on windows
Well it turns out that Andrew and Will hit the nail on the head. There is something wrong with the cf9.0.2 installer. Today, I reloaded the os and used the cf9 installer. Then I ran the cf9.0.1 updater, then I loaded up the administrator and all appeared to be working fine. Next, Ioaded a few sites and ran the web server config tool, and all is working as expected. Weird that the 9.0.2 exe does not work. -RR On Mon, Sep 3, 2012 at 1:23 AM, Andrew Scott andr...@andyscott.id.auwrote: It sounds like they are using the same installer as 9.0, if that is the case then I am also guessing that the same problems exist. Which means when you update / install 9.02 it needs to have the IIS 6 compatibility installed. I would have assumed that Adobe would have taken care of that. If your lucky enough to have a 9.01 or 9.02 server running, you could try to install ColdFusion and grab that WSCFG tool and try getting the connectors working with that. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Mon, Sep 3, 2012 at 3:17 PM, Wil Genovese jugg...@trunkful.com wrote: I wish I could help, I have not been able to get been able to get 9.0.2 to install and run either. I tried the 64Bit version on Linux. Eventually I had to load 9.0 and then to the upgrade and patch process. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Sep 3, 2012, at 12:09 AM, Robert Rhodes wrote: I agree. :) I am installing with: ColdFusion_9_WWEJ_win64.exe from the link here: http://www.adobe.com/support/coldfusion/downloads_updates.html#cf9 I have tried deinstalling and reinstalling CF9.02 a few times. I have also tried reloading the OS and starting from scratch a few times. No luck. I guess my next try will be to load from the 9.0 disc and do the updates. That's a pain but at least might get this damn server running. This really should not be this hard. Every other time I have done this it has gone fine. It's something about this particular build. --RR On Mon, Sep 3, 2012 at 12:41 AM, Andrew Scott andr...@andyscott.id.au wrote: Yeah something does seem to have gone wrong. And I have no real solutions to that problem, I can only guess at things to try like you are doing. But some of the things to double check, are you sure it is x64bit ColdFusion, I doubt that the 32bit would have problems installing though. Install as an Administrator, this is something that Adobe don't make it clear enough, but they will tell you it should be. Failing those two, could it be that the machine just needs a reboot before configuration of the connectors? Failing that I am not sure what else to suggest, but the description you give seems to be more of a problem with things not being setup correctly in IIS.. You could uninstall ColdFusion and then manually double check that all has been removed for CF, then try reinstalling CF and see if that fixes things. But failing that I know ColdFusion 9, had problems with running on IIS7.5, and the solution was to install it then install 9.01, and then configure ColdFusion. My thinking is maybe the installer is the 9.0 installer that has issues with IIS7.5? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Monday, 3 September 2012 2:33 PM To: cf-talk Subject: Re: r2 server (web edition(Can;t get CF installed on windows Each time I have tried running the config tool after installation, it has shown that the server was already configured. I have tried to remove and reinstall the web configuration, and still get the same errors. It's almost as if the 64bit windows 9.0.2 installer just has a problem. (but I am still betting that I screwed something up). ~| 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:352407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JVM settings question
Jonah, your settings helped. Thank you. -RR On Wed, Aug 29, 2012 at 8:54 PM, .jonah jonah@creori.com wrote: I've got a 3 gig heap and these settings on a similarly spec'ed box - no claim whether they're ideal or not. -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=512m -XX:+UseParallelGC -Xbatch -Dsun.rmi.dgc.client.gcInterval=60 -Dsun.rmi.dgc.server.gcInterval=60 On 8/29/12 5:38 PM, Robert Rhodes wrote: Yes: Java HotSpot(TM) 64-Bit Server VM How about I try setting min and max heap size to 2gb and see how that goes? Anything else I should tweak? Garbage Collection? On Wed, Aug 29, 2012 at 8:05 PM, .jonah jonah@creori.com wrote: Are you running 64bit Java? You can give the JVM as much RAM as you can spare. On 8/29/12 4:56 PM, Robert Rhodes wrote: Hello to all. I have several Windows 2008 R2 x64 servers running Coldfusion 9 standard. Each has 6 gigabytes of RAM. Each runs about 50 fairly active sites. I have not had any JVM errors I know about but sometimes the sites run slower than they should, as if CF is having trouble keeping up. Any suggestions on JVM settings for this configuration? Currently, I have Min and Max JVM size both set at 1GB. I have changed no other arguments. Thanks for the help. -RR ~| 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:352398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
r2 server (web edition(Can;t get CF installed on windows
I have installed CF9 many times without incident, but am now having no luck installing the new 9.0.2 x64 installer. I am sure I am doing something wrong, but I have tried everything I can think of and still no luck. Hopefully someone here can help. I am installing CF9.0.2 on Windows 2008R2 Server x64 (Web Edition). After installing the OS, I do all the OS patches first. Next, I install the Web Server Role, and in role services, I install: Static Content Default Document Http Errors Http Redirection Asp.net .net extendibility CGI ISAPI Extensions ISAPI FIlters Htttp Logging Request Monitor Request FIltering IP and Domain Restrictions Static Content Compression IIS Management Console I then install CF9.0.2 in a small partition (f: drive) and when prompted I use a path outside the webroot for the CFAdmin. When the 9.0.2 Installer finishes, the administrator loads fine for the final configuration. Once CF is done with its final configuration, I add an IIS site, and drop in a simple coldfusion file. When I run the simple coldfusion file, I get this error: HTTP Error 404.2 - Not Found The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server. I then check ISAPI and CGI Restrictions. There are four entries there (2 asp.net and 2 Macromedia Server extensions) I then try setting Allow unspecifiec CGI and ISAPI modules, but still no luck. Lastely, I try setting permissions on cgi and isapi (in Handler mappings) to and set them to execute. adnd still no luck. But I now get this different message: HTTP Error 500.0 - Internal Server Error The page cannot be displayed because an internal server error has occurred. Sorry for the long email.I have been trying to get this going for most of the day and I am quite frustrated. Any ideas? --RR ~| 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:352399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: r2 server (web edition(Can;t get CF installed on windows
Each time I have tried running the config tool after installation, it has shown that the server was already configured. I have tried to remove and reinstall the web configuration, and still get the same errors. It's almost as if the 64bit windows 9.0.2 installer just has a problem. (but I am still betting that I screwed something up). On Mon, Sep 3, 2012 at 12:08 AM, Andrew Scott andr...@andyscott.id.auwrote: Robert, I can't see if you did this or not. But it sounds like the connectors didn't get setup, try running the web server Configuration tool. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Monday, 3 September 2012 1:51 PM To: cf-talk Subject: r2 server (web edition(Can;t get CF installed on windows I have installed CF9 many times without incident, but am now having no luck installing the new 9.0.2 x64 installer. I am sure I am doing something wrong, but I have tried everything I can think of and still no luck. Hopefully someone here can help. I am installing CF9.0.2 on Windows 2008R2 Server x64 (Web Edition). After installing the OS, I do all the OS patches first. Next, I install the Web Server Role, and in role services, I install: Static Content Default Document Http Errors Http Redirection Asp.net .net extendibility CGI ISAPI Extensions ISAPI FIlters Htttp Logging Request Monitor Request FIltering IP and Domain Restrictions Static Content Compression IIS Management Console I then install CF9.0.2 in a small partition (f: drive) and when prompted I use a path outside the webroot for the CFAdmin. When the 9.0.2 Installer finishes, the administrator loads fine for the final configuration. Once CF is done with its final configuration, I add an IIS site, and drop in a simple coldfusion file. When I run the simple coldfusion file, I get this error: HTTP Error 404.2 - Not Found The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server. I then check ISAPI and CGI Restrictions. There are four entries there (2 asp.net and 2 Macromedia Server extensions) I then try setting Allow unspecifiec CGI and ISAPI modules, but still no luck. Lastely, I try setting permissions on cgi and isapi (in Handler mappings) to and set them to execute. adnd still no luck. But I now get this different message: HTTP Error 500.0 - Internal Server Error The page cannot be displayed because an internal server error has occurred. Sorry for the long email.I have been trying to get this going for most of the day and I am quite frustrated. Any ideas? --RR ~| 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:352401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: r2 server (web edition(Can;t get CF installed on windows
I agree. :) I am installing with: ColdFusion_9_WWEJ_win64.exe from the link here: http://www.adobe.com/support/coldfusion/downloads_updates.html#cf9 I have tried deinstalling and reinstalling CF9.02 a few times. I have also tried reloading the OS and starting from scratch a few times. No luck. I guess my next try will be to load from the 9.0 disc and do the updates. That's a pain but at least might get this damn server running. This really should not be this hard. Every other time I have done this it has gone fine. It's something about this particular build. --RR On Mon, Sep 3, 2012 at 12:41 AM, Andrew Scott andr...@andyscott.id.auwrote: Yeah something does seem to have gone wrong. And I have no real solutions to that problem, I can only guess at things to try like you are doing. But some of the things to double check, are you sure it is x64bit ColdFusion, I doubt that the 32bit would have problems installing though. Install as an Administrator, this is something that Adobe don't make it clear enough, but they will tell you it should be. Failing those two, could it be that the machine just needs a reboot before configuration of the connectors? Failing that I am not sure what else to suggest, but the description you give seems to be more of a problem with things not being setup correctly in IIS.. You could uninstall ColdFusion and then manually double check that all has been removed for CF, then try reinstalling CF and see if that fixes things. But failing that I know ColdFusion 9, had problems with running on IIS7.5, and the solution was to install it then install 9.01, and then configure ColdFusion. My thinking is maybe the installer is the 9.0 installer that has issues with IIS7.5? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Monday, 3 September 2012 2:33 PM To: cf-talk Subject: Re: r2 server (web edition(Can;t get CF installed on windows Each time I have tried running the config tool after installation, it has shown that the server was already configured. I have tried to remove and reinstall the web configuration, and still get the same errors. It's almost as if the 64bit windows 9.0.2 installer just has a problem. (but I am still betting that I screwed something up). ~| 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:352403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
JVM settings question
Hello to all. I have several Windows 2008 R2 x64 servers running Coldfusion 9 standard. Each has 6 gigabytes of RAM. Each runs about 50 fairly active sites. I have not had any JVM errors I know about but sometimes the sites run slower than they should, as if CF is having trouble keeping up. Any suggestions on JVM settings for this configuration? Currently, I have Min and Max JVM size both set at 1GB. I have changed no other arguments. Thanks for the help. -RR ~| 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:352341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JVM settings question
Yes: Java HotSpot(TM) 64-Bit Server VM How about I try setting min and max heap size to 2gb and see how that goes? Anything else I should tweak? Garbage Collection? On Wed, Aug 29, 2012 at 8:05 PM, .jonah jonah@creori.com wrote: Are you running 64bit Java? You can give the JVM as much RAM as you can spare. On 8/29/12 4:56 PM, Robert Rhodes wrote: Hello to all. I have several Windows 2008 R2 x64 servers running Coldfusion 9 standard. Each has 6 gigabytes of RAM. Each runs about 50 fairly active sites. I have not had any JVM errors I know about but sometimes the sites run slower than they should, as if CF is having trouble keeping up. Any suggestions on JVM settings for this configuration? Currently, I have Min and Max JVM size both set at 1GB. I have changed no other arguments. Thanks for the help. -RR ~| 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:352343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
I guess it was bound to happen
Hello everyone. I have a site where a password is required to access the site. On pages in the site, there are links to download files. I set the appropriate meta tags and robots.txt to tell the search engines to not spyder the site. Though the site pages are not in google, the files are showing up. that's bad. It's a lot of files, so before I code up a solution to access all the through logic so I can control the permissions, is there some way to protect a directory so that files can't be downloaded without being logged in on the site? My guess is the answer is no, but I thought I would ask. -RR ~| 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:352081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I guess it was bound to happen
Yes, I am using CF for login security. Thanks to all for the suggestions. While I am considering the various suggestions, I renamed the directory and removed the insecure page that had links to the files (the client put this page up with he cms). I then changed all the links on the secure pages to the new directory name. That solves the problem now whileI work out a more permanent solution. Thanks again for the help. -RR On Fri, Aug 10, 2012 at 2:05 PM, Brian Thornton br...@cfdeveloper.comwrote: Are you using IIS security for login or CFM security? On Fri, Aug 10, 2012 at 1:02 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello everyone. I have a site where a password is required to access the site. On pages in the site, there are links to download files. I set the appropriate meta tags and robots.txt to tell the search engines to not spyder the site. Though the site pages are not in google, the files are showing up. that's bad. It's a lot of files, so before I code up a solution to access all the through logic so I can control the permissions, is there some way to protect a directory so that files can't be downloaded without being logged in on the site? My guess is the answer is no, but I thought I would ask. -RR ~| 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:352102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Extracting text from various file-types
Hello again to all. I need a way to extract text from word, excel, text, pdf, and ppt files with Coldfusion, as the files are each submitted via a form. The output does not have to be particularly pretty or nicely formatted -- just plain text that can be stored and searched later. Any ideas? --RR ~| 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:352103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Extracting text from various file-types
Hi Bruce. Thanks for the reply. I did, but no luck. On text files, I got the text just fine. On Word docs, I got the text but with a whole bunch of garbage in the return. On ppt, pdf, and excel docs, they all come out as unreadable garbage. I tried both the read and readbinary actions and they both did not work. Maybe I am doing something wrong? I am using CF9. -RR On Fri, Aug 10, 2012 at 6:11 PM, Bruce Sorge sor...@gmail.com wrote: Check out the CFFILE tag. That offers this type of functionality. Bruce On Aug 10, 2012, at 4:07 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello again to all. I need a way to extract text from word, excel, text, pdf, and ppt files with Coldfusion, as the files are each submitted via a form. The output does not have to be particularly pretty or nicely formatted -- just plain text that can be stored and searched later. Any ideas? --RR ~| 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:352110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: validating query string error
May I ask a probably dumb question? Isn't val() simply enough to stop a sql injection attack through that function? --RR On Mon, Jun 11, 2012 at 6:08 PM, Mike Little m...@nzsolutions.co.nz wrote: on my pricing page, i have the following if statement to ensure invalid url vars are not being input... if (isnumeric(val(URL.lid))) { however the query string below seems to get through? what should i be doing instead? --- error message --- Diagnostics: The LOCATION_ID argument passed to the get_term_loaded function is not of type numeric. If the component name is specified as a type of this argument, its possible that a definition file for the component cannot be found or is not accessible. The error occurred on line 153. Referrer: Template: /pricing.cfm Query string: lid=14%27%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40version-- ~| 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:351546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Trouble setting up CF Builder
After wasting an entire day trying to figure out how to get CFB2 to work correctly with my development web server on the local network, I got tired of beating my head against the wall and gave up. So I loaded CF10 on my development machine and CFB controls the server just fine, and RDS communication works fine too. It's a shame that this can't work with a local server on a private network. But here's a question: How do I get the files from the project directory into the local webroot? (I am running IIS7, btw). I do not see any mechanism to Put or Publish the files to the web root. I am sure it's something staring me in the face and I am just not seeing it. Any ideas? -RR On Thu, Jun 7, 2012 at 5:42 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello Dave, Thank you very much for the reply. I tried as you suggested (good suggestion, btw), but I am still stuck. I thought it might be helpful to provide more detail: I am running CF 9.0.1 on Windows Server 2k8 Standard x64. CF is installed in C:\Coldfusion9. Multiple development sites are running under IIS7 at individual private IP addresses (10.10.1.xxx). The webroots for these sites are not within C:\Coldfusion9, but are within the D:\dev\prj directory. On the development server, I did run adminstart.bat in C:\Coldfusion9\runtime\bin. Here is what I entered during the server setup in CFB2: General Settings... Server Name: Development Description: [blank] Application Server: Jrun Host Name: 10.10.1.199 Is Local is selected Web Server Port: 80 J2EE Settings... Context Root: [blank] Application Server Name: [blank] RDS Username: Developer PDS Password: password Enable SSL is not selected Auto Start/Stop are not selected Local Server Settings... Server Home: P:\ (This points to C:\Coldfusion9 on the dev server.) Document Root: Q:\ (This points to D:\dev\prj1425 on the dev server.) Virtual Host Settings... Name: prj1425 Host Name: 10.10.1.199 Port:80 Document Root: Q:\ When I try to refresh that server, I get this in the console log: [Development]:(06/07 at 03:39:19) Server is available. Getting server settings. [Development]:Error(06/07 at 03:39:19) Unable to fetch server mappings. [Development]:Error(06/07 at 03:39:20) Unable to fetch server mappings. [Development]:Error(06/07 at 03:39:20) Unable to get the log directory. When I try to restart it: [Development]:Error(06/07 at 03:40:17) Unable to query service for the server Development. Now I realize I am not the brightest bulb in the box, but the setup instructions and video all seem a bit too vague to me... All help appreciated. -RR On Thu, Jun 7, 2012 at 1:32 PM, Dave Watts dwa...@figleaf.com wrote: Anyway, I think my problem is that both my CF install directory and my web root are on another server on the local network. So I am setting my server home to: \\10.10.1.10\c$\ColdFusion9 and my document root to: \\10.10.1.10\d$\dev\prj1425 CFB2 doesn't seem to like the configuration. It won't let me pick the CF version and won't let me click next to move on. You might try creating drive mappings for those shares, then using the drive mappings in CFB. Dave Watts, CTO, Fig Leaf Software 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 onsit ~| 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:351512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re[2]: Trouble setting up CF Builder
Yes that makes sense. Thanks Dave. Where do I find an SVN plugin (or other source control options) for CFB2? On Sat, Jun 9, 2012 at 12:16 AM, Dave Watts dwa...@figleaf.com wrote: So you are editing directly on the files that are in the dev server webroot? That will take some getting used to. I am used to editing locally and them pushing the files to the dev server for testing. Yes, but the dev server is on my laptop, so I am editing locally. I can then directly test the script on my laptop, then when I'm done I can check everything back into source control, etc. Dave Watts, CTO, Fig Leaf Software 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:351516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re[2]: Trouble setting up CF Builder
Glad to hear I am not the only one who thinks that. But then, I have been using Dreamweaver for for a long time. CFB is a whole new world for me. On Sat, Jun 9, 2012 at 12:13 AM, Michael David li...@michaeldavid.comwrote: So you are editing directly on the files that are in the dev server webroot? That will take some getting used to. I am used to editing locally and them pushing the files to the dev server for testing. -- Original Message -- From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: 6/9/2012 12:08:12 AM Subject: Re: Trouble setting up CF Builder But here's a question: How do I get the files from the project directory into the local webroot? (I am running IIS7, btw). I do not see any mechanism to Put or Publish the files to the web root. I am sure it's something staring me in the face and I am just not seeing it. Any ideas? I just put my projects in the local web root in the first place - when you create a project, you can uncheck the default project location (which by default is in your workspace, which in turn is in your Windows profile). Alternatively, you can simply create a workspace in your web root, and all subsequent projects will then go in there by default. Dave Watts, CTO, Fig Leaf Software 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 on ~| 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:351517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Trouble setting up CF Builder
Hello to all. I sent this message last night, but it looks like it did not make it through. So I thought I should try again. I am a little frustrated here trying to get CF Builder 2 set up. Of course it does not help that the cheezy synthetic-speech videos that you can play from within CFB2 cannot be controlled while you have the setup dialogs open (don't know how Adobe could have missed that). Anyway, I think my problem is that both my CF install directory and my web root are on another server on the local network. So I am setting my server home to: \\10.10.1.10\c$\ColdFusion9 and my document root to: \\10.10.1.10\d$\dev\prj1425 CFB2 doesn't seem to like the configuration. It won't let me pick the CF version and won't let me click next to move on. Anyone got any ideas? -RR ~| 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:351482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Trouble setting up CF Builder
Hello to all. I am a little frustrated here trying to get CF Builder 2 set up. Of course it does not help that the cheezy synthetic-speech videos that you can play from within CFB2 cannot be controlled while you have the setup dialogs open (don't know how Adobe could have missed that). Anyway, I think my problem is that both my CF install directory and my web root are on another server on the local network. So I am setting my server home to: \\10.10.1.10\c$\ColdFusion9 and my document root to: \\10.10.1.10\dev\prj1425 CFB2 doesn't seem to like the configuration. It won't let me pick the CF version and won't let me click next to move on. Anyone got any ideas? -RR ~| 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:351488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Trouble setting up CF Builder
Hello Dave, Thank you very much for the reply. I tried as you suggested (good suggestion, btw), but I am still stuck. I thought it might be helpful to provide more detail: I am running CF 9.0.1 on Windows Server 2k8 Standard x64. CF is installed in C:\Coldfusion9. Multiple development sites are running under IIS7 at individual private IP addresses (10.10.1.xxx). The webroots for these sites are not within C:\Coldfusion9, but are within the D:\dev\prj directory. On the development server, I did run adminstart.bat in C:\Coldfusion9\runtime\bin. Here is what I entered during the server setup in CFB2: General Settings... Server Name: Development Description: [blank] Application Server: Jrun Host Name: 10.10.1.199 Is Local is selected Web Server Port: 80 J2EE Settings... Context Root: [blank] Application Server Name: [blank] RDS Username: Developer PDS Password: password Enable SSL is not selected Auto Start/Stop are not selected Local Server Settings... Server Home: P:\ (This points to C:\Coldfusion9 on the dev server.) Document Root: Q:\ (This points to D:\dev\prj1425 on the dev server.) Virtual Host Settings... Name: prj1425 Host Name: 10.10.1.199 Port:80 Document Root: Q:\ When I try to refresh that server, I get this in the console log: [Development]:(06/07 at 03:39:19) Server is available. Getting server settings. [Development]:Error(06/07 at 03:39:19) Unable to fetch server mappings. [Development]:Error(06/07 at 03:39:20) Unable to fetch server mappings. [Development]:Error(06/07 at 03:39:20) Unable to get the log directory. When I try to restart it: [Development]:Error(06/07 at 03:40:17) Unable to query service for the server Development. Now I realize I am not the brightest bulb in the box, but the setup instructions and video all seem a bit too vague to me... All help appreciated. -RR On Thu, Jun 7, 2012 at 1:32 PM, Dave Watts dwa...@figleaf.com wrote: Anyway, I think my problem is that both my CF install directory and my web root are on another server on the local network. So I am setting my server home to: \\10.10.1.10\c$\ColdFusion9 and my document root to: \\10.10.1.10\d$\dev\prj1425 CFB2 doesn't seem to like the configuration. It won't let me pick the CF version and won't let me click next to move on. You might try creating drive mappings for those shares, then using the drive mappings in CFB. Dave Watts, CTO, Fig Leaf Software 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 onsit ~| 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:351495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need to get at browser size and Flash support
Hello to all. I am working on a project where I need to get at the browser size of the site visitor, as well as whether the browser supports Flash or not. Can anyone point me in the right direction? The browser size detect is get at whether visitor is using a desktop, tablet, or handheld browser, so I can load the best layouts for that device. The Flash detect is to load an alternative interface for i-devices. As always, all help appreciated. -- RR ~| 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:351279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Video Streaming Provider
Thanks to Brian and Dave for the Brightcove suggestion. That looks like it will work great. -RR On Wed, May 2, 2012 at 12:28 PM, Brian Thornton br...@cfdeveloper.comwrote: Brightcove... It's cool also because the Allaire guys launched it. On Wed, May 2, 2012 at 12:26 PM, Robert Rhodes rrhode...@gmail.com wrote: My next project involves a bunch of streaming videos (mp4) for an organization's users. Each user will need to have access to a different set of videos. So, user 1 might have access to videos 100, 211, and 513, while user 2 has access to videos 21, 100, 513 and 624. So I'll need obviously need a different login, password, and access list for each user. I don't want to stream these videos on the organization's site, but rather from an external provider. Either I would just use this provider to stream the videos through a player on the organization's site (preferred), or move the user off to the video vendor's site and have the login and streaming happen there. In that case, I would need to set up the user specific video streaming lists at the provider. Either way, I am hoping to find a streaming video provider that has a straightforward API that I can use to stream the videos and possible to set up users, their passwords, and perhaps their access permissions to specific videos. Any suggestions? Thanks to all, as always. :) -RR ~| 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:351016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Best IDE for cfscript
What is the best IDE for cfcript work? CFBuilder 2? CFEclipse? Or? -RR ~| 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:351017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to get IIS7 to redirect with query string
So, I finally finished this project up. Thanks to Jonah and Andrew for their suggestions on this. The info was quite helpful. --RR On Wed, Apr 4, 2012 at 8:38 PM, .jonah jonah@creori.com wrote: In the rules section of your web.config it'd be something like: rule name=favorite color rewrite match url=((?:[a-z][a-z0-9_]*))\/((**?:[a-z][a-z0-9_]*))\/((?:[a-z]** [a-z0-9_]*))\/((?:[a-z][a-z0-**9_]*))\/((?:[a-z][a-z0-9_]*)) / action type=Rewrite url=index.cfm?q=favorite.** colorsamp;{R:2}={R:3}amp;{R:**4}={R:5} appendQueryString=false / /rule On 4/4/12 5:22 PM, Robert Rhodes wrote: Anyone out there know how to set up IIS7 to pass a query string? Any url construct is probably fine as long as I can pass four variables and it does not have a ? or a in it (per client's requirements). I am trying to get something like... http://mydomain.com/redir/a/**red/b/greenhttp://mydomain.com/redir/a/red/b/green to redirect to: http://mydomain.com/index.cfm?**q=favorite.colorsa=redb=**greenhttp://mydomain.com/index.cfm?q=favorite.colorsa=redb=green Any Ideas? -RR ~~**~~** ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-**Coldfusion-Anthology/dp/** 1430272155/?tag=houseoffusionhttp://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/**groups/cf-talk/message.cfm/** messageid:350638http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350638 Subscription: http://www.houseoffusion.com/**groups/cf-talk/subscribe.cfmhttp://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/** groups/cf-talk/unsubscribe.cfmhttp://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm ~| 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:350958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Video Streaming Provider
My next project involves a bunch of streaming videos (mp4) for an organization's users. Each user will need to have access to a different set of videos. So, user 1 might have access to videos 100, 211, and 513, while user 2 has access to videos 21, 100, 513 and 624. So I'll need obviously need a different login, password, and access list for each user. I don't want to stream these videos on the organization's site, but rather from an external provider. Either I would just use this provider to stream the videos through a player on the organization's site (preferred), or move the user off to the video vendor's site and have the login and streaming happen there. In that case, I would need to set up the user specific video streaming lists at the provider. Either way, I am hoping to find a streaming video provider that has a straightforward API that I can use to stream the videos and possible to set up users, their passwords, and perhaps their access permissions to specific videos. Any suggestions? Thanks to all, as always. :) -RR ~| 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:350964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Javascript test in ColdFusion
Thanks to all for the suggestions on this. I went with the approach below and it worked well. Thank you Andy, -RR On Mon, Mar 26, 2012 at 11:39 PM, andy matthews li...@commadelimited.comwrote: A dead simple way of testing for JavaScript: script window.location.href = 'javascriptCapable.cfm'; /script meta http-equiv=refresh content=1; url=nonJavascriptCapable.cfm If a browser understands JS they get one page, if they don't they get another. One thing to consider though that it's not quite as simple as understanding JS...you should be checking for specific functionality using something like Modernizr. http://www.modernizr.com/ andy -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Monday, March 26, 2012 12:00 PM To: cf-talk Subject: Javascript test in ColdFusion Hello again. I have a site that loads all the content in ajax. I also have a version of the site that does not use ajax. I am looking for some code I can put in the application.cfm to test to see if the visitor's browser supports javascipt or not, so I can load the right version of the site. Any ideas? Thanks. --RR ~| 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:350635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to get IIS7 to redirect with query string
Anyone out there know how to set up IIS7 to pass a query string? Any url construct is probably fine as long as I can pass four variables and it does not have a ? or a in it (per client's requirements). I am trying to get something like... http://mydomain.com/redir/a/red/b/green to redirect to: http://mydomain.com/index.cfm?q=favorite.colorsa=redb=green Any Ideas? -RR ~| 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:350638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
I wanted to circle back and thank everyone for their suggestions. Running the site in SSL all the time got us passed, and the site seems to be working fine. I wish there was a better way, but this works. Thanks again. -RR On 3/6/12, Robert Rhodes rrhode...@gmail.com wrote: If jsessionids are enabled, CF appears to set that cookie, no matter what. I know of no way to prevent that from happening. And yes, even those the site being loaded by https, the jsessionid cookie is still being set insecurely. As I said before, this should be easier than it is. Or maybe it's just because I am missing something obvious. -RR On Tue, Mar 6, 2012 at 3:00 PM, Cameron Childress camer...@gmail.comwrote: On Tue, Mar 6, 2012 at 2:56 PM, Robert Rhodes rrhode...@gmail.com wrote: Yes, I saw that. But he does not say how he made the new jsession id string. I am sure it is not some random string he pro grammatically generated. So, there must be a way to get at the jsessionid even if you don't have jsessionidenabled in the administrator. I'd say, enable it in the CFAdmin, tell CF not to set cookies automatically (via code), then set it yourself. Are you sure it's getting set as nonsecure? That is very suprising to me. -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:350542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Javascript test in ColdFusion
Hello again. I have a site that loads all the content in ajax. I also have a version of the site that does not use ajax. I am looking for some code I can put in the application.cfm to test to see if the visitor's browser supports javascipt or not, so I can load the right version of the site. Any ideas? Thanks. --RR ~| 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:350545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
It's a video streaming site for members. I can't believe my only option is to stream video across ssl. There must be another solution. -RR On Tue, Mar 6, 2012 at 7:46 AM, DURETTE, STEVEN J sd1...@att.com wrote: Just out of curiosity, why can't you have the entire session running under SSL? Ever since Firesheep came out it is actually suggested to be all encrypted all the time. Steve -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Tuesday, March 06, 2012 2:20 AM To: cf-talk Subject: Failed PCI Compliance test on CF9.01 So a site that I built failed PCI compliance testing because the jsessionid cookie is not set securely. I found this post http://thinkinglemur.com/index.php/2009/02/setting-secure-attribute-of-jsessionid-cookie-in-coldfusion-8/ that shows how to force jrun to do always set the session cookies securely, but the user loses their session state when they move between secure and non-secure pages (the jsessionid is different for secure pages). This is obviously a big problem, since we can't have the entire user session running under ssl. Any ideas on how to get the jsessionid to be the same on secure and non-secure pages? I am a little lost here. I am running cf9.01, with the app set to sessionmanagement=yes and setclientcookies=no. In the administrator, I have Cookie set as my default client storage storage mechanism, and J2EE session variables enabled. I also have use UUID for cftoken enabled, but since I have setclientcookies set to no, I don't think that matters. *-RR* ~| 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:350249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
Justin, thanks for the reply, and I get your point, but I can't break out the registration process into a standalone site quickly. There must be a fairly quick solution to this problem. Surely, I can't be the first to deal with this. On Tue, Mar 6, 2012 at 8:44 AM, Justin Scott leviat...@darktech.org wrote: It's a video streaming site for members. I can't believe my only option is to stream video across ssl. There must be another solution. There is: take the main site out of scope for compliance. The only parts of a system that have to be PCI compliant are the ones that handle credit card information, usually an online store or subscription system. There is no technical reason I can think of that would require your billing system and video streaming servers to share infrastructure. Separating the billing system out on to its own infrastructure means the rest of the system goes out of scope and then you can do whatever you want with your cookies on the main part of the site. Keep the billing system isolated and your headaches will be greatly reduced. -Justin Sco ~| 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:350253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
For both Phillip and Donnie -- I just set the site up for database storage for the client session in the cf admin (server settings - client variables), and I see data going in those two tables, but I am still losing the session state when moving from https to http. I have this set in my application.cfm: clientmanagement=Yes sessionmanagement=Yes setclientcookies=No clientstorage=MyDSN What am I doing wrong? I did remove the change I made to jrun to force session cookies to be set securely, but I doubt that matters now, because set client cookies is set to no. I am running cf 9.01 standard. -RR On Tue, Mar 6, 2012 at 9:24 AM, Donnie Bachan (Gmail) donnie.bac...@gmail.com wrote: Robert, This is odd that you are losing the session, are you using CF in multiserver mode or standalone? The article you referenced was for CF8, however, we're currently running CF9 Ent in multiserver mode and we've not had this issue crop up. We are however using a DB with client cookies for managing state across CF instances. Best Regards, 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 Tue, Mar 6, 2012 at 2:17 PM, Che Vilnonis ch...@asitv.com wrote: Robert, a product like Fuseguard from Pete Freitag or a Web Application Firewall (or a plugin type of filter to your existing firewall) may help. I'm currently going through a similar process and thought these options might help. Ché -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Tuesday, March 06, 2012 9:08 AM To: cf-talk Subject: Re: Failed PCI Compliance test on CF9.01 Justin, thanks for the reply, and I get your point, but I can't break out the registration process into a standalone site quickly. There must be a fairly quick solution to this problem. Surely, I can't be the first to deal with this. ~| 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:350265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
Nope. Just CF on this sever, and just this one site running. On Tue, Mar 6, 2012 at 10:37 AM, Phillip Duba phild...@gmail.com wrote: Are all your sites running under CF or do you have another Java-based app server, like Tomcat/JBoss, running portions of your site as well? That happened to me. Someone turned on sessions for a Tomcat app that didn't need it and users would drop sessions as they moved around the site from the CF side to the Tomcat side, Phil On Tue, Mar 6, 2012 at 10:33 AM, Robert Rhodes rrhode...@gmail.com wrote: For both Phillip and Donnie -- I just set the site up for database storage for the client session in the cf admin (server settings - client variables), and I see data going in those two tables, but I am still losing the session state when moving from https to http. I have this set in my application.cfm: clientmanagement=Yes sessionmanagement=Yes setclientcookies=No clientstorage=MyDSN What am I doing wrong? I did remove the change I made to jrun to force session cookies to be set securely, but I doubt that matters now, because set client cookies is set to no. I am running cf 9.01 standard. -RR On Tue, Mar 6, 2012 at 9:24 AM, Donnie Bachan (Gmail) donnie.bac...@gmail.com wrote: Robert, This is odd that you are losing the session, are you using CF in multiserver mode or standalone? The article you referenced was for CF8, however, we're currently running CF9 Ent in multiserver mode and we've not had this issue crop up. We are however using a DB with client cookies for managing state across CF instances. Best Regards, 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 Tue, Mar 6, 2012 at 2:17 PM, Che Vilnonis ch...@asitv.com wrote: Robert, a product like Fuseguard from Pete Freitag or a Web Application Firewall (or a plugin type of filter to your existing firewall) may help. I'm currently going through a similar process and thought these options might help. Ché -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Tuesday, March 06, 2012 9:08 AM To: cf-talk Subject: Re: Failed PCI Compliance test on CF9.01 Justin, thanks for the reply, and I get your point, but I can't break out the registration process into a standalone site quickly. There must be a fairly quick solution to this problem. Surely, I can't be the first to deal with this. ~| 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:350267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
I just put back the jrun setting to pass cookies securely, and am sending the jsessionid securely again. And I am set up to use the database for client storage. It's still losing the session when I switch between http and https. I do have setclientcookies to no, because that sets cfid and cftoken insecurely which is what caused the PCI test failure. This really should not be this hard. I an't be the only person dealing with this issue. :( On Tue, Mar 6, 2012 at 10:44 AM, Donnie Bachan (Gmail) donnie.bac...@gmail.com wrote: Hi Robert, I'm not sure if I'm missing something but shouldn't you have setClientCookies to Yes? Otherwise you'd have to pass the JSESSIONID in the url on each request. Best Regards, 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 Tue, Mar 6, 2012 at 3:33 PM, Robert Rhodes rrhode...@gmail.com wrote: For both Phillip and Donnie -- I just set the site up for database storage for the client session in the cf admin (server settings - client variables), and I see data going in those two tables, but I am still losing the session state when moving from https to http. I have this set in my application.cfm: clientmanagement=Yes sessionmanagement=Yes setclientcookies=No clientstorage=MyDSN What am I doing wrong? ~| 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:350269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
I hear you, but there are issues preventing me from going all https. It's a long story. Is there a way to copy, with some code in the application.cfm, the jsessionid between http and https so we don't lose the session state? -rr On Tue, Mar 6, 2012 at 11:24 AM, Pete Freitag p...@foundeo.com wrote: Hi Robert, You are caught in a bit of a catch 22 here. If you want to set the secure attribute on session cookies delivered over SSL, but also have it use the same cookie values over non-ssl - then that defeats the purpose of adding the secure attribute. If you want to do that you can't use the secure attribute on the cookies. The secure attribute says only send this cookie over SSL, so when you make a request to a non-ssl url the browser will not send the cookie, this causes ColdFusion to issue a new session. The best solution is to run all on SSL as Cameron suggested, here's a good read on the performance of SSL and TLS: http://www.imperialviolet.org/2010/06/25/overclocking-ssl.html the main point being that SSL is not as computationally expensive as you may think. If that's not going to fly then you need to build something to share data between the sessions, while making sure that the non-ssl data is not privileged - it can get complicated to ensure that your not opening yourself up to security issues over non-ssl. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Tue, Mar 6, 2012 at 2:19 AM, Robert Rhodes rrhode...@gmail.com wrote: So a site that I built failed PCI compliance testing because the jsessionid cookie is not set securely. I found this post http://thinkinglemur.com/index.php/2009/02/setting-secure-attribute-of-jsessionid-cookie-in-coldfusion-8/ that shows how to force jrun to do always set the session cookies securely, but the user loses their session state when they move between secure and non-secure pages (the jsessionid is different for secure pages). This is obviously a big problem, since we can't have the entire user session running under ssl. Any ideas on how to get the jsessionid to be the same on secure and non-secure pages? I am a little lost here. I am running cf9.01, with the app set to sessionmanagement=yes and setclientcookies=no. In the administrator, I have Cookie set as my default client storage storage mechanism, and J2EE session variables enabled. I also have use UUID for cftoken enabled, but since I have setclientcookies set to no, I don't think that matters. *-RR* ~| 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:350277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
Ok, I am going to try to make the site work all ssl. I am concerned about the video streaming over ssl, but I guess we will see how it goes. On a related subject: is there a way to make the jsessionid cookie secure without making the jrun change? I ask because doing so affects all sites on the server, and I had planed to run other sites on this particular server. On Tue, Mar 6, 2012 at 12:59 PM, Cameron Childress camer...@gmail.comwrote: On Tue, Mar 6, 2012 at 11:55 AM, Robert Rhodes rrhode...@gmail.com wrote: I hear you, but there are issues preventing me from going all https. It's a long story. Is there a way to copy, with some code in the application.cfm, the jsessionid between http and https so we don't lose the session state? You could make this work, but then you would be exactly where you currently are, and would again fail the PCI audit. I know you are looking for a quick answer, but there isn't really a great easy option here. Many shops spend literally months getting compliant, so this code change really doesn't seem so huge in comparison, even though I know if feel like it is. You best solution, in the long term as well as the short run, is to make the code changes and just spend the time and money on it so it's right. -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:350282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
That works for cfid and cftoken, thanks. But it won't work for jsessionid, because once that is selected in the administrator, it shows up as an unsecure cookie, even if you have setclientcookies turned off. That's a bummer, I wanted to use jsessionids. On Tue, Mar 6, 2012 at 1:59 PM, Cameron Childress camer...@gmail.comwrote: Yes. If it were me, I would turn setClientCookies=false in the Applciation.cfc|cfm and then set them manually using: cfcookie name=cfid value=#session.cfid# secure=true/ cfcookie name=cftoken value=#session.cftoken# secure=true/ If you google around a bit you can probably find some sample code for doing this. If you are using JSessionIDs (not cfid/cftoken) you'll be just setting that cookie but I would expect it to work in that case as well. Whole you're at it you might also pop open Chrome debugging or the like and verify that those are the only cookies being sent, just to make sure you don't have something else that trips you up. -Cameron On Tue, Mar 6, 2012 at 1:47 PM, Robert Rhodes rrhode...@gmail.com wrote: Ok, I am going to try to make the site work all ssl. I am concerned about the video streaming over ssl, but I guess we will see how it goes. On a related subject: is there a way to make the jsessionid cookie secure without making the jrun change? I ask because doing so affects all sites on the server, and I had planed to run other sites on this particular server. On Tue, Mar 6, 2012 at 12:59 PM, Cameron Childress camer...@gmail.com wrote: On Tue, Mar 6, 2012 at 11:55 AM, Robert Rhodes rrhode...@gmail.com wrote: I hear you, but there are issues preventing me from going all https. It's a long story. Is there a way to copy, with some code in the application.cfm, the jsessionid between http and https so we don't lose the session state? You could make this work, but then you would be exactly where you currently are, and would again fail the PCI audit. I know you are looking for a quick answer, but there isn't really a great easy option here. Many shops spend literally months getting compliant, so this code change really doesn't seem so huge in comparison, even though I know if feel like it is. You best solution, in the long term as well as the short run, is to make the code changes and just spend the time and money on it so it's right. -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:350285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
Yes, I saw that. But he does not say how he made the new jsession id string. I am sure it is not some random string he pro grammatically generated. So, there must be a way to get at the jsessionid even if you don't have jsessionidenabled in the administrator. On Tue, Mar 6, 2012 at 2:44 PM, Cameron Childress camer...@gmail.comwrote: Try this: http://www.12robots.com/index.cfm/2009/5/6/Making-the-JSESSIONID-Session-Token-Cookie-SECURE-and-HTTPOnly-and-settings-its-PATH -Cameron On Tue, Mar 6, 2012 at 2:39 PM, Robert Rhodes rrhode...@gmail.com wrote: That works for cfid and cftoken, thanks. But it won't work for jsessionid, because once that is selected in the administrator, it shows up as an unsecure cookie, even if you have setclientcookies turned off. That's a bummer, I wanted to use jsessionids. -- 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:350289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Failed PCI Compliance test on CF9.01
If jsessionids are enabled, CF appears to set that cookie, no matter what. I know of no way to prevent that from happening. And yes, even those the site being loaded by https, the jsessionid cookie is still being set insecurely. As I said before, this should be easier than it is. Or maybe it's just because I am missing something obvious. -RR On Tue, Mar 6, 2012 at 3:00 PM, Cameron Childress camer...@gmail.comwrote: On Tue, Mar 6, 2012 at 2:56 PM, Robert Rhodes rrhode...@gmail.com wrote: Yes, I saw that. But he does not say how he made the new jsession id string. I am sure it is not some random string he pro grammatically generated. So, there must be a way to get at the jsessionid even if you don't have jsessionidenabled in the administrator. I'd say, enable it in the CFAdmin, tell CF not to set cookies automatically (via code), then set it yourself. Are you sure it's getting set as nonsecure? That is very suprising to me. -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:350291 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Failed PCI Compliance test on CF9.01
So a site that I built failed PCI compliance testing because the jsessionid cookie is not set securely. I found this posthttp://thinkinglemur.com/index.php/2009/02/setting-secure-attribute-of-jsessionid-cookie-in-coldfusion-8/that shows how to force jrun to do always set the session cookies securely, but the user loses their session state when they move between secure and non-secure pages (the jsessionid is different for secure pages). This is obviously a big problem, since we can't have the entire user session running under ssl. Any ideas on how to get the jsessionid to be the same on secure and non-secure pages? I am a little lost here. I am running cf9.01, with the app set to sessionmanagement=yes and setclientcookies=no. In the administrator, I have Cookie set as my default client storage storage mechanism, and J2EE session variables enabled. I also have use UUID for cftoken enabled, but since I have setclientcookies set to no, I don't think that matters. *-RR* ~| 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:350243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFScript Book
Hello to all. Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. All suggestions welcome. -RR ~| 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:349961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFScript Book
Hi Cameron. I know CF very well. I been coding in it for many years. But, I admit, I am a little tagged out. Cfscript feels more elegant, and as I learn more and more javascript, it seems a natural time to try to get completely up to speed on cfscript. I do wish Adobe would fill out CF so that one could write mostly in cfscript and avoid cf tags altogether, if desired. It would also help when I end up around small-minded coders who scoff at CF merely because of the tags. Yes, I have answers for those types, like how I can produce the same apps they can, but in 1/3 the time, or how Adobe puts a lot of development into the language, which gets us big upgrades every few years -- or how we can get a live body on the phone when we need one. But still, I really want to be a cfscripter, and I am looking for a path to make that happen. There must be at least a few chapters in some book out there somewhere, no? Pete, thank you very much for the cheat sheet. That will come in handy. -RR On Mon, Feb 20, 2012 at 12:25 PM, Cameron Childress camer...@gmail.comwrote: On Mon, Feb 20, 2012 at 10:48 AM, Robert Rhodes rrhode...@gmail.com wrote: Are there any CFScript books out there? I ordered this onw but it was a complete joke. A total waste of money: http://www.barnesandnoble.com/w/cfscript-lambert-m-surhone/1026883099. Is there a reason you want to only learn CFScript? The CFML language has so many tags and many ways of doing things. Learning only CFScript may not serve you well. Attempting to use all tags or all script is probably not the best goal IMHO. Having said that, the Adobe docs are a good starting point for learning CFScript, but if you want more than that I'd look at a regular ole CF Book like CFWACK, and then look for a CFScript equivalent for what you're doing if you really need/want one. -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:349983 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Quick CF9 Install questions
Hell to all. I have to deploy a couple new CF9 installs today, and I just want to confirm that I have this right: Download the installer here: https://www.adobe.com/cfusion/tdrc/index.cfm?product=coldfusion Then the CF 9 Update 1 (9.01) here: http://www.adobe.com/support/coldfusion/downloads_updates.html Then the CF9 Cumulative Hot-Fix here: http://kb2.adobe.com/cps/918/cpsid_91836.html That's all I need for CF, yes? Sorry for the dumb question, it's still yesterday to me. :( -RR ~| 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:348877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Generating Thumbnails of file contents
Thanks all for the replies. You responses confirmed that there is unfortunately no simple solution to this. I appreciate the suggestions and see if I can get the client to go with any of them. RR On Tue, Sep 20, 2011 at 11:11 AM, Robert Rhodes rrhode...@gmail.com wrote: Hello to all. I know we can generate thumbnails of PDFs with cfpdf, but is there a way with CF to generate thumbnails for Word, Excel, Powerpoint, and text files? If not, is there some service some where that I can hook into for realtime conversion? Thanks. RR ~| 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:347664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Generating Thumbnails of file contents
Hello to all. I know we can generate thumbnails of PDFs with cfpdf, but is there a way with CF to generate thumbnails for Word, Excel, Powerpoint, and text files? If not, is there some service some where that I can hook into for realtime conversion? Thanks. RR ~| 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:347544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looking for a shared host that doesn't block cfobject
Good Morning. I am looking for a shared host that doesn't block CreateObject(Java). Any ideas? Also, what's the risk on this? And is there any way to mitigate that risk? (either by the host or by me) Thanks. RR ~| 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:346754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Looking for a shared host that doesn't block cfobject
Russ, thanks for the reply. Does proper sandboxing and cf9 alleviate the risks enough to be reasonably safe? If not, what are the risks? On Mon, Aug 15, 2011 at 8:38 AM, Russ Michaels r...@michaels.me.uk wrote: Hi, we do not block cfobject, it is less of an issue in CF9 than previous versions, it is CreateObject(java) that is more of an issue. I'm afraid it is a toss up, you go with a host that disables all the dangerous tags and work around it, safe in the knowledge that no-one else on the server can do anything dodgy either, or you go with a host that allows dangerous tags and take the risk. Any host should at least be using security sandboxes to lock down any takes that allow I/O access, if they have just turned them on and have not sand boxed, then they are extremely insecure and you should avoid them. -- Russ Michaels www.cfmxhosting.co.uk: ColdFusion Hosting www.cfmldeveloper.com: ColdFusion developer community + free developer hosting www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine ** *skype me* : russmichaels ~| 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:346756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
missing args in jvm
Hi to all. I notice that the jvms on a couple of my cf9.01 installs dont include these args that the others do: -Djava.security.policy={application.home}/../lib/coldfusion.policy -Djava.security.auth.policy={application.home}/../lib/neo_jaas.policy What are these for, and why would they be missing form a couple of the installs? Maybe I did the 9.01 patch incorrectly on those two boxes? It is a bit of a pain in the ass RR ~| 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:346281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Looking for a good Click-to-Call provider
No one here has ever use a click-to-call provider? Can't believe little old me is breaking new ground. :) On Thu, Jun 23, 2011 at 9:56 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello All. I am looking for good Click-to-Call provider with a cf-friendly web service to consume. Any recommendations? RR ~| 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:345711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Looking for a good Click-to-Call provider
Hello All. I am looking for good Click-to-Call provider with a cf-friendly web service to consume. Any recommendations? RR ~| 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:345607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf9 query not returning identityCol
I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| 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:345066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
I wanted to circle back and thank everyone who helped me on this thread. I did as Nathan described below, and it was immediately clear that the cfinvoke posts were not going out. After some painful troubleshooting and using a lot of very bad words, I figured out why. When using cfinvoke, you must pass ALL arguments specified in the wsdl -- even though they are not required by the service. I swear, I looked at the cf9 docs a bunch of times and never saw that! The good news is that you can pass unneeded arguments with omit=yes so you don't have to set their values. But how crazy is that? You are required to pass all arguments just so you can tell cfinvoke to omit them! In the end it all worked out, but what a pain in the arse! RR On Wed, May 25, 2011 at 8:57 AM, Nathan Mische nmis...@gmail.com wrote: On Tuesday, May 24, 2011, Robert Rhodes rrhode...@gmail.com wrote: I don't need to monitor between my computer and the application server. I need to monitor between the application server and a remote server across the web that hosts the web service. Adding the proxyserver and proxyport attributes to you cfinvoke call will proxy the request from the application server to the remote server through your local instance of Charles, allowing you to see the traffic. To simply things you may want to install Charles on your development server. Then you can set cfinvoke's proxyserver attribute to 127.0.0.1 and the proxyport to . If using SSL you will still need to configure the remote server in Charles and add the Chalres CA to ColdFusion key store. I have no control over the remote server and the folks that do are only marginally helpful. Worse, they are taking the position that this is a Coldfusion problem. All very frustrating. It can be a bit tricky to craft SOAP requests from CF, particularly if the remote service expects complex input. You may want to check out my chapter on web services and complex types in the ColdFusion Anthology, available on Google books: http://bit.ly/cfwebservices --Na ~| 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:345067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFIDE weirdness in iis7
I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| 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:345068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
aha! I see it now. Unfortunately, I can delete or change that mapping. :( On Sat, Jun 4, 2011 at 6:56 PM, Wil Genovese jugg...@trunkful.com wrote: Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| 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:345073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
I always thought that cfide being available on a public site was a security risk, so I have done without, rolling my own as necessary. Is there a way to have it available and still be totally secure? On Sat, Jun 4, 2011 at 7:06 PM, Russ Michaels r...@michaels.me.uk wrote: You do need the CFIDE mapped on your sites if you use ANY of the ajax, CFFORM, applets, etc as these need to loads files form the CFIDE, it is also worth noting that even if you do not map to the master CFIDE on the site and instead create a copy with only the files you need CF itself still accesses the original folder for certain functions. This will probably only affect you if you use sandboxing though. On Sat, Jun 4, 2011 at 11:56 PM, Wil Genovese jugg...@trunkful.com wrote: Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| 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:345074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Oh yeah, I know. But if you set the connector to all sites, and you add a new site, they all go down until you remove the connector and reapply it. And even when you set the connector on a site by site basis (which is a pain), if you change the site's root directory (like when you are deploying a new version), cf stops working for that site and you have remove its connector and reapply it again. Another pain. I have chosen to go with the second approach, becuase at least it doesn;t take down all sites. I really don't want to install iis6 compatibility just to use Coldfusion. Adobe needs to fix this. On Sat, Jun 4, 2011 at 7:10 PM, Matt Quackenbush quackfu...@gmail.comwrote: On Sat, Jun 4, 2011 at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. FYI, on a clean installation of CF9.0.1 there is absolutely no need whatsoever to install the IIS6 compatibility tools. Simply run the CF9 installer and then immediately run the CF9.0.1 update installer. _THEN_ browse to the CF Administrator to finish the install. It truly is that simple. ~| 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:345075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| 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:345076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
Weird. Not working for me with cf9 and sql sever 2005. Identity Specification = Yes Is Identity = Yes Identity Increment 1 Identity Seed 1 On Sat, Jun 4, 2011 at 8:23 PM, Paul Kukiel pkuk...@gmail.com wrote: It does work and thats the way to do it. Are you 100% it's an auto inc field? http://cookbooks.adobe.com/post_Generated_key___Get_the_ID_of_the_inserted_record-16593.html Paul. On Jun 5, 2011, at 9:35 AM, Robert Rhodes wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| 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:345081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf9 query not returning identityCol
This is the way I have been doing it. I may have to keep doing it this way if I can't get result.identityCol to work the way it is supposed to: cfquery datasource=someDsn name=insertRecord INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) SELECT Scope_Identity() AS ID /cfquery cfoutput#tinsertRecord.ID#/cfoutput It's a little more efficient than doing it with two separate querys. RR On Sat, Jun 4, 2011 at 10:12 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: http://cookbooks.adobe.com/post_Getting_the_ID_of_the_Last_Record_Inserted_I nto_a-16522.html I'm curious as to the best way of doing this in CF7. Currently I do another query to find the last inserted ID, but this seems a long winded way of doing things. Jenny Gavin-Wear Fast Track eCommerce http://www.ftol-ecommerce.com/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: 05 June 2011 02:11 To: cf-talk Subject: Re: cf9 query not returning identityCol Weird. Not working for me with cf9 and sql sever 2005. Identity Specification = Yes Is Identity = Yes Identity Increment 1 Identity Seed 1 On Sat, Jun 4, 2011 at 8:23 PM, Paul Kukiel pkuk...@gmail.com wrote: It does work and thats the way to do it. Are you 100% it's an auto inc field? http://cookbooks.adobe.com/post_Generated_key___Get_the_ID_of_the_ inserted_record-16593.html Paul. On Jun 5, 2011, at 9:35 AM, Robert Rhodes wrote: That's for MYSQL. I am using SQL Server 2005. The docs say identityCol But I will give it a try.. Nope., didn't work. Thanks, though. :) On Sat, Jun 4, 2011 at 6:56 PM, Jason Durham jqdur...@gmail.com wrote: It's theResult.generatedKey On Jun 4, 2011 4:46 PM, Robert Rhodes rrhode...@gmail.com wrote: I am frustrated. :( In the cf9 docs, it says that cfquery is supposed to return, in the result variable, the identity column value of the inserted record. However it is not working from me. Would one of you kind souls point out my mistake? cfquery datasource=someDsn name=insertRecord result=theResult INSERT INTO someTable ( firstName, lastName ) VALUES ( cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.firstName#, cfqueryparam cfsqltype=cf_sql_varchar maxlength=20 value=#arguments.lastName# ) /cfquery cfoutput#theResult.identityCol#/cfoutput When I run this, identityCol is not there. I am indeed using an autonumbering identity column in the database. Yes, I know I can just add a select to this query to get at it, but I really want this to work, dammit! ~| 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:345083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Will, thanks for the reply. I tried changing the mapping to the cfide directory in neo-runtime.xml, but it keeps reverting to its original path. I don't want to use the CFIDE that is in the wwwroot directory, but rather a copy of the directory in another location. RR On Sat, Jun 4, 2011 at 8:15 PM, Wil Genovese jugg...@trunkful.com wrote: You can manually edit the neo-runtime.xml file and set the mapping to the proper location that way. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 6:23 PM, Robert Rhodes wrote: aha! I see it now. Unfortunately, I can delete or change that mapping. :( On Sat, Jun 4, 2011 at 6:56 PM, Wil Genovese jugg...@trunkful.com wrote: Look at the mappings in the CF Admin - that tells you and CF where the CFIDE folder is that it's actually using. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Jun 4, 2011, at 5:24 PM, Robert Rhodes wrote: I am still grumpy about how 9.01 does not install nicely with IIS7 withouth first installing the IIS compatibility tools. But not I am having a new weirdness. I usually do not set virtual directories pointing to cfide and cfdocs. I get at the administrator on an admin site that is only available via vpn. When I installed the web connector on IIS7, it automatically added those virtual directories to a public facing web site, so I deleted them. But when you go to the admin login url, the form is still there (but the links to all the images are broken), and you can actually log into the cf admin from the public site. But those virtual directories are really deleted! What am I missing here? RR ~| 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:345084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Yes, I tried that. No luck. Actually, it's almost as if it is changed, but when I log into the Administrator, it reverts back then. I know that sounds crazy... On Sun, Jun 5, 2011 at 12:02 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 5/06/2011 13:52, Robert Rhodes wrote: Will, thanks for the reply. I tried changing the mapping to the cfide directory in neo-runtime.xml, but it keeps reverting to its original path. make sure you do the edit with CF stopped as it writes its settings back to the file when you shut it down. -- Yours, Kym Kovan mbcomms.net.au ~| 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:345088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Aha. The trick is to stop cf, rename the incorrect cfide, delete the web.config files, restart cf, load the administrator at its new location. On Sun, Jun 5, 2011 at 12:22 AM, Robert Rhodes rrhode...@gmail.com wrote: Yes, I tried that. No luck. Actually, it's almost as if it is changed, but when I log into the Administrator, it reverts back then. I know that sounds crazy... On Sun, Jun 5, 2011 at 12:02 AM, Kym Kovan dev-li...@mbcomms.net.auwrote: On 5/06/2011 13:52, Robert Rhodes wrote: Will, thanks for the reply. I tried changing the mapping to the cfide directory in neo-runtime.xml, but it keeps reverting to its original path. make sure you do the edit with CF stopped as it writes its settings back to the file when you shut it down. -- Yours, Kym Kovan mbcomms.net.au ~| 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:345089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIDE weirdness in iis7
Andrew, your post on the cf9.01 install problem hits the nail on the head. I have been complaining about this since I first got cf9.01 running. I talked with Adobe tech support, but they could not seem to grasp why I did not want to install IIS 6 compatibility. Therefore, they don't see this as a problem. So we should not hold our breath for a solution. RR Your other pose was an interesting read too On Sun, Jun 5, 2011 at 12:50 AM, Andrew Scott andr...@andyscott.id.auwrote: There are a few things one needs to take into consideration when doing sandboxing and ORM as well as with the CFIDE, most hosting providers will setup a safe version of the CFIDE mapping for you. But what if you are looking at doing this yourself? http://www.andyscott.id.au/2011/4/18/ColdFusion-ORM-Event-Handling-and-a-pro blem-with-shared-hosting And things to know when installing ColdFusion 9.01 and some pitfalls people may come across. http://www.andyscott.id.au/2011/3/29/Things-to-know-when-installing-ColdFusi on-9-then-updating-to-901 Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Sunday, 5 June 2011 9:30 AM To: cf-talk Subject: Re: CFIDE weirdness in iis7 Oh yeah, I know. But if you set the connector to all sites, and you add a new site, they all go down until you remove the connector and reapply it. And even when you set the connector on a site by site basis (which is a pain), if you change the site's root directory (like when you are deploying a new version), cf stops working for that site and you have remove its connector and reapply it again. Another pain. I have chosen to go with the second approach, becuase at least it doesn;t take down all sites. I really don't want to install iis6 compatibility just to use Coldfusion. Adobe needs to fix this. ~| 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:345092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Hello Jochem. I checked out Wireshark, but did not see a way for it to show me the XML I was sending. Am I missing something? It looks like Wireshark is a packet capture tool? rr On Mon, May 23, 2011 at 7:47 AM, Jochem van Dieten joch...@gmail.comwrote: On Mon, May 23, 2011 at 1:16 AM, Robert Rhodes wrote: Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? Install Wireshark to capture all traffic on a system: http://www.wireshark.org/ Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:344856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Hi Pete. I did try soapui, and it looked like it should do what I wanted, but I could not figure out how to make it work so that I could capture the outgoing soap and responses between my dev server and the remote server. On Mon, May 23, 2011 at 11:04 AM, Pete Freitag p...@foundeo.com wrote: SoapUI is a great tool for debugging soap: http://www.soapui.org/ If you give it a WSDL url it can generate stubs for testing the remote service and lets you see and edit all aspects of the soap request and response. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Sun, May 22, 2011 at 7:16 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello everyone. I appreciate the help you have given me recently. Now I have a new challenge, and I am sure some of you have faced it before. I have written an application that gets and puts data to a SOAP .asmx web service running on a windows server across the internet. I am using cfinvoke. All my gets are working fine. I am getting the expected data. However all my puts are failing, and the guy at the other end says my soap xml must be wrong. Hey, it might be, but I have not been able to come up with a way to see it. I did a google search and found Fiddler and Charles, and installed them both on the dev server which is running my application. But no luck. Each program seems to monitor the traffic between my browser and local dev server, but I need to monitor traffic betwen dev server and the other server across the internet (on a non-standard ssl port). Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? RR ~| 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:344857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Yes, that is the case. And all my attempts so for to view the https xml and response have failed. This is probably because there is some part of this that I am just not getting. I am hoping for that lightbulb moment soon. In the meantime, I am feeling totally lost On Tue, May 24, 2011 at 4:48 AM, James Holmes james.hol...@gmail.comwrote: One issue the OP faces is that the traffic is HTTPS. The request will have to change to HTTP before anything useful will show up. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 24 May 2011 16:14, Jochem van Dieten joch...@gmail.com wrote: On Tue, May 24, 2011 at 9:55 AM, Robert Rhodes wrote: Hello Jochem. I checked out Wireshark, but did not see a way for it to show me the XML I was sending. Am I missing something? It looks like Wireshark is a packet capture tool? Yes, it is a packet capture tool. It allows you to drill down in the results until you reach the SOAP data in the HTTP payload. Just keep expanding the results until you reach it. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:344861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Brook, would you share how to set fiddler up? I could not get it to show me traffic between by dev server and the remote server. (which is happening on a non-standard SSL port) On Tue, May 24, 2011 at 10:07 AM, Brook Davies cft...@logiforms.com wrote: I use Fiddler (http://www.fiddler2.com/Fiddler2/version.asp ) for debugging web service calls and it can dump the raw XML request/response and allows you to inspect HTTPS traffic... Brook -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: May-24-11 1:00 AM To: cf-talk Subject: Re: Debugging SOAP Hi Pete. I did try soapui, and it looked like it should do what I wanted, but I could not figure out how to make it work so that I could capture the outgoing soap and responses between my dev server and the remote server. On Mon, May 23, 2011 at 11:04 AM, Pete Freitag p...@foundeo.com wrote: SoapUI is a great tool for debugging soap: http://www.soapui.org/ If you give it a WSDL url it can generate stubs for testing the remote service and lets you see and edit all aspects of the soap request and response. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Sun, May 22, 2011 at 7:16 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello everyone. I appreciate the help you have given me recently. Now I have a new challenge, and I am sure some of you have faced it before. I have written an application that gets and puts data to a SOAP .asmx web service running on a windows server across the internet. I am using cfinvoke. All my gets are working fine. I am getting the expected data. However all my puts are failing, and the guy at the other end says my soap xml must be wrong. Hey, it might be, but I have not been able to come up with a way to see it. I did a google search and found Fiddler and Charles, and installed them both on the dev server which is running my application. But no luck. Each program seems to monitor the traffic between my browser and local dev server, but I need to monitor traffic betwen dev server and the other server across the internet (on a non-standard ssl port). Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? RR ~| 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:344869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Yes I loaded it on the development web/cf9 server. And I set fiddler to the ssl port we are using. From another computer, I loaded up the site on the dev server and ran the cfinvoke to post up the soap to the server across the web. Fiddler saw nothing. I am sure I have it configured incorrectly. RR On Tue, May 24, 2011 at 1:10 PM, Brook Davies cft...@logiforms.com wrote: Did you install it on the dev server? Brook -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: May-24-11 10:01 AM To: cf-talk Subject: Re: Debugging SOAP Brook, would you share how to set fiddler up? I could not get it to show me traffic between by dev server and the remote server. (which is happening on a non-standard SSL port) On Tue, May 24, 2011 at 10:07 AM, Brook Davies cft...@logiforms.com wrote: I use Fiddler (http://www.fiddler2.com/Fiddler2/version.asp ) for debugging web service calls and it can dump the raw XML request/response and allows you to inspect HTTPS traffic... Brook -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: May-24-11 1:00 AM To: cf-talk Subject: Re: Debugging SOAP Hi Pete. I did try soapui, and it looked like it should do what I wanted, but I could not figure out how to make it work so that I could capture the outgoing soap and responses between my dev server and the remote server. On Mon, May 23, 2011 at 11:04 AM, Pete Freitag p...@foundeo.com wrote: SoapUI is a great tool for debugging soap: http://www.soapui.org/ If you give it a WSDL url it can generate stubs for testing the remote service and lets you see and edit all aspects of the soap request and response. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Sun, May 22, 2011 at 7:16 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello everyone. I appreciate the help you have given me recently. Now I have a new challenge, and I am sure some of you have faced it before. I have written an application that gets and puts data to a SOAP .asmx web service running on a windows server across the internet. I am using cfinvoke. All my gets are working fine. I am getting the expected data. However all my puts are failing, and the guy at the other end says my soap xml must be wrong. Hey, it might be, but I have not been able to come up with a way to see it. I did a google search and found Fiddler and Charles, and installed them both on the dev server which is running my application. But no luck. Each program seems to monitor the traffic between my browser and local dev server, but I need to monitor traffic betwen dev server and the other server across the internet (on a non-standard ssl port). Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? RR ~| 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:344871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
I tried both and fiddler caught the traffic between my browser and CF, but not between CF and the server across the web hosting the web service. RR On Tue, May 24, 2011 at 1:46 PM, Brook Davies cft...@logiforms.com wrote: I believe fiddler needs to be on the machine that is making the request. That's always how I have used it. Typically with next to zero configuration required. Can you try: a) Install it on your machine making the request b) Open a browser on your dev server and run the request from there Brook -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: May-24-11 10:41 AM To: cf-talk Subject: Re: Debugging SOAP Yes I loaded it on the development web/cf9 server. And I set fiddler to the ssl port we are using. From another computer, I loaded up the site on the dev server and ran the cfinvoke to post up the soap to the server across the web. Fiddler saw nothing. I am sure I have it configured incorrectly. RR On Tue, May 24, 2011 at 1:10 PM, Brook Davies cft...@logiforms.com wrote: Did you install it on the dev server? Brook -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: May-24-11 10:01 AM To: cf-talk Subject: Re: Debugging SOAP Brook, would you share how to set fiddler up? I could not get it to show me traffic between by dev server and the remote server. (which is happening on a non-standard SSL port) On Tue, May 24, 2011 at 10:07 AM, Brook Davies cft...@logiforms.com wrote: I use Fiddler (http://www.fiddler2.com/Fiddler2/version.asp ) for debugging web service calls and it can dump the raw XML request/response and allows you to inspect HTTPS traffic... Brook -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: May-24-11 1:00 AM To: cf-talk Subject: Re: Debugging SOAP Hi Pete. I did try soapui, and it looked like it should do what I wanted, but I could not figure out how to make it work so that I could capture the outgoing soap and responses between my dev server and the remote server. On Mon, May 23, 2011 at 11:04 AM, Pete Freitag p...@foundeo.com wrote: SoapUI is a great tool for debugging soap: http://www.soapui.org/ If you give it a WSDL url it can generate stubs for testing the remote service and lets you see and edit all aspects of the soap request and response. -- Pete Freitag - Adobe Community Professional http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Sun, May 22, 2011 at 7:16 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello everyone. I appreciate the help you have given me recently. Now I have a new challenge, and I am sure some of you have faced it before. I have written an application that gets and puts data to a SOAP .asmx web service running on a windows server across the internet. I am using cfinvoke. All my gets are working fine. I am getting the expected data. However all my puts are failing, and the guy at the other end says my soap xml must be wrong. Hey, it might be, but I have not been able to come up with a way to see it. I did a google search and found Fiddler and Charles, and installed them both on the dev server which is running my application. But no luck. Each program seems to monitor the traffic between my browser and local dev server, but I need to monitor traffic betwen dev server and the other server across the internet (on a non-standard ssl port). Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? RR ~| 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:344873 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Anyone else have any ideas on how to monitor SOAP exchanges between my application server and the remote server hosting the service? Everything I have tried so far (fiddler, Charles, soapUI, wireshark) is just not working (Or I don't know enough to make it work). RR On Sun, May 22, 2011 at 7:16 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello everyone. I appreciate the help you have given me recently. Now I have a new challenge, and I am sure some of you have faced it before. I have written an application that gets and puts data to a SOAP .asmx web service running on a windows server across the internet. I am using cfinvoke. All my gets are working fine. I am getting the expected data. However all my puts are failing, and the guy at the other end says my soap xml must be wrong. Hey, it might be, but I have not been able to come up with a way to see it. I did a google search and found Fiddler and Charles, and installed them both on the dev server which is running my application. But no luck. Each program seems to monitor the traffic between my browser and local dev server, but I need to monitor traffic betwen dev server and the other server across the internet (on a non-standard ssl port). Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? RR ~| 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:344876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
No problem Brook. Thanks for the replies. :) It seems I must have an unusual need here. RR On Tue, May 24, 2011 at 2:25 PM, Brook Davies cft...@logiforms.com wrote: Sorry Robert, I haven't used it in that context.. ~| 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:344877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Yes, via cfinvoke. But I am getting errors back on all services when I am trying to post data. Getting data via cfinvoke is fine. Does your reply mean to say that there are problems with cfinvoke? I could build manually the xml but this is many services with many nodes. It would take a long time to do it. So I am really hoping that cfinvoke works out. On Tue, May 24, 2011 at 6:47 PM, Brook Davies cft...@logiforms.com wrote: How are you sending your request? Via cfinvoke? Or are you crafting the XML manually and using CFHTTP? You should know what you are sending and you should be able to dump the response no? If your using CFINVOKE to call the remote webservice, maybe you could instead try CFHTTP and then dump the response? Am I missing something? Brook -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: May-24-11 2:43 PM To: cf-talk Subject: Re: Debugging SOAP No problem Brook. Thanks for the replies. :) It seems I must have an unusual need here. RR On Tue, May 24, 2011 at 2:25 PM, Brook Davies cft...@logiforms.com wrote: Sorry Robert, I haven't used it in that context.. ~| 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:344881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Yes they are willing to do quick non-ssl tests. But even non-secure I have had no luck getting any of the recommended monitors/proxies to capture the soap exchange between a cf9 server and their server. They tell me there is nothing specific showing up in their logs. I really just want to see the xml going out and the response. That should tell me everything I need. It is really frustrating I have had so much trouble with this. RR On Tue, May 24, 2011 at 6:39 PM, Russ Michaels r...@michaels.me.uk wrote: can you speak to the people who run the web service and ask them if you can access it without ssl or ask them if have any kind of debugging/testing interface or perhaps simply give you access to logs.. Russ On Tue, May 24, 2011 at 10:43 PM, Robert Rhodes rrhode...@gmail.com wrote: No problem Brook. Thanks for the replies. :) It seems I must have an unusual need here. RR On Tue, May 24, 2011 at 2:25 PM, Brook Davies cft...@logiforms.com wrote: Sorry Robert, I haven't used it in that context.. ~| 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:344882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
Nathan, thanks for the reply. I don't need to monitor between my computer and the application server. I need to monitor between the application server and a remote server across the web that hosts the web service. I have no control over the remote server and the folks that do are only marginally helpful. Worse, they are taking the position that this is a Coldfusion problem. All very frustrating. I did try Charles and had no luck, but will take a look again. On Tue, May 24, 2011 at 10:37 PM, Nathan Mische nmis...@gmail.com wrote: You can use a proxy to do this. I use Charles. For example, assume your local computer is running Charles and has an IP address of 192.168.1.1 and the development server can reach your local computer at that address. In your cfinvoke tag, set the proxyServer attribute to 192.168.1.1 and the proxyPort to , or whatever port Charles is running on. (The default is but you can find this info in Charles under Proxy Settings...) Run your application and watch the traffic. If you are making SSL requests you will need to to configure Charles. See http://www.charlesproxy.com/documentation/proxying/ssl-proxying/. You will also need to add the Charles CA Certificate to ColdFusion's root certificate trust store. For more info on this see the Java Applications section here: http://www.charlesproxy.com/documentation/using-charles/ssl-certificates/and http://kb2.adobe.com/cps/400/kb400977.html. --Nathan On Tue, May 24, 2011 at 9:41 PM, Robert Rhodes rrhode...@gmail.com wrote: Yes they are willing to do quick non-ssl tests. But even non-secure I have had no luck getting any of the recommended monitors/proxies to capture the soap exchange between a cf9 server and their server. They tell me there is nothing specific showing up in their logs. I really just want to see the xml going out and the response. That should tell me everything I need. It is really frustrating I have had so much trouble with this. RR On Tue, May 24, 2011 at 6:39 PM, Russ Michaels r...@michaels.me.uk wrote: can you speak to the people who run the web service and ask them if you can access it without ssl or ask them if have any kind of debugging/testing interface or perhaps simply give you access to logs.. Russ On Tue, May 24, 2011 at 10:43 PM, Robert Rhodes rrhode...@gmail.com wrote: No problem Brook. Thanks for the replies. :) It seems I must have an unusual need here. RR On Tue, May 24, 2011 at 2:25 PM, Brook Davies cft...@logiforms.com wrote: Sorry Robert, I haven't used it in that context.. ~| 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:344884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Debugging SOAP
Hello everyone. I appreciate the help you have given me recently. Now I have a new challenge, and I am sure some of you have faced it before. I have written an application that gets and puts data to a SOAP .asmx web service running on a windows server across the internet. I am using cfinvoke. All my gets are working fine. I am getting the expected data. However all my puts are failing, and the guy at the other end says my soap xml must be wrong. Hey, it might be, but I have not been able to come up with a way to see it. I did a google search and found Fiddler and Charles, and installed them both on the dev server which is running my application. But no luck. Each program seems to monitor the traffic between my browser and local dev server, but I need to monitor traffic betwen dev server and the other server across the internet (on a non-standard ssl port). Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? RR ~| 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:344825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error)
Hello Russ. I see the handler mappings as the site lever. There are 5 entries. Are you saying adding those entries at the root will prevemt hte problem I described, where any change in webroot or adding a site takes down all sites? RR On Fri, May 13, 2011 at 6:04 AM, Russ Michaels r...@michaels.me.uk wrote: you just go into the handler mappings at root or site level and add the handler yourself rather than let the web config tool do it. the advantage is that you canuse the same connector for all site, whereas the config tool creates a new connector for each site, which is pointless on a standard install. On Fri, May 13, 2011 at 6:08 AM, Robert Rhodes rrhode...@gmail.com wrote: Hello Russ. How would I do it manually? Are there instructions somewhere? It sure feels like that's the problem (connectors not being installed at the root level). There just has to be a decent workaround for this problem. On Thu, May 12, 2011 at 2:08 AM, Russ Michaels r...@michaels.me.uk wrote: I haven't actually tested it yet as we are still running IIS6, however if the problem is that the web config tool is not applying the connectors correctly at root level then you can try doing this manually and see if that resolves the problem. On Thu, May 12, 2011 at 6:38 AM, Andrew Scott andr...@andyscott.id.au wrote: Yes, this is a known issue. What happens is that when you do it in this manner, you are telling ColdFusion to run in IIS7 mode. The connectors don't install to all the websites when you do this, what you need to do is add a connector to each site individually. This blog might shed some more insight. http://www.andyscott.id.au/2011/3/29/Things-to-know-when-installing-ColdFusi on-9-then-updating-to-901 Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Thursday, 12 May 2011 4:30 AM To: cf-talk Subject: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error) Ok, I downloaded cf 9 and installed it on WIn2K8 R2 Web Server Edition.as a standalone installation. I then ran the 9.01 updater and he 9.01 hotfix. Finally, I ran the webserver config tool and selected IIS all sites. Now when I load a cf template I get a 404.3 error and this message: HTTP Error 404.3 - Not Found The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map. I am sure I did something wrong. Any suggestions RR ~| 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:344509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error)
Andrew, thanks. That is exactly what I was experiencinging. I am quite surprised that this problem has not been sorted out by Adobe. I really like CF, but this seems a bit lame. I briefly tried installing the connector on individual sites, but it didn't seem to work (was still getting 404.3 errors). Since I was short on time, I set the connector for all sites and made myself a big not tom remind me not to touch anything. It's crazy I had to do that. Adobe needs to get this sorted out. RR On Thu, May 12, 2011 at 1:38 AM, Andrew Scott andr...@andyscott.id.auwrote: Yes, this is a known issue. What happens is that when you do it in this manner, you are telling ColdFusion to run in IIS7 mode. The connectors don't install to all the websites when you do this, what you need to do is add a connector to each site individually. This blog might shed some more insight. http://www.andyscott.id.au/2011/3/29/Things-to-know-when-installing-ColdFusi on-9-then-updating-to-901 Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Thursday, 12 May 2011 4:30 AM To: cf-talk Subject: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error) Ok, I downloaded cf 9 and installed it on WIn2K8 R2 Web Server Edition.as a standalone installation. I then ran the 9.01 updater and he 9.01 hotfix. Finally, I ran the webserver config tool and selected IIS all sites. Now when I load a cf template I get a 404.3 error and this message: HTTP Error 404.3 - Not Found The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map. I am sure I did something wrong. Any suggestions RR ~| 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:344483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error)
Hello Russ. How would I do it manually? Are there instructions somewhere? It sure feels like that's the problem (connectors not being installed at the root level). There just has to be a decent workaround for this problem. On Thu, May 12, 2011 at 2:08 AM, Russ Michaels r...@michaels.me.uk wrote: I haven't actually tested it yet as we are still running IIS6, however if the problem is that the web config tool is not applying the connectors correctly at root level then you can try doing this manually and see if that resolves the problem. On Thu, May 12, 2011 at 6:38 AM, Andrew Scott andr...@andyscott.id.au wrote: Yes, this is a known issue. What happens is that when you do it in this manner, you are telling ColdFusion to run in IIS7 mode. The connectors don't install to all the websites when you do this, what you need to do is add a connector to each site individually. This blog might shed some more insight. http://www.andyscott.id.au/2011/3/29/Things-to-know-when-installing-ColdFusi on-9-then-updating-to-901 Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Thursday, 12 May 2011 4:30 AM To: cf-talk Subject: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error) Ok, I downloaded cf 9 and installed it on WIn2K8 R2 Web Server Edition.as a standalone installation. I then ran the 9.01 updater and he 9.01 hotfix. Finally, I ran the webserver config tool and selected IIS all sites. Now when I load a cf template I get a 404.3 error and this message: HTTP Error 404.3 - Not Found The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map. I am sure I did something wrong. Any suggestions RR ~| 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:344484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error)
Hey Kym. So are you saying that you don't have to remove and reinstall the connector every time you add a site (or change a directory)? What's the down-side of running with the ii6 extensions installed? If there is not a big performance hit, it might make sense to do so. On Thu, May 12, 2011 at 2:21 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: Just to add to the last two, we originally installed with CF9 and so needed IIS6 compatibility turned on. When we upgraded to 9.0.1 we left that all on and have had no issues. I wonder if turning that on (add it in like the ASP.Net via Roles/Features) might help after another pass with the webconfig tool. On 12/05/2011 16:08, Russ Michaels wrote: I haven't actually tested it yet as we are still running IIS6, however if the problem is that the web config tool is not applying the connectors correctly at root level then you can try doing this manually and see if that resolves the problem. On Thu, May 12, 2011 at 6:38 AM, Andrew Scottandr...@andyscott.id.au wrote: Yes, this is a known issue. What happens is that when you do it in this manner, you are telling ColdFusion to run in IIS7 mode. The connectors don't install to all the websites when you do this, what you need to do is add a connector to each site individually. This blog might shed some more insight. http://www.andyscott.id.au/2011/3/29/Things-to-know-when-installing-ColdFusi on-9-then-updating-to-901 Regards, Andrew Scott http://www.andyscott.id.au/ -- Yours, Kym Kovan mbcomms.net.au ~| 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:344485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Well, it wasn't as easy as I had hoped. I installed cf 9 as a standalone installation. I updated to 9.01 and applied the 9.01 hotfix. I then ran the web Server Configuration Tool, and got an error: ASP.Net Window's feature is not installed. They are required to configure IIS7 Connector. I am installing this on Wn2K8 R2 Web Server Edition as I mentioned above. So now what? :) On Tue, May 10, 2011 at 6:34 PM, Robert Rhodes rrhode...@gmail.com wrote: Ok, thanks. I haven't installed cf9 before and I didn't want to find out when I got there that I didn't know what to do. Thanks again. On Tue, May 10, 2011 at 12:23 PM, Russ Michaels r...@michaels.me.ukwrote: Start - program files - adobe - coldfusion 9 it is self explanitory On Tue, May 10, 2011 at 5:07 PM, Robert Rhodes rrhode...@gmail.com wrote: Sorry about the typos: On Tue, May 10, 2011 at 12:06 PM, Robert Rhodes rrhode...@gmail.com wrote: Sorry. Where is the the web config tool? And is it self-explanatory, or is there documentation somewhere? On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.uk wrote: choose the standard server config, but install it using the built in web server and do not configure IIS. then update to 9.0.1 then use the web config tool to enable CF on IIS7 you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your IIS website if you wish to run it from there. On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com wrote: Dave pardon the lame question, but which install option do I pick if not server configuration? And then how do I hook up to IIS after the fact? RR On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote: Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. You will have to update CF to 9.0.1 before hooking it to IIS, if you want to avoid installing the IIS 6 compatibility layer. Dave Watts, CTO, Fig Leaf Software 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 onsit ~| 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:344436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
I wanted to add that I did not install the IIS6 compatibility extensions. So that isn't the problem. On Wed, May 11, 2011 at 3:02 AM, Robert Rhodes rrhode...@gmail.com wrote: Well, it wasn't as easy as I had hoped. I installed cf 9 as a standalone installation. I updated to 9.01 and applied the 9.01 hotfix. I then ran the web Server Configuration Tool, and got an error: ASP.Net Window's feature is not installed. They are required to configure IIS7 Connector. I am installing this on Wn2K8 R2 Web Server Edition as I mentioned above. So now what? :) On Tue, May 10, 2011 at 6:34 PM, Robert Rhodes rrhode...@gmail.comwrote: Ok, thanks. I haven't installed cf9 before and I didn't want to find out when I got there that I didn't know what to do. Thanks again. On Tue, May 10, 2011 at 12:23 PM, Russ Michaels r...@michaels.me.ukwrote: Start - program files - adobe - coldfusion 9 it is self explanitory On Tue, May 10, 2011 at 5:07 PM, Robert Rhodes rrhode...@gmail.com wrote: Sorry about the typos: On Tue, May 10, 2011 at 12:06 PM, Robert Rhodes rrhode...@gmail.com wrote: Sorry. Where is the the web config tool? And is it self-explanatory, or is there documentation somewhere? On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.uk wrote: choose the standard server config, but install it using the built in web server and do not configure IIS. then update to 9.0.1 then use the web config tool to enable CF on IIS7 you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your IIS website if you wish to run it from there. On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com wrote: Dave pardon the lame question, but which install option do I pick if not server configuration? And then how do I hook up to IIS after the fact? RR On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote: Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. You will have to update CF to 9.0.1 before hooking it to IIS, if you want to avoid installing the IIS 6 compatibility layer. Dave Watts, CTO, Fig Leaf Software 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 onsit ~| 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:344437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
It was a pain to find, but thatworked . Thanks. I really don't like the new IIS 7 interface... On Wed, May 11, 2011 at 3:45 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 11/05/2011 17:02, Robert Rhodes wrote: Well, it wasn't as easy as I had hoped. I installed cf 9 as a standalone installation. I updated to 9.01 and applied the 9.01 hotfix. I then ran the web Server Configuration Tool, and got an error: ASP.Net Window's feature is not installed. They are required to configure IIS7 Connector. I am installing this on Wn2K8 R2 Web Server Edition as I mentioned above. So now what? :) In the Server Manager home page go to the Roles section and add the needed service. By default only the minimum is installed so you need to add in ASP.Net, etc. -- Yours, Kym Kovan mbcomms.net.au ~| 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:38 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Couple of quick IIS 7 questions
Sorry for the off-topic questions, but everyone here is so helpful, and if you saw my posts, you know that I am under the gun. 1) How do I remove Server: Microsoft-IIS/7.5 from the response headers? 2) Have any of you ever user IIS7 caching for a CF site? I am assuming it will be applicable only for images, but this site has a lot of them. Which mode do I use? Kernel-mode or User-mode? Thanks for all your help. You folks are keeping me sane. ~| 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:344450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Ack! CF9 pages not serving pages on IIS7.5 (404.3 error)
Ok, I downloaded cf 9 and installed it on WIn2K8 R2 Web Server Edition.as a standalone installation. I then ran the 9.01 updater and he 9.01 hotfix. Finally, I ran the webserver config tool and selected IIS all sites. Now when I load a cf template I get a 404.3 error and this message: HTTP Error 404.3 - Not Found The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map. I am sure I did something wrong. Any suggestions RR ~| 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:344463 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error)
Well that kinda helps, but only for a time. After I run the web service configuration tool and select ALL for IIS Web Site, and check configure web server for Coldfusion 9 applications, CF will process pages fine... but only until I change the webroot of an existing site or add anther site. Then, all sites stop serving and give that 404.3 error until I remove the CF web config and reinstall it.Then things work fine until the next time I change a directory or add a site, when it will die again. This certainly was not the case in IIS6. Anyone have any suggestions on how to set up CF9 with IIS7.5 so that is does not exhibit this crazy behavior? I can't take every site down each time I make a change in IIS. RR On Wed, May 11, 2011 at 3:13 PM, Jason Durham jqdur...@gmail.com wrote: Run wsconfig again (add/remove sites) On May 11, 2011 2:00 PM, Robert Rhodes rrhode...@gmail.com wrote: Ok, I downloaded cf 9 and installed it on WIn2K8 R2 Web Server Edition.as a standalone installation. I then ran the 9.01 updater and he 9.01 hotfix. Finally, I ran the webserver config tool and selected IIS all sites. Now when I load a cf template I get a 404.3 error and this message: HTTP Error 404.3 - Not Found The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map. I am sure I did something wrong. Any suggestions RR ~| 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:344468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ack! CF9 pages not serving pages on IIS7.5 (404.3 error)
Dave, thanks for the reply. That might be the only solution, but isn't the behaviour I describe odd? CF9 didn't behave this way on iis6. On Wed, May 11, 2011 at 10:11 PM, Dave Watts dwa...@figleaf.com wrote: Anyone have any suggestions on how to set up CF9 with IIS7.5 so that is does not exhibit this crazy behavior? I can't take every site down each time I make a change in IIS. You can configure each IIS virtual server individually with wsconfig. Dave Watts, CTO, Fig Leaf Software 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:344472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Sorry. Where is the the web config tool? ANd is it welf-explanatory, or is there documentation somewhere? On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.uk wrote: choose the standard server config, but install it using the built in web server and do not configure IIS. then update to 9.0.1 then use the web config tool to enable CF on IIS7 you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your IIS website if you wish to run it from there. On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com wrote: Dave pardon the lame question, but which install option do I pick if not server configuration? And then how do I hook up to IIS after the fact? RR On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote: Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. You will have to update CF to 9.0.1 before hooking it to IIS, if you want to avoid installing the IIS 6 compatibility layer. Dave Watts, CTO, Fig Leaf Software 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 onsit ~| 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:344408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Sorry about the typos: On Tue, May 10, 2011 at 12:06 PM, Robert Rhodes rrhode...@gmail.com wrote: Sorry. Where is the the web config tool? And is it self-explanatory, or is there documentation somewhere? On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.ukwrote: choose the standard server config, but install it using the built in web server and do not configure IIS. then update to 9.0.1 then use the web config tool to enable CF on IIS7 you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your IIS website if you wish to run it from there. On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com wrote: Dave pardon the lame question, but which install option do I pick if not server configuration? And then how do I hook up to IIS after the fact? RR On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote: Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. You will have to update CF to 9.0.1 before hooking it to IIS, if you want to avoid installing the IIS 6 compatibility layer. Dave Watts, CTO, Fig Leaf Software 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 onsit ~| 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:344409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Ok, thanks. I haven't installed cf9 before and I didn't want to find out when I got there that I didn't know what to do. Thanks again. On Tue, May 10, 2011 at 12:23 PM, Russ Michaels r...@michaels.me.uk wrote: Start - program files - adobe - coldfusion 9 it is self explanitory On Tue, May 10, 2011 at 5:07 PM, Robert Rhodes rrhode...@gmail.com wrote: Sorry about the typos: On Tue, May 10, 2011 at 12:06 PM, Robert Rhodes rrhode...@gmail.com wrote: Sorry. Where is the the web config tool? And is it self-explanatory, or is there documentation somewhere? On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.uk wrote: choose the standard server config, but install it using the built in web server and do not configure IIS. then update to 9.0.1 then use the web config tool to enable CF on IIS7 you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your IIS website if you wish to run it from there. On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com wrote: Dave pardon the lame question, but which install option do I pick if not server configuration? And then how do I hook up to IIS after the fact? RR On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote: Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. You will have to update CF to 9.0.1 before hooking it to IIS, if you want to avoid installing the IIS 6 compatibility layer. Dave Watts, CTO, Fig Leaf Software 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 onsit ~| 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:344415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Hello again. Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. RR ~| 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:344376 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
I do use MSSQL, but never on server that is web-facing. So, that will not be a problem. On Mon, May 9, 2011 at 8:00 PM, Russ Michaels r...@michaels.me.uk wrote: yes it will run fine. The limitations of web edition are windows related, you cannot installed MSSQL for example, but it doesn;t stop you installing any 3rd party software. On Tue, May 10, 2011 at 12:55 AM, Robert Rhodes rrhode...@gmail.com wrote: Hello again. Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. RR ~| 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:344387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?
Dave pardon the lame question, but which install option do I pick if not server configuration? And then how do I hook up to IIS after the fact? RR On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote: Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. You will have to update CF to 9.0.1 before hooking it to IIS, if you want to avoid installing the IIS 6 compatibility layer. Dave Watts, CTO, Fig Leaf Software 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 onsit ~| 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:344390 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help! Too much tracffic and too little time!
I talked them into a few more days. Currently we are aiming for Friday. Phew! On Mon, May 9, 2011 at 10:26 PM, Brian Polackoff bpolack...@gmx.com wrote: So how did your first day go? Any load issues with the setup the good folks on this recommended? Brian Polackoff On May 8, 2011, at 9:46 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 8/05/2011 10:58 PM, Robert Rhodes wrote: I installed Win2K8 on one of the servers last night, and discovered there is actually 6GB of memory in them. I had forgotten that I had to install the RAM sticks in threes on these servers. Just sitting there idling, it's got 340mb cached, 5451mb available, and 5133mb free. 6GB, that's a nice number. Set the JVM max to 3GB, max perm to 512 and let it take traffic. If all is good the OS will bump up to about 1GB and the cache the same leaving a smidge of fully free mem. If you have a server monitor of some form you can then balance as needed. -- Yours, Kym Kovan mbcomms.net.au ~| 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:344391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help! Too much tracffic and too little time!
I installed Win2K8 on one of the servers last night, and discovered there is actually 6GB of memory in them. I had forgotten that I had to install the RAM sticks in threes on these servers. Just sitting there idling, it's got 340mb cached, 5451mb available, and 5133mb free. On Sat, May 7, 2011 at 10:12 PM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 8/05/2011 9:29 AM, Robert Rhodes wrote: It looks like I will be x64 on Win2K8R2 for two of these boxes which will have only 4gb on memory, at least for now. With that in mind... can I up my jvm settings a bit? In a prod environment the OS will run about 1GB mem usage and 2K8 has this extra mem allocation caching trick which is really useful on hard working machines but you cannot allow much for that with only 4GB RAM. I'd say set the JVM for 2.5GB and 512 Perm and see how it flows (Look at mem usage in the Resource Monitor which you find in the Task Manager, if there is just a tad of Really Free Mem then you are fine.) -- Yours, Kym Kovan mbcomms.net.au ~| 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:344347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help! Too much tracffic and too little time!
uh flak below should read folks. On Sat, May 7, 2011 at 9:43 AM, Robert Rhodes rrhode...@gmail.com wrote: Well you folks certainly have me thinking. I could set up one of the machine as a Win2K8 server and see how it does. If it's humming along just fine, then I can steer more traffic to it. With the speed increase you flak are talking about here, do you think a million page loads per day can be handled by one Win2K8 server? (with a backup in place of course) I understand the basics about how to set up a site in 2K8, but what about lockdown? Can anyone point me to a guide somewhere? The servers are behind a firewall with only port 443 and port 80 open. Nothing else. On Sat, May 7, 2011 at 1:24 AM, Andrew Scott andr...@andyscott.id.auwrote: Yeah it does take a little getting used to the new UI changes, but the functionality and operations are still the same. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Kym Kovan [mailto:dev-li...@mbcomms.net.au] Sent: Saturday, 7 May 2011 1:46 PM To: cf-talk Subject: Re: Help! Too much tracffic and too little time! We found 2K8 R2 so good that we are now trashing our oldest machines and moving to 2K8 wherever possible, the advantage is so great and it is not quirky, it is much easier than 2K3 once you get used to the new IIS, etc. I'd even stick my head out and say 2K8 R2 is a good operating system... ~| 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:344330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help! Too much tracffic and too little time!
Well you folks certainly have me thinking. I could set up one of the machine as a Win2K8 server and see how it does. If it's humming along just fine, then I can steer more traffic to it. With the speed increase you flak are talking about here, do you think a million page loads per day can be handled by one Win2K8 server? (with a backup in place of course) I understand the basics about how to set up a site in 2K8, but what about lockdown? Can anyone point me to a guide somewhere? The servers are behind a firewall with only port 443 and port 80 open. Nothing else. On Sat, May 7, 2011 at 1:24 AM, Andrew Scott andr...@andyscott.id.auwrote: Yeah it does take a little getting used to the new UI changes, but the functionality and operations are still the same. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Kym Kovan [mailto:dev-li...@mbcomms.net.au] Sent: Saturday, 7 May 2011 1:46 PM To: cf-talk Subject: Re: Help! Too much tracffic and too little time! We found 2K8 R2 so good that we are now trashing our oldest machines and moving to 2K8 wherever possible, the advantage is so great and it is not quirky, it is much easier than 2K3 once you get used to the new IIS, etc. I'd even stick my head out and say 2K8 R2 is a good operating system... ~| 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:344331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help! Too much tracffic and too little time!
Thanks. I'll look into that. Being a Windows guy, I am not sure how well Squid and I would get along. :) On Sat, May 7, 2011 at 3:23 PM, Cameron Childress camer...@gmail.comwrote: In addition to other comments, it might be worth spending a minute reading up on Squid: http://www.squid-cache.org/ Caching some or all of the site could mean you can do the entire thing with just 2 CF machines. In my experience, the bottleneck for Squid is not the OS or Squid itself, but the capacity of the network cards in the machine. It can handle ALOT of traffic. The learning curve required to implement this may or may not be within your time window. -Cameron On Fri, May 6, 2011 at 9:57 PM, Rob Rhodes rrhode...@gmail.com wrote: Hello. I have been a lurker on this board for a while, and never thought I was qualified enough to offer opinions. Well, that has not changed. But now I could really use some advice on how to gear up quickly to handle a ton of traffic on a cf9 site. I can't really go into the details, but I have just inherited a cf9/SQL server site that gets well over a million page views per day. It was previously running on multiple servers using shared array. It's an impossible task, but I have to have this up and running this weekend. So, I don't have any time or money for complex solutions. I just need to this all to stay up long enough to figure out a proper plan. Until then, here is my working plan. Please tell me what you think. I have 4 cf9 standard licences, and four servers running win2k3 x86 (fairly fast processors and 4gb ram each). I have a fifth win2k3 server x64 running SQL Server 2005. These servetrs are recent installs and do not have any other sites on them. My plan is to load the site on all four servers, all pointing to the same database server (it appears much of the queries in the site are cached) I would then set up round-robin DNS to do the poor-mans load distribution. Most importantly I am hoping some of the gurus here might have some jvm tuning suggestions to help handle the load. Ok let me have it. Is there any hope, or am I just hopelessly screwed? ~| 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:344338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm