This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

All Voucher are lost after new install and backup import

UTM 9.103-5
The harddisk of my utm failed and i installed it new from a CD and imported the backup.
Everthing works fine, but all wireless vouchers are lost! Is the a normal? All other wireless setting, also the picture in the hotspot are there.

Thanks for help!

This thread was automatically locked due to age.

0 treskaan over 11 years ago

Hi,
do you mean the voucher definitions or the voucher codes??
Greetings,
Andreas
Cancel
Vote Up 0 Vote Down

Cancel
0 Boldmen over 11 years ago

The vouchers for the users/guest, who using the WLAN.
Our users need a voucher (valid 365 days) to use the WLAN.
The guests also for the guest-WLAN of course.
Thx for helping!
Cancel
Vote Up 0 Vote Down

Cancel
0 treskaan over 11 years ago

Hi,
thanks for reporting. I will check this!
Greetings, Andreas
Cancel
Vote Up 0 Vote Down

Cancel
0 trollvottel over 11 years ago

This is a known problem but not recognized as an issue. The configuration backup is exactly that - a configuration backup. Wireless vouchers are stored in the database and are not part of the system configuration.

Yes that's not nice since there is no official way to export/import the database.
Cancel
Vote Up 0 Vote Down

Cancel
0 Boldmen over 11 years ago

Is it usefull to open a request for that, a option for the backup to include the vouchers?
For me it is also a part of the configuration, because it's a right that you give to selected users, like in a firewall-rule etc.
Thank you for helping!
Cancel
Vote Up 0 Vote Down

Cancel
0 trollvottel over 11 years ago

Well, under the hood you can dump the DB and import after a reinstall using the 'pg_dump' & 'pg_restore' commands. But this is only safe if you don't change system version in the meantime so that DB schema is ensured to stay the same.

Howto: (untested)
- Export: pg_dump -U postgres hotspot > hotspot.sql
- Import: pg_restore -U postgres -c
Cancel
Vote Up 0 Vote Down

Cancel
0 BAlfson over 11 years ago

This is a bigger problem for the email quarantine.

Cheers - Bob

Sorry for any short responses. Posted from my iPhone.

Sophos UTM Community Moderator
Sophos Certified Architect - UTM
Sophos Certified Engineer - XG
Gold Solution Partner since 2005

MediaSoft, Inc. USA
Cancel
Vote Up 0 Vote Down

Cancel
0 gfreiler over 11 years ago

@Bob: the email Quarantäne ins not included in Backup???
Right, this ins no configuration - but User data!!!
So in many company's it is a must have to Backup! Also the Mail log should be included in the Backup.

Other question: is there a was Do male FULL Backup using crontab?
Cancel
Vote Up 0 Vote Down

Cancel
0 trollvottel over 11 years ago

No there is no official way to save user data. Yes I don't like that either. And yes we're going off-topic.
Cancel
Vote Up 0 Vote Down

Cancel
0 sebastian.mair over 9 years ago

any news on this?this is a big problem..i have to upgrade to sg330 and have about 300 voucher codes.. so what can i do?
Cancel
Vote Up 0 Vote Down

Cancel