search for: view_us

An HTML attachment was scrubbed... URL: <https://dovecot.org/pipermail/dovecot/attachments/20230318/8ce3c29a/attachment-0001.htm>

...#39;s all working except quota by user.. I have a database with all quotas in bytes, and that lines in /etc/dovecot/dovecot-sql.conf : driver = mysql connect = host=127.0.0.1 dbname=mailserver user=USER password=PASS default_pass_scheme = CRYPT password_query = SELECT email as user, password FROM view_users WHERE email='%u'; #Quota: user_query = SELECT home AS maildir, 5000 AS uid, 5000 AS gid, CONCAT('dirsize:storage=', ROUND( view_users.quota / 1024) ) AS quota FROM view_users WHERE email='%u'; and in /etc/dovecot/dovecot.conf : protocol imap { mail_plugins = quota imap...

...rying to work out why, since it already has its answer by Q54 and Q55, it is doing Q56 and Q57, which seem pointless... 54 Connect 54 Query SELECT destination FROM view_aliases WHERE email='laura at example.com' 55 Connect 55 Query SELECT email FROM view_users WHERE email='laura at example.com' 56 Connect 56 Query SELECT destination FROM view_aliases WHERE email='laura at example.com' 57 Connect 57 Query SELECT email FROM view_users WHERE email='laura at example.com' So, it to m...

...o May 20 12:14:57 auth-worker: Debug: pam(me at example.org,5.6.7.8): lookup service=dovecot May 20 12:14:57 auth-worker: Debug: pam(me at example.org,5.6.7.8): #1/1 style=1 msg=Password: May 20 12:15:00 auth-worker: Debug: sql(me at example.org,5.6.7.8): query: SELECT email as user, password FROM view_users WHERE email='me at example.org'; May 20 12:15:00 auth: Debug: client out: OK 1 user=me at example.org May 20 12:15:00 auth: Debug: master in: REQUEST 4018667521 25337 1 ccd274c0359454ad3beae53ccb1cc03b May 20 12:15:00 auth: Debug: passwd(me at example.org,5.6.7.8): lookup May 20 12:15:00...

Excuse me for being stupid and confused. I'm trying to convert my dovecot install from passwd-file to mysql. I have a single table called "users" that has 3 fields, user_name, domain_name and password. The data came from passwd/shadow files so it uses the same password encryption as the shadow files do. The directory where the email is stored is calculated elsewhere and not

Part of my application should show a list of all users on the system who agreed to have their details revealed. So, I have an action like this: def view_users @users = User.find(:all,:conditions=>"reveal = 1",:order=>"login DESC") end In the associated view, @users is an object of nilclass and the app. breaks as it tries to iterate over the @users array. However, if I include this at the top of view_users.rhtml <% @use...

...auth(default): client out: CONT^I1^IPDAxNDgyOTE1OTk5OTE0NTEuMTI2MTY4OTE5N0BzZC0xMjE5Mj4= Dec 24 22:13:17 domain dovecot: auth(default): client in: CONT<hidden> Dec 24 22:13:17 domain dovecot: auth-worker(default): sql(email at domain.com,1.2.3.4): query: SELECT email as user, password FROM view_users WHERE email='email at domain.com'; Dec 24 22:13:17 domain dovecot: auth-worker(default): password(email at domain.com,1.2.3.4): Requested HMAC-MD5 scheme, but we have only PLAIN-MD5 Dec 24 22:13:18 domain dovecot: auth(default): client out: FAIL^I1^Iuser=email at domain.com Dec 24 22:...

...l_location pointing to local users ~/Maildir while UserDatabase/Extrafields feature will overwrite the path for virtual users. dovecat-sql.conf: password_query = SELECT email as user, password, CONCAT('/home/ vmail/', path) as userdb_mail, 5000 as userdb_uid, 5000 as userdb_gid FROM view_users WHERE email='%u';

...Henry Yonathan wrote: > > > password_query = SELECT email AS user, password, CONCAT('/home/vmail/ > > %d/%n/', maildir) AS userdb_home, CONCAT('maildir:/home/vmail/%d/ > > %n/', maildir) AS userdb_mail, 5000 AS userdb_uid, 5000 AS > > userdb_gid FROM view_users WHERE email = '%u'; > > Here you're trying to use prefetch userdb by returning userdb_* > fields. But they're different than here: > > > user_query = SELECT '/home/vmail/%d/%n' AS home, '/home/vmail/%d/%n/ > > Maildir' AS mail, 5000 AS...

Good Afternoon I?m really new at this and i don?t know if i?m posting at the right place. My problem is that our Dovecot IMAP is stopping from time to time with no info in the log, i just realize about this when our support person call me saying that the whatsup monitor is showing the IMAP4 process down. I can figure about this too by trying to get in our webmail Horde and i cannot login.

