Coldfusion 2011 / 2018 Datasource to MSSQL AG Fail...

ImageLine · ‎Dec 17, 2019

Hi. We have set up a SQL 2017 failover cluster (active/passive). We have created the datasource in ColdFusion to the IP of the AG database and it's all OK. If i switch the SQL servers all old request from coldfusion remain suspended (new request go to the active server). I found in MS documentation how to set JDBC driver in HA: https://docs.microsoft.com/en-us/sql/connect/jdbc/jdbc-driver-support-for-high-availability-disaster-recovery?view=sql-server-ver15 But it seems that it cannot be done with the native coldfusion JDBS driver for MSSQL. I've to use the MS JDBC Driver (acctual version 7.4.1.0)? It's supported? Or there's a way to use the multiSubnetFailover in the coldfusion native driver?

ImageLine · ‎Jun 18, 2019

Thank you Charlie, here my answers: 1) The code is located under cfusion/wwwroot (/Applications/ColdFusionBuilder2018/ColdFusion/cfusion) 2) I'm trying to adapt the server enviroment (cf11/Suse) where the code is currently developed. There we have apache and cf11 and some folders are mapped with sym links. Sym link "il_shared" path is /Applications/ColdFusionBuilder2018/ColdFusion/cfusion/wwwroot/sharedcode/il_shared 3) Because I wasn't able to navigate from browser to the directory mapped, so (according to the tomcat documentation) I added in context.xml <Resources allowLinking="true"/>. After that I was able to navigate to the mapped folder 4) Yes I'm referring to the CF+tomcat bundle in cfbuilder to run my application and I'm able to navigate to the mapped folder (after enabling allowlinking). The site I'm trying to launch is located in wwwroot/sites/site1 and the mapped folder is located in wwwroot/sharedcode/il_shared. The cfbuilder server is started and running on port 8600 and the url I launch is: http://localhost:8600/sites/site1/default.cfm and as I said earlier I can navigate to http://localhost:8600/il_shared. The error I get is: Could not find the included template /il_shared/global_application.cfm. The error occurred in /Applications/ColdFusionBuilder2018/ColdFusion/cfusion/wwwroot/sites/site1/Application.cfc: line 26 26 : <cfinclude template="/il_shared/global_application.cfm"> 5) I checked and I've no Coldfusion in opt folder, and to recheck I put a simple .cfm file in the folder I mentioned and, after commenting Application.cfc, It runs as expected. Thanks in advance for your help. Massimo

ImageLine · ‎Jun 17, 2019

Hallo, I installed CFB2018 on my mac and trying to run my application. In application.cfc i have a <cfinclude template="/adirectoryunderwwwroot/fileincluded.cfm"> and always i get a could not find the template error. Some informations: -The code directory is under wwwroot folder -The path is mapped with a sym link. -CFB2018 server is Coldfusion+Tomcat version and i changed the context.xml file to allow linking. -CFB2018 server document root is under wwwroot folder -When i try to navigate to the path using the browser I can reach that folder (so I think tomcat is correctly setup) -I passed a chmod 777 on all files under the wwwroot -I unchecked save class in the server admin console -I tried with and without mapping in coldfusion and it doesn't change the behaviour. Do you have any advice?

