Page 1 of 1

Problems after installation with "Content MAnager" and more

Posted: Mon Aug 08, 2011 8:29 am
by web
Hello,

I just installed openEMM 2011 on my root server, this server has got enough hardware resources so the problems may not be caused by insufficient system performance.
Well I looked in the web but didn't find much help therefore...

I can login as admin and even navigate through the menu, but some important funcionalities throw errors like 'A general error occurred. Please check your input.'
For Example, each tab in the "Content Manager" like 'CM templates', 'Module types', 'content modules' ans so on shows this error erverytime,
'Module Types' ist totaly empty except the error message...
Even in some points of 'Mailings' this errors sometimes appear...

Could somebody help me with it?

I just looked up the 'openemm_core.log', there are multiple errors and warnings inside - just take a look please

Code: Select all

2011-08-08 08:51:14,624: WARN  [main] net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/openemm-2011/webapps/openemm/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
2011-08-08 08:51:17,572: WARN  [main] net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/openemm-2011/webapps/openemm/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
2011-08-08 08:52:47,808: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources  -   Resource messages_de_DE.properties Not Found.
2011-08-08 08:52:47,808: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources -   Resource messages_de_DE.properties Not Found.
2011-08-08 08:52:47,812: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources  -   Resource messages_en_US.properties Not Found.
2011-08-08 08:52:47,812: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources -   Resource messages_en_US.properties Not Found.
2011-08-08 08:52:53,851: INFO  [http-8080-2] org.agnitas.userlogs - admin: do login
2011-08-08 08:52:53,851: INFO  [http-8080-2] org.agnitas.userlogs - admin: do login
2011-08-08 08:52:55,046: WARN  [http-8080-6] org.displaytag.export.ExportViewFactory - Unable to instantiate class for pdf export. org.displaytag.export.PdfView was found, but required libraries are missing: com/lowagie/text/Element
2011-08-08 08:53:05,731: ERROR [http-8080-4] org.agnitas - cmTemplateList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:281)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:88)
org.agnitas.cms.utils.dataaccess.LocalCMTemplateManager.getCMTemplates(LocalCMTemplateManager.java:52)
org.agnitas.cms.web.CMTemplateAction.getCMTemplateList(CMTemplateAction.java:681)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:277)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2011-08-08 08:53:05,731: ERROR [http-8080-4] org.agnitas - cmTemplateList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:281)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:88)
org.agnitas.cms.utils.dataaccess.LocalCMTemplateManager.getCMTemplates(LocalCMTemplateManager.java:52)
org.agnitas.cms.web.CMTemplateAction.getCMTemplateList(CMTemplateAction.java:681)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:277)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2011-08-08 08:53:05,751: WARN  [http-8080-4] org.apache.struts.util.PropertyMessageResources  -   Resource cmsmessages_de_DE.properties Not Found.
2011-08-08 08:53:05,751: WARN  [http-8080-4] org.apache.struts.util.PropertyMessageResources -   Resource cmsmessages_de_DE.properties Not Found.
2011-08-08 08:53:52,053: ERROR [http-8080-5] org.agnitas - Username: admin Password: 8...
2011-08-08 08:53:52,053: ERROR [http-8080-5] org.agnitas - Username: admin Password: 8...
2011-08-08 08:53:52,059: INFO  [http-8080-5] org.agnitas.userlogs - admin: edit user admin
2011-08-08 08:53:52,059: INFO  [http-8080-5] org.agnitas.userlogs - admin: edit user admin
2011-08-08 08:54:03,793: INFO  [http-8080-3] org.agnitas.userlogs - admin: do logout
2011-08-08 08:54:03,793: INFO  [http-8080-3] org.agnitas.userlogs - admin: do logout
2011-08-08 08:54:08,937: INFO  [http-8080-6] org.agnitas.userlogs - admin: do login
2011-08-08 08:54:08,937: INFO  [http-8080-6] org.agnitas.userlogs - admin: do login
2011-08-08 08:54:19,182: ERROR [http-8080-4] org.agnitas - cmTemplateList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:281)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:88)
org.agnitas.cms.utils.dataaccess.LocalCMTemplateManager.getCMTemplates(LocalCMTemplateManager.java:52)
org.agnitas.cms.web.CMTemplateAction.getCMTemplateList(CMTemplateAction.java:681)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:277)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2011-08-08 08:54:19,182: ERROR [http-8080-4] org.agnitas - cmTemplateList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:281)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:88)
org.agnitas.cms.utils.dataaccess.LocalCMTemplateManager.getCMTemplates(LocalCMTemplateManager.java:52)
org.agnitas.cms.web.CMTemplateAction.getCMTemplateList(CMTemplateAction.java:681)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:277)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2011-08-08 08:54:19,192: WARN  [http-8080-4] org.apache.struts.util.PropertyMessageResources  -   Resource cmsmessages_en_US.properties Not Found.
2011-08-08 08:54:19,192: WARN  [http-8080-4] org.apache.struts.util.PropertyMessageResources -   Resource cmsmessages_en_US.properties Not Found.
2011-08-08 09:02:20,726: INFO  [http-8080-3] org.agnitas.userlogs - admin: do logout
2011-08-08 09:02:20,726: INFO  [http-8080-3] org.agnitas.userlogs - admin: do logout
2011-08-08 09:12:16,763: INFO  [http-8080-5] org.agnitas.userlogs - admin: do login
2011-08-08 09:12:16,763: INFO  [http-8080-5] org.agnitas.userlogs - admin: do login
2011-08-08 09:12:20,699: ERROR [http-8080-3] org.agnitas - cmTemplateList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:281)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:88)
org.agnitas.cms.utils.dataaccess.LocalCMTemplateManager.getCMTemplates(LocalCMTemplateManager.java:52)
org.agnitas.cms.web.CMTemplateAction.getCMTemplateList(CMTemplateAction.java:681)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:277)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2011-08-08 09:12:20,699: ERROR [http-8080-3] org.agnitas - cmTemplateList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:281)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:88)
org.agnitas.cms.utils.dataaccess.LocalCMTemplateManager.getCMTemplates(LocalCMTemplateManager.java:52)
org.agnitas.cms.web.CMTemplateAction.getCMTemplateList(CMTemplateAction.java:681)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:277)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2011-08-08 09:18:29,487: ERROR [http-8080-3] org.agnitas - Error while executing action with CM Template: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.ContentModuleTypeDaoImpl.getContentModuleTypes(ContentModuleTypeDaoImpl.java:94)
org.agnitas.cms.utils.dataaccess.LocalContentModuleTypeManager.getContentModuleTypes(LocalContentModuleTypeManager.java:47)
org.agnitas.cms.web.ContentModuleAction.loadCMTList(ContentModuleAction.java:316)
org.agnitas.cms.web.ContentModuleAction.execute(ContentModuleAction.java:116)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

