8 messages in net.sourceforge.lists.courier-maildropRe: [maildropl] No luck with mysql + ...
FromSent OnAttachments
Sunil William SavkarSep 16, 2002 11:45 am 
Rolan YangSep 16, 2002 12:14 pm 
Sunil William SavkarSep 16, 2002 12:26 pm 
Sunil William SavkarSep 16, 2002 1:54 pm 
Sunil William SavkarSep 16, 2002 2:30 pm 
Rodolfo GonzalezSep 17, 2002 2:40 pm 
Sunil William SavkarSep 18, 2002 4:26 am 
Rodolfo GonzalezSep 18, 2002 9:55 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [maildropl] No luck with mysql + maildrop + postfix setup... recompiled but errorsActions...
From:Sunil William Savkar (sav@inthespace.com)
Date:Sep 16, 2002 12:26:41 pm
List:net.sourceforge.lists.courier-maildrop

I'm not sure. Maybe your maildrop didn't compile correctly? Maildrop should output to your syslog (/var/log/maillog?). I did several things to test. One was finding a previously sent email in one of my maildir's and cat'ing it directly to maildrop from the command line.

I am pretty sure things compiled fine. I checked a couple of times to make sure.

I am running 2.4.18 Kernel using the Mandrake distribution. I do not see a maillog, but I do have a mail/info log. When I look at that, there are no direct messages from maildrop.

cat "1031860874.95260_0.rolan,S=4027:2,S" | maildrop -d bl@yourdomain.com

FUnny! I immediately tried this and I get an error signal 0x06!!

also, turn logging on in your mysql

bin/safe_mysqld --user=mysql -log &

Again, I have turned on logging, but unless i am missing something I am not seeing any log errors.

and "tail -f" the logs in a separate window and watch what happens when you try to send mail.

Sunil William Savkar wrote:

Hi.

I recompiled maildrop with the following config:

%configure --with-devel --enable-maildropmysql --with-mysqlconfig=/etc/maildrop/maildropmysql.cf --enable-userdb --enable-maildirquota --enable-syslog=1 --enable-restrict-trusted=0 --enable-sendmail=/usr/sbin/sendmail --with-etcdir=/etc/maildrop

I then set up /etc/maildrop/maildropmysql.config as follows:

# hostname - host name of your ldap server hostname localhost #port 3306 socket /var/lib/mysql/mysql.sock database email dbuser postfix dbpw ****** dbtable users

#not used now #timeout 5

# default_uid - default uid (number only) to use incase uidnumber attribute not # found in users mysql entry default_uidnumber 450

# default_gid - default gid (number only) to use incase gidnumber attribute not # found in users ldap entry default_gidnumber 450

# UID_FIELD - MySQL attribute which contains the users name (w or w/o domain)

uid_field id

# UIDNUMBER_FIELD - MySQL attribute which contains the system uid to deliver # mail as uidnumber_field uid

# GIDNUMBER_FIELD - MySQL attribute which contains the system gid to deliver # mail as

gidnumber_field gid

# MAILDIR_FIELD - MySQL attribute which contains the path to the users # custom maildir

maildir_field maildir

# HOMEDIRECTORY_FIELD - MySQL attribute which contains the path to the users # home directory

homedirectory_field home

# QUOTA_FIELD - MySQL attribute which contains the users quota #quota_field quota

mailstatus_field imapok where_clause ""

===

I also changed my transport table ot use maildrop: and set up master.cf with the following entry

maildrop unix - n n - - pipe flags=R user=fax argv=/usr/bin/maildrop -V9 -d ${user}

But now when I try to send a message, the only response i get is:

Sep 16 14:39:15 sunserver postfix/nqmgr[8949]: 1F6AF3792F: from=<ssavkar@reboul. com>, size=1357, nrcpt=1 (queue active) Sep 16 14:39:15 sunserver postfix/nqmgr[8949]: 1BDC537930: from=<ssavkar@reboul. com>, size=1388, nrcpt=1 (queue active) Sep 16 14:39:15 sunserver postfix/nqmgr[8949]: 1C41037932: from=<ssavkar@reboul. com>, size=1360, nrcpt=1 (queue active) Sep 16 14:39:15 sunserver postfix/pipe[9145]: 1F6AF3792F: to=<sunil@siliconsculp tures.com>, relay=maildrop, delay=3594, status=deferred (temporary failure. Comm and output: maildrop: signal 0x0B )

I don't know what signal 0x0b is and on top of this, I don't seem to get any more log information that I could use. Is there a way to properly turn on logging so I can see what maildrop is doing? Additionally, should I be using some other user name other than fax? I didn't think it necessarily mattered.