Reset Geoblocker app database in Nextcloud

[Dan149885]

After Installing Geoblocker in Nextcloud the database is stuck in the update process forever. This is a known issue documented in their github with a command to reset the database.

Code:

sudo -u %NEXTCLOUD_INSTANCE_USER% php occ geoblocker:localization-service:reset-db 2

I can't get this command to work. I have tried in the Truenas shell as well as in the Nextcloud jail shell, with the error usually being either "user not found" or "command not found". I have tried ncadmin and root as the %NEXTCLOUD_INSTANCE_USER%. Is there a version of this command that will work in Truenas?

TrueNAS-12.0-U8.1
Nextcloud Version: 24.0.2

 

[mbrundridge]

To reset the RIRData database, open the Nextcloud Jail Shell -> and at the shell prompt execute Nextclouds Command-line interface (i.e. occ) command by itself (i.e. occ geoblocker:localization-service:reset-db 2).

Note: More than likely you don't have php installed in your TrueNAS config (however, it is installed as part of Nextcloud, but again you don't need it to execute the occ command directly from the Nextcloud Jail).

cheers,
Michael