Re: [vchkpw] 90% CPU in vchkpw

2002-10-29 Thread Justin Heesemann
On Tuesday 29 October 2002 21:22, Brad Dameron wrote:
> What does "softlimit" do?


it limits the ammount of memory the process may use.
in this case about 2MB ram.

Luis, which options did you use when compiling vpopmail?
>
> > -Original Message-
> > From: Luis Gustavo Facioni Barcellos [mailto:lbarcellos@;emater.tche.br]
> > Sent: Tuesday, October 29, 2002 11:58 AM
> > To: [EMAIL PROTECTED]
> > Subject: [vchkpw] 90% CPU in vchkpw
> >
> >
> > Hi, all
> >
> > I have a qmail 1.0.3, daemontools 0.76, qmail-scanner 1.12 with mcafee,
> > vpopmail 5.2.1 and sqwebmail 3.3.4 in a brand new Slackware 8.1 box.
> >
> > Its all running fine, but sometimes the server stops authenticating. The
> > top shows a vchkpw process consuming more then 90% CPU and I get a
> > *server busy* on client.
> >
> > my qmail-pop3/run script:
> > #!/bin/sh
> > env - PATH="/usr/local/qmail/bin:/usr/local/bin"
> > MAXCON=40
> > exec /usr/local/bin/softlimit -m 200 \
> >   /usr/local/bin/tcpserver -v -H -R -c "$MAXCON" 0 pop3 \
> >   /usr/local/qmail/bin/qmail-popup mydomain.here.com \
> >   /usr/local/vpopmail/bin/vchkpw /usr/local/qmail/bin/qmail-pop3d
> > Maildir 2>&1
> >
> > Someone could tell where do I start to fix it?
> >
> > TIA
> > --
> > Gustavo
> > --
> > * "Duct tape is like the Force. It has a light side, a dark side, and it
> > holds the universe together."
> > --

-- 
Best Regards
---
Justin Heesemannionium Technologies
[EMAIL PROTECTED]www.ionium.org





Re: [vchkpw] Vpopmail Debian - Problem sending Mials

2002-10-29 Thread Zeno Davatz
On 29.10.2002 21:27 Uhr, "David Phillips" <[EMAIL PROTECTED]> wrote:

> tcp.smtp (compiled into tcp.smtpd.cdb) controls which IP's are allowed to
> connect to tcpserver.  It defaults to allow (which would be a single
> ":allow" line).  Setting RELAYCLIENT for an IP tells qmail-smtpd to allow it
> to relay mail.
Ok. Got that.

> Normally, this file contains all IP's on your network, assuming you want
> them to relay through qmail.  The following is an example.  RBLSMTPD is only
> needed if you are using rblsmtpd.  Leaving it blank tells rblsmtpd to not
> perform lookups against that address (you don't want it looking up your own
> addresses):
> 
> 127.:allow,RELAYCLIENT="",RBLSMTPD=""
> 192.168.:allow,RELAYCLIENT="",RBLSMTPD=""
Well obviously I forgot the '127.:...' entry. Now it works fine locally. I
will jut go an try online now.

>> My run file is (I just changed the path of the vpopmail-home):
> 
> If your domains directory is on /var, then make sure you have enough space
> for all the mail.
Yes I will do so.

>> #!/bin/sh
>> QMAILDUID=`id -u qmaild`
>> NOFILESGID=`id -g qmaild`
>> MAXSMTPD=`cat /var/qmail/control/concurrencyincoming`
> 
> As a tip, you can get rid of QMAILDUID and NOFILESGID by adding -U to the
> tcpserver command line and using "envuidgid qmaild" as the first thing after
> exec.
What will this help me?

>> exec softlimit -m 200 \
>>   tcpserver -v -R -l 0 -x /var/lib/vpopmail/etc/tcp.smtp.cdb -c
>> "$MAXSMTPD" \
>> -u "$QMAILDUID" -g "$NOFILESGID" 0 smtp qmail-smtpd 2>&1
>> 
>> When I try to send a message I get the 5.7.1 error.
>> I read all the documentation for Newbies on relaying from Chris.
> 
> Does your tcp.smtp file set RELAYCLIENT for the IP that you are sending
> from?
Yes, I got '127.: ...' and '192.168.0.:... ' as an entry.
Now on my online setup I got the following problem:
In my office I am sitting behind a firewall. I got a t1 connection but I do
_not_have_a fix IP.

I am obviously sending mails only from the domains listed in rcpthosts but
somehow I still get the 5.7.1 error! Argh.

> vpopmail will create vpopmail/etc/open-smtp that it merges with tcp.smtp
> when building tcp.smtp.cdb.  It does this automatically for any IP that
> successfully authenticates via POP3 (or anything using vchkpw, such as
> Courier IMAP).  tcp.smtp.cdb is automatically rebuilt when this happens.
> 
> You need to make sure vpopmail/bin/clearopensmtp is being run from cron
> every 30-60 minutes, otherwise these IP's will never expire.
Do I have to check this or has this already been done automatically?

