[Opendnssec-user] Migrating from sqllite to MySQL

[Jerry Lundström]

Hi,

On Dec 17, 2013, at 11:43 , Volker Janzen wrote:

> I'm currently switching over from sqllite to MySQL with my OpenDNSSEC, because that's recommented for production use. I noticed, that the migration guide on https://wiki.opendnssec.org/display/DOCS/Migrating+between+supported+database+backends does not work this way:
> 
> enforcer/utils/convert_database.pl --from dbi:SQLite:dbname=/var/lib/opendnssec/kasp.db --to dbi:mysql:database=opendnssec;host=localhost --to-username opendnssec --to-password SECRET
> Connected to exporting database dbi:SQLite:dbname=/var/lib/opendnssec/kasp.db
> Validating existing data
> Create the importing database, this will delete existing data? [NO/yes] yes
> Enter importing database password (--to-password):
> 
> -> the command line arguments for MySQL user/password are ignored.

I can't really see how it can be ignored, the code is the same as for --from-password. Is your password an empty string?

> I needed to use the MySQL root password for the migrate:


You should not need to if you setup the database correctly and has given the user the right permissions.

/Jerry

--
Jerry Lundström - OpenDNSSEC Developer
http://www.opendnssec.org/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 625 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.opendnssec.org/pipermail/opendnssec-user/attachments/20131217/c81230da/attachment.bin>