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@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:[email protected]] Im Auftrag von Steffen
> Kaiser
> Gesendet: Mittwoch, 8. Februar 2017 12:52
> An: Maurizio Caloro <[email protected]>
> Cc: [email protected]
> 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([email protected],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 =
>> '[email protected]' OR email =
>> '[email protected]') AND ((imap = 1 AND 'pop3' = 'imap') OR (pop3 = 1
>> AND 'pop3' = 'pop3') OR 'pop3' = 'smtp' OR 'pop3' = 'sieve')
>
> - --
> Steffen Kaiser
>