Thanks for your kind help.
Zeno





[vchkpw] Question about vpopmail and shared folders

2002-10-29 Thread Taylor Dondich
I am using vpopmail with courier-imap as my mail solution and I love it 
so far.  I've got a small question about shared folders.  When creating 
a shared mail folder under a shared mailbox directory structure, you use 
the -s  flag to specify permission to the folder.  How can this 
work with virtual domains?  I don't see a way of specifying specific 
permissions and only doing global read/write access to the folder.

Taylor Dondich




[vchkpw] how to handle quota

2002-10-29 Thread zafar
helo all
   i already put that question but no answer till i receive.
i want to know how i implement quota on folders in a single INBOX or
Maildir.
When  quota exceed no mail will come.
so plz guide to how implement quota on Maildir
qmailadmin implement but it creates problems.
thanks.
wait for reply.





RE: [vchkpw] Courier-Imap and Sqwebmail

2002-10-29 Thread Clayton Weise
This would probably be a good question for courier-imap or sqwebmail.

-Original Message-
From: Fernando Costa de Almeida [mailto:falmeida@;easyit.com.br]
Sent: Tuesday, October 29, 2002 12:06 PM
To: [EMAIL PROTECTED]
Subject: [vchkpw] Courier-Imap and Sqwebmail


Hi,

Ive installed Courier-Imap with vchkpw authentication (qmail + vpopmail +
qmailadmin + Courier-IMAP), and all works well: I can connect to the server
and etc... But there is a problem:
If I delete the Drafts folder (used by Sqwebmail), Sqwebmail shows an errors
when I try to send a message, because it needs this folder to store
something.

The question is: How can I avoid that users delete this folder in
Courier-IMAP? Sorry if it was off-topic...

Thanks in advance,

___
ALMEIDA, Fernando Costa de
Computeasy Informática
www.computeasy.com.br
BSD USER BSD050945
ICQ 72293951







Re: [vchkpw] 90% CPU in vchkpw

2002-10-29 Thread David Phillips
Brad Dameron writes:
> What does "softlimit" do?

http://cr.yp.to/daemontools/softlimit.html

-- 
David Phillips <[EMAIL PROTECTED]>
http://david.acz.org/





Re: [vchkpw] Vpopmail Debian - Problem sending Mials

2002-10-29 Thread David Phillips
Zeno Davatz writes:
> I followed the below HOWTO and think is great - it helped me a lot. I
> managed to send and receive messages locally an online.

Cool.

> What I do not quite understand yet is how vpopmail and qmail handle
> the outgoing messages via smtp:

vpopmail does not affect outgoing mail.  It controls whether or not certain
IP's are allowed to relay mail when connecting to qmail-smtpd.

>> * Change the run script for qmail-smtpd (/service/qmail-smtpd/run)
>> to use vpopmail.  The tcp.smtp.cdb file needs to point to the one in
>> the vpopmail home directory (ex. /home/vpopmail/etc/tcp.smtp.cdb).
>> This step makes POP-before-SMTP work.
> Does this file contain the all the hosts for witch my Server will send
> Email?

tcp.smtp (compiled into tcp.smtpd.cdb) controls which IP's are allowed to
connect to tcpserver.  It defaults to allow (which would be a single
":allow" line).  Setting RELAYCLIENT for an IP tells qmail-smtpd to allow it
to relay mail.

Normally, this file contains all IP's on your network, assuming you want
them to relay through qmail.  The following is an example.  RBLSMTPD is only
needed if you are using rblsmtpd.  Leaving it blank tells rblsmtpd to not
perform lookups against that address (you don't want it looking up your own
addresses):

127.:allow,RELAYCLIENT="",RBLSMTPD=""
192.168.:allow,RELAYCLIENT="",RBLSMTPD=""

> My run file is (I just changed the path of the vpopmail-home):

If your domains directory is on /var, then make sure you have enough space
for all the mail.

> #!/bin/sh
> QMAILDUID=`id -u qmaild`
> NOFILESGID=`id -g qmaild`
> MAXSMTPD=`cat /var/qmail/control/concurrencyincoming`

As a tip, you can get rid of QMAILDUID and NOFILESGID by adding -U to the
tcpserver command line and using "envuidgid qmaild" as the first thing after
exec.

> exec softlimit -m 200 \
>   tcpserver -v -R -l 0 -x /var/lib/vpopmail/etc/tcp.smtp.cdb -c
> "$MAXSMTPD" \
> -u "$QMAILDUID" -g "$NOFILESGID" 0 smtp qmail-smtpd 2>&1
>
> When I try to send a message I get the 5.7.1 error.
> I read all the documentation for Newbies on relaying from Chris.