2011-08-08 09:18:29,487: ERROR [http-8080-3] org.agnitas - Error while executing action with CM Template: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.ContentModuleTypeDaoImpl.getContentModuleTypes(ContentModuleTypeDaoImpl.java:94)
org.agnitas.cms.utils.dataaccess.LocalContentModuleTypeManager.getContentModuleTypes(LocalContentModuleTypeManager.java:47)
org.agnitas.cms.web.ContentModuleAction.loadCMTList(ContentModuleAction.java:316)
org.agnitas.cms.web.ContentModuleAction.execute(ContentModuleAction.java:116)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

2011-08-08 09:18:29,500: ERROR [http-8080-3] org.agnitas - getContentModuleList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.ContentModuleDaoImpl.getAllCMCategories(ContentModuleDaoImpl.java:399)
org.agnitas.cms.utils.dataaccess.LocalContentModuleManager.getAllCMCategories(LocalContentModuleManager.java:147)
org.agnitas.cms.web.ContentModuleAction.execute(ContentModuleAction.java:211)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

2011-08-08 09:18:29,500: ERROR [http-8080-3] org.agnitas - getContentModuleList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' to database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.ContentModuleDaoImpl.getAllCMCategories(ContentModuleDaoImpl.java:399)
org.agnitas.cms.utils.dataaccess.LocalContentModuleManager.getAllCMCategories(LocalContentModuleManager.java:147)
org.agnitas.cms.web.ContentModuleAction.execute(ContentModuleAction.java:211)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

Re: Problems after installation with "Content MAnager" and m

Posted: Mon Aug 08, 2011 10:18 am
by web
Hello everbody,

now I just droped all tabels and cleared all logs - so I can give you specific information to reconstruct my errors

This ist what I´ve done so far.

Load all data from "openemm_demo-cms-2011.sql" and "openemm-2011.sql" to the mysql server - so modules are in the database as well...

1. First Login with "admin" and password "openemm" than called "Administration" -> "Users" and changed the admin password
Look at what my log (openemm_core.log) says so far - error about missing configuration in the ehcache from ehcache-failsafe.xml and missing Resource messages_de_DE.properties even with Resource messages_en_US.properties

Code: Select all

