84 int KsmKeyPairCreate(
int policy_id,
const char* HSMKeyID,
int smID,
int size,
int alg,
const char* generate,
DB_ID*
id)
95 sql =
DisSpecifyInit(
"keypairs",
"policy_id, HSMkey_id, securitymodule_id, size, algorithm, generate");
146 char* columns = NULL;
153 StrAppend(&columns,
"zone_id, keypair_id, keytype, state");
260 switch (condition[i].code) {
263 condition[i].data.
number, i);
268 condition[i].data.
number, i);
273 condition[i].data.
number, i);
278 condition[i].data.
number, i);
283 condition[i].data.
number, i);
508 status =
KsmKey(result, data);
562 int KsmKeyPredict(
int policy_id,
int keytype,
int shared_keys,
int interval,
int *count,
int rollover_scheme,
int zone_count)
573 if (zone_count == 0) {
622 *count *= zone_count;
663 nchar = snprintf(in,
sizeof(in),
"(%d, %d, %d, %d, %d, %d, %d)",
665 if (nchar >=
sizeof(in)) {
732 int KsmKeyCountStillGood(
int policy_id,
int sm,
int bits,
int algorithm,
int interval,
const char* datetime,
int *count,
int keytype)
767 nchar = snprintf(in,
sizeof(in),
"(%d, %d, %d, %d, %d, %d, %d)",
769 if (nchar >=
sizeof(in)) {
778 nchar = snprintf(buffer,
sizeof(buffer),
779 "DATE_ADD('%s', INTERVAL %d SECOND)", datetime, total_interval);
781 nchar = snprintf(buffer,
sizeof(buffer),
782 "DATETIME('%s', '+%d SECONDS')", datetime, total_interval);
784 if (nchar >=
sizeof(buffer)) {
792 sql =
StrStrdup(
"SELECT COUNT(DISTINCT location) FROM KEYDATA_VIEW");
793 if (policy_id != -1) {
802 if (algorithm != -1) {
813 StrAppend(&sql,
" and (DATETIME(RETIRE) > ");
870 int KsmKeyGetUnallocated(
int policy_id,
int sm,
int bits,
int algorithm,
int zone_id,
int share_keys,
int *keypair_id)
890 snprintf(in_sql, 1024,
"(select id from KEYALLOC_VIEW where zone_id = %d)", zone_id);
891 snprintf(in_sql2, 1024,
"(select distinct id from KEYDATA_VIEW where policy_id = %d and state in (%d, %d))", policy_id,
KSM_STATE_RETIRE,
KSM_STATE_DEAD);
919 else if (status == -1) {}
968 status =
KsmKey(result, &data);
969 while (status == 0) {
974 status =
KsmKey(result, &data);
1017 printf(
"Couldn't turn \"now\" into a date, quitting...\n");
1025 if (zone_id != -1) {