Re-Install LibreSign App (dropped tables did not get recreated)

[dietriclX]

Nextcloud Hub 8 (29.0.9)
LibreSign 9.4.0

As a noob with Nextcloud and LibreSign in particular, I first played around with the app, screwed up configuration and wanted to start from scratch.

Even though I had managed to get the LibreSign app back working ... I didn't understand, why the app did not re-create the tables (after step 9.). Is that normal?
Should I have dropped/deleted more than what I did so far (at step 8.)?

How it all started ..

1. installed the LibreSign app
2. made the base configuration for the LibreSign app
3. played around with LibreSign (it is really great, I love it!)
4. ruined my configuration
5. uninstalled the LibreSign app
6. installed the app again

Well ... the configuration was the same like before

So on my next attempt, I tried to delete "all" LibreSign related records and tables from the Nextcloud database.

7. uninstalled the LibreSign app
8. executed the following SQL statements

DROP TABLE oc_libresign_account_file;
DROP TABLE oc_libresign_file;
DROP TABLE oc_libresign_file_element;
DROP TABLE oc_libresign_file_type;
DROP TABLE oc_libresign_identify_method;
DROP TABLE oc_libresign_sign_request;
DROP TABLE oc_libresign_user_element;
DELETE FROM oc_appconfig WHERE appid = 'libresign';

9. installed the LibreSign app again
10. made the base configuration for the LibreSign app

Now comes the weird part ...

11. I logged in as a regular used (allowed to use LigbreSign)
12. navigated to the "LibreSign" app, using the button from the menu

• immediately the menu buttons disappeared; the whole top line had been empty
• when navigating to the LibreSign account settings, the area had been empty as well (usually your Profile picture is shown and there are options to upload your certiifcate/signature)

13. I took the backup SQL script, from my nightly system backup ¹
14. extracted all parts which were related to LibreSign tables.
15. executed the SQL script ² from step 14. and recreate the tables

Finally LibreSign was again working.

¹ the efforts, I spend on the nightly backup script, were a good investment :-)

² see attachment PostgreSQL_rebuild_tables.sql.zip

[vitormattos]

Nextcloud use migrations to create all tables.

If you want to re-create, remove all executed migrations.

DELETE from oc_migrations where app = 'libresign';

The issue that you found was because installed the app after then you removed the content related to LibreSign from appconfig but the tables wasn't created because all migrations "was executed".

[dietriclX]

Excellent. Thank you very much, that indeed solved the issue of re-creating the tables.

And on my quest to understand more about the tables, I didn't exactly found the purpose of table oc_migrations being explained. However I found a thread on another app, mentioning the oc_preferences table. I have checked this and indeed the user folder for LibreSign is stored in it.

So finally I would say, on deleting the LibreSign configuration ... in addition to the DELETE/DROP of my initial posting the following two lines are required as well.

DELETE FROM oc_migrations WHERE app='libresign';
DELETE FROM oc_preferences WHERE appid='libresign';

[vitormattos]

I didn't remember about nothing from LibreSign that is saving data at preferences table.

You can get more info about migrations here:
https://docs.nextcloud.com/server/latest/developer_manual/basics/storage/migrations.html

[dietriclX]

Well, I guess that usually the administrators keep the option "Customise default user folder" disabled. And in this cases probably nothing will be written into oc_preferences.
Except an admin would be like me, trying out every option, like I did. What a mistake, afterwards I had been unable to delete the folder (it always re-appeared). And that had be the main reason for me to start the journay of starting from the scratch. :-)

Thx for the reference to the documentation (I didn't run into it before). Will read it.