Re: [vchkpw] maildrop with bounce-no-mailbox

2004-07-15 Thread Jay Tortorelli
 so, how do you do it?
 use the chkuser patch for qmail, so no illegal users get into the queue?
 write a wrapper for vpopmail so that it exits 0 even when the user 
 doesn't exist?
 use some hack for maildrop??

I am also having the same problems.  I hadn't noticed it until my queue
was over 30,000 messages.  I haven't had the time to work out a real
solution yet.  I didn't know if it was better to hack maildrop or hack
vdelivermail since I haven't even looked into either one of them yet. 
What I had found was that one of my domains was receiving thousands of
messages per hour for non-existent users and bouncing back.  So as a
quick fix, I set the default to delete, I shortened the queuelifetime to
3 days, and increased the concurrency settings because they were
constantly maxed out.

I'd also like to hear what real solutions people have come up with to
deal with this.



Re: [vchkpw] vpopmail / postgres config issues

2004-07-02 Thread Jay Tortorelli
On Thu, 2004-07-01 at 18:50, Darius Wei wrote:
 OK, I'm trying to configure vpopmail 5.4.6 with postgres 7.4.1.  The 
 compilation process seems to work fine, but I can't get a connection to 
 the database when actually running the tools. 

In vpgsql.h there are a couple of lines that need editing:

#define DB NAME_OF_YOUR_DATABASE
#define PG_CONNECT host=YOUR_DB_HOST_NAME user=YOUR_DB_USERNAME
password=YOUR_PASSWORD dbname= DB

Although I don't think host is in there as a default.  But if your
database server is on a different server you will need to add that.

Hope that helps.

Jay Tortorelli



Re: [vchkpw] SATA NAS for vpop cluster

2004-06-30 Thread Jay Tortorelli
On Wed, 2004-06-30 at 08:36, Rainer Duffner wrote:

 NetApp is really the high-end of storage, but also from a price-viewpoint.
 But if you have enough customers and/or pretty strict SLAs, there's 
 hardly a choice, unless you want to gamble ;-)

 The clustering-software  is very expensive - and you've got to buy a 2nd 
 NetApp, too. ;-)

I'll chime in a say that I have had great success setting up
Qmail/Vpopmail/etc that stores on an nfs mount from a two machine mirror
using drbd/heartbeat to provide mirroring and failover.
http://www.drbd.org/

Using commodity hardware, it really does save you a lot of money over
the Netapps with clustering and I wouldn't even consider it a
gamble...just based on my experiences.

Jay



Re: [vchkpw] Anyone using 5.5.x in production?

2004-06-14 Thread Jay Tortorelli
On Thu, 2004-06-10 at 22:01, Tom Collins wrote:
 Can anyone report on performance of the MySQL and/or Postgres
 backendsin 5.5.0 or later on a production machine?  I made some
 significantchanges related to building SQL queries which should make
 them moresecure.  I also fixed some outstanding bugs in Postgres code
 andconsolidated some code in MySQL and Postgres.

I have been using 5.5.0 in production for about a month with the
Postqresql back end.  So far it has held up very well and have not had
any performance/stability problems.

I remember I had some problems in the beginning...but I didn't send them
to the list because previous messages regarding the use of the
Postgresql back end had went unanswered.

Looking through my notesI had problems with --enable-pgsql-logging
and --enable-valias

--enable-pgsql-logging I remember, never created the appropriate
table(s).  When I created the table(s) by hand, it still would not log
anything to it.

--enable-valias  I can't remember exactly what the problem was here as I
didn't keep very good notes.  I remember I had a problem with the 5.4.x
series as well, but I would receive a different error.  I couldn't
create an alias that would be delivered to 2 different accounts.  And I
remember in the 5.5.x series, if I tried to use valias with the -s
switch to look up an alias it would just print out the destination
address over and over again until I sent it a ctrl-c.  I believe if it
didn't do that it would segfault.

Sorry I do not have more specifics for you.

My current configure line is:

/configure --enable-clear-passwd --enable-logging=p
--enable-learn-passwords --enable-qmail-ext --enable-auth-module=pgsql




