Re: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions?

[Jeff Hill]

Thank you, very much.

I thoroughly scanned the vpopmail list, but I didn't think about the 
qmailadmin list (next time I'll remember).

My original solution to the error message was simply to send a Welcome 
e-mail to the new user immediately after they signup.  However, perhaps it 
is best to create the directories first, so I've now scripted PHP to do it, 
with the right permissions. My only issue with having PHP create the 
directories was the additional execution time, but it's not that big of a 
deal, given the numbers.

Thanks again,

Jeff Hill

At 09:13 AM 13/06/2003 +1000, Michael Bowe wrote:
- Original Message -
From: "Jeff Hill" <[EMAIL PROTECTED]>
To: "vpopmail list" <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2003 11:12 AM
Subject: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions?
> I'm working on adding users directly to the mysql tables. It appears from
> the list archive that this is reasonable, but I'm not certain if there's
> any catch?
I do this pretty regularly with no ill effect

The only thing I have noticed is that the user's maildir wont get created
until their 1st message arrives
This can cause a problem if the user tries to login to qmailadmin before
receiving any mail, as qmailadmin spits an error because it tries to write a
lock file to the non-existent maildir
There was a discussion a while back on the qmailadmin list about the the
pros/cons of creating accounts directly in SQL... maybe have a look at this
thread :
http://www.mail-archive.com/[EMAIL PROTECTED]/msg03509.html
Michael.

Re: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions?

[Michael Bowe]

- Original Message -
From: "Jeff Hill" <[EMAIL PROTECTED]>
To: "vpopmail list" <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2003 11:12 AM
Subject: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions?


> I'm working on adding users directly to the mysql tables. It appears from
> the list archive that this is reasonable, but I'm not certain if there's
> any catch?


I do this pretty regularly with no ill effect

The only thing I have noticed is that the user's maildir wont get created
until their 1st message arrives

This can cause a problem if the user tries to login to qmailadmin before
receiving any mail, as qmailadmin spits an error because it tries to write a
lock file to the non-existent maildir

There was a discussion a while back on the qmailadmin list about the the
pros/cons of creating accounts directly in SQL... maybe have a look at this
thread :
http://www.mail-archive.com/[EMAIL PROTECTED]/msg03509.html

Michael.

[vchkpw] Adding Users Directly to the MySQL Table: Suggestions?

[Jeff Hill]

I'm working on adding users directly to the mysql tables. It appears from 
the list archive that this is reasonable, but I'm not certain if there's 
any catch?

I've played around with it a bit, and I can't see any particular problems 
with my few tests. Has anyone actually done this? Is it better to let 
vchkpw create the maildir, or should I create them?

I'm using PHP to insert the users into the tables, so I can have it create 
the maildirs with the correct permissions, but I'd rather skip it to reduce 
the execution time.

Thanks for any tips. I'm new to vpopmail and want to avoid as many 
potential problems as possible. (I have installed vqregister and the new 
qmailadmin, and while they'll be very helpful, they won't give me the 
control I need in linking with our members database when adding new pop 
accounts).

Jeff Hill

Re: [vchkpw] how can i do that

[Tom Collins]

On Thursday, June 12, 2003, at 08:00  AM, Ahmad Masood Shah wrote:
If someone are sending an email to user  that have 100% full quota. 
qmail
will reply message like shown below..

<[EMAIL PROTECTED]>:
address: /home/vpopmail/domains/fibre.net.pk/3/abdo/Maildir/
quota: 5242880S
Message rejected. Not enough storage space in user's mailbox to accept
message.
I want to hide address:/home and quota information from this 
autogenerated
message. Can someone let me know what file I will have to edit for 
this..
Here's a patch to vdelivermail that takes care of the problem -- be 
careful, the user_over_maildirquota line might wrap.  I think someone 
else mentioned it on the list (stating that it was probably debug code 
someone accidentally left in), but I don't know if anyone posted a 
patch (it's a simple one).  Ken, please add this to the next vpopmail 
release (when can we expect that new release?).

diff -u vpopmail-5.3.20/vdelivermail.c vpopmail-5.3.20-tc/vdelivermail.c
--- vpopmail-5.3.20/vdelivermail.c  2003-04-18 07:40:25.0 
-0700
+++ vpopmail-5.3.20-tc/vdelivermail.c   2003-06-12 10:37:18.0 
-0700
@@ -460,8 +460,6 @@
 /* If the user is over thier quota, return it back
  * to the sender.
  */
-   printf("address: %s\n", address);
-   printf("quota: %s\n", quota);
 if 
(user_over_maildirquota(address,format_maildirquota(quota))==1) {

 /* check for over quota message in domain */

--
Tom Collins
[EMAIL PROTECTED]

Re: [vchkpw] .qmail-defaut

[Peter Palmreuther]

Hi Eduardo,

On Thu, 12 Jun 2003 11:31:14 -0300 Eduardo Cardone wrote:

> Hello, I'm using a script that has to check each email from internet to my
> vpopmail/domains and from my vpopmail/domains to internet.
> 
> So I have in each vpopmail/domains/mydomain.com/.qmail-default a line like
> this:
[...]
> And the content of  /var/qmail/alias/.qmail-default is:
[...]
> When I receive a email from internet to my users, it works OK, but when the
> mail is from my users to Internet, the scripts is not executed.

Oh wonder ... have you ever thought about "who's evaluating those
dot-qmail files?"???
It's _qmail-local_. Now try to figure if there might be a reason why a
_REMOTE_ delivery does not trigger qmail-local (hint: there's a
qmail-remote!!!)

> Why?

Because you don't have understood the qmail system.
Read the documentation. Read it again. Read it a third time.
Have a look at "The big qmail picture" [1].
Understand when dot-qmail is used (hint: it's _delivery instructions_,
not "sending instructions"), and why it would be pure bloat to write
"remote sending instructions" in dot-qmail files (hint: smtproutes).

But you have read the Qmail-FAQ coming with qmail sources? Point 8.2?

Alternatively:
Get qmail-scanner and integrate your script as "spam checker" or write
an own script / executable that can be called via "QMAILQUEUE"
environment variable (hint: patch needed!) ...

[1] http://www.nrg4u.com/
-- 
Ciao,
 Pit

[vchkpw] how can i do that

[Ahmad Masood Shah]

If someone are sending an email to user  that have 100% full quota. qmail
will reply message like shown below..

<[EMAIL PROTECTED]>:
address: /home/vpopmail/domains/fibre.net.pk/3/abdo/Maildir/
quota: 5242880S
Message rejected. Not enough storage space in user's mailbox to accept
message.

I want to hide address:/home and quota information from this autogenerated
message. Can someone let me know what file I will have to edit for this..

-- 

Best Regs,
Masood Ahmad Shah

[vchkpw] vpopmail exit codes

[Clayton Weise]

I'm having a strange issue with vpopmail and maildrop.  I'm running a spam
scanner called spamprobe.  Attached is the maildrop filter itself, and my
qmail-default file looks like this (all one line):

| /var/qmail/bin/preline /usr/local/bin/maildrop
/var/vpopmail/etc/maildroprc-spamprobe

The problem I'm running into happens after a message has been marked as
spam.  Basically, the jist of the filter is that if the message is larger
than 262144 bytes it is scanned.  If a message is scanned and marked as
spam, it's delivered to a .SPAM folder inside their Maildir which is then
readable via IMAP.  But, the problem I'm encountering is when a message is
marked as spam and to an invalid recipient, it goes to deliver to the .SPAM
directory of a user that doesn't exist.  When maildrop has a problem
delivering it exits with a EX_TEMPFAIL, which puts the message back in queue
for delivery later.  The message just sits in queue until finally qmail
bounces back saying it's been in queue too long.

To try and combat this problem, I had maildrop run a test to make sure that
the ~vpopmail/domains/iswest.net/user/Maildir existed, and if it didn't to
pipe the message to vdelivermail and exit.  This is where the weirdness
comes in.  Sometimes, and I can't figure out how to reproduce it, vpopmail
exits back to maildrop with a 0 error code so maildrop considers the message
delivered and it bounces back to the sender with the "no mailbox here by
that name" error.  Other times though, I get this in my log files:


@40003ee220592b6202ac status: local 6/10 remote 1/120
@40003ee220592b6788bc delivery 1708886: deferral:
Sorry,_no_mailbox_here_by_that_name._vpopmail_(#5.1.1)/maildrop:_error_writi
ng_to_mailbox.//usr/local/bin/maildrop:_Unable_to_deliver_to_mailbox./
@40003ee220592c32432c status: local 5/10 remote 1/120
@40003ee220592c3275f4 delivery 170: deferral:
Sorry,_no_mailbox_here_by_that_name._vpopmail_(#5.1.1)/maildrop:_error_writi
ng_to_mailbox.//usr/local/bin/maildrop:_Unable_to_deliver_to_mailbox./
@40003ee220592c32bc44 status: local 4/10 remote 1/120
@40003ee220592c32df6c delivery 1708889: deferral:
Sorry,_no_mailbox_here_by_that_name._vpopmail_(#5.1.1)/maildrop:_error_writi
ng_to_mailbox.//usr/local/bin/maildrop:_Unable_to_deliver_to_mailbox./

I've had this same problem with vpopmail 5.3.8 and I just tried upgrading to
5.3.20 this morning but I still see the same things in the log files.  I am
not able to reproduce this myself, so I have no idea exactly why it happens,
but any input on this would be greatly appreciated.
##
mailfilter
##
import EXT
import HOST
import HOME
VHOME=`/var/vpopmail/bin/vuserinfo -d [EMAIL PROTECTED]
VPOP="| /var/vpopmail/bin/vdelivermail '' bounce-no-mailbox"

# messages larger than X bytes are not scanned
if ($SIZE < 262144)
{
# message is scored and automatically added to the filter
#SCORE=`/usr/local/bin/spamprobe -d /var/spool/spamprobe -s 500 receive`

# message is scored but not added to the filter
SCORE=`/usr/local/bin/spamprobe -d /var/spool/spamprobe -s 500 score`

# header added to the email based defining it's score
xfilter "/usr/local/bin/reformail -i 'X-SpamProbe: $SCORE'"
}

# if the score is marked as "SPAM" it is delivered to a .SPAM dir
if ((/^X-SpamProbe: SPAM/:h))
{

   # check to see if user even exists, if not, send to vpopmail to boucne it
   `test -d $VHOME/Maildir/`
   if( $RETURNCODE == 1)
   {
   to "$VPOP"
   }

   # make sure the Maildir/.SPAM dir exists, if not, create it
   USER="vpopmail"
   GROUP="vchkpw"
   `test -d $VHOME/Maildir/.SPAM`
   if( $RETURNCODE == 1 )
   {
   `/usr/local/bin/maildirmake $VHOME/Maildir/.SPAM ; /usr/sbin/chown -R $USER:$GROUP 
$VHOME/Maildir/.SPAM`
   }

   # deliver spam to Maildir/.SPAM dir
   to "$VHOME/Maildir/.SPAM/"

   # find old spams and delete them
   `find $VHOME/Maildir/.SPAM -type f -mtime +7 -delete`
}

# everything else delivered normally
to "$VPOP"

[vchkpw] .qmail-defaut

[Eduardo Cardone]

Hello, I'm using a script that has to check each email from internet to my
vpopmail/domains and from my vpopmail/domains to internet.

So I have in each vpopmail/domains/mydomain.com/.qmail-default a line like
this:

 | /usr/local/bin/my_script.sh
 | /home/vpopmail/bin/vdelivermail '' delete

And the content of  /var/qmail/alias/.qmail-default is:

 | /usr/local/bin/my_script.sh
 ./Maildir/

When I receive a email from internet to my users, it works OK, but when the
mail is from my users to Internet, the scripts is not executed.

Why?

Thanks.



<>
Eduardo G. Cardone <[EMAIL PROTECTED]>
HYNET Networking Solutions
http://www.hynet.com.ar/  
Av. Presidente Julio A. Roca 620 Piso 7º
C1067ABO - Buenos Aires - Argentina
Phone: 54-11-5128-1000
Fax: 54-11-5128-1001
<>

Re: [vchkpw] vpopmail autorespond and mailinglists

[Samuel Hug]

Hi again,

Justin Heesemann wrote:

On Tuesday 08 April 2003 13:37, Samuel Hug wrote:
 

Hi,

i would like to make use of the autorespond feature (vacation
notification) wich is provided by the Autoresponder package.
I've installed it an it works fine. The only problem is, that i don't
want to autorespond the mails from a mailinglist.
How can i suppress automac responds to mails from a mailinglist?

regards sam
   

use bruce's autoresponder : http://untroubled.org

it has checks for most mailinglist headers.

 

yes bruce's package works well, but now i got the problem that i can't 
use qmailadmin to administer the autoresponder functionality. is there 
an other possibility yet?

regards sam