ColdFusion

Has anyone had to deal with upgrading to Cf 21 in Azure and seeing intermittent "Connection Failures" when making api calls using cfhtttp? We ended up rolling back to the CF 16 servers. We've looked into TLS settings, certificates problems but nothing. Thanks for any suggestions. 

We'd like to duplicate the Production VM, which runs a licensed copy of ColdFusion 2021, and run the clone as a Test VM.Will deactivating the ColdFusion licence in the Test VM impact the licence in the Production VM?I'm assuming "no", but would appreciate confirmation before going ahead.Thanks.

How do we enable term highlighting in Coldfusion 2021 please? This article https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-r-s/cfsearch.html says "Enable Term Highlighting using Data & Services > ColdFusion Collections > Manage Collection." However I don't see a Manage Collection option on that page in Coldfusion Adminstrator (2021) Is term highlighting still supported? Thanks very much. I've tried making the the changes to solrconfig.xml and schema.xml as detailed here https://helpx.adobe.com/coldfusion/developing-applications/accessing-and-using-data/solr-search-support/term-highlighting.html but context = empty string in my cfsearch result.

Hi All, Facing a weired issue in cfhttpparam, when I hard code a string value it goes without quotes: as seen in fireshark capture below:But when this string is done dunamicly it gets wraped in "". adding Quotes makes it fail in third party REST API. see below line which adds quotes<cfhttpparam type="formField" name="annotation" value="#some variables#">

We recently updated our Coldfusion 2018 servers to hotfix 14 in an attempt to remove all remaining instances of log4j1.2.x - this appeared to work, as the two remaining instances of those files were removed and replaced with an adapter for using log4j1 with log4j2.  However, we just got a report from our IT team that log4j1.2.15 was still installed on our system - it appears as though the file cfusion/lib/cf-logging.jar is simply log4j1.2.15 (renamed and with the classes put in a coldfusion package).  Has anyone run into this?  Is this file something we can remove without breaking Coldfusion?

Hello, Will CF2021 u2 be supported on Windows Server 2022? I am aware support matrix does not currently list it. Thanks, Carl.

has anyone done this?  We just upgraded one of our nodes and CFIDE is giving us an db incompatibility error.Windows 2016 ServerMSSQL Server 2017 cu13CF2016 EnterpriseCF2018 Enterprisethe clustered scheduled tasks was initialized with CF2016we try to go to CF2018's CFIDE Scheduled Tasks and attach this new node to the existing datasource for the cluster that has existing running schema.is it possible CF2018's clustered scheduler is not compatible with CF2016's clustered scheduler?

Hello Has anyone been able to create a datastore on Azure SQL Managed Instance? We've been plugging away trying to get this working, but we keep hitting roadblocks. Thanks!

Hello all,is there a way to do a reverse search using a text field. This means that I enter a term in the text field that the search results should not contain.Many thanks for your help

Somehow I managed to forget my CF21 admin password. I ran the passwordreset.bat. (selected option 1). I looked in neo-security.xml to verify the admin user name. Restarted the services and still can't get in. Restarted the server - still can't get in. I've done the entire procedure multiple times trying a couple of different password combos. Tried changing the admin username in neo-security and restarted everything. I'm out of ideas. What am I missing??? Gary

I'm working on setting up the scheduled tasks in coldfusion 2018. I have already configured it in the cluster mode and its working.Our concern is that we have to create ITaskEventHandlers scripts for each app on the coldfusion document root source folder of the file system.For example document root is /disk1/cfdata/source and the folder called scheduler has to reside here, for example /disk1/cfdata/source/scheduler and apps paths are /disk1/cfdata/source/webapps/app1, /disk1/cfdata/source/webapps/app2I think that ITaskEventHandlers scripts should be in the app folder along side the other source code and not outside in the centralized location. Can this be changed so ITaskEventHandlers scripts are in the source code?

Hi thereI am looking for the right ColdFusion functions to compare with PHP functons.In PHP:PHP Calculations (these are the correct ones)$xValue = base64_encode(hash_hmac("sha512", "test", true)); echo $xValue;Is the result:ZjNlNzQ4NGE3YmIyMjJmNDU4MzgxOTZhMTQzMDIwYjNmOGNkZDJhMDQzYjZjOWMyNWU4NTBkMmM5NDk1MGQ5YTRhMzE5OGRmOWFmOWZhMDMxOGNmOGRhMDg2NGVmMzU2NGE2YWU1MjA3NTQwN2Q0ZmFmNjFjMjJkOGZiZDM3NGU= In CF:<cfset xMacValue = ToBase64(Hmac("test", "HMACSHA512")) /> <cfdump var="#xMacValue#" />is the result:NkJEQ0NEN0VFNkY1QUYyMTU5NjNENDY0NERBMDQwMjQ=.Which CF functions do I need to use to get the result from PHP? Thank you for your supportSteve

Hello good people - I've an 'easy;' one whipping my butt.I have two random dates, I need to display how many years, months, days have passed between the dates. I've been playing around with DateDiff and its all fine to "year" level, but days and months are killing me.  I tried one of Ben Nadel's techniques, but I end up with a "12" on my month counter when it should be "0".  (For the record, for testing purposes I had my two dates precisely a year apart, and got 1 year and 12 months... erm, no!)Yes, I have searched these forums (and others).  Yes, I got lost as none of them are helpful, either over complicared, or too siimple "Just use datediff()".  I cannot beleive somehting this simple (which I can do in Excel* in 12 seconds) has now been taking all weekend on Coldfusion.*Example of Excel code which is working 100%=DATEDIF(E6,B!, "y") & " y " & DATEDIF(E6, B1, "ym") & " m " & DATEDIF(E6,B1, "md") & " d."