Does your tcp.smtp file set RELAYCLIENT for the IP that you are sending
from?

vpopmail will create vpopmail/etc/open-smtp that it merges with tcp.smtp
when building tcp.smtp.cdb.  It does this automatically for any IP that
successfully authenticates via POP3 (or anything using vchkpw, such as
Courier IMAP).  tcp.smtp.cdb is automatically rebuilt when this happens.

You need to make sure vpopmail/bin/clearopensmtp is being run from cron
every 30-60 minutes, otherwise these IP's will never expire.

--
David Phillips <[EMAIL PROTECTED]>
http://david.acz.org/





RE: [vchkpw] 90% CPU in vchkpw

2002-10-29 Thread Brad Dameron
What does "softlimit" do? 

---
Brad Dameron
Network Account Executive
TSCNet Inc.
 www.tscnet.com
Silverdale, WA. 
1-888-8TSCNET

 

> -Original Message-
> From: Luis Gustavo Facioni Barcellos [mailto:lbarcellos@;emater.tche.br]
> Sent: Tuesday, October 29, 2002 11:58 AM
> To: [EMAIL PROTECTED]
> Subject: [vchkpw] 90% CPU in vchkpw
> 
> 
> Hi, all
> 
> I have a qmail 1.0.3, daemontools 0.76, qmail-scanner 1.12 with mcafee, 
> vpopmail 5.2.1 and sqwebmail 3.3.4 in a brand new Slackware 8.1 box.  
> 
> Its all running fine, but sometimes the server stops authenticating. The 
> top shows a vchkpw process consuming more then 90% CPU and I get a 
> *server busy* on client.
> 
> my qmail-pop3/run script:
> #!/bin/sh
> env - PATH="/usr/local/qmail/bin:/usr/local/bin"
> MAXCON=40
> exec /usr/local/bin/softlimit -m 200 \
>   /usr/local/bin/tcpserver -v -H -R -c "$MAXCON" 0 pop3 \
>   /usr/local/qmail/bin/qmail-popup mydomain.here.com \
>   /usr/local/vpopmail/bin/vchkpw /usr/local/qmail/bin/qmail-pop3d 
> Maildir 2>&1
> 
> Someone could tell where do I start to fix it?
> 
> TIA
> -- 
> Gustavo
> --
> * "Duct tape is like the Force. It has a light side, a dark side, and it 
> holds the universe together."
> --
> 
> 
> 




[vchkpw] Courier-Imap and Sqwebmail

2002-10-29 Thread Fernando Costa de Almeida
Hi,

Ive installed Courier-Imap with vchkpw authentication (qmail + vpopmail +
qmailadmin + Courier-IMAP), and all works well: I can connect to the server
and etc... But there is a problem:
If I delete the Drafts folder (used by Sqwebmail), Sqwebmail shows an errors
when I try to send a message, because it needs this folder to store
something.

The question is: How can I avoid that users delete this folder in
Courier-IMAP? Sorry if it was off-topic...

Thanks in advance,

___
ALMEIDA, Fernando Costa de
Computeasy Informática
www.computeasy.com.br
BSD USER BSD050945
ICQ 72293951





Re: [vchkpw] Vpopmail Debian - Problem sending Mials

2002-10-29 Thread Zeno Davatz
Hi

I followed the below HOWTO and think is great - it helped me a lot. I
managed to send and receive messages locally an online.

What I do not quite understand yet is how vpopmail and qmail handle the
outgoing messages via smtp:

On 24.10.2002 2:06 Uhr, "David Phillips" <[EMAIL PROTECTED]> wrote:
... \snip
> * Install vpopmail from source.  The Debian packages are pretty old and seem
> to be buggy, at least the last time I tried.
> 
> * Change the run script for qmail-smtpd (/service/qmail-smtpd/run) to use
> vpopmail.  The tcp.smtp.cdb file needs to point to the one in the vpopmail
> home directory (ex. /home/vpopmail/etc/tcp.smtp.cdb).  This step makes
> POP-before-SMTP work.
Does this file contain the all the hosts for witch my Server will send
Email?

My run file is (I just changed the path of the vpopmail-home):

#!/bin/sh
QMAILDUID=`id -u qmaild`
NOFILESGID=`id -g qmaild`
MAXSMTPD=`cat /var/qmail/control/concurrencyincoming`

exec softlimit -m 200 \
  tcpserver -v -R -l 0 -x /var/lib/vpopmail/etc/tcp.smtp.cdb -c "$MAXSMTPD"
\
-u "$QMAILDUID" -g "$NOFILESGID" 0 smtp qmail-smtpd 2>&1

When I try to send a message I get the 5.7.1 error.
I read all the documentation for Newbies on relaying from Chris.

