Displaying 20 results from an estimated 32 matches for "substring_index".
2007 Aug 28
2
quota imap_quota
...= outlook-idle delay-newmail
}
plugin {
# 10 MB + 1000 messages quota limit
# quota = maildir:storage=10240:messages=1000
driver = mysql
connect = host=/var/lib/mysql/mysql.sock user=mail_admin
password=XXXXXXXX dbname=mail
user_query = SELECT CONCAT(('/home/vmail/'),
SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'),
CONCAT('5000'), CONCAT('5000'), CONCAT('maildir:storage=', quota) FROM
users AS quota WHERE email = '%u';
}
The querry output looks like this:
+------------------------------------...
2018 Sep 18
2
Problem getting quota-warning script to function.
...ted user=redacted
password=reallyredacted
# Default password scheme.
#
# List of supported schemes is in
# http://wiki2.dovecot.org/Authentication/PasswordSchemes
#
default_pass_scheme = CRYPT
password_query = select email as user, crypt_password as password,
CONCAT('/',volume,'/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1))
AS home, 5000 AS uid, 5000 AS gid, concat('*:storage=', volume_limit
,'G') AS quota_rule from easymail_users where email = '%u' and banned =
'0' and active = '1'
user_query = SELECT
CONC...
2009 Feb 02
1
Dovecot changes username
...rport=38118 resp=<hidden>
Feb 1 09:45:51 count-bubba dovecot: auth-worker(default):
sql(mail at fathomssen.de,85.177.168.174): query: SELECT id AS user, mbox_host AS
domain, passwd AS password FROM pop_access WHERE ( (id = 'mail' AND mbox_host
= 'fathomssen.de') OR (id = SUBSTRING_INDEX('mail', '@', 1) AND mbox_host =
SUBSTRING_INDEX('mail', '@', -1)) ) AND active = '1'
Feb 1 09:45:51 count-bubba dovecot: auth-worker(default):
auth(mail at fathomssen.de,85.177.168.174): username changed mail at fathomssen.de -
> mail
Feb 1 09:45:51 co...
2017 Mar 23
2
Ubuntu Dovecot 2.2.9 several Errors, Transaction log as well as BUG message
...ostmaster at example.net
quota_full_tempfail = yes
}
dovecot-mysql.conf
driver = mysql
connect = host=localhost dbname=mail user=user password=XXX
default_pass_scheme = CRYPT
password_query = SELECT password FROM users WHERE email = '%u'
user_query = SELECT
CONCAT('/var/vmail/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
AS home,
CONCAT('maildir:/var/vmail/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/Maildir/')
AS mail, 5000 AS uid, 5000 AS gid, concat('*:bytes=',...
2007 Nov 17
1
mailbox size limit
...ostfix
group: postfix
plugin:
quota: maildir:storage=102400
[root:pts/0][~]# cat /etc/dovecot-sql.conf
driver = mysql
connect = host=/var/lib/mysql/mysql.sock user=mail_admin
password=XXXXXXXX dbname=mail
default_pass_scheme = CRYPT
password_query = SELECT password FROM users WHERE
CONCAT(SUBSTRING_INDEX(email,'@',1)) = '%n' AND
CONCAT(SUBSTRING_INDEX(email,'@',-1)) = '%d';
[root:pts/0][~]# cat /etc/dovecot-userdb-sql.conf
driver = mysql
connect = host=/var/lib/mysql/mysql.sock user=mail_admin
password=XXXXXXXX dbname=mail
user_query = SELECT CONCAT(('/home/vma...
2006 Feb 28
1
Wrong id after join!
...join in my find the id attributes set in my Entity objects
are wrong! It is setting the Entity id to the value from Postcode id!
The Code
--------
entities = Entity.find(:all,
:conditions => [...omited...],
:joins => "as e inner join postcodes as pc on
substring_index(e.postcode,'' '', 1) = pc.outer_part " )
Produces the folowing SQL
-------------------------
SELECT * FROM entities as e inner join postcodes as pc on
substring_index(e.postcode,'' '', 1) = pc.outer_part WHERE (categories_id
= 4 and pc.metres_x >= 367400....
2015 Sep 13
3
no login with MySQL
...active = 1
> > user_query = SELECT maildir, uid, gid, concat('*:storage=', quota) AS
> > quota_rule, concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM
> > mailbox WHERE username = '%u'
>
> what about
> user_query = SELECT CONCAT(maildir, SUBSTRING_INDEX(username,'@',+1)) as
> mail, uid, gid, concat('*:storage=', quota) AS quota_rule,
> concat('Trash:storage=+', quota_trash) AS quota_rule2 FROM mailbox WHERE
> username = '%u'
With this query above I can login again with Roundcube and claws-mail but
with...
2018 Sep 19
0
Problem getting quota-warning script to function.
...gt; # Default password scheme.
> #
> # List of supported schemes is in
> # http://wiki2.dovecot.org/Authentication/PasswordSchemes
> #
> default_pass_scheme = CRYPT
>
> password_query = select email as user, crypt_password as password,
> CONCAT('/',volume,'/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1))
> AS home, 5000 AS uid, 5000 AS gid, concat('*:storage=', volume_limit
> ,'G') AS quota_rule from easymail_users where email = '%u' and banned =
> '0' and active = '1'
>
>...
2012 Apr 05
1
Username bug in '%%' variables selects
...omain.com): Error: Couldn't create namespace 'INBOX.shared.' for user victor at domain: userdb didn't return a home directory, but mail_location used it (%h): maildir:%h
That's I seen in logs:
auth-worker: Debug: sql(victor at domain): SELECT CONCAT('/var/spool/mail/', SUBSTRING_INDEX(email, '@', -1), '/', SUBSTRING_INDEX(email, '@', 1)) as home from `users` WHERE email='victor at domain'
What happened with my username? 'victor at domain' is not correct value.
My config:
namespace {
inbox = yes
location =
prefix = INBOX.
separ...
2014 Oct 01
1
Simply mysql quota check
...%% quota-warning 80 %u@%d
args = /etc/dovecot/dovecot-sql.conf.ext
}
#/etc/dovecot/dovecot-sql.conf.ext
password_query = \
SELECT username AS user, value AS password \
FROM mailboxes WHERE username = '%n@%d'
user_query = \
SELECT username, domain, \
CONCAT('*:storage=', SUBSTRING_INDEX(quota, 'm', 1)*1048576) AS userdb_quota_rule \
FROM mailboxes, domains WHERE mailboxes.username = '%n@%d' \
AND domains.domain = '%d'
My idea is when a message is delivered, the dovecot to check quota in the mysql according to the value received in the "user_query&...
2017 Mar 23
0
Ubuntu Dovecot 2.2.9 several Errors, Transaction log as well as BUG message
...> }
>
>
> dovecot-mysql.conf
>
> driver = mysql
> connect = host=localhost dbname=mail user=user password=XXX
> default_pass_scheme = CRYPT
> password_query = SELECT password FROM users WHERE email = '%u'
> user_query = SELECT
> CONCAT('/var/vmail/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
> AS home,
> CONCAT('maildir:/var/vmail/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/Maildir/')
> AS mail, 5000 AS uid, 5000 AS gid, concat('...
2014 Aug 14
1
Quota Help
...4:06:24: auth: Debug: client out:
OK#0111#011user=test.example.org
Aug 14 14:06:24: auth: Debug: master in:
REQUEST#0111720057857#0118090#0111#0114bf45b372441751900d7d967578b0e03
Aug 14 14:06:24: auth-worker(8095): Debug:
sql(test.example.org,55.55.55.55): SELECT
CONCAT('/var/vmail/',CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1))) AS home, 5000 AS uid, 5000 AS gid, CONCAT('maildir:storage=+',quota_kb) AS quota_rule FROM users WHERE email='test.example.org';
Aug 14 14:06:24: auth: Debug: master out:
USER#0111720057857#011test.example.org#...
2017 Jan 24
2
quota-status returns quota_status_success when email would put user over quota
...m a SAN
towards the kvm/ovirt cluster.
I test by using nc towards the quota-status instance:
root at mail:~# printf "recipient=kptest at asom-net.dk\nsize=1000000000\n\n"
| nc -q1 localhost 12340
action=DUNNO
User has 500MB quota:
mysql> SELECT
CONCAT('/data/vmail/',CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1)))
AS home, 110 AS uid, 110 AS gid, CONCAT('*:storage=',mailquota,'M') AS
quota_rule FROM virtual_users WHERE email='kptest at asom-net.dk';
+--------------------------------+-----+-----+----------------...
2012 Oct 10
1
I need a quota expert
...r = mysql
connect = host=127.0.0.1 dbname=mail user=****** password=******
default_pass_scheme = CRYPT
password_query = SELECT email as user, password, concat('*:storage=', quota_kb) AS quota_rule FROM users WHERE email='%u';
user_query = SELECT CONCAT('/home/vmail/',CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1))) AS home, 5000 AS uid, 5000 AS gid, concat('*:storage=', quota_kb) AS quota_rule FROM users WHERE email='%u'
map {
pattern = priv/quota/storage
table = user
username_field = user
value_field = quota_kb...
2018 Sep 19
3
Problem getting quota-warning script to function.
...Debug: Module
loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
Sep 17 23:19:16 ezm11-pco dovecot: auth-worker(8299): Debug:
sql(billing at edwardcsmith.ca,64.68.203.197,<x3/sZhl263lARMvF>): query:
select email as user, crypt_password as password,
CONCAT('/',volume,'/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1))
AS home, 5000 AS uid, 5000 AS gid, concat('*:storage=', volume_limit
,'G') AS quota_rule from easymail_users where email =
'billing at edwardcsmith.ca' and banned = '0' and active = '1'
S...
2015 Sep 13
2
no login with MySQL
Hello!
Christian Kivalo <ml+dovecot at valo.at> schrieb am 13.09.15 um 19:51:38 Uhr:
> > Sep 13 11:55:49 imap(a.meyer at nimmini.de): Error: user
> > a.meyer at nimmini.de: Initialization failed: Namespace '': Home
> > directory not set for user. Can't expand ~/ for mail root dir in: ~/
> > Sep 13 11:55:49 imap(a.meyer at nimmini.de): Error: Invalid user
2013 Mar 11
5
Integrating with Drupal SQL db
.../postfix# grep -v '^ *\(#.*\)\?$'
/etc/dovecot/dovecot-sql.conf
driver = mysql
connect = host=127.0.0.1 dbname=Drupal user=Dru_Adm password=localu
default_pass_scheme = CRYPT
password_query = SELECT name AS user, pass AS password FROM users WHERE
name='%n'
user_query = SELECT
CONCAT(SUBSTRING_INDEX(mail,'@',-1),'/',SUBSTRING_INDEX(mail,'@',1),'/') AS
mail FROM users WHERE name='%n'
root at SSiS:/etc/postfix# tail /var/log/mail.log
Mar 11 16:17:42 SSiS dovecot: auth(default): new auth connection: pid=8593
Mar 11 16:17:51 SSiS dovecot: auth(default): clie...
2017 Jan 31
0
quota-status returns quota_status_success when email would put user over quota
...I test by using nc towards the quota-status instance:
> root at mail:~# printf
> "recipient=kptest at asom-net.dk\nsize=1000000000\n\n" | nc -q1 localhost
> 12340
> action=DUNNO
>
> User has 500MB quota:
> mysql> SELECT
> CONCAT('/data/vmail/',CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1)))
> AS home, 110 AS uid, 110 AS gid, CONCAT('*:storage=',mailquota,'M') AS
> quota_rule FROM virtual_users WHERE email='kptest at asom-net.dk';
> +--------------------------------+-----+-----+-...
2017 Jan 31
3
quota-status returns quota_status_success when email would put user over quota
...r = mysql
>> connect = host=xyz dbname=xyz user=xyz password=xyz
>> default_pass_scheme = CRYPT
>> password_query = SELECT email as user, password FROM virtual_users
>> WHERE email='%u';
>> user_query = SELECT
>>
>CONCAT('/data/vmail/',CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1)))
>
>> AS home, 110 AS uid, 110 AS gid, CONCAT('*:storage=',mailquota,'M')
>AS
>> quota_rule FROM virtual_users WHERE email='%u';
>>
>> If I do a strace on the quota-status...
2006 Oct 20
1
md5 password storage
...port = 3306
db = mail
db_user = my_conn_user
db_passwd = my_conn_passwd
#
# Pehapes i need to change this, but I tryied changing it do md5 with no
success.
#
default_pass_scheme = PLAIN
#
# This I changed for own reasons, but works.
#
password_query = SELECT clear FROM postfix_users WHERE
user=substring_index('%u', "@", 1)
user_query = SELECT concat('/var/spool/mail/', maildir) AS mail, uid,
gid FROM postfix_users WHERE user=substring_index('%u', "@", 1)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://dovecot.org/...