ColdFusion

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.

I am running the 2023 Server Auto-Lockdown on one of my sites.  When running, it seemed fairly slow, but not horrible.  But it took multiple minutes. Now the Auto-Lockdown tool is at 100% (20 minutes), but it still has a message saying, 'Installing... App pool created!' and the bar is at 100%.  The last bits of the log are above.  Evidently the tool is very proud of creating the App pool...but doesn't seem to move on from that. Is there a way to check if the necessary changes have been made?  I need to run this on 5 other sites, just wanting to make sure it is actually doing something.   Thanks!

ColdFusion 2021 will not update through CFAdmin.  Download states "Starting Download".  However, this error is logged in cfusion/logs/update.log:  Not able to connect to Update Site: Connection Failure: Status code unavailable.

Hello:Is it possible to create car and j2ee archives from the command line?Thanks,Greg 

Hi Everyone,I am in the middle of creating a CSV file export.  I'm currently using the Java StringBuffer class to append my query data and then output the data using cfcontent.  Anyway, I noticed that the Zip Code field has removed the first leading zero.How can I modify my code to allow for the entire zip code to be displayed.  When I originally used cffile was able to wrap a variable in quotes and that preserved it.  However, I am not using cffile since it has slowed the export considerably.Also one of the address fields contained a comma that caused a blank column to be added - shifting some of my content. I replaced the comma with a blank and that removed the comma but the added column still exists.  Any idea on how to resolve that?Here is a sample of the code<cfscript>    csvExport = createObject("java", "java.lang.StringBuffer");    csvExport.append("First Name,Last Name,Address1,Address2,City,State,Zip Code,Local,Works

I've tried multiple installations now - completely new. After the configuration is complete, and I navigate to the Administrator > Settings Summary page, I get the following error: The getMachineUUID method was not found.Either there are no methods with the specified method name and argument types or the getMachineUUID method is overloaded with argument types that ColdFusion cannot decipher reliably. ColdFusion found 0 methods that match the provided arguments. If this is a Java object and you verified that the method exists, use the javacast function to reduce ambiguity. The specific sequence of files included or processed is: C:\ColdFusion2021\cfusion\wwwroot\CFIDE\administrator\reports\index.cfm, line: 191 What gives????