Hi together, I tried to add the CF Builder Extension into VSCode: But look:

I updated one of my CF instances and the new setup will be using CF WebSockets behind an NGINX reverse proxy, with CF utilizing the Apache connector. Do I need to install the Apache websocket connector for CF and also configure NGINX to handle the WebSockets? 🤔 Just trying to get my brain wrapped around this a bit before I dive in. I previously was not utilizing the proxy or NGINX…

The Adobe CF Alpha Demos video has been published. Link is in the homepage text of the alpha site. Please do not share this link with folks outside the alpha. ❤️

Adobe Fortuna Alpha testers, the demo code for interacting with GCP has been uploaded. We are in need of testing in that area, as it is brand new and we want to make sure it works the way you all want it to work. Log in to the Alpha site, go to "downloads" and search for "Demo Code for GCP". There is a Zip containing all of the files as well as some of the presentations.

I am trying to utilize the parallel feature in a queryeach. I am new to the whole parallel capability. What I am trying to do is loop through a query that invokes a CFC function in which makes an API call to AWS and returns a structure. This usually takes a couple of seconds. Then I want to take a value from the structure and update SQL server DB. When I don't use the parallel option all of the values returned correctly. When I do use the parallel option all of the values are exactly the same.

Why, I wonder, did the CF Team implement

arrayReduceRight

and

stringReduceRight

, but not

structReduceRight

, and

queryReduceRight

? Any thoughts, @Mark Takata (Adobe)?

i have a CF2021 instance with some custom folders/files within the cfadministrator, where we basically had special functionality only accessible to those logged in to cfadmin. these have been there through multiple CF versions and multiple upgrades. yesterday I upgraded that instance from update 4 to update 5 and every custom file/folder was removed. i didn't see any documentation in the release notes about this behavior. is this something anyone else has run into?

OK folks, so this is the time of year when we wind things down at Adobe for about a week. Officially, winter shutdown spans from December 23rd to January 2nd, but the reality is that most folks are off starting on the 19th. But not me. I will be here All next week because, damn it, I love you all and I will not let ridiculous things like family, holidays or rest get in the way of that. But seriously, I'm around next week probably through about Wednesday and then I'm a ghost till January 3rd. And I swear to Zeus if someone finds another Java CVE that week I will personally find the person and read every poem I wrote during high school to them using a megaphone until the FBI drags me away. 😂

