Does group name not kept in database?

Discussion about VPN Client Pro
Post Reply
px85
Posts: 5
Joined: Thu Dec 16, 2021 10:45 am

Does group name not kept in database?

Post 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?
admin
Site Admin
Posts: 669
Joined: Fri Feb 15, 2019 4:04 pm
Contact:

Re: Does group name not kept in database?

Post 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
admin
Site Admin
Posts: 669
Joined: Fri Feb 15, 2019 4:04 pm
Contact:

Re: Does group name not kept in database?

Post 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
Post Reply