After Update to 23.04 Error in Preview and sending Mail

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

MikaLaurer
Posts: 35
Joined: Thu Apr 02, 2020 9:18 am

After Update to 23.04 Error in Preview and sending Mail

Post by MikaLaurer »

Hello,

I just upgraded to 23.04 Beta
I followed all steps to replace MySQL with MariaDB and even created a new database with OMT.
Still I get the following error when previewing mailings. Furthermore it's not possible to send any mailings.

All drivers are installed. I can access the database with the python console using the mariadb python connector.
My dbcfg looks fine to me as well:

Code: Select all

openemm: dbms=mariadb, name=openemm, jdbc-connect=jdbc:mariadb://127.0.0.1/openemm?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8, host=127.0.0.1, user=openemm, jdbc-driver=org.mariadb.jdbc.Driver, password=XXXXXXXX

Code: Select all

2023-07-24 14:44:57,020: ERROR [ajp-nio-127.0.0.1-8009-exec-7] org.agnitas.web.MailingSendAction - Error occurred: Database setup failed: java.lang.Exception: No configured database driver found
java.lang.Exception: Database setup failed: java.lang.Exception: No configured database driver found
	at org.agnitas.backend.Data.setupDatabase(Data.java:838) ~[classes/:?]
	at org.agnitas.backend.Data.setup(Data.java:524) ~[classes/:?]
	at org.agnitas.preview.TAGCheckImpl.<init>(TAGCheckImpl.java:48) ~[classes/:?]
	at com.agnitas.preview.TAGCheckFactoryImpl.createTAGCheck(TAGCheckFactoryImpl.java:23) ~[classes/:?]
	at org.agnitas.web.MailingSendAction.loadPreviewHeaderData(MailingSendAction.java:1392) [classes/:?]
	at org.agnitas.web.MailingSendAction.execute(MailingSendAction.java:502) [classes/:?]
	at com.agnitas.web.ComMailingSendActionBasic.execute(ComMailingSendActionBasic.java:734) [classes/:?]
	at com.agnitas.web.perm.DelegatingActionProxySecured.execute(DelegatingActionProxySecured.java:107) [classes/:?]
	at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:668) [servlet-api.jar:5.0.0]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:560) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499) [catalina.jar:10.0.20]
	at org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:301) [taglibs-standard-impl-1.2.5.migrated.jar:1.2.5-migrated-1.0.0]
	at org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:155) [taglibs-standard-impl-1.2.5.migrated.jar:1.2.5-migrated-1.0.0]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_c_005fimport_005f0(mailing_002dpreview_002dselect_jsp.java:3620) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_c_005fif_005f4(mailing_002dpreview_002dselect_jsp.java:3548) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_c_005fif_005f1(mailing_002dpreview_002dselect_jsp.java:2787) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_c_005fset_005f15(mailing_002dpreview_002dselect_jsp.java:2631) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_agn_005fagnForm_005f0(mailing_002dpreview_002dselect_jsp.java:596) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspService(mailing_002dpreview_002dselect_jsp.java:446) [ROOT/:?]
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) [jasper.jar:10.0.20]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) [jasper.jar:10.0.20]
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:380) [jasper.jar:10.0.20]
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:328) [jasper.jar:10.0.20]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:560) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499) [catalina.jar:10.0.20]
	at org.springframework.security.web.header.HeaderWriterFilter$HeaderWriterRequestDispatcher.include(HeaderWriterFilter.java:176) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:994) [jasper.jar:10.0.20]
	at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:495) [jasper.jar:10.0.20]
	at jdk.internal.reflect.GeneratedMethodAccessor189.invoke(Unknown Source) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
	at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:129) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:152) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.taglib.InsertTag.doInclude(InsertTag.java:764) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.taglib.InsertTag$InsertHandler.doEndTag(InsertTag.java:896) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.taglib.InsertTag.doEndTag(InsertTag.java:465) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.jsp.WEB_002dINF.jsp.ajax_002dresponse_002dtemplate_jsp._jspx_meth_tiles_005finsert_005f1(ajax_002dresponse_002dtemplate_jsp.java:195) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.ajax_002dresponse_002dtemplate_jsp._jspService(ajax_002dresponse_002dtemplate_jsp.java:134) [ROOT/:?]
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) [jasper.jar:10.0.20]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) [jasper.jar:10.0.20]
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:380) [jasper.jar:10.0.20]
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:328) [jasper.jar:10.0.20]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:441) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:367) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:295) [catalina.jar:10.0.20]
	at org.apache.struts.tiles.commands.TilesPreProcessor.doForward(TilesPreProcessor.java:260) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.commands.TilesPreProcessor.execute(TilesPreProcessor.java:217) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:668) [servlet-api.jar:5.0.0]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.web.filter.Struts1SecurityFilter.doFilter(Struts1SecurityFilter.java:89) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.emm.core.commons.filter.OriginUriFilter.doFilter(OriginUriFilter.java:43) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46) [ajaxanywhere-1.2.1.migrated.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.emm.core.sessionhijacking.web.GroupingSessionHijackingPreventionFilter.doFilter(GroupingSessionHijackingPreventionFilter.java:108) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.web.filter.responseheaders.HttpResponseHeadersFilter.doFilter(HttpResponseHeadersFilter.java:115) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.emm.core.commons.filter.LoadBalancerFilter.doFilter(LoadBalancerFilter.java:154) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.emm.core.commons.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:80) [classes/:?]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:10.0.20]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:10.0.20]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:661) [catalina.jar:10.0.20]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:119) [catalina.jar:10.0.20]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:10.0.20]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:10.0.20]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:10.0.20]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) [catalina.jar:10.0.20]
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:439) [tomcat-coyote.jar:10.0.20]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:10.0.20]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:867) [tomcat-coyote.jar:10.0.20]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1716) [tomcat-coyote.jar:10.0.20]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:10.0.20]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:10.0.20]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:10.0.20]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:10.0.20]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.lang.Exception: No configured database driver found
	at org.agnitas.backend.DBase.setup(DBase.java:593) ~[classes/:?]
	at org.agnitas.backend.Data.setupDatabase(Data.java:835) ~[classes/:?]
	... 156 more
