# Ciphermail and MariaDB

**URL:** <https://community.ciphermail.com/t/ciphermail-and-mariadb/449>\
**Category:** Gateway\
**Created:** [June 29, 2015, 2:17pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449 "2015-06-29T14:17:25Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Django](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@Django](https://community.ciphermail.com/u/Django)\
**Post date:** [June 29, 2015, 2:17pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/1 "2015-06-29T14:17:25Z")

</div>

HI,

one short question:

Are thzere any plans 'bout supporting MariaDB? At one installation this  
is a "must have"/"killing frequest". Postgres isn't allowed. 😕

I think that's all for now, maybe much mor questions come next day. 😉

ttyl  
Django

> **···**
>
> --  
> "Bonnie & Clyde der Postmaster-Szene!" approved by Postfix-God  
> [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> [http://wiki.piratenpartei.de/Benutzer:Django](http://wiki.piratenpartei.de/Benutzer:Django)

---

<div class="post-metadata">

**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:** [June 29, 2015, 2:31pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/2 "2015-06-29T14:31:22Z")

</div>

Hi Django,

Interesting. Why is Postgres not allowed? I would assume that it would  
be the other way around since MariaDB is based on code owned by Oracle  
and Postgres is "more" open source. Anyway, perhaps it's not of legal  
reasons but some technical reason. That said, Maria DB is not directly  
supported but you can see whether you can make it work with Maria DB.  
The database layer uses Hibernate (which is an ORM library). Hibernate  
supports multiple databases and in theory you might tell it to use a  
different database. This however has never tested but it you are willing  
to spend some time testing it, I can assist you.

Kind regards,

Martijn Brinkers

> **···**
>
> On 06/29/2015 04:17 PM, Django [BOfH] wrote:
> 
> > one short question:
> > 
> > Are thzere any plans 'bout supporting MariaDB? At one installation this  
> > is a "must have"/"killing frequest". Postgres isn't allowed. 😕
> 
> --  
> 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)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [June 30, 2015, 3:03am UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/3 "2015-06-30T03:03:44Z")

</div>

I too would like to try running on MySQL. Just converted my DB from PSQL to MySQL, and will try the actual Hibernate connection later on tomorrow or the next day.

My interest is adding CipherMail to the cluster of MySQL, Dovecot and Postfix servers. Currently, any mail we want to send through CipherMail must travel to a specific server in one site, versus going out (or in) through any site.

MySQL is so much easier to have a reliable master-master configuration. I spent the day trying to get a similar functionality through PostgreSQL, but I really did hit a lot of roadblocks.

I believe MariaDB and MySQL share the same connection libraries, yes? I can share my experiences here.

~ Laz Peterson  
Paravis, LLC  
Ph: 951.319.3240 x201

> **···**
>
> > On Jun 29, 2015, at 7:31 AM, Martijn Brinkers \<martijn(a)djigzo.com\> wrote:
> > 
> > On 06/29/2015 04:17 PM, Django [BOfH] wrote:
> > 
> > > one short question:
> > > 
> > > Are thzere any plans 'bout supporting MariaDB? At one installation this  
> > > is a "must have"/"killing frequest". Postgres isn't allowed. 😕
> > 
> > Hi Django,
> > 
> > Interesting. Why is Postgres not allowed? I would assume that it would  
> > be the other way around since MariaDB is based on code owned by Oracle  
> > and Postgres is "more" open source. Anyway, perhaps it's not of legal  
> > reasons but some technical reason. That said, Maria DB is not directly  
> > supported but you can see whether you can make it work with Maria DB.  
> > The database layer uses Hibernate (which is an ORM library). Hibernate  
> > supports multiple databases and in theory you might tell it to use a  
> > different database. This however has never tested but it you are willing  
> > to spend some time testing it, I can assist you.
> > 
> > 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](https://www.ciphermail.com)
> > 
> > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)  
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

---

<div class="post-metadata">

**Author:** ![Django](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@Django](https://community.ciphermail.com/u/Django)\
**Post date:** [June 30, 2015, 7:18am UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/4 "2015-06-30T07:18:23Z")

</div>

Hello!

> Currently, any mail we want to send through CipherMail must travel to a  
> specific server in one site, versus going out (or in) through any site.

Incomming emails to different sites are routed with transport\_maps's  
hashtable:

domain\_1 lmtp:backend\_domain\_1:24  
doamin\_2 lmtps:backend\_domain\_2:24  
domain\_3 smtp:[10.10.10.10]:25

> I can share my experiences here.

Grait, please do it! 😉

Best regards  
Django

> **···**
>
> Am 30.06.2015 um 05:03 schrieb Laz C. Peterson:  
> --  
> "Bonnie & Clyde der Postmaster-Szene!" approved by Postfix-God  
> [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> [http://wiki.piratenpartei.de/Benutzer:Django](http://wiki.piratenpartei.de/Benutzer:Django)

---

<div class="post-metadata">

**Author:** ![Django](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@Django](https://community.ciphermail.com/u/Django)\
**Post date:** [June 30, 2015, 7:37am UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/5 "2015-06-30T07:37:22Z")

</div>

Griasde Martijn!

Quoting "Martijn Brinkers" martijn(a)djigzo.com:

> Interesting. Why is Postgres not allowed?

It's a political decision - we can use following prioroties ans databeses:

&nbsp;&nbsp;1st Oracle 12  
&nbsp;&nbsp;2nd MariaDB

> Anyway, perhaps it's not of legal reasons but some technical reason.

FULLACK

> That said, Maria DB is not directly supported but you can see  
> whether you can make it work with Maria DB.

That's a very good idea If you can tell me technical details about  
changing the backend database, I'll do it, test it and give feedback  
to you!

> The database layer uses Hibernate (which is an ORM library).

My colleague Klaus, my database specialist, assumed, that your are using  
Hibernate.

> This however has never tested but it you are willing to spend some  
> time testing it, I can assist you.

Oh yes, I'll make this tests! So please tell me, what I should do!

Thanks for help!!!

Best regards  
Django

> **···**
>
> --  
> [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> [http://ebersberger-liedersammlung.de](http://ebersberger-liedersammlung.de)

---

<div class="post-metadata">

**Author:** ![Django](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@Django](https://community.ciphermail.com/u/Django)\
**Post date:** [June 30, 2015, 7:49am UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/6 "2015-06-30T07:49:10Z")

</div>

Hello!

Quoting "lst\_hoe02 at kwsoft.de" lst\_hoe02(a)kwsoft.de:

> Maybe they will sponsor the work?

At first point I evaluate, either ciphermail or Z1 will met our  
requirements. And I think ciphermail is very good in the race! 😉  
And yes, we will pay4use like a support contract or an licence cost.  
But first we have to overcome the first hurdle and actually this is  
MariaDB support.

Have a nice day!  
Django

> **···**
>
> --  
> [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> [http://ebersberger-liedersammlung.de](http://ebersberger-liedersammlung.de)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [June 30, 2015, 1:27pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/7 "2015-06-30T13:27:32Z")

</div>

Hello there Django.

Yes that is how we are doing it right now, using transport\_map. But our goal is to go independent if one site goes down — both for high availability and live backup. Would love to replicate the CipherMail database same as we are replicating our mailbox storage and other services.

I tested out converting the PostgreSQL database to MySQL, but found some issues already. Seems that some of the tables (certificates for example) are given a very large size in PostgreSQL, where as in MySQL they are capped at 255. I don’t know about the restrictions in MariaDB, but I was unable to copy the data from the certificates table.

Other than that, it seems to be a very possible option as Hibernate supports MySQL just the same.

Any thoughts about the data type mismatch?

~ Laz Peterson  
Paravis, LLC

> **···**
>
> > On Jun 30, 2015, at 12:18 AM, Django [BOfH] \<django(a)nausch.org\> wrote:
> > 
> > Hello!
> > 
> > Am 30.06.2015 um 05:03 schrieb Laz C. Peterson:
> > 
> > > Currently, any mail we want to send through CipherMail must travel to a  
> > > specific server in one site, versus going out (or in) through any site.
> > 
> > Incomming emails to different sites are routed with transport\_maps's  
> > hashtable:
> > 
> > domain\_1 lmtp:backend\_domain\_1:24  
> > doamin\_2 lmtps:backend\_domain\_2:24  
> > domain\_3 smtp:[10.10.10.10]:25
> > 
> > > I can share my experiences here.
> > 
> > Grait, please do it! 😉
> > 
> > Best regards  
> > Django  
> > --  
> > "Bonnie & Clyde der Postmaster-Szene!" approved by Postfix-God  
> > [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> > [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> > [Benutzer:Django – Piratenwiki](http://wiki.piratenpartei.de/Benutzer:Django)  
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

---

<div class="post-metadata">

**Author:** ![Django](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@Django](https://community.ciphermail.com/u/Django)\
**Post date:** [June 30, 2015, 1:54pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/8 "2015-06-30T13:54:36Z")

</div>

HI Laz!

Quoting "Laz C. Peterson" \<laz(a)paravis.net\>:

> I tested out converting the PostgreSQL database to MySQL, but found  
> some issues already. Seems that some of the tables (certificates  
> for example) are given a very large size in PostgreSQL, where as in  
> MySQL they are capped at 255.

really?

CREATE TABLE certificates (  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;id bigint NOT NULL,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;notbefore timestamp without time zone,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;notafter timestamp without time zone,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;issuer text,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;issuerfriendly text,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;serial character varying(1024),  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;subjectkeyidentifier text,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;subject text,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;subjectfriendly text,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;certificate bytea,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;thumbprint character varying(255),  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;certpath bytea,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;certpathtype character varying(255),  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;creationdate timestamp without time zone,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;datepathupdated timestamp without time zone,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;keyalias character varying(1024),  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;storename character varying(255)  
);

How did you made your database dump from your postgresql?

ttyl  
Django

> **···**
>
> --  
> [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> [http://ebersberger-liedersammlung.de](http://ebersberger-liedersammlung.de)

---

<div class="post-metadata">

**Author:** ![Django](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@Django](https://community.ciphermail.com/u/Django)\
**Post date:** [June 30, 2015, 2:08pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/9 "2015-06-30T14:08:46Z")

</div>

Hello Laz, hello Martijn,

Quoting "Laz C. Peterson" \<laz(a)paravis.net\>:

> I believe MariaDB and MySQL share the same connection libraries,  
> yes? I can share my experiences here.

May someone show me details, how I can set up Ciphermail/Hibernating  
using a MariaDB?

Thanx!

ttyl  
Django

> **···**
>
> --  
> [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> [http://ebersberger-liedersammlung.de](http://ebersberger-liedersammlung.de)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [June 30, 2015, 2:54pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/10 "2015-06-30T14:54:15Z")

</div>

Yes, I have same information in the database dump.

I was actually using MySQL Workbench to do the conversion, and my issue was using the wrong ODBC driver (I was using ANSI, should have been using Unicode). After switching that, all is good, data has been moved over.

Regarding the Hibernate config, let me play around with this today and I will get back to you later on. But the switch should be simple, as long as you have the correct ODBC driver in the /usr/share/djigzo/lib folder (that is where mine are on Ubuntu 14.04 for CipherMail) then you can just change the /usr/share/djigzo/conf/hibernate.cfg.xml to reflect these changes. Those folder paths and files are where I have CipherMail installed, your installation may be different.

You can get the MySQL JDBC driver from [http://dev.mysql.com/downloads/connector/j/](http://dev.mysql.com/downloads/connector/j/) as well.

~ Laz Peterson  
Paravis, LLC  
Ph: 951.319.3240 x201

> **···**
>
> > On Jun 30, 2015, at 6:54 AM, django(a)nausch.org wrote:
> > 
> > HI Laz!
> > 
> > Quoting "Laz C. Peterson" \<laz(a)paravis.net\>:
> > 
> > > I tested out converting the PostgreSQL database to MySQL, but found some issues already. Seems that some of the tables (certificates for example) are given a very large size in PostgreSQL, where as in MySQL they are capped at 255.
> > 
> > really?
> > 
> > CREATE TABLE certificates (  
> > &nbsp;&nbsp;&nbsp;id bigint NOT NULL,  
> > &nbsp;&nbsp;&nbsp;notbefore timestamp without time zone,  
> > &nbsp;&nbsp;&nbsp;notafter timestamp without time zone,  
> > &nbsp;&nbsp;&nbsp;issuer text,  
> > &nbsp;&nbsp;&nbsp;issuerfriendly text,  
> > &nbsp;&nbsp;&nbsp;serial character varying(1024),  
> > &nbsp;&nbsp;&nbsp;subjectkeyidentifier text,  
> > &nbsp;&nbsp;&nbsp;subject text,  
> > &nbsp;&nbsp;&nbsp;subjectfriendly text,  
> > &nbsp;&nbsp;&nbsp;certificate bytea,  
> > &nbsp;&nbsp;&nbsp;thumbprint character varying(255),  
> > &nbsp;&nbsp;&nbsp;certpath bytea,  
> > &nbsp;&nbsp;&nbsp;certpathtype character varying(255),  
> > &nbsp;&nbsp;&nbsp;creationdate timestamp without time zone,  
> > &nbsp;&nbsp;&nbsp;datepathupdated timestamp without time zone,  
> > &nbsp;&nbsp;&nbsp;keyalias character varying(1024),  
> > &nbsp;&nbsp;&nbsp;storename character varying(255)  
> > );
> > 
> > How did you made your database dump from your postgresql?
> > 
> > ttyl  
> > Django  
> > --  
> > [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> > [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> > [http://ebersberger-liedersammlung.de](http://ebersberger-liedersammlung.de)
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [June 30, 2015, 3:02pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/11 "2015-06-30T15:02:47Z")

</div>

In theory, you should just be able to drop that MySQL JDBC driver inside /usr/share/djigzo/lib/lib.d/ and then change the hibernate.cfg.xml to reflect these options:

\<hibernate-configuration\>  
&nbsp;&nbsp;&nbsp;&nbsp;\<session-factory\>  
\<!-- \<property name="hibernate.dialect"\>org.hibernate.dialect.PostgreSQLDialect\</property\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.driver\_class"\>org.postgresql.Driver\</property\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.url"\>jdbc:postgresql://127.0.0.1/djigzo/\</property\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.username"\>djigzo\</property\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.password"\>djigzo\</property\>  
--\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.dialect"\>org.hibernate.dialect.MySQLDialect\</property\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.driver\_class"\>com.mysql.jdbc.Driver\</property\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.url"\>jdbc:mysql://127.0.0.1/djigzo\</property\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.username"\>djigzo\</property\>  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.password"\>djigzo\</property\>

I have not tried this yet, so I don’t know how well or if it even works.

~ Laz Peterson  
Paravis, LLC  
Ph: 951.319.3240 x201

> **···**
>
> > On Jun 30, 2015, at 7:08 AM, django(a)nausch.org wrote:
> > 
> > Hello Laz, hello Martijn,
> > 
> > Quoting "Laz C. Peterson" \<laz(a)paravis.net\>:
> > 
> > > I believe MariaDB and MySQL share the same connection libraries, yes? I can share my experiences here.
> > 
> > May someone show me details, how I can set up Ciphermail/Hibernating using a MariaDB?
> > 
> > Thanx!
> > 
> > ttyl  
> > Django  
> > --  
> > [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> > [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> > [http://ebersberger-liedersammlung.de](http://ebersberger-liedersammlung.de)
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [June 30, 2015, 3:14pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/12 "2015-06-30T15:14:59Z")

</div>

I just tried this and unfortunately it is not so straight forward.

The driver loads but then it is unable to access the tables. Seems like the problem is due to case sensitivity — CipherMail is looking for the “Admin” table, where I have “admin” … I will look into this more later on.

~ Laz Peterson  
Paravis, LLC  
Ph: 951.319.3240 x201

> **···**
>
> > On Jun 30, 2015, at 8:02 AM, Laz C. Peterson \<laz(a)paravis.net\> wrote:
> > 
> > In theory, you should just be able to drop that MySQL JDBC driver inside /usr/share/djigzo/lib/lib.d/ and then change the hibernate.cfg.xml to reflect these options:
> > 
> > \<hibernate-configuration\>  
> > &nbsp;&nbsp;&nbsp;\<session-factory\>  
> > \<!-- \<property name="hibernate.dialect"\>org.hibernate.dialect.PostgreSQLDialect\</property\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.driver\_class"\>org.postgresql.Driver\</property\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.url"\>jdbc:postgresql://127.0.0.1/djigzo/\</property\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.username"\>djigzo\</property\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.password"\>djigzo\</property\>  
> > --\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.dialect"\>org.hibernate.dialect.MySQLDialect\</property\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.driver\_class"\>com.mysql.jdbc.Driver\</property\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.url"\>jdbc:mysql://127.0.0.1/djigzo\</property\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.username"\>djigzo\</property\>  
> > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.password"\>djigzo\</property\>
> > 
> > I have not tried this yet, so I don’t know how well or if it even works.
> > 
> > ~ Laz Peterson  
> > Paravis, LLC  
> > Ph: 951.319.3240 x201
> > 
> > > On Jun 30, 2015, at 7:08 AM, django(a)nausch.org wrote:
> > > 
> > > Hello Laz, hello Martijn,
> > > 
> > > Quoting "Laz C. Peterson" \<laz(a)paravis.net\>:
> > > 
> > > > I believe MariaDB and MySQL share the same connection libraries, yes? I can share my experiences here.
> > > 
> > > May someone show me details, how I can set up Ciphermail/Hibernating using a MariaDB?
> > > 
> > > Thanx!
> > > 
> > > ttyl  
> > > Django  
> > > --  
> > > [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> > > [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> > > [http://ebersberger-liedersammlung.de](http://ebersberger-liedersammlung.de)
> > > 
> > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > > Users mailing list  
> > > Users(a)lists.djigzo.com  
> > > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [June 30, 2015, 3:23pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/13 "2015-06-30T15:23:39Z")

</div>

Possibly Martijn can shed some light on this …

I have renamed the tables so that they match the same case as the original PostgreSQL tables. Attached is the error log at that point, seems to have something to do with the XML configuration files, but I am not too familiar with Java so I don’t exactly know what to be looking for.

~ Laz Peterson  
Paravis, LLC  
Ph: 951.319.3240 x201

> **···**
>
> > On Jun 30, 2015, at 8:14 AM, Laz C. Peterson \<laz(a)paravis.net\> wrote:
> > 
> > I just tried this and unfortunately it is not so straight forward.
> > 
> > The driver loads but then it is unable to access the tables. Seems like the problem is due to case sensitivity — CipherMail is looking for the “Admin” table, where I have “admin” … I will look into this more later on.
> > 
> > ~ Laz Peterson  
> > Paravis, LLC  
> > Ph: 951.319.3240 x201
> > 
> > > On Jun 30, 2015, at 8:02 AM, Laz C. Peterson \<laz(a)paravis.net\> wrote:
> > > 
> > > In theory, you should just be able to drop that MySQL JDBC driver inside /usr/share/djigzo/lib/lib.d/ and then change the hibernate.cfg.xml to reflect these options:
> > > 
> > > \<hibernate-configuration\>  
> > > &nbsp;&nbsp;\<session-factory\>  
> > > \<!-- \<property name="hibernate.dialect"\>org.hibernate.dialect.PostgreSQLDialect\</property\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.driver\_class"\>org.postgresql.Driver\</property\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.url"\>jdbc:postgresql://127.0.0.1/djigzo/\</property\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.username"\>djigzo\</property\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.password"\>djigzo\</property\>  
> > > --\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.dialect"\>org.hibernate.dialect.MySQLDialect\</property\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.driver\_class"\>com.mysql.jdbc.Driver\</property\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.url"\>jdbc:mysql://127.0.0.1/djigzo\</property\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.username"\>djigzo\</property\>  
> > > &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\<property name="hibernate.connection.password"\>djigzo\</property\>
> > > 
> > > I have not tried this yet, so I don’t know how well or if it even works.
> > > 
> > > ~ Laz Peterson  
> > > Paravis, LLC  
> > > Ph: 951.319.3240 x201
> > > 
> > > > On Jun 30, 2015, at 7:08 AM, django(a)nausch.org wrote:
> > > > 
> > > > Hello Laz, hello Martijn,
> > > > 
> > > > Quoting "Laz C. Peterson" \<laz(a)paravis.net\>:
> > > > 
> > > > > I believe MariaDB and MySQL share the same connection libraries, yes? I can share my experiences here.
> > > > 
> > > > May someone show me details, how I can set up Ciphermail/Hibernating using a MariaDB?
> > > > 
> > > > Thanx!
> > > > 
> > > > ttyl  
> > > > Django  
> > > > --  
> > > > [http://dokuwiki.nausch.org](http://dokuwiki.nausch.org)  
> > > > [http://wetterstation-pliening.info](http://wetterstation-pliening.info)  
> > > > [http://ebersberger-liedersammlung.de](http://ebersberger-liedersammlung.de)
> > > > 
> > > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > > > Users mailing list  
> > > > Users(a)lists.djigzo.com  
> > > > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)
> > > 
> > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > > Users mailing list  
> > > Users(a)lists.djigzo.com  
> > > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

---

<div class="post-metadata">

**Author:** ![Django](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@Django](https://community.ciphermail.com/u/Django)\
**Post date:** [June 30, 2015, 4:38pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/14 "2015-06-30T16:38:52Z")

</div>

HI Laz!

> Those folder paths and files are where I have CipherMail installed,  
> your installation may be different.

Fine! 😉 I've installed Ciphermail based on RPM, so the path are  
exactly the same here. Tomorrow morning my colleague an me are working  
on MariaDB support.

> You can get the MySQL JDBC driver from  
> [http://dev.mysql.com/downloads/connector/j/](http://dev.mysql.com/downloads/connector/j/)

Thanx for your usefull hints!

cul8r  
Django

> **···**
>
> Am 30.06.2015 um 16:54 schrieb Laz C. Peterson:

---

<div class="post-metadata">

**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:** [July 4, 2015, 9:27pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/15 "2015-07-04T21:27:15Z")

</div>

Hi,

It turned out that adding support for MySQL (MariaDB) was more work than  
just changing the Hibernate dialect. We had to make sure that the  
required changes did not require existing users to update the database.  
Modifying all the unit tests to support different databases was also  
quite a bit of work. That said, now we have it working for MySQL, in  
principle adding support for other database (if ever) is now relative easy.

We have uploaded an RPM which does not depend on Postgres and contains  
the required configuration files for MySQL.

The RPMs can be downloaded from

Backend;

[http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm](http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm)

Web GUI:

[http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm](http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm)

Instructions:

1. Install RPMs

Install the RPMs using the quick install guide  
([Quick setup — CipherMail Documentation](https://www.ciphermail.com/documents/quick-install-guide.txt))

Note: skip the parts about postgres

2. Install and configure MySQL (MariaDB)

Install MySQL

yum -y install mariadb-server mariadb  
systemctl start mariadb  
systemctl enable mariadb

max\_allowed\_packet should be set to a high value (in mysql config)

$ vi /etc/my.cnf.d/server.cnf

Add the following line below [server]

max\_allowed\_packet = 128M

Note: the max size depends on the largest email, CRL you want to support.

systemctl restart mariadb

3. Create database user and database

mysql -u root

CREATE USER 'djigzo'@'localhost' IDENTIFIED BY 'djigzo';  
CREATE DATABASE djigzo CHARACTER SET utf8 COLLATE utf8\_general\_ci;  
GRANT ALL ON djigzo.\* TO 'djigzo'@'localhost';

Note 1: The database should be set to UTF8  
Note 2: ALL permission should probably be changed to a lower privilege  
but we did not yet check what the minimal required privileges are.

4. Import database scheme

$ mysql -u djigzo --password=djigzo djigzo \<  
/usr/share/djigzo/conf/database/sql/djigzo.mysql.sql

5. Tell CipherMail to use MySQL

$ vi /usr/share/djigzo/wrapper/djigzo.wrapper.conf

Uncomment the line:

wrapper.java.additional.15=-Dciphermail.hibernate.database.type=mysql

6. Restart

/etc/init.d/djigzo restart

Because if licensing issues, we use the JDBC driver from MariaDB  
([Download MariaDB Server - MariaDB.org](https://downloads.mariadb.org/connector-java/)). If you insist on using  
the driver from MySQL, you need to remove the MariaDB jdbc driver, add  
the MySQL JDBC driver and configure the hibernate config file to use the  
MySQL driver.

The RPM is probably not final so it might change. We are thinking of  
splitting up the packages (RPM, deb) into a back-end package which does  
not automatically configure Postgres and a database specific back-end  
package which depends on the main back-end package.

Let me know how it goes.

Kind regards,

Martijn Brinkers

> **···**
>
> On 06/30/2015 09:37 AM, django(a)nausch.org wrote:
> 
> > Griasde Martijn!
> > 
> > Quoting "Martijn Brinkers" martijn(a)djigzo.com:
> > 
> > > Interesting. Why is Postgres not allowed?
> > 
> > It's a political decision - we can use following prioroties ans databeses:
> > 
> > 1st Oracle 12  
> > 2nd MariaDB
> > 
> > > Anyway, perhaps it's not of legal reasons but some technical reason.
> > 
> > FULLACK
> > 
> > > That said, Maria DB is not directly supported but you can see whether  
> > > you can make it work with Maria DB.
> > 
> > That's a very good idea If you can tell me technical details about  
> > changing the backend database, I'll do it, test it and give feedback to  
> > you!
> > 
> > > The database layer uses Hibernate (which is an ORM library).
> > 
> > My colleague Klaus, my database specialist, assumed, that your are using  
> > Hibernate.
> > 
> > > This however has never tested but it you are willing to spend some  
> > > time testing it, I can assist you.
> > 
> > Oh yes, I'll make this tests! So please tell me, what I should do!
> > 
> > Thanks for help!!!
> > 
> > Best regards  
> > Django
> 
> --  
> 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)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [July 4, 2015, 11:44pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/16 "2015-07-04T23:44:23Z")

</div>

Martijn, as always, you are awesome!

Running Ubuntu over here, would I be able to “alien” these .rpm files into .deb and get the same results?

I am really looking forward to trying this out tomorrow. Thank you for your efforts, this is greatly appreciated!

Cheers.

~ Laz Peterson  
Paravis, LLC  
Ph: 951.319.3240 x201

> **···**
>
> > On Jul 4, 2015, at 2:27 PM, Martijn Brinkers \<martijn(a)djigzo.com\> wrote:
> > 
> > Hi,
> > 
> > It turned out that adding support for MySQL (MariaDB) was more work than  
> > just changing the Hibernate dialect. We had to make sure that the  
> > required changes did not require existing users to update the database.  
> > Modifying all the unit tests to support different databases was also  
> > quite a bit of work. That said, now we have it working for MySQL, in  
> > principle adding support for other database (if ever) is now relative easy.
> > 
> > We have uploaded an RPM which does not depend on Postgres and contains  
> > the required configuration files for MySQL.
> > 
> > The RPMs can be downloaded from
> > 
> > Backend;
> > 
> > [http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm](http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm)
> > 
> > Web GUI:
> > 
> > [http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm](http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm)
> > 
> > Instructions:
> > 
> > 1. Install RPMs
> > 
> > Install the RPMs using the quick install guide  
> > ([Quick setup — CipherMail Documentation](https://www.ciphermail.com/documents/quick-install-guide.txt))
> > 
> > Note: skip the parts about postgres
> > 
> > 2. Install and configure MySQL (MariaDB)
> > 
> > Install MySQL
> > 
> > yum -y install mariadb-server mariadb  
> > systemctl start mariadb  
> > systemctl enable mariadb
> > 
> > max\_allowed\_packet should be set to a high value (in mysql config)
> > 
> > $ vi /etc/my.cnf.d/server.cnf
> > 
> > Add the following line below [server]
> > 
> > max\_allowed\_packet = 128M
> > 
> > Note: the max size depends on the largest email, CRL you want to support.
> > 
> > systemctl restart mariadb
> > 
> > 3. Create database user and database
> > 
> > mysql -u root
> > 
> > CREATE USER 'djigzo'@'localhost' IDENTIFIED BY 'djigzo';  
> > CREATE DATABASE djigzo CHARACTER SET utf8 COLLATE utf8\_general\_ci;  
> > GRANT ALL ON djigzo.\* TO 'djigzo'@'localhost';
> > 
> > Note 1: The database should be set to UTF8  
> > Note 2: ALL permission should probably be changed to a lower privilege  
> > but we did not yet check what the minimal required privileges are.
> > 
> > 4. Import database scheme
> > 
> > $ mysql -u djigzo --password=djigzo djigzo \<  
> > /usr/share/djigzo/conf/database/sql/djigzo.mysql.sql
> > 
> > 5. Tell CipherMail to use MySQL
> > 
> > $ vi /usr/share/djigzo/wrapper/djigzo.wrapper.conf
> > 
> > Uncomment the line:
> > 
> > wrapper.java.additional.15=-Dciphermail.hibernate.database.type=mysql
> > 
> > 6. Restart
> > 
> > /etc/init.d/djigzo restart
> > 
> > Because if licensing issues, we use the JDBC driver from MariaDB  
> > ([Download MariaDB Server - MariaDB.org](https://downloads.mariadb.org/connector-java/)). If you insist on using  
> > the driver from MySQL, you need to remove the MariaDB jdbc driver, add  
> > the MySQL JDBC driver and configure the hibernate config file to use the  
> > MySQL driver.
> > 
> > The RPM is probably not final so it might change. We are thinking of  
> > splitting up the packages (RPM, deb) into a back-end package which does  
> > not automatically configure Postgres and a database specific back-end  
> > package which depends on the main back-end package.
> > 
> > Let me know how it goes.
> > 
> > Kind regards,
> > 
> > Martijn Brinkers
> > 
> > On 06/30/2015 09:37 AM, django(a)nausch.org \<mailto:django(a)[nausch.org](http://nausch.org)\> wrote:
> > 
> > > Griasde Martijn!
> > > 
> > > Quoting "Martijn Brinkers" martijn(a)djigzo.com:
> > > 
> > > > Interesting. Why is Postgres not allowed?
> > > 
> > > It's a political decision - we can use following prioroties ans databeses:
> > > 
> > > 1st Oracle 12  
> > > 2nd MariaDB
> > > 
> > > > Anyway, perhaps it's not of legal reasons but some technical reason.
> > > 
> > > FULLACK
> > > 
> > > > That said, Maria DB is not directly supported but you can see whether  
> > > > you can make it work with Maria DB.
> > > 
> > > That's a very good idea If you can tell me technical details about  
> > > changing the backend database, I'll do it, test it and give feedback to  
> > > you!
> > > 
> > > > The database layer uses Hibernate (which is an ORM library).
> > > 
> > > My colleague Klaus, my database specialist, assumed, that your are using  
> > > Hibernate.
> > > 
> > > > This however has never tested but it you are willing to spend some  
> > > > time testing it, I can assist you.
> > > 
> > > Oh yes, I'll make this tests! So please tell me, what I should do!
> > > 
> > > Thanks for help!!!
> > > 
> > > Best regards  
> > > Django
> > 
> > --  
> > CipherMail email encryption
> > 
> > Open source email encryption gateway with support for S/MIME, OpenPGP  
> > and PDF messaging.
> > 
> > [https://www.ciphermail.com/&gt](https://www.ciphermail.com/&gt);
> > 
> > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)  
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com \<mailto:Users(a)[lists.djigzo.com](http://lists.djigzo.com)\>  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

---

<div class="post-metadata">

**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:** [July 5, 2015, 8:24am UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/17 "2015-07-05T08:24:24Z")

</div>

Hi Laz,

The Ubuntu/Debian version can be downloaded from:

Backend:

[http://www.ciphermail.com/downloads/other/djigzo\_2.10.3-0\_all-no-database.deb](http://www.ciphermail.com/downloads/other/djigzo_2.10.3-0_all-no-database.deb)

Web GUI:

[http://www.ciphermail.com/downloads/other/djigzo-web\_2.10.3-0\_all.deb](http://www.ciphermail.com/downloads/other/djigzo-web_2.10.3-0_all.deb)

(add .asc for GPG sig)

Kind regards,

Martijn Brinkers

> Martijn, as always, you are awesome!
> 
> Running Ubuntu over here, would I be able to “alien” these .rpm files  
> into .deb and get the same results?
> 
> I am really looking forward to trying this out tomorrow. Thank you  
> for your efforts, this is greatly appreciated!
> 
> Cheers.
> 
> ~ Laz Peterson Paravis, LLC Ph: 951.319.3240 x201
> 
> > Hi,
> > 
> > It turned out that adding support for MySQL (MariaDB) was more work  
> > than just changing the Hibernate dialect. We had to make sure that  
> > the required changes did not require existing users to update the  
> > database. Modifying all the unit tests to support different  
> > databases was also quite a bit of work. That said, now we have it  
> > working for MySQL, in principle adding support for other database  
> > (if ever) is now relative easy.
> > 
> > We have uploaded an RPM which does not depend on Postgres and  
> > contains the required configuration files for MySQL.
> > 
> > The RPMs can be downloaded from
> > 
> > Backend;
> > 
> > [http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm](http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm)  
> > \<[http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm&gt](http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm&gt);

Web GUI:

> > [http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm](http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm)  
> > \<[http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm&gt](http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm&gt);

Instructions:

> > 1. Install RPMs
> > 
> > Install the RPMs using the quick install guide  
> > ([Quick setup — CipherMail Documentation](https://www.ciphermail.com/documents/quick-install-guide.txt)  
> > \<[https://www.ciphermail.com/documents/quick-install-guide.txt&gt;\](https://www.ciphermail.com/documents/quick-install-guide.txt&gt;%5C))
> > 
> > Note: skip the parts about postgres
> > 
> > 2. Install and configure MySQL (MariaDB)
> > 
> > Install MySQL
> > 
> > yum -y install mariadb-server mariadb systemctl start mariadb  
> > systemctl enable mariadb
> > 
> > max\_allowed\_packet should be set to a high value (in mysql config)
> > 
> > $ vi /etc/my.cnf.d/server.cnf
> > 
> > Add the following line below [server]
> > 
> > max\_allowed\_packet = 128M
> > 
> > Note: the max size depends on the largest email, CRL you want to  
> > support.
> > 
> > systemctl restart mariadb
> > 
> > 3. Create database user and database
> > 
> > mysql -u root
> > 
> > CREATE USER 'djigzo'@'localhost' IDENTIFIED BY 'djigzo'; CREATE  
> > DATABASE djigzo CHARACTER SET utf8 COLLATE utf8\_general\_ci; GRANT  
> > ALL ON djigzo.\* TO 'djigzo'@'localhost';
> > 
> > Note 1: The database should be set to UTF8 Note 2: ALL permission  
> > should probably be changed to a lower privilege but we did not yet  
> > check what the minimal required privileges are.
> > 
> > 4. Import database scheme
> > 
> > $ mysql -u djigzo --password=djigzo djigzo \<  
> > /usr/share/djigzo/conf/database/sql/djigzo.mysql.sql
> > 
> > 5. Tell CipherMail to use MySQL
> > 
> > $ vi /usr/share/djigzo/wrapper/djigzo.wrapper.conf
> > 
> > Uncomment the line:
> > 
> > wrapper.java.additional.15=-Dciphermail.hibernate.database.type=mysql

6. Restart

> **···**
>
> On 07/05/2015 01:44 AM, Laz C. Peterson wrote:
> 
> > > On Jul 4, 2015, at 2:27 PM, Martijn Brinkers \<martijn(a)djigzo.com\> \>\> wrote:
> > > 
> > > /etc/init.d/djigzo restart
> > > 
> > > Because if licensing issues, we use the JDBC driver from MariaDB  
> > > ([Download MariaDB Server - MariaDB.org](https://downloads.mariadb.org/connector-java/)  
> > > \<[Download MariaDB Server - MariaDB.org](https://downloads.mariadb.org/connector-java/&gt;%5C)). If you insist on  
> > > using the driver from MySQL, you need to remove the MariaDB jdbc  
> > > driver, add the MySQL JDBC driver and configure the hibernate  
> > > config file to use the MySQL driver.
> > > 
> > > The RPM is probably not final so it might change. We are thinking  
> > > of splitting up the packages (RPM, deb) into a back-end package  
> > > which does not automatically configure Postgres and a database  
> > > specific back-end package which depends on the main back-end  
> > > package.
> > > 
> > > Let me know how it goes.
> > > 
> > > Kind regards,
> > > 
> > > Martijn Brinkers
> > > 
> > > On 06/30/2015 09:37 AM, django(a)nausch.org \>\> \<mailto:django(a)[nausch.org](http://nausch.org)\> wrote:
> > > 
> > > > Griasde Martijn!
> > > > 
> > > > Quoting "Martijn Brinkers" martijn(a)djigzo.com:
> > > > 
> > > > > Interesting. Why is Postgres not allowed?
> > > > 
> > > > It's a political decision - we can use following prioroties ans  
> > > > databeses:
> > > > 
> > > > 1st Oracle 12 2nd MariaDB
> > > > 
> > > > > Anyway, perhaps it's not of legal reasons but some technical  
> > > > > reason.
> > > > 
> > > > FULLACK
> > > > 
> > > > > That said, Maria DB is not directly supported but you can see  
> > > > > whether you can make it work with Maria DB.
> > > > 
> > > > That's a very good idea If you can tell me technical details  
> > > > about changing the backend database, I'll do it, test it and  
> > > > give feedback to you!
> > > > 
> > > > > The database layer uses Hibernate (which is an ORM library).
> > > > 
> > > > My colleague Klaus, my database specialist, assumed, that your  
> > > > are using Hibernate.
> > > > 
> > > > > This however has never tested but it you are willing to spend  
> > > > > some time testing it, I can assist you.
> > > > 
> > > > Oh yes, I'll make this tests! So please tell me, what I should  
> > > > do!
> > > > 
> > > > Thanks for help!!!
> > > > 
> > > > Best regards Django
> > > 
> > > -- CipherMail email encryption
> > > 
> > > Open source email encryption gateway with support for S/MIME,  
> > > OpenPGP and PDF messaging.
> > > 
> > > [https://www.ciphermail.com/&gt](https://www.ciphermail.com/&gt);
> > > 
> > > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)  
> > > \<[http://twitter.com/CipherMail&gt](http://twitter.com/CipherMail&gt);  
> > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Users mailing list  
> > > Users(a)lists.djigzo.com \<mailto:Users(a)[lists.djigzo.com](http://lists.djigzo.com)\>  
> > > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)  
> > > \<[https://lists.djigzo.com/lists/listinfo/users&gt](https://lists.djigzo.com/lists/listinfo/users&gt);
> > 
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Users mailing list  
> > Users(a)lists.djigzo.com [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)
> 
> --  
> 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)
> 
> --  
> 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)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [July 5, 2015, 5:51pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/18 "2015-07-05T17:51:17Z")

</div>

Hello Martijn, thank you for these .deb files. I have set up the test server and all looks to be running smoothly except for (so far) one thing I have noticed.

When importing certificates or keys under “Certificates” menu, we are getting an error that says:

Keys: The private key file could not be imported. Cause: ClassNotFoundException: org.bouncycastle.jcajce.provider.keystore.pkcs12.PKCS12KeyStoreSpi$BCPKCS12KeyStore  
Certificates: An unexpected application exception has occurred. org/bouncycastle/asn1/ANS1InputStream

Since I am not tossing this into production just yet, I don’t know of a way to test the certificates/keys automatically importing from incoming emails. If you have a way to do that without being a live relay, I would be happy to test.

Also, the /etc/djigzo folder no longer contains the symbolic links to the CipherMail configuration files. (/etc/djigzo-web is fine.)

Other than that, looks great! Thanks again Martijn, your help is greatly appreciated. I will let you know if I see anything else that looks interesting.

~ Laz Peterson  
Paravis, LLC  
Ph: 951.319.3240 x201

> **···**
>
> > On Jul 5, 2015, at 1:24 AM, Martijn Brinkers \<martijn(a)ciphermail.com\> wrote:
> > 
> > Hi Laz,
> > 
> > The Ubuntu/Debian version can be downloaded from:
> > 
> > Backend:
> > 
> > [http://www.ciphermail.com/downloads/other/djigzo\_2.10.3-0\_all-no-database.deb](http://www.ciphermail.com/downloads/other/djigzo_2.10.3-0_all-no-database.deb)
> > 
> > Web GUI:
> > 
> > [http://www.ciphermail.com/downloads/other/djigzo-web\_2.10.3-0\_all.deb](http://www.ciphermail.com/downloads/other/djigzo-web_2.10.3-0_all.deb)
> > 
> > (add .asc for GPG sig)
> > 
> > Kind regards,
> > 
> > Martijn Brinkers
> > 
> > On 07/05/2015 01:44 AM, Laz C. Peterson wrote:
> > 
> > > Martijn, as always, you are awesome!
> > > 
> > > Running Ubuntu over here, would I be able to “alien” these .rpm files  
> > > into .deb and get the same results?
> > > 
> > > I am really looking forward to trying this out tomorrow. Thank you  
> > > for your efforts, this is greatly appreciated!
> > > 
> > > Cheers.
> > > 
> > > ~ Laz Peterson Paravis, LLC Ph: 951.319.3240 x201
> > > 
> > > > On Jul 4, 2015, at 2:27 PM, Martijn Brinkers \<martijn(a)djigzo.com\> \>\>\> wrote:
> > > > 
> > > > Hi,
> > > > 
> > > > It turned out that adding support for MySQL (MariaDB) was more work  
> > > > than just changing the Hibernate dialect. We had to make sure that  
> > > > the required changes did not require existing users to update the  
> > > > database. Modifying all the unit tests to support different  
> > > > databases was also quite a bit of work. That said, now we have it  
> > > > working for MySQL, in principle adding support for other database  
> > > > (if ever) is now relative easy.
> > > > 
> > > > We have uploaded an RPM which does not depend on Postgres and  
> > > > contains the required configuration files for MySQL.
> > > > 
> > > > The RPMs can be downloaded from
> > > > 
> > > > Backend;
> > > > 
> > > > [http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm](http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm)  
> > > > \<[http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm&gt](http://www.ciphermail.com/downloads/other/djigzo-2.10.3-0.noarch-no-database.rpm&gt);
> > 
> > Web GUI:
> > 
> > > > [http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm](http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm)  
> > > > \<[http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm&gt](http://www.ciphermail.com/downloads/other/djigzo-web-2.10.3-0.noarch.rpm&gt);
> > 
> > Instructions:
> > 
> > > > 1. Install RPMs
> > > > 
> > > > Install the RPMs using the quick install guide  
> > > > ([Quick setup — CipherMail Documentation](https://www.ciphermail.com/documents/quick-install-guide.txt)  
> > > > \<[https://www.ciphermail.com/documents/quick-install-guide.txt&gt;\](https://www.ciphermail.com/documents/quick-install-guide.txt&gt;%5C))
> > > > 
> > > > Note: skip the parts about postgres
> > > > 
> > > > 2. Install and configure MySQL (MariaDB)
> > > > 
> > > > Install MySQL
> > > > 
> > > > yum -y install mariadb-server mariadb systemctl start mariadb  
> > > > systemctl enable mariadb
> > > > 
> > > > max\_allowed\_packet should be set to a high value (in mysql config)
> > > > 
> > > > $ vi /etc/my.cnf.d/server.cnf
> > > > 
> > > > Add the following line below [server]
> > > > 
> > > > max\_allowed\_packet = 128M
> > > > 
> > > > Note: the max size depends on the largest email, CRL you want to  
> > > > support.
> > > > 
> > > > systemctl restart mariadb
> > > > 
> > > > 3. Create database user and database
> > > > 
> > > > mysql -u root
> > > > 
> > > > CREATE USER 'djigzo'@'localhost' IDENTIFIED BY 'djigzo'; CREATE  
> > > > DATABASE djigzo CHARACTER SET utf8 COLLATE utf8\_general\_ci; GRANT  
> > > > ALL ON djigzo.\* TO 'djigzo'@'localhost';
> > > > 
> > > > Note 1: The database should be set to UTF8 Note 2: ALL permission  
> > > > should probably be changed to a lower privilege but we did not yet  
> > > > check what the minimal required privileges are.
> > > > 
> > > > 4. Import database scheme
> > > > 
> > > > $ mysql -u djigzo --password=djigzo djigzo \<  
> > > > /usr/share/djigzo/conf/database/sql/djigzo.mysql.sql
> > > > 
> > > > 5. Tell CipherMail to use MySQL
> > > > 
> > > > $ vi /usr/share/djigzo/wrapper/djigzo.wrapper.conf
> > > > 
> > > > Uncomment the line:
> > > > 
> > > > wrapper.java.additional.15=-Dciphermail.hibernate.database.type=mysql
> > 
> > 6. Restart
> > 
> > > > /etc/init.d/djigzo restart
> > > > 
> > > > Because if licensing issues, we use the JDBC driver from MariaDB  
> > > > ([Download MariaDB Server - MariaDB.org](https://downloads.mariadb.org/connector-java/)  
> > > > \<[Download MariaDB Server - MariaDB.org](https://downloads.mariadb.org/connector-java/&gt;%5C)). If you insist on  
> > > > using the driver from MySQL, you need to remove the MariaDB jdbc  
> > > > driver, add the MySQL JDBC driver and configure the hibernate  
> > > > config file to use the MySQL driver.
> > > > 
> > > > The RPM is probably not final so it might change. We are thinking  
> > > > of splitting up the packages (RPM, deb) into a back-end package  
> > > > which does not automatically configure Postgres and a database  
> > > > specific back-end package which depends on the main back-end  
> > > > package.
> > > > 
> > > > Let me know how it goes.
> > > > 
> > > > Kind regards,
> > > > 
> > > > Martijn Brinkers
> > > > 
> > > > On 06/30/2015 09:37 AM, django(a)nausch.org \>\>\> \<mailto:django(a)[nausch.org](http://nausch.org)\> wrote:
> > > > 
> > > > > Griasde Martijn!
> > > > > 
> > > > > Quoting "Martijn Brinkers" martijn(a)djigzo.com:
> > > > > 
> > > > > > Interesting. Why is Postgres not allowed?
> > > > > 
> > > > > It's a political decision - we can use following prioroties ans  
> > > > > databeses:
> > > > > 
> > > > > 1st Oracle 12 2nd MariaDB
> > > > > 
> > > > > > Anyway, perhaps it's not of legal reasons but some technical  
> > > > > > reason.
> > > > > 
> > > > > FULLACK
> > > > > 
> > > > > > That said, Maria DB is not directly supported but you can see  
> > > > > > whether you can make it work with Maria DB.
> > > > > 
> > > > > That's a very good idea If you can tell me technical details  
> > > > > about changing the backend database, I'll do it, test it and  
> > > > > give feedback to you!
> > > > > 
> > > > > > The database layer uses Hibernate (which is an ORM library).
> > > > > 
> > > > > My colleague Klaus, my database specialist, assumed, that your  
> > > > > are using Hibernate.
> > > > > 
> > > > > > This however has never tested but it you are willing to spend  
> > > > > > some time testing it, I can assist you.
> > > > > 
> > > > > Oh yes, I'll make this tests! So please tell me, what I should  
> > > > > do!
> > > > > 
> > > > > Thanks for help!!!
> > > > > 
> > > > > Best regards Django
> > > > 
> > > > -- CipherMail email encryption
> > > > 
> > > > Open source email encryption gateway with support for S/MIME,  
> > > > OpenPGP and PDF messaging.
> > > > 
> > > > [https://www.ciphermail.com/&gt](https://www.ciphermail.com/&gt);
> > > > 
> > > > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)  
> > > > \<[http://twitter.com/CipherMail&gt](http://twitter.com/CipherMail&gt);  
> > > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Users mailing list  
> > > > Users(a)lists.djigzo.com \<mailto:Users(a)[lists.djigzo.com](http://lists.djigzo.com)\>  
> > > > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)  
> > > > \<[https://lists.djigzo.com/lists/listinfo/users&gt](https://lists.djigzo.com/lists/listinfo/users&gt);
> > > 
> > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Users mailing list  
> > > Users(a)lists.djigzo.com [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)
> > 
> > --  
> > CipherMail email encryption
> > 
> > Open source email encryption gateway with support for S/MIME, OpenPGP  
> > and PDF messaging.
> > 
> > [https://www.ciphermail.com](https://www.ciphermail.com)
> > 
> > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)
> > 
> > --  
> > CipherMail email encryption
> > 
> > Open source email encryption gateway with support for S/MIME, OpenPGP  
> > and PDF messaging.
> > 
> > [https://www.ciphermail.com](https://www.ciphermail.com)
> > 
> > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)  
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

---

<div class="post-metadata">

**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:** [July 5, 2015, 7:49pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/19 "2015-07-05T19:49:17Z")

</div>

> Hello Martijn, thank you for these .deb files. I have set up the  
> test server and all looks to be running smoothly except for (so far)  
> one thing I have noticed.
> 
> When importing certificates or keys under “Certificates” menu, we are  
> getting an error that says:
> 
> Keys: The private key file could not be imported. Cause:  
> ClassNotFoundException:  
> org.bouncycastle.jcajce.provider.keystore.pkcs12.PKCS12KeyStoreSpi$BCPKCS12KeyStore  
> Certificates: An unexpected application exception has occurred.  
> org/bouncycastle/asn1/ANS1InputStream

Could it be that you upgraded an existing server and forgot to restart  
tomcat? I just tested it with a fresh installation on Ubuntu 14.04 and  
was able to import a p12 (pfx) file without any problem.

> Since I am not tossing this into production just yet, I don’t know of  
> a way to test the certificates/keys automatically importing from  
> incoming emails. If you have a way to do that without being a live  
> relay, I would be happy to test.
> 
> Also, the /etc/djigzo folder no longer contains the symbolic links to  
> the CipherMail configuration files. (/etc/djigzo-web is fine.)

This was already changed with the last release (2.10.0-3). I decided  
that it was not worth the effort to symlink all config files from /etc/  
to the real dir. Some config files were symlinked from /etc/ and some  
were not.

Kind regards,

Martijn Brinkers

> **···**
>
> On 07/05/2015 07:51 PM, Laz C. Peterson wrote:
> 
> --  
> 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)
> 
> --  
> 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)

---

<div class="post-metadata">

**Author:** ![Laz\_C\_Peterson](https://avatars.discourse-cdn.com/v4/letter/l/94ad74/32.png) [@Laz\_C\_Peterson](https://community.ciphermail.com/u/Laz_C_Peterson)\
**Post date:** [July 5, 2015, 7:50pm UTC](https://community.ciphermail.com/t/ciphermail-and-mariadb/449/20 "2015-07-05T19:50:11Z")

</div>

Ah, let me try restarting Tomcat.

~ Laz Peterson  
Paravis, LLC

> **···**
>
> > On Jul 5, 2015, at 12:49 PM, Martijn Brinkers \<martijn(a)ciphermail.com\> wrote:
> > 
> > On 07/05/2015 07:51 PM, Laz C. Peterson wrote:
> > 
> > > Hello Martijn, thank you for these .deb files. I have set up the  
> > > test server and all looks to be running smoothly except for (so far)  
> > > one thing I have noticed.
> > > 
> > > When importing certificates or keys under “Certificates” menu, we are  
> > > getting an error that says:
> > > 
> > > Keys: The private key file could not be imported. Cause:  
> > > ClassNotFoundException:  
> > > org.bouncycastle.jcajce.provider.keystore.pkcs12.PKCS12KeyStoreSpi$BCPKCS12KeyStore  
> > > Certificates: An unexpected application exception has occurred.  
> > > org/bouncycastle/asn1/ANS1InputStream
> > 
> > Could it be that you upgraded an existing server and forgot to restart  
> > tomcat? I just tested it with a fresh installation on Ubuntu 14.04 and  
> > was able to import a p12 (pfx) file without any problem.
> > 
> > > Since I am not tossing this into production just yet, I don’t know of  
> > > a way to test the certificates/keys automatically importing from  
> > > incoming emails. If you have a way to do that without being a live  
> > > relay, I would be happy to test.
> > > 
> > > Also, the /etc/djigzo folder no longer contains the symbolic links to  
> > > the CipherMail configuration files. (/etc/djigzo-web is fine.)
> > 
> > This was already changed with the last release (2.10.0-3). I decided  
> > that it was not worth the effort to symlink all config files from /etc/  
> > to the real dir. Some config files were symlinked from /etc/ and some  
> > were not.
> > 
> > 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](https://www.ciphermail.com)
> > 
> > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)
> > 
> > --  
> > CipherMail email encryption
> > 
> > Open source email encryption gateway with support for S/MIME, OpenPGP  
> > and PDF messaging.
> > 
> > [https://www.ciphermail.com](https://www.ciphermail.com)
> > 
> > Twitter: [http://twitter.com/CipherMail](http://twitter.com/CipherMail)  
> > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_  
> > Users mailing list  
> > Users(a)lists.djigzo.com  
> > [https://lists.djigzo.com/lists/listinfo/users](https://lists.djigzo.com/lists/listinfo/users)

[Next page](https://community.ciphermail.com/t/ciphermail-and-mariadb/449.md?page=2)