Re: [vchkpw] Troubles installing Vpopmail with mysql
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
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
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
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
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
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
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