Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Content Gateway v7.x: Frequently Asked Questions : How do I backup and restore the SSL Incident List?
How do I backup and restore the SSL Incident List?
Topic 60070 | Content Gateway FAQs | Updated: 22-October-2013
Applies To:
Websense Content Gateway v7.x
Websense Web Security Gateway / Anywhere v7.x
The SSL Incident list can be backed up and restored on the Linux command line using sqlite3.
Start by logging on to the Content Gateway host system and acquiring root privileges.
To back up the Incident list
1.
Change to the Content Gateway SSL database directory:
For v7.8.x and later:
# cd /opt/WCG/config
For v7.7.x and earlier:
# cd /opt/WCG/sxsuitedb/db
2.
Open the database with sqlite:
For v7.8.x and later:
# sqlite3 new_scip3.db
For v7.7.x and earlier:
# sqlite3 scip3.db
3.
In sqlite, perform the following steps:
sqlite> .tables
sqlite> .output certificate_acl.bak
sqlite> .dump certificate_acl
sqlite> .exit
You now have a backup of the Incident list named "certificate_acl.bak".
To restore a backup
1.
Change to the Content Gateway SSL database directory and open the database with sqlite3:
For 7.8.x and later:
# cd /opt/WCG/config
# sqlite3 new_scip3.db
For 7.7.x and earlier:
# cd /opt/WCG/sxsuitedb/db
# sqlite3 scip3.db
2.
To replace the current list with the backup list, delete the current list. Skip this step if you want to add the backup list to the current list.
sqlite> drop table certificate_acl;
3.
To restore the backup list:
sqlite> .read certificate_acl.bak
sqlite> .exit
4.
In Content Gateway Manager, verify that the Incident List has been restored.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Content Gateway v7.x: Frequently Asked Questions : How do I backup and restore the SSL Incident List?
Copyright 2016 Forcepoint LLC. All rights reserved.