ColdFusion

Hi, I am testing a process we have, on CF 2016 enterpise. ( 2016.0.16.320445  ) A scheduled page month_end.cfm calls a number of additional processes via cfhttp. This website ( on an intranet ) I have just recently implemented https. Since the move to https the calls to the other pages do not work. The documentation for CFHTTP has instructions for using https, and I have imported the site certificate with the provided keytool command, however the error still occurs.   CF server http.log shows the call, but does not show an error. Other logs show no info either. The call is pretty straightfoward:<cfhttpurl = "#getPageContext().getRequest().getScheme()#://#cgi.server_name##getDirectoryFromPath(cgi.SCRIPT_NAME)#runthispage.cfm?EOM=#VARIABLES.MONTH_END_DATE#&unique=#TimeFormat(Now(),"hhmmss")#"method = "get"></cfhttp> How do I further debug the connection failure, and where do  I go from here? Thanks, 

Hi everyone,I got a strange issue with coldfusion 2018. It is working on my local machine, but everytime I try to run it on one of my servers, the first time it goes through, but the second time it throws me an error.{"Errordetail": "I/O Exception: Received fatal alert: handshake_failure","Mimetype": "Unable to determine MIME type of file.","Statuscode": "Connection Failure. Status code unavailable.","Filecontent": "Connection Failure","Responseheader": {},"Text": true,"Charset": "","Header": ""} I thought by adding the certificate into the cacerts would solve the issue but to no prevail. I verified the debug but I'm no expert in this matter.What bugs me the most is that, whenever I restart the coldfusion service it works for one call, and then goes back into the error.Can anyone help me with this?Url I'm calling is (it's not the real one, but I have it set on this to test the return): https://api.opensea.io/wyvern/v1/ordersThx

Hi All,We are trying to connect Azure DB by CF ORM. But it keeps showing the error message like either Unable to determine Dialect to use [name=Microsoft Azure SQL Database, majorVersion=12]; user must register resolver or explicitly set 'hibernate.dialect' ORjava.lang.NullPointerExceptionat coldfusion.orm.hibernate.HibernateConfiguration.determineDialect(HibernateConfiguration.java:401)a We tried to setup "ormseetings.dialect" with different values in application.cfc,e.g.MicrosoftSQLServerorg.hibernate.dialect.SQLServer2008Dialectorg.hibernate.dialect.SQLServer2012Dialectorg.hibernate.dialect.SQLServerDialectorg.hibernate.dialect.MicrosoftSQLServer2012DialectSQLServer2012DialectSQLServer2008Dialect But all failed, any idea which value would be correct in "ormseetings.dialect" to make it works? Thanks,CF Dev 

I would like to use ColdFusion to add dynamic breadcrumbs to my site. Does anyone know what is the best way to do this? For example, if I'm at www.mysite.com/about/privacy.cfm. I'd like to display Home > About > Privacy Policy at the top of the page. Thanks.

I have been banging my head against this brick wall for awhile now. I have some beefy scheduled tasks that easily go over our global timeout. Since we upgraded to Coldfusion 2018, it seems like the standard fix of <cfsetting requestTimeout="7200"> doesn't override the global timeout.I have also added timeouts to every query within the template, as well as the cfhttp call itself. Funny thing, when I remove the cfhttp call from the template, it still times out with the same error The request has exceeded the allowable time limit Tag: cfhttp even though the tag is gone.When I run the page directly via the URL, the template runs perfectly and never times out.So, how do I make the schedule task respect the timeouts within the template and ignore the global timeouts?

Hi,I am trying to run a Java Agent with ColdFusion 2021. In coldfusion error.log it prints NoClassDefFoundError and breaks some functionalities. This is usually due to OSGi infrastructure conflict which gets resolved via adding property org.osgi.framework.bootdelegation=agent.package.* in a osgi related config file or via -D option. But with  -D option it's not working and there is no appropriate .properties file to give in this value or even a way to know if these are getting picked up or not. Any solution to this?Exception in thread "DefaultQuartzScheduler_Worker-1" Exception in thread "DefaultQuartzScheduler_Worker-10" java.lang.NoClassDefFoundError: agent/package/InterceptorDelegatorBoott at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java) ..... Caused by: java.lang.ClassNotFoundException: agent.package.InterceptorDelegatorBoot not found by org.quartz-scheduler.quartz [14] at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDeleg

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