2011-08-08 11:02:34,731: WARN  [main] net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/openemm-2011/webapps/openemm/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
2011-08-08 11:02:37,336: WARN  [main] net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/openemm-2011/webapps/openemm/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
2011-08-08 11:03:26,026: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources  -   Resource messages_de_DE.properties Not Found.
2011-08-08 11:03:26,026: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources -   Resource messages_de_DE.properties Not Found.
2011-08-08 11:03:26,030: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources  -   Resource messages_en_US.properties Not Found.
2011-08-08 11:03:26,030: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources -   Resource messages_en_US.properties Not Found.
2011-08-08 11:03:35,077: WARN  [http-8080-4] org.agnitas - logon: login FAILED User: admin Password-Length: 8
2011-08-08 11:03:35,077: WARN  [http-8080-4] org.agnitas - logon: login FAILED User: admin Password-Length: 8
2011-08-08 11:03:40,416: INFO  [http-8080-4] org.agnitas.userlogs - admin: do login
2011-08-08 11:03:40,416: INFO  [http-8080-4] org.agnitas.userlogs - admin: do login
2011-08-08 11:03:40,456: WARN  [http-8080-4] org.apache.struts.util.PropertyMessageResources  -   Resource messages_en_EN.properties Not Found.
2011-08-08 11:03:40,456: WARN  [http-8080-4] org.apache.struts.util.PropertyMessageResources -   Resource messages_en_EN.properties Not Found.
2011-08-08 11:03:41,588: WARN  [http-8080-6] org.displaytag.export.ExportViewFactory - Unable to instantiate class for pdf export. org.displaytag.export.PdfView was found, but required libraries are missing: com/lowagie/text/Element
2011-08-08 11:04:30,930: ERROR [http-8080-6] org.agnitas - Username: admin Password: 8...
2011-08-08 11:04:30,930: ERROR [http-8080-6] org.agnitas - Username: admin Password: 8...
2011-08-08 11:04:30,937: INFO  [http-8080-6] org.agnitas.userlogs - admin: edit user admin
2011-08-08 11:04:30,937: INFO  [http-8080-6] org.agnitas.userlogs - admin: edit user admin
2011-08-08 11:04:34,866: INFO  [http-8080-2] org.agnitas.userlogs - admin: do logout
2011-08-08 11:04:34,866: INFO  [http-8080-2] org.agnitas.userlogs - admin: do logout

2. Than I perfomed a logout and login with the new password, than I clicked on "Content Mangager" - causes "A general error occurred. Please check your input. "
Even "Module Types" and "Content Modules" tabs are empty but cause teh same error, lets take a look at the log (openemm_core.log) there additional data was written...

Code: Select all

2011-08-08 11:04:41,592: INFO  [http-8080-2] org.agnitas.userlogs - admin: do login
2011-08-08 11:04:41,592: INFO  [http-8080-2] org.agnitas.userlogs - admin: do login
2011-08-08 11:05:10,731: ERROR [http-8080-1] org.agnitas - cmTemplateList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:281)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:88)
org.agnitas.cms.utils.dataaccess.LocalCMTemplateManager.getCMTemplates(LocalCMTemplateManager.java:52)
org.agnitas.cms.web.CMTemplateAction.getCMTemplateList(CMTemplateAction.java:681)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:277)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2011-08-08 11:05:10,731: ERROR [http-8080-1] org.agnitas - cmTemplateList: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unknown database 'openemm_cms')
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:281)
org.agnitas.cms.dao.impl.CMTemplateDaoImpl.getCMTemplates(CMTemplateDaoImpl.java:88)
org.agnitas.cms.utils.dataaccess.LocalCMTemplateManager.getCMTemplates(LocalCMTemplateManager.java:52)
org.agnitas.cms.web.CMTemplateAction.getCMTemplateList(CMTemplateAction.java:681)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:277)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

2011-08-08 11:05:10,747: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources  -   Resource cmsmessages_en_US.properties Not Found.
2011-08-08 11:05:10,747: WARN  [http-8080-1] org.apache.struts.util.PropertyMessageResources -   Resource cmsmessages_en_US.properties Not Found.
May somebody could help me please, as alternative solution I have to use phpList instead :(

Re: Problems after installation with "Content MAnager" and m

Posted: Mon Aug 08, 2011 5:58 pm
by maschoff
Error message "Unknown database 'openemm_cms'" means that you did not set up database openemm_cms. Could it be that you dumped the openemm_cms content into database openemm?

Re: Problems after installation with "Content MAnager" and m

Posted: Tue Aug 09, 2011 8:09 am
by web
Damned, I totally miss this entry - now everything make sense.

Pardon me, was just my impreciseness. I but both database contents in db openemm without creating openemm_cms.
I´m on the way to an appointment right now, but I will fix and test it this afternoon. I´ll write more about it
as soon as I´m back.

Thank you

Re: Problems after installation with "Content MAnager" and m

Posted: Tue Aug 09, 2011 12:56 pm
by web
I just removed all tables and created both required databases openemm and openemm_cms.

That solved all mentioned problems, thank you again...