1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
.\"
.\" Argus-5.0 Software
.\" Copyright (c) 2000-2024 QoSient, LLC
.\" All rights reserved.
.\"
.\"
.TH RASQL 1 "12 August 2023" "rasql 5.0.3"
.SH NAME
\fBrasql\fP \- read \fBargus(8)\fP data from mysql database.
.SH SYNOPSIS
.B rasql
[\fB\-M\fP \fIsql='where clause'\fP] -r mysql://user@host/db/table [\fBraoptions\fP] [\fB--\fP \fIfilter-expression\fP]
.SH DESCRIPTION
.IX "rasql command" "" "\fBrasql\fP \(em argus data"
.LP
\fBRasql\fP reads
.BR 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 \fIrasqlinsert.1\fP when adding argus data to a
mysql table.
.SH RASQL SPECIFIC OPTIONS
Rasql, like all ra based clients, supports a number of \fBra options\fP
including filtering of input argus records through a terminating filter expression.
\fBrasql(1)\fP specific options are:
.TP 4 4
.BI \-M "\| sql='where clause'\^"
This appends the 'where clause' to the SELECT mysql database command.
providing a means to use SQL select and join strategies when performing queries.
.SH INVOCATION
This invocation reads \fBargus(8)\fP data from the \fItable\fP table that
is contained in the \fIdb\fP database, using the \fIuser\fP database account,
and instructs MySQL to select records where the database attribute 'saddr'
equals to the string '2.3.4.5'.
.nf
\fBrasql\fP -r mysql://user@localhost/db/table -M sql="saddr='2.3.4.5'"
.fi
.SH COPYRIGHT
Copyright (c) 2000-2024 QoSient. All rights reserved.
.SH SEE ALSO
.BR ra(1),
.BR rasqlinsert(1),
.BR rarc(5),
.BR argus(8),
.SH AUTHORS
.nf
Carter Bullard (carter@qosient.com).
.fi
|
