search

pkp / pkp-lib

The library used by PKP's applications OJS, OMP and OPS, open source software for scholarly publishing.
https://pkp.sfu.ca
GNU General Public License v3.0
304 stars 444 forks source link

Error converter usageEventLogs/usage_events #9489

Closed Mathewwss closed 11 months ago

Mathewwss commented 11 months ago

Update OJS 3.3.0.14 to 3.4.0.3.

Update guide : https://docs.pkp.sfu.ca/dev/upgrade-guide/en/

image

Do not configure "files" and "public" in config.inc.php to update completed successfully. And configure after update.

Is it incorrect to do it this way???

asmecher commented 11 months ago

@Mathewwss, could you ask this question on our support forum (https://forum.pkp.sfu.ca) rather than filing an issue? That's the best place to get support.

bozana commented 11 months ago

@Mathewwss, once you write a question/post in the forum, can you address me (@bozana) there, so I can take a look -- the files folder should be there and have correct path...

Mathewwss commented 11 months ago

I didn't post it on the forum, because I found a similar post.

https://forum.pkp.sfu.ca/t/upgrade-error-ojs-3-3-0-14-to-3-4-0-3-the-usage-events-log-could-not-be-successfully-converted-and-stop-update/82966

Solved the problem by changing the IP of the requests and the website to the IP of the host machine where OJS is installed.

Original:

172.16.16.5 - - "2023-01-02 00:04:25" http://url/index 200 "Mozilla/5.0 (X11; U; Linux; en-US) AppleWebKit/527 (KHTML, like Gecko, Safari/419.3) Arora/0.10.1"

Change (OJS machine = 172.16.16.20):

172.16.16.20 - - "2023-01-02 00:04:25" http://**172.16.16.20**/index 200 "Mozilla/5.0 (X11; U; Linux; en-US) AppleWebKit/527 (KHTML, like Gecko, Safari/419.3) Arora/0.10.1"

New alert:

There was a problem finding IP in the Geo database at /var/www/ojs-files/usageStats/IPGeoDB.mmdb. Error: The address 172.16.16.20 is not in the database.

Despite the alert, the update was completed.

Any problem doing it this way ?

bozana commented 11 months ago

@Mathewwss, yes the journal URLs in the log file need to be the same as the installation URL (defined in base_url setting in config.inc.php)...

Mathewwss commented 11 months ago

usage_events IP : http://domain.com base_url IP : 172.16.16.20

usage_events IP : http://172.16.16.20 base_url IP : 172.16.16.20

        Problem : There was a problem finding IP in the Geo database at /var/www/ojs-files/usageStats/IPGeoDB.mmdb. Er
ror: The address 172.16.16.20 is not in the database.