Dotaz: maildrop a MySQL

[Tomas3]

Tak jsem konecne nainstaloval ke svemu postfixu a courieru take maildrop 1.7.0 v main.cf v postfixu jsem nastavil misto transportu virtual transport maildrop. V logu se mi zapise text, ktery uvadim na konci meho dotazu. Kdyz jsem dal maildrop -v zobrazi se:

GDBM extensions enabled.
Maildir quota extension enabled.
Virtual user database extension enabled.
This program is distributed under the terms of the GNU General Public
License. See COPYING for additional information.

takze by mysql melo byt v maildropu zapnute. Nevim v cem muze byt problem a proto se ptam, je mozne ze se to bude dat dohledat podle jinych logu, ale v soucasne dobe jsem uvizl na mrtvem bode. Diky za pripadny tip a rady.

Nov  2 12:27:05 www3 postfix/smtpd[16616]: connect from unknown[172.22.1.5]
Nov  2 12:27:05 www3 postfix/smtpd[16616]: EB41B1B1B01: client=unknown[172.22.1.5], sasl_method=PLAIN, sasl_username=info@domena1.cz
Nov  2 12:27:05 www3 postfix/cleanup[16623]: EB41B1B1B01: message-id=<4549D591.5020506@domena1.cz>
Nov  2 12:27:05 www3 postfix/qmgr[16611]: EB41B1B1B01: from=info@domena1.cz, size=564, nrcpt=1 (queue active)
Nov  2 12:27:05 www3 postfix/smtpd[16616]: disconnect from unknown[172.22.1.5]
Nov  2 12:27:05 www3 spamd[5822]: spamd: connection from www3.domena1.cz [127.0.0.1] at port 54967 
Nov  2 12:27:05 www3 spamd[5822]: spamd: setuid to nobody succeeded 
Nov  2 12:27:05 www3 spamd[5822]: spamd: creating default_prefs: //.spamassassin/user_prefs 
Nov  2 12:27:05 www3 spamd[5822]: spamd: failed to create readable default_prefs: //.spamassassin/user_prefs 
Nov  2 12:27:06 www3 spamd[5822]: spamd: processing message <4549D591.5020506@domena1.cz> for nobody:65534 
Nov  2 12:27:07 www3 spamd[5822]: spamd: clean message (-1.4/5.0) for nobody:65534 in 1.5 seconds, 549 bytes. 
Nov  2 12:27:07 www3 spamd[5822]: spamd: result: . -1 - ALL_TRUSTED,AWL,SUBJECT_NOVOWEL scantime=1.5,size=549,user=nobody,uid=65534,required_score=5.0,rhost=www3.domena1.cz,raddr=127.0.0.1,rport=54967,mid=<4549D591.5020506@domena1.cz>,autolearn=failed 
Nov  2 12:27:07 www3 spamd[5251]: prefork: child states: II 
Nov  2 12:27:07 www3 postfix/pickup[16610]: 987BC1B1B12: uid=65534 from=info@domena1.cz
Nov  2 12:27:07 www3 postfix/cleanup[16623]: 987BC1B1B12: message-id=<4549D591.5020506@domena1.cz>
Nov  2 12:27:07 www3 postfix/pipe[16625]: EB41B1B1B01: to=pokus@domena2.cz, relay=spamassassin, delay=1.7, delays=0.04/0.01/0/1.6, dsn=2.0.0, status=sent (delivered via spamassassin service)
Nov  2 12:27:07 www3 postfix/qmgr[16611]: EB41B1B1B01: removed
Nov  2 12:27:07 www3 postfix/qmgr[16611]: 987BC1B1B12: from=info@domena1.cz, size=882, nrcpt=1 (queue active)
Nov  2 12:27:07 www3 postfix/pipe[16630]: 987BC1B1B12: to=pokus@domena2.cz, relay=maildrop, delay=0.14, delays=0.08/0.01/0/0.05, dsn=5.1.1, status=bounced (user unknown. Command output: Invalid user specified. )
Nov  2 12:27:07 www3 postfix/cleanup[16623]: AEFE31B1B01: message-id=<20061102112707.AEFE31B1B01@www3.domena1.cz>
Nov  2 12:27:07 www3 postfix/qmgr[16611]: AEFE31B1B01: from=<>, size=2576, nrcpt=1 (queue active)
Nov  2 12:27:07 www3 postfix/bounce[16632]: 987BC1B1B12: sender non-delivery notification: AEFE31B1B01
Nov  2 12:27:07 www3 postfix/qmgr[16611]: 987BC1B1B12: removed
Nov  2 12:27:07 www3 postfix/pipe[16630]: AEFE31B1B01: to=info@domena1.cz, relay=maildrop, delay=0.03, delays=0.01/0/0/0.01, dsn=5.1.1, status=bounced (user unknown. Command output: Invalid user specified. )
Nov  2 12:27:07 www3 postfix/qmgr[16611]: AEFE31B1B01: removed

