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 table. RASQL SPECIFIC OPTIONS Rasql, like all ra based clients, supports a number of ra options including 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 command. 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 contained in the db database, using the user database account, and instructs 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-2024 QoSient. All rights reserved. SEE ALSO ra(1), rasqlinsert(1), rarc(5), argus(8), AUTHORS Carter Bullard (carter@qosient.com). rasql 5.0.3 12 August 2023 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+15.1.quarterly>