Administrace komentářů

Dobry den, mam drobny problem s uvedenou kombinaci demonu a i kdyz jsem tady narazil na velke mnozstvi prispevku na toto tema, zadny neresi muj problem. Mam nakonfigurovan postfix proti MySQL s postfixadminem, Cyrus-auth, Cyrus-Imap, Cyrus-SASL,PAM_mySQL. Cilem je, abych pri odesilani posty byl pozadan o jmeno a heslo nejakeho existujiciho usera a v pripade shody byla moje posta odeslana. Struktura tabulky mailbox:

username    franta@domena.cz
password    cryptovane heslo
name
maildir     franta@domena.cz/
quota       20000
domain      domena.cz
created     nejake datum
modified    nejake datum
active      1

do /etc/pam.d/ pridan soubor smtp

auth       sufficient   /lib/security/pam_mysql.so config_file=/etc/pam-mysql.conf
account    sufficient   /lib/security/pam_mysql.so config_file=/etc/pam-mysql.conf

do /etc/pam-mysql.conf

users.host = 127.0.0.1;
users.database = postfix;
users.db_user = postfix;
users.db_passwd = postfix;
users.table = mailbox;
users.user_column = username;
users.password_column = password;
users.where_clause = active ='1' ;
users.password_crypt = 1;
users.use_323_password = false;
users.use_md5 = false;

verbose = 1;

v souboru /usr/lib/sasl2/smtpd.conf

pwcheck_method: saslauthd
mech_list: PLAIN LOGIN

a ted konecne k dotazu Postfix se zepta na jmeno/heslo, vyplnim mu ho a odeslu, nicmene dotaz do databaze dorazi ve forme "jmeno" a nikoliv "jmeno@domena.cz".

Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - SELECT password FROM mailbox WHERE username = 'franta' AND (active ='1' )
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - SELECT returned no result.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_check_passwd() returning 1.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_sql_log() called.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_sql_log() returning 0.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_converse() called.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_open_db() called.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_check_passwd() called.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_format_string() called
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_quick_escape() called.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - SELECT password FROM mailbox WHERE username = 'franta' AND (active ='1' )
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - SELECT returned no result.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_check_passwd() returning 1.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_sql_log() called.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_sql_log() returning 0.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_sm_authenticate() returning 10.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_release_ctx() called.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_destroy_ctx() called.
Sep 23 16:01:24 trinity saslauthd[7305]: pam_mysql - pam_mysql_close_db() called.

Nejaky napad? Dik