Accidentally deleted user database

Business solution to host your own OpenVPN server with web management interface and bundled clients.
Post Reply
w421421
OpenVpn Newbie
Posts: 3
Joined: Fri Aug 19, 2022 11:14 pm

Accidentally deleted user database

Post by w421421 » Fri Aug 19, 2022 11:18 pm

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?

w421421
OpenVpn Newbie
Posts: 3
Joined: Fri Aug 19, 2022 11:14 pm

Re: Accidentally deleted user database

Post by w421421 » Fri Aug 19, 2022 11:24 pm

To be precise, I deleted the following database:

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

TinCanTech
OpenVPN Protagonist
Posts: 11137
Joined: Fri Jun 03, 2016 1:17 pm

Re: Accidentally deleted user database

Post by TinCanTech » Fri Aug 19, 2022 11:55 pm

It would be simpler to re-install, from scratch.

w421421
OpenVpn Newbie
Posts: 3
Joined: Fri Aug 19, 2022 11:14 pm

Re: Accidentally deleted user database

Post by w421421 » Sat Aug 20, 2022 12:34 am

Thanks, I ended up doing that.

TinCanTech
OpenVPN Protagonist
Posts: 11137
Joined: Fri Jun 03, 2016 1:17 pm

Re: Accidentally deleted user database

Post by TinCanTech » Sat Aug 20, 2022 2:01 am

I recommend that you take a backup this time around 8-)

User avatar
openvpn_inc
OpenVPN Inc.
Posts: 1333
Joined: Tue Feb 16, 2021 10:41 am

Re: Accidentally deleted user database

Post by openvpn_inc » Tue Aug 23, 2022 4:19 pm

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
Image OpenVPN Inc.
Answers provided by OpenVPN Inc. staff members here are provided on a voluntary best-effort basis, and no rights can be claimed on the basis of answers posted in this public forum. If you wish to get official support from OpenVPN Inc. please use the official support ticket system: https://openvpn.net/support

Post Reply