[vchkpw] Abnormal query to database
Why when I use the command 'vadddomain domainname', in the logs of postgresql I see always this message? ERROR: the relation "vpopmail" already exists STATEMENT: CREATE TABLE vpopmail ( pw_name varchar(32) NOT NULL, pw_domain varchar(96) NOT NULL, pw_passwd varchar(40), pw_uid int4, pw_gid int4, pw_gecos varchar(48), pw_dir varchar(160), pw_shell varchar(20), PRIMARY KEY (pw_name, pw_domain ) ) Marco ---fine del testo--- -- -- ATTENZIONE: Per rispondere al messaggio è necessario scrivere nel campo soggetto la parola SPAMDENY seguita dal testo del soggetto, es: SPAMDENY Testo da inserire nel campo soggetto In questo modo il filtro antispam farà pervenire correttamente l'email al destinatario ;-) --
Re: [vchkpw] Delivery Problem
On Fri, Sep 14, 2007 at 04:32:14PM -0400, Rick Macdougall wrote:
> Date: Fri, 14 Sep 2007 16:32:14 -0400
> From: Rick Macdougall <[EMAIL PROTECTED]>
> Subject: Re: [vchkpw] Delivery Problem
> To: vchkpw@inter7.com
>
> Marco wrote:
> >Hi
> >
> >Qmail does not write into directory of domains of vpopmail.
> >As I can say to qmail to write inside to virtual domains?
> >This is a part of log file (/var/log/qmail/smtpd/current):
> >@400046eacdee2f7ec67c tcpserver: status: 1/20
> >@400046eacdee2f7ed61c tcpserver: pid 4176 from 127.0.0.1
> >@400046eacdee33365bf4 tcpserver: ok 4176
> >mail2.server.com:127.0.0.1:25 localhost:127.0.0.1::46480
> >@400046eace3d04c16a34 tcpserver: end 4176 status 0
> >@400046eace3d04c175ec tcpserver: status: 0/20
> >@400046eaceaa37dda0cc tcpserver: status: 1/20
> >@400046eaceaa37e15604 tcpserver: pid 4184 from 127.0.0.1
> >@400046eaceaa3b0e3f7c tcpserver: ok 4184
> >mail2.server.com:127.0.0.1:25 localhost:127.0.0.1::47801
> >@400046eacec224833c94 tcpserver: end 4184 status 0
> >@400046eacec22483484c tcpserver: status: 0/20
> >@400046ead150248da88c tcpserver: status: 1/20
> >@400046ead150248dbc14 tcpserver: pid 4220 from 127.0.0.1
> >@400046ead15027a21094 tcpserver: ok 4220
> >mail2.server.com:127.0.0.1:25 localhost:127.0.0.1::42118
> >@400046ead1820ed83d54 tcpserver: end 4220 status 0
> >@400046ead1820ed84cf4 tcpserver: status: 0/20
> >
> >Thanks
>
> Delivery logs are in /var/log/qmail/current, not
> /var/log/qmail/smtpd/current.
>
> Look there instead to see what the problem might be.
>
> Regards,
>
> Rick
You have right. . .
I send message to account local:
telnet 127.0.0.1 25
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
Welcome to: 220 mail2.server.com ESMTP
MAIL FROM [EMAIL PROTECTED]
250 ok
RCPT TO [EMAIL PROTECTED]
250 ok
DATA
354 go ahead
prova tecnica
.
250 ok 1189836423 qp 3115
quit
221 mail2.server.com
Connection closed by foreign host.
The log to which you reported:
tail -f /var/log/qmail/current | /command/tai64nlocal
2007-09-15 07:49:43.818093500 delivery 2: success:
2007-09-15 07:49:43.818191500 status: local 0/10 remote 0/20
2007-09-15 07:49:43.818439500 end msg 96489
2007-09-15 07:51:18.085863500 new msg 96489
2007-09-15 07:51:18.085867500 info msg 96489: bytes 185 from <> qp 3090
uid 77922007-09-15 07:51:18.088756500 starting delivery 3: msg 96489 to
local @mail2.server.com
2007-09-15 07:51:18.088788500 status: local 1/10 remote 0/20
2007-09-15 07:51:18.089111500 delivery 3: success:
2007-09-15 07:51:18.089210500 status: local 0/10 remote 0/20
2007-09-15 07:51:18.089330500 end msg 96489
2007-09-15 07:56:14.137859500 new msg 96489
2007-09-15 07:56:14.137863500 info msg 96489: bytes 185 from <> qp 3102
uid 77922007-09-15 07:56:14.140824500 starting delivery 4: msg 96489 to
local @mail2.server.com
2007-09-15 07:56:14.140849500 status: local 1/10 remote 0/20
2007-09-15 07:56:14.141195500 delivery 4: success:
2007-09-15 07:56:14.141296500 status: local 0/10 remote 0/20
2007-09-15 07:56:14.141389500 end msg 96489
The directory of virtual domain mydomain are empty:
cat /var/vpopmail/domains/mydomain.com/email/Maildir/{cur,new,tmp}/*
cat: /var/vpopmail/domains/mydomain.com/email/Maildir/cur/*: No such
file or directory
cat: /var/vpopmail/domains/mydomain.com/email/Maildir/new/*: No such
file or directory
cat: /var/vpopmail/domains/mydomain.com/email/Maildir/tmp/*: No such
file or directory
This is the script of qmail-smtpd:
/var/qmail/supervise/qmail-smtpd/run
#!/bin/sh
QMAILDUID=`id -u root`
NOFILESGID=`id -g root`
MAXSMTPD=`cat /var/qmail/control/concurrencyincoming`
LOCAL=`head -1 /var/qmail/control/me`
LISTEN="127.0.0.1"
BANNER="Welcome to: "
if [ -z "$QMAILDUID" -o -z "$NOFILESGID" -o -z "$MAXSMTPD" -o -z
"$LOCAL" ];thenecho QMAILDUID, NOFILESGID, MAXSMTPD, or LOCAL is unset
in
echo /var/qmail/supervise/qmail-smtpd/run
exit 1
fi
if [ ! -f /var/qmail/control/rcpthosts ];
then
echo "No /var/qmail/control/rcpthosts!"
echo "Refusing to start SMTP listener because it'll create an open
relay"
exit 1
fi
exec /usr/local/bin/softlimit -m 700 /usr/local/bin/tcpserver \
-u "$QMAILDUID" -g "$NOFILESGID" -B "$BANNER" -v -R -l "$LOCAL" \
-x /etc/tcp.smtp.cdb -c "$MAXSMTPD" "$LISTEN" smtp \
/var/qmail/bin/qmail-smtpd /var/vpopmail/bin/vchkpw \
/usr/bin/true 2>&1;
If I use ESMTP the authentication it works regularly but the problem is
always the same one . . . . the mail does not come delivered.
Have you some suggestion?
Bye Rick
Re: [vchkpw] Delivery Problem
Marco wrote: Hi Qmail does not write into directory of domains of vpopmail. As I can say to qmail to write inside to virtual domains? This is a part of log file (/var/log/qmail/smtpd/current): @400046eacdee2f7ec67c tcpserver: status: 1/20 @400046eacdee2f7ed61c tcpserver: pid 4176 from 127.0.0.1 @400046eacdee33365bf4 tcpserver: ok 4176 mail2.flynter.net:127.0.0.1:25 localhost:127.0.0.1::46480 @400046eace3d04c16a34 tcpserver: end 4176 status 0 @400046eace3d04c175ec tcpserver: status: 0/20 @400046eaceaa37dda0cc tcpserver: status: 1/20 @400046eaceaa37e15604 tcpserver: pid 4184 from 127.0.0.1 @400046eaceaa3b0e3f7c tcpserver: ok 4184 mail2.flynter.net:127.0.0.1:25 localhost:127.0.0.1::47801 @400046eacec224833c94 tcpserver: end 4184 status 0 @400046eacec22483484c tcpserver: status: 0/20 @400046ead150248da88c tcpserver: status: 1/20 @400046ead150248dbc14 tcpserver: pid 4220 from 127.0.0.1 @400046ead15027a21094 tcpserver: ok 4220 mail2.flynter.net:127.0.0.1:25 localhost:127.0.0.1::42118 @400046ead1820ed83d54 tcpserver: end 4220 status 0 @400046ead1820ed84cf4 tcpserver: status: 0/20 Thanks Delivery logs are in /var/log/qmail/current, not /var/log/qmail/smtpd/current. Look there instead to see what the problem might be. Regards, Rick
[vchkpw] Delivery Problem
Hi Qmail does not write into directory of domains of vpopmail. As I can say to qmail to write inside to virtual domains? This is a part of log file (/var/log/qmail/smtpd/current): @400046eacdee2f7ec67c tcpserver: status: 1/20 @400046eacdee2f7ed61c tcpserver: pid 4176 from 127.0.0.1 @400046eacdee33365bf4 tcpserver: ok 4176 mail2.flynter.net:127.0.0.1:25 localhost:127.0.0.1::46480 @400046eace3d04c16a34 tcpserver: end 4176 status 0 @400046eace3d04c175ec tcpserver: status: 0/20 @400046eaceaa37dda0cc tcpserver: status: 1/20 @400046eaceaa37e15604 tcpserver: pid 4184 from 127.0.0.1 @400046eaceaa3b0e3f7c tcpserver: ok 4184 mail2.flynter.net:127.0.0.1:25 localhost:127.0.0.1::47801 @400046eacec224833c94 tcpserver: end 4184 status 0 @400046eacec22483484c tcpserver: status: 0/20 @400046ead150248da88c tcpserver: status: 1/20 @400046ead150248dbc14 tcpserver: pid 4220 from 127.0.0.1 @400046ead15027a21094 tcpserver: ok 4220 mail2.flynter.net:127.0.0.1:25 localhost:127.0.0.1::42118 @400046ead1820ed83d54 tcpserver: end 4220 status 0 @400046ead1820ed84cf4 tcpserver: status: 0/20 Thanks
