ColdFusion

I am finding solution in ColdFusion21 to get a file from a folder. I want to make changes in that file and want to remove top few header rows as well as blank rows. Then i want to filter records based on keywords "Water" that is in column 6. Then I have to remove last 2 coulmns that is 9 and 10.After all that changes I have to save that modified Excel file at target location.Note: Top header rows exsists in 2 columns only where detailed rows is in 10 columns.

Hi All,We have CF2021 in windows  IIS 10 (windows server 2019).We have 4 sites all in IIS using one application Pool. Can we assigned one site to their own application pool for better performance?I know it was a tomcat limitation before:Multiple application pools for ColdFusion possible... - Adobe Community - 6246482Thanks,Johnny

Hi,I am having issues with connecting to my ColdFusion website after changing  fileExtensions allowUnlisted="false" in IIS 10.0.   If I change allowUnlisted back to true, then the website works perfectly. Neither the IIS logs nor the ColdFusion logs show offer any assistance in debugging this problem.  There is a proxy if that matters.My web.config is shown below. (I have tried without the mimeMap settings and I have tried resetting the IIS connector)Any assistance would be greatly appreciated! Thanks!<?xml version="1.0" encoding="UTF-8"?><configuration><system.webServer><security><requestFiltering allowDoubleEscaping="false" allowHighBitCharacters="false"><fileExtensions allowUnlisted="false"><add fileExtension=".cfm" allowed="true" /><add fileExtension=".cfc" allowed="true" /><add fileExtension=".json" allowed="true" /><add fileExtension=".htm" allowed="true" /><add fileExtension=".css"

Hello, I am working on integrating UPS REST API and getting error message:{"response":{"errors":[{"code":"110609","message":"All package dimensions are required and each must be greater than 0 for package 1."}]}} This is my code:<!--- Get UPS Access Token Information ---> <cfhttp url="https://wwwcie.ups.com/security/v1/oauth/token" method="post" result="ups_authorization"> <cfhttpparam type="header" name="Content-Type" value="application/x-www-form-urlencoded" /> <cfhttpparam type="header" name="x-merchant-id" value="#UPSAccountNumber#" /> <cfhttpparam type="header" name="Authorization" value="Basic #ToBase64(clientID & ':' & secretKey)#" /> <cfhttpparam name="grant_type" value="client_credentials" type="formfield"> </cfhttp> <cfset ups_access_token_json = DeserializeJSON(ToString(ups_authorization.filecontent)) /> <cfset ups_access_token = ups_access_token_json.access_token /> <!--- Get UPS Shipping Rat

What has happened to the user guide? The Adobe page does not seem to include links to the reference for tags / functions etc. https://helpx.adobe.com/coldfusion/user-guide.html

Hello folks, Sorry for this naive question. Hello, I have recently installed ColdFusion 2023 and ran the update 6 which gave me an error during the installation. below is the error I have got Execute Script/Batch file: Extracting CURRENT_RUNTIME_USER from cfsetup.sh Status: ERROR Additional Notes: ERROR - Error while attempting to execute the installation scriptI realized that I have not mentioned SILENT_RUNTIME_USER  parameter in my silent install properties file. How do I fix this issue?  Please advice. Thanks.

I have a newly setup REHL 9.3-0.5.el9.x86_64 server. I have Apache 2.5.47 running on it. I installed CF2023 using the GUI installer and set it up with the Production Profile. I upgraded to Update 7 and then upgraded the Java to 17.0.11 and in the CF Admin I can see that it is running Tomcat version 9.0.85.0. In Apache I setup two virtual hosts and on my windows machine I edited my hosts file so that I can access both of those sites through a web browser on my local computer. I can access the CFAdmin just fine and .cfm test pages work fine. I am having problems getting the cfldap tag to work. I have setup many CF servers over the years from CF2008 until the current version and to get LDAP to work all I ever had to do was install some LDAP security certs into my java key store, restart CF, and then it would work. I have done that for my new server as well but I get an error on my test page “One or more of the required attributes may be missing or incorrect or you do not have permiss

How can I pipe a remote file directly to the response, without having to read the file in the memory or writing it to disk on the server? The remote file can be huge and I'm not going to do anything to the file itself. If possible I'd like to be able to set the basic headers like 'content-type' and 'content-length'. 

