search for: userdb_

...ord_query = SELECT login as user, passwd as password FROM mail.dovecot_passwd_v WHERE login = '%n' # 2 user_query = SELECT home, 5020 as uid, 5020 as gid FROM mail.dovecot_passwd_v WHERE login = '%n' # 3 # password_query = SELECT login as user, passwd as password, home as userdb_home, 5020 as userdb_uid, 5020 as userdb_gid FROM mail.dovecot_passwd_v WHERE login = '%n' when #3, instead of #1 and #2 is used, it still calls a default user_query. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protect...

Hi, I thought I read that anything from dovecot.conf can be overridden in a userdb lookup. Or a passdb lookup with "userdb_" prefix. But I tried for fun change log_path but it never worked. Is that because logging is special, already started logging before it comes to the passdb/userdb lookups? So are there some dovecot.conf settings that cannot be overridden? Thanks!

Sorry for that! I was offline during writing my answer to your mail and so it left my outbox after the advice from Sami. The solution works well when using passwd userdbs only. I didn?t get it running in conjunction with ldap userdb. I tried to use an LDAP attribute and mapping it to userdb_acl_globals_only and another try with acl_globals_only. Both attributes were not considered by the lookup. Another try was to use a separate passwd-userdb for this attribute only. When placing the passwd-userdb before the ldap-userdb the ldap attributes are not considered. If the ldap-userdb is plac...

Can you provide your doveconf -n after adding the database *after* LDAP. You probably need to add 'noauthenticate' as one parameter after the userdb ones. Aki On 07.08.2018 11:05, Simeon Ott wrote: > May you please clarify that? Where should I omit the userdb_ prefix? Which of my attempts are you pointing at? > As stated, I omitted the userdb_ prefix when working with an LDAP attribute. > >> On 7 Aug 2018, at 10:03, Aki Tuomi <aki.tuomi at dovecot.fi> wrote: >> >> with ldap userdb, you need to omit the userdb_ prefix. >&g...

Hi, I know that there are some variables (as user or username) I could use inside dovecot. They are at https://wiki2.dovecot.org/Variables. My question is if I can create my own variables from attributes at my pass/user db and then use it inside dovecot configuration. -- Angel L. Mateo Mart?nez Secci?n de Telem?tica ?rea de Tecnolog?as de la Informaci?n y las Comunicaciones Aplicadas

Hello Everyone, First wanted to say thanks for any help in advance. I have a clustered mail system each running on centos 5.2. I have a test box that I am running the newest version on dovecot on and I am getting some random authnication failed errors. Here is the error below: Nov 04 17:31:22 auth(default): Error: worker-server(xxx at xxxx.com): Aborted: Lookup timed out Nov 04 17:31:23

El 27/09/18 a las 12:04, Aki Tuomi escribi?: > > You can. In passdb, return userdb_your_own_variable=value, in userdb you > can omit the userdb_ prefix, except if you are using passwd-file. > I'm trying this. In the ldap configuration, I have: pass_attrs = =userdb_user=%{ldap:mail},=userdb_quota_rule=%{ldap:quota:*:storage=10G},=userdb_uuid=%{ldap:entryUUID} user_att...

May you please clarify that? Where should I omit the userdb_ prefix? Which of my attempts are you pointing at? As stated, I omitted the userdb_ prefix when working with an LDAP attribute. > On 7 Aug 2018, at 10:03, Aki Tuomi <aki.tuomi at dovecot.fi> wrote: > > with ldap userdb, you need to omit the userdb_ prefix. > > Aki > >...

...heme=SHA512-CRYPT username_format=%Lu /etc/dovecot/virtual_passwd } -->>-- i.e. I use a passwd-like database. For the non-overlapping accounts in both servers I want to prevent replication, as it will otherwise fail with "Error: sync: Unknown user in remote". I have added "userdb_noreplicate" (also tried "userdb_noreplicate=y") for those users, but I still see the above error message in the logs. Like: reinob at bbmk.org:{SHA512-CRYPT}$6$e10...4c::::::userdb_noreplicate=y If I run "doveadm user -u reinob at bbmk.org" I get the following: userdb:...