I have an old ACF 9 server running as an API to our ERP system. It’s an old unsupported system that needs 32-bit COM support and ver 9 was the last one I could get to work. The system is isolated and only accessed via our internal network. Error emails stopped working a long time ago. Anyways, Starting this morning cfhttp calls to it are not passing cfhttpparams to the ACF 9 server. cfhttp( charset="utf-8", url=http://#util.getSystemSetting(EVEREST")#/item.cfc?wsdl&method=deactivate", result="item", method="POST" ) { cfhttpparam( name="itemCode", type="formfield", value=row.ITEMNO ); } This same line of code was working perfectly last week, now it is not. This is the error we are getting

The ITEMCODE parameter to the deactivate function is required but was not passed in.
 Root Cause: coldfusion.runtime.MissingArgumentException: The ITEMCODE parameter to the deactivate function is required but was not passed in.

Can you confirm that the cfsqltype "decimal" is not accurate enough to match the mssql type "money"? https://cfdocs.org/cfsqltype-cheatsheet lists to use decimal for money, and https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfqueryparam.html does not list a cfsqltype for money. 😞 With a mssql column type of MONEY and cfsqltype="cf_sql_decimal" this

66.50

is saved as

67.00

- notice the rounding up. Ofcourse, cfsqltype="cf_sql_money" works as expected.

Alright folks, I am checking out*** till around the 3rd of January. I assume most folks are also off. Wishing everyone the best and most amazing holidays, a safe and fun New Year and all the best going into 2023. . . .

*** OK, I will probably still be around, but only because there's a few items that might ship between now and January & I want to make sure you all get access to them asap. However, generally speaking I will not be trolling here much. If you have an emergency issue please email <mailto:cfsup@adobe.com|cfsup@adobe.com> and cc myself at <mailto:takata@adobe.com|takata@adobe.com>. I get alerts for all emails. The support crew is working through the shutdown, so please be nice to them.

acf Hi everyone, we've released fixes for both ColdFusion (2021 release) and ColdFusion (2018 release) for authenticating IMAP, POP, SMTP, and Exchange connections using OAuth. We've uploaded the requisite zip and jar files, and the instructions are documented on the page below. Please update accordingly. @Mark Takata (Adobe) will have more details on it. https://helpx.adobe.com/coldfusion/kb/authenticate-imap-pop-smtp-connection-oauth.html

I am following the https://helpx.adobe.com/coldfusion/kb/authenticate-imap-pop-smtp-connection-oauth.html page and there is a section for <cfhttp result="httpresult" url=https://login.microsoftonline.com/1aea0321-half of the code/oauth2/v2.0/token method="post"> <cfhttpparam name="grant_type" type="formfield" value="authorization_code"> <cfhttpparam name="scope" type="formfield" value=https://outlook.office365.com/EWS.AccessAsUser.All> <cfhttpparam name="code" type="formfield" value="#url.code#"> <cfhttpparam name="client_id" type="formfield" value="4e17271f-bd66-half of client id"> <cfhttpparam name="redirect_uri" type="formfield" value=https://cf-dev2.co.weld.co.us/milllevy/oauthtest.cfm> </cfhttp> It seems to need <cfhttpparam name="client_secret" type="formfield" value="tDh8Q~2X4ae_half my client secret"> it returns a token if I add that... [2:27 PM] But I still can't get into Exchange

Server lockdown wizard: We are using a Windows 2019 CIS Benchmark Level 2 in a secured environment to run CF 2018. Trying to run the wizard, which worked in CIS Level 1, but wondering if anyone found it did not work in CIS Level 2, and why? I can access the CFAdmin, but the Lockdown Wizard says coldfusion is not running.

Well shoot. Just when I'm back, it looks like a storm is coming to kill us all in Sacramento. Been lovely cutting it up with you chaps. Guess I'm heading out to sea lol.

Any chance Adobe have done anything with tree-sitter for CF , this looks really promising and it would be nice to get ColdFusion support for it.. https://lapce.dev/

I use treesitter in neovim and oh how I would love if cfml had a real deal lsp.

Sigh. I've talked about this before, with no resolution.

Sigh. I've talked about this before, with no resolution. We're running a fairly large 24x7 app on CF2018. Every so often, seemingly nonsense crashes start happening on a page that hasn't changed in a while, errors like

Element EXECUTIONMODE is undefined in THISTAG

and

Could not find the included template

on pages that have run many times for weeks without problems and haven't been modified since. Clearing the template cache from CF Admin fixes it, instantly. Happened again this evening, same fix. Excuse my frustration, but WTF?!? This 100% does not help CF's reputation, Adobe's, mine, or our team's, not to mention that it's a service app, and it's failing our users. One poor guy banged on the same page 31 times tonight before giving up; I saw the errors much later. Trusted cache and Save class files are both unchecked, and have been for a long time, and I cleared out the cache directory manually a while ago too. We're not dynamically writing pages to disk, or using the in-memory file system. It's mostly old- or semi-old-school code, cfms that call CFCs for data, business logic, and sometimes rendering, some common includes, the usual, straight-up ninja-free stuff. Clearing the template cache doesn't change the code but fixes the problem (until next time), which on the face of it seems to say he problem isn't our code, but some kind of foobar in the CFML engine itself. What now? @Mark Takata (Adobe) @saghosh, can we get some help on this from Adobe?

Docker question, for those who use it. If I'm running cf in a docker container, and want to set up a server in the VS Code ACF Builder extension, what would the "server home" be? Inside the container it's

/usr/local/lib/serverHome

, but where that's inside the container I'm not sure how to reference it from the host. I tried the host directory I have as the web root that is mapped as a volume in my docker file, but the VS Code extension just says "invalid server home".

I've still never been able to get the shiny new debugger working and am trying to give it one more go

my experience - project folder with CFM files on host machine that is mapped to web server root of Lucee docker container. That's enough for development. Probably Builder extension wants to control Adobe CF server, that requires access to ACF folder, all the .exe and .bat files there. There's no way to expose Docker folder to host machine without copying files to host machine, though... So I'd say it's no go.

from what my Google Fu told me, that sounds 'bout right. which is like... so the debugger is not compatible with and does not support running CF in docker. @Mark Takata (Adobe) can you confirm or deny?

sorry - trying to add the server so that I can run the debugger. adding the server, per the docs, appears to be prerequisite to debugging. if I'm off on that, lemme know

Add support for Docker to the new VS Code extension, feature request: https://tracker.adobe.com/#/view/CF-4216439 Please upvote if this is important to you! 🐋

just to be clear, I mean upvote over on tracker.adobe.com 😄 (though the ➕ here for visibility is definitely appreciated too)

With update 15 to CF 2018 and the removal of the tools to search and view the log files in the ColdFusion administrator, how does one go about reviewing the log files and managing them now?

I just found this post from Ben Nadel from 2007... https://www.bennadel.com/blog/943-ask-ben-testing-for-coldfusion-session-management.htm Is there a documented way to check if session management is enabled?

Hey folks, there was a post earlier this week concerning our new OAuth capabilities and Hostek hosting. A customer asked a Hostek representative whether they'd be installing the patch and enabling OAuth for MS mail services. They were told no, and that no plans existed. THIS IS INCORRECT. Speaking with one of the leadership folks at Hostek, I was told the following:

"Hostek is planning to enable the patch in the coming weeks"

Their support team has now been made aware of this and will be conveying the proper information. So, again, if you are hosting on Hostek, they WILL be enabling the patch to allow OAuth authentication on your hosted accounts there for CF2018 and CF2021 soon.

I gave my CF Summit 2022 presentation online last week if anyone is interested. Adobe is trying to have all the presenters at last year's CF Summit give their presentations to people, so check out the Adobe ColdFusion channel for more content. https://www.youtube.com/@adobecoldfusion