ColdFusion

Hello.  I'm hoping someone can help me convert some PHP hash code to CF (2018).  I'm confused by PHPs hash_init, hash_hmac, hash_update and hash_final.  // PHP $sha256_hash = hash_init("sha256",HASH_HMAC,$secret); hash_update($sha256_hash,$hash_string); $signature = hash_final($sha256_hash);I'm having a hard time wrapping my head around the three steps being done here and what the HASH_HMAC contstant is in PHP (yes, I've Googled...).I've taken a few stabs at it in CF with HASH and HMAC but am coming up empty.<CFSET signature = lcase(hmac(hash_string, secret, "HMACSHA256")) >Any thoughts?      Thanks,      John.     

i am trying to connect mysql database using my coldfusion admin. But I am getting this error. I am new to using docker with coldfusion but i think coldfusion container does not have necessary permissions to connect to database. 

We have noticed the below error is thrown IF there is a Java object initialisation error during boot of our CF server: "loader constraint violation: when resolving method  org.slf4j.impl.StaticLoggerBinder.getLoggerFactory()Lorg/slf4j/ILoggerFactory;" the class loader (instance of coldfusion/runtime/java/JavaDynamicClassLoader) of the current class, org/slf4j/LoggerFactory, and the class loader (instance of coldfusion/bootstrap/BootstrapClassLoader) for the method's defining class, org/slf4j/impl/StaticLoggerBinder, have different Class objects for the type org/slf4j/ILoggerFactory used in the signature"Which looks as if the Java exception is trying to use log4j to log details.The odd thing is that this Java exception clears after an application refresh and the underlying CF exception is revealed. We use commandbox in a 'Dev' environment so it's a war cf server deployment of an FW1/Coldspring application.It's hardly critical, but got me wondering how CF/Java classes get

Hi,I am having a problem with establishing Coldfusion 2023 connector to Apache 2.4.52 on Ubuntu 22. I got this error message when I started Apache2 service.apache2: Syntax error on line 228 of /etc/apache2/apache2.conf: Syntax error on line 4 of /etc/apache2/mod_jk.conf: Cannot load /etc/apache2/mod_jk.so into server: /etc/apache2/mod_jk.so: cannot open shared object file: No such file or directory All configuration and existence is checked nothing is wrong but the Apache won't start.Please help. Thanks.

Hi All,I am trying to run a ksh file with cfexecute tag. I am getting an error for no such file or directory: An exception occurred when invoking an external process. The cause of this exception was that: java.io.IOException: Cannot run program "/opt/web/apache2/htdocs/esdConfigTool/artifactorySoftware/REST/runJFrog.ksh": error=2, No such file or directory.This is the path for ksh file that i need to run:/opt/web/apache2/htdocs/esdConfigTool/artifactorySoftware/REST/runJFrog.kshThe code for cfexecute is this: <cfexecute    name="#VARIABLES.jFrogLocation#/runJFrog.ksh"    arguments='"#application.toolartifactorySoftTempabspath#" "#VARIABLES.jFrogLocation#/jfrogEsd" "#fileLocation#" "#VARIABLES.fileFolderLocation#/#arguments.file_name#"'        timeout="3000"        variable="downloadResult"        errorVariable="downloadErrorResult" />this is the stack trace of error: java.io.IOException

I have a simple query that pulls one record from a table based on a varchar(50) uesrname: select top 1 as hasunreadmessagesfrom usermessages um with (nolock)left outer join iepreferral on iepreferral.iepcaseid = um.iepcaseidwhere um.tousername = <cfqueryparam value="#client.userName#" CFSQLType="CF_SQL_VARCHAR">and um.isread = 0and um.isdeleted = 0and isnull(iepreferral.isDeleted, 0) = 0 My database monitor reports the folowing every time this query is run: This ad hoc statement had the following implicit conversions:The variable @7246612 has a data type of nvarchar which caused implicit conversion on the column [um].[ToUserName] with the value N'testusername'.?> This option in CF Administrator is NOT checked:String Format -- Enable High ASCII characters and Unicode for data sources configured for non-Latin characters Why does CF send the parameter as NVARCHAR?

