ColdFusion

I'm trying to plan how to authorize users to access a page, based on the currency of their subscription payments. They might pay a typical one month in advance subscription each month, or they might pay six months or a year in advance (possibly with a discount).  I'm thinking I would control access through, for instance, "ExpireDate > today()". And I would calculate ExpireDate, based on payments. This is completely new to me, and web searches get me into software companies' software subscriptions—no how-tos. How would you handle this? I will create another table to record the user's payments.  If you know of an online resource that discusses this topic, please share! Thanks!John

I'm currently having issues with our ColdFusion 2018 Application Server in production. If we need to restart the ColdFusion 2018 service or the server reboots after patching, the SQL Server DSN fails to connect to the database with the message that it "Timed out trying to establish a connection." The only way we have found to resolve this issue is to delete the DSN and recreate it. The operating system is Windows Server 2016 and the Java JVM is Java SE 11.0.12. Our instance of ColdFusion is up-to-date with current patches. The database is SQL Server 2019. We are using a trusted connection to the database (i.e., the ColdFusion AD service account has a login entry in the database).We are running ColdFusion 2016 in development and connecting to SQL Server 2019 and do not have these issues. We have various other DSNs that connect to an Oracle 19c database and none of these DSNs experience connectivity issues after service restart or server reboot. It is only the SQL Server.

I am trying to troubleshoot some issues related to User Management and the new IDP/SP pages of the administrator.I created a user and granted access to Security > SAML in the user manager.  Saved the user and when I log into the account, it shows only IDP/SP pages.  However, when I click on a IDP or the button Add IDP or even the simialr ones in the SP configuration, I get the below lol.  Is there anyone whom fixed this?  Currently on CF2021 without the first patch..   Forbidden PageYou do not have permission to access the requested page. Please contact your administrator.

Bonjour,Ma question est simple :Quand, pour la première fois, je vais chercher un fichier : <CFINPUT type="file" action = "upload" name="Aut_photo" value="" size="50" accept="image/jpg, image/jpeg, image/gif"><br>Pas de problème ! cela affiche, à côté du bouton "Parcourir", le nom du fichier !Par contre, quand je veux consulter cette donnée à nouveau :<CFINPUT type="file" action ="read" name="Aut_photo" value="/../../#session.site#/_Editeurs/#get_clients.Societe#/#MajAuteurs.Aut_Nom#/Auteur/#MajAuteurs.Aut_photo#">Je n'ai plus aucune trace de ce dernier. J'ai le bouton "Parcourir" et la mention "Aucun fichier selectionné".Merci d'avance pour votre aide. Hello,My question is simple:When, for the first time, I go to look for a file:<CFINPUT type = "file" action = "upload" name = "Aut_photo" value = "" size = "50" accept = "image / jpg, image / jpeg, image / gif"> <br>No problem ! this displays, next to the "Browse" button, the name of the file!On t

I'm trying to create a new instance using the CF2018 instance manager. I can see that the new instance folder is getting created and files were copied but the webpage never comes back to say that the process was completed. It happens whether I choose to create the windows service or not. I don't see any errors in the CF or Windows logs. I'm not sure what is supposed to happen once the folder is created and populated. Also, is there a way to manually install instances in CF2018?

Hi, The company has an application that stores the content of files uplaoded into an sql database table allowing for the content of those files to be rebuilt and downloaded as required using cf code.The code works perfectly in the application running cf9.1 on a window 2008 server When I run the identical code pointing to the same database running cf2021 on a windows 2016 server  the files are generated successfully however when they are opened they either generate an error within the default application used to open the file determined by the file extension  (eg ms word, xls, msg, etc ) and or advises there are permission errors preventing the file to be opened. Can anyone shed some light on what may be causing this and a possible solution Just recapping the cfm page generating the file, and the sql database, table, and the record being  used are idetical in both examples. The ony differnece is the working solution is running cf9.1 on windows server 2

I have a DB with a date field that I need to update periodically. I'd like to set a date on the same template where I insert the record.  I run my insert query, then run a select query for maxID to get the data row. I set a session variable with a calculated date, and I want to "set" that date in the field with an update query. In the following code, setting the value as "2021-09-17" will update the field, as I desire. But, if I try to use my session variable for the update, it doesn't work. I've tried every variation on syntax I can conceive of, and nothting works.  After the form action, debugging on my page shows that the variable exists and holds a value. Is there a chance that it doesn't get set before the update query fires?  <!--- Set ExpireDate column ---> <cfquery datasource="#APPLICATION.dsn#"> UPDATE tbl_user <!---SET ExpireDate = "#session.ExpireDate#"---> SET ExpireDate = "2021-09-17" WHERE U

Hello I recently upgraded my office coldfusion11 server to the coldfusion 2021 server.  Once the upgrade took place I was no longer able to access the coldfusion admin interface. I currently configured the site to run on IIS. I have attached a screenshot of the error I am getting.  Any feedback or help is greatly appericated.  Thank you. 

