Re: [vchkpw] Problems connecting courier-imap to vpopmail
First check that courier-imap works. Install it, edit the config files, and turn it on. Then log into your mail server from your mail client through IMAP instead of POP. Once that works, try tackling Squirrelmail. -- Adam Hooper [EMAIL PROTECTED] Jerker Jörbrand (FP/XCQ) wrote: Hi, I cant seem to connect courier-imap to vpopmail. Im using qmailadmin to handle all users and domains that I have and that works fine. But the problem is when i installed courier-imap and squirrelmail to get webaccess i cant seem to logon... How do i connect courier-imap to vpopmail, and verify that it works? Did I miss something when it comes to configuring the authentification for vpop, or what? Glad for help // Jerker
Re: [vchkpw] Mysql Threads
X-Istence wrote: Adam Hooper wrote: Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance. Last i checked Slashdot was running PostGreSQL. http://www.mysql.com/press/user_stories/slashdot.html Naturally, Slashdot has been running on the world's most popular open source database, MySQL, since the site's inception in 1997 (published April 2002). Have they switched more recently? I never heard of it if they have -- Adam Hooper [EMAIL PROTECTED]
Re: [vchkpw] Mysql Threads
They're threads, they share the same memory. So all the MySQL threads are sharing, among them, 10 megs. For an RDBMS, MySQL is quite lightweight. -- Adam Hooper [EMAIL PROTECTED] Mandy wrote: Hello, I saw, that on the mailserver there are 10 Mysqltreads waiting for requests. Everyone of the use 10MB RAM (standard installation of the rpms) Is this nessesary, our would 2 threads be enought. If yes, where can i change this ? Because 10 Threads -- 10 MB Ram -- 100MB RAM only for mysql ?? regards mandy.
Re: [vchkpw] Mysql Threads
I don't quite follow you. Why is it not relational? Note that MySQL's InnoDB table storage supports transactions, row-level locks, and foreign keys. -- Adam Hooper [EMAIL PROTECTED] Erik Bourget wrote: Adam Hooper [EMAIL PROTECTED] writes: They're threads, they share the same memory. So all the MySQL threads are sharing, among them, 10 megs. For an RDBMS, MySQL is quite lightweight. Then again, it's not an RDBMS (note the lack of 'relational'). SQL syntax doesn't make an RDB. - Erik
Re: [vchkpw] Mysql Threads
I've never had problems with InnoDB in the past 1-2 years. In one case it's being used for some fairly computationally intense PHP website calculations. Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance. It's around the same speed as MyISAM. One thing it's missing is fulltext searching... but you can't win 'em all It's not really all that useful for vpopmail, because all the data's in one table anyway. But using InnoDB wouldn't cause all that much harm. InnoDB is installed and initialized by default on MySQL 4.x. To use it, just ALTER TABLE table_name TYPE=InnoDB (could take a while if it's a big table -- you might want to create a separate InnoDB table and copy a few thousand rows at a time), or when CREATE-ing, CREATE TABLE table_name (blah blah blah) TYPE=InnoDB. -- Adam Hooper [EMAIL PROTECTED] Erik Bourget wrote: Adam Hooper [EMAIL PROTECTED] writes: I don't quite follow you. Why is it not relational? Note that MySQL's InnoDB table storage supports transactions, row-level locks, and foreign keys. To be fair, I don't count InnoDB as mysql. Perhaps I should. Is it production-ready (I assume so)? How is the speed compared to featureless myisam? - Erik
Re: [vchkpw] Spamassassin + qmail + vpopmail + procmail + courier-imapd + squirrelmail + qmail-scanner + clamav
Warning: may be a red herring: You might want to consider using qmail-scanner to call spamassassin as well as clamav. By default (I think) it puts a X-Spam-Status: Yes/No header in the mails, which can be filtered on any client. -- Adam Hooper [EMAIL PROTECTED] Vpopmail List wrote: Hello list .. I tried the gentoo list with this problem, but no luck .. I have finally taken the shot at trying to get this working .. What is working? Qmail, vpopmail, courier-imapd, qmail-pop3d and squirrelmail, qmail-scanner, clamav(minor problems) this all works ... what I am trying to involve now is procmail and spamassassin there really isn't much documentation to get this all working especially under gentoo .. but I don't think there is much to configure with either of these packages .. .. so I was wondering if I'd get any help here .. I think that vpopmail being involved is what is confusing me .. most have the $HOME as /home/USER/.maildir well with vpopmail I have it as .. /var/vpopmail/domains/USER/Maildir/ and from there it is new, cur, etc .. also I do not see this X-Spam file anywhere? any help is appreciated .. thanks ..
Re: [vchkpw] MySQL support in SqWebmail
We use sqwebmail with MySQL and have had no problems. Where did you read that it doesn't work? -- Adam Hooper [EMAIL PROTECTED] til wrote: Hi, i have a running setup using vchkpw with cdb authentication. I thought about switching to MySql Authentication to have a better overview over the existing accounts. Somewhere i read that Sqwebmail does not completely work with Mysql authentication and still vchkpw should be used. The problem is, that if vpopmail is already using mysql, new accounts will only be created in the databse so sqwebmail cannot login unless i convert them back from the mysql to cdb files ? What is the best way if i want to use the mysql database as the only source for login and password data ? Thanks, Till
Re: [vchkpw] lets stop the fight!
Two CVS sources is a nightmare -- as a user, I'd much rather two branches on the same source, so I could just do, for example, 'cvs up -r UNSTABLE' -- Adam Hooper [EMAIL PROTECTED] Evren Yurtesen wrote: I dont see why you fight over this. There should be two cvs sources anyhow one for current development branch and one for stable releases branch.
Re: [vchkpw] vpopmail mysql
Could it be that you're linking against MySQL client 3 instead of MySQL client 4? Or is your MySQL 4.0 client library trying to connect to MySQL 4.1 server? You've definitely got a version mismatch of *some* sort Also, I'd strongly recommend NOT using MySQL Server 4.1.0. It was released just to convince people that MySQL AB follows the release early, release often philosophy (though that version is ages old by now), but it really has too many bugs. If you absolutely need the latest MySQL (for subselects and derived tables, for example, though I don't see how you need use them in the vpopmail database) then install from the 4.1 bitkeeper branch. Instructions are on mysql.com. If you don't know what you want, you want MySQL 4.0.13. And you want to uninstall MySQL Client 3. -- Adam Hooper [EMAIL PROTECTED] eLgino wrote: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client i have mysql client 3 AND 4 and server 4.1.0 OS: FreeBSD 4.8 vpopmail= newest one - Original Message - From: Rick Macdougall [EMAIL PROTECTED] To: eLgino [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 6:17 PM Subject: Re: [vchkpw] vpopmail mysql Hi, We use it with 4.x without a problem. Regards, Rick eLgino wrote: hi folks, does work vpopmail with MySQL 4.1.0? or only with version 3? thx
Re: [vchkpw] vpopmail+spamassassin+clamscan
Another method (for different needs, of course): On our site, we just
put qmail-scanner in the qmail queue. All that needs to be done (all?
I spent hours on this :P) is apply the QMAILQUEUE patch to qmail, and
install qmail-scanner by following its instructions:
http://qmail-scanner.sourceforge.net/
qmail-scanner works with spamassassin and clamscan and can do primitive
attachment checks (i.e., block all .exe/.bat/.vbs attachments). The
way we have it set up, it just puts an 'X-Spam-Status: Yes/No' in the
message's header, and users can set their mail clients to use rules
based on that.
The downside: If you're running a very large site and only expect a few
people to use the virus-scanning abilities of spamassassin, you're going
to be burning lots of processor cycles. Our site is relatively small and
we need qmail-scanner anyway to block dangerous attachments, so the
waste of CPU isn't an issue for us.
--
Adam Hooper
[EMAIL PROTECTED]
Tom Walsh wrote:
There was some discussion a while back about making SA work with vpopmail.
Most solutions I saw used .qmail-username or .qmail-default which wasn't the
right method for us. Below is a quick write up on how to use SA+clamscan
from a .qmail file in the users maildir. We also pull user preferences for
SA from SQL, so the line we use to call SA might not be what you want.
Delivery and hand off for scanning is handled by maildrop.
First and foremost, make certain that the user vpopmail has a valid shell...
this is very important as vdeliermail will run anything in the .qmail as the
user vpopmail, provided the application doesn't do a setuid/setgid, which
maildrop does not do. (That alone cost me 3 hours to troubleshoot.)
For each user you want to enable SA and virus scanning put the following in
a .qmail file in the users directory:
| /var/qmail/bin/preline /usr/local/bin/maildrop
/usr/home/vpopmail/domains/.mailfilter
Make sure that this file has been chmod'ed to 600 (u+rw) and is owned by
vpopmail:vchkpw otherwise it will not be run.
The .mailfilter listed above contains (some of this script has come from
another list member, but I forgot his name, if you contact me I will give
credit where credit is due), it must also be chmod'ed to 600 with owner
vpopmail:vchkpw :
import EXT
import HOST
VHOME=`/usr/home/vpopmail/bin/vuserinfo -d [EMAIL PROTECTED]
# Check for Spam if it is smaller than 250KB
if($SIZE 262144)
{
xfilter /usr/local/bin/spamc -d 192.168.1.2 -t 20 -f -u [EMAIL PROTECTED]
}
if ((/^X-Spam-Flag:.*YES/))
{
`/bin/test -d $VHOME/Maildir/.Spam`
if( $RETURNCODE == 1 )
{
`/var/qmail/bin/maildirmake $VHOME/Maildir/.Spam;
/usr/sbin/chown -R vpopmail:vchkpw $VHOME/Maildir/.Spam`
}
to $VHOME/Maildir/.Spam/
}
# If it isn't Spam, then we scan for Virus if it is smaller than 2MB in
size... anything larger... they are on their own
if($SIZE 200)
{
xfilter /usr/home/vpopmail/domains/clamscan.sh
}
if ((/^X-Virus-Status:.*INFECTED/))
{
`/bin/test -d $VHOME/Maildir/.Virus`
if ( $RETUNRCODE == 1 )
{
`/var/qmail/bin/maildirmake $VHOME/Maildir/.Virus;
/usr/sbin/chown -R vpopmail:vchkpw $VHOME/Maildir/.Virus`
}
to $VHOME/Maildir/.Virus/
}
#If it isn't Spam or Virus, then deliver normally
to $VHOME/Maildir/
The specific lines of interest are the xfilter lines. We use spamc/spamd to
offload the very CPU intensive process of spam scanning to another machine
on the private network. That is what the -d directive is for which tells SA
which IP to connect to for spamd...
The clamscan.sh file is a wrapper for the clamscan binary. We need to do
this because of the incompatibility between how clamscan operates and how
maildrop expects an xfilter program to operate. maildrop expects any message
it sends out to an xfilter program to be returned to it via stdout. The
problem is that the clamscan binary only returns the results of the scan,
not the message, so we have to create a shell script to pass the altered
message back to maildrop via stdout, also we use the shell script to alter
the exit code of clamscan (0 if clean and 1 if infected) to be compatible
with what maildrop expects. maildrop expects the application to return a
exit code of 0, so we have to alter it.
You will need bash in order to use this.
#!/usr/local/bin/bash
# Created by Tom Walsh
# slim at ala.net
MSG=$(/bin/cat /dev/stdin) # Is there a better way to do this?
SCAN=$(echo $MSG | /usr/local/bin/clamscan - --stdout --disable-summary)
EXIT=$?
VIRUS=$(echo $SCAN | awk '{print $2}')
SUBJECT=$(echo $MSG | /usr/local/bin/reformail -x Subject:)
if [ $EXIT == 1 ]; then
SUBJECT=**VIRUS** [$VIRUS] $SUBJECT
MSG=$(echo $MSG | /usr/local/bin/reformail -aX-Virus-Status:
INFECTED -iSubject: $(echo $SUBJECT))
else
MSG=$(echo $MSG | /usr/local/bin/reformail -aX-Virus-Status: CLEAN)
fi
echo $MSG
exit 0
And just for completeness... I have included our spamd config line to let
you
[vchkpw] Incredibly destructive chmod's in vpopmail's Makefile.am
Here's a snippet of vpopmail's Makefile.am (from line 106 in 5.3.23) chmod 755 $(DESTDIR)@vpopmaildir@ chmod 755 $(DESTDIR)@vpopmaildir@/include chmod 755 $(DESTDIR)@vpopmaildir@/etc chmod 755 $(DESTDIR)@vpopmaildir@/doc chmod 755 $(DESTDIR)@vpopmaildir@/doc/man_html chmod 755 $(DESTDIR)@vpopmaildir@/doc/doc_html chmod 755 $(DESTDIR)@vpopmaildir@/bin chmod 700 $(DESTDIR)@vpopmaildir@/@domains_dir@ chmod 711 $(DESTDIR)@vpopmaildir@/bin/* chmod 444 $(DESTDIR)@vpopmaildir@/include/* chmod 444 $(DESTDIR)@vpopmaildir@/doc/doc_html/* Can anyone besides me see the problem? To make vpopmail distribution-friendly, I symlinked /home/vpopmail/bin to /usr/sbin (where I feel the files belong in the first place). So everything in /usr/sbin is set to rwx--x--x. Because I installed qmail via my distribution's installation tool, its binaries are located in /usr/sbin. Needless to say, the mail server was broken. There is no good reason to change permissions on all these files anyway; just install them properly in the first place and there's no reason they would get changed (unless the sysadmin wanted them changed, for whatever reason). The Makefile.am would be a lot simpler and less system-intrusive if it used the 'install' command instead of mkinstalldirs/cp/chown/chmod. Would it be more helpful if I wrote up a patch for this? I have hardly any time for the next 3 weeks, but figured this issue ought to be brought to people's attention as soon as possible. Adam Hooper [EMAIL PROTECTED]
Re: [vchkpw] Re: vpopmail documentation initiative
Hehe. I know it doesn't really add to the discussion, but...: I once made a FAQ interface for a completley unrelated project. I let people add their own FAQs with admin reviews, FAQs can have multiple categories, there's a nice search feature, everything was very dandy. I put in the first few FAQs myself and let users submit questions and answers as they found them. In the beginning, all was well. But nobody wants to maintain it! I sure as hell don't, I find it infuriating. None of the 5 other admins can be bothered with it either. Users STILL use the faq all the time, with 6-month-old data, but nobody wants to bother keeping it up to date, because it takes lots of research, time and patience. Worst of all, mailing-list questions don't disappear, they appear with just the same regularity. Except now the key phrase is search the faq. Proper netizens are indeed grateful and spend time to offer suggestions, but proper netizens can usually find most answers on Google anyway, so they'd never ask the question in the first place! In brief, a FAQ does surprisingly little to quell mailing list/IRC/private email clutter. I for one get MORE email I don't want, since I guess my email address draws peoples' attention more than the 'Contact us' link. One person has donated 10 dollars (US! Woo!) and beyond that I've spent countless hours replying to people with stuff like I haven't the fogiest notion. Check the 'Contact us' link for people who know more. To wrap up: In my experience, a FAQ is a f*cking pain. Good luck finding somebody who'll want to put that amount of time and effort -- I know I'll never do one again :). And that's THAT off my chest ;). (The project is http://openzaurus.org -- just a little plug for my favourite embedded distro!) I might as well add something *constructive* to all this: I've heard and seen nothing but good things from Wikis. Sourceforge has all you need to set one up :). (I've used phpwiki, but as far as I know they're all quite similar.) I think a vpopmail Wiki could be quite useful. -- Adam Hooper [EMAIL PROTECTED] Paul L. Allen wrote: My apologies if I've offended anyone, but it's late, I've had a lot of wine, and I've wanted to get that one off my chest for well over three years. I even put my money where my mouth is. If there is an FAQ (on whatever) and I have something useful I submit it to the maintainer. But all too often the FAQ has been abandoned in favour of search the archive.
Re: [vchkpw] Re: [qmailadmin] Why support imap?
I don't use it so I had to do a bit of a search, but I know Fetchmail does it, here's a relevent snippet from the FAQ, at http://www.catb.org/~esr/fetchmail/fetchmail-FAQ.html#O4 The other (which we recommend) is to switch to IMAP. IMAP has an explicit expunge command and fetchmail normally uses it to delete messages immediately after they are downloaded. And yes, if you want to use IMAP as a POP-type service, you'd have to save to local folders. If wouldn't have to be manual though, depending on the mail client I suppose. I've never used Fetchmail, so please don't ask me any Fetchmail questions ;). -- Adam Hooper [EMAIL PROTECTED] Evren Yurtesen wrote: how do you delete messages from server? :) next time you check your emails, your mail client would delete all from your inbox too... unless you move them to another folder manually (probably a local folder) On Thu, 14 Aug 2003, Adam Hooper wrote: Chris Shenton wrote: Because when you're on travel, your mail is inaccessible on those PCs, whether at work or at home. With IMAP you can leave mail on server, organize it into folders, search it, etc. Sure, it the server has to pay for disk, but in a corporate setting, one would pay for disk whether it's on a server or a desktop. A server, hopefully, would be backed up so you should lose mail if you lose a system. *OR* with IMAP you can download messages and delete them from the server just like with POP. I've always felt that IMAP just makes up for the deficiencies in POP -- it allows all the same activities, as well as so much more. -- Adam Hooper [EMAIL PROTECTED]
