search for: mbox_nam

Displaying 6 results from an estimated 6 matches for "mbox_nam".

Did you mean: 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...