It was just posted that the new Update 16 includes the fix to this issue. https://community.adobe.com/t5/coldfusion-discussions/now-live-adobe-coldfusion-2023-and-2021-september-2024-security-updates/td-p/14852233  ... View more

Hi @pintuk86858408 , I have been able to show that this is unlikely to be a ColdFusion issue. I did it as follows.    Download the ColdFusion 2018 installer for Windows from CFMLRepo. Install it on Windows 10 Pro.  Save the following code as the file C:\ColdFusion2018\cfusion\wwwroot\calibriPdfTest.cfm <cfhtmltopdf destination="C:\Users\BKBK\Desktop\FILEPATH.pdf" overwrite="true" orientation="portrait" unit="in" marginbottom="0.25" marginleft="0.25" marginright="0.25" margintop="0.25"> DISPLAYED IN PDF <div style="font-family:calibri;font-size:13pt;"> THIS IS THE LINE TO BE TESTED: IF IT APPEARS IN THE PDF, THEN THE TEST WILL HAVE SUCCEEDED. </div> DISPLAYED IN PDF </cfhtmltopdf> ​  Launch in the browser: http://localhost:8501/calibriPdfTest.cfm  Verify that the file FILEPATH.pdf has been saved on the desktop.   On inspecting the PDF, I can see that it contains the text within the div element. I have attached the resulting FILEPATH.pdf .   This test suggests that the cause of your problem is local to your environment. ... View more

Thanks for confirming the command line cfstart helped you, Paul.    FWIW, as with Coolidge in May, I have my doubts it was the windows update itself, but instead that something else changed before the box (and therefore CF) restart. But I appreciate you may be happy enough just to be running again, without really wanting to dig into "what really happened". 🙂 Glad to hear that you're back up and running.  ... View more

Thanks Charlie your post explaining how to use command line install of the CF update, adding that new arg (like I'd added to CF's JVM args), before the -jar arg pointing to the update jar. worked.   An example of doing that, for CF2021 update 9 (Windows users should be sure to use "run as admin" in opening the command line):   java -Djdk.util.zip.disableZip64ExtraFieldValidation=true -jar hotfix-009-330148.jar Sure enough, it worked, allowing the update to run. (If you may never have yet run the CF update jar this way, it presents a series of a couple of screen walking one through the CF update process.)   ref: Beware you can't download or install CF updates via the CF Admin after Jul 2023 JVM update - Charlie Arehart - Server Troubleshooting (carehart.org) ... View more

@taunnt , Are you still looking for a solution to this? If not, I would be glad to hear how you solved the CSS/CFDocument integration issue. ... View more

I just wanted to highlight that Dani started another question on this issue on the forum.  If the POP/IMAP server is Microsoft Office 365 based, then it might be related to server chagnes that were made disabling BASIC authentication.  Microsoft is making a strong push to get away from the simple authentication method.     I just wanted to make sure that if anyone ended up on this ticket that they are aware of this other discussion since it might be related.  Look for the discussion on:  "CFIMAP tag connecting to Exchange: Logon failure: unknown user name or bad password"  I know I have started seeing issues with POP and Office365.  That being said, the specific issue this user might be having might be unrelated, just wanted to note it.     Matt   ... View more

To be clear, the jetty folder is about the cf add-on service (not monitoring), which is the solr or pdfg/cfhtmltopdf feature.   There are no documented mitigation steps. One could uninstall the cf add-on service if you're not using it. One could even just yank the log4j jar, if you wanted to just stop the add-on service without installing it.    We can hope that some future update (perhaps coming even this month) will address this more appropriately.    BTW, Ripley, the jetty aspect related to monitoring is yet ANOTHER jetty that Cf has had, starting back in cf9, which was about offering a separate port and web server through which to access the enterprise server monitor. It has its own jetty.xml config file in the cfusion/lib folder, which relies on a jetty jar in that folder. That is NOT the cfusion/jetty folder, added starting in cf11 (if one enabled the add-on service at cf install), which is the focus of the log4j concern in this thread. It can get confusing!    Hope that's helpful.  ... View more

If you want to go the Duo route, using their Duo Web SDK, there's a CFC for that here: https://github.com/duosecurity/duo_coldfusion   Duo Web SDK implementation steps: https://duo.com/docs/duoweb-v2   It's been a few years, but I was successful in getting Duo to work with our CF logins without too much trouble...   ... View more

Thanks, @paule12345 , for the update.  ... View more

