Page 1 of 1

Accidentally deleted user database

Posted: Fri Aug 19, 2022 11:18 pm
by w421421
I believe I accidentally deleted the database for users, thereby eliminating my access to the admin web console. Furthermore, I cannot seem to add users via the command line. For example, the following command provides an error:

Code: Select all

./sacli UserPropGet
This gives a message that mentions: "no such table".

Is there a way to recreate the database for users so that I can add users via the command line?

Re: Accidentally deleted user database

Posted: Fri Aug 19, 2022 11:24 pm
by w421421
To be precise, I deleted the following database:

/usr/local/openvpn_as/etc/db/userprop.db

Re: Accidentally deleted user database

Posted: Fri Aug 19, 2022 11:55 pm
by TinCanTech
It would be simpler to re-install, from scratch.

Re: Accidentally deleted user database

Posted: Sat Aug 20, 2022 12:34 am
by w421421
Thanks, I ended up doing that.

Re: Accidentally deleted user database

Posted: Sat Aug 20, 2022 2:01 am
by TinCanTech
I recommend that you take a backup this time around 8-)

Re: Accidentally deleted user database

Posted: Tue Aug 23, 2022 4:19 pm
by openvpn_inc
Hi,

Access Server makes a backup before the upgrade, hence, if you did upgrade before, you can check in folder "/usr/local/openvpn_as/etc/backup", find the newest folder, and copy userprop.db from it.

Regards,
.\kionci