I am having an issue where the ColdFusion service inside of the Docker Container is not starting up. When I look at the Logs view in Docker Desktop all that returns is the following.  [] Checking server startup status...  This setup has been working for months and all of the sudden after the 14.5 update on MacOS it stopped working.  Chipset: Apple M3 MaxMacOS 14.5Docker Desktop Version 4.30.0 (149282)Docker Engine: 26.1.1 Docker Container Setup Script # variables cf_administrator_pwd=ColdFusion123 # Run the docker conainer docker run -dt --name mysite -p 80:8500 -v $PWD/www:/app -e acceptEULA=YES -e password=$cf_administrator_pwd -e enableSecureProfile=true --platform linux/amd64 adobecoldfusion/coldfusion2023:latest # Wait 10 seconds sleep 10 # Install All docker exec mysite /opt/coldfusion/cfusion/bin/cfpm.sh install all  When I look at the logs in the container I am seeing that ColdFusion is started /opt/coldfusion/cfusion/logs/c

I need to build a coldfusion 2016 environment before upgrading to coldfusion 2023. However, I can't find the 2016 installation version, can you help me?

I need a tool to support Unit Testing and Code Coverage for ColdFusion project, do you know any such tool? Thank you.

Hi, Every server I configure with the PMT (CF+PMT2021) it can't figure out the connectors, it has dubplicate entries for all connectors, once by ip, once by application name.It keeps switching over from ip to sitename connector constantly, and everytime it does I get an alert saying site unavailable, site available. This happens like 1000 times a day depending on the amount of connectors. I am fine with just ignoring this as everything seems to work fine and the PMT is just buggy I guess.The only problem I have is there is no option to disable these notifications, all alerts are turned off in every section on the nodes as well as the PMT alert settings itself. Anybody have any clue? <rant>It doesn't seem the PMT is used by many, as there are like 10 topics in total about it on this forum (2 of which are mine now, one on another account) and not properly updated by adobe as the 2021 PMT still says "© 1995 - 2020 Adobe. All Rights Reserved." It is also a pita to

So, hello again. On my website inside my root folder I had folders for some guides, however I moved them to another location. What I would need now is when they try to go to https://almarsguides.com/Aion/ , they are moved to https://almarsguides.com/Computer/Games/Aion/ . Because right now they will be redirected to page 404.  One important thing to note is that this should work for all guides. If let's say they go to https://almarsguides.com/Aion/professions , they should be redirected to https://www.almarsguides.com/Computer/Games/Aion/professions/ I will have to do this for other folders too, but this is the main idea. Is it possible to do this in Application.cfc because it seems that my htaccess doesn't work well?

Greetings,We have a ColdFusion 2021 installation on Server 2022 that calls all of its scheduled tasks via http://localhost. Now that we have implemented SmartCard login for the server, and set the server to https only and Client Certificate required, the tasks of course will not run. Any call to the server, even from localhost, will now require an https connection and must provide a valid certificate. I don't beleive the scheduler can provide that, though we could issue a soft cert for it and have it available to the engine if needed. Do you know of any guidance on how to do that?Alternatively we could run the tasks as Windows tasks, but it seems like the cfm files that contain the tasks scripts might need to be altered to run from the cf.bat in either cmd or powershell. It also looks like the cfms may need to be altered to run that way vice running in the browser. Do you know of any guidance for our developers on how to alter the cfm tasks to be run via cf.bat instead of via the brows

We have recently switched from one Antivirus/Firewall app to Windows Defender for Servers.  I tried replicating our settings into Windows Defender Firewall to allow our ColdFusion Webservers to operate.  End result, our sites were unable to be reached. Can someone provide a complete list of Ports/Port Ranges that require access? Windows Server 2019 running ColdFusion 2021.  SQL 2019 backend.  Apache webserver.  Traffic comes in as HTTPS (443) to our primary firewall, then using a VIP is transferred to our Load Balancers.  The Load Balancers do SSL Offloading, so the traffic is forwarded to the ColdFusion server on HTTP (80).  I have Firewall rules for both 443 and 80 to allow access.  I also have rules to allow the SQL access using the specific ports we have designated in our Data Sources (Within CFadmin).Turning off the Defender Firewall allows the websites to work again, so I am apparently missing a rule or two.Thanks,Phillip

Hello - Has anyone ever seen CFDUMP  - form, not display all the fieldnames with data in it? I have a number of formfields, but not A LOT of them and one of the names is missing. Anyway, I have attached a CFDUMP of the form fields...The field in question should be the last one in the list, it should be journal_date.It doesn't exist in the list of fieldnames, but the value does exist. Anybody have an idea of what's happening? Thanks Doug

We have 2 load balanced ColdFusion servers, and want to use PMT Performance Monitoring Toolset. The advice from Adobe : For deploying in production, it is recommended that Performance Monitoring Toolset must be deployed separately from a ColdFusion server. If we install on one of the ColdFusion server how much of an impact would it have? Marginal or a total no-no?

