Actually can you test it with SELECT 1
The test is just to test whether the database is active or not. The result is not important. It's just a test whether the select returns an error or not. Kind regards, Martijn On 07/06/2015 04:28 PM, Martijn Brinkers wrote: > Yes you are right :( > > I'll fix it. The RPMs have the same problem (since they are built from > the same source). > > The query is defined in the filw > > james-smtphandlerchain.xml > > SELECT 1 FROM user > > For now you can you try: > > SELECT 1 FROM cm_users > > I'll see whether I can come up with a solution which does not depend on > the database to use. > > I'll probably have a version ready today > > Kind regards, > > Martijn > > > On 07/06/2015 04:18 PM, Laz C. Peterson wrote: >> Martijn, we are seeing this in the logs on both servers we set up to use >> MySQL. Looks like there is one more reference to the PostgreSQL database, >> yes? >> >> I tried to grep the /usr/share/djigzo folder but did not find that >> particular reference. >> >> 05 Jul 2015 23:27:16 | WARN SQL Error: 1146, SQLState: 42S02 >> (org.hibernate.util.JDBCExceptionReporter) [default Worker #2] >> 05 Jul 2015 23:27:16 | ERROR Table 'djigzo.user' doesn't exist >> (org.hibernate.util.JDBCExceptionReporter) [default Worker #2] >> 05 Jul 2015 23:27:16 | WARN Unable to open a stateless session. Database is >> probably not active. (mitm.common.hibernate.HibernateUtils) [default >> Worker #2] >> 05 Jul 2015 23:27:16 | WARN Database is not active. >> (mitm.application.djigzo.james.smtpserver.CheckDatabaseBlockingRcptCmdHandler) >> [default Worker #2] >> >> ~Laz >> >> On 7/4/15 2:27 PM, Martijn Brinkers 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 >>> (https://www.ciphermail.com/documents/quick-install-guide.txt >>> <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 >>> (https://downloads.mariadb.org/connector-java/ >>> <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, [email protected] <mailto:[email protected]> wrote: >>>> Griasde Martijn! >>>> >>>> Quoting "Martijn Brinkers" [email protected] <mailto:[email protected]>: >>>> >>>>> 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 >>>> >> >> _______________________________________________ >> Users mailing list >> [email protected] >> 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 Twitter: http://twitter.com/CipherMail _______________________________________________ Users mailing list [email protected] https://lists.djigzo.com/lists/listinfo/users