Thanks for any help and hints.
Zeno

> * Install a qmail-pop3d service.  The easiest way to do this is qmail-conf.
> You could use qmail-conf to redo all the qmail services, but it is easier to
> stick with the ones that qmail-run sets up:
> 
> http://www.din.or.jp/~ushijima/qmail-conf.html
> 
> * Allow incoming connections to pop3d.  By default, it does not allow any
> connections.  There is an add-client script in
> /var/qmail/service/qmail-pop3d that can be used.  To simply allow
> connections from everywhere, create an empty tcp file and run the Makefile.
> You will need to run the Makefile after using add-client.
> 
> * Change the qmail-pop3d run script to use vpopmail.  It needs to use vchkpw
> as the checkpassword program.  Change this to your vchkpw program (ex.
> /home/vpopmail/bin/vchkpw).  The parameter to be changed is the second
> parameter to qmail-popup.
> 
> * Restart all of the services:
> 
> svc -t /service/qmail-*
> 
> * You can make things easier if you add /var/qmail/bin and the vpopmail bin
> directory to root's PATH.
> 
> --
> David Phillips <[EMAIL PROTECTED]>
> http://david.acz.org/





Re: [vchkpw] Vdeldomain

2002-10-29 Thread Zeno Davatz
On 29.10.2002 20:14 Uhr, "Clayton Weise" <[EMAIL PROTECTED]> wrote:

> Check your qmail configs to see if it's in there:
> 
> /var/qmail/control/virtualdomains
> /var/qmail/control/rcpthosts
> /var/qmail/users/assign
> 
> And after you've changed those, you'll need to run a qmail-newu to rebuild
> the assign cdb file.
Thanks Clayton, for your kind help. You saved my night.

Zeno

> -Original Message-
> From: Zeno Davatz [mailto:zdavatz@;ywesee.com]
> Sent: Tuesday, October 29, 2002 10:49 AM
> To: [EMAIL PROTECTED]
> Subject: [vchkpw] Vdeldomain
> 
> 
> I deinstalled vpopmail and installed it again from source.
> 
> I do vdeldomain yweseelocal.com and get:
> Error: Domain does not exist.
> 
> I do vadddomain yweseelocal.com and get:
> Error: Domain already exists.
> 
> What can I do to remove the domain completely so that I can add it again.
> 
> Thanks for any help and hints.
> 
> Zeno
> 
> 
> 
> 
> 

-- 
Mit freundlichen Grüssen / best regards

Zeno Davatz
Strategie & Akquisition

+41 1 350 85 86

www.ywesee.com > intellectual capital connected > www.generika.cc






Re: [vchkpw] Re: qmailadmin-limits update

2002-10-29 Thread Pasi Kärkkäinen

On Tue, 29 Oct 2002, Brian Kolaci wrote:

>
>   >
>   > On Thu, 24 Oct 2002, John Johnson wrote:
>   >
>   > > I am not a programmer but from what I can see this
>   > > looks like a clean and very efective way to do the
>   > > qmailadmin-limits. If you try to bloat things down
>   > > for something that MIGHT be added or changed then
>   > > we really will not have things really planned, they
>   > > will be half planned and still open waiting for the
>   > > stuff people might want to add to the tables. I say
>   > > we go with this, lock it down and make it happen and
>   > > deal with tomarrow when tomarrow happens as far as the
>   > > tables.
>   > >
>   > >  -John
>   > >
>   >
>   > Yeah. This sounds good. I just find out that I need qmailadmin-limits
>   > myself too, and it would be nice to store this data in mysql.
>   >
>   > Brian, do you already have some patches for this?
>   >
>   > I'm willing to test and maybe spent some time coding this if needed..
>   >
>   >
>   > - Pasi Kärkkäinen
>
>
> I've had the basic table layouts done since January
> and have been running in production with a patched
> vdelivermail and qmailadmin since then.  Mine supports
> the limits as given, and the quotas (not message counts)
> in vdelivermail.  It should take more or less an hour to
> get this written - actually just change what I have
> to include the additional fields, however you're only
> the second person to reply to this.  I was hoping to get
> a consensus from people as to what else is needed or
> required, or find out if its overkill and to strip some.
>

OK. Sounds good.

Maybe you should just put those patches available.. people could
test them and start giving feedback.. At least I would
do so :)


> Thanks,
>
> Brian
>


- Pasi Kärkkäinen

   ^
. .
 Linux
  /-\
 Choice.of.the
   .Next.Generation.





[vchkpw] LDAP-patch

2002-10-29 Thread jja

Hi,

this is my second drop to make the LDAP-Code from vpopmail
more robust. The second patch includes my first patch I send a 3 weeks ago.
To review my work I'll give a link where all patches are available.

Changes:

- multiple domains stored in LDAP - operational
- vsetuserquota stored in LDAP - operational
- Bugfixes
- Code cleanup

For each Domain a seperate OU is setup, so that a user [EMAIL PROTECTED] is
different from user [EMAIL PROTECTED]

I have testet the following which worked:
- vadddomain
- vadduser
- vdeluser
- vdeldomain
- vsetuserquota
- compatible to qmailadmin
- compatible to vdeliver

My next TODO items:
- code cleanup
- more flexible error handling
- add more items stored in LDAP

You are welcome to test it on your system, for me it works !!
You can download my patches on :

http://www.tiski.de/linux/patches/vpopmail/patch-ldap-1.gz
http://www.tiski.de/linux/patches/vpopmail/patch-ldap-2.gz

Note this are not incremental patches !!
Copy the   patch-ldap-2.gz to your vpopmail dir, gunzip it and use:
patch -p1 < patch-ldap-2 
to aplly.

The patches are against vpopmail-5.3.8, but they should apply cleanly against
vpopmail-5.3.8.

Enjoy
Jens





This mail sent through Novasoft WWW-Mail




Re: [vchkpw] Does qmailadmin support MySQL....

2002-10-29 Thread Pasi Kärkkäinen

On Wed, 30 Oct 2002, Neo Wee Teck wrote:

> Does qmailadmin support MySQL for vpopmail?
>
>

Yes, if you have compiled vpopmail with mysql support.

qmailadmin just talks to vpopmail, and vpopmail talks to whatever backend
you have configured it to talk to.


- Pasi Kärkkäinen

   ^
. .
 Linux
  /-\
 Choice.of.the
   .Next.Generation.





RE: [vchkpw] Vdeldomain

2002-10-29 Thread Clayton Weise
Check your qmail configs to see if it's in there:

/var/qmail/control/virtualdomains
/var/qmail/control/rcpthosts
/var/qmail/users/assign

And after you've changed those, you'll need to run a qmail-newu to rebuild
the assign cdb file.

-Clayton

-Original Message-
From: Zeno Davatz [mailto:zdavatz@;ywesee.com]
Sent: Tuesday, October 29, 2002 10:49 AM
To: [EMAIL PROTECTED]
Subject: [vchkpw] Vdeldomain


I deinstalled vpopmail and installed it again from source.

I do vdeldomain yweseelocal.com and get:
Error: Domain does not exist.

I do vadddomain yweseelocal.com and get:
Error: Domain already exists.

What can I do to remove the domain completely so that I can add it again.

Thanks for any help and hints.

Zeno







[vchkpw] 90% CPU in vchkpw

2002-10-29 Thread Luís Gustavo Facioni Barcellos
Hi, all

I have a qmail 1.0.3, daemontools 0.76, qmail-scanner 1.12 with mcafee, 
vpopmail 5.2.1 and sqwebmail 3.3.4 in a brand new Slackware 8.1 box.	

Its all running fine, but sometimes the server stops authenticating. The 
top shows a vchkpw process consuming more then 90% CPU and I get a 
*server busy* on client.

my qmail-pop3/run script:
#!/bin/sh
env - PATH="/usr/local/qmail/bin:/usr/local/bin"
MAXCON=40
exec /usr/local/bin/softlimit -m 200 \
 /usr/local/bin/tcpserver -v -H -R -c "$MAXCON" 0 pop3 \
 /usr/local/qmail/bin/qmail-popup mydomain.here.com \
 /usr/local/vpopmail/bin/vchkpw /usr/local/qmail/bin/qmail-pop3d 
Maildir 2>&1

Someone could tell where do I start to fix it?

TIA
--
Gustavo
--
* "Duct tape is like the Force. It has a light side, a dark side, and it 
holds the universe together."
--




[vchkpw] Error compiling

2002-10-29 Thread Carl A Jeptha



Hi,
The first error was that make could not find 
"mysql.h" ( I copied "vmysql.h")
After that I receive the following error when 
running "make" :
vauth.c:35: parse error before 
'mysql_update'
 
Any Assistance would be appreciated.
 
You have a good day now,
 
Carl


[vchkpw] Vdeldomain

2002-10-29 Thread Zeno Davatz
I deinstalled vpopmail and installed it again from source.

I do vdeldomain yweseelocal.com and get:
Error: Domain does not exist.

I do vadddomain yweseelocal.com and get:
Error: Domain already exists.

What can I do to remove the domain completely so that I can add it again.

Thanks for any help and hints.

Zeno





[vchkpw] Does qmailadmin support MySQL....

2002-10-29 Thread Neo Wee Teck
Does qmailadmin support MySQL for vpopmail?





Re: [vchkpw] Re: qmailadmin-limits update

