ColdFusion

Crypto.com API is not very friendly.Took forever to get account balance authorized. Using same technique, same encoding I cannot get the order created. Always get unauthorized.<cfscript> apiKey = "#cr_key#"; apiSecret = "#cr_s#"; hmacm = #req_path# & 121 & apikey & #unixdatetimeNow.getTime()#; CrHex = hmac(hmacm, apiSecret, "HmacSHA256"); theKeyBytes = charsetDecode(ApiSecret, "UTF-8"); crsign = lcase(hmac(hmacm, apiSecret, "HmacSHA256")); newbody = serializeJSON({ "api_key": "#cr_key#", "id": "121", "method": "#req_path#", "nonce": "#unixdatetimeNow.getTime()#", "params": {}, "sig": "#crsign#" }); </cfscript>This works for account balance just fine. hmacm = #req_path# & 121 & apikey & #unixdatetimeNow.getTime()#; THIS is the HMACM getting envrypted which works is:private/get-account-summary121XXXXoZW8Cw75583kiSMqjp1649261460418This HMACM has no parameters in it which are only {} in the body. <

how to convert an array of one row to a number?

In our application on some pages we use cfprogressbar to show the progress of long running actions to the user. The progress bar is bound to a cfc which returns status and message from out of the session of the user.This coding has been in use many years and always worked well. For some time in version 2018 we sporadically get an error of the meaning that the cfc cannot be bound: java.lang.NullPointerException at coldfusion.tagext.html.ajax.AjaxProxyTag.getCFCInvocationPath(AjaxProxyTag.java:520) at coldfusion.tagext.html.ajax.AjaxProxyTag.getCallParameters(AjaxProxyTag.java:386) at coldfusion.tagext.html.ajax.BindProcessor.parseBind(BindProcessor.java:558) at coldfusion.tagext.html.ajax.BindProcessor.processBind(BindProcessor.java:325) at coldfusion.tagext.html.ajax.ProgressBarTag.generateBindFunction(ProgressBarTag.java:335) at coldfusion.tagext.html.ajax.ProgressBarTag.doEndTag(ProgressBarTag.java:273) at cfplpButtons2ecfm1713680839._factor0(G:\Websites\icmms\farcry\tags\p

My application used a Java function to open a new window. Code worked fine when it was in Coldfusion11 server but when it's Coldfusion 2021, all the client variables are deleted when the new page opened. Here is the Java part :I've compared all the setting in the coldfusion admin page of both server.Is there any hidden setting anywhere or some change between coldfusion version that can keep client variables between pages? Can you suggest any reasons why client variables would just disappear?

Windows 2016 server, IIS 10 and Adobe ColdFusion 2018 using Tomcat. The server has about 8 sites on it and one site is getting intermittent 500 errors. All other sites remain up and responsive. Failed Request Tracing shows "Filter Error - Incorrect Function 0x1" The site will come back up if you recycle the app pool for that site, or restart that site in IIS. I have the app pool set to recycle every 10 minutes. I've seen some vague references to possibly being a URL rewrite setting something that Tomcat doesn't understand, but could never find anything concrete related to that. If I go through our rewrite rules one by one, each one works fine individually. At this point I'm not sure what to even do with it. In March it was doing it frequently (once per day or more) and we recreated the site - new web root, new IIS config etc. same thing. Finally I noticed that the server had a pending restart from updates and once we did that it was fine until about 2 weeks ago. Other th

I need all my Coldfusion logs to store in JSON format.I can then parse those logs as a single line rather than a multi-line.How can I achieve that? 

Hello Everyone Spanish ASCII codes are not inserting properly into the database. I'm using microsoft SQL server 2014.Spanish letters are changed automatically. For example Ñ changed into Á along with special character like ? or '. 

I have found 10 year old examples on the net showing the coordinates included in the returned query, but when I try it on my CF 2021 server, those coordinates are not there, not even referenced in the cfdump. Has this function changed over time?

Bonjour,Ce qui est classique, je dois vérifié si l'IBAN (ou tous autres) est correct.Existe-t-il des solutions en CF ?Sinon comment s'y prendre ?Merci par avance Hello,What is classic, I have to check if the IBAN (or any others) is correct.Are there solutions in CF?Otherwise how to go about it?thanks in advance

I created an Azure Container Instance and Coldfusion 2021 is running on it as a Docker image.The application creates multiple log files. I sent all these logs to Standard Output by the symlink.Now, I want to parse these logs file-wise in Azure Log Analytics Workspace. Can anyone help me? Thanks!

I am having an interesting problem.  Since installing CF2018 Update 14 I am no longer able to use the CFMail tags in my web pages.  It was working before the update without issue.  Since applying the update when the page is called, it acts as if it stops reading the page at the <cfmail> tag.  Nothing else loads after that point.  I just get a blank white page in the browser.Looking at chrome developer tools, the body of the page is blank. Example of my cfmail:<cfmail from="test_noreply@server.com" to="email_address@server.com" subject="test email message"> This is a test email message </cfmail>I get the following error in the server application log:"Error","ajp-nio-127.0.0.1-8018-exec-5","06/28/22","07:46:57","","org/bouncycastle/jce/provider/BouncyCastleProvider The specific sequence of files included or processed is: X:\<path>\page.cfm, line: 2 " I've tried the <cfmail> tag all on one line and get the same error but the

I want to add a database (Microsoft SQL) to the website I'm working on, using Cold Fusion Administrator (latest version).After entering all needed data, I got the issue:Connection verification failed for data source: dbKantine java.sql.SQLException: The sqlserver package is not installed. You can install the package through the CLI package manager (C:/Users/MYNAME/.CommandBox/server/C1EA019F5A81794693D0EA837C1622B4-PROJECTNAME/adobe-2021.0.2.328618/WEB-INF/cfusion/bin/cfpm.bat) by running the command : install sqlserver.I tried to execute the *.bat file mentioned, but nothing happened.I also tried install sqlserver in the CommandBox, but it says:Error getting ForgeBox entry [sqlserver] The entry slug sent is invalid or does not existEDIT:I got it installed using cfpm.sh and wrote there "install sqlserver".But now it tells me this inside of Cold Fusion Administrator:Connection verification failed for data source: MYDB java.sql.SQLNonTransientConnectionException: [Macromedia][

HiFirst post here and very new to CF/Java. I have inherited  a somewhat legacy application that is running on windows/IIS fine. However, I am trying to deploy the same application in a docker container ( linux ) and running into some strange slow down issues.The application runs fine though it seems that half the time ( or more than that ) the application doesnt seem to be able to cache all classes and compiles them everytime . For testing, I remove the container and deploy everything again. Sometimes the system runs fine and is reponsive after deployment. Once its responsive, I can use the application all day without any slowdowns. At other times ( more often than not ), when I deploy the container, it slows down from the first request and never picks up speed. It feels as if the classes are being created everytime or being loaded in mem with every click. The difference is on the order of 2 minutes to browse through all links in the application to up to 2 hours for the

We are getting below message in error log:"There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected." When ever we are trying to update any setting or create new scheduler/gateway, it is redirecting us to login page.Error While Updating any setting in CF Admin

Hello, all,I'm just playing around with CFDIV, seeing what is possible, and something is not working._any.cfm:<cfoutput>This server is: #cgi.server_name#</cfoutput>index.cfm:<cfdiv id="testCFDiv" bind="url:_any.cfm" bindOnLoad="true"></cfdiv>When I open index.cfm in a browser, I get a blank page.  Using F12, I can see:<div id="testCFDiv"></div><!--- empty - nothing --->Shouldn't the CFDIV be loading the contents of _any.cfm???V/r,^ _ ^

I have a default install of Coldfusion 2018 update 13 running without issues. After the update 14 is installed manually via the jre/bin/java.exe, both the admin page and the coldfusion site throw 500 errors. I tried increasing the debug info from the admin panel before beginning, but it still just shows 500. I also made sure my c++ runtime is up to date. I also tried rebuilding the connector to IIS, even though I should not have to as the one from update 13 should work. Nothing fixes the 500 error, though uninstalling update 14 restores functionality. Any other ideas how get this update to work, or where to look to find out more details about what is actually broken?

Help!I can't seem to figure out how to handle WSS (Websockets over SSL). I have a cert that has already been sent/received by verifier. I have a cert and an intermediate cert. I've been looking at documentation and from what I've gathered i need to add the certs to the "keystore". I issued a command like this ->>>  D:\CF11\jre\bin\keytool -import -v -alias myCert-cert -file myCert.cer -keystore D:\CF11\jre\lib\security\cacerts -storepass changeit <-- I see the cert is added. And if list the keystore i see the number of certs increased by one. I then enable the SSL WS, use default port (built in server.. not proxied), and point it to the keystore D:\CF11\jre\lib\security\cacerts and for pass i simply use the default changeit.... I've modified my cfcode to have the secure="true" attribute. So I think everything is setup correctly ....but...  when i goto the webpage the web socket will try to connect then simply not connect (Firebug says the connection was refused) (

I am starting the process of upgrading one of my clients' test server in preparation to upgrading their production server from CF2016 to CF2021 and am seeing some strange QoQ behaviour. I was able to reduce the code to the following: <!--- SQL Server backend create table qoq1 (id int,name varchar(10)) insert into qoq1 select 1,'One' union select 2,'Two' union select 3,'Three' create table qoq2 (appid int,name varchar(10)) insert into qoq2 select 1,'Uno' union select 2,'Dos' union select 3,'Tres' ---> <CFQuery Name="q1b" DataSource="myds"> select qoq1.id,qoq1.name from qoq1 order by qoq1.name </CFQuery> <CFQuery Name="q2b" DataSource="myds"> select qoq2.name as catname,qoq2.appid from qoq2 order by qoq2.name </CFQuery> <CFQuery Name="q3b" DBType="Query"> select q2b.catname,q1b.* from q1b,q2b where q1b.id=q2b.appid order by q2b.catname,q1b.name </CFQuery> <CFDump Var="#q3b#"> The above dump in CF2016 shows 4 columns (which

Is there any variable in coldfusion that stores user ip address?Please let me know.Thank you

I am getting this issue on Coldfusion 2021.JDK 12.0.2 is used.Azure MSSQL Server is used.Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]An SSL socket connection could not be established because JRE 1.4 or above is required. Can anyone help me?Thanks!  

Following the Stripe documentation, which uses curl, I have tried the code:<cfhttp method = "POST" url="https://api.stripe.com/v1/payment_methods/pm_1LCuutGKxC2502V8WNrkE3Ja" result = "result"> <cfhttpparam type="header" name="Authorization" value="Bearer sk_test_51...."> <cfhttpparam type="FormField" name="customer" value = "cust_admin_1"> ..... </cfhttp> where pm_1LCuutGKxC2502V8WNrkE3Ja is the Payment Method id from the JSON response when the card payment method was set up.The above code gives the error: You cannot attach a PaymentMethod to a Customer during PaymentMethod creation. Please instead create the PaymentMethod and then attach it using the attachment method of the PaymentMethods API.Of course the PaymentMethod had already been created, and indeed if I change the ID slightly I get the message No such PaymentMethod: pm_1LCuutGKxC2502V8WNrkE3Ja22 as would be expected. Thanks in advance for any comments.

[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. My environment is CF16 with 2 servers connected through a public facing IP load balancer.  The SQL db is on a cluster. CF admin all datasource is pointed to an IP server. It has been working for quite a long time. Suddlenly last Thursday, we got a network issue. Network issue resolved. We are  kept getting this connection error. I rebooted 2 CF servers, telnet to DB server are ok. DBA stated he did the fell over to other node of the cluster. instead of bouncing the DB server.Are there anyone encounter this kind error and kindly guide me to solve this issue. 

I am attempting -- unsuccessfully -- to establish SSL connectivity to SQL Server 2019 from ColdFusion 2021 Enterprise running on Tomcat 9. Tomcat itself is configured with SSL and its own separate web server certificate. I have previously been able to connect ColdFusion Standard 2016 to the SQL instance from a different server, so I'm fairly sure the SQL instance is configured properly. The Java version for CF is 11.0.14 -- I have checked to make sure that Tomcat and CF are actually running this version of the JVM. I have added the root CA, the web server certificate, and the SQL Server cert to the Java keystore in cacerts for this Java instance. I have also added EncryptionMethod and other parameters to the Connection String in the datasource definition, and pointed it to the correct Java keystore with the correct password. This is what I get when I try to add the datasource:SSL socket connection could not be established because JRE 1.4 or above is required. I don't und

Hey there, I'm playing around with CF locally with a Reac Front End, for speed of testing I'm using the built in webserver to see whether it's work keeping legacy CF components for a REST API. I can get the GET and POST methods to work but am getting a CORS issue with DELETE. I've tried including the following inside my Rest service but still no luck. <cfheader name="Access-Control-Allow-Origin" value="*" /><cfheader name="Access-Control-Allow-Methods" value="GET,PUT,POST,DELETE" /><cfheader name="Access-Control-Allow-Headers" value="Content-Type" /> Any help would be much appreciated.Cheers

I am able to pass field values to Stripe's Customer object using the code   <cfhttp method = "POST" url="https://api.stripe.com/v1/customers"> <cfhttpparam type="header" name="Authorization" value="Bearer sk_test_....."> <cfhttpparam type="FormField" name="id" value = "cust_admin_18"> <cfhttpparam type="FormField" name="address[country]" value = "US"> ........ </cfhttp>   However when I try similar code with other Stripe objects, for example Payment_Method, I get an error with the id field. So <cfhttp method = "POST" url="https://api.stripe.com/v1/payment_methods"> <cfhttpparam type="header" name="Authorization" value="Bearer sk_test_....."> <cfhttpparam type="FormField" name="id" value = "pm_123"> <cfhttpparam type="FormField" name="type" value = "card"> <cfhttpparam type="FormField" name="card[number]" value = "4242424242424242">  </cfhttp> produces an error parameter_unknown - id   Changing "F