Page 1 of 1

Does group name not kept in database?

Posted: Tue Dec 28, 2021 7:48 am
by px85
FIles used for issue reproducing: https://disk.yandex.ru/d/gADou4TkNbvVCw

Restore backup from Pure1.bak (pass: pure)

Observe 2 vpn groups: PureVPN and purevpn

Copy database files (from /data/data/it.colucciweb.vpnclientpro/databases) to computer and open file "database" (I used DB Browser for SQLite Version 3.12.2)

Execute update:

Code: Select all

update vpn_profiles
set "group" = 'PureVPN'
where upper ("group") = upper ("PureVPN")
Commit changes (save changes to database)
At this point i got files "database" and "database-val" and "database"

Close VPN Client Pro on android

Replace files in /data/data/it.colucciweb.vpnclientpro/databases with files you got after update

Open VPN Client Pro and you see only one group - "PureVPN". Correct

Now perform new backup (VPNClientPro_2021-12-28_10-28-27.bak pure)
Restore this backup without adding it to current data.

Expected to see 1 group: "PureVPN".
Observed 2 vpn groups: "PureVPN" and "purevpn"

Why?

Database had only "PureVPN" group.
Where did it get "purevpn" from?

Re: Does group name not kept in database?

Posted: Tue Dec 28, 2021 11:22 am
by admin
This happen because the source of truth is not the database. The database is used only as index.
The real configuration data are stored in seperated encrypted files that cannot be modified.
To change the group you must use the app.
The app allows also to change it for multiple VPN profiles:
  • start the app
  • long tap on a VPN profile list entry
  • select the other VPN profiles
  • tap on top right icon with 3 dots
  • tap on "Set VPN group"
  • enter the VPN group and tap on OK

Re: Does group name not kept in database?

Posted: Tue Dec 28, 2021 11:31 am
by admin
Here the steps to change the VPN group from "purevpn" to "PureVPN":
  • start the app
  • tap on top right icon (to show the filter panel)
  • set "Show VPN group" to "purevpn"
  • long tap on one VPN profile list entry
  • tap on top right with 3 dots
  • tap on "Select all"
  • tap on top right with 3 dots
  • tap on "Set VPN group"
  • set the VPN group to "PureVPN" and tap on OK