i-MSCP and auth.log

RamCZ · Mar 7th 2017

Hello

I browsed a log files and i've found...

Code: /var/log/auth.log

...
Mar 7 13:50:23 server postfix/smtpd[9340]: sql auxprop plugin using mysql engine
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin Parse the username files
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin try and connect to a host
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin trying to open db 'imscp' on host '127.0.0.1:3306'
Mar 7 13:50:24 server postfix/smtpd[9340]: begin transaction
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin create statement from userPassword files server.xxx.xxx
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin doing query SELECT mail_pass FROM mail_users WHERE mail_addr = 'files@server.xxx.xxx' AND status = 'ok';
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin: no result found
Mar 7 13:50:24 server postfix/smtpd[9340]: commit transaction
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin Parse the username files
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin try and connect to a host
Mar 7 13:50:24 server postfix/smtpd[9340]: sql plugin trying to open db 'imscp' on host '127.0.0.1:3306'
...
Mar 7 08:57:42 server postfix/smtpd[12845]: sql plugin create statement from userPassword sales1 server.xxx.xxx
Mar 7 08:57:42 server postfix/smtpd[12845]: sql plugin doing query SELECT mail_pass FROM mail_users WHERE mail_addr = 'sales1@server.xxx.xxx' AND status = 'ok';
...

Display More

'files' or 'sales1' are changing... (not extisting names)

Is this normal ?

(Ubuntu 16.04.2 and i-MSCP 1.3.16)

Thanks for any your feedback.

**Nuxwin** · Mar 7th 2017

Quote from RamCZ

Is this normal ?

Yes

RamCZ · Mar 8th 2017

I found this...

Code: /etc/postfix/sasl/smtpd.conf

sql_select: SELECT mail_pass FROM mail_users WHERE mail_addr = '%u@%r' AND status = 'ok'

Maybe it is a SMTP sender authentication (get password for sender).

Thank you.

Share