Reference Guide

438 | rap-wml table Dell PowerConnect ArubaOS 5.0 Command Line Interface | Reference Guide
rap-wml table
rap-wml table <server-name> <table-name> <column-name> {[delimiter <char>] |
[timestamp-column <timestamp-column-name> <lookup-time>]}
Description
Use this command to specify the name and attributes of the database table to be used for lookup.
Syntax
Usage Guidelines
Use the rap-wml <servername> command to configure a MySQL or an MSSQL server, then use the rap-wml
table command to configure the associated database table for the server.
Example
This example configures a MySQL server and sets up associated rap-wml table attributes for that server.
(host) (config) #rap-wml mysqlserver type mysql ip-addr 10.4.11.10 db-name
automatedtestdatabase user sa password sa
rap-wml table mysqlserver mactest_undelimited mac timestamp-column time 600
rap-wml table mysqlserver mactest_delimited mac delimiter : timestamp-column time 600
This example configures an MSSQL server and sets up associated rap-wml table attributes for that server.
(host) (config) # rap-wml mssqlserver type mssql ip-addr 10.4.11.11 db-name
automatedtestdatabase user sa password sa
rap-wml table mssqlserver mactest_undelimited mac timestamp-column time 600
rap-wml table mssqlserver mactest_delimited mac delimiter : timestamp-column time 600
Command History
This commands was introduced in ArubaOS 2.0.
Command Information
Parameter Description Default
server-name Specifies the database server name (created using the rap-wml <server-
name> command.
—
table-name Specifies the database table name. —
column-name Specifies the database column name with the MAC address. —
delimiter Specifies the optional delimiter character for the MAC address in the
database.
No delimiter
no Negates the rap-wml table for the named server. —
timestamp-column Specify the database column name with the timestamp last seen. —
timestamp-column-nam
e
Specify the database column name with the timestamp last seen. —
lookup-time Specifies how far back—in seconds—to look for the MAC address. Use 0
seconds to lookup everything.
0
Platforms Licensing Command Mode
All platforms Requires the WIP license. Config mode on master controllers