ColdFusion

Anyone have any experience setting up the Simba JDBC driver for Google BigQuery using service account authentication?The problem seems to be reading the file  which is defined in the OAuthPvtKeyPath which is a part of the JDBC URL. When I submit the form with the JDBC URL, Driver Class, Driver Name etc I receive the following error:java.sql.SQLNonTransientConnectionException: [Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): OAuthPvtKeyPath, OAuthServiceAcctEmail, ProjectIdAll three parameters (OAuthPvtKeyPath, OAuthServiceAcctEmail and Projectid) is part of the JDBC URL like this example from the Simba JDBC driver user manual (except from the OAuthPvtKeyPath which is the path I'm using on my Mac):jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=MyBigQueryProject;OAuthType=0;OAuthServiceAcctEmail=bqtest1@data-drivertesting.iam.gserviceaccount.com;OAuthPvtKeyPath=/Applications/ColdFusion2018/cfusion/lib/myfilewithkeys.json

Coldfusion 11. I use server monitoring, which is configured on jetty.port. How to disable http TRACE, OPTIONS methods on jetty.port?

I've recently changed from Dreamweaver CSS.5 to Dreamweaver CC.  There are a number of little differences that make a BIG difference in usability.I finally found (through an internet search) where "Search local site" is.When I attempt to close a tag with </, the autofill is almost never the tag I opened. When using block comments with <!---   --->If there is a comment IN that block comment, the color change terminates. Auto indent is really just messed up...I had to turn it off.So the basic question is....Is there a way to make Dreamweaver CC work more like Dreamweaver CSS.5?It is not my opinion that these are all "things you are used to" kind of problems.  These are changes that were made that a) don't work the way they were supposed to and b) are NOT a step forward.

Setup: CF 2016 on MS Server 2016 w/IIS 10Using Fusion Reactor trial and finding queries hanging.  Still not found an answer that directly impacts this condition. I did uncheck "save class files" restart the CF Server, rechecked "save class files" per another thread.  Does not seem to cooperate.ajp-nio-8016-exec-11" Id=160 WAITING on java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject@72e82b6c    java.lang.Thread.State: WAITING        at sun.misc.Unsafe.park(Native Method)        - waiting on java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject@72e82b6c        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)        at j

Hi all,I'm using the addons docker image as part of setting my app up for local development using Docker as well as preparing to deploy to AWS ECS.I've managed to connect to Solr from the CF Admin and I can access the Solr admin on my local machine as well.However, when I try to create a new collection, I'm getting this error:solrconfig.xml missing luceneMatchVersionIn my docker-compose.yml file I have"  addons:    container_name: mycfaddons    image: eaps-docker-coldfusion.bintray.io/cf/addons    environment:      - acceptEULA=YES      - configureExternalAddons=true      - addonsHost=addons      - addonsPort=8991      - addonsUsername=admin      - addonsPassword=admin    ports:      - "8991:8991"    networks:    &n

I'm a bit out of my league on this issue.due to a recent infrastructure change that disabled the mail relay without actually notifying of an error and left us not sending any emails for two weeks, Worse we were completely unable to rebuild the "lost" emails. I've been tasked with a way to create a local backup of all outgoing mail.  This is easy enough to do in CF, however the team wants solutions that don't use CF tags.  The specific requirements I have are either to capture and locally store the cfmail file itself, or to capture the to, from, reply, cc, bcc, subject and body using (for instance) event gateways, mail log,or any listeners or apis that might be available.The email log contains to, from and subject, but doesn't contain body, so it's not viable for us unless i am missing a setting that makes the log keep the body of the email.I'm currently researching CFMailgun, and the Mailgun API, but i need a few other options as it does have some issues that may not be palat

