IPsec parameters
Digi TransPort User Guide 417
Configure a TransPort to use a backup database
Once the router has been configured to run a SQL csv database locally, this backup csv database
can be used in the event of the main SQL database going offline. The configuration parameters
required are:
1. Configure the IP address of the SQL server to use.
egroup 0 dbhost "192.168.0.50"
2. Configure the IP address of the SQL server that will have a backup database. If a socket
connection fails to this IP address, the router will use the backup IP address.
ipbu 0 IPaddr "192.168.0.50"
3. Configure the backup database IP address; that is, the loopback address of the router or an
alternative SQL server, this example shows the loopback IP address of the router.
ipbu 0 BUIPaddr "127.0.0.1"
4. Set the amount of time in seconds that the connection to the main SQL server will be retried.
ipbu 0 retrysec 30
5. Set the router to use the backup IP address if the main database is unavailable.
ipbu 0 donext ON
For example, to configure and use a local backup database when the main SQL database at
192.168.0.50 is offline, the configuration may look similar to this:
egroup 0 dbhost "192.168.0.50"
sql 0 dbsrvmem 200
sql 0 dbfile "sardb.csv"
sql 0 dbname "sarvpns"
sql 0 learn ON
sqlsave 0 backup.csv
ipbu 0 IPaddr "192.168.0.50"
ipbu 0 BUIPaddr "127.0.0.1"
ipbu 0 retrysec 30
ipbu 0 donext ON
To Next Page
Loading...
