How to reproduce/rebuild the table metrics in OJS3.2.1.1

Rephrasing my post. I have upgraded our test server OJS to and the usage statistics is not working correctly. I have looked at the db table metrics and it is not collecting all of the info that we needed. The country_id column is all NULL.

I have downloaded GeoLiteCity.dat from GeoIP Legacy Databases and moved it to plugins/generic/usageStats/ . I am not sure which geoip database PKP OJS recommends. But, I have downloaded and I tested about 5 of them and no success. Can someone point to me the correct database to use? Do we buy the commercial version?

I have also moved the log files from …/usageStats/archive into …/usagestats/stage and ran:
php tools/runScheduledTasks.php lib/pkp/plugins/generic/usageStats/scheduledTasks.xml

The “Generate custom report” do not generate reports with “Country” when I choose County and select range by “month”.

Is there any way to fix this?