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:
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

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