ImageLine · ‎May 17, 2019

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.properties i added a new worker in the worker list (example name: "newworker") and i defined it in this way: worker.our-cf-instance.type=ajp13 worker.our-cf-instance.host=localhost worker.our-cf-instance.port=9151 worker.our-cf-instance.connection_pool_timeout=60 worker.our-cf-instance.max_reuse_connections=250 worker.our-cf-instance.connection_pool_size=500 worker.our-cf-instance.lbfactor=1 worker.our-cf-instance.route=newworker 2) uriworkermap_our-cf-instance.properties (in /opt/coldfusion2018/config/wsconfig/1/) i set the new worker for /rest/* /rest/* = newworker ---- It works, now the endpoints are reachable through port 80, and apache matches requests containing "/rest/*" and routes them to port 9151 (ajp of API Manager Proxy) i would like to know: it's this the best way? could it introduce some security issues? is there a better way to achieve that? Thank you

ImageLine · ‎Feb 14, 2018

Thanks Jamo, we've already heard about GraphicsMagick, but we'd like to solve the issue within the standard CF code

ImageLine · ‎Feb 14, 2018

We made several tests both with jpg and png images and different color profiles, the attached image is a sRGB png. Here is the code:  <cfset imageObject = ImageRead("#imgPath##newImg#")>  <cfset ImageSetAntialiasing(imageObject,"on") /> <cfset ImageScaleToFit(imageObject,imgMaxW,imgMaxH,"mediumQuality") />  <cfset ImageWrite(imageObject,"#imgPath##newImg#",true) />

ImageLine · ‎Feb 13, 2018

We’re experiencing an important issue on our CF11 server: when we try to resize an image, it changes its appearance to a negative/posterized image (e.g. see attached images). We tried both with ImageResize/ImageScaleToFit functions and cfimage tag, and we also made several tests by changing the interpolation and the other options value. Further more, we have 4 different CF instances on the same server, with pretty similar configurations and with exactly the same Java version (1.8) and libraries, but we have this issue only on one of them and it start to appear few weeks after the previous reboot, so we need to restart again the instance to avoid the problem. Can you please provide a solution or suggest any other way to solve this issue?

ImageLine · ‎Dec 13, 2016

Hi Charlie I do what you suggest, i take my time becuase this is the production machine and i cannot stop it in prduction time. I rollback all the hotfix installed, can't go back more than hotfix 003 because it's inside the first installation i did. After that i install again all hotfix, 1 to 1 (004, 005, 006, 007, 008, 009, 010). The "problem" is not solved, the application.log is full off that: "Error","scheduler-2","12/13/16","14:34:58",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-0","12/13/16","14:35:17",,"" "Error","scheduler-1","12/13/16","14:36:57",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" "Error","scheduler-2","12/13/16","14:40:48",,"" I put "problem" inside " because the machine is working correctly and don't give any error, only log this al the day. Hi Cristian

ImageLine · ‎Dec 13, 2016

Hi, We are using <cfdocument> tag to generate ~50 pages pdf with styled text only (no images). Sometimes the library unexpectedly stop working and the pdf generation hangs forever. We are forced to restart ColdFusion to make it working properly again. Can you suggest us a way to debug the underlying java library (icebrowser,iText) to collect some useful information about the circumstances that causes the problem? Some additional server data: SUSE Linux Enterprise Server 12 on VMware Server Details Server Product ColdFusion Version 11,0,09,299201 Edition Enterprise Operating System UNIX OS Version 3.12.28-4-default Update Level /opt/coldfusion11/cfusion/lib/updates/chf11000009.jar Adobe Driver Version 5.1.3 (Build 000094) JVM Details Java Version 1.8.0_25 Java Vendor Oracle Corporation

ImageLine · ‎Feb 10, 2016

Hello Charlie, thank for the reponse The messages in the logs are going on day by day, something like 700 messages in one day for the 3 logs that i write before. From the first post, there is nothing new, i applied update 7 but nothing change and i continue to get those errors in log. 1) Thank you for the explanation, i already know what you say about this “scheduler”. 2) I checked everything as you say, i find something in the installations log: --------------------------------------------------- ############### hf-11-00004 ############### --------------------------------------------------- /opt/coldfusion11/cfusion/hf-updates/hf-11-00004/Adobe_ColdFusion_11_Update_4_Install_11_13_2015_15_42_15.log Summary ------- Installation: Unsuccessful. 363 Successes 0 Warnings 0 NonFatalErrors 1 FatalErrors Action Notes: Failed to copy hotfix files:/tmp/577245.tmp/dist/cfusion: Failed to copy the hotfix files to the target location. Retry installation after ensuring that the server is not running or files are not locked by the server. Install File: /tmp/692619.tmp/dist/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Status: SUCCESSFUL Failed to copy hotfix files:/tmp/577245.tmp/dist/cfusion Status: FATAL ERROR Additional Notes: FATAL ERROR - Failed to copy the hotfix files to the target location:/opt/coldfusion11/cfusion FATAL ERROR - /opt/coldfusion11/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe (File di testo occupato) --------------------------------------------------- /opt/coldfusion11/cfusion/hf-updates/hf-11-00004/Adobe_ColdFusion_11_Update_4_Install_11_13_2015_15_42_15.log Summary ------- Installation: Unsuccessful. 363 Successes 0 Warnings 0 NonFatalErrors 1 FatalErrors Action Notes: Failed to copy hotfix files:/tmp/692619.tmp/dist/cfusion: Failed to copy the hotfix files to the target location. Retry installation after ensuring that the server is not running or files are not locked by the server. Install File: /tmp/692619.tmp/dist/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Status: SUCCESSFUL Failed to copy hotfix files:/tmp/692619.tmp/dist/cfusion Status: FATAL ERROR Additional Notes: FATAL ERROR - Failed to copy the hotfix files to the target location:/opt/coldfusion11/cfusion FATAL ERROR - /opt/coldfusion11/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe (File di testo occupato) --------------------------------------------------- ############### hf-11-00005 ############### --------------------------------------------------- /opt/coldfusion11/cfusion/hf-updates/hf-11-00005/Adobe_ColdFusion_11_Update_5_Install_11_13_2015_16_02_48.log Summary ------- Installation: Unsuccessful. 388 Successes 0 Warnings 0 NonFatalErrors 1 FatalErrors Action Notes: Failed to copy hotfix files:/tmp/049431.tmp/dist/cfusion: Failed to copy the hotfix files to the target location. Retry installation after ensuring that the server is not running or files are not locked by the server. Install File: /tmp/049431.tmp/dist/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Status: SUCCESSFUL Failed to copy hotfix files:/tmp/049431.tmp/dist/cfusion Status: FATAL ERROR Additional Notes: FATAL ERROR - Failed to copy the hotfix files to the target location:/opt/coldfusion11/cfusion FATAL ERROR - /opt/coldfusion11/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe (File di testo occupato) --------------------------------------------------- ############### hf-11-00006 ############### --------------------------------------------------- /opt/coldfusion11/cfusion/hf-updates/hf-11-00006/Adobe_ColdFusion_11_Update_6_Install_11_13_2015_16_05_50.log Summary ------- Installation: Unsuccessful. 393 Successes 0 Warnings 0 NonFatalErrors 1 FatalErrors Action Notes: Failed to copy hotfix files:/tmp/187201.tmp/dist/cfusion: Failed to copy the hotfix files to the target location. Retry installation after ensuring that the server is not running or files are not locked by the server. Install File: /tmp/187201.tmp/dist/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Status: SUCCESSFUL Failed to copy hotfix files:/tmp/187201.tmp/dist/cfusion Status: FATAL ERROR Additional Notes: FATAL ERROR - Failed to copy the hotfix files to the target location:/opt/coldfusion11/cfusion FATAL ERROR - /opt/coldfusion11/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe (File di testo occupato) --------------------------------------------------- /opt/coldfusion11/cfusion/hf-updates/hf-11-00006/Adobe_ColdFusion_11_Update_6_Install_11_13_2015_16_09_10.log Summary ------- Installation: Unsuccessful. 393 Successes 0 Warnings 0 NonFatalErrors 1 FatalErrors Action Notes: Failed to copy hotfix files:/tmp/125792.tmp/dist/cfusion: Failed to copy the hotfix files to the target location. Retry installation after ensuring that the server is not running or files are not locked by the server. Install File: /tmp/125792.tmp/dist/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Status: SUCCESSFUL Failed to copy hotfix files:/tmp/125792.tmp/dist/cfusion Status: FATAL ERROR Additional Notes: FATAL ERROR - Failed to copy the hotfix files to the target location:/opt/coldfusion11/cfusion FATAL ERROR - /opt/coldfusion11/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe (File di testo occupato) --------------------------------------------------- /opt/coldfusion11/cfusion/hf-updates/hf-11-00006/Adobe_ColdFusion_11_Update_6_Install_11_13_2015_16_09_10.log Summary ------- Installation: Successful. 406 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors Action Notes: None Install File: /tmp/503083.tmp/dist/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Status: SUCCESSFUL --------------------------------------------------- ############### hf-11-00007 ############### --------------------------------------------------- /opt/coldfusion11/cfusion/hf-updates/hf-11-00007/Adobe_ColdFusion_11_Update_7_Install_12_14_2015_13_48_24.log Summary ------- Installation: Successful. 2007 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors Action Notes: None Install File: /tmp/593159.tmp/dist/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Status: SUCCESSFUL Copy File: Source:/opt/coldfusion11/cfusion/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Destination:/opt/coldfusion11/cfusion/hf-updates/hf-11-00007/backup/jetty/webapps/PDFgServlet/Resources/bin/HTML2PDFConverter.exe Status: SUCCESSFUL --------------------------------------------------- As you see i got FATAL ERROR error in update 4 2 times, in update 5 1 times AND 2 time in update 6 But update 6 finaly goes good, and Update 7 goes good too … And it get a fatal error in an .exe file, im worknig on a Linux server, not a Windows server

ImageLine · ‎Feb 08, 2016

No response .....

ImageLine · ‎Nov 26, 2015

Hello I'm running ColdFusion 11 (11,0,06,295053) in a SLESS 12 with Apache 2.4.10 I found my logs full of messages like that: application.log: "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" "Error","scheduler-2","11/26/15","09:46:51",,"" coldfusion-out.log nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - nov 26, 2015 09:46:51 AM Error [scheduler-2] - exception.log "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException "Error","scheduler-2","11/26/15","09:46:51",,"" java.lang.NullPointerException But no error page, no users tell me something about error while their working in my sites ... How i can get more information on these errors? Thank you Bye Cristian

ImageLine · ‎Nov 26, 2015

I've found the solution : I've installed CF11 on a SLES12 And for the PDF Server to work, i need some other things: zlib-devel nss-tools libsoftokn And in the end, verify the Host Name in Jetty configuration file and in the CF Admin; in the first install i've the IP of the host in the Jetty conf file anche 127.0.0.1 in the CF admin .. it doesn't work, the must be the same.

ImageLine · ‎Nov 18, 2015

I've buy CF11 ancd want to use the PDF server, but i dosn't work. The "Verify all Service Manager" in the PDF Service page say: "Connection verification failed for PDF Service Manager: localhost Check logs for more details." I the log i found only this line (/opt/coldfusion/cfusion/logs/server.log) "Error","ajp-bio-8014-exec-4","11/18/15","14:16:03",,"Connect to 127.0.0.1:8987 [/127.0.0.1] failed: Connection refused http://127.0.0.1:8987/PDFgServlet/verify" After some google serch i found that page: https://helpx.adobe.com/coldfusion/pdf-generation-in-coldfusion.html But .... i've a SLES 12 (Suse Linux Enterprise Server) and i don't find on YAST all the libraries that this Adobe document mention. What i've to do? Whare i can find that libraries? Adobe tell me that CF 11 work on SLES 12 and i want it all work. In need the right library for my operating system and the correct instruction for made PDF server oin CF11 work on SLES 12 By Cristian

ImageLine

ImageLine

Activity

Coldfusion 2011 / 2018 Datasource to MSSQL AG Fail...

Re: Coldfusion Builder 2018 - Could not find the i...

Coldfusion Builder 2018 - Could not find the inclu...

Coldfusion with Apache, RESTful API on port 80

Re: Bug with ImageResize/ImageScaleToFit functions...

Re: Bug with ImageResize/ImageScaleToFit functions...

Bug with ImageResize/ImageScaleToFit functions and...

Re: ColdFusion 11 Application log full of "Error",...

cfdocument pdf - hangs on ColdFusion 11

Re: ColdFusion 11 Application log full of "Error",...

Re: ColdFusion 11 Application log full of "Error",...

ColdFusion 11 Application log full of "Error","sch...

Re: ColdFusion 11 - PDF Server - Linux SLES 12

ColdFusion 11 - PDF Server - Linux SLES 12