User`s guide

451
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
Memory info
smem
Displays the amount of memory allocated, in use and available for use by the MySQL server
on the Digi.
Transact SQL commands
To query a SQL database manually using transact SQL statements, the following commands
can be used.
To connect to the SQL server and database:
sqlcon <host> <user> <pwd> <database>
For example:
sqlcon 192.168.0.50 sqluser sqlpass eroute-db
To issue transact SQL statements:
sqldo <"cmd">
For example:
sqldo "select * from site where subnet='10.110.100.0' limit 3"
To limit the sqldo command to only act on specified fields, the following command can be
used:
sqlfields “<field1> <field2> <field3>”
For example:
sqlfields “remmsk password peerip”
After issuing the sqlfields command, all further sqldo commands will apply to these fields
only.
When finished, to close the SQL server connection correctly:
sqlclose
If the database being queried is held locally on the Digi, these commands can be preceded
with the SQL debug command to give extra feedback on any commands issued.