Digi TransPort WR11 - Page 496

Configuring Virtual Private Networking (VPN) Configure Internet Protocol security (IPsec)
Digi TransPort® Routers User Guide
496
Lear ni ng i nf o.
i t ems l ear ned: 0
mat ched r et r i eval s: 0
OK
Configure a TransPort to use a backup database
Once the router has been configured to run a SQL csv database locally, you can use this backup csv
database if the main SQL database goes offline. Required configuration parameters are:
1. Configure the IP address of the SQL server to use.
egr oup 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.
i pbu 0 I Paddr " 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.
i pbu 0 BUI Paddr " 127. 0. 0. 1"
4. Set the amount of time in seconds that the connection to the main SQL server will be retried.
i pbu 0 r et r ysec 30
5. Set the router to use the backup IP address if the main database is unavailable.
i pbu 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:
egr oup 0 dbhost " 192. 168. 0. 50"
sql 0 dbsr vmem 200
sql 0 dbf i l e " sar db. csv"
sql 0 dbname " sar vpns"
sql 0 l ear n ON
sql save 0 backup. csv
i pbu 0 I Paddr " 192. 168. 0. 50"
i pbu 0 BUI Paddr " 127. 0. 0. 1"
i pbu 0 r et r ysec 30
i pbu 0 donext ON
smem command: Display memory information
smem
Displays the amount of memory allocated, in use and available for use by the MySQL server on the
router.
Transact SQL commands
To query a SQL database manually using transact SQL statements, use the following commands: