[vchkpw] Can't seem to get rid of mysql?
When a user tries to subscribe to an ezmlm-idx mailing list, I get the following entry in my qmail-smtpd log: vmysql: no valid settings in /home/vpopmail/etc/vpopmail.mysql Why is this file still read? If I remove this file I get: 2006-10-14 10:55:54.895147500 vmysql: can't read settings from /home/ vpopmail/etc/vpopmail.mysql Listing the mailing list in qmailadmin doesn't show that mysql is enabled. Here's how I've configured vpopmail: $ cat configure.txt # vpopmail's configure script needs to be run as root. ./configure \ --enable-auth-module=cdb \ --disable-auth-module=mysql \ --enable-learn-passwords \ --disable-rebuild-tcpserver-file \ --enable-qmail-ext \ --enable-logging=v \ --disable-many-domains It results in: vpopmail 5.4.17 Current settings --- vpopmail directory = /home/vpopmail domains directory = /home/vpopmail/domains uid = 89 gid = 89 roaming users = OFF --disable-roaming-users (default) password learning = ON --enable-learn-passwords 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 = ON --enable-qmail-ext ip alias = OFF --disable-ip-alias-domains (default) auth module = cdb --enable-auth-module=cdb (default) auth inc = -Icdb auth lib = system passwords = OFF --disable-passwd (default) pop syslog = log success and errors including passwords --enable-logging=v auth logging = ON --enable-auth-logging (default) -- Regards, Charles.
Re: [vchkpw] Can't seem to get rid of mysql?
On 14-okt-2006, at 11:03, Charles M. Gerungan wrote: Here's how I've configured vpopmail: $ cat configure.txt # vpopmail's configure script needs to be run as root. ./configure \ --enable-auth-module=cdb \ --disable-auth-module=mysql \ Erm, the above line isn't actually in there. It's something I also tried, but configure doesn't accept it. --enable-learn-passwords \ --disable-rebuild-tcpserver-file \ --enable-qmail-ext \ --enable-logging=v \ --disable-many-domains -- Regards, Charles.
Re: [vchkpw] Can't seem to get rid of mysql?
On Saturday 14 October 2006 10:03, Charles M. Gerungan wrote: When a user tries to subscribe to an ezmlm-idx mailing list, I get the following entry in my qmail-smtpd log: vmysql: no valid settings in /home/vpopmail/etc/vpopmail.mysql Why is this file still read? If I remove this file I get: 2006-10-14 10:55:54.895147500 vmysql: can't read settings from /home/ vpopmail/etc/vpopmail.mysql Listing the mailing list in qmailadmin doesn't show that mysql is enabled. Here's how I've configured vpopmail: $ cat configure.txt # vpopmail's configure script needs to be run as root. ./configure \ --enable-auth-module=cdb \ --disable-auth-module=mysql \ --enable-learn-passwords \ --disable-rebuild-tcpserver-file \ --enable-qmail-ext \ --enable-logging=v \ --disable-many-domains I use --disable-ezmlm-mysql cdb is the default auth-module so you don't need to mention it It results in: vpopmail 5.4.17 Current settings --- vpopmail directory = /home/vpopmail domains directory = /home/vpopmail/domains uid = 89 gid = 89 roaming users = OFF --disable-roaming-users (default) password learning = ON --enable-learn-passwords 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 = ON --enable-qmail-ext ip alias = OFF --disable-ip-alias-domains (default) auth module = cdb --enable-auth-module=cdb (default) auth inc = -Icdb auth lib = system passwords = OFF --disable-passwd (default) pop syslog = log success and errors including passwords --enable-logging=v auth logging = ON --enable-auth-logging (default) -- - Bob Hutchinson Midwales dot com -
Re: [vchkpw] Can't seem to get rid of mysql?
On 14-okt-2006, at 11:24, Bob Hutchinson wrote: I use --disable-ezmlm-mysql I'm assuming you're talking about qmailadmin? My configure for vpopmail doesn't list it. -- Regards, Charles.
Re: [vchkpw] Why is vadduser creating a hierarchy?
Bert JW Regeer wrote: Hey Ismail, I would like to see some stats on this. Do you have any facts or evidence to back this up? It's true - if you don't have some sort of directory-hashing (UFS_DIRHASH in FreeBSD-land) in place, which for FreeBSD has been default since sometime in the early 4.x days, IIRC. On current systems 7000 directories inside a directory should not be a problem. Most employ hashing of some sort to speed up this kind of thing. On my FreeBSD system there is currently a directory with 10,010 directories, and it is no slower than if that same directory had only 128 directories in it for example. Several of my users are on several mailing lists for open source projects, and some of their Maildir's have cur directories with over 30,000 emails in them. Biggest one is 150,000, with no slow downs. No extra load on my server. DJB gave qmail's queue split directories, See above. DJB was or is a (Free)-BSD user (when he started, Linux was a toy anyway), which back in these days had this problem. why I do not understand, and I might never, since clearly he did not create his Maildir's to have the same sort of split directories for speedy access by IMAP/POP3 or other mail protocols. I always disable vpopmail's big dir stuff, as writing scripts for it is harder, extra sub directories to traverse. Just use the output of vuserinfo -d BTW: Does the latest version of vpopmail include the patch someone posted that fills up earlier hash-directories, where domains have been deleted from, instead of creating new ones? cheers, Rainer
Re: [vchkpw] Why is vadduser creating a hierarchy?
On Oct 14, 2006, at 16:06:30 MST, Rainer Duffner wrote: Bert JW Regeer wrote: Hey Ismail, I would like to see some stats on this. Do you have any facts or evidence to back this up? It's true - if you don't have some sort of directory-hashing (UFS_DIRHASH in FreeBSD-land) in place, which for FreeBSD has been default since sometime in the early 4.x days, IIRC. We are talking about new systems that exist right now. There is no need to do dirhashing in an application anymore. On current systems 7000 directories inside a directory should not be a problem. Most employ hashing of some sort to speed up this kind of thing. On my FreeBSD system there is currently a directory with 10,010 directories, and it is no slower than if that same directory had only 128 directories in it for example. Several of my users are on several mailing lists for open source projects, and some of their Maildir's have cur directories with over 30,000 emails in them. Biggest one is 150,000, with no slow downs. No extra load on my server. DJB gave qmail's queue split directories, See above. DJB was or is a (Free)-BSD user (when he started, Linux was a toy anyway), which back in these days had this problem. Agreed, however his Maildir approach did not include hashing in any way shape or form, so how did file systems back then handle over 1000's of email messages in an Inbox? why I do not understand, and I might never, since clearly he did not create his Maildir's to have the same sort of split directories for speedy access by IMAP/POP3 or other mail protocols. I always disable vpopmail's big dir stuff, as writing scripts for it is harder, extra sub directories to traverse. Just use the output of vuserinfo -d Not always what I need. BTW: Does the latest version of vpopmail include the patch someone posted that fills up earlier hash-directories, where domains have been deleted from, instead of creating new ones? cheers, Rainer Greets, Bert JW Regeer smime.p7s Description: S/MIME cryptographic signature
Re: [vchkpw] Why is vadduser creating a hierarchy?
On Saturday 14 October 2006 19:06, Rainer Duffner wrote: BTW: Does the latest version of vpopmail include the patch someone posted that fills up earlier hash-directories, where domains have been deleted from, instead of creating new ones? Nope, it doesn't (I wrote the patch, and last I heard it hadn't even been considered... ) I posted the patch here a while back - while it may take a little hacking, it should work fine with the latest vpopmail. Josh -- Joshua Megerman SJGames MIB #5273 - OGRE AI Testing Division You can't win; You can't break even; You can't even quit the game. - Layman's translation of the Laws of Thermodynamics [EMAIL PROTECTED]
Re: [vchkpw] Why is vadduser creating a hierarchy?
On Oct 14, 2006, at 4:16 PM, Joshua Megerman wrote: Nope, it doesn't (I wrote the patch, and last I heard it hadn't even been considered... ) I posted the patch here a while back - while it may take a little hacking, it should work fine with the latest vpopmail. Please re-email it directly to me and I'll put it in my queue of patched for vpopmail. A slew of them were just posted to SourceForge, so I'll probably try to get a 5.4.18 release out before too long. -- Tom Collins - [EMAIL PROTECTED] Vpopmail - virtual domains for qmail: http://vpopmail.sf.net/ QmailAdmin - web interface for Vpopmail: http://qmailadmin.sf.net/
Re: [vchkpw] Why is vadduser creating a hierarchy?
On 10/14/06, Bert JW Regeer [EMAIL PROTECTED] wrote: On Oct 14, 2006, at 16:06:30 MST, Rainer Duffner wrote: See above. DJB was or is a (Free)-BSD user (when he started, Linux was a toy anyway), which back in these days had this problem. Agreed, however his Maildir approach did not include hashing in any way shape or form, so how did file systems back then handle over 1000's of email messages in an Inbox? Poorly. I had a server stall after a user stopped checking mail and accumulated 100,000 messages in a single folder. The filesystem was basically unusable. That was on FreeBSD 4.6, IIRC. Once I cleared that up, the mysterious slowness in general of the machine disappeared. -- Jon
