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? Regards, Michael _______________________________________________ Users mailing list [email protected] https://lists.djigzo.com/lists/listinfo/users
