Displaying 6 results from an estimated 6 matches for "mbox_name".
2012 Jun 10
1
director userdb problem
...sn't exist (using built-in default iterate_query: SELECT username, domain FROM users)
in my dovecot.conf I have:
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
passdb {
driver = static
args = proxy=y nopassword=y
}
and in /etc/dovecot/dovecot-sql.conf:
user_query = select MBOX_NAME AS user from M_MAILBOX WHERE (MBOX_NAME = '%u');
Do I have to use special table named users ? is it hard-coded?
2012 Jun 20
1
director map and mysql
...service doveadm {
inet_listener {
port = 24245
}
}
protocol doveadm {
auth_socket_path = director-userdb
}
doveadm_proxy_port = 24245
in /etc/dovecot/dovecot-sql.conf at director there's
password_query = SELECT \
NULL AS password,\
'Y' as nopassword, \
'Y' AS proxy, \
MBOX_NAME as user, \
host2 as host \
from M_MAILBOX \
where MBOX_NAME = '%u'
user_query = SELECT \
MBOX_NAME AS username, \
MAIL_DIRECTORY as home \
from M_MAILBOX \
where MBOX_NAME = '%u';
iterate_query = select MBOX_NAME AS username from M_MAILBOX;
backend's conf:
service doveadm {...
2007 May 29
0
Migration from tpop3d to dovecot - troubles galore!
...have tried so far:
Take a case of one username, eddie, who belongs to the domain,
demo.wananchi.com.
1. This query is what I am using for password_query. I do suspect it is
wrong, but well, this is what it yields from the current DB:
mysql> SELECT CONCAT(domain.path, '/', popbox.mbox_name), popbox.password_hash FROM popbox, domain WHERE popbox.local_part = 'eddie' AND popbox.
domain_name = 'demo.wananchi.com' AND popbox.domain_name = domain.domain_name;
+--------------------------------------------+---------------------------------------+
| CONCAT(domain.path, '/...
2007 May 30
1
Dovecot Authentication Problem (REVISED)
...password FROM popbox, domain \
WHERE popbox.local_part = 'eddie' AND popbox.domain_name = 'demo.wananchi.com' \
AND popbox.domain_name = domain.domain_name;
+----------+
| password |
+----------+
| boeing8 |
+----------+
user_query = SELECT CONCAT(domain.path, '/', popbox.mbox_name) as home, \
69 as uid, 6 as gid FROM popbox, domain WHERE popbox.local_part = 'eddie' \
AND popbox.domain_name = 'demo.wananchi.com' AND \
popbox.domain_name = domain.domain_name;
+--------------------------------------------+-----+-----+
| home...
2005 Jan 06
1
Dovecot Crashing after MySQL Auth
...n one row or
# column
# is returned, authentication will automatically fail.
#
password_query = SELECT substring(password_hash, 6) AS password FROM
popbox WHERE local_part = '%n' AND domain_name = '%d'
# user_query = SELECT CONCAT('maildir:',domain.path,'/',
# popbox.mbox_name) AS home, '508' AS uid, '508' AS gid FROM popbox,
# domain WHERE popbox.local_part = '%n' AND popbox.domain_name = '%d'
# AND popbox.domain_name = domain.domain_name
user_query = SELECT CONCAT(domain.path,'/', popbox.mbox_name) AS home,
'508' AS uid,...
2007 Jun 03
3
Dovecot Authentication Problem - Help pls!
...password FROM popbox, domain \
WHERE popbox.local_part = 'eddie' AND popbox.domain_name = 'demo.wananchi.com' \
AND popbox.domain_name = domain.domain_name;
+----------+
| password |
+----------+
| boeing8 |
+----------+
user_query = SELECT CONCAT(domain.path, '/', popbox.mbox_name) as home, \
69 as uid, 6 as gid FROM popbox, domain WHERE popbox.local_part = 'eddie' \
AND popbox.domain_name = 'demo.wananchi.com' AND \
popbox.domain_name = domain.domain_name;
+--------------------------------------------+-----+-----+
| home...