Portál AbcLinuxu, 4. května 2024 18:27
pwcheck_method: auxprop auxprop_plugin: sql mech_list: plain login sql_engine: mysql sql_hostnames: localhost sql_user: vmailuser sql_passwd: HESLO sql_database: mail sql_select: select clear from postfix_users where email='%u@%r' and smtpaccess='Y'Nešlo by to upravit z tohodle? třeba ..where name='%u'..??
CREATE TABLE postfix_alias ( id int(11) unsigned NOT NULL auto_increment, alias varchar(128) NOT NULL default '', destination varchar(128) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; CREATE TABLE postfix_relocated ( id int(11) unsigned NOT NULL auto_increment, email varchar(128) NOT NULL default '', destination varchar(128) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; CREATE TABLE postfix_transport ( id int(11) unsigned NOT NULL auto_increment, domain varchar(128) NOT NULL default '', destination varchar(128) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY domain (domain) ) TYPE=MyISAM; CREATE TABLE postfix_virtual_domains ( id int(11) unsigned NOT NULL auto_increment, domain varchar(128) NOT NULL default '', destination varchar(128) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY domain (domain) ) TYPE=MyISAM; CREATE TABLE postfix_users ( id int(11) unsigned NOT NULL auto_increment, email varchar(128) NOT NULL default '', clear varchar(128) NOT NULL default '', crypt varchar(128) NOT NULL default '', name tinytext NOT NULL, uid int(11) unsigned NOT NULL default '1001', gid int(11) unsigned NOT NULL default '1001', homedir tinytext NOT NULL, maildir tinytext NOT NULL, quota tinytext NOT NULL, access enum('Y','N') NOT NULL default 'Y', postfix enum('Y','N') NOT NULL default 'Y', disablepop3 char(1) NOT NULL default '0', disableimap char(1) NOT NULL default '0', disablewebmail char(1) NOT NULL default '0', sharedgroup varchar(128) NOT NULL default '0', smtpaccess enum('Y','N') NOT NULL default 'Y', PRIMARY KEY (id), UNIQUE KEY email (email) ) TYPE=MyISAM; CREATE TABLE postfix_virtual ( id int(11) unsigned NOT NULL auto_increment, email varchar(128) NOT NULL default '', destination varchar(128) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; CREATE TABLE postfix_access ( id int(10) unsigned NOT NULL auto_increment, source varchar(128) NOT NULL default '', access varchar(128) NOT NULL default '', type enum('recipient','sender','client') NOT NULL default 'recipient', PRIMARY KEY (id) ) TYPE=MyISAM ;
auth required pam_mysql.so user=vmailuser passwd=HESLO host=127.0.0.1 db=mail table=postfix_users usercolumn=name passwdcolumn=crypt crypt=1 md5=y account sufficient pam_mysql.so user=vmailuser passwd=HESLO host=127.0.0.1 db=mail table=postfix_users usercolumn=name passwdcolumn=crypt crypt=1a taky nic. V logu je:
Jul 2 10:02:17 mail authdaemond: authpam: trying this module Jul 2 10:02:17 mail authdaemond: authpam: sysusername=vasek, sysuserid=<null>, sysgroupid=1000, homedir=/home/vasek, address=vasek, fullname=vasek,,,, maildir=<null>, quota<null>, options=<null> Jul 2 10:02:17 mail authdaemond: pam_service=imap, pam_username=vasek Jul 2 10:02:17 mail authdaemond: pam_authenticate failed, result 7 Jul 2 10:02:17 mail authdaemond: authpam: REJECT - try next module Jul 2 10:02:17 mail authdaemond: FAIL, all modules rejectedHeslo mám v md5.
Jul 2 13:37:07 mail postfix/smtpd[6713]: warning: SASL authentication problem: unknown password verifier Jul 2 13:37:07 mail postfix/smtpd[6713]: warning: SASL authentication failure: Password verification failed Jul 2 13:37:07 mail postfix/smtpd[6713]: warning: *192.168.1.5]: SASL PLAIN authentication failed Jul 2 13:37:07 mail postfix/smtpd[6713]: warning: SASL authentication problem: unknown password verifier Jul 2 13:37:07 mail postfix/smtpd[6713]: warning: *[192.168.1.5]: SASL LOGIN authentication faileda po debugu saslauthd to vypadá, jako když se k tomu ani postfix nepřipojil :((((( Prosím help me. Životně důležité.
[where=postfix="Y"]
jsi zkoušel? Co znamená "nefunguje"?
Na temhle web jsi koukal?
http://pam-mysql.sourceforge.net/Documentation/package-readme.php?seemore=y
mail postfix/qmgr[7171]: 124CFC0271D1: from=<test@test.cz>, size=570, nrcpt=1 (queue active) mail postfix/pipe[7177]: 124CFC0271D1: to=<moje@domena.cz>, relay=maildrop, delay=3132, status=deferred (temporary failure. Command output: ERR: authdaemon: s_connect() failed: Permission denied /usr/local/bin/maildrop: Temporary authentication failure. )Tak jsem si řekl, že to bude tím, že jsem změnil přihlašování emailem za přihlašování jménem email jsem nahradil name v authdaemon konfiguraci. Tak jsem místo Ru v master.cf u maildropu napsal původní DRhu a to taky nevezme a dokonce nemám nic v logu. Je to ale divný, fungovat by to mělo. Vždyť jsem postupoval podle návodu.
Tiskni Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.