We are using cfhtmltopdf and inside calibri font block, content is not displaying in PDF  <cfhtmltopdf destination="FILEPATH" overwrite="true" orientation="portrait" unit="in" marginbottom="0.25" marginleft="0.25" marginright="0.25" margintop="0.25"> <cfprocessingdirective pageencoding="utf-8"> DISPLAYED IN PDF <div style="font-family:calibri;font-size:13pt;"> THIS IS NOT DISPLAYING IN PDF </div> DISPLAYED IN PDF </cfhtmltopdf>  We have installed calibri font. and coldfusion server: 2018.

I have setup CF on many windows servers over the years but this is my firat attempt at setting up CF on Linux. I have a newly setup REHL 9.3-0.5.el9.x86_64 server. I have Apache 2.5.47 running on it. I installed CF using the GUI installer and set it up with the Production Profile. I upgraded to Update 7 and then upgraded the Java to 17.0.11 and in the CF Admin I can see that it is running Tomcat version 9.0.85.0. In Apache I setup two virtual hosts and on my windows machine I edited my hosts file so that I can access both of those sites through a web browser on my local computer. Next I ran the wsconfig from the command line with this:sudo ./wsconfig -ws Apache -dir /etc/httpd/conf -bin /usr/sbin/httpd -vI can see it created several files in the ColdFusion2023/config/wsconfig folder and in the /ect/httpd/conf folder it added mod_jk.so and it added these lines to the httpd.conf file.Include "/etc/httpd/conf/mod_jk.conf"Include "/home/cimwebadm/opt/ColdFusion2023/config/wsconfig/1/mod_jk

I've been using a slightly modified version of the SocketGateway (examples.socket.SocketGateway) for over 15 years (modified just to comment out the "welcome" message) with great success.  Our legacy ERP system has several processes that communication on TCP/IP sockets and we've been able to streamline multiple integrations by letting it talk to my ColdFusion sockets and using CF code to connect to partner APIs.The new version of the ERP system has changed one of those socket processes to communicate over TLS and my CF socket can no longer understand what it's sending.  Strangely, the process still CONNECTS, but what I would typically receive as a single "message" with an EOF character is now broken up into multiple messages and gets logged as gibberish (the usual sort of binary characters you see from encrypted data).  I'm trying to figure out what changes would be needed to allow this connection to work properly.  I've started down the road of trying to modify the

Want to install PMT - but when checking the install instructions there is reference to Datastore (which requires additional resources) and ElasticSearchh (which Datastore uses).  What is this and is it needed for PMT to work?When I read up on PMT on the web (the various overviews) no mention is made of Datastore. The page I referenced is Performance Monitoring Toolset deployment guide (adobe.com) This impacts the size of VM I need to request or share with other apps. if there is a web page that explains this, that may be sufficeient (cannot seem to find this).

Hi, i know there are literally no free tools for ci/cd scanning of coldfusion besides cflint/sonarqube plugin- Is this still true? - No SAST SCA etc type scanners in the wild?  Also; As per new mandate of security etc; SBOM. I notice grype/syft in a repo on my github repos, do not map dependencies of coldfusion code. With the release of 2024 how are we to approach this? 

I am having a website with URL where subfolders vary from all uppercase to all lowercase. What I would like to happen is to make whole website URL lowercase once loaded. Even if the user changes it to whatever he wants, it will revert to lowercase once page refreshed.  I tried using what ChatGPT said but this only gives me 500 Internal error. He tried many different variations of this and with http and https and yet all fail in the same way. He also tried with haccess file but it didn't work. Actually, it works for first subfolder, but fails for all others in the path. <cfsetting showdebugoutput="Yes"> <cftry> <cfset requestURL = GetHttpRequestData().headers["host"] & GetHttpRequestData().headers["x-original-uri"]> <cfset lowercaseURL = LCase(requestURL)> <cfset segments = ListToArray(lowercaseURL, "/")> <cfset lastSegment = ArrayLast(segments)> <cfif CGI.QUERY_STRING NEQ ""> <cfset lowercas

Hi if i want to start coldfusiln 2016 it braike After it Runs a few minutes. it says connection refused pdfgservlet this is new .. since one year all is ok and I don't install an update since 10 month ..can I disable the service ? pdfgservletKjndly regards thorsten 

How can I create  404 page and apply it all across the website? Is that something I need to add in Application.cfc ?  I have 404.cfc page which contains only gif, however if I would to navigate to that page, all templates are being loaded (header with navigation), body and even footer. Can I somehow disable templates for this page?