IPA_SDB(5) IPA_SDB(5) NAME ipa_sdb -- database format for ipa_db_sdb(8) and ipa_st_sdb(8) SYNOPSIS #include "ipa_sdb_config.h" #include <ipa_sdb.h> DESCRIPTION ipa_sdb is a database for IPA database module with the following fea- tures: - All database files and directories are stored in own database formats; - Each rule, limit and threshold has own directory; - Formats of database files are machine architecture independent; - Sizes of database records are relatively small: the size of a rule's record is 15 bytes, the size of a limit's record is 73 bytes and the size of a threshold's record is 30 bytes. DATABASE FORMAT All structures needed for direct access to database data are available in the ipa_sdb.h C-header file. The ipa_sdb_config.h file has macros for packing structures, which are determined by the configure script (check its content). If you use another compiler than the compiler used by the configure script, then modify this file and redefine these macros. By default main database directory is IPA_SDB_DB_DIR, but since it can be changed, then let's call it <DB>. The ipa_db_sdb(8) and ipa_st_sdb(8) modules do not expect that any file or directory they currently use can be removed, renamed or modified by another process. The the version number of the database format is stored in the <DB>/IPA_SDB_VERSION_FILE file. There is the IPA_SDB_FORMAT_VERSION macro variable, which is equal to the version number of the database format. Statistics for an arbitrary rule is stored in the <DB>/<rule> direc- tory. There are files with yyyymm like names in this directory which contain statistics per year/month. Each <rule>/yyyymm file contains records with the following format: struct ipa_sdb_rule_record { uint8_t mday; uint8_t h1; uint8_t m1; uint8_t s1; uint8_t h2; uint8_t m2; uint8_t s2; uint32_t c_high; uint32_t c_low; }; mday is a day of a month, h1, m1 and s1 is time when a record was added to the database, h2, m2 and s2 is time when a record was updated last time. c_high and c_low are high 32-bit part and low 32-bit part of the counter, each of these parts is represented in network byte order. Since a new record for any new day is always appended, then it is enough to have only the mday field here. The <rule>/IPA_SDB_INFO_FILE file contains description of the rule. Data for limits is kept in the <rule>/IPA_SDB_LIMITS_DIR directory, data for each limit is stored in the <limit> directory. There are files with yyyymm like names in this directory which contain statistics per year/month. Here year/month means year and month when a limit was started. Each <limit>/yyyymm file contains records with the following format: struct ipa_sdb_date_struct { uint16_t year; uint8_t mon; uint8_t mday; uint8_t hour; uint8_t min; uint8_t sec; }; typedef struct ipa_sdb_date_struct ipa_sdb_date; #define IPA_SDB_DATE_START_SET 0x01 #define IPA_SDB_DATE_RESTART_SET 0x02 #define IPA_SDB_DATE_RESTART_EXEC_SET 0x04 #define IPA_SDB_DATE_REACH_SET 0x08 #define IPA_SDB_DATE_REACH_EXEC_SET 0x10 #define IPA_SDB_DATE_EXPIRE_SET 0x20 #define IPA_SDB_DATE_EXPIRE_EXEC_SET 0x40 #define IPA_SDB_DATE_UPDATED_SET 0x80 struct ipa_sdb_limit_record { uint8_t set; ipa_sdb_date start; ipa_sdb_date restart; ipa_sdb_date restart_exec; ipa_sdb_date reach; ipa_sdb_date reach_exec; ipa_sdb_date expire; ipa_sdb_date expire_exec; uint32_t l_high; uint32_t l_low; ipa_sdb_date updated; uint32_t c_high; uint32_t c_low; }; IPA_SDB_DATE_xxx_SET bits in the set field determine which of fields with ipa_sdb_data type have actual data. start is a date when a limit was started, restart is a date when a limit will be restarted, restart_exec is a date when commands for restarted limit were run, reach is a date when a limit was reached, reach_exec is a date when commands for reached limit were run, expire is a date when a limit will expire, expire_exec is a date when commands for expired limit were run and updated is a date when a limit was updated last time. The year field in the ipa_sdb_date structure is represented in network byte order. l_high and l_low represent value of the limit, c_high and c_low repre- sent value of the limit's counter. These fields have the same format as c_high and c_low fields in the ipa_sdb_rule_record structure. The <limit>/IPA_SDB_INFO_FILE file contains description of the limit. Data for thresholds is kept in the <rule>/IPA_SDB_THRESHOLDS_DIR direc- tory, data for each threshold is stored in the <threshold> directory. The <threshold>/IPA_SDB_THRESHOLD_STATE file contains current thresh- old's state: struct ipa_sdb_threshold_record { uint32_t t_high; uint32_t t_low; uint32_t c_high; uint32_t c_low; ipa_sdb_date tm_started; ipa_sdb_date tm_updated; }; t_high and t_low represent value of the threshold, c_high and c_low represent value of the threshold's counter. These fields have the same format as c_high and c_low fields in the ipa_sdb_rule_record structure. tm_started and tm_updated are two timestamps for the threshold. The <threshold>/IPA_SDB_INFO_FILE file contains description of the threshold. SEE ALSO ipa_db_sdb(8), ipa_st_sdb(8), ipa_sdb_dump(8) AUTHOR Andrey Simonenko <simon@comsys.ntu-kpi.kiev.ua> BUGS If you find any, please send email me. July 24, 2007 IPA_SDB(5)