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, [email protected] wrote: > > HI Laz! > > Quoting "Laz C. Peterson" <[email protected]>: > >> 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 ( > id bigint NOT NULL, > notbefore timestamp without time zone, > notafter timestamp without time zone, > issuer text, > issuerfriendly text, > serial character varying(1024), > subjectkeyidentifier text, > subject text, > subjectfriendly text, > certificate bytea, > thumbprint character varying(255), > certpath bytea, > certpathtype character varying(255), > creationdate timestamp without time zone, > datepathupdated timestamp without time zone, > keyalias character varying(1024), > storename character varying(255) > ); > > How did you made your database dump from your postgresql? > > > ttyl > Django > -- > http://dokuwiki.nausch.org > http://wetterstation-pliening.info > http://ebersberger-liedersammlung.de > > _______________________________________________ > Users mailing list > [email protected] > https://lists.djigzo.com/lists/listinfo/users _______________________________________________ Users mailing list [email protected] https://lists.djigzo.com/lists/listinfo/users
