ColdFusion

 Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]An SSL socket connection could not be established because JRE 1.4 or above is required.Windows VM running SQL from Microsoft Azure. Having used CF for 20 years, moved to a new venue and established a dev server running CF2021.  We are about to spool up prod servers and buy the licence but there was this nagging issue.  On restart of windows servers, we would battle for varying periods to get the system up again. Tried restarting services, restarting computer, putting a delayed start on the CF services etc.  Eventually found a reproducible method to allow the system to come up each time.By executing the startup sequence as per the image, we can now get our system to start without issue.  Now to write a script to automate this by setting services to manually then starting in the correct sequence.VM is on aged hardware (10 years old) but abundant resources. There is going to be a lot

After CF11 is installed I see that Node.js has been installed too, Is that the expected behavior? (Using ColdFusion_11_WWEJ_win64.exe installer and Windows 8.1 Pro)

Does anyone know of a free or 'cheap' barcode generator that will work with CF?

To whom it may concern: I am trying to activate Adobe ColdFusion 2021 on a Windows Server, running in an environment where the server is restricted from web browser access. For this reason, I was forced to attempt to utilize the offline activation method. Upon doing so, I received the following message: "You cannot activate a Virtual Core license offline. To activate ColdFusion, connect to the internet from your server and retry activation."  Is there a workaround for this process?  I have 3 additional servers in the coming week that I need to upgrade and this will be a major blocker for my customer.

Due to many politics and things out of my control here, we will be continuing running a public production CF 11 host with no end date in sight. (which is part of those politics - they actually appear to want it to fail) Since it is unsupported and will never be updated, I’m just wondering if there are mitigation steps I can take to ensure even known issues are not available to hackers? Any extraneous services, packages, etc. I can make sure are off/removed, etc.? Appreciate everyone’s feedback.

Hello, I can't remember where in IIS you set up Coldfusion to handle all error codes. When I Googled it people say to use advance in application pool. Only issue is only option sI have in application pool are add and refesh. I have Enable HTTP status codes uncheck in CF admin. Any help would be great. Thanks

In Update 5 of the 2018 release of ColdFusion, the application flag useJavaAsRegexEngine was introduced. If you enable this flag at the application level, you can override the default Regex engine and you can use the Java Regex engine. For example,       component { this.useJavaAsRegexEngine=true; }       For more information, see Application.cfc variables. You can also enable the option at the serve. Enable the option Use Java As Regex Engine, located in Server Settings > Settings of the ColdFusion Administrator.       For more information, see Using the ColdFusion Administrator. For example, using the default Perl-regex engine, you can write the following snippet:       <cfscript> writeOutput(refind("[[:digit:]]","abc 456 ABC 789? Paraguay for $99 airfare!")) // Returns 5 </cfscript>       After you enable the flag useJavaAsRegexEngine, you can rewrite the snippet above as follows:  

Hello, I just upgraded a server to use Coldfusion Builder 2018 to edit CFR files. Issue I'm seeing is it can't figure out the coding and opens them I think as raw data (see pic). What do I need to do in order to see them correctly. The old version of Coldfusion Builder was for CF10. So it's pretty old.Thanks 

Hi, I have a server running CF2018 and we have just purchased the CF2021 (both enterprise versions).  In previous versions of CF I could install two different version on the same server.  I think this is still possible but has anyone got any advice/guidance on the best way to do it? The CF2018 has production initativies running on it.  My plan was to install CF2021, configure, secure, migrate and then eventually unintall CF2018 once happy all is running well. Thanks Peter

I have an instance of CF 2018 Enterprise with Update 15, Java 11.0.13, running on a Windows 2019 EC2 instance in AWS.  I noticed that, in the Debugging and Logging Log Files screen, I am unable to select individual logs to view and, compared to another installation, the Actions column for each log is missing Actions icons (see attached).  I compared Debug Output Settings between the two installations, and they appear to match.  Looking for an answer to the difference in function.  Thnaks.

Good Morning All Is there a workaround to view logs in the Administrator/Console after installing 2018 Update 15? Update 15 removes access to View/Download/Delete logs. That doesn't make sense! Without the online interface, we have to log into the server to view the logs.

Simple question. Where can one locate the zip file for the silent install of ColdFusion 2021? I see the EXE on the Downloads page, but am unable to find the zip package. 

Microsoft is deprecating Basic Authentication:https://docs.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online We have an Application built in Coldfusion which uses CFMAIL and CFEXCHANGECONNECTION to connect to Exchange online to send email and retrieve mail from mailboxes. I wanted to know how to make this work with Microsoft modern authentication which uses OAuth 2.0 token-based authorization. Any help regarding this will be much appreciated.

I have CF2018 installed with IIS v10.  I want to make use of the Web Sockets feature but currently CFADMIN only allows options to enable this on port 8581 or port 8553.  How would I configure ColdFusion and IIS to use Web Sockets over HTTPS on port 443?

I have Docker Desktop installed in my Macbook pro 13 M2 and the Apache2 of the adobecoldfusion/coldfusion:latest-2018 container keeps failing on starting; I already check the config using apachectl configtest, and it's returning OK. The error below is what I found under /var/log/apache2/error.log [Wed Aug 10 15:17:30.643137 2022] [mpm_event:notice] [pid 465:tid 139744629492672] AH00489: Apache/2.4.52 (Ubuntu) mod_jk/1.2.46 configured -- resuming normal operations [Wed Aug 10 15:17:30.643188 2022] [core:notice] [pid 465:tid 139744629492672] AH00094: Command line: '/usr/sbin/apache2' [Mon Oct 31 22:14:51.535467 2022] [jk:crit] [pid 63:tid 274907793600] (95)Operation not supported: mod_jk: could not create jk_log_lock Docker Desktop: v4.13.1Docker: version 20.10.20, build 9fdeb9cColdFusion: 2018 This happens only on my Macbook 13 M2. I tried running it on a windows laptop, and it's working well.

