GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
RASQL(1) FreeBSD General Commands Manual RASQL(1)

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

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

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, 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.

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 (c) 2000-2016 QoSient. All rights reserved.

ra(1), rasqlinsert(1), rarc(5), argus(8),

Carter Bullard (carter@qosient.com).
12 August 2009 rasql 3.0.8

Search for    or go to Top of page |  Section 1 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.