> So noone really tested migrating a MySQL backed OpenDNSSEC > installation from 1.4 to 2.x? I'm a bit concerned about this, as there > are a lot of TLDs using OpenDNSSEC. Do they all still use 1.4? Do they > not use MySQL? Didn't anyone test this in development?
Well, I did test it. But it is a complex migration because the database layout and key state representation changed radically. Unfortunately I can only test a subset of every imaginable situation in my lifetime. It is true (my impression) that most people run OpenDNSSEC with SQLite and the migration script was initially developed (and mostly tested for corner cases and such) for SQLite and later adapted for MySQL. Same database layout, slightly different SQL dialect. In that process there was an oversight of some SQL dialect issues, like the comment syntax. But depending on your MySQL version /and/ the contents of your database this may or may not be a problem. It wasn't for me at the time and went undetected. //Yuri
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Opendnssec-user mailing list [email protected] https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
