Questions

The latest DOD STIG for CF is for version 11, but I have to used even if its just in spirit.  It calls for the internal tomcat webserver to be disabled. I could be wrong but it seems that even though I've configure all the IIS websites to run with CF, the admin pages are still being served by the internal webserver by default, yes? Is there a way to serve the admin pages over IIS so I can disable the internal web server? Thanks.

We are pleased to announce that we have released the updates for the following ColdFusion versions:   ColdFusion (2021 release) Update 4 ColdFusion (2018 release) Update 14   Note: The ColdFusion Add-Ons and lockdown installers are also refreshed. The refreshed installers are available at ColdFusion downloads.   In these updates, we’ve fixed a few security bugs, and upgraded Tomcat, along with other libraries.   ColdFusion (2021 release) Update 4 ColdFusion (2018 release) Update 14 Performance Monitoring Toolset 2018 Update 5 Performance Monitoring Toolset 2021 Update 4   These updates fix security vulnerabilities that are mentioned in the security bulletin,  APSB22-22.   The Docker images will be hosted shortly on Docker Hub.   Please update your ColdFusion versions and provide us with your valuable feedback.  

we have been using cfpop for years to open a mailbox and download attachment/headers.it started failing last night.....now exchange provider claims we are not using TLS 1.2This is what we've been using <cfpopserver = "*.*.*.*"username = "*****@*****" password = "*******!"action = "getAll"name = "qheader"secure="yes"> Other than CFIMAP or  createObject("component", "pop").init() are there any other alternatives to open a mailbox and download headers/attachments? Thanks Paolo 

Surprisingly I could not find a discussion about this in the forums. I downloaded and unzipped the files, and went to cfinstall.bat in the bin folder. I also downloaded VC 2012 Runtime. But here my progress ended. I tried to run cfsnstall.bat as administrator, and also I made attempts to start the installation in other ways, but without success. I got to the usual window "accept changes ro the system..." but that was it. What is the correct procedure at this point? It must be very straightforward.  

Hello,I am new to CF and I am struggling to convert an existing form that creates and downloads an .xls fileinto a form that creates and downloads an .xlsx file.We are currently running ColdFusion Server Enterprise 2021,0,03,329779.The current main .cfm page queries the data, formats the output,and calls another .cfm to generate the .xls file.The struggle is after code changes are made and after the .xlsx file is created and downloaded,I receive the error message:"Excel cannot be open the file 'nnnnn.xlsx' because the file format or file extension is not valid" The main.cfm page uses the following file name, header data, and formatting masks structure:<cfsilent> <cfscript> variables.fileName = "#replace(reportData.headerData.reportTitle, ' ', '', 'all')#_#dateFormat(reportData.headerData.reportUpdatedDate, 'yyyymmdd')#.xls"; variables.headerContent = "#reportData.headerData.reportTitle#"; // styles styles = StructNew(); styles.th = "border: 1px solid ##