mailout:db_driver is unset
mailout:db_driver is unset
2023-07-24 14:44:57,188: ERROR [ajp-nio-127.0.0.1-8009-exec-1] org.agnitas.web.MailingSendAction - Error occurred: Database setup failed: java.lang.Exception: No configured database driver found
java.lang.Exception: Database setup failed: java.lang.Exception: No configured database driver found
	at org.agnitas.backend.Data.setupDatabase(Data.java:838) ~[classes/:?]
	at org.agnitas.backend.Data.setup(Data.java:524) ~[classes/:?]
	at org.agnitas.preview.TAGCheckImpl.<init>(TAGCheckImpl.java:48) ~[classes/:?]
	at com.agnitas.preview.TAGCheckFactoryImpl.createTAGCheck(TAGCheckFactoryImpl.java:23) ~[classes/:?]
	at org.agnitas.web.MailingSendAction.loadPreviewHeaderData(MailingSendAction.java:1392) [classes/:?]
	at org.agnitas.web.MailingSendAction.execute(MailingSendAction.java:502) [classes/:?]
	at com.agnitas.web.ComMailingSendActionBasic.execute(ComMailingSendActionBasic.java:734) [classes/:?]
	at com.agnitas.web.perm.DelegatingActionProxySecured.execute(DelegatingActionProxySecured.java:107) [classes/:?]
	at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:694) [servlet-api.jar:5.0.0]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:560) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499) [catalina.jar:10.0.20]
	at org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:301) [taglibs-standard-impl-1.2.5.migrated.jar:1.2.5-migrated-1.0.0]
	at org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:155) [taglibs-standard-impl-1.2.5.migrated.jar:1.2.5-migrated-1.0.0]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_c_005fimport_005f0(mailing_002dpreview_002dselect_jsp.java:3620) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_c_005fif_005f4(mailing_002dpreview_002dselect_jsp.java:3548) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_c_005fif_005f1(mailing_002dpreview_002dselect_jsp.java:2787) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_c_005fset_005f15(mailing_002dpreview_002dselect_jsp.java:2631) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspx_meth_agn_005fagnForm_005f0(mailing_002dpreview_002dselect_jsp.java:596) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.mailing.mailing_002dpreview_002dselect_jsp._jspService(mailing_002dpreview_002dselect_jsp.java:446) [ROOT/:?]
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) [jasper.jar:10.0.20]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) [jasper.jar:10.0.20]
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:380) [jasper.jar:10.0.20]
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:328) [jasper.jar:10.0.20]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:560) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499) [catalina.jar:10.0.20]
	at org.springframework.security.web.header.HeaderWriterFilter$HeaderWriterRequestDispatcher.include(HeaderWriterFilter.java:176) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:994) [jasper.jar:10.0.20]
	at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:495) [jasper.jar:10.0.20]
	at jdk.internal.reflect.GeneratedMethodAccessor189.invoke(Unknown Source) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
	at org.apache.struts.tiles.TilesUtilImpl.doInclude(TilesUtilImpl.java:129) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:152) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.taglib.InsertTag.doInclude(InsertTag.java:764) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.taglib.InsertTag$InsertHandler.doEndTag(InsertTag.java:896) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.taglib.InsertTag.doEndTag(InsertTag.java:465) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.jsp.WEB_002dINF.jsp.ajax_002dresponse_002dtemplate_jsp._jspx_meth_tiles_005finsert_005f1(ajax_002dresponse_002dtemplate_jsp.java:195) [ROOT/:?]
	at org.apache.jsp.WEB_002dINF.jsp.ajax_002dresponse_002dtemplate_jsp._jspService(ajax_002dresponse_002dtemplate_jsp.java:134) [ROOT/:?]
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) [jasper.jar:10.0.20]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466) [jasper.jar:10.0.20]
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:380) [jasper.jar:10.0.20]
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:328) [jasper.jar:10.0.20]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:441) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:367) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:295) [catalina.jar:10.0.20]
	at org.apache.struts.tiles.commands.TilesPreProcessor.doForward(TilesPreProcessor.java:260) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.tiles.commands.TilesPreProcessor.execute(TilesPreProcessor.java:217) [struts-tiles-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191) [commons-chain-1.2.migrated.jar:1.2-migrated-1.0.0]
	at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) [struts-core-1.3.8.migrated.jar:1.3.8-migrated-1.0.0]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:694) [servlet-api.jar:5.0.0]
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:777) [servlet-api.jar:5.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:223) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.web.filter.Struts1SecurityFilter.doFilter(Struts1SecurityFilter.java:89) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.emm.core.commons.filter.OriginUriFilter.doFilter(OriginUriFilter.java:43) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46) [ajaxanywhere-1.2.1.migrated.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.emm.core.sessionhijacking.web.GroupingSessionHijackingPreventionFilter.doFilter(GroupingSessionHijackingPreventionFilter.java:108) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.web.filter.responseheaders.HttpResponseHeadersFilter.doFilter(HttpResponseHeadersFilter.java:115) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:122) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:116) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:109) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183) [spring-security-web-5.6.2.migrated.jar:5.6.2-migrated-1.0.0]
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.emm.core.commons.filter.LoadBalancerFilter.doFilter(LoadBalancerFilter.java:154) [classes/:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at com.agnitas.emm.core.commons.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:80) [classes/:?]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.18.migrated.jar:5.3.18-migrated-1.0.0]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:185) [catalina.jar:10.0.20]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:158) [catalina.jar:10.0.20]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:10.0.20]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:10.0.20]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:661) [catalina.jar:10.0.20]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:119) [catalina.jar:10.0.20]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:10.0.20]
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:10.0.20]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:10.0.20]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) [catalina.jar:10.0.20]
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:439) [tomcat-coyote.jar:10.0.20]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:10.0.20]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:867) [tomcat-coyote.jar:10.0.20]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1716) [tomcat-coyote.jar:10.0.20]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:10.0.20]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:10.0.20]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:10.0.20]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:10.0.20]
	at java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: java.lang.Exception: No configured database driver found
	at org.agnitas.backend.DBase.setup(DBase.java:593) ~[classes/:?]
	at org.agnitas.backend.Data.setupDatabase(Data.java:835) ~[classes/:?]
	... 156 more
