[vchkpw] vpopmail-5.4.0-rc2 - Mysql valias not working

2004-01-20 Thread Jeff Koch
I just compiled and installed vpopmail-5.4.0-rc2 with mysql support for 
users and aliases. Using the valias command the mysql valias table is not 
being created and populated. the vpopmail, lastauth and dir-control tables 
seem OK.

Here's the configuration report:

   vpopmail 5.4.0-rc2
Current settings
---
vpopmail directory = /home/vpopmail
   uid = 89
   gid = 89
 roaming users = OFF --disable-roaming-users (default)
 password learning = OFF --disable-learn-passwords (default)
 md5 passwords = ON  --enable-md5-passwords (default)
  file locking = ON  --enable-file-locking (default)
vdelivermail fsync = OFF --disable-file-sync (default)
 make seekable = ON  --enable-make-seekable (default)
  clear passwd = ON  --enable-clear-passwd (default)
 user dir hashing  = ON  --enable-users-big-dir (default)
address extensions = OFF --disable-qmail-ext (default)
  ip alias = OFF --disable-ip-alias-domains (default)
 domain quotas = OFF --disable-domainquotas (default)
   auth module = mysql --enable-auth-module=mysql
 mysql replication = OFF --disable-mysql-replication (default)
 mysql logging = ON  --enable-mysql-logging
  mysql limits = OFF --disable-mysql-limits (default)
  MySQL valias = ON  --enable-valias
  auth inc = -I/usr/include/mysql
  auth lib = -L/usr/lib/mysql  -lmysqlclient -lz
  system passwords = OFF --disable-passwd (default)
pop syslog = log success and errors including passwords
 --enable-logging=v
  auth logging = ON  --enable-auth-logging (default)
all domains in one SQL table = --enable-many-domains (default)
Am I missing something or is mysql valias support broken?



Best Regards,

Jeff Koch, Intersessions 




[vchkpw] Courier-imap + vpopmail-5.4.0-rc2 + Roaming success

2004-01-20 Thread Shane Chrisp
Just letting the list know that I have managed to get the roaming users
working with the vpopmail-5.4.0-rc2 and courier-imap-2.2.2.20040118
version of courier on a redhat 7.3 box.

I noticed a post earlier saying that valias in MySQL wasn't working, however
all of mine are working still as they did before.

My compile time options for vpopmail were:

./configure  --enable-rebuild-tcpserver-file=n --enable-roaming-users=y
--enable-defaultquota=20971520S --enable-auth-module=mysql
--enable-file-sync=n --enable-mysql-logging=y --enable-learn-passwords=y
--enable-clear-passwd=y --enable-valias=y --enable-mysql-limits=y
--enable-logging=v --enable-relay-clear-minutes=15

My courier options were:

./configure --with-trashquota --without-authpwd --without-authshadow
--without-authpam --without-authuserdb --without-authcram --without-authldap
--without-authmysql --without-authpgsql --without-authcustom
--without-authdaemon --disable-root-check --with-redhat

At first compile with vpopmail-5.4.0-rc1 I was getting the problem with the
formatting of ip addresses in the relay table such as :::111.222.333
being put into the table. After a compile and install of vpopmail-5.4.0-rc2
and a make clean, configure and make/make install of courier again, all
is working as expected.

Shane



Re: [vchkpw] Courier-imap + vpopmail-5.4.0-rc2 + Roaming success

