Re: [vchkpw] Why is vadduser creating a hierarchy?

2006-10-14 Thread Jon Simola

On 10/14/06, Bert JW Regeer [EMAIL PROTECTED] wrote:


On Oct 14, 2006, at 16:06:30  MST, Rainer Duffner wrote:



 See above. DJB was or is a (Free)-BSD user (when he started, Linux
 was a toy anyway), which back in these days had this problem.

Agreed, however his Maildir approach did not include hashing in any
way shape or form, so how did file systems back then handle over
1000's of email messages in an Inbox?


Poorly. I had a server stall after a user stopped checking mail and
accumulated 100,000 messages in a single folder. The filesystem was
basically unusable. That was on FreeBSD 4.6, IIRC. Once I cleared that
up, the mysterious slowness in general of the machine disappeared.

--
Jon


Re: [vchkpw] Why is vadduser creating a hierarchy?

2006-10-06 Thread Jon Simola

On 10/6/06, Dave Richardson [EMAIL PROTECTED] wrote:


However, I'm seeing vadduser create a hierarchy of folders after about
the first 80-100 users are added.  Using subfolders A-z,0-9.

I only have about 7,000 users to manage and would rather NOT subtree
(whatever the term is) this user hierarchy.


Be sure your filesystem can handle this. Certain filesystems (ffs for
example) can take a major performance hit with a large number of files
in a single directory.


What logic controls when vadduser decides to subtree the folders for a
particular domain?


When running configure:
 --disable-users-big-dirDisable hashing of user directories.

--
Jon


Re: [vchkpw] User quota over NFS

2006-07-18 Thread Jon Simola

On 7/18/06, Darek M [EMAIL PROTECTED] wrote:


Incoming mail is handled by separate MX machines.  They in turn mount
the vpopmail directory from the main system via NFS, so they have access
to the same vpopmail binaries and domain directories.  So they are using
the vpopmail install from the main system.



However, when a user is over 100%, mail continues to be delivered into
the inbox.  Does anyone have any info on this?  A fix?


You might need Bill Shupp's qmail Maildir++ patch, it has solved
similar issues for me:

This patch adds maildirquota (Maildir++) support to qmail-pop3d and
qmail-local.  It was created because when vpopmail switched to maildirquotas,
a user's quota usage was not decreased after deleting mail via qmail-pop3d.
Also, because .qmail files would allow qmail-local to write directly to a
Maildir whithout piping through vdelivermail first, quotas were not effective
for aliases.  Actually, this was the case with vpopmail's old quota system as
well.

http://shupp.org/patches/qmail-maildir++-universal.patch

--
Jon


[vchkpw] maildirquota.c patches against 5.4.15

2006-03-08 Thread Jon Simola
I believe this fixes most of my problems with weird quotas showing up
in maildirsize files, as on some systems long and off_t are not the
same. The %lld in the sprintf (bottom of the patch) may not be
correct on all systems but was required in my case, as off_t is
typedef'd as long long.

--- maildirquota.h.orig Sun Mar 20 09:01:43 2005
+++ maildirquota.h  Wed Mar  8 10:52:32 2006
@@ -21,7 +21,7 @@
 int maildir_addquota(const char *, /* Pointer to the maildir */
int,/* Must be the int pointed to by 2nd arg to checkquota */
const char *,   /* The quota */
-   long,   /* +/- bytes */
+   off_t,  /* +/- bytes */
int);   /* +/- files */

 /* skip the rest... */
@@ -50,7 +50,7 @@
 int maildir_checkquota(const char *,   /* Pointer to directory */
int *,  /* Initialized to -1, or opened descriptor for maildirsize */
const char *,   /* The quota */
-   long,   /* Extra bytes planning to add/remove from maildir */
+   off_t,  /* Extra bytes planning to add/remove from maildir */
int);   /* Extra messages planning to add/remove from maildir */

 int maildir_readquota(const char *,/* Directory */

--- maildirquota.c.orig Tue Jan 17 11:08:34 2006
+++ maildirquota.c  Wed Mar  8 10:52:34 2006
@@ -43,12 +43,12 @@
time_t *, off_t *, unsigned *);
 static int statcurnew(const char *, time_t *);
 static int statsubdir(const char *, const char *, time_t *);