I've installed CF 2023, the Add-on service is running.I can bring up the SOLR server admin page (in CFadmin)but when I click on Coldfusion collections I see this error message Unable to retrieve collections from the Search Services.Ensure that you have installed ColdFusion Search Service and it is running. the SOLR files appear to be all there under /cfusion/jettyThe install log says it installed without any errors  Summary-------Installation: Successful.897 Successes0 Warnings0 NonFatalErrors0 FatalErrorsAction Notes:NoneInstall Log Detail:Check Disk Space: C:\ColdFusionAdd-onServicesStatus: SUCCESSFULAdditional Notes: NOTE - Required Disk Space:755,448,814 Bytes Free Disk Space:62,365,196,288 Bytes  how do i fix this?

Hi there,I have started using ColdFusion again after a break of many, many years, so I’m as rusty as anything. Quick question.I have a table that stores the HTML-tagged content between body tags. It is for the narrative documentation of a science project ( a bit like Wikipedia articles). I use cffile action=“write” to create a static HTML page for each article. How do I get the HTML tags to be outputted by ColdFusion? I have tried both HTMLEditFormat() and HTMLCodeFormat, and neither. The CFML files execute fine, but the displayed content is stripped of any HTML content in the database table. cfoutput#Article#/cfoutput Many thanksMike PetersNew Zealand

I am attempting to deploy ColdFusion 2023 containerized with podman in a podman pod along side a MySQL podman container.  The goal is to have a rootless deploy on a VM.  I have succesfully deployed a test with docker-compose in a local docker-desktop environment but when I try to do this on the VM with the following commands I get an error in the Admin console -> Enterprise Manager -> Instance Manager "webcamp_pod: Name or service not known".  I feel like I'm missing a setting somewhere.  Any suggestions or help would be appreciated. podman pod create --network host --name webcamp_podpodman build -t wc_mysql_db -f=docker_files/Containerfile.mysql .podman run -d --pod webcamp_pod --name wc_mysql_db wc_mysql_db:latestpodman build -t webcamp_dev -f=docker_files/Containerfile.dev.app .podman run -d --name webcamp_dev -p 8500:8500 --pod webcamp_pod webcamp_dev:latest 

We have installed CF2023 (30-days-trial, Update 4, version 2023.0.04.330500) on two different VMs with openSUSE-Leap-15.5-1.One Server is using the build-in Tomcat (port 8500), the second one Apache (port 80).Both servers are getting stuck for at least 9 minutes at the same point on every restart:coldfusion-out.logAug 28, 2023 19:31:26 PM Information [main] - Starting logging...Aug 28, 2023 19:31:26 PM Information [main] - Starting license...Aug 28, 2023 19:31:26 PM Information [main] - Evaluation Edition enabled*** Minimum pause 9 minutes (on every restart) ***Aug 28, 2023 19:40:04 PM Information [main] - Starting crypto... We tried it with and without this JVM-paramters: -Djava.security.egd=file:/dev/urandom-Djava.security.egd=file:/dev/random(no difference) Both servers use the build-in JRE (CF standard), version 17.0.6+9-LTS-190 CF2018 ist starting up immediately on those machines.On Windows Server CF2023 also starts-up immediately. Any help would be h

They dropped a servder upgrade on me and now (after a little more than 10 years) this code doesn't work.  Any ideas what I can change it to? #dateformat(News_Date, 'dddd mmmm dd, yyyy')# HELP!  Please, And thank you.

