forum.lissyara.su

Код: Выделить всё

evil@demosoft:/var/log# cat /etc/pam.conf
smtp auth    sufficient /usr/local/lib/pam_mysql.so user=mailer_user passwd=mailer_passwd db=mail
 table=users usercolumn=login passwdcolumn=password crypt=1
smtp account sufficient /usr/local/lib/pam_mysql.so user=mailer_user passwd=mailer_passwd db=mail
  table=users usercolumn=login passwdcolumn=password crypt=1

Код: Выделить всё

Jul 13 23:01:28 demosoft saslauthd[19599]: pam_mysql - MySQL error(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM  WHERE  = 'evil'' at line 1)
Jul 13 23:01:28 demosoft saslauthd[19599]: pam_mysql - MySQL error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM  WHERE  = 'evil'' at line 1)
Jul 13 23:14:55 demosoft saslauthd[19990]: pam_mysql - MySQL error(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM  WHERE  = 'evil'' at line 1)
Jul 13 23:14:55 demosoft saslauthd[19990]: pam_mysql - MySQL error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM  WHERE  = 'evil'' at line 1)
Jul 13 23:20:07 demosoft saslauthd[20057]: pam_mysql - MySQL error(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM  WHERE  = 'evil'' at line 1)
Jul 13 23:20:07 demosoft saslauthd[20057]: pam_mysql - MySQL error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM  WHERE  = 'evil'' at line 1)

Код: Выделить всё

evil@demosoft:/var/log# cat /usr/local/lib/sasl2/smtpd.conf
pwcheck_method: saslauthd
auxprop_plugin: sql
log_level: 3
sql_engine: mysql
sql_hostname: demosoft.org.ua
sql_user: пользователь_дб
sql_passwd: пароль_к_дб
sql_database: mail
sql_select: select password from users where login = '%u@%r'