Questions

Hi,We see a lot of these errors in coldfusion-out.log:"removeOnExceptions is true for ourdsn. Closed the physical connection."The errors are expected in this case, but we get a lot of them. Is there any way to disable this specific error? There was an article online about editing one of CF's XML files, but it was for CFMX and we are on CF2018 Enterprise. Advice appreciated, as always.Thanks,Mark

Hi,I have a new ColdFusion 9 install on a CentOS server with Apache 2.2I applied the 9.0.1 update.The install is Standard, not Enterprise.I can access the admin at /CFIDE/... perfectly.The problem is when I try to access the first domain I have setup on server, where I installed ColdFusion on Wheels. When I type (using example instead of real domain) www.example.com or www.example.com/index.cfm, I get a ColdFusion error screen saying that it cannot find index.cfm . But index.cfm is there.I checked ColdFusion logs, and I have noticed that apparently, somewhere, two single quotes are being appended to the file name.This is what I see in cfserver.log:05/14 09:28:47 Error [jrpp-140] - File not found: /index.cfm The specific sequence of files included or processed is: /home/folder/folder/index.cfm''(with those two single quotes in the end. The file, without the single quotes, exists. The path included in the log file is the real valid path)From application.log:"Error","jrpp-140","05/14/12",

My client is considering buying a system that is based on Coldfusion.How should I evaluate whether this application has had the care and feeding necessary for it to be a healthy application with a future?What is the future of Coldfusion in general?  Has Adobe published an official roadmap (I am not interested in seeing some blog)?What are the license fees for an application deployed on a client site?What are some of the dependencies installed on the host computer?  (installed on a windows computer)?Are there RPA (robotic process automation) tools that work well with Coldfusion based web pages?I am asking the vendor these same questions but I want to do my own independent research.What other questions should I ask the vendor?

Just to let folks know, I have done a small update on cflive.net and added togetherJS to allow collaboration.Hope you find it useful.

Environment: Coldfusion2016 StandardI've imported the domain root certificate to both jre/bin/cacerts and to jre/lib/security/cacerts successfully but when using secure="CFSSL_CLIENT_AUTH" and useTLS="True", I get the message "CFSSL_CLIENT_AUTH, a client certificate is required to be imported into the security database".  Both the clientcert path and clientcertpassword are correct. 

Hi,We are on a cloud server with CF2018 Enterprise. We want to implement access restrictions to specific folders for certain user IP addresses and, of course, CGI variables such as REMOTE_ADDR are useless since we just get our cloud proxy address. CGI.REMOTE_ADDR has bit more promise as I am not sure it can be easily spoofed, but has anyone tackled such a problem and what technique did you use?We also have CGI.X_FORWARDED_FOR and this does have the client's IP address, but again I am not sure as to its "spoofability". If we ensured that the X_FORWARDED_FOR was the IP we wanted and the REMOTE_ADDR was our proxy gateway address, would that be sufficient to allow/disallow users to certain folders to run .cfm scripts?Thanks,Mark

I have this code <cfif len(trim(form.fileUpload))>  <cffile action="upload"     fileField="fileUpload"     destination="#FileDirectory#"     nameconflict="makeunique">  <cfset FileName ="#FORM.lname#_#FORM.file_type#_#FORM.key#">  <cffile action="rename" source="#FileDirectory##cffile.serverfile#" destination="#FileDirectory##variables.filename#-0.#cffile.serverFileExt#" nameconflict="makeunique"></cfif>It is code where users upload files and they get uploaded. If there are files with the same name they get renamed and made unique.For exampleUpload 1 = REV-D_166032-0.docxUpload 2 = REV-D_166032-01.docxUpload 3 = REV-D_166032-02.docxI have this on a Railo server and it works fine.But I have the exact same code on a windows server and it works differently.It overwrites the existing file. Like thisUpload 1 = REV-D_166032-0.docxUpload 2 = REV-D_166032-0.docxUpload 3 = REV-D_166032-0.doc

When running the CF 2018 installer, it does not detect that I have CF11 already installed. I have a Windows 2016 server with CF11/IIS installed on the 😧 drive. The installer doesn't give me the option to configure my web server for 2018

Hi,On one of the ColdFusion 2018 Server on Windows 2019, service doesn't start after server reboot and seeing this following error in event log. The ColdFusion 2018 Application Server service could not be started within 240 seconds.  Increase the server startup timeout value using E:\ColdFusion2018\cfusion\bin\coldfusionsvc.exe -starttimeout <seconds> "ColdFusion 2018 Application Server".We have to manually start service. I don't see anything in ColdFusion logs:"Information","main","06/01/19","03:04:11","","Starting logging...""Information","main","06/01/19","03:04:11","","Starting license...""Information","main","06/01/19","03:04:12","","Enterprise Edition enabled""Information","main","06/01/19","03:04:12","","Starting crypto...""Information","main","06/01/19","03:04:13","","Installed JSafe JCE provider: Version 6.21 Crypto-J 6.2.1, EMC Corporation. JsafeJCE Security Provider (implements RSA, DSA, ECDSA, Diffie-Hellman, ECDH, AES, DES, Triple DES, DESX, RC2, RC4, RC5, PBE,

