Re: Ruby Gems
Can Ruby Gems be installed without conflict along side of Coldfusion 8 on a Windows 2003 Server? thanks! ~| 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:359458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ruby Gems
Hi Dave, All we want to use Ruby for is to compile SASS into CSS for use with Zurb Foundation pages used on our Coldfusion websites. Can this be done using the same IIS? If not, what is the problem that occurs? Thanks. ~| 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:359459 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Ruby Gems
Can Ruby Gems be installed without conflict along side of Coldfusion 8 on a Windows 2003 Server? thanks! ~| 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:359455 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 and Solr
We're going to move to CF10 later this year but would like to improve our CF8 Verity search engine. Specifically, we've not been successful in using suggestions based on other spellings of words in Verity. For example if someone types in Steven Smith but it's really Stephen Smith, no results are returned. Suggestions are more often than not relevant. There are also a whole of slew of other problems. Are people happy the Solr integration in CF10? Would it require a significant amount of time to switch to Solr if we want to use with CF8? What are the caveats? Thanks! ~| 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:359024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Slow running request
We occasionally have a slow running request for no apparent reason. We have Fusion-Reactor and can see that there is no heavy traffic on the server. The same query run at a different time, runs just fine. The SQL db queries (as shown by F-R) are running very fast. I/O is also fine at the time this happens as can be seen in the performance monitor. How should we go about finding out the cause of these slow running requests? Thanks! Rick ~| 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:356227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Amazon Affiliates
Is there a CF plugin or CFC that will automatically sense which country a user is coming from and then use the appropriate affiliate code for that particular country's closest Amazon website for ordering, assuming the item's order number is the same? Thanks. ~| 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:356141 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Throttling Bot Traffic
We're caching parts of some key pages, but unfortunately some of the data has to be live. When the bots start hitting us, our CF8 server can't keep up and we get long running threads. Is there an easy way to throttle url page requests? Perhaps throw up a note say that the server is busy, please retry in a bit. Thanks! ~| 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:356030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion 10 in the Cloud
Does anyone have any experience with using Media3 for CF 10 in the cloud? If so, would love to get some feedback about their service from someone who actually uses them. Thanks! Rick ~| 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:355866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 8 erratic behavior
Thanks. But no, the db queries are fast. ~| 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:355843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion 8 erratic behavior
How can I determine what causes a coldfusion 8 page to be fast loading sometimes and other times, extremely slow? The server seems to have enough memory and the traffic is not high. The db query part of the page is fast according to Fusion Reactor. I don't see any leads in the Fusion Reactor Request Detail. What else should I check? Thanks in advance. Rick ~| 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:355836 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion 10 on Amazon?
Is anyone using Amazon's Coldfusion 10 AMI? If so, how are you liking it? Can I load balance between instances within the one AMI? Thanks! Rick ~| 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:355668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion 10 on Amazon?
We have 4 different websites running on CF8 Enterprise. Each website has 2 instances that are load balanced. Thus there are 8 instances on the CF8 Enterprise dedicated server which has 16 gb of memory. ~| 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:355701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Wikipedia API Parser
They have a pretty simple API - http://www.mediawiki. org/wiki/API:Main_page . Here is a quick example: cfset wURL = http://en.wikipedia.org/w/api. php?format=json action=querytitles=Adobe%20ColdFusionprop=revisionsrvprop=content cfhttp url=#wURL# cfdump var=#cfhttp.fileContent# On Sun, Dec 16, 2012 at 10:49 AM, Richard Steele r...@photoeye.com wrote: I want to pull pages for individuals from Wikipedia and insert them into a website. Has someone come up with a way to do this with Coldfusion? Thanks! ~| 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:353508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Wikipedia API Parser
Thanks Ray. Has someone come up with a parser of the content that formats it properly? ~| 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:353509 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Wikipedia API Parser
I want to pull pages for individuals from Wikipedia and insert them into a website. Has someone come up with a way to do this with Coldfusion? Thanks! ~| 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:353493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instance hogs cpu
Client variables being stored in registry? Paul On 03/10/2012, at 8:32 AM, Richard Steele r...@photoeye.com wrote: We have a problem with one of our CF8 Enterprise instances. Almost daily, it hogs the entire cpu of the server and the service has to be restarted. Over 2.5 gb of memory is dedicated to this instance. It reaches that ceiling within several hours of use. Perhaps garbage collection can't keep up? Is there a way to limit the cpu resources given to an instance? How do we troubleshoot what might be causing this? Thanks! Rick ~| 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:352850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instance hogs cpu
Client variables being stored in registry? No, both instances are stored in one database. ~| 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:352851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 Instance hogs cpu
We have a problem with one of our CF8 Enterprise instances. Almost daily, it hogs the entire cpu of the server and the service has to be restarted. Over 2.5 gb of memory is dedicated to this instance. It reaches that ceiling within several hours of use. Perhaps garbage collection can't keep up? Is there a way to limit the cpu resources given to an instance? How do we troubleshoot what might be causing this? Thanks! Rick ~| 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:352819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instance hogs cpu
Are you logging long-running requests? How do we log these? Any requests hanging? All requests start to hang at 97% cpu usage. Can you correlate the memory/cpu spike with site traffic or spiders? We think it may be spider related. Like Wil said, it's probably the code in a certain request / page that's using more memory/cycles than it needs to. Our code has been in place for years. You may need something like FusionReactor to see what's causing issues. We have F-R but can't get to it when this occurs as the 97% cpu usage freezes everthing. Is there a way to limit cpu usage for a particular instance? Thanks. Rick ~| 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:352825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instance hogs cpu
Perhaps code is the issue. Perhaps a custom tag is the issue. Details are needed before anyone can give any sort of reasonable answer. It's always on the same instance of a multi-instance, load-balanced cf8 server. How much traffic is the site getting? requests/second? We get about 6,000 visitors a day. Not sure about the request/second. What is the code processing? Same code that's been in place for many years. What is the code accessing? SQL Server 2005 Is the database responding properly? Yes Can we isolate / limit cpu usage for this instance? Thanks. Rick ~| 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:352827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instance hogs cpu
look at the request activity graph and activity logs to see what was running at the time the issue occurred. Again, F-R can't be viewed during this time as 97% cpu hog prevents anything from working. Have you setup crash protection to kill long running requests? We had set this up before, but did not have good results. More often than not, it wouldn't crash the request, and would just keep it in limbo. ~| 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:352829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Controlling Spiders
Thanks to everyone for their thoughts on this. Very good advise and ideas here! R ~| 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:351119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Controlling Spiders
Today we had Google + 3 or 4 other spiders hammering our multi-instance server at the same time. Is there a way to control these bots to prevent them from submitting request after request? How do most high traffic servers handle this? Thanks! ~| 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:351030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Bizarre Behavior
We offer a template-based, self-administered solution for hosting websites and have a CF8 Enterprise server with two load-balanced. Yesterday, for the first time in 6 years of offering hosting services, we had a bizarre user login problem event. A user logged into to administer their hosted site using their normal credentials and another user's administration came up!! I then tried logging into their administrative backend and the same thing happened to me. I then logged out and tried yet another user's credentials and that worked fine, but when I logged out of their administrative backend I was taken to that other user's site's administration (the one that was the wrong one in the first example) instead of to the hosting site's home page. I thought we might have been hacked, but no login files' date times had changed. The application.cfm had not changed either. I restarted both instances of CF server and all is back to normal. I'm completely baffeled and concerned. What in the world could cause this that a CF service restart would fix? Thanks in advance. ~| 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:350343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Detecting changes in db in order to delete cached pages
We host websites using a content management system we developed in CF8 and would like to detect whenever a user changes anything in their website template. If changed, code would run that would delete their cached pages. Changes are recorded in a SQL Server db. There are 12 different tables that are used. Here's what we've come up with. 1. Insert a date time stamp when a change is made, and then query each table to see if there are any changes. 2. Delete the cached pages any time there is an insert or update. (there are a ton of these). Is there a simpler way to detect the change in order to fire the deletion of the cached pages? Thanks in advance. ~| 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:349267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
imageGeEXIFMetaData
We can't get imageGeEXIFMetaData (or its counterpart imageGeIPTCMetaData) to work properly in CF8. ImageGeEXIFMetaData does return jpg metadata if the file is NOT Saved for Web in Photoshop CS4. However, if the file is Saved for Web, no metadata is returned, even if METADATA is set to ALL in the Save for Web dialog box. The same Saved for Web jpg clearly has the meta data included as http://regex.info/exif.cgi shows it all. This is CF8 with all updates applied including the hotfix that solved some cfimage problems. Any ideas as to what is going on here would be greatly appreciated. Thanks in advance. Richard ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFImage Woes
We've been getting these Missing Huffman code table entry error on write calls with cfimage for certain jpgs: javax.imageio.IIOException: Missing Huffman code table entry at com.sun.imageio.plugins.jpeg.JPEGImageWriter.writeImage(Native Method) at com.sun.imageio.plugins.jpeg.JPEGImageWriter.writeOnThread(JPEGImageWriter.java:1034) at com.sun.imageio.plugins.jpeg.JPEGImageWriter.write(JPEGImageWriter.java:339) Found a lot of noise about this from 2008 (see http://forums.adobe.com/message/848767), but it seems the root cause of those issues was solved by a hotfix. We're running CF8 cumulative update 4, so we should be in the clear there. The worst part is that on these occasions they seem to be writing corrupt (empty?) jpg files which then choke the system down the line. Has anybody had experience with this issue? We're hoping to fix it directly rather than rewrite our cfimage routines to use java I/O. Richard ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFImage Woes
Thank you, while we've kept up with the cumulative updates, this hot fix was evidently not part of those updates. We'll get that done and report back if this is still a problem. Richard ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instances hanging every 3-4 days or so.
Ok for all of those following this thread, we resolved our hanging instance problem! It was an Efflare imageCR3 service (an image tag alternative to cfimage), that was getting hung. As a result, it caused any pages that called the tag to hang. Restarting that service solved the problem. Why it hangs, I have no idea, but we are now restarting that service every 4 hours (it takes 5 secs). We will retire that tag at some point, but for now hopefully the restart will keep it fresh and prevent the hangups. That makes total sense as to why we had to reboot the server to prevent the instances from hanging (restarting the two instances didn't help, nor restarting IIS). Made sense that all other domain instances were working well as they don't relay on the tag. Had we known that the Efflare tag was the culprit, we could have prevented all those server reboots. Thanks for everyone's help. I learned a lot! ~| 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:347668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instances hanging every 3-4 days or so.
Yes, we use Fusion Reactor and can view the vitals including which threads are hung (essentially all threads). Other vitals don't point to anything suspect. However today, we had a different problem. Only one instance hung and it was a CPU problem. The entire server memory was being used by the one instance. Restarting the instance DID solve the problem, unlike the issue last night, where rebooting did not help. We had to restart the server. Today we made sure that all CFC and functions had properly scoped vars (they didn't before). Several of these cfcs were called each time a page loaded (often!). So we're keeping our fingers crossed that this was the problem. (Thanks Justin, we used varscoper to find them). Still would love to be able to clear those network sockets without rebooting the server after these events. Rick ~| 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:347612 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instances hanging every 3-4 days or so.
Right, couldn't even get there as the mouse was not responding since the cpu was at 100%. Was only barely able to restart the service. ~| 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:347614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Instances hanging every 3-4 days or so.
Thanks for the info. Java Garbage Collection seems to be working fine as always. Rebooting the services doesn't free the network sockets and it continues to be a problem until the server is rebooted. 1. Use Java Garbage Collection Modify the JVM.CONFIG file and and append the following line to code to force GC every 10 minutes. -Dsun.rmi.dgc.client.gcInterval=60 -Dsun.rmi.dgc.server. gcInterval=60 2. Use Jrun Monitor This is a DotNet application developed by me to handle such situations. You can find more information on this at http://ketanjetty. com/coldfusion/monitor/jrun-monitor/ One of the reasons why this happens is discussed at http://ketanjetty. com/coldfusion/useful-code/avoid-coldfusion-hang. Should you need more information, please let me know. I am interested in knowing the cause for your server hangs. Thanks, Ketan Jetty http://KetanJetty.com kjetty@gmail. com ~| 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:347615 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 Instances hanging every 3-4 days or so.
We're starting to get CF8 Enterprise hung instances every 3=4 days or so at different times. For no apparent reason, requests don't complete on two load balanced instances. Restarting both instances does not help. The instances become hung again very quickly. Restarting IIS for these instances does not help either. Our other instances for different domains are not affected so I don't think the SQL Server db is locked. Once we reboot the server, all is well. Perhaps the rebooting clears the network sockets for those instances? I'm out of my experience range here, so not sure what is going on. At first I thought we were being hammered by out of control spiders, but tonight's log analysis doesn't show spider activity during during the time the instances hang. 1. Can we clear the network sockets without rebooting the server so that we don't take down the hundreds of websites we host on other instances for the 5 minutes while the server reboots? 2. What's the best way to troubleshoot this? The IIS logs for these two instances do not shed any light. CF Server logs don't either. Any help would be greatly appreciated. Thank you in advance. Rick ~| 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:347585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFImage and sRGB Profiles
Does the CF8 CFImage tag support ICC sRGB color profiles or does it strip the profile out. If it doesn't support it, wouldn't it be crazy for an Adobe product not to support the web sRGB standard? Thanks in advance. ~| 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:346944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't Delete Sessions Programmatically
Well I tried J2EE sessions and we are getting the occasional but unacceptable Session is Invalid error even after changing the web.xml of each instance to be longer than the session timeout in the application.cfc. It seems that there may be numerous causes of Session is Invalid in CF8 from improper patching to legitimate CF bugs. Now I'm thinking about going back to NOT using J2EE. At least CFID and CFToken duplications were just a few in a thousand. Is there any problem apart from people losing their sessions, resulting from turning off J2EE sessions? ~| 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:346851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't Delete Sessions Programmatically
Thanks Peter, that's helpful. Any thoughts about the Session is Invalid problem? Richard. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't Delete Sessions Programmatically
Have you tried enabling J2EE sessions? Is this CF9? This is CF8 with the most recent service pack. How easy is it to switch to J2EE sessions? Is there additionally programming involved? Many thanks! R ~| 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:346793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't Delete Sessions Programmatically
We are dealing with two different applications. For example, there are calls to an image server from within the application and that image server is cold fusion based too. ~| 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:346794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't Delete Sessions Programmatically
And uncheck either of the other two below it? Enable Application Variables Enable Session Variables (when unchecked, CSRF protection) Nothing needs to be changed in the third party F5 LTM Load Balancer? Thanks so much! ~| 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:346798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can't Delete Sessions Programmatically
There are duplicate CFIDES and CFTOKENs session variables when a person uses IE8 browser. Other browsers seem fine. We can't figure out why duplicates are being included. So, we are trying to delete those session variables with no luck. cfcookie name=CFID expires=now / cfcookie name=CFTOKEN expires=now / and we've tried javascript too... var createCookie = function(name,value,days) { if (days) { var date = new Date(); date.setTime(date.getTime()+(days*24*60*60*1000)); var expires = ; expires=+date.toGMTString(); } else var expires = ; document.cookie = name+=+value+expires+; path=/; }; var eraseCookie = function(name) { createCookie(name,,-1); }; eraseCookie(CFID); eraseCookie(CFTOKEN); eraseCookie(CFID); eraseCookie(CFTOKEN); eraseCookie(CFID); eraseCookie(CFTOKEN); Still no luck. Here's the dump from her computer: HTTP_COOKIE CFID=20896392; CFTOKEN=37979387; __utma=89202778.639364946.1307983780..1313258701.1313434308.26; __utmz=89202778.1307983780.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __HTTP_COOKIE=BAR; LB-Persist=539953674.20480.; CFID=19834341; CFTOKEN=65045225; __HTTPS_COOKIE=FAR User can't log in as they have two session cookies. Any help would be greatly appreciated. Thanks. ~| 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:346772 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't Delete Sessions Programmatically
Our application works fine in all other browsers tested by over a 1000 users. One should never be able to plant identical session cookie variables for the same domain (we confirmed they were the same domain). And if you could, you surely should be able to delete them. The user that has this problem switched to Google Chrome and all is well. But our application is dead in the water for her on IE because of the duplication of session ids that cannot be deleted (she's using Windows 7 and now IE upgraded to version 9). Who could we report this possible bug to at Adobe? Thanks in advance. ~| 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:346777 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Can't Delete Sessions Programmatically
Thanks. We've had 3 people report this problem with IE8. ~| 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:346779 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sessions failing due to multiple CFID / CFTOKEN cookies
We have one server running ColdFusion 8 Enterprise. It has two applications with each application having two load balanced instances. Both applications are called within one website. ~| 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:346690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Sessions failing due to multiple CFID / CFTOKEN cookies
Should we be using jsessionids instead? Are there any problems in switching to them? Thanks so much. ~| 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:346700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Sessions failing due to multiple CFID / CFTOKEN cookies
We're encountering the following issue with some percentage of IE users (Definitely but not necessarily limited to IE8 8.0.7601.17514 windows 7). Basically their SESSION is failing the same way it might if they're cookies were disabled, however, we are able to set cookies manually using CFCOOKIE. After running several tests, we found that the users request headers include 2 CFID and CFTOKEN cookies. It seems like Coldfusion writes both into the COOKIE scope, then can't translate them into the SESSION so creates a new (third) CFID and CFTOKEN pair, then overwrites the value of both in the COOKIE scope. CGI.HTTP_COOKIES -- CFID=19602005; CFTOKEN=13461642; (other cookies removed); CFID=20907643; CFTOKEN=42056124; (other cookies removed); COOKIES -- struct CFID20907644 CFID20907644 CFTOKEN 22098534 CFTOKEN 22098534 SESSION -- struct cfid20907644 cftoken 22098534 sessionid APPNAME_20907644_22098534 urltokenCFID=20907644CFTOKEN=22098534 Anybody know what could be going on here? Thanks in advance! ~| 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:346659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 10 and beyond
I'm concerned that at some point Adobe will pull the plug on CF as free PHP continues to grow its user base. I know that there is an open source version of CF, but I'm not sure if it has Enterprise features such as the ability to create load balanced multiple instances. What's the general feeling about this? Should I be concerned? Is there any work being done on ColdFusion 10? ~| 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:346593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 and beyond
Sorry, not predicting its imminent death, just was concerned, that's all. Somehow when I googled it I didn't see any Coldfusion 10 references other than wish list items (must have misspelled it in the search). Ok by me if we kill this thread. Sorry! ~| 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:346599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 and beyond
Yes, that's true, except I'd be concerned about no security patches. ~| 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:346600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 and beyond
Nope, I'm a CF advocate. Ok by me that we kill this thread! ~| 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:346605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfexecute Problem
That worked! Thank you so much! Is it because both the program Webshot and ColdFusion were installed under my user account? ~| 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:346477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 cfexecute Problem
I can run a screen capture program executable from a Windows Server 2008 (32bit) cmd line and it captures a flash website fine. However, when I try this from cfexecute, it says no flash player is installed. Latest Flash Player has been installed for IE 8 32 bit. Please advise. Thanks. ~| 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:346471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfexecute Problem
I can run a screen capture program executable from a Windows Server 2008 (32bit) cmd line and it captures a flash website fine. However, when I try this from cfexecute, it says no flash player is installed. Latest Flash Player has been installed for IE 8 32 bit. Please advise. Thanks. Try logging in as the user that runs CF, and running the screen capture program. If you're running CF as SYSTEM rather than a specific user, you'll probably have to change that to a specific user account. 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:346474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 cfexecute Problem
Hmmm... This runs via cfhttp url=http://www.myserverdev.com/ipi_grabber/get.cfm?w=#xWaitDocTime#s=#lcase(attributes.website)# result=grabResult /. So the caller is on a different server than the webshot program. ~| 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:346475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 Enterprise Instance Size
I'd appreciate any guidance about sizing instances that are load balanced in CF8 Enterprise. Right now we have instances that are allocated 1.5 GB of RAM for each. I want to add memory to our server and am not sure if I should add 2 more instances for a domain and/or give more memory to each instance. Thanks in advance. ~| 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:346095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Enterprise Instance Size
Hi Russ, It's 64 bit windows. Load balancing is between instances (only one physical server). It's a Xeon L5410 Process which I believe is 4 cores. Each instance has CF8 Admin set for a max of 10 requests. We definitely want to add another pair of instances for a new website we are finishing up. Currently we have one pair of instances reporting low memory availability (used memory reports around 460mb used (allocated 500mb) in Fusion Reactor Enterprise dashboard). So to recap, there is currently 8 gb of memory on the server. We have two pairs of instances for two different websites each with around 500mb of memory allocated. We want to add a third pair for a new website under development. One of the two pairs almost always reports memory close to being exhausted. On the other pair we occasionally have a hosted website go viral and the instances hang as they can't handle all of the requests. Right now, we can only afford to add memory (not clustered servers). What would be your recommendation to do? ~| 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:346098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF8 Enterprise Instance Size
Hi Russ, It's 64 bit windows. Load balancing is between instances (only one physical server). It's a Xeon L5410 Process which I believe is 4 cores. Each instance has CF8 Admin set for a max of 10 requests. We definitely want to add another pair of instances for a new website we are finishing up. Currently we have one pair of instances reporting low memory availability (used memory reports around 460mb used (allocated 500mb) in Fusion Reactor Enterprise dashboard). So to recap, there is currently 8 gb of memory on the server. We have two pairs of instances for two different websites each with around 500mb of memory allocated. We want to add a third pair for a new website under development. One of the two pairs almost always reports memory close to being exhausted. On the other pair we occasionally have a hosted website go viral and the instances hang as they can't handle all of the requests. Right now, we can only afford to add memory (not clustered servers). What would be your recommendation to do? ~| 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:346099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Handling Multiple Requests
Hi Dave, We do have that setup in the load balancer. I've just discovered that while FusionReactor doesn't show the IP in the main screen (it shows the load balancer IP instead), it does show it in the header detail screen. Thanks so much. ~| 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:345908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Handling Multiple Requests
How do I handle the following situation? User clicks a link to a CF page. The page is, for whatever reason, slow to respond. User becomes impatient and clicks the same link x number of times in secession hoping to get a response from the server. Now there are x multiple requests that are slow running. This acerbates the problem as the server has now queued up to run the same slow requests multiple times. Thanks in advance. ~| 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:345848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Handling Multiple Requests
We have thousands of links on our website, so I don't think we can do that. Is there not some sort of system level way to discard multiple identical clicks from an individual's IP address? ~| 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:345859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Handling Multiple Requests
Can't think of a way to globally disable multiple clicks. Do you use jQuery on your site at all? Do you use Application.cfc or Application.cfm? If Application.cfc, adding the link disabler or status dialog could be done by modifying your onRequest() method to insert some script tags into the head of each requested page. Carl On 6/28/2011 8:58 AM, Richard Steele wrote: We have thousands of links on our website, so I don't think we can do that. Is there not some sort of system level way to discard multiple identical clicks from an individual's IP address? ~| 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:345865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Handling Multiple Requests
Hmmm... do you have an example of the code to include? I'm worried that it would mess with other javascript that we use and in particular our sophisticated light box application where users click forward and back buttons on images to call the next and previous images, etc. ~| 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:345867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Handling Multiple Requests
Yes, for sure in an ideal world. However even though we have CF Enterprise, we can only have two instances for this particular site due to hardware and budget constraints. When traffic increases due to some link to the site going viral (which is unusual), it would be impossible for the server to keep up with the requests even if the requests were all processed under a second. Then requests would build up in the queue awaiting processing. People then get impatient and start clicking the link over and over, further exacerbating the problem. ~| 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:345868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Handling Multiple Requests
A site? A single site? In my experience, performance issues come down to a few things: Poor (or no) scoping choices, poor SQL (both query execution plans and general server health), and an improperly tuned JVM. Most of the time, for me, it appears to be the DB. Either the queries are terribly written, there aren't any indexes on tables, or both (and more). Have your tried FusionReactor yet? FR can be a great resource for finding and resolving bottlenecks and poorly written code, and I think there's a 10 trial download. Hiring guys like Mike Brunt and Charlie Arehart are well worth the money too. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 6/28/2011 12:33 PM, Richard Steele wrote: Yes, for sure in an ideal world. However even though we have CF Enterprise, we can only have two instances for this particular site due to hardware and budget constraints. When traffic increases due to some link to the site going viral (which is unusual), it would be impossible for the server to keep up with the requests even if the requests were all processed under a second. Then requests would build up in the queue awaiting processing. People then get impatient and start clicking the link over and over, further exacerbating the problem. ~| 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:345875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Handling Multiple Requests
Yes, it's a hugely complex site with 170k page views a day. We pull some of the data we show from Amazon's services further slowing it down (much of which can't be cached according to their terms of service). Yes, I agree, getting rid of any slow running queries is the most important thing to do and we do have some work to do in that realm. But 95% of the time the site works just fine. So it's a lot of programming time to make that 96% of the time or greater. We do have FusionReactor and it is extremely helpful. But it can't tell us the IP addresses hitting the site if we have a bot crawling through 10k dynamically produced links or if some other website is hammering the instances. We see the load balancer IP address instead. Thus we need to go into the server logs and analyze what is happening. A site? A single site? In my experience, performance issues come down to a few things: Poor (or no) scoping choices, poor SQL (both query execution plans and general server health), and an improperly tuned JVM. Most of the time, for me, it appears to be the DB. Either the queries are terribly written, there aren't any indexes on tables, or both (and more). Have your tried FusionReactor yet? FR can be a great resource for finding and resolving bottlenecks and poorly written code, and I think there's a 10 trial download. Hiring guys like Mike Brunt and Charlie Arehart are well worth the money too. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub. com/learni ng-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 6/28/2011 12:33 PM, Richard Steele wrote: Yes, for sure in an ideal world. However even though we have CF Enterprise, we can only have two instances for this particular site due to hardware and budget constraints. When traffic increases due to some link to the site going viral (which is unusual), it would be impossible for the server to keep up with the requests even if the requests were all processed under a second. Then requests would build up in the queue awaiting processing. People then get impatient and start clicking the link over and over, further exacerbating the problem. ~| 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:345876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Handling Multiple Requests
I think it's possible, so we'll explore that as a possibility. Thanks so much. ~| 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:345877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Real head Scratcher
Ok, I have a page that loads most of the time. However, occasionally it gives an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. In verbose debugging the query that fails should be no problem whatsoever and in fact in runs fine in SQL but only 70% of the time when the page is refreshed. We are on CF8 Enterprise with two instances. What could be happening? Here's the verbose error message: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. The error occurred in C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 319 : cfquery name=qPhotographer dataSource=#ipi_dsn# 320 : SELECT * FROM ipi_photographers 321 : WHERE id = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#arguments.photographerid# / 322 : /cfquery 323 : cfreturn qPhotographer / SQLSTATE HY000 SQLSELECT * FROM ipi_photographers WHERE id = (param 1) DATASOURCEphotoeyecom Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 Remote Address 10.10.47.254 Referrer Date/Time 20-Apr-11 01:08 AM Stack Trace at cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor2(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:197) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor3(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:165) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:162) at cfdsp_search_results2ecfm265917465.._factor0(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:63) at cfdsp_search_results2ecfm265917465._factor6(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:54) at cfdsp_search_results2ecfm265917465.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:1) at cfdsp_search_results_page2ecfm2071414576.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:210) at cfsearch_results2ecfm1795000755.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm:5) at cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205)
CFexecute and licenses
Ok, we have a program that we are running using cfexecute. It requires the license for that program to be placed in the folder that holds the program that calls it. Right now, the program doesn't run since cfexecute is the calling program. In this case, thus I assume I'll need to place the program's license file somewhere in a coldfusion folder. So, where do I put it? CFIDE? Jrun? Thanks in advance. ~| 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:343559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFexecute and licenses
Ok, we have a program that we are running using cfexecute. It requires the license for that program to be placed in the folder that holds the program that calls it. Right now, the program doesn't run since cfexecute is the calling program. In this case, thus I assume I'll need to place the program's license file somewhere in a coldfusion folder. So, where do I put it? CFIDE? Jrun? You could call cmd.exe and pass this program as an argument to it, then put the license in your system folder. 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:343563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFexecute and licenses
The program is a batch screen capture program. Got the cfexecute to work by putting the license in the jrun folder. So that worked! But now it fails to load the flash plug-in that accompanies IE 8. It works like a charm if run by clicking on a batch file that resides in the folder that has the exe. How to get it to capture a flash website is my next challenge. Any insight to that would be greatly appreciated. Thanks. ~| 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:343564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Batch Website Screen Captures
We need to capture the home pages of thousands of websites using a batch file. We've tried Webshots with mixed success. Can anyone recommend a different program to try? ~| 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:343443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfheader and foreign characters
I'm trying to save a text file that has foreign characters. Here's my code: cfset xOutput = République cfheader charset=utf-8 name=content-disposition value=attachment; filename=test.txt #xOutput# When I open this file up it looks like this: Râ©publique How can I retain the proper foreign characters? Thanks in advance. ~| 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:342489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader and foreign characters
I tried this: cfheader charset=utf-8 name=content-disposition value=attachment; filename=#xFileName# cfcontent type = text/html; charset=utf-8 reset=true variable=#ToBinary( ToBase64(xOutput) )# / Still no foreign characters. ~| 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:342492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader and foreign characters
Hi Alan, closer, but now I get R?publique. Any other ideas would be greatly appreciated. ~| 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:342493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader and foreign characters
No, I get this: R?publique ~| 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:342496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader and foreign characters
That odd, it totally worked for me... http://alan.rotherfamily.net/demos/utf8/ cfprocessingdirective pageencoding=utf-8 cfset xOutput = République I get RÈpublique when I click your link. not République. ~| 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:342497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader and foreign characters
That's totally it. Apple Chrome, Safari and Firefox show RÈpublique when I click your link. IE 8 and Firefox PC show République. It shows it this in both Word 2011 and Text Edit on the Mac. Plain text endcoding is set to Automatic for Plain Text in Text Edit and utf-8 for html documents. Anyway, we'll just use Safari for the PC to run the cfm that produces this. Thanks for your patience and help! ~| 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:342499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader and foreign characters
Meant to say Firefox for the PC. Thanks again. ~| 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:342502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfimage on cf8 oversharpens thumbs
If I downsize an image to make thumbs using cfimage, it seems to automatically oversharpen some of the images. Others seem fine. When I try ImageCR3 from Efflare and I don't have this issue. Is there a way to prevent cfimage from automatically sharpen when it downsizes? Thanks in advance. ~| 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:342145 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: refreshing application variables
Got it! Thanks for all of the help! ~| 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:342016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
coldfusion errors
Is there anyway to catch coldfusion programming errors? cfoutput#999sdflkjsdf;lk#/cfoutput is caught by my error handler. But cfoutput#alsdk;fjlkj#/cfoutpu is not. Thanks in advance. ~| 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:342025 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cleaning operators out of cfsearches
I saw a utility to do this once, but have not been able to find it now that I need it. Here's what is needed... http://forums.adobe.com/thread/546788?tstart=0 Thanks in advance. ~| 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:341947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cleaning operators out of cfsearches
Found it! http://www.cflib.org/index.cfm?event=page.udfbyidudfid=760 ~| 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:341951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing Specific CF8 Instances
How do you get the session ids for each instance? What would the url look like that targeted a specific instance? Many thanks. ~| 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:341952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing Specific CF8 Instances
Well, I'm wondering if I can access the instance using an external, website address. Our developers don't necessarily have access to logging into the server. So, I'm hoping we could do something like this. http://www.website.com/index.cfm?CFID=x where x is the id of an instance. ~| 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:341956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
refreshing application variables
How does one refresh application.cfc application variables without restarting coldfusion services? Thanks in advance. ~| 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:341960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: refreshing application variables
I've changed the code in application.cfc that creates application variables for error checking and I need to test it (without restarting coldfusion 8 services). ~| 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:341963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Exporting query data
Is there an easy way to export SQL query data into a tab delimited or CSV format? I know I can do this with a loop and variables, but it seems like there should be an easier way. (my query has 100+ column names!). Thanks in advance. ~| 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:341817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf8 image format not supported error
I'm getting the following error message after a new cf8 server install. C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war image format is not supported on this operating system. It's a windows server 2008 machine. What might I be doing wrong? Thanks in advance. Ok, sorry. I didn't have a virtual directory setup in iis and it couldn't pull an image. All is well. ~| 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:34 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cf8 image format not supported error
I'm getting the following error message after a new cf8 server install. C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war image format is not supported on this operating system. It's a windows server 2008 machine. What might I be doing wrong? Thanks in advance. ~| 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:341109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Hosting Multiple CF websites on EC2 Windows Server 2008 and IIS 7
Has anyone been successful in setting up multiple CF websites with separate domains on an amazon EC2 windows server 2008 machine? I can add multiple websites in IIS but since there is only one elastic IP address from Amazon, I'm not sure how to route the traffic from each domain to their respective IIS home directory. Any help would be greatly appreciated. ~| 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:340744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
webserver configuration tool
What should the settings be in the webserver configuration tool for coldfusion 8 I'm getting the following error message: The service is unavailable. Server Error Thanks in advance. ~| 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:340618 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Accessing Specific CF8 Instances
Is there a way to access particular instances that are running on a load balanced CF8 Enterprise server? If so, how is that done? thanks in advance. ~| 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:340488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Accessing Filezilla Server on a EC2 Windows 2008 Server
I've successfully installed Filezilla server and it connects to our EC2 Windows 2008 Server 127.0.0.1. However, Our public ip address assigned by Amazon's elastic ip , works for the website, but not for ftp. I've added Filezilla to the Windows Firewall exception list. Not sure what else to try. Thanks in advance. ~| 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:340490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF8 Administrator's Debugging Options
I don't understand how the Debugging options with a specific IP Address works. If I check the Enable Robust Exception information on a production server (we have no development server) and include only a specific IP Address, our website still shows the Robust Exception information to ALL visitors to the website. Obviously this is not acceptable. If the Enable Robust Exception information is disabled and Enable Request Debugging Output is enabled, what information is then shown only to that specific IP address? Is there a way to show the Robust Exception information to only the developer's IP address without having a development server? Thanks in advance. ~| 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:340363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Template Page Not Found Errors
Our error handler captures information about a page not found. For example, it logs the following: Referrer: Query String: id=3273MoreImages=1 Browser/version: Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) How can I tell the actual page that was requested? Thanks in advance. ~| 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:340399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Amazon EC2 Windows 2008 Coldfusion Server
Hi, Does anyone have experience (good or bad) with setting up an Amazon EC2 Windows 2008 Server? We had a Gogrid Server that just disappeared one day. Gogrid had no clue as to why it happened, nor were they willing to troubleshoot. Thanks in advance. ~| 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:340403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
Did you find a tutorial on how to set up a Windows 2008 server? There's one online for a non-windows server, but I haven't found one for a Windows 2008 server. Also, I know that Amazon has different levels of guarantee for their s3 storage, but it seems like having it backed up to a different location would be wise. Is that easy to accomplish? Thanks! ~| 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:340412 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Template Page Not Found Errors
Thanks, that's it! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Amazon EC2 Windows 2008 Coldfusion Server
Ok, great. I've got my Windows Server Instance up and running! Now I'm downloading the CF8 Developer's Edition. Can I install both CF8 and CF9 Developer's Edition? Our current production server is CF8, but would like to test our code in CF9 before upgrading. ~| 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:340436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
application.cfm question
I'm testing some error checking stuff and don't understand why the application.cfm doesn't abort before an error is found in a file. Here's the application.cfm cfabort Here's the index.cfm cftest When the index.cfm is run, it shows the error information (Unknown tag: cftest). I would think that application.cfm would fire first and not even get to index.cfm. What am I'm missing here? Thanks in advance. ~| 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:340333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm