1RASQL(1)                    General Commands Manual                   RASQL(1)
2
3
4

NAME

6       rasql - read argus(8) data from mysql database.
7

SYNOPSIS

9       rasql [-M sql='where clause'] -r mysql://user@host/db/table [raoptions]
10       [-- filter-expression]
11

DESCRIPTION

13       Rasql reads argus data from an argus-client generated mysql database.
14
15       The principal function of rasql is to extract the 'record' binary  blob
16       that is inserted by rasqlinsert.1 when adding argus data to a mysql ta‐
17       ble.
18
19

RASQL SPECIFIC OPTIONS

21       Rasql, like all ra based clients,  supports  a  number  of  ra  options
22       including filtering of input argus records through a terminating filter
23       expression.  rasql(1) specific options are:
24
25       -M sql='where clause'
26           This appends the 'where clause' to the SELECT mysql  database  com‐
27           mand.  providing a means to use SQL select and join strategies when
28           performing queries.
29
30
31

INVOCATION

33       This invocation reads argus(8) data from the table table that  is  con‐
34       tained  in  the  db  database,  using  the  user  database account, and
35       instructs MySQL to select records where the database attribute  'saddr'
36       equals to the string '2.3.4.5'.
37
38
39          rasql -r mysql://user@localhost/db/table -M sql="saddr='2.3.4.5'"
40
41

43       Copyright (c) 2000-2016 QoSient. All rights reserved.
44
45

SEE ALSO

47       ra(1), rasqlinsert(1), rarc(5), argus(8),
48
49

AUTHORS

51       Carter Bullard (carter@qosient.com).
52
53
54
55rasql 3.0.8                     12 August 2009                        RASQL(1)
Impressum