Matt Simerson
Matt Simerson
The latter condition is being resolved by modifying the last_publish field to 'DATETIME DEFAULT NULL'. Timestamp fields don't support NULL where DATETIME fields do.
For now, the way to work around this is to first see what SQL modes are active in the version of MySQL you have installed with this query: `SELECT @@sql_mode;`....
Zones and records already have a field for storing locations. The tinydns exports will include the location information in the exports.
The Location field is now exposed in NicTool Client.
> From my limited perl skills, I'm thinking something like an extra grep to only include records that have a matching location (even if the location is null). Yep, that'd...
Knot also has [GeoIP](https://blog.apnic.net/2018/11/14/geoip-in-knot-dns-2-7/) location support.
Coming soon, with NicTool 3. See [dns-resource-record](https://github.com/NicTool/dns-resource-record)
> The API inserts "0" and this ends up in the zone file, which is silly at best. It's less silly than leaving the field blank, which causes the name...
> I had assumed I could get rid of BIND. That is sad. Knot and NSD are really well done.
As another option, you could always resort to hacking. For example: ``` diff diff --git a/server/lib/NicToolServer/Export/Base.pm b/server/lib/NicToolServer/Export/Base.pm index a3c2349..411784f 100644 --- a/server/lib/NicToolServer/Export/Base.pm +++ b/server/lib/NicToolServer/Export/Base.pm @@ -64,6 +64,7 @@ sub export_db...