[vchkpw] Getting Error: Could not open qmail default on vadddomain

2004-04-28 Thread Jay Tortorelli
I have a fresh install of RHEL ES 3 Update 1, netqmail 1.05, and
vpopmail 5.4.3 and am receiving:
Error: Could not open qmail default
whenever I run vadddomain as root

Here are my configure options:
./configure --enable-clear-passwd --enable-qmail-ext
--enable-domains-dir=/mail/domains --enable-qmaildir=/mail/
--enable-qmail-newu=/var/qmail/bin/qmail-newu
--enable-qmail-inject=/var/qmail/bin/qmail-inject
--enable-qmail-newmrh=/var/qmail/bin/qmail-newmrh
--enable-auth-module=pgsql --enable-logging=p --enable-pgsql-logging
--enable-valias --enable-learn-passwords


I have my qmail control and user/assign directories in /mail  I also
have them sym linked in /var/qmail as I was getting an error when I
would try and run vdominfo earlier saying it couldn't open
/var/qmail/users/assign (not sure why it was looking there when I did
declared the qmail dir in configure).

I changed the PG_CONNECT and DB entries in vpgsql.h to reflect the
settings for my remote host before I configured.

Vpopmail has created the dir_control table and made 1 entry in it so I
know that the connection to the database server is working correctly.

The permissions on my vpopmail home dir are:
drwx--8 vpopmail vchkpw   4096 Apr 28 20:41 .
drwxr-xr-x6 root root 4096 Apr 28 15:26 ..
-rw---1 vpopmail vchkpw334 Apr 27 18:54 .bash_history
-rw-r--r--1 vpopmail vchkpw 24 Apr 26 19:34 .bash_logout
-rw-r--r--1 vpopmail vchkpw191 Apr 26 19:34 .bash_profile
-rw-r--r--1 vpopmail vchkpw124 Apr 26 19:34 .bashrc
drwxr-xr-x2 vpopmail vchkpw   4096 Apr 28 19:02 bin
drwxr-xr-x4 vpopmail vchkpw   4096 Apr 27 15:39 doc
drwxr-xr-x2 vpopmail vchkpw   4096 Apr 27 15:39 etc
drwxr-xr-x2 vpopmail vchkpw   4096 Apr 28 19:02 include
drwxr-xr-x2 vpopmail vchkpw   4096 Apr 28 19:02 lib
drwx--3 vpopmail vchkpw   4096 Apr 27 15:39 mail


The permissions on /mail are:
drwxr-xr-x5 root root 4096 Apr 28 18:31 .
drwxr-xr-x   23 root root 4096 Apr 26 17:47 ..
drwxr-xr-x2 root qmail4096 Apr 26 18:35 control
drwx--2 vpopmail vchkpw   4096 Apr 28 20:28 domains
drwxr-xr-x2 root qmail4096 Apr 28 19:06 users


I have no other domains setup on this machine yet.  If I manually create
the directory inside of domains and then run vadddomain mydomain.com
password it deletes the directory I created and gives me the same error.

I have tried reinstalling vpopmail a few times and continue to get the
same error.

Thank you for your time,
Jay Tortorelli



Re: [vchkpw] skel

2003-11-06 Thread Jay Tortorelli
On Thu, 2003-11-06 at 04:34, Raboo Treed wrote:
 Isn't there a way to have like a /etc/skel but for vpopmail users
 
 like a skel with a  dot qmail file and some extra imap folders and such?
 
 if not that would be a great feutre request..

Below is a copy of an email and patch submitted by David Winkler back in
September to handle just that.

--enable-vpopmail-skel=y



Hello again,

I seem to have answered my own question. Here
is my unified diff against cvs if anyone is interested.

Enjoy!

David

Index: vpopmail.c
===
RCS file: /cvsroot/vpopmail/vpopmail/vpopmail.c,v
retrieving revision 1.2
diff -u -r1.2 vpopmail.c
--- vpopmail.c  14 Sep 2003 22:17:30 -  1.2
+++ vpopmail.c  23 Sep 2003 19:12:45 -
@@ -1655,6 +1655,7 @@
  struct vqpasswd *mypw;
  char calling_dir[MAX_BUFF];
  char domain_dir[MAX_BUFF];