I am running the 2023 Server Auto-Lockdown on one of my sites.  When running, it seemed fairly slow, but not horrible.  But it took multiple minutes. Now the Auto-Lockdown tool is at 100% (20 minutes), but it still has a message saying, 'Installing... App pool created!' and the bar is at 100%.  The last bits of the log are above.  Evidently the tool is very proud of creating the App pool...but doesn't seem to move on from that. Is there a way to check if the necessary changes have been made?  I need to run this on 5 other sites, just wanting to make sure it is actually doing something.   Thanks!

ColdFusion 2021 will not update through CFAdmin.  Download states "Starting Download".  However, this error is logged in cfusion/logs/update.log:  Not able to connect to Update Site: Connection Failure: Status code unavailable.

Hello:Is it possible to create car and j2ee archives from the command line?Thanks,Greg 

Hi Everyone,I am in the middle of creating a CSV file export.  I'm currently using the Java StringBuffer class to append my query data and then output the data using cfcontent.  Anyway, I noticed that the Zip Code field has removed the first leading zero.How can I modify my code to allow for the entire zip code to be displayed.  When I originally used cffile was able to wrap a variable in quotes and that preserved it.  However, I am not using cffile since it has slowed the export considerably.Also one of the address fields contained a comma that caused a blank column to be added - shifting some of my content. I replaced the comma with a blank and that removed the comma but the added column still exists.  Any idea on how to resolve that?Here is a sample of the code<cfscript>    csvExport = createObject("java", "java.lang.StringBuffer");    csvExport.append("First Name,Last Name,Address1,Address2,City,State,Zip Code,Local,Works

I've tried multiple installations now - completely new. After the configuration is complete, and I navigate to the Administrator > Settings Summary page, I get the following error: The getMachineUUID method was not found.Either there are no methods with the specified method name and argument types or the getMachineUUID method is overloaded with argument types that ColdFusion cannot decipher reliably. ColdFusion found 0 methods that match the provided arguments. If this is a Java object and you verified that the method exists, use the javacast function to reduce ambiguity. The specific sequence of files included or processed is: C:\ColdFusion2021\cfusion\wwwroot\CFIDE\administrator\reports\index.cfm, line: 191 What gives????

We updated to CF 2021 Update 10, and we're now seeing an odd error with CFPDF calls that utilize the write action. Essentially, we read a PDF from a network share (\\server\share\inputfile.pdf), do some work on it, then write out a new file in the same location (\\server\share\outputfile.pdf).We've recently been getting an "access denied" error when executing the CFPDF call that writes the file out.  The CF process absolutely has access to write to that network location, and looking at the event log on the server, I don't see any audit failures when the CFPDF call executes. As a workaround, we've changed the CFPDF call to output to an internal temp directory, then we use CFFILE to move the file to the network share.  This works fine. If anyone else seeing this behavior?The only changes to our server recently have been the installation of Windows Updates and CF 2021 Update 10.  I haven't yet had time to dig further, but I was wondering if anyone else h

I have a CF process where I click a submit button. Then I need the process to wait/pause for 30 seconds and then run another check. If the check is no the process ends. If the check is yes then i need the process to wait for 10 more seconds and then run the checks again. What is a good way to do this to get the processes to wait the 30 seconds and then the 10 seconds?

I am assisting in moving a site that was on CF11 to CF2021. There has been a lot to fix but I have had trouble on on instace in where there are client variables that are lost from one page to another. When a user logs in, client variables are set.However, when users click to go to a part of that websiet that uses Model Glue for this and only this folder, the client variables and session variables are cleared. Now, on CF 11, this worked no problem. The variables exist without issue. However, on CF2021, those variables are cleared. Now, yes, there is an Application.cfc within this folder and I suspect its the reason why this is cleared (there is no app.cfc in the folders before this again, old appliction not my code) The problem is, that there is code within this model glue folder that tries to refrence that now cleared (on CF2021) variable. I'm lookng for a good solution, is there a way to move that client information into this folder which is needed for some functionalit

