Questions

my knowledge to the crypt functions and the hmac is limited and i am still learning. I am trying to do this of Node JS code to Coldfusion but my results are not the same const getMessageSignature = (path, request, secret, nonce) => { const message = qs.stringify(request); const secret_buffer = new Buffer(secret, 'base64'); const hash = new crypto.createHash('sha256'); const hmac = new crypto.createHmac('sha512', secret_buffer); const hash_digest = hash.update(nonce + message).digest('binary'); const hmac_digest = hmac.update(path + hash_digest, 'binary').digest('base64'); return hmac_digest; };and i did some try in Coldfusion but i am not able to get right results  <cfset nonce = createobject("java","java.lang.System").currentTimeMillis()> <cfset string_to_sign = "/0/private/TradeBalance" & hash(nonce, "SHA-512", "UTF-8")> <cfset api_sign = tobase64(hmac(string_to_sign, "#secret_key#", "HMACSHA256"))> 

Hello, I just installed the January Microsoft updates for Windows Server 2012R2 and now ColdFusion 2016 ( with level 16 patch ) will not start. Please help, this is a production system for state Government! Here is the info from the logs. I have tried restarting the server 4 times. Funny thing is that the server log says ColdFusion application server was started. Thanks for any help you can give! When I try to start the Application Server from Windows Services it times out and gives the following response. "Windows could not start the ColdFusion 2016 Application Server services on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion. Here is the coldfusion-error log:Jan 24, 2021 7:22:07 AM org.apache.catalina.core.AprLifecycleListener lifecycleEventINFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [D:\ColdFusion2016\cfusion\

I am wondering if anyone found success running CF Performance Monitoring Toolset (2021 specifically) in kubernetes.  I am asking about two things specifically:- Were you able to get autodiscover to work?  I think I am having an issue with multicast and RKE with multiple nodes.  I believe this to be a networking issue and NOT a PMT issue, since autodiscover works great for me in Dev (single kubernetes node).- Is there any option for updating the password for PMT at container runtime?  I looked at the official docker image but didn't see a way to set a user/password via env var.  I did see a bin/passwordreset.sh but it seams to be a TUI script and from a quick glance it doesn't take a user/pass as arguments.Beyond updating the password, I wasn't able to find any options for updating PMT configurations in an automated fashion, besides the handful of env vars from the official container image (which I am using and did help me), but maybe I missed a file/document so

I am following the instructions here:https://developer.paypal.com/docs/checkout/integrate/#5-capture-the-transactionAnd when I get to step 6.2 to verify the transaction on the server side I am not sure what to do. Do I need to install something on the server if I am using the javascript code shown?Cheers!

I'm using ColdFusion 2018, Oracle 12c, and IIS 10.  I setup a page to upload Microsoft Word files with a DOCX file extension into a BLOB field into the database.  When I use the website to open the file all I see is the text.  The problem is I do not see any images that were pasted into the file before it was uploaded.  In IIS there is a MIME Type of DOCX.    The upload query is similar to:<cfquery datasource="my_dsn">INSERT INTO my_db_table (File_Name,File_Content)VALUES (<CfQueryParam CfSqlType="cf_sql_varchar" value="#File_Name_Value#">,<CfQueryParam CfSqlType="cf_sql_blob" value="#File_Content_Value#">,)</cfquery> The query to get the file from the database is similar to:<cfquery datasource="my_dsn" name="my_query">SELECT File_Name, File_ContentFROM my_db_tableWHERE File_Id = "#File_Id_Value#"</cfquery>

Having trouble getting GoogleBot or Bing to crawl through pages on a website.  For some reason when you use Google Console or Bing Webmaster tools the crawlers timeout or get kicked from the site and i receive the error of "Page cannot be reached".  I've ensured robots.txt is not blocking the crawlers as well as no firewall is blocking them and IIS is allowing them into the page as the log files for the site sees the bot talking to it.ColdFusion is in lockdown.I've looked through the log files and haven't found anything to point to the crawlers getting booted.Any suggestions would be greatly appreciated. 

Hi, We want to explore the option of running Adobe Coldfusion in AWS on a EC2 instance.  Currently we run CF on RHEL 6/7 on premise. Is there any information/documentation regarding AWS and CF? I would it appreciate if any other community members can share there experience? Thank you.

I am working with a SOAP request in coldfusion. When the code I have is run from a .CFM file, it works. If it is run from a .CFC file, it doesn't work. The code is the same as far as possible (the .CFC needs the cfcomponent and cffunction tags for example). Why would it work from one and not the other? When I call it from the CFC page I get the error Unable to determine MIME type of file. Does anyone have any idea why this might be happening? The SOAP request is identical on both pages. The call with the CFHTTP as well as all the CFHTTPPARAMs are the same as well.