-static int doaddquota(const char *, int, const char *, long, int, int);
+static int doaddquota(const char *, int, const char *, off_t, int, int);
 static int docheckquota(const char *dir, int *maildirsize_fdptr,
-   const char *quota_type, long xtra_size, int xtra_cnt, int *percentage);
+   const char *quota_type, off_t xtra_size, int xtra_cnt, int *percentage);
 static int docount(const char *, time_t *, off_t *, unsigned *);
 static int maildir_checkquota(const char *dir, int *maildirsize_fdptr,
-   const char *quota_type, long xtra_size, int xtra_cnt);
+   const char *quota_type, off_t xtra_size, int xtra_cnt);
 /* moved into maildirquota.h as non-static
 static int maildir_addquota(const char *dir, int maildirsize_fd,
const char *quota_type, long maildirsize_size, int maildirsize_cnt);
@@ -407,7 +407,7 @@
 static int maildir_checkquota(const char *dir,
int *maildirsize_fdptr,
const char *quota_type,
-   long xtra_size,
+   off_t xtra_size,
int xtra_cnt)
 {
 intdummy;
@@ -430,7 +430,7 @@
 static int docheckquota(const char *dir,
int *maildirsize_fdptr,
const char *quota_type,
-   long xtra_size,
+   off_t xtra_size,
int xtra_cnt,
int *percentage)
 {
@@ -593,7 +593,7 @@
 }

 intmaildir_addquota(const char *dir, int maildirsize_fd,
-   const char *quota_type, long maildirsize_size, int maildirsize_cnt)
+   const char *quota_type, off_t maildirsize_size, int maildirsize_cnt)
 {
if (!quota_type || !*quota_type)return (0);
return (doaddquota(dir, maildirsize_fd, quota_type, maildirsize_size,
@@ -601,7 +601,7 @@
 }

 static int doaddquota(const char *dir, int maildirsize_fd,
-   const char *quota_type, long maildirsize_size, int maildirsize_cnt,
+   const char *quota_type, off_t maildirsize_size, int maildirsize_cnt,
int isnew)
 {
 union  {
@@ -665,7 +665,7 @@
}


-   sprintf(u.buf, %ld %d\n, maildirsize_size, maildirsize_cnt);
+   sprintf(u.buf, %lld %d\n, maildirsize_size, maildirsize_cnt);
iov[niov].iov_base=u.buf;
iov[niov].iov_len=strlen(u.buf);


--
Jon Simola
Systems Administrator
ABC Communications


Re: [vchkpw] maildirquota.c bug in 5.4.12

2006-02-07 Thread Jon Simola
On 2/5/06, Tom Collins [EMAIL PROTECTED] wrote:

 There's probably a problem elsewhere in the maildirquota code, where we
 use an unsigned long instead of a long.

Sounds good to me, I'll be back in there today as...

 When you made the change, did the problem go away?

It seems to have made it occur less frequently, but definately has not
fixed it. A sample maildirsize file that was pointed out to me this
morning contained:

# cat maildirsize
1S,3000C
6944656590839403888  102

So my patch has just made the issue a lot more visible.

  --- maildirquota.c.orig Tue Jan 24 11:24:36 2006
  +++ maildirquota.c  Tue Jan 24 11:24:58 2006
  @@ -283,5 +283,5 @@
char *p;
unsigned l;
  - int n;
  + long n;
int first;

--
Jon Simola
Systems Administrator
ABC Communications


[vchkpw] vadduser from perl script via sudo

2005-12-29 Thread jon
I have created a user registration script to create a new email account. 
The script is written in perl and call vadduser, I have added a sudo entry
to allow the webserver user to execute vadduser as root.  The script has
worked well for sometime but now receives the following error.  This error
is not raised when running vadduser from the command line.

Error: Unable to chdir to vpopmail/domains directory 64256

Thanks in advance


[vchkpw] high cpu with qmail-smtpd-chk or vchkpw

2005-12-07 Thread Jon
I'm getting 3-8 processes that hog all of the server's CPU.  Any ideas?  The
server was installed using to qmail-toaster SRPMSs

PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND

15810 vpopmail  25   0  5804 1412 1176 R 99.2  0.1   0:53.75 qmail-smtpd-chk

15933 vpopmail  25   0  6420 1412 1176 R 50.8  0.1   0:36.64 qmail-smtpd-chk

15260 vpopmail  25   0  5008 1412 1176 R 49.6  0.1   1:46.28 qmail-smtpd-chk

16250 root  16   0  2780  964  748 R  0.4  0.0   0:00.01 top


-

18984 ?R  0:51 /var/qmail/bin/qmail-smtpd-chkuser
/home/vpopmail/bin/vchkpw /bin/true
19024 ?R  0:46 /var/qmail/bin/qmail-smtpd-chkuser
/home/vpopmail/bin/vchkpw /bin/true
19045 ?R  0:48 /var/qmail/bin/qmail-smtpd-chkuser
/home/vpopmail/bin/vchkpw /bin/true
19151 ?R  0:36 /var/qmail/bin/qmail-smtpd-chkuser
/home/vpopmail/bin/vchkpw /bin/true
19366 ?R  0:16 /var/qmail/bin/qmail-smtpd-chkuser
/home/vpopmail/bin/vchkpw /bin/true
19374 ?R  0:14 /var/qmail/bin/qmail-smtpd-chkuser
/home/vpopmail/bin/vchkpw /bin/true
19452 ?R  0:12 /var/qmail/bin/qmail-smtpd-chkuser
/home/vpopmail/bin/vchkpw /bin/true
19494 ?R  0:08 /var/qmail/bin/qmail-smtpd-chkuser
/home/vpopmail/bin/vchkpw /bin/true




RE: [vchkpw] high cpu with qmail-smtpd-chk or vchkpw

2005-12-07 Thread Jon
I was wondering if this had something to do with it but it is unclear to me.

On Wednesday 26 October 2005 10:49 am, Miguel wrote:  
 Rick Macdougall wrote:  
  What options was vpopmail compiled with ?  I'll bet you had domain  
  quota support.  
  
 Excelente point, i forgot to tell you that im using mysql 4.1.7  
 My configure:  
 $ ./configure --enable-logging=p --enable-auth-module=mysql  
 --enable-mysql-limits --enable-domainquotas --enable-learn-passwords=y  
  
 is the domain quota a default flag?  
 
no, but it's right there, you have it enabled.  disable it and your problems

will disappear.  
 
-Jeremy  
 
--  
Jeremy Kitchen ++ E-mail Protected  
 
In the beginning was The Word and The Word was Content-type: text/plain  
  -- The Word of Bob.  


-Original Message-
From: Ken Jones [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 07, 2005 5:24 PM
To: vchkpw@inter7.com
Subject: Re: [vchkpw] high cpu with qmail-smtpd-chk or vchkpw

If you have the qmail TLS patch installed
then make sure you put in a cron job to build a temporary
key and put it in place.

Otherwise, each smtp connection causes an SSL key/pair to
be generated which can use all of the CPU.

Ken Jones

Jon wrote:
 I'm getting 3-8 processes that hog all of the server's CPU.  Any ideas?
The
 server was installed using to qmail-toaster SRPMSs
 
 PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
 
 15810 vpopmail  25   0  5804 1412 1176 R 99.2  0.1   0:53.75
qmail-smtpd-chk
 
 15933 vpopmail  25   0  6420 1412 1176 R 50.8  0.1   0:36.64
qmail-smtpd-chk
 
 15260 vpopmail  25   0  5008 1412 1176 R 49.6  0.1   1:46.28
qmail-smtpd-chk
 
 16250 root  16   0  2780  964  748 R  0.4  0.0   0:00.01 top
 
 
 -
 
 18984 ?R  0:51 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19024 ?R  0:46 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19045 ?R  0:48 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19151 ?R  0:36 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19366 ?R  0:16 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19374 ?R  0:14 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19452 ?R  0:12 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19494 ?R  0:08 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 
 




RE: [vchkpw] high cpu with qmail-smtpd-chk or vchkpw

2005-12-07 Thread Jon
/var/qmail/control/rsa512.pem exists

-Original Message-
From: Ken Jones [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 07, 2005 5:24 PM
To: vchkpw@inter7.com
Subject: Re: [vchkpw] high cpu with qmail-smtpd-chk or vchkpw

If you have the qmail TLS patch installed
then make sure you put in a cron job to build a temporary
key and put it in place.

Otherwise, each smtp connection causes an SSL key/pair to
be generated which can use all of the CPU.

Ken Jones

Jon wrote:
 I'm getting 3-8 processes that hog all of the server's CPU.  Any ideas?
The
 server was installed using to qmail-toaster SRPMSs
 
 PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
 
 15810 vpopmail  25   0  5804 1412 1176 R 99.2  0.1   0:53.75
qmail-smtpd-chk
 
 15933 vpopmail  25   0  6420 1412 1176 R 50.8  0.1   0:36.64
qmail-smtpd-chk
 
 15260 vpopmail  25   0  5008 1412 1176 R 49.6  0.1   1:46.28
qmail-smtpd-chk
 
 16250 root  16   0  2780  964  748 R  0.4  0.0   0:00.01 top
 
 
 -
 
 18984 ?R  0:51 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19024 ?R  0:46 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19045 ?R  0:48 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19151 ?R  0:36 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19366 ?R  0:16 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19374 ?R  0:14 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19452 ?R  0:12 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 19494 ?R  0:08 /var/qmail/bin/qmail-smtpd-chkuser
 /home/vpopmail/bin/vchkpw /bin/true
 
 




Re: [vchkpw] high cpu with qmail-smtpd-chk or vchkpw

2005-12-07 Thread jon
 Jon wrote:
 /var/qmail/control/rsa512.pem exists

 -Original Message-
 From: Ken Jones [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, December 07, 2005 5:24 PM
 To: vchkpw@inter7.com
 Subject: Re: [vchkpw] high cpu with qmail-smtpd-chk or vchkpw

 If you have the qmail TLS patch installed
 then make sure you put in a cron job to build a temporary
 key and put it in place.

 Hi,

 Ok, let's not top post if you don't mind.

 1) What is the date on the *.pem files in /var/qmail/control

 2) What are your vpopmail configure options?

 Regards,

 Rick



Sorry about the top posts

Dec  7 01:01 rsa512.pem

Where do I look to find the configure options?




Re: [vchkpw] high cpu with qmail-smtpd-chk or vchkpw

2005-12-07 Thread jon
 [EMAIL PROTECTED] wrote:
 Jon wrote:

 Sorry about the top posts

 No problem


 Dec  7 01:01 rsa512.pem

 Where do I look to find the configure options?

 cd /var/src/vpopmail/5.4.12 (or where ever your vpopmail source code is
 that you compiled it from)

 less config.log

 In my case it shows

 This file contains any messages produced by compilers while
 running configure, to aid debugging if configure makes a mistake.

 It was created by vpopmail configure 5.4.12, which was
 generated by GNU Autoconf 2.53.  Invocation command line was

$ ./configure --enable-logging=v --enable-ip-alias-domains=y

 Regards,

 Rick




./configure --prefix=/home/vpopmail --enable-vpopuser=vpopmail
--enable-vpopgroup=vchkpw --enable-libdir=/usr/lib/mysql
--disable-roaming-users --enable-tcprules-prog=/usr/bin/tcprules
--enable-tcpserver-file=/etc/tcprules.d/tcp.smtp --enable-make-seekable
--enable-clear-passwd --disable-users-big-dir --enable-qmail-ext
--disable-ip-alias-domains --enable-domainquotas
--enable-auth-module=mysql --disable-passwd --enable-logging=v
--enable-log-name=vpopmail --disable-mysql-limits --enable-valias
--disable-many-domains


Re: [vchkpw] Recomendations for best spam rejection

2004-09-17 Thread Jon LaBass
 Jon LaBass wrote:

 Jon LaBass wrote:
 
 snip
 
 Compile vpopmail with  SPAM_THRESHOLD=10 and any message scored at 10.0
 
  or
 
 above will not be delivered.
 
 Jon
 
 I just upgraded four servers this morning to 5.4.6, that is not a
 configure option that I know of. What vpopmail do you use?
 
 DAve
 
 
  Well, I use vpopmail on FreeBSD and that's how you define it with the
ports.
  After I wrote that I thought Doh!  Not everybody is using bsd so that
  option may not be available.  But, on other systems where you have to
  manually compile vpopmail, the option --enable-spam-threshold=10 should
  work.
 

 I use FreeBSD and NetBSD though I don't use ports. The stock vpopmail
 doesn't have this option, at least not the sources I downloaded Monday.
 Looking through the files directory in the port it seems the
 spamassassin code is a patch added by someone else to vdelivermail.c and
 vpopmail.c

 Interested in knowing how well it works for you though.

 DAve

 -- 
 Systems Administrator
 http://www.tls.net
 Get rid of Unwanted Emails...get TLS Spam Blocker!


It works quite well.  I'm surprised you don't take advantage of the FreeBSD
ports.  Install vpopmail with the SA flags and SA gets installed
automagically and it works normally.

Jon



Re: [vchkpw] Recomendations for best spam rejection

2004-09-16 Thread Jon LaBass
 Hi,

 how can I use SA global in qmail, with dropping of Mails that
 have more than 10 points of score?

 So that this mails that are definitly spam don't deliver to the
 user?

 That would extremly reduce our traffic and spam mails in the customer
 mailbox.

 Greetings
 Jan

  -Original Message-
  From: Matthew Walker [mailto:[EMAIL PROTECTED]
  Sent: Thursday, September 16, 2004 7:06 PM
  To: [EMAIL PROTECTED]
  Subject: Re: [vchkpw] Recomendations for best spam rejection
 
  Oh, yes. I have to second the ClamAV (or /any/ antivirus, really).
 
 
  On Thu, 16 Sep 2004 11:58:13 -0500, Ken Jones [EMAIL PROTECTED] wrote:
  
  
   On Thursday 16 September 2004 11:40 am, Andrew
  Niemantsverdriet wrote:
I am doing a major upgrade to our mail server and I am looking for
recommendations for programs and qmail patches to limit
  the amount of
spam that gets through. What are you guys using that has
  great success?
  
   I would recommend using an RBL list. Using a check-user patch to
   qmail-smtpd. And using a combination of spamassassin and clamav.
  
   Ken Jones
  
 



Compile vpopmail with  SPAM_THRESHOLD=10 and any message scored at 10.0 or
above will not be delivered.

Jon



Re: [vchkpw] Recomendations for best spam rejection

2004-09-16 Thread Jon LaBass
 Jon LaBass wrote:

 snip

 
  Compile vpopmail with  SPAM_THRESHOLD=10 and any message scored at 10.0
or
  above will not be delivered.
 
  Jon

 I just upgraded four servers this morning to 5.4.6, that is not a
 configure option that I know of. What vpopmail do you use?

 DAve

 -- 
 Systems Administrator
 http://www.tls.net
 Get rid of Unwanted Emails...get TLS Spam Blocker!



Well, I use vpopmail on FreeBSD and that's how you define it with the ports.
After I wrote that I thought Doh!  Not everybody is using bsd so that
option may not be available.  But, on other systems where you have to
manually compile vpopmail, the option --enable-spam-threshold=10 should
work.



Re: [vchkpw] www.qmailrocks.org - was: Re: [vchkpw] RE: good howto

2004-07-16 Thread Jon Reynolds
Quoting Bruno Negrão [EMAIL PROTECTED]:

 
 
  www.qmailrocks.org
 Hey, this website is incredible useful! Awesome!!!
 
 How isn't it mentioned on www.qmail.org website?!
 
 bruno
 
 
  That's all you need.
  
  -Original Message-
  From: Michiels Tom (Uptime) [mailto:[EMAIL PROTECTED] 
  Sent: 15 July 2004 10:38
  To: [EMAIL PROTECTED]
  Subject: good howto
  
  
  Can somebody point me to a good howto for installing and configuring
  vpopmail together with squirrelmail/qmail/antispam/antivirus on a Debian
  machine ?
  
  thx in advance!
  
  regards
  
  Tom Michiels
  
  
  
  
  
 
I don't know why it isn't listed. The guy that maintains it even updates all the
pkgs just about as soon as they come out. I emailed him after one install and he
emailed me back, so he is paying attention if you have problems. Also, qmail
does rock!

Jon




Re: [vchkpw] Qmail popmail and relay-ctrl problem

2004-05-08 Thread Jon Reynolds
On Sat, 2004-05-08 at 06:16, Paul Theodoropoulos wrote:
 sorry for the double post.
 
 At 07:13 AM 5/8/2004, you wrote:
 At 05:10 AM 5/8/2004, X-Istence wrote:
 Paul Theodoropoulos wrote:
 
 Paul Theodoropoulos
 http://www.anastrophe.com
 
 
 

Your message was posted twice to the same list, please refrain from
doing this. If you don't know what this means go to
www.idontknowwhatthismeans.org or please do not post until you do.

;)

Jon



Re: [vchkpw] moving servers

2004-01-24 Thread Jon Reynolds
On Fri, 2004-01-23 at 15:53, Rick Widmer wrote:
 Jon Reynolds wrote:
 
  I am moving from one server to a new and was wondering what I need to do
  to move my users from the old server to the new. I am thinking I need to
  move the /etc/passwd,/etc/master.passwd and /etc/group then move the
  domain directory in /home/vpopmail/domains/domain.
 
 I've done it that way before and it worked.  You could also edit the 
 password and group files to move just the qmail, vpopmail and related 
 lines across.  Less chance of messing up some other part of the system 
 that way.  Make sure you don't duplicate any existing uid/gid values.
 
  Would that work and do I need to make sure that all the uid's and gid's
  match for spamassassin, clamav and the others?
 
 You also want to preserve the uid/gid values on all the files and 
 directories...  or go through all of them and make sure they match when 
 you are done.  (not much fun!)
 

Rick and Rick,

Thanks for the reply, that is exactly what I needed to know.

Well alright, I just woke up about 2 hours ago and have almost finished
this move, dang flu is killing me! 

I have found that all I had to do was move the /home/vpopmail/domains/
folder to the new server. I checked all the users and group ID's and
they were exactly the same on both machines so I didn't need to move the
passwd files or the group files. 

Apparently vpopmail stores it's passwd file inside of the directory of
the domain it is hosting so user passwords are intact from the move. So
what I ended up doing was just to scp the domain folder over and chown
it to the correct uid:gid and restart qmail.

 Was that ever easy!

Thanks for the help and the replies, it's always nice to have someone
holding your hand when you are doing something your not sure of. :)

Jon



[vchkpw] vpopmail(mysql) squirrelmail - user change passwd?

2003-11-13 Thread jon kutassy
Hello List (again),

I've got vpopmail with mysql authentication and courier-imap and 
squirrelmail (thanks Michael Bowe), and I'm wondering the best/most eloquent 
way of allowing users to change their own passwords.

Is anybody doing this already?

I've looked at the squirrelmail plugin for change-mysql-passwd 
(http://www.squirrelmail.org/plugin_view.php?id=25) but that, as far as I 
can tell, is expecting all the logins/passes to be in one table.

mysql stores all the user/passes in seperate tables (one for each domain).

My first thought would be somehow to replicate all the various domain table 
user/passes into one table...

any thoughts?

regards

Jon

_
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile



Re: [vchkpw] TR : [vchkpw] [MySQL] error

2003-11-11 Thread jon kutassy


Perhaps the socket its trying is wrong?

If you try

# mysql -p
# password pass
mysql \s

it should confirm where your mysql is listening.. its sometimes 
/tmp/mysql.sock





-Message d'origine-
De : Tanen [mailto:[EMAIL PROTECTED]
Envoyé : mardi 11 novembre 2003 13:39
À : 'Gary'
Objet : RE : [vchkpw] [MySQL] error


Yes Mysql is running, i see the process on the ps ax

All work fine, i think ... PhPMyAdmin work correctly i can access to all my
database, it want meant MySQL is running correctly no ?
Someone have an idea plz ??

Thanks,

Tanen.



-Message d'origine-
De : Gary [mailto:[EMAIL PROTECTED]
Envoyé : mardi 11 novembre 2003 13:48
À : [EMAIL PROTECTED]
Objet : Re: [vchkpw] [MySQL] error




Hello,

I get a problem when i try to add my domain, with the vadddomain my.domain
my-pass


When the script try to be executed, i get this error message :



:~# /home/vpopmail/bin/vadddomain my.domain

Please enter password for postmaster:

enter password again:

could not connect to mysql update server Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock' (2) with database
could not connect to mysql update server Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock' (2)
vmysql: sql error[c]: MySQL server has gone away

vmysql: sql error[b]: MySQL server has gone away

vmysql: sql error[3]: MySQL server has gone away

vmysql: sql error[c]: MySQL server has gone away

vmysql: sql error[c]: MySQL server has gone away

vmysql: sql error[b]: MySQL server has gone away

vmysql: sql error[3]: MySQL server has gone away

vmysql: sql error[2]: MySQL server has gone away

Error: Unable to chdir to vpopmail/users directory

:~#



I’m on Debian Sarge (Woody upgraded).



Someone can tel me why i get this error and how to correct it plz ?



Best regards,

Tanen.



Looks like mysql died...double check to make sure mysql is running if not
start it up :)


Cheers,



Gary

_
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile



[vchkpw] Resolution: Re: [vchkpw] libvpopmail + squirrelmail/courier-imap

2003-11-11 Thread jon kutassy
Just for list completeness, upgrading from 5.2.1 to 5.3.29 cured my problem. 
Thanks all.

Another link to Michael Bowes documentation: (which is updating behind me as 
I work down the steps!)

http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm

- Original Message -
From: jon kutassy [EMAIL PROTECTED]
 Hello List,

 I've been following Michael Bowe's crib sheet on how to set up
 qmail+vpopmail+mysql+loads+loadsmore
:-)

 Im running vpopmail 5.2.1 .

You should not use vpopmail-5.2.1, it contains some nasty bugs that can
cause unreliable operation of courier-imap (especially if you compiled
courier with --with-authdaemon)
You could either go for vpopmail-5.2.2, or vpopmail-5.3.28

Once you have upgraded your vpopmail, you will also need to go and rebuild
your other add-on apps like qmailadmin and courier-imap, so that they can
link against the updated vpopmail code.
Michael.

_
Find a cheaper internet access deal - choose one to suit you. 
http://www.msn.co.uk/internetaccess




[vchkpw] libvpopmail + squirrelmail/courier-imap

2003-11-10 Thread jon kutassy
Hello List,

I've been following Michael Bowe's crib sheet on how to set up 
qmail+vpopmail+mysql+loads+loadsmore

I'm experiencing a problem with squirrelmail+courier-imap which the imap 
list suggested was down to libvpopmail..

The Problem:

Squirrelmail works fine as long as I'm the only one using it. When more than 
one connection is made, the Squirrelmail drops everyone back to the login 
prompt and no valid user-passwd combinations work.

Restarting courier-imap fixes this temporarily.

The courier-imap list said this was down to libvpopmail and that a very 
latest version of this should cure it.

Im running vpopmail 5.2.1 .

Does the vpopmail list agree that this is the case, and how do I repair it 
if you do. Do I need to re-install the whole vpopmail, ( I was looking at 
5.3.28) or can I just get this libvpopmail on its own?

I can't see that it should be this because Im using the same version as 
Michael Bowe was in his write-up.

Great write-up btw Michael.

Regards
Jon
_
MSN Messenger with backgrounds, emoticons and more. 
http://www.msnmessenger-download.com/tracking/cdp_customize




Re: [vchkpw] libvpopmail + squirrelmail/courier-imap

2003-11-10 Thread jon kutassy
Mine are set to 40 and 40, as per Michaels notes.. will try 512

At 09:00 AM 11/10/2003, jon kutassy wrote:
The Problem:

Squirrelmail works fine as long as I'm the only one using it. When more 
than one connection is made, the Squirrelmail drops everyone back to the 
login prompt and no valid user-passwd combinations work.

Restarting courier-imap fixes this temporarily.
in your courier-imap configuration (normally 
/usr/local/lib/courier-imap/etc/imapd)

what do you have the values set at for:

MAXDAEMONS=
MAXPERIP=
?

I set mine to 512 each. why? squirrelmail connects normally on localhost, 
127.0.0.1. which means a lot of concurrent connections to localhost. If you 
have a small value for those two variables, people will be locked out pretty 
quickly.

Paul Theodoropoulos
http://www.anastrophe.com
_
Find a cheaper internet access deal - choose one to suit you. 
http://www.msn.co.uk/internetaccess




Re: [vchkpw] libvpopmail + squirrelmail/courier-imap

2003-11-10 Thread jon kutassy
No, 512 doesnt make any difference, as soon as I open another browser and 
sign into a different account, the first one fails to the login screen.



Mine are set to 40 and 40, as per Michaels notes.. will try 512

At 09:00 AM 11/10/2003, jon kutassy wrote:
The Problem:

Squirrelmail works fine as long as I'm the only one using it. When more 
than one connection is made, the Squirrelmail drops everyone back to the 
login prompt and no valid user-passwd combinations work.

Restarting courier-imap fixes this temporarily.
in your courier-imap configuration (normally 
/usr/local/lib/courier-imap/etc/imapd)

what do you have the values set at for:

MAXDAEMONS=
MAXPERIP=
?

I set mine to 512 each. why? squirrelmail connects normally on localhost, 
127.0.0.1. which means a lot of concurrent connections to localhost. If you 
have a small value for those two variables, people will be locked out pretty 
quickly.

Paul Theodoropoulos
http://www.anastrophe.com
_
Find a cheaper internet access deal - choose one to suit you. 
http://www.msn.co.uk/internetaccess

_
Sign-up for a FREE BT Broadband connection today! 
http://www.msn.co.uk/specials/btbroadband




[vchkpw] mysql gone away. Please help a noob.

2003-08-19 Thread jon kutassy
I'd like to get vpopmail working with authenticating against mysql... I have 
a working version of mysql that Id rather not break:

Excuse me if I include too much info : Im not sure what is and isnt 
relevent:

mysql  Ver 12.21 Distrib 4.0.14, for pc-linux (i686)
Server version: 4.0.14-standard
Protocol version:   10
Connection: Localhost via UNIX socket
UNIX socket:/var/lib/mysql/mysql.sock
I compiled with ./configure --enable-mysql=y

when I run add domain I get:

Please enter password for postmaster:
enter password again:
could not connect to mysql update server Access denied for user: 
'[EMAIL PROTECTED]' (Using password: YES) with database
could not connect to mysql update server Access denied for user: 
'[EMAIL PROTECTED]' (Using password: YES)
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away

I have a database called vpopmail and a user vpopmail that has (I believe 
got access to this db).. but looking at this error message makes me 
wonder... does  Access denied for user:  mean that the database has been 
found just that its not allowing the user to authenticate?

Im lost..

Regards

Jon

_
Express yourself with cool emoticons - download MSN Messenger today! 
http://www.msn.co.uk/messenger




Re: [vchkpw] mysql gone away. Please help a noob.

2003-08-19 Thread jon kutassy
Thanks for the replies.

I've been following Michael  Bowe's excellent documentation on setting 
this up.

http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm (I hope he 
doesnt mind the link)

I took the windoze approach and restarted mysql, and its all working fine!!

Thanks everyone for your input!!

did you configure for your mysql user/password in vmysql.h?  if not, amend 
the entries and recompile.
also, did you create the tables or check that they were created?
did you allow mysql access from within mysql?
did you 'flush priviledges' to make the privs stick in mysql?

Good luck

jon kutassy wrote:

I'd like to get vpopmail working with authenticating against mysql... I 
have a working version of mysql that Id rather not break:

Excuse me if I include too much info : Im not sure what is and isnt 
relevent:

mysql  Ver 12.21 Distrib 4.0.14, for pc-linux (i686)
Server version: 4.0.14-standard
Protocol version:   10
Connection: Localhost via UNIX socket
UNIX socket:/var/lib/mysql/mysql.sock
I compiled with ./configure --enable-mysql=y

when I run add domain I get:

Please enter password for postmaster:
enter password again:
could not connect to mysql update server Access denied for user: 
'[EMAIL PROTECTED]' (Using password: YES) with database
could not connect to mysql update server Access denied for user: 
'[EMAIL PROTECTED]' (Using password: YES)
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away

I have a database called vpopmail and a user vpopmail that has (I believe 
got access to this db).. but looking at this error message makes me 
wonder... does  Access denied for user:  mean that the database has been 
found just that its not allowing the user to authenticate?

Im lost..

Regards

Jon

_
Express yourself with cool emoticons - download MSN Messenger today! 
http://www.msn.co.uk/messenger




v

_
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile



Re: [vchkpw] configure --enable-mysql=y error : help a noob please?

2003-08-17 Thread jon kutassy
Gents,  Im still trying to set up vpopmail with mysql. I followed Michael's 
exellent instructions below, which (after a re-install of mysql) worked, but 
I broke php/phpmyadmin in the progress.

Ive now got php back and working, but not vpopmail again!

I think its a socket issue, I believe vpopmail is expecting a socket in 
/tmp/mysql.sock:

My socket is here :

mysqladmin  Ver 8.40 Distrib 4.0.14, for pc-linux on i686

Server version  4.0.14-standard
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
How can I get vpopmail to look in the right place?

Regards

Jon

 Im trying to set up vpopmail +mysql + qmail on redhat 9

 I believe I've read the relevent docs, and searched the web :

 when i run ./configure --enable-mysql=y

 I get this error:

 configure: error: unable to find your inc dir, specify --enable-incdir
Hello

Maybe take a look at this guide I wrote :

A QUICK GUIDE TO VPOPMAIL WITH MYSQL
http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm
Michael.

_
Use MSN Messenger to send music and pics to your friends 
http://www.msn.co.uk/messenger




[vchkpw] configure --enable-mysql=y error : help a noob please?

2003-08-14 Thread jon kutassy
Im trying to set up vpopmail +mysql + qmail on redhat 9

I believe I've read the relevent docs, and searched the web :

when i run ./configure --enable-mysql=y

I get this error:

configure: error: unable to find your inc dir, specify --enable-incdir

Now I'd love to be able to do this, but Im not sure what one is...

Regards

Jon

_
Tired of 56k? Get a FREE BT Broadband connection 
http://www.msn.co.uk/specials/btbroadband




[vchkpw] pop auth and relaying

2003-01-21 Thread Jon
I was wondering if there was a way to make vpopmail and qmail only allow 
relaying through the domain that a pop auth has succeeded through.

for example,
I have domain1.com and domain2.com both on my host machine (these are ip 
based hosts and I have used vipmap to add their ip addresses). Now 
currently if a user pop auth's through domain1.com, they are able to relay 
through any domain name or ip address that is bound to the machine. I want 
to limit them to only be able to relay through domain1.com ip address.

Any instructions or documentation on setting this up would be most helpful.

Thank you.


   -Jon Keller




RE: [vchkpw] Vacation Messages *and* redirect

2002-08-27 Thread Jon Coulter

Create a .qmail-user file for that person with the auto-responder line
in it (I'm not sure off the top of my head what that syntax is). If
there is a .qmail-user file in the domain's home directory, then
vpopmail (well qmail, really) ignores the 'real' user, and does whatever
the .qmail file says to do (so it will send the auto respond, and then
never save the message anywhere).

Alternately, you can put this in the
~vpopmail/domains/domain.ext/user/.qmail file:

| /bin/cat /dev/null

This will cause cat to cat /dev/null (which takes no fileio cpu, since
its null and empty), and exits with a clean 0, telling vpopmail that
everything went okay.

There are many ways to do many things, isn't qmail/vpopmail great? :)

Jon Coulter
[EMAIL PROTECTED] 

-Original Message-
From: Phil Dibowitz [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 26, 2002 6:57 PM
To: vchkpw
Subject: [vchkpw] Vacation Messages *and* redirect


Hey all,

I'd like to have a user whose email is redirected to /dev/null, and who
has an 
  auto-responder (vacation message).

I'm not quite sure how to go about this, can someone tell me if it's
possible, 
and maybe tell me how to do it, or point me to a link if it's documented

already...

Thanks,
-- 
Phil Dibowitz [EMAIL PROTECTED]
Freeware and Technical Pages  Insanity Palace of Metallica
http://home.earthlink.net/~jaymzh666/ http://www.ipom.com/

They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety.
  - Benjamin Franklin, 1759




RE: [vchkpw] Vacation Messages *and* redirect

2002-08-27 Thread Jon Coulter

Ah, touché. I knew that an empty file would cause qmail to consider it a
'tmp file', but I never figured that it would treat an comment-line'd
file any different. And my point about not using fileio is that
something like '/bin/cat  /dev/null' would actually have cat reading
from stdin, and print to stdout, where as '/bin/cat /dev/null' would
just tell cat to read /dev/null and print to stdio, and said file is
obviously empty, so very little cpu/fileio :)

Jon Coulter
[EMAIL PROTECTED] 

-Original Message-
From: Peter Palmreuther [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, August 27, 2002 11:57 AM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Vacation Messages *and* redirect


Hello Jon,

On Tuesday, August 27, 2002 at 7:40:18 AM you wrote:

 | /bin/cat /dev/null

 This will cause cat to cat /dev/null (which takes no fileio cpu, since

 its null and empty), and exits with a clean 0, telling vpopmail that 
 everything went okay.

It will create a process and therefor use fileIO and CPU, as it has to
look for '/bin/cat', read the file and execute it; therefore reserve
memory, etc. etc. etc ...

Why not doing it the 'qmail-way'???

$cat .qmail-emtpy
#

This will make qmail-local ignore the line as it is 'only' a comment,
but not take any further steps for delivering the mail, as one valid
instruction (the dot-qmail-file) was found. No need to spawn additional
processes or doing some really nifty stuff to make simple thing look
really complicated done by a simple instruction :-)
-- 
Best regards
Peter Palmreuthermailto:[EMAIL PROTECTED]




FW: [vchkpw] Vacation Messages *and* redirect

2002-08-27 Thread Jon Coulter

'tmp file'... I meant to say 'tmp fail' ;p

Jon Coulter
[EMAIL PROTECTED] 

-Original Message-
From: Jon Coulter [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, August 27, 2002 2:47 PM
To: [EMAIL PROTECTED]
Subject: RE: [vchkpw] Vacation Messages *and* redirect


Ah, touché. I knew that an empty file would cause qmail to consider it a
'tmp file', but I never figured that it would treat an comment-line'd
file any different. And my point about not using fileio is that
something like '/bin/cat  /dev/null' would actually have cat reading
from stdin, and print to stdout, where as '/bin/cat /dev/null' would
just tell cat to read /dev/null and print to stdio, and said file is
obviously empty, so very little cpu/fileio :)

Jon Coulter
[EMAIL PROTECTED] 

-Original Message-
From: Peter Palmreuther [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, August 27, 2002 11:57 AM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Vacation Messages *and* redirect


Hello Jon,

On Tuesday, August 27, 2002 at 7:40:18 AM you wrote:

 | /bin/cat /dev/null

 This will cause cat to cat /dev/null (which takes no fileio cpu, since

 its null and empty), and exits with a clean 0, telling vpopmail that
 everything went okay.

It will create a process and therefor use fileIO and CPU, as it has to
look for '/bin/cat', read the file and execute it; therefore reserve
memory, etc. etc. etc ...

Why not doing it the 'qmail-way'???

$cat .qmail-emtpy
#

This will make qmail-local ignore the line as it is 'only' a comment,
but not take any further steps for delivering the mail, as one valid
instruction (the dot-qmail-file) was found. No need to spawn additional
processes or doing some really nifty stuff to make simple thing look
really complicated done by a simple instruction :-)
-- 
Best regards
Peter Palmreuthermailto:[EMAIL PROTECTED]




RE: [vchkpw] Vpopmail/qmail spam filter using SpamAssassin (and other stuff)

2002-08-26 Thread Jon Coulter

Requires a patch (QMAILQUEUE patch). Besides, I wasn't saying that they
were all bad. Just needlessly complex, and usually don't follow in the
qmail methodologies

Jon Coulter
[EMAIL PROTECTED] 

-Original Message-
From: Iain [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 26, 2002 1:23 AM
To: Jon Coulter; [EMAIL PROTECTED]
Subject: Re: [vchkpw] Vpopmail/qmail spam filter using SpamAssassin (and
other stuff)


On Mon, 26 Aug 2002 03:20, Jon Coulter wrote:
 Out of my pure hatred for spam, love for qmail/vpopmail/perl, and 
 dislike of the complexity of all current 'spam filtering' 
 implementations for qmail (and/or vpopmail), I decided to write my own

 perl app to do all the things I wanted (and more) when filtering 
 email.


What's wrong with qmail-scanner ?

-- 
PGP info: http://www.myspinach.org/~iain/pgpinfo.html




[vchkpw] Vpopmail/qmail spam filter using SpamAssassin (and other stuff)

2002-08-25 Thread Jon Coulter

Out of my pure hatred for spam, love for qmail/vpopmail/perl, and
dislike of the complexity of all current 'spam filtering'
implementations for qmail (and/or vpopmail), I decided to write my own
perl app to do all the things I wanted (and more) when filtering email.

Using procmail and the standard spamassassin methods required patches
for qmail (seekable patch) and all kinds of other ridicules setup, and
then still didn't work with vpopmail (at least I couldn't get it to). So
I thought, Why are we hacking up source codes and changing how stuff is
processed to accomplish this? After all, qmail's mentality is chaining
programs together to complete the task, so why don't we filter this
way?

So here is my spam-filter.pl script, been in production for quite some
time with me, and I haven't had any problems. There is quite detailed
usage file ( http://www.ledscripts.com/dev/install.txt ) plus reading
the source itself will likely tell you a lot. Anyhow, you can get it at:

http://www.ledscripts.com/dev/vpopmail-spam-filter.html

Please try and comment. I really think its implementations like this
that will finally help some of us clean up our mailboxes :)

By the way, this is not something that should be used on a heavy-load
machine. If interest is high enough, I'll do something similar to what
the spamassassin people did with spamd/spamc.

Anyway, good luck!

Jon Coulter
[EMAIL PROTECTED]