mailout:db_driver is unset
mailout:db_driver is unset
mailout:db_driver is unset
mailout:db_driver is unset
MikaLaurer
Posts: 35
Joined: Thu Apr 02, 2020 9:18 am

Re: After Update to 23.04 Error in Preview and sending Mail

Post by MikaLaurer »

UPDATE:

I managed to get the preview generation running againg.
I took a look a the source code and found that in frontend/src/java/org/agnitas/util/DBConfig.java the path for the dbcfg is set to "/opt/agnitas.com/etc/dbcfg"
I didn't find anything that indicates this path to be changed. So I just copied the dbcfg file from /home/openemm/etc/ to that path and after a restart the preview generation worked.
Sadly I still got the problem that no mailings are sent. Neither Test/Admin mailings nor actual mailings.
MikaLaurer
Posts: 35
Joined: Thu Apr 02, 2020 9:18 am

Re: After Update to 23.04 Error in Preview and sending Mail

Post by MikaLaurer »

UPDATE:

I found out something interesting ...
The mailout-server listens on port 8093 though the mailout-client tries to connect to 8089.
Is there a way to change either of these ports?

/home/openemm/var/log/mailoutserver.log

Code: Select all

[25.07.2023  13:05:43] INFO/server: Listening to *:8093 for XML-RPC requests running 22.10.000.222 (with default dbid "openemm")
/home/openemm/var/log/mailoutclient.log

