postfix+mysql+courier-imap+amavisd-new and maildrop it's doesn't work

Discussion in 'HOWTO-Related Questions' started by osanet, Jul 6, 2006.

  1. osanet

    osanet New Member

    Hi

    I used debian sarge and I have postfix+mysql+spamassassin,amavisd-new,clamav...

    I try running maildrop + mysql but it's not working
    How are compiled maildrop with mysql, from source?

    Anyone writes yours configurations about maildropmysql and mai.cf,master.cf?

    Regards,
    osanet
     
  2. falko

    falko Super Moderator ISPConfig Developer

    That's a good error message... ;)
    What exactly is not working? Any error messages in the logs?
     
  3. osanet

    osanet New Member

    Hi:) sorry I forgot past my error:)

    maildrop -v
    maildrop 1.5.3 Copyright 1998-2003 Double Precision, Inc.
    GDBM extensions enabled.
    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

    And yous see , maildrop have support for mysql, now I run a little test

    maildrop -V 10 -d [email protected] < test.txt
    maildrop: Invalid user specified.
    [email protected] in a mysql mail..
    Why maildrop don't see mysql e-mail user?

    Regards,
    osanet
     
  4. falko

    falko Super Moderator ISPConfig Developer

    What's in your maildrop configuration file?
     
  5. osanet

    osanet New Member

    Hi
    My config /etc/maildropmysql.conf

    hostname 127.0.0.1
    port 3306
    database db_name
    dbuser db_user
    dbpw db_password
    dbtable mailbox
    default_uidnumber 107
    default_gidnumber 1003
    uid_field username
    homedirectory_field concat('/var/vmail/',maildir)
    homedirectory_base /var/vmail/
    maildir_field maildir
    quota_field concat(quota,'S')
    mailstatus_field active
    gid_field 1003
     
  6. falko

    falko Super Moderator ISPConfig Developer

    Is this information correct?
    Can you connect to MySQL with
    Code:
    mysql -u db_user -p
    ?
     
  7. osanet

    osanet New Member

    no:) the really base name is a postfix_virt and username is a sarge
    and I can connect to Mysql with this username :) the base and passwd is the same which postfix configurations used and postfix working ok
    maildrop still not working
     
    Last edited: Jul 10, 2006
  8. falko

    falko Super Moderator ISPConfig Developer

    And you use this username and password in your maildrop configuration? Is the database name correct?
    What's the output of
    Code:
    netstat -tap
    ?
     
  9. osanet

    osanet New Member

    Look:)
    Postfix is working, users can get and send mails without any problmes.

    maildrop -V 9 -d [email protected]
    maildrop: Invalid user specified.

    osanet
     
  10. falko

    falko Super Moderator ISPConfig Developer

  11. osanet

    osanet New Member

    select * from mailbox where username='[email protected]'
    -> ;
    +------------------+------------------------------------+--------+-----------+-------------------+---------+-------------+---------------------+---------------------+--------+
    | username | password | name | transport | maildir | quota | domain | created | modified | active |
    +------------------+------------------------------------+--------+-----------+-------------------+---------+-------------+---------------------+---------------------+--------+
    | [email protected] | $1$37b37de6$NyV1Hy/Y2jEb3SOd./UMF0 | | virtual | [email protected]/ | 1024000 | make.one.pl | 2005-03-08 19:10:34 | 2006-06-05 11:00:57 | 1 |
    +------------------+------------------------------------+--------

    An you see , user exist:)
    I have OS - debian sarge, what distribution you used to write this howto
    http://howtoforge.net/postfix_mailfilter ?
     
  12. falko

    falko Super Moderator ISPConfig Developer

Share This Page