RE: ColdFusion|JRun CPU and|or memory problem.
Ian, Doing triage I always look at (in order). 1) client vars - are they stored in the registry? If so you could have an issue deleting that that shows up as the purge process starts hitting actual values to attempt to delete. 2) DB issues - Trouble on the DB spells trouble for the CF Server for most aps - even though CF gets the blame :) Look for locks and blocks. After that I start looking pot luck of other things -Mark -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Wednesday, January 20, 2010 3:38 PM To: cf-talk Subject: ColdFusion|JRun CPU and|or memory problem. Any good information on how to track down what is causing a ColdFusion server to behave badly. The symptoms we have to date: 1) Starting January 5th, our Windows 2003, ColdFusion Web Server will suddenly jump from under 5% CPU usage to an average over 50% with frequent spikes to 80%, 90% and over. 2) When this happens the JRun process for our main JRun process will be running with over 600,000kb of memory. 3) Restarting this ColdFusion instances resets the server back to it's normal 5% CPU usage. 4) When I point the Administrator monitor at the server nothing seems to be obviously wrong 5) *EXCEPT* The monitor will sometimes report an Application Scope of nearly 821,000,000,000,000kb. Yes, that is over 100 petabytes of data according to Wolfram-Alpha. I am pretty sure we do not have that much memory on this server. The weird thing is that there does not seem to be a correlation between that impossible memory spike and the problem with the server. I have been able to see the spike twice since I have started monitoring things yesterday. Once this occurred during a problem period, once it did not. Using the monitor and looking at the various log files, I can not find any clear smoking gun, so I am looking for advice on how one my track down an elusive problem like this. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 64bit CF Server and System DSNs - Solved
That is an outstanding tip... Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Bobby [mailto:bo...@acoderslife.com] Sent: Wednesday, January 20, 2010 8:14 PM To: cf-talk Subject: Re: 64bit CF Server and System DSNs - Solved There actually IS a 64bit version of the MSDASQL provider. After installing that and adding 'Provider=MSDASQL;' to all connection strings, everything started working fine. Bobby Hartsfiled wrote: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 We are in the process of setting up a 64bit, multiserver configuration ColdFusion server. We have setup and tested multiserver configuration in the past but that was on 32bit. This is our first attempt at 64bit. - Windows 64bit Server 2003 R2 - CF 8 Enterprise 64 bit Some parts of our application still contain legacy ASP code and we use System DSNs to allow that legacy code to talk to our databases. With 64bit, we are receiving the following error anytime ASP attempts to talk to a system DSN. ADODB.Connection error '800a0ea9' Provider is not specified and there is no designated default provider. /openadmin/_scripts/conn.inc, line 11 I found a couple of different reasons and alleged solutions to this but have still had no luck solving it. The first, and most common, explanation that I've found is that the MSDASQL.dll (provider for ODBC drivers) has no 64 bit version and that SQLOLEDB should be used instead. To use SQLOLEDB, the suggestion was to add the provider argument to your connection strings: DSN=systemDSNName;UID=username;PWD=password; Prodvider=SQLOLEDB; When I try that, I receive a different error: Microsoft OLE DB Provider for SQL Server error '80004005' Invalid connection string attribute /openadmin/_scripts/conn.inc, line 11 Another solution was to use the connection string argument Driver={SQL Server} instead of the provider. But when I try that, I get a completely different error message: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /openadmin/_scripts/conn.inc, line 11 Another solution, yet again, was to use the 32bit version of the ODBC Manager to create your system DSNs. I tried that as well with all of the same results. I also tried setting IIS to run as a 32 bit application by setting Enable32BitAppOnWin64 to true but that resulted in a different error as well: %1 is not a valid Win32 application. I also tried all of the same connection string changes from above while running at 32bit but there was no change in this error messages. As you can see, I'm not having much luck. Has anyone else had this issue before that might be able to offer some suggestions? Thanks for any help you can offer. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion|JRun CPU and|or memory problem.
I'll second that on the memory tracking - I wish I could disable the button so an unwary admin doesn't accidentaly crash the server for me (yikes). Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Wednesday, January 20, 2010 5:04 PM To: cf-talk Subject: RE: ColdFusion|JRun CPU and|or memory problem. Is the jrun process specifically consuming the CPU usage, or is another process using it? Is SQL Server or any thing else also running on this box? Also, how much memory does jrun usually use? What are you min and max heap arguments? Windows may have 1 Gig allocated to jrun, but you may only be using a portion of it. Another quick place to check are scheduled tasks in CF. Ditto on the CF server monitoring. It is bad news, period. I hate to say it but memory tracking is virtually unusable in my experience because it has instantly crashed the server any time I've even tried to enable it-- even if only for a few seconds. And finally, buy SeeFusion. It's like 300 bucks and it makes it dang easy to watch your memory, get stack traces (for a specific thread, or the whole server) and it will show you what is running and what SQL it is calling. ~Brad Original Message Subject: ColdFusion|JRun CPU and|or memory problem. From: Ian Skinner h...@ilsweb.com Date: Wed, January 20, 2010 3:37 pm To: cf-talk cf-talk@houseoffusion.com Any good information on how to track down what is causing a ColdFusion server to behave badly. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Recent SQL Injection attacks
Michael, Yes... Certain types of installations of MySQL are subject to character injection attacks. http://www.coldfusionmuse.com/index.cfm/2008/2/22/sql-injection-on-a-charact er-field Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Wednesday, January 13, 2010 5:34 PM To: cf-talk Subject: Re: Recent SQL Injection attacks Fast question. Has anyone seen an injection attack that used a field other than an integer? I've written a fast RegEx for use in Homesite (or any other regex using editor) that will find any query that has numeric 'looking' variables that are not in a cfqueryparam. While I have to change every variable not in a cfqueryparam, I'm trying to get the numerics first. Thanks -- Michael ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329639 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQLServer Express and SQLServer - totally compatible?
Leaving aside the advisability of doing this :) I have detached and reattached SQL 05 express DBs to prod servers and vice versa - and I will give you a qualified Yes that what you want to do will work. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Monday, January 04, 2010 8:05 PM To: cf-talk Subject: SQLServer Express and SQLServer - totally compatible? I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? I should also add that I'm only going to be using the Express on a dev machine - not connected to the internet, and there wont be multiple users. And i hardly ever use the advanced features of the database for these little applications - things like syndication and triggers etc - i prefer to have ColdFusion take care of all those kinds of jobs. So for the most part, the databases are simple data storage mechanisms, with all the processing of data being done in ColdFusion. Can anyone see a problem if i do this?I'm not sure the machine I'm building justifies the cost of buying a licence for SQLServer2005 the full version. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQLServer Express and SQLServer - totally compatible?
Dave, I didn't catch that it was an external drive - I think if it's an external USB drive you might be right - I was thinking more along the lines of a hot swap sata drive on a sled that plugs into a empty bay. I know with 2000 you could only do direct attached, but now days there are so many storage choices I believe they have changed that limitation. Mike, A quick google search brought up this link: http://stackoverflow.com/questions/78560/locked-sql-server-data-files I think it relates directly to what you want to do - I would read it carefully. It seems like you might end up with ACL signiture or other file status or permission issues when spooling up these files. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, January 04, 2010 8:16 PM To: cf-talk Subject: Re: SQLServer Express and SQLServer - totally compatible? I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. Honestly, I don't know if SQL Server will let you do this. I suspect it might not, as Windows can detect removable drives. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? Yes, you can use database files created by one with the other, although there may be some limitations if you use certain features in SQL Server 2005 when you create the database files (such as the ability to create databases larger than 4GB - that's not supported by Express). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more inform ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Performance
2 things for you. First, check the DB for blocks and locks - about 9 times out of ten queuing requests are due to DB requests that are hanging. For some reason we web developers bang our head against CF over and over thinking there is something we can do on the web server to solve problems that exist on the DB server :) Secondly, If you are already running perfmon then you can get the information on which site is busiest (or at least handling the most requests). Choose web service and then Current connections and all instances. Use the report view (the little page icon next to the chart icon on the toolbar) it is clearer. Oh... current connections is appropriate for Wind2003 and above. For windows 2000 use current anonymous users. What you should see (using the report view) is a horizontal list of all your sites. The _total will be the first item. On a busy server you may need to scroll to the right to see them all. You can click on them and delete the ones you know are not the problem. Even though seeFusion and fusionReactor are great tools, I set up saved Perfomon mcc's for all my windows servers - in fact you can view the counters remotely (if you have the right domain rules in place) and you can see more than one server at a time in the same perfmon instance. Granted it is less introspective than one of the Java tools - but for a quick glimpse of a server to answer the question - how busy is it - in real time, it's handy and easy. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: Thursday, December 17, 2009 6:20 PM To: cf-talk Subject: Server Performance Is there a way through command line or a 3rd party application to see what web sites on a CF Pro 8 server are causing the most requests? On one particular server it is starting to show behavior of page timeouts and longer running requests. In the Performance Monitor in windows I see the running requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Server Performance
No prob. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: Friday, December 18, 2009 11:22 AM To: cf-talk Subject: RE: Server Performance Thanks Mark this actually helped quite a bit. I didn't realize that option was available in perfmon. Thanks, Patrick J. Hedgepath Pegasus Web Productions webmas...@pegweb.com 803-996-0578 -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Friday, December 18, 2009 8:46 AM To: cf-talk Subject: RE: Server Performance 2 things for you. First, check the DB for blocks and locks - about 9 times out of ten queuing requests are due to DB requests that are hanging. For some reason we web developers bang our head against CF over and over thinking there is something we can do on the web server to solve problems that exist on the DB server :) Secondly, If you are already running perfmon then you can get the information on which site is busiest (or at least handling the most requests). Choose web service and then Current connections and all instances. Use the report view (the little page icon next to the chart icon on the toolbar) it is clearer. Oh... current connections is appropriate for Wind2003 and above. For windows 2000 use current anonymous users. What you should see (using the report view) is a horizontal list of all your sites. The _total will be the first item. On a busy server you may need to scroll to the right to see them all. You can click on them and delete the ones you know are not the problem. Even though seeFusion and fusionReactor are great tools, I set up saved Perfomon mcc's for all my windows servers - in fact you can view the counters remotely (if you have the right domain rules in place) and you can see more than one server at a time in the same perfmon instance. Granted it is less introspective than one of the Java tools - but for a quick glimpse of a server to answer the question - how busy is it - in real time, it's handy and easy. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: Thursday, December 17, 2009 6:20 PM To: cf-talk Subject: Server Performance Is there a way through command line or a 3rd party application to see what web sites on a CF Pro 8 server are causing the most requests? On one particular server it is starting to show behavior of page timeouts and longer running requests. In the Performance Monitor in windows I see the running requests will max out from time to time and then requests start to queue. I want to be able to determine which sites are generating the most requests so I can examine the traffic and the code on those sites for potential problems. Anybody know of any way to do this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Faster SMTP
There is more to it than that. Javamail translates the spooler file into smtp commands which result in the file on the SMTP server. Get ahold of one of the .eml files from the /queue directory of the IIS SMTP server.. That's the one you need to emulate. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: webmas...@pegweb.com [mailto:webmas...@pegweb.com] Sent: Friday, December 11, 2009 1:14 PM To: cf-talk Subject: Re: Faster SMTP So all I would need to do is recreate the txt file that is those .cfmail files or is there more to it than that? Thanks, Patrick J Hedgepath Pegasus Web Productions webmas...@pegweb.com (803)-996-0578 On Dec 11, 2009, at 2:11 PM, Justin Scott jscott-li...@gravityfree.com wrote: This is an actual mail server though correct? My mail server is not the issue it spools out fine. It's the CF Spooler that is my bottleneck. Bypass it. Some mail servers have a place where a message file can be written or copied to and it will pick it up and process it. The Microsoft SMTP spooler has a folder under mailroot called pickup specifically for this purpose. ModusMail has a similar option. I'm not sure about MDaemon and Smartermail, but they're fairly mature products and I'd expect they do as well. You can write files out a lot faster than CF's spooler can move the mail via SMTP. -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: For consideration...
I like it in principle but what is your idea of ajax based server side validation... Server side validation needs to always be done prior to the server uitlizing the inputs (inserting into the DB etc). You can't validate using an ajax request and THEN submit the form values using a submit request... You sumbit the form and then validate... Otherwise your validation is easily circumvented and of no value... Right? Am I missing something? Are you talking about ajax submissions encorporating validation? -Mark -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Friday, December 11, 2009 4:55 PM To: cf-talk Subject: For consideration... I'm tired of writing form input validation routines over and over again. Using CFINPUT and its validation options work great for the front end, but it's still a pain to write input validation on the server-side, and the rules between the two can get out of sync, and the built-in validation rules don't have as much flexibility as server-side rules do. I'm working on a project where I have some flexible time to write a new tool and wanted to see if there would be any interest in the community in a tool defined as such: A form library that would allow a form with all of its properties and validation requirements to be defined in one place (likely a JSON file) which would then 1) Generate the form for display (optional), 2) provide for AJAX-based client-side validation, and 3) provide server-side validation. The core library would have a number of built-in validation options and allow for new rules to be added as needed without changing the core library files. My thought is that this would help speed development by centralizing form definitions and properties and make input validation on both the client and server side consistent and reliable without having to constantly write and rewrite huge blocks of cfif/cfelseif code for each form. Thoughts? Opinions? Bad idea? Someone already release something that does this? If it sounds like something you could use, please let me know. If it's pursued, it would be released free for the community to use, but I don't want to waste time building it if something similar exists or nobody else could benefit from it. Any feedback appreciated. -Justin Scott ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329115 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: For consideration...
Got... Clever. I see exactly what you are getting at. The use of ajax for client side makes the validation run the exact same routines. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Friday, December 11, 2009 5:35 PM To: cf-talk Subject: Re: For consideration... The app can do both. The idea is to write one set of server-side validation routines in CF. The app then uses AJAX to check fields as the used fills them out, for the benefit of the user; it also checks them server side on submission to ensure data integrity and prevent circumvention of the validation routines. A framework to easily apply the validation at both ends would make it all a low maintenance thing - the validation need only be written once and can be maintained in one place. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/12/12 Mark Kruger mkru...@cfwebtools.com: You can't validate using an ajax request and THEN submit the form values using a submit request... You sumbit the form and then validate... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: convert this cfscript back to tag?
Ok... But why? Other than the pound signs it seems fine to me... Except that form.ID will always be the last item in the list once you are done with the loop. cfloop list=#form.whattoupdate# index=tempval cfset form.id = tempval/ cfset form.newRank = form[rank_ tempval]/ /cfloop Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Thursday, December 10, 2009 8:43 AM To: cf-talk Subject: convert this cfscript back to tag? Hi all, could someone convert this cfscript back to tag? for(i=1;i lte listlen(#form.whatToUpdate#,,);i++){ tempVal = #listgetat(form.whatToUpdate,i,,)#; form.ID = #tempVal#; //Option ID form.newRank = form[rank_ #tempVal#]; } thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Load-balancing servers
Rick, The questions to ask are - what are you doing with session variabls and client variables, and .. What are the capabilities of your chosen load balancing method. Remember that the potential here is for a user to bounce back and forth between your servers while surfing your site - so you have to be able to imagine the impact of that on the user. Will he lose his session? Will that matter? Etc. If you are using a hardware load balancer they typically come with choices to help mitigate these issues (like sticky sessions for example). As for files - you have to be able to either sync files between the servers or use a shared file storage - and there are trade offs to each of these approaches. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Sanders [mailto:r...@webenergy.ca] Sent: Thursday, December 10, 2009 8:59 AM To: cf-talk Subject: Load-balancing servers I have 2 Cold Fusion Enterprise servers. What I would like to do is balance the load between 2 machines, and maybe more in the future. I have a very large and demanding portal app that is going live soon. I've looked over the documentation and it doesn't seem to cover much about it. Can anyone offer some insight on this? I know I'll have to change any absolute paths to UNC paths and set up any ODBC databases, but is there anything else from the app side I need to do? Thanks! Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Long Running Processes in ColdFusion
Great rundown Brad -mk -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] It has always been my understanding that CF was better suited to fast running processes. In general, fast request times are desired when they are a response to a web request. Nobody is sitting in front of a keyboard waiting for your long running job to complete so there's really nothing wrong with the fact that is will run for a long time. I've run scheduled tasks that took hours on ColdFusion and it worked fine. If you have a dedicated ColdFusion server processing this job, I say do it. If you want this process to run on your main ColdFusion server that is also serving your web content, you have a few questions to ask yourself. At face value a long running process can have the following affects on the server: 1) It uses a thread. You only have so many of these available. If no more than 1 of these long running processes are gong at the same time, it will only be taking 1 thread at any given time away from the rest of the server. 2) It can take CPU usage from your CF server. This is largely dependent on WHAT the process is doing. Is most of the process CFML code execution? If so, it will probably take a lot of CPU load and will slow down the other threads. If 99% of the process is waiting on some huge database query to run, then I would say that thread will have a very minimal impact on the other requests. 3) It can cause locks on CF/Web resources. This depends on what the code does. There could be CFLOCKs your app may have which would affect other requests. If you are running ColdFusion Standard, there are semaphore locks for things like PDF generation and SMS gateways because they are single-threaded unless you have ColdFusion Enterprise. A process that reads or writes a large number of files may also bog down disk activity for the server. Memory consumption may also be an issue. Once again, this all depends on what your process is doing. 4) It can cause locks on DB resources. If this process spends a lot time hitting the database, it can cause a lot locks and disk I/O based on what it is doing. If it is reading only, this would be a very good place for a replicated DB server. So I guess my answer is a big fat it depends. I would say there are long-running jobs that would be perfectly safe to have on a box also serving a web site. That being said, I would personally feel much safer having it run on a dedicated server. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Writing query to a csv file
Well.. The code below would uh... Create the same file over and over with only the last row... Unless I'm reading it wrong ;) What you needs is something like Cfsavecontent variable =csvcfoutput query=get_all ##TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed _title)#,#TRIM(ed_email)#, And so on /cfsavecontent Cffile write=c:\blah.csv output=#trim(csv)#/ You can't use html (like br) in a csv.. Instead you use actual line breaks (chr(10) or chr(10)chr(13) for windows). But the code above will add those because they are created when you code and hit enter :) Good luck. You will get this - it's not too tough. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: coldfusion.develo...@att.net [mailto:coldfusion.develo...@att.net] Sent: Wednesday, December 09, 2009 8:34 AM To: cf-talk Subject: Writing query to a csv file I have a need to write the output from aquery to a csv file without headers. I've seen many examples where you can write the output from a query to a CSV file. However most of the examples I've seen require that the file be created first with headers and then then ourput from the query is appended. I've tried to skip the file create and header insertion but the data doesn't write to the csv correctly. Any advice? cfquery name=get_all datasource=#datasource# maxrows=55 select * from Employee_main /cfquery !--- Create the file with column header's. It is crucial that you have all the outputed text on one line with no spaces between the comma and the next column header.--- cffile action=write file=D:\Inetpub\wwwroot\HR\employee\cfmscripts\contacts.csv output=ed_first_name, ed_last_name, ed_fi_last_name, ed_title, ed_email, ed_reports_to, ed_department, ed_division, ed_location, ed_phone_number, ed_extension, ed_submitted, ed_state, ed_country, ed_zip_code addnewline=yes !--- Output the contents of the export_contacts query --- cfoutput cfloop query=get_all #TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,#TRIM(ed_ title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)#,#TRIM(e d_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_extension) #,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(ed_country)#,#TRIM(ed_zip_code )# BR / !--- Append (Insert) the contents of the query into the already created CSV file. Make sure that you keep all the output on one line exactly like the column header--- cffile action=WRITE file=D:\Inetpub\wwwroot\HR\employee_directory\cfmscripts\contacts555.csv output=#TRIM(ed_first_name)#,#TRIM(ed_last_name)#,#TRIM(ed_fi_last_name)#,# TRIM(ed_title)#,#TRIM(ed_email)#,#TRIM(ed_reports_to)#,#TRIM(ed_department)# ,#TRIM(ed_division)#,#TRIM(ed_location)#,#TRIM(ed_phone_number)#,#TRIM(ed_ex tension)#,#TRIM(ed_submitted)#,#TRIM(ed_submitted)#,#TRIM(ed_state)#,#TRIM(e d_country)#,#TRIM(ed_zip_code)# addnewline=yes /cfloop /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF7 multiserver config with JRun and SSL = 500 errors
Am I wrong... It sounds like you are trying to get the site to be served via SSL - that would not require you to do anything with the keystore. The keystore comes into play when CF has to make HTTP calls to an SSL URL (cfhttp, web service etc). -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rob Barthle [mailto:r...@barthle.com] Sent: Wednesday, December 02, 2009 3:16 PM To: cf-talk Subject: CF7 multiserver config with JRun and SSL = 500 errors I need some help. I have been put on a project where half the site is run through SSL. I have never set up an SSL site before. First, I configured MAMP Pro (my Apache server) for SSL using these instructions: http://www.webopius.com/content/355/getting-mamp-working-with-ssl-on-os-x Then I followed these instructions to set up a keyStore and trustStore for my CF7 Jrun instance: http://www.bpurcell.org/blog/index.cfm?mode=entryentry=1064 I created different key stores (cedmx7dev.keystore) and trust stores (cedmx7dev.trustStore) because I was getting a weird error using the defaults. I edited the jrun.xml file and uncommented the lines and updated for the ability to use the ProxyService with SSL: !-- = -- !-- This service is for communicating with a native (IIS, Apache, Netscape) -- !-- web server. -- !-- To run this service in a secure mode via SSL, set the keyStore, -- !-- keyStorePassWord, trustStore and socketFactoryName attributes. -- !-- = -- [...] attribute name=keyStore{jrun.rootdir}/lib/cedmx7dev.keystore/attribute attribute name=keyStorePasswordchangeit/attribute attribute name=trustStore{jrun.rootdir}/lib/cedmx7dev.trustStore/attribute attribute name=socketFactoryNamejrun.servlet.jrpp.JRunProxySSLServerSocketFactory/ attribute And the end result is... 500 errors. The Apache log just says this: [notice] jrApache[74382: 26873] JRun will not accept request. Check JRun web server configuration and JRun mappings on JRun server. I am lost and at this point need some help. Thanks in advance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfsqltype error
If you change something on the server (add a column to a table for example) ColdFusion still holds onto the old schema. Consequently it tries to insert into a column that is incorrectly mapped (via the tableid or whatever in the system tables of the db in question). Here's a post with the scoop. http://www.coldfusionmuse.com/index.cfm/2005/4/29/dbschemaChange To mitigate it you need to force the schema to be recached. Restarting CF does it of course, but so does changing some of your queries - adding a space works well on selects for example. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Monday, November 30, 2009 2:35 PM To: cf-talk Subject: cfsqltype error Hi All, I am getting the following error when I am trying to insert data into the database: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER The line one which the error is shown is using a cfqueryparam cfsqltype=cf_sql_varchar value = #somevalue# but the error says cf_sql_integer. can anyone please let me know what could possibly have gone wrong? Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to register Fonts for CF8 Enterprise installation?
H Try copying some true type files into a separate directory somewhere ... Maybe in the ColdFusion directory itself Although I'm struggling to come up with a theory why that would help :) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Hatz [mailto:daveh...@hatzventures.org] Sent: Monday, November 23, 2009 7:13 AM To: cf-talk Subject: Re: How to register Fonts for CF8 Enterprise installation? Mark, I have the service running under a user account that has ADMINISTRATOR rights. I checked the permissions on the /Fonts folder, everyone has access to the folder. Dave ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to register Fonts for CF8 Enterprise installation?
Aha! ... I missed that one. Indeed.. You should be inside of each of your separate instance managers - yes? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Maureen Barger [mailto:m...@cornell.edu] Sent: Monday, November 23, 2009 8:38 AM To: cf-talk Subject: Re: How to register Fonts for CF8 Enterprise installation? You are running multiserver which implies you are using sandbox security? Add your fonts directory to the instance's sandbox security. On Sun, Nov 22, 2009 at 19:43, Dave Hatz daveh...@hatzventures.org wrote: We are running CF8 Enterprise, multi-server, JRun, Windows 2008 box. This is a new installation and we are getting errors trying to produce CFDocument PDFs. When I go into CF Admin, Server Settings, Font Management, there are no Fonts registered. When I try to select the windows font directory, /windows/fonts, CF Admin is throwing errors: com.lowagie.text.FontFactory.getFontProperties()Ljava/util/Map; null brThe error occurred on line 68. http://127.0.0.1/CFIDE/administrator/settings/fonts.cfm We have CF8 running on 2003 on another box and we don't have this problem. Can someone point me in the right direction where to find information on how to register fonts on our CF8 2008 box? Thanks, Dave ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: remote FTP directly from client browser
Robert, I don't think you will be able to do this Unless perhaps you can use a unc path or mnt to some other server (although I fail to see how this would be more secure). What you need is to be able to FTP from the client directly to the FTP server. I guess you will need to look for a Java applet or active X to do that - or possibly a flash object? Of course doing it this way means that the permissions for the FTP will end up on the client (in order to make it's own indpendent connection) which is far less secure (at least for the FTP server) than storing and forwarding the file. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Robert Schimmel [mailto:rschim...@spectir.com] Sent: Monday, November 23, 2009 9:25 AM To: cf-talk Subject: remote FTP directly from client browser So, here is my problem. I need to be able to get a file from a client browser to a remote FTP server without storing the file on the CF server. It's a government project that won't allow cffile to upload a file from the client onto the webserver, but they gave me access to an ftp server (requiring authentication of course). So basically, I want to be able to use cfftp but that appears to only be able to transfer files that are already on the local server. Anyone have a solution that allows the user to get a simple browse interface, i.e. cffile, but can put the file on a remote FTP server? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: remote FTP directly from client browser
Ben, But wouldn't the file be written to physical memory? And if so, you could not guarantee that the OS isn't caching part of the file in the Swap (Unless I'm misunderstanding). Still, it might be enough to check off his requirement. I suspect they won't want the web server to touch the file at all - memory or disk notwithstanding :) -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ben Forta [mailto:b...@forta.com] Sent: Monday, November 23, 2009 9:35 AM To: cf-talk Subject: Re: remote FTP directly from client browser CF9 virtual file system may do what you need. You'll be able to read and write and access files, but they'll not be written to disk on the server. --- Ben (Sent from my phone, please pardon the typos) On Nov 23, 2009, at 10:24 AM, Robert Schimmel rschim...@spectir.com wrote: So, here is my problem. I need to be able to get a file from a client browser to a remote FTP server without storing the file on the CF server. It's a government project that won't allow cffile to upload a file from the client onto the webserver, but they gave me access to an ftp server (requiring authentication of course). So basically, I want to be able to use cfftp but that appears to only be able to transfer files that are already on the local server. Anyone have a solution that allows the user to get a simple browse interface, i.e. cffile, but can put the file on a remote FTP server? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How to register Fonts for CF8 Enterprise installation?
Dave, That's a new one It kind of looks like it's blowing up trying to enumerate. Perhaps it has a permissions problem? What's the service settings for the CF Ap server? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Hatz [mailto:daveh...@hatzventures.org] Sent: Sunday, November 22, 2009 6:44 PM To: cf-talk Subject: How to register Fonts for CF8 Enterprise installation? We are running CF8 Enterprise, multi-server, JRun, Windows 2008 box. This is a new installation and we are getting errors trying to produce CFDocument PDFs. When I go into CF Admin, Server Settings, Font Management, there are no Fonts registered. When I try to select the windows font directory, /windows/fonts, CF Admin is throwing errors: com.lowagie.text.FontFactory.getFontProperties()Ljava/util/Map; null brThe error occurred on line 68. http://127.0.0.1/CFIDE/administrator/settings/fonts.cfm We have CF8 running on 2003 on another box and we don't have this problem. Can someone point me in the right direction where to find information on how to register fonts on our CF8 2008 box? Thanks, Dave ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph
Dom, That is a GREAT play by play... Thanks! Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Thursday, November 19, 2009 9:09 AM To: cf-talk Subject: Re: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph An update on this, for my own reference as well as for people googling. I have, following various people's advice, changed the memory profile of our application quite dramatically and I will summarize what I changed and the tools I used to find the problems. I shall properly blog this later, no time now. Firstly, after installing and using JConsole, I figured it was high time I learned about JVM and its memory spaces. I found the following articles very useful: http://www.slideshare.net/gengmao/inside-the-jvm-memory-management-and-troub leshooting http://www.javaworld.com/javaworld/jw-01-2002/jw-0111-hotspotgc.html I had also followed Paul's advice and increased New Gen space in the heap, which did have an immediate effect, just not as large as I had hoped - more on that in a bit. Next I found error logs in the same directory as the jvm.config file (mine was {colfusion}/runtime/bin), the part dump of which is seen below. It turned out this was a reasonably common error, and not just to do with CF: http://www.talkingtree.com/blog/index.cfm/2006/4/28/Understanding-HotSpot-in -Plain-English This article recommended using the -Xint JVM option to turn off Hotspot optimization. I did this and the effect was pretty disastrous on performance (the effect can vary a lot depending on the nature of your application, apparently). I searched some more and found an article suggesting that to avoid the error, free 'Survivor' space needed increasing - this seemed in line with the state of memory at the time of my crash so I went ahead and started tweaking, bringing me back to Paul's earlier advice but finally seeing me use more dramatic settings: -Xmn384m -XX:SurvivorRatio=1 -XX:TargetSurvivorRatio=25 This says, use 384Mb for new gen, of which 2/3rds will be for Survivor space; also, the GC will aim to keep survivor space at least 75% empty (no more than 25% full). I ended with these figures after a whole heap of teaking that had previously brought my memory spikes down. This had the benefit of clearly showing little jumps in Old Gen memory every 10 seconds or so. I tracked these jumps down using JConsole to spot the time of the jump and SeeFusion to see what templates were requested at those times. My tracking led me to the same page that appeared in my error log, a verity search. I googled and found: Operations on collections (e.g., CFSearch and CFIndex) can cause growth over time. http://kb2.adobe.com/cps/175/tn_17517.html No workarounds, that's just the way it is. I noted the size of memory being eaten by these searches (up to and around 15MB) and ended with the JVM settings quoted above, the idea being that there should be enough new gen memory available to cope with these verity searches (so that object don't just get dumped into Old gen all the time). Finally, and most dramatically, I found some code that allowed a blank search against verity. When I ran it, I found it ate 100-150Mb or RAM each time. Using subversion, I found out when this became possible and why. It turns out this code was committed and deployed the same day we started seeing the crash reports on our servers and that it was an unneccessary change, fixing the symptom of a bug but not the cause. I reverted the change. So now I have a very different JVM memory configuration on one of our live servers and have committed a code change that will alleviate some horrid memory abuse to all three. I have JConsole monitoring all three servers and can see the modified server memory useage starkly contrasted against the other two. I shall keep them running for a while and see how things go... Anyways, enough already. Dominic 2009/11/18 Dominic Watson watson.domi...@googlemail.com Right, so changing Eden memory size had a slight effect on the memory useage pattern (spikes only going up to around 80% instead of 95%), but did not stop the crashing. Getting to grips with JConsole has been really useful / educating. I have been monitoring all three of our live servers overnight and one of the servers bombed this morning; I was then able to see what was going on in memory when the bomb occurred: * Old Gen - normal, using far less than peak * Perm gen - normal, sub 90MB * Eden - normal, far less than the 192MB allocated * Survivor - had been flat at max (20MB) for around 20 seconds. Normal shape of this graph for the server is very spikey, peaking very briefly and very often I then discovered the hs_err log for the crash (yes, I'm a server debugging noob) and it told me the following: # # An unexpected error has been detected by Java
RE: CFHTTP Connection Failure
I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFHTTP Connection Failure
Here's a post on the issue... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:41 PM To: cf-talk Subject: Re: CFHTTP Connection Failure where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.comwrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP Connection Failure
H. So the call to HTTP works, but HTTPS does not URLs are exactly the same I assume you have pinged around and made sure that the 4 servers resolve the domain exactly the same right? And you have tried a CF Restart? Sometimes the DNS cache for the JVM will have the wrong address in it if you have been making networking changes etc. Remember also that each server needs to be examined from the console (from RDP or whatever). You have to be able to troubleshoot by making outgoing requests from the individual servers. Still, I'm with dave. If it works via HTTP but not HTTPS it has to be the certs somehow. This post is about SSL 3.0 http://www.coldfusionmuse.com/index.cfm/2009/2/24/CF-SSL30-Authorize-net But it also includes some info on how to test CF and the JVM and log the results. It is probably worth it to try and trap the handshake conversation and see what's up. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 5:06 PM To: cf-talk Subject: Re: CFHTTP Connection Failure the certs are already there. I compared the server working with the one not working. I actually failed to mention that they were all working fine until yesterday when three of them failed. I have them working with HTTP for now but I need to turn on HTTPS ASAP. I just got off the 3 hour long conference call with my networking guy and the third party tech. It makes me believe that it's on the CF side but I can't figure what it is. On Thu, Nov 19, 2009 at 11:53 AM, Mark Kruger mkru...@cfwebtools.comwrote: Here's a post on the issue... http://www.coldfusionmuse.com/index.cfm/2005/01/29/keystore -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:41 PM To: cf-talk Subject: Re: CFHTTP Connection Failure where do i check that? what do i need to check for? On Thu, Nov 19, 2009 at 11:12 AM, Mark Kruger mkru...@cfwebtools.com wrote: I would say to check the keystore and make sure the cert (and any intermediate certs) is installed. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Agha Mehdi [mailto:aghaime...@gmail.com] Sent: Thursday, November 19, 2009 1:11 PM To: cf-talk Subject: CFHTTP Connection Failure I am having issue connecting to HTTPS through CFHTTP Get/Post. It's throwing Connection Failure. The strange thing is that we have 4 servers in a cluster. it's failing on three servers but running fine from one. Any ideas? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion 8 ODBC Agent won't start on Windows 2008
You cannot use the ODBC service on a 64bit server. It will not work. You will have to go to plan B. Might I suggestion the Access driver from httx - or moving away from access (which is your best option). -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Yves Arsenault [mailto:yves.arsena...@gmail.com] Sent: Monday, November 16, 2009 12:41 PM To: cf-talk Subject: ColdFusion 8 ODBC Agent won't start on Windows 2008 Hi folks, Haven't been around this list in quite a while. I have a CF8 VPS on Windows 2008(64 bit) that I've started moving sites to for a client. A couple of these sites use MS Access databases and when I've tried to create a DSN in CF Admin I keep getting the following message: The ColdFusion ODBC Server service is not running or has not been installed. You may also use the MS Access with Unicode driver to connect to MS Access datasources. When I try to start the CF ODBC Server I keep getting the following message: Error 1053: The service did not respond to the start or control request in a timely fashion. Has anyone seen this? I know that from what I've read, the 64bit Windows 2008 does not comme with ODBC drivers for MS Access. Any ideas?? I'm still googling!! Thanks, Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion 8 ODBC Agent won't start on Windows 2008
Take a look at this post... And read the comments as well. http://www.coldfusionmuse.com/index.cfm/2009/4/7/MS.Access.Proxy Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Yves Arsenault [mailto:yves.arsena...@gmail.com] Sent: Monday, November 16, 2009 12:41 PM To: cf-talk Subject: ColdFusion 8 ODBC Agent won't start on Windows 2008 Hi folks, Haven't been around this list in quite a while. I have a CF8 VPS on Windows 2008(64 bit) that I've started moving sites to for a client. A couple of these sites use MS Access databases and when I've tried to create a DSN in CF Admin I keep getting the following message: The ColdFusion ODBC Server service is not running or has not been installed. You may also use the MS Access with Unicode driver to connect to MS Access datasources. When I try to start the CF ODBC Server I keep getting the following message: Error 1053: The service did not respond to the start or control request in a timely fashion. Has anyone seen this? I know that from what I've read, the 64bit Windows 2008 does not comme with ODBC drivers for MS Access. Any ideas?? I'm still googling!! Thanks, Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion 8 ODBC Agent won't start on Windows 2008
Yes, to get that specific fix to work... But the comments reference a 64bit Access driver by HTTX. That would probably be the quickest path for you. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Yves Arsenault [mailto:yves.arsena...@gmail.com] Sent: Monday, November 16, 2009 1:28 PM To: cf-talk Subject: Re: ColdFusion 8 ODBC Agent won't start on Windows 2008 I'm thinking I'll probably need to to switch to something else. As I understand it, I would need a 32bit server to get that to work? Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. On Mon, Nov 16, 2009 at 2:59 PM, Mark Kruger mkru...@cfwebtools.com wrote: Take a look at this post... And read the comments as well. http://www.coldfusionmuse.com/index.cfm/2009/4/7/MS.Access.Proxy Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Yves Arsenault [mailto:yves.arsena...@gmail.com] Sent: Monday, November 16, 2009 12:41 PM To: cf-talk Subject: ColdFusion 8 ODBC Agent won't start on Windows 2008 Hi folks, Haven't been around this list in quite a while. I have a CF8 VPS on Windows 2008(64 bit) that I've started moving sites to for a client. A couple of these sites use MS Access databases and when I've tried to create a DSN in CF Admin I keep getting the following message: The ColdFusion ODBC Server service is not running or has not been installed. You may also use the MS Access with Unicode driver to connect to MS Access datasources. When I try to start the CF ODBC Server I keep getting the following message: Error 1053: The service did not respond to the start or control request in a timely fashion. Has anyone seen this? I know that from what I've read, the 64bit Windows 2008 does not comme with ODBC drivers for MS Access. Any ideas?? I'm still googling!! Thanks, Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hosting options
James, Have you thought of cloud hosting using BD or Ralio? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Tuesday, November 10, 2009 9:16 AM To: cf-talk Subject: Re: Hosting options I can only recommend Viviotech. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/11/10 Rob Voyle robvo...@voyle.com: Hi folks I have about 6 sites that run CF and need to move them to a new host. any recommendations? I see that godaddy offers CF for $1.99 a month. Has anyone used them. Or does anyone have any recommendations. I am tired of being on small providers that seem to get bought and sold by who knows what. Thanks Rob ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Trouble with query...
Not ifnull ... I'ts isnull .. ISNULL(col,0) AS alias Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: Saturday, October 24, 2009 6:04 PM To: cf-talk Subject: Re: Trouble with query... i'm not very familiar with sql server syntax, but would something like this work? SELECT IFNULL(cpn.numCoupons,0) as numCoupons, couponcode, THEORDERDATE Hmm. didn't work. SQL server didn't like it. :( I just simplified it and didn't break it down by the day. I got somethin that'll work for now. Thanks jessica! Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327653 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Education
Rick, That is so funny I have a BA in Theology, a BA in Music and I'm just shy of a master in Sociology - and here I am working in computer development :) It's not surprising how many folks have Music as a part of their skill set who are also programmers. There's a natural synergy there I think. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Friday, October 23, 2009 3:10 PM To: cf-talk Subject: RE: Education I have 5 degrees: - Associate of Arts (1980) - Bachelor of Music (1983) - Master of Theology (1992) and the most applicable ones for programming and business: - Masters from the School of Hard Knocks - Doctorate of PraKnApp (Practical Knowledge and Application) from the CF-Talk School of Higher Education...although, I would hardly truly qualify for a doctorate in the course material here...I just know enough to make a living as a free-lancer (what else is there a need for? :o) Rick -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Friday, October 23, 2009 3:31 PM To: cf-talk Subject: Re: Education Ian Skinner wrote: CF 9 - 2009 CF 8 - 2008 CF 7 - 2007 CF 6 - 2006. I believe that ColdFusion development cycle is two to three years per version. According to Wikipedia yes every two or three years. 2002-May : Macromedia ColdFusion MX version 6.0 2005 : Macromedia ColdFusion MX 7 2007-July-30 : Adobe ColdFusion 8 2009-October-05 : Adobe ColdFusion 9 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: After the fact: SQL Injection Scanner
If the injection was the one that went around a few months ago - check out this post http://www.coldfusionmuse.com/index.cfm/2008/7/18/Injection-Using-CAST-And-A SCII There is a reverse stored procedure that can undo the damage down in the comments. Be sure and read the post and comments (and related posts) - otherwise you will fight this over again until you get it right :) -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mosh Teitelbaum [mailto:mosh.teitelb...@evoch.com] Sent: Wednesday, October 21, 2009 2:10 PM To: cf-talk Subject: After the fact: SQL Injection Scanner All: A client called today letting me know that their server had been breached and that some malicious code had been uploaded to the site. After doing some research into the particular files that were uploaded, it turns out that the attack is also usually accompanied by a SQL Injection attack. Their database is huge and, instead of manually going through the database looking for altered records, I thought to write some code that would scan the records and report any potential problems. Before doing that, does anyone know of any existing code that does that? Thanks in advance. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 WWW: http://www.evoch.com/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8, 64 bit, and Microsoft Access
There IS an Access driver that is 64 bit. It is httx. You can also jury rig a proxy ws to a 32bit server (which is how I handled it for a data export). That approach assumes you have access to both types of server and on a shared host is probably out of the question. The 64bit driver may be out of the question as well. Here's a post on the topic. http://www.coldfusionmuse.com/index.cfm/2009/4/7/MS.Access.Proxy The notes below have some comments on the 64 bit driver. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: John Pullam [mailto:jpul...@mcleansystems.com] Sent: Thursday, October 15, 2009 12:02 PM To: cf-talk Subject: CF8, 64 bit, and Microsoft Access I've just been told by my ISP that CF8 doesn't support Microsoft Access on a 64 bit server, and seeing as they are implementing it on a 64 bit server, I'm in trouble. Don't get me wrong--I understand that Access isn't strategic and I will be moving away from it, but I have an app that gets an Access mdb and must process it and I really need to move up to CF8 to start adding Ajax features. Is it true? And if yes, is there anything I can do? Are there technical alternatives to allow me to use Access from a 64 bit CF8 system? I looked at the brief CF9 doc on the Adobe site and it implied that Access is fully supported. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfcontent create file
Richard, You don't really need CFCONTENT (which actually sets up headers in the browser). You are not trying to send your content to the output buffer of IIS. Try cfsavecontent instead. cfsavecontent variable=content {\rtf1\ansi\ansicpg1252\uc1\deff0=stshfdbch0 etc... /cfsavecontent cffile action=write output=#content# file=full file and path name.rff/ -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Richard White [mailto:rich...@j7is.co.uk] Sent: Wednesday, October 14, 2009 10:57 AM To: cf-talk Subject: cfcontent create file hi we are using cfcontent and rich text to create a word doc as follows: cfcontent type=application/mswordcfoutput{\rtf1\ansi\ansicpg1252\uc1\deff0\stshfd bch0 etc.../cfoutput however when we run the cfm page it brings up the download option, whereas we want to create the file and store it on the server can anyone help with this? thanks richard ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Rather big log
You may also need to delete the client key. It could be that the Registry is full and new entries are not able to be written. If you switch to something else (DB or cookie), the CF routine that handles purging will still attempt to clear out these variables. If you do decide to clear navigate to HCLM/software/macromedia/ColdFusion/currentversion/ and right click on clients and choose delete. I recommend that you do not try to expand the clients key. If you do you might as well go for a cup of coffee :) Of course it could be that someone has altered permissions for writing to the registry (that's a common method of preventing client vars that I've heard recommended) - in which case simply switching to something else will do the trick. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Wednesday, October 07, 2009 11:49 PM To: cf-talk Subject: RE: Rather big log I'm guessing the way to solve that would be to stop using the registry to store client variables. I recommend a database-- but if you must, cookies would still be a better option than registry. If you're also having the same problem with your logs not rolling over, check out this link from the original post on CF-Talk. http://www.succor.co.uk/index.cfm/2006/5/2/Massive-CFJrun-log-files http://www.adobe.com/go/24039877 ~Brad Original Message Subject: Re: Rather big log From: Jeff Gould jgo...@princetonol.com Date: Wed, October 07, 2009 10:51 pm To: cf-talk cf-talk@houseoffusion.com Ooooh dear. I just checked in C:\CFusionMX7\runtime\logs\ and the coldfusion-out.log is a whopping 500MB. It is packed to the rafters with nearly 2 million lines like these: 09/25 20:03:59 Information [jrpp-99] - Unable to set value HKEY_LOCAL_MACHINE\SOFTWARE\ Macromedia\ColdFusion\CurrentVersion\Clients\290377-98442833\urltoken: Gareth, I am having the same problem. Do you remember what you did to resolve this? Thanks. Jeff ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327029 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF load times on VPS
Chip, As Jordan pointed out much of the stuff to check will be up to your NOC support guys. Here's things that come to the top of my head. Sometimes hosts use virtual network to isolate your system from other systems in the same data center or on the same rack. In that case the connection is going through VPN protocols which can incur overhead. In addition, DNS comes into play if you are using a FQDN (your machine has to look it up). Note: If you use an IP address your stack will actually look up the Reverse address :) You could be running into inside/outside firewall behavior where your traffic is hitting the firewall which routes it back to the other box - making the inside interface of the firewall a possible bottleneck. You could also be running afoul of NIC capacity on the VPS - which shares it's overall capacity with N number of VPS on the same box. Of course if the 2 servers are in different locations you might be onto something with the hop count or total number of interfaces that examine the packets en route. And further up the stack (as Jared mentioned) are drivers, driver settings, connection pooling etc. That's all I can think of. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Chip Beck [mailto:chipb...@gmail.com] Sent: Wednesday, October 07, 2009 4:22 PM To: cf-talk Subject: Re: CF load times on VPS Thanks to everyone for the responses. I wanted to respond in case any other novices to dedicated machines run into the same issue. After debugging, I realized the performance issue was in the database query time. As MySQL was being run on a separate box, for whatever reason the connection between my VPS and the database-hosting box was not as fast as the connection between my shared host and the MySQL database it was querying. Was this because of physical distance between boxes? Maybe they were housed in different locations? What are the major factors that contribute to the speed at which CF talks to MySQL or any database for that matter? On Wed, Sep 16, 2009 at 12:29 PM, Jordan Michaels jor...@viviotech.netwrote: +1 The debugging information is what you need to get your hands on here. I'm not familiar with how KA's setup is, but if you have access to the CF Admin you can just turn it on from there, hit your page, and debugging info will show up at the bottom. That should provide some real insight as to what's causing the hang-up. Sending this question to KAVPS Support may also be a good idea. They would be most familiar with their VPS's and maybe they've run into this problem before. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider b...@bradwood.com wrote: Can you turn on debugging, or better yet, install SeeFusion on both servers? Then it's a simple matter of looking to see what is taking so long. Stack traces are your friend here. I *doubt* it is directly related to the fact that the file is big (unless you're talking megabytes-big) other than the fact that you have more room to cram poorly performing queries in a larger file. :) ~Brad Original Message Subject: CF load times on VPS From: Chip Beck chipb...@gmail.com Date: Wed, September 16, 2009 9:41 am To: cf-talk cf-talk@houseoffusion.com Forgive me in advance for this seemingly vague question, but I'm mostly just asking for suggestions on a general method of troubleshooting this... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327012 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion Enterprise or Standard Installed?
Robert, Find the serial number (in license.properties) and go to an existing CF installation - even one on your dev box - and update the serial number. Then look at the server settings. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Robert Kelso [mailto:robert.ke...@forensicpursuit.com] Sent: Monday, September 28, 2009 1:39 PM To: cf-talk Subject: Cold Fusion Enterprise or Standard Installed? Hi guys, I'm doing a computer forensic investigation on a bad hard drive with Cold Fusion MX7 installed. I'm trying to find out if the installed version is Enterprise or Standard. Is there a way I can determine in the version is Enterprise or Standard just by looking at the files on the hard drive. Please note that I'm viewing this drive as an external drive, so I cannot actually run the Cold Fusion, I can only look at the files and their content. Any help would be appreciated. Thanks! Robert Kelso Forensic Pursuit robert.ke...@forensicpursuit.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion Enterprise or Standard Installed?
Doh! That is better :) -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Monday, September 28, 2009 2:33 PM To: cf-talk Subject: RE: Cold Fusion Enterprise or Standard Installed? Better yet-- if you have access to the server.log file, crack it open and look at its last restart: Information,main,09/04/09,15:24:12,,Starting logging... Information,main,09/04/09,15:24:12,,Starting license... Information,main,09/04/09,15:24:14,,Enterprise Edition enabled It should tell you what version was enabled after the starting license part. ~Brad Original Message Subject: RE: Cold Fusion Enterprise or Standard Installed? From: Mark Kruger mkru...@cfwebtools.com Date: Mon, September 28, 2009 2:21 pm To: cf-talk cf-talk@houseoffusion.com Robert, Find the serial number (in license.properties) and go to an existing CF installation - even one on your dev box - and update the serial number. Then look at the server settings. -Mark ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion Enterprise or Standard Installed?
Log into he CF admin (i.e. http://127.0.0.1/cfide/administrator/. On the left hand side under server settings there is a link to settings summary. Click on it and at the top you will see something like the following: Server Product ColdFusion MX Version 7,0,2,142559 Edition Standard Serial Number x-xx Operating System Windows 2003 OS Version 5.2 The edition value is the one you are looking for. -Mark -Original Message- From: Robert Kelso [mailto:robert.ke...@forensicpursuit.com] Sent: Monday, September 28, 2009 3:17 PM To: cf-talk Subject: Re: Cold Fusion Enterprise or Standard Installed? Mark, Since the server.log didn't seem to give me what I was looking for, I started down the road of your idea of replacing the S/N into an existing installation of ColdFusion. Of course, I had no such thing since I am a computer forensics guy, not a developer and I've never used ColdFusion. Regardless, I downladed and installed a trial version of Cold Fusion and replaced the serial number into my own license.properties file. Not sure where to go from here though. I'm sure look at the server settings makes perfect sense to all the ColdFusion developers out there, but I don't really know what that means. By the way, the serial number I extracted is CED700-53365-17253-87902. If it would be really fast for you pop this serial number into one of your ColdFusion installations and see what information you can gather, I would dearly appreciate it. I could probably even arrange for some compensation for your efforts. Let me know if you'd to give it a try. Thanks! Hi Brad, Thanks for that (Thanks to Mark as well). I have looked through the server log but see no reference to either Enterprise or Standard. Do you think the absence of the line Enterprise Edition enabled means that non-Enterprise edition was installed, or could it be something else? Here's an excerpt from my log: Information,main,05/14/07,19:46:55,,D:\CFusionMX7\logs\server. log initialized Information,main,05/14/07,19:46:55,,Starting logging... Information,main,05/14/07,19:46:55,,Starting crypto... Information,main,05/14/07,19:46:56,,Starting license... Information,main,05/14/07,19:46:56,,Starting License server ... Information,main,05/14/07,19:46:58,,Starting scheduler... Information,main,05/14/07,19:46:58,,Starting WatchService... Information,main,05/14/07,19:46:58,,Starting debugging... Information,main,05/14/07,19:46:58,,Starting sql... Information,main,05/14/07,19:46:58,,Starting mail... Information,main,05/14/07,19:46:58,,CORBA Configuration not enabled Information,main,05/14/07,19:46:58,,Starting cron... Information,main,05/14/07,19:46:58,,Starting registry... Information,main,05/14/07,19:46:58,,Starting client... Information,main,05/14/07,19:46:58,,Starting xmlrpc... Information,main,05/14/07,19:46:58,,Starting graphing... Information,main,05/14/07,19:46:58,,Starting verity... Information,main,05/14/07,19:46:58,,Starting archive... Information,main,05/14/07,19:46:58,,Starting document... Information,main,05/14/07,19:46:59,,Starting eventgateway... Information,main,05/14/07,19:46:59,,Starting FlexAssembler... Information,main,05/14/07,19:46:59,,ColdFusion started Information,main,05/14/07,19:50:07,,Starting logging... Information,main,05/14/07,19:50:07,,Starting crypto... Information,main,05/14/07,19:50:07,,Starting license... Information,main,05/14/07,19:50:07,,Starting License server ... Information,main,05/14/07,19:50:08,,Starting scheduler... Information,main,05/14/07,19:50:08,,Starting WatchService... Better yet-- if you have access to the server.log file, crack it open and look at its last restart: Information,main,09/04/09,15:24:12,,Starting logging... Information,main,09/04/09,15:24:12,,Starting license... Information,main,09/04/09,15:24:14,,Enterprise Edition enabled It should tell you what version was enabled after the starting license part. ~Brad Robert, Find the serial number (in license.properties) and go to an existing CF installation - even one on your dev box - and update the serial number. Then look at the server settings. -Mark ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion Enterprise or Standard Installed?
Er Uh Hmmm Good question. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Monday, September 28, 2009 3:41 PM To: cf-talk Subject: Re: Cold Fusion Enterprise or Standard Installed? Log into he CF admin (i.e. http://127.0.0.1/cfide/administrator/. On the left hand side under server settings there is a link to settings summary. Click on it and at the top you will see something like the following: Server Product ColdFusion MX Version 7,0,2,142559 Edition Standard Serial Number x-xx Operating System Windows 2003 OS Version 5.2 The edition value is the one you are looking for. -Mark I do wonder how the CF8 trial he most likely downloaded and installed is going to digest a CF 7 license key forced into it's license.property file? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfc's above the webroot
Phil, You can create a CF mapping that points to your data directory ... Say 'cfclib' ... And then use it as in: Component=cfclib.cfcfilename Keep in mind that a CFC outside the web root is going to be innaccessible via Ajax or remoting (of course you could extend it using a component inside the web root making only the access=remote methods available). -Mark -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Thursday, September 24, 2009 9:49 AM To: cf-talk Subject: cfc's above the webroot I would like to store my CFC's above my webroot (../Data/cfc to be precise). Do I need any special coding to show this? cfinvoke component=CFCFILENAME.CFCCOMPONENT method=CFCFUNCTION returnvariable=RETURNVARIABLE/cfinvoke It seems to me cfc's MUST be on the webroot for this to function correctly. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfc's above the webroot
It's always good to be security conscious :) Without the ability to fully control the server here's one trick (a little clunky but serviceable). You can put your CFCs in a subfolder and include an application.cfc in the subfolder that aborts any requests directly to that folder. /application.cfc /index.cfm .. Calls to createobject(cfclib.mycomponent) /cfclib/application.cfc ... Includes an abort in onRequest /cfclib/mycomponent.cfc - your component As long as you are accessing the CFC from index.cfm the application in question will be the one from the root /... But trying to access it directly from a URL (for example) will cause it to fail. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Thursday, September 24, 2009 10:13 AM To: cf-talk Subject: Re: cfc's above the webroot Ok.. Let's pretend though that I don't have access to mapping (shared hosting). Any other way or am I just being to security conscious about cfcs in the webroot? On Thu, Sep 24, 2009 at 8:11 AM, chornobyl chorno...@gmail.com wrote: You can make a mapping to a folder outside of the root, and point the request to the mapping. On Thu, Sep 24, 2009 at 10:49 AM, Phillip Vector vec...@mostdeadlygame.comwrote: I would like to store my CFC's above my webroot (../Data/cfc to be precise). Do I need any special coding to show this? cfinvoke component=CFCFILENAME.CFCCOMPONENT method=CFCFUNCTION returnvariable=RETURNVARIABLE/cfinvoke It seems to me cfc's MUST be on the webroot for this to function correctly. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Form Output Iteration/Looping Question
Something bothers me about your code below... tr#form.vendor_id5#td#form.nvc_id5#/td/tr Shouldn't there be a td after the tr Anyway, you could do the same thing like so... cfoutput cfloop from=4 to=49 index=x trtd#form['vendor_id' x]#/tdtd#form['nvc_id' x]#/td/tr /cfloop /cfoutput Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: patrick buch [mailto:patrick.b...@verizon.com] Sent: Wednesday, September 23, 2009 9:59 AM To: cf-talk Subject: Form Output Iteration/Looping Question Hi, Thank you for taking a minute to look at my post... In the form output section below, I'm wondering how to dynamically add the number at the end of the id (form.vendor_id* form.nvc_id*). I should be able to loop and dynamically create the output section below instead of hardcoding the numbers like I have. The ID numbera (4-19) represents the recordkey in the db. * FORM INPUT * input type=hidden id=vendor_id name=vendor_id#recordkey# value=td#vendor#/tdtd#item_id#/tdtd#description#/td cfinput type=Text name=nvc_id#recordkey# maxlength=100 required=yes size=3 * FORM OUTPUT * cfelseif form.ID eq ont_count trtdPlant: /tdtd#form.plant#/td/tr tr#form.vendor_id4#td#form.nvc_id4#/td/tr tr#form.vendor_id5#td#form.nvc_id5#/td/tr tr#form.vendor_id6#td#form.nvc_id6#/td/tr tr#form.vendor_id7#td#form.nvc_id7#/td/tr tr#form.vendor_id8#td#form.nvc_id8#/td/tr tr#form.vendor_id9#td#form.nvc_id9#/td/tr tr#form.vendor_id10#td#form.nvc_id10#/td/tr tr#form.vendor_id11#td#form.nvc_id11#/td/tr tr#form.vendor_id12#td#form.nvc_id12#/td/tr tr#form.vendor_id13#td#form.nvc_id13#/td/tr tr#form.vendor_id14#td#form.nvc_id14#/td/tr tr#form.vendor_id15#td#form.nvc_id15#/td/tr tr#form.vendor_id16#td#form.nvc_id16#/td/tr tr#form.vendor_id17#td#form.nvc_id17#/td/tr tr#form.vendor_id18#td#form.nvc_id18#/td/tr tr#form.vendor_id19#td#form.nvc_id19#/td/tr /cfif Hope you have all the info you need. If you have any questions, please ask. Thank you again for looking at this post. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help: DSN across VPN with virtual IP
Kris, No problem. Send me a note if you get it figured out. I'll be curious. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: Sunday, September 20, 2009 1:30 PM To: cf-talk Subject: Re: Help: DSN across VPN with virtual IP Mark, Thanks for the suggestions. I had just emailed them last night about the other 2 services, and am prepping a test file to check on reading/writing just as you suggest. Glad to see I'm thinking down the right path on this one. I'll also send the suggestion on the hosts file entry. Never would have thought of it. Thanks much. Cheers, Kris I would take the time to create a test script and try to access ANY file on the share (like a text file). You must use the unc path formatted correctly (\\servername\sharename\path\filename.mbd). One other thing that is often forgotten is that the ODBC system in MX is a separate service. CF actually interfaces with the ColdFusion 8 ODBC Server service and the ColdFusion 8 ODBC Agent service. Each of these will need to be running as a registered user as well. Networking is even more tricky. I usually add a HOSTS file entry for the servername that points to the VPN IP address (routing can be tricky). Otherwise it may not be able to resolve the server name or it may resolve it using some other means and give you the real instead of the vpn address. Keep in mind that this VPN connection must be available to all users and not just a connection dialed by a user (i.e. logging in and connecting) - it needs to be running at a lower level than the desktop and stay connected. To test from the CF user context you can use cfexecute to ping the IP. If it doesn't resolve that is likely your issue. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help: DSN across VPN with virtual IP
Kris, I would take the time to create a test script and try to access ANY file on the share (like a text file). You must use the unc path formatted correctly (\\servername\sharename\path\filename.mbd). One other thing that is often forgotten is that the ODBC system in MX is a separate service. CF actually interfaces with the ColdFusion 8 ODBC Server service and the ColdFusion 8 ODBC Agent service. Each of these will need to be running as a registered user as well. Networking is even more tricky. I usually add a HOSTS file entry for the servername that points to the VPN IP address (routing can be tricky). Otherwise it may not be able to resolve the server name or it may resolve it using some other means and give you the real instead of the vpn address. Keep in mind that this VPN connection must be available to all users and not just a connection dialed by a user (i.e. logging in and connecting) - it needs to be running at a lower level than the desktop and stay connected. To test from the CF user context you can use cfexecute to ping the IP. If it doesn't resolve that is likely your issue. That's all I can think of - hope it helps :) -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: Saturday, September 19, 2009 5:49 PM To: cf-talk Subject: Help: DSN across VPN with virtual IP Hi all, I'm trying to help a client work out an interim fix for a security issue. They need to move the administrative interface for some CF applications off of their public-facing website. The applications store some sensitive data that require there be no public interface available. The interim solution is to move the administrative interfaces onto a web-server inside their firewall, create a VPN from this box to the external public-facing web-server, and connect to the databases using the VPN tunnel. The databases in question are SQL Server or Access. They've got the VPN functional (using virtual IP configuration), and have mapped a drive through to the directory where the Access DBs reside. Unfortunately, they're getting an error trying to create the DSN on the internal ws. The servers are Windows servers. Using either the drive-letter of the mapped path, or a UNC addressing scheme, the error received is: Connection verification failed for data source:[datasourcename] java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. They also tried using the Access Unicode driver, and get a slightly different error, but essentially the same: Connection verification failed for data source:[datasourcename] com.inzoom.adojni.ComException: Not a valid file name. The root cause was that: com.inzoom.adojni.ComException: Not a valid file name. in Microsoft JET Database Engine code=0 Type=1 They have checked the user the CF services are running under, have logged in as that user and verified that it has access to the share and the files therein. Also, CF can successfully create Access DSNs on the local server without problem. Any suggestions would be most appreciated. Cheers, Kris ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: coldfusion barcode
Friend and Guru Ryan Stille produced a bar code component for us that uses an inexpensive commercial java class. http://www.stillnetstudios.com/2d-barcodes-coldfusion/ -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Friday, September 18, 2009 11:01 AM To: cf-talk Subject: Re: coldfusion barcode This may also help to use Barbecue (although the package may have changed a little since then). http://www.bifrost.com.au/blog/index.cfm/2006/8/24/Generating-Barcodes-with- Barbecue-and-Coldfusion mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/9/18 Kevin Pepperman chorno...@gmail.com: I have used the java lib barbecue http://barbecue.sourceforge.net/index.html in CFML before and it worked out well. On Fri, Sep 18, 2009 at 9:22 AM, Phillip Vector vec...@mostdeadlygame.comwrote: I forget where I've seen it, I think RIAForge has barcode39.cfm. It's a nice piece of program and generates lots of different types of codes. Here's the code if you want it.. !--- = = FILE: barcode39.cfm - Custom tag for Code 39 (3 from 9) barcodes VERSION: 1.0 AUTHOR: Philip Pearson (Inspired by Ryan Masuga's UPCA version) MODIFIED BY: pears...@aquinas.vic.edu.au WRITTEN: 17/11/2004 DESCRIPTION: Writes barcodes in a browser window ready to be printed and scanned. COMMENTS: Code 39 specs from www.barcodeman.com = == --- !--- These are fairly self explanatory --- cfparam name=Attributes.InputValue default=INVALID cfparam name=Attributes.BarWidth default=2 cfparam name=Attributes.BarHeight default=50 cfparam name=Attributes.TextTop default= cfparam name=Attributes.TextBottom default= cfparam name=Attributes.TextFontTop default=font: bold 14px Arial, sans-serif cfparam name=Attributes.TextFontBottom default=font: bold 18px Courier, sans-serif cfparam name=Attributes.MarginTop default=0 cfparam name=Attributes.MarginBottom default=0 !--- Initialize array. Note: not all characters are supported by the code 39 specification, --- !--- so invalid characters will show as a $ sign. Lowercase not supported either. --- cfset code39 = ArrayNew(1) cfloop index=i from=1 to=256 cfset code39[i] = 01110 !--- '$' is default init string --- /cfloop !--- Load array with all the supported characters' bar attributes --- cfset code39[32] = 001101000 !--- --- cfset code39[36] = 01110 !--- $ --- cfset code39[37] = 00111 !--- % --- cfset code39[42] = 001101000 !--- * --- cfset code39[43] = 01011 !--- + --- cfset code39[45] = 000111000 !--- - --- cfset code39[46] = 100101000 !--- . --- cfset code39[47] = 01101 !--- / --- cfset code39[48] = 001100100 !--- 0 --- cfset code39[49] = 100010100 !--- 1 --- cfset code39[50] = 010010100 !--- 2 --- cfset code39[51] = 11100 !--- 3 --- cfset code39[52] = 001010100 !--- 4 --- cfset code39[53] = 101000100 !--- 5 --- cfset code39[54] = 011000100 !--- 6 --- cfset code39[55] = 000110100 !--- 7 --- cfset code39[56] = 100100100 !--- 8 --- cfset code39[57] = 010100100 !--- 9 --- cfset code39[65] = 100010010 !--- A --- cfset code39[66] = 010010010 !--- B --- cfset code39[67] = 11010 !--- C --- cfset code39[68] = 001010010 !--- D --- cfset code39[69] = 10110 !--- E --- cfset code39[70] = 01110 !--- F --- cfset code39[71] = 000110010 !--- G --- cfset code39[72] = 100100010 !--- H --- cfset code39[73] = 010100010 !--- I --- cfset code39[74] = 001100010 !--- J --- cfset code39[75] = 100010001 !--- K --- cfset code39[76] = 010010001 !--- L --- cfset code39[77] = 11001 !--- M --- cfset code39[78] = 001010001 !--- N --- cfset code39[79] = 10101 !--- O --- cfset code39[80] = 01101 !--- P --- cfset code39[81] = 000110001 !--- Q --- cfset code39[82] = 10011 !--- R --- cfset code39[83] = 01011 !--- S --- cfset code39[84] = 00111 !--- T --- cfset code39[85] = 100011000 !--- U --- cfset code39[86] = 010011000 !--- V --- cfset code39[87] = 110001000 !--- W --- cfset code39[88] = 001011000 !--- X --- cfset code39[89] = 101001000 !--- Y --- cfset code39[90] = 011001000 !--- Z --- !--- Code 39 specification requires * at the start and end of the barcode --- cfset Attributes.InputValue = * Attributes.InputValue * cfoutput span style=#Attributes.TextFontTop##Attributes.TextTop#/span div cfloop index=i from=1 to=#len(Attributes.InputValue)# span
RE: Coldfusion + Cloud
If you are using EC2 you might find a saved instance with CF (trial) pre installed (I know there is one for Blue Dragon/MySQL/CentOS for example). Spool up the instance amd use it - keep in mind that the CF license agreements are probably violated by production cloud usage (not sure on this point ... Someone help me out). The learning curve here is not CF, it is EC2. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, September 16, 2009 11:33 AM To: cf-talk Subject: Re: Coldfusion + Cloud Where can I find comprehensive setup guidelines for CF on cloud including setting up dsn for mysql in windows environment. There is not enough information in that question to provide an answer. What cloud vendor? Amazon? One of the myriad front-ends to Amazon, like Stax? Your own virtualization environment? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Stung by HostMySite price increase?
Yes the proc license is really the only way to go... The difficulty in switching depends greatly on your code. IT could be quite easy - or require rewriting every query. I recently helped a customer go from MySQL to MSSQL and I wrote a couple of posts on it. It will give you an idea of the type of difficulty you might encounter. http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m ssql Hope this helps (a little) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Billy Cox [mailto:bi...@oldworldspices.com] Sent: Friday, September 04, 2009 10:18 AM To: cf-talk Subject: Stung by HostMySite price increase? We recently got a note from HostMySite (now Hosting.com) telling us about a big price increase in SQL Server licensing. We've had a dedicated server with HMS for about a year and the mere thought of shopping for a new hosting provider makes me feel tired. Has anyone else encountered this? We have considered purchasing our own SQL Server licensing and I am wondering (predictably) whether a processor license is the only way to go for a web app database. How hard is it to switch from SQL Server to MySQL? -- *Billy Cox* IT Manager *Old World Spices* bi...@oldworldspices.com 816.861.0400 x138 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: submit one big form post of all tabs
Ah... Right ... Actually I think it treats those includes more like frames or ajaxian innerHTML elements. You would likely have to write some JS to extract the form elements prior to submission. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Friday, August 28, 2009 5:16 AM To: cf-talk Subject: Re: submit one big form post of all tabs yes that would work but not with using includes with the tabs or source. the issue is that when you do it with an include it does not work due to CF thinking you dont have a completed form Sorry I meant wrapping the whole set of tabs in 'form tags' ... I didn't mean to confuse you :) -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com Glyn, I have done this using cflayout and wrapping the whole set of tabs in from tabs. What problems are you experiencing? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com someone must have done this before? using tab layout in CF8 had tabs with just one form post submitting all data in all tabs at once? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cfemail issue(s)
Victor, Do you mean you are passing a list of 500 addresses in a single attribute? As in: cfmail to=b...@blah.com,bl...@blah.com ... If that is what you are doing I would not be surprised if there is a buffer for that attribute that truncates your string at some point. You would be better off looping through your addresses. Meanwhile you can try restarting the spooler: cflock type=EXCLUSIVE name=MailSpoolServiceLock timeout=10 throwontimeout=No cfobject action=CREATE type=JAVA class=coldfusion.server.ServiceFactory name=factory cfset MailSpoolService = factory.getMailSpoolService() cfset MailSpoolService.restart() /cflock -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Victor Moore [mailto:victor.mo...@gmail.com] Sent: Thursday, August 27, 2009 9:56 AM To: cf-talk Subject: Cfemail issue(s) Hi all, I have a couple of issues with cfmail. Environment: Windows 2003, CF8.01 ent The server stopped sending emails After checking the logs .I found out that it stopped after complaining that one email had Invalid Address which is strange because I check all emails using isEmail () before sending and I looked at all the emails in the spool directory and none have any bad email addresses.The one that CF was complaining about had 500 email addresses but all are valid. After that, no emails are sent out. They just sit in the spool directory. I have tried to move them in and out, play with CF admin mail settings but no luck. Somehow the original message caused CF server to ignore mail messages in the spool directory. So my questions are: Is it possible to re-send the emails, short of restarting CF? Second why would an email fail with Invalid address if all the emails are valid email addresses. Third, why will that error cause CF server to black out and stop sending emails (even if after I have manually removed the so called offending email with Invalid Address) Thanks Victor ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325776 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: submit one big form post of all tabs
Glyn, I have done this using cflayout and wrapping the whole set of tabs in from tabs. What problems are you experiencing? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Tuesday, August 25, 2009 11:48 AM To: cf-talk Subject: Re: submit one big form post of all tabs someone must have done this before? using tab layout in CF8 had tabs with just one form post submitting all data in all tabs at once? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: submit one big form post of all tabs
Sorry I meant wrapping the whole set of tabs in 'form tags' ... I didn't mean to confuse you :) -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, August 25, 2009 11:56 AM To: cf-talk Subject: RE: submit one big form post of all tabs Glyn, I have done this using cflayout and wrapping the whole set of tabs in from tabs. What problems are you experiencing? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Tuesday, August 25, 2009 11:48 AM To: cf-talk Subject: Re: submit one big form post of all tabs someone must have done this before? using tab layout in CF8 had tabs with just one form post submitting all data in all tabs at once? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion Web Service question
I would suspect the WSDL file and examine it first. If the WSDL file is missing some node then perhaps the compiler is creating path information but has not methods to stub out. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rin C. [mailto:pager...@gmail.com] Sent: Wednesday, August 19, 2009 8:58 AM To: cf-talk Subject: ColdFusion Web Service question Hi all, I have a few questions about an issue that is occuring at my office. We have several ColdFusion boxes and we often invoke web services. It has been my experience that ColdFusion 8 generates stub class files when a web service is invoked. However, we just recently began running into a problem where one of our ColdFusion instances will generate a folder in the stubs directory, and then generate all of the subfolders, but it will not actually generate a stub class file. Does anyone know why the stub class file would not be getting generated? Is there a setting that someone may have changed that would cause this? I can't replicate this on any of our other ColdFusion boxes. I even tried to replicate it on a clean install of ColdFusion, but (as expected) - on a clean install, everything worked perfectly. Also, the only error we're getting from the box is the java.lang.ClassNotFoundException: ... , and again, the reason for this seems to be that the stub class isn't getting generated on the box (folders are being generated, class files aren't). As always, thanks in advance for your help. Keywords: java.lang.ClassNotFoundException, web service, ColdFusion not generating stubs, ColdFusion 8 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFDOCUMENT SRC= and Dynamic HTML
Brook, I don't think that DHTML will render correctly for cfdocument no matter what you do. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Brook Davies [mailto:cft...@logiforms.com] Sent: Thursday, August 13, 2009 7:32 PM To: cf-talk Subject: CFDOCUMENT SRC= and Dynamic HTML Is there any way to capture a rendered page that uses DHTML? I have a simple test case where I use some JS to do a document.write('test') to the page and then use CFDOCUMENT to grab the page via the src attribute. But none of the dynamic content is ever rendered. Has any one had any success with this? The only workaround I can think of, and its convoluted and I am not even sure it would work: 1. Create a Unique ID server side and write a database entry for the content to fetch 2. Call cfdocument or cfhttp to fetch the page, passing the uniqueID. 3. On the page, include an ajax call back to send back to the server the documents innerHTML (which should be the dynamic output) along with the uniqueID 4. The server (polls?) gets the new HTML from the database and uses it with CFDOCUMENT to create the page. This is a bit crazy right? There has got to be a better way. And oh yeah, The output is generated through a lot of JS, so I can't easily reproduce it on the server and avoid these steps. But, I wish there was some other way.. Brook ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cftable query
I suspect you won't get much help with this. I've never seen CFTABLE used to produce Excel content - although under the hood it produces HTML so I guess why not. Still, I think most of us (myself included) would suggest a different method with more control over formatting ... Like creating HTML Table with cfoutput (for the simple apporach) or usuing POI. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: vidya yegnaraman [mailto:viduka...@gmail.com] Sent: Wednesday, August 12, 2009 3:45 PM To: cf-talk Subject: cftable query Hi, I am a newbie to coldfusion. I have a code that has to write some data to an excel sheet. Below is the code snippet for it. CFHEADER NAME=Content-Disposition VALUE=attachment; FILENAME=test.xls CFCONTENT TYPE=application/msexcel cftable query = sql startRow = 1 colSpacing = 3 colheaders What happens is, when the excel opens up, data is printed from A34581 and not A1. Can any please help me with this as it is very urgent. Thanks much in advance karth ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cftable query
Cool...glad I could help. -Mark -Original Message- From: vidya yegnaraman [mailto:viduka...@gmail.com] Sent: Wednesday, August 12, 2009 4:45 PM To: cf-talk Subject: Re: cftable query Thanks Mark, I used html table and that worked I suspect you won't get much help with this. I've never seen CFTABLE used to produce Excel content - although under the hood it produces HTML so I guess why not. Still, I think most of us (myself included) would suggest a different method with more control over formatting ... Like creating HTML Table with cfoutput (for the simple apporach) or usuing POI. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com Hi, I am a newbie to coldfusion. I have a code that has to write some data to an excel sheet. Below is the code snippet for it. CFHEADER NAME=Content-Disposition VALUE=attachment; FILENAME=test.xls CFCONTENT TYPE=application/msexcel cftable query = sql startRow = 1 colSpacing = 3 colheaders What happens is, when the excel opens up, data is printed from A34581 and not A1. Can any please help me with this as it is very urgent. Thanks much in advance karth ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF and Java
Alan, Getting in on this late (sorry). This tag decoder allows you to do what - get at the dimensions of the stage in the swf file? Pretty cool. Does it allow for anything else? Like extracting the embedded assets etc? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: Friday, August 07, 2009 11:04 AM To: cf-talk Subject: Re: CF and Java Cool, thanks everyone. Just in case someone else has something, let me give a better example of what I'm talking about. I had a problem the other day where I had a client who has a website with years and years of assets stacking up on their server. They had hundreds of SWF files in one folder and a database table linking them to the respective advertisers. Unfortunately due to bad design by the original author, there were no dates associated with the files in the database (UUID PK). The one thing the client did know was that they only wanted to be using their newest size of 138h X 250w. So any files that were not that dimension could be filtered out. SO I needed a way to programatically determine their sizes. One quick google search turned up the perfect solution on Rupesh Kumar's blog, which is what started all of this for me. Now Rupesh is one of the engineers at Adobe, so he has all sorts of inside info, but how would any of us regular programmers know that this package existed decoder = createObject(java, macromedia.swf.TagDecoder).init(fis); // create TagDecoder And how many other amazing little tidbits like this are there still waiting to be found and put to use... Anyhow... Thats was my inspiration for wanting to troll through all the java packages CF has just laying around. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Excel File Parser for ColdFusion
Well here's one approach. Keep in mind that CF9 will have some good features for this sort of thing. http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] Sent: Friday, August 07, 2009 10:59 AM To: cf-talk Subject: Re: Excel File Parser for ColdFusion Hi Dan, Yes. Currently I am reading the uploaded CSV file with CFHTTP which returns the data in a query. Thanks, Donnie The end goal is to convert the file into a query-like struct that you can loop through taking action on the contents of each line? On Fri, Aug 7, 2009 at 10:41 AM, Donnie Carvajal donnie.carva...@transformyx.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Excel File Parser for ColdFusion
Dan, Yes I thought you had mentioned a CSV file. The same approach will work with excel - you would just need a different driver. Check out Ryan's post: http://www.stillnetstudios.com/garbled-truncated-reading-xls-files/ Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dan Baughman [mailto:dan.baugh...@gmail.com] Sent: Friday, August 07, 2009 11:22 AM To: cf-talk Subject: Re: Excel File Parser for ColdFusion It appears that approach wants to work with a CSV file, not an xls? On Fri, Aug 7, 2009 at 11:17 AM, Mark Kruger mkru...@cfwebtools.com wrote: Well here's one approach. Keep in mind that CF9 will have some good features for this sort of thing. http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] Sent: Friday, August 07, 2009 10:59 AM To: cf-talk Subject: Re: Excel File Parser for ColdFusion Hi Dan, Yes. Currently I am reading the uploaded CSV file with CFHTTP which returns the data in a query. Thanks, Donnie The end goal is to convert the file into a query-like struct that you can loop through taking action on the contents of each line? On Fri, Aug 7, 2009 at 10:41 AM, Donnie Carvajal donnie.carva...@transformyx.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Twitter down
H I just tried to tweet on one of my blog posts and noticed that twitter is down and I've heard facebook is having problems as well. In a completely unrelated story palid teenagers are emerging from basement hideaways and over-garage bedrooms by the thousands, blinking and squinting at the sun. Meanwhile the Jonas brothers are frantically brainstorming other ways to tell the world what they had for breakfast. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com http://www.cfwebtools.com/ www.coldfusionmuse.com http://www.coldfusionmuse.com/ http://www.necfug.com/ www.necfug.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325246 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Twitter down
Charlie, (lol) ... I didn't get it either but I didn't say anything because I didn't want to appear du... (doh!) ... Never mind. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Thursday, August 06, 2009 2:30 PM To: cf-talk Subject: Re: (ot) Twitter down I think the joke was Denial of Social Networking. They would've gotten it on cf-community (hint, hint) :) On Thu, Aug 6, 2009 at 12:27 PM, Nathan Strutz str...@gmail.com wrote: On Thu, Aug 6, 2009 at 11:58 AM, David McGuigan davidmcgui...@gmail.com wrote: I think you mean DOSN attack. If that's a joke, I don't get it. http://en.wikipedia.org/wiki/Denial-of-service_attack I've heard it also called DDOS, distributed denial of service, which is more in reference to what you're saying. A DOSN or DOSNet (Denial of Service Network) is the malware/software behind the attack, in reference to its network. You don't get a DOSN attack, you get a DDOS attack via a DOSNet or you get a DOS attack. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Thu, Aug 6, 2009 at 11:50 AM, Robert Harrison rob...@austin-williams.com wrote: It's a self-fulfilling problem. Spread enough news there's a DOS attack so everyone goes to check it out, and there is a DOS attack. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 4312 (20090806) __ The message was checked by ESET Smart Security. http://www.eset.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Could use some inputs
Don, You are giving us the wrong information here. What you should post is the code in question and a description of the former environment (cf8 + what? MSSQL?) and the new environment. -mark -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: Wednesday, August 05, 2009 8:22 AM To: cf-talk Subject: Could use some inputs Here's a situation I hope you could provide some thoughtful input. I've converted a cf8-based app into an open source one. Initially it seemed all's well but lately, right when I'm ready to deploy it (not to be hosted like many do), some core functionality like automatically data saving, normal data saving are no longer reliable, let me explain. I have a form for data entry with multiple fields. Function 1: auto save the data elements at an interval, thanks again Sam. This feature does not seem to be consistently reliably on the new platform but this function is less critical. Function 2: manually save the form, this one now is a MAJOR PROBLEM! the form data is saved/updated all right, BUT it deleted 2 or 3 most recent rows of the data table (all with data of required columns)! The query does not delete anything. Would other scripts delete them? No, here's why. Here's the basic structure of this table: id -- title -- content 27 -- 'agri' -- 'one phase of humanity' 28 -- 'indu' -- 'mass production' -- newest entry 29 -- 'new here' -- 'bla bla' -- where id is of identity (1,1) not null Upon clicking on save, rows of id(27 and 28) would be mysteriously gone. I've checked the table does not have any triggers whatsoever, and the machine is totally offline. On some other instances, the newest value and id would replace the second newest one, like upon SAVE, the above would read 27 -- 'agri' -- 'one phase of humanity' -- newest entry 28 -- 'new here' -- 'bla bla' Also, please note there's only ONE user. If it's coding problem, somewhere there's some code like DELETE from theTABLE where Len(title) 0 or something like that but there's absolutely not code across board like that, absolutely not. So, how did they disappear? FYI, I've also provided the open source company a copy of compiled code set (to them it's no different from source code) upon their request in hope of obtaining an flexible installer of their engine, which didn't happen. Also, I don't mind paying 400 or 500 bucks for service of making my app deployable but unlike the online web apps I don't need a full year service... but please do not read too much into this... I'm just laying out facts. Also, I've been using the app for over a year without any of the above mentioned problem. Now, it's extremely unlikely for cf coding issue regarding to this problem, so, who has the motivation and capability to cause this problem? I'm at wits end if any... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325212 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web service error
You need to set the access level for the function to remote if you wish to use it as a WS. cffunction name=echoString Access=remote -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: ch g [mailto:chr_...@yahoo.com] Sent: Wednesday, August 05, 2009 12:07 PM To: cf-talk Subject: Web service error Hi all, I am developing a simple web service, but i am getting an error like this Web service operation echoString with parameters {INPUT={hello}} cannot be found. Here is the published web service cfcomponent cffunction name=echoString returnType=string output=no cfargument name=input type=string cfreturn #arguments.input# /cffunction /cfcomponent And the test file is cfinvoke webservice =http://www.ecodes.biz/UserVerif.cfc?wsdl; method =echoString input = hello returnVariable=foo cfoutput#foo#/cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web service error
A quick test on my own server shows that your function works fine. cfset x = createobject(webservice,http://www.ecodes.biz/UserVerif.cfc?wsdl;).echoSt ring(hello World)/ cfoutput#x#/cfoutput I suspect you have compiled the WSDL and the stub is being cached. You need to refresh the cache... But as a quick fix just rename your file to UserVerify.cfc or something and try again :) -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: ch g [mailto:chr_...@yahoo.com] Sent: Wednesday, August 05, 2009 12:20 PM To: cf-talk Subject: Re: Web service error I included that also cffunction name=echoString returnType=string output=no access=remote cfargument name=input type=string required=yes cfreturn #arguments.input# /cffunction Still receving the same error message Web service operation echoString with parameters {input={hello}} cannot be found. Thank you. You need to set the access level for the function to remote if you wish to use it as a WS. cffunction name=echoString Access=remote -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com Hi all, I am developing a simple web service, but i am getting an error like this Web service operation echoString with parameters {INPUT={hello}} cannot be found. Here is the published web service cfcomponent cffunction name=echoString returnType=string output=no cfargument name=input type=string cfreturn #arguments.input# /cffunction /cfcomponent And the test file is cfinvoke webservice =http://www.ecodes.biz/UserVerif.cfc?wsdl; method =echoString input = hello returnVariable=foo cfoutput#foo#/cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JVM Memory Errors
You should probably post the contents of the JVM.config file. What has changed recently? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Wil Genovese [mailto:jugg...@visi.com] Sent: Friday, July 24, 2009 9:18 AM To: cf-talk Subject: Re: JVM Memory Errors I guess more information is needed. What OS, 32 or 64 bit? Which JVM version are you running? What are your other JVM config settings? Have you read any of the very helpful blog posts on tuning the JVM? http://www.trunkful.com/index.cfm/JVM-Tuning http://www.cfwhisperer.com/post.cfm/blog-posts-on-clustering-tuning-and-data base-design http://www.adobe.com/devnet/coldfusion/articles/coldfusion_performance.html Wil Genovese Sr. Web Application Developer On Thu, Jul 23, 2009 at 11:42 PM, Callum McLardy call...@tassweb.com.auwrote: and all had plenty of ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Long running ColdFusion process and JVM Garbage collection.
Just remember this should be done as a short term fix. If you are having GC problems it is best to sort them out so that Java is running smoothly without frequent stop-the-world' type pauses engendered by a full GC. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Randy cfedge [mailto:ra...@cfedge.com] Sent: Friday, July 24, 2009 10:36 AM To: cf-talk Subject: Re: Long running ColdFusion process and JVM Garbage collection. You can run Garbage Collection like this: cfset runtime = CreateObject(java, java.lang.Runtime).getRuntime() cfset runtime.gc() YMMV ~Brad Is there anyway to encourage a ColdFusion server to run garbage collection during a long running, memory intensive process? Does this run Garbage Collection for the whole coldfusion server? This doesn't sound like a good idea but I am going to ask, What would the ramifications be of putting that code in a scheduled task and running it every so often? I think I read before that too much garbage collection could slow things down. Randy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ecommerce emergency
You are definitley working with the wrong clients... And it sounds like you need to move as well :) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Thursday, July 23, 2009 8:30 AM To: cf-talk Subject: Re: ecommerce emergency I'll keep my eye out for it. Thanks. :) The client I'm doing this for is only willing to part with $450. That's total. For my setup time, configuration, etc. I'm not sure how it is around the country, but where I am (NW USA), it's dog eat dog with PHP developers who are charging $9/hr. for websites. I managed to convince the client that I'm able to code allot faster with ColdFusion and that PHP is open source, therefore not as secure (I used the Google 'PHPbb virus' response). So I have this guy set to dump his hosting prepaid for 2 years to get some hosting on hostingatoz (which I'm hesitant to do since they still have yet to fix my cffile issue) or pay for some cf hosting someplace else, but that's another issue. I am glad you guys could tell your clients You need this and this and this and you guys get it. Us contractors in this area tend to tell our clients this and they go, Well, I'll go with someone else then who does PHP and take my chances because I don't have the money. I'd enjoy getting a $400 product that I can customize for clients. But if I were to ask a client out here for that up front (instead of at the end), then I wouldn't have the client. It's tough enough to get the client to pay 50% down nowadays. BTW, if anyone DOES have a client they are too busy to handle who is willing to drop $400 at the start and needs an ecommerce solution, I'll be glad to take them off your hands. :) Thank you for the advice, but I still have to go with CFShopKart at the moment. On Thu, Jul 23, 2009 at 6:05 AM, Gerald Guidogerald.gu...@gmail.com wrote: Phillip, you might need to double check but last I looked cfshopkart it was storing credit card details in its database (an MS Access database). Last time I looked at it, a couple of weeks ago, it had queries that did not use use cfqueryparam. Double plus ungood. You can always use that tool (the name escapes me) to cfqueryparam-tize the queries. I have used it before and it worked well enough, It did not add the cfsqltype attribute. I had to do that by hand, but it did 90% of the grunt work. My advice, free and worth every penny, is to get something battle tested. I have 5-6 carts under my belt and they can be rather involved and hence there is a lot that can, and if that Murphy fellow has anything say about it, will go wrong. G! On Wed, Jul 22, 2009 at 10:53 PM, Kevan Stannard ke...@stannard.net.auwrote: Phillip, you might need to double check but last I looked cfshopkart it was storing credit card details in its database (an MS Access database). And if you're on shared hosting this this db is likely to be web accessible. If this is still the case then avoid this cart. Mike, cfshopkart was one of the authors first cf applications so is not a good example of a well designed or coded app. -- Gerald Guido http://www.myinternetisbroken.com http://www.cfsimple.org/ To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ecommerce emergency
Then I suppose you will just have to sit and wait for all those PHP developers to die off from starvation :) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Thursday, July 23, 2009 10:27 AM To: cf-talk Subject: Re: ecommerce emergency hehehe.. To move, I need money.. To make money, I need to move. :) On Thu, Jul 23, 2009 at 8:12 AM, Mark Krugermkru...@cfwebtools.com wrote: You are definitley working with the wrong clients... And it sounds like you need to move as well :) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Thursday, July 23, 2009 8:30 AM To: cf-talk Subject: Re: ecommerce emergency I'll keep my eye out for it. Thanks. :) The client I'm doing this for is only willing to part with $450. That's total. For my setup time, configuration, etc. I'm not sure how it is around the country, but where I am (NW USA), it's dog eat dog with PHP developers who are charging $9/hr. for websites. I managed to convince the client that I'm able to code allot faster with ColdFusion and that PHP is open source, therefore not as secure (I used the Google 'PHPbb virus' response). So I have this guy set to dump his hosting prepaid for 2 years to get some hosting on hostingatoz (which I'm hesitant to do since they still have yet to fix my cffile issue) or pay for some cf hosting someplace else, but that's another issue. I am glad you guys could tell your clients You need this and this and this and you guys get it. Us contractors in this area tend to tell our clients this and they go, Well, I'll go with someone else then who does PHP and take my chances because I don't have the money. I'd enjoy getting a $400 product that I can customize for clients. But if I were to ask a client out here for that up front (instead of at the end), then I wouldn't have the client. It's tough enough to get the client to pay 50% down nowadays. BTW, if anyone DOES have a client they are too busy to handle who is willing to drop $400 at the start and needs an ecommerce solution, I'll be glad to take them off your hands. :) Thank you for the advice, but I still have to go with CFShopKart at the moment. On Thu, Jul 23, 2009 at 6:05 AM, Gerald Guidogerald.gu...@gmail.com wrote: Phillip, you might need to double check but last I looked cfshopkart it was storing credit card details in its database (an MS Access database). Last time I looked at it, a couple of weeks ago, it had queries that did not use use cfqueryparam. Double plus ungood. You can always use that tool (the name escapes me) to cfqueryparam-tize the queries. I have used it before and it worked well enough, It did not add the cfsqltype attribute. I had to do that by hand, but it did 90% of the grunt work. My advice, free and worth every penny, is to get something battle tested. I have 5-6 carts under my belt and they can be rather involved and hence there is a lot that can, and if that Murphy fellow has anything say about it, will go wrong. G! On Wed, Jul 22, 2009 at 10:53 PM, Kevan Stannard ke...@stannard.net.auwrote: Phillip, you might need to double check but last I looked cfshopkart it was storing credit card details in its database (an MS Access database). And if you're on shared hosting this this db is likely to be web accessible. If this is still the case then avoid this cart. Mike, cfshopkart was one of the authors first cf applications so is not a good example of a well designed or coded app. -- Gerald Guido http://www.myinternetisbroken.com http://www.cfsimple.org/ To invent, you need a good imagination and a pile of junk. -- Thomas A. Edison ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Equity
Unless you have an absolutely compelling reason you should not do it. It is a two edge sword and it makes projects hard to walk away from as well. Only one group of folks have made money in a predictable way on the web - consultants (and porn vendors but I'll leave them out as a matter of principle). Everthing else is pretty much a lottery ticket :) Before you go and do this you need to take the time to discover - The financial situation of the company. - Who are the backers and what is their skill set. - Do they have a marketing plan or are they just hoping the web will catch fire and make them the next facebook. - Are they realistic? Most brick and mortar startups plan for 18 to 36 months to reach break even. Most Internet startups have moved toward the internet because it is the largest get-rich-quick culture dish in the world. It has a reputation for being a cheap way of starting a business (which is a terrible reason to choose it). Yet there are thousands of failures for every one success. Check out this post I wrote some months ago. I'm presenting an expanded version at the chamber of commerce here in Omaha in a couple of weeks. http://www.coldfusionmuse.com/index.cfm/2009/1/23/Great-Expectations-What-Ma kes-Money-on-the-WEb What most folks need is a reality check. Most startups are populated with folks who are all drinking the coolaid and without a naysayer in the bunch. Having said that I suppose no great ideas would never be birthed without the visionaries (and crackpots) who give it the old college try :) Anyway that's my 2 cents. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Tuesday, July 07, 2009 12:54 PM To: cf-talk Subject: Equity Just curious about what people think.. Would you ever work for equity in a company? Why or why not? What guidelines would you put in place if you were to? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Authorize.net down Anyone get through support yet?
Casey, I have a number of customers currently down due to this issue. I suspect support is flooded with calls. The main web site is not up either so my guess would be a major network issue. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Friday, July 03, 2009 9:10 AM To: cf-talk Subject: (ot) Authorize.net down Anyone get through support yet? I'm on hold 1 hour 5 minutes now. Anyone get though to their suppor about authorize.net being down? -- Casey ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cookie won't set
Brian, What version of CF? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Brian Bradley [mailto:bbrad...@plrb.org] Sent: Friday, June 19, 2009 11:33 AM To: cf-talk Subject: Re: Cookie won't set Tried putting setclientcookies=yes and loginStorage=cookie and that didn't work. Also changed the language of cfif loginQuery.Role NEQ to cfif loginQuery.Role is not None worked. Still won't set the cookie. Any other ideas? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: css and cfdocument...grrr
This is pretty old but it might be helpful. http://www.coldfusionmuse.com/index.cfm/2006/2/16/cfdocument.performance The main thing to realize is that converting HTML to PDF is really a trick - going from a fluid medium to a very staticky and specific medium. Unless your HTML is already pretty lean and minimal you may need a different layout wrapper. Also check to see if your CSS is even making it into cfdocument. Remember that if you use something like: link rel=stylesheet type=text/css href=/css/mystylesheet.css media=screen / In your cfdocument, CF has to retrieve that resource to include it into the doc. Under the hood it makes a cfhttp call right? The server has to resolve the domain into the proper IP etc. So a lot of things might have to go right for that to work. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, June 18, 2009 1:17 PM To: cf-talk Subject: css and cfdocument...grrr Ok, I know cfdocument is finicky about the html it tries to render into a pdf. I have a template I'm putting together and it validates xhtml transitional, it uses both @import and link to include the stylesheet (just in case), I use a standard Yahoo supplied reset css file and the resulting html renders identically in Firefox, IE 7 and Chrome. So, several things don't actually render correctly at all in the resulting pdf. Things like background colors bleeding over into other elements, background colors not showing up at all on a div whose only content are other divs, etc. Where are the best places to look for tips on making it behave? And are there good troubleshooting guides for things to pay attention to/avoid? I'm ok with a little black magic but this is getting irritating as there is no obvious place to correct these problems. Thanks, Judah ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server (RESOLVED)
Adria, I blogged this solution http://www.coldfusionmuse.com/index.cfm/2009/6/10/javax.imageio.jpg.crash.jv m -Mark -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Wednesday, June 10, 2009 3:21 AM To: cf-talk Subject: RE: Image killing server (RESOLVED) Dude and double dude! Excellent work :OD To stop the errors we started looking in files for certain strings to indicate the image would crap out CF. Will let you know how we get on when we upgrade. Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 22:49 To: cf-talk Subject: RE: Image killing server (RESOLVED) Adrian, I have an explanation and a resolution for you. The problem is a buffer overrun in the ICC parser (a bit of color correction meta data that ships with the image). To resolve it I upgraded my JVM from 1.6.0_04 to 1.6.0_14 ... But _05 or above would do the trick I think. I'll write a blog on it and give a more thorough explanation - but meanwhile, I found my best clues by looking not for ColdFusion related image issues, but javax.imagaio related image issues. I found this post: http://www.securiteam.com/securitynews/5SP0E1PNQA.htm Which lead me more closely examine the update (build) number of my JVM install. I hope this helps you! -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 10:49 AM To: cf-talk Subject: RE: Image killing server Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server
Adrian, What version, what build and what platform (Linux, windows, etc)? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server
Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server
Adrian, FYI: CF 9 and Ralio handle this file ok (according to my friend and colleague Ryan Stille). I don't know what to make of that embedded color profile information. I wouldn't worry about posting it - get it out in the open and let's deal with it :) -Mark -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 10:49 AM To: cf-talk Subject: RE: Image killing server Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323278 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Miles per gallon...
Hey, that sounds great How can we help :) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Andy Matthews [mailto:amatth...@dealerskins.com] Sent: Tuesday, June 09, 2009 11:44 AM To: cf-talk Subject: RE: Miles per gallon... After speaking with John Henderson and Josh Wolter, here's what we think might be the best approach. 1) We receive data for MPG from JATO and/or the dealerships. a) If the dealer sends us data we dump that into the mpg column. b) if they do not send us data, we use whatever JATO sends us 2) We add MPG as a selectable field for listings pages. The data would display on listings pages (sortable, and filterable), but there would be no fuel pump icon. 3) We add MPG as a selectable field for details pages. If enabled, we display the fuel pump icon along with the data. 4) In our disclaimers some of the things we need to address are: a) MPG differences based on different engine, transmission, or other options. b) do we allow dealers to display MPG for used cars, or do we just make sure our disclaimer covers when this car was manfactured, the MPG was...? 5) For JATO data, this is the format (on the listings pages) that we were thinking of using: city: 23 / hwy: 29 are there any objections to that? As an aside, I just spot-checked sites from dealer.com, clickmotive, and reyrey and none of them showed MPG on listings pages. Reyrey sites didn't even show MPG on the details page. andy -Original Message- From: Chris Redmond [mailto:credm...@dealerskins.com] Sent: Monday, June 08, 2009 4:56 PM To: 'Andy Matthews' Cc: 'Eric Brown' Subject: RE: Miles per gallon... 1) We receive MPG (split between city and state) from JATO. We also have the ability to receive MPG data directly from dealers. We need to decide which data takes precedence. Dealer should override but the jato info should be standard... 2) Displaying the fuel pump icon on the details page is relatively straightforward. There were rumors though that we also wanted to display the fuel pump icon at a smaller size on the listings page. If this is true, then that's going to be more difficult and time consuming. The fuel pump is kind of the standard... it draws attention to it. 3) We need a disclaimer added to the default copy regarding MPG display, I'd assume this would come from Anne. Just need to see if California has any weird rules... Chris R. Redmond Regional Sales Manager Cell: 704.307.0797 Fax: 704.973.0853 ch...@dealerskins.com www.dealerskins.com -Original Message- From: Andy Matthews [mailto:amatth...@dealerskins.com] Sent: Monday, June 08, 2009 5:47 PM To: 'Eric Brown' Cc: 'Chris Redmond'; Aaron West Subject: RE: Miles per gallon... Roger that. Chris/Eric...let me run a few things past you so that I know how to proceed. We have two main locations we want to display the MPG; listings pages, and details pages. The simplest way for us to get this into Autobahn would be to treat MPG as any other piece of inventory data. This would allow MPG to appear as a column in the listings page, it could be sorted, filtered, and would be easy to display. For the details page, we would prominently display the fuel pump icon, along with the data received. We have a few challenges though. 1) We receive MPG (split between city and state) from JATO. We also have the ability to receive MPG data directly from dealers. We need to decide which data takes precedence. 2) Displaying the fuel pump icon on the details page is relatively straightforward. There were rumors though that we also wanted to display the fuel pump icon at a smaller size on the listings page. If this is true, then that's going to be more difficult and time consuming. 3) We need a disclaimer added to the default copy regarding MPG display, I'd assume this would come from Anne. Andy Matthews Senior Web Developer www.dealerskins.com Total customer satisfaction is my number 1 priority! If you are not completely satisfied with the service I have provided, please let me know right away so I can correct the problem, or notify my manager Aaron West at aw...@dealerskins.com. -Original Message- From: Eric Brown [mailto:ebr...@dealerskins.com] Sent: Monday, June 08, 2009 4:15 PM To: Andy Matthews Cc: Chris Redmond Subject: Re: Miles per gallon... Actually Chris Redmond is best here...he has dealt with a number of dealers who have requested...but of course I'll be by to offer my two cents worth..eric On 6/8/09 4:03 PM, Andy Matthews amatth...@dealerskins.com wrote: Eric... Could I have a few minutes of your time to discuss MPG? I'm tasked with including it into Autobahn and I'd like to see if you have any specific input as to where (or how) it should appear. I'm planning on making it available for dealers to include in listings pages, and the details page. Andy
RE: Image killing server
Adrian, I'm working through this problem on another list and I'll try to keep you up to date. I found the following exception in the *-out.log along with a good deal more detail in an hs_err log. You might look for those - although I'm not sure they will tell you anything. -Mark # # An unexpected error has been detected by Java Runtime Environment: # # EXCEPTION_ACCESS_VIOLATION (0xc005) at pc=0x7c910f1e, pid=4948, tid=5340 # # Java VM: Java HotSpot(TM) Server VM (10.0-b19 mixed mode windows-x86) # Problematic frame: # C [ntdll.dll+0x10f1e] # # An error report file with more information is saved as: # C:\ColdFusion8\runtime\bin\hs_err_pid4948.log # # If you would like to submit a bug report, please visit: # http://java.sun.com/webapps/bugreport/crash.jsp # The crash happened outside the Java Virtual Machine in native code. # See problematic frame for where to report the bug. # Starting Macromedia JRun 4.0 (Build 108673), coldfusion server ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Image killing server (RESOLVED)
Adrian, I have an explanation and a resolution for you. The problem is a buffer overrun in the ICC parser (a bit of color correction meta data that ships with the image). To resolve it I upgraded my JVM from 1.6.0_04 to 1.6.0_14 ... But _05 or above would do the trick I think. I'll write a blog on it and give a more thorough explanation - but meanwhile, I found my best clues by looking not for ColdFusion related image issues, but javax.imagaio related image issues. I found this post: http://www.securiteam.com/securitynews/5SP0E1PNQA.htm Which lead me more closely examine the update (build) number of my JVM install. I hope this helps you! -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 10:49 AM To: cf-talk Subject: RE: Image killing server Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DSN-Less connections in CF8
Scott, Here's the approach we usually use (it works pretty well). http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, June 01, 2009 3:23 PM To: cf-talk Subject: DSN-Less connections in CF8 Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Dynamic robots.txt
Andy, You could use CF to handle the .txt extension and then write a dyanmic script that figures out what the output should look like - including absolute paths etc. A single robots.txt file could gin up various outputs based on data in a database or parsing through the CGI vars or whatever. The downside is that the CF engine is now going to take a look at all your txt files - so if your site serves a lot of static txt files it's additional overhead to the CF engine. But if you don't server more than the occasional txt file and/or The 404 idea is not going to work because a 404 is a status code error that is thrown (to the browser I think) - which is going to cause indexers to turn away assuming there is not robots file. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Andy Matthews [mailto:amatth...@dealerskins.com] Sent: Wednesday, May 27, 2009 8:41 AM To: cf-talk Subject: Dynamic robots.txt We have an application which delivers about 2000 websites. This is really nice for lots of things, but not so nice for items such as robots.txt where we might want unique values. Reviewing the spec for robots.txt it requires that sitemap references be absolute paths (while everything else can be root relative). As a hard coded file we obviously can't do this. A coworker had the idea to delete our robots.txt file and use our 404 handler to toss that request to ColdFusion, and write in the absolute path to our sitemap each time the file is requested. 1) Can this be done reliably? 2) Is anyone out there doing this already and could answer these questions? Andy Matthews Senior Web Developer www.dealerskins.com P Please consider the environment before printing this e-mail. Total customer satisfaction is my number 1 priority! If you are not completely satisfied with the service I have provided, please let me know right away so I can correct the problem, or notify my manager Aaron West at aw...@dealerskins.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parsing large CSVs and inserting in MSSQL
Jason, This is not what you want to hear but My advice would be don't use CF to do this. DTS (or SSIS) is quite capable of doing this in about 1/30 the time that CF is able to do this. One of our DTS packages consumes a file of over 300k rows in less than 15 seconds every few minutes. You can't get that with CF no matter how hard you try :) But if you insist on doing it with CF, don't use CFFILE. Instead read the lines in one at a time using a line reader technique - that will allow you to handle one line at a time instead of reding the entire file into memory. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jason Durham [mailto:jdur...@cti-stl.com] Sent: Tuesday, May 26, 2009 10:53 AM To: cf-talk Subject: Parsing large CSVs and inserting in MSSQL I have been tasked with providing a mechanism to upload/parse/perform a couple of checks/save CSV data. The current test file is 28,000 records (~16 columns). I expect this file to grow in size each month, to an indeterminate number (hundreds of thousands). It seems that I'll need to set a limit on the number of rows being processed at each time. The two obvious options (in my eyes)... #1 break the CSV up into several smaller CSV files and write them back to the file system before processing each individually (all checks performed in memory) #2 set a large timeout value and attempt to load all of the records from the CSV into a temp table, retrieving back smaller, more manageable record sets Currently, I'm doing #2 but not limiting the number of records (28,000). The data is getting into the temp table, being retrieved, but the final insert is causing ColdFusion to hang. The final insert consists of one cfquery with an internal loop over the temp table query object. The final insert is within a single transaction so I can rollback if it fails. This process will only take place on my development machine, connecting to the live database. 2.6 Core 2 Duo, 4GB, Vista 32 with a 100MB connection to production server running MS SQL 2005 Express. Perhaps I need to take a step back and consider alternatives. Btw, the checks I'm performing are simply that 2 of the columns do not contain a unique value (FKs). I'm currently doing this with QoQs but I could probably push this off with a fairly complicated query to MS SQL. What do the CF wizards suggest? TIA ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322780 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Parsing large CSVs and inserting in MSSQL
Yes... I was going to mention that but I didn't want to muddy the waters :) Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Tuesday, May 26, 2009 11:10 AM To: cf-talk Subject: Re: Parsing large CSVs and inserting in MSSQL Mark Kruger wrote: Jason, But if you insist on doing it with CF, don't use CFFILE. Instead read the lines in one at a time using a line reader technique - that will allow you to handle one line at a time instead of reding the entire file into memory. I also recommended pushing the heavy lifting into the database. But I did want to point out that in ColdFusion 8, you can now use the cfloop file= tag to get a CFML line reader, so one does not need to go to the Java for this anymore. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Parsing large CSVs and inserting in MSSQL
Jason, Here's a big uh oh for you If you are using MSSQL express you don't have the SSIS services that come with it. DTS may be possible through installing the active X controls on the same server - but you may be out of luck if you want to do SSIS. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jason Durham [mailto:jdur...@cti-stl.com] Sent: Tuesday, May 26, 2009 1:27 PM To: cf-talk Subject: RE: Parsing large CSVs and inserting in MSSQL Thanks to everybody who has replied. It appears I need to do some homework on MS SQL. :) -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, May 26, 2009 11:03 AM To: cf-talk Subject: RE: Parsing large CSVs and inserting in MSSQL Jason, This is not what you want to hear but My advice would be don't use CF to do this. DTS (or SSIS) is quite capable of doing this in about 1/30 the time that CF is able to do this. One of our DTS packages consumes a file of over 300k rows in less than 15 seconds every few minutes. You can't get that with CF no matter how hard you try :) But if you insist on doing it with CF, don't use CFFILE. Instead read the lines in one at a time using a line reader technique - that will allow you to handle one line at a time instead of reding the entire file into memory. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jason Durham [mailto:jdur...@cti-stl.com] Sent: Tuesday, May 26, 2009 10:53 AM To: cf-talk Subject: Parsing large CSVs and inserting in MSSQL I have been tasked with providing a mechanism to upload/parse/perform a couple of checks/save CSV data. The current test file is 28,000 records (~16 columns). I expect this file to grow in size each month, to an indeterminate number (hundreds of thousands). It seems that I'll need to set a limit on the number of rows being processed at each time. The two obvious options (in my eyes)... #1 break the CSV up into several smaller CSV files and write them back to the file system before processing each individually (all checks performed in memory) #2 set a large timeout value and attempt to load all of the records from the CSV into a temp table, retrieving back smaller, more manageable record sets Currently, I'm doing #2 but not limiting the number of records (28,000). The data is getting into the temp table, being retrieved, but the final insert is causing ColdFusion to hang. The final insert consists of one cfquery with an internal loop over the temp table query object. The final insert is within a single transaction so I can rollback if it fails. This process will only take place on my development machine, connecting to the live database. 2.6 Core 2 Duo, 4GB, Vista 32 with a 100MB connection to production server running MS SQL 2005 Express. Perhaps I need to take a step back and consider alternatives. Btw, the checks I'm performing are simply that 2 of the columns do not contain a unique value (FKs). I'm currently doing this with QoQs but I could probably push this off with a fairly complicated query to MS SQL. What do the CF wizards suggest? TIA ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Page Faults
Michael, Page faults occur when the memory manager is asked for a register that is not in PHYSICAL memory (meaning it has been swapped to the disk. The word fault was an unfortunate choice by some original assembly programmer because it makes folks think something is wrong when it may or may not be wrong. When a chunk of memory is called for the memory manage figures out if it exists physically (in RAM) or virtually (pretending it is in RAM but really swapped to the disk). If the memory chunk is actually on the disk, the memory manager says wait just a sec and then goes to the disk to retrieve the info into physical memory before sending it back to the calling process. This wait a sec operation is a page fault. On a very busy server the memory manager might also have to figure out how to swap something else to disk to make room for the memory required by the fault. In general very high page fault rates mean that a good deal of what the system needs is in the pagefile instead of in physical memory. Note, I said page fault rates. The actual number of page faults might be irrelevant, since a 1 time operation calling something from the pagefile can result in a very high number. What is more key is how often the number of page faults increments. If you see constant and steady activity it's possible you are swapping in and out in a steady stream and your disk is thrashing (leading to disk errors and things like corrupt master mdb files :) Typically if you see a high rate you need more memory or you need to fine tune the memory and processes that are running. In the case of JRUN and MSSQL on the same machine (not a great idea but common) - as well as SWOC (the sequelink access driver - you mentioned MS Access), you need to specify what amount of memory is going to jrun, what amount to mssql and then have a reserve for kernel, swoc, and other operations. So for example, on a 2 gig machine, you might set jrun to 756 megs heap (effectively about 900 megs) set mssql to run 512 megs and leave the rest for everything else. Of course, depending on the type of setup you would need to adjust those values - every system is different. Finally, if you run MSSQL on it's own box the best choice is usually to give it its head and let it tune it's own memory usage. But if you run it on a box with JRUN you need to specify a top limit - otherwise it will sometimes overrun the box. It's just a smarty pants and thinks it is always the most important software on the box (and really it should be - on it's own box). Hope this helps. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Michael Muller [mailto:ad...@montaguema.net] Sent: Wednesday, May 20, 2009 8:41 AM To: cf-talk Subject: (ot) Page Faults I'm dealing w/ a corrupt SQL Server master DB right now, so all my SQL Server sites are offline at the moment (ugh) -- but that's not why I'm here. While trying to figure out what in heck was going on on my server I looked at Task Manager processes and sorted by various columns until I saw the Page Faults column... jqs.exe was at 1.5 billion and jrun.exe was at 715 million. sqlservr.exe was at 218 million. So, after rebooting and restarting these processes (and getting all my smaller Access sites back up -- since CF was hung on all the SQL Server requests) they were all set back to 0, and then immediately started climbing back up. jqs.exe is already over 300,000 and jrun is at 150,000. So... wth? Is this a hardware issue? From Wiki Answers: In computer storage technology, a page is a fixed length block of memory that is used as a unit of transfer between physical memory and external storage like a disk, and a page fault is an interrupt (or exception) to the software raised by the hardware, when a program accesses a page that is mapped in address space, but not loaded in physical memory. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Page Faults
Michael, It's not strictly true that windows can't address more than 2gb. Windows cannot address more than 2gb of contiguous memory address space. That certainly affects the JVM to be sure because the JVM needs contiguous space to run. But you CAN make use of more than 2GB on a 32gb windows box. For example, you can put 32Gigs on it and run 24 instances of ColdFusion in multi-server mode - each with a contiguous block of memory (see what I mean). As for SQL server, windows and SQL work together hand in glove on memory and adding more will almost certainly help MSSQL. That may or may not solve your problem, but it's important to know in any case :) Finally, windows 64 bit has freed itself from the contiguous block shackle that has bound it lo these many years. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Michael Muller [mailto:ad...@montaguema.net] Sent: Wednesday, May 20, 2009 12:34 PM To: cf-talk Subject: Re: (ot) Page Faults BTW, I have 2gb on the machine already. Is it worth bumping up to 3 or 4? I know that at one point Windows couldn't address more than 2gb of ram, but I think that's no longer the case, though it is for CF (unless CF8 can now address more than 2gb?). Mik ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) Page Faults
Sorry... That should have read ...make use of 2GB on a 32bit windows box -Mark -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, May 20, 2009 12:49 PM To: cf-talk Subject: RE: (ot) Page Faults Michael, It's not strictly true that windows can't address more than 2gb. Windows cannot address more than 2gb of contiguous memory address space. That certainly affects the JVM to be sure because the JVM needs contiguous space to run. But you CAN make use of more than 2GB on a 32gb windows box. For example, you can put 32Gigs on it and run 24 instances of ColdFusion in multi-server mode - each with a contiguous block of memory (see what I mean). As for SQL server, windows and SQL work together hand in glove on memory and adding more will almost certainly help MSSQL. That may or may not solve your problem, but it's important to know in any case :) Finally, windows 64 bit has freed itself from the contiguous block shackle that has bound it lo these many years. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Michael Muller [mailto:ad...@montaguema.net] Sent: Wednesday, May 20, 2009 12:34 PM To: cf-talk Subject: Re: (ot) Page Faults BTW, I have 2gb on the machine already. Is it worth bumping up to 3 or 4? I know that at one point Windows couldn't address more than 2gb of ram, but I think that's no longer the case, though it is for CF (unless CF8 can now address more than 2gb?). Mik ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Page Faults
True... That is worth mentioning. But... The web edition will not run MSSQL - so I don't think that is the edition he is using. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jochem van Dieten [mailto:joch...@gmail.com] Sent: Wednesday, May 20, 2009 1:59 PM To: cf-talk Subject: Re: (ot) Page Faults On Wed, May 20, 2009 at 7:33 PM, Michael Muller wrote: BTW, I have 2gb on the machine already. Is it worth bumping up to 3 or 4? Not if it is Windows Webserver Edition, which is limited at 2 GB. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: billing
Chad, Speaking from fairly vast experience I would say the following: 1) Agree in advance on the rate. 2) Find a way to communicate these hours are racking up as it happens. The worst thing is to surprise them. You really want to work hard to communicate as the hours are worked so they have all the bad news up front. 3) If you break the rate down based on size or scope then make it based on advanced payment or immediate payment. We offer a reduced rate to customers who buy hours in advance and that has helped both our cash flow and our negotiating position tremendously. Sometimes we also offer a discount to paygo customers for immediate payment. The discount works out to a bit of a break off of our highest rate, but still less of a break than our block hours customers. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Monday, May 04, 2009 12:54 PM To: cf-talk Subject: billing Does anyone give price breaks for quantity of hours in a project? Usually I quote jobs, but this latest one they just said go do it and we have racked up 400+ hours and I think they are going to freak out when they see the bill. We have worked with the company many times in the past so I feel I have to keep my pricing similar to what we have billed before. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322149 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Question about hack
Nate, Thanks for the post follow up. Very helpful. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: ALL [mailto:thegreat...@gmail.com] Sent: Thursday, April 30, 2009 10:25 AM To: cf-talk Subject: Re: Question about hack We finally fixed our issue. After a long crackdown on security on our server, one of our sites (the one that was causing all the fuss) gave me it's name and after about 2 mins it was quite clear what was causing it. mw.asp - (contents can be found here: http://pastebin.com/f5d798bd1 ) and we already moved the sites that had important info to another *secure* server, so until we get the dns info to all the sites so we can migrate them over to another server, we are going to have to stick with this one for a few weeks. Just figured i'd share the final cause of the problem. -Nathan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some WSDL Help
Give me the details and if I can help I will do so. If it turns out to be something that is time consuming we can talk about a maintenance contract. 1) What are the 2 end points (.NET and CF or CF and PHP etc...) 2) What is the object you are passing - an array, structure etc. Is the WSD and documentation publically available? -Mark P.S. I post on this sort of thing pretty often. I just did a post on 'passing an array to .net from Coldfusion' at my blog. Here is the link: http://www.coldfusionmuse.com/index.cfm/2009/4/27/array.CF.to.NET Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Rick Shapley [mailto:rs...@cade1.com] Sent: Tuesday, April 28, 2009 12:03 PM To: cf-talk Subject: Need some WSDL Help We are trying to connect some Cold Fusion Generated Data to a WSDL file. Can anyone help? Please e-mail me at rs...@cade1.com Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Injection
Start here http://www.coldfusionmuse.com/index.cfm/2008/7/18/Injection-Using-CAST-And-A SCII -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Chad McCue [mailto:c...@advmediaproductions.com] Sent: Friday, April 24, 2009 11:27 AM To: cf-talk Subject: SQL Injection We have one site on our server that was built about 10 years ago. Today some bot is hitting the site and appending their content to the content already in the system. I can't figure out how or where they are getting in. Anyone have any ideas how I can stop this. They are only putting in content and no script tags. I do have the Enable Global Script Protection enabled in the cf admin. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF PDF output
Brent, Remember that paths are important in cfdocument - it works a lot like cfhttp. See this post. http://www.coldfusionmuse.com/index.cfm/2006/2/16/cfdocument.performance It's likely that your CSS isn't being correctly consumed by cfdocument. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Brent Nicholas [mailto:brentnicho...@hotmail.com] Sent: Friday, April 24, 2009 12:28 PM To: cf-talk Subject: CF PDF output Anyone else had experience with the CF PDF creation totally botching the CSS page layout? I've got a really nice html page created by CF. Looks very nice as a web page, when you send it through the CF PDF creator it looks horrible!! The tables end up with really wide spacing and padding you can't adjust. I've done everything from external css, to css at the top of the page, to css in the tags (yuch!!). I even gave it the middle finger, alas... nothing worked. Thoughts? Thanks, BN ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL Injection
Didn't Homer Simpson say rinse and repeat Always repeat :) -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Friday, April 24, 2009 12:59 PM To: cf-talk Subject: RE: SQL Injection We have one site on our server that was built about 10 years ago. Today some bot is hitting the site and appending their content to the content already in the system. I can't figure out how or where they are getting in. Anyone have any ideas how I can stop this. If you're sure it's SQL injection, start by implementing my basic protector available at: http://www.gravityfree.com/_SQLPrev.cfm.txt Next, run this against your files to find queries where CFQUERYPARAM isn't being used: http://qpscanner.riaforge.org/ Finally, implement CFQUERYPARAM on your queries to protect them against these attacks. Rinse and repeat as necessary. -Justin ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Question about hack
Nate, Excellent ...thanks for this. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: ALL [mailto:thegreat...@gmail.com] Sent: Thursday, April 23, 2009 3:34 AM To: cf-talk Subject: Re: Question about hack Not sure if any more info on this subject has came up, but here is the contents of the file gm.vbs that was doing all the dirty work: http://paste-it.net/public/v22f672/ I have also noticed a new file named: 1.exe in the c:\ root directory. It has an icon of BMW (the car company), not sure if that has something to do with it either. -Nathan On Thu, Apr 16, 2009 at 7:56 PM, Al Musella, DPM muse...@virtualtrials.comwrote: A few ideas: 1. Set the ftp security to only allow connections from specific IP addresses. If the user has a dynamic ip, then use his entire range.. better than letting the entire world in 2. Your blog shows why I said to Michael to reformat the drive and reinstall everything when he was attacked. Once you let someone else get access to your server, there is no way you can ever trust it again. It has to be reformatted. 3. I know it isn't the right way to fight an attack, but for this specific attack, just put your index.cfm file into a different file, then have your index.cfm file just do a cflocation to that page. If the hack adds stuff to the index.cfm page, nothing will happen to the users. At 03:31 PM 4/16/2009, you wrote: For those interested I have compiled all I know about this attack into a blog post: http://www.coldfusionmuse.com/index.cfm/2009/4/16/iframe.insertion.ha ck Again, we have not specifically identified the attack but we have lots of information and a stop gap measure :) -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, April 14, 2009 5:37 PM To: cf-talk Subject: RE: Question about hack Thanks... I'll add that to my list. I have a pretty hefty blog post coming out on this tomorrow (or hopefully tomorrow :). -mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321873 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: BOLT!
We have one copy running in house... Can't say more or I'd have to do something terrible to you with Jell-O and a duck suite. (I didn't want to be clichéd :) -Mk -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: Friday, April 17, 2009 10:28 AM To: cf-talk Subject: Re: BOLT! I'm probably going to get in trouble for this.. but I can tell you with absolute certainty, the public beta has not been released yet. Very few people outside of Adobe have gotten their hands on Bolt yet. Be patient, when it's ready they'll open it up to the public beta. The only reason I'm saying this is I know your pain... Waiting for something super cool like this is a killer.. especially when you don't hear anything one way or the other... =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
FW: BOLT!
Shouldn't that be suit ... What's a duck suite anyway? Some kind of wetland litigation no doubt. -mk -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Friday, April 17, 2009 10:34 AM To: 'cf-talk@houseoffusion.com' Subject: RE: BOLT! We have one copy running in house... Can't say more or I'd have to do something terrible to you with Jell-O and a duck suite. (I didn't want to be clichéd :) -Mk -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: Friday, April 17, 2009 10:28 AM To: cf-talk Subject: Re: BOLT! I'm probably going to get in trouble for this.. but I can tell you with absolute certainty, the public beta has not been released yet. Very few people outside of Adobe have gotten their hands on Bolt yet. Be patient, when it's ready they'll open it up to the public beta. The only reason I'm saying this is I know your pain... Waiting for something super cool like this is a killer.. especially when you don't hear anything one way or the other... =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: multiple cfapplications
Check out this post. http://www.coldfusionmuse.com/index.cfm/2005/8/19/application.variables It outlines some of the fundamentals and pitfalls. If you want to use a 'base' + extended application model, the application.cfc makes it make sense a little more. You can create your base somewhere and then extend it wherever you need it - overwriting the functions/variables that are needed for the application you are using. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, April 17, 2009 10:57 AM To: cf-talk Subject: multiple cfapplications If I have many cfapplication.cfm files on a web site in different folders how do they work together? Say I have application.cfm on the root of the web site with an application name foo. Then in a user folder I have an application.cfm page and it's application name is also foo. How do they interact? Do they inherent each other's settings? What if I have a application.cfm page in a login folder and it's application name is goo. Does it overwrite the root application.cfm??? Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4