We have a test server running CF2016 with code migrated from CF10.Everything works great... until... we pull a change from our repo that includes an edit to one of our CFC's.We have a chain of CFC's that extend one another... on a server restart, it takes approximately 40 seconds for the CFC chain to init.  It takes a bit of time, but there are no issues.If we make a single change to one of the CFCs in this chain on CF2016, it appears to be causing CF to "re-init" the entire chain and brings the server to a grinding halt under load.When we do the exact same thing on CF10, it handles it like a pro.I would love any suggestion on what to try here.  We've tried playing with various settings, but it seems there's something different in CF2016 that we are not aware of.You help is greatly appreciated!

How do you change the ColdFusion Administrator password? Does this require a restart of a service or any interruption of service?

I recently had up set up a new development laptop on which I use CF and mySQL.  I have had this application running for almost 10 years on various versions without a problem, but this is the first install on a Windows 10 machine (don't know how Windows 10 would affect this, but that is the only difference).After getting everything set up and running I came across a weird error and am wondering if anyone else has seen it.I have information I collect in which I need to encrypt a date of birth and store it.  I have this field in the database as a VARCHAR, not a date.  However, on the new machine, when trying to update or insert with cfupdate/cfinsert, I receive an error that the encrypted value is not a valid date or time string.  This happens even if I remove any validation of a valid date format and just leave it strictly as a text value.I am able to manually code an SQL update/insert which is accepted, so that would make me believe it is a CF issue, however, I am al

Bonjour,Je voudrais prendre un pdf d'un livre pour l'insérer dans un fichier mais je voudrais aussi la mise en page basique.Voici mon code :<cfpdf action = "extracttext" source = "chemin" name = "myXML"/> <cfcontent type = "text/html" /> <cfoutput> #myXML# </cfoutput>J'arrive à récupérer le texte mais sans la mise en page !Merci par avance pour votre aide.

Need a bit of assistance.  I have a client who manually creates a report t the end of each year that consists of poundage of every product per customer.  A customer may buy 50K lbs of different products each year.  Is there a way that I can add anywhere from 2 to 1000 different numbers together by outputting the data into a cfset tag or something else?

Just had to restart my Mac server for the first time since Mac OSX upgrade from 10.14.4 to 10.14.5 last week.  ColdFusion now no longer starts.   Error log shows.INFO: CFMxmlServlet: Macromedia Flex Build: 87315.134646Jun 02, 2019 11:50:11 AM org.apache.coyote.AbstractProtocol startINFO: Starting ProtocolHandler ["ajp-bio-8014"]Jun 02, 2019 11:50:11 AM com.adobe.coldfusion.launcher.Launcher runINFO: Server startup in 4859990 msError: Could not load mediaLib accelerator wrapper classes. Continuing in pure Java mode.Occurs in: com.sun.media.jai.mlib.MediaLibAccessorcom.sun.media.jai.mlib.MediaLibLoadExceptionJun 02, 2019 12:02:58 PM org.apache.catalina.core.AprLifecycleListener lifecycleEventINFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /Applications/ColdFusion11/cfusion/bin/../lib:/Applications/ColdFusion11/cfusion/bin/../lib:Jun 02, 2019 12:03:20 PM org.apache.coyote.Ab

HI Cancel membership has been canceled . How do i return membership ?

I'm looking for a way to add a text equivalent to a rendered cfchart. I've read documentation for CF11 that states "Some complex controls such as cfmap and cfchart do not include text alternatives for some image," and you cannot add an alt tag to <cfchart>. However, the same documentation states "ColdFusion charts do provide any text equivalents for non-text elements." Adobe ColdFusion 11 - Section 508 Voluntary Product Accessibility Template How is this achieved?

I am rendering a screen using AJAX / and a cfc. (No reloads)All goes well until I make a boo boo and get a JSON error. I know what causes it - text that should not be in the cfc.  But now I've hit a brick wall.  I cannot find the "extra text" that's causing it. Or ... is that the only cause? The odd thing is the application runs fine on the bets server but not on localhost. So I looked for any / all instances of "localhost" or 127.0.0.1 and nothing problematic. Is there a tool out here that scans cfc's for these silly errors? I have looked in the server admin logs but I have no idea which of the log files would house it. Usually only use application.logThanks

I've been using CFwindow for years and find it very old fashioned.Have to use this code to open a window ...<cfwindow width="#srw#" height="700" bodystyle="overflow:auto"name="Alerts" title="Alerts" modal="True" closable="true" draggable="true" resizable="true"  initshow="false" />then trigger it withColdFusion.navigate('/members/edit/edit.cfm','MemberProfileEdit');rePositionWindow('MemberProfileEdit');ColdFusion.Window.show('MemberProfileEdit');ColdFusion.Window.hide('pRC')I am also told by another developer that this usage is archaic and inefficient, in that the cfwindow line actually opens the window on initial load.Also having problems getting a cfwindow to "find" javascript that is declared outside of it.What in jquery can one use that is today's standards?

J'd like to manage libreooffice api for replace text in odf.i've done a running java cfx but when i transate to cf sintax i get an errorthis is the working java/cfx codecom.sun.star.util.XReplaceable xReplaceable = null;com.sun.star.util.XReplaceDescriptor xReplaceDescr = null;xReplaceable = UnoRuntime.queryInterface(com.sun.star.util.XReplaceable.class, xTextDocument);xReplaceDescr = xReplaceable.createReplaceDescriptor();and this is the cf code<cfset xReplaceable = CreateObject("java", "com.sun.star.util.XReplaceable")><cfset xReplaceableClass = xReplaceable.getClass()><cfset xReplaceable = UnoRuntime.queryInterface(XTextDocumentClass, xTextDocument)><cfset xReplaceDescr = xReplaceable.createReplaceDescriptor()>the error is in the last lineclass not found: com.sun.star.util.XReplaceable.createReplaceDescriptorany ideas?

Hello, all,I've got an issue that has me perplexed.We have a section on our restricted site for news.  There is an admin panel that allows someone (authorized) to create/edit news articles, and one of the optional fields is for uploading an image.Now, so far this hasn't really presented any problems.  Until today, every image that was uploaded fit a particular format ratio, so everything appears correct.Today, two images that are much more wide compared to the height have been uploaded.  When viewing the actual article, it looks okay.  However, on the 'landing' page of the site, there is a carousel that rotates among four selected articles that contain an image, along with four clickable thumbnails on the right side.  For both the thumbnails and the full-size image associated with it, those two images extend past the right of the image space, I'm assuming it's using overflow: hidden;.I tried to update the page that processes the form, using imageInfo() to check

I'm looking to convert libreoffice java example to cfm but j don't undestand how reference to "XComponentLoader.class" before create itthis row are ok<cfset OOB = createObject("java","com.sun.star.comp.helper.Bootstrap")/><cfset xContext = OOB.bootstrap()><cfset xMCF = xContext.getServiceManager()><cfset desktop = xMCF.createInstanceWithContext("com.sun.star.frame.Desktop", xContext)><cfset UnoRuntime = createObject("java","com.sun.star.uno.UnoRuntime")/>this is then row to convert     XComponentLoader xCompLoader = UnoRuntime.queryInterface(XComponentLoader.class, xDesktop);I try:1) <cfset xComponentLoader = UnoRuntime.queryInterface(XComponentLoader.class, desktop)>2) <cfset myloader = createObject("java","com.sun.star.frame.XComponentLoader")/><cfset xComponentLoader = UnoRuntime.queryInterface(myloader.class, desktop)>3) <cfobject type="Java" class="com.sun.star.frame.XComponentLoader.class" name="myloader" acti