2002-10-29 Thread Brian Kolaci

  > 
  > On Thu, 24 Oct 2002, John Johnson wrote:
  > 
  > > I am not a programmer but from what I can see this
  > > looks like a clean and very efective way to do the
  > > qmailadmin-limits. If you try to bloat things down
  > > for something that MIGHT be added or changed then
  > > we really will not have things really planned, they
  > > will be half planned and still open waiting for the
  > > stuff people might want to add to the tables. I say
  > > we go with this, lock it down and make it happen and
  > > deal with tomarrow when tomarrow happens as far as the
  > > tables.
  > >
  > >  -John
  > >
  > 
  > Yeah. This sounds good. I just find out that I need qmailadmin-limits
  > myself too, and it would be nice to store this data in mysql.
  > 
  > Brian, do you already have some patches for this?
  > 
  > I'm willing to test and maybe spent some time coding this if needed..
  > 
  > 
  > - Pasi Kärkkäinen


I've had the basic table layouts done since January
and have been running in production with a patched
vdelivermail and qmailadmin since then.  Mine supports
the limits as given, and the quotas (not message counts)
in vdelivermail.  It should take more or less an hour to
get this written - actually just change what I have
to include the additional fields, however you're only
the second person to reply to this.  I was hoping to get
a consensus from people as to what else is needed or
required, or find out if its overkill and to strip some.

Thanks,

Brian

  > 
  > 
  > > Brian Kolaci writes:
  > >
  > > >
  > > > I've done some thinking about the many suggestions about handling
  > > > the limits and wanted to summarize some of the pros & cons.
  > > >
  > > > First was whether to use a generic approach that had a
  > > > table with domain, name, value which has a row for each
  > > > parameter, or to use a single row will all values per domain.
  > > >
  > > > The pros:
  > > >
  > > >  - allows extensability - we can easily add new attributes with a new 
row
  > > >
  > > > The cons:
  > > >
  > > >  - consumes more space - there's overhead of N-1 times the size of
  > > >the domainname, plus N times the size of the option name, plus
  > > >overhead for the value to be able to hold the largest possible value
  > > >even for smaller items.
  > > >  - updates not atomic - there would have to be N update statements to
  > > >change a value.  We would have to encapsulate the updates within a
  > > >transaction.
  > > >  - performance - there would be more data going back and forth to/from
  > > >the sql server.  We would also have to store all data as strings in
  > > >the database and do conversions.  When we perform updates, there 
would
  > > >have to be N updates sent to the server, which is N round trips plus
  > > >the transaction overhead.
  > > >
  > > > At first when I saw the suggestion I thought it was a great idea,
  > > > however after thinking it over, I believe performance and reliability
  > > > would suffer just to save an "alter table" if/when the schema needs to
  > > > be extended.
  > > >
  > > > That being said, I'll continue down the path of a single row per domain,
  > > > however if others have arguments to the contrary, please speak up.
  > > >
  > > > The schema needs to be adjusted to accomodate all the requests I've 
seen.
  > > > Both the C structure and the database schema needs to change.
  > > >
  > > > I've read the Maildir++ quotas and understand that the concept of a
  > > > "Maildir quota" encapsulates both a maximum size and maximum message 
count.
  > > > It appears to be just a string that contains "#S,#C", which combines
  > > > the Size and the Count into one string, where the #C is optional.  I
  > > > personally would want them separated as two values, since you can't do
  > > > much with the combined string but pass it around.  To actually use it,
  > > > you need to split them up with a parser and convert them to numbers.
  > > > I think the API should keep them as numbers in the structure in C.  Its
  > > > easy enough to combine them with a snprintf(), but more work to parse
  > > > them out to actually use/enforce them.  How they're stored in the 
database
  > > > and/or file doesn't really matter (but should be discussed).  I believe
  > > > they were combined due to the old hack to put the quota value into
  > > > the "shell" field of a password record.  Being that we're in new
  > > > territory here, we don't even have the concept of message count in
  > > > .qmailadmin-limits files or the database, so adding a field/column
  > > > for the "default per-user message count" or "per-domain message count"
  > > > shouldn't be an issue, and would even keep the old fileformat backward
  > > > compatible.  In fact, it appears the vqpasswd structure has already
  > > > been amended to add a "clear password", so why wasn't it just updated
  > > > to add fields for "storage quota" and "max message count" ?  Wouldn't

Re: [vchkpw] Re: qmailadmin-limits update

2002-10-29 Thread Pasi Kärkkäinen

On Thu, 24 Oct 2002, John Johnson wrote:

> I am not a programmer but from what I can see this
> looks like a clean and very efective way to do the
> qmailadmin-limits. If you try to bloat things down
> for something that MIGHT be added or changed then
> we really will not have things really planned, they
> will be half planned and still open waiting for the
> stuff people might want to add to the tables. I say
> we go with this, lock it down and make it happen and
> deal with tomarrow when tomarrow happens as far as the
> tables.
>
>  -John
>

