Digi TransPort - Page 418

IPsec parameters
Digi TransPort User Guide 418
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, 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 router, these commands can be preceded
with the SQL debug command to give extra feedback on any commands issued.
•To enable the SQL debug:
sql 0 debug_opts 3
• To view the debug data via the ASY 0 port:
debug 0
• To view the debug data via telnet:
debug t
• To disable the SQL debug:
sql 0 debug_opts 0
debug off