Dotaz: Problem s maildropem

[hates]

nevi nekdo jak spravne zkompilovat maildrop z podporou MySQL ??? pokud se podivam jestli ma podporu mysql tak ano

server1:~# maildrop -v
maildrop 1.6.3 Copyright 1998-2003 Double Precision, Inc.
Maildir quota 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.

pokud si chci overit jestli spravne funguje tak se stane tohle

server1:~# maildrop -d petr.haton@unicov-net.com
maildrop: signal 0x0B

Kompiloval jsem ho takhle

server1:~# ./configure --prefix=/usr --enable-maildropmysql \
--enable-maildirquota --with-devel \
--with-mysqlconfig=/etc/maildrop/maildropmysql.cf \
--enable-syslog=1 --enable-restrict-trusted=0 \
--enable-sendmail=/usr/sbin/sendmail \
--with-etcdir=/etc/maildrop --enable-maildrop-uid=virtual \
--enable-maildrop-gid=virtual

vi nekdo proc to vyhazuje tuhle chybu ??? Distro Debian Serge. Zkousel jsem i verzi 2.0.2 ale ta mi nechce sahat na mysql vubec

Odpovědi

[Zdeněk Burda]

Novější verze se nekompilují přímo proti mysql, ale využívají courier-authdaemona stejně jako courier-imap nebo pop server.

Ta verze 1.6.3 se ti do databáze připojí, provede dotaz a pak spadne? Co máš v databázi za data? Narazil jsem na problém, že když tam byla hodnota NULL, tak to padalo na kokos (třeba když jsem neměl nastavené quoty). Chtělo to vkládat do databáze prázdný řetězec ("").

[hates]

Zkousel jsem to i z verzi 2.0.2 ale ta mi vypise ze uzivatel neexistuje. v logach k mysql se vubec nic nezobrazi.

[hates]

nastavoval jsem to presne podle tveho HOWTO

[Zdeněk Burda]

Zkusme se věnovat jen verzi 1.6.3, kterou máš už zkompilovanou s podporou MySQL. Jaký data máš v databázi, kdy ti to padne, po dotazu?

[hates]

v databazi mam toto:

postfix_users

email: petr.haton@unicov-net.com
crypt: heslo v md5
name: Jmeno
uid: 5000
gid: 5000
homedir: /home/virtual
maildir: /unicov-net.com/petr.haton@unicov-net.com/Maildir
access: Y
Postfix: Y
bypass_virus_check: Y
bypass_spam_check: Y
bypass_header_check: Y

postfix_access
source: unicov-net.com
access: OK
type: recipient

postfix_transport:
domain: unicov-net.com
destination: maildrop:

V logach k mysql nic neni. jak zapnu podrobnejsi vypisi mysql

[hates]

zde je jeste vypis z logu mysql

060402 21:26:13	      1 Connect     postfix@localhost on 
		      1 Init DB     postfix
		      1 Query       SELECT email, uid, gid, homedir, maildir, quota FROM postfix_users WHERE email = "petr.haton@unicov-net.com" and postfix='y' 

podle toho vseho maildrop k databazi pristoupi ale potom nahle spadne

[Zdeněk Burda]

A co ta quota, ta v databázi není uložená? Maildrop se na ní evidentně ptá, ale tys jí sem nevypsal... Jesli quoty nepoužíváš, tak tam hoď aspoň prázdný řetězec (""). Četl jsi mou první odpověď?

[hates]

ta quota pomohla uz jsem se dostal dal ted pokud poslu mail na existujici ucet tak mi v logu postfix pise tohle

Apr  3 01:42:44 server1 postfix/qmgr[1071]: 922601B542: from=<petr.haton@unicov-net.com>, size=1348, nrcpt=1 (queue active)
Apr  3 01:42:44 server1 maildrop[19618]: Cannot have world/group permissions on the filter file - for your own good.
Apr  3 01:42:44 server1 postfix/pipe[19617]: 922601B542: to=<petr.haton@unicov-net.com>, relay=maildrop, delay=0, status=deferred (temporary failure. Command output: /usr/bin/maildrop: Cannot have world/group permissions on the filter file - for your own good. )

[hates]

v logu mysql je tohle:

mysqld, Version: 4.1.11-Debian_4sarge2-log. started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
060403  1:41:17       1 Connect     postfix@localhost on
                      1 Init DB     postfix
                      1 Query       SELECT email, uid, gid, homedir, maildir, quota FROM postfix_users WHERE email = "petr.haton@unicov-net.com" and postfix='y'
                      1 Quit
060403  1:42:09       2 Connect     postfix@localhost on postfix
                      2 Query       SELECT email, crypt, "", uid, gid, homedir, maildir, "", name, "" FROM postfix_users WHERE email = "petr.haton" AND (access='y')
060403  1:42:14       3 Connect     postfix@localhost on postfix
                      3 Query       SELECT email, crypt, "", uid, gid, homedir, maildir, "", name, "" FROM postfix_users WHERE email = "petr.haton" AND (access='y')
060403  1:42:20       4 Connect     postfix@localhost on postfix
                      4 Query       SELECT email, crypt, "", uid, gid, homedir, maildir, "", name, "" FROM postfix_users WHERE email = "petr.haton@unicov-net.com" AND (access='y')
060403  1:42:44       5 Connect     postfix@localhost on postfix
                      5 Query       select destination from postfix_transport where domain = '*'
                      5 Query       select destination from postfix_transport where domain = '*'
                      6 Connect     postfix@localhost on postfix
                      6 Query       select destination from postfix_virtual where email = 'unicov-net.com'
                      7 Connect     postfix@localhost on postfix
                      7 Query       select email from postfix_email where email = 'unicov-net.com'
                      8 Connect     postfix@localhost on postfix
                      8 Query       select destination from postfix_trash where email = 'unicov-net.com'
                      9 Connect     postfix@localhost on postfix
                      9 Query       select maildir from postfix_users where email = 'unicov-net.com' and postfix = 'y'
                      5 Query       select destination from postfix_transport where domain = 'petr.haton@unicov-net.com'
                      5 Query       select destination from postfix_transport where domain = 'unicov-net.com'
                     10 Connect     postfix@localhost on postfix
                     10 Query       select destination from postfix_relocated where email = 'petr.haton@unicov-net.com'
                     10 Query       select destination from postfix_relocated where email = 'petr.haton'
                     10 Query       select destination from postfix_relocated where email = '@unicov-net.com'
                     11 Connect     postfix@localhost on postfix
                     11 Query       select access from postfix_access where source = 'petr.haton@unicov-net.com' and type = 'recipient'
                     11 Query       select access from postfix_access where source = 'unicov-net.com' and type = 'recipient'
                     12 Connect     postfix@localhost on postfix
                     12 Query       select destination from postfix_virtual where email = 'petr.haton@unicov-net.com'
                     13 Connect     postfix@localhost on postfix
                     13 Query       select email from postfix_email where email = 'petr.haton@unicov-net.com'
                     14 Connect     postfix@localhost on postfix
                     14 Query       select destination from postfix_trash where email = 'petr.haton@unicov-net.com'
                     12 Query       select destination from postfix_virtual where email = 'petr.haton'
                     13 Query       select email from postfix_email where email = 'petr.haton'
                     14 Query       select destination from postfix_trash where email = 'petr.haton'
                     12 Query       select destination from postfix_virtual where email = '@unicov-net.com'
                     13 Query       select email from postfix_email where email = '@unicov-net.com'
                     14 Query       select destination from postfix_trash where email = '@unicov-net.com'
                     15 Connect     postfix@localhost on postfix
                     15 Query       select destination from postfix_alias where alias = 'petr.haton@unicov-net.com'
                     16 Connect     postfix@localhost on postfix
                     16 Query       select maildir from postfix_users where email = 'petr.haton@unicov-net.com' and postfix = 'y'
                     17 Connect     postfix@localhost on postfix
                     17 Query       select destination from postfix_virtual where email = 'petr.haton@unicov-net.com'
                     18 Connect     postfix@localhost on postfix
                     18 Query       select email from postfix_email where email = 'petr.haton@unicov-net.com'
                     19 Connect     postfix@localhost on postfix
                     19 Query       select destination from postfix_trash where email = 'petr.haton@unicov-net.com'
                     17 Query       select destination from postfix_virtual where email = 'petr.haton'
                     18 Query       select email from postfix_email where email = 'petr.haton'
                     19 Query       select destination from postfix_trash where email = 'petr.haton'
                     17 Query       select destination from postfix_virtual where email = '@unicov-net.com'
                     18 Query       select email from postfix_email where email = '@unicov-net.com'
                     19 Query       select destination from postfix_trash where email = '@unicov-net.com'
                      6 Query       select destination from postfix_virtual where email = 'unicov-net.com'
                      7 Query       select email from postfix_email where email = 'unicov-net.com'
                      8 Query       select destination from postfix_trash where email = 'unicov-net.com'
                      9 Query       select maildir from postfix_users where email = 'unicov-net.com' and postfix = 'y'
                      5 Query       select destination from postfix_transport where domain = 'petr.haton@unicov-net.com'
                      5 Query       select destination from postfix_transport where domain = 'unicov-net.com'
                     10 Query       select destination from postfix_relocated where email = 'petr.haton@unicov-net.com'
                     10 Query       select destination from postfix_relocated where email = 'petr.haton'
                     10 Query       select destination from postfix_relocated where email = '@unicov-net.com'
                     20 Connect     postfix@localhost on
                     20 Init DB     postfix
                     20 Query       SELECT email, uid, gid, homedir, maildir, quota FROM postfix_users WHERE email = "petr.haton@unicov-net.com" and postfix='y'
                     20 Quit