I need to know the latest version of JVM and Tomcat for Cold Fusion 2016  Currently I am using JVM: 11.0.6+8-LTS looking at upgrading to JVM 11.0.7 As well as upgrading from Tomcat 8.5.42 to Tomcat 8.5.55 

Hi,I enabled encryption on a varchar column in database MS SQL 2019. Now, CF application is generating an error ByteArray objects cannot be converted to strings.  How to enable or register encryption for this database in the CF 2016 server?Thank you in advance,

Hi All I'm trying to find some help / pointers to create a work/schedule/calendar section for my website. I need 1 month across the top and my resources/programmers down the left. Quite a simple layout but I've been struggling for 4-5 days, any help/pointers etc. would be gratefully received. ThanksGary

The small Australian organisation I consult for has a problem. The CF application I created for them some 8 or 9 years ago and which they have been happily using ever since, seems to have reverted to the developer version thus restricting them to a single workstation for the application when they need 3 or 4. We originally purchased CF8 and in 2018 moved to CF9 but we have no idea what our CF serial number is and therefore can't correct the situation. I have spent a fair amout of time trying to figure out how this situation arose without finding an answer. How can we find out what our serial number is?

Hello everybody!I'm posting this here to have a place to gather any information about using Postgres 12 with the most recent releases of Coldfusion. In our current environment (Postgres 12 and CF2018), we are getting errors thrown by Postgres indicating a very mismatch between the client (CF's JDBC Postgres driver) and our Postgres 12 database server. We do not see these errors when connecting to our Postgres 11 server. I will document here our updating attempts to resolve this issue. First, we will update to CF2021. This may resolve the issue, but I'm not optimistic as the support matrix only says Postgres 11. If that does not succeed, we will try simply replacing the jdbc driver jar and test that. Hopefully it won't break coldfusion and will resolve the errors. If anyone else has done this, I'd love to hear how your experience went. If anyone from Adobe has any advice or news on if/when Postgres 12 will be officially supported, that would be great to have!thanks, everyone!

Moved from an old laptop to a new Surface computer. Trying to connect my Localhost (127.0.0.1) installation on Windows 10 on the IIs server to my existing MySQL database. CF Administrator works fine, as do my CF templates (except for queries, of course). Got this message:"The standalone MySQL JDBC driver is no longer shipped with ColdFusion.Please download it, put it in cf_root/lib folder and restart ColdFusion."1. Where to I get the correct MySQL JDBC driver?2. Does is go under C:\ColdFusion2021\cfusion\lib  ?Thanks in advance. 

Hi i have an value:  20191111153402IT is: YYYYMMDDHHMMSSHow can i convert it in an mysql DATETIME Format? Anybody an idea? Kindly RegardsThorsten

What could possible go wrong, right? Since we bought CF 2021 I googled "coldfusion download" which took me here https://www.adobe.com/support/coldfusion/downloads.htmlUm, no Linux 64bit installer? Ok, so I logged into my adobe account and got here: https://www.adobe.com/products/coldfusion/download-trial/try.htmlActually, I don't want to try it 30 days ... we already purchased it ... now I need to fill in a marketing survey?! REALLY?Well, ... after hitting the "Download" button I got to a page with some getting started content, but no download. I tried a few times with mostly random answers to the survey. Frustrating ... Turns out the download doesn't start in Chrome 87 so I needed to switch to Safari browser to get the ColdFusion_2021_GUI_WWEJ_linux64.bin Ok, since I want to update our CF docker image which we use for development I searched for silent installation properties.https://helpx.adobe.com/de/coldfusion/using/install-coldfusion-2021.html#Sil

I am having an issue with the square API and want to make sure I'm not doing something stupid. Here's my code: <cfset stFields = { "order": { "idempotency_key": "xxxxxx-215d-4dce-b92a-90c306eb5eba", "location_id": "xxxxxx", "total_money": { "amount": 99999, "currency_code": "USD" }, "order": { "location_id": "xxxxx", "customer_id": "asdasd" } }, "idempotency_key": "xxxxxx-215d-4dce-b92a-90c306eb5eba", "ask_for_shipping_address": false, "merchant_support_email": "consectetur@loremipsum.com", "redirect_url": "https://abc.com" } >  I keep getting the error: {"errors":[{"category":"INVALID_REQUEST_ERROR","code":"VALUE_TOO_LOW","detail":"`order.total_money.amount` must be greater than 1.","field":"order.total_money.amount"}]}Yet... It looks to me like there's a value...  Any ideas??? 

