1 Topic by chrispyfur

  • chrispyfur
  • Member
  • Offline
  • Registered: 2012-07-09
  • Posts: 39

Topic: roundcube managesieve error for just one user

==== Required information ====
- iRedMail version: v1.4.0 (MySQL)
- Linux/BSD distribution name and version: Debian 6.0
- Related log if you're reporting an issue:
====

Hi, "m having terrible trouble with one users filters screen in roundcube.

If I make a new user under this domain, their filters work perfectly, but this one user, despite being able to login via imap or smtp fine, cannot connect to managesieve it seems.

I finally found this error:
------------------------------------------------------------------------------------
root@mailhost:/var/log# tail -f dovecot.log
Sep 07 16:16:54 auth(default): Error: userdb(xxxx@xxxxxxx.net,127.0.0.1): user not found from userdb sql
Sep 07 16:16:54 managesieve-login: Info: Internal login failure (auth failed, 1 attempts): user=<xxxx@xxxxxxx.net>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
------------------------------------------------------------------------------------

So, user not found from userdb sql? which sql table in which database would that be? Ive looked at this users record in the vmail database and roundcube database, it all looks kosher to me....

Chris.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: roundcube managesieve error for just one user

Please turn on debug mode in Dovecot to see why it happened. Reference:
http://www.iredmail.org/wiki/index.php? … In.Dovecot

3 Reply by chrispyfur

  • chrispyfur
  • Member
  • Offline
  • Registered: 2012-07-09
  • Posts: 39

Re: roundcube managesieve error for just one user

Hi, I get the following, an ok login to imap using iredmail then an error:

Sep 10 10:01:23 auth(default): Info: new auth connection: pid=934
Sep 10 10:01:25 auth(default): Info: client in: AUTH    1    PLAIN    service=sieve    secured    lip=127.0.0.1    rip=127.0.0.1    lport=4190    rport=35721    resp=AGNocmlzQGNocmlzcHlmdXIubmV0AG0yM3JqajAtdA==
Sep 10 10:01:25 auth-worker(default): Info: sql(xxxx@xxxxx.xxx,127.0.0.1): query: SELECT password FROM mailbox WHERE username='xxxx@xxxxx.xxx' AND active='1'
Sep 10 10:01:25 auth(default): Info: client out: OK    1    user=xxxx@xxxxx.xxx
Sep 10 10:01:25 auth(default): Info: master in: REQUEST    9    885    1
Sep 10 10:01:25 auth-worker(default): Info: sql(xxxx@xxxxx.xxx,127.0.0.1): SELECT CONCAT(mailbox.storagebasedirectory, '/', mailbox.storagenode, '/', mailbox.maildir) AS home, CONCAT('*:bytes=', mailbox.quota*1048576) AS quota_rule FROM mailbox,domain WHERE mailbox.username='xxxx@xxxxx.xxx' AND mailbox.domain='xxxxx.xxx' AND mailbox.enablesievesecured=1 AND mailbox.domain=domain.domain AND domain.backupmx=0 AND domain.active=1 AND mailbox.active=1
Sep 10 10:01:25 auth-worker(default): Info: sql(xxxx@xxxxx.xxx,127.0.0.1): Unknown user
Sep 10 10:01:25 auth(default): Error: userdb(xxxx@xxxxx.xxx,127.0.0.1): user not found from userdb sql
Sep 10 10:01:25 auth(default): Info: master out: NOTFOUND    9
Sep 10 10:01:25 managesieve-login: Info: Internal login failure (auth failed, 1 attempts): user=<xxxx@xxxxx.xxx>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: roundcube managesieve error for just one user

Do you have column "mailbox.mailbox.enablesievesecured=1" for this user in database "vmail"?

5 Reply by chrispyfur

  • chrispyfur
  • Member
  • Offline
  • Registered: 2012-07-09
  • Posts: 39

Re: roundcube managesieve error for just one user

ZhangHuangbin wrote:

Do you have column "mailbox.mailbox.enablesievesecured=1" for this user in database "vmail"?

awesome spot, that's done it, I changed it to 1

Any ideas why it was set to 0?

Chris.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: roundcube managesieve error for just one user

chrispyfur wrote:

Any ideas why it was set to 0?

No idea at all.

As you can see with SQL command "show create table mailbox", default value of this column is set to 1 (enable).