Is everyone else seeing the same short, wide, blank box when clicking "Download and Install" for Update 4? Steps to reproduce are:Log in to ColdFusion 2021 AdministratorPackage ManagerAvailable Versions: select "ColdFusion 2021 Update 4"Click "Download and Install" The background dims and a blank box appears alongside the "Core Server" image... and then nothing. This happens on several machines in a variety of browsers (Firefox, Chrome, Internet Explorer, Microsoft Edge) and is unimpacted by disabling extensions. Thanks for any pointers.

This is always a head scratcher. Is there a way to simply install a server update and any packages that may need to be updated as well? I seem to only be able to do the reverse, update installed packages which may then install a server update.

I am hoping someone can point me in the right direction. I have a CF2021 Server which runs a Node.js websocket server and CF pages (via javascript) as a client. Messages from user to user work as expected, so no issue there.This CF Server also has a custom API built using CFML that handles and routes inbound SMS messages. My question is; what would be the best way to send the SMS message (by now its json) to the Node.js websocket to it can send it to the user(s).I tried using the same javascript that the browser client uses, but it appears that the CFML API script is "browser-less", so that doesn't work, or should it?I thought something like Apache Groovy may be the solution, but I am having difficulties with any websocket broadcast example I have found.Any suggestions would be greatly appreciated.thanks in advance

Do we know if ColdFusion, any supported version, is affected by the just released Spring Framework vulnerability,https://tanzu.vmware.com/security/cve-2022-22965? I need to provide updates to my InfoSec team, Phil

I am deploying a Docker image running Apache on top of Coldfusion to Azure App Service. I am unable to connect to the App Service Coldfusion Server from the Performance Monitoring Tool running on another machine.Can I connect the server to port 80/443 rather than 8500 port? Thanks!

Is there any sort of remaining log4j issue with the newest version of ColdFusion 2021? Either vulnerability or is the version of log4j included EOL?

 I’m trying to output data in the form of a grid pattern using coldfusion or MySQL . When I execute the code below, it outputs it in the regular drill down format. I Want to see if there’s a ColdFusion method and or a MySQL method that will allow my data to be out in a grid-like format With each row having a different person and each column having the results for that particular person in the row over a period of time. Please see the attached code and please also see the attached desired output. I am trying to see how I can get the desired results to look like the second image. Is it an array function in ColdFusion that I would need to do that in? Attached code: Regular output desired output 

We are running into an issue of Coldfusion looking for java in the wrong place.For some reason in the 2021 container, coldfusion is looking for java in `/opt/coldfusion2021/jre/bin/java` ,but it actually exists at `/opt/coldfusion/jre/bin/java`.I've tried setting the JAVA_HOME variable to `/opt/coldfusion/jre/bin/java` in the Dockerfile, through a .env file, and through docker-compose's environment key.I've also tried building the containers individually and running them with the -e (extra vars) flag where I set the env var.The question is:Where is the default JAVA_HOME set in the coldfusion configs? Any help will be greatly appreciatd.  Thank You, 

Hi,( ColdFusion Server Developer 2016,0,11,314546  )Consider:<cfcomponent> <cffunction access="remote" name="getDCR" output="false" returntype="string" returnformat="JSON"> <cfset var graphresultset= "" /> <cfquery datasource="datasouce" name="dcr"> SELECT [FINANCIAL_YEAR], DATE_FIELD, COUNT(*) as DCR_Count FROM XXXX WHERE YYYYY GROUP BY P.[FINANCIAL_YEAR], P.DATE_FIELD ORDER BY P.DATE_FIELD </cfquery> <cfreturn graphresultset> </cffunction> </cfcomponent> that returns:"COLUMNS":["FINANCIAL_YEAR","DATE_FIELD","DCR_COUNT"],"DATA":[["FY19/20","July, 01 2019 00:00:00",127],["FY19/20","August, 01 2019 00:00:00",2740],["FY19/20","September, 01 2019 00:00:00",4140],["FY19/20","October, 01 2019 00:00:00",4154],["FY19/20","November, 01 2019 00:00:00",3653],["FY19/20","December, 01 2019 00:00:00",3521],["FY19/20","Jan

I installed ColdFusion update 14 and all of my ColdFusion websites ( except the administrator website ) return a 403. Please help. This is a WIndows Server 2012 ColdFusion 2016 build. Re-installing is not an option. I have removed the update for now until I can find a solution. HTTP Status 403 – ForbiddenType Status ReportDescription The server understood the request but refuses to authorize it.Apache Tomcat/8.5.42

Does anyone know if the zero-day exploit affecting the popular Apache Log4j utility (CVE-2021-44228) that was announced on 12/9/2021 will affect ColdFusion version 10 and 2018?

I am using coldfusion 10 and IIS server 7. I am getting some issue like. website sometime being blank page and I restart the coldfusion service in windows machine then it starts working. please help me to resolve the issue.