Hi, i found issues on cfhtmltopdfitem <cfif _PAGENUMBER eq _LASTPAGENUMBER >  Last Page<cfelse>  Page: _PAGENUMBER of _LASTPAGENUMBER</cfif>this will only work if no html tags like <div> something like that. ill give example<cfif _PAGENUMBER eq _LASTPAGENUMBER >  <div> Last Page </div><cfelse>  <div> Page: _PAGENUMBER of _LASTPAGENUMBER </div></cfif> this line of code will not work. also this like of code will also not work  <cfhtmltopdfitem type="header">    <div >      Header    </div>  </cfhtmltopdfitem>  <div>     Body  </div>  <cfhtmltopdfitem type="footer" evalAtPrint="true">      <cfif _PAGENUMBER eq _LASTPAGENUMBER >        Last Page      <cfelse>        Page: _PAGENUMBER of _LASTPAGENUMB

Hi,I am trying to convert some java code (below) to Coldfusion but am running into an error "Variable HEX is undefined". How can I create a Hex object in CF?  <cfset input='{"id":7,"attempts":1,"notifications":[{"action":"UPDATE","message":{"id":0,"sender":"","body":"{\u0022TableId\u0022:930002,\u0022TableName\u0022:\u0022DEMOGRAPHIC\u0022,\u0022TableAction\u0022:\u0022UPDATE\u0022}"}}]}'> <cfset key = "xxxx"> <cfscript> secret = createObject('java', 'javax.crypto.spec.SecretKeySpec' ).Init(key.GetBytes("UTF-8"), 'HmacSHA256'); mac = createObject('java', "javax.crypto.Mac"); mac = mac.getInstance("HmacSHA256"); mac.init(secret); digest = Hex.encodeHexString(mac.doFinal(input.GetBytes("UTF-8"))); </cfscript> 

We are pleased to announce that we have released the updates for the following ColdFusion versions: ColdFusion (2021 release) Update 2 ColdFusion (2018 release) Update 12   Note: The ColdFusion (2021 release) installers have also been refreshed with this update. The new server installers bundle Update 2 and JDK 11.0.11. The ColdFusion Add-Ons and other installers are bundled with JDK 11.0.11. The refreshed installers are available at ColdFusion downloads.   In these updates, we’ve fixed a few security bugs and some other bugs, which are mentioned in the tech notes. ColdFusion (2021 release) Update 2 ColdFusion (2018 release) Update 12   These updates fix security vulnerabilities that are mentioned in the security bulletin,  APSB21-75. In addition, Update 2 of ColdFusion 2021 features the following: CFSetup enhancements ColdFusion licensing and activation ColdFusion AWS Lambda   For more information, see the tech notes for ColdFusion 2021 Up

I am moving an old application which is on a CF11 install to my CF2021 install.the code has worked fine for 10 years under CF11 i have code where after i am adding a product to my cart it its updating the database with the cart product information. it is running this code as part of a UPDATE cfquery and upating a user table: SET PreviousProduct_ID = '#Listfirst(Form.Product_ID)#', CF is complaining - Complex object types cannot be converted to simple values.but it is not a complext object it is a simple list productid numbers with commasthis is the variable output in the CF debugPRODUCT_ID=5332,5333,5334,5335,5336,5337,5338,5339,5340,5341,5342,5343,5344,5345,5346,5347,5348,5349,5350that is a list? not a complex object? works fine in CF11 but not in 2021 and i can not for the life of me fiture it out.Please help.   

Hi,Strangely, our CF 10 server has started to show "500 - Internal server error" whenever a CF error occurs, instead of the normal error message. The error is logged, but the front end shows the error 500 and nothing else. Normally, we'd see the error message and stack trace etc.How would I troubleshoot that?EDIT: This is a CF10 on IIS 8 Windows 2012 server, with update 11.Regards,MarkMessage was edited by: tribule

Is there a particular folder within coldfusion that scheduled tasks that i create has to be stored?