I have never successfully run the updates through the CF Admin (we have pretty strict security and our systems do not have access to the outside internet without requessts and jumping through many hoops) so I have always doen the updates manually.  The changes in 2021 have led to my needing to download a few more files to get the updates to work.  Below are the steps I use from my documentation so I can reopeat these somewhat convoluted steps each time.  I hope they can help someone more successfully run updates manually. (apologies for this comment box decimating my "outline" format.  I hope they are still clear steps.)   How to Hotfix ColdFusion 2021 Download the Patch files you will be installing: Hotfix Page You will need the hotfix file: Example hotfix-001-325996.jar We do not have outside web access so I need to get the "Package repository:" Example: packages-cf2021-001-325996.zip Copy the files to the server you wish to update The jar file for clarity should be put into the(our method to keep them organized): C:\ColdFusionINSTALL\INSTANCE\hf-updates\XXXX.jar This folder may need to be created on a new install The "Package repository" should be placed in a folder: C:\packagerepo This file usually unzips to a "bundles" folder but the contents of "bundles" needs to be in the C:\packagerepo ONE TIME STEP: If this is the first hotfix you are running you will need to make a couple of changes in the ColdFusion Administrator. Go to "Package Manager → Settings" and change "Package Site: Site URL" to C:\packagerepo\bundlesdependency.json You can also, if not set, set the proxy settings on this page as well Proxy Host: http://YOURPROXYURL Proxy Port: 80  Stop and restart ColdFusion if you needed to make these additions.  If they already existed all this could be skipped. All the files should now be setup so now we can run the update. Open a prompt as an administrator to run the jar Windows: <cf_root>/jre/bin/java.exe -jar C:\ColdFusionINSTALL\INSTANCE\hf-updates\/hotfix-XXX-XXXXXX.jar Linux-based platforms: <cf_root>/jre/bin/java -jar  /ColdFusionINSTALL/INSTANCE/hf-updates/hotfix-XXX-XXXXXX.jar (sudo) Occasionally the install will have problems restarting the ColdFusion service.  Open the task manager and stop all coldfusion processes then restart the service manually. Once you have restarted it is always a good idea to load the ColdFusion Administartor and check out the settings summary to see that the version is what you expect. ... View more

Windows Script Host FTW ... View more

Hi paule12345 Thanks for the update. Could you please share the stacktrace of the extra thread (the stracktrace you get from Fusionreactor). ... View more

I did a quick search for SelectAllEditableRanges, and it seems your perl script is possibly using Microsoft Office Automation to process the document.  It's probably trying to execute MS Word and that's where it could be failing.  This article may be of use to you:   http://shamcf.blogspot.com/2014/08/not-able-to-run-vbscript-using.html   ... View more

Thank you. That was the article I needed.  ... View more

A fix for this has been offered in another forum thread: https://coldfusion.adobe.com/2019/09/coldfusion-2018-release-update-5-coldfusion-2016-release-update-12/#comment-35695   As for anyplace that tracks the sizes of the connector DLL, I don't know of one. And it is indeed VERY unfortunate that the "version" info reported for the dll file has not changed with those clearly different versions. I hope Adobe will address that.   ... View more

Thanks. Can I do this even though the image is not a separate item in the database? It's part of the whole content value. ... View more

Test by selecting just one column, dataID, but otherwise with exactly the same query. Is there a difference between times taken by SQL Studio and ColdFusion? ... View more

Thanks. When I revisit that part of the application, I will defo give this a try! ... View more

Did you ever solve your duplicate email issue? We've been having the same problem for the past two months. ... View more

You are right. I was using an old Java Version, Java 6. I will upgrade it to Java 8 and try it out!! Thanks for all the support!! ... View more

I am using Docker, so already tried loading fonts into the container, it didn't work. We are planning tackle it by "wkhtmltopdf".  Thanks for your time, paule12345. ... View more

It's true, what @Paule12345 says. Write the table as an HTML file. In fact, you may style it using CSS, for example, and make it as fancy as you wish. Then include it in the presentation. As an example, save the following code as myPresentation.cfm. <cfpresentation title="myPresentation" format="ppt" destination="#expandpath('myTestPresentation.ppt')#" overwrite="yes" >     <cfpresentationslide src="testTable.html">            </cfpresentationslide>     </cfpresentation> In the same directory as the CFM file, save the HTML table from W3Schools as the file testTable.html. Launch the CFM file. The result should be a Powerpoint file, myTestPresentation.ppt, containing the table. ... View more

Thanks for the feedback, the SSL Labs is very cool, one for the bookmarks. I relented and went to ColdFusion 2016 and now it works. I had a bit of a time getting CF to recognise the CFM default pages, which was resolved (although I'm not sure what was causing the 2016 installer to mess up, but I did manage to get it working) Re: Default document not being processed when not included in URL Thanks Mark ... View more

Using the SSL Labs server testing tool ( https://www.ssllabs.com/ssltest/ ) shows that the API endpoint https://api.unsplash.com has only TLS 1.2 enabled. If you're on an old OS such as Windows Server 2008, you're stuck with TLS 1.0. IISCrypto can show you what protocols are enabled on your Windows box: https://www.nartac.com/Products/IISCrypto ... View more

deepthit, If your users install the latest windows updates to the Office suite, it should resolve your issue. This thread discusses the issue in depth: KB3170008 for Office 2016 Breaks Functionality - MS16-088     - Office 365 subscription (Click-to-Run)—install the latest updates      - Windows Installer version (MSI)—you could wait about a week for the next security update for MSI, and it will update automatically. Or, to get the fix today, use the Download Center to get the KB for your version of Office: Office 2016: https://support.microsoft.com/kb/3115438 Office 2013: https://support.microsoft.com/kb/3115455 Office 2010: https://support.microsoft.com/kb/3115476 ... View more

Thank you, I never would have found that.  It worked. ... View more

Do you have sandbox security enabled?  If so, turn it off and see if the problem goes away. We recently had severe problems with the DB connection pool hanging when a certain (hard to define) threshold of incoming requests was reached.  CF10 and CF11 both exhibited the behavior.  With sandbox security disabled, the hangs disappeared.  If you must have sandbox security enabled, in the CF admin, try limiting your DSN's connections to, say, 10 max connections.  It seemed to help. I've been meaning to submit a bug report on this... ... View more