| 1 |
/* |
| 2 |
* Argus-5.0 Client Software. Tools to read, analyze and manage Argus data. |
| 3 |
* Copyright (c) 2000-2024 QoSient, LLC |
| 4 |
* All rights reserved. |
| 5 |
* |
| 6 |
* THE ACCOMPANYING PROGRAM IS PROPRIETARY SOFTWARE OF QoSIENT, LLC, |
| 7 |
* AND CANNOT BE USED, DISTRIBUTED, COPIED OR MODIFIED WITHOUT |
| 8 |
* EXPRESS PERMISSION OF QoSIENT, LLC. |
| 9 |
* |
| 10 |
* QOSIENT, LLC DISCLAIMS ALL WARRANTIES WITH REGARD TO THIS |
| 11 |
* SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY |
| 12 |
* AND FITNESS, IN NO EVENT SHALL QOSIENT, LLC BE LIABLE FOR ANY |
| 13 |
* SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES |
| 14 |
* WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER |
| 15 |
* IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, |
| 16 |
* ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF |
| 17 |
* THIS SOFTWARE. |
| 18 |
*/ |
| 19 |
|
| 20 |
|
| 21 |
|
| 22 |
Tue Feb 11 20:32:09 EST 2014 |
| 23 |
In the process of generating rasqlinsert() such that there are |
| 24 |
separate threads to insert, update and select from records within |
| 25 |
the data base table backing store, if such a thing exists. |
| 26 |
|
| 27 |
|
| 28 |
Mon Aug 4 09:04:17 EDT 2008 |
| 29 |
Currently in performance trials with the latest incarnation. |
| 30 |
This program is being used as the foundation for most of the |
| 31 |
situational awareness backing stores. The trial is establishing |
| 32 |
a series of database tables that are being updated continuously. |
| 33 |
|
| 34 |
raisql -nnd -S apophis -M rmon -P ratop:etherHost -m srcid smac saddr \ |
| 35 |
-s stime dur srcid smac saddr pkts bytes -U root - ip |
| 36 |
|
| 37 |
raisql -nnd -S apophis -P ratop:etherMatrix -m srcid macmatrix \ |
| 38 |
-s stime dur srcid smac dmac pkts bytes -U root |
| 39 |
|
| 40 |
|
| 41 |
These two databases provide most of the base information for understanding |
| 42 |
probes observation domain, what L2 identities are being observed, and |
| 43 |
the L3 addresses that are behind those L2 identities. |
| 44 |
|
| 45 |
Mon Jan 12 16:29:36 EST 2004 |
| 46 |
|
| 47 |
raisql is turning into a very interesting program. |
| 48 |
when using -S 'host', it will load up a mysql table with |
| 49 |
data using the RADIUM_SQL_FIELDS to specify the database key. |
| 50 |
|
| 51 |
raisql -f raisql.conf -S host -P projectName -n - tcp or udp |
| 52 |
|
| 53 |
Currently the -n and the 'tcp or udp' filter are important |
| 54 |
as icmp traffic does not generate a good SQL key, and it |
| 55 |
tries to insert icmp entries when it collides with an existing |
| 56 |
one, creating a "DUPLICATE ..." error in mysql(). |
| 57 |
|
| 58 |
The ratop style cache is maintained in the database, and |
| 59 |
the update rate, is controlled by the update timers, ala |
| 60 |
ratop(). |
| 61 |
|