Updating the Makefile.PL with MariaDB about nictool HOT 5 CLOSED

Long term my plan is to ditch SQL entirely and move the DNS data into a document store. Beyond that, I haven't given it much thought.

from nictool.

So, Can I send you a PR with the MariaDB dependancy in the Makefile.PL ?? So far under Debian 8.8 it works.

from nictool.

Hi, I have created PR #262. Is there a chance that will be merged? I know that change has the potential of introducing a breaking change. If there is a way to introduce the changes without causing a breaking change, please let me know and I will update it.

from nictool.

I haven't had a chance to look in more detail. Im thinking there's a couple paths forward:

1. Switch dependency to MariaDB
2. Add a bash/sh pre-script that rewrites all the dep files that allows switching engines

from nictool.

Well, at this point, all the scripts involved (except very few scripts) are already mysql AND MqriaDB compatible.

• server/sql/dump_schema.pl
• server/sql/upgrade.pl
• server/bin/nt_powerdns.pl

I never used those but from the code, server/sql/upgrade.pl is asking for the dsn and should therefore be compatible with Mariadb even with the default pointing to mysql.

The server/sql/dump_schema.pl and the server/bin/nt_powerdns.pl have all database credentials and the dsn hard-coded in the script. Editing the dsn while you are changing the credentials and even that script should work. Not sue if that is a the intention, but it should work.

The only remaining files where I could find a reference to mysql dbi connectors is in the .test/ directory and the ,travis.yml. Sadly I have no clue how those are used. If they need changing, please point me the right direction and I will change them too.

from nictool.