On 06/03/2016 12:48 AM, Prof. Dr. Michael Schefczyk wrote: > Dear All, > > In preparing to move the two Ciphermail servers (djigzo_3.0.5-0) I am > keeping in a dual SOHO situation from Centos 6 to Centos 7, I would > also very much like to switch from postgres to mysql. That would > allow me to work with a Percona mysql cluster to synchronize the > servers instead of continuing with bucardo synchronization or > investigate the new built-in and probably better postgres > synchronization possibilities. > > Based on the install instructions, I was able to setup Ciphermail on > Centos 7 with mysql. Running "mysql djigzo < > /usr/local/djigzo/conf/database/sql/djigzo.mysql.sql" (in my case > modified to run on an external host) does create the usual 29 > tables. > > What I find myself unable to do is to convert the data (admin, > atmin_authority, authority, blob, current certificates, > certificates_email, properties, crls, keyring, keyring_email, > keyring_userid, keystore, named_blob, pgp_trust_list, > pgp_trust_list_namevalues, properties, properties_namevalues, > userpreferences, userpreferences_certificates, > userpreferences_inheritedpreferences, > userpreferences_named_certificates, users) from postgres to mysql. I > was naively thinking that ODBC and mysql workbench could do the job > in a straightforward manner, but I did not find that feasible. For > example, there are lots of "truncated key column length ..." warnings > (logfile available upon request) and I did not find the result to > work. I must admit that I am far from being a database expert also. > > Is it realistic to migrate the database or would one have to start > from scratch even in terms of users and certificates?
Unfortunately an easy migration path is currently not available. The problem is that MySQL has some strict requirements about table names, length of fields, types etc. It's therefore not as easy as copying the tables one to one. The most important data is the certificates, keys and PGP keys. These can be exported from the gateway to a file which can then be imported into the gateway. A user object is only required if you override an inherited value so in most cases a user object is not required. Kind regards, Martijn Brinkers -- CipherMail email encryption Email encryption with support for S/MIME, OpenPGP, PDF encryption and secure webmail pull. https://www.ciphermail.com Twitter: http://twitter.com/CipherMail -- CipherMail email encryption Email encryption with support for S/MIME, OpenPGP, PDF encryption and secure webmail pull. https://www.ciphermail.com Twitter: http://twitter.com/CipherMail _______________________________________________ Users mailing list [email protected] https://lists.djigzo.com/lists/listinfo/users
