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


[vchkpw] Troubles installing Vpopmail with mysql

2005-05-21 Thread Patrick Donker

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 for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets ${MAKE}... yes
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for gawk... (cached) gawk
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for style of include used by make... GNU
checking dependency style of gcc... none
checking for a BSD-compatible install... /usr/bin/install -c
checking for ranlib... ranlib
checking for strerror in -lcposix... no
checking for crypt in -lcrypt... yes
checking for dirent.h that defines DIR... yes
checking for library containing opendir... none required
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/wait.h that is POSIX.1 compatible... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking arpa/inet.h usability... yes
checking arpa/inet.h presence... yes
checking for arpa/inet.h... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking for memory.h... (cached) yes
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking shadow.h usability... yes
checking shadow.h presence... yes
checking for shadow.h... yes
checking for stdlib.h... (cached) yes
checking for string.h... (cached) yes
checking sys/file.h usability... yes
checking sys/file.h presence... yes
checking for sys/file.h... yes
checking sys/param.h usability... yes
checking sys/param.h presence... yes
checking for sys/param.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking syslog.h usability... yes
checking syslog.h presence... yes
checking for syslog.h... yes
checking for unistd.h... (cached) yes
checking utime.h usability... yes
checking utime.h presence... yes
checking for utime.h... yes
checking for gcc option to accept ANSI C... none needed
checking for an ANSI C-conforming const... yes
checking for uid_t in sys/types.h... yes
checking for inline... inline
checking for mode_t... yes
checking for off_t... yes
checking for pid_t... yes
checking for size_t... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking whether closedir returns void... no
checking return type of signal handlers... void
checking whether utime accepts a null argument... yes
checking for bzero... yes
checking for dup2... yes
checking for fdatasync... yes
checking for getcwd... yes
checking for gethostname... yes
checking for getpass... yes
checking for getspnam... yes
checking for memset... yes
checking for mkdir... yes
checking for putenv... yes
checking for rmdir... yes
checking for socket... yes
checking for strchr... yes
checking for strdup... yes
checking for strerror... yes
checking for strncasecmp... yes
checking for strrchr... yes
checking for strspn... yes
checking for strstr... yes
checking for utime... yes
checking vpopmail configure options... ok
checking whether we can locate the qmail directory... yes
checking whether we can locate the qmail-newu program... yes
checking whether we can locate the qmail-inject program... yes
checking whether we can locate the qmail-inject program... yes
checking for valid vpopmail user and group... yes
checking whether password file entry for the vpopmail user exists... yes
checking whether roaming-users has been enabled... yes
checking whether we can locate the tcprules program... yes
checking whether we can locate the tcp.smtp file... yes
checking whether rebuild-tcpserver-file is been enabled... yes
checking whether learn-passwords is enabled... no
checking whether 

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


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:

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 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 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