...; Dovecots %w variable is only available within dovecot-auth, is there any >>>> way to access the password for a mail-filter? >>> >>> Something like this should work in recent versions: >>> >>> passdb { >>> .. >>> override_fields = userdb_pass=%w >>> } >>> >>> plugin { >>> mail_filter = mail-filter %{userdb:pass} >>> } >>> >> >> Thanks for that idea, unfortunately %{ seems to be misinterpreted and >> the mail-filter script recieves the rest of the string "u...

...Mar 26 15:16:03 imapserver dovecot: auth(default): master in: REQUEST 1 16001 1 Mar 26 15:16:03 imapserver dovecot: auth(default): passwd(testuser at mydomain.com,127.0.0.1): unknown user Mar 26 15:16:03 imapserver dovecot: auth(default): prefetch(testuser at mydomain.com,127.0.0.1): userdb_uid not returned Mar 26 15:16:03 imapserver dovecot: auth(default): prefetch(testuser at mydomain.com,127.0.0.1): userdb_gid not returned Mar 26 15:16:03 imapserver dovecot: auth(default): userdb(testuser at mydomain.com,127.0.0.1): user not found from userdb Mar 26 15:16:03 imapserver dovecot: auth...

> > I thought I read that anything from dovecot.conf can be overridden in a > > userdb lookup. Or a passdb lookup with "userdb_" prefix. > > > > But I tried for fun change log_path but it never worked. Is that because > > logging is special, already started logging before it comes to the > > passdb/userdb lookups? So are there some dovecot.conf settings > > that cannot be overridden? >...

Connections from anything other than LAN. On Thu, Oct 18, 2018 at 08:49, Aki Tuomi <aki.tuomi at open-xchange.com> wrote: > On 18.10.2018 9.48, Rupert Gallagher wrote: >> Hello! >> >> Is it possible to hide the public folder when the user is on its >> mobile phone? > How would you know this? > > Aki -------------- next part -------------- An HTML

hi, i'm trying to use passdb ldap and userdb prefetch, using the userdb_ prefixes in pass_attrs, and i get: passdb didn't return userdb entries looking at the code at auth/userdb-prefetch.c i see: if (auth_request->userdb_reply == NULL) { if (auth_request->auth->userdbs->next == NULL) { /* no other userdbs */...

If the auth backend (postgresql in my case) returns extra fields, and all of these extra_fields begin with 'userdb_', the auth_callback functions adds an unwanted extra tab at the end of the response: auth(default): client out: OK^I8^Iuser=foo at bar^I This extra tab at the end confuses exim's dovecot-auth handler (the exim-dovecot auth handler does not correctly count the number of returned fields the...

...led dovecot.conf: passdb { driver = sql args = /etc/dovecot/sql.conf } userdb { driver = sql args = /etc/dovecot/sql.conf } sql.conf: driver = mysql connect = host=much dbname=toarx user=exim password=xxxxxxxx default_pass_scheme = PLAIN password_query = select user as username, password, userdb_home, userdb_mail, userdb_quota_rule from vusers where email = '%u' user_query = select user as username, userdb_home, userdb_mail, userdb_quota_rule from vusers where email = '%u' iterate_query = select email as user from vusers Cheers Axel

...quota to user database , and i added the queries from http://wiki.dovecot.org/Quota/1.1 MySQL: user_query = select uid, gid, home, \ concat('*:bytes=', quota_bytes) as quota_rule \ from users where userid = '%u' # MySQL with userdb prefetch: Remember to prefix quota_rule with userdb_ # (just like all other userdb extra fields): password_query = select userid as user, password, \ uid as userdb_uid, gid as userdb_gid, \ concat('*:bytes=', quota_bytes) as userdb_quota_rule \ from users where userid = '%u' but it is not work what i have to change and in whic...

...s... auth(default): client in: AUTH 1 PLAIN service=imap secured lip=69.94.137.124 rip=71.155.185.14 auth(default): client out: CONT 1 auth(default): client in: CONT 1 AGRvZGExAGZpcmUyM2JyaWNr auth-worker(default): sql(doda1,71.155.185.14): query: SELECT password, home AS userdb_home,\ uid AS userdb_uid, gid AS userdb_gid FROM users WHERE user = 'doda1' auth(default): client out: OK 1 user=doda1 auth(default): master in: REQUEST 1 12491 1 auth(default): prefetch(doda1,71.155.185.14): passdb didn't return userdb entries auth-worker(default)...

Any way to minimize the number of sql statements that dovecot do? (and I tried adding userdb prefetch { } but number of sql calls are still the same) Am I doing something wrong or? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bj?rn T Johansen btj at havleik.no

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] Subject: Re: [Dovecot] Can not Create Maildir using userdb sql > On Jan 12, 2009, at 8:38 PM, Henry...