Displaying 2 results from an estimated 2 matches for "aliasid".
Did you mean:
aliased
2011 Oct 10
1
To query two SQL tables for user verification over LMTP, should I use (a) two separate lookups? or (b) just one lookup with a boolean query?
...<user>@<domain> exists. If yes, deliver through LMTP. If NO, reject
it.
Here are the table definitions so far,
CREATE TABLE user (
userid TINYINT,
user VARCHAR(64),
domain VARCHAR(128),
password VARCHAR(64),
PRIMARY KEY (userid),
UNIQUE (user,domain)
);
CREATE TABLE alias (
aliasid TINYINT,
alias VARCHAR(64),
user VARCHAR(64),
domain VARCHAR(128),
PRIMARY KEY (aliasid),
UNIQUE (domain,user,alias),
CONSTRAINT fk_alias1 FOREIGN KEY (user) REFERENCES user (user) ON
DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT fk_alias2 FOREIGN KEY (domain) REFERENCES user (domain) O...
2019 Oct 08
1
ITERINDEX not showing subfolders.
...n as user, crypt_sha1 as password, home as
userdb_home, uid AS userdb_uid, gid AS userdb_gid,
concat('maildir:',maildir,':INDEX=/data/indexes/',login,':ITERINDEX',':VOLATILEDIR=/data/indexes/',login)
as userdb_mail from mailbox left join aliases on aliases.systemid = aliasid
where login = '%u' and inactive = 0;
user_query = select home, maildir as mail, uid, gid from mailbox left join
aliases on aliases.systemid = aliasid where login = '%u' and inactive = 0;
iterate_query = select distinct login as user from mailbox;
-------------- next part -----------...