What is the IP limit maximum of a CF server developer edition. I just noticed that by accident I am running a dev edition on a server that responds to many web sites (multi homed under Windows IIS)These domains are speculative (about 10) and all they do is say "FOR SALE".  They also track IP of origin, unique IP's. All told about 500 inquiries a day. But WHY does it even work???  Shouldn't users or robots get an error saying maxed out based on IP addresses? I am planning on installing CF18 in the coming week, when it occurred to me ... don't fix what ain't broken ... and WHY is the IP restriction not being enforced? I thought 2 or 3 was the limit?

I have asked several Adobe support people over the years for this tiny feature but it's not in 2018 even though I was told it would be In debugging section ... where it asks what IP addresses should include debugging data on screen, and we put the IP addresses in, it would be helpful to have a description field next to it so we know whose IP address it is?Same in IIS ... no description!Unless ... ... is there a way to add a delimiter and add a description?  Like:  122.122.122.122; Stans workstation

Hi,I use the following code to consume a rest service in my local ColdFusion application (and it works fine) but I am trying to add it into the ColdFusion administrator so I can manage the rest service from the admin rather than having a URL in local code.  I then just want to simply call it from my local code.Is this possible?  How do I achieve this?-----------------------------------------<cfhttpurl="[URL goes here]?LH_ADDRESS=#parameter#"method="get"result="res"/>-----------------------------------------Many Thanks,George

Hi,a customer is going to update their Oracle and announced they are setting SQLNET.ALLOWED_LOGON_VERSION_SERVER to 12. This means the client driver has to be version 11.2 or later.In previous discussions I always sad simply use a recent Thin driver and everything's fine.I found this query that says which client you are on    SELECT DISTINCT s.client_version     FROM v$session_connect_info s     WHERE s.sid = SYS_CONTEXT('USERENV', 'SID')I run it from a cfquery tag in a ColdFusion script and everything is fine when I use a recent Thin driver, they report back version 12 or 18 or something.I also ran it in ColdFusion 2016 with Updater 10 installed. I connected to Oracle using the built in driver (Developer Edition/Enterprise). I got 11.1.0.7.0 as my client version. This is lower than the driver recommended to connect to Oracle 12 with (11.2).Does anyone have a recent Oracle running and set ALLOWED_LOGON_VERSION_SERVER to a high valu

Hi All,   ColdFusion 2018 is passing a datetime in the format '2019-05-16 23:59:00.0'The code I am using is given below<cftry><cfset fromDateObject=parsedateTime(datefrom)><cfset toDateObject=parsedateTime(dateto)><cfset fromDateTimeString=dateFormat(fromDateObject, "yyyy/mm/dd") & " " & timeFormat(fromDateObject, "HH:nn:ss")><cfset toDateTimeString=dateFormat(toDateObject, "yyyy/mm/dd") & " " & timeFormat(toDateObject, "HH:nn:ss")>  <cfstoredproc procedure="dbo.multi_report_pkg.run_multi_report" datasource="#datasource#" username="#Session.UserName#" password="#Session.password#">    <cfprocparam  value="#Session.multi_rep_id#">    <cfprocparam  value="#Session.UserName#">    <cfprocparam  value="#multi_report_def_id#">    <cfprocparam cfsqltype="CF_SQL_TIMESTAMP" value="#parsedateTime(fromDateTimeString)#">  &n

