[Opendnssec-user] how to convert my database Sqlite3 to Mysql

[Sebastian Castro]

On 26/02/14 22:00, Ramanou Biaou wrote:
> Thank you!
> I do it, so I have this errors
> 
> # enforcer/utils/convert_database.pl --from
> dbi:SQLite:dbname=/var/opendnssec/kasp.db --to
> dbi:mysql:database=kasp;host=localhost --to-username kaspuser
> --to-password 123456
> install_driver(SQLite) failed: Can't locate DBD/SQLite.pm in @INC (@INC
> contains: /etc/perl /usr/local/lib/perl/5.14.2
> /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5
> /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at
> (eval 6) line 3.
> 
> Perhaps the DBD::SQLite perl module hasn't been fully installed,
> or perhaps the capitalisation of 'SQLite' isn't right.
> Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge, mysql.
>  at enforcer/utils/convert_database.pl line 144
> -bash: --to-username : commande introuvable
> 

You are missing the Perl Sqlite DBD. Assuming Debian/Ubuntu, it's
provided by the package 'libdbd-sqlite3-perl'

If you are using a different OS or distribution, you need to find a way
to install it.

Once you figured it out, you can test if the conversion script can run
by executing

perl -c enforcer/utils/convert_database.pl

Cheers,

> 
> Le 25/02/2014 17:18, Volker Janzen a écrit :
>> Hi,
>>
>> there is a guide in the OpenDNSSEC wiki:
>>
>> https://wiki.opendnssec.org/display/DOCS/Migrating+between+supported+database+backends
>>
>> I needed the MySQL root password on my machine to complete the migration.
>>
>>
>> Regards,
>>      Volker
>>
>>
>> Am 25.02.2014 um 17:13 schrieb Ramanou Biaou <ramanou at netim.com
>> <mailto:ramanou at netim.com>>:
>>
>>> Hello
>>> Please tell me how to convert my database Sqlite3 to Mysql with
>>> opendnssec.
>>>
>>> Thank!
>>>
>>> Ramanou
>>> _______________________________________________
>>> Opendnssec-user mailing list
>>> Opendnssec-user at lists.opendnssec.org
>>> <mailto:Opendnssec-user at lists.opendnssec.org>
>>> https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
>>>
> 
> 
> 
> _______________________________________________
> Opendnssec-user mailing list
> Opendnssec-user at lists.opendnssec.org
> https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
> 


-- 
Sebastian Castro
Technical Research Manager
.nz Registry Services (New Zealand Domain Name Registry Limited)
desk: +64 4 495 2337
mobile: +64 21 400535