On 08/28/2015 01:35 AM, Robert Cicerelli wrote: > I'm getting the following errors in my > /usr/share/djigzo/logs/james.wrapper.log > > 27 Aug 2015 19:31:07 | WARN SQL Error: 1146, SQLState: 42S02 > (org.hibernate.util.JDBCExceptionReporter) [default Worker #5] > 27 Aug 2015 19:31:07 | ERROR Table 'djigzo.user' doesn't exist > (org.hibernate.util.JDBCExceptionReporter) [default Worker #5] > 27 Aug 2015 19:31:07 | WARN Unable to open a stateless session. > Database is probably not active. (mitm.common.hibernate.HibernateUtils) > [default Worker #5] > 27 Aug 2015 19:31:07 | WARN Database is not active. > (mitm.application.djigzo.james.smtpserver.CheckDatabaseBlockingRcptCmdHandler) > [default Worker #5] > > I've uncommented the following line from > /usr/share/djigzo/wrapper/djigzo.wrapper.confand re-started djigzo : > > wrapper.java.additional.15=-Dciphermail.hibernate.database.type=mysql > > > For some reason it's looking for the djigzo.user table, even though the > table is called djigzo.cm_users > > The Web GUI seems to be working fine with MySQL. > > I'm using ciphermail Version: 2.10.3-1.Built: 2015-07-07-09:13 > > Any ideas?
That's strange because this was fixed. It could be that you are somehow using an older version or that the file james-smtphandlerchain.xml was not replaced (for whatever reason) during an upgrade. In the file james-smtphandlerchain.xml there should be the line: <testQuery>SELECT 1</testQuery> In previous releases this was "SELECT 1 FROM user" Kind regards, Martijn Brinkers -- CipherMail email encryption Open source email encryption gateway with support for S/MIME, OpenPGP and PDF messaging. https://www.ciphermail.com Twitter: http://twitter.com/CipherMail _______________________________________________ Users mailing list [email protected] https://lists.djigzo.com/lists/listinfo/users
