RE: CFHTTP SSL Cert
It continues to work fine in the browser. Its pretty weird how it will work for a day and then start generating this error: AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: javax.net.ssl.SSLException: java.lang.RuntimeException: Could not generate secret faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:javax.net.ssl.SSLException: java.lang.RuntimeException: Could not generate secret at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Alerts.java:190) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1731) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1692) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.handleException(SSLSocketImpl.jav a:1675) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java :1204) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java :1181) at org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.ja va:186) at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender ''/pre Note, this is the error from a webservice call, using CFHTTP generates the I/O Exception: peer not authenticated. Restarting the CFService resolves the problem temporarily. I deleted and re-added the CERT to the cacerts store yesterday with no change... Just weird right? Brook -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: April-16-14 11:02 AM To: cf-talk Subject: Re: CFHTTP SSL Cert When cfhttp is broken, can you drop the URL into your browser and have it work? Or is it broken there too? On Wed, Apr 16, 2014 at 12:27 PM, Brook Davies cft...@logiforms.com wrote: Hey Peeps, After heartbleed, I had to re-add the EchoSign Cert to our keystore (via the keytool) on all our servers. It worked as expected, and the connection started working again. However, on one our webservers, it works, and then later that day stops being able to connect and I get I/O Exception: peer not authenticated when I try to CFHTTP to the HTTPS address. If I restart the server, it works again, and then stops working again later in the day. What the heck could cause that? My other webservers work without an issue. But this one seems to keep failing. The cert IS in the keystore... Any ideas? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFHTTP SSL Cert
Hey Peeps, After heartbleed, I had to re-add the EchoSign Cert to our keystore (via the keytool) on all our servers. It worked as expected, and the connection started working again. However, on one our webservers, it works, and then later that day stops being able to connect and I get I/O Exception: peer not authenticated when I try to CFHTTP to the HTTPS address. If I restart the server, it works again, and then stops working again later in the day. What the heck could cause that? My other webservers work without an issue. But this one seems to keep failing. The cert IS in the keystore... Any ideas? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: danger in increasing PostParameterLimit ?
Umm - maybe its a big form??! -Original Message- From: Casey Dougall - Uber Website Solutions [mailto:ca...@uberwebsitesolutions.com] Sent: January-19-14 5:07 PM To: cf-talk Subject: Re: danger in increasing PostParameterLimit ? On Fri, Jan 17, 2014 at 10:52 AM, Chris 0404tow...@gmail.com wrote: How dangerous is increasing PostParameterLimit in CFv9 ? We have increased from the default 100 to 1,100 to meet applications' needs. We are now requested to consider increasing it to 2,000. The developers are reviewing updating the design to use fewer PostParameters. They should update the design to us XML or JSON for all those parameters. I don't understand the need for all those post parameters where you could be using json or xml in one parameter. -- Casey Dougall Über Website Solutions (518) 633-1621 Saratoga Springs, NY http://uberwebsitesolutions.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:357483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Simple SQL Query sometimes really Slow?
This may not be the right place to post this (man, CF-TALK has changed a lot in the last 5 or so years ;)). I have a simple SQL query that is showing up as running slow. When I run it via the Management Studio it is sometimes fast 0.1 seconds and sometimes, seemingly randomly slow 1.5 minutes!). Other queries on other tables are executing normally. This table only has 50k records and even a simple query is sometimes really slow. The query that runs slow is as simple as select commitDate,id from databaseChangeLog where usr_id = 62622 and form_id = 312468 and commitDate '2013-12-04 11:00:05.0' But is just as slow without the date part. The table has a clustered index on the primary key (id) and a non-clustered index on usr_id,form_id and commitDate. The index doesn't seem to make any difference. My guess is the table is locked. My question is: How can I determine if it is locked? What would be locking it. I checked all my code and there are no CFTRANSACTIONS or ISOLATED READS or anything like that. There are some inserts and the table has 2 TEXT columns which are being updated at times with fairly large values. But the only queries reported as slow are these simple SELECTS. The query execution plan uses the non-clustered index on (usr_id,form_id and commitDate). I'm just at a loss as to why this specific query is sometimes so slow.. where to look? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357289 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Simple SQL Query sometimes really Slow?
Thank you everyone for all your suggestions. Gonna start testing them out. Byron: I have this issue when running the query via management studio and via cfquery so not sure if that is relevant.. Jon: I'm still running 2005 (if it ain't broke...), but was also thinking about trying READ UNCOMMITTED (maybe that would have the same effect as your suggestion?) Mark: The select is only returning a couple of columns (date/int) and no text.. I'll check the activity monitor.. the execution plan shows the index usage and doesn't appear to account for the delays... Jeff: Thanks for the Queries, I'll try them! Whohoo! Cftalk is alive!! Brook -Original Message- From: Byron Mann [mailto:byronos...@gmail.com] Sent: December-05-13 10:22 AM To: cf-talk Subject: Re: Simple SQL Query sometimes really Slow? Could never figure this out, but we had a similar issue on 2005 with a date time column. I remember we changed from a cfquery to a stored procedure and it was resolved. Byron Mann Lead Engineer Architect HostMySite.com On Dec 5, 2013 12:27 PM, Brook Davies cft...@logiforms.com wrote: This may not be the right place to post this (man, CF-TALK has changed a lot in the last 5 or so years ;)). I have a simple SQL query that is showing up as running slow. When I run it via the Management Studio it is sometimes fast 0.1 seconds and sometimes, seemingly randomly slow 1.5 minutes!). Other queries on other tables are executing normally. This table only has 50k records and even a simple query is sometimes really slow. The query that runs slow is as simple as select commitDate,id from databaseChangeLog where usr_id = 62622 and form_id = 312468 and commitDate '2013-12-04 11:00:05.0' But is just as slow without the date part. The table has a clustered index on the primary key (id) and a non-clustered index on usr_id,form_id and commitDate. The index doesn't seem to make any difference. My guess is the table is locked. My question is: How can I determine if it is locked? What would be locking it. I checked all my code and there are no CFTRANSACTIONS or ISOLATED READS or anything like that. There are some inserts and the table has 2 TEXT columns which are being updated at times with fairly large values. But the only queries reported as slow are these simple SELECTS. The query execution plan uses the non-clustered index on (usr_id,form_id and commitDate). I'm just at a loss as to why this specific query is sometimes so slow.. where to look? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
When I flatten an acroform, the radio buttons no longer show as checked.
If I don't call flatten (CFPDFflatten=true), the PDF shows the radio buttons selected, but as soon as I flatten the PDF, the radio buttons are not shown as selected. Checkboxes work, text fields work, but radio buttons just all show as unselected. This is on CF 9,0,1,274733. Has anyone else seen this? Any suggestions? ~| 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:357067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
JSON Encoding bug (again...)
I have had to do so many hacks to get serializeJSON() to play nice. I add a ~ to all yes/no strings so I don't get back true/false values, I have a series of regular expressions that quote values in the resulting JSON that don't get quoted and break on the client side. And now I have this issue: cfset x = {testval='.0006'} cfdump var=#serializeJSON(x)# Which outputs: {TESTVAL:6.0E-4} WTF? I am using CF 9,0,1,274733 Update Level /C:/ColdFusion9/lib/updates/hf901-4.jar Anybody know of a workaround for this? The source data is in a query which gets serialized after being converted to an array of structs. It would be too slow to check each field for values like this and modify them to return to the client. I need another Idea. Anyone? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356382 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Hey Guys, I am getting a lot of these errors today: Transaction (Process ID 65) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. On a system that is used to track 'views' of a page via an ajax request. All of the errors are related to updating a specific table with a query like this (this is not the CFML query..): update formAnalytics_view set INLINESTART={ts '2013-07-16 10:04:21'} , INTERACTED=1 where sessionid = '5BAC1158-D89E-4CB5-A8FB-1DC06D3E82A9' The table has 4,925,131 rows and growing. It is has more writes than reads. Is there something I can do to optimize this table to avoid these deadlock errors? I had added a try/catch around the transactions that were causing these deadlocks, and then I was re-running the failed transaction in the catch segment, but it looks like the lock was not yet removed and this was just leading to more errors. What is the best way to resolve this? Would adding a thread.sleep() statement and then re-trying the transaction work or would that just lead to more errors? Note the queries should 9 times out of 10 be updating different rows of this table. Should I add an index on the sessionID? Or would that make writes slower? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Thanks Jeff and Byron! -Original Message- From: Jeff Garza [mailto:j...@garzasixpack.com] Sent: July-16-13 10:38 AM To: cf-talk Subject: re: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Absolutely you should have an index on sessionID. Without that index you are forcing a table scan for that id so the engine can do the update. When your table was smaller, SQL could deal with that a lot easier. Once you start getting to 3-4 million rows, the performance starts to slow down on a flat table scan. I have tables with 500 million rows and I can find a unique record using a clustered index scan in under a second... If you are only indexing the sessionID column you shouldn't see any major performance hits on inserts and you should see dramatic performance increases on your updates. --Jeff Original Message From: Brook Davies cft...@logiforms.com Sent: Tuesday, July 16, 2013 10:03 AM To: cf-talk cf-talk@houseoffusion.com Subject: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Hey Guys, I am getting a lot of these errors today: Transaction (Process ID 65) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. On a system that is used to track 'views' of a page via an ajax request. All of the errors are related to updating a specific table with a query like this (this is not the CFML query..): update formAnalytics_view set INLINESTART={ts '2013-07-16 10:04:21'} , INTERACTED=1 where sessionid = '5BAC1158-D89E-4CB5-A8FB-1DC06D3E82A9' The table has 4,925,131 rows and growing. It is has more writes than reads. Is there something I can do to optimize this table to avoid these deadlock errors? I had added a try/catch around the transactions that were causing these deadlocks, and then I was re-running the failed transaction in the catch segment, but it looks like the lock was not yet removed and this was just leading to more errors. What is the best way to resolve this? Would adding a thread.sleep() statement and then re-trying the transaction work or would that just lead to more errors? Note the queries should 9 times out of 10 be updating different rows of this table. Should I add an index on the sessionID? Or would that make writes slower? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Memory consumption issue in CF 9
You need to look at the threads that were running when your memory started to spike. Or look under the slow pages in fusion reactor and then look and see what they are doing, what queries are executing (seems like a pretty high number of JDBC requests per second) and how long they are taking. Or do a stack trace of the hung threads to see where they are hung... Brook -Original Message- From: Ben Conner [mailto:b...@webworldinc.com] Sent: July-09-13 5:23 PM To: cf-talk Subject: Memory consumption issue in CF 9 Hi, I have a CF 9 server, version 9,0,0,251028 running on top of Java vsn 1.6.0_38. Recently I've started having significant out-of-memory conditions that cause the JVM to crash. I have Fusion Reactor running on this machine and have taken snapshots of the appropriate screens. Running a manual garbage collect does not reduce the memory to a significant degree. The graphs, along with the config parms passed to the JVM, are at: http://www.webworldinc.com/cf9/ Suggestions on where to look for the root cause for this? Thanks! --Ben -- Ben Conner b...@webworldinc.com Web World, Inc. 888-206-6486 or PO Box 1122 480-704-2000 Queen Creek, AZ 85142 ~| 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:356151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Geargian Dates??
Hi Guys, I am interfacing with a webservice and the dates returned are in Gregorian format. For example I get back: {ts '1582-10-04 16:00:00'} How do you convert Gregorian dates into something CF can use and format? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: dragon dictation and CF
Yeah, I ditched dragon too, what a waste of time. And their sales people can't keep calling me every since... -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: March-22-13 2:44 PM To: cf-talk Subject: Re: dragon dictation and CF That program takes a lot of training to be able to recognize your voice and is frustrating to use during the learning period. Trying to program with dictation software would result in a huge decrease in productivity compared to a good keyboard with macro keys for all the common code, the benefit of code-completion features within the IDE, and the use to two fully functional hands. I think the technology is only suitable for programmers who cannot use their hands and work at home or in an quiet office with a door that can be closed. I didn't watch the video since it is 30min long. I assume the presenter has a higher opinion of voice recognition software than I do. I only spent a day using Dragon before giving up on it. -Mike Chabot On Fri, Mar 22, 2013 at 3:01 PM, Chad Gray cg...@careyweb.com wrote: Has anyone tried to use Dragon dictation software to write CF code? I saw this video and it got my brain going. https://www.youtube.com/watch?feature=player_embeddedv=8SkdfdXWYaI My fingers are developing some numbness and I need to be pro-active. Chad ~| 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:355138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Flying Saucer instead of CFDocument
I am looking at integrating Flying Saucer to replace CFDOCUMENT mostly to add support for page-break-inside:avoid. Anybody been down this road and have any advice before I get started? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Localization , French Accents...
Thanks Paul! -Original Message- From: Paul Hastings [mailto:p...@sustainablegis.com] Sent: February-27-13 5:31 PM To: cf-talk Subject: Re: Localization , French Accents... On 2/28/2013 3:05 AM, Brook Davies wrote: Sorry, Unicode/utf-8 are the same thing...my mistake.. they're not the same thing. unicode is a *standard* (the unicode consortium produces a book the unicode standard). utf-8 (UCS Transformation Format 8 bit) is one *encoding* implementing that standard, there are others. ~| 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:354737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Localization , French Accents...
I am trying to read in a number of text files that contain translations (using French in this example) and store them in my applications app scope. The file I am reading in looks like this: http://screencast.com/t/DZTv3iVrbyo When I dump the results from reading in the file, or try to use them in output, the accents get munged: http://screencast.com/t/aoRcLWWHn I have tried everything I can think of to get this to work and everything has failed. I have tried manually setting the charset on the CFFILE tag and that has not helped. I tried using UTF-8, and WINDOWS-1255. Since I have numerous language files I have even tried implementing this java class org.mozilla.universalchardet.UniversalDetector that detects the encoding of a file, and then using the detected encoding when reading in the translation files. But no matter what I do, the encoding is not preserved. Note, this library tells me my French files are WINDOWS-1255./ Does anyone have any suggestions on how I can handle this? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Localization , French Accents...
Should I be saving it in Unicode or UTF-8? -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: February-27-13 11:01 AM To: cf-talk Subject: Re: Localization , French Accents... My first guess is that it is happening when the file is read in. Was it saved as unicode? I think notepad lets you do that. If not, notepad++ does. On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote: I am trying to read in a number of text files that contain translations (using French in this example) and store them in my applications app scope. The file I am reading in looks like this: http://screencast.com/t/DZTv3iVrbyo When I dump the results from reading in the file, or try to use them in output, the accents get munged: http://screencast.com/t/aoRcLWWHn I have tried everything I can think of to get this to work and everything has failed. I have tried manually setting the charset on the CFFILE tag and that has not helped. I tried using UTF-8, and WINDOWS-1255. Since I have numerous language files I have even tried implementing this java class org.mozilla.universalchardet.UniversalDetector that detects the encoding of a file, and then using the detected encoding when reading in the translation files. But no matter what I do, the encoding is not preserved. Note, this library tells me my French files are WINDOWS-1255./ Does anyone have any suggestions on how I can handle this? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Localization , French Accents...
Sorry, Unicode/utf-8 are the same thing...my mistake.. -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: February-27-13 11:01 AM To: cf-talk Subject: Re: Localization , French Accents... My first guess is that it is happening when the file is read in. Was it saved as unicode? I think notepad lets you do that. If not, notepad++ does. On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote: I am trying to read in a number of text files that contain translations (using French in this example) and store them in my applications app scope. The file I am reading in looks like this: http://screencast.com/t/DZTv3iVrbyo When I dump the results from reading in the file, or try to use them in output, the accents get munged: http://screencast.com/t/aoRcLWWHn I have tried everything I can think of to get this to work and everything has failed. I have tried manually setting the charset on the CFFILE tag and that has not helped. I tried using UTF-8, and WINDOWS-1255. Since I have numerous language files I have even tried implementing this java class org.mozilla.universalchardet.UniversalDetector that detects the encoding of a file, and then using the detected encoding when reading in the translation files. But no matter what I do, the encoding is not preserved. Note, this library tells me my French files are WINDOWS-1255./ Does anyone have any suggestions on how I can handle this? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Localization , French Accents...
Bobby, thanks for the notepad+ idea - it was the encoding on the source file -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: February-27-13 12:05 PM To: cf-talk Subject: Re: Localization , French Accents... UTF-8 should do it. On 2/27/13 3:00 PM, Brook Davies cft...@logiforms.com wrote: Should I be saving it in Unicode or UTF-8? -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: February-27-13 11:01 AM To: cf-talk Subject: Re: Localization , French Accents... My first guess is that it is happening when the file is read in. Was it saved as unicode? I think notepad lets you do that. If not, notepad++ does. On 2/27/13 12:52 PM, Brook Davies cft...@logiforms.com wrote: I am trying to read in a number of text files that contain translations (using French in this example) and store them in my applications app scope. The file I am reading in looks like this: http://screencast.com/t/DZTv3iVrbyo When I dump the results from reading in the file, or try to use them in output, the accents get munged: http://screencast.com/t/aoRcLWWHn I have tried everything I can think of to get this to work and everything has failed. I have tried manually setting the charset on the CFFILE tag and that has not helped. I tried using UTF-8, and WINDOWS-1255. Since I have numerous language files I have even tried implementing this java class org.mozilla.universalchardet.UniversalDetector that detects the encoding of a file, and then using the detected encoding when reading in the translation files. But no matter what I do, the encoding is not preserved. Note, this library tells me my French files are WINDOWS-1255./ Does anyone have any suggestions on how I can handle this? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Email attachment problem
Don't use CFsleep to sleep for 15 minutes unless you want to tie up a thread for 15 minutes doing nothing. Depending on the max requests/threads settings, you could stall/crash the server just by reloading that page 10+ times... Brook -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: January-04-13 11:34 AM To: cf-talk Subject: RE: Email attachment problem Use a delay between sending the file and deleting it, like CFSleep. The file is being deleted too quickly. I usually give it about 15 minutes. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Rob Voyle [mailto:robvo...@voyle.com] Sent: Friday, January 04, 2013 1:27 PM To: cf-talk Subject: Email attachment problem Hi folks I have an online classroom that enables participants to email each other including sending attachments. The attachments are uploaded to a private temporay directory and then attached to the email. After the email is sent i want to delete the file from the temp directory. If the file is large (several mb) and the list is large the delete function interferes with the cfmail program, by deleting the file before all the email is processed. Is there a way to tell when the email is sent to automatically delete the temporary file and/or is there a way to set up routine that would automatically delete the temp directory every day. Thanks Rob ~| 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:353783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
UTF-8 encoding when writing to a PDF
I am totally stuck on this one. I am using an old Ben Forta tag cf_pdfform. Im still using it because it makes writing to a PDF form and populating fields easier than using the native cfpdf form population methods. The problem is that any strings with UTF-8 characters get truncated at the first character. The method basically takes an XMl string of form data and the PDF form/file and returns the populated PDF document (in this case in bytes). The XML I am testing with looks good: ?xml version=1.0 encoding=UTF-8? xfdffieldsfield name=activitiesvalueGrave accent (à, è, ù): Over a or u, used primarily to distinguish homophones: à (to) vs. a (has), ou (or) vs1. où (where, note that ù exists1 only in this word). Over an e, 1indicates the sound/value/field/fields/xfdf // PDF form input stream formIS=CreateObject(java, java.io.FileInputStream); formIS.init(ARGUMENTS.PDFForm); // Get PDF document object PDFfactory=server.javaLoader.create(com.adobe.pdf.PDFFactory); PDFdoc=PDFfactory.openDocument(formIS); // Convert raw XML data to byte array bytes=ARGUMENTS.XMLData.getBytes(UTF-8); byteArrayIS=CreateObject(java, java.io.ByteArrayInputStream); byteArrayIS.init(bytes); // Perform actual import PDFdoc.importFormData(byteArrayIS); //Call the PDFDocument object's save method outputIS=PDFdoc.save(); // Read bytes byteClass=CreateObject(java, java.lang.Byte).TYPE; PDFBytes=CreateObject(java, java.lang.reflect.Array).newInstance(byteClass, outputIS.available()); // And store them outputIS.read(PDFBytes); But when I executed the code below and then write the bytes via CFILE CHARSET=UTF-8, the form field data is truncated in the resulting PDF. Anybody have any ideas? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352781 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Any reason a cfhttp post can't be made in a component method?
Hi Rick, There is no reason why this should not work via the CFC method or even via the direct ajax method. Some gateways however restrict access to approved IPs, so the ajax method, originating from the end user IP may not work directly, which is why you probably want to route it through a CFC. The CFC method is the best option anyways, because otherwise you would need to do 2 ajax requests to talk to Authorize and then send the results to your server. You should just call a CFC (via ajax), your CFC should post to Auth.net and then return record the result and return to the client. If your transactions are getting approved via your CFHTTP post, then you should be getting a result. What do you see when you dump the cfhttp.fileContent result? I have some authorize.net code you can look at that uses CFHTTP, just email me off list and I'll send it to you. Its nothing special though.. just a CFHTTP post and some list parsing code to parse the result... Brook -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: September-25-12 8:34 AM To: cf-talk Subject: RE: Any reason a cfhttp post can't be made in a component method? Ok... next question. Can a jQuery ajax function be used to send post variables to a component method and have a cfhttp function post those variables to another domain, in this case, https://test.authorize.net/gateway/transact.dll ??? I'm at my wits end trying to process form data into two parts. The data fields that can go to authorize.net and the parts that need to stay with me and go into my database. Authorize.net forbids personally identifiable info from going into the merchant-defined fields. Ergo, I need to post some of the form data to Authorize.net and if a transaction is approved, post some of that info (not CC numbers, etc) to my database, along with other info not pertinent to the transaction, such as in honor of etc. The easiest way I thought to do this was to use AJAX and submit some of the data that way (I couldn't get a straight jQuery AJAX post to work...couldn't get a response from the Authorize.net server, although the transaction was successful) and I haven't been successful getting the form values with jQuery AJAX and posting them to Authorize.net by send the form values via AJAX to a CFC method, which utilizes CFHTTP for the post. No response from the Authorize.net server. If you know this will work, Ray, how much would it cost you to guide me through a solution. I have a patient client, but this needs to get done. I'm at the point now where I'm either considering going to session variables or just putting all the post variables into a temp table in a database, then processing the transaction, and, if successful, putting the transaction data into a permanent table. I just can't seem to work up a solution from everything I've read (which is all I could find) and everyone that would discuss this with me, including calling Authorize.net, who said we don't support developers... Can it be done? Can you do it? If so, how much to guide me through it? Still have my hair, but not for long! Rick -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: Tuesday, September 25, 2012 10:54 AM To: cf-talk Subject: Re: Any reason a cfhttp post can't be made in a component method? Nope. On Tue, Sep 25, 2012 at 7:15 AM, Rick Faircloth r...@whitestonemedia.com wrote: Can anyone think of a reason that a cfhttp post can't be made within a component method? 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:352746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Long Text Truncation
Don't forget you need the Enable long text retrieval (CLOB). checkbox checked within the cfadmin datasource settings. (its under advanced settings...) Brook -Original Message- From: DURETTE, STEVEN J [mailto:sd1...@att.com] Sent: July-17-12 8:35 AM To: cf-talk Subject: RE: CF Long Text Truncation Don't know if this will help but try looking at this: http://cutesoft.net/forums/thread/42292.aspx It's for IIS7 but it was quickly googled, so it may be a start. Before going that way though I would test. Submit one of these long posts to a test page and determine if what you sent is what got through. If its not then look at IIS. Steve -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, July 17, 2012 11:14 AM To: cf-talk Subject: RE: CF Long Text Truncation are you sure that all the data is getting to your query ... are you hitting the HTML Post limit Where is this setting? Is this an IIS setting or something? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:351917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Urgent: Server queues all requests for one loop
I have a jar file with a couple of methods that do decryption that I am calling in a loop. The loop is big, 6000 iterations and while its running the server is basically brought to a grinding halt and other requests start to queue and/or execute very slowly. The cpu is at 40% or so, memory usage does not spike. How does one thread cause the entire server to grind to a halt? The funny thing is, If I add a thread.sleep(10) in between each iteration then the server is able to serve other requests fairly quickly and nothing queues. This code does not cause the server to queue all other requests because of the thread.sleep(), without it, this loop takes over and everything else queues (or completes very slowly): cfset thread = CreateObject(java, java.lang.Thread) cfloop from=1 to=6000 index=i !--- adding this sleep command, saves the day and allows processing to continue --- cfset thread.sleep(10) cfinvoke component=#application.util.RSACrypt# method=decrypt inputCollection=#encryptedData# key=#private_key# returnvariable=encryptedData /cfloop This is the method that is being called: /** * Decodes a string encoded using its corresponding private key. This must be done manually due to the unusual padding and * byte ordering involved. * @param encryptedString the encrypted string, in aec/TRSA's version of RSA, in aec's version of base-64 encoding. * @param aecPrivateKey the corresponding private key, in aec/TRSA's version of base-64 encoding. * @return a String representing the original plaintext message. */ public static String aecDecrypt(String encryptedString, String aecPrivateKey) { RSAPrivateKeySpec privKeySpec = AECKeyToPrivateKeySpec(aecPrivateKey); BigInteger d = privKeySpec.getPrivateExponent(); BigInteger n = privKeySpec.getModulus(); byte[] src = unpackAECEncodedBase64(encryptedString); // this is where the time is spent.. BigInteger c = new BigInteger(1,src); BigInteger m = c.modPow(d,n); byte[] decrypted = m.toByteArray(); for(int i=0; idecrypted.length/2; i+=1) { byte a = decrypted[decrypted.length-i-1]; byte b = decrypted[i]; decrypted[decrypted.length-i-1] = b; decrypted[i] = a; } int padBytes = decrypted[decrypted.length-1]; String dest = ; for(int i=0; i(64-padBytes-1); i++) dest+=(char)decrypted[i]; d.finalize(); //just to be helpful... return dest; } ~| 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:351563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Calling custom Java class in a loop kills the server
I think I found out what was killing my server the other day. We used to use an encryption CFX called textCrypt, actually we've been using it for years and years, but it stopped working on our new CF9 64bit server. So we hired a Java developer to write a java class that would handle decrypting strings using the existing private keys generated with this CFX (aec/TRSA.). The new java class seems to work pretty good, but when called in a loop, ohh, 6000 times, it is really slow and the entire server basically seems to stop and wait for it to finish before serving other threads. I don't understand why this is the case.. We're calling the method below aecDecrypt() to decrypt each string (6000 times.) and its killing our server and taking too long to finish processing. I don't know Java, does anyone see a way that this could be improved? One thing I notice is that each time its called it takes the private key provided and calls AECKeyToPrivateKeySpec() to convert the private key to the format needed. I guess this really only needs to be called once each time. If anyone thinks they can help me with this I am willing to pay some one to help me optimize this before I setup a new server specifically for decryption so that it doesn't bring my webserver to its knees. I still don't understand why that happens though. /** * Decodes a string encoded using its corresponding private key. This must be done manually due to the unusual padding and * byte ordering involved. * @param encryptedString the encrypted string, in aec/TRSA's version of RSA, in aec's version of base-64 encoding. * @param aecPrivateKey the corresponding private key, in aec/TRSA's version of base-64 encoding. * @return a String representing the original plaintext message. */ public static String aecDecrypt(String encryptedString, String aecPrivateKey) { RSAPrivateKeySpec privKeySpec = AECKeyToPrivateKeySpec(aecPrivateKey); BigInteger d = privKeySpec.getPrivateExponent(); BigInteger n = privKeySpec.getModulus(); byte[] src = unpackAECEncodedBase64(encryptedString); BigInteger c = new BigInteger(1,src); BigInteger m = c.modPow(d,n); byte[] decrypted = m.toByteArray(); for(int i=0; idecrypted.length/2; i+=1) { byte a = decrypted[decrypted.length-i-1]; byte b = decrypted[i]; decrypted[decrypted.length-i-1] = b; decrypted[i] = a; } int padBytes = decrypted[decrypted.length-1]; String dest = ; for(int i=0; i(64-padBytes-1); i++) dest+=(char)decrypted[i]; d.finalize(); //just to be helpful... return dest; } , /** * Creates an RSAPrivateKeySpec object based on a private key generated with the aecRSA library (such as TextCrypt). * @param aecPrivateKeyA base64-encoded string in the aecRSA format * @return an RSAPrivateKeySpec object representing the same 'n' and 'd' values. If the key is invalid, returns null. */ public static RSAPrivateKeySpec AECKeyToPrivateKeySpec(String aecPrivateKey) { String[] pieces = aecPrivateKey.split(:); if (pieces.length2) { return null; } String nString = unpackWeirdMPInt(pieces[0]); while(nString.endsWith(?)) nString = nString.substring(0,nString.length()-1); String dString = unpackWeirdMPInt(pieces[1]); while(dString.endsWith(?)) dString = dString.substring(0,dString.length()-1); BigInteger n = new BigInteger(1,unpackHexString(nString)); BigInteger d = new BigInteger(1,unpackHexString(dString)); //BigInteger d = new BigInteger(dString,16); //BigInteger n = new
CF 9 Server restart
Hey guys, My Brand new CF9 Server (64 bit), for a site I just launched on Friday restarted itself 3 times in a row this morning while logging only: Potentially fatal error in generated byte array length: 63 AWT blocker activation interrupted:06/04 05:55:59 user CFInternalServlet: destroy 1) java.lang.InterruptedException at java.lang.Object.wait(Native Method) at java.lang.Object.wait(Object.java:485) at sun.awt.AWTAutoShutdown.activateBlockerThread(AWTAutoShutdown.java:315) at sun.awt.AWTAutoShutdown.setToolkitBusy(AWTAutoShutdown.java:232) at sun.awt.AWTAutoShutdown.notifyToolkitThreadBusy(AWTAutoShutdown.java:118) at sun.awt.windows.WToolkit.eventLoop(Native Method) at sun.awt.windows.WToolkit.run(WToolkit.java:293) at java.lang.Thread.run(Thread.java:662) 06/04 05:55:59 Information [Thread-1] - Stopping Event Gateways. 2) Potentially fatal error in generated byte array length: 63 06/04 05:56:36 user CFInternalServlet: destroy 3) Potentially fatal error in generated byte array length: 63 06/04 05:58:25 user CFInternalServlet: destroy Anyone seen this error before? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFC returns escaped strings.. grrrr
I am trying to do some jsonP stuff and call a CFC directly. The problem is the CFC doesn't return the correctly formatted string. I want to return a string from the remote CFC call but it quotes the string and escapes the quotes. I return: jsonp_fa({RESULT:ok}) And I get: jsonp_fa({\RESULT\:\ok\}) My CFC method is set to return a string with no formatting, so why does it escape the string???!! cffunction name=record access=remote returntype=string returnformat=plain output=true Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFC returns escaped strings.. grrrr
omg! - your right!!! Thank you - I don't know how I missed that! Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: June-03-12 11:59 AM To: cf-talk Subject: Re: CFC returns escaped strings.. g When you call it, are you adding returnformat=json in the url? It will override the returnformat in your function call. On Sun, Jun 3, 2012 at 1:31 PM, Brook Davies cft...@logiforms.com wrote: I am trying to do some jsonP stuff and call a CFC directly. The problem is the CFC doesn't return the correctly formatted string. I want to return a string from the remote CFC call but it quotes the string and escapes the quotes. I return: jsonp_fa({RESULT:ok}) And I get: jsonp_fa({\RESULT\:\ok\}) My CFC method is set to return a string with no formatting, so why does it escape the string???!! cffunction name=record access=remote returntype=string returnformat=plain output=true Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ZenDesk Rest API
Hello, Has any one done any integration with ZenDesks API that they care to share? I am just looking for the basics, actually, I would be happy with an example of how to 'create' a ticket from a web form submission and then I think I can figure the rest out from there.. Anyways, thought I would check here before I dive in (nothing on riaForge..). Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Application Scoped CFC's and the Request Scope
Hey Guys, While I know its not best practice, I am setting some variables in the request scope that are then referenced by several application scoped CFCs. Can this lead to collisions? I am seeing some strange errors that only happen when I run multiple requests at the same time and seem to involve the request scoped data. Could this potentially be the issue? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Somewhat OT....Making us look bad...For the adobe engineers on the list..
Maybe Adobe Support also had a hard time 'understanding' what you were trying to tell them. I do some support, and if the customer doesn't provide the right information, it can be difficult to provide a good response. I'm not saying that's what happened, but look how easily it can happen as it did here. Brook -Original Message- From: Eric Roberts [mailto:ow...@threeravensconsulting.com] Sent: April-27-12 12:44 PM To: cf-talk Subject: Re: Somewhat OTMaking us look bad...For the adobe engineers on the list.. Oops... meant 8...yes...I am so used to saying CF9, it just comes naturally :-D. Sorry for the confusion... On Fri, Apr 27, 2012 at 2:06 PM, Wil Genovese jugg...@trunkful.com wrote: ColdFusion 9.0.x not ColdFusion 8.0.x What you are describing was true for ColdFusion 8.0.x. When ColdFusion 9.0.x was released ALL editions were 64bit. Read this product Matrix http://www.adobe.com/products/coldfusion-family/buying-guide.html All ColdFusion 9 editions can run as 64-bit applications on the 64-bit versions of Microsoft Windows, Sun Solaris, Linux, and Mac OS. For detailed information about supported platforms http://www.adobe.com/products/coldfusion-standard/faq.html Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 27, 2012, at 1:59 PM, Eric Roberts wrote: Not according to the website. It is compatable with 64 bit, but it is not 64 bit. If you download a 64 bit version and enter in a standard password, it will not accept it. On Fri, Apr 27, 2012 at 1:57 PM, Wil Genovese jugg...@trunkful.com wrote: ColdFusion 9/9.0.1 IS 64 bit for Standard AND Enterprise. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Apr 27, 2012, at 1:54 PM, Eric Roberts wrote: Standard doesn't have a 64 bit vesion...it is only Enterprise that does. Standard is 32 bit only. On Fri, Apr 27, 2012 at 1:46 PM, Kris Jones kris.jon...@verizon.net wrote: Wow. That's pretty tough. I didn't know that was required when installing 64-bit version of CF. -KJ On Fri, Apr 27, 2012 at 2:40 PM, Eric Roberts ow...@threeravensconsulting.com wrote: Why doesn't support seem to know to tell a customer, when they are installing CF9 standard on a 64 bit box that they need to go into the IIS application pool setting and enable 32 bit apps? I am doing a gig for a client that could get CF( installed and that was all it was). That should have been a quick fix. While i glad for the business, I just think this makes us as a community look bad when Adobe's support is that incompetent. I have a stack of emails going back and forth about an inch thick and not one mentioned. My client got a CF app dumped in their lap and they didn't have any CF resources. Sorry for the rant, but since I know we have some Adobe folks here...I thought this would be as good as a spot as any. This is a HUGE company that could potentially get impressed by CF and create a lot of CF jobs. I won't name them, but i can tell you that probably everyone on this list has consumed their products...some on a regular basis. This is how companies get turned off of products. This could have been a big win on Adobe's part. Way to drop the ball. Some days I think Adobe purposely tries to sabotage their own product. Adobe folks...feel free to pass this on to the appropriate people. back to your regularly scheduled topics... Eric ~| 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:350871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: FusionReactor - Development server
No, you have to buy a separate license for your dev server. I know this because I just went through this process. They did offer me a bit of a discount on the dev server license when I asked really nicely and said please. Brook -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: April-14-12 7:39 AM To: cf-talk Subject: Re: FusionReactor - Development server I saw that but it doesn't mention development. Their license does talk about a development license but doesn't talk about cost in the license. You ever have one of those dreams that seems s real? Apparently I have :-) On 4/14/12 10:23 AM, andy matthews li...@commadelimited.com wrote: Looks like you might have been dreaming: http://www.fusion-reactor.com/fr/faq.cfm#licencing1 Each physical or virtual server requires one FusionReactor license - all of the instances which are installed on that server are covered by the one FusionReactor license. So, if you have (say) 6 physical boxes, then you need 6 licenses. Note, that on a single box you may have multiple instances (ColdFusion, JRun, Tomcat, JBoss) installed on it, but you still only need 1 license for that (virtual or physical) server. Virtual Machines (VM's) are also classed as separate physical servers and therefore require a license. andy -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: Saturday, April 14, 2012 8:31 AM To: cf-talk Subject: FusionReactor - Development server I figured if anyone knew the answer to this (outside of FR Support), it would be someone on this listC I may have dreamed this because I can't find it again but I thought I read that if you bought a FusionReactor enterprise license, you were also allowed to install a second copy on a development server at no extra cost. Does anyone know whether or not that is true? 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:350704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RSACrypt.cfc help
Hi Jen, Are the keys generated via the Bounce Castle API? They should be in order to be used with this CFC. Brook -Original Message- From: Jen McVicker [mailto:snarkmeis...@gmail.com] Sent: March-26-12 11:00 AM To: cf-talk Subject: RSACrypt.cfc help I'm getting an error trying to decrypt a string with RSACrypt.cfc. The error is: javax.crypto.BadPaddingException: blocktype mismatch Has anyone else come across this and found a solution? My google-fu is failing me.it looks like perhaps one of the strings (either the private key or the encrypted string) needs to be padded to reach a certain length, but I'm not sure how to determine which string needs to be padded, how much padding is required, and how that needs to be done. Please note: RSACrypt is decrypting just fine for other private key/encrypted string pairs. It is only *some* that are failing, so it's likely not a coding error in the CFC or in the java crypto lib. Thanks bunches for any help you can provide. Jen Perkins McVicker Adobe Certified ColdFusion Developer mailto:jen.mcvic...@gmail.com jen.mcvic...@gmail.com Phone/Fax: 925.757.1839 Mobile: 925.759-3321 http://www.linkedin.com/in/jmcvicker http://www.linkedin.com/in/jmcvicker ~| 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:350549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Browser and OS detection with CF
Does anyone know of a good script to detect the browser and OS (including versions) with CF? So far I have found BrowserDetect UDF (http://www.cflib.org/udf/browserDetect) which looks good, but I would also like to record the OS and Screen Resolution. Are these things better suited to JS? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Browser and OS detection with CF
I guess there is some benefit to using a 3rd party paid tool like browserHawk since they keep it up to date. I'll take another look at it... Brook -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: March-19-12 11:10 AM To: cf-talk Subject: Re: Browser and OS detection with CF On Mon, Mar 19, 2012 at 1:00 PM, Russ Michaels r...@michaels.me.uk wrote: http://www.cyscape.com/ used to be written in CF, dunno if it still is. I haven't used it in years, but BrowserHawk is kept up to date and is a great solution for this work of thing. If you want things like screen resolution, you're going to have to pick something that runs on the client side, not the server side. No amount of looking at CGI variables is going to get you that information. -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:350482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Migrate back and forth between cf7 and cf8 on IIS
Just set the ISAPI paths at the website level for the CF7 site to point to your CF7 install directory (specifically at the jrun dll's).. Brook -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Sent: March-09-12 8:55 AM To: cf-talk Subject: Re: Migrate back and forth between cf7 and cf8 on IIS What services are running? On Mar 9, 2012 11:47 AM, daniel kessler dani...@umd.edu wrote: In going through my web site configuration - application configuration, I see a bunch of paths that go through ColdFusion8 and end with jrun.dll. Could this be the problem? Will I need to delete these and import the cf7 ones each time I switch? oy. ~| 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:350319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Migrate back and forth between cf7 and cf8 on IIS
Hey Daniel, If you set it at the site level then you should be able to have different settings for each website. Not sure if you would need a bat file to the changes. But you could probably script it by using the connectors that CF comes with (c:\coldfusion7\bin\connectors\IIS_connector.bat) or using some of the code in those bat files and specifying the correct site ID. Note, there are also cfstart.bat and cfstop.bat you could script the whole thing... Brook -Original Message- From: daniel kessler [mailto:dani...@umd.edu] Sent: March-09-12 9:21 AM To: cf-talk Subject: Re: Migrate back and forth between cf7 and cf8 on IIS Just set the ISAPI paths at the website level for the CF7 site to point to your CF7 install directory (specifically at the jrun dll's).. ok, that worked. Thank you very much. Is that the sort of thing that can be adjusted using a .bat file? I don't know much about them. However, I'm trying to make switching between these two environments as easy as possible. I appreciate the assistance everyone. daniel ~| 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:350332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
JSON Encoding Bug
I just want to say I think that it is seriously lame that Adobe has not fixed the encoding issues with serializeJSON() converting 'yes' / 'no' to true/false. Yes, you can append as string and then convert it back afterwards and all that, but that's just adding extra processing overhead and hoakiness(?), and this bug has been around for so long - its now officially annoying. Sorry, I know, I'm just ranting. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Zen Desk Single Sign On
Just about to work on getting the Single Sign on for ZenDesk working this weekend. Before I start I thought I would check if any one had already done it and had any code they wanted to share? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Zen Desk Single Sign On
Well, it was super easy to implement! I just created a page on my server called zendesk_auth.cfm. Zendesk sends login requests here and I send back a response after logging the user in, or if the user is already logged in. In my code, if a user is not logged in I redirect to a login page which sends them back to zendesk after authentication (you have to pass around the timestamp and return_to values to send back). This is basically the code I used, I didn't include my login page and login check, but that's pretty simple... !--- zendesk_auth.lf Description: Called from zendesk when a user attempts to log in at zendesk. Check if the user is already logged in here and send that info to zendesk or show the login page (zendesk themed) and let them log in here and redirect to zendesk Parameters: @param {String} url.return_to The url to return to @param {Number} url.locale_id @param {Number} url.timestamp --- cfparam name=url.timestamp default= cfparam name=url.return_to default= cfset sToken= application.gs.zendesk_sharedsecret !--- you get this from zendesk --- cfset sUrl = '' cfset sMessage = '' cfset sDigest = '' !--- user is logged in send back to zendesk --- cfif structKeyExists(client,'isLoggedIn') !--- create auth string and send back to zen desk --- cfset sMessage = client.name client.username sToken url.timestamp cfset sDigest = hash(sMessage) !--- and the url --- cfset sUrl = url.return_to '?name=' urlencodedformat(client.name) 'email=' urlencodedformat(client.username) 'timestamp=' url.timestamp 'hash=' sDigest !--- redirect back to ZenDesk --- cflocation url=#sUrl# /cfif !--- not logged in, show login screen --- cfinclude template=zendesk_login.lf -Original Message- From: Brook Davies [mailto:br...@logiforms.com] Sent: March-02-12 3:35 PM To: cf-talk Subject: Zen Desk Single Sign On Just about to work on getting the Single Sign on for ZenDesk working this weekend. Before I start I thought I would check if any one had already done it and had any code they wanted to share? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Application Mappings RE: Ram Disk problem under load
So we ran a load test last night with 100 concurrent users. Everything went fine *except* this ram disk problem and another problem with a missing template include. Looking at it closer, both errors Could not find the included template used application mappings to do the include. These are defined in the application.cfc: cfcomponent output=false extends=coldfireApplication cfset this.name= 'YourMama' cfset this.mappings[ /publicroot ] = webroot 'web\public\' / cfset this.mappings[ /ram ] = ram:// / /cfcomponent Cf 8.01 had a hotfix that was supposed to fix custom tag path mappings acting up under load: http://kb2.adobe.com/cps/529/cpsid_52915.html 73761 Fix for the error Cannot find CFML template for custom tag thrown under load when using THIS.customtagpath in application.cfc and enable per app settings is enabled. But I am running CF 9.01 with all the hotfixes. BTW, I dumped the ram disk after some failed includes and the file *did exist* on the ram disk. -- I just did another load test this morning, however this time the load was all done on a single application testing a form submission process (this is where the include error was generated). No errors this time. The difference between this test and the last test that generated lots of errors is that this test did not run concurrent load on the other side of this application which uses an application.cfc that extends the main application.cfc via applicationProxy.cfc. Its a child application that shares the main applications name and scope but also enables client variables and does some other stuff (pseudo code below) cfcomponent output=false extends=ApplicationProxy cfset this.clientManagement= true cfset this.setClientCookies= true cfset this.setDomainCookies= true cfset this.clientStorage= 'LF-CLIENTVARS' !--- NO MAPPINGS HERE LIKE IN THE MAIN APPLICATION.CFC. COULD THAT BE THE PROBLEM?? --- cffunction name=onRequestStart returnType=boolean output=false cfargument name=thePage type=string required=true cfset super.onRequestStart(arguments.thePage) cfreturn true /cffunction /cfcomponent --- So my guess is that because it doesn't include the application mappings that it is somehow overwriting them when two requests run at the same time. Strange I know, but thats the best I can figure. I am gonna run another load test tomorrow night, and try adding the mappings into the child application and see if that helps. Brook -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: February-22-12 12:30 PM To: cf-talk Subject: RE: Ram Disk problem under load Hi Raymond, I don't see your reply actually... oh here it is in my junk folder...g... Tonight when the load test is running, I'll pause midway and swap in a real file path and see how that runs. The only other thing I can think is that there is a name collision and the file is deleted by another thread who was using the same filename. But the filename variable IS var scoped (FYI, this IS inside an application scoped CFC). Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: February-22-12 11:38 AM To: cf-talk Subject: Re: Ram Disk problem under load Noticed you didn't reply to my idea... can you also ensure that it really is a VFS issue by simply switching to a real folder - just for testing? On Wed, Feb 22, 2012 at 12:05 PM, Brook Davies cft...@logiforms.com wrote: Good idea, I'll check the contents of the ram disk after any failures... Brook -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: February-22-12 9:58 AM To: cf-talk Subject: Re: Ram Disk problem under load Hi Brook, Certainly you will want to have a try / catch around that, you could put the delete of the ram file in a cffinally tag to ensure it runs, otherwise if an error is thrown in the cfinclude the file never gets deleted and stays in ram. Also to answer your question about the garbage collection, I don't think that would be the issue, the garbage collector only removes objects that have a reference count of zero, I would assume that when you have a file on the ram disk ColdFusion maintains a reference to it, when you delete the file CF will delete the reference and allow the GC to cleanup. I don't think reducing the size of your ram disk will make the problem go away. What you might want to do is run this after you run your load test to see whats in there: cfdirectory directory=ram:// action=list recurse=true name=dir cfdump variable=#dir# -- 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 Wed, Feb 22, 2012 at 12:44 PM, Brook Davies cft
RE: Application Mappings RE: Ram Disk problem under load
Nope, no code that called onApplicationStop() at all... -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: February-23-12 10:36 AM To: cf-talk Subject: Re: Application Mappings RE: Ram Disk problem under load Do you have code that calls ApplicationStop() on error or something I wonder if that might cause the application scoped mappings to be undefined for a split second while the application is reloading? Just a guess. On Thu, Feb 23, 2012 at 1:10 PM, Brook Davies cft...@logiforms.com wrote: So we ran a load test last night with 100 concurrent users. Everything went fine *except* this ram disk problem and another problem with a missing template include. Looking at it closer, both errors Could not find the included template used application mappings to do the include. These are defined in the application.cfc: cfcomponent output=false extends=coldfireApplication cfset this.name= 'YourMama' cfset this.mappings[ /publicroot ] = webroot 'web\public\' / cfset this.mappings[ /ram ] = ram:// / /cfcomponent Cf 8.01 had a hotfix that was supposed to fix custom tag path mappings acting up under load: http://kb2.adobe.com/cps/529/cpsid_52915.html 73761 Fix for the error Cannot find CFML template for custom tag thrown under load when using THIS.customtagpath in application.cfc and enable per app settings is enabled. But I am running CF 9.01 with all the hotfixes. BTW, I dumped the ram disk after some failed includes and the file *did exist* on the ram disk. -- I just did another load test this morning, however this time the load was all done on a single application testing a form submission process (this is where the include error was generated). No errors this time. The difference between this test and the last test that generated lots of errors is that this test did not run concurrent load on the other side of this application which uses an application.cfc that extends the main application.cfc via applicationProxy.cfc. It's a child application that shares the main applications name and scope but also enables client variables and does some other stuff (pseudo code below) cfcomponent output=false extends=ApplicationProxy cfset this.clientManagement= true cfset this.setClientCookies= true cfset this.setDomainCookies= true cfset this.clientStorage= 'LF-CLIENTVARS' !--- NO MAPPINGS HERE LIKE IN THE MAIN APPLICATION.CFC. COULD THAT BE THE PROBLEM?? --- cffunction name=onRequestStart returnType=boolean output=false cfargument name=thePage type=string required=true cfset super.onRequestStart(arguments.thePage) cfreturn true /cffunction /cfcomponent --- So my guess is that because it doesn't include the application mappings that it is somehow overwriting them when two requests run at the same time. Strange I know, but that's the best I can figure. I am gonna run another load test tomorrow night, and try adding the mappings into the child application and see if that helps. Brook -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: February-22-12 12:30 PM To: cf-talk Subject: RE: Ram Disk problem under load Hi Raymond, I don't see your reply actually... oh here it is in my junk folder...g... Tonight when the load test is running, I'll pause midway and swap in a real file path and see how that runs. The only other thing I can think is that there is a name collision and the file is deleted by another thread who was using the same filename. But the filename variable IS var scoped (FYI, this IS inside an application scoped CFC). Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: February-22-12 11:38 AM To: cf-talk Subject: Re: Ram Disk problem under load Noticed you didn't reply to my idea... can you also ensure that it really is a VFS issue by simply switching to a real folder - just for testing? On Wed, Feb 22, 2012 at 12:05 PM, Brook Davies cft...@logiforms.com wrote: Good idea, I'll check the contents of the ram disk after any failures... Brook -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: February-22-12 9:58 AM To: cf-talk Subject: Re: Ram Disk problem under load Hi Brook, Certainly you will want to have a try / catch around that, you could put the delete of the ram file in a cffinally tag to ensure it runs, otherwise if an error is thrown in the cfinclude the file never gets deleted and stays in ram. Also to answer your question about the garbage collection, I don't think that would be the issue, the garbage collector only removes objects that have a reference count of zero, I would assume that when you have a file on the ram disk ColdFusion maintains
RE: Application Mappings RE: Ram Disk problem under load
Whats the best way to contact Adobe Support? -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: February-23-12 10:51 AM To: cf-talk Subject: Re: Application Mappings RE: Ram Disk problem under load I'd suggest pinging Adobe support. You are right - this is something that was fixed. But it sounds like you have a -very- reproduceable case, which makes it easier for them to fix. On Thu, Feb 23, 2012 at 12:36 PM, Pete Freitag p...@foundeo.com wrote: Do you have code that calls ApplicationStop() on error or something I wonder if that might cause the application scoped mappings to be undefined for a split second while the application is reloading? Just a guess. ~| 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:350080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Ram Disk problem under load
Hey everyone, Did some very light pre-load testing yesterday in preparation for a larger test tomorrow. This limited load threw some errors. I'm writing to the in memory file system some CFML code, that I then cfinclude to execute it. Its pretty straight forward code, and this was under very little load (10 concurrent users only). Note: I have an application mapping for the ram disk in application.cfc: cfset this.mappings[ /ram ] = ram:// / And then in the problem code: - !--- set the filename to a unique name --- cfset filename = 'wildcardparsing-#createUUID()#.cfm' !--- write the file --- cffile action=write output=#cfml# file=ram://#filename#/ !--- include and execute the cfml --- cfinclude template=/ram/#filename# / !--- clean up --- cffile action=delete file=ram://#filename#/ - The error I got was: Could not find the included template /ram/wildcardparsing-66031760-EEDC-69FB-8F2EFEC77564096A.cfm. I got a similar error in another template on a different execution that uses similar code to generate the CFML for a CFDOCUMENT tag and then writes it to ram disk and includes. I have never seen this error in development it only started happening under a wee bit of load. What could be the problem? The In memory file system is set to 500 megs in the cfadmin (which is probably overkill..). Would a garbage collection before the include had been completed cause this to happen? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Ram Disk problem under load
Hi Pete, I don't think its possible because the ram disk size is set to 500 megs, and this was only 10 concurrent users! I have another test with 100 cuncurrent users running tonight and I guess we'll see what happens though I am sure this is going to be an issue. I added a try/catch around the write/read and am them attempting to do it again, so I guess we'll see what happens. Maybe I should reduce the size allocated to the ram disk? Brook -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: February-22-12 9:35 AM To: cf-talk Subject: Re: Ram Disk problem under load Another thing to consider is that the Ram disk has a size limit specified in the ColdFusion administrator. Is it possible that the write failed (perhaps silently) because the ram disk was full. -- 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 Wed, Feb 22, 2012 at 3:12 AM, Brook Davies cft...@logiforms.com wrote: Hey everyone, Did some very light pre-load testing yesterday in preparation for a larger test tomorrow. This limited load threw some errors. I'm writing to the in memory file system some CFML code, that I then cfinclude to execute it. Its pretty straight forward code, and this was under very little load (10 concurrent users only). Note: I have an application mapping for the ram disk in application.cfc: cfset this.mappings[ /ram ] = ram:// / And then in the problem code: - !--- set the filename to a unique name --- cfset filename = 'wildcardparsing-#createUUID()#.cfm' !--- write the file --- cffile action=write output=#cfml# file=ram://#filename#/ !--- include and execute the cfml --- cfinclude template=/ram/#filename# / !--- clean up --- cffile action=delete file=ram://#filename#/ - The error I got was: Could not find the included template /ram/wildcardparsing-66031760-EEDC-69FB-8F2EFEC77564096A.cfm. I got a similar error in another template on a different execution that uses similar code to generate the CFML for a CFDOCUMENT tag and then writes it to ram disk and includes. I have never seen this error in development it only started happening under a wee bit of load. What could be the problem? The In memory file system is set to 500 megs in the cfadmin (which is probably overkill..). Would a garbage collection before the include had been completed cause this to happen? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Ram Disk problem under load
Good idea, I'll check the contents of the ram disk after any failures... Brook -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: February-22-12 9:58 AM To: cf-talk Subject: Re: Ram Disk problem under load Hi Brook, Certainly you will want to have a try / catch around that, you could put the delete of the ram file in a cffinally tag to ensure it runs, otherwise if an error is thrown in the cfinclude the file never gets deleted and stays in ram. Also to answer your question about the garbage collection, I don't think that would be the issue, the garbage collector only removes objects that have a reference count of zero, I would assume that when you have a file on the ram disk ColdFusion maintains a reference to it, when you delete the file CF will delete the reference and allow the GC to cleanup. I don't think reducing the size of your ram disk will make the problem go away. What you might want to do is run this after you run your load test to see whats in there: cfdirectory directory=ram:// action=list recurse=true name=dir cfdump variable=#dir# -- 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 Wed, Feb 22, 2012 at 12:44 PM, Brook Davies cft...@logiforms.com wrote: Hi Pete, I don't think its possible because the ram disk size is set to 500 megs, and this was only 10 concurrent users! I have another test with 100 cuncurrent users running tonight and I guess we'll see what happens though I am sure this is going to be an issue. I added a try/catch around the write/read and am them attempting to do it again, so I guess we'll see what happens. Maybe I should reduce the size allocated to the ram disk? Brook -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: February-22-12 9:35 AM To: cf-talk Subject: Re: Ram Disk problem under load Another thing to consider is that the Ram disk has a size limit specified in the ColdFusion administrator. Is it possible that the write failed (perhaps silently) because the ram disk was full. -- 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 Wed, Feb 22, 2012 at 3:12 AM, Brook Davies cft...@logiforms.com wrote: Hey everyone, Did some very light pre-load testing yesterday in preparation for a larger test tomorrow. This limited load threw some errors. I'm writing to the in memory file system some CFML code, that I then cfinclude to execute it. Its pretty straight forward code, and this was under very little load (10 concurrent users only). Note: I have an application mapping for the ram disk in application.cfc: cfset this.mappings[ /ram ] = ram:// / And then in the problem code: - !--- set the filename to a unique name --- cfset filename = 'wildcardparsing-#createUUID()#.cfm' !--- write the file --- cffile action=write output=#cfml# file=ram://#filename#/ !--- include and execute the cfml --- cfinclude template=/ram/#filename# / !--- clean up --- cffile action=delete file=ram://#filename#/ - The error I got was: Could not find the included template /ram/wildcardparsing-66031760-EEDC-69FB-8F2EFEC77564096A.cfm. I got a similar error in another template on a different execution that uses similar code to generate the CFML for a CFDOCUMENT tag and then writes it to ram disk and includes. I have never seen this error in development it only started happening under a wee bit of load. What could be the problem? The In memory file system is set to 500 megs in the cfadmin (which is probably overkill..). Would a garbage collection before the include had been completed cause this to happen? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Ram Disk problem under load
Hi Raymond, I don't see your reply actually... oh here it is in my junk folder...g... Tonight when the load test is running, I'll pause midway and swap in a real file path and see how that runs. The only other thing I can think is that there is a name collision and the file is deleted by another thread who was using the same filename. But the filename variable IS var scoped (FYI, this IS inside an application scoped CFC). Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: February-22-12 11:38 AM To: cf-talk Subject: Re: Ram Disk problem under load Noticed you didn't reply to my idea... can you also ensure that it really is a VFS issue by simply switching to a real folder - just for testing? On Wed, Feb 22, 2012 at 12:05 PM, Brook Davies cft...@logiforms.com wrote: Good idea, I'll check the contents of the ram disk after any failures... Brook -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: February-22-12 9:58 AM To: cf-talk Subject: Re: Ram Disk problem under load Hi Brook, Certainly you will want to have a try / catch around that, you could put the delete of the ram file in a cffinally tag to ensure it runs, otherwise if an error is thrown in the cfinclude the file never gets deleted and stays in ram. Also to answer your question about the garbage collection, I don't think that would be the issue, the garbage collector only removes objects that have a reference count of zero, I would assume that when you have a file on the ram disk ColdFusion maintains a reference to it, when you delete the file CF will delete the reference and allow the GC to cleanup. I don't think reducing the size of your ram disk will make the problem go away. What you might want to do is run this after you run your load test to see whats in there: cfdirectory directory=ram:// action=list recurse=true name=dir cfdump variable=#dir# -- 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 Wed, Feb 22, 2012 at 12:44 PM, Brook Davies cft...@logiforms.com wrote: Hi Pete, I don't think its possible because the ram disk size is set to 500 megs, and this was only 10 concurrent users! I have another test with 100 cuncurrent users running tonight and I guess we'll see what happens though I am sure this is going to be an issue. I added a try/catch around the write/read and am them attempting to do it again, so I guess we'll see what happens. Maybe I should reduce the size allocated to the ram disk? Brook -Original Message- From: Pete Freitag [mailto:p...@foundeo.com] Sent: February-22-12 9:35 AM To: cf-talk Subject: Re: Ram Disk problem under load Another thing to consider is that the Ram disk has a size limit specified in the ColdFusion administrator. Is it possible that the write failed (perhaps silently) because the ram disk was full. -- 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 Wed, Feb 22, 2012 at 3:12 AM, Brook Davies cft...@logiforms.com wrote: Hey everyone, Did some very light pre-load testing yesterday in preparation for a larger test tomorrow. This limited load threw some errors. I'm writing to the in memory file system some CFML code, that I then cfinclude to execute it. Its pretty straight forward code, and this was under very little load (10 concurrent users only). Note: I have an application mapping for the ram disk in application.cfc: cfset this.mappings[ /ram ] = ram:// / And then in the problem code: - !--- set the filename to a unique name --- cfset filename = 'wildcardparsing-#createUUID()#.cfm' !--- write the file --- cffile action=write output=#cfml# file=ram://#filename#/ !--- include and execute the cfml --- cfinclude template=/ram/#filename# / !--- clean up --- cffile action=delete file=ram://#filename#/ - The error I got was: Could not find the included template /ram/wildcardparsing-66031760-EEDC-69FB-8F2EFEC77564096A.cfm. I got a similar error in another template on a different execution that uses similar code to generate the CFML for a CFDOCUMENT tag and then writes it to ram disk and includes. I have never seen this error in development it only started happening under a wee bit of load. What could be the problem? The In memory file system is set to 500 megs in the cfadmin (which is probably overkill..). Would a garbage collection before the include had been completed cause this to happen? Brook
RE: Fusion Reactor and Fusion Analytics Kick Ass
My thoughts exactly... -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: February-20-12 8:24 AM To: cf-talk Subject: Re: Fusion Reactor and Fusion Analytics Kick Ass On Sun, Feb 19, 2012 at 10:03 AM, Dan Baughman dan.baugh...@gmail.com wrote: Thats great, but I guess outside of being cool none of that really provides any value. Have you even looked at FusionReactor and FusionAnalytics? I find it _incredible_ you would say these tools don't provide any value, but I guess to each his own. -Ray ~| 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:349965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Fusion Reactor and Fusion Analytics Kick Ass
Hi Dan, That wasn't a good example, and no it doesn't take a CF tool to determin a server reboot. However, this was a brand new server install that didn't have any monitoring services setup (which would notify me of a restart etc). Sure, I could have looked in the event viewer or other logs, but that wasn't really the point of my comment. The fact that I was able to see a spike in CPU usage (when my otherwise dormant application server was re-initializing) , click on it and see the exact CF log file entries at that time (which showed the restart) is useful and more than just cool. Plus that is just one of the options to inspect at any point of the graph. Fusion Analytics can pull up all of the JDBC requests at that time, and like I said, a ton of other useful information. I don't see how that's not of value and I have been administrating CF servers for over 10 years without the help of FR/FA . **For me** it is of value and makes my job that much easier. Brook -Original Message- From: Dan Baughman [mailto:dan.baugh...@gmail.com] Sent: February-19-12 8:03 AM To: cf-talk Subject: Re: Fusion Reactor and Fusion Analytics Kick Ass Thats great, but I guess outside of being cool none of that really provides any value. It shouldn't take a Coldfusion tool to determine your server is rebooting at 3AM. On Fri, Feb 17, 2012 at 3:31 PM, Brook Davies cft...@logiforms.com wrote: I just set up fusionAnalytics - its awesome. It really makes fusionReactor that much better. I have a new server setup I am working on, I was looking at the CPU and memory graph today and saw a spike at 3 am on all 3 of our servers. I right clicked on the memory spike and was able to choose from a ton of options from that time period I choice to show the logs (FusionAnalytics stores and indexes/aggregates all the CF logs..) and saw immediately that the CF server was doing a restart. Turns out windows update was set to do automatic updates and automatic restarts on our brand new out the box server. Simple example, and sure, I could have just went through the logs and found this manually, but to be able to see spike in memory/requests/response/jdbc/cpu and just right click the spike and get: JDBC requests at that exact time Threads at that time Log file entries CF Scope sizes System Metrics And more For that exact moment. Priceless :) Brook -Original Message- From: Nick Gleason [mailto:n.glea...@citysoft.com] Sent: February-17-12 2:14 PM To: cf-talk Subject: RE: Fusion Reactor and Fusion Analytics Kick Ass +1 for FusionReactor. We've got but have not yet installed Fusion Analytics. But we're looking forward to that addition as well. Nick PS - also no affiliation with them. . .. ... CitySoft, Inc. | http://www.citysoft.com Phone: (866) 751-1992 | Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less Do More - Community Enterprise combines great features with an affordable price. . .. ... -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: Friday, February 17, 2012 12:19 PM To: cf-talk Subject: Fusion Reactor and Fusion Analytics Kick Ass Hey people, I'm sure most of you already know this, but Fusion Reactor and Fusion Analytics for monitoring CF servers kick some serious ass. I've been a seefusion customer for years, and while it does a decent job its not in the same class as the Fusion Reactor/Analytics Products. This pair of products is phenomenal and give you incredible insight into your CF server. If you're a CF sys admin, you really want to check em out. I have absolutely zero affiliation with the company, I just bought and setup 3 licenses and am so happy with it, that I wanted to share how great they are. I've had them running for a few days and they have already helped resolve problems. Now for the load testing J Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Fusion Reactor and Fusion Analytics Kick Ass
Hey people, I'm sure most of you already know this, but Fusion Reactor and Fusion Analytics for monitoring CF servers kick some serious ass. I've been a seefusion customer for years, and while it does a decent job its not in the same class as the Fusion Reactor/Analytics Products. This pair of products is phenomenal and give you incredible insight into your CF server. If you're a CF sys admin, you really want to check em out. I have absolutely zero affiliation with the company, I just bought and setup 3 licenses and am so happy with it, that I wanted to share how great they are. I've had them running for a few days and they have already helped resolve problems. Now for the load testing J Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Fusion Reactor and Fusion Analytics Kick Ass
I just set up fusionAnalytics - its awesome. It really makes fusionReactor that much better. I have a new server setup I am working on, I was looking at the CPU and memory graph today and saw a spike at 3 am on all 3 of our servers. I right clicked on the memory spike and was able to choose from a ton of options from that time period I choice to show the logs (FusionAnalytics stores and indexes/aggregates all the CF logs..) and saw immediately that the CF server was doing a restart. Turns out windows update was set to do automatic updates and automatic restarts on our brand new out the box server. Simple example, and sure, I could have just went through the logs and found this manually, but to be able to see spike in memory/requests/response/jdbc/cpu and just right click the spike and get: JDBC requests at that exact time Threads at that time Log file entries CF Scope sizes System Metrics And more For that exact moment. Priceless :) Brook -Original Message- From: Nick Gleason [mailto:n.glea...@citysoft.com] Sent: February-17-12 2:14 PM To: cf-talk Subject: RE: Fusion Reactor and Fusion Analytics Kick Ass +1 for FusionReactor. We've got but have not yet installed Fusion Analytics. But we're looking forward to that addition as well. Nick PS - also no affiliation with them. . ... CitySoft, Inc. | http://www.citysoft.com Phone: (866) 751-1992 | Direct: (617) 899-5395 | Fax: (617) 507-0444 Spend Less Do More - Community Enterprise combines great features with an affordable price. . ... -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: Friday, February 17, 2012 12:19 PM To: cf-talk Subject: Fusion Reactor and Fusion Analytics Kick Ass Hey people, I'm sure most of you already know this, but Fusion Reactor and Fusion Analytics for monitoring CF servers kick some serious ass. I've been a seefusion customer for years, and while it does a decent job its not in the same class as the Fusion Reactor/Analytics Products. This pair of products is phenomenal and give you incredible insight into your CF server. If you're a CF sys admin, you really want to check em out. I have absolutely zero affiliation with the company, I just bought and setup 3 licenses and am so happy with it, that I wanted to share how great they are. I've had them running for a few days and they have already helped resolve problems. Now for the load testing J Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Load Testing - what to look for and monitor/report
Hi Dave, We're doing performance analysis and looking for bottlenecks and also memory leaks since we have a lot of application scoped components and large numbers of objects created per request. That's one of my main concerns actually.. Brook -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: February-11-12 7:46 AM To: cf-talk Subject: Re: Load Testing - what to look for and monitor/report Anyhow, what I really want to know from you experts is what should I be watching and recording during these load tests? Generally, you're interested in response time and throughput. Also should I pair down from a load balanced solution to a single server to make it easier to debug log files and track memory etc? And then scale up after a specific duration? Or for the second test interval? I don't have much experience with load testing and just want to make sure that this is money well spend in terms of having some actionable data. It's hard to answer this without more information. What is the goal of the load test? What kind of actionable data are you looking for? You can use load tests to answer a couple of different questions. There are two basic types of load test: performance analysis, and capacity planning. In a performance analysis test, you're looking for bottlenecks in your application with the goal of improving application performance. In a capacity planning test, you're trying to identify how many users your application can support as it's currently written. Which one of these are you doing? 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:349863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Load Testing - what to look for and monitor/report
Hey Guys, I am hiring a load testing company, Neustar, to run some load tests on a new cf app and server deployment. I have FusionReactor installed and the platform is CF9 Standard on windows 2008 web server, and the backend is a separate MS SQL box. A beefy one at that J. The server environment is virtualized running on vmware on Dell 610s (in case any one cared..).. Anyhow, what I really want to know from you experts is what should I be watching and recording during these load tests? Also should I pair down from a load balanced solution to a single server to make it easier to debug log files and track memory etc? And then scale up after a specific duration? Or for the second test interval? I don't have much experience with load testing and just want to make sure that this is money well spend in terms of having some actionable data. Thank yo! Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Accessing the Application Scope of another App
Hi, Can you guys tell me if this is bad practice or will lead to memory issues. I have a CF app that has the main app and an admin module, each with their own cfapplication, and application namepace. From within the admin app I need to clear some application scoped data in the main app. I do something like this: cffunction.. cfif application.applicationName is COREAPP cfset local.appScopeReference = application cfelse cfset local.appScopeReference = createObject(java,coldfusion.runtime.ApplicationScopeTracker) ..getApplicationScope('COREAPP') /cfif cflock scope=application type=exclusive cfset structDelete(local.appScopeReference,'somekey') /cflock /cffunction Is there gonna be an issues with dumping the app scope into a local variable like this? Or something else? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Were to store admin passwords?
This is a bit OT, but I'm starting to get paranoid. Where is the best place to store server administrator account password and passwords for the cfadministrator etc. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFFILE to \\tsclient\c$\
Hi Andrew, Essentially, yes. I want the remote CF server that I am connecting to via RDP to write a file to my local filesystem. I can access the local file system using \\tsclient, so I thought CF, provided it has permissions, would be able to aswell. But it doesn't look like its gonna happen Brook -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: January-29-12 10:02 PM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ Are you saying that you are using a Remote Desktop Client to connect to the server, and you want ColdFusion to be able to access the remote drive resource of that RDC? I don't think that it is permissible under any circumstances, and the OS will not see the remote resourced drive as this is something that the RDC can only see. I maybe wrong. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Mon, Jan 30, 2012 at 4:52 PM, Brook Davies cft...@logiforms.com wrote: Hi AJ, I am doing that - have you done this successfully? Brook -Original Message- From: AJ Mercer [mailto:ajmer...@gmail.com] Sent: January-29-12 5:25 PM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ you will need to run your CF services with a named account and that account will need access permissions to that share On 30 January 2012 09:17, Brook Davies br...@logiforms.com wrote: Anybody ever tried to call CFFILE or CFDIRECTORY to a connected RDP session? I'm getting an access denied error even though I have added the cf account on my local box. Maybe this is just not possible? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFFILE to \\tsclient\c$\
Hi Andrew, That's make sense, thanks. The reason I wanted to be able to do this is to be able to automate the transfer of some objects from the server to my local development environment. Basically on my site clients can build forms. The form, on the backend is a series of database records with JSON encoded objects and some related file resources. I wanted to be able to automate the transfer of a form that a user was getting errors on in the form designer to my local database and filesystem in order to do debugging on It and re-create the problem. I can't just copy the DB rows because of the file structure and files that are integrated with the form object... Brook -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: January-30-12 8:28 AM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ That's because you are doing it from the RDC, due to security reasons you are in a session that is allowed this. But if you were to physically go to the machine / server you would not be able to see your machine this way. Now this is where I could be wrong, because my understanding is that if this was allowed that means any other session, or the server could potentially open up more security implications. And as ColdFusion is running well before your RDC session starts, then there will be no way ColdFusion or any other system outside of your RDC session can access your drives. So the next question, is why would you want ColdFusion to be able to access your drive over an RDC session? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jan 31, 2012 at 2:59 AM, Brook Davies cft...@logiforms.com wrote: Hi Andrew, Essentially, yes. I want the remote CF server that I am connecting to via RDP to write a file to my local filesystem. I can access the local file system using \\tsclient, so I thought CF, provided it has permissions, would be able to aswell. But it doesn't look like its gonna happen Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFFILE to \\tsclient\c$\
Yeah, that's an option, I could create a zip file.. really though this system is intended to transfer the objects from a production server to another server used specifically for debugging. So I wanted to leverage the same code base that used UNC file paths to copy the data. Being able to plugin my localhost as a list of available servers to copy the data to would have been nice, but its not a 100% requirement. Brook -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: January-30-12 9:31 AM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ Why don't you just get ColdFusion to generate what you want to transfer, to a file and when you RDC just add a resource to your RDC settings for a drive on your machine, then just copy this file to your resourced drive manually? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jan 31, 2012 at 4:17 AM, Brook Davies cft...@logiforms.com wrote: Hi Andrew, That's make sense, thanks. The reason I wanted to be able to do this is to be able to automate the transfer of some objects from the server to my local development environment. Basically on my site clients can build forms. The form, on the backend is a series of database records with JSON encoded objects and some related file resources. I wanted to be able to automate the transfer of a form that a user was getting errors on in the form designer to my local database and filesystem in order to do debugging on It and re-create the problem. I can't just copy the DB rows because of the file structure and files that are integrated with the form object... Brook -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: January-30-12 8:28 AM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ That's because you are doing it from the RDC, due to security reasons you are in a session that is allowed this. But if you were to physically go to the machine / server you would not be able to see your machine this way. Now this is where I could be wrong, because my understanding is that if this was allowed that means any other session, or the server could potentially open up more security implications. And as ColdFusion is running well before your RDC session starts, then there will be no way ColdFusion or any other system outside of your RDC session can access your drives. So the next question, is why would you want ColdFusion to be able to access your drive over an RDC session? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jan 31, 2012 at 2:59 AM, Brook Davies cft...@logiforms.com wrote: Hi Andrew, Essentially, yes. I want the remote CF server that I am connecting to via RDP to write a file to my local filesystem. I can access the local file system using \\tsclient, so I thought CF, provided it has permissions, would be able to aswell. But it doesn't look like its gonna happen Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFFILE to \\tsclient\c$\
I do? Why? -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: January-30-12 10:11 AM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ Sounds like you need a better debugging strategy then. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jan 31, 2012 at 5:01 AM, Brook Davies cft...@logiforms.com wrote: Yeah, that's an option, I could create a zip file.. really though this system is intended to transfer the objects from a production server to another server used specifically for debugging. So I wanted to leverage the same code base that used UNC file paths to copy the data. Being able to plugin my localhost as a list of available servers to copy the data to would have been nice, but its not a 100% requirement. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFFILE to \\tsclient\c$\
Hey Andrew, I do use redgate (love it!), but I need to be able to transfer objects from a number of tables, and there is also lots of JSON encoded data that itself contains id references from other records and file path references for media. Also, for each 'object' there is a specific directory structure and supplemental files. Its hella complicated :( Anyhow, I already wrote the code to copy the forms and its really multipurpose as customers often ask to transfer/copy forms between accounts aswell. So now we can do that via a web ui, and also port a problematic form to our debugging server where we can replay their failed commit (we store the commit array which describes each change made before saving) and find where the problem is. Brook -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: January-30-12 11:02 AM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ Because of your comment this system is intended to transfer the objects from a production server to another server used specifically for debugging , I think there has to be a better way to sync and debug than what you're doing. I mean why can't you use red-gate for MS SQL server sync and beyond compare for files, to your testing environment? Or even backup your database and transfer it to your testing server, and restore the database to a local SQL Server, and file sync the files. Just throwing some ideas out there, as I do not know much about your situation. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jan 31, 2012 at 5:53 AM, Brook Davies cft...@logiforms.com wrote: I do? Why? -Original Message- From: Andrew Scott [mailto:andr...@andyscott.id.au] Sent: January-30-12 10:11 AM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ Sounds like you need a better debugging strategy then. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jan 31, 2012 at 5:01 AM, Brook Davies cft...@logiforms.com wrote: Yeah, that's an option, I could create a zip file.. really though this system is intended to transfer the objects from a production server to another server used specifically for debugging. So I wanted to leverage the same code base that used UNC file paths to copy the data. Being able to plugin my localhost as a list of available servers to copy the data to would have been nice, but its not a 100% requirement. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFFILE to \\tsclient\c$\
Anybody ever tried to call CFFILE or CFDIRECTORY to a connected RDP session? I'm getting an access denied error even though I have added the cf account on my local box. Maybe this is just not possible? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFFILE to \\tsclient\c$\
Hi AJ, I am doing that - have you done this successfully? Brook -Original Message- From: AJ Mercer [mailto:ajmer...@gmail.com] Sent: January-29-12 5:25 PM To: cf-talk Subject: Re: CFFILE to \\tsclient\c$\ you will need to run your CF services with a named account and that account will need access permissions to that share On 30 January 2012 09:17, Brook Davies br...@logiforms.com wrote: Anybody ever tried to call CFFILE or CFDIRECTORY to a connected RDP session? I'm getting an access denied error even though I have added the cf account on my local box. Maybe this is just not possible? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Best Practice question about database access between Dev and Production Servers
Hello, I'm setting up a new environment and I would like to have the ability, through a web UI to copy objects from our production database (separate server) to a development/debugging database (separate server). My question is not about how to implement this but rather whether this is bad practice. It would involve exposing the production database on the dev server (via a datasource mapping in the cfadmin). This would mean that any developer that is using our dev server (my concern is contractors..) would be able to write a query against the production database and potentially download sensitive data. How to people handle this type of risk? One idea I had was to not hardcode the database username/password in the CFadmin and instead prompt for it when accessing this specific tool through the web UI. Does that sound like a reasonable means of protecting the data in the production database from developers working on the development server? Anybody have better ideas? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Way OT: Funny video
Its Friday, so don't hate: If you haven't seen this, you need to. Its an oldie but a goody: http://www.youtube.com/watch?v=zV0OgsRK0Bc Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349650 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: [ANNOUNCE] CF-FireLogger
Looks cool! I'm gonna try it -Original Message- From: Max Paperno [mailto:m...@wdg.us] Sent: January-26-12 2:25 PM To: cf-talk Subject: [ANNOUNCE] CF-FireLogger Hello all, Please pardon the interruption but CF-Community is high on politics and low on CF content. I haven't posted to this list in at least 10 years, so I might be out of practice :) CF-FireLogger is a ColdFusion server-side library for the FireLogger (http://firelogger.binaryage.com) Firebug extension. It enables logging of information from within ColdFusion code directly to the Firebug/FireLogger console. Think of it as the equivalent of JavaScript console.log() but for your CF apps. An optional feature allows viewing of ColdFusions debugging information in the console instead of inline. CF-FireLogger is a great debugging tool for any situation, and is especially useful for AJAX style applications where showing debug info inline isn't always an option. CF-FireLogger can be used as a standalone feature, or integrated with CFs built-in cftrace/trace() commands. CF-FireLogger can be used alongside the ColdFire debugging output console, or as a replacement. More details available here: http://www.wdg.us/cf-firelogger Get the code: https://github.com/mpaperno/CF-FireLogger Or at RIA Forge: http://cffirelogger.riaforge.org/ Cheers, -Max ~| 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:349634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: [ANNOUNCE] CF-FireLogger
Hey Max, Got it installed (painless) and it looks cool. What I am wondering is it seems like you advocate using trace() instead of console(). And it sounds like if firebug/firelogger is not enabled, that no debugging output would be sent. Is that true? If so, is there a performance penalty to using this on a production server to track a bug? Wouldn't any client that does not have the firebug/firelogger combo and their IP added to the CF debugging IP list not get any additional overhead? Does the trace tag have overhead when debugging is not enabled? Just some thoughts Thanks again for a very cool extension and contribution to the community! Brook -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: January-26-12 9:16 PM To: cf-talk Subject: RE: [ANNOUNCE] CF-FireLogger Looks cool! I'm gonna try it -Original Message- From: Max Paperno [mailto:m...@wdg.us] Sent: January-26-12 2:25 PM To: cf-talk Subject: [ANNOUNCE] CF-FireLogger Hello all, Please pardon the interruption but CF-Community is high on politics and low on CF content. I haven't posted to this list in at least 10 years, so I might be out of practice :) CF-FireLogger is a ColdFusion server-side library for the FireLogger (http://firelogger.binaryage.com) Firebug extension. It enables logging of information from within ColdFusion code directly to the Firebug/FireLogger console. Think of it as the equivalent of JavaScript console.log() but for your CF apps. An optional feature allows viewing of ColdFusions debugging information in the console instead of inline. CF-FireLogger is a great debugging tool for any situation, and is especially useful for AJAX style applications where showing debug info inline isn't always an option. CF-FireLogger can be used as a standalone feature, or integrated with CFs built-in cftrace/trace() commands. CF-FireLogger can be used alongside the ColdFire debugging output console, or as a replacement. More details available here: http://www.wdg.us/cf-firelogger Get the code: https://github.com/mpaperno/CF-FireLogger Or at RIA Forge: http://cffirelogger.riaforge.org/ Cheers, -Max ~| 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:349635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: [ANNOUNCE] CF-FireLogger
Hey Max, I set everything up according to the docs. I can see the output in firelogger when I do this: cfscript console = new firelogger(debugMode=false, debugLevel=info, fallbackLogMethod=trace-inline); console.log(arguments.commitArray); /cfscript But when I try this: cftrace var=commitArray type=information text=Starting FormArray Commit category=FormModel Update,silver,black inline=false abort=false I get an error: Variable DEBUGGER is undefined. StackTrace coldfusion.runtime.UndefinedVariableException: Variable DEBUGGER is undefined. at coldfusion.runtime.CfJspPage._get(CfJspPage.java:377) at coldfusion.runtime.CfJspPage._get(CfJspPage.java:339) at cftrace2ecfm1786375826.runPage(E:\cf9_final\cfusion\wwwroot\WEB-INF\cftags\t race.cfm:194) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cftrace2ecfm2140486297$funcDOTRACE.runFunction(C:\ColdFusion9\wwwroot\WEB-IN F\cftags\trace.cfm:232) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java: 368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582) at cftrace2ecfm2140486297._factor1(C:\ColdFusion9\wwwroot\WEB-INF\cftags\trace. cfm:40) at cftrace2ecfm2140486297.runPage(C:\ColdFusion9\wwwroot\WEB-INF\cftags\trace.c fm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java: 56) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfFormDesignController2ecfc2073814296$funcUPDATEFORMMODEL.runFunctio Note, this only happens when I try to call the TRACE() command from within an application scoped CFC. When I run the same command from a simple cfm template, it works as expected. Any idea why? Brook -Original Message- From: Max Paperno [mailto:m...@wdg.us] Sent: January-26-12 2:25 PM To: cf-talk Subject: [ANNOUNCE] CF-FireLogger Hello all, Please pardon the interruption but CF-Community is high on politics and low on CF content. I haven't posted to this list in at least 10 years, so I might be out of practice :) CF-FireLogger is a ColdFusion server-side library for the FireLogger (http://firelogger.binaryage.com) Firebug extension. It enables logging of information from within ColdFusion code directly to the Firebug/FireLogger console. Think of it as the equivalent of JavaScript console.log() but for your CF apps. An optional feature allows viewing of ColdFusions debugging information in the console instead of inline. CF-FireLogger is a great debugging tool for any situation, and is especially useful for AJAX style applications where showing debug info inline isn't always an option. CF-FireLogger can be used as a standalone feature, or integrated with CFs built-in cftrace/trace() commands. CF-FireLogger can be used alongside the ColdFire debugging output console, or as a replacement. More details available here: http://www.wdg.us/cf-firelogger Get the code: https://github.com/mpaperno/CF-FireLogger Or at RIA Forge: http://cffirelogger.riaforge.org/ Cheers, -Max ~| 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:349636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Hide CFC Introspection on Railo
I'm playing around with railo and when I access a CFC directly via a URL, it dumps the CFC methods and details. Is there someway to hide this? Searched the docs and web to no avail.. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349627 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: varScoper menu not shown in CFBUILDER
I appreciate the offer Raymond, but I am okay just running it from the CFM code base directly. Again thanks Jedi! Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: January-19-12 6:31 AM To: cf-talk Subject: Re: varScoper menu not shown in CFBUILDER No idea than - sorry man. You could call Adobe tech support, but I'd assume they would put the blame on the extension. If you want to hop into a Connect room or Google Hangout, let me know. On Wed, Jan 18, 2012 at 10:29 PM, Brook Davies cft...@logiforms.com wrote: Yeah, I can right click on both.. CFB2, yeah. And I see other extensions, I think, like apply CF Nature... Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: January-18-12 6:23 PM To: cf-talk Subject: Re: varScoper menu not shown in CFBUILDER But to be clear, you can right click on a .cfm file in the navigator, just not a folder? CFB2? On Wed, Jan 18, 2012 at 5:10 PM, Brook Davies cft...@logiforms.com wrote: Hi Ray, I do see that bit, inside of some other XML: application namevarScoper/name authorMike Schierberl/author version1.0/version emailm...@schierberl.com/email descriptionintr ~| 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:349546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
varScoper menu not shown in CFBUILDER
Does anyone else have the problem where after installing the varscoper extension to CFbuilder, it is listed as an extension in the extensions window but not available for use via the context menu? I can't figure out how to run it! Other extensions, installed in the same folder ARE Listed in the context menu. Anybody else run into this? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: varScoper menu not shown in CFBUILDER
At the top level CF project folder. It used to be there, but its not there any more. I tried reinstalled the extension and that made no difference. I CAN run varscoper directly however via the CFM files... Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: January-18-12 11:41 AM To: cf-talk Subject: Re: varScoper menu not shown in CFBUILDER Are you right clicking in the navigator? Are you right clicking on a CFM or CFC file? On Wed, Jan 18, 2012 at 12:36 PM, Brook Davies cft...@logiforms.com wrote: Does anyone else have the problem where after installing the varscoper extension to CFbuilder, it is listed as an extension in the extensions window but not available for use via the context menu? I can't figure out how to run it! Other extensions, installed in the same folder ARE Listed in the context menu. Anybody else run into this? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: varScoper menu not shown in CFBUILDER
Hi Ray, I do see that bit, inside of some other XML: application namevarScoper/name authorMike Schierberl/author version1.0/version emailm...@schierberl.com/email descriptionintro.html/description version1.30/version licenselicense.html/license menucontributions contribution target=projectview menu name=varScoper action name=Run varScoper handlerid=varscoper showResponse=true dialog height=600 width=800 / /action /menu /contribution /menucontributions handlers handler id=varscoper type=CFM filename=cfbuilder.cfm / /handlers /application I actually just downloaded and installed it from riaforge aswell, so I dont know either why its not working. Maybe its permissions related Thanks for taking a look! Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: January-18-12 1:34 PM To: cf-talk Subject: Re: varScoper menu not shown in CFBUILDER Odd - I just checked - downloaded from http://varscoper.riaforge.org/, installed, right clicked on a project root, and it showed up as an option. Not sure what to tell you. When you look at the extension's ide_config.xml file, do you see this? menucontributions contribution target=projectview menu name=varScoper action name=Run varScoper handlerid=varscoper showResponse=true dialog height=600 width=800 / /action /menu /contribution /menucontributions On Wed, Jan 18, 2012 at 3:30 PM, Brook Davies cft...@logiforms.com wrote: At the top level CF project folder. It used to be there, but its not there any more. I tried reinstalled the extension and that made no difference. I CAN run varscoper directly however via the CFM files... Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: January-18-12 11:41 AM To: cf-talk Subject: Re: varScoper menu not shown in CFBUILDER Are you right clicking in the navigator? Are you right clicking on a CFM or CFC file? On Wed, Jan 18, 2012 at 12:36 PM, Brook Davies cft...@logiforms.com wrote: Does anyone else have the problem where after installing the varscoper extension to CFbuilder, it is listed as an extension in the extensions window but not available for use via the context menu? I can't figure out how to run it! Other extensions, installed in the same folder ARE Listed in the context menu. Anybody else run into this? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: varScoper menu not shown in CFBUILDER
Yeah, I can right click on both.. CFB2, yeah. And I see other extensions, I think, like apply CF Nature... Brook -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: January-18-12 6:23 PM To: cf-talk Subject: Re: varScoper menu not shown in CFBUILDER But to be clear, you can right click on a .cfm file in the navigator, just not a folder? CFB2? On Wed, Jan 18, 2012 at 5:10 PM, Brook Davies cft...@logiforms.com wrote: Hi Ray, I do see that bit, inside of some other XML: application namevarScoper/name authorMike Schierberl/author version1.0/version emailm...@schierberl.com/email descriptionintr ~| 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:349542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can you ever allocate too much ram to the JVM
Quick Question. On our new server we have lots of ram (32 gigs). Its running CF 9 Standard 64 bit. Is there any downside to allocating 12 gigs of ram to CF? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can you ever allocate too much ram to the JVM
Thanks for the replies. I will have to review the implications of the longer GC with more ram allocated Brook -Original Message- From: Scott Stewart [mailto:webmas...@sstwebworks.com] Sent: January-12-12 2:26 PM To: cf-talk Subject: Re: Can you ever allocate too much ram to the JVM The 64 bit version of windows will address up to a terabyte of phyisical memory, that doesn't mean that you can throw 500 gb at the JVM... garbage collection creates more problems than it solves with large amounts of memory On Jan 12, 2012 5:18 PM, Matt Quackenbush quackfu...@gmail.com wrote: Additionally, he is running CF9 _Standard_, which means he is limited to a single CF instance. On Thu, Jan 12, 2012 at 4:16 PM, Matt Quackenbush quackfu...@gmail.com wrote: That limit only applies to 32-bit machines. Since he is running CF9 64-bit I am assuming he is also on a 64-bit machine where the limit would not apply. On Thu, Jan 12, 2012 at 4:12 PM, Scott Stewart webmas...@sstwebworks.comwrote: Yes, the practical limit is around 3gb per JVM. The advantage to that much ram is being able to run alot of separate cf instances. Each with its own jvm On Jan 12, 2012 4:41 PM, Brook Davies cft...@logiforms.com wrote: Quick Question. On our new server we have lots of ram (32 gigs). Its running CF 9 Standard 64 bit. Is there any downside to allocating 12 gigs of ram to CF? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cftransaction isolation=repeatable_read
Bump... Casey - is this method thread safe? -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: December-13-11 10:15 PM To: cf-talk Subject: RE: cftransaction isolation=repeatable_read So this would update and select the rows at the same time? Would I need to use transaction or would this guarantee if another request for the same query at the exact same time happened, it would not return or update the same rows? Brook -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: December-13-11 6:29 PM To: cf-talk Subject: Re: cftransaction isolation=repeatable_read On Tue, Dec 13, 2011 at 6:13 PM, Brook Davies cft...@logiforms.com wrote: I guess my question is, will this lead to performance problems? Is there a more elegant way to do this? Are you using MS SQL server? If so you only need one query which will still output rows like the first query with OUTPUT. cfquery name=getEvents update t1 set t1.enabled = 0 OUTPUT inserted.ID, inserted.cfc, inserted.runMethod, inserted.arguments, inserted.frequency, inserted.frequencytype from scheduledTasks t1 inner join scheduledTasks t2 on t1.ID = t2.ID where t2.enabled = 1 and t2.nextDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# and t2.startDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# and t2.endDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# /cfquery ~| 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:349127 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: fresh cf 9 install can't see administrator
You can also try, running cf as the administrator account (just temporarily) and if that works, then at least you *know* it's a permissions problem. Then you can work backwards from there after setting it back to a service... Brook -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: December-13-11 1:45 PM To: cf-talk Subject: Re: fresh cf 9 install can't see administrator On Tue, Dec 13, 2011 at 12:14 PM, Mr. Chedder P. Slam chedders...@gmail.com wrote: apache running on VM to wwwroot in host machine Apache is running inside a VM? Is CF installed on the VM or the host? cf service running as local system account, but wwwroot has everyone full access Is CF installed as standalone? Multiserver? -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:349089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cftransaction isolation=repeatable_read
I am using cftransaction isolation=repeatable_read to single thread access to scheduled tasks that live in a DB table. This application spawns multiple servers, and each server is set to poll the scheduled task table every 3 minutes. It grabs the tasks and executes them. Now, if this was on one server, I could simply use a named exclusive lock to single thread access to the tasks so that multiple servers don't pick up and execute the same task (they should only be run once). What I have ended up doing is something like the code below. Basically, within the repeatable_read transaction I also update each row that was picked up for processing. This has the effect of causing another server who reads the data at the same time (before the enabled flag is set to false) to fail. I've tested this by adding a sleep() command after the first read and running this from two instances. One request always fails, so that is working as I want it to. I guess my question is, will this lead to performance problems? Is there a more elegant way to do this? cftransaction isolation=repeatable_read cfquery name=getEvents datasource=#application.gs.datasource# Select ID,cfc,runMethod,arguments,frequency,frequencytype from scheduledTasks where enabled=1 and nextDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# and startDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# and endDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# /cfquery cfoutput query=getEvents cftry cfquery datasource=#application.gs.datasource# update scheduledtasks set enabled=0 where id=cfqueryparam cfsqltype=cf_sql_integer value=#id# /cfquery cfcatch cfinvoke component=#application.core.Log# method=call logFile=scheduledEventLauncher log_error=Unable to update table, another server has a lock? #cfcatch.message# #cfcatch.detail# email=true cfreturn false /cfcatch /cftry /cfoutput /cftransaction Thanks for the input! Hopefully the above code does not get mangled.. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cftransaction isolation=repeatable_read
So this would update and select the rows at the same time? Would I need to use transaction or would this guarantee if another request for the same query at the exact same time happened, it would not return or update the same rows? Brook -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: December-13-11 6:29 PM To: cf-talk Subject: Re: cftransaction isolation=repeatable_read On Tue, Dec 13, 2011 at 6:13 PM, Brook Davies cft...@logiforms.com wrote: I guess my question is, will this lead to performance problems? Is there a more elegant way to do this? Are you using MS SQL server? If so you only need one query which will still output rows like the first query with OUTPUT. cfquery name=getEvents update t1 set t1.enabled = 0 OUTPUT inserted.ID, inserted.cfc, inserted.runMethod, inserted.arguments, inserted.frequency, inserted.frequencytype from scheduledTasks t1 inner join scheduledTasks t2 on t1.ID = t2.ID where t2.enabled = 1 and t2.nextDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# and t2.startDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# and t2.endDate cfqueryparam cfsqltype=cf_sql_timestamp value=#createodbcdatetime(Now())# /cfquery ~| 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:349092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Changing Application settings at runtime
What I ended up doing was just setting a flag in the request scope when I need to fallback to an alternate SMTP server. I just set request.toggleSMTP = true and then in the onRequestEnd() method, I check for that flag and do the processing to update this.smtpserversettings to an available server. This works... I load so much crap into the app scope, that I don't want to re-initialize the application!! Brook -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: December-06-11 9:31 AM To: cf-talk Subject: Re: Changing Application settings at runtime In CF9, there is the ApplicationStop() method which will restart the application on the next request, thus reinitializing the application scope. Ben Nadel wrote up an investigation of this awhile back: http://www.bennadel.com/blog/1667-Learning-ColdFusion-9-Resetting-Applicatio ns-With-ApplicationStop-.htm One thing to note is that calling ApplicationStop() does not reset the Session scope. This could be viewed as either a bug or a feature. So if you are ok with restarting the application while leaving the session scope in place, I'd place the smtpserversettings in your OnApplicationStart() method and make a call to whatever service you have that knows what the currently valid server settings should be. Of course you still have to figure out how to trigger the fact that you need to reset the application because of a downed smtp server. Hope this helps, Judah On Mon, Dec 5, 2011 at 5:30 PM, Brook Davies br...@logiforms.com wrote: So I have something like this at the top of application.cfc: cfset this.smtpserversettings = { server=mail.yourmama.com, username=b...@yourmama.com, password=issofat } But I want to be able to change these settings when I (somehow) detect that the server is down. From what I have read the only way to do this would in onRequestStart or onRequestEnd. So I can set up a request scoped flag that triggers the update, fine, but is that really the only way? Is there no way to call a method of application.cfc within the scope of the application? Broo ~| 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:348983 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is the CF scheduler Reliable?
How reliable is the CF Scheduler? For years we have used the infusion mailserver and its Infusion Scheduler App/Service. Its always worked great but since that product is dead/no longer supported, we need to find a new way of running scheduled tasks and adding/removing scheduled task programmatically. In the past I have seen lots of posts about the built in scheduler being unreliable. What I need to know is can the built in scheduler be used reliably for mission critical applications? Thanks for your input! Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Is the CF scheduler Reliable?
Thank you for the replies. Full steam ahead with CF Scheduler. Kym, it's a shame Infusion just vanished into thin air eh? I mean WTF? I loved their software! Briook -Original Message- From: Kym Kovan [mailto:dev-li...@mbcomms.net.au] Sent: December-05-11 3:50 PM To: cf-talk Subject: Re: Is the CF scheduler Reliable? On 6/12/2011 10:25, Brook Davies wrote: How reliable is the CF Scheduler? For years we have used the infusion mailserver and its Infusion Scheduler App/Service. Its always worked great but since that product is dead/no longer supported, we need to find a new way of running scheduled tasks and adding/removing scheduled task programmatically. In the past I have seen lots of posts about the built in scheduler being unreliable. We have no issues with the scheduler and we had the same problem as you being iMS junkies. Set a schedule to run every minute and one second and call the same page that you were calling with your iMS scheduler and it can sort out what really needs to run. BTW, if you are using Railo it can schedule tasks in seconds not minutes. Useful sometimes. -- 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:348958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Changing Application settings at runtime
So I have something like this at the top of application.cfc: cfset this.smtpserversettings = { server=mail.yourmama.com, username=b...@yourmama.com, password=issofat } But I want to be able to change these settings when I (somehow) detect that the server is down. From what I have read the only way to do this would in onRequestStart or onRequestEnd. So I can set up a request scoped flag that triggers the update, fine, but is that really the only way? Is there no way to call a method of application.cfc within the scope of the application? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is CFMAIL reliable??
Hi Guys (and girls), You may notice a trend in my postings! Moving away from infusion (long over due) and looking at Native CF functions instead. So now I am looking at CFMAIL and in the past know it has been a bit dodgy. There is a conversation here about restarting the spooling service: http://www.mail-archive.com/cf-talk@houseoffusion.com/msg342750.html And Ben Nadel talks about monitoring the undeliverable folder and how the spooler just occasionally stops working. http://www.bennadel.com/blog/1893-Monitoring-The-ColdFusion-Mail-Server-With -GMail-And-A-Scheduled-Task.htm The comments attest to this being an issue for a lot of people. So I guess the question is, has this been resolved or is it necessary to implement all of these hacks to keep CFMAIL running well? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
getPageContext() in onRequestEnd is empty?
I run some metric updating code in onRequestEnd. In certain cases, I want to show a message if the metric update fails. I want to replace what is already in the output buffer. I am trying this in onRequest end: cfset pageContent = getPageContext().getOut().getString() cfset getPageContext().getOut().clearBuffer() cfset pageContent = hello! cfset writeOutput(pageContent) cfset getPageContext().getOut().flush() But the original HTML is still outputted and my message is not. If I dump the getOut() result it is an empty string. I am not using CFFLUSH anywhere, so why would the HTML already by written from the buffer in onRequestEnd? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Check for list of words in string
Wouldn't this also catch words like 'myselection'? Brook -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: October-11-11 7:16 AM To: cf-talk Subject: Re: Check for list of words in string Regular expressions. if ( reFindNoCase((select|declare),myString) 0 ) { // at least one of the words is present } HTH On Tue, Oct 11, 2011 at 9:11 AM, Brian Cain bcc9...@gmail.com wrote: Hello all, I would like to check a string against a list of keywords and either null the string or replace the keywords if found. Over the past couple of weeks someone has been probing my sites for SQL injection vulnerabilities. I have used queryparams and other types of validation. but I fear I may have missed something. I am using an old version of formurl2attributes that has been modified over the years. My thought is to check the attributes list at the end of the custom tag, and look for some of the common SQL injection keywords there and mitigate their effectiveness. So in short, how do I search for keywords like select,declare in a string without looping over the keywords? Thanks, Brian Cain ~| 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:348053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Count rows in Excel file
Hey Everyone, Anyone know a way to count the rows in an excel file without using cfspreadsheet to read the entire file in first? That's what I am trying to avoid.. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Awesome Eclipse Shortcut
I know its OT, and most of you probably already know it, but this shortcut saves me so much time, and I'm such a geek, that I had to post it: CTRL + SHIFT + R - then hit Enter Type a few characters of the name of the file your looking for, boom, hit enter to open it. Or if you highlight the name of a component or an include in your code (assuming the filename is similar or the same) and hit the shortcut it will select that file by default. Awesome to find that CFC or include that is buried deep somewhere.. Saves me so much time. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Way OT - Technical Writing
Sorry for the way OT post. But I am going crazy trying to find a good technical writer to write a user guide for our CF web app. I've gone through a few people already. They keep writing stuff that seems to make the topics MORE difficult. I think I would pull my hair out trying to use what they are writing. I suspect the people on this list have had to hire technical writers at one point or another. Does anyone have a good technical writer they use for projects that they want to refer to me??? I would be so grateful. Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Linkpoint Web Service API
I'm in the same boat over the next 1-2 months and would pay you for a CFC that did all the heavy lifting. Its not likely that complex, but I don't have the time right now... Brook -Original Message- From: Justin Scott [mailto:leviat...@darktech.org] Sent: September-06-11 1:32 PM To: cf-talk Subject: Re: Linkpoint Web Service API Does anyone have any experience with Linkpoint Web Services? I installed 64bit CF9 and found that the DLL COM call does not work. I need to reprogam to use WebServices instead. I don't yet, but I have one project that is using LinkPoint's old COM object to handle payments and another one in the works which will need to talk to LinkPoint as well in the next couple of months. I'll likely be rewriting our interface for that project and applying it to the older one as well. If you find something already built that works with their newer model, or hire someone to build it (I see your post on cf-jobs as well), I'd be interested in anything you find or potentially purchasing a copy of the one you have built if you hire it out as it would save me some time as well. -Just ~| 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:347264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFHTTP, DNS Caching, and CF 9 won't behave.
Is it an HTTPS connection? Have you added their cert to the Java KeyStore? Brook -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: September-02-11 12:00 PM To: cf-talk Subject: CFHTTP, DNS Caching, and CF 9 won't behave. So, I'm having a problem with CFHTTP caching DNS and not wanting to update. Basically, a vendor updated their API yesterday and now all CFHTTP calls to the url give a Connection Failure error, even though you can pull the url up in a browser (from the server) and it works fine. I've already gone through the suggestions in the following posts: http://www.talkingtree.com/blog/index.cfm/2006/5/23/Configuring-the-Caching- of-Hostname-Resolution-for-ColdFusion-MX http://dcooper.org/blog/client/index.cfm?mode=entryentry=B322459B-D872-DC1E -6F2424DDC66215E6 http://www.coldfusionmuse.com/index.cfm/2008/10/9/cfhttp-troubleshooting http://www.coldfusionmuse.com/index.cfm/2009/1/28/cfhttp.dns.restart and it doesn't seem to work. I've changed every java.security file I can find on my machine, restarted all CF services, even rebooted twice and the cache doesn't clear. I'm running CF 9 on Windows 7 64-bit. Any suggestions? ~| 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:347187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Stopping Railo via an ANT task
Sorry for the OT post, I'm stuck on this. Trying to get Railo Express to stop via an ANT task. The java code is the same as in stop.bat. Note, calling stop.bat directly is not working for me either. target name=stopRailo description=Stopping Railo Server echo message=Stoping Railo../ java jar=tools/build/railo/lib/start.jar dir=tools/build/railo/ fork=true failonerror=true arg value=-DSTOP.PORT=8887/ arg value=-DSTOP.KEY=railo/ arg value=--stop/ /java echo message=Railo Stopped../ /target I get this error, and can still connect to localhost: [java] java.net.ConnectException: Connection refused: connect [java] at java.net.PlainSocketImpl.socketConnect(Native Method) [java] at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) [java] at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) [java] at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) [java] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) [java] at java.net.Socket.connect(Socket.java:525) [java] at java.net.Socket.connect(Socket.java:475) [java] at java.net.Socket.init(Socket.java:372) [java] at java.net.Socket.init(Socket.java:215) [java] at org.eclipse.jetty.start.Main.stop(Main.java:1096) [java] at org.eclipse.jetty.start.Main.parseCommandLine(Main.java:136) [java] at org.eclipse.jetty.start.Main.main(Main.java:81) [java] Usage: java -jar start.jar [options] [properties] [configs] [java]java -jar start.jar --help # for more information I can't get it to stop no matter what I try... Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) Stopping Railo via an ANT task (SOLVED)
It looks like I had somehow spawned multiple processes and they were not getting stopped correctly. I think this happened when a build failed. Please disregard.. Brook -Original Message- From: Brook Davies [mailto:br...@logiforms.com] Sent: August-19-11 1:08 PM To: cf-talk Subject: (ot) Stopping Railo via an ANT task Sorry for the OT post, I'm stuck on this. Trying to get Railo Express to stop via an ANT task. The java code is the same as in stop.bat. Note, calling stop.bat directly is not working for me either. target name=stopRailo description=Stopping Railo Server echo message=Stoping Railo../ java jar=tools/build/railo/lib/start.jar dir=tools/build/railo/ fork=true failonerror=true arg value=-DSTOP.PORT=8887/ arg value=-DSTOP.KEY=railo/ arg value=--stop/ /java echo message=Railo Stopped../ /target I get this error, and can still connect to localhost: [java] java.net.ConnectException: Connection refused: connect [java] at java.net.PlainSocketImpl.socketConnect(Native Method) [java] at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) [java] at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) [java] at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) [java] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) [java] at java.net.Socket.connect(Socket.java:525) [java] at java.net.Socket.connect(Socket.java:475) [java] at java.net.Socket.init(Socket.java:372) [java] at java.net.Socket.init(Socket.java:215) [java] at org.eclipse.jetty.start.Main.stop(Main.java:1096) [java] at org.eclipse.jetty.start.Main.parseCommandLine(Main.java:136) [java] at org.eclipse.jetty.start.Main.main(Main.java:81) [java] Usage: java -jar start.jar [options] [properties] [configs] [java]java -jar start.jar --help # for more information I can't get it to stop no matter what I try... Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: coldfusion spreadsheet leading zeroes issue
This is an excel issue, not a CF issue. If you set the data type of the column to text it does not happen.. http://www.google.ca/search?hl=enclient=firefox-ahs=vpOrls=org.mozilla%3A en-GB%3Aofficialbiw=1920bih=1084q=excel+truncates+leading+zerobtnG=Searc hoq=excel+truncates+leading+zeroaq=faqi=aql=gs_sm=sgs_upl=0l0l0l18408l 0l0l0l0l0l0l0l0ll0l0 Brook -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: August-16-11 10:35 AM To: cf-talk Subject: coldfusion spreadsheet leading zeroes issue Hi All - I am facing an issue with coldfusion9 spreadsheet functions. It cuts of leading zeroes. This is what I am trying. I am getting array of data and using spreadsheetaddrows. When I am constructing an array, am using quotes so as to preserve the zeroes but with no effect. Adding some characters like ~ helps. But when I am adding space, coldfusion is not preserving the spaces. Is there a better way to handle this issue? 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:346790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Setting client variable datasource via config.xml
Good Solution, thanks! -Original Message- From: Brian Kotek [mailto:brian...@gmail.com] Sent: August-11-11 9:47 PM To: cf-talk Subject: Re: Setting client variable datasource via config.xml Right, set up a function that you call to get the variables, and have it read the XML the first time, and on any subsequent calls just use the XML already loaded rather than load it again. On Fri, Aug 12, 2011 at 12:17 AM, Matt Quackenbush quackfu...@gmail.comwrote: No, you cannot do cfset this.clientStorage = application.gs.clientVarDataSource / You might get away with that after the application has already been init'd, but even then it would be a false positive and would stop working as soon as the application timed out or the application server was restarted. However, you *can* do something like so: this.clientStorage = getClientStorageDatasource(); function getClientStorageDatasource() { // read your xml file and extract the variable return theDatasource; } HTH On Thu, Aug 11, 2011 at 10:57 PM, Brook Davies cft...@logiforms.com wrote: But can you set this.clientstorage that way? Because It seems setting that property within onRequestStart() does not work. In my requestStart method I call another method which sets a client var. If I set the this.client[(storage|Management|etc] in the onRequestStart, I get an error that the client scope is not enabled when I try to set a client var in a method called from there. Sorry to be using client variables Nathan :( Brook -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: August-11-11 5:45 PM To: cf-talk Subject: Re: Setting client variable datasource via config.xml I used to have this issue as well, you obviously cannot read read app vars that do not exist yet and you cannot create them until the application scope is initialised. The way I got round this is to have 2 XML files. One that contains the init variables that need to exist before the application scope is initialised, and I load these into request scope onapplicationstart. Once this is done, I then load the global config into the application scope. On Thu, Aug 11, 2011 at 11:06 PM, Brook Davies cft...@logiforms.com wrote: I'm trying to set all my apps properties via a config file to make deployment between dev, production servers easy. Problem is the application vars that are read via onApplicationStart() are not available within the opening part of the application.cfc and when I try to set these properties inside onRequestStart() they do not work. Should I be able to set these in onRequestsStart()? cfcomponent output=false extends=coldfireApplication cfset this.clientManagement= true cfset this.setClientCookies= true cfset this.setDomainCookies= false cfset this.clientStorage = application.gs.clientVarDataSource ~| 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:346723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFGRID strange behaviour in Production Server (Windows 2000 + ISS)
Steve's right, if you have unescaped HTML inside the grid (in the data), then it can cause the grid display to be wonky. Brook -Original Message- From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com] Sent: August-11-11 10:28 AM To: cf-talk Subject: Re: CFGRID strange behaviour in Production Server (Windows 2000 + ISS) No, you can't update Ext on the server. You could write a straight Ext implementation, skipping the cfajax components all together. Or, it could be a data issue, where something in the data is breaking cfgrid's js. If you're server versions, hotfix levels, etc are all the same then it should just work. 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/learning-ext-js-3-2-for-building-dynamic-desktop-st yle-user-interfaces/book The best way to predict the future is to help create it On 8/11/2011 1:18 PM, Luiz Milfont wrote: Could it be an EXT issue? Is there any way to update EXT on production server? I ask this, because my CFGRID component uses EXT. ~| 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:346709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Setting client variable datasource via config.xml
I'm trying to set all my apps properties via a config file to make deployment between dev, production servers easy. Problem is the application vars that are read via onApplicationStart() are not available within the opening part of the application.cfc and when I try to set these properties inside onRequestStart() they do not work. Should I be able to set these in onRequestsStart()? cfcomponent output=false extends=coldfireApplication cfset this.clientManagement= true cfset this.setClientCookies= true cfset this.setDomainCookies= false cfset this.clientStorage = application.gs.clientVarDataSource .. ~| 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:346710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Setting client variable datasource via config.xml
I'm trying to set all my apps properties via a config file to make deployment between dev, production servers easy. Problem is the application vars that are read via onApplicationStart() are not available within the opening part of the application.cfc and when I try to set these properties inside onRequestStart() they do not work. Should I be able to set these in onRequestsStart()? cfcomponent output=false extends=coldfireApplication cfset this.clientManagement= true cfset this.setClientCookies= true cfset this.setDomainCookies= false cfset this.clientStorage = application.gs.clientVarDataSource ~| 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:346711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Setting client variable datasource via config.xml
But can you set this.clientstorage that way? Because It seems setting that property within onRequestStart() does not work. In my requestStart method I call another method which sets a client var. If I set the this.client[(storage|Management|etc] in the onRequestStart, I get an error that the client scope is not enabled when I try to set a client var in a method called from there. Sorry to be using client variables Nathan :( Brook -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: August-11-11 5:45 PM To: cf-talk Subject: Re: Setting client variable datasource via config.xml I used to have this issue as well, you obviously cannot read read app vars that do not exist yet and you cannot create them until the application scope is initialised. The way I got round this is to have 2 XML files. One that contains the init variables that need to exist before the application scope is initialised, and I load these into request scope onapplicationstart. Once this is done, I then load the global config into the application scope. On Thu, Aug 11, 2011 at 11:06 PM, Brook Davies cft...@logiforms.com wrote: I'm trying to set all my apps properties via a config file to make deployment between dev, production servers easy. Problem is the application vars that are read via onApplicationStart() are not available within the opening part of the application.cfc and when I try to set these properties inside onRequestStart() they do not work. Should I be able to set these in onRequestsStart()? cfcomponent output=false extends=coldfireApplication cfset this.clientManagement= true cfset this.setClientCookies= true cfset this.setDomainCookies= false cfset this.clientStorage = application.gs.clientVarDataSource ~| 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:346713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Run a class file generated with CF outside of CF
Hey Nathan, So what I was doing was this. I am working on a new web app written with extJS. I have a CFC that I call that builds the client side app. It reads all of the ux and util directories and generates a config file used by jsBuilder to compress, combine and minify the JS used on the client side as well as compress and move CSS and resources. I am working towards getting a CI server setup and also need to ensure all developers can run a build locally. That's where the problem arises. The developers (JS developers) will not have CF installed on their local machine (or our pre-configured EC2 instance), and so I need to move the process of generating the jsBuilder config and executing it out of CF and into something that can run on any developers workstation - without a big install and setup. Since its just 1 CFC, I thought I could just use the java classes. But of course there are dependencies. I found a wicked, super cool solution to this last night! I downloaded Ralio Express and was able to get it to execute my CFC with basically zero setup. Ralio Express is freakin awesome! There's no installer, you just run start.bat to start the server and stop.bat to stop it. So I've added it to my SVN and written an ANT task that starts it up and then runs the CFC that indexes all the directories, read in an XML config file and calls (via cfexcecute) the CFC that handles the build. My ANT task has these targets: target name=startRalio description=Starting Ralio Server depends=MakeDirectories java jar=tools/build/ralio/lib/start.jar dir=tools/build/ralio/ fork=true spawn=true maxmemory=512M arg value=-h/ arg value=-DSTOP.PORT=8887/ arg value=-DSTOP.KEY=railo/ /java !-- wait for server to start up -- waitfor maxwait=10 maxwaitunit=second and socket server=localhost port=/ http url=http://localhost:/index.cfm/ /and /waitfor /target target name=doBuild description=Call the Ralio script to in turn call JsBuilder and do compilation depends=startRalio get src=http://localhost:/build/doBuild.cfm; dest=buildresult.txt / !-- look for buildresult.txt, read the result and throw an error if any errors exist -- loadfile property=buildresult srcFile=${desktop.build.dir}buildresult.html/ echo message=${buildresult}/ antcall target=checkResult / antcall target=stopRalio / /target Never used Ralio before, but very impressed with it! Brook -Original Message- From: Nathan Strutz [mailto:str...@gmail.com] Sent: August-06-11 12:39 PM To: cf-talk Subject: Re: Run a class file generated with CF outside of CF Yeah, it's probably not going to happen. I mean, I am getting famous for saying that it's software, so we can do anything, but the problem is the amount of work it takes to do a thing. In this case you have to load a good amount of the CF server into memory, all the other related classes (one ..class for the cfc, one for each cffunction, etc.), then fake a request response object, or whatever servlets do (I knew at one point). Your best bet is to not do this. It would be much easier to call your CF server rather than try to use the generated code out of context. There are many ways to call into CF from Java. The easiest one would be to hit it via a HTTP URI. Second easiest would be a web service. Third, you can use the CF services gateway - you can set up a local socket listener, which should be really performant. Also, I think Terrence Ryan had a project on RIAForge that lets you call it via the command line console. I wonder, what is the underlying reason for wanting to call the generated classes? Sort of an odd request. Why are you doing this? Maybe there's a better way to accomplish your end goal. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Sat, Aug 6, 2011 at 10:53 AM, Brook Davies cft...@logiforms.com wrote: Hey, I don't know if this is possible. I want to take a class file from the cfclasses/ directory and run it from the command line outside of the CF server. It complains about not being able to find some cf related classes. I assume this is not at all possible since the classes include lots of CF specific classes for various functions. Is that right? Is this not possible? Brook ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346567
RE: Run a class file generated with CF outside of CF
Sean, Re: Railo from the command line That's sounds very cool and will be very useful. Nathan, Yeah, I know its kinda nuts to do all that just to run one CFC. But it is a pretty big CFC and it does a lot including reading in and parsing XML config files that are used by the application, and indexing directories etc. While I would agree it would be better to keep it all inside ANT without the dependency on Railo (thank Peter!), the main factor for me was implementation time. I'm already behind schedule and no time to re-write this code - so using Railo was the fastest solution. It has the added benefit that it is leveraging some existing CFML and plus, CFML scripting is where I am strongest (that and JS..), so it made sense. I think if I had the time I would have done it all in ANT. What you said about using Rhino sounds very promising. Brook -Original Message- From: Sean Corfield [mailto:seancorfi...@gmail.com] Sent: August-07-11 6:22 PM To: cf-talk Subject: Re: Run a class file generated with CF outside of CF FWIW, Railo 4.0 will make this even easier by allowing CFML to be executed directly from the command line (or ant) without needing a server running at all. This will effectively make CFML a general purpose scripting language that can be used outside the servlet container! Builds of 4.0 are currently pre-alpha and undergoing testing in-house. Once Railo 3.3 goes gold (should happen around the end of this month), that will become the stable release and 4.0 will appear on the development builds / bleeding edge provider. Sean On Sun, Aug 7, 2011 at 6:37 AM, Brook Davies cft...@logiforms.com wrote: I found a wicked, super cool solution to this last night! I downloaded Ralio Express and was able to get it to execute my CFC with basically zero setup. Ralio Express is freakin awesome! There's no installer, you just run start.bat to start the server and stop.bat to stop it. So I've added it to my SVN and written an ANT task that starts it up and then runs the CFC that indexes all the directories, read in an XML config file and calls (via cfexcecute) the CFC that handles the build. ~| 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:346580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm