Re: [vchkpw] Troubles installing Vpopmail with mysql

2005-05-22 Thread Rick Widmer



Tom Collins wrote:


On May 21, 2005, at 6:02 AM, Patrick Donker wrote:

Does enabling it has any impact on performance, or is it just a dead 
feature?


I think the premise is to read all of the user quotas (rebuilding any 
that are outdated) and summing them up to see if they're over the domain 
quota before receiving the message.  Even when working, it will add 
significant overhead to every message received, especially if you have a 
lot of users in the domain.


Now imagine a large server with lots of domains and users, and a fairly 
heavy load.  Install a new version of vopomail and enable this feature. 
   At first every single mail delivery will have to traverse the entire 
domain directory tree and stat every file in it to sum its size. 
Eventually all the totals will be cached and it'll go much faster... if 
the machine doesn't melt down first.  From what I've seen on the list 
most people shut it down and leave it off as soon as they figure out why 
the machine went crazy.



Maybe part of the answer is a program that would calculate the cached 
size values before you let domain quotas lose on a system...



Rick


Re: [vchkpw] Troubles installing Vpopmail with mysql

2005-05-21 Thread Tom Collins

On May 21, 2005, at 6:02 AM, Patrick Donker wrote:
Does enabling it has any impact on performance, or is it just a dead 
feature?


I'm not sure.  I think it might impact performance, but I haven't taken 
a close look at it.


My involvement with the feature started around 5.4, and I just worked 
on it enough to prevent it from segfaulting.


I think the premise is to read all of the user quotas (rebuilding any 
that are outdated) and summing them up to see if they're over the 
domain quota before receiving the message.  Even when working, it will 
add significant overhead to every message received, especially if you 
have a lot of users in the domain.


--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
You don't need a laptop to troubleshoot high-speed Internet: 
sniffter.com




Re: [vchkpw] Troubles installing Vpopmail with mysql

2005-05-21 Thread Tom Collins

On May 21, 2005, at 5:46 AM, Rick Macdougall wrote:
I think that option should probably be removed in future releases, Tom 
or Ken ?  You hear that?  Any thoughts.


Excellent idea.  I'll temporarily comment it out of the configure file 
so it can't be enabled.


--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
You don't need a laptop to troubleshoot high-speed Internet: 
sniffter.com




Re: [vchkpw] Troubles installing Vpopmail with mysql

2005-05-21 Thread Rick Macdougall



Patrick Donker wrote:


There was an older version where domain quotas sort of worked but the 
overhead involved when you had more than a few users was over 
whelming, at least that is my understanding.


I think that option should probably be removed in future releases, Tom 
or Ken ?  You hear that?  Any thoughts.



Does enabling it has any impact on performance, or is it just a dead 
feature?


Good question but not one I have an answer too as I have never enabled 
it.  Sorry.


Regards,

Rick


Re: [vchkpw] Troubles installing Vpopmail with mysql

2005-05-21 Thread Patrick Donker

Rick Macdougall wrote:




Patrick Donker wrote:


Rick Macdougall wrote:


Hi,

It's looking for the mysql libs, not includes.  On some of my 
systems it's in /usr/lib/mysql, in others it's in /usr/local/mysql/lib


A locate libmysqlclient.a should show you where yours is.




Shoot me if I understand, but I have cleaned up my env and deleted 
all files related to this build and now it suddenly works!



PS - domainquotas do not work.




So, if it doesnt work, why is it there then? Future feature?



Hi,

There was an older version where domain quotas sort of worked but the 
overhead involved when you had more than a few users was over 
whelming, at least that is my understanding.


I think that option should probably be removed in future releases, Tom 
or Ken ?  You hear that?  Any thoughts.


Regards,

Rick


Does enabling it has any impact on performance, or is it just a dead 
feature?


Re: [vchkpw] Troubles installing Vpopmail with mysql

2005-05-21 Thread Rick Macdougall



Patrick Donker wrote:

Rick Macdougall wrote:

Hi,

It's looking for the mysql libs, not includes.  On some of my systems 
it's in /usr/lib/mysql, in others it's in /usr/local/mysql/lib


A locate libmysqlclient.a should show you where yours is.



Shoot me if I understand, but I have cleaned up my env and deleted all 
files related to this build and now it suddenly works!



PS - domainquotas do not work.



So, if it doesnt work, why is it there then? Future feature?


