...
1 #include "pEp_internal.h"
2 #include "dynamic_api.h"
3 #include "cryptotech.h"
8 static int init_count = -1;
10 static int user_version(void *_version, int count, char **text, char **name)
14 assert(text && text[0]);
15 if (!(_version && count == 1 && text && text[0]))
18 int *version = (int *) _version;
19 *version = atoi(text[0]);
23 DYNAMIC_API PEP_STATUS init(PEP_SESSION *session)
25 PEP_STATUS status = PEP_STATUS_OK;
27 static const char *sql_log;
28 static const char *sql_trustword;
29 static const char *sql_get_identity;
30 static const char *sql_set_person;
31 static const char *sql_set_pgp_keypair;
32 static const char *sql_set_identity;
33 static const char *sql_set_identity_flags;
34 static const char *sql_set_trust;
35 static const char *sql_get_trust;
36 static const char *sql_least_trust;
37 static const char *sql_mark_as_compromized;
38 static const char *sql_crashdump;
39 static const char *sql_languagelist;
40 static const char *sql_i18n_token;
43 static const char *sql_blacklist_add;
44 static const char *sql_blacklist_delete;
45 static const char *sql_blacklist_is_listed;
46 static const char *sql_blacklist_retrieve;
49 static const char *sql_own_key_is_listed;
50 static const char *sql_own_identities_retrieve;
53 static const char *sql_sequence_value1;
54 static const char *sql_sequence_value2;
56 // Revocation tracking
57 static const char *sql_set_revoked;
58 static const char *sql_get_revoked;
60 bool in_first = false;
62 assert(sqlite3_threadsafe());
63 if (!sqlite3_threadsafe())
64 return PEP_INIT_SQLITE3_WITHOUT_MUTEX;
66 // a little race condition - but still a race condition
67 // mitigated by calling caveat (see documentation)
75 return PEP_ILLEGAL_VALUE;
79 pEpSession *_session = calloc(1, sizeof(pEpSession));
84 _session->version = PEP_ENGINE_VERSION;
87 if (LOCAL_DB == NULL) {
88 status = PEP_INIT_CANNOT_OPEN_DB;
92 int_result = sqlite3_open_v2(
97 | SQLITE_OPEN_FULLMUTEX
98 | SQLITE_OPEN_PRIVATECACHE,
102 if (int_result != SQLITE_OK) {
103 status = PEP_INIT_CANNOT_OPEN_DB;
107 sqlite3_busy_timeout(_session->db, BUSY_WAIT_TIME);
110 if (SYSTEM_DB == NULL) {
111 status = PEP_INIT_CANNOT_OPEN_SYSTEM_DB;
115 int_result = sqlite3_open_v2(
116 SYSTEM_DB, &_session->system_db,
118 | SQLITE_OPEN_FULLMUTEX
119 | SQLITE_OPEN_SHAREDCACHE,
123 if (int_result != SQLITE_OK) {
124 status = PEP_INIT_CANNOT_OPEN_SYSTEM_DB;
128 sqlite3_busy_timeout(_session->system_db, 1000);
130 // increment this when patching DDL
131 #define _DDL_USER_VERSION "2"
134 int_result = sqlite3_exec(
136 "create table version_info (\n"
137 " id integer primary key,\n"
138 " timestamp integer default (datetime('now')) ,\n"
146 if (int_result == SQLITE_OK) {
147 int_result = sqlite3_exec(
149 "pragma user_version = "_DDL_USER_VERSION";\n"
150 "insert or replace into version_info (id, version)"
151 "values (1, '" PEP_ENGINE_VERSION "');",
156 assert(int_result == SQLITE_OK);
159 int_result = sqlite3_exec(
161 "PRAGMA application_id = 0x23423423;\n"
162 "create table if not exists log (\n"
163 " timestamp integer default (datetime('now')) ,\n"
164 " title text not null,\n"
165 " entity text not null,\n"
166 " description text,\n"
169 "create index if not exists log_timestamp on log (\n"
172 "create table if not exists pgp_keypair (\n"
173 " fpr text primary key,\n"
174 " public_id text unique,\n"
175 " private_id text,\n"
176 " created integer,\n"
177 " expires integer,\n"
179 " flags integer default (0)\n"
181 "create index if not exists pgp_keypair_expires on pgp_keypair (\n"
184 "create table if not exists person (\n"
185 " id text primary key,\n"
186 " username text not null,\n"
187 " main_key_id text\n"
188 " references pgp_keypair (fpr)\n"
189 " on delete set null,\n"
192 " device_group text\n"
194 "create table if not exists identity (\n"
197 " references person (id)\n"
198 " on delete cascade,\n"
199 " main_key_id text\n"
200 " references pgp_keypair (fpr)\n"
201 " on delete set null,\n"
203 " flags integer default (0),"
204 " primary key (address, user_id)\n"
206 "create table if not exists trust (\n"
207 " user_id text not null\n"
208 " references person (id)\n"
209 " on delete cascade,\n"
210 " pgp_keypair_fpr text not null\n"
211 " references pgp_keypair (fpr)\n"
212 " on delete cascade,\n"
213 " comm_type integer not null,\n"
215 " primary key (user_id, pgp_keypair_fpr)\n"
218 "create table if not exists blacklist_keys (\n"
219 " fpr text primary key\n"
222 "create table if not exists sequences(\n"
223 " name text primary key,\n"
224 " value integer default 0\n"
226 "create table if not exists revoked_keys (\n"
227 " revoked_fpr text primary key,\n"
228 " replacement_fpr text not null\n"
229 " references pgp_keypair (fpr)\n"
230 " on delete cascade,\n"
231 " revocation_date integer\n"
238 assert(int_result == SQLITE_OK);
241 int_result = sqlite3_exec(
243 "pragma user_version;",
248 assert(int_result == SQLITE_OK);
251 int_result = sqlite3_exec(
253 "alter table identity\n"
254 " add column flags integer default (0);\n",
259 assert(int_result == SQLITE_OK);
263 int_result = sqlite3_exec(
265 "alter table pgp_keypair\n"
266 " add column flags integer default (0);\n"
267 "alter table person\n"
268 " add column device_group text;\n",
273 assert(int_result == SQLITE_OK);
276 if (version < atoi(_DDL_USER_VERSION)) {
277 int_result = sqlite3_exec(
279 "pragma user_version = "_DDL_USER_VERSION";\n"
280 "insert or replace into version_info (id, version)"
281 "values (1, '" PEP_ENGINE_VERSION "');",
286 assert(int_result == SQLITE_OK);
289 sql_log = "insert into log (title, entity, description, comment)"
290 "values (?1, ?2, ?3, ?4);";
292 sql_get_identity = "select fpr, username, comm_type, lang,"
293 " identity.flags | pgp_keypair.flags"
295 " join person on id = identity.user_id"
296 " join pgp_keypair on fpr = identity.main_key_id"
297 " join trust on id = trust.user_id"
298 " and pgp_keypair_fpr = identity.main_key_id"
299 " where address = ?1 and identity.user_id = ?2;";
301 sql_trustword = "select id, word from wordlist where lang = lower(?1) "
304 // Set person, but if already exist, only update.
305 // if main_key_id already set, don't touch.
306 sql_set_person = "insert or replace into person (id, username, lang, main_key_id)"
307 " values (?1, ?2, ?3,"
308 " (select coalesce((select main_key_id from person "
309 " where id = ?1), upper(replace(?4,' ',''))))) ;";
311 sql_set_pgp_keypair = "insert or replace into pgp_keypair (fpr) "
312 "values (upper(replace(?1,' ',''))) ;";
314 sql_set_identity = "insert or replace into identity (address, main_key_id, "
315 "user_id, flags) values (?1, upper(replace(?2,' ','')),"
318 sql_set_identity_flags = "update identity set flags = ?1 & 255 "
319 "where address = ?2 and user_id = ?3 ;";
321 sql_set_trust = "insert or replace into trust (user_id, pgp_keypair_fpr, comm_type) "
322 "values (?1, upper(replace(?2,' ','')), ?3) ;";
324 sql_get_trust = "select comm_type from trust where user_id = ?1 "
325 "and pgp_keypair_fpr = upper(replace(?2,' ','')) ;";
327 sql_least_trust = "select min(comm_type) from trust where pgp_keypair_fpr = upper(replace(?1,' ','')) ;";
329 sql_mark_as_compromized = "update trust not indexed set comm_type = 15"
330 " where pgp_keypair_fpr = upper(replace(?1,' ','')) ;";
332 sql_crashdump = "select timestamp, title, entity, description, comment"
333 " from log order by timestamp desc limit ?1 ;";
335 sql_languagelist = "select i18n_language.lang, name, phrase from i18n_language join i18n_token using (lang) where i18n_token.id = 1000;" ;
337 sql_i18n_token = "select phrase from i18n_token where lang = lower(?1) and id = ?2 ;";
341 sql_blacklist_add = "insert or replace into blacklist_keys (fpr) values (upper(replace(?1,' ',''))) ;"
342 "delete from identity where main_key_id = upper(replace(?1,' ','')) ;"
343 "delete from pgp_keypair where fpr = upper(replace(?1,' ','')) ;";
345 sql_blacklist_delete = "delete from blacklist_keys where fpr = upper(replace(?1,' ','')) ;";
347 sql_blacklist_is_listed = "select count(*) from blacklist_keys where fpr = upper(replace(?1,' ','')) ;";
349 sql_blacklist_retrieve = "select * from blacklist_keys ;";
353 sql_own_key_is_listed =
354 "select count(*) from ("
355 " select main_key_id from person "
356 " where main_key_id = upper(replace(?1,' ',''))"
357 " and id = '" PEP_OWN_USERID "' "
359 " select main_key_id from identity "
360 " where main_key_id = upper(replace(?1,' ',''))"
361 " and user_id = '" PEP_OWN_USERID "' );";
363 sql_own_identities_retrieve = "select address, fpr, username, '" PEP_OWN_USERID "',"
364 " comm_type, lang, identity.flags | pgp_keypair.flags"
366 " join person on id = identity.user_id"
367 " join pgp_keypair on fpr = identity.main_key_id"
368 " join trust on id = trust.user_id"
369 " and pgp_keypair_fpr = identity.main_key_id"
370 " where identity.user_id = '" PEP_OWN_USERID "';";
372 sql_sequence_value1 = "insert or replace into sequences (name, value) "
374 "(select coalesce((select value + 1 from sequences "
375 "where name = ?1), 1 ))) ; ";
376 sql_sequence_value2 = "select value from sequences where name = ?1 ;";
378 sql_set_revoked = "insert or replace into revoked_keys ("
379 " revoked_fpr, replacement_fpr, revocation_date) "
380 "values (upper(replace(?1,' ','')),"
381 " upper(replace(?2,' ','')),"
384 sql_get_revoked = "select revoked_fpr, revocation_date from revoked_keys"
385 " where replacement_fpr = upper(replace(?1,' ','')) ;";
388 int_result = sqlite3_prepare_v2(_session->db, sql_log,
389 (int)strlen(sql_log), &_session->log, NULL);
390 assert(int_result == SQLITE_OK);
392 int_result = sqlite3_prepare_v2(_session->system_db, sql_trustword,
393 (int)strlen(sql_trustword), &_session->trustword, NULL);
394 assert(int_result == SQLITE_OK);
396 int_result = sqlite3_prepare_v2(_session->db, sql_get_identity,
397 (int)strlen(sql_get_identity), &_session->get_identity, NULL);
398 assert(int_result == SQLITE_OK);
400 int_result = sqlite3_prepare_v2(_session->db, sql_set_person,
401 (int)strlen(sql_set_person), &_session->set_person, NULL);
402 assert(int_result == SQLITE_OK);
404 int_result = sqlite3_prepare_v2(_session->db, sql_set_pgp_keypair,
405 (int)strlen(sql_set_pgp_keypair), &_session->set_pgp_keypair,
407 assert(int_result == SQLITE_OK);
409 int_result = sqlite3_prepare_v2(_session->db, sql_set_identity,
410 (int)strlen(sql_set_identity), &_session->set_identity, NULL);
411 assert(int_result == SQLITE_OK);
413 int_result = sqlite3_prepare_v2(_session->db, sql_set_identity_flags,
414 (int)strlen(sql_set_identity_flags), &_session->set_identity_flags,
416 assert(int_result == SQLITE_OK);
418 int_result = sqlite3_prepare_v2(_session->db, sql_set_trust,
419 (int)strlen(sql_set_trust), &_session->set_trust, NULL);
420 assert(int_result == SQLITE_OK);
422 int_result = sqlite3_prepare_v2(_session->db, sql_get_trust,
423 (int)strlen(sql_get_trust), &_session->get_trust, NULL);
424 assert(int_result == SQLITE_OK);
426 int_result = sqlite3_prepare_v2(_session->db, sql_least_trust,
427 (int)strlen(sql_least_trust), &_session->least_trust, NULL);
428 assert(int_result == SQLITE_OK);
430 int_result = sqlite3_prepare_v2(_session->db, sql_mark_as_compromized,
431 (int)strlen(sql_mark_as_compromized), &_session->mark_compromized,
433 assert(int_result == SQLITE_OK);
435 int_result = sqlite3_prepare_v2(_session->db, sql_crashdump,
436 (int)strlen(sql_crashdump), &_session->crashdump, NULL);
437 assert(int_result == SQLITE_OK);
439 int_result = sqlite3_prepare_v2(_session->system_db, sql_languagelist,
440 (int)strlen(sql_languagelist), &_session->languagelist, NULL);
441 assert(int_result == SQLITE_OK);
443 int_result = sqlite3_prepare_v2(_session->system_db, sql_i18n_token,
444 (int)strlen(sql_i18n_token), &_session->i18n_token, NULL);
445 assert(int_result == SQLITE_OK);
449 int_result = sqlite3_prepare_v2(_session->db, sql_blacklist_add,
450 (int)strlen(sql_blacklist_add), &_session->blacklist_add, NULL);
451 assert(int_result == SQLITE_OK);
453 int_result = sqlite3_prepare_v2(_session->db, sql_blacklist_delete,
454 (int)strlen(sql_blacklist_delete), &_session->blacklist_delete,
456 assert(int_result == SQLITE_OK);
458 int_result = sqlite3_prepare_v2(_session->db, sql_blacklist_is_listed,
459 (int)strlen(sql_blacklist_is_listed),
460 &_session->blacklist_is_listed, NULL);
461 assert(int_result == SQLITE_OK);
463 int_result = sqlite3_prepare_v2(_session->db, sql_blacklist_retrieve,
464 (int)strlen(sql_blacklist_retrieve), &_session->blacklist_retrieve,
466 assert(int_result == SQLITE_OK);
470 int_result = sqlite3_prepare_v2(_session->db, sql_own_key_is_listed,
471 (int)strlen(sql_own_key_is_listed), &_session->own_key_is_listed,
473 assert(int_result == SQLITE_OK);
475 int_result = sqlite3_prepare_v2(_session->db, sql_own_identities_retrieve,
476 (int)strlen(sql_own_identities_retrieve),
477 &_session->own_identities_retrieve, NULL);
478 assert(int_result == SQLITE_OK);
482 int_result = sqlite3_prepare_v2(_session->db, sql_sequence_value1,
483 (int)strlen(sql_sequence_value1), &_session->sequence_value1,
485 assert(int_result == SQLITE_OK);
487 int_result = sqlite3_prepare_v2(_session->db, sql_sequence_value2,
488 (int)strlen(sql_sequence_value2), &_session->sequence_value2,
490 assert(int_result == SQLITE_OK);
492 // Revocation tracking
494 int_result = sqlite3_prepare_v2(_session->db, sql_set_revoked,
495 (int)strlen(sql_set_revoked), &_session->set_revoked, NULL);
496 assert(int_result == SQLITE_OK);
498 int_result = sqlite3_prepare_v2(_session->db, sql_get_revoked,
499 (int)strlen(sql_get_revoked), &_session->get_revoked, NULL);
500 assert(int_result == SQLITE_OK);
502 status = init_cryptotech(_session, in_first);
503 if (status != PEP_STATUS_OK)
506 status = init_transport_system(_session, in_first);
507 if (status != PEP_STATUS_OK)
510 status = log_event(_session, "init", "pEp " PEP_ENGINE_VERSION, NULL, NULL);
511 if (status != PEP_STATUS_OK)
516 _session->passive_mode = false;
517 _session->unencrypted_subject = false;
519 _session->use_only_own_private_keys = true;
520 #elif TARGET_OS_IPHONE
521 _session->use_only_own_private_keys = true;
523 _session->use_only_own_private_keys = false;
527 return PEP_STATUS_OK;
530 status = PEP_OUT_OF_MEMORY;
537 DYNAMIC_API void release(PEP_SESSION session)
539 bool out_last = false;
541 assert(init_count >= 0);
544 if (!((init_count >= 0) && session))
547 // a small race condition but still a race condition
548 // mitigated by calling caveat (see documentation)
557 sqlite3_finalize(session->log);
558 if (session->trustword)
559 sqlite3_finalize(session->trustword);
560 if (session->get_identity)
561 sqlite3_finalize(session->get_identity);
562 if (session->set_person)
563 sqlite3_finalize(session->set_person);
564 if (session->set_pgp_keypair)
565 sqlite3_finalize(session->set_pgp_keypair);
566 if (session->set_identity)
567 sqlite3_finalize(session->set_identity);
568 if (session->set_identity_flags)
569 sqlite3_finalize(session->set_identity_flags);
570 if (session->set_trust)
571 sqlite3_finalize(session->set_trust);
572 if (session->get_trust)
573 sqlite3_finalize(session->get_trust);
574 if (session->least_trust)
575 sqlite3_finalize(session->least_trust);
576 if (session->mark_compromized)
577 sqlite3_finalize(session->mark_compromized);
578 if (session->crashdump)
579 sqlite3_finalize(session->crashdump);
580 if (session->languagelist)
581 sqlite3_finalize(session->languagelist);
582 if (session->i18n_token)
583 sqlite3_finalize(session->i18n_token);
584 if (session->blacklist_add)
585 sqlite3_finalize(session->blacklist_add);
586 if (session->blacklist_delete)
587 sqlite3_finalize(session->blacklist_delete);
588 if (session->blacklist_is_listed)
589 sqlite3_finalize(session->blacklist_is_listed);
590 if (session->blacklist_retrieve)
591 sqlite3_finalize(session->blacklist_retrieve);
594 sqlite3_close_v2(session->db);
595 if (session->system_db)
596 sqlite3_close_v2(session->system_db);
599 release_transport_system(session, out_last);
600 release_cryptotech(session, out_last);
606 DYNAMIC_API void config_passive_mode(PEP_SESSION session, bool enable)
609 session->passive_mode = enable;
612 DYNAMIC_API void config_unencrypted_subject(PEP_SESSION session, bool enable)
615 session->unencrypted_subject = enable;
618 DYNAMIC_API void config_use_only_own_private_keys(PEP_SESSION session,
622 session->use_only_own_private_keys = enable;
625 DYNAMIC_API PEP_STATUS log_event(
629 const char *description,
633 PEP_STATUS status = PEP_STATUS_OK;
640 if (!(session && title && entity))
641 return PEP_ILLEGAL_VALUE;
643 sqlite3_reset(session->log);
644 sqlite3_bind_text(session->log, 1, title, -1, SQLITE_STATIC);
645 sqlite3_bind_text(session->log, 2, entity, -1, SQLITE_STATIC);
647 sqlite3_bind_text(session->log, 3, description, -1, SQLITE_STATIC);
649 sqlite3_bind_null(session->log, 3);
651 sqlite3_bind_text(session->log, 4, comment, -1, SQLITE_STATIC);
653 sqlite3_bind_null(session->log, 4);
655 result = sqlite3_step(session->log);
656 assert(result == SQLITE_DONE || result == SQLITE_BUSY);
657 if (result != SQLITE_DONE && result != SQLITE_BUSY)
658 status = PEP_UNKNOWN_ERROR;
659 } while (result == SQLITE_BUSY);
660 sqlite3_reset(session->log);
665 DYNAMIC_API PEP_STATUS trustword(
666 PEP_SESSION session, uint16_t value, const char *lang,
667 char **word, size_t *wsize
670 PEP_STATUS status = PEP_STATUS_OK;
676 if (!(session && word && wsize))
677 return PEP_ILLEGAL_VALUE;
685 assert((lang[0] >= 'A' && lang[0] <= 'Z')
686 || (lang[0] >= 'a' && lang[0] <= 'z'));
687 assert((lang[1] >= 'A' && lang[1] <= 'Z')
688 || (lang[1] >= 'a' && lang[1] <= 'z'));
689 assert(lang[2] == 0);
691 sqlite3_reset(session->trustword);
692 sqlite3_bind_text(session->trustword, 1, lang, -1, SQLITE_STATIC);
693 sqlite3_bind_int(session->trustword, 2, value);
695 const int result = sqlite3_step(session->trustword);
696 if (result == SQLITE_ROW) {
697 *word = strdup((const char *) sqlite3_column_text(session->trustword,
700 *wsize = sqlite3_column_bytes(session->trustword, 1);
702 status = PEP_OUT_OF_MEMORY;
704 status = PEP_TRUSTWORD_NOT_FOUND;
706 sqlite3_reset(session->trustword);
710 DYNAMIC_API PEP_STATUS trustwords(
711 PEP_SESSION session, const char *fingerprint, const char *lang,
712 char **words, size_t *wsize, int max_words
715 const char *source = fingerprint;
724 assert(max_words >= 0);
726 if (!(session && fingerprint && words && wsize && max_words >= 0))
727 return PEP_ILLEGAL_VALUE;
732 buffer = calloc(1, MAX_TRUSTWORDS_SPACE);
735 return PEP_OUT_OF_MEMORY;
738 fsize = strlen(fingerprint);
740 if (!lang || !lang[0])
743 assert((lang[0] >= 'A' && lang[0] <= 'Z')
744 || (lang[0] >= 'a' && lang[0] <= 'z'));
745 assert((lang[1] >= 'A' && lang[1] <= 'Z')
746 || (lang[1] >= 'a' && lang[1] <= 'z'));
747 assert(lang[2] == 0);
750 while (source < fingerprint + fsize) {
757 for (value=0, j=0; j < 4 && source < fingerprint + fsize; ) {
758 if (*source >= 'a' && *source <= 'f')
759 value += (*source - 'a' + 10) << (3 - j++) * 4;
760 else if (*source >= 'A' && *source <= 'F')
761 value += (*source - 'A' + 10) << (3 - j++) * 4;
762 else if (*source >= '0' && *source <= '9')
763 value += (*source - '0') << (3 - j++) * 4;
768 _status = trustword(session, value, lang, &word, &_wsize);
769 if (_status == PEP_OUT_OF_MEMORY) {
771 return PEP_OUT_OF_MEMORY;
775 return PEP_TRUSTWORD_NOT_FOUND;
778 if (dest + _wsize < buffer + MAX_TRUSTWORDS_SPACE - 1) {
779 strncpy(dest, word, _wsize);
785 break; // buffer full
788 if (source < fingerprint + fsize
789 && dest + _wsize < buffer + MAX_TRUSTWORDS_SPACE - 1)
793 if (max_words && n_words >= max_words)
798 *wsize = dest - buffer;
799 return PEP_STATUS_OK;
802 pEp_identity *new_identity(
803 const char *address, const char *fpr, const char *user_id,
807 pEp_identity *result = calloc(1, sizeof(pEp_identity));
811 result->address = strdup(address);
812 assert(result->address);
813 if (result->address == NULL) {
819 result->fpr = strdup(fpr);
821 if (result->fpr == NULL) {
822 free_identity(result);
827 result->user_id = strdup(user_id);
828 assert(result->user_id);
829 if (result->user_id == NULL) {
830 free_identity(result);
835 result->username = strdup(username);
836 assert(result->username);
837 if (result->username == NULL) {
838 free_identity(result);
846 pEp_identity *identity_dup(const pEp_identity *src)
850 pEp_identity *dup = new_identity(src->address, src->fpr, src->user_id,
856 dup->comm_type = src->comm_type;
857 dup->lang[0] = src->lang[0];
858 dup->lang[1] = src->lang[1];
861 dup->flags = src->flags;
866 void free_identity(pEp_identity *identity)
869 free(identity->address);
871 free(identity->user_id);
872 free(identity->username);
877 DYNAMIC_API PEP_STATUS get_identity(
881 pEp_identity **identity
884 PEP_STATUS status = PEP_STATUS_OK;
885 static pEp_identity *_identity;
892 if (!(session && address && address[0] && identity))
893 return PEP_ILLEGAL_VALUE;
897 sqlite3_reset(session->get_identity);
898 sqlite3_bind_text(session->get_identity, 1, address, -1, SQLITE_STATIC);
899 sqlite3_bind_text(session->get_identity, 2, user_id, -1, SQLITE_STATIC);
901 const int result = sqlite3_step(session->get_identity);
904 _identity = new_identity(
906 (const char *) sqlite3_column_text(session->get_identity, 0),
908 (const char *) sqlite3_column_text(session->get_identity, 1)
911 if (_identity == NULL)
912 return PEP_OUT_OF_MEMORY;
914 _identity->comm_type = (PEP_comm_type)
915 sqlite3_column_int(session->get_identity, 2);
916 const char* const _lang = (const char *)
917 sqlite3_column_text(session->get_identity, 3);
918 if (_lang && _lang[0]) {
919 assert(_lang[0] >= 'a' && _lang[0] <= 'z');
920 assert(_lang[1] >= 'a' && _lang[1] <= 'z');
921 assert(_lang[2] == 0);
922 _identity->lang[0] = _lang[0];
923 _identity->lang[1] = _lang[1];
924 _identity->lang[2] = 0;
926 _identity->flags = (unsigned int)
927 sqlite3_column_int(session->get_identity, 4);
928 *identity = _identity;
931 status = PEP_CANNOT_FIND_IDENTITY;
935 sqlite3_reset(session->get_identity);
939 DYNAMIC_API PEP_STATUS set_identity(
940 PEP_SESSION session, const pEp_identity *identity
947 assert(identity->address);
948 assert(identity->fpr);
949 assert(identity->user_id);
950 assert(identity->username);
952 if (!(session && identity && identity->address && identity->fpr &&
953 identity->user_id && identity->username))
954 return PEP_ILLEGAL_VALUE;
957 PEP_STATUS status = blacklist_is_listed(session, identity->fpr, &listed);
958 assert(status == PEP_STATUS_OK);
959 if (status != PEP_STATUS_OK)
963 return PEP_KEY_BLACKLISTED;
965 sqlite3_exec(session->db, "BEGIN ;", NULL, NULL, NULL);
967 sqlite3_reset(session->set_person);
968 sqlite3_bind_text(session->set_person, 1, identity->user_id, -1,
970 sqlite3_bind_text(session->set_person, 2, identity->username, -1,
972 if (identity->lang[0])
973 sqlite3_bind_text(session->set_person, 3, identity->lang, 1,
976 sqlite3_bind_null(session->set_person, 3);
977 sqlite3_bind_text(session->set_person, 4, identity->fpr, -1,
979 result = sqlite3_step(session->set_person);
980 sqlite3_reset(session->set_person);
981 if (result != SQLITE_DONE) {
982 sqlite3_exec(session->db, "ROLLBACK ;", NULL, NULL, NULL);
983 return PEP_CANNOT_SET_PERSON;
986 sqlite3_reset(session->set_pgp_keypair);
987 sqlite3_bind_text(session->set_pgp_keypair, 1, identity->fpr, -1,
989 result = sqlite3_step(session->set_pgp_keypair);
990 sqlite3_reset(session->set_pgp_keypair);
991 if (result != SQLITE_DONE) {
992 sqlite3_exec(session->db, "ROLLBACK ;", NULL, NULL, NULL);
993 return PEP_CANNOT_SET_PGP_KEYPAIR;
996 sqlite3_reset(session->set_identity);
997 sqlite3_bind_text(session->set_identity, 1, identity->address, -1,
999 sqlite3_bind_text(session->set_identity, 2, identity->fpr, -1,
1001 sqlite3_bind_text(session->set_identity, 3, identity->user_id, -1,
1003 sqlite3_bind_int(session->set_identity, 4, identity->flags);
1004 result = sqlite3_step(session->set_identity);
1005 sqlite3_reset(session->set_identity);
1006 if (result != SQLITE_DONE) {
1007 sqlite3_exec(session->db, "ROLLBACK ;", NULL, NULL, NULL);
1008 return PEP_CANNOT_SET_IDENTITY;
1011 sqlite3_reset(session->set_trust);
1012 sqlite3_bind_text(session->set_trust, 1, identity->user_id, -1,
1014 sqlite3_bind_text(session->set_trust, 2, identity->fpr, -1,
1016 sqlite3_bind_int(session->set_trust, 3, identity->comm_type);
1017 result = sqlite3_step(session->set_trust);
1018 sqlite3_reset(session->set_trust);
1019 if (result != SQLITE_DONE) {
1020 sqlite3_exec(session->db, "ROLLBACK ;", NULL, NULL, NULL);
1021 return PEP_CANNOT_SET_TRUST;
1024 result = sqlite3_exec(session->db, "COMMIT ;", NULL, NULL, NULL);
1025 if (result == SQLITE_OK)
1026 return PEP_STATUS_OK;
1028 return PEP_COMMIT_FAILED;
1031 DYNAMIC_API PEP_STATUS set_identity_flags(
1032 PEP_SESSION session,
1033 pEp_identity *identity,
1041 assert(identity->address);
1042 assert(identity->user_id);
1044 if (!(session && identity && identity->address && identity->user_id))
1045 return PEP_ILLEGAL_VALUE;
1047 sqlite3_reset(session->set_identity_flags);
1048 sqlite3_bind_int(session->set_identity_flags, 1, flags);
1049 sqlite3_bind_text(session->set_identity_flags, 2, identity->address, -1,
1051 sqlite3_bind_text(session->set_identity_flags, 3, identity->user_id, -1,
1053 result = sqlite3_step(session->set_identity_flags);
1054 sqlite3_reset(session->set_identity_flags);
1055 if (result != SQLITE_DONE)
1056 return PEP_CANNOT_SET_IDENTITY;
1058 identity->flags = flags;
1059 return PEP_STATUS_OK;
1062 DYNAMIC_API PEP_STATUS mark_as_compromized(
1063 PEP_SESSION session,
1070 assert(fpr && fpr[0]);
1072 if (!(session && fpr && fpr[0]))
1073 return PEP_ILLEGAL_VALUE;
1075 sqlite3_reset(session->mark_compromized);
1076 sqlite3_bind_text(session->mark_compromized, 1, fpr, -1,
1078 result = sqlite3_step(session->mark_compromized);
1079 sqlite3_reset(session->mark_compromized);
1081 if (result != SQLITE_DONE)
1082 return PEP_CANNOT_SET_TRUST;
1084 return PEP_STATUS_OK;
1087 void pEp_free(void *p)
1092 DYNAMIC_API PEP_STATUS get_trust(PEP_SESSION session, pEp_identity *identity)
1094 PEP_STATUS status = PEP_STATUS_OK;
1099 assert(identity->user_id);
1100 assert(identity->user_id[0]);
1101 assert(identity->fpr);
1102 assert(identity->fpr[0]);
1104 if (!(session && identity && identity->user_id && identity->user_id[0] &&
1105 identity->fpr && identity->fpr[0]))
1106 return PEP_ILLEGAL_VALUE;
1108 identity->comm_type = PEP_ct_unknown;
1110 sqlite3_reset(session->get_trust);
1111 sqlite3_bind_text(session->get_trust, 1, identity->user_id, -1,
1113 sqlite3_bind_text(session->get_trust, 2, identity->fpr, -1, SQLITE_STATIC);
1115 result = sqlite3_step(session->get_trust);
1118 int comm_type = (PEP_comm_type) sqlite3_column_int(session->get_trust,
1120 identity->comm_type = comm_type;
1125 status = PEP_CANNOT_FIND_IDENTITY;
1128 sqlite3_reset(session->get_trust);
1132 DYNAMIC_API PEP_STATUS least_trust(
1133 PEP_SESSION session,
1135 PEP_comm_type *comm_type
1138 PEP_STATUS status = PEP_STATUS_OK;
1145 if (!(session && fpr && comm_type))
1146 return PEP_ILLEGAL_VALUE;
1148 *comm_type = PEP_ct_unknown;
1150 sqlite3_reset(session->least_trust);
1151 sqlite3_bind_text(session->least_trust, 1, fpr, -1, SQLITE_STATIC);
1153 result = sqlite3_step(session->least_trust);
1156 int _comm_type = sqlite3_column_int(session->least_trust, 0);
1157 *comm_type = (PEP_comm_type) _comm_type;
1161 status = PEP_CANNOT_FIND_IDENTITY;
1164 sqlite3_reset(session->least_trust);
1168 DYNAMIC_API PEP_STATUS decrypt_and_verify(
1169 PEP_SESSION session, const char *ctext, size_t csize,
1170 char **ptext, size_t *psize, stringlist_t **keylist
1180 if (!(session && ctext && csize && ptext && psize && keylist))
1181 return PEP_ILLEGAL_VALUE;
1183 return session->cryptotech[PEP_crypt_OpenPGP].decrypt_and_verify(
1184 session, ctext, csize, ptext, psize, keylist);
1187 DYNAMIC_API PEP_STATUS encrypt_and_sign(
1188 PEP_SESSION session, const stringlist_t *keylist, const char *ptext,
1189 size_t psize, char **ctext, size_t *csize
1199 if (!(session && keylist && ptext && psize && ctext && csize))
1200 return PEP_ILLEGAL_VALUE;
1202 return session->cryptotech[PEP_crypt_OpenPGP].encrypt_and_sign(session,
1203 keylist, ptext, psize, ctext, csize);
1206 DYNAMIC_API PEP_STATUS verify_text(
1207 PEP_SESSION session, const char *text, size_t size,
1208 const char *signature, size_t sig_size, stringlist_t **keylist
1218 if (!(session && text && size && signature && sig_size && keylist))
1219 return PEP_ILLEGAL_VALUE;
1221 return session->cryptotech[PEP_crypt_OpenPGP].verify_text(session, text,
1222 size, signature, sig_size, keylist);
1225 DYNAMIC_API PEP_STATUS delete_keypair(PEP_SESSION session, const char *fpr)
1230 if (!(session && fpr))
1231 return PEP_ILLEGAL_VALUE;
1233 return session->cryptotech[PEP_crypt_OpenPGP].delete_keypair(session, fpr);
1236 DYNAMIC_API PEP_STATUS export_key(
1237 PEP_SESSION session, const char *fpr, char **key_data, size_t *size
1245 if (!(session && fpr && key_data && size))
1246 return PEP_ILLEGAL_VALUE;
1248 return session->cryptotech[PEP_crypt_OpenPGP].export_key(session, fpr,
1252 DYNAMIC_API PEP_STATUS find_keys(
1253 PEP_SESSION session, const char *pattern, stringlist_t **keylist
1260 if (!(session && pattern && keylist))
1261 return PEP_ILLEGAL_VALUE;
1263 return session->cryptotech[PEP_crypt_OpenPGP].find_keys(session, pattern,
1267 DYNAMIC_API PEP_STATUS generate_keypair(
1268 PEP_SESSION session, pEp_identity *identity
1273 assert(identity->address);
1274 assert(identity->fpr == NULL || identity->fpr[0] == 0);
1275 assert(identity->username);
1277 if (!(session && identity && identity->address &&
1278 (identity->fpr == NULL || identity->fpr[0] == 0) &&
1279 identity->username))
1280 return PEP_ILLEGAL_VALUE;
1283 session->cryptotech[PEP_crypt_OpenPGP].generate_keypair(session,
1285 if (status != PEP_STATUS_OK)
1288 // if a state machine for keysync is in place, inject notify
1289 if (session->sync_state != DeviceState_state_NONE)
1290 status = fsm_DeviceState_inject(session, KeyGen, NULL, NULL);
1295 DYNAMIC_API PEP_STATUS get_key_rating(
1296 PEP_SESSION session,
1298 PEP_comm_type *comm_type
1305 if (!(session && fpr && comm_type))
1306 return PEP_ILLEGAL_VALUE;
1308 return session->cryptotech[PEP_crypt_OpenPGP].get_key_rating(session, fpr,
1312 DYNAMIC_API PEP_STATUS import_key(
1313 PEP_SESSION session,
1314 const char *key_data,
1316 identity_list **private_keys
1322 if (!(session && key_data))
1323 return PEP_ILLEGAL_VALUE;
1325 return session->cryptotech[PEP_crypt_OpenPGP].import_key(session, key_data,
1326 size, private_keys);
1329 DYNAMIC_API PEP_STATUS recv_key(PEP_SESSION session, const char *pattern)
1334 if (!(session && pattern))
1335 return PEP_ILLEGAL_VALUE;
1337 return session->cryptotech[PEP_crypt_OpenPGP].recv_key(session, pattern);
1340 DYNAMIC_API PEP_STATUS send_key(PEP_SESSION session, const char *pattern)
1345 if (!(session && pattern))
1346 return PEP_ILLEGAL_VALUE;
1348 return session->cryptotech[PEP_crypt_OpenPGP].send_key(session, pattern);
1351 DYNAMIC_API PEP_STATUS renew_key(
1352 PEP_SESSION session,
1360 if (!(session && fpr))
1361 return PEP_ILLEGAL_VALUE;
1363 return session->cryptotech[PEP_crypt_OpenPGP].renew_key(session, fpr, ts);
1366 DYNAMIC_API PEP_STATUS revoke_key(
1367 PEP_SESSION session,
1375 if (!(session && fpr))
1376 return PEP_ILLEGAL_VALUE;
1378 return session->cryptotech[PEP_crypt_OpenPGP].revoke_key(session, fpr,
1382 DYNAMIC_API PEP_STATUS key_expired(
1383 PEP_SESSION session,
1393 if (!(session && fpr && expired))
1394 return PEP_ILLEGAL_VALUE;
1396 return session->cryptotech[PEP_crypt_OpenPGP].key_expired(session, fpr,
1400 DYNAMIC_API PEP_STATUS key_revoked(
1401 PEP_SESSION session,
1410 if (!(session && fpr && revoked))
1411 return PEP_ILLEGAL_VALUE;
1413 return session->cryptotech[PEP_crypt_OpenPGP].key_revoked(session, fpr,
1417 static void _clean_log_value(char *text)
1420 for (char *c = text; *c; c++) {
1421 if (*c < 32 && *c != '\n')
1429 static char *_concat_string(char *str1, const char *str2, char delim)
1431 str2 = str2 ? str2 : "";
1432 size_t len1 = str1 ? strlen(str1) : 0;
1433 size_t len2 = strlen(str2);
1434 size_t len = len1 + len2 + 3;
1435 char * result = realloc(str1, len + 1);
1439 strcpy(result + len1 + 1, str2);
1440 result[len - 2] = '"';
1441 result[len - 1] = delim;
1451 DYNAMIC_API PEP_STATUS get_crashdump_log(
1452 PEP_SESSION session,
1457 PEP_STATUS status = PEP_STATUS_OK;
1458 char *_logdata= NULL;
1461 assert(maxlines >= 0 && maxlines <= CRASHDUMP_MAX_LINES);
1464 if (!(session && logdata && maxlines >= 0 && maxlines <=
1465 CRASHDUMP_MAX_LINES))
1466 return PEP_ILLEGAL_VALUE;
1470 int limit = maxlines ? maxlines : CRASHDUMP_DEFAULT_LINES;
1471 const char *timestamp = NULL;
1472 const char *title = NULL;
1473 const char *entity = NULL;
1474 const char *desc = NULL;
1475 const char *comment = NULL;
1477 sqlite3_reset(session->crashdump);
1478 sqlite3_bind_int(session->crashdump, 1, limit);
1483 result = sqlite3_step(session->crashdump);
1486 timestamp = (const char *) sqlite3_column_text(session->crashdump,
1488 title = (const char *) sqlite3_column_text(session->crashdump,
1490 entity = (const char *) sqlite3_column_text(session->crashdump,
1492 desc = (const char *) sqlite3_column_text(session->crashdump,
1494 comment = (const char *) sqlite3_column_text(session->crashdump,
1497 _logdata = _concat_string(_logdata, timestamp, ',');
1498 if (_logdata == NULL)
1501 _logdata = _concat_string(_logdata, title, ',');
1502 if (_logdata == NULL)
1505 _logdata = _concat_string(_logdata, entity, ',');
1506 if (_logdata == NULL)
1509 _logdata = _concat_string(_logdata, desc, ',');
1510 if (_logdata == NULL)
1513 _logdata = _concat_string(_logdata, comment, '\n');
1514 if (_logdata == NULL)
1517 _clean_log_value(_logdata);
1524 status = PEP_UNKNOWN_ERROR;
1525 result = SQLITE_DONE;
1527 } while (result != SQLITE_DONE);
1529 sqlite3_reset(session->crashdump);
1530 if (status == PEP_STATUS_OK)
1531 *logdata = _logdata;
1536 status = PEP_OUT_OF_MEMORY;
1542 DYNAMIC_API PEP_STATUS get_languagelist(
1543 PEP_SESSION session,
1547 PEP_STATUS status = PEP_STATUS_OK;
1548 char *_languages= NULL;
1553 if (!(session && languages))
1554 return PEP_ILLEGAL_VALUE;
1558 const char *lang = NULL;
1559 const char *name = NULL;
1560 const char *phrase = NULL;
1562 sqlite3_reset(session->languagelist);
1567 result = sqlite3_step(session->languagelist);
1570 lang = (const char *) sqlite3_column_text(session->languagelist,
1572 name = (const char *) sqlite3_column_text(session->languagelist,
1574 phrase = (const char *) sqlite3_column_text(session->languagelist,
1577 _languages = _concat_string(_languages, lang, ',');
1578 if (_languages == NULL)
1581 _languages = _concat_string(_languages, name, ',');
1582 if (_languages == NULL)
1585 _languages = _concat_string(_languages, phrase, '\n');
1586 if (_languages == NULL)
1595 status = PEP_UNKNOWN_ERROR;
1596 result = SQLITE_DONE;
1598 } while (result != SQLITE_DONE);
1600 sqlite3_reset(session->languagelist);
1601 if (status == PEP_STATUS_OK)
1602 *languages = _languages;
1607 status = PEP_OUT_OF_MEMORY;
1613 DYNAMIC_API PEP_STATUS get_phrase(
1614 PEP_SESSION session,
1620 PEP_STATUS status = PEP_STATUS_OK;
1622 assert(session && lang && lang[0] && lang[1] && lang[2] == 0 && phrase);
1623 if (!(session && lang && lang[0] && lang[1] && lang[2] == 0 && phrase))
1624 return PEP_ILLEGAL_VALUE;
1628 sqlite3_reset(session->i18n_token);
1629 sqlite3_bind_text(session->i18n_token, 1, lang, -1, SQLITE_STATIC);
1630 sqlite3_bind_int(session->i18n_token, 2, phrase_id);
1632 const char *_phrase = NULL;
1635 result = sqlite3_step(session->i18n_token);
1638 _phrase = (const char *) sqlite3_column_text(session->i18n_token, 0);
1642 status = PEP_PHRASE_NOT_FOUND;
1646 status = PEP_UNKNOWN_ERROR;
1649 if (status == PEP_STATUS_OK) {
1650 *phrase = strdup(_phrase);
1651 if (*phrase == NULL)
1655 sqlite3_reset(session->i18n_token);
1659 status = PEP_OUT_OF_MEMORY;
1665 DYNAMIC_API PEP_STATUS sequence_value(
1666 PEP_SESSION session,
1671 PEP_STATUS status = PEP_STATUS_OK;
1678 if (!(session && name && value))
1679 return PEP_ILLEGAL_VALUE;
1683 sqlite3_reset(session->sequence_value1);
1684 sqlite3_bind_text(session->sequence_value1, 1, name, -1, SQLITE_STATIC);
1685 result = sqlite3_step(session->sequence_value1);
1686 assert(result == SQLITE_DONE);
1687 sqlite3_reset(session->sequence_value1);
1688 if (result != SQLITE_DONE) {
1689 status = PEP_UNKNOWN_ERROR;
1692 sqlite3_reset(session->sequence_value2);
1693 sqlite3_bind_text(session->sequence_value2, 1, name, -1,
1695 result = sqlite3_step(session->sequence_value2);
1698 int32_t _value = (int32_t)
1699 sqlite3_column_int64(session->sequence_value2, 0);
1704 status = PEP_UNKNOWN_ERROR;
1706 sqlite3_reset(session->sequence_value2);
1711 DYNAMIC_API PEP_STATUS set_revoked(
1712 PEP_SESSION session,
1713 const char *revoked_fpr,
1714 const char *replacement_fpr,
1715 const uint64_t revocation_date
1718 PEP_STATUS status = PEP_STATUS_OK;
1721 revoked_fpr && revoked_fpr[0] &&
1722 replacement_fpr && replacement_fpr[0]
1726 revoked_fpr && revoked_fpr[0] &&
1727 replacement_fpr && replacement_fpr[0]
1729 return PEP_ILLEGAL_VALUE;
1731 sqlite3_reset(session->set_revoked);
1732 sqlite3_bind_text(session->set_revoked, 1, revoked_fpr, -1, SQLITE_STATIC);
1733 sqlite3_bind_text(session->set_revoked, 2, replacement_fpr, -1,
1735 sqlite3_bind_int64(session->set_revoked, 3, revocation_date);
1739 result = sqlite3_step(session->set_revoked);
1742 status = PEP_STATUS_OK;
1746 status = PEP_UNKNOWN_ERROR;
1749 sqlite3_reset(session->set_revoked);
1753 DYNAMIC_API PEP_STATUS get_revoked(
1754 PEP_SESSION session,
1757 uint64_t *revocation_date
1760 PEP_STATUS status = PEP_STATUS_OK;
1771 return PEP_ILLEGAL_VALUE;
1773 *revoked_fpr = NULL;
1774 *revocation_date = 0;
1776 sqlite3_reset(session->get_revoked);
1777 sqlite3_bind_text(session->get_revoked, 1, fpr, -1, SQLITE_STATIC);
1781 result = sqlite3_step(session->get_revoked);
1784 *revoked_fpr = strdup((const char *)
1785 sqlite3_column_text(session->get_revoked, 0));
1787 *revocation_date = sqlite3_column_int64(session->get_revoked,
1790 status = PEP_OUT_OF_MEMORY;
1795 status = PEP_CANNOT_FIND_IDENTITY;
1798 sqlite3_reset(session->get_revoked);
1803 DYNAMIC_API PEP_STATUS reset_peptest_hack(PEP_SESSION session)
1808 return PEP_ILLEGAL_VALUE;
1810 int int_result = sqlite3_exec(
1812 "delete from identity where address like '%@peptest.ch' ;",
1817 assert(int_result == SQLITE_OK);
1819 return PEP_STATUS_OK;