keydb_db4.c

   1 /*
   2  * keydb_db4.c - Routines to store and fetch keys in a DB4 database.
   3  *
   4  * Jonathan McDowell <noodles@earth.li>
   5  *
   6  * Copyright 2002-2004 Project Purple
   7  */
   8
   9 #include <sys/types.h>
  10 #include <sys/uio.h>
  11 #include <ctype.h>
  12 #include <errno.h>
  13 #include <fcntl.h>
  14 #include <stdio.h>
  15 #include <stdlib.h>
  16 #include <string.h>
  17 #include <unistd.h>
  18
  19 #include <db.h>
  20
  21 #include "charfuncs.h"
  22 #include "keyarray.h"
  23 #include "keydb.h"
  24 #include "keyid.h"
  25 #include "decodekey.h"
  26 #include "keystructs.h"
  27 #include "mem.h"
  28 #include "log.h"
  29 #include "onak-conf.h"
  30 #include "parsekey.h"
  31 #include "wordlist.h"
  32
  33 /**
  34  *      dbenv - our database environment.
  35  */
  36 static DB_ENV *dbenv = NULL;
  37
  38 /**
  39  *      numdb - The number of database files we have.
  40  */
  41 static int numdbs = 16;
  42
  43 /**
  44  *      dbconn - our connections to the key database files.
  45  */
  46 static DB **dbconns = NULL;
  47
  48 /**
  49  *      worddb - our connection to the word database.
  50  */
  51 static DB *worddb = NULL;
  52
  53 /**
  54  *      id32db - our connection to the 32bit ID database.
  55  */
  56 static DB *id32db = NULL;
  57
  58 /**
  59  *      txn - our current transaction id.
  60  */
  61 static DB_TXN *txn = NULL;
  62
  63 DB *keydb(uint64_t keyid)
  64 {
  65         uint64_t keytrun;
  66
  67         keytrun = keyid >> 8;
  68
  69         return(dbconns[keytrun % numdbs]);
  70 }
  71
  72 /**
  73  *      starttrans - Start a transaction.
  74  *
  75  *      Start a transaction. Intended to be used if we're about to perform many
  76  *      operations on the database to help speed it all up, or if we want
  77  *      something to only succeed if all relevant operations are successful.
  78  */
  79 static bool db4_starttrans(void)
  80 {
  81         int ret;
  82
  83         log_assert(dbenv != NULL);
  84         log_assert(txn == NULL);
  85
  86         ret = dbenv->txn_begin(dbenv,
  87                 NULL, /* No parent transaction */
  88                 &txn,
  89                 0);
  90         if (ret != 0) {
  91                 logthing(LOGTHING_CRITICAL,
  92                                 "Error starting transaction: %s",
  93                                 db_strerror(ret));
  94                 exit(1);
  95         }
  96
  97         return true;
  98 }
  99
 100 /**
 101  *      endtrans - End a transaction.
 102  *
 103  *      Ends a transaction.
 104  */
 105 static void db4_endtrans(void)
 106 {
 107         int ret;
 108
 109         log_assert(dbenv != NULL);
 110         log_assert(txn != NULL);
 111
 112         ret = txn->commit(txn,
 113                 0);
 114         if (ret != 0) {
 115                 logthing(LOGTHING_CRITICAL,
 116                                 "Error ending transaction: %s",
 117                                 db_strerror(ret));
 118                 exit(1);
 119         }
 120         txn = NULL;
 121
 122         return;
 123 }
 124
 125 /**
 126  *      cleanupdb - De-initialize the key database.
 127  *
 128  *      This function should be called upon program exit to allow the DB to
 129  *      cleanup after itself.
 130  */
 131 static void db4_cleanupdb(void)
 132 {
 133         int i = 0;
 134
 135         if (dbenv != NULL) {
 136                 dbenv->txn_checkpoint(dbenv, 0, 0, 0);
 137                 if (id32db != NULL) {
 138                         id32db->close(id32db, 0);
 139                         id32db = NULL;
 140                 }
 141                 if (worddb != NULL) {
 142                         worddb->close(worddb, 0);
 143                         worddb = NULL;
 144                 }
 145                 for (i = 0; i < numdbs; i++) {
 146                         if (dbconns[i] != NULL) {
 147                                 dbconns[i]->close(dbconns[i], 0);
 148                                 dbconns[i] = NULL;
 149                         }
 150                 }
 151                 free(dbconns);
 152                 dbconns = NULL;
 153                 dbenv->close(dbenv, 0);
 154                 dbenv = NULL;
 155         }
 156 }
 157
 158 /**
 159  *      initdb - Initialize the key database.
 160  *
 161  *      This function should be called before any of the other functions in
 162  *      this file are called in order to allow the DB to be initialized ready
 163  *      for access.
 164  */
 165 static void db4_initdb(bool readonly)
 166 {
 167         char       buf[1024];
 168         FILE      *numdb = NULL;
 169         int        ret = 0;
 170         int        i = 0;
 171         u_int32_t  flags = 0;
 172
 173         snprintf(buf, sizeof(buf) - 1, "%s/num_keydb", config.db_dir);
 174         numdb = fopen(buf, "r");
 175         if (numdb != NULL) {
 176                 if (fgets(buf, sizeof(buf), numdb) != NULL) {
 177                         numdbs = atoi(buf);
 178                 }
 179                 fclose(numdb);
 180         } else if (!readonly) {
 181                 logthing(LOGTHING_ERROR, "Couldn't open num_keydb: %s",
 182                                 strerror(errno));
 183                 numdb = fopen(buf, "w");
 184                 if (numdb != NULL) {
 185                         fprintf(numdb, "%d", numdbs);
 186                         fclose(numdb);
 187                 } else {
 188                         logthing(LOGTHING_ERROR,
 189                                 "Couldn't write num_keydb: %s",
 190                                 strerror(errno));
 191                 }
 192         }
 193
 194         dbconns = malloc(sizeof (DB *) * numdbs);
 195         if (dbconns == NULL) {
 196                 logthing(LOGTHING_CRITICAL,
 197                                 "Couldn't allocate memory for dbconns");
 198                 ret = 1;
 199         }
 200
 201         if (ret == 0) {
 202                 ret = db_env_create(&dbenv, 0);
 203                 if (ret != 0) {
 204                         logthing(LOGTHING_CRITICAL,
 205                                 "db_env_create: %s", db_strerror(ret));
 206                 }
 207         }
 208
 209         /*
 210          * Enable deadlock detection so that we don't block indefinitely on
 211          * anything. What we really want is simple 2 state locks, but I'm not
 212          * sure how to make the standard DB functions do that yet.
 213          */
 214         if (ret == 0) {
 215                 ret = dbenv->set_lk_detect(dbenv, DB_LOCK_DEFAULT);
 216                 if (ret != 0) {
 217                         logthing(LOGTHING_CRITICAL,
 218                                 "db_env_create: %s", db_strerror(ret));
 219                 }
 220         }
 221
 222         if (ret == 0) {
 223                 ret = dbenv->open(dbenv, config.db_dir,
 224                                 DB_INIT_LOG | DB_INIT_MPOOL | DB_INIT_LOCK |
 225                                 DB_INIT_TXN |
 226                                 DB_CREATE,
 227                                 0);
 228                 if (ret != 0) {
 229                         logthing(LOGTHING_CRITICAL,
 230                                         "Error opening db environment: %s (%s)",
 231                                         config.db_dir,
 232                                         db_strerror(ret));
 233                         dbenv->close(dbenv, 0);
 234                         dbenv = NULL;
 235                 }
 236         }
 237
 238         if (ret == 0) {
 239                 db4_starttrans();
 240
 241                 for (i = 0; !ret && i < numdbs; i++) {
 242                         ret = db_create(&dbconns[i], dbenv, 0);
 243                         if (ret != 0) {
 244                                 logthing(LOGTHING_CRITICAL,
 245                                         "db_create: %s", db_strerror(ret));
 246                         }
 247
 248                         if (ret == 0) {
 249                                 snprintf(buf, 1023, "keydb.%d.db", i);
 250                                 flags = DB_CREATE;
 251                                 if (readonly) {
 252                                         flags = DB_RDONLY;
 253                                 }
 254                                 ret = dbconns[i]->open(dbconns[i],
 255                                                 txn,
 256                                                 buf,
 257                                                 "keydb",
 258                                                 DB_HASH,
 259                                                 flags,
 260                                                 0664);
 261                                 if (ret != 0) {
 262                                         logthing(LOGTHING_CRITICAL,
 263                                                 "Error opening key database:"
 264                                                 " %s (%s)",
 265                                                 buf,
 266                                                 db_strerror(ret));
 267                                 }
 268                         }
 269                 }
 270
 271         }
 272
 273         if (ret == 0) {
 274                 ret = db_create(&worddb, dbenv, 0);
 275                 if (ret != 0) {
 276                         logthing(LOGTHING_CRITICAL, "db_create: %s",
 277                                         db_strerror(ret));
 278                 }
 279         }
 280
 281         if (ret == 0) {
 282                 ret = worddb->set_flags(worddb, DB_DUP);
 283         }
 284
 285         if (ret == 0) {
 286                 ret = worddb->open(worddb, txn, "worddb", "worddb", DB_BTREE,
 287                                 flags,
 288                                 0664);
 289                 if (ret != 0) {
 290                         logthing(LOGTHING_CRITICAL,
 291                                         "Error opening word database: %s (%s)",
 292                                         "worddb",
 293                                         db_strerror(ret));
 294                 }
 295         }
 296
 297         if (ret == 0) {
 298                 ret = db_create(&id32db, dbenv, 0);
 299                 if (ret != 0) {
 300                         logthing(LOGTHING_CRITICAL, "db_create: %s",
 301                                         db_strerror(ret));
 302                 }
 303         }
 304
 305         if (ret == 0) {
 306                 ret = id32db->set_flags(id32db, DB_DUP);
 307         }
 308
 309         if (ret == 0) {
 310                 ret = id32db->open(id32db, txn, "id32db", "id32db", DB_HASH,
 311                                 flags,
 312                                 0664);
 313                 if (ret != 0) {
 314                         logthing(LOGTHING_CRITICAL,
 315                                         "Error opening id32 database: %s (%s)",
 316                                         "id32db",
 317                                         db_strerror(ret));
 318                 }
 319         }
 320
 321         if (txn != NULL) {
 322                 endtrans();
 323         }
 324
 325         if (ret != 0) {
 326                 db4_cleanupdb();
 327                 logthing(LOGTHING_CRITICAL,
 328                                 "Error opening database; exiting");
 329                 exit(EXIT_FAILURE);
 330         }
 331
 332         return;
 333 }
 334
 335 /**
 336  *      fetch_key - Given a keyid fetch the key from storage.
 337  *      @keyid: The keyid to fetch.
 338  *      @publickey: A pointer to a structure to return the key in.
 339  *      @intrans: If we're already in a transaction.
 340  *
 341  *      We use the hex representation of the keyid as the filename to fetch the
 342  *      key from. The key is stored in the file as a binary OpenPGP stream of
 343  *      packets, so we can just use read_openpgp_stream() to read the packets
 344  *      in and then parse_keys() to parse the packets into a publickey
 345  *      structure.
 346  */
 347 static int db4_fetch_key(uint64_t keyid, struct openpgp_publickey **publickey,
 348                 bool intrans)
 349 {
 350         struct openpgp_packet_list *packets = NULL;
 351         DBT key, data;
 352         int ret = 0;
 353         int numkeys = 0;
 354         struct buffer_ctx fetchbuf;
 355
 356         if (keyid < 0x100000000LL) {
 357                 keyid = getfullkeyid(keyid);
 358         }
 359
 360         memset(&key, 0, sizeof(key));
 361         memset(&data, 0, sizeof(data));
 362
 363         data.size = 0;
 364         data.data = NULL;
 365
 366         key.size = sizeof(keyid);
 367         key.data = &keyid;
 368
 369         if (!intrans) {
 370                 db4_starttrans();
 371         }
 372
 373         ret = keydb(keyid)->get(keydb(keyid),
 374                         txn,
 375                         &key,
 376                         &data,
 377                         0); /* flags*/
 378
 379         if (ret == 0) {
 380                 fetchbuf.buffer = data.data;
 381                 fetchbuf.offset = 0;
 382                 fetchbuf.size = data.size;
 383                 read_openpgp_stream(buffer_fetchchar, &fetchbuf,
 384                                 &packets, 0);
 385                 parse_keys(packets, publickey);
 386                 free_packet_list(packets);
 387                 packets = NULL;
 388                 numkeys++;
 389         } else if (ret != DB_NOTFOUND) {
 390                 logthing(LOGTHING_ERROR,
 391                                 "Problem retrieving key: %s",
 392                                 db_strerror(ret));
 393         }
 394
 395         if (!intrans) {
 396                 endtrans();
 397         }
 398
 399         return (numkeys);
 400 }
 401
 402 int worddb_cmp(const void *d1, const void *d2)
 403 {
 404         return memcmp(d1, d2, 12);
 405 }
 406
 407 /**
 408  *      fetch_key_text - Trys to find the keys that contain the supplied text.
 409  *      @search: The text to search for.
 410  *      @publickey: A pointer to a structure to return the key in.
 411  *
 412  *      This function searches for the supplied text and returns the keys that
 413  *      contain it.
 414  */
 415 static int db4_fetch_key_text(const char *search,
 416                 struct openpgp_publickey **publickey)
 417 {
 418         DBC *cursor = NULL;
 419         DBT key, data;
 420         int ret;
 421         uint64_t keyid;
 422         int i;
 423         int numkeys;
 424         char *searchtext = NULL;
 425         struct ll *wordlist = NULL;
 426         struct ll *curword = NULL;
 427         struct keyarray keylist = { NULL, 0, 0 };
 428         struct keyarray newkeylist = { NULL, 0, 0 };
 429
 430         numkeys = 0;
 431         searchtext = strdup(search);
 432         wordlist = makewordlist(wordlist, searchtext);
 433
 434         for (curword = wordlist; curword != NULL; curword = curword->next) {
 435                 db4_starttrans();
 436
 437                 ret = worddb->cursor(worddb,
 438                                 txn,
 439                                 &cursor,
 440                                 0);   /* flags */
 441
 442                 memset(&key, 0, sizeof(key));
 443                 memset(&data, 0, sizeof(data));
 444                 key.data = curword->object;
 445                 key.size = strlen(curword->object);
 446                 data.flags = DB_DBT_MALLOC;
 447                 ret = cursor->c_get(cursor,
 448                                 &key,
 449                                 &data,
 450                                 DB_SET);
 451                 while (ret == 0 && strncmp(key.data, curword->object,
 452                                         key.size) == 0 &&
 453                                 ((char *) curword->object)[key.size] == 0) {
 454                         keyid = 0;
 455                         for (i = 4; i < 12; i++) {
 456                                 keyid <<= 8;
 457                                 keyid += ((unsigned char *)
 458                                                 data.data)[i];
 459                         }
 460
 461                         if (keylist.count == 0 ||
 462                                         array_find(&keylist, keyid)) {
 463                                 array_add(&newkeylist, keyid);
 464                         }
 465
 466                         free(data.data);
 467                         data.data = NULL;
 468
 469                         ret = cursor->c_get(cursor,
 470                                         &key,
 471                                         &data,
 472                                         DB_NEXT);
 473                 }
 474                 array_free(&keylist);
 475                 keylist = newkeylist;
 476                 newkeylist.keys = NULL;
 477                 newkeylist.count = newkeylist.size = 0;
 478                 if (data.data != NULL) {
 479                         free(data.data);
 480                         data.data = NULL;
 481                 }
 482                 ret = cursor->c_close(cursor);
 483                 cursor = NULL;
 484                 endtrans();
 485         }
 486         llfree(wordlist, NULL);
 487         wordlist = NULL;
 488
 489         db4_starttrans();
 490         for (i = 0; i < keylist.count; i++) {
 491                 numkeys += fetch_key(keylist.keys[i],
 492                         publickey,
 493                         true);
 494         }
 495         array_free(&keylist);
 496         free(searchtext);
 497         searchtext = NULL;
 498
 499         endtrans();
 500
 501         return (numkeys);
 502 }
 503
 504 /**
 505  *      store_key - Takes a key and stores it.
 506  *      @publickey: A pointer to the public key to store.
 507  *      @intrans: If we're already in a transaction.
 508  *      @update: If true the key exists and should be updated.
 509  *
 510  *      Again we just use the hex representation of the keyid as the filename
 511  *      to store the key to. We flatten the public key to a list of OpenPGP
 512  *      packets and then use write_openpgp_stream() to write the stream out to
 513  *      the file. If update is true then we delete the old key first, otherwise
 514  *      we trust that it doesn't exist.
 515  */
 516 static int db4_store_key(struct openpgp_publickey *publickey, bool intrans,
 517                 bool update)
 518 {
 519         struct     openpgp_packet_list *packets = NULL;
 520         struct     openpgp_packet_list *list_end = NULL;
 521         struct     openpgp_publickey *next = NULL;
 522         int        ret = 0;
 523         int        i = 0;
 524         struct     buffer_ctx storebuf;
 525         DBT        key;
 526         DBT        data;
 527         uint64_t   keyid = 0;
 528         uint32_t   shortkeyid = 0;
 529         uint64_t  *subkeyids = NULL;
 530         char     **uids = NULL;
 531         char      *primary = NULL;
 532         unsigned char worddb_data[12];
 533         struct ll *wordlist = NULL;
 534         struct ll *curword  = NULL;
 535         bool       deadlock = false;
 536
 537         keyid = get_keyid(publickey);
 538
 539         if (!intrans) {
 540                 db4_starttrans();
 541         }
 542
 543         /*
 544          * Delete the key if we already have it.
 545          *
 546          * TODO: Can we optimize this perhaps? Possibly when other data is
 547          * involved as well? I suspect this is easiest and doesn't make a lot
 548          * of difference though - the largest chunk of data is the keydata and
 549          * it definitely needs updated.
 550          */
 551         if (update) {
 552                 deadlock = (delete_key(keyid, true) == -1);
 553         }
 554
 555         /*
 556          * Convert the key to a flat set of binary data.
 557          */
 558         if (!deadlock) {
 559                 next = publickey->next;
 560                 publickey->next = NULL;
 561                 flatten_publickey(publickey, &packets, &list_end);
 562                 publickey->next = next;
 563
 564                 storebuf.offset = 0;
 565                 storebuf.size = 8192;
 566                 storebuf.buffer = malloc(8192);
 567
 568                 write_openpgp_stream(buffer_putchar, &storebuf, packets);
 569
 570                 /*
 571                  * Now we have the key data store it in the DB; the keyid is
 572                  * the key.
 573                  */
 574                 memset(&key, 0, sizeof(key));
 575                 memset(&data, 0, sizeof(data));
 576                 key.data = &keyid;
 577                 key.size = sizeof(keyid);
 578                 data.size = storebuf.offset;
 579                 data.data = storebuf.buffer;
 580
 581                 ret = keydb(keyid)->put(keydb(keyid),
 582                                 txn,
 583                                 &key,
 584                                 &data,
 585                                 0); /* flags*/
 586                 if (ret != 0) {
 587                         logthing(LOGTHING_ERROR,
 588                                         "Problem storing key: %s",
 589                                         db_strerror(ret));
 590                         if (ret == DB_LOCK_DEADLOCK) {
 591                                 deadlock = true;
 592                         }
 593                 }
 594
 595                 free(storebuf.buffer);
 596                 storebuf.buffer = NULL;
 597                 storebuf.size = 0;
 598                 storebuf.offset = 0;
 599
 600                 free_packet_list(packets);
 601                 packets = NULL;
 602         }
 603
 604         /*
 605          * Walk through our uids storing the words into the db with the keyid.
 606          */
 607         if (!deadlock) {
 608                 uids = keyuids(publickey, &primary);
 609         }
 610         if (uids != NULL) {
 611                 for (i = 0; ret == 0 && uids[i] != NULL; i++) {
 612                         wordlist = makewordlist(wordlist, uids[i]);
 613                 }
 614
 615                 for (curword = wordlist; curword != NULL && !deadlock;
 616                                 curword = curword->next) {
 617                         memset(&key, 0, sizeof(key));
 618                         memset(&data, 0, sizeof(data));
 619                         key.data = curword->object;
 620                         key.size = strlen(key.data);
 621                         data.data = worddb_data;
 622                         data.size = sizeof(worddb_data);
 623
 624                         /*
 625                          * Our data is the key creation time followed by the
 626                          * key id.
 627                          */
 628                         worddb_data[ 0] = publickey->publickey->data[1];
 629                         worddb_data[ 1] = publickey->publickey->data[2];
 630                         worddb_data[ 2] = publickey->publickey->data[3];
 631                         worddb_data[ 3] = publickey->publickey->data[4];
 632                         worddb_data[ 4] = (keyid >> 56) & 0xFF;
 633                         worddb_data[ 5] = (keyid >> 48) & 0xFF;
 634                         worddb_data[ 6] = (keyid >> 40) & 0xFF;
 635                         worddb_data[ 7] = (keyid >> 32) & 0xFF;
 636                         worddb_data[ 8] = (keyid >> 24) & 0xFF;
 637                         worddb_data[ 9] = (keyid >> 16) & 0xFF;
 638                         worddb_data[10] = (keyid >>  8) & 0xFF;
 639                         worddb_data[11] = keyid & 0xFF;
 640                         ret = worddb->put(worddb,
 641                                 txn,
 642                                 &key,
 643                                 &data,
 644                                 0);
 645                         if (ret != 0) {
 646                                 logthing(LOGTHING_ERROR,
 647                                         "Problem storing word: %s",
 648                                         db_strerror(ret));
 649                                 if (ret == DB_LOCK_DEADLOCK) {
 650                                         deadlock = true;
 651                                 }
 652                         }
 653                 }
 654
 655                 /*
 656                  * Free our UID and word lists.
 657                  */
 658                 llfree(wordlist, NULL);
 659                 for (i = 0; uids[i] != NULL; i++) {
 660                         free(uids[i]);
 661                         uids[i] = NULL;
 662                 }
 663                 free(uids);
 664                 uids = NULL;
 665         }
 666
 667         /*
 668          * Write the truncated 32 bit keyid so we can lookup the full id for
 669          * queries.
 670          */
 671         if (!deadlock) {
 672                 shortkeyid = keyid & 0xFFFFFFFF;
 673
 674                 memset(&key, 0, sizeof(key));
 675                 memset(&data, 0, sizeof(data));
 676                 key.data = &shortkeyid;
 677                 key.size = sizeof(shortkeyid);
 678                 data.data = &keyid;
 679                 data.size = sizeof(keyid);
 680
 681                 ret = id32db->put(id32db,
 682                         txn,
 683                         &key,
 684                         &data,
 685                         0);
 686                 if (ret != 0) {
 687                         logthing(LOGTHING_ERROR,
 688                                 "Problem storing short keyid: %s",
 689                                 db_strerror(ret));
 690                         if (ret == DB_LOCK_DEADLOCK) {
 691                                 deadlock = true;
 692                         }
 693                 }
 694         }
 695
 696         if (!deadlock) {
 697                 subkeyids = keysubkeys(publickey);
 698                 i = 0;
 699                 while (subkeyids != NULL && subkeyids[i] != 0) {
 700                         shortkeyid = subkeyids[i++] & 0xFFFFFFFF;
 701
 702                         memset(&key, 0, sizeof(key));
 703                         memset(&data, 0, sizeof(data));
 704                         key.data = &shortkeyid;
 705                         key.size = sizeof(shortkeyid);
 706                         data.data = &keyid;
 707                         data.size = sizeof(keyid);
 708
 709                         ret = id32db->put(id32db,
 710                                 txn,
 711                                 &key,
 712                                 &data,
 713                                 0);
 714                         if (ret != 0) {
 715                                 logthing(LOGTHING_ERROR,
 716                                         "Problem storing short keyid: %s",
 717                                         db_strerror(ret));
 718                                 if (ret == DB_LOCK_DEADLOCK) {
 719                                         deadlock = true;
 720                                 }
 721                         }
 722                 }
 723                 if (subkeyids != NULL) {
 724                         free(subkeyids);
 725                         subkeyids = NULL;
 726                 }
 727         }
 728
 729         if (!intrans) {
 730                 endtrans();
 731         }
 732
 733         return deadlock ? -1 : 0 ;
 734 }
 735
 736 /**
 737  *      delete_key - Given a keyid delete the key from storage.
 738  *      @keyid: The keyid to delete.
 739  *      @intrans: If we're already in a transaction.
 740  *
 741  *      This function deletes a public key from whatever storage mechanism we
 742  *      are using. Returns 0 if the key existed.
 743  */
 744 static int db4_delete_key(uint64_t keyid, bool intrans)
 745 {
 746         struct openpgp_publickey *publickey = NULL;
 747         DBT key, data;
 748         DBC *cursor = NULL;
 749         uint32_t   shortkeyid = 0;
 750         uint64_t  *subkeyids = NULL;
 751         int ret = 0;
 752         int i;
 753         char **uids = NULL;
 754         char *primary = NULL;
 755         unsigned char worddb_data[12];
 756         struct ll *wordlist = NULL;
 757         struct ll *curword  = NULL;
 758         bool deadlock = false;
 759
 760         if (!intrans) {
 761                 db4_starttrans();
 762         }
 763
 764         fetch_key(keyid, &publickey, true);
 765
 766         /*
 767          * Walk through the uids removing the words from the worddb.
 768          */
 769         if (publickey != NULL) {
 770                 uids = keyuids(publickey, &primary);
 771         }
 772         if (uids != NULL) {
 773                 for (i = 0; ret == 0 && uids[i] != NULL; i++) {
 774                         wordlist = makewordlist(wordlist, uids[i]);
 775                 }
 776
 777                 ret = worddb->cursor(worddb,
 778                         txn,
 779                         &cursor,
 780                         0);   /* flags */
 781
 782                 for (curword = wordlist; curword != NULL && !deadlock;
 783                                 curword = curword->next) {
 784                         memset(&key, 0, sizeof(key));
 785                         memset(&data, 0, sizeof(data));
 786                         key.data = curword->object;
 787                         key.size = strlen(key.data);
 788                         data.data = worddb_data;
 789                         data.size = sizeof(worddb_data);
 790
 791                         /*
 792                          * Our data is the key creation time followed by the
 793                          * key id.
 794                          */
 795                         worddb_data[ 0] = publickey->publickey->data[1];
 796                         worddb_data[ 1] = publickey->publickey->data[2];
 797                         worddb_data[ 2] = publickey->publickey->data[3];
 798                         worddb_data[ 3] = publickey->publickey->data[4];
 799                         worddb_data[ 4] = (keyid >> 56) & 0xFF;
 800                         worddb_data[ 5] = (keyid >> 48) & 0xFF;
 801                         worddb_data[ 6] = (keyid >> 40) & 0xFF;
 802                         worddb_data[ 7] = (keyid >> 32) & 0xFF;
 803                         worddb_data[ 8] = (keyid >> 24) & 0xFF;
 804                         worddb_data[ 9] = (keyid >> 16) & 0xFF;
 805                         worddb_data[10] = (keyid >>  8) & 0xFF;
 806                         worddb_data[11] = keyid & 0xFF;
 807
 808                         ret = cursor->c_get(cursor,
 809                                 &key,
 810                                 &data,
 811                                 DB_GET_BOTH);
 812
 813                         if (ret == 0) {
 814                                 ret = cursor->c_del(cursor, 0);
 815                                 if (ret != 0) {
 816                                         logthing(LOGTHING_ERROR,
 817                                                 "Problem deleting word: %s",
 818                                                 db_strerror(ret));
 819                                 }
 820                         }
 821
 822                         if (ret != 0) {
 823                                 logthing(LOGTHING_ERROR,
 824                                         "Problem deleting word: %s",
 825                                         db_strerror(ret));
 826                                 if (ret == DB_LOCK_DEADLOCK) {
 827                                         deadlock = true;
 828                                 }
 829                         }
 830                 }
 831                 ret = cursor->c_close(cursor);
 832                 cursor = NULL;
 833
 834                 /*
 835                  * Free our UID and word lists.
 836                  */
 837                 llfree(wordlist, NULL);
 838                 for (i = 0; uids[i] != NULL; i++) {
 839                         free(uids[i]);
 840                         uids[i] = NULL;
 841                 }
 842                 free(uids);
 843                 uids = NULL;
 844                 free_publickey(publickey);
 845                 publickey = NULL;
 846         }
 847
 848         if (!deadlock) {
 849                 ret = id32db->cursor(id32db,
 850                         txn,
 851                         &cursor,
 852                         0);   /* flags */
 853
 854                 shortkeyid = keyid & 0xFFFFFFFF;
 855
 856                 memset(&key, 0, sizeof(key));
 857                 memset(&data, 0, sizeof(data));
 858                 key.data = &shortkeyid;
 859                 key.size = sizeof(shortkeyid);
 860                 data.data = &keyid;
 861                 data.size = sizeof(keyid);
 862
 863                 ret = cursor->c_get(cursor,
 864                         &key,
 865                         &data,
 866                         DB_GET_BOTH);
 867
 868                 if (ret == 0) {
 869                         ret = cursor->c_del(cursor, 0);
 870                         if (ret != 0) {
 871                                 logthing(LOGTHING_ERROR,
 872                                         "Problem deleting short keyid: %s",
 873                                         db_strerror(ret));
 874                         }
 875                 }
 876
 877                 if (ret != 0) {
 878                         logthing(LOGTHING_ERROR,
 879                                 "Problem deleting short keyid: %s",
 880                                 db_strerror(ret));
 881                         if (ret == DB_LOCK_DEADLOCK) {
 882                                 deadlock = true;
 883                         }
 884                 }
 885
 886                 subkeyids = keysubkeys(publickey);
 887                 i = 0;
 888                 while (subkeyids != NULL && subkeyids[i] != 0) {
 889                         shortkeyid = subkeyids[i++] & 0xFFFFFFFF;
 890
 891                         memset(&key, 0, sizeof(key));
 892                         memset(&data, 0, sizeof(data));
 893                         key.data = &shortkeyid;
 894                         key.size = sizeof(shortkeyid);
 895                         data.data = &keyid;
 896                         data.size = sizeof(keyid);
 897
 898                         ret = cursor->c_get(cursor,
 899                                 &key,
 900                                 &data,
 901                                 DB_GET_BOTH);
 902
 903                         if (ret == 0) {
 904                                 ret = cursor->c_del(cursor, 0);
 905                                 if (ret != 0) {
 906                                         logthing(LOGTHING_ERROR,
 907                                                 "Problem deleting short"
 908                                                 " keyid: %s",
 909                                                 db_strerror(ret));
 910                                 }
 911                         }
 912
 913                         if (ret != 0) {
 914                                 logthing(LOGTHING_ERROR,
 915                                         "Problem deleting short keyid: %s",
 916                                         db_strerror(ret));
 917                                 if (ret == DB_LOCK_DEADLOCK) {
 918                                         deadlock = true;
 919                                 }
 920                         }
 921                 }
 922                 if (subkeyids != NULL) {
 923                         free(subkeyids);
 924                         subkeyids = NULL;
 925                 }
 926
 927                 ret = cursor->c_close(cursor);
 928                 cursor = NULL;
 929         }
 930
 931         if (!deadlock) {
 932                 key.data = &keyid;
 933                 key.size = sizeof(keyid);
 934
 935                 keydb(keyid)->del(keydb(keyid),
 936                                 txn,
 937                                 &key,
 938                                 0); /* flags */
 939         }
 940
 941         if (!intrans) {
 942                 endtrans();
 943         }
 944
 945         return deadlock ? (-1) : (ret == DB_NOTFOUND);
 946 }
 947
 948 /**
 949  *      iterate_keys - call a function once for each key in the db.
 950  *      @iterfunc: The function to call.
 951  *      @ctx: A context pointer
 952  *
 953  *      Calls iterfunc once for each key in the database. ctx is passed
 954  *      unaltered to iterfunc. This function is intended to aid database dumps
 955  *      and statistic calculations.
 956  *
 957  *      Returns the number of keys we iterated over.
 958  */
 959 static int db4_iterate_keys(void (*iterfunc)(void *ctx,
 960                 struct openpgp_publickey *key), void *ctx)
 961 {
 962         DBT                         dbkey, data;
 963         DBC                        *cursor = NULL;
 964         int                         ret = 0;
 965         int                         i = 0;
 966         int                         numkeys = 0;
 967         struct buffer_ctx           fetchbuf;
 968         struct openpgp_packet_list *packets = NULL;
 969         struct openpgp_publickey   *key = NULL;
 970
 971         for (i = 0; i < numdbs; i++) {
 972                 ret = dbconns[i]->cursor(dbconns[i],
 973                         NULL,
 974                         &cursor,
 975                         0);   /* flags */
 976
 977                 memset(&dbkey, 0, sizeof(dbkey));
 978                 memset(&data, 0, sizeof(data));
 979                 ret = cursor->c_get(cursor, &dbkey, &data, DB_NEXT);
 980                 while (ret == 0) {
 981                         fetchbuf.buffer = data.data;
 982                         fetchbuf.offset = 0;
 983                         fetchbuf.size = data.size;
 984                         read_openpgp_stream(buffer_fetchchar, &fetchbuf,
 985                                 &packets, 0);
 986                         parse_keys(packets, &key);
 987
 988                         iterfunc(ctx, key);
 989
 990                         free_publickey(key);
 991                         key = NULL;
 992                         free_packet_list(packets);
 993                         packets = NULL;
 994
 995                         memset(&dbkey, 0, sizeof(dbkey));
 996                         memset(&data, 0, sizeof(data));
 997                         ret = cursor->c_get(cursor, &dbkey, &data,
 998                                         DB_NEXT);
 999                         numkeys++;
1000                 }
1001                 if (ret != DB_NOTFOUND) {
1002                         logthing(LOGTHING_ERROR,
1003                                 "Problem reading key: %s",
1004                                 db_strerror(ret));
1005                 }
1006
1007                 ret = cursor->c_close(cursor);
1008                 cursor = NULL;
1009         }
1010
1011         return numkeys;
1012 }
1013
1014 /**
1015  *      getfullkeyid - Maps a 32bit key id to a 64bit one.
1016  *      @keyid: The 32bit keyid.
1017  *
1018  *      This function maps a 32bit key id to the full 64bit one. It returns the
1019  *      full keyid. If the key isn't found a keyid of 0 is returned.
1020  */
1021 static uint64_t db4_getfullkeyid(uint64_t keyid)
1022 {
1023         DBT       key, data;
1024         DBC      *cursor = NULL;
1025         uint32_t  shortkeyid = 0;
1026         int       ret = 0;
1027
1028         if (keyid < 0x100000000LL) {
1029                 ret = id32db->cursor(id32db,
1030                                 txn,
1031                                 &cursor,
1032                                 0);   /* flags */
1033
1034                 shortkeyid = keyid & 0xFFFFFFFF;
1035
1036                 memset(&key, 0, sizeof(key));
1037                 memset(&data, 0, sizeof(data));
1038                 key.data = &shortkeyid;
1039                 key.size = sizeof(shortkeyid);
1040                 data.flags = DB_DBT_MALLOC;
1041
1042                 ret = cursor->c_get(cursor,
1043                         &key,
1044                         &data,
1045                         DB_SET);
1046
1047                 if (ret == 0) {
1048                         keyid = *(uint64_t *) data.data;
1049
1050                         if (data.data != NULL) {
1051                                 free(data.data);
1052                                 data.data = NULL;
1053                         }
1054                 }
1055
1056                 ret = cursor->c_close(cursor);
1057                 cursor = NULL;
1058         }
1059
1060         return keyid;
1061 }
1062
1063 /*
1064  * Include the basic keydb routines.
1065  */
1066 #define NEED_GETKEYSIGS 1
1067 #define NEED_KEYID2UID 1
1068 #define NEED_UPDATEKEYS 1
1069 #include "keydb.c"
1070
1071 struct dbfuncs keydb_db4_funcs = {
1072         .initdb                 = db4_initdb,
1073         .cleanupdb              = db4_cleanupdb,
1074         .starttrans             = db4_starttrans,
1075         .endtrans               = db4_endtrans,
1076         .fetch_key              = db4_fetch_key,
1077         .fetch_key_text         = db4_fetch_key_text,
1078         .store_key              = db4_store_key,
1079         .update_keys            = generic_update_keys,
1080         .delete_key             = db4_delete_key,
1081         .getkeysigs             = generic_getkeysigs,
1082         .cached_getkeysigs      = generic_cached_getkeysigs,
1083         .keyid2uid              = generic_keyid2uid,
1084         .getfullkeyid           = db4_getfullkeyid,
1085         .iterate_keys           = db4_iterate_keys,
1086 };