I have upgraded ColdFusion from 2016 to 2021.  The installation log file shows only successes without any warnings or errors.  CF Admin launched after the installation and I was able to confirm the settings migrated correctly and I created 2 of the 3 datasources with the Oracle driver(I don't have good password for 1 of them).  I also manually installed update 4.  I disconnected all the IIS sites from version 2016 with its Web Ser Config Tool and then connected all of them to the new version.  I've disabled the old CF2016 services to ensure there's no confusion Unfortunately now, I can't get into the CF Admin.  IE reports ERR_CONNECTION_TIMED_OUT.  The 1 site the server is hosting responds with a CF error because one of the datasources is broken.  So at least I know CF is running and responding to requests.  The pathes of 2 of the virtual directories were correctly updated to the new CF version's path. However, CFIDE was still poin

I am trying to implement Amazon Pay Checkout, V2 in coldfusion (ACF2016/windows) leveraging the provided JAVA code from Amazon's docs and Amazon's .jar file. (https://github.com/amzn/amazon-pay-api-sdk-java#readmeglobal)I have written a cfc, meant to be used in the session. I instantiate the WebstoreClient object, set the Pay Configuration and generate the button code just fine. Click the button on the page, a window opens, log into sandbox, close the window and go to the second checkout page with a sessionid in the URL (keeping it simple) When the button is clicked, amazon creates your checkout session, and all the local methods are GET/POST/PATCH operations to amazon servers - simple enough. Not knowing java, but able to [usually] follow code, it sure looks like everything is there..Here is where I am having trouble. I cannot getCheckoutSession(sessionid) The error I get isThe getCheckoutSession method was not found. Either there are no methods with the specified method name and argu

Running Cold Fusion 2021, and the upper menu on each of the options (Server Settings, Data & Sources, etc.) has suddely disappeared. Has anyone else had the same experience? Server Product: ColdFusion 2021 ReleaseVersion: 2021.0.0.323925Tomcat Version: 9.0.37.0Edition: EnterpriseOperating System: Windows Server 2016OS Version: 10.0Adobe Driver Version: 5.1.4 (Build 0001) 

There is a reference for offline activation of a license for a server located behind a firewall in this linkhttps://helpx.adobe.com/in/coldfusion/using/coldfusion-licensing-activation.html#Offlineactivationhowever I cannot see any link to Generate Activation Request in the Lincensing and Activation page.  When I try to activate, it accepts my license and says its activated, but on restart, it goes back to trial version.

Hi Cold Fusion community, today i've  installed the ColdFusion 2021 (Update 14) and entered the Number Series during. Due to the fact our server is in a secured network layer we cannot connect to the Adobe licensing server.So we tried to follow the offline activation process, but the mentioned button "Generate Activation Request" from the Adobe Instruction is not available in the CF Admin portal:https://helpx.adobe.com/coldfusion/using/coldfusion-licensing-activation.html Did someone else have/had the same issue and resolved it? Is there another way to get the software activated? Thank you in advance.

Here's another issue I'm running into with our new CF2021 instance. This function worked fine with CF2016 using Java 11  public date function convertEpochToODBCDate( required numeric ts ){ var objTZ = createObject( "java", "java.util.TimeZone" ); var objDF = createObject( "java", "java.text.SimpleDateFormat" ); var objDate = createObject( "java", "java.util.Date" ); var dte = objDate.init( JavaCast("long",arguments.ts) * 1000 ); var tz = objTZ.getTimeZone( JavaCast("string", 'UTC') ); var outputFormat = objDF.init( javaCast( "string", "yyyy-MM-dd HH:mm:ss" ) ); outputFormat.setTimeZone(tz); return CreateODBCDateTime( outputFormat.format(dte.getTime()) ); }  Here's the stack trace:DetailEither there are no methods with the specified method name and argument types or the init method is overloaded with argument types that ColdFusion cannot decipher reliably. ColdFusion found 2 methods that match the provided arguments. If this is a Java obje

I just installed CF2016 Developer with the internal web server on Windows 10 server. After installation, I attempt to open the administrator app with this code http://127.0.0.1:8500/CFIDE/administrator/index.cfm and receive this message: This site can’t be reached127.0.0.1 refused to connect.Any ideas?Thanks

Hi everyone,I have a CF project that I need to work on. I'm super new to CF. I have CF Builder 2016. If someone is familiar with CD Builder 2016, can you please guide me the steps on how to debug CD project on CF Builder 2016? Thanks very much!Chris

Will my CF 2016 Enterprise Edition will turn to developer edition after license expiry?In that how to contact CF for licence renewal.

Crypto.com API is not very friendly.Took forever to get account balance authorized. Using same technique, same encoding I cannot get the order created. Always get unauthorized.<cfscript> apiKey = "#cr_key#"; apiSecret = "#cr_s#"; hmacm = #req_path# & 121 & apikey & #unixdatetimeNow.getTime()#; CrHex = hmac(hmacm, apiSecret, "HmacSHA256"); theKeyBytes = charsetDecode(ApiSecret, "UTF-8"); crsign = lcase(hmac(hmacm, apiSecret, "HmacSHA256")); newbody = serializeJSON({ "api_key": "#cr_key#", "id": "121", "method": "#req_path#", "nonce": "#unixdatetimeNow.getTime()#", "params": {}, "sig": "#crsign#" }); </cfscript>This works for account balance just fine. hmacm = #req_path# & 121 & apikey & #unixdatetimeNow.getTime()#; THIS is the HMACM getting envrypted which works is:private/get-account-summary121XXXXoZW8Cw75583kiSMqjp1649261460418This HMACM has no parameters in it which are only {} in the body. <

how to convert an array of one row to a number?

In our application on some pages we use cfprogressbar to show the progress of long running actions to the user. The progress bar is bound to a cfc which returns status and message from out of the session of the user.This coding has been in use many years and always worked well. For some time in version 2018 we sporadically get an error of the meaning that the cfc cannot be bound: java.lang.NullPointerException at coldfusion.tagext.html.ajax.AjaxProxyTag.getCFCInvocationPath(AjaxProxyTag.java:520) at coldfusion.tagext.html.ajax.AjaxProxyTag.getCallParameters(AjaxProxyTag.java:386) at coldfusion.tagext.html.ajax.BindProcessor.parseBind(BindProcessor.java:558) at coldfusion.tagext.html.ajax.BindProcessor.processBind(BindProcessor.java:325) at coldfusion.tagext.html.ajax.ProgressBarTag.generateBindFunction(ProgressBarTag.java:335) at coldfusion.tagext.html.ajax.ProgressBarTag.doEndTag(ProgressBarTag.java:273) at cfplpButtons2ecfm1713680839._factor0(G:\Websites\icmms\farcry\tags\p

My application used a Java function to open a new window. Code worked fine when it was in Coldfusion11 server but when it's Coldfusion 2021, all the client variables are deleted when the new page opened. Here is the Java part :I've compared all the setting in the coldfusion admin page of both server.Is there any hidden setting anywhere or some change between coldfusion version that can keep client variables between pages? Can you suggest any reasons why client variables would just disappear?

Windows 2016 server, IIS 10 and Adobe ColdFusion 2018 using Tomcat. The server has about 8 sites on it and one site is getting intermittent 500 errors. All other sites remain up and responsive. Failed Request Tracing shows "Filter Error - Incorrect Function 0x1" The site will come back up if you recycle the app pool for that site, or restart that site in IIS. I have the app pool set to recycle every 10 minutes. I've seen some vague references to possibly being a URL rewrite setting something that Tomcat doesn't understand, but could never find anything concrete related to that. If I go through our rewrite rules one by one, each one works fine individually. At this point I'm not sure what to even do with it. In March it was doing it frequently (once per day or more) and we recreated the site - new web root, new IIS config etc. same thing. Finally I noticed that the server had a pending restart from updates and once we did that it was fine until about 2 weeks ago. Other th

I need all my Coldfusion logs to store in JSON format.I can then parse those logs as a single line rather than a multi-line.How can I achieve that? 

Hello Everyone Spanish ASCII codes are not inserting properly into the database. I'm using microsoft SQL server 2014.Spanish letters are changed automatically. For example Ñ changed into Á along with special character like ? or '. 

I have found 10 year old examples on the net showing the coordinates included in the returned query, but when I try it on my CF 2021 server, those coordinates are not there, not even referenced in the cfdump. Has this function changed over time?

Bonjour,Ce qui est classique, je dois vérifié si l'IBAN (ou tous autres) est correct.Existe-t-il des solutions en CF ?Sinon comment s'y prendre ?Merci par avance Hello,What is classic, I have to check if the IBAN (or any others) is correct.Are there solutions in CF?Otherwise how to go about it?thanks in advance

I created an Azure Container Instance and Coldfusion 2021 is running on it as a Docker image.The application creates multiple log files. I sent all these logs to Standard Output by the symlink.Now, I want to parse these logs file-wise in Azure Log Analytics Workspace. Can anyone help me? Thanks!

I am having an interesting problem.  Since installing CF2018 Update 14 I am no longer able to use the CFMail tags in my web pages.  It was working before the update without issue.  Since applying the update when the page is called, it acts as if it stops reading the page at the <cfmail> tag.  Nothing else loads after that point.  I just get a blank white page in the browser.Looking at chrome developer tools, the body of the page is blank. Example of my cfmail:<cfmail from="test_noreply@server.com" to="email_address@server.com" subject="test email message"> This is a test email message </cfmail>I get the following error in the server application log:"Error","ajp-nio-127.0.0.1-8018-exec-5","06/28/22","07:46:57","","org/bouncycastle/jce/provider/BouncyCastleProvider The specific sequence of files included or processed is: X:\<path>\page.cfm, line: 2 " I've tried the <cfmail> tag all on one line and get the same error but the