+ char tmpbuf[MAX_BUFF];
 
   verrori = 0;
   /* record the dir where the command was run from */
@@ -1701,6 +1702,7 @@
 return(NULL);
   }
 
+#ifndef ENABLE_VPOPMAIL_SKEL
   if (mkdir(Maildir,VPOPMAIL_DIR_MODE) == -1){ 
 /* back out of changes made above */
 chdir(domain_dir); chdir(user_hash); vdelfiles(username);
@@ -1743,6 +1745,12 @@
 
   /* set permissions on the user's dir */
   chdir(../..);
+#else
+  sprintf(tmpbuf, cp -rf %s/etc/skel/* %s/%s,
VPOPMAILDIR,domain_dir,username);
+  system(tmpbuf);
+  chdir(../);
+#endif
+
   r_chown(username, uid, gid);
 
   /* see if the user already exists in the auth backend */
Index: acconfig.h
===
RCS file: /cvsroot/vpopmail/vpopmail/acconfig.h,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 acconfig.h
--- acconfig.h  10 Sep 2003 20:43:14 -  1.1.1.1
+++ acconfig.h  23 Sep 2003 19:12:45 -
@@ -1,3 +1,5 @@
+#undef ENABLE_VPOPMAIL_SKEL
+
 #undef PS_COMMAND
 
 #undef ENABLE_PASSWD
Index: Makefile.am
===
RCS file: /cvsroot/vpopmail/vpopmail/Makefile.am,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 Makefile.am
--- Makefile.am 10 Sep 2003 20:43:12 -  1.1.1.1
+++ Makefile.am 23 Sep 2003 19:12:45 -
@@ -94,6 +94,12 @@
  $(DESTDIR)@vpopmaildir@/@domains_dir@
 
$(INSTALL) -d $(DESTDIR)@vpopmaildir@/etc
+   $(INSTALL) -d $(DESTDIR)@vpopmaildir@/etc/skel
+   $(INSTALL) -d $(DESTDIR)@vpopmaildir@/etc/skel/Maildir
+   $(INSTALL) -d $(DESTDIR)@vpopmaildir@/etc/skel/Maildir/new
+   $(INSTALL) -d $(DESTDIR)@vpopmaildir@/etc/skel/Maildir/cur
+   $(INSTALL) -d $(DESTDIR)@vpopmaildir@/etc/skel/Maildir/tmp
+
echo [EMAIL PROTECTED]@/include  @vpopmaildir@/etc/inc_deps
echo [EMAIL PROTECTED]@/lib -lvpopmail @auth_libs@ 
@vpopmaildir@/etc/lib_deps
 
Index: configure.in
===
RCS file: /cvsroot/vpopmail/vpopmail/configure.in,v
retrieving revision 1.1.1.1
diff -u -r1.1.1.1 configure.in
--- configure.in10 Sep 2003 20:43:11 -  1.1.1.1
+++ configure.in23 Sep 2003 19:12:45 -
@@ -342,6 +342,23 @@
  ;;
 esac
 
+AC_ARG_ENABLE(vpopmail-skel,   
+ [ --enable-vpopmail-skel=y|nTurn on (y) or off (n,
default) to use
+vpopmail skeleton for new users.],
+ ENABLE_VPOPMAIL_SKEL=$enableval,
+ [
+ ENABLE_VPOPMAIL_SKEL=n
+ ])
+ 
+case $ENABLE_VPOPMAIL_SKEL in
+1*|y*|Y*)
+  ENABLE_VPOPMAIL_SKEL=1
+
AC_DEFINE_UNQUOTED(ENABLE_VPOPMAIL_SKEL,$ENABLE_VPOPMAIL_SKEL)
+  ;;
+*)
+  ;;
+esac
+
 AC_ARG_ENABLE(md5-passwords,
 [  --enable-md5-passwords=y|n   Turn on (y default ) or off (n)
to store encrypted passwords as md5.],
 ENABLE_MD5_PASSWORDS=$enableval,
@@ -1315,6 +1332,15 @@
  ;;
 esac
 
+case $ENABLE_VPOPMAIL_SKEL in
+1*|y*|Y*)
+echo  vpop skel = ON  --enable-vpopmail-skel=y
+echo  --enable-vpopmail-skel=y \\  vpopmail.config.sh
+  ;;
+*)  
+echo  vpop skel = OFF --enable-vpopmail-skel=n (default)
+  ;;
+esac
 
 case $ENABLE_LOGGING in
 1*|y*|Y*)




