Sql commands 8 – Westermo MR Series User Manual
Page 369
369
6622-3201
Web Interface and Command Line Reference Guide
www.westermo.com
SQL Commands
8
These events can be used to debug the correct matching string to match on when trying to config-
ure these parameters.
If both lists are left blank, all drivers are enabled and no extra events will appear in the event log.
When IPSec Egroups are used with a SQL database for dynamic Eroute configuration, there are CLI
commands that will help with configuration and troubleshooting on the Westermo router.
Local Database commands
As well as using an external SQL database, the Westermo can cache the SQL table entries it learns
from the SQL server in RAM so if the SQL server goes offline for any reason, the database entries
are still available to renew existing IPSec SA’s.
To configure the caching options the command used is sql 0
The following parameters are available to configure the caching of database entries:
dbsrvmem
This parameter is used to specify the amount of memory (RAM) the MySQL server cache should
use. Where
To calculate the amount of memory to specify in this parameter:
Look at the size of the database file (.csv) that will be loaded into the Westermo memory.
1.
Double this value and add 100Kb, for example, if the csv file is 200Kb, this would make a value
2.
of 500Kb for the memory allocation. Use the command sql 0 dbsrvmem 500
Load the database file into memory and check the memory allocated and free using the smem
3.
command. This will show the memory allocated and left available. Increase the memory in the
dbsrvmem command if required.
dbfile
This is the name of the csv file that the Westermo will use to store the table definitions (1st line)
and data records. This file is stored in flash and is used to populate the database stored in RAM on
power up or when a new file matching this name has just been stored. The dbfile can be populated
with records or the be empty except for the definitions line. The dbfile stored in RAM will be popu-
lated from both the dbfile stored in flash and (if configured) via caching items learnt from the main
SQL server. The dbfile in flash can then be updated from the dbfile in RAM and saved.
dbname
This is the name of the backup database incase the main database goes offline. This name needs to
match the database name in use on the SQL server.
learn
When enabled, the Westermo will cache entries learnt via the main SQL database in a file stored
in RAM. This can be used as a backup in the event of the main SQL database going offline. To use
learning mode, at least one column in the csv dbfile must be marked as a unique key, with the U
prefix.
For example, remip is marked as the unique key:
peerip[IP],bakpeerid[IP],peerid[K20],password[20],ourid[20],remip[UKIP],remmsk[IP]
intrude
If a connection to the SQL server fails, setting intrude to ON will allow the Westermo to seam-
lessly use the local database to perform the lookup.
Learning mode - Saving entries
When learning mode is used, the dynamic backup database is stored in RAM. This database will be
lost if the Westermo router is power cycled. The database in RAM can be saved to flash to over-
write the dbfile with the one in RAM that includes the learnt entries or it can be saved to a new
file.
To save the dbfile to flash from RAM, use the following command.