Hi,I am new in ColdFusion and trying to setup CF 2021 on all DEV, TEST, and Prodction servers. DEV and TEST servers were configured properly  but I am having problem configuring Production server. I am at the step where I need to create a Virtual directory of Jakarta but I dont see wsconfig folder in config dolder. I am sure I am missing something. Thanks for you help! SK

So I tried updating CF2021 to update 5 using the command line, you know that tool that is reliable, dependable, and takes 5 minutes but now it doesnt work.  We got these "packages" that "dont install with core." What is the steps to download things onto a local desktop, scan em, copy to servers and install in command line because you all broke what was fast and reliable.  I have no internet allowed on servers policies so Adobe cannot be calling home to Adobe... 

Hi! I'm learning how to hash a user password during user registration. It looks like I can successfully generate the hash password & inserted into my DB (screen shot below). My biggest problem is validating user login & checking if both values match. Been trying for days without success and wondering if I can get some help from this forum. Below is the function I created to hash a password when users register to my site:<CFFUNCTION name="generateHash" access="public">   <cfargument name="UserPassword" required="TRUE" type="String">  <cfset Salt = GenerateSecretKey( 'AES' , '256' )>  <cfset Iterations = randRange( 50000 , 100000 , 'SHA1PRNG' )>  <cfset Hash= generatePBKDFKey('PBKDF2WithHmacSHA1', arguments.UserPassword, Salt,       Iterations,  128)>  <cfset HashedPassword> = Iterations & ':' & Salt & ':' & Hash>  <CFRETURN HashedPassword></CFFUNCTION&

My production environment is being moved from Windows 2016 to Centos 7.9. On my Windows deployment, I can run a large query without it timing out. Windows/Centos have the same Memory and CPUs. However, on the CentOS server, the same code (query) times out. I've extended the TimeOut by using sessionTimeout variable, but it still errors out. The ColdFusion Settings are identical for both servers:Timeout = 2400Request Size Limits = 1000Max size of post data = 100 Database is accessible directly by both servers. Even if I increase Timeout, Request Size Limits and Max Size of post data settings, on the Linux deployment it times out. The same settings on Windows don't time out. Any ideas? I've had to paginate pages with a lot of data, but some pages I can't paginate. It needs to display all the data pulled from the DB.

ColdFusion 2021 installed with the latest Update 5 has Jetty 9.4.31 installed inside of itself.  I was working through another issue and was looking at the Jetty release notes when I started seeing multiple comments on resolved CVEs in the versions newer than the one in CF 2021.  Most are Low and Moderate but two of them are classified as High.   CVE-2020-27223CVE-2021-28163CVE-2021-28164CVE-2021-28165CVE-2021-28169CVE-2021-34428CVE-2021-34429CVE-2022-2047CVE-2022-2048

All,I can't seem to find a link to download CF 2018 Standard and CF Builder 2018.Could someone, please share itThanks,Eugene

Here is my issue. I have a column of data I am attempting to write using cfspreadsheet. The data in the column is a client's identification code for a shipment.  The format they use is two numeric one alpha five numeric, example 01E23456. Lots of their shipments use E for the alpha character. When I write this to the new excel spreadsheet it ends up doing something to the data. When I open the Excel Spreadsheet I get an error, "File error: data may have been lost." Looking at the data in the column any value using E as the alpha character become "#NUM!" in the spreadsheet.Here is the code I'm using.<cfset SpreadsheetObj = SpreadsheetNew()> <cfset spreadsheetAddRows(SpreadsheetObj,resultData)><cfspreadsheet action="write" filename="#theFile#" name="SpreadsheetObj" sheet=1 sheetname="Invoice" overwrite=true></cfspreadsheet>I have tried the following to correct this issue without success.Settings the column format using the following code.<cfscript>forma

I have scheduled tasks in CF 2016 . They have been running successfully for years however, now it runs but actually it does not. The scheduler log says it is triggering but actually does not. When the task's URL accessed directly from browser the CF page actually get executed. When I set the  "set to save output to file" the log  says "Connection Failure" I have restarted the CF instance with no successm Any advise would be of great help on what could be the issue with scheduled task.

Hello, Just wondering if anyone is using logz.io to monitor their CF logs and if so how easy is it to setup? Thanks

Hello,I have a long standing issue with SSL via tasks that has plagued me throughout CF10, 11, and now 2018.When we initially stand up the server, we generate the certs and add them to the keystore; everything works great.  Fast foward a year, the cert expires and you update it; all tasks break with "Connection Failure".I have tried:- adding the new cert and restarting (continues to fail)- deleting the inappropriate certs and then adding the new cert (continues to fail)- searching the box for any cacerts store and adding the right cert to those (continues to fail)- giving up on the newly gernerated crt file, I remotely connect and generate the cert from the remote site and then add it to the castores (its seen as a new cert, but connections continue to fail) The fact that I can set this up during the initial install tells me my process is appropriate.  the fact that CF can never again see the cert after an update makes me think theres a cache or somthing somewhere that n