Can't login to mailbox using Postfix/Dovecot/MySQL: “Failed to initialize quota”
I'm trying to setup my own mail server and I am stuck on one Dovecot error, “Error: Failed to initialize quota.” Anyone have a solution?
Feb 16 01:10:25 outgoing dovecot: imap(ichanged@original.domain)<13083><PzPpt/eBKIofusGT>:
Error: Failed to initialize quota: Quota root User quota: dict quota init failed: dict_init(sqlquota) failed: Dictionary URI is missing ':': sqlquota
EDIT:
Here is dovecot sql settings
driver = mysql
connect = host=127.0.0.1 dbname=mail_server user=mail password=password
default_pass_scheme = BLF-CRYPT
iterate_query = SELECT username AS user FROM mailbox
user_query = SELECT CONCAT('/var/mail/vmail/',maildir) AS home, CONCAT('maildir:/var/mail/vmail/',maildir) AS mail, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=',quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = 1
password_query = SELECT username AS user,password FROM mailbox WHERE username = '%u' AND active='1'
mysql postfix dovecot
asked Feb 16 at 0:22
DelavorDelavor
62
add a comment |
I'm trying to setup my own mail server and I am stuck on one Dovecot error, “Error: Failed to initialize quota.” Anyone have a solution?
Feb 16 01:10:25 outgoing dovecot: imap(ichanged@original.domain)<13083><PzPpt/eBKIofusGT>:
Error: Failed to initialize quota: Quota root User quota: dict quota init failed: dict_init(sqlquota) failed: Dictionary URI is missing ':': sqlquota
EDIT:
Here is dovecot sql settings
driver = mysql
connect = host=127.0.0.1 dbname=mail_server user=mail password=password
default_pass_scheme = BLF-CRYPT
iterate_query = SELECT username AS user FROM mailbox
user_query = SELECT CONCAT('/var/mail/vmail/',maildir) AS home, CONCAT('maildir:/var/mail/vmail/',maildir) AS mail, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=',quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = 1
password_query = SELECT username AS user,password FROM mailbox WHERE username = '%u' AND active='1'
mysql postfix dovecot
asked Feb 16 at 0:22
DelavorDelavor
62
Have you done a Google search for “Error: Failed to initialize quota.”?
– JakeGould
Feb 16 at 0:29
1
@JakeGould, yep. Found something but it doesn't help, that's why i wrote here.
– Delavor
Feb 16 at 0:41
add a comment |
I'm trying to setup my own mail server and I am stuck on one Dovecot error, “Error: Failed to initialize quota.” Anyone have a solution?
Feb 16 01:10:25 outgoing dovecot: imap(ichanged@original.domain)<13083><PzPpt/eBKIofusGT>:
Error: Failed to initialize quota: Quota root User quota: dict quota init failed: dict_init(sqlquota) failed: Dictionary URI is missing ':': sqlquota
EDIT:
Here is dovecot sql settings
driver = mysql
connect = host=127.0.0.1 dbname=mail_server user=mail password=password
default_pass_scheme = BLF-CRYPT
iterate_query = SELECT username AS user FROM mailbox
user_query = SELECT CONCAT('/var/mail/vmail/',maildir) AS home, CONCAT('maildir:/var/mail/vmail/',maildir) AS mail, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=',quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = 1
password_query = SELECT username AS user,password FROM mailbox WHERE username = '%u' AND active='1'
mysql postfix dovecot
asked Feb 16 at 0:22
DelavorDelavor
62
I'm trying to setup my own mail server and I am stuck on one Dovecot error, “Error: Failed to initialize quota.” Anyone have a solution?
Feb 16 01:10:25 outgoing dovecot: imap(ichanged@original.domain)<13083><PzPpt/eBKIofusGT>:
Error: Failed to initialize quota: Quota root User quota: dict quota init failed: dict_init(sqlquota) failed: Dictionary URI is missing ':': sqlquota
EDIT:
Here is dovecot sql settings
driver = mysql
connect = host=127.0.0.1 dbname=mail_server user=mail password=password
default_pass_scheme = BLF-CRYPT
iterate_query = SELECT username AS user FROM mailbox
user_query = SELECT CONCAT('/var/mail/vmail/',maildir) AS home, CONCAT('maildir:/var/mail/vmail/',maildir) AS mail, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=',quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = 1
password_query = SELECT username AS user,password FROM mailbox WHERE username = '%u' AND active='1'
mysql postfix dovecot
mysql postfix dovecot
asked Feb 16 at 0:22
DelavorDelavor
62
asked Feb 16 at 0:22
DelavorDelavor
62
edited Feb 16 at 0:44
Delavor
asked Feb 16 at 0:22
DelavorDelavor
62
asked Feb 16 at 0:22
DelavorDelavor
62
asked Feb 16 at 0:22
DelavorDelavor
62
62
Have you done a Google search for “Error: Failed to initialize quota.”?
– JakeGould
Feb 16 at 0:29
1
@JakeGould, yep. Found something but it doesn't help, that's why i wrote here.
– Delavor
Feb 16 at 0:41
add a comment |
Have you done a Google search for “Error: Failed to initialize quota.”?
– JakeGould
Feb 16 at 0:29
1
@JakeGould, yep. Found something but it doesn't help, that's why i wrote here.
– Delavor
Feb 16 at 0:41
Have you done a Google search for “Error: Failed to initialize quota.”?
– JakeGould
Feb 16 at 0:29
Have you done a Google search for “Error: Failed to initialize quota.”?
– JakeGould
Feb 16 at 0:29
1
1
@JakeGould, yep. Found something but it doesn't help, that's why i wrote here.
– Delavor
Feb 16 at 0:41
@JakeGould, yep. Found something but it doesn't help, that's why i wrote here.
– Delavor
Feb 16 at 0:41
add a comment |
1 Answer
1
active
oldest
votes
You activate the quota, but probably forgot to configure.
If you want to configure, follow theses instructions, they are generally written to the /etc/dovecot/conf.d/90-quota.conf:
https://wiki2.dovecot.org/Quota/Dict
But if you want to disable, execute a grep -R 'quota' in your dovecot directory, and comment, or remove the occurrences, like:
mail_plugins = $mail_plugins quota # change this
mail_plugins = $mail_plugins # to this
answered Mar 5 at 16:15
Hector VidoHector Vido
314
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1406324%2fcant-login-to-mailbox-using-postfix-dovecot-mysql-failed-to-initialize-quota%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You activate the quota, but probably forgot to configure.
If you want to configure, follow theses instructions, they are generally written to the /etc/dovecot/conf.d/90-quota.conf:
https://wiki2.dovecot.org/Quota/Dict
But if you want to disable, execute a grep -R 'quota' in your dovecot directory, and comment, or remove the occurrences, like:
mail_plugins = $mail_plugins quota # change this
mail_plugins = $mail_plugins # to this
answered Mar 5 at 16:15
Hector VidoHector Vido
314
add a comment |
You activate the quota, but probably forgot to configure.
If you want to configure, follow theses instructions, they are generally written to the /etc/dovecot/conf.d/90-quota.conf:
https://wiki2.dovecot.org/Quota/Dict
But if you want to disable, execute a grep -R 'quota' in your dovecot directory, and comment, or remove the occurrences, like:
mail_plugins = $mail_plugins quota # change this
mail_plugins = $mail_plugins # to this
answered Mar 5 at 16:15
Hector VidoHector Vido
314
add a comment |
You activate the quota, but probably forgot to configure.
If you want to configure, follow theses instructions, they are generally written to the /etc/dovecot/conf.d/90-quota.conf:
https://wiki2.dovecot.org/Quota/Dict
But if you want to disable, execute a grep -R 'quota' in your dovecot directory, and comment, or remove the occurrences, like:
mail_plugins = $mail_plugins quota # change this
mail_plugins = $mail_plugins # to this
answered Mar 5 at 16:15
Hector VidoHector Vido
314
You activate the quota, but probably forgot to configure.
If you want to configure, follow theses instructions, they are generally written to the /etc/dovecot/conf.d/90-quota.conf:
https://wiki2.dovecot.org/Quota/Dict
But if you want to disable, execute a grep -R 'quota' in your dovecot directory, and comment, or remove the occurrences, like:
mail_plugins = $mail_plugins quota # change this
mail_plugins = $mail_plugins # to this
answered Mar 5 at 16:15
Hector VidoHector Vido
314
answered Mar 5 at 16:15
Hector VidoHector Vido
314
answered Mar 5 at 16:15
Hector VidoHector Vido
314
answered Mar 5 at 16:15
Hector VidoHector Vido
314
314
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1406324%2fcant-login-to-mailbox-using-postfix-dovecot-mysql-failed-to-initialize-quota%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Have you done a Google search for “Error: Failed to initialize quota.”?
– JakeGould
Feb 16 at 0:29
1
@JakeGould, yep. Found something but it doesn't help, that's why i wrote here.
– Delavor
Feb 16 at 0:41