I was preparing a CF server for production. While in testing everything worked seeming fine. Put it in live and suddenly, it got extremely unstable. Server log shows: “java.io.IOException: An existing connection was forcibly closed by the remote host”. Thoughts on where to start? I have taken the server offline and put our 2018 srever back.

Last month at Sac Interactive we had @Mark Takata (Adobe) give a great preso about the various new features in Adobe ColdFusion 2023. Here's a recording of said preso if you'd like to check it out. Please click the "like" and "subscribe" buttons, it really helps out the channel. Enjoy!

Intro to MASA CMS is now live: MASA is an open source enterprise CMS written in ColdFusion. It started as a fork of Mura after they went closed source.

@foundeo has a page showing how to do a reverse IP address lookup in cf, like so (converted from tag syntax):

<cfscript>
inet_address = CreateObject("java", "java.net.InetAddress");
host_name = inet_address.getByName("66.249.66.99").getHostName();
writeOutput(host_name);
</cfscript>

Finding the host name for that specific IP works fine for me, but none of the ones I actually care about do, They all throw "No such host is known (#ipAdr#)". When I do nslookup of the IPs I care about in a (non-admin) cmd prompt, on the same cf server or my work laptop on the VPN, that works fine. What's the difference? How is that lookup available in a cmd prompt but not available to cf (really java)? How can I make it available to cf?

Hi Guys, Can anyone help me in this https://cfml.slack.com/archives/C06T99N9G/p1694697753895289

Does anyone have any ideas about ad hoc end-user-driven reporting? We have a ton of different databases and other piles of data, that various groups of users want to set up various reports against. These are business analysts, department heads or their people, and other non-programmers, so custom CF code is a non-starter. Power BI is too expensive for widespread use (we're a non-profit), but that's the kid of thing I'm thinking of. It's what some of our data people use. Thoughts?

In cf2021 why would this variable be undefined?

image.png

Is it correct that a problem which is solved here - instead of, say... a web board or stack-overflow - will be a solution lost to posterity after just 90 days per Slack policy?

Maybe a shot in the dark, but does anyone still use <cfreport> to build pdfs ? We just migrated a client from CF2018 to CF2021 and it seems that cfreports calls that include cfreportparam are all failing. Commenting out the cfreportparam allows that cfreport to build correctly.

<cfreport template="#variables.RPTFileName#" format="PDF" query="#qDataRpt#">

<cfreportparam name="filterOutput" value="#variables.filterString#">

</cfreport>

where the exception references java.lang.StringIndexOutOfBoundsException: begin 25, end -1, length 36

Is anyone here familiar with MURA CMS?

All of the sudden, we cannot login to MURA CMS Admin with any user (we have several setup as admins) including the admin user. If I punch in a username/password that is WRONG, I get the login failed message "No account was found with that Username and Password." If I punch in a username/password that is RIGHT, it just takes me back to the same login page, no re-direct, with no message at all. I know the passwords are 100% correct. Any suggestions?

We're running Coldfusion 10 on the server.

Try using an "incognito" window. Or deleting all cookies before trying again.

Is this shared hosting or private server? Have you tried restarting the service?

I've tried "incognito" mode, clearing cache, deleting cookies, rebooting server..

Recently out of nowhere I started having issues with application initialization hanging indefinitely. The only way I could fix it was moving a bunch of our settings such as

this.ormenabled = true

and

this.nullsupport = true

etc, etc outside of the root of the

Application.cfc

component. I chose

onApplicationStart()

because that seemed like an appropriate place to initialize application settings. However most things I put there (maybe even everything) doesn't have an effect. I get

null doesn't exist

errors and

ApplicationException: ORM is not enabled

among other issues Is there a better place to put these settings? In the mean time I will probably try checking these settings one by one to see what is killing my app init. It appears that

this.ormenabled = true

stops my application from initializing.

cfdocs says cfrethrow is supported since cf4.5 but I am getting an error

variable cfrethrow is undefined

what gives?

try {
    asd = 1 /0;
} catch(any e){
    cfrethrow()
}

Oh. its

rethrow

no

cfrethrow()

We are working on a data quality system, writing dozens of queries that only return results if there is a problem. The ideal situation would be keeping them all in a single stored proc, so the DBAs and other PMs can add queries at any time. Then it could be run daily, and an email generated with any problems. Processing the results with cfstoredproc would be a hassle, though, since resultsets have to be defined in advance. A separate mapping table could work, but seems less elegant than it could be. Any ideas?

So, I usually like to use lucee tag island for sql over queryexecute. Looks like the new team I'm in likes to use queryexecute. How can I create dynamic SQL? I mean, switch between column names, comditions, order by, etc and use cfqueryparam. Does anyone know a valueble example in a blog? Can't find anything.

Looks like I need to create an sql string and the params dynamically?

Request timeout errors in cfhttp call from cfthread from cfschedule.

Does the CF Scheduler defer to request timeout settings in a script fired off by the scheduler or does it timeout based on the server setting? I have a long-running script to index a collection that uses threads to perform multiple cfhttp calls to itself. I have tried setting the timeout in the script page and in the cfhttp attribute, and nothing I do makes a difference. Some of the cfhttp calls are timing out, and the page thread itself is timing out. If I uncheck the request timeout setting in the CFADMIN, the process runs to completion (in about 285 seconds). I can tell when it works, because I can use the SOLR admin interface to view the SOLR collection, and it shows as optimized (part of my script) when the process runs to completion, but shows no updates if it times out. Any insights appreciated!

This is the first hit on the script (from the scheduler). The threads are fired off separately. Some will timeout, others will not. My CFADMIN settings are set to timeout at 30 seconds. Sep 25, 2023 155117 PM Information [DefaultQuartzScheduler_Worker-7] - Starting HTTP request Sep 25, 2023 155147 PM Error [DefaultQuartzScheduler_Worker-7] - The request has exceeded the allowable time limit Tag: cfhttp

I've also tried setting the request timeout to 500 on the task in the CFADMIN.

Adobe CF2021.

All threads are stopping at 30 seconds.

Currently we have a Dockerfile with coldfusion-2016. We are using ubuntu 22 as base image and passing ColdFusion_2016_WWEJ_linux64.bin, cf2016-prod-installer.properties, cf2016-update-installer.properties from host machine to docker. We are planning to upgrade to ColdFusion 2021 using the same docker method. From where can i get the respective files(ColdFusion_2021_WWEJ_linux64.bin, cf2021-prod-installer.properties, cf2021-update-installer.properties) for versions 2021.