Re: [vchkpw] Postgres support?

2003-03-25 Thread Jay Tortorelli
On Tue, 2003-03-25 at 07:53, Ken Jones wrote:
 There already is a working postgres module in vpopmail.
 Looks like it's not built into the configure script.

Yup, since I wrote that email (Jan 14th) Andrew Kohlsmith made some
changes that made it into 5.3.17.  He mentioned that there was some work
that still needed to be done on it.

Charles Boening wrote the code to get postgres support using configure
and posted it to http://www.cot.net/~charlieb/vpopmail/ but I haven't
seen mention of it making it into a development release yet.

I will be upgrading my mail servers again in a month or two, and will
move to postgres, so I might do a little hacking to it as well.

Jay






RE: [vchkpw] Postgres support?

2003-01-14 Thread Jay Tortorelli
I for one am very interested in postgresql support in vpopmail and have
been quietly waiting for it.  I had even inquired about the cost of
finishing up the work on this list, but received no replies.  Since then
I have setup mysql, but would still like to use postgresql someday.

If there is anything I can do to help out, let me know.

Jay Tortorelli

 -Original Message-
 From: Charles J. Boening [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 14, 2003 4:30 PM
 To: 'Caffeinate The World'
 Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: RE: [vchkpw] Postgres support?
 
 I had done some finishing work with the code that Nels wrote and am
 currently running vpopmail 5.3.4 in a production environment with a
little
 over 1000 users.  It works very well with no hangups that I have
noticed.
 
 I submitted the code to the vpopmail developers back around May or
April
 of
 2002.  Since then there has been little interest from the vpopmail
 community
 for postgresql support and the vpopmail development team.
 
 From the looks of it, postgresql support will not be making it into
 vpopmail
 unless someone makes patches for every release.
 
 I still have the code and would like to see it integrated into
vpopmail.
 I
 don't know much about autoconf and haven't had the time to learn or
I'd do
 that part myself.  I think that's about all that needs to be done.
Once
 autoconf knows about postgresql, the make file should be generated
 properly
 and we'd have postgresql support.
 
 Feel free to contact me off list if you'd like to discuss this
further.
 
 
 Charlie
 
 
 
 -Original Message-
 From: Caffeinate The World [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 13, 2003 9:49 AM
 To: [EMAIL PROTECTED]
 Subject: Re: [vchkpw] Postgres support?
 
 
 
 --- Andrew Kohlsmith [EMAIL PROTECTED] wrote:
  Back in April of last year I'd asked about Postgres support in
  vpopmail and Bill had mentioned that it was in the development
  version.  Has that been
  abandoned altogether?  I didn't see it in the current stable
release,
  and
  there's been a few releases between 04/02 and now.  :-)
 
 I checked with the guy who did the original Postgresql patch, but he
 hacked
 together the Configure files etc to make it compile. He has not done
any
 work on it and someone else seemed to have taken over the work.
 
 What I ended up doing was using qmail-sql available at:
 
   http://qmail-sql.digibel.be
 
 Then I patched courier-imap for configurable custom SELECT and UPDATE
SQL
 queries for use with IMAP and POP3. I sent the patch back to Sam
(author
 of
 Courier).
 
 Courier IMAP SQL uses its own table schema which is different from
 qmail-sql. Having customizable SELECT and UPDATE queries allow you to
 glue
 the two together.
 
 __
 Do you Yahoo!?
 Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
 http://mailplus.yahoo.com