CBSecurity Demo Gallery does not run

GavinBaumanis · February 16, 2025, 8:11pm

When attempting to use the following example application from Ortus Github:
https://github.com/coldbox-modules/cbsecurity_demo_gallery

I get the following error when I run migrate up - to create the app’s tables
(yes I know I can create the tables manually via reading the migrations - but I was trying to get it to work so that I could fix for others and then create a PR.)

And I hate things getting the better of me!


The requested class could not be found.
 The requested class 'com.github.vertical_blank.sqlformatter.SqlFormatter' could not be found in the loaded jars/directories.

I have spent about four hours, now, hours playing with the app trying to get it to run - but have been unsuccessful.

I manually installed the sqlformatter module but that didn’t work.
I also tried editing all box.json files in the app to use the latest versions - but that didn’t help either.
I tried with lucee 5 and 6

If anyone has any suggestions I would be grateful - thanks.

Here is the rest of the stacktrace:

 lucee.runtime.exp.CustomTypeException: The requested class could not be found.
        at lucee.runtime.tag.Throw._doStartTag(Throw.java:212)
        at lucee.runtime.tag.Throw.doStartTag(Throw.java:201)
        at modules.commandbox_migrations495.modules.sqlformatter.modules.cbjavaloader.models.javaloader.javaloader_cfc$cf.udfCall4(/commandbox/modules/commandbox-migrations/modules/sqlformatter/modules/cbjavaloader/models/javaloader/JavaLoader.cfc:680)
        at modules.commandbox_migrations495.modules.sqlformatter.modules.cbjavaloader.models.javaloader.javaloader_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/modules/sqlformatter/modules/cbjavaloader/models/javaloader/JavaLoader.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at modules.commandbox_migrations495.modules.sqlformatter.modules.cbjavaloader.models.javaloader.javaloader_cfc$cf.udfCall1(/commandbox/modules/commandbox-migrations/modules/sqlformatter/modules/cbjavaloader/models/javaloader/JavaLoader.cfc:123)
        at modules.commandbox_migrations495.modules.sqlformatter.modules.cbjavaloader.models.javaloader.javaloader_cfc$cf.udfCall(/commandbox/modules/commandbox-migrations/modules/sqlformatter/modules/cbjavaloader/models/javaloader/JavaLoader.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at models.loader_cfc$cf.udfCall1(/cbjavaloader/models/Loader.cfc:58)
        at models.loader_cfc$cf.udfCall(/cbjavaloader/models/Loader.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at cfml.modules.commandbox_migrations495.modules.sqlformatter.modules.cbjavaloader.models.javaloaderdsl_cfc$cf.udfCall(/C__Users_gavin__CommandBox/cfml/modules/commandbox-migrations/modules/sqlformatter/modules/cbjavaloader/models/JavaLoaderDSL.cfc:55)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:804)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at cfml.modules.commandbox_migrations495.modules.sqlformatter.modules.cbjavaloader.models.javaloaderdsl_cfc$cf.udfCall(/C__Users_gavin__CommandBox/cfml/modules/commandbox-migrations/modules/sqlformatter/modules/cbjavaloader/models/JavaLoaderDSL.cfc:43)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at system.ioc.builder_cfc$cf.udfCall2(/wirebox/system/ioc/Builder.cfc:494)
        at system.ioc.builder_cfc$cf.udfCall(/wirebox/system/ioc/Builder.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall3(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:994)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall1(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:738)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at system.ioc.scopes.noscope_cfc$cf.udfCall(/wirebox/system/ioc/scopes/NoScope.cfc:49)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall1(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:432)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at system.ioc.builder_cfc$cf.udfCall3(/wirebox/system/ioc/Builder.cfc:800)
        at system.ioc.builder_cfc$cf.udfCall(/wirebox/system/ioc/Builder.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:804)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at system.ioc.builder_cfc$cf.udfCall2(/wirebox/system/ioc/Builder.cfc:581)
        at system.ioc.builder_cfc$cf.udfCall(/wirebox/system/ioc/Builder.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall3(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:994)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall1(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:738)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at system.ioc.scopes.singleton_cfc$cf.udfCall(/wirebox/system/ioc/scopes/Singleton.cfc:77)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall1(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc:432)
        at users.gavin._commandbox46.cfml.system.wirebox.system.ioc.injector_cfc$cf.udfCall(/Users/gavin/.CommandBox/cfml/system/wirebox/system/ioc/Injector.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at system.services.commandservice_cfc$cf.udfCall3(/commandbox/system/services/CommandService.cfc:1008)
        at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at system.services.commandservice_cfc$cf.udfCall2(/commandbox/system/services/CommandService.cfc:844)
        at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at system.services.commandservice_cfc$cf.udfCall2(/commandbox/system/services/CommandService.cfc:685)
        at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at system.services.commandservice_cfc$cf.udfCall1(/commandbox/system/services/CommandService.cfc:223)
        at system.services.commandservice_cfc$cf.udfCall(/commandbox/system/services/CommandService.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
        at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1776)
        at system.shell_cfc$cf.udfCall4(/commandbox/system/Shell.cfc:865)
        at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:804)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at system.shell_cfc$cf.udfCall3(/commandbox/system/Shell.cfc:680)
        at system.shell_cfc$cf.udfCall(/commandbox/system/Shell.cfc)
        at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
        at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
        at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
        at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
        at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
        at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
        at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1795)
        at users.gavin._commandbox46.cfml.system.bootstrap_cfm$cf.call(/Users/gavin/.CommandBox/cfml/system/Bootstrap.cfm:165)
        at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1057)
        at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:949)
        at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:930)
        at j3lh5ynvlgtz.call(Unknown Source)
        at lucee.runtime.compiler.Renderer.tag(Renderer.java:107)
        at lucee.runtime.compiler.Renderer.script(Renderer.java:97)
        at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:65)
        at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:220)
        at cliloader.LoaderCLIMain.execute(LoaderCLIMain.java:339)
        at cliloader.LoaderCLIMain.execute(LoaderCLIMain.java:158)
        at cliloader.LoaderCLIMain.main(LoaderCLIMain.java:595)

lmajano · February 17, 2025, 9:47am

@elpete Can you help Gavin out. This is the quick auth template.

CBSecurity Demo Gallery does not run

Latest Ortus News

GIVING BACK

HARVESTING IN SPANISH

WOODSEDGE