Activation Database
RLM activation uses a MySQL database to store all data. There are a total of 19 database tables:
active_users |
The currently active users |
audit |
Audit trail |
badhost |
Esed to automatically ban IP addresses |
blacklist |
Banned list definitions |
company |
Table of customer companies |
contact |
Table of customer contacts |
contact_types |
Table of contact types |
debuglog |
License generator debug logging information |
defaults |
Default values for product definition and activation keys |
keyd |
The Activation Key definitions |
keyf |
The Activation key fulfillment status, |
licf |
License Fulfillment data |
prod |
The product definitions |
report_cols |
Database columns which appear in reports |
report_select |
Selection criteria for reports |
report_types |
Report type definitions |
setup |
Activation setup data |
stats |
License generator statistics |
users |
Table of authorized users |
Each table indicates whether the admin tool and/or the license generator read and write to it.
The contents of these tables is as follows:
active_users - active RLC users
This table is used only by the admin tool. Unused by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
user |
username logged in |
string |
timestamp |
Time user logged in |
integer |
audit – database Audit Trail (v11.2)
This table is used only by the admin tool. Unused by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
date |
Time of entry |
integer |
who |
Username logged in |
string |
what |
Operation performed |
string |
tablekey |
Key in table modified |
string |
tablename |
Table modified |
string |
badhost – automatic banned list data
This table is used by both the admin tool. and the license generator.
Column |
Meaning |
Data type |
|---|---|---|
ip |
IP address |
string |
first |
First transaction |
integer |
last |
Last transaction |
integer |
count |
Transaction count |
integer |
blacklist – banned list definitions, one row per banned host
This table is written only by the admin tool. Read-only by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
id |
Row ID |
integer |
domain |
The hostname/domain of the banned host. If this string matches any part of the requesting host, that host is not allowed to use the activation server |
string (255). No spaces. |
type |
Type of banned list entry |
integer |
company – customer company information
This table is used only by the admin tool. Unused by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
company_id |
Company ID (primary key) |
integer |
company |
Company name |
string (60) |
addr1 |
Address line 1 |
string (60) |
addr2 |
Address line 2 |
string (60) |
addr3 |
Address line 3 |
string (60) |
city |
City |
string (60) |
state |
State |
string (60) |
zip |
Zip/Postal code |
string (60) |
country |
Country |
string (60) |
c_notes |
Misc notes. |
string (255) |
companyowner |
Reseller owner of this company |
integer |
u1 |
User-defined. |
string (60) |
u2 |
User-defined. |
string (60) |
u3 |
User-defined. |
string (60) |
u4 |
User-defined. |
string (60) |
u5 |
User-defined. |
string (60) |
u6 |
User-defined. |
string (60) |
u7 |
User-defined. |
string (60) |
u8 |
User-defined. |
string (60) |
u9 |
User-defined. |
string (60) |
u10 |
User-defined. |
string (60) |
contact – customer contact person information
This table is used only by the admin tool. Unused by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
contact_id |
Contact ID (primary key) |
integer |
contact |
Contact person name |
string (60) |
contact_type |
Contact type |
string (60) |
title |
Job Title |
string (60) |
phone |
Phone # |
string (20) |
fax |
Fax # |
string (20) |
Email address |
string (60) |
|
info |
General notes |
string (60) |
company_id |
ID of associated company record |
integer |
ccreate |
Creation date |
string (11) |
contactowner |
Reseller owner of contact |
integer |
contact_types – customer contact type definitions
This table is used only by the admin tool. Unused by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
contact_type |
Contact type |
string (60) |
debuglog – license generator debug log
This table is written by the license generator and admin tool. Read by the admin tool only.
Column |
Meaning |
Data type |
|---|---|---|
date |
Date/time of entry |
integer |
logdata |
The debug data logged |
string (500) |
defaults – default specifications for products and activation keys
This table is read and written only by the admin tool.
Column |
Meaning |
Data type |
|---|---|---|
id |
Row unique id |
integer |
user |
Whose default (#SYS# for system default) |
string (30) |
tab |
Which table (prod or keyd) |
string (30) |
col |
Column in table |
string (30) |
value |
Default value |
string (80) |
invis |
Field is invisible |
integer (1) |
keyd - activation key definitions, one row per activation key
This table is written only by the admin tool. Read-only by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
akey |
The activation key (35 character maximum). |
string |
active |
0 if this definition is inactive, 1 if active. |
integer |
product id |
Product identifier, from product definitions. |
integer |
count |
The # of activations allowed, 0 = unlimited. Limited to 1 for Refresh-type activations. |
integer |
type |
0 - Normal, 1 - Reactivate, 2 - Refresh |
integer |
rehosts |
For revoked hostids, the number of hostid changes allowed. |
integer |
lastdate |
Expiration date of activation key - key cannot be used after this date. |
string |
exp |
If a number, number of days to expiration of the license after product activation. If == 0, the license does not expire. If a standard RLM date format, it is a fixed expiration date. If specified, this expiration date overrides the expiration date in the product definition. |
string |
kver |
License version, to override product definition. |
string (11) |
kver_type |
License version type. |
integer |
white |
Domain whitelist for key - only domain names appearing in this list can use the key. This string can be a spaceseparated list. If any component of the string matches the requesting hostname, that host is allowed to activate using this key. |
string (100) |
misc |
Any optional RLM license attributes. |
string (255) |
notes |
Optional notes to allow you to identify the key - unused by RLM. |
string (100) |
contact_id |
Contact ID of owner of activation key. |
integer |
key_allowed_hostids |
Allowed Hostids for this activation key (overrides product definition). |
integer |
kcreate |
Key creation time. |
char (11) |
ash_sn |
Serial number for Alternate Server hostid. |
integer |
user_def |
User-defined field (unused by Activation Pro). |
char (32) |
sub_interval |
Subscription Interval (Subscription type only). -1 == month, -2 == quarter -3 == year, + == # of days. |
smallint (6) |
sub_window |
Subscription Renewal Window (Subscription type only). |
smallint (6) |
keyowner |
Company id of reseller who owns this key. |
integer |
keyf - activation key fulfillment information, one row per activation key
This table is written by both the license generator and RLC.
Column |
Meaning |
Data type |
|---|---|---|
akey |
The activation key |
string |
num |
Number of (current) fulfillments from this key, not counting fulfillments which were subsequently revoked. |
integer |
date |
For Reactvation: original expiration date of the license. For Refresh: last date license refreshed. |
string |
lasthostid |
For Refresh type: Last hostid fulfilled. |
string (80) |
num_revoked |
Number of licenses revoked . |
integer |
licf - license fulfillment information, one row per activation
This table is written by both the license generator and RLC.
Column |
Meaning |
Data type |
|---|---|---|
id |
Row ID |
integer |
akey |
The activation key. |
string |
product_id |
Product identifier |
integer |
count |
Number of licenses activated. |
integer |
time |
Time() value when activation was done. |
time_t (integer) |
license_hostid |
Hostid for license. |
string |
reference_hostid |
Reference hostid for rehostable licenses. |
string |
expdate |
Expiration date of first license, in fmt yyyy-mm-dd. |
string |
hostname |
Hostname on activated machine. |
string |
remote_host |
IP address (typically) of machine requesting activation. |
string |
log |
Log info from rlm_act_request() call. |
string |
license |
Generated license. For floating licenses, this is just the LICENSE line. |
string |
last_fulfill |
time() value at last fulfillment. |
time_t (integer) |
num_fulfills |
Number of fulfillments of this license. |
integer |
revoked |
“license was revoked” flag (1=revoked). |
integer |
revoked_time |
Time license was revoked. |
integer |
last_check |
Last time an rlm_act_keyvalid() called on this fulfillment. |
integer |
time_str |
String version of time field. |
string |
last_fulfill_str |
String version of last_fulfill field. |
string |
last_check_str |
String version of last_check field. |
string |
prod - product definitions, one row per product definition
This table is written only by the admin tool. Read-only by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
id |
Activation product identifier |
integer |
active |
0 if this definition is inactive, 1 if active (product definitions are not deleted). The license generator doesn’t create licenses for inactive products . |
integer |
obsolete |
1 if this product definition is obsolete, meaning it can’t be used to create new activation keys. |
integer (1) |
name |
Product Definition name |
string |
version |
The RLM product version |
string |
version_type |
0 – normal version, non-zero – date-based version |
integer |
upgrade_version |
Upgrade-from version number (UPGRADE licenses only) |
string |
exp |
If a number, number of days to expiration of the license after product activation. If == 0, the license does not expire. If a standard RLM date format, it is a fixed expiration date. |
string |
lictype |
0 = floating, 1 = node-locked, uncounted, 2 = node-locked, counted (unimplemented), 3 = single, 4 = UPGRADE (floating) |
integer |
issued |
0 - do not include “issued=” in license, 1 - include “issued=[today’s date]” in license. |
integer |
add_akey |
0 – do not include “akey=” in license, 1 – include “akey=” |
integer |
add_cust |
0 – do not include “customer=” in license, 1 - include |
tinyint |
product |
License product name . |
string |
misc |
Any optional RLM license attributes . |
string |
generator |
Used to specify alternate license generators. 0=standard RLM generator. |
integer |
prod_id |
ID of the Primary License of this product definition. 0 for the primary license. |
integer |
nlic |
Number of licenses to create per fulfillment request. Multiplied by request count. Unused for nodelocked or single licenses. |
integer |
prod_allowed_hostids |
Bitmap of allowed hostid types. If 0, all hostid types are allowed. |
integer |
pcreate |
Record creation date |
string |
ash_type |
Alternate server hostid type |
integer |
ash_tolerance |
Alternate server hostid tolerance |
integer |
lictext |
Text to prepend to generated license |
varchar (1024) |
pnotes |
Notes for this product definition |
varchar (100) |
report_cols – database columns which appear in report
This table is read-only by RLC. Unused by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
id |
Primary key |
integer |
report |
Report name |
string (40) |
displayorder |
Order to display selections |
integer (2) |
tablecolumn |
Column name from table |
string (40) |
display |
Report column header text |
string (30) |
is_int |
If non-zero, column contains integer data |
integer (1) |
report_select – report selection definitions
This table is read-only by RLC. Unused by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
id |
Primary key |
integer |
report |
Report name |
string (40) |
fixed |
Is selection criteria fixed or variable |
integer (1) |
displayorder |
Order to display selections |
integer (2) |
display |
Text to display in UI |
string (40) |
var |
POST variable name |
string (20) |
size |
Size of text box in UI |
integer (3) |
op |
Table for report data |
string (20) |
value |
Value for fixed selection criteria |
string (64) |
report_types – report type definitions
This table is read-only by RLC. Unused by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
report |
Report name |
string (40) |
sel |
Used by report writer UI |
string (2) |
tablename |
Table for report data |
string (40) |
displayorder |
Order to display report names |
integer (2) |
report_header |
Display header for report |
string (80) |
type |
Report type (0-internal, 1-user-defined) |
integer (1) |
base_report |
Base report for a user-defined report |
string (40) |
rep_output |
Output for user-defined report |
integer (2) |
schedule |
Schedule for user-defined report |
integer (1) |
subschedule |
Sub-schedule for user-defined report |
char (10) |
email_to |
Email list for user-defined report |
char (80) |
setup - RLC setup definitions, one row per setup item
This table is written only by the admin tool. Read-only by the license generator. This table contains data such as the activation URL for refresh, Activation Pro version, etc.
Column |
Meaning |
Data type |
|---|---|---|
what |
Description of the data item |
string (30) |
data |
The actual data |
string (64) |
stats – Activation statistics
This table contains license generation statistics. This table is read-only by RLC. Read-write by the license generator.
Column |
Meaning |
Data type |
|---|---|---|
date |
Date in the format” yyyy-mm-dd hh”. This record collects statistics for 60 minutes starting at the hour indicated. Primary key. |
char (13) |
total |
Total transactions with the activation server |
integer (11) |
good |
Completed license fulfillments |
integer (11) |
badkey |
Unknown activation key supplied |
integer (11) |
blacklist |
# of hosts automatically banned |
integer |
checks |
Reprise pings the hosted activation servers with an invalid activation key to check that the website is up, the license generator is working and the database is working. This is a bad key where the key supplied is “rsi-check-act-server”. |
integer (11) |
numfulfill |
Number of “num fulfill” commands executed. Used by rlm_act_revoke()/rlm_act_rehost_revoke(). |
integer (11) |
rmfulfill |
Number of “remove fulfill” commands executed. Used by rlm_act_revoke()/rlm_act_rehost_revoke(). |
integer (11) |
prod |
Number of “list product” commands executed. Used by rehostable hostid activation. |
integer (11) |
badtime |
Number of otherwise good requests from clients with clocks which are off by more than 7 days. |
integer (11) |
info |
# of getinfo requests. |
integer |
keyvalid |
# of keyvalid requests. |
integer |