I'm always dismayed at Adobe's documentation - for a large company you'd think they would have that sort of thing buttoned up. :( In contrast I'm not sure if there is one person at Ortus that does documentation or if it's a group effort but I'd just like to say thank you for having up-to-date, concise and thorough documentation for your products. You are an example of what great software documentation looks like!

As a reminder, you can also listen to the Modernize or Die podcast several ways. https://www.ortussolutions.com/learn/modernize-or-die 🙂

Hi Folks, has anyone shimmed PHP support into the Undertow web server in CommandBox? I’m liking undertow out of the box for dev or prototyping. For Undertow, most of what I’ve found speaks from a Redhat perspective. Also saw some references to Quercus (php interpreter in a java war) being able to tie in via Undertow somewhere but am hoping to keep the rabbit holes minimized. Nginx/Apache is likely the permanent containerized solution, just not interested in dockering anything until I have had a chance to test podman as it’s replacement.

in Commandbox when I run tasks and encounter an error the message, line number, cf stacktrace and java stacktrace are printed to console. any way to disable the java stacktrace? I have yet to find any use for that long dump or stacktrace when running tasks via commandbox.

Tune in to the CFML News Podcast at 10am PDT / 12pm CDT today live on YouTube -

GOING LIVE NOW with Gavin and Eric - CFML News Podcast on YouTube -

do the CB or CbDebugger docs say anywhere how to trigger the debugger in the URL? I see a reference to it where it talks about the debug password, but nowhere that goes over what URL param should be used

if i have a lucee application running in commandbox with the dotenv module installed, is there a way to get from

server.system.environment

just those environment variables that were set via a .env file as opposed to those 'baked in' to the engine's server scope?

Hi @bdw429s Looking at https://dev.lucee.org/t/lucee-5-3-10-97-stable-release/11540 I see the following:

One of the most exciting features in 5.3.10, which should make should make everyone’s life easier when deploying Lucee servers, is improved, still experimental, native support for

CFconfig

.

• Startup Listeners, server.cfc and web.cfc :: Lucee Documentation 13

• configImport() :: Lucee Documentation 13

• add support for .cfconfig.json importing on startup 9

There are, however, a few known issues with

configImport

, datasource imports and s3 mappings don’t quite work yet

• LDEV-4255 3 - configImport isn’t importing custom args for datasources

• LDEV-4289 - configImport isn’t importing s3 mappings

Am I correct in thinking that this (at least once remaining issues are resolved) should allow for use of finalised CB docker images, whilst maintaining the ability to set certain Lucee configuration variables dynamically from environment variables?

Hi, What is the type for a foreign key to another table using Coldbox? Schema:

component {

	function up( schema, query ){
		schema.create( "characters", function(table) {
			table.increments( "id" );
			table.integer( "userid" ).references( "id" ).onTable( "users" ).onDelete( "cascade" );
			table.boolean( "deleted" ).default( 0 );
			table.boolean( "active" ).default( 0 );
			table.string( "name", 25 ).unique();
			table.integer( "xp" ).default( 0 );
			table.integer( "belt" ).references( "id" ).onTable( "belts" ).onDelete( "cascade" );
			table.integer( "wins" ).default( 0 );
			table.integer( "loses" ).default( 0 );
			table.integer( "draws" ).default( 0 );
		} );
	}

	function down( schema, query ){
		schema.drop( "characters" );
	}

}

Model:

component extends="quick.models.BaseEntity" accessors="true" {

    property name="id" type="number";
    property name="userid" type="number";
    property name="deleted" type="boolean";
    property name="active" type="boolean";
    property name="name" type="string";
    property name="xp" type="number";
    property name="belt" type="number";
    property name="wins" type="number";
    property name="loses" type="number";
    property name="draws" type="number";

    public User function retrieveCharacterByName(required string name)
    {
        return newEntity().where("name", arguments.name).firstOrFail();
    }
    
    public User function retrieveCharacterById(required numeric id)
    {
        return newEntity().findOrFail(arguments.id);
    }
    
    public struct function getMemento()
    {
        return {"name"=variables.getName()};
    }
    
}

Is this correct?

