Update SQLite DB

[SysadminJeroen]

Hello,

Is there any info or documentation available on how to update the SQLite database? I have followed a blog post at http://www.splitbrain.org/blog/2011-02/12-maxmind_geoip_db_and_sqlite where Whitetiger also commented but if I use the commands and queries it will end up giving some errors.

Edit: I came here because LookupFFS stopped and I'm looking for better alternative.

[Whitetigerswt]

I have updated the databases on the GitHub page, please let me know if everything is working correctly as I currently cannot test it. If everything is working well I will update the topic on the SA-MP forum.

https://github.com/Whitetigerswt/SAMP-geoip/releases/download/Db.3/Mar.2016.Databases.zip

[SysadminJeroen]

@Whitetigerswt I will check if it works. If the new database works can you explain the steps that you have done to create the database?

[SysadminJeroen]

It works perfectly. Can you post the steps you have used to convert the CSV file to SQLite here or make some documentation? Just for future references in case you are not around.

[Whitetigerswt]

I use SQLite Expert to import CSV files into an sqlite database, then I run the queries explained here: http://www.splitbrain.org/blog/2011-02/12-maxmind_geoip_db_and_sqlite (This emulates a HashTable for the GeoIP)

[SysadminJeroen]

I'm getting the following error. Error: GeoLiteCity-Location.csv line 420398: expected 9 columns of data but found 10 But it does output a database file. I will check the database file now.

[Whitetigerswt]

Did you remove the copyright line at the beginning of the file? On Apr 2, 2016 1:25 PM, "Jeroen" notifications@github.com wrote:

I'm getting the following error. Error: GeoLiteCity-Location.csv line 420398: expected 9 columns of data but found 10 But it does output a database file. I will check the database file now.

— You are receiving this because you were mentioned. Reply to this email directly or view it on GitHub https://github.com/Whitetigerswt/SAMP-geoip/issues/4#issuecomment-204762365

[SysadminJeroen]

Yes, these are the first 5 lines in my GeoLiteCity-Location.csv

2,AP,,,,35.0000,105.0000,,
3,EU,,,,47.0000,8.0000,,
4,AD,,,,42.5000,1.5000,,
5,AE,,,,24.0000,54.0000,,

But that leaves another question, even when it works for the CityFile how to make a .db out of the GeoIPCountryWhois.csv file for the MainFile?

[Whitetigerswt]

You add the idx field after you've imported the csv. When you import the csv it should adjust your table to whatever number of columns it found. On Apr 2, 2016 1:48 PM, "Jeroen" notifications@github.com wrote:

Yes, these are the first 5 lines in my GeoLiteCity-Location.csv 1,O1,,,,0.0000,0.0000,, 2,AP,,,,35.0000,105.0000,, 3,EU,,,,47.0000,8.0000,, 4,AD,,,,42.5000,1.5000,, 5,AE,,,,24.0000,54.0000,,

But that leaves another question, how to make a .db out of the GeoIPCountryWhois.csv file for the MainFile?

— You are receiving this because you were mentioned. Reply to this email directly or view it on GitHub https://github.com/Whitetigerswt/SAMP-geoip/issues/4#issuecomment-204765185

[Whitetigerswt]

And if you use sqlite expert it'll make your .db file when you import On Apr 2, 2016 1:54 PM, "Seaver Thorn" whitetigerswt@gmail.com wrote:

You add the idx field after you've imported the csv. When you import the csv it should adjust your table to whatever number of columns it found. On Apr 2, 2016 1:48 PM, "Jeroen" notifications@github.com wrote:

Yes, these are the first 5 lines in my GeoLiteCity-Location.csv 1,O1,,,,0.0000,0.0000,, 2,AP,,,,35.0000,105.0000,, 3,EU,,,,47.0000,8.0000,, 4,AD,,,,42.5000,1.5000,, 5,AE,,,,24.0000,54.0000,,

But that leaves another question, how to make a .db out of the GeoIPCountryWhois.csv file for the MainFile?

— You are receiving this because you were mentioned. Reply to this email directly or view it on GitHub https://github.com/Whitetigerswt/SAMP-geoip/issues/4#issuecomment-204765185

[SysadminJeroen]

I'm trying not to use SQLite Expert as I am trying to automate this and trying to not use proprietary software.

[SysadminJeroen]

And now that I got geoip_city.db, how did you make geoip.db?

[SysadminJeroen]

@Whitetigerswt, do you have instructions how to make both SQLite files?