2004-01-20 Thread Michael Bowe
- Original Message - 
From: Shane Chrisp [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 8:59 PM
Subject: [vchkpw] Courier-imap + vpopmail-5.4.0-rc2 + Roaming success


 Just letting the list know that I have managed to get the roaming users
 working with the vpopmail-5.4.0-rc2 and courier-imap-2.2.2.20040118
 version of courier on a redhat 7.3 box.

Ahh good stuff!

That courier-imap-2.2.2.20040118 build has got the 2nd and final update
that I sent Mr Sam, as as far as I know all the security problems / bugs etc
are now resolved.

Michael.



[vchkpw] autocreate and autodelete?

2004-01-20 Thread Teixeira (listas)
I saw vpopmail 5.4.0 has fixed an autocreate feature.

I didn't even know it was possible.

The question is. I understand that the autocreation creates the user
directory if it encounters a record in the auth db. But what can I do if
I want to delete a user and it's dir without having to run vdeluser?

-- 
[] Mauricio Teixeira - MaceiĆ³/AL/Brazil
[] * Este e-mail serve apenas para listas!!! *
[] * This e-mail is for mailing lists only!!! *



RE: [vchkpw] autocreate and autodelete?

2004-01-20 Thread Shane Chrisp
There is a tool called vdeloldusers that can be used to delete users who
havnt accessed their mailbox in xx number of days. eg: 

*/5 * * * * /home/vpopmail/bin/vdeloldusers -a 360 -e -D  /dev/null 2
/dev/null

runs from crontab and tells the tool to delete users that havnt auth'd
in the last 360 days.

Shane

-Original Message-
From: Mauricio Teixeira (listas) [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 20 January 2004 7:20 PM
To: vpopmail list
Subject: [vchkpw] autocreate and autodelete?

I saw vpopmail 5.4.0 has fixed an autocreate feature.

I didn't even know it was possible.

The question is. I understand that the autocreation creates the user
directory if it encounters a record in the auth db. But what 
can I do if
I want to delete a user and it's dir without having to run vdeluser?

-- 
[] Mauricio Teixeira - MaceiĆ³/AL/Brazil
[] * Este e-mail serve apenas para listas!!! *
[] * This e-mail is for mailing lists only!!! *





Re: [vchkpw] Re: spamassassin patch ready ahead of schedule

2004-01-20 Thread Ken Jones
On Monday 19 January 2004 5:47 pm, Thomas Smith wrote:
 Ken Jones writes:
  On Saturday 17 January 2004 6:03 pm, Raboo Treed wrote:
  is this a feature that will be added to vpopmail permantly??
 
  if not now it should be in contrib on the stable i think
 
  Yep, it will be added permanently.

 Two questions:

 1) Does this patch effect custom .qmail-default files? Or any other .qmail
 or .mailfilter files?

No .qmail files are effected. vdelivermail calls the spamc program
instead of having a .qmail file call spamc. 


 2) I saw on a previous post that spam filtering can be disabled for a
 specific user, but what about for an entire domain?

There is no mechanism to turn off a whole domain except setting
the NO_SPAMFILTER flag for each user. Nor is there a method
for automatically having it turned off when a new user is added.

We migth want to use the next bit flag in the pw_gid(pw_flags) field
to enable automatically deleting the email if hit the email is marked 
as spam. 

Ken Jones


Re: [vchkpw] enable-file-sync

2004-01-20 Thread Ken Jones
On Monday 19 January 2004 11:30 pm, Jeff Koch wrote:
 Could someone please explain the purpose of the following configure option
 in vpopmail:

--enable-file-sync Enable file sync after each message is
 delivered

 We're having file system corruption problems with qmail/vpopmail (IDE hard
 disk, ext3 file system) and are wondering if this might help. Is there a
 downside to using this option?

That might help. I put the option in for exactly this type of reason.
Instead of calling fsync after the delivery it lets the OS manage
the disk buffering. You might also want to comment out the fsync's
in the qmail source code. These two changes will let the OS manage
the disk buffers instead of flushing them all the time. You'll get
much better disk performance.

Ken Jones



Re: [vchkpw] enable-file-sync

2004-01-20 Thread Marcin Soltysiak
  Could someone please explain the purpose of the following configure
option
  in vpopmail:
 
 --enable-file-sync Enable file sync after each message is
  delivered
 
  We're having file system corruption problems with qmail/vpopmail (IDE
hard
  disk, ext3 file system) and are wondering if this might help. Is there a
  downside to using this option?

 That might help. I put the option in for exactly this type of reason.
 Instead of calling fsync after the delivery it lets the OS manage
 the disk buffering. You might also want to comment out the fsync's
 in the qmail source code. These two changes will let the OS manage
 the disk buffers instead of flushing them all the time. You'll get
 much better disk performance.

Ok. But when it is up to OS? when the option is enabled or disabled?

 I've just upgraded to current RC and got quite a load (about 9-10) caused
by vdelivermai and vmstat suggests that I got IO bottleneck now. Besides I
see lots of vdelivermail running and every mail spends now lots of time in a
queue, even when it is local.

Any ideas, please?

Solt

PS Ken, sorry about two copies of this mail. BTW: Could you set default
Reply-To: to list address? It would be easier when replying.



Re: [vchkpw] Courier-imap + vpopmail-5.4.0-rc2 + Roaming success

2004-01-20 Thread Jeff Koch
Hi Shane:

We weren't able to get the MySQL alias table to be created and populated by 
./valias commands. The only significant difference in our configuration was 
that we did not use mysql-limits.

At 04:59 AM 1/20/2004, you wrote:
Just letting the list know that I have managed to get the roaming users
working with the vpopmail-5.4.0-rc2 and courier-imap-2.2.2.20040118
version of courier on a redhat 7.3 box.
I noticed a post earlier saying that valias in MySQL wasn't working, however
all of mine are working still as they did before.
My compile time options for vpopmail were:

./configure  --enable-rebuild-tcpserver-file=n --enable-roaming-users=y
--enable-defaultquota=20971520S --enable-auth-module=mysql
--enable-file-sync=n --enable-mysql-logging=y --enable-learn-passwords=y
--enable-clear-passwd=y --enable-valias=y --enable-mysql-limits=y
--enable-logging=v --enable-relay-clear-minutes=15
My courier options were:

./configure --with-trashquota --without-authpwd --without-authshadow
--without-authpam --without-authuserdb --without-authcram --without-authldap
--without-authmysql --without-authpgsql --without-authcustom
--without-authdaemon --disable-root-check --with-redhat
At first compile with vpopmail-5.4.0-rc1 I was getting the problem with the
formatting of ip addresses in the relay table such as :::111.222.333
being put into the table. After a compile and install of vpopmail-5.4.0-rc2
and a make clean, configure and make/make install of courier again, all
is working as expected.
Shane
Best Regards,

Jeff Koch, Intersessions 




Re: [vchkpw] enable-file-sync

2004-01-20 Thread Tom Collins
On Jan 20, 2004, at 7:57 AM, Marcin Soltysiak wrote:
PS Ken, sorry about two copies of this mail. BTW: Could you set 
default
Reply-To: to list address? It would be easier when replying.
I second that request.  With the latest QmailAdmin, it's easy to do...

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] vpopmail-5.4.0-rc2 - Mysql valias not working

2004-01-20 Thread Tom Collins
On Jan 20, 2004, at 12:54 AM, Jeff Koch wrote:
I just compiled and installed vpopmail-5.4.0-rc2 with mysql support 
for users and aliases. Using the valias command the mysql valias table 
is not being created and populated. the vpopmail, lastauth and 
dir-control tables seem OK.
I just ran a test, and the valias table was created.

If there's an error creating the table, valias should print it out.  
What happens when you run

valias -i [EMAIL PROTECTED] [EMAIL PROTECTED]

It should create a table called valias...  Do vuserinfo and vadduser 
work?

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] Re: spamassassin patch ready ahead of schedule

2004-01-20 Thread Jeff Koch
Hi Ken:

Is this going to be coordinated with qmailadmin? Currently we use 
qmailadmin to add some mail filtering code that calls spamc. Qmailadmin 
also has the Spam Detection enable box at the bottom. Will the patch 
interfere with this.

We also, store the user spam prefs in a MySQL table - will this continue to 
work?

Also, will this patch now allow spam filtering of mail delivered to remote 
forwards?

Thanks,

At 09:32 AM 1/20/2004, you wrote:
On Monday 19 January 2004 9:43 pm, Jeff Koch wrote:
 Is there an explanation of what this patch does somewhere?
Not yet. It's fairly simple. It adds a new configuration option
--enable-spamassassin. Then the vdelivermail program will
call the spamc program with the right options unless the users
no-spamassassin flag is turned on. spamd will then check
if the user has a .spamassassin/user_prefs file or use the
default settings for the server. Also adds a vmoduser -f option
to turn off spam assassin for any one user.
Best Regards,

Jeff Koch 




Re: [vchkpw] Re: spamassassin patch ready ahead of schedule

2004-01-20 Thread Ken Jones
Well, if you like how your system works now, then
don't use the --enable-spamain change. 


On Tuesday 20 January 2004 10:01 am, Jeff Koch wrote:
 Hi Ken:

 Is this going to be coordinated with qmailadmin? Currently we use
 qmailadmin to add some mail filtering code that calls spamc. Qmailadmin
 also has the Spam Detection enable box at the bottom. Will the patch
 interfere with this.

 We also, store the user spam prefs in a MySQL table - will this continue to
 work?

 Also, will this patch now allow spam filtering of mail delivered to remote
 forwards?

 Thanks,

 At 09:32 AM 1/20/2004, you wrote:
 On Monday 19 January 2004 9:43 pm, Jeff Koch wrote:
   Is there an explanation of what this patch does somewhere?
 
 Not yet. It's fairly simple. It adds a new configuration option
 --enable-spamassassin. Then the vdelivermail program will
 call the spamc program with the right options unless the users
 no-spamassassin flag is turned on. spamd will then check
 if the user has a .spamassassin/user_prefs file or use the
 default settings for the server. Also adds a vmoduser -f option
 to turn off spam assassin for any one user.

 Best Regards,

 Jeff Koch



Re: [vchkpw] Re: spamassassin patch ready ahead of schedule

