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