/dports/mail/dbmail/dbmail-3.2.5/src/ |
H A D | sievecmd.c | 44 static int do_list(uint64_t user_idnr); 55 uint64_t user_idnr = 0; in main() local 238 res = do_remove(user_idnr, script_name); in main() 240 res = do_edit(user_idnr, script_name); in main() 244 res = do_activate(user_idnr, script_name); in main() 246 res = do_deactivate(user_idnr, script_name); in main() 248 res = do_list(user_idnr); in main() 316 int do_edit(uint64_t user_idnr, char *name) in do_edit() argument 365 if (do_cat(user_idnr, name, ftmp)) { in do_edit() 400 if (do_insert(user_idnr, name, tmp)) { in do_edit() [all …]
|
H A D | authmodule.c | 139 char *auth_get_userid(uint64_t user_idnr) in auth_get_userid() argument 140 { return auth->get_userid(user_idnr); } in auth_get_userid() 141 int auth_check_userid(uint64_t user_idnr) in auth_check_userid() argument 142 { return auth->check_userid(user_idnr); } in auth_check_userid() 151 char *auth_getencryption(uint64_t user_idnr) in auth_getencryption() argument 152 { return auth->getencryption(user_idnr); } in auth_getencryption() 158 clientid, maxmail, user_idnr); } in auth_adduser() 163 int auth_change_password(uint64_t user_idnr, in auth_change_password() argument 176 GList * auth_get_user_aliases(uint64_t user_idnr) in auth_get_user_aliases() argument 177 { return auth->get_user_aliases(user_idnr); } in auth_get_user_aliases() [all …]
|
H A D | dm_sievescript.h | 52 int dm_sievescript_isactive(uint64_t user_idnr); 53 int dm_sievescript_isactive_byname(uint64_t user_idnr, const char *scriptname); 65 int dm_sievescript_get(uint64_t user_idnr, char **scriptname); 75 int dm_sievescript_list(uint64_t user_idnr, GList **scriptlist); 99 int dm_sievescript_add(uint64_t user_idnr, char *scriptname, char *script); 110 int dm_sievescript_deactivate(uint64_t user_idnr, char *scriptname); 121 int dm_sievescript_activate(uint64_t user_idnr, char *scriptname); 131 int dm_sievescript_delete(uint64_t user_idnr, char *scriptname); 141 int dm_sievescript_quota_check(uint64_t user_idnr, uint64_t scriptlen); 150 int dm_sievescript_quota_set(uint64_t user_idnr, uint64_t quotasize); [all …]
|
H A D | auth.h | 76 char *auth_get_userid(uint64_t user_idnr); 86 int auth_check_userid(uint64_t user_idnr); 116 int auth_getclientid(uint64_t user_idnr, uint64_t * client_idnr); 141 char *auth_getencryption(uint64_t user_idnr); 168 uint64_t clientid, uint64_t maxmail, uint64_t * user_idnr); 186 int auth_change_username(uint64_t user_idnr, const char *new_name); 196 int auth_change_password(uint64_t user_idnr, 206 int auth_change_clientid(uint64_t user_idnr, uint64_t new_cid); 215 int auth_change_mailboxsize(uint64_t user_idnr, uint64_t new_size); 262 GList * auth_get_user_aliases(uint64_t user_idnr); [all …]
|
H A D | authmodule.h | 17 int (* user_exists)(const char *username, uint64_t * user_idnr); 18 char * (* get_userid)(uint64_t user_idnr); 19 int (* check_userid)(uint64_t user_idnr); 22 int (* getclientid)(uint64_t user_idnr, uint64_t * client_idnr); 24 char * (* getencryption)(uint64_t user_idnr); 27 uint64_t clientid, uint64_t maxmail, uint64_t * user_idnr); 29 int (* change_username)(uint64_t user_idnr, const char *new_name); 30 int (* change_password)(uint64_t user_idnr, 32 int (* change_clientid)(uint64_t user_idnr, uint64_t new_cid); 40 GList * (* get_user_aliases)(uint64_t user_idnr); [all …]
|
H A D | dm_sievescript.c | 39 db_stmt_set_u64(s, 1, user_idnr); in dm_sievescript_getbyname() 68 db_stmt_set_u64(s, 1, user_idnr); in dm_sievescript_isactive_byname() 72 db_stmt_set_u64(s, 1, user_idnr); in dm_sievescript_isactive_byname() 148 db_stmt_set_u64(s,1, user_idnr); in dm_sievescript_rename() 158 db_stmt_set_u64(s, 1, user_idnr); in dm_sievescript_rename() 168 db_stmt_set_u64(s, 3, user_idnr); in dm_sievescript_rename() 195 db_stmt_set_u64(s, 1, user_idnr); in dm_sievescript_add() 213 db_stmt_set_u64(s, 1, user_idnr); in dm_sievescript_add() 239 db_stmt_set_u64(s, 1, user_idnr); in dm_sievescript_deactivate() 262 db_stmt_set_u64(s, 1, user_idnr); in dm_sievescript_activate() [all …]
|
H A D | dm_db.h | 259 int dm_quota_user_set(uint64_t user_idnr, uint64_t size); 261 int dm_quota_user_dec(uint64_t user_idnr, uint64_t size); 262 int dm_quota_user_inc(uint64_t user_idnr, uint64_t size); 283 int dm_quota_rebuild_user(uint64_t user_idnr); 339 int db_empty_mailbox(uint64_t user_idnr, int only_empty); 451 int db_findmailbox(const char *name, uint64_t user_idnr, 748 gboolean db_user_active(uint64_t user_idnr); 751 int db_user_get_security_action(uint64_t user_idnr); 756 int db_user_security_trigger(uint64_t user_idnr); 762 int db_user_find_create(uint64_t user_idnr); [all …]
|
H A D | dm_db.c | 1374 DBPFX,user_idnr); in db_get_notify_address() 1442 return user_idnr; in db_get_useridnr() 1504 DBPFX, user_idnr); in db_empty_mailbox() 2075 if (user_idnr == 0) user_idnr = db_get_useridnr(msg->realmessageid); in db_update_pop() 2100 if (user_idnr != 0) { in db_update_pop() 3906 assert(user_idnr); in db_user_security_trigger() 3949 assert(user_idnr); in db_user_exists() 3950 *user_idnr = 0; in db_user_exists() 4000 if (*user_idnr==0) { in db_user_create() 4034 if (*user_idnr == 0) *user_idnr = id; in db_user_create() [all …]
|
H A D | sortmodule.c | 103 SortResult_T *sort_process(uint64_t user_idnr, DbmailMessage *message, const char *mailbox) in sort_process() argument 111 return sort->process(user_idnr, message, mailbox); in sort_process() 114 SortResult_T *sort_validate(uint64_t user_idnr, char *scriptname) in sort_validate() argument 122 return sort->validate(user_idnr, scriptname); in sort_validate()
|
H A D | sortmodule.h | 15 SortResult_T *(* process)(uint64_t user_idnr, DbmailMessage *message, const char *mailbox); 16 SortResult_T *(* validate)(uint64_t user_idnr, char *scriptname);
|
H A D | sort.h | 30 SortResult_T *sort_process(uint64_t user_idnr, DbmailMessage *message, const char *mailbox); 31 SortResult_T *sort_validate(uint64_t user_idnr, char *scriptname);
|
H A D | export.c | 189 uint64_t user_idnr = 0, owner_idnr = 0, mailbox_idnr = 0; in do_export() local 195 if (! auth_user_exists(user, &user_idnr)) { in do_export() 215 db_findmailbox_by_regex(user_idnr, search_mailbox, &children, 0); in do_export() 237 db_getmailboxname(mailbox_idnr, user_idnr, mailbox); in do_export() 242 if (owner_idnr == user_idnr) { in do_export()
|
/dports/mail/dbmail/dbmail-3.2.5/src/modules/ |
H A D | authsql.c | 144 assert(user_idnr > 0); in auth_getencryption() 247 *user_idnr=0; in auth_adduser() 311 assert(user_idnr != NULL); in auth_validate() 312 *user_idnr = 0; in auth_validate() 349 *user_idnr = 0; in auth_validate() 361 uint64_t user_idnr = 0; in auth_md5_validate() local 390 user_idnr = 0; // failed in auth_md5_validate() 393 user_idnr = 0; in auth_md5_validate() 404 if (user_idnr == 0) in auth_md5_validate() 409 return user_idnr; in auth_md5_validate() [all …]
|
H A D | authldap.c | 549 if (! user_idnr) { in dm_ldap_mod_field() 656 *user_idnr = 0; in auth_user_exists() 735 if (!user_idnr) { in auth_getclientid() 741 user_idnr); in auth_getclientid() 762 if (!user_idnr) { in auth_getmaxmailsize() 768 user_idnr); in auth_getmaxmailsize() 1011 *user_idnr = 0; in auth_adduser() 1078 *user_idnr=0; in auth_adduser() 1169 if (!user_idnr) { in auth_change_username() 1257 *user_idnr = 0; in auth_validate() [all …]
|
H A D | sortsieve.c | 36 uint64_t user_idnr; member 123 int send_alert(uint64_t user_idnr, char *subject, char *body) in send_alert() argument 132 char *userchar = g_strdup_printf("%" PRIu64 "", user_idnr); in send_alert() 163 char *to = auth_get_userid(user_idnr); in send_alert() 172 if (sort_deliver_to_mailbox(new_message, user_idnr, in send_alert() 410 if (sort_deliver_to_mailbox(m->message, m->user_idnr, in sort_fileinto() 448 send_alert(m->user_idnr, "Sieve script parse error", alertbody); in sort_errparse() 850 SortResult_T *sort_validate(uint64_t user_idnr, char *scriptname) in sort_validate() argument 867 sort_context->user_idnr = user_idnr; in sort_validate() 925 sort_context->user_idnr = user_idnr; in sort_process() [all …]
|
/dports/mail/dbmail/dbmail-3.2.5/test/ |
H A D | check_dbmail_deliver.c | 45 uint64_t user_idnr; in init_testuser1() local 168 uint64_t user_idnr; in get_first_user_idnr() local 172 return user_idnr; in get_first_user_idnr() 364 uint64_t user_idnr; in START_TEST() local 425 uint64_t user_idnr; in START_TEST() local 446 uint64_t user_idnr; in START_TEST() local 467 uint64_t user_idnr; in START_TEST() local 513 user_idnr = 0; in START_TEST() 577 uint64_t user_idnr; in START_TEST() local 610 uint64_t user_idnr; in START_TEST() local [all …]
|
H A D | check_dbmail_auth.c | 85 uint64_t user_idnr; in START_TEST() local 89 result = auth_validate(ci, "testuser1", "test", &user_idnr); in START_TEST() 91 result = auth_validate(ci, "nosuchtestuser", "testnosuchlogin", &user_idnr); in START_TEST() 101 uint64_t user_idnr, user_idnr_check; 109 if (!auth_user_exists(userid, &user_idnr)) 110 auth_adduser(userid,"initialpassword","", 101, 1002400, &user_idnr); 125 result = auth_change_password(user_idnr, password, enctype); 139 uint64_t user_idnr, user_idnr_check; 147 if (!auth_user_exists(userid, &user_idnr)) 148 auth_adduser(userid,"initialpassword","", 101, 1002400, &user_idnr); [all …]
|
H A D | check_dbmail_user.c | 92 uint64_t user_idnr; in START_TEST() local 93 auth_user_exists("nosuchuser",&user_idnr); in START_TEST() 102 uint64_t user_idnr; in START_TEST() local 103 auth_user_exists("testadduser",&user_idnr); in START_TEST() 104 fail_unless(user_idnr > 0,"abort test_do_delete: can't find user_idnr"); in START_TEST() 105 result = do_delete(user_idnr, "testadduser"); in START_TEST()
|
/dports/mail/dbmail/dbmail-3.2.5/sql/mysql/ |
H A D | migrate_from_1.x_to_2.0_innodb.mysql | 44 DROP KEY user_idnr, 57 REFERENCES dbmail_users (user_idnr) 167 FOREIGN KEY (`user_idnr`) 176 FOREIGN KEY (`user_idnr`) 185 ADD PRIMARY KEY (user_idnr); 191 ADD PRIMARY KEY (user_idnr); 216 user_idnr bigint(21) not null default '0', 218 PRIMARY KEY(user_idnr) 225 WHERE u.user_idnr = b.owner_idnr 228 GROUP BY (u.user_idnr); [all …]
|
H A D | create_tables.mysql | 71 …CONSTRAINT `dbmail_acl_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `dbmail_users` (`user_idnr`) ON … 377 `user_idnr` bigint(20) UNSIGNED NOT NULL auto_increment, 387 PRIMARY KEY (`user_idnr`), 393 user_idnr bigint(20) UNSIGNED NOT NULL, 395 INDEX user_idnr_index (user_idnr), 396 FOREIGN KEY user_idnr_fk (user_idnr) 397 REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON UPDATE CASCADE 402 user_idnr bigint(20) UNSIGNED DEFAULT '0' NOT NULL, 406 INDEX user_idnr_index (user_idnr), 407 FOREIGN KEY user_idnr_fk (user_idnr) [all …]
|
/dports/mail/dbmail/dbmail-3.2.5/sql/sqlite/ |
H A D | create_tables.sqlite | 85 AND ((SELECT user_idnr FROM dbmail_users WHERE user_idnr = new.owner_idnr) IS NULL) 121 AND ((SELECT user_idnr FROM dbmail_users WHERE user_idnr = new.user_id) IS NULL) 130 AND ((SELECT user_idnr FROM dbmail_users WHERE user_idnr = new.user_id) IS NULL) 215 UPDATE dbmail_acl SET user_id = new.user_idnr WHERE user_id = OLD.user_idnr; 395 … AND ((SELECT user_idnr FROM dbmail_users WHERE user_idnr = new.user_idnr) IS NULL) 404 … AND ((SELECT user_idnr FROM dbmail_users WHERE user_idnr = new.user_idnr) IS NULL) 411 … UPDATE dbmail_auto_replies SET user_idnr = new.user_idnr WHERE user_idnr = OLD.user_idnr; 416 DELETE FROM dbmail_auto_replies WHERE user_idnr = OLD.user_idnr; 429 … AND ((SELECT user_idnr FROM dbmail_users WHERE user_idnr = new.user_idnr) IS NULL) 438 … AND ((SELECT user_idnr FROM dbmail_users WHERE user_idnr = new.user_idnr) IS NULL) [all …]
|
/dports/mail/dbmail/dbmail-3.2.5/contrib/autosubscribe/ |
H A D | autosubscribe.sql | 14 select u.user_idnr,b.mailbox_idnr from dbmail_mailboxes b 15 right outer join dbmail_users u on b.owner_idnr!=u.user_idnr 18 owner_idnr=(select user_idnr from dbmail_users where userid='__public__'); 67 anyoneid := user_idnr from dbmail_users where userid='anyone';
|
/dports/mail/dbmail/dbmail-3.2.5/sql/postgresql/ |
H A D | migrate_from_1.x_to_2.0.pgsql | 31 user_idnr INT8 DEFAULT '0' NOT NULL, 39 user_idnr INT8 DEFAULT '0' NOT NULL, 67 ALTER TABLE dbmail_users ALTER COLUMN user_idnr 92 user_id INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE ON UPDATE CASCADE, 201 ALTER TABLE dbmail_auto_notifications ADD PRIMARY KEY (user_idnr); 202 ALTER TABLE dbmail_auto_notifications ADD FOREIGN KEY (user_idnr) 203 REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON UPDATE CASCADE; 209 ALTER TABLE dbmail_auto_replies ADD PRIMARY KEY (user_idnr); 210 ALTER TABLE dbmail_auto_replies ADD FOREIGN KEY (user_idnr) 211 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE ON UPDATE CASCADE; [all …]
|
H A D | create_tables.pgsql | 57 user_idnr INT8 DEFAULT nextval('dbmail_user_idnr_seq'), 67 PRIMARY KEY (user_idnr) 84 owner_idnr INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE ON UPDATE CASCADE, 105 user_id INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE ON UPDATE CASCADE, 112 user_id INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE ON UPDATE CASCADE, 182 user_idnr INT8 REFERENCES dbmail_users(user_idnr) ON DELETE CASCADE ON UPDATE CASCADE, 184 PRIMARY KEY (user_idnr) 188 user_idnr INT8 REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON UPDATE CASCADE, 192 PRIMARY KEY (user_idnr) 280 REFERENCES dbmail_users(user_idnr) [all …]
|
/dports/mail/dbmail/dbmail-3.2.5/sql/oracle/ |
H A D | dbmail_schema.sql | 507 user_idnr number(20) NOT NULL, field 518 CREATE UNIQUE INDEX dbmail_users_idx ON dbmail_users (user_idnr) TABLESPACE DBMAIL_TS_IDX; 519 ALTER TABLE dbmail_users ADD CONSTRAINT dbmail_users_pk PRIMARY KEY (user_idnr) USING INDEX dbmail_… 523 new.user_idnr IS NULL OR new.user_idnr = 0 527 INTO :new.user_idnr 535 …CONSTRAINT dbmail_acl_fk1 FOREIGN KEY (user_id) REFERENCES dbmail_users(user_idnr) ON DELETE CASCA… 540 …RAINT dbmail_filters_fk1 FOREIGN KEY (user_id) REFERENCES dbmail_users (user_idnr) ON DELETE CASCA… 548 … dbmail_mailboxes_fk1 FOREIGN KEY (owner_idnr) REFERENCES dbmail_users (user_idnr) ON DELETE CASCA… 559 REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE; 562 REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE;
|