I'm having issues with creating a useable docker container for a ColdFusion 2021 app. I can create the container, but everytime it is rebuilt I have to reinstall all of the modules (admin, search, etc.). This is an issue because the site that the container will be housed on will be rebuilding the container everyday. The container is being built with docker-compose. I have tried using the installModule and importModule environmental variables, running the install command from the Dockerfile, building the container and creating a .car file to keep the settings, and disabling the secure mode using the environmental variables. I have looked at the log, and all of the different methods used to install/import the modules are actually downloading and installing the modules. However, when the container first starts to spin up there's a section where the selected modules are installed (and the modules that are not installed are listed). That section is followed by the message that the

I'm having issues with creating a useable docker container for a ColdFusion 2021 app. I can create the container, but everytime it is rebuilt I have to reinstall all of the modules (admin, search, etc.). This is an issue because the site that the container will be housed on will be rebuilding the container everyday. The container is being built with docker-compose. I have tried using the installModule and importModule environmental variables, running the install command from the Dockerfile, building the container and creating a .car file to keep the settings, and disabling the secure mode using the environmental variables. I have looked at the log, and all of the different methods used to install/import the modules are actually downloading and installing the modules. However, when the container first starts to spin up there's a section where the selected modules are installed (and the modules that are not installed are listed). That section is followed by the message that the

Hi Everyone, I have a few kiosks that I use this code for and over the last few days I keep receiving this error "Element upload-id is undefined in a CFML structure referenced as part of an expression." on line 93 which I have in bold and Italic. Nothing has changed at all with those code. Here are a few lines from it before and after the error.  </cfoutput><cfhttp url="#baseurl#/api/recipients/upload" method="post" result="uploadresult" ><cfhttpparam type="header" name="Authorization" value="Bearer #token.access_token#" /><cfhttpparam type="FormField" name="stage" value="1" /><cfhttpparam type="FormField" name="updateAll" value="1" /><cfhttpparam type="FormField" name="uniqueUploadId" value="#result['upload-id']#" /></cfhttp><!---cfdump var="#uploadresult#" / ---><cfoutput>Requesting stage 3 processing<BR></cfoutput><cfhttp url="#baseurl#/api/recipients/upload" method="post" result="uploadresult" >&

CF Version: 2021 Enterprise (Licensed)Operating System: Windows 2016 (x64 in Azure)Web Service: IISWhen I attempt to run a .cfm file using cf.bat, it gives the error below.  It seems to error out because it can't contact adobe, however it is behind a very strict network, it might as well be offline.  Is there a way to get past the license check, since the service is already licensed?cf-cli>e:\webroot\scheduled_jobs\nll\index.cfm Aug 13, 2021 23:37:51 PM Error [main] - Unable to install WatchService package: coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Security service is not available. SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". SLF4J: Defaulting to no-operation (NOP) logger implementation SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Security service is not available. cf-cli>Aug 13, 2021 23:38:33 PM Error [Thread-2] - Faile

(CF2016 Update 17) Hi, I've used #CGI.http_referer# on and off for many years. On my recent use I noticed that part of the URL's were missing Example if  link from the local host to the domain and try to log in, I get part of the link http://127.0.0.1/ but not the full link I came from http://127.0.0.1/sometest/testrefer.html for example I just tried it on the local host to the local host and that worked fine. I have some servers on a load balancer and in the past I'd lost some info as the ISP didn't pass it through but this server is not on the balancer so I know that is not the issue Does anybody know where I might look to resolve this? Thanks

I have ColdFusion 2018 Update 11 installed on the Windows server. This ColdFusion uses a Tomcat version 9.0.41 as a connector . Is it any way to upgrade tomcat version 9.0.46 internally without upgrading ColdFusion 2018 Update 11?And also if there is way then ColdFusion 2018 don't have any compatibility issue, It should run smooth on Tomcat 9.0.46 because I am having old ColdFusion code.Any suggestion please help.Thanks.  

System Information:MACOS: Catalina 10.15.7 Docker DEV Envirment – MSSQL + Coldfusion:FROM mcr.microsoft.com/mssql/server:2019-latestCFENGINE: adobe@2021 Context:Recently updated docker software and now dev envirment won't complete build. Worth noting this used to work prior to the update but there was a few unrelated changes that needed to be made - i.e. the MSSQL image needed to be pulled from a new repository. Once I changed the DockerFile FROM microsoft/mssql-server-linux:2017-latest to the newer repository... FROM mcr.microsoft.com/mssql/server:2017-latest the "docker-compose up" build process worked up until initiating the database. The build is now stuck on this Terminal message and never completes:cfml_1 | WARNING: org.xerial's sqlite-jdbc is not loaded.cfml_1 | Please provide the jar on your classpath to parse sqlite files. cfml_1 | See tika-parsers/pom.xml for the correct version.database_1 | 2021-07-19 21:34:50.

We attempted to upgrade from Coldfusion 11 to 2018 today and we are now getting  our cross-origin requests blocked by Chrome. Reverting back to CF11 (changing no settings in IIS, just switching the connector) we have no problems. So, my question is this: What has changed in the Rest Services served by CF2018 so that cross-origin requests would start getting blocked when the same code served by CF11 works fine? And, what, if anything, might be done to get around this issue?