Hi,

There was an older version where domain quotas sort of worked but the 
overhead involved when you had more than a few users was over whelming, 
at least that is my understanding.


I think that option should probably be removed in future releases, Tom 
or Ken ?  You hear that?  Any thoughts.


Regards,

Rick


Re: [vchkpw] Troubles installing Vpopmail with mysql

2005-05-21 Thread Patrick Donker

Rick Macdougall wrote:




Patrick Donker wrote:


Hi people,

I am having ./configure problems using  mysql as authmodule. This is my
commandline:
./configure \
--prefix=$PATHINSTALLVPOPMAIL \
--enable-vpopuser=$VPOPUSER \
--enable-vpopgroup=$VPOPGROUP \
--enable-roaming-users \
--enable-tcprules-prog=$TCPRULES \
--enable-relay-clear-minutes=$ENABLE_RELAY \
--enable-sqwebmail-pass \
--enable-qmail-ext \
--enable-ip-alias-domains \
--enable-domainquotas \
--enable-auth-module=$DATABASE_TYPE \
--enable-logging=p \
--enable-auth-logging \
--enable-valias \
--enable-sql-logging \
--enable-clear-passwd \
--enable-mysql-limits \
--enable-libdir=$MYSQLLIBDIR

And this is the error:




checking whether an auth module has been specified... mysql
configure: error: Unable to find your MySQL lib dir, specify
--enable-libdir.
./1.3.10.sh: line 1082: --enable-libdir=/usr/include/mysql: No such file
or directory
make: *** No targets specified and no makefile found.  Stop.
Error with vpopmail's installation (make)

All variables are correctly filled, the only error I get is about mysql
libdir. I have tried every version from 5.4.10 and up. My mysql version
is 4.1. What is it exactly configure is looking for? I dont know which
lib supposedly is missing, so I cant check either. How to troubleshoot
this? The dir /usr/include/mysql exsist. I also already have tried 
/usr/lib.

Thanks



Hi,

It's looking for the mysql libs, not includes.  On some of my systems 
it's in /usr/lib/mysql, in others it's in /usr/local/mysql/lib


A locate libmysqlclient.a should show you where yours is.


Shoot me if I understand, but I have cleaned up my env and deleted all 
files related to this build and now it suddenly works!



PS - domainquotas do not work.


So, if it doesnt work, why is it there then? Future feature?


Regards,

Rick


Thanks for your thoughts Rick


Re: [vchkpw] Troubles installing Vpopmail with mysql

2005-05-21 Thread Rick Macdougall



Patrick Donker wrote:

Hi people,

I am having ./configure problems using  mysql as authmodule. This is my
commandline:
./configure \
--prefix=$PATHINSTALLVPOPMAIL \
--enable-vpopuser=$VPOPUSER \
--enable-vpopgroup=$VPOPGROUP \
--enable-roaming-users \
--enable-tcprules-prog=$TCPRULES \
--enable-relay-clear-minutes=$ENABLE_RELAY \
--enable-sqwebmail-pass \
--enable-qmail-ext \
--enable-ip-alias-domains \
--enable-domainquotas \
--enable-auth-module=$DATABASE_TYPE \
--enable-logging=p \
--enable-auth-logging \
--enable-valias \
--enable-sql-logging \
--enable-clear-passwd \
--enable-mysql-limits \
--enable-libdir=$MYSQLLIBDIR

And this is the error:




checking whether an auth module has been specified... mysql
configure: error: Unable to find your MySQL lib dir, specify
--enable-libdir.
./1.3.10.sh: line 1082: --enable-libdir=/usr/include/mysql: No such file
or directory
make: *** No targets specified and no makefile found.  Stop.
Error with vpopmail's installation (make)

All variables are correctly filled, the only error I get is about mysql
libdir. I have tried every version from 5.4.10 and up. My mysql version
is 4.1. What is it exactly configure is looking for? I dont know which
lib supposedly is missing, so I cant check either. How to troubleshoot
this? The dir /usr/include/mysql exsist. I also already have tried 
/usr/lib.

Thanks


Hi,

It's looking for the mysql libs, not includes.  On some of my systems 
it's in /usr/lib/mysql, in others it's in /usr/local/mysql/lib


A locate libmysqlclient.a should show you where yours is.


PS - domainquotas do not work.

Regards,

Rick