Odpovědi

[em]

maildrop musi hlasit toto:

maildrop 1.7.0 Copyright 1998-2003 Double Precision, Inc.
GDBM extensions enabled.
Maildir quota extension enabled.
Virtual user database extension enabled.
!!!!!!Virtual user database via MySQL extension enabled.
This program is distributed under the terms of the GNU General Public
License. See COPYING for additional information.

ja jsem na svem Debianu nemel MySQL v maildrop povolenou, musel jsem prelozit ze zdrojaku.

maildropmysql.config ma nasledujici strukturu:

hostname localhost
port 3306
database vmail
dbuser vmail
dbpw SUPER_TAJNY_HESLO
dbtable passwd
default_uidnumber 500
default_gidnumber 500
uid_field id
uidnumber_field uid
gidnumber_field gid
homedirectory_field concat(home,'/',maildir)
#homedirectory_base maildir
quota_field quota

[Tomas3]

Uz mi to hlasi, stacilo dat maildrop-mysql -V

kdyz zkusim dat maildrop-mysql -d info@domena1.cz tak mi napise invalid user :o(

do /var/log/mysqld se mi nic nevklada, mozna se nekde vypnuly logy pro mysql, ale hledam na netu jak to zapnout a nevim, je mozne, ze to zapnute je, ale proste to nic nehleda :o(

[Tomas3]

Ted mi to uz overuze zadam maildrop-mysql -d info@domena1.cz a zustane cerny radek, muzu ho ukoncit ctrl+c, kdyz zadam neexistujici mail tak mi to napise invalid user ... Takze to vypada, ze maildrop funguje, problem je ten, ze mam omezeno na 3 maily ve schrance a stejne mi to dalsi maily prijima ... Vypada to, ze se maildropu moc nechce :o(

[Tomas3]

Takze uz jsem to dal nejak dohromady, ze to overuje, ale v logu mailu mi to pise:

Nov 2 14:47:14 www3 postfix/local[19824]: 2341B1B1B39: to=postfix@www3.domena1.cz, orig_to=root, relay=local, delay=2233, delays=2233/0.05/0/0.07, dsn=4.3.0, status=deferred (temporary failure. Command output: /usr/bin/maildrop-mysql: Invalid home directory permissions - world writable. ) Nov 2 14:47:14 www3 postfix/local[19825]: C58E81B1B41: to=postfix@www3.domena1.cz, orig_to=root, relay=local, delay=1034, delays=1033/0.02/0/0.09, dsn=4.3.0, status=deferred (temporary failure. Command output: /usr/bin/maildrop-mysql: Invalid home directory permissions - world writable. )

[zabza]

http://www.abclinuxu.cz/forum/show/156274

[Tomas3]

Ted mi to uz nepise, ale nechapu tedy jak zjistim, zda-li mi maildrop opravdu funguje :o(

[svorc]

prosím o radu jak zkompilovat maildrop ze zdrojáku a aby fungovala podpora mysql?

[svorc]

Prosím o radu.Jak zkompilovat maildrop ze zdrojáku aby fungovala podpora mysql?

[em]

tusim, ze nejak takto:

--enable-syslog=1 --enable-maildropmysql --with-mysqlconfig=/etc/maildropmysql.config --without-db \\
--enable-maildrop-uid=5000 --enable-maildrop-gid=5000 --enable-trusted-users="root postfix vmail"