Dear all, I've been experiencing this problem and still can't find a solution for this. I want to have a dynamic quota for each virtual user. I've followed instruction from : http://wiki.dovecot.org/HowTo/DovecotLDAPostfixAdminMySQL http://workaround.org/articles/ispmail-etch/ But still can't give what I want. But if I use userdb static, I works fluently. Below are my Dovecot

...mode: 384 user: vmail degus:/home/vmail# degus:/etc/dovecot# grep -v '^ *\(#.*\)\?$' dovecot-sql.conf driver = mysql connect = host=127.0.0.1 dbname=mailserver user=*****88 password=******** default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM view_users WHERE email='%u'; degus:/etc/dovecot# ------------------------------------------------------- Thank you for your help and time.

...ning.sh 95 quota_warning2: storage=80%% /usr/local/bin/quota-warning.sh 80 ns1# grep -v '^ *\(#.*\)\?$' dovecot-sql.conf driver = mysql connect = host=127.0.0.1 dbname=****** user=****** password=******** default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM view_users WHERE email='%u'; user_query = select 5000 as uid, 5000 as gid, '/home/vmail/%d/%n' as home, \ concat('*:bytes=', quota_bytes) as quota_rule \ from email_quota where email = '%u'

...o I copied the file ../dovecot-sql.conf.ext and rename it into auth-sql.conf.ext. conf.d/auth-sql.conf.ext: --------------------- driver = mysql connect = host=127.0.0.1 dbname=foobarserver user=foo password=bar default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM view_users WHERE email='%u'; When I try to load the config I get the following error : root at sd-30635:/etc/dovecot/conf.d# dovecot -n # 2.0.13 (ba03935cc599): /etc/dovecot/dovecot.conf doveconf: Fatal: Error in configuration file /etc/dovecot/conf.d/auth-sql.conf.ext line 29: Unknown setting...

...n/dovecot/auth-master mode: 384 user: vmail grep -v '^ *\(#.*\)\?$' /etc/dovecot/dovecot-sql.conf output: driver = mysql connect = host=127.0.0.1 dbname=mailserver user=mailuser password=XXXXXX default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM view_users WHERE email='%u'; dovecot --version: 1.0.rc15 --------------------------------------- 1. created a file dovecot-pop3 under /etc/xinetd.d with this content: service pop3 { disable = no socket_type = stream protocol = tcp wait = no server = /usr/li...

I have been using cyrus for the past 6 years, but it is a pain to config. So ... I just installed dovecot 1.0.15 on a new debian 4r7 box. In cyrus we were using usernames as "user.domain.tld". In dovecot I realize I can: auth_username_translation = .@ But this converts user.domain.tld to user at domain@tld which of course fails. Is there a regex or something I can apply to pull this

hi, I am running debian lenny standard install and dovecot also as a standard install. I have a problem with POP3 access. The error message is: May 19 09:16:10 greenchilly dovecot: chdir(/home/vmail/example.com/john) failed with uid 5000: Permission denied May 19 09:16:10 greenchilly dovecot: child 26253 (pop3) returned error 89 May 19 09:16:10 greenchilly dovecot: pop3-login: Login:

...:42 host-mail postfix/qmgr[21877]: 9D80C12AF610: removed And /var/log/dovecot/deliver.info: 2011-03-17 22:43:43 auth(default): Info: new auth connection: pid=22232 2011-03-17 22:43:59 auth-worker(default): Info: sql(dkoski@[domainhidden].com,127.0.0.1): query: SELECT email as user, password FROM view_users WHERE email='dkoski@[domainhidden].com'; 2011-03-17 22:43:59 auth(default): Info: client out: OK 1 user=dkoski@[domainhidden].com 2011-03-17 22:43:59 auth(default): Info: master in: REQUEST 73 22061 1 2011-03-17 22:43:59 auth(default): Info: master out: USER 73...

...t: expire: mysql:/etc/dovecot/dovecot-dict-expire.conf root at server:~# cat /etc/dovecot/dovecot-sql.conf driver = mysql connect = host=127.0.0.1 dbname=mailserver user=mailserver password=testpwd1 default_pass_scheme = CRAM-MD5 password_query = SELECT email AS user, password, quota_rule FROM view_users WHERE email='%u' root at server:~# cat /etc/dovecot/dovecot-dict-expire.conf connect = host=localhost dbname=mailserver user=mailserver_exp password=testpwd2 table = expire select_field = expire_stamp where_field = mailbox I tried using a "user_field = user" additionally a...

...iver = sql args = /etc/dovecot/dovecot-sql.conf } /etc/dovecot/dovecot-sql.conf: ------------------------------ driver = mysql connect = host=127.0.0.1 dbname=mailserver user=myuser password=mypassword default_pass_scheme = CRAM-MD5 password_query = SELECT email as user, password FROM view_users WHERE email='%u'; /etc/dovecot/conf.d/10-master.conf: ---------------------------------- service imap-login { inet_listener imap { } inet_listener imaps { } } service pop3-login { inet_listener pop3 { } inet_listener pop3s { } } service lmtp { unix_list...