Questions

I am attempting to migrate a CF10 application to CF2018 that uses a CFLDAP call to an Active Directory server and is experiencing failures. We have already used keytool to import the AD server certificate, and we have verified connectivity by telnet <ip address>:636 and can create a connection via openssl s_client -connect <ip address>:636. We use CFSSL_BASIC, port 636, and are getting this error on the LDAP call:Detail: One or more of the required attributes may be missing or incorrect or you do not have permissions to execute this operation on the server. Operation: query :<ip address>:636I have noted in the coldfusion-error.log an error that occurs when CF restarts:INFO: The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [C:\ColdFusion2018\cfusion\lib;C:\ColdFusion2018\cfusion\jintegra\bin;C:\ColdFusion2018\cfusion\jintegra\bin\international;C:\ColdFusion2018\cfusion\lib\oosdk\classes\win;C:\\ColdFusion2018\\jre

I am trying to change my websocket connection to WSS and can't determine why it's not working.  I have obtained a keystore with the type JKS, which uses the same certificate as the website.  It is not self-signed.  Port 8543 is accessible when I try to test the connection.  Yet when I visit https://mywebsite.com,  my browser console says the WebSocket connection to wss://mywebsite.com:8543 failed.  I'm not sure where to go next for troubleshooting.

We were having a number of issues with our database connections (turned out to be a database issue) so did a ColdFusion Application Server service restart just in case that helped.The licence then went back to Developer. Re-entered the Standard licence key and all is well.But need to understand why this happened.  Running ColdFusion 2018. Never occurred on our old ColdFusion 10. Concerned if it happens out of hours - eg. a server reboot or someone else restarts the service, as this used to be a standard way of getting ColdFusion working it if hangs. Thanks  Paul 

Have a case open as well but wondering if anybody knows about this. Just purchased CF Standard 2021 (for All Supported OSes — which should include Windows!) but in the Download area, only see Linux/Mac/Solaris as in screenshot.

On a self submitting form (like a Contact Us)...Why is <cfif structKeyExists(form, "submitform")> preferred over <cfif IsDefined('FORM.submitform')>?What is the advantage/benefit of structKeyExists?Thanks

Hi, We've just started a migration from ColdFusion 2016 to ColdFusion 2021. We have been using cfstat.bat to gather statistics that we periodically write to disk and then ship to Kibana. This has been working well for ColdFusion 2016, but when running the same setup on ColdFusion 2021 we ran into issues. The following works fine:PS C:\ColdFusion2021\cfusion\bin> .\cfstat.bat Pg/Sec DB/Sec CP/Sec Reqs Reqs Reqs AvgQ AvgReq AvgDB Bytes Bytes Now Hi Now Hi Now Hi Q'ed Run'g TO'ed Time Time Time In/Sec Out/Sec 0 0 0 0 -1 -1 0 0 0 0 0 1361 0 0 But when we add the -x switch ("Extended output. (Included counters for individual request types)") we get the following back:PS C:\ColdFusion2021\cfusion\bin> .\cfstat.bat -x Pg/Sec DB/Sec CP/Sec Reqs Reqs Reqs Templ Templ Templ Flash Flash Flash CFC CFC CFC WebS WebS WebS AvgQ AvgReq AvgDB Bytes Bytes Now Hi Now Hi Now Hi Q'ed Run'g TO'ed Q'ed R

I am getting error when I am using column index inside the Query of Query SQL. This is happening on Coldfusion 2021 and seems fine w/ Coldfusion 2016. Is this bug w/ Coldfusion 2021? THANKS!<cffunction name="test" access="public"> <cfquery datasource="myDS" name="local.getData" > SELECT email, first_name, last_name FROM users </cfquery> <cfquery dbtype="query" name="local.testQrySet"> select email, first_name, last_name from getData where id=<cfqueryparam value="1919" cfsqltype="cf_sql_numeric" /> order by 2 asc </cfquery> <cfdump var="#local.testQrySet#" /> </cffunction> <cfset test() /> 

I'm attempting to use the cfexchange tag to create an event in Outlook Calendar. However, I was unable to gain access to the outlook server; is this a security issue with the outlook server itself? Can I still use cfexchange if the email account is a shared account, such as project@xxx.com, rather than a personal account?  

Hi, I have been working with pdf type files in Coldfusion and I can't get the characters to appear quite right.For example I get the character attached, it should be a μ.I am using the tag <cfdocument> to save the information and <cfpdf> to create the component.Thank you very much for any help you can give me.

We updated Coldfusion 2018 from Update 11 to 12 on windows servers and began having permissions issues when trying to read from or write to folders on file servers. ColdFusion can do this for folders on the ColdFusion server but if it is a file server (aka not on the same server), it has issues. Prior to the upgrade the we could perform folder and file related access activities without issue. We tested this issue with a script which looped over a list of folder paths and performed:Check to see if the folder exists (directoryExists(...))If not create the directory (<cfdirectory action="create"...>)If does exist then just print that it existsDo a directory listing of the folder and dump results to screen (<cfdirectory action="list" ...>)Copy a file from a local server folder to the destination folder (<cffile action="copy" ...>) We verified that the ColdFusion service account had read and write permissions to all of the folders involved and were even

I read this article https://helpx.adobe.com/coldfusion/kb/enable-ssl-coldfusion-administrator.html about making the CFADMIN use SSL with CF2021.  But I don't understand this line: "Make sure you also import the private key and have the correct key pair." How do you import the private key? Thanks!

Hi,We updated our CF servers over the weekend and since the update we've had errors coming in from an area with a Query of Queries is used. Basically there is an order by in the QoQ and this is the field not being returned. It should be returned and it was until we did the updates and for now I had to manually add the field back into the select statement. It should be returned via a select query.* from original but not working now. The only one missing though is the one used in the order by clause. Anyone had similiar issues? Thanks

Our IT started to block outbound internet traffic from our Coldfusion server by default. I usually use CF amin interface to install CF updates. Can anyone tell me what IP addresses Adobe uses for ColdFusion updates? I would like to allow outbound traffic to those IP addresses. Thanks. William

We have the base version of CF 2018 (build  2018.0.0.310739) and need to apply the upgrades.  There are 12 of them.Looking at the comments in some, they say : The updates below are cumulative and contain all updates from previous ones. If you are skipping updates, you can apply the latest update.Does this mean I can cut it down to 3 updates (ie. updates 4, 8 and 12)?Or should I always apply each upgrade in turn.To make life interesting we have no test server and it is used 24x7 within out organisation, so I need to minimise down time.

Worked on and ensured both Server.xml and workers. properties file resolved.  pointed both to server Ipfor host. Continues to get Internal 500 when logging into site for index.cfm. I have tried different index.cfmunder our content folder under root. For some reason .cfm not rendering. I intially removed /installed Connector. was getting errors now fixed.Triplex check IIS setting ISAPI etc all look good.If i click on recycle site, home page load with any content showing. Just some embedded links.at a loss. Working on this last 2-3 days.This is a fresh CF2021 install on Windows server 2019.CF Admin working fine, mappings/DSN for both Oracle 19c and MySql 8 testing fine. txs in advance Jose

Hello,I have an strange issue on CF2021. The following code works in the first loop and afterwars fails with the message: "I/O Exception: Received fatal alert: handshake_failure. Connection Failure. Status code unavailable." Other targets like google.com e.g. work fine. <cfloop from=1 to=10 index=i><cfset data_url = "https://www.cruiseportal.de"><cfhttp url="#data_url#" method="GET" resolveurl="no" useragent="#cgi.http_user_agent#" timeout="50"></cfhttp><cfdump var="#cfhttp#"></cfloop> Any ideas? CF 2021.0.02.328618Tomcat  9.0.50.0JVM 11.0.1 

We updated our Coldfusion 2018 installations to the recent version 12.After this update code of the form <queryname>("<querycolumn>").toArray(), which worked the way ValueArray(x,x) worked before, is broken.Is there any way to get compatibility here or do we have to change the application?

I am having an issue where some of our mail is not sending to the mail server. All the mail is setting the spool. When I check the mail log I am seeing this error.  Can't find resource for base name coldfusion/tagext/mail/resource.properties Does anyone have any suggestions?

Saw the link athttp://www.irt.org/articles/js154/index.htm which explains how to do it.But, my need is a bit more than what is shown.I have to run a query and based on results of it decide what should be a row title, then display its value. Something like<cfquery name="getDepartments" datasource="#Application.ds#">                    SELECT *                     FROM departments                    WHERE deptID = '#form_data.deptID#'                </cfquery>then<table width="100%" border="1" rules="all" cellpadding="5px" cellspacing="0px" style="width:100%; font-family:Arial, Helvetica, sans-serif; font-size:12px;"&gt

Hi,I have a current development environment where we use a program called GoodSync to copy files from our local computer to a development server where we can then test our code.  We don't run CF locally on our own desktop/laptops.  Usually this works just fine but occasionally we have an issue where we can't copy our files to the server because the file gets locked by ColdFusion.exe.Any ideas why ColdFusion is locking files and not releasing them?  We have to restart the CF service in order to clear the locks.  It seems like this is happening by mistake for some reason.  I've never encountered it in any other environment.-Steve

Before I start working on manually migrating over CF11 fix19 setttings over. I was trying to update newly installed CF services to run under domain account. This accounthas logon as services permissions and is an Administrator on our 2019 Windows server.I keep getting logon failure. I made sure this account has full rights to f:\Coldfusion2021 install folder and its subs. ty Jose

 Started receiving errors on issuing a spreadsheetAddRows in production code using a CF2018 standard server after applying update 12.Production code was working as intended until update was applied.  After Update 12 was uninstalled, the code is once again working as before.

Is it possible to merge 2 query results? I have a function that returns a querey result. < CFSET temp = query1> <CFSET FNCTransfers = temp> Now I want to change the query to return a merged query result < CFSET temp = query1> <CFSET temp2 = query2> Is it possible to merge the two results? Some thing like this (I know that it cannot be done like this) <CFSET FNCTransfers = temp1 & temp2> Maby it should be a union and query of query?

Hi, I need to consume the bitstamp websocket ( wss://ws.bitstamp.net. ) using ColdFusion and process the stream in the backend. I have read the cfwebsocket documentation, however this focuses on creating a websocket, i just want to consume an external websocket and process. Much the same as using cfhttp to make an API call. Any example code would be very much appreciated.    Link to bitstamp documentation  https://www.bitstamp.net/websocket/v2/

After installing the update 12 via CFAdminstrator, CF will not start. 😞 The log files shows...Installation: Successful with errors.3397 Successes0 Warnings1 NonFatalErrors0 FatalErrors The only error in the log file is...Custom Action: com.adobe.ia.action.ServiceStopCheckStatus: ERRORAdditional Notes: ERROR - class com.adobe.ia.action.ServiceStopCheck.install() runtime exception: When starting the service, Windows says... "Windows could not start ... blah blah blah ... contact the service vendor and refer to service-specific error code 2." Windows event log says: The ColdFusion 2018 Application Server service could not be started. Check the server "cfusion" log files for more information. The cf log files haven't been changed since the update. This is all I have to go on.