Hello,   I am using Coldfusion 2018 with Oracle Database. One of my pages in the application gives me an error as shown belowHow can this be resolved ?   I am not getting the same error on Test server where the same version of Cold fusion 2018 is installed.ThanksIQError Executing Database Query.   ORA-01858: a non-numeric character was found where a numeric was expected      The error occurred in C:/inetpub/wwwroot/TOPS/ValidateConsumptionList.cfm: line 134Called from C:/inetpub/wwwroot/TOPS/ValidateConsumptionList.cfm: line 1Called from C:/inetpub/wwwroot/TOPS/ValidateConsumptionList.cfm: line 134Called from C:/inetpub/wwwroot/TOPS/ValidateConsumptionList.cfm: line 1132 :        and dd.data_date = TO_DATE(<cfqueryparam 133 :                               &

Hi,we have installed Coldfusion 2018 with Apache web server and CF Api Manager on our SUSE server.We have many CF instances and one of these provides some RESTful services.I configured apis in the CF Api Manager and now our REST enpoints are accessible at ports 9100 and 9151 (ajp), but we want our customers to use this services with port 80 keeping other ports closed.The endpoints are located somewhere like https://our_domain1.com/rest/services/ ..So i've modify the following two Apache configuration files:1) worker.propertiesi added a new worker in the worker list (example name: "newworker") and i defined it in this way:worker.our-cf-instance.type=ajp13worker.our-cf-instance.host=localhostworker.our-cf-instance.port=9151worker.our-cf-instance.connection_pool_timeout=60worker.our-cf-instance.max_reuse_connections=250worker.our-cf-instance.connection_pool_size=500worker.our-cf-instance.lbfactor=1worker.our-cf-instance.route=newworker2) uriworkermap_our-cf-instance.properties (in /opt/co

Hi All,Anyone encountered this similar error? Scheduled job run twice. Although, it only shows once in the scheduler log, we can tell it run twice because we have our own logging as well, and data are being logged twice. Below are the other details:1. This does not happen always, but happens  intermittently.2. No other server or instance running.3. This is a long running job (3 or 4 hours average).Anyone who has idea and how you have resolved this problem? I can't seem to find any solutions online although there are similar cases reported.I hope someone from Adobe Coldfusion support can see and give advice on this as well.Thanks.

I am upgrading to CF 2018 from CF 9.In CF 9 I run the Coldfusion services under a local Windows user I create specifically for the Coldfusion services.  In Windows the c:\users\<CF Username>\AppData \Local\Temp\poifiles directory gets filled with thousands of poi-ooxml--<some number>.tmp files. Nothing in CF cleans these up and after discovering them by accident and having to clean up hundreds of thousands of these leftover files, I have one question: will this same thing happen in CF 2018?

I am limited as to what i can do with the server, however i really need to verify that the code on a particular page is calling the right url into an iframe. CF Server: Cold Fusion 11 (11,0,15,311399)Web Server: IIS  on Windows 2012 R2I cannot do the following:turn on debuggingmodify the JVMinstall packet sniffersmodify the code to write the log file directlyI've reviewed the most recent IIS and CF logs on my dev environment and i couldn't locate outgoing calls. Can any of you recommend some other options?  Is there a log level i might be able to turn on in CF that will capture this information?  What about IIS?Thanks

I have this codeExample #1<cffile action = "read" file = "./config.txt" variable = "fileContents"><cfset line1 = listGetAt(fileContents, 1, chr(10))><cfset line2 = listGetAt(fileContents, 2, chr(10))><cfset AuthKey = #mid(line1,19)#><cfset RefToken = #mid(line2,15)#><cfset contentBody = "grant_type=refresh_token&client_id=bcbb1365893&client_secret=62b5a8a84567992666tf986a3f474791e&refresh_token=9312beb987fbd8efebf6dc&scope=read%2Bwrite" /><cfhttp method="POST" url="https://api.wedoo.com/oauth2/access_token"><cfhttpparam type="header" name="Content-Type" value="application/x-www-form-urlencoded" /><cfhttpparam type="formfield" name="grant_type" value="refresh_token" /><cfhttpparam type="formfield" name="client_id" value="bcqq13f2d1d320543524"><cfhttpparam type="formfield" name="client_secret" value="62b5a8a84567992666tf986a3f474791e" /><cfhttpparam type="formfield" name="scope" value="read+write" />&

Hi all,After changing the "server.xml" to point to my new (built-in server) webroot and pointing the appropriate Resources to the CFIDE and WEB-INF folders, the CF 2018 Admin webpage becomes unusable.  The login page loads.  I am able to log in.  The buttons show up for a split second, but are then greyed out as the Search Bar becomes the only thing I can click and type in.  Typing something in the Search Bar and submitting it does nothing.  Clicking the X on the Search Bar does not close it and the other function buttons are unclickable.I am using the same 'change webroot' method outlined for CF 2016, which works great on that version.  I fear that by using this method somehow messes up the new 2018 Admin interface.  Any help or ideas would be appreciated.  Below are the code in the "server.xml" file and a screenshot of the CF Admin page...(yes, I installed CF on my 😧 drive...I like to keep things off of my Windows directory.  I am

I had a lot of trouble getting a fairly complicated site to function with CF11 on Windows 2012 (I'm moving from CF8 on Windows 2003). After several days I noticed update 1; once I applied that, I was able to get beyond the 404Now I'm trying to add a second site and I'm back to the 404s. I can access the main page with a domain name by not specifying index.cfm.http://www.mydomain.com:80/jakarta/isapi_redirect.dllDetailed Error Information:Module    IIS Web Core Notification    MapRequestHandler Handler    ISAPI-dll Error Code    0x80070002 Requested URL    http://www.mydomai.com:80/jakarta/isapi_redirect.dll Physical Path    C:\ColdFusion11\config\wsconfig\1\isapi_redirect.dll Logon Method    Anonymous Logon User    Anonymous The Configuration WizardCreated a folder 1 in cfroot\config\wsconfig, that contains all connector-related files.Created a virtual directory Jakar

I'm looking to get some hands-on experience with Azure.Can someone tell me the limitations of running CF2018 in Azure App Service vs VM? Such as, if certain CFADMIN features will not be available.

In another thread here, someone made the comment today about CF2016 that they "plan to never upgrade to it. I've read too many forum and blog posts regarding issues with it." I thought that was a pretty stunning statement, and unduly damning if asserting that many people are hitting some issue that remains unresolved. I started to offer my reply to it there, but as the reply grew in length (to cover more possibilities and offer help), I thought better of de-railing that thread from its main discussion. So I have created this new thread here and I will point there to this. I have not linked here to that thread, as I'm not trying to make this at all a personal thing toward the commenter. I just want to respond to the comment, whoever might make it. I'm sure others have made it, and I think it deserves more consideration.So to be clear, since all I do all day is CF server troubleshooting (as an independent consultant, helping about a hundred clients per year), I just want to go on record

Hello,I am trying to install an update for coldfusion 2018. I have downloaded the zip file and I am trying to follow the steps shown below for installing the update manually      Click the link to download the JAR.Execute the following command on the downloaded JAR. You must have privileges to start or stop ColdFusion service and full access to the ColdFusion root directory.    Windows: <cf_root>/jre/bin/java.exe -jar <jar-file-dir>/hotfix-003-314033.jarI am unable to do this as the file that is being downloaded is a zip file and its not a JAR file, so its not working.Can someone please advise how to install this update ?ThanksIQ

Updates for ColdFusion 2018 (ColdFusion (2018 release) updates ) appear to be unavailable. I don't see any issues on the system status page for it (Adobe Status). Is it just me?

Is there any way to use the Adobe Coldfusion AMI from the AWS Marketplace in GovCloud? The GovCloud East and West regions do not appear in the Region dropdown in the Pricing section of the page. I thought they had been available at some point in the past when I looked at it, but either I was seeing things or it's no longer an option.My company has been using Coldfusion on AWS EC2 instances for around 4 years, and we're very much interested in switching to a licensing method that allows for auto-scaling. We're hosting our apps on GovCloud due to the FedRAMP certification which helps us comply with our customers' security requirements.

I migrated my application from CF10 Enterprise to CF11 Enterprise but the chart fail to render in the webpage. It says com.gp.api.jsp.MxServerComponent is not found. I figured out that the required JAR file (wc50) is absent from Coldfusion 11.Then I found similar discussion here https://forums.adobe.com/thread/1495819 and I did the same thing - copied the required JAR's (wc50 and others which are missing in CF11). Now I can generate the report but it is coming with a visible watermark which says "Adobe ColdFusion 8 Developer Edition Not for production use".   This is surprising, because we were using CF10 earlier and that too licensed version. Then why this watermark? Any help here would be highly appreciated.