Good day! First time posting here, so if I'm missing something please let me know gently. 🙂 I've been trying to setup CommandBox to run behind IIS using BonCode. I has this working a week ago, but I made so many changes I don't know what actually made it work, but I know it can work. I think what made it work was using the BonCode installer and installing across all sites, but I have a need to run CommandBox on some sites and ACF standalone on others for now. I got my start following the directions in the video here: https://www.ortussolutions.com/blog/screencast-running-commandbox-servers-behind-iis-with-boncode That got me where BonCode was connecting to Tomcat. What was missing though is the secret key for the ghostcat update. I got that information from reading the BonCode documentation here: http://www.boncode.net/connector/webdocs/Tomcat_Connector.htm This is what I have in the CommandBox config: server.json- { "web":{ "AJP":{ "enable":"true", "port":"8079", "secret":"<secret_key_here>" } } } This is what I have in the site's BonCode config post connector installation in BonCodeAJP13.settings- <Settings> <Server>localhost</Server> <Port>8079</Port> <EnableRemoteAdmin>False</EnableRemoteAdmin> <EnableHeaderDataSupport>False</EnableHeaderDataSupport> <ForceSecureSession>False</ForceSecureSession> <AllowEmptyHeaders>False</AllowEmptyHeaders> <ModCFMLSecret><secret_key_here></ModCFMLSecret> <RequestSecret><secret_key_here></RequestSecret> </Settings> The installation done to setup the BonCode connector and handlers is using the following configuration- [Setup] installType=sites acceptLicense=1 enableRemote=0 configurePoolPermissions=1 [Handlers] installCF=1 installJSP=0 installWildCard=0 [Tomcat] server=localhost ajpPort=8079 configureServerXml=0 [Settings] allowEmptyHeaders=0 forceSecureSession=0 enableHeaderDataSupport=0 enableFlush=0 enableRemoteIpDetection=0 requestSecret=<secret_key_here> modCfmlSecret=<secret_key_here> [Sites] Site10=1 (Note: Site10 is the 10th site in my IIS which I want to configure to use CommandBox) What I end up getting is a response from Tomcat saying 403 - Forbidden, The server understood the request but refuses to authorize it. I'm missing something here, and I don't know what. Does anyone here have any experience or direction that could short circuit my endless attempts at making this work as a single site handled by CommandBox behind IIS using the BonCode connector? Or is there another way to setup CommandBox behind IIS? Thank you in advance for any advice you may have.

Gavin and Dan Card going live for the CFML News Podcast in 90 mins on YouTube - tune in and chat with the host and other viewers

Hey folks, I downloaded the latest commandbox v5.7.0 with JRE for windows. I extracted the folder and opened it, then double-clicked the box.exe there. It ran but then I got this error:

What's the fix? @bdw429s

Going Live Now!!! Gavin and Dan Card going live for the CFML News Podcast on YouTube - tune in and chat with the host and other viewers

Hi Guys When I try and use cfconfig, I get this:

CommandBox:commandbox-jre-win64-5.6.1> cfconfig export from=C:\domains\<http://cg-acf11-0-19_314546.com|cg-acf11-0-19_314546.com>\wwwroot to=api-learningassistant-local-acf11019314546_config.json

ERROR (5.6.1+00618)

Command "cfconfig export from=C:\domains\<http://cg-acf11-0-19_314546.com|cg-acf11-0-19_314546.com>\wwwroot to=api-learningassistant-local-acf11019314546_config.json" cannot be resolved.

Do I need to install something? I though

cfconfig

was part of CommandBox?

I am using:

Windows Server 2016
Commandbox: with JRE win64-5.6.1

Day 6 of 12 days of Christmas-- 2022 ITB Video Release Edition! 3 sessions related to ContentBox. Getting started with ContentBox 101, Headless CMS and then deploying to the cloud. https://bit.ly/3Pz8yfQ

maybe I have missed this in the past, but with commandox and running CF2021 I only want to install certain packages...right now I am spinning up the CB server and then going into cfadmin and manually installing the packages...can I automate that based on the export of the packages? if so how can I do that.....is it via command line and if so how? thanks all

Does the "tail" cmd work in CommandBox? It claims to be supported and has help but when I run it for a logs file in the cfusion full path (from C:\Users\...) it just returns the path I just specified for the file to tail and then returns to the cmd prompt.

I built an API following this description in the docs (probably with ColdBox 5.x). The code checks for proper authentication in preHandler(), and this worked nicely:

function preHandler( event, action, eventArguments ){
    var authDetails = event.getHTTPBasicCredentials();
    if( !securityService.authenticate( authDetails.username, authDetails.password ) ) {
        event.renderData( type="JSON", data={ message = 'Please check your credentials' }, statusCode=401, statusMessage="You're not authorized to do that");
    }
}

Today I discovered that in CB 6.6, the renderData() call seems never to run, but the unauthenticated user is allowed to proceed... using event.noRender() instead works, but I would like to know if this is a bug or a feature? :)

I'm sure it's very old news by now (especially with github copilot having been out for a while now), but I put this prompt into ChatGPT: "write a cfscript component with coldbox handlers for simple crud operations" and it... just. worked. I'm out of my reckoning. I kind of think pair programming with an AI assistant isn't going away

I mean... I asked it to re-implement itself using Node.js and it did ok. bit of a flex on its part, but I also feel like I should've seen an achievement unlock or something at that point.

itself = ChatGPT

Throwing this here in addition to Adobe channel. We are using ortussolutions/commandbox:adobe2021 I have an old ACF 9 server running as an API to our ERP system. It’s an old unsupported system that needs 32-bit COM support and ver 9 was the last one I could get to work. The system is isolated and only accessed via our internal network. Error emails stopped working a long time ago. Anyways, Starting this morning cfhttp calls to it are not passing cfhttpparams to the ACF 9 server. cfhttp( charset="utf-8", url=http://#util.getSystemSetting(EVEREST")#/item.cfc?wsdl&method=deactivate", result="item", method="POST" ) { cfhttpparam( name="itemCode", type="formfield", value=row.ITEMNO ); } This same line of code was working perfectly last week, now it is not. This is the error we are getting: The ITEMCODE parameter to the deactivate function is required but was not passed in. Root Cause: coldfusion.runtime.MissingArgumentException: The ITEMCODE parameter to the deactivate function is required but was not passed in. Have there been any updates to ACF@2021 or the commandbox docker image that could have caused an issue like this?

Going live now - Join us for the CFML News Podcast https://bit.ly/3VexTwP