ColdFusion

I have been migrating some old ColdFusion MX 7 applications to CF2016. I am currently stuck on a code which is calling a webservice. It works without any error in MX7 but fails to find the Web service operation in CF2016.Below is how the code is written in MX7:<cfscript>//Printer validationprintername = structNew() ;printername.pid = "1221";//printername.command = "PRINTERS"&#url.branch_loc#;printername.command ="PRINTERS185";//printername.command = "PRINTERSALL"; printername.locale = "en-CA"; Application.UserWebService = CreateObject("webservice","http://weburl:9115/wsdl/WWS001.wsdl"); printerdtls  = Application.UserWebService.WWS001Operation(printername);printerdtlsreq  = printerdtls.TABLEOUT; isprntrvalid="no";for(i=1;i LTE ArrayLen(printerdtlsreq);i=i+1){tempprntrData = UCase(printerdtlsreq[i].TNAME);//writeOutput(tempprntrData & "<bR />"); }writeoutput(#ArrayLen(printerdtlsreq)#);END;</cfscript>I get list of Printer

We are setting up an SFTP connection via cfftp, and are currently receiving the following error:"Error: Session.connect: java.io.IOException: End of IO Stream Read."We have narrowed it down to the version of JSch, which is currently jsch-0.1.54. This will work if we use diffie-hellman-group-exchange-sha1 algorithm, but we need to use diffie-hellman-group-exchange-sha256, which produces the above error. Testing this outside of CF, we have managed to prove that it works successfully using  jsch-0.1.55, while returning the same error above using jsch-0.1.54.So we have been trying to update the CF FTP package to jsch-0.1.55, using the approach detailed here: https://helpx.adobe.com/nz/coldfusion/kb/apply-custom-patch-coldfusion-2021.htmlWhich somewhat usefully has this exact update as it's example. It installs without issue (and we can see the dependency shown as jsch-0.1.55 in the FTP package in the administrator), but it still continues to pick up

I'm running Windows10Pro on my development server with IIS 8.  I'm wanting to run ColdFusion server on this machine.  The site running on it will have a CF application with an Access database behind it.  Eventually, when it goes Production on another machine, the database will be MSSQL.Which version of CFusion should I install?CheersRoy 

I am curring running cf 2021, lockdown tool and performance monitoringI now want to upgrade to 2023 and keep all my settings and it looks a bit scary. Can anyone recommend the best path forward? Do I need to uninstall the 2021 lockdown and pef mon tools as there are 2023 versions of them? will they update along with the core cf install/ And what about migrating all settings? They show multiple ways so just trying to figure out what works the best. I figure they would give you the option to just migrate everything from the old.  Any advice in advance would be great. 

Hi,I was looking at some performance issues on a test server and I came across the following: Tip: Our research has shown that in some versions of ColdFusion, leaving Report Execution Times enabled while Enable Request Debugging Output was disabled would still cause ColdFusion to perform excessive background processing on every request, leading to significant overhead. It is highly recommended to disable Report Execution Times regardless of the Enable Request Debugging Output setting in your production environment. I noticed we had Report Execution Times enabled. We are using CF2018. Can anyone confirm if there is additional overhead having this enabled and should I disable it or does it not matter?Thanks

Using cf2018.The coldfusion service start, stop option are in disabled mode now and hence cf not working suddenly  Checked cf logs coldfusion out log and sever.log, but couldn't find any trace.Is there any options other than reinstall?Any help is appreciated. 

Hi,While using Select scripts in cfquery records get limited to print 9999 records only when we dump it with cfdump. We are using the below code<cfoutput> CF-MSSQL-Select scripts </cfoutput>            <cfquery name="list_customer" datasource="ohub">            Select top 10020 custid from customers        </cfquery><cfdump var="#list_customer#" label="list_customer"> When we execute this code in cfdump only lists 9999 records.Is there any way to increase the data limit to 50,000 plus?Please see the below screenshot attached. Please advise.Thank youJibin

Here is my code to encrypt and decrypt. When i change my key to decrpt ( 'Mykey1234') i stil can decrypt the string i just encrypted. The key i used to encrypt i 'Mykey12345678'. Any one can explain why this happen? <cfoutput>Encrypt : #encrypt('This string will be encrypted (you can replace it with more typing).', 'Mykey12345678', 'CFMX_COMPAT','Base64')#<cfset new_encrypt = encrypt('This string will be encrypted (you can replace it with more typing).', 'Mykey12345678', 'CFMX_COMPAT','Base64')> <br>Decrypt : #decrypt(new_encrypt, 'Mykey1234', 'CFMX_COMPAT','Base64')#</cfoutput>

Receiving vulnerability scan issue with SOLR version in ColdFusion 2022.  Seems to be 5. version and current version is SOLR 8.11Is there a way to upgrade or will Adobe add it to next CF hotfix scan showsApache Solr < 8.4.0 Remote Code Execution

Using coldfusion 2018 . The application service start,stop,restart options became in disabled mode now.Checked coldfusion out log and sever log files, but couldn't figure out why suddenly stopped. Had configured System password in its property from service. The system password is changed now.

Hi, Using cf10 and sqlserverbackend. Have around 1 lakh record to process from a table A.  Need to compare data is present in another table B in another server .If not present need to update few columns of record in table A. Looping and processing is giving timeout. Try to take valuelist for id list and do the process in 10 batch using query of query. It is giving error as parameter cannot contain more than 2100 . Please suggest better way to process one lakh record in Coldfusion  

Hi,I have Coldfusion installed on linuxOS  (as a code) on AWS instance. Trying to upgrade Coldfusion from 2018 to 2021 with the same working setting/code.After upgrade, Schedule tasks is not working. When tried to manually run a task with output file, it doesnt run at all, and no logs are captured on scheduled tasks.Scheduler package has been reinstalled, still not working.In http logs, could see entries - which means it is not permission issue.And the URL used in the task is HTTP - so not key issues. Any idea on this issue ? 

Could anybody help me with this. I have a various strings that should (unless it is passed incorrectly which is possible) contain a number at the end, but may also have numbers at the start and/orwithin the string . Example:somestring4567some123string4567123some123string4567123somestring4567 I need to split it so that I end up with the number at the end, so in the examples above the 4567 I could probably do it with a loop but I'm guessing there is a slicker more efficient way of doing it Thanks

Hi,Using coldfusion 10. Have one table insertion from Table A to Table B in a loopWith a flag=0 in TABLE B.A scheduler is running at 5 minute interval reading data in a batch of 2000  from Table B and processing it.After process, update Flag =1. When there was around 20,000 data in Table A, it inserted only around 16,000 records and stopped. Is it because of simultaneously read and write operations?What is the ideal way to avoid partial insertion?   

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.