-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Wed, 8 Feb 2017, Maurizio Caloro wrote:
Please I need to add "Maurizio" to this MSSQL DB, but I don't now how to add this step
add this step to which workflow, action, ... ?
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?
INSERT INTO mail_users (...) VALUES (*correct* data of maurizio);
Who has installed the Dovecot server and the user DB? This person should know how to fill the *correct* data into the SQL table.
Feb 8 12:09:56 caloro dovecot: auth-worker(13303): Debug: sql(maurizio@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@caloro.ch' OR email = 'maurizio@caloro.ch') AND ((imap = 1 AND 'pop3' = 'imap') OR (pop3 = 1 AND 'pop3' = 'pop3') OR 'pop3' = 'smtp' OR 'pop3' = 'sieve')
Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1
iQEVAwUBWJsGd3z1H7kL/d9rAQJA+Af9EQk22pq64AYSxwQhkjm0a5D3qA72oW+M +k+46ivZXYvZiqGPYzY7YpeUQAKSRw6ihkIeF+hrm8Li6bauZJ5mDt7+DBZNCXc4 5S0+qZpuVBFGrC/k/grajnkRiiB56ejMkGjNLiB6tukUVGoeT3U5Q7hzmW0q0hlf vECIswRv6Yct0ZfsmHpy1apeB3HwOb3z4C8a6oaZBMkgo3GhSeJZQVKfeJtjaG2O HIPMHjvFKJjw9P8DfRjP5rqqUxI2MZLYq5ShI/pgOIqNoTSTvRCALbcAdOj0DO8R 2xCH+0vB3vEMk4kz0bQxlW0EXdJYJkoqx2O19dNDHVdYkPBexes78w== =tFGQ -----END PGP SIGNATURE-----