Yeah. This sounds good. I just find out that I need qmailadmin-limits
myself too, and it would be nice to store this data in mysql.

Brian, do you already have some patches for this?

I'm willing to test and maybe spent some time coding this if needed..


- Pasi Kärkkäinen


> Brian Kolaci writes:
>
> >
> > I've done some thinking about the many suggestions about handling
> > the limits and wanted to summarize some of the pros & cons.
> >
> > First was whether to use a generic approach that had a
> > table with domain, name, value which has a row for each
> > parameter, or to use a single row will all values per domain.
> >
> > The pros:
> >
> >  - allows extensability - we can easily add new attributes with a new row
> >
> > The cons:
> >
> >  - consumes more space - there's overhead of N-1 times the size of
> >the domainname, plus N times the size of the option name, plus
> >overhead for the value to be able to hold the largest possible value
> >even for smaller items.
> >  - updates not atomic - there would have to be N update statements to
> >change a value.  We would have to encapsulate the updates within a
> >transaction.
> >  - performance - there would be more data going back and forth to/from
> >the sql server.  We would also have to store all data as strings in
> >the database and do conversions.  When we perform updates, there would
> >have to be N updates sent to the server, which is N round trips plus
> >the transaction overhead.
> >
> > At first when I saw the suggestion I thought it was a great idea,
> > however after thinking it over, I believe performance and reliability
> > would suffer just to save an "alter table" if/when the schema needs to
> > be extended.
> >
> > That being said, I'll continue down the path of a single row per domain,
> > however if others have arguments to the contrary, please speak up.
> >
> > The schema needs to be adjusted to accomodate all the requests I've seen.
> > Both the C structure and the database schema needs to change.
> >
> > I've read the Maildir++ quotas and understand that the concept of a
> > "Maildir quota" encapsulates both a maximum size and maximum message count.
> > It appears to be just a string that contains "#S,#C", which combines
> > the Size and the Count into one string, where the #C is optional.  I
> > personally would want them separated as two values, since you can't do
> > much with the combined string but pass it around.  To actually use it,
> > you need to split them up with a parser and convert them to numbers.
> > I think the API should keep them as numbers in the structure in C.  Its
> > easy enough to combine them with a snprintf(), but more work to parse
> > them out to actually use/enforce them.  How they're stored in the database
> > and/or file doesn't really matter (but should be discussed).  I believe
> > they were combined due to the old hack to put the quota value into
> > the "shell" field of a password record.  Being that we're in new
> > territory here, we don't even have the concept of message count in
> > .qmailadmin-limits files or the database, so adding a field/column
> > for the "default per-user message count" or "per-domain message count"
> > shouldn't be an issue, and would even keep the old fileformat backward
> > compatible.  In fact, it appears the vqpasswd structure has already
> > been amended to add a "clear password", so why wasn't it just updated
> > to add fields for "storage quota" and "max message count" ?  Wouldn't
> > that be cleaner?  Sorry for going off topic...  I'll stick to the subject
> > now.
> >
> > So my suggestion would be to store 4 "quota type" fields to handle
> > storage/message count for per-domain/per-user.  Any comments?
> >
> > Here's what I would see as a new C structure:
> >
> > /*
> >  * permissions for non-postmaster admins
> >  */
> > #define VLIMIT_DISABLE_CREATE 0x01
> > #define VLIMIT_DISABLE_MODIFY 0x02
> > #define VLIMIT_DISABLE_DELETE 0x04
> >
> > struct vlimits {
> >   int   maxpopaccounts;
> >   int   maxaliases;
> >   int   maxforwards;
> >   int   maxautoresponders;
> >   int   maxmailinglists;
> >   int   diskquota;
> >   int   maxmsgcount;
> >   int   defaultquota;
> >   int   defaultmaxmsgcount;
> >   /* the following are 0 (false) or 1 (true) */
> >   short disable_pop;
> >   short disable_im

Re: [vchkpw] Default-quota per domain and per user..

2002-10-29 Thread Pasi Kärkkäinen

On Mon, 28 Oct 2002, Pasi Kärkkäinen wrote:

>
> Hello!
>
> I have read the README.quotas from vpopmail 5.2.1, but I still have some
> questions..
>
> 1. What is the correct way to setup per domain default-quota? How does it
>work? Where is the quota-information stored? It needs patched qmail to
>understand it?
>
> 2. How can I override the per-domain quota for some specific user in that
>domain? Just use the vsetuserquota for that user, and it then uses the
>user's own quota rather than the domain-wide quota?
>
> 3. Does courier-imapd understand the per-domain quota if user does not
>have specific quota for him/her? How about qmail's pop3d?
>
> 4. Can domain admins (postmaster) edit the per user quota from qmailadmin?
>needs some patch?
>
> I'm currently running vpopmail 5.0.1, so I need to upgrade at least to
> 5.2.1.. should I upgrade to 5.3.x, are there any enhancements to quota
> code compared to 5.2.1 ?
>
> How is this qmailadmin-limits related to quota? I've been reading the
> discussion on the list during last couple of days but I'm not quite sure
> what is qmailadmin-limits used for..
>

Quoting myself.. I played with these things a little, and it seems to be
like this:

- With vqadmin (or by editing
~vpopmail/domains/domain/.qmailadmin-limits) you can specify maximun
number of accounts and the default quota etc for each domain.
Qmailadmin honours these limits and sets the quota like specified in
.qmailadmin-limits, if you don't specify some other quota for that
user.

- In vpopmail vdelivermail is responsible for handling the
Maildir++ quota when user gets new mail via SMTP. No need to patch Qmail.
I suppose vdelivermail gets the per user quota information from vpopmail
(from the backend you have compiled vpopmail with, mysql, ldap or so).

- --enable-hardquota in vpopmail causes the mail to be bounced
back if the user is over quota. Without this option the mail will NOT be
bounced back when the user is over quota.

so.. I think that's how it works?

And in pop/imap servers you only need to update the maildirsize
file when you remove mails from the server (because pop/imap servers
can't add new files to the Maildir), correct?
Courier supports this out-of-the-box, and there is separate patch for the
qmail's pop3d too with vpopmail..

Then question about qmailadmin.. I remember reading from the archives that
somebody had a patch for qmailadmin to modify per user quota.. is that
available from someplace?

And the qmailadmin-limits discussion on the list a while ago is about
storing the contents of .qmailadmin-limits file in mysql? (Plus of course
patching vqadmin and qmailadmin to use it from mysql too).


Thanks!

- Pasi Kärkkäinen

   ^
. .
 Linux
  /-\
 Choice.of.the
   .Next.Generation.





[vchkpw] Limiting size of the emails sent based on quota

2002-10-29 Thread Fernando Costa de Almeida
Hi all,

I have to add the following feature in my email system:

"Users of a determined domain can't sent email with size greater than 20% of
their quota."

Ive already have vpopmail, sqwebmail, qmailadmin, vqadmin working well with
LDAP and quotas, but I dont know (yet) how to do the feature above.

Any help willl be apreciated,


___
ALMEIDA, Fernando Costa de
Computeasy Informática
www.computeasy.com.br
BSD USER BSD050945
ICQ 72293951





Re: [vchkpw] Qmail Vpopmail

2002-10-29 Thread Michael Bowe
- Original Message -
From: "Joeffrey Betita" <[EMAIL PROTECTED]>
To: "Vchkpw" <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 10:22 PM
Subject: [vchkpw] Qmail Vpopmail


>
>  i already change the checkpassword. below is my configuration. what
should
> i do next.
>
>
> #!/bin/sh
> MAXCON=100
> exec /usr/local/bin/softlimit -m 500 \
> /usr/local/bin/tcpserver -v -R -H -c "$MAXCON" \
> 0 110 /var/qmail/bin/qmail-popup example.com.ph /bin/vchkpw \
> /var/qmail/bin/qmail-pop3d Maildir 2>&1

Joeffrey,
More than likely it should be this (note the change to the vchkpw path on
the 2nd last line of the script) :

#!/bin/sh
MAXCON=100
exec /usr/local/bin/softlimit -m 500 \
/usr/local/bin/tcpserver -v -R -H -c "$MAXCON" \
0 110 /var/qmail/bin/qmail-popup example.com.ph
/home/vpopmail/bin/vchkpw \
/var/qmail/bin/qmail-pop3d Maildir 2>&1

Also, I reckon the softlimit is set a bit high
I would recommend 200 for a "standard" vpopmail install,
or 300 for installs using the MySQL backend.

Michael.






[vchkpw] Qmail Vpopmail

2002-10-29 Thread Joeffrey Betita

 i already change the checkpassword. below is my configuration. what should
i do next.


#!/bin/sh
MAXCON=100
exec /usr/local/bin/softlimit -m 500 \
/usr/local/bin/tcpserver -v -R -H -c "$MAXCON" \
0 110 /var/qmail/bin/qmail-popup example.com.ph /bin/vchkpw \
/var/qmail/bin/qmail-pop3d Maildir 2>&1


do i have to create a file /var/qmail/supervise/qmail-pop3d/vchkpw insert
this script or configuration

Here is a sample startup line for qmail-pop3d and vchkpw

env - PATH="/var/qmail/bin:/usr/local/bin" \
tcpserver -H -R 0 pop-3 \
/var/qmail/bin/qmail-popup your.domain.com \
/home-dir-of-vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir
&
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.408 / Virus Database: 230 - Release Date: 10/24/2002