Anyone have any experience setting up the Simba JDBC driver for Google BigQuery using service account authentication?The problem seems to be reading the file  which is defined in the OAuthPvtKeyPath which is a part of the JDBC URL. When I submit the form with the JDBC URL, Driver Class, Driver Name etc I receive the following error:java.sql.SQLNonTransientConnectionException: [Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): OAuthPvtKeyPath, OAuthServiceAcctEmail, ProjectIdAll three parameters (OAuthPvtKeyPath, OAuthServiceAcctEmail and Projectid) is part of the JDBC URL like this example from the Simba JDBC driver user manual (except from the OAuthPvtKeyPath which is the path I'm using on my Mac):jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=MyBigQueryProject;OAuthType=0;OAuthServiceAcctEmail=bqtest1@data-drivertesting.iam.gserviceaccount.com;OAuthPvtKeyPath=/Applications/ColdFusion2018/cfusion/lib/myfilewithkeys.json

Coldfusion 11. I use server monitoring, which is configured on jetty.port. How to disable http TRACE, OPTIONS methods on jetty.port?

I've recently changed from Dreamweaver CSS.5 to Dreamweaver CC.  There are a number of little differences that make a BIG difference in usability.I finally found (through an internet search) where "Search local site" is.When I attempt to close a tag with </, the autofill is almost never the tag I opened. When using block comments with <!---   --->If there is a comment IN that block comment, the color change terminates. Auto indent is really just messed up...I had to turn it off.So the basic question is....Is there a way to make Dreamweaver CC work more like Dreamweaver CSS.5?It is not my opinion that these are all "things you are used to" kind of problems.  These are changes that were made that a) don't work the way they were supposed to and b) are NOT a step forward.