Not everything in the stable 3.2.0 release works. Let me rephrase that. As I found when I tried to use it, some of the JPA classes create tables only in the derby database and users of true SQL databases - SQL Server, MySQL, etc. - are left in the cold, but not intentionally. There just is not enough manpower to test the code in all possible configurations. I will see if ‘createHamTable’ appears in the 3.3 chain and if so, forward it to you. If it is in the java source, I will let you know where.
Sent from my iPhone > On Feb 27, 2019, at 9:11 PM, Simon Levesque <suriv...@gmail.com> wrote: > > 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 --------------------------------------------------------------------- To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org For additional commands, e-mail: server-user-h...@james.apache.org