ColdFusion

Is there a way I can OPEN an MS Word document with CF? I don't want to CREATE one, but only open one that exists already (then let its Autoexec function do a whole lot of stuff with the document). Thanks. -Dale

I'm having problems with the cfsetup.bat tool included with the zip installer of CF 2021. On a clean install, updated to Update 1 and installed the following packages: caching, debugger, mail, scheduler, sqlserver, zip, I encounter some problems exporting and reimporting settings using cfsetup.bat. If I export METRIC using the command:cfsetup.bat export METRIC c:\METRIC.json c:\ColdFusion\cfusion And then immediately try to import it again with:cfsetup.bat import METRIC c:\METRIC.json c:\ColdFusion\cfusion It fails with the following error(s):ERR: Invalid setting key (cfstatHost) for category: (METRIC).ERR: Import of cfstatHost in METRIC is unsuccessful.ERR: Import of METRIC is unsuccessful.ExitStatus: FAIL Why would this be the case? The default for this setting was unchanged from "127.0.0.1" and I can clearly see the setting in the UI so I know this must be a setting somewhere... Additionally I have the same problems with the RUNTIME settings. Exporting those

Hi,When checking the box next to "Enable TLS connection to mail server" in CFadmin, no email will go out. It all ends up in the Undelivr folder. However, if I also include useTLS = "yes" in the CFMAIL tag, it works perfectly.  I have CF Enterprise 2018.  Anyone have any ideas why this is happening? I'd rather not be forced to find the hundreds of places I've used the CFMAIL tag and add useTLS. Oddly, from my Dev version of CF 2018, I don't have to include useTLS... and it's using the same email server. Thank you!- Shawn  

I wrote my code in CF 2018 on my local dev environment. I had no issues with it in 2018. When I load the same code into CF 2021 Standard I'm getting an error when I try to move a file from one directory to another after reading it.  Basic set up is I read the excel file and then move it to a different directory. The file gets moved but errors out on deletion. When I try to manually do anything to the file in Windows, I get a message that the file is being used by coldfusion.exe and cannot be deleted or modified.  The only way I've been able to release this lock on the file is to restart the ColdFusion service. I tried waiting to see  if it gets release but it didn't after 24 hours.  Any ideas on how to get the file  moved to a new directory and deleted from the original after I'm done reading it?

HelloI speak for my client, he is on Windows Server 2019 is on a license of Coldfusion 10.It is since a week he has this kind of message: Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. Resources: • Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option. You have how to solve this problem.Kind regardsMichel 

Hi,Suddenly, the Data Source that was working quit working for me in CF2016. The error is:I was following this post to set up DataSource.  Below is my set up.  It worked since  Nov 2020.  But, today, it quits working!  The connection string is EncryptionMethod=SSL;Encrypt=yes;TrustServerCertificate=no;HostNameInCertificate=*.sql.azuresynapse-dogfood.net; I wonder if the "HostNameInCertificate" changed. I believed I got the HostNameInCertificate from an error message in CF2016 when I set it up back in Nov 2016. Any idea on how to solve this?   Thanks!   DChan

Could anybody provide a example YAML script that demonstrates how to take updated code and deliver it to a remote test server?  I'm having trouble wrapping my head around what to deliver after a merge request.  I'm completely new to GitLab and the whole CICD pipeline process, and the examples I'm seeing are for mostly builds of other languages. My process is as follows  pull from develop  edit code  unit test with dev server  commit changes  push changes  UAT  merge request Thanks for any clarification you can offer on what commands would be used to automate this.  

Now that I have PMT monitoring remote instances, I can see a few more questions that need answers. What we have is half a dozen separate instances of CF Ent 2021 running on an Amazon EC2 server,I am running PMT and datastore on my office server. Each CF instance is one separate web site in IIS to allow for application isolation. Here are questions I need help with: 1. In PMT on the Connectors page, I see no info for any of the instances being monitored. I see that connectors are filtered by Sites so ....2. Under Topology / Servers I see all my instances. But under Topology / Sites, I am not seeing any at all. It simply says no sites available. Which might explain why I also don't see any connectors? I assume if I can't see any connectors then PMT also can't autotune them.3. When I set an instance to enable datasource monitoring, it seems to pick up each of the unique DSN names in each instance, but does not show any data at all? No queries, nothing. Even if I change the

My question is whether there's a simpler way to do the following than what I've discovered on my own. My user will run a query and make selections of items (MID) from a table. These MIDs will be stored in another table along with the user's UserID. This will allow the user to tailor another query to be populated only with these MIDs. The user might make one set of selections and then replace it later with a different set of selections.  Right now, I'm not worrying about how to code the CFML to produce the query I send to MySQL. I'm just wanting to know if this is a suitable/optimal method of doing it. tbl_user_units has three columns, UUID (autoincrement), UserID, MID.I'm using 202 for the UserID in this exampleThe user is likely to select between 20 and 40 MIDsI would use a form with checkboxes to select the MIDs Not knowing how to delete old selections and insert new ones in a single operation, I propose to first  delete all the old values using this:&nb

