How to add User in MSSQL DB - error unknown user

Maurizio Caloro mauric at gmx.ch
Wed Feb 8 11:22:49 UTC 2017


Hello

 

Please I need to add  "Maurizio" to this MSSQL DB, but I don't now how to
add this step 

in my opinion I'think that the user can't be found, so I will have the
"unknown user"

Can give here any little help to fix this?

 

Feb  8 12:09:56 caloro dovecot: auth: Debug: auth client connected
(pid=13300)

Feb  8 12:09:56 caloro dovecot: auth: Debug: client in:
AUTH#0111#011PLAIN#011service=pop3#011session=dfsfdsdsJITACX+KIh#011lip=37.1
20.190.188#011rip=151.248.162.33#011lport=110#011rport=54604#011resp=<hidden
>

Feb  8 12:09:56 caloro dovecot: auth-worker(13303): Debug: Loading modules
from directory: /usr/lib/dovecot/modules/auth

Feb  8 12:09:56 caloro dovecot: auth-worker(13303): Debug: Module loaded:
/usr/lib/dovecot/modules/auth/libdriver_mysql.so

Feb  8 12:09:56 caloro dovecot: auth-worker(13303): Debug:
sql(maurizio at caloro.ch,151.248.162.33): query: SELECT username AS user,
password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS
userdb_uid, gid AS userdb_gid,  CONCAT('maildir:', homedir, maildir) AS
userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM
mail_users WHERE (username = 'maurizio at caloro.ch' OR email =
'maurizio at caloro.ch') AND ((imap = 1 AND 'pop3' = 'imap') OR (pop3 = 1 AND
'pop3' = 'pop3') OR 'pop3' = 'smtp' OR 'pop3' = 'sieve')

 

Feb  8 12:09:56 caloro dovecot: auth-worker(13303):
sql(maurizio at caloro.ch,151.248.162.33): unknown user

 

Feb  8 12:09:58 caloro dovecot: auth: Debug: client passdb out:
FAIL#0111#011user=maurizio at caloro.ch

Feb  8 12:09:58 caloro dovecot: pop3-login: Disconnected (auth failed, 1
attempts in 2 secs): user=<maurizio at caloro.ch>, method=PLAIN,
rip=151.248.162.33, lip=37.120.190.188, session=<DPyY5wJITACX+KIh>

 

Regards and thank for any hint or help

mauri



More information about the dovecot mailing list