060403  1:42:48      21 Connect     postfix@localhost on postfix
                     21 Query       SELECT email, crypt, "", uid, gid, homedir, maildir, "", name, "" FROM postfix_users WHERE email = "petr.haton@unicov-net.com" AND (access='y')
060403  1:43:44      15 Quit
                     14 Quit
                     13 Quit
                     12 Quit
                     11 Quit
                     16 Quit
                     19 Quit
                     18 Quit
                     17 Quit
                     10 Quit
                      5 Quit
                      9 Quit
                      8 Quit
                      7 Quit
                      6 Quit

[Zdeněk Burda]

Cannot have world/group permissions on the filter file - for your own good.

Nastav si správně práva (asi 700 nebo 750, nevím co všechno ti do daného adresáře leze) na domácí adresář uživatele pod kterým ti to běží (virtual) a na soubory s filtrama (600).

[hates]

momentalne mi to dela problem s pouzitim prav pokud na cely adresar /home/virtual dam pravo 777 tak mi do logu pise

Apr  3 19:22:19 server1 maildrop[22123]: Invalid home directory permissions - world writable.
Apr  3 19:22:19 server1 postfix/pipe[22110]: 71B901B54B: to=<petr.haton@unicov-net.com>, relay=maildrop, delay=0, status=deferred (temporary failure. Command output: /usr/bin/maildrop: Invalid home directory permissions - world writable. ) 

coz mi pripada ze zase nemuze najit adresar kam to ulozit i kdyz stromova struktura by mela byt vytvorena spravne nebo jsou nejak divne prava, ale vzdyt jsou nastavena na 777 tak by to melo vzit.

[Zdeněk Burda]

Invalid home directory permissions - world writable.

Z důvodu bezpečnosti si spousta programů kontroluje jestli nejsou na adresář s konfigurací nebo domácí adresář uživatele pod kterým to běží příliš velká práva. Proto ti to s 777 nebude fungovat.

[hates]

zkousel jsem to i z pravy 770 a 775 ale bohuzel se mi to porad nejak nedari pokud je zmenim na vyse uvedena prava tak uz to zase pise

Cannot have world/group permissions on the filter file - for your own good

uz jsem z toho opravdu zoufaly snazim se to rozjed uz ponekolikaty a porad nastavaji nejake problemy

[Zdeněk Burda]

Zkus si přeložit tu hlášku a zařiď se podle ní. Jednou ti to píš, že máš špatně práva na home, tak to opravíš a objeví se hláška s tím, že máš špatně práva na soubor s filtrovacími pravidly. Co zkusit třeba nastavit práva ještě na ten soubor (případně všechny soubory s filtry)?

[hates]

vyreseno diky za nakopnuti. bylo to opravdu temi pravy. asi jsem premejslel nad kravinama kdyz jsem si s nimi hral