3
Александр
no recommendations
no complaints
Project title: Install Maxmind geo-bases in Keitaro TDS
Type of cooperation: One-time project
Section: Administration
Prepayment: without prepayment
Payment methods: Electronic money
Acceptance of requests: from 2019-10-02 until 2019-10-09
Type of cooperation: One-time project
Section: Administration
Prepayment: without prepayment
Payment methods: Electronic money
Acceptance of requests: from 2019-10-02 until 2019-10-09
Project description:
You need to download Maxmind geo-bases in Keitaro TDS, this requires a file in DAT format, which you need to download to a specific directory on the hosting.
I have all the data from Maxmind databases: ISP, City, Country, Connection Type. But they're in SQL.
It looks like this:
For each database (Country, City, ISP, Connection Type) there is a separate sql file that contains the ID and name. Example: City: http://joxi.ru/Vrwle4ghOzEp9m
There is one sql file that combines all the others.
Each line contains the IP address range and all other data.
As follows: (Id, start IP, end IP, ISP, Country, City, Connection type), example of a line:
(193036, 1000000000000, 1000000255, 55456, 2, 1, 1)
Can you convert data from sql files to separate dat files for each database and install it in Keitaro?
The support technician said that this is impossible, since Maxmind has its own binary format, they do not provide tools for compiling such databases. But there may be some workarounds.
If you can do this, leave a request, I will contact you.
I would also be grateful for any constructive comments.
You need to download Maxmind geo-bases in Keitaro TDS, this requires a file in DAT format, which you need to download to a specific directory on the hosting.
I have all the data from Maxmind databases: ISP, City, Country, Connection Type. But they're in SQL.
It looks like this:
For each database (Country, City, ISP, Connection Type) there is a separate sql file that contains the ID and name. Example: City: http://joxi.ru/Vrwle4ghOzEp9m
There is one sql file that combines all the others.
Each line contains the IP address range and all other data.
As follows: (Id, start IP, end IP, ISP, Country, City, Connection type), example of a line:
(193036, 1000000000000, 1000000255, 55456, 2, 1, 1)
Can you convert data from sql files to separate dat files for each database and install it in Keitaro?
The support technician said that this is impossible, since Maxmind has its own binary format, they do not provide tools for compiling such databases. But there may be some workarounds.
If you can do this, leave a request, I will contact you.
I would also be grateful for any constructive comments.
