FreeBSD Manual Pages
RASQL(1) General Commands Manual RASQL(1) NAME rasql - read argus(8) data from mysql database. SYNOPSIS rasql [-M sql='where clause'] -r mysql://user@host/db/table [raoptions] [-- filter-expression] DESCRIPTION Rasql reads argus data from an argus-client generated mysql database. The principal function of rasql is to extract the 'record' binary blob that is inserted by rasqlinsert.1 when adding argus data to a mysql ta- ble. RASQL SPECIFIC OPTIONS Rasql, like all ra based clients, supports a number of ra options in- cluding filtering of input argus records through a terminating filter expression. rasql(1) specific options are: -M sql='where clause' This appends the 'where clause' to the SELECT mysql database com- mand. providing a means to use SQL select and join strategies when performing queries. INVOCATION This invocation reads argus(8) data from the table table that is con- tained in the db database, using the user database account, and in- structs MySQL to select records where the database attribute 'saddr' equals to the string '2.3.4.5'. rasql -r mysql://user@localhost/db/table -M sql="saddr='2.3.4.5'" COPYRIGHT Copyright (c) 2000-2016 QoSient. All rights reserved. SEE ALSO ra(1), rasqlinsert(1), rarc(5), argus(8), AUTHORS Carter Bullard (carter@qosient.com). rasql 3.0.8 12 August 2009 RASQL(1)
NAME | SYNOPSIS | DESCRIPTION | RASQL SPECIFIC OPTIONS | INVOCATION | COPYRIGHT | SEE ALSO | AUTHORS
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=rasql&sektion=1&manpath=FreeBSD+Ports+14.3.quarterly>