When I installed CF 2021 Ent I accepted the defaults like I normally do and set up the instances and all run just fine. BUT now I want to use performance monitoring toolset to monitor those instances from a remote machine and cannot make it work. CF is running everything on the internal server as localhost or 127.0.0.1 and since those are not reachable from a remote machine PMT will not connect to each instance. If I use the domain name assigned to the IIS site for an instance and port 8500, the result is a server 500 error. I assume that when I installed CF I should have specified the DNS hostname for the EC2 server instead of localhost in order to make this work, but server is in production and I cannot re-install coldfusion. So is there any way to edit config files for the internal web server used for admin and PMT to use the hostname of the server instead of localhost or 127.0.0.1? Thanks

Hello Folks,Anyone know what a CF11 upsell key is?Issue trying to upgrade CF11 Standard to Enterprise. Using CF11admin > System Information > New License then pasting in valid Enterprise key.Prompts with:ALERT! Important notice about last submission...You cannot upgrade from a Standard license to Enterprise license. Use an upsell key or reinstall the server to upgrade.Currently a CF11 Standard key is applied:About ColdFusion » Server Details  Server Product  ColdFusion  Version  11,0,04,293328  Tomcat Version  7.0.54.0  Edition  Standard    Thanks in advance, Carl.

We have a new AWS Windows server, according to AWS sizing, this server has 4 cores. We want to install ColdFusion 2021 Standard on it. It sounds like we will need two licenses. So how do we do this?Do we just purchase 2 copies of CF 2021 Standard? Presumably we will end up with 2 serial numbers. How do we get both serial numbers into the install?Thanks

We are pleased to announce that we have released the updates for the following ColdFusion versions: ColdFusion (2021 release) Update 1 ColdFusion (2018 release) Update 11 ColdFusion (2016 release) Update 17   In these updates, we’ve fixed a few security bugs and some other bugs, which are mentioned in the tech notes.   In ColdFusion (2021 release), we’ve added activation and deactivation of Virtual core licenses. In addition, we’ve introduced support for RHEL 8.3, WildFly 23, Tomcat 9.0.43, PostgreSQL 13, Oracle 19c (2018), and MS SQL Server 2019.   For more information, see the tech notes below: ColdFusion (2021 release) Update 1 ColdFusion (2018 release) Update 11 ColdFusion (2016 release) Update 17   These updates fix security vulnerabilities that are mentioned in the security bulletin,  APSB21-16.   We’ve also updated Performance Monitoring Toolset for the 2018 and 2021 releases of ColdFusion. Check out the tech notes: Col

I am having problems converting XML data into the appropriate data types using a function. I have read in an XML file using XmlParse(). Within that there is an array which I loop around. <Cfloop array=#i.Task# index="t"> My understanding is that the items in this array are XML text. I can display all the items with CFoutput no problem. One item in the array (BaseLineColor) is a colour. #t.BaseLineColor# However this colour value is a single decimal integer number of varying length. I have worked out the maths to convert this decimal number into R,G,B decimal values. All good so far. The problem is that if I try mathematical functions on BaseLineColor, then I get:The value ?xml version="1.0" encoding="UTF-8"? BaseLineColor 255 /BaseLineColor cannot be converted to a number. So OK I have tried a few methods to try and convert BaseLineColor to an integer but nothing works. Val() doesn't work. In fact I can't seem to convert it into any datatype. Fo

I am attempting to run the CF 2018 Auto-Lockdown tool.  When I get to the ColdFusion Configuration and select the available instance of cfusion I get the following error: "ColdFusion server is nor running.  Please start the server and try again." All ColdFusion services are running and I am able to log into the admin portal. I have restarted services and rebooted the maching with the same result. I also could not find any recent documentation on how to lockdown CF 2018 manually since the tool was failing. Thanks.

When installing 2021 on macOSX Big Sur throws error,  “libCFXNeo.jnilib” cannot be opened because the developer cannot be verified. This appears to be a notorization issue with Apple.  This happens with every mouse click.  My guess is the dev team used a forged certificate, which is common, and a full notorization needs to be approved by Apple. Or maybe I should shut my mouth. 

I have registered a remote server and then created a cluster.  If I add both the local instance and the remote server, when I visit the configured website I get this error: The page cannot be displayed because an internal server error has occurred."  However, if I remove the remote server so only the local server is in the cluster the site works fine.  ALSO, if I remove the local server and only have the remote server in the cluster the site works fine.  It's only when both are in does it fail.  In the isapi redirect log I see this:[Fri Jan 19 20:46:36.099 2018] [1184:9128] [debug] ajp_close_endpoint::jk_ajp_common.c (921): (site2) closing endpoint with socket -1 (socket shutdown)[Fri Jan 19 20:46:36.099 2018] [1184:9128] [error] wc_create_worker::jk_worker.c (208): validate failed for DEV_SITE_CLUSTER[Fri Jan 19 20:46:36.099 2018] [1184:9128] [error] build_worker_map::jk_worker.c (310): failed to create worker DEV_SITE_CLUSTERAny ideas what it could be? 