We have just recently updated from CF11 to CF2018.One thing we do often as we develop is use CFDUMP to view the contents of variables and objects as we're coding.  We've grown quite fond of ColdFusion's neat little CFDUMP tables that make viewing objects so convenient such as this little example:However, since installing CF2018, CF when we use a CFDUMP inside a CFC we no longer get this nice view.  We get a plain old HTML table that's much harder to read..especially as the objects grow much larger:Viewing the source code of the dumped page, CF is not inserting the CSS nor JS for it's CFDUMP tables when used within a CFC.  Everything is fine if the CFDUMP is used on a CFM page.  This was not a problem in CF11 nor any version prior.Any ideas how to get CF to 'dump' out the CSS and JS when used in a CFC?

We have many queries which do something similar to:WHERE dateCol > <CFQUERYPARAM VALUE="#someDateString#" CFSQLTYPE="CF_SQL_TIMESTAMP"> Today, users informed us that existing reports were returning unexpected results.We use datetime2(7) columns in an MS SQL server. As an example, we have data (3 rows) in a table with dateCol values of "2020-03-01 10:00:00.54321".We run a query with a clause of: WHERE dateCol > <CFQUERYPARAM VALUE="2020-03-01 10:00:00.54321" CFSQLTYPE="CF_SQL_TIMESTAMP"> These queries have been in place for years, and up until today they were working fine.  The example query was returning 0 rows (as the timestamps were equal).Today, the query is returning the 3 rows as if the converted value (from whatever CFSQLTYPE does internally) is earlier than 2020-03-01 10:00:00.54321. Removing CFSQLTYPE="CF_SQL_TIMESTAMP" makes it work as expected.  Running the query in SSMS without CFQUERYPARAMVALUE at all makes it work as exp

We have ColdFusion 2018 with Java version 10.0.1.  There is also installed on the server JDK 12.0.1.  Is the JDK necessary and required?  We have security notice that JDK should be updated to version 15.  Can this be done without causing problems for ColdFusion?  Thanks,Jim

We're running an older CF10 instance on Windows Server 2012 that we finally got approval to upgrade. The goal is to bring it in line with other instances of the same application, so we're upgrading to CF2016. During the upgrade process, we chose "Configure my web server for ColdFusion 2016 (recommended)" as opposed to "Enable the built-in web server (coexist)". The upgrade process went fine, with 1 reported error.  Looking into the log file, it was an error related to the connector, which made sense as we had left the old CF10 instance and conenctor in place. We got onto CF Administrator, chose not to migrate anything (we do a full review of settings against a reference server manually), and verified some basic settings. We went through the process of updating CF (to 11, then to 13), then stopping CF10, removing the connector for CF10, and adding the connector for CF2016.  This all went as expected. We then set the CF2016 Application Server to ru

Good morning,       I have a very strange occurence on several web pages.  I have some cfc binds setup on a couple of web pages that are being called from another folder directory instead of the current directory the cfc's reside in.  For example, one of my binds should be calling a cfc file that exists in the same folder that the web page exists in, but it is calling from a completely different directory:Current directory of web page and cfc file: /var/www/vhosts/egtyctest.com/egtgup2.egtyctest.com/XXX/XXXWhen page is erroring out, rawtrace: /var/www/vhosts/GUP_EGT/XXX/XXXXThe GUP_EGT folder does exists with the same file structure as the egtgup2.egtyctest.com folder. I have other cfc function calls that are calling the correct cfc files from the correct path, but they are not bound to a cfselect or cfinput.  Any insight on this issue will be greatly appreciated. Thanks, Daniel

Does anyone know if the Developers edition can be installed in an Azure environment?And the same thing for the 30 Day free trial.  Can that be installed in an Azure environment? I know the new version is suposed to be capable of it, but can the "freebies" also be set up in a cloud environment to do some proper testing and understanding of the new features before I recommend my company to buying it. Thanks

Hello, Has anyone had success with centering or spanning the entire PDF with a header image?  When I add a header image with the code below, it is always left aligned no matter if I use the align attribute (which says it is for text) or if I increases the width of the image (it appears to be cropped). <cfhtmltopdfitem type="header" image="pathto/simple_head.png" /> I would like to use the Coldfusion to PDF capability because I need to deliver my user accessible PDF's on demand. Thanks!

Good morning CF community,       I have a new install of ColdFusion 2018 Entereprise on a CentOS 7 box, and have run into errors being thrown if on a web page that has cfstoredproc call, and the query scripts in my database procedures have a table name that is in all caps.  All table names on the database are lowercase.  My companies current live ColdFusion setup, on a webserver we are migrating from, does not have this issue.  This setup processes queries from procedures just fine, even if the table names are capitalized in their scripts.  For example, on our current live setup, if a query has: "SELECT STU_LAST FROM xx_xxx.TABLE_NAME, it processes just fine with no errors.  On the new server, it throws an 1146, Message: "Table 'xx_xxx.TABLE_NAME' doesn't exist", SQLState: 42S02, even though the table does exists but its name is all lowercase: 'xx_xxx.table_name'.  Is there a parameter I can set to ignore case senstivity from