# issue with MySQL version of ciphermail **URL:** \ **Category:** Gateway\ **Created:** [August 27, 2015, 11:35pm UTC](https://community.ciphermail.com/t/issue-with-mysql-version-of-ciphermail/454 "2015-08-27T23:35:54Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Robert\_Cicerelli](https://avatars.discourse-cdn.com/v4/letter/r/4bbf92/32.png) [@Robert\_Cicerelli](https://community.ciphermail.com/u/Robert_Cicerelli)\ **Post date:** [August 27, 2015, 11:35pm UTC](https://community.ciphermail.com/t/issue-with-mysql-version-of-ciphermail/454/1 "2015-08-27T23:35:54Z")
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 ---
**Author:** ![martijn](https://dub1.discourse-cdn.com/flex017/user_avatar/community.ciphermail.com/martijn/32/127_2.png) [@martijn](https://community.ciphermail.com/u/martijn)\ **Post date:** [August 28, 2015, 6:45am UTC](https://community.ciphermail.com/t/issue-with-mysql-version-of-ciphermail/454/2 "2015-08-28T06:45:56Z")
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: \SELECT 1\ 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. > > > **[CipherMail email encryption and digital signatures](https://www.ciphermail.com)** > > > > Easy to use server-side email encryption for automatic encryption and digital signing of email. > > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)