I want to set my Creative Cloud Files folder as my wwwroot folder on my Mac Big Sur 11.4 machine. This will mean that with the sync I can easily develop on other machies from different locations. Currently the server.xml file reads:  <Context path="" docBase="<cf_home>/wwwroot" WorkDir="<cf_home>/runtime/conf/Catalina/localhost/tmp" ><Resources><PreResources base="docBase1" className="org.apache.catalina.webresources.DirResourceSet" webAppMount="/aliasPath1"/><PreResources base="docBase2" className="org.apache.catalina.webresources.DirResourceSet" webAppMount="/aliasPath2"/></Resources></Context> Please let me know exactly what I should update it to? I have tried everything I can think of and google but am obviously wrong... I have restarted the coldfusion server on each of my attempts.My Creative Cloud Files are located at: /Users/davidwhitehead/Creative Cloud Files Thanks in advance for your

Can some one post SSL connection string for Oracle DSN. Also, what is needed to connect to Oracle via SSL? 

HiI have Coldfusión 2016 and currently it has a server monitor, in the browsers it tells me that from this year I will no longer be able to use Flash, will this affect my coldfusión or only the monitoring?Do I have alternatives other than flash?

Hello,For a while now, I can't access server monitoring when I click on the server monitoring button, it sends me this linkThis content requires the Adobe Flash Player. Get Flash and when I click on get flash send me here: https://www.adobe.com/products/flashplayer/end-of-life.htmlSince Adobe no longer supports Flash Player after December 31, 2020 and blocked Flash content from running in Flash Player beginning January 12, 2021, Adobe strongly recommends all users immediately uninstall Flash Player to help protect their systems.how do I access if the plash player does not work anymore?  thanks

My "plan" was to install PMY on my home server and use it to monitor a clients AWS server instances and fire alerts etc. My problem is that if I manually add an instance to PMT on my local machine to connect to the AWS server it does not connect. I think the issue is that all instances on AWS are using the internal CF server for admin, running on 127.0.0.1. I do have all the necessary ports opened for PMT and Datastore, and I can access CF admin for each instance using this url format: <my domain name>:8500/CFIDE/administrator/index.cfm If in PMT I set the instance to use something like <my domain name> and port 8500 and set the correct secret, the result is the html of of 500 server error page when it fails. So I am not sure how to monitor a remote instance in PMT from my local machine. Any advice appreciated as always!  Thanks  

I have a new Windows 2019 server running CF21.I moved my main site, and intranet, over and all went well.I added an additional site, and extranet, and cfm pages will not load.I created an index.cfm page that displays simple text and the current date.https://harvardtransfusion.partners.org/ displays correctlyhttps://harvardtransfusion.partners.org/index.cfm gives a 404 error.Any thoughts on what I need to do to correct this?  Please be kind as I am not a programmer, but a Blood Banker.  🙂Thank you

Hello -  My company is in the final stages of a months long project testing and tweaking our CF application to work with CF 2018.  The project was set to go live at the beginning of next month.  Now it appears CF 2021 has been released, and appears to be unavailable for purchase.    We do not have the testing and development manpower to confirm our web applications compatibility with CF2021 in the next couple of weeks.  If there any backward licensing possible where we would buy licenses fro CF 20201 enterprise, but be able to install CF2018 enterprise until we are ready to migrate to CF 2021? Failing that, is it even possible to still purchase CF 2018?   And if so, would it be possible to qualify for the complimentary upgrade?  We plan to purchase 3 or 4 enterprise licenses, pending a final business decision.Thank you, -Anthony

Installed PMT and Datastore on my Windows 10 machine. Everything goes well until it tries to start the PMT service. It eventually times out. If I try to start from services panel I get the same result. A check of the PMT logs shows nothing as far as errors. Checking windows event logs shows these: The ColdFusion 2021 Performance Monitoring Toolset service killed process with pid 25056. The ColdFusion 2021 Performance Monitoring Toolset service could not be started within 240 seconds. Increase the server startup timeout value using C:\ColdFusion2021PerformanceMonitoringToolset\bin\perfmontoolsetsvc.exe -starttimeout <seconds> "ColdFusion 2021 Performance Monitoring Toolset". I tried changing the timeout and it still won't start. This was my thrid attempt at uninstall and reinstall of PMT. On the first two attempts I also got this error: Windows cannot load the extensible counter DLL "cfperfmon_2021.dll" (Win32 error code The specified module coul