I have a server with 4 instances set up with the CFadmin Instance Manager.All is well, but when I try to get a user count, you only get the count on your logged in instance.I'm trying to log in to a specific instance, any suggestions? -Chuck   

Hi Team,We  are  using ColdFusion 2016 Services in one of  the application. We observed that service is  not starting automatically even after  mutiple restart . Could you please check and assist further on this issue Please find the error  log for the same and let us know in case ofany further logs required.  RegardsHemanth 

Hi,The JSON format I would like to send  is like this:{"InvoiceID": "12345",  "InvoiceLine": [{"Description": "Item1", "Quantity": 1, "LineTotal": 20} ,                            {"Description": "Item2", "Quantity": 2, "LineTotal": 15} ]} I tried to create the above by <cfset LineInfo =' {"Description": "Item1", "Quantity": 1, "LineTotal": 20} ,                            {"Description": "Item2", "Quantity": 2, "LineTotal": 15} '>This is done after some looping to find out the number of lines I have.  <cfscript>myStruct= {"InvoiceID": "12345",  "InvoiceLine": [#LineInfo#]}</cfscript> Then, #serialize JSON(myStruct)# becomes{"InvoiceID": "12345", "InvoiceLine": ["{\"Description\": \"Item1\", \"Quantity\": 1, \"LineTotal\": 20} ,             

Hi, Just wondering if anyone has any experience of upgrading the Microsoft SQL Server driver from the Adobe one to the Microsoft one and if there was any improvement in performance. We did it but ran into issues with identity fields not being returned from insert queries but if there was a noticeable improvement in performance from them its something we would revisit. Thanks,Paul

Want to migrate from CF2016 to CF2021.  Have 2021 developers version with update 1 running.  My site has many cflayout tab areas with cflayoutarea tags for each tab.  These layouts are bound to dropdowns.  When another dropdown selection is made CF returns the following error: Component with the name tabname already exists.  Please use unique names for all the components.  Layout will not be rendered. If i remove the name= property in the cflayout then no tabs are rendered, so name is needed.  The page has one name for each tab and worked just fine in CF2016. Coding unique names seems like it shouldnt be needed for each time the dropdown is selected. Any suggestions?

I have been using ColdFusion 2016 for about 5 months without problem. Two days ago I suddenly could not access the built in server, receiving such messages as:127.0.0.1 refused to connect. in Opera and ERR_CONNECTION_REFUSED in Chrome.I thought it could be a firewall issue, since when booting up I saw a message saying that another app (Akamai NetSession)  was being blocked and that Windows Firewall had made some changes. However on checking the firewall, ColdFusion Server is being allowed through (as are Opera Chrome, etc).I tried to start CFServer from a command prompt, but after navigating to the bin directory and typing ColdFusion.exe start I got no message of any kind.I am on port 8501 with the server (8500 was used by and old version of CF11) but have never had any running problems.I noted that the IIS start page appears on 127.0.0.1 when I checked the relevant options - so localhost is not completely disabled.I am not an expert on server issues. Anyone any ideas? Thanks in a

I ran into an issue where a condition (CFIF) that should be true is returning false. I'm hoping someone has a nifty answer to this. Here's some code I created to demonstrate the test:<cfif url.userid is "session.userid"> <!--- Condition True ---> My test is <cfif url.userid is "session.userid"><br><br> url.userid IS equal to session.userid<br><br> The values are:<br> url.userid = <cfoutput>#url.userid#</cfoutput><br> session.userid = <cfoutput>#session.userid#</cfoutput><br><br> <cfelse> <!--- Condition False ---> My test is <cfif url.userid is "session.userid"><br><br> url.userid is NOT equal to session.userid<br><br> The values are:<br> url.userid = <cfoutput>#url.userid#</cfoutput><br> session.userid = <cfoutput>#session.userid#</cfoutput><br><b

I'm installing Coldfusion 2021 on a RHEL8 server.  It is supposed to be running under Tomcat 9.0.50.  We run this succesfully on a CentOS 8 server/Coldfusion 2018.  However, RHEL, both cf2018 and cf2021 give the following message:"Error","main","08/04/21","08:52:35","","The Runtime service is not available. This exception is usually caused by service startup failure. Check your server configuration."coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available.How can I mitigate this?

Good afternoon,      CF 2018 installed on a CentOS 7 server.  I'm having what seems like a permission issue when using tag:<cfdocument>, PDF generated file.  The error report indicates "java.io.FileNotFoundException" <path to PDF file> (Permission denied).  This is happening for all PDF generated files using <cfdocument>.  Has anyone had experience with granting the appropriate permissions to generate these PDF files on linux?  I'm guessing the ColdFusion user needs to be granted the appropritate permissions to generate the file, or this is something having to do with the way the hosted server is setup in regards to network security.  Any insight will be much appreciated. Thanks, -Daniel