Re: [vchkpw] Change the default quota
Hi Luqman, > how do i change default quota in vpopmail ? Recompile. It's hard coded at compile time. Jonas
[vchkpw] tes just tes
tes
[vchkpw] Re: Change the default quota
Jonas Pasche writes: Hi Luqman, how do i change default quota in vpopmail ? Recompile. It's hard coded at compile time. but is it OK to do 'make install' ? i already have a virtual domain, and many account Luqman.H www.unhas.ac.id/~luqe
Re: [vchkpw] Re: Change the default quota
Hi Luqman, > but is it OK to do 'make install' ? > i already have a virtual domain, and many account Yes. It only installs the binaries and doesn't change your virtual host configuration. Jonas
Re: [vchkpw] Re: Change the default quota
Hi, On Thu, 2003-03-20 at 10:49, Jonas Pasche wrote: > > but is it OK to do 'make install' ? > > i already have a virtual domain, and many account > Yes. It only installs the binaries and doesn't change your virtual host > configuration. I have to wonder, will make install do a recursive chown and chgrp? If so, it would be a bad idea to use 'make install' if you use system quotas. -- Anders Brander - http://anders.brander.dk/
Re: [vchkpw] Re: Change the default quota
Hi Anders, > I have to wonder, will make install do a recursive chown and chgrp? Yes. > If > so, it would be a bad idea to use 'make install' if you use system > quotas. Only if you still keep your user-managed domains under ~vpopmail/domains. Yes, you're right; haven't thought about it because I let my users manage their domains themselves through ~/domains/, thus vpopmail isn't chown'ing their dirs. Jonas
Re: [vchkpw] Re: Change the default quota
Could probably edit the Makefile and comment the lines that set permissions on the domains directory. It reads: @echo "If the recursive chown is taking a long time" @echo "go ahead and break out of it by pressing control-C" @echo "this is the last stage of the install and can be skipped" chown -R vpopmail $(DESTDIR)/home/vpopmail/include chgrp -R vchkpw $(DESTDIR)/home/vpopmail/include chown -R vpopmail $(DESTDIR)/home/vpopmail/etc chgrp -R vchkpw $(DESTDIR)/home/vpopmail/etc chown -R vpopmail $(DESTDIR)/home/vpopmail/bin chgrp -R vchkpw $(DESTDIR)/home/vpopmail/bin chown -R vpopmail $(DESTDIR)/home/vpopmail/doc chgrp -R vchkpw $(DESTDIR)/home/vpopmail/doc chown -R vpopmail $(DESTDIR)/home/vpopmail/domains chgrp -R vchkpw $(DESTDIR)/home/vpopmail/domains - Original Message - From: "Jonas Pasche" <[EMAIL PROTECTED]> To: "Jonas Pasche" <[EMAIL PROTECTED]> Sent: Thursday, March 20, 2003 8:17 PM Subject: Re: [vchkpw] Re: Change the default quota > Hi Anders, > > > I have to wonder, will make install do a recursive chown and chgrp? > > Yes. > > > If > > so, it would be a bad idea to use 'make install' if you use system > > quotas. > > Only if you still keep your user-managed domains under > ~vpopmail/domains. Yes, you're right; haven't thought about it because I > let my users manage their domains themselves through > ~/domains/, thus vpopmail isn't chown'ing their dirs. > > Jonas > > > >
[vchkpw] maildir or mailbox
i have been instal qmail , i use mailbox and instal checkpasswd , i have scrip like this : #!/bin/sh env - PATH=/var/qmail/bin:/usr/local/bin tcpserver -v -R 0 pop3 /var/qmail/bin/qmail-popup mydomain /bin/checkpassword /var/qmail/bin/qmail-pop3d Mailbox 2>&1 | /var/qmail/bin/splogger pop3d & and running , try to telnet localhost 110 , user xx , pass xx and get error -ERR this user has no $HOME/Maildir Connection closed by foreign host. tcpserver: end 892 status 256 tcpserver: status: 0/40 i want use Mailbox because old use Mailbox , and one againt how to convert Mailbox to Maildir thank's
Re: [vchkpw] Change the default quota
> Hi Luqman, > > > how do i change default quota in vpopmail ? > > Recompile. It's hard coded at compile time. > > Jonas As of vpopmail-5.3.19 you update the .qmailadmin-limits file or the vlimits mysql table. The hard coded value is used to initialize the default for the domain. Brian
Re: [vchkpw] Change the default quota
> > Hi Luqman, > > > > > how do i change default quota in vpopmail ? > > > > Recompile. It's hard coded at compile time. > > > > Jonas > > As of vpopmail-5.3.19 you update the .qmailadmin-limits > file or the vlimits mysql table. The hard coded value > is used to initialize the default for the domain. My mistake, the limits API is used only if you have the latest patched version of qmailadmin that this was added in on. I'll patch vpopmail also... Brian
[vchkpw] patch to set default quota in vadd_user()
This patch uses the vlimits() API to retrieve the
default user quota for their domain. This is for
cdb and mysql storage.
This should be applied to 5.3.19
Thanks,
Brian
diff -c vpopmail-5.3.18/vcdb.c vpopmail-5.3.19/vcdb.c
*** vpopmail-5.3.18/vcdb.c Thu Feb 20 13:27:49 2003
--- vpopmail-5.3.19/vcdb.c Thu Mar 20 08:49:29 2003
***
*** 666,671
--- 666,673
uid_t uid;
gid_t gid;
char crypted[100];
+ char quota[30];
+ struct vlimits limits;
if ( vget_assign(domain, Dir, 156, &uid, &gid ) == NULL ) {
strcpy(Dir, VPOPMAILDIR);
***
*** 699,709
}
#ifdef HARD_QUOTA
! fprintf(fs1, "%s", HARD_QUOTA);
#else
! fprintf(fs1, "NOQUOTA");
#endif
#ifndef CLEAR_PASS
fprintf(fs1, "\n");
#else
--- 701,715
}
#ifdef HARD_QUOTA
! snprintf(quota, sizeof(quota), "%s", HARD_QUOTA);
#else
! strcpy(quota, "NOQUOTA");
#endif
+ if (!vget_limits(domain, &limits))
+ snprintf(quota, sizeof(quota), "%s", limits.defaultquota);
+ fprintf(fs1, quota);
+
#ifndef CLEAR_PASS
fprintf(fs1, "\n");
#else
diff -c vpopmail-5.3.18/vmysql.c vpopmail-5.3.19/vmysql.c
*** vpopmail-5.3.18/vmysql.cMon Jan 27 11:29:15 2003
--- vpopmail-5.3.19/vmysql.cThu Mar 20 08:45:53 2003
***
*** 250,255
--- 250,256
char quota[30];
char Crypted[100];
int err;
+ struct vlimits limits;
if ( (err=vauth_open_update()) != 0 ) return(err);
vset_default_domain( domain );
***
*** 260,265
--- 261,269
strncpy( quota, "NOQUOTA", 30 );
#endif
+ if (!vget_limits(domain, &limits))
+ snprintf(quota, sizeof(quota), "%s", limits.defaultquota);
+
#ifndef MANY_DOMAINS
domstr = vauth_munch_domain( domain );
#else
Re: [vchkpw] maildir or mailbox
Hello sonjaya, Thursday, March 20, 2003, 6:43:29 PM, you wrote: > i have been instal qmail , i use mailbox and instal checkpasswd , i > have scrip like this : > #!/bin/sh > env - PATH=/var/qmail/bin:/usr/local/bin > tcpserver -v -R 0 pop3 /var/qmail/bin/qmail-popup mydomain > /bin/checkpassword /var/qmail/bin/qmail-pop3d Mailbox 2>&1 | > /var/qmail/bin/splogger pop3d & > and running , try to telnet localhost 110 , user xx , pass xx and get > error > -ERR this user has no $HOME/Maildir OBVIOUSLY (CLEAR), qmail-pop3 only support MAILDIR mailboxes. > Connection closed by foreign host. > tcpserver: end 892 status 256 > tcpserver: status: 0/40 > i want use Mailbox because old use Mailbox , > and one againt how to convert Mailbox to Maildir > thank's http://www.gerg.ca/hacks/mb2md/ -- made <[EMAIL PROTECTED]> Ikuti polling TELKOM Memo 166 di www.plasa.com dan menangkan hadiah masing-masing Rp 250.000 tunai
RE: [vchkpw] Spam Assassin implementation
Thanks Benjamin! I didn't really know a qmail-scanner existed until I started posting. Thanks to everyone else too. I'LL BE BACK! -Original Message- From: Benjamin Tomhave [mailto:[EMAIL PROTECTED] Sent: March 19, 2003 6:39 PM To: John McGivern Cc: [EMAIL PROTECTED] Subject: RE: [vchkpw] Spam Assassin implementation I would suggest checking out http://qmail-scanner.sourceforge.net/ in order to learn about how qmail-scanner is setup and to help you figure out what's being called, etc. > -Original Message- > From: John McGivern [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 19, 2003 4:18 PM > To: Jonas Pasche; [EMAIL PROTECTED] > Subject: RE: [vchkpw] Spam Assassin implementation > > > Well, I think however the UNIX guy set this up before that it > does actually work - somehow (I'm obviously a little light on the > UNIX stuff compared to you guys!) I know that if these people > weren't getting mail I would be in big trouble so they are > receiving mail. And I know from looking in the queue that spam > messages are getting bounced back. > > I don't really know how to find out how the spam assassin is > being called. I don't really know anything about qmail-scanner > either. I guess I need to do some research on that. I would > just like to understand the whole process and know it is set up > properly because obviously it isn't set up properly :0 ;) > > Any ideas on where to start would be appreciated! > > Thanks, > > John McGivern > > -Original Message- > From: Jonas Pasche [mailto:[EMAIL PROTECTED] > Sent: March 19, 2003 2:38 PM > To: [EMAIL PROTECTED] > Subject: Re: [vchkpw] Spam Assassin implementation > > > Hi John, > > > Somebody else had set this up a while ago - I think it is working but > > I'm not sure if it is affecting other mail deliveries. > > Oh well, it is... > > > Basically I have spam assassin installed and I have a .qmail-default > > in every domain folder on my server. It looks like this: > > > > | /var/qmail/bin/preline -d /var/qmail/bin/bouncesaying \ > > "[message to bounce back if not SPAM]" > > | /home/vpopmail/bin/vdelivermail ' ' bounce-no-mailbox > > The first line simply bounces _everything_ back to the sender, telling > him it is spam. You don't actually call any SpamAssassin program in your > .qmail-default file - how do you expect SpamAssassin to be actually used > in your setup? ;-) > > > Does this look like it should work okay with spam assassin? > > Definitely not. > > > I notice others .qmil-default files look a little different. > > Theirs might be hopefully working ;-) > > Personally, I'd prefer qmail-scanner to mark all messages with a spam > analysis header, and then use dot-qmail filtering to sort them out > later. Try out this, if your mail server supports qmail-scanner with > SpamAssassin integration. You'll need the 822mess package from DJB to > get the "822field" program. > > $ cat .qmail-default > | bouncesaying "I don't want your spam" 822field X-Spam-Flag > /dev/null > | /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox > > It's 822field in this case that checks for the presence of the > X-Spam-Flag header. If it's present, it bounces the message back to the > sender. If not, it continues with the next delivery instruction. > > Please be aware that qmailadmin occasionally rewrites .qmail-default, > causing your manual filtering rules to disappear! > > Jonas > > > >
[vchkpw] Spam Assassin implementation
I have spamassassin running in the user's .qmail. It looks like this...
| /var/qmail/bin/preline /usr/local/bin/maildrop
/home/vpopmail/etc/mailfilter
And the mailfilter script looking like this...
##
#mailfilter
##
import EXT
import HOST
import HOME
VHOME=`/home/vpopmail/bin/vuserinfo -d [EMAIL PROTECTED]
VPOP="| /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox"
if ($SIZE < 262144)
{
xfilter "/usr/bin/spamc -u [EMAIL PROTECTED]"
}
if ((/^X-Spam-Flag:.*YES/))
{
`test -d $VHOME/Maildir/.JunkMail`
if( $RETURNCODE == 1 )
{
`maildirmake $VHOME/Maildir/.JunkMail;chown -R vpopmail.vchkpw
$VHOME/Maildir/.JunkMail`
}
to "$VHOME/Maildir/.JunkMail/"
}
to "$VHOME/Maildir/"
- Original Message -
From: "Cory Wright" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 19, 2003 8:22 AM
Subject: Re: [vchkpw] Spam Assassin implementation
On Wed, Mar 19, 2003 at 11:14:53AM -0500, John McGivern wrote:
> Basically I have spam assassin installed and I have a .qmail-default in
> every domain folder on my server. It looks like this:
>
> | /var/qmail/bin/preline -d /var/qmail/bin/bouncesaying "[message to
bounce back if not SPAM]"
> | /home/vpopmail/bin/vdelivermail ' ' bounce-no-mailbox
Where exactly are you calling SpamAssassin?
Cory
--
Cory Wright
Stand Blue Technology
http://www.standblue.net/
[vchkpw] Re: Spam Assassin implementation
News from the front lines:
In a world that has mostly benign spam where spammers with real
return addresses send messages to valid recipients, qmail-scanner
has its place. You can easily tag spam qith qmail-scanner so that
the POP/IMAP clients can deal with the messsages appropriately.
For a small site with a few users ("few" < 1000), using
.qmail-(USER|default) or user-based implementation rules is fine.
For an ISP with thousands of users, it's not good enough anymore.
Even qmail-scanner-queue doesn't help protect servers from the
constant deluge of malignant messages.
I've been finding that at a small ISP (20k users), the final delivery
is far too late in the process to deal with spam. Address harvesters
(sending to 99% invalid addresses to find the 1% that don't bounce) and
spam blasters (sending spam to >3 invalid recipients per message) tax
the server processing hard enough to cause problems, particularly from
bounce addresses to forged senders. As the spammers get more
persistent or desperate, they've been less gracious about how they
spam. In one case recently, I had a DDoS from 40 sites sending similar
spam all at once to/through our server to thousands of bad addresses.
Our servers spent a whole weekend trying to deliver the bounce messages
until I could clean/drain the queues of 85000 bounce messages. There's
not much that qmail-scanner can do itself to protect the server.
I am using two tools for the benefit of my users:
SpamAssassin (www.spamassassin.org)
Vexira virus scanner (www.centralcommand.com)
If the spammers weren't too peristent, I'd be able to just use
qmail-scanner-queue.pl and be mostly done. This worked for a
couple months before our ISP became a heavily hit target (60%
spam, 25% malignant spam).
My implementation now includes:
a qmail-smtpd that rejects mail based on environment variables
set from tcp.smtp.
a qmail.c hacked to provde better SMTP error codes based on qq exit
codes.
a rewitten qmail-scanner-queue that is highly optimized at letting
SA/spamc and Vexira do their job with minimal system resources
a qmail-send that injects bounce messages to the sender only when
it's a non-malignant message (one-to-one communication to a valid
recipient)
a qmail-send that puts messages into a holding queue rather
than fully processing them right away. An asynchronous program
comes by and processes each message in the holding queue linearly
to prevent load swings from simultaneous qmail-send/vdelivermail
instances.
a procmail-like perl program responsible for final delivery that
queries a mysql database for a user's spam preference and uses
those preferences to tag/delete/pass messages based on SA scores
and user-defined keywords. A coworker made a web user interface.
added functionality to auto-add and auto-remove statistically
defined address harvesters and spam blasters to my tcp.smtp
block lists (with appropriate 400 or 500 messages based on
severity)
a program to create a cdb database of valid users to help the
filtering programs detect how many valid vs invalid users an IP
address or netblock is attempting to send to.
This my the third round of an on-and-off 6-month long fight. It's
not about filtering spam anymore, it's about protecting our mail
servers. As I leave, I have a big "I told you so" about how our CEO
should have just subscribed to BigFish/Frontbridge and paying the extra
money instead of going it alone. It would have saved money and reduced
downtime if SPAM processing weren't our problem.
The system is complex (some new perl/SspeedyCGI programs plus several
patches to qmail and one to vdelivermail), but it actively provides
negative feedback to spammers and harvesters with (hopefully) little
to no administration from a mail administrator. The good news is
that I'm about to finish up, and I don't have any IP restricions with
the ISP, so I believe I'll be able to share most of my work. I hope
to be posting some patches and programs soon.
Another approach could have been to just integrate everything into
SpamAssassin, but it's getting too huge already. Each of thousands
of 4K messages doen't need to go through a program that sucks 16MB
RSS memory. A large program isn't the most efficient place to
block/route messages.
--
Eric Ziegast
internet!vix.com!ziegast
Winning another battle in the losing war against spam.
Re: [vchkpw] Spam Assassin implementation
Opps, the spamassassin stuff should be on one line
| /var/qmail/bin/preline /usr/local/bin/maildrop
/home/vpopmail/etc/mailfilter
- Original Message -
From: "Joe Young" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 20, 2003 8:50 AM
Subject: [vchkpw] Spam Assassin implementation
I have spamassassin running in the user's .qmail. It looks like this...
| /var/qmail/bin/preline /usr/local/bin/maildrop
/home/vpopmail/etc/mailfilter
And the mailfilter script looking like this...
##
#mailfilter
##
import EXT
import HOST
import HOME
VHOME=`/home/vpopmail/bin/vuserinfo -d [EMAIL PROTECTED]
VPOP="| /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox"
if ($SIZE < 262144)
{
xfilter "/usr/bin/spamc -u [EMAIL PROTECTED]"
}
if ((/^X-Spam-Flag:.*YES/))
{
`test -d $VHOME/Maildir/.JunkMail`
if( $RETURNCODE == 1 )
{
`maildirmake $VHOME/Maildir/.JunkMail;chown -R vpopmail.vchkpw
$VHOME/Maildir/.JunkMail`
}
to "$VHOME/Maildir/.JunkMail/"
}
to "$VHOME/Maildir/"
- Original Message -
From: "Cory Wright" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 19, 2003 8:22 AM
Subject: Re: [vchkpw] Spam Assassin implementation
On Wed, Mar 19, 2003 at 11:14:53AM -0500, John McGivern wrote:
> Basically I have spam assassin installed and I have a .qmail-default in
> every domain folder on my server. It looks like this:
>
> | /var/qmail/bin/preline -d /var/qmail/bin/bouncesaying "[message to
bounce back if not SPAM]"
> | /home/vpopmail/bin/vdelivermail ' ' bounce-no-mailbox
Where exactly are you calling SpamAssassin?
Cory
--
Cory Wright
Stand Blue Technology
http://www.standblue.net/
[vchkpw] smtp/queue problems
Hi everyone, I have a client using plesk which is a system that integrates qmail with web services. They have been using their own server to send mail as well as receive. Right now when I do a qmail-qread on the queue it just goes on for days and days - there is alot of stuff in there - most likely spammers!! Is there a way to just blast everything out of the queue in one mighty fell-swooping command? I really need to get this queue completely cleared out so that htey can send mail again - I will fix up their set up after so this doesn't happen again!! Thanks, John McGivern
Re: [vchkpw] smtp/queue problems
John McGivern wrote: I have a client using plesk which is a system that integrates qmail with web services. They have been using their own server to send mail as well as receive. Right now when I do a qmail-qread on the queue it just goes on for days and days - there is alot of stuff in there - most likely spammers!! Is there a way to just blast everything out of the queue in one mighty fell-swooping command? I really need to get this queue completely cleared out so that htey can send mail again - I will fix up their set up after so this doesn't happen again!! Google is your friend ;-) http://www.faqts.com/knowledge_base/view.phtml/aid/6567/fid/286/lang/en -- Aj. Systems Administrator / Developer
[vchkpw] Compile erro
Hi, I'm trying to install Vpopmail 5.3.6 with MySQL support on a Red Hat 8.0 When i do 'make' i got the following error: vauth.c:25:19: mysql.h: No such file or directoryIn file included from vauth.c:29:vmysql.h:50:22: warning: multi-line string literals are deprecatedvauth.c:32: parse error before "mysql_update"vauth.c:32: warning: type defaults to `int' in declaration of `mysql_update'vauth.c:32: warning: data definition has no type or storage classvauth.c:33: parse error before "mysql_read_getall"vauth.c:33: warning: type defaults to `int' in declaration of `mysql_read_getall'vauth.c:33: warning: data definition has no type or storage classvauth.c:51: parse error before '*' tokenvauth.c:51: warning: type defaults to `int' in declaration of `res_update'vauth.c:51: warning: data definition has no type or storage classvauth.c:52: parse error before '*' tokenvauth.c:52: warning: type defaults to `int' in declaration of `res_read_getall'vauth.c:52: warning: data definition has no type or storage classvauth.c:60: parse error before "row"vauth.c:60: warning: type defaults to `int' in declaration of `row'vauth.c:60: warning: data definition has no type or storage classvauth.c:61: parse error before "row_getall"vauth.c:61: warning: type defaults to `int' in declaration of `row_getall'vauth.c:61: warning: data definition has no type or storage classvauth.c: In function `vauth_open_update':vauth.c:105: warning: implicit declaration of function `mysql_init'vauth.c:108: warning: implicit declaration of function `mysql_real_connect'vauth.c:113: warning: implicit declaration of function `mysql_error'vauth.c:113: warning: format argument is not a pointer (arg 3)vauth.c:124: warning: format argument is not a pointer (arg 3)vauth.c:132: warning: implicit declaration of function `mysql_query'vauth.c:137: warning: format argument is not a pointer (arg 2)vauth.c:140: warning: implicit declaration of function `mysql_store_result'vauth.c:140: warning: assignment makes pointer from integer without a castvauth.c:141: warning: implicit declaration of function `mysql_free_result'vauth.c:144: warning: implicit declaration of function `mysql_select_db'vauth.c: In function `vauth_adddomain':vauth.c:236: warning: assignment makes pointer from integer without a castvauth.c: In function `vauth_adduser':vauth.c:311: warning: format argument is not a pointer (arg 2)vauth.c:314: warning: assignment makes pointer from integer without a castvauth.c: In function `vauth_getpw':vauth.c:365: warning: format argument is not a pointer (arg 2)vauth.c:369: warning: assignment makes pointer from integer without a castvauth.c:374: warning: implicit declaration of function `mysql_num_rows'vauth.c:393: warning: implicit declaration of function `mysql_fetch_row'vauth.c:394: subscripted value is neither array nor pointervauth.c:394: subscripted value is neither array nor pointervauth.c:394: subscripted value is neither array nor pointervauth.c:394: subscripted value is neither array nor pointervauth.c:394: subscripted value is neither array nor pointervauth.c:395: subscripted value is neither array nor pointervauth.c:395: subscripted value is neither array nor pointervauth.c:395: subscripted value is neither array nor pointervauth.c:395: subscripted value is neither array nor pointervauth.c:395: subscripted value is neither array nor pointervauth.c:395: subscripted value is neither array nor pointervauth.c:396: subscripted value is neither array nor pointervauth.c:396: subscripted value is neither array nor pointervauth.c:397: subscripted value is neither array nor pointervauth.c:397: subscripted value is neither array nor pointervauth.c:398: subscripted value is neither array nor pointervauth.c:398: subscripted value is neither array nor pointervauth.c:398: subscripted value is neither array nor pointervauth.c:398: subscripted value is neither array nor pointervauth.c:398: subscripted value is neither array nor pointervauth.c:398: subscripted value is neither array nor pointervauth.c:399: subscripted value is neither array nor pointervauth.c:399: subscripted value is neither array nor pointervauth.c:399: subscripted value is neither array nor pointervauth.c:399: subscripted value is neither array nor pointervauth.c:399: subscripted value is neither array nor pointervauth.c:399: subscripted value is neither array nor pointervauth.c:400: subscripted value is neither array nor pointervauth.c:400: subscripted value is neither array nor pointervauth.c:400: subscripted value is neither array nor pointervauth.c:400: subscripted value is neither array nor pointervauth.c:400: subscripted value is neither array nor pointervauth.c:400: subscripted value is neither array nor pointervauth.c:402: subscripted value is neither array nor pointervauth.c:402: subscripted value is neither array nor pointervauth.c:402: subscripted value is neither array nor pointervauth.c:402: subscripted va
[vchkpw] SpamAssassin
I realize this topic has been beaten to death, but I've decided to keep on poking it anyhow. It also might be a little OT. I wasn't able to find anything in the list archives similar to this, so I decided to post it in case it's useful to someone. I needed to have SpamAssassin scan all incoming mail for a particular domain on my server. I didn't want to patch qmail and use qmail-qfilter or qmail-scanner. I don't need the server to redirect the message, delete it, or bounce it. I just want the spam to be tagged/modified and it's up to my users what they do with it from there. Here's the solution I came up with: In my .qmail-default for the domain: | spamc -u [EMAIL PROTECTED] -e /usr/local/vpopmail/bin/vdelivermail '' bounce-no-mailbox My local.cf for SpamAssassin: rewrite_subject 1 subject_tag ***SPAM*** auto_whitelist_path ~/auto-whitelist bayes_path ~/bayes The command used to start spamd: spamd -a -d -u vpopmail -v Points of interest: I had to modify the auto_whitelist_path and bayes_path because for some reason when spamd uses vpopmail style home dir (-v option) it already puts /.spamassassin/ in the home dir path. (if I left the defaults my files would end up at ~vpopmail/domain.com/user/.spamassassin/.spamassassin/file) The following excerpt from the spamc man page explains that by using the -e option there is a small chance of losing mail: "Instead of writing to stdout, pipe the output to command's standard input. Note that there is a very slight chance mail will be lost here, because if the fork-and-exec fails there's no place to put the mail message." I can't find anything wrong with this solution, but comments are definitely welcome. Cheers, Rob Gridley, System Administrator MHz Design Communications Inc. Macs for productivity. UNIX for stability. Windows for solitaire.
Re: [vchkpw] Compile erro
Maybe compare your steps with the ones in my "quick guide to vpopmail with mysql" at http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm Michael - Original Message - From: "Thiago Campos" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 21, 2003 7:50 AM Subject: [vchkpw] Compile erro Hi, I'm trying to install Vpopmail 5.3.6 with MySQL support on a Red Hat 8.0 When i do 'make' i got the following error: vauth.c:25:19: mysql.h: No such file or directory In file included from vauth.c:29: vmysql.h:50:22: warning: multi-line string literals are deprecated vauth.c:32: parse error before "mysql_update" vauth.c:32: warning: type defaults to `int' in declaration of `mysql_update' vauth.c:32: warning: data definition has no type or storage class vauth.c:33: parse error before "mysql_read_getall" vauth.c:33: warning: type defaults to `int' in declaration of `mysql_read_getall' vauth.c:33: warning: data definition has no type or storage class vauth.c:51: parse error before '*' token vauth.c:51: warning: type defaults to `int' in declaration of `res_update' vauth.c:51: warning: data definition has no type or storage class vauth.c:52: parse error before '*' token vauth.c:52: warning: type defaults to `int' in declaration of `res_read_getall' vauth.c:52: warning: data definition has no type or storage class vauth.c:60: parse error before "row" vauth.c:60: warning: type defaults to `int' in declaration of `row' vauth.c:60: warning: data definition has no type or storage class vauth.c:61: parse error before "row_getall" vauth.c:61: warning: type defaults to `int' in declaration of `row_getall' vauth.c:61: warning: data definition has no type or storage class vauth.c: In function `vauth_open_update': vauth.c:105: warning: implicit declaration of function `mysql_init' vauth.c:108: warning: implicit declaration of function `mysql_real_connect' vauth.c:113: warning: implicit declaration of function `mysql_error' vauth.c:113: warning: format argument is not a pointer (arg 3) vauth.c:124: warning: format argument is not a pointer (arg 3) vauth.c:132: warning: implicit declaration of function `mysql_query' vauth.c:137: warning: format argument is not a pointer (arg 2) vauth.c:140: warning: implicit declaration of function `mysql_store_result' vauth.c:140: warning: assignment makes pointer from integer without a cast vauth.c:141: warning: implicit declaration of function `mysql_free_result' vauth.c:144: warning: implicit declaration of function `mysql_select_db' vauth.c: In function `vauth_adddomain': vauth.c:236: warning: assignment makes pointer from integer without a cast vauth.c: In function `vauth_adduser': vauth.c:311: warning: format argument is not a pointer (arg 2) vauth.c:314: warning: assignment makes pointer from integer without a cast vauth.c: In function `vauth_getpw': vauth.c:365: warning: format argument is not a pointer (arg 2) vauth.c:369: warning: assignment makes pointer from integer without a cast vauth.c:374: warning: implicit declaration of function `mysql_num_rows' vauth.c:393: warning: implicit declaration of function `mysql_fetch_row' vauth.c:394: subscripted value is neither array nor pointer vauth.c:394: subscripted value is neither array nor pointer vauth.c:394: subscripted value is neither array nor pointer vauth.c:394: subscripted value is neither array nor pointer vauth.c:394: subscripted value is neither array nor pointer vauth.c:395: subscripted value is neither array nor pointer vauth.c:395: subscripted value is neither array nor pointer vauth.c:395: subscripted value is neither array nor pointer vauth.c:395: subscripted value is neither array nor pointer vauth.c:395: subscripted value is neither array nor pointer vauth.c:395: subscripted value is neither array nor pointer vauth.c:396: subscripted value is neither array nor pointer vauth.c:396: subscripted value is neither array nor pointer vauth.c:397: subscripted value is neither array nor pointer vauth.c:397: subscripted value is neither array nor pointer vauth.c:398: subscripted value is neither array nor pointer vauth.c:398: subscripted value is neither array nor pointer vauth.c:398: subscripted value is neither array nor pointer vauth.c:398: subscripted value is neither array nor pointer vauth.c:398: subscripted value is neither array nor pointer vauth.c:398: subscripted value is neither array nor pointer vauth.c:399: subscripted value is neither array nor pointer vauth.c:399: subscripted value is neither array nor pointer vauth.c:399: subscripted value is neither array nor pointer vauth.c:399: subscripted value is neither array nor pointer vauth.c:399: subscripted value is neither array nor pointer vauth.c:399: subscripted value is neither array nor pointer vauth.c:400: subscripted value is neither array nor pointer vauth.c:400: subscripted value is neither array nor pointer vauth.c:400: subscripted value is neither array nor pointer vauth.c:400: subscripted value is neither array nor pointer vauth.c:
Re: [vchkpw] Compile erro
Thiago Campos wrote: When i do 'make' i got the following error: vauth.c:25:19: mysql.h: No such file or directory In file included from vauth.c:29: It can't find your mysql.h include file. Look in /usr/include. If you built MySQL from source (and didn't use the RPM package) then make sure you tell configure where to look for it. -- Aj. Systems Administrator / Developer
Re: [vchkpw] SpamAssassin - scaling
On Thu, 20 Mar 2003, Rob Gridley wrote: > I realize this topic has been beaten to death, but I've decided to keep on > poking it anyhow. It also might be a little OT. I wasn't able to find > anything in the list archives similar to this, so I decided to post it in > case it's useful to someone. Not to steal your thread, but oops... Technically OT, but there's really no other place to do it. And since it seems more and more people are needing *something* to filter spam just to be on a level playing field with other providers, there's no harm in getting some SA info in the archives. Can anyone running SA on a per-user or per-domain basis speak to how this is scaling for you? Say you're running spamd on another box (or two, or three), how many users have you been able to squeeze on one box? For sake of argument, say the box is a dual-proc PIII 1GHz that is only running vpopmail/qmail handling only incoming mail. Are you getting 2,000 accounts comfortably? 5,000? 10,000? Do these numbers hold up when you're being attacked by a spammer doing a dictionary run or other evil deeds? I'm not too interested in the qmail-scanner approach, that's too much perl in the heart of the mail system. I think it would be beneficial to all involved to have some people post what type of density they can get on modern hardware. Thanks, Charles > Cheers, > > > Rob Gridley, System Administrator > MHz Design Communications Inc. > > Macs for productivity. UNIX for stability. Windows for solitaire. > > >
Re: [vchkpw] Compile erro
Hi Thiago, > I'm trying to install Vpopmail 5.3.6 with MySQL support on a Red Hat 8.0 > > When i do 'make' i got the following error: > > vauth.c:25:19: mysql.h: No such file or directory You're simply missing the mysql-devel package which includes the appropriate header files. ftp://rpmfind.net/linux/redhat/updates/8.0/en/os/i386/mysql-devel-3.23.54a-4.i386.rpm Jonas
RE: [vchkpw] Re: Best Way To Import cdb to MySQL w/ Alterations
Peter, cp -R /sites/home/vpopmail/domains/someonesdomain.com/* /sites/http/somonesdomain.com/postoffice/someonesdomain.com/ vconvert -c -m someonesdomain.com Only results in "converting someonesdomain.com domain conversion failed" Is there something I have to do before hand that I am not aware of? I can add new domains and they all go where they are supposed to go adding the correct information to /var/qmail/users /var/qmail/control and vpopmail.* but once I get to conversion nothing! And this is a machine with 1 virtual domain. I am already having nightmares about getting to the machine with 250 domains. Thanks for the help, Wil > -Original Message- > From: Peter Palmreuther [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 19, 2003 2:31 PM > To: Wil Hatfield - HVHM Customer Care in vpop > Subject: [vchkpw] Re: Best Way To Import cdb to MySQL w/ Alterations > > > Hello Wil, > > On Wednesday, March 19, 2003 at 8:37:28 PM you wrote (at least in > part): > > > I am sure it has already been covered but I couldn't find > exactly what I was > > looking for so here we go again. > > > I need to import from the old cdb version that Vpopmail used to the new > > MySQL. New to us anyways. The tricky part is that the old user base was > > located at /sites/home/vpopmail/domains and the new location will be > > /sites/http/domainname.com/postoffice by using the -u switch. > > > Could someone point me in the direction of a resource that may > be modifiable > > in this fashion? It would be most appreciated. > > Try copying > > /sites/home/vpopmail/domains/domain.com/vpasswd* > > to > > /sites/http/domainname.com/postoffice/ > > and use the 'vconvert' tool provided with vpopmail. > -- > Best regards > Peter Palmreuther > > A real patriot is the fellow who gets a parking ticket and rejoices > that the system works. > >
RE: [vchkpw] Spamassassin Integration Problem
We added the spamc command to the .qmail-alias files and it does not seem to filter the mail. As an example we have a file '.qmail-jeff' with the following contents: | preline /usr/bin/spamc -u [EMAIL PROTECTED] &[EMAIL PROTECTED] and a file '.qmail-daniel' with: | preline /usr/bin/spamc /home/vpopmail/domains/edeinternet.com/pop99922/Maildir/ The email that shows up at '[EMAIL PROTECTED]' and the email that ends up in the 'pop99922' maildir show no evidence in the headers of having been processed by spamassassin. We also tried various forms of the first line to no avail. We can only get spammassassin to work through the .qmail-default file and then it doesn't process aliases and forwards. What am I doing wrong? Jeff -- On Tue, 18 Mar 2003, remo wrote: > You need to add the spam option into the alias file too otherwise it > will not work, this has been posted before :) > > Have a good one. > > REMO > > -Original Message- > From: jeffkoch [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 10:40 AM > To: [EMAIL PROTECTED] > Subject: [vchkpw] Spamassassin Integration Problem > > > > We have spamassassin partly working with the qmail/vpopmail setup. But > are > having a problem getting it setup so that it processes all of the email > that comes into the domain. > > We have the following line in .qmail-default : > > | preline /usr/bin/spamc | /home/vpopmail/bin/vdelivermail '' > /home/vpopmail/domains/edeint.com/pop99922 > > within this domain directory we have directories for the users: > > ede/ > jbk/ > pop99922/ > postmaster/ > > we also have .qmail files for the following aliases. There .qmail files > were created by qmailadmin > > .qmail-chinesco (contains &[EMAIL PROTECTED]) > .qmail-daniel (contains > /home/vpopmail/domains/edeint.com/pop99922/Maildir/ ) > .qmail-jeff (contains &[EMAIL PROTECTED] ) > > The problem we have is that spamassassin commands in .qmail-default are > only analyzing emails that are addressed to one of the real pop accounts > - > it is not analyzing emails addressed to an alias for either a local or > remote email account. > > For example it does not work on mail addressed to [EMAIL PROTECTED] even > > though that mail is then put into the local pop99922 email account. > > Does anyone have a suggestion on how we can get spamassassin to work on > all mail at the domain level? Are we using it wrong or are we using > qmailadmin incorrectly. > > Thanks > > Jeff > -- > > > > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 > >
[vchkpw] vpopmail + courier-imap + pop-before-smtp?
I have courier-imap working OK with vpopmail, no problems doing that beyond the usual bugs in the courier-imap build process. But I don't see any straightforward way to make it do pop-before-smtp. Courier uses its own authorization scheme. It calls the vpopmail lookup code, but doesn't have any interface to the relay stuff. I'm particularly interested in the MySQL version so I can handle multiple SMTP hosts. It's easy enough to stick an extra program into the courier-imap startup script, but it looks like I'll have to write the program myself. It's no big deal to write, but it's hard to believe that nobody's done it before. Regards, John Levine, [EMAIL PROTECTED], Primary Perpetrator of "The Internet for Dummies", Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer Commissioner "More Wiener schnitzel, please", said Tom, revealingly.
[vchkpw] Re: Change the default quota
Brian Kolaci writes: > As of vpopmail-5.3.19 you update the .qmailadmin-limits > file or the vlimits mysql table. The hard coded value > is used to initialize the default for the domain. My mistake, the limits API is used only if you have the latest patched version of qmailadmin that this was added in on. I'll patch vpopmail also... i don't know if it is safe to upgrade to 5.3 or upgrade is a must.. but i just want my vqregister set the quota so every new register has the quota set maybe recompiling is better, then manually set bigger quota for several people and the rest using the default quota Luqman.H www.unhas.ac.id/~luqe
[vchkpw] Re: Spamassassin Integration Problem
Hello Jeffkoch, On Friday, March 21, 2003 at 2:26:32 AM you wrote (at least in part): > We added the spamc command to the .qmail-alias files and it does not seem > to filter the mail. As an example we have a file '.qmail-jeff' with the > following contents: > | preline /usr/bin/spamc -u [EMAIL PROTECTED] > &[EMAIL PROTECTED] > and a file '.qmail-daniel' with: > | preline /usr/bin/spamc > /home/vpopmail/domains/edeinternet.com/pop99922/Maildir/ > The email that shows up at '[EMAIL PROTECTED]' and the > email that ends up in the 'pop99922' maildir show no evidence in the > headers of having been processed by spamassassin. [...] > What am I doing wrong? Could you show me the position in your dot-qmail files where you feed the output of spamc to a useful delivery? Both dot-qmail files pipe the message to spamc and if spamc didn't return with code 99 (which it never does, IIRC) the second delivery instruction is executed ... but of course not using the modified mail, but the original one. To get an idea change your .qmail-jeff like this: | preline /usr/bin/spamc -u [EMAIL PROTECTED] >/tmp/xxx and have a look at '/tmp/xxx' ... amazing, isn't it? Doing it right make it work. Now all you'll need is to store the output of spamc in a Maildir, but I'll leave it up to you as your home work to figure out the concrete command line. Hint: you'll most probably need something like 'tomaildir' from 'qtools' and you should probably think about that 'preline' when using programs that already handle 'qmail-command' environment variables, like 'tomaildir' does. -- Best regards Peter Palmreuther Win without boasting. Lose without excuse.
[vchkpw] Re: Best Way To Import cdb to MySQL w/ Alterations
Hello Wil, On Friday, March 21, 2003 at 1:15:12 AM you wrote (at least in part): > "converting someonesdomain.com domain conversion failed" I've never actually done such a conversation, so my experiences are limited. But I'd 'strace()' the vconvert process to figure out where (and maybe why) it fails. Perhaps it's only a file it is missing / searching in a different directory?!?!? -- Best regards Peter Palmreuther Always do right. This will gratify some people and astonish the rest. -- Mark Twain --
