ColdFusion

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

Hello - I am having difficulty installing the ajax package. The package I'm trying to install is ajax (2021.0.02.328618) and I've tried using CFAdmin and cfpm. Is there anyone that has run into a similar problem? I'm running CF2021 on Windows server 2016.  thanks

A part of a Google pay implementation we need to attach a certificate .PEM file and key to a CFHTTP request. It seems some envoronments like Node can do a HTTP POST and specifiy such files. Is this possible in CFML? Unless we do a CFHTTP POST with a specific .PEM file, the request is rejected. Help appreciated.

Is it possible to throw site wide error of each unique type only once? Using CF 2016 . The website application has on error exception handling mechanism used in Application.cfc. The site encounter ed a SQL injection attempt and numerous error sent like mail flood.Can we handle without using any black list table creation in such a way that the spam kind of mail throw only once in a day? Also, genuine error mails are not prevented.Any suggestion is appreciated.

I have an Azure Container Instance service and deployed the Docker service there. Now ColdFusion server is running on the Docker service. Now I want the ColdFusion log through the Docker and Container Instance.Currently, I mapped between Azure Container Instance and Log Analytics workspace. And I got the Container Instance log. But I can't see the Docker or ColdFusion log.Can anyone help me to get the ColdFusion log using the Azure Container Instance and Docker? Please give me the same example or any documentation.let me know if you want more information.

Is there an upgrade path from ColdFusion 11 to ColdFusion 2021 using an upgrade?

I'm totally stumped! Some users are having a problem with our site because CF can't seem to maintain the session. The users keep saying their browsers are set to accept cookies but CF, for some reason, can't read them. I am having a hard time diagnosing the problem because I can't recreate it. The website is accessed from two domains and the problem is only encountered when someone tries to place something in the shopping cart. The domains are: nottinghillnotes.com nottinghillnotes.co.uk One user was kind enough to spend some of his time helping me. Here's what we have so far... This particular user has Safari on a Mac (we've also received complaints from users with IE 6) He verified his browser is set to accept cookies and even sent me a screenshot... Screenshot 1 - Cookies in the Safari Browser I had the user browse to a test page that just dumps out the cookie structure using the cfdump tag. The request sent to the webserver included the proper cookies. Here is part of

We have been using cffile upload for many years without issue, but we have a problem with text files that get uploaded sometimes with a charset of "utf-8 with BOM". The BOM characters at the beginning of the file are interfering with the processes we do on the file. I don't see a way to change the encoding during the upload process, and I think one option might be to use cffile to read it back, change the charset, then write it back out to disk. I wonder if there is an easier approach... Tom

We are having a great deal of trouble getting a ColdFusion Enterprise web app to upload or download from Azure Blob Storage over TLS/SSL. Storage is connectable by other methods such as remote copy with an SAS key, and is on the same virtual network as the web app service. We have a different instance of the app that was eventually able to connect, upload and download: after a lot of trial and error, we added the server's own certificate and the Root CA of the Blob Storage endpoint's certificate to Azure's TLS/SSL Settings, and suddenly everything worked great. On the problematic server, the security restrictions are a bit tighter, and it uses a different set of certificates; still, we uploaded the certs to the Azure public keystore as we did on the first server, even including all the intermediary CA certs... but nothing helps. The uploads and downloads are handled by a CFC, written for CF2018, that creates Java objects to handle the connections, but the error we're getting from

Hello Everyone, i have been task with something very difficult migrating a Coldfusion 6.1 VM running on a Windows Server 2003 to a Coldfusion 2021 VM running on a Windows Server 2022. Does anyone have any experiece or info on how to do it? Is it even possible?  The Old Coldfusion Server:Server Product: ColdFusion MXVersion: 6,1,0,83762Edition: EnterpriseOperating System: Windows 2003OS Version: 5.2Java Version: 1.4.2 The New Server:Operating System: Windows Server 2022OS Build: 20348.643no Coldfusion installed yet

Folks,I've been dealing with a problem over the past month or so with one of my developers where his application is crashing my IIS server's w3wp.exe.Essentially, the application pool keeps crashing and restarting until it hits the limit of crashes within the timeframe allowed, and then stays down - resulting in a 503 error - website unavailable.According to the crash dumps that I've been able to collect - the faulting module in this case is MSVCR110.dll - and it's crashing because it's trying to read from memory that it doesn't have access to. Fault bucket 1896345861034215315, type 4 Event Name: APPCRASH Response: Not available Cab Id: 0 Problem signature: P1: w3wp.exe P2: 10.0.14393.0 P3: 57899b8a P4: MSVCR110.dll P5: 11.0.51106.1 P6: 5098826e P7: c0000005 P8: 0000000000051d70 P9: P10: Faulting application name: w3wp.exe, version: 10.0.14393.0, time stamp: 0x57899b8a Faulting module name: MSVCR110.dll, version: 11.0.51106.1, time stamp: 0x5098826e Exception code: 0xc0000005

Hi I have just installed ColdFusion 2021 locally on my Intel based MacBook pro - I am presented with the Configuration and Settings Migration Wizard and I enter my password and I get an error. I am using HomeBrew apache. Intel based Macbook Pro. This is the error I am getting: "Error","http-nio-8500-exec-6","06/12/22","21:15:32","cfadmin","'' The specific sequence of files included or processed is: /Applications/ColdFusion2021/cfusion/wwwroot/CFIDE/Administrator/enter.cfm, line: 598 "coldfusion.security.SecurityManager$UnauthenticatedCredentialsExceptionat coldfusion.security.SecurityManager.getAdminHash(SecurityManager.java:2660)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.base/java.lang.reflect.Method.invoke(Metho

 I'm using application.cfc's onError method to email me any CF exceptions that occur. Using the exception struct provided I'm able to create a somewhat detailed email message, but seems I don't have access to the same info that would normally be displayed in a CF error template, for example I want to see the lines of code that errored, to get that I would need to do a fileread on the template which seems hack-ish. Any better way to get something more like the default error handler? 

We are having issues where CFTOKEN and CFID are being passed between our users. When one user clicks on these links their session switches to the sender of the URL. How can I prevent this?I was going to add something to the application.cfc like this.<cfif (CGI.QUERY_STRING) CONTAINS "CFTOKEN"><cflocation url="Log User out and go to the login screen"></cfif>But I am worried that users may legitimately have CFTOKEN and CFID in their working URLs and it would kick them out in that scenario. Though we have added cftoken="no" in all of our cflocation tags.What is the best way to deal with this issue where sessions sometimes (?) are changed when a URL with cftoken or cfid is in the URL.

Hi all, I search for a gateway watching changes in a database (e.g. insertions of records in a table etc), as DirectoryWatcher does in a directory for files when creating / modifing / deleting them. Which of the existing CF gateways fits better to this role? or could fit with some changes???Is out there any custom made CF gateway doing it?? Thanks in advance 

I am trying to pass variable values from CFML forms to the Stripe API (Checkout API), but have not been able to find relevant documentation.  The data can be passed through hidden variables or by Javascript/Ajax.  Does anyone have any useful information on this? Thanks in advance.

I am trying to deploy a CF 11 .car file on CF 18.In the admin, I can browse to the .car file, select it, and click deploy.  The screen refreshes but none of the data sources get added? Does CF 18 allow CF 11 .car files?