AW: How to add User in MSSQL DB - error unknown user

[Tom Hendrikx]

Hi,

Your postfix and dovecot configurations refer to a MySQL database that
contains email accounts. You didn't get all of that by doing 'apt-get
install postfix dovecot', the database setup is something you added
yourself (or someone else did that for you). Running 'adduser -m
maurizio' will create a system user on the server, but no email account
in the MySQL database setup.

Please refer to the installation manual you (or someone else on your
behalf) followed during 'Add config steps to dovecot.conf, main.cf,
master.cf' which should tell you how to manage your accounts.

Regards,
	Tom

On 08-02-17 13:14, Maurizio Caloro wrote:
> Linux caloro.ch 3.16.0-4-amd64 #1 SMP Debian 3.16.39-1 (2016-12-30) x86_64
> GNU/Linux
> 
> Apt-get install postfix dovecot
> Adduser -m maurizio
> Add config steps to dovecot.conf, main.cf, master.cf
>  
> Email from CLI running, but if connect from Outlook or Thunderbird I have
> this error, I think
> that maurizio this user aren’t opened correct on this sqldb?
> 
> root at caloro:/home/maurizio# postconf -n
> alias_maps = $alias_database
> append_dot_mydomain = no
> biff = no
> broken_sasl_auth_clients = yes
> command_directory = /usr/sbin
> config_directory = /etc/postfix
> daemon_directory = /usr/lib/postfix
> data_directory = /var/lib/postfix
> debugger_command = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin ddd
> $daemon_directory/$process_name $process_id & sleep 5
> dovecot_destination_recipient_limit = 1
> home_mailbox = Maildir/
> html_directory = no
> inet_interfaces = all
> inet_protocols = ipv4
> local_transport = local
> mailbox_size_limit = 0
> mailq_path = /usr/bin/mailq
> manpage_directory = /usr/share/man
> message_size_limit = 52428800
> mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
> mydomain = nmail.caloro.ch
> myhostname = nmail.caloro.ch
> mynetworks = 127.0.0.0/8 192.168.1.0/27
> myorigin = $mydomain
> newaliases_path = /usr/bin/newaliases
> queue_directory = /var/spool/postfix
> readme_directory = /usr/share/doc/postfix
> sample_directory = /usr/share/doc/postfix
> sendmail_path = /usr/sbin/sendmail
> setgid_group = postdrop
> smtp_tls_note_starttls_offer = yes
> smtp_tls_security_level = may
> smtpd_banner = $myhostname ESMTP $mail_name
> smtpd_client_restrictions = permit_mynetworks, permit_sasl_authenticated,
> reject_unknown_client_hostname
> smtpd_helo_required = yes
> smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated,
> reject_unauth_destination, reject_unauth_pipelining,
> reject_non_fqdn_recipient
> smtpd_relay_restrictions =
> smtpd_sasl_auth_enable = yes
> smtpd_sasl_local_domain = $myhostname
> smtpd_sasl_path = private/auth
> smtpd_sasl_type = dovecot
> smtpd_sender_login_maps =
> mysql:/etc/postfix/mysql-virtual_sender_permissions.cf
> smtpd_sender_restrictions = permit_mynetworks, reject_sender_login_mismatch,
> permit_sasl_authenticated, reject_unknown_helo_hostname,
> reject_unknown_recipient_domain, reject_unknown_sender_domain
> smtpd_tls_cert_file = /etc/ssl/server/servername.pem
> smtpd_tls_key_file = $smtpd_tls_cert_file
> smtpd_tls_loglevel = 1
> smtpd_tls_received_header = yes
> smtpd_tls_security_level = may
> unknown_local_recipient_reject_code = 550
> virtual_alias_maps = mysql:/etc/postfix/mysql-virtual_alias_maps.cf
> virtual_gid_maps = static:2000
> virtual_mailbox_base = /var/customers/mail/
> virtual_mailbox_domains =
> mysql:/etc/postfix/mysql-virtual_mailbox_domains.cf
> virtual_mailbox_limit = 0
> virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual_mailbox_maps.cf
> virtual_transport = dovecot
> virtual_uid_maps = static:2000
> 
> 
> -----Ursprüngliche Nachricht-----
> Von: dovecot [mailto:dovecot-bounces at dovecot.org] Im Auftrag von Steffen
> Kaiser
> Gesendet: Mittwoch, 8. Februar 2017 12:52
> An: Maurizio Caloro <mauric at gmx.ch>
> Cc: dovecot at dovecot.org
> Betreff: Re: How to add User in MSSQL DB - error unknown user
> 
> -----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 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')
> 
> - --
> Steffen Kaiser
>