Hi all, I am using:
- jpa - MariaDB - Apache James 3.2.0 When I add the mailet BayesianAnalysis , I am getting: INFO | jvm 1 | 2019/02/26 22:00:34 | 22:00:34.036 [WrapperSimpleAppMain] ERROR org.apache.james.mailetcontainer.lib.AbstractStateMailetProcessor - Unable to init mailet BayesianAnalysis INFO | jvm 1 | 2019/02/26 22:00:34 | javax.mail.MessagingException: Exception initializing queries INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.transport.mailets.BayesianAnalysis.initDb(BayesianAnalysis.java:271) INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.transport.mailets.BayesianAnalysis.init(BayesianAnalysis.java:258) [...] INFO | jvm 1 | 2019/02/26 22:00:34 | at java.lang.Thread.run(Thread.java:748) INFO | jvm 1 | 2019/02/26 22:00:34 | Caused by: java.lang.RuntimeException: Required SQL resource: 'createHamTable' was not found. INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.util.sql.SqlResources.getSqlString(SqlResources.java:372) INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.util.bayesian.JDBCBayesianAnalyzer.createTable(JDBCBayesianAnalyzer.java:362) INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.util.bayesian.JDBCBayesianAnalyzer.checkTables(JDBCBayesianAnalyzer.java:335) INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.util.bayesian.JDBCBayesianAnalyzer.initSqlQueries(JDBCBayesianAnalyzer.java:322) INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.transport.mailets.BayesianAnalysis.initDb(BayesianAnalysis.java:269) INFO | jvm 1 | 2019/02/26 22:00:34 | ... 38 common frames omitted INFO | jvm 1 | 2019/02/26 22:00:34 | 22:00:34.036 [WrapperSimpleAppMain] ERROR org.apache.james.mailetcontainer.lib.AbstractStateMailetProcessor - Caused by nested exception: INFO | jvm 1 | 2019/02/26 22:00:34 | java.lang.RuntimeException: Required SQL resource: 'createHamTable' was not found. INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.util.sql.SqlResources.getSqlString(SqlResources.java:372) INFO | jvm 1 | 2019/02/26 22:00:34 | at org.apache.james.util.bayesian.JDBCBayesianAnalyzer.createTable(JDBCBayesianAnalyzer.java:362) [...] First, I thought maybe it was due to the "dbMatchers" in sqlResources.xml that did not include "mariadb", but I checked the value returned by conn.getMetaData().getDatabaseProductName() when using the MariaDB connector and it should be returning "MySQL" (just like the MySQL connector). My second guess is maybe because I am using JPA and that mailet is using JDBC. For instance, we have to configure: <repositoryPath>db://maildb</repositoryPath> but I do not see any other occurences of "db://maildb". This is the name in the example for that mailet, but does it need any special config? I zipped my full config here: https://www.foilen.com/wp-content/uploads/conf.zip thanks
