Cfspreadsheet error

Hello,
cfspreadsheet no longer works, the error is as follows:
Lucee 5.3.10.97 Error (template)
Message undefined tag [cfspreadsheet]

In lucee administrator → component → Additional Resources
Name : cfspreadsheet
Archive: /opt/lucee/tomcat/lucee-server/context/archives/cfc/cfspreadsheet/cfc-archive-cfspreadsheet.lar
Primary: Archive
Inspect: inherit

This happened after that in cf administrator I get an update for cfspreadsheet (Leftbower version)
The current version is 3.0.3 the new version would be 3.0.3.0
I ran the update and it gave me the following error:

write access is protected
lucee.runtime.exp.SecurityException: write access is protected at lucee.runtime.config.ConfigWebUtil.checkPassword(ConfigWebUtil.java:529) at lucee.runtime.config.ConfigWebUtil.checkGeneralWriteAccess(ConfigWebUtil.java:514) at lucee.runtime.config.XMLConfigAdmin.checkWriteAccess(XMLConfigAdmin.java:186) at lucee.runtime.config.XMLConfigAdmin.removeComponentMapping(XMLConfigAdmin.java:857) at lucee.runtime.config.XMLConfigAdmin.removeArchive(XMLConfigAdmin.java:5687) at lucee.runtime.config.XMLConfigAdmin.removeRHExtension(XMLConfigAdmin.java:5453) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:4742) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:4719) at lucee.runtime.config.XMLConfigAdmin._updateRHExtension(XMLConfigAdmin.java:4701) at lucee.runtime.tag.Admin.doUpdateRHExtension(Admin.java:4349) at lucee.runtime.tag.Admin._doStartTag(Admin.java:781) at lucee.runtime.tag.Admin.doStartTag(Admin.java:364) at ext_applications_cfm184$cf.call(/admin/ext.applications.cfm:89) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at web_cfm$cf.call(/admin/web.cfm:492) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at server_cfm$cf.call(/admin/server.cfm:2) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at mod_cfml.core.invoke(core.java:180) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source)

to access the configuration without a password, you need to change the write access to [open] in the Server Administrator

OS: Linux 7.9.2009
Tomcat Version: 9.0.31
Lucee Version: 5.3.10.97

The .lar file is present in the mapped folder -rw-r----- 1 lighte lighte 76636 May 4 2020 cfc-archive-cfspreadsheet.lar :slight_smile:
-rw-r----- 1 lucee lucee 76636 May 4 2020 cfc-archive-cfspreadsheet.lar

Your problem is at the top:

“write access is protected
lucee.runtime.exp.SecurityException”

You need to correct your security permissions and you need to add a password.txt file if you want to access the web interface.

No.
I tried.
It does not change anything.
I solved it by uninstalling the extension and reinstalling it by loading the cfspreadsheet-lucee-5.lex file in the lucee-server/deploy folder
Now cfspreadsheet works, but in light of the admin proposes me to update it:
obviously I won’t do it because it offers version 3.0.3.0

Lucee 5.3.10.97 - Overview

The Server Administrator allows you to install updates and patches for your Lucee installation and to restart the engine with a mouse click. You can configure new web contexts and define restrictions and configurations per web context individual.

There are some updates available for your installed Extensions.
cfspreadsheet

I had similar situation and would caution anyone to NOT use the Lucee Admin to update this plugin as it essentially “breaks” it. Just use the drop into deploy directory as noted above.

1 Like

any know which version of Lucee updating via the admin worked with extension? (it was last updated in 2018)

Ran into the same error and after debugging for a while ended up removing the cfspreadsheet plugin all together (minimal usage in our apps thankfully).

The plugin was installed via an environment variable: LUCEE_EXTENSIONS: “037A27FF-0B80-4CBA-B954BEBD790B460E;name=cfspreadsheet;version=3.0.3”

This hadn’t changed in 2.5 years and then all of the sudden in 2023 all our builds failed. We updated the version to 3.0.3.0, which resulted in successful builds, but then Lucee threw errors later on as it apparently lost track of cfspreadsheet. It’s a pretty bizarre issue that does seem related to the versioning (3.0.3 vs 3.0.3.0).

1 Like