ColdFusion in Baltimore Rotating Header Image

ColdFusion System

CFCentOS7: A Lucee (ColdFusion) and DB2 development virtual machine

CFCentOS7 is a VMWare VirtualBox image (aka, appliance) of a pre-configured Linux system for developers.

Why ColdFusion ? If you have to ask, just give it a try. It’s by far the fastest way to write code and deploy web based, database driven applications.

System configuration:

  • CentOS 7 (minimal, with yum installs, 2GBRAM, 2 core CPU which you can change): This is a version of RHEL – one of the most widely used Linux in business and government.
  • IBM DB2-C Express 11.1: Like above, DB2 is widely used and support is plenty. It can handle big data, NoSQL, and pretty much everything else. This version is free without DB size limits 15TB user limit – but 2 CPU and 16GB RAM limit, which is more than enough for most applications.
  • Lucee 5: This is the free version of the fastest way to develop and deploy web applications. I challenge anybody to develop faster apps, with less code, with more built-in security, and better performance. That equals time, which equals money. Adobe ColdFusion development license is free, but the production license does cost money.

Download CFCentOS7 VirtualBox image. (zip, 5gb compressed, 11gb expanded)

Download VirtualBox

HOWTO:

After launching the VM you will get a shell.

  • Login: root|coldfusion – all other passwords are also coldfusion
  • After login: startx
  • After GNOME starts, read the file README on desktop for configuration info.
  • Firefox is installed. Lucee admin, and a sample website are bookmarked.
  • CFEclipse and IBM DataStudio are under Applications>Programming. Both are preconfigured for the SAMPLE database and website.
  • Open the default project for CFEClipse and get tinkering.

1-10-2017 Update: Reduced disk size by removing some unneeded apps, added some development tools, converted to VBox image, and added VBox tools.

If you want a portable Lucee with MySQL, that’s here. http://www.luceeserver.nl/

And here’s another Linux Lucee VM (~700MB) for VirtualBox

 

 

Factual and ColdFusion

Here is how to use the Java driver from Factual in ColdFusion. I wish Factual would support CF. So I’m posting it for anyone to use, and turns out it’s really simple.

 

  1. You can either obtain the Java driver from Factual Github, and get all the dependencies from Maven, or you can download this complete jar package FactualJarLib. Unzip and place all the jar files in your ColdFusion lib folder, and restart the server to enable the driver. You can also dynamically load the jar files (google it).
  2. To use the driver, use the following code. You can substitute the table names and add other vars, just append them to the query string (factual_URL) as below.
  3. [coldfusion]
    <cfscript>
    // set query vars
    limit =20;
    place_type = 150;
    locality = "Baltimore";
    region = "MD";
    offset = 0;
    // create query string
    factual_url = ‘query.limit(#limit#).field("category_ids").includes(#place_type#).field("locality").includes("#locality#").field("region").includes("#region#").offset("#offset#")’;
    /// init driver, add keys
    factual = createObject("Java","com.factual.driver.Factual").init("yourApiKey", "yourSecret");
    // init Query object
    query = createObject("Java","com.factual.driver.Query").init();
    // evaluate built query string
    q=evaluate(factual_url);
    // submit string to query object
    q=factual.fetch("places", q);
    </cfscript>

    <cfdump var="#q#">
    [/coldfusion]

  4. That’s it!!!

 

 

Railux 3.3 – A ColdFusion Application Server VM Appliance

update: this version is old, newer one is here and it has MySQL and Eclipse.

update:  fixed password issue,  working on enhancements (Eclipse, mySQL, etc)

With the release of Railo 3.3,  we now have Railux 3.3! This version is built on Damn Smal Linux (DSL) and is a base version with almost no configuration other than Railo with Tomcat.  This is so that you can customize it any way you wish.  It’s fast and light-weigth. You can also use this as a plain Tomcat server.

(more…)

Railux: A Railo ColdFusion CFML Virtual Appliance

This is the older version of Railux, but has Apache and MySQL. For the ligthweight new Railux with Railo 3.3, go to http://blog.thesitestudio.com/?p=79

Railo Appliance, Railux, is an Apache/Tomcat/Railo stack on Ubuntu Linux and Railo 3.2 on Tomcat. Based on the BitNami Apache-Tomcat Appliance, it’s a fully functioning Railo ColdFusion Server Appliance that could be used for production or development.

Version information
– Railo 3.2 (CF 9.0 compatible)
– Apache 2.2.16
– Tomcat 6.0.29
– MySQL 5.1.50
– Java 1.6.0_22
– Samba server (latest via apt-get)
– UFW Firewall (latest via apt-get)
– Nano editor (latest via apt-get)

Usernames, passwords, and other information
– For Linux: bitnami:bitnami
– For Tomcat: manager:bitnami
– For Railo: istanbul
– For Samba: coldfusion:istanbul
– For mySQL: coldfusion:istanbul
– Hostname: Railux
– IP Address: DHCP Configured
– Railo Homepage: http://railux (you will need to add the IP and name to your host file)
– Tomcat Manager URL: http://railux/manager
– Installation folder: /opt/bitnami

How to get it
Download image (717MB)
– Extract the contents folder to your drive

How to use it
– Double click bitnami-tomcatstack-6.0.32-0-ubuntu-10.10.vmx in the extracted folder to start the appliance (you must have VMWare or VMWare Player, get the player free here)
– There is no need to login to the console to use Railo. After start up, you can either go to the IP address displayed on the console window or go to http://railux to view the Railo homepage. From there you can access the Railo admin
– The Site Studio website is provided as an example under http://railux/tss
– To upload your website, go to the samba share on \railuxcoldfusion
– You can delete the TSS folder if you like but do not delete anything else
– To make the default page your home page (e.g. http://yourdomain.com), you must add a Virtual Host to Apache , then  create a domain in your hosts file or on your network’s DNS server and point it to railux so you can access it
– The conf file is in /opt/bitnami/apache2/conf/httpd.conf
– Restart Apache when done by running the control script by sudo /opt/bitnami/ctlscript.sh restart apache

Future Features
– Add Mura and other CF apps
– Improve management
– Reduce image size
– Add other VM formats

If you have questions or feedback, contact me ozzy@thesitetudio.com