issue with MySQL version of ciphermail

Gateway
1

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?

thanks

2

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

ยทยทยท

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?

--
CipherMail email encryption

Open source email encryption gateway with support for S/MIME, OpenPGP
and PDF messaging.

Twitter: http://twitter.com/CipherMail