similar to: Quota from passdb sql

Hello people! I'm new to the list and to dovecot too. In advance I'd like to thank everybody who could help me, and I'll be very glad if a could help somebody here. I'm working in a project to integrate dovecot and active directory authentication for 2 weeks without total success. I've tried so many waysto solve my problem, but no one gave me the right answer. I'll

> > I use postfx 2.3.5 + dovecot (pop3/imap/lda/auth daemon for postfix) rc15. > > root at post /etc/postfix# grep dovecot main.cf > smtpd_sasl_type = dovecot > virtual_transport = dovecot > dovecot_destination_recipient_limit = 1 > > root at post /etc/dovecot# grep password_query dovecot-sql.conf > password_query = SELECT mail as user, cryptp as password, >

Hello! I'm trying move to dovecot2 (centos 5.5, dovecot 2.0.8, dovecot compiled/packaged via edited dovecot2.spec from fedora git). Almost all fine, I can login via imap/pop3 and work with mail. I get segfault error with "doveadm quota get -u user" Here backtrace and other info: # gdb `which doveadm` core.5202 GNU gdb (GDB) Red Hat Enterprise Linux (7.0.1-23.el5_5.2) Copyright

Hello! I'd like to setup quota for for virtualusers, i'm using both maildir++ and mdbox as storage, and i'm using postgresql to keep users. I'm keeping all users data in one table: [...] login text NOT NULL, domain text, password text, quota_mb integer NOT NULL DEFAULT 0 [... other columns ...] i'd like to keep present quota in such two columns: quota_dict_bytes integer NOT

Thank you for your reply. So, you mean that both user_query and password_query should have the same amount of parameter and the mail parameter from user_query should have the exact parameter as userdb_mail from password_query? And also I've to turn on userdb prefetch {} Kind Regards, Henry From: Timo Sirainen [mailto:tss at iki.fi] To: Dovecot Mailing List [mailto:dovecot at dovecot.org]

Is there a way to return a per user dirsize quota from a passdb sql lookup? If so, what is the syntax? maybe "select quota as userdb_quota"? ..and in mysql table, quota column would be: "quota=dirsize:storage=10240" ? I'm using mbox, with /etc/passwd userdb, and mysql passdb. Thanks, Ken -- Ken Anderson Pacific.Net

Hi everybody, I have a server works good but the quota calculation includes trash, what i have to do in order to ignore trash in quota calculation? My server imap is dovecot 1.0, my smtp server is postfix 2.3.8-2 and my webmail is horde 3.1.3 and imp 4.1.3. my dovecot.conf : base_dir: /var/run/dovecot/ log_path: /var/log/mail.log log_timestamp: %Y-%m-%d %H:%M:%S protocols: pop3 imap

Hi everybody, I am trying to work with quota. I use postfix and dovecot with a sql backend. Below you'll find my configuration. Everything works except for the quota part. It doesn't seem to see the quota and doesn't respond to the sender that the client is over its quota. versions: postfix-2.5.20070531-mysql dovecot-1.0.2-mysql Thanks for the help in advance. My Settings: #

Hello All! I use postfx 2.3.5 + dovecot (pop3/imap/lda/auth daemon for postfix) rc15. root at post /etc/postfix# grep dovecot main.cf smtpd_sasl_type = dovecot virtual_transport = dovecot dovecot_destination_recipient_limit = 1 root at post /etc/dovecot# grep password_query dovecot-sql.conf password_query = SELECT mail as user, cryptp as password,

Hello everyone, I'm trying to make dovecot do user authentication against a SQL database. The passwords (managed by Django) are stored as salted SHA1 encoded in hex. I monkey patched Django's password method so that the password hash is made with <password><salt> (Django does <salt><password>, the patched method was verified to return same value as

Hello, I'm running dovecot 2.29 on a freebsd 10.3 system. I'm trying to cut down queries to my database and tried to do a userdb static and prefetch. I modified the password query to pull in userdb_quota and got an error that that was not valid. Is this behavior normal? Apr 13 17:22:15 hostname dovecot: master: Dovecot v2.2.29 (13ebc01) starting up for imap, sieve Apr 13 17:22:24

Hi, I am working through setting up a virtual hosting system using Dovecot, Postfix and Postgres on a CentOS 5 box running an install of the dovecot-1.0-1.2.rc15.el5 RPM. The question I have is, given this password_query SELECT clause, which all return valid values from the database: user password domain can I use a %d in the WHERE clause of my user_query? The reason I ask is that the

Situation: one front-facing server running Dovecot as IMAP/POP3/ ManageSieve proxy, a mixture of IMAP servers (Dovecot, Exchange, ...) in the back-end. Dovecot's passdb does lookups against MySQL which contains a simple user/host mapping, the actual authentication happens on the back-end IMAP servers. The configuration is more or less as described here:

Hi, Where can I get examples for the records for the "users" table? For SHA512-CRYPT, I tried: replace into users values ('a at a.com','a.com',ENCRYPT('b', CONCAT('$6$', SUBSTRING(SHA(RAND()), -16))),'',0,0,'true'); schema is: CREATE TABLE `users` ( `username` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL,

Hi I have been attempting to do a mapping on the last_logon plugin. I have been reading the documentation on mapping. is there any way to customise a little more and create a individual SQL query for each of the functions SELECT and UPDATE, my current SQL setup has the username and domain in separate tables and my user_query and password_query are concat which I do not believe can be defined

This just isn't working for me. I've tried everything. Trailing the logs with debug and vebose... we connect fine === Oct 15 22:51:35 rsrr1 dovecot: Killed with signal 15 Oct 15 22:51:37 rsrr1 dovecot: Dovecot v1.0.alpha3 starting up Oct 15 22:51:38 rsrr1 dovecot: auth(default): pgsql: Connected to vmail === and then we die: === Oct 15 23:02:07

Our current virtual mailbox configuration is not compatible with one of the assertions in the dovecot quota plugin's assertions in quota-dirsize.c. I believe the assertion is incorrect, but I would also be happy if I could get the same result with a better configuration setting. Here is a sample passdb entry which causes the quota assertion to fail: test at

Hi everyone, first post to the list, be gentle with me! Perhaps I'm missing something here, but it appears to me that many password database extra fields currently aren't much use inside SQL queries? All boolean fields like nologin/nodelay/nopassword are set if the column is present in the returned query, regardless of value (including NULL) For example, say you have a query like:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I've spent the past couple of hours trying to figure this out by checking the wiki and googling, but haven't come up with anything that works yet. I just installed dovecot 1.0.14 with the quota-rewrite (1.09) patch and i'm trying to get the quota overridden via a passwd-file type userdb. I had 1.0.13 without the new quota style patched

Hi, We're running dovecot 1.2.15 and use SQL authentication. We'd like to be able to support APOP, but can't see how this would fit in with SQL auth. Currently we have: password_query = SELECT email as user, password FROM virtual_users WHERE email='%u' or (email LIKE '%n@%%' AND unhashed='%w') It seems that in order to auth APOP logins, we'd need to