Code: Select all

[25.07.2023  12:55:10] INFO/invoke: Connecting to nfsserver:8089
[25.07.2023  12:55:10] ERROR/invoke: MailoutClient exception: org.apache.xmlrpc.XmlRpcException: Failed to open connection to nfsserver:8089: nfsserver
MikaLaurer
Posts: 35
Joined: Thu Apr 02, 2020 9:18 am

Re: After Update to 23.04 Error in Preview and sending Mail

Post by MikaLaurer »

UPDATE:

Managed to get it up and running.
The source code at "frontend/src/java/org/agnitas/util/MailoutClient.java" uses a file to configure the mailout-client.
I created the "/opt/agnitas.com/etc/system.cfg" file with these parameters:
  • mailout-server = localhost
  • mailout-port = 8093
After restarting the backend I was able to send mailings again.
ud
Posts: 154
Joined: Thu Aug 17, 2006 9:56 am
Location: Munich, Germany
Contact:

Re: After Update to 23.04 Error in Preview and sending Mail

Post by ud »

Hello,

I appreciate it a lot that you dig your way through the source code to find a solution. What you have found are the (hard coded) default values used by the commercial version of EMM. For OpenEMM these are overwritten using environment variables set in $HOME/scripts/config.sh (near the top of the file you find the definition for SYSTEM_CFG as a replacement for the /opt/agnitas.com/etc/system.cfg configuration file and DBCFG_PATH to point to the proper database definition file). To ensure that the OpenEMM uses this file, this should be referenced by $HOME/bin/setenv.sh. The last line in this file should look like this:

source $HOME/scripts/config.sh

Could you please check if this is the case? This should had been added automatically if its missing, so there seems to be a case where this had been missing out.

-- ud
MikaLaurer
Posts: 35
Joined: Thu Apr 02, 2020 9:18 am

Re: After Update to 23.04 Error in Preview and sending Mail

Post by MikaLaurer »

Hello,

my setenv.sh was indeed missing this line: source $HOME/scripts/config.sh
I manually added it and deleted the files I created at /opt/agnitas.com/etc/

Everything works as usual now :)
Post Reply