1RASQL(1) General Commands Manual RASQL(1)
2
3
4
6 rasql - read argus(8) data from mysql database.
7
9 rasql [-M sql='where clause'] -r mysql://user@host/db/table [raoptions]
10 [-- filter-expression]
11
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
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
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
47 ra(1), rasqlinsert(1), rarc(5), argus(8),
48
49
51 Carter Bullard (carter@qosient.com).
52
53
54
55rasql 3.0.8 12 August 2009 RASQL(1)