2004-01-20 Thread Ken Jones
On Tuesday 20 January 2004 10:01 am, Jeff Koch wrote:
 Hi Ken:

 Is this going to be coordinated with qmailadmin? 
Yes. Eventually

 Currently we use
 qmailadmin to add some mail filtering code that calls spamc. Qmailadmin
 also has the Spam Detection enable box at the bottom. Will the patch
 interfere with this.
No, if you like how things are working now, dont use --enable-spamassassin
with vpopail.


 We also, store the user spam prefs in a MySQL table - will this continue to
 work?
Sure.


 Also, will this patch now allow spam filtering of mail delivered to remote
 forwards?
Yes, but not if the forward is done with a .qmail-user file in the main
directory, since qmail-inject will be forwarding it. But if it's a users
.qmail file then it will filter it.

Ken Jones


 Thanks,

 At 09:32 AM 1/20/2004, you wrote:
 On Monday 19 January 2004 9:43 pm, Jeff Koch wrote:
   Is there an explanation of what this patch does somewhere?
 
 Not yet. It's fairly simple. It adds a new configuration option
 --enable-spamassassin. Then the vdelivermail program will
 call the spamc program with the right options unless the users
 no-spamassassin flag is turned on. spamd will then check
 if the user has a .spamassassin/user_prefs file or use the
 default settings for the server. Also adds a vmoduser -f option
 to turn off spam assassin for any one user.

 Best Regards,

 Jeff Koch



[vchkpw] Problem with vchkpw

2004-01-20 Thread Brad

I have a Debian (Woody) system and it is running shadow passwords.  I have
qmail installed and woking just fine.  I did a basic install (no config
options) for vpopmail.  Everything installed fin but when I change my
/etc/inetd.conf file to this pop3 stream tcp nowait root
/var/qmail/bin/qmail-popup qmail-popup email.byesville.net
/home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir (all one line)
I cannot authenticate any users on the system popping  mail or loggin gon to
a webbased email system.  What am I missing on the install for vpopmail.  I
shouldn't have to create a virtual domain for my local system and it should
authenticate properly like before.  Please corrrect me if I am wrong.  I
have created a virtual domain and two users on that domain and it still
doesn't work.

  What does this mean when I try and login:

email:/etc# /var/qmail/bin/qmail-popup qmail-popup email.byesville.net
/home/vpopmail/bin/vchkpw
+OK [EMAIL PROTECTED]
user bswest
+OK
pass **
-ERR authorization failed
email:/etc#

password is correct and user does exist on the system and is a virtual user
as well.

   Brad West
   Custom Technical Services
   740-439-5055





Re: [vchkpw] Yermo's patch: welcome msg

2004-01-20 Thread Yermo Lamers
Based on several requests I've received,  I have updated my welcome 
message patch for 5.4.0-rc2.

PLEASE NOTE: I do not have a running 5.4.0-rc2 setup with which to test 
and won't for another few weeks. As a result, this version of the patch 
is UNTESTED. All I could do at this time was make sure it compiled.

Having said that, it's a really simple patch.

If you have any problems with it please contact me.

Thanks,

-- Yermo

Andrea Riela wrote:
Hi folks,

The Yermo's patch at
http://sourceforge.net/tracker/index.php?func=detailaid=851781group_id=859
37atid=577800 works only on 5.3.30, or it could work on 5.4.0-rc1?
Thanks for all
Regards
Andrea

--
-
DTLink Software http://www.dtlink.com
FieldPost Business Email http://www.fieldpost.com
Nuts and Bolts Interactive, Inc. http://www.nbinteractive.com
-


Re: [vchkpw] Problem with vchkpw

2004-01-20 Thread Tom Collins
On Jan 20, 2004, at 2:21 PM, Brad wrote:
I have a Debian (Woody) system and it is running shadow passwords.  I 
have
qmail installed and woking just fine.  I did a basic install (no config
options) for vpopmail.  Everything installed fin but when I change my
/etc/inetd.conf file to this pop3 stream tcp nowait root
/var/qmail/bin/qmail-popup qmail-popup email.byesville.net
/home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir (all one 
line)
I cannot authenticate any users on the system popping  mail or loggin 
gon to
a webbased email system.  What am I missing on the install for 
vpopmail.  I
shouldn't have to create a virtual domain for my local system and it 
should
authenticate properly like before.  Please corrrect me if I am wrong.  
I
have created a virtual domain and two users on that domain and it still
doesn't work.
First, to enable system users, add --enable-passwd to your vpopmail 
configuration.

To log in to virtual domains, you need to use USER 
[EMAIL PROTECTED] or USER username%domain.com in the POP login.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/