Install Maxmind geo-bases in Keitaro TDS
Employer
[no-member:pro]Aleksandr[/no-member:pro]
Project parameters
Type of cooperationOne-time project
SectionAdministration
Prepaymentwithout prepayment
Payment methodsElectronic money
Acceptance of requestsfrom Oct 2, 2019 until Oct 9, 2019
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.
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.
