Re: anyway to initialize ORM AFTER onApplicationStart()?
On Thu, Mar 19, 2015 at 12:22 AM, Yuliang Ruan wrote: current app sets the datasource in onApplicationStart(). i can't have ormEnabled=true unless there's a datasource.and it doesn't look like i can intialize orm at the end of onApplicationStart() by doing a this.ormEnabled=true what are the alternatives? When we ran into this we moved datasource initialization from onApplicationStart() to onServerStart(). Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) JavaScript detecting foreign scripts
On Mon, Mar 2, 2015 at 8:52 PM, UXB Internet denn...@uxbinternet.com wrote: I apologize for this off topic post. A while back someone posted a thread where they were working on a script that would enumerate the DOM and detect foreign JS scripts running or loaded. I am looking to consult with that person off-list because I have a case where I need to do the same. Nowadays most browsers support having a Content Security Policy which IMHO offers a much better mechanism to do so in its reporting functionality: http://www.w3.org/TR/CSP/ Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360184 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Remove Jrun Server Instance
On Fri, Feb 27, 2015 at 7:39 PM, Donnie Carvajal wrote: I've removed a Jrun Server Instance by clicking on the Delete Icon in the Available Servers list under CF Admin-Enterprise Manager-Instance Manager for CF 9, but the c:\Jrun4\Servers\[instancename] folder is still on the C drive. Can I remove this folder? Also, are there any other manual steps that you would suggest when deleting a Jrun Server instance? You can remove it. There may also be logfiles in c:\jrun4\logs and under c:\jrun4\runtime and there may be a Windows service you have to remove manually Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cf11 and Tomcat Datasources
On Wed, Jan 28, 2015 at 1:27 AM, Alex DeMarco wrote: Is possible to configure a data-source in Tomcat and have it visible to the CF11 instance? Configure a JDBC datasource in Tomcat: http://tomcat.apache.org/tomcat-7.0-doc/jndi-resources-howto.html#JDBC_Data_Sources Then use it as a JEE datasource in CF. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360029 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving to Railo
On Tue, Dec 23, 2014 at 9:49 PM, Mik Muller wrote: Anyone here using Railo and have recommendations in terms of installation and configuration? I've been to GetRailo.org and com and find the documentation to be a little paltry, especially regarding the installation and the best configuration for various situations. I guess that is somewhat caused by Railo being more community driven and less corporate. In a community what is 'best' requires broad consensus before it is codified and 'carried' by the community members, and that broad consensus simply isn't there in the Railo community. Some of the more vocal members couldn't care less whether it works on Windows at all, some prefer the installer from Railo because it is just one click, some want to run on specific Linux flavours, some have their own idea on managing configurations etc. I will be hosting only my own websites, about 210 so far, broken down into four CF applications, ie; there are 185 sites running one application; 10 running another, etc. I also have about a dozen static HTML sites, so I'll need IIS on the box. It is a long time ago I worked with IIS and if you are already set on that I have no advice for you, but why so many sites? Why not attach 185 HTTP hostnames to one site? I've written a manager app for two of the applications to create the IIS instance, the folders, the database, the DSN, and the DNS. My guess is I'll have to add some code to support the Railo architecture... or maybe not. In either case, most new websites, and soon all of them, will be created on my server by one of these manager apps. You'll need to rewrite the Railo part of that. Check the documentation for the cfadmin tag. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OT, but stil.
On Sep 4, 2014 5:04 PM, Dave Watts wrote: This is exactly how user scripts work. They are installed by the user in some fashion, and can control browser functionality. This is how online password managers work, how Greasemonkey works, etc, etc, etc. If a user installs malware, of course that malware can do this sort of thing. There's nothing magically sacrosanct in HTTP or HTML to prevent this sort of thing. A Content Security Policy that blocks inline scripts will block some local malware too. It may for instance block bookmarklets, but not Greasemonkey. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Opening Local Files
On Aug 25, 2014 3:40 PM, Richard White wrote: We have created an online database program. I have a requirement for a user to store links to files contained on their local machines, then at the click of a button it will open the file. Open the file how? With the default application installed on their local machine? In that case just linking to the file should work once the user has configured the application and permissions. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359193 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: EMail Injection Attack
On Mon, Aug 18, 2014 at 9:56 PM, Garry Tran wrote: My first question is - is there a way to trace back to which page cfmail is being called from? Are there any logs that I can view that would allow us to track down what pages are being hijacked? If I write code where a cfmail tag is called straight from the website (as opposed to a scheduled process or something internal), I consider it a best practice to add the following two lines of code: cfmailparam name=X-Original-IP value=#cgi.remote_addr# / cfmailparam name=X-Original-URL value=#cgi.host_name#/#cgi.script_name#/#cgi.path_info#?#cgi.query_string# / Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Emails MIA
On Aug 5, 2014 3:35 PM, Byron Mann wrote: Use a failto in cfmail as it may provide you some detail. If the mail isn't making it off the server, it should bounce to the failto. Multi-recipient email will not generate a bounce or undeliverable message in CF if the CF spooler can deliver to at least one recipient. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving part of my hosting business - thoughts about my plan please ...
On Tue, Jun 3, 2014 at 4:26 PM, Pete Freitag wrote: On Fri, Mar 28, 2014 at 5:21 AM, Mike K wrote: Is there any benefit of one flavour of Linux over another? Yes, if you pick an obscure distribution intended for hardcore linux users (for example Gentoo linux) you will have a hard time as a newbie. Pick one that is commonly used such as Redhat Enterprise Linux / CentOS or Ubuntu. I think the most important consideration for a new user is whether the software you want to install is available as a package or needs to be installed from source. If everything you want is a package, you can expect the different applications to integrate together quite easily and you can expect security updates to become available automatically. For us that typically means we install Apache, Tomcat7 and PostgreSQL from packages. This automatically installs dependencies such as Java and the modules to connect Apache to Tomcat. Then we add a configuration to forward requests for .cfm files from Apache to Tomcat and deploy a Railo WAR on Tomcat. From then on, the platform is easily updated from the package manager. We never use the official Railo installer: it may be easier for the initial installation, but being able to install security updates for all installed application with just one command is more important in the long run. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam to varchar raw problem
On Tue, May 20, 2014 at 9:01 PM, daniel kessler wrote: I am adding CFQueryparams to an INSERT. The item that I am sending over to the oracle 11g db is empty text. The CFQueryParam is varchar because I am sending it over as text. From there, it is encrypted and a Cast_to_RAW is done on it to be put in a RAW field. This is failing with an invalid hex number error. I suspect you have a charset mismatch. What is the DB charset, CF charset and what is the setting for sending cfqueryparams as Unicode? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Honest question about cfform
On Mar 4, 2014 5:40 AM, Gerald Guido wrote: Why are people so vehemently opposed so to CFForm? Because it will only get you so far. And once you want to go further, you'll find that you can't. So then you have to go back, rip out cfform and replace it with something else. At which point you will discover that whatever skills you learned using cfform are useless because they don't transfer to other form frameworks. All of this is just fine if you know it beforehand and plan for it. But at the same time you are developing your cfform project, the rest of the world is moving forward. And I am guessing too many of us got burned when a project initially was fine with cfform, but then the requirements changed and it wasn't anymore Additionally I suspect plain old snobbery: it is not a technologically good solution, therefore it can never be a good solution from an ROI perspective. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357844 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFDOCUMENT Output without Page Break
On Tue, Feb 25, 2014 at 5:10 PM, Richard Colman wrote: I am trying to output a PDF through the cfdocument tag, without any any page breaks. I would like to get one long document, with pagination. Does anyone know of a way to do this? Specify a sufficiently long pageHeight? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Versions of Apache Supported on CF10 Linux?
On Tue, Feb 25, 2014 at 12:37 AM, Dan LeGate wrote: We are on 64-bit Redhat, which has Apache 2.2.3, which I've read doesn't support the ap_get_server_description What do you all recommend? Run the standard Tomcat and standard AJP connector with a ColdFusion WAR deployed on them. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 8 Manually Upgrade Flash
On Wed, Feb 12, 2014 at 5:49 PM, Dave Watts wrote: You should be able to disable the embedded Flash Media Server functionality if you're not using it. I'm not sure how to do this offhand, and I don't have a copy of CF handy. I believe it is just a matter of removing the servlet mappings in web.xml. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357664 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hash SHA-512 equivalent in JS
On Fri, Feb 7, 2014 at 2:37 PM, Richard White wrote: 1) is this best practise as if the salt phrase is contained within Javascript it will be easy for anyone to see what it is Why would it be a problem if somebody saw it? It still increases the complexity for a would-be attacker. Just make sure you hash again with a secret salt on the server. Even if the public salt was fully available in a rainbow table somewhere, you still haven't lost any security. And to increase the cost of generating rainbow tables against your salt make sure you use a salt that is the combination of something long and something unique, such as the username. (Just make sure you lowercase and trim the username before using it in the salt.) 2) if this is best practise then how can i obfuscate the salt phrase and also is there a JS equivalent to coldfusions SHA-512 hash function? There are several Javascript crypto libraries available with SHA-512 implementations, which you can find through a search engine. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Viviotech?
On Wed, Jan 29, 2014 at 2:28 AM, Russ Michaels wrote: perhaps this will help. http://www.watchguard.com/infocenter/editorial/135324.asp That is the traditional ARP attack in which the request is broadcasted and the reply has the IP address. That has the consequence of redirecting normal, local traffic to the spoofed address. That does nothing to explain how you flood ARP requests to an IP address. ARP runs on ethernet, not on IP, so it can not have an IP address as a destination, only an ethernet address. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Secure application code from host
On Tue, Jan 28, 2014 at 2:35 PM, Byron Mann wrote: While I've never had occasion to package a CF app as a WAR, I doubt it obfuscates the classes. So it too would be easily decompiled. But it would be decompiled to Java,. And that Java bears absolutely zero resemblance to the original CFML. I searched around and this seems to be a somewhat popular java obfuscator. http://proguard.sourceforge.net/ Whether things will still work with CF, I could not say, but might be worth a go. When we have mixed Java/CFML projects we use ProGuard to obfuscate the Java code. But the CFML we just compile. If you have ever looked at some decompiled CFML you will realize that it is much better protected than obfuscated Java code. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Viviotech?
On Tue, Jan 28, 2014 at 11:53 PM, Jordan Michaels wrote: A 0-day (previously unknown) exploit was used against the Kloxo control panel to upload malicious php files to the kloxo default site. Those files were then hit remotely and caused the exploited servers to send massive amounts of ARP requests off to an IP belonging to Chase bank. Since when do ARP requests have a destination IP? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Forms going into Barracuda
On Mon, Jan 13, 2014 at 4:05 PM, Steve LaBadie wrote: I am being asked to insert some type of header record to indicate the message is coming from a local form that guarantees a person completed the fields. cfmailparam is your friend: https://learn.adobe.com/wiki/display/coldfusionen/cfmailparam Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMAIL - SASL
On Fri, Nov 8, 2013 at 3:35 PM, Robert Harrison wrote: I'm trying to set up CFMAIL to use a relay server for one of my clients. The relay service says: Make sure that SMTP authentication (SASL) is turned ON I don't see any such setting in CFMAIL. Anyone know what this means SASL is an authentication protocol. Your best bet is to make sure you use both TLS and a username and password. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Application.cfm/c
On Wed, Sep 25, 2013 at 5:39 AM, Byron Mann wrote: Our admins are telling me that we run into issues with customers on our shared platform not having one. (they didn't specify the issues in the email). It has been a while since I last set up a server for shared hosting, but I used to put an Application.cfc in a parent folder which would display a short message that an Application.cfc/m was required and then cfabort it. It used to be just for logging (some logfiles will have the application name with each logline), but with application specific settings available you want people to make sure they have one so they can deal with their own mappings. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Resources for setting up ColdFusion in a shared environment?
On Tue, Jul 23, 2013 at 6:49 PM, Plunkett, Matthew wrote: We are looking at deploying ColdFusion in a load balanced configuration initially with two servers. We have a hardware load balancer and are running Windows Server 2012 for the web servers. We have figured out how to have the two servers share an applicationhost.config and run the websites out of a DFS share, but aren't sure how to share ColdFusion's configuration between the two servers. We want it to be that if a change is made to ColdFusion on one of the servers, it happens to both. Does anyone know where I could start looking at this problem? There is a setting in the CF administrator to reload the configuration every X seconds. It is intended for Websphere clusters where changes to configuration files are propagated to other nodes, but it might work for DFS as well. We are also interested in methods to rapidly deploy ColdFusion using an answer file or similar tech. Installing CF using an answer file is fully supported, search the installation documentation for a silent install. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356297 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: What would you call high traffic for CF8 standard?
On Thu, Jun 13, 2013 at 7:49 PM, Paul Vernon wrote: The sites already make extensive use of NOLOCK hints especially around the job search functions. If you have control over the database server the easiest way to solve most database locking issues when your usage pattern is read-mostly is to switch to snapshot isolation as the default isolation level: http://msdn.microsoft.com/en-us/library/tcbchxcb%28v=vs.80%29.aspx Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Optimising SQL Statement
On Fri, Apr 26, 2013 at 12:56 PM, Richard White wrote: I am sure there must be a way to restructure this query to bring the time down I am afraid we can't really help because most of the information we need for that is missing. Schema, cardinalities etc. SELECT * FROM ( SELECT primarys.primaryid , q_1 AS `subjectID` , q_2 AS `studyNumbers` FROM primarys LEFT OUTER JOIN questions_1_100 ON primarys.primaryid = questions_1_100.primaryid WHERE 0 = 0 AND q_1 IS NOT NULL GROUP BY primaryid) AS maintable_1 GROUP BY `subjectID` In addition there is a serious issue with this part of the query: it is not deterministic. You are selecting the columns primaryid, subjectID and studyNumbers from the inner select and then grouping by subjectID, without telling the DB what to do for the other columns. So if your inner query produces: 1, 2, 3 3, 2, 1 The result could be either of: 1,2,3 3,2,1 I am presuming this query produces the results you are expecting, but that is either an accident (and as soon as an optimisation changes the execution plan you get different results), or because there is a lot of correlation between the columns of your tables, of which you haven't told us anything. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355619 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: how risky is allowing java.security.AllPermission ?
On Thu, Sep 20, 2012 at 12:52 AM, Chris wrote: So ... a client wants to know just how risky it is to temporarily allow java.security.AllPermission ? I presume this is a followup to your Weblogic / RMI problem? It's clear it's not good, but how bad is it? What exactly could someone do to a server that's behind firewalls and load balancers? Probably it is inconsequential in the big picture. As always there is a layered security model. The access of the server running CF to other systems is limited by firewalls. The access of the JVM instance to the server is limited by the Windows account. The access of CF to the JVM instance is limited by the java.security.* security permissions. What I presume is happening is that by default CF runs with java.security.AllPermission already. (Have a look at the security policy in /WEB-INF/cfusion/lib/coldfusion.policy and /WEB-INF/cfusion/lib/neo_jaas.policy to see what CF ships with.) Then when some Weblogic RMI call is ran, some other security policy that is much more restricted is loaded, causing CF to fail. The new configuration would overrule that security policy and restore the original security from CF. If this presumption is right, you can tel them that from a CF perspective you are just restoring the original configuration. The only additional risk is not CF, but the Weblogic RMI running with additional proivileges. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternative to CFOBJECT
On Thu, Aug 30, 2012 at 10:17 PM, Russ Michaels wrote: well the only reason they could have all those tags disabled is because they do not use security sandboxes, which would imply they are hosting with the standard edition of ColdFusion, and tus have to disable any tag which allows files to be read/written from the server. If that were the case they would disable tags like cffile and cfdirectory. Instead, what they have disabled are those tags that allows you to instantiate arbitrary Java/COM/.NET classes and run executables. (Plus cfdump which uses cfobject internally so would be broken if enabled.) Those are the tags that allow you to bypass even a properly configured security sandbox. Unfortunately sandboxes are imperfect and this is the price you pay if you have to share an instance with somebody else. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352387 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: In CF 10, how to force session to end when browser is closed
On Thu, Jul 5, 2012 at 2:26 PM, Byte Me wrote: Anyone know how to force the session to end when the browser is closed when using CF 10? Strictly speaking that is impossible. The session will end a time X after the last request. What you can do is make sure the browser discards the cookie that is used to associate requests to the session. The session on the server does not disappear, the browser is just no longer associated with it. The session will only disappear after the session timeout. To do so, the easiest way is to enable J2EE session variables in your Administrator. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351834 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Wait for File to Get Written
On Wed, May 30, 2012 at 1:03 AM, Mary Jo Sminkey wrote: Basically I have situations where I need to wait for ColdFusion to finish creating a file before displaying it. The legacy code I'm working with using a cfexecute to run an executable file, and it uses this code snippet: cfloop condition=NOT FileExists(theFileName)/cfloop cfinclude template=viewFile.cfm If you just add a timeout to your cfexecute, CF will wait and continue when the legacy program is ready. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Question for UK List Members
On Wed, May 23, 2012 at 10:31 AM, Edward Chanter wrote: 2. Do people have any experiences with running CF hosting on a VM solution, how does it compare to a standalone server? In most configurations disk I/O is a bit more unpredictable. For the rest it is the same. 3. I tried to convince my boss that cloud is just another of those meaningless marketing buzz-words The cloud is a buzzword. However, hidden behind more buzzwords (at least in the case of AWS) as design to fail, autoscale and RDS are some sound technological concepts and offerings that make the cloud more than just a big VM environment. If you have no need for them and your application can't use them, the cloud is just a big VM environment. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Holy sweet mother of Jeremy Allaire...
On Wed, May 16, 2012 at 8:38 PM, Wil Genovese wrote: But this release of CF10 just two days before CF.Objective() and not AT Cf.Objective() reminded me of the past pettiness. The opening keynote is on Thursday at 14:00 UTC. That is not just past the deadline for the Friday news in a big part of the world, but is Ascention Thursday. About the only day worse for announcements is Christmas. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351224 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9/OpenOffice for Word to PDF
On Fri, May 4, 2012 at 4:19 PM, Justin Hansen wrote: Is anyone using the CF9/OpenOffice to convert Word/Excel documents to PDF? How well is it working? What sort of issues did you run into? How did you get around them? If you have a history / archive of documents that have not been created with PDF conversion in mind any conversion project is going to be painful. That is not because of either OpenOffice or ColdFusion, but because Office type of documents tend to be of very poor quality. I have done one project in particular for one of the Big Four where we basically pointed LiveCycle PDF Generator + MS Office + OpenOffice at a network drive with 12 years of documents to convert \and the things we ran into were: - password protection; - missing fonts; - no print permissions; - incorrect print ranges; - wrong paper format; - missing linked documents; - Office apps hanging on various dialogues (updates, missing references files, macros etc.). I believe the project ended up sending a significant part to India for manual conversion. But if you are dealing with current documents it is a whole different ballgame. Take a CMS like Razuna or Alfresco and configure / program it to run an automated PDF conversion for every document that is being saved. All errors get returned to the person who uploaded the document and people will learn fast. Fix the permissions so that only the owner can download the source format and the rest has to use the PDF file and you have turned the rest of the users into a large QA group. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351007 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFINVOKE - Component Location
On Thu, May 3, 2012 at 7:38 PM, Rick Faircloth wrote: Why would CF begin to use dot notation for cfc's instead of sticking with the familiar ../, etc, syntax? Because it represents the package and the component instead of the directory and the file, i.e. it represents a logical hierarchy instead of a physical one. One might even say that you are not supposed to know something as mundane as a filesystem location (an implementation, let CF figure out where it is), and should just work with the exposed functionality (the interface). Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350988 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How big is your CF JVM?
On Tue, May 1, 2012 at 4:10 PM, Justin Hansen wrote: Quick poll... How much memory have you allocated to CF on your production servers? That ranges from 384 tot 3072 MB depending on the app. and workload. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Odd ACF 8 v 9 issue
On Mon, Apr 16, 2012 at 9:49 PM, John M Bliss wrote: In ACF 9, I had: xmlparse(cfhttp.filecontent)['top-level-node'] ...and it worked fine but ACF 8 threw a syntax error Support for square braces directly after parenthesis was one of the syntax improvements in CF 9. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Edition not changing from developer to standard...
On Mon, Apr 16, 2012 at 8:37 PM, Eric Roberts wrote: I am having an issue with CF8 64BIT (8.01) when I enter the serial number fo the standard edition we purchased, the serial number appears to be accepted, but the edition stays at developer. Any ideas on how to resolve this? CF8 Standard does not support a 64-bit configuration. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: hash collision
On Tue, Mar 13, 2012 at 8:36 PM, Judah McAuley wrote: Thanks, Leigh, looks like that verifies that it is the same issue. Now I'm curious why it took Adobe til the middle of March to fix a vulnerability that everyone else fixed by early January at the latest. Just like with their other software Adobe tries to stick to a 3-month release cycle for ColdFusion. The 2011Q4 update was December 13, the 2012Q1 update is March 13. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Crossed Accounts Issue
On Wed, Feb 1, 2012 at 4:28 PM, Eric Williams wrote:
CFSCRIPT
if(NOT IsDefined(APPLICATION.oUser)){
APPLICATION.oUser=CreateObject(component,#APPLICATION.G.CFC_PATH#User);
}
APPLICATION.oUser.DSN=this.DSN;
/CFSCRIPT
CFSET
session.RetAuth=APPLICATION.oUser.authenticate(form.Login,form.Password)
CFSET SESSION.UserName=FORM.Login
I see 3 problems with this code:
1. Why is that authentication component instantiated there instead of
in the onApplicationStart()?
2. You are setting the DSN in a separate call from the authenticate()
call. If your application uses the same DSN all the time, that should
go in the onApplicationStart() as well. If not, the DSN should be an
argument of the authenticate() call.
3. You are setting the session username to whatever was in the login
form instead of what is returned from your authentication call.
I would put money on not needing any locking at all to make this code
thread-safe if you just refactor along those lines.
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349764
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Opinion: Abuse of session variables
On Tue, Jan 31, 2012 at 5:01 PM, Robert Harrison rob...@austin-williams.com wrote: I've got a new programmer working for me (on contract) and I'm finding he's using session Vars all over the place. He creating session Vars on forms that have a hundred fields, he putting arrays into session Vars, etc. I just went through a few of the programs he wrote and used them, then I dumped my session vars and found I had over 250 session vars from just using a few programs. Considering the site has over 1,000 users on it at any given moment, I'm very concerned about this practice. Your primary concern should not be the memory usage implications of this practice, but the functional implications. What does it mean for the correctness of your application? Can you still navigate the site with multiple tabs opened if everything goes into the session scope or do you get weird results on some pages because session variables get overwritten from elsewhere? Only after you are certain the code is functionally correct memory optimizations come into play Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: This actually works!
On Fri, Jan 20, 2012 at 6:03 AM, Justin Scott wrote: When you use XMLParse(), the resulting variable is a set of arrays and structures, so it's not just a lot like working with them, you actually are, What does that even mean in a typeless language? The way I always explain it when doing CF training is that in a strongly typed language variable datatypes take precedence over function/operator datatypes while in CFML funtion and operator types take precedence over variable datatypes. So in a strongly typed language the statement x = y + z is executed by looking at the datatypes of y and z, and then searching for an operator with symbol + and a left and right parameter with the right datatypes. In CFML on the other hand the statement x = y + z is executed by searching for the operator +, finding out what types its left and right parameter are and then casting y and z to the required type. So no, the resulting variable from XMLParse() is not a set of arrays and structures, it is a variable that is cast-compatible with array and structure functions. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JRun parsing path error
On Tue, Dec 13, 2011 at 11:44 AM, Kym Kovan wrote: my.domain.name/content.cfm/name/of/page fails with a 404 from JRun and an error message of File not found - content.cfm/name/of/page. Search /WEB-INF/web.xml for SES and follow the instructions in the comment. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: TOT - Forwarding port 80 to two machines with a home Router -- Linksys WRT54GL
On Sat, Dec 10, 2011 at 4:06 AM, Gerald Guido wrote: I have two servers @ home that I want to use for hosting hobby sites. One runs Win 08 server and the other Linux (CentOS). My router ( Linksys WRT54GL) does port forwarding but I want to have port 80 point to both machines based on the domain. Did you upgrade your router to run an open souce Linux or are you running the original Linksys firmware? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 9 on One Computer and IIS 7 on Another Computer
On Thu, Dec 8, 2011 at 2:29 AM, Eugene Colucci wrote: Out of curiosity, at that point why not use 64-bit CF on your 64-bit server? Fear of the unknown. Conquer your fears :) Unless you still use 32-bit stuff (COM, MS Access, 32-bit CFX tags) 64-bit CF is actually easier to install on Win64 than 32-bit CF. There are two ways you could do this: using distributed mode in CF, or using IIS as a reverse proxy for specific URL patterns that correspond to your web applications on the other server. The distributed mode functionality is somewhat limited and CF-specific, and may not work in your environment, so I'd suggest the reverse proxy approach. Google IIS reverse proxy for more information. Forgive my obtuseness, but does this mean we can use the Standard Edition of CF 9? Yes. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Change Subversion login info stored in CFBuilder
On Thu, Dec 8, 2011 at 6:38 PM, Eric Cobb wrote: So, I have my SVN repositories set up in CFBuilder (via the subclipse plugin), and I have it set to remember my username/password when connecting to the repositories. I have a case where I need to change my login for one of my repository connections, and I can't seem to figure out how to do that in CFBuilder. The default location is a Subversion folder in your user dir. By storing it there all your SVN clients can share cached login information. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFDocument problem - direct call works cfinclude doesn't
On Wed, Nov 2, 2011 at 2:43 PM, DURETTE, STEVEN J wrote: I've searched and my google-foo is failing me today. I have a very simple page that generates a pdf file. When called directly it works just fine, however if the file is included through a cfinclude then the error: cfdocument tag has no body. It must have a body or a source file or URL. comes up every time. The page that does the cfinclude probably has a different setting for enablecfoutputonly. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFtransaction questions
On Tue, Nov 1, 2011 at 1:13 AM, Matt Blatchley wrote: Microsoft SQL Server 2008 (SP1) Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2) Database table stores the Metrics by daily values so it's constantly being hit by the imported data and the user interface. That is what snapshot isolation is designed for: http://msdn.microsoft.com/en-us/library/tcbchxcb%28v=vs.80%29.aspx Use with updlock and as short lock acquisition timeout to grab items from a queue table and the snapshot isolation will make sure the concurrent updates to the metrics table won't affect eachother. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFtransaction questions
On Mon, Oct 31, 2011 at 8:56 PM, Matt Blatchley wrote: So my question is this: Is it possible to have multiple queues running on different machines and dumping the data into the same table? Yes. Using cftransaction, the second queue attempts to run but has to wait until the main Queue finishes before the secondary queue starts. That is probably caused by the exact SQL used in combination with the locking strategy your database is using. You have to either make sure your database doesn't use predicate locking, or that you don't run multi row statements by separating the table that holds the actual queue from the one where you lock your records in a transaction More details on database schema's, vendors and versions will result in more details in the answer :) Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JVM Heap Size
On Wed, Oct 12, 2011 at 9:41 PM, John M Bliss wrote: This may be a shot in the dark, but, does anyone on this list have a resource/URL/etc illustrating average traceroute/ping times between high-end Web hosting facilities and 'Net locations around the world? Run your own tests: http://www.traceroute.org/ Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JVM Heap Size
On Wed, Oct 5, 2011 at 6:25 AM, John M Bliss wrote: Regularly, CF briefly consumes all but about 50 MB of max heap size. Isn't that what is supposed to happen? The JVM uses memory until it runs out which starts the garbage collector. Are you experiencing any problems with the current behaviour? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Error handler or database bringing down server?
On Wed, Oct 5, 2011 at 2:05 PM, Jon F wrote: I have a situation where the web server became unresponsive and have been unable to pinpoint the exact issue as to why. Question: Is it the error handler or the database timeouts locking up threads that played havoc on the server or a combination of both? Also, what do you suggest will fix it permanently? Install a full JDK and use jstack to generate a thread dump when this happens again. Then you can see what is going on and fix it. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347956 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JVM Heap Size
On Oct 5, 2011 8:37 AM, John M Bliss wrote: We're just tuning stuff to get the fastest possible responses from our app. And isn't that goal best served by letting the JVM consume all available memory instead f running the garbage collector all the time? (If you answer no please include your exact definition of fastest possible responses.) Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 8 Scheduler Not Able to Run Tasks
On Wed, Oct 5, 2011 at 11:56 AM, Robert Nurse wrote: I'm running CF8 on a CentOS 4 box and I've just imported some scheduled jobs via Packaging Deploying. I've updated the URL within each task and tested them manually in a browser. However, when I attempt to run them via the Scheduler, I get errors and none of the listed possible causes apply. Is there some reason you are not including the errors you are getting for us? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: READ UNCOMMITTED
On Fri, Sep 30, 2011 at 11:45 PM, John M Bliss wrote: type 1 - about 1-5 SELECTS per second that have to run as fast as possible *always* ( 1 second) My question is: if the goal is to make sure type 1 remains as fast as possible, will it help/hurt to also declare SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED on type 1 queries? It would help. What would help equally but would IMHO have less side effects would be to use snapshot isolation. That is an isolation level that provides serializability according to the SQL standard, even though it is not true mathematical serializability. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
On Mon, Sep 26, 2011 at 9:50 PM, Richard (J7 Group) wrote: I wonder if I am over complicating this issue. Basically our application is a Software as a Service (SaaS) and each client that accesses it really only needs to connect to their own data source due to the type of data our application processes... and regulations in the industry say their data must be separated. I imagined that was the use-case :) Database vendors have specific solutions for multiple identical databases, one for each customer. A popular one is to have separate databases faked by a database server that uses just one database but shows different data based on the customer (login). I believe that is a reasonable approximation of the problem you are facing. One of the vendor buzzwords for that is Virtual Private Database and looking for that shows that the performance problem in having different classes for each customer is solvable if you use Hibernate directly: https://forum.hibernate.org/viewtopic.php?t=940748 I am unsure if ColdFusion exposes sufficient control over the Hibernate session to dynamically switch the datasource or login session in CFML, but if you want to use ORM this is the direction I would recommend exploring. So, the actual objects in the database may vary but only *very* slightly. If you want this to work you are probably going to have to merge those differences into one standard schema. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Multiple reply-to addresses?
On Tue, Sep 27, 2011 at 4:06 PM, Russ Michaels wrote: it is not valid to have multiple reply-to addresses, if you want it to go to multiple users then set the reply-to to a LIST/MRA address. While it is not valid to have multiple Reply-to headers in your email message, RFC 2822 specifically says the one Reply-to header you are allowed to have consists of a list of email addresses. It just happens to be so that that lists usually has a length of 1. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM overhead
On Mon, Sep 26, 2011 at 8:07 PM, Richard (J7 Group) wrote: Performance overhead, especially in an application that could be linked to thousands of data sources? I think an application with thousands of datasources is so far out of the experience of other users that we will have no way of answering your question. I do have a few questions that may be helpful in finding the right questions and answers yourself. 1. What would you consider an acceptable overhead in terms of GB of RAM? 2. What would you consider an acceptable overhead ni terms of seconds delay of application startup? Once you have answered that, run the following experiment: 1. For one database, generate the CFCs for the tables using a code generator (such as the plugin to CF Builder). 2. Add the database to the orm configuration in application.cfc 3. Add the CFC folder to the orm configuration in application.cfc. 4. Measure startup time. 5. Repeat step 1-3 for 9 more databases. 6. Measure startup time. 7. Extrapolate. With thousands of datasources even a small number of tables per datasource means on startup CF has to compile and process tens or even hundreds of thousands of CFCs to build all the right relations and objects. I expect that to be prohibitively expensive on startup time (question 2) long before you have a problem with RAM (question1), even if you use HBMXML files to store the relations. Since my experience does not go further then close to 200 tables in one application I have no idea what the result will be and am very interested in what your measurements will tell. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CreateObject referencing a .NET assembly on Network Storage
On Wed, Sep 14, 2011 at 8:21 PM, Andrey Baranov wrote: So, both IIS and Coldfusion are installed on the same server, but the actual web content resides elsewhere. Coldfusion is running under a local account that's synced to an account for the Network Storage, so it has access to the pages it needs. But what account is the ColdFusion .NET Service using? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Distributed servers?
On Sun, Aug 28, 2011 at 5:45 PM, Al Musella, DPM wrote: The costs seem too high. It looks like it would cost about $86 a month for a small instance.. and then I need coldfusion. Adobe donated one licence of cf to us, but I would probably have to buy that second license? I do not believe a separate license is required for a standby server. I wound up setting up a godaddy shared account to use as a backup.. It was $129 per year and includes SQL server and cold fusion Then what you need to do is set a very aggressive backup schedule on the transaction log of your database. Something like a backup every 5 minutes. Then schedule an FTP synchronization to run every 5 minutes to godaddy and you have a reasonable guarantee against data loss. Of course that presumes you are willing to store the data from a patient registry on a shared server in the first place. -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Mail Queue
On Fri, Aug 26, 2011 at 1:42 PM, Jenny Gavin-Wear wrote: For some reason a mail item causes an error and then holds up the entire mail spool. All the mail.log shows is Error. Is there somewhere I can get further error details so I can prevent this happening? You could try to verify in your mailserver logfile if this problem occurs before sending (corrupt message) or after sending (problem during delete due to permissions / lock by virusscanner etc.). If this happens again in a few years, try to remember to make a tread dump of the CF server and see if any application is holding a lock on the file. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Distributed servers?
On Fri, Aug 26, 2011 at 7:49 PM, Al Musella, DPM wrote: Luckily, people will understand down time due to a hurricane.. not too worried about a few minutes of data loss - I have a way to recover in case there is a loss... Sounds like you could get away with synchronizing your database transaction logs to somewhere with rsync. That easily keeps your data loss under 10 minutes and if you have a prepared AMI/VPS image somewhere you could be up and running again in 15 minutes. Just make sure your DNS TTL is low enough for that. when anything in this patient registry is added or updated, I send an email to my gmail account with the old and new data (encrypting any person info)... so if worst case happens, I can manually go back and fix things. But that only works if the email is not spooled on your local system. So you need to both disable the disk mail spool and use a remote SMTP server. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Distributed servers?
On Fri, Aug 26, 2011 at 4:57 AM, Al Musella, DPM wrote: I have my server in my office. The website runs a brain cancer registry with pretty important database stuff. More valuable than money:) How would you approach setting up a redundant server across the country so if my town gets wiped out, we still have access to the website? What is an acceptable downtime in seconds? Is any data loss acceptable (like the last 30, 60, 120, 300, 600 seconds of transactions)? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Jrun + Apache generating high amounts of log
On Tue, Aug 23, 2011 at 11:27 PM, Pradeep Viswanathan R wrote: My logs look similar to [Fri May 13 17:58:44 2011] [notice] jrApache[7365: 46824] HOST: http://www.host.com www.host.com This logfile is not generated by the JRun process, but by the JRun connector loaded into the Apache process. Try reducing the loglevel in the Apache connector configuration. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346982 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFLOCK QUESTION
On Mon, Aug 22, 2011 at 4:19 PM, Robert Harrison wrote: Please confirm... I only need that lock to hold long enough to set the variable (in case multiple people are logging in at the same time) and DO NOT need it for the entire session. cflock scope=session type=exclusive timeout=20 cfset session.userid=#getprofile.student_user_id# /cflock If multiple people sign in simultaneously they sign in to their own individual session. So that is not a reason to lock at all. The only reason to lock this code is if there is some other code that would function incorrectly if the value of session.userid changed while that code is running. In that case you have 2 options: 1. use an exclusive lock around all changes combined with a readonly lock around the piece of code that requires the userid not to change; 2. copy the userid to a local variable before you enter the code that requires the userid not to change and make that code use the local variable instead of the session variable. In my experience most web applications don't need programmatic locks at all, they just need a proper definition of risks and ordering of the operations. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Setting client variable datasource via config.xml
On Fri, Aug 12, 2011 at 12:06 AM, Brook Davies wrote: I'm trying to set all my apps properties via a config file to make deployment between dev, production servers easy. Problem is the application vars that are read via onApplicationStart() are not available within the opening part of the application.cfc and when I try to set these properties inside onRequestStart() they do not work. Should I be able to set these in onRequestsStart()? We have moved those parts of the configuration required for code outside the methods in Application.cfc to the onServerStart() method of Server.cfc. That only works because we deploy one application per instance though. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 10 and beyond
On Tue, Aug 9, 2011 at 7:19 PM, Richard Steele wrote: Yes, that's true, except I'd be concerned about no security patches. So naturally you Google;s for ColdFusion EOL and found http://www.adobe.com/support/products/enterprise/eol/eol_matrix.html#63 Adobe is classified as an Enterprise product with a 5 + 2 year support policy. Extrapolating a supposed 2012 release of ColdFusion 10 means ColdFusion will be supported until 2019 at least. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
On Thu, Aug 4, 2011 at 10:11 PM, Bryan Stevenson wrote: Well OKI'll come in with the unpopular vote thenDON'T STRIP HTML! I have always found that the text you are left with will NOT look nice to the person receiving it. As always that depends on the quality of the input. If you have properly written HTML and you: - remove everything outside the body; - remove script tags including content; - remove style tags including content; - replace anchors with their href; - remove all tags; - collapse whitespace; - rewrap with a flowed algorithm; the content will look pretty OK. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: COMPLEX SQL RANDOM
On Wed, Aug 3, 2011 at 8:43 PM, Robert Harrison wrote: Normally I would use TOP 1 and ORDER BY NEWID() to do this. But it doesn't like that with the DISTINCT clase. I'm using DISTINCT because the same poll could come up several times if it's allowed in multiple groups and that use is in several of those groups. And I would drop the DISTINCT but if one poll comes up a bunch of times that would increase the likelihood it would be selected at random. The reason for this skew is the order of execution: first you calculate matches (resulting in multiple rows for some polls), then you assign each a newID(). The solution is to assign the newID() first (when each poll only occurs once) and then calculate the matches. One of the most readable ways to force an execution order is with a CTE, which should look something like: -- define a CTE open_polls WITH open_polls AS ( SELECT portal_polls.* , NewID() as randomNumber FROM portal_polls WHERE -- with polls that are currently open portal_polls.start_date #Now()# and portal_polls.end_date #Now()# -- and have not been completed by this user and not exists ( SELECT * FROM portal_students_x_polls_completed WHERE portal_students_x_polls_completed.poll_id=portal_polls.poll_id and portal_students_x_polls_completed.student_user_id=#session.userid# ) ) -- from which we select one row SELECT TOP 1 open_polls.poll_id, open_polls.question, open_polls.answer1, open_polls.answer2, open_polls.answer2, open_polls.answer4, open_polls.answer4, open_polls.number_answers FROM open_polls, portal_groups_x_polls, portal_groups_x_students WHERE (everyone=1 OR ( portal_groups_x_polls.poll_id=open_polls.poll_id and portal_groups_x_students.group_id=portal_groups_x_polls.group_id and portal_groups_x_students.student_user_id=#session.userid# ) ) ORDER BY open_polls.randomNumber; Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: COMPLEX SQL RANDOM
On Wed, Aug 3, 2011 at 9:36 PM, Bill Franklin wrote: Why not try something like this...(not sure which database you are using) SELECT TOP 1 * FROM ( SELECT DISTINCT portal_polls.poll_id, portal_polls.question, portal_polls.answer1, portal_polls.answer2, portal_polls.answer2, portal_polls.answer4, portal_polls.answer4, portal_polls.number_answers FROM portal_polls, portal_groups_x_polls, portal_groups_x_students WHERE (portal_polls.start_date #Now()# and portal_polls.end_date #Now()#) and (everyone=1 OR (portal_groups_x_polls.poll_id=portal_polls.poll_id and portal_groups_x_students.group_id=portal_groups_x_polls.group_id and portal_groups_x_students.student_user_id=#session.userid#)) and not exists (SELECT * FROM portal_students_x_polls_completed WHERE portal_students_x_polls_completed.poll_id=portal_polls.poll_id and portal_students_x_polls_completed.student_user_id=#session.userid#); ) Because this query does not have a random result. The result of the outer query will always be the first row of the inner query. The result of the inner query will be in a predictable order based on the indexes and statistics (probably whichever row is returned first by the index over poll_id, start_date and end_date as I suspect that will be the driving index). Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Resetting cached components
On Wed, Aug 3, 2011 at 4:41 PM, Eric Cobb wrote: Let's say I've got an object cached in the application scope. The call to this CFC is used throughout the site, which gets a lot of traffic. Everything inside the CFC is var scoped, and it's completely encapsulated. It's just runs a query, sets some variables, and returns the results. What would happen if I were to reset the cache (by re-running cfset application.myCfc = new com.blah) while someone was using that cached call? The short answer: requests would use either the old instance or the new instance, so the only way you would get a problem is if the requests call multiple methods on the CFC (or one method multiple times) and expect the results to be consistent between calls. (If your application expects that consistency, put the cfc instance in the request scope in the onRequestStart() and use that throughout your application. The long answer is a bit more complicated and depends on your exact addressing scheme. Imagine the following (pseudo)code in some template: 1. cfset application.myCfc = new utilCfc() / 2. cfset local.something[1].localReference = application.myCfc / 3. cfset application.myCfc = new utilCfc() / 4. cfset local.something[1].localReference.doSomething() / 5. cfset application.myCfc.doSomething() / If you use patterns like this the code in line 4 and 5 may refer to different instances of utilCfc because in line 4 you are addressing utilCfc through an intermediate variable that may or may not have been updated by the code on line 3, while in line 5 you are definitely talking to the new instance that was created by line 3. Consistent coding is not just for readability :) Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: COMPLEX SQL RANDOM
On Wed, Aug 3, 2011 at 10:13 PM, Leigh wrote: Offhand do you know if there are any issues using NEWID() within CTE's? I have a vague recollection of issues with that function. Either when used within CTE's or possible derived tables. Not sure. Not that I am aware off. But then again, I didn't even know that uniqueidentifiers had a comparator nowadays and could be sorted :) Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Label Printer
On Wed, Aug 3, 2011 at 5:50 PM, Chad Gray wrote: I have an inventory website and it would be nice to be able to print barcodes and product data to a label printer. Do you want to print to your own printer or should the visitor print to his printer? In the latter case it may be a better idea to provide a PDF generation service that generates PDFs with a paper size suitable for labels so they can be printed on general purpose printers as well. (Or if you have a label printer yourself you should see if it is supported by cfprint.) Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Adobe Solution?
On Wed, Jul 13, 2011 at 10:13 PM, Scott Spurlock wrote: Yes, this is what I'm trying to accomplish. My client wants a PDF (or Excel or Word) form that he can send to people, have them fill out, and email back to him. Easy so far with a PDF form. You can configure it to send back either XML or the filled out PDF. He then wants to be able to import that data into an Access database without having to retype anything into an Access form. With a PDF form there are 2 solutions: - hook up the receiving mailbox to some server solution (for instance LiveCycle or ColdFusion) and let the server solution parse the data and fill the database; - manually open each email, save the attachment to a folder and process the attachment. For processing the attachment you can either do something with having the clients submit is as XML and processing the XML using VBA(?) or you can have the clients submit as PDF and extract the results as a .csv from a directory of PDFs and then import the .csv to Access. Since it looks like circumstances force you to go the manual route, how much time is the client willing to spent per received response? 3 minutes? 1 minute? 10 seconds? What volume are you looking at? Would the client be compatible with one of the licensing options described at: http://help.adobe.com/en_US/Acrobat/9.0/3D/WS58a04a822e3e50102bd615109794195ff-7e0d.w.html Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346234 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
On Tue, May 24, 2011 at 10:48 AM, James Holmes wrote: One issue the OP faces is that the traffic is HTTPS. The request will have to change to HTTP before anything useful will show up. In that case, these are the steps I usually go through: 1. Download the WSDL file. 2. Change the endpoints from HTTPS to HTTP. 3. Save the file on a site. 4. Modify the hosts file of the ColdFusion server to point the hostname in the WSDL to some other server under your control. 5. On that other server set up a HTTP to HTTPS conversion listening on port 80 and forwarding to port 443 on the server the webservice runs on. (I typically use stunnel for that). 6. Invoke the service from CF. 7 Sniff with Wireshark. A setup with Fiddler could do this without the need for a second server, but I use this for lots of non HTTP protocols so I have a permanent stunnel setup anyway. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
On Tue, May 24, 2011 at 9:55 AM, Robert Rhodes wrote: Hello Jochem. I checked out Wireshark, but did not see a way for it to show me the XML I was sending. Am I missing something? It looks like Wireshark is a packet capture tool? Yes, it is a packet capture tool. It allows you to drill down in the results until you reach the SOAP data in the HTTP payload. Just keep expanding the results until you reach it. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
On Mon, May 23, 2011 at 1:16 AM, Robert Rhodes wrote: Would one of you kind souls tell me how to configure one of these programs (or some other program) so I can see my SOAP going out and see the response? Install Wireshark to capture all traffic on a system: http://www.wireshark.org/ Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bless cfqueryparam - helped defend against a persistent hack attempt
On Mon, May 2, 2011 at 11:48 AM, Mike Kear wrote: Thankfully I'd heeded good advice and used cfqueryparam on all the queries in that site and nothing they tried worked. They were submitting urls with parameters like : /index.cfm?pid=111825pgm=../../../../../../../../../../proc/self/environguestprogID=2 and many many variations. That is not an attempts at SQL injection at all. That is an attempt to test for a Linux vulnerability: http://lwn.net/Articles/191954/ Considering how long ago that vulnerability was fixed this was most likely a generic scan, not something tailored to ColdFusion or your sites. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9's cfmail remove attribute not working at Crystal Tech
On Tue, May 3, 2011 at 7:23 PM, Dave Burns wrote: I just spent an hour working with a tech at Crystal Tech diagnosing an email problem which ended up with me realizing that the very convenient remove attribute that is new to CF9's cfmail tag will not work in their environment. The reason for this is that they don't use CF's built-in mail client, instead handing off to SmarterMail. Disable spooling alltogether with the spoolenable attribute of cfmail. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfzip and Native Windows Zip Support
IIRC the Windows native compressed file facility is not Unicode aware and has a 256 character path lenght limit. Jochem ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Insufficient error logging
On Thu, Mar 31, 2011 at 8:03 PM, David Patricola wrote: Correct! I did manage to get a more robust error to spit out (truncated): sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target So I'm trying to figure out whether Java isn't looking in the default cacerts file that ColdFusion points to, or my certificate is incorrect. Try importing the whole certificate chain: PostgreSQL certificate, intermediate certificate and root certificate. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion service stop rsponding or CPU goes up tp 100%
On Mon, Mar 21, 2011 at 7:11 PM, tom vallee wrote: Sometimes the CPU goes up to 100% and I need to restart the coldfusion service and everything goes back normal Sometimes, coldfusion stop responding, if i type my website in internet explorer, it's not responsing but IIS is responding i think it might be the JVM settings, Why do you think so? Can you correlate the problems to occurrences of garbage collection in your log files? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343241 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with new CF Update
On Fri, Mar 18, 2011 at 4:07 PM, Jason Nokes wrote: I successfully deployed the fixed hotfix (http://www.adobe.com/support/security/bulletins/apsb11-04.html) on both of our development servers, but cannot get it deployed to our production servers. When I add âDcoldfusion.session.protectfixation=false to the JVM arguments CF service will not start. I have seen the same on some CF 8 Standard servers. The critical lines in coldfusion-out.log are: java.lang.NoClassDefFoundError: Dcoldfusion/session/protectfixation=false Caused by: java.lang.ClassNotFoundException: Dcoldfusion.session.protectfixation=false at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) Exception in thread main These sites run with a very non-default set of classpath and libpath variables in jvm.config and I haven't had time to see if this is a problem with these sites or with the patch in general. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343149 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 generates Error Code 430 in event log
On Sat, Mar 19, 2011 at 4:49 PM, John Pullam wrote: I'm struggling with a problem in my Win7 system that just started today. It freezes on me and requires a reboot so I'm trying to get to the bottom of what might be causing it. When I open the windows event log, the first error message after a boot is this: The message you are looking for is the last one *before* a boot. Anyway, it should be easy to rule out CF: - why are you using ODBC at all? - if you run your ColdFusion services as a non-privileged user they simply don't have sufficient permissions to halt the computer. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF and GIS?
On Wed, Mar 16, 2011 at 5:12 PM, Bryan Stevenson wrote: I'm wondering if anyone has any advice on performing a task that involves determining if a given lat/long is within a given oddly shaped (not a simple rectangle) area/box? Where do the point and the polygon originate and in which way are they described? In most cases I have dealt with the point was based on user input and the polygon was in some server side dataset. In that case it is just a matter of storing the polygon in a proper format like WKB or whatever geometric datatype your database offers and using the API's or SQL operators provided to do the comparison. I would assume the hard part is defining the boundaries of an irregular shaped box, but once defined the check to see if the co-ordinates are within it is probably more straightforward. Typically you define your shapes by the coordinates of the series of points that make up the edge. Then you first get a simple (indexable in a proper database) comparison to see if your point is a potential match (between min/max of long/lat). Followed by more complex math to see if it is a proper match. For instance a crescent shape has lots of points between the minimum and maximum that still don't overlap. The latter comparison is something you definitely don't want to implement yourself. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfdocument and javascript
On Sun, Mar 6, 2011 at 5:49 PM, fun and learning wrote: I am using cfdocument with format = pdf. I am displaying some dynamic data. I need to have an expand/collapse functionality within the pdf. Is it possible to implement the same using javascript in cfdocument? You can not do that with cfdocument. You would need to create an XFA PDF form using LiveCycle Designer (part of Adobe Acrobat) and then will it with the proper data using cfpdfform. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfheader and foreign characters
On Tue, Feb 22, 2011 at 10:42 PM, Richard Steele wrote: I'm trying to save a text file that has foreign characters. If you want to instruct the browser to save a file instead of trying to render it to the user, you need to set a content disposition in combination with a MIME type of application/octet-stream. See RFC 2616 19.5.1. Once your file is placed on the harddisk of the client computer, it is up to the used application on the client computer to infer what charset is in it. Some applications will just presume it is the environment charset, some will presume it is a specific one (like ISO-8859-1), some will try to do some logic. You may be able to help that last category by making sure there is a BOM in your file: http://unicode.org/faq/utf_bom.html#bom10 Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion app using MySQL - Is moving the MySql to Amazon RDS feasible/efficient?
On Fri, Feb 18, 2011 at 5:57 AM, Chris wrote: Stumbled onto Amazon RDS (link: http://aws.amazon.com/rds/) and the concept from what I'm reading at least, sounds great. I currently use shared hosting with CF and MySQL. I'm pouring over the documentation but most of it is over my head as I'm not familiar with Amazon web services and/or MySQL server administration. From what I'm getting though, I can create the MySQL database there, import data into it, and then connect to it from the CF server during CFQUERY calls. In theory yes. In practice you may encounter the following problems: - firewalls preventing your shared host from connecting to the database; - latency between your shared host and the database. The last one can be a killer. Let's presume the network latency is about 50 ms. For setting up a database connection you first have the TCP SYN/ACK and then MySQL authentication. Your best case scenario is now 100 ms to set up the connection. Doing a query? First send the PREPARE statement, then execute it. So that is another 100 ms. But wait, once the results are in the driver will do additional calls to get the metadata that describe the columns. So doing a query over a new connection is now 250 ms, and over an existing connection 150 ms. And that is without the unpredictability of the latency inside the Amazon cloud. Amazon RDS may be a good solution if your app is hosted at Amazon too, but otherwise I don't think it is a good idea for interactive applications. And if you are hosting your servers on Amazon, why not load MySQL on your instance there? But the great thing about all the Amazon Cloud services is the cost for a short test. Since it costs you about 0.11$ per hour to just test it, so why not try it and tell us how it goes :) Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: JVM help!
Why do you believe this is a JVM problem? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
On Mon, Feb 14, 2011 at 11:44 PM, Matt Robertson wrote: I am tasked with doing an import on a file whose size can essentially be unlimited. We've been able to handle in the 10-15mb range but it recently ballooned to 100 mb, and its going to get larger. Processing time seems to be about 66 hours for a 45 mb file and thats a disaster. Would it help if you split the file into individual records before processing them? http://jochem.vandieten.net/2011/02/17/splitting-large-xml-files-with-coldfusion-and-stax/ Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Change in ColdFusion management
push in CF 9 would have been nice, but that ship has sailed (without any problems that are insurmountable IMHO). That leaves language changes due to functionality additions. The choice what functionality will be added is a business decision and we don't need a committee to decide whether a new tag will be named cflivecycle or cflcworkspce or cfpdfservice. (And for that sort of design you won't be able to interest any serious academics either.) I guess I could just have written that I don't see what the big deal is. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion errors
On Wed, Feb 9, 2011 at 6:35 AM, Dave Watts wrote: That said, you should not need to catch compiler errors. Those should never make it past the first stage of development, much less into production. The easiest (best?) way to catch compile errors is to precompile all your code using the cfcompile batch file (or your own Ant/Maven scripts) and deploy compiled code. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Accessing Specific CF8 Instances
On Mon, Feb 7, 2011 at 10:58 PM, Richard Steele wrote: Well, I'm wondering if I can access the instance using an external, website address. Our developers don't necessarily have access to logging into the server. So, I'm hoping we could do something like this. http://www.website.com/index.cfm?CFID=x where x is the id of an instance. The load balancing in a Java cluster is a feature of the underlying Java container and the connector used to connect it to a webserver. Or alternatively of the loadbalancer you use to distribute the load between the diffeent webservers. You didn't explicitly specify what you are using, so I will presume you are using several ColdFusion instances deployed on JRun, connected to a single webserver. The way you can influence to which server a request goes is through the jsessionid. Make sure you configure the cluster to use sticky sessions and then look up the server.id for each instance (in the connector.properties file in SERVER-INF). Any jsessionidof which the first 4 bytes are equal to the server.id will be directed to that instance. If you have a different setup, ask on the mailinglist for you loadbalancer vendor or Java container. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341968 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Webservice error after CF 8.01 update CF FAILS TO START! Error loading: C:/ColdFusion8/runtime/jre\bin\server\jvm.dll
On Wed, Dec 1, 2010 at 11:34 AM, Brook Davies wrote: If I open a command prompt and go to 'c:\coldfusion8\runtime\bin\' and run any of executables directly (like sniffer.exe or xmlscript.exe - I get the same error Error loading: C:/ColdFusion8/runtime/jre\bin\server\jvm.dll. So does the dll exist on the filesystem? What is the md5 and file size of the dll? Do you have some sort of antivirus with on-access scans installed on the system? Theres nothing in any logs. I don't know what else to do. How can I get a more detailed error message or insight into what is happening? How are you starting CF? Have you tried bypassing the service and just starting it from the command line with jrun.exe -start cfusion? What is the output from the command set? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Service Randomly Restarting
On Mon, Nov 29, 2010 at 4:15 PM, Dave Sueltenfuss wrote: We have a CF 9.0.1 server 32 bit, in production that randomly restarts the CF service. Does it restart the CF service wrapper (jrunsvc.exe) or the CF process (jrun.exe)? If the service wrapper restarts, look outside CF for the cause. If the process restarts, see whether there are any memory dumps from the VM anywhere or what the last loglines in int -out.log and the -event.log are. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Service Randomly Restarting
On Mon, Nov 29, 2010 at 7:01 PM, Dave Sueltenfuss wrote: It appears to be the Service Wrapper thats restarting, based on the Windows Application log Don't trust the application log, look at the PIDs. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Performance Monitoring
On Tue, Nov 23, 2010 at 5:35 PM, Paul Alkema wrote: This setting is in the ColdFusion administrator under Debugging And Logging à Debug Output Settings à Enable Performance Monitoring. I am not aware of any problems with enabling *that* setting. The Memory Monitoring option in the Server Monitoring is a killer in production though. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFDocument and Images
On Mon, Nov 22, 2010 at 5:18 PM, JediHomer wrote: I've tried toggleing the localURL with the img src set to ./image1.png and using ExpandPath to get the full path to the file so that the img src is set to the full physical path to the file. I'm on linux, so the path then becomes /home/jedi/blah... but the problem is still the same... Try a file:///home/jedi/... path. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
On Wed, Nov 10, 2010 at 12:40 AM, Richard White wrote: [query with 6600 cfqueryparams taking 9 seconds vs. 1 for plain SQL] In understand that adding the cfqueryparam is adding approx 6600 validations, however would it really be the cause of slowing this query down so much? cfqueryparam is not adding 6600 validations. Each use of cfqueryparam is causing one variable to be set on the database side. So without cfqueryparam you are sending 1 SQL statement to the JDBC driver, with cfqueryparam you are first sending a prepare command with the 'structure' of the query, then the command to create an instance of it, then 6600 commands to set the 6600 parameters, then the command to execute it. I am not familiar with the wire protocol for MySQL and can not look into the propietary JDBC driver Adobe uses for MySQL, but I would not be surprised if this were implemented as a synchronous protocol and there is significant roundtripping between the database server and ColdFusion. You are testing the pathological worst case scenario for cfqueryparam. In addition to the overhead from specifiying the variables in separate statements, you add the overhead for preparing the query and caching the execution plan, and then you only execute it once. But anyway, do you really care? If this is part of a scheduled job that takes a few hours anyway ... Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Blog software
On Tue, Nov 9, 2010 at 9:44 PM, Andrew Scott wrote: And what surprised me was cfdump is one, because of the way it is implemented. cfdump internally uses createObject(java, ...) so it isn't as much that cfdump iself is disallowed as that you can't use it when Java objects have been disabled. But since cfdump is just a .cfm template I replace it with another implementation of cfdump that doesn't rely on Java objects when I built a secure server. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339035 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Blog software
On Tue, Nov 9, 2010 at 5:35 PM, DURETTE, STEVEN J (ATTASIAIT) wrote: my provider restricts a bunch of tags (below) Most of the restrictions are reasonable for a shared host that wants to provide a modicum of security. In a properly configured Sandbox cfcontent, cflog and setProfileStrng could be enabled but the rest is just the way ColdFusion works. Pick two: - shared hosting - security - functionality With the prices I see on some of the VPS / cloud offerings I can't imagine a scenario where shared hosting is the best solution for any commercial site, and we are fast approaching the same for any personal site as well. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need assistance with hashbytes (kinda urgently..been at this since 6AM)
On Sun, Oct 24, 2010 at 9:50 AM, Monique Boea wrote:
1. I saved the value of the password column (VARCHAR 200) to a new column
for safe keeping
3. I saved the hashed value of the password column into this new
hashedPassword column like so: UPDATE [prod].[dbo].[users] SET
hashedPassword = HashBytes('MD5', password)
So for your old users you have fed your HashBytes() function a varchar.
---When a user REGISTERS, I enter the password value like so:
HashBytes('MD5', @strPassword),
How is @strPassword defined? varchar or nvarchar? Are you using
parameters in your call? Do you have string parameters as unicode
enaled or not?
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338514
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
