[vchkpw] Convert MySQL to LDAP?
Is it possible to convert from MySQL to LDAP authentication in any sort of a sane manner? I'm trying to couple two systems together, one of them being closed-source. The only available way to couple qmail together with my CS application without programming an intermediary black-box is to convert my qmail back-end to LDAP. -- --- - Nick Bright Network Administrator Valnet, LLC Tel 888-332-1616 x 315 Fax 620-332-1201 !DSPAM:4a0044fa32689579318546!
Re: [vchkpw] Qmail admin quota assignment
compile qmail-admin with --enable-modify-quota --- - Nick Bright Network Administrator Terra World Communications, LLC Tel 888-332-1616 x 315 Fax 620-332-1201 Tariq Azad/OPS wrote: Can any body tell me how to enable quota in qmail admin so that postmaster could assign quota from the qmailadmin control panel Thanks. !DSPAM:489873b032315753898114!
Re: [vchkpw] Local delivery and routing to another server
It sounds like you are wanting to use what some packages call a smarthost, and relay all of your non-local mail through a particular server. To use one server as a smarthost for all outbound mail, place in smtproutes: :smarthostip If you want to relay only specific domains use: domain.tld:smarthost.ip domain2.tld:smarthost.ip If you want to relay specific domains to specific locations use: domain.tld:smarthost.ip domain2.tld:smarthost2.ip If you want to do specific domains to one smarthost, and catchall to another, use: domain.tld:smarthost.ip :smarthost2.ip --- - Nick Bright Network Administrator Terra World Communications, LLC Tel 888-332-1616 x 315 Fax 620-332-1201 [EMAIL PROTECTED] wrote: Hi All, I have a server that is used to authenticated relay and where alsothe local domains are. I would like to know if is possible, and how, to do the following: - a mail is sent to a local domain and it is delivered locally - a mail is sent to a non-local domain and it is forward to another machine that will do the relay. I don't pretend too use this server as a relay to the outside. Is this configuration possible? Should I use in smtproutes :ip of other machine and it will do the job? Thanks, Sérgio Rosa !DSPAM:489874e332314137136428!
[vchkpw] Problems with domain limits
Greetings, I've got an installation of vpopmail 5.4.17, vqadmin 2.3.6, and qmailadmin 1.2.11 (updated vqadmin and qmailadmin trying to fix this issue). This issue started when I recompiled qmailadmin to remove domain-autofill, and I came across it once before long ago - but lost/forgot the fix. What happens is that vpopmail (even when compiled with --disable-mysql-limits) stores all information in the SQL table limits. Qmailadmin, regardless of how vpopmail is compiled, will only look in the SQL table for limit information, and does not have a compile flag to tell it to pay attention to the .qmailadmin-limits file. Vqadmin, regardless of how vpopmail is compiled, will only look at the .qmailadmin-limits file, and does not have a compile flag to tell it to look in the database instead. Though I would prefer that things look at the .qmailadmin-limits file (since that's where all the limits are defined currently) I don't really care if the limits are in .qmailadmin-limits, or in the sql table, I just need to know how to get _all_ of the applications to look at the same thing. If it has to be in SQL, I can go through all my domains and put them in the database. Any advice is welcome, thanks in advance. -- --- - Nick Bright Network Administrator Terra World Tel 888-332-1616 x 315 Fax 620-332-1201 !DSPAM:48483e5232352133457548!
Re: [vchkpw] Problems with domain limits
Update to this issue: It seems a little odd, but with vpopmail compiled for --disable-mysql-limits if the limits table exists, vmoddomlimits will apply settings to that table. If the table is deleted, it applies them to the .qmailadmin-limits file. So now, vpopmail and vqadmin are talking to .qmailadmin-limits; all that remains is to get qmailadmin to talk to .qmailadmin-limits. Any tips? --- - Nick Bright Network Administrator Terra World Tel 888-332-1616 x 315 Fax 620-332-1201 Nick Bright wrote: Greetings, I've got an installation of vpopmail 5.4.17, vqadmin 2.3.6, and qmailadmin 1.2.11 (updated vqadmin and qmailadmin trying to fix this issue). This issue started when I recompiled qmailadmin to remove domain-autofill, and I came across it once before long ago - but lost/forgot the fix. What happens is that vpopmail (even when compiled with --disable-mysql-limits) stores all information in the SQL table limits. Qmailadmin, regardless of how vpopmail is compiled, will only look in the SQL table for limit information, and does not have a compile flag to tell it to pay attention to the .qmailadmin-limits file. Vqadmin, regardless of how vpopmail is compiled, will only look at the .qmailadmin-limits file, and does not have a compile flag to tell it to look in the database instead. Though I would prefer that things look at the .qmailadmin-limits file (since that's where all the limits are defined currently) I don't really care if the limits are in .qmailadmin-limits, or in the sql table, I just need to know how to get _all_ of the applications to look at the same thing. If it has to be in SQL, I can go through all my domains and put them in the database. Any advice is welcome, thanks in advance. !DSPAM:4848456632351386346584!
Re: [vchkpw] Problems with domain limits
Odd. I can't explain it other than I must have done something in the wrong order, because I installed qmailadmin-1.2.11 after recompiling vpopmail-5.4.17 without mysql-limits, but I did a make clean and make install-strip on qmailadmin-1.2.11 as you suggested and now it's reading the .qmailadmin-limits file. --- - Nick Bright Network Administrator Terra World Tel 888-332-1616 x 315 Fax 620-332-1201 Rick Macdougall wrote: Nick Bright wrote: Update to this issue: It seems a little odd, but with vpopmail compiled for --disable-mysql-limits if the limits table exists, vmoddomlimits will apply settings to that table. If the table is deleted, it applies them to the .qmailadmin-limits file. So now, vpopmail and vqadmin are talking to .qmailadmin-limits; all that remains is to get qmailadmin to talk to .qmailadmin-limits. After recompiling vpopmail with --disable-mysql-limits, make clean and make qmailadmin. That should fix the problem. qmailadmin reads fine from .qmailadmin-limits here. Regards, Rick !DSPAM:484851b632351682512477!
Re: [vchkpw] Distribute Qmail + Vpopmail bundle
Joshua Megerman wrote: On Saturday 23 February 2008 01:55:14 pm Nick Bright wrote: While the qmail sources are available, it is not GPL. It's my understanding that the way qmail is licensed specifically forbids repackaging. Um, no. As the original poster stated qmail is now in the public domain, which means there is not only no restrictions to its distribution, there's not even any license anymore. Well, that is excellent. I was not aware that it had been placed into the public domain. Perhaps now someone could get a project together with some traction to integrate all of the best patches into qmail and make a technologically recent package that doesn't have to have 15 patches applied to get anything resembling a recent feature set. I for one would love to see inter7 take the lead on such a project, as they have a proven track record and as far as I can tell, know qmail quite well. And please try not to top-post :) I'll never understand why people don't like top posting. I find it easier to read, but lets not get OT on this; I'm sure it's been argued about before. Josh !DSPAM:47c2e0ce310547801340479!
Re: [vchkpw] Distribute Qmail + Vpopmail bundle
While the qmail sources are available, it is not GPL. It's my understanding that the way qmail is licensed specifically forbids repackaging. Serhiy wrote: Hello, Now, when Qmail sources are in public domain don't you think that it makes sense to release not bundle containing Qmail already integrated with vpopmail? You can use qmil sources to build complete mailing solution. Do you have any plans on this? Thanks, -- Serhiy !DSPAM:47c06c16310548697717900!
[vchkpw] Feature support questions: CRAM-MD5, SPA/APOP, SSL
I'm working on adding security features and compatability to my server, which is currently running vpopmail 5.4.17. At the moment, everything is working fine, but there are many features my system doesn't support. My end goal is to support virtually any combination of server options in Outlook Express. While personally I detest OE, it is without a doubt the most commonly used email client, so I'd like to make sure I support it as well as possible. Currently, if someone check marks Secure password authentication in OE (either for SMTP or POP), it does not work. Is it possible to get qmail/vpopmail to support that option for both POP and SMTP? I've already got SMTP Authentication SMTP CRAM-MD5 working properly, based on the vpopmail contrib patch for such; as well as IMAP-SSL, IMAP-TLS (courier-imap). However, courier-imap doesn't seem to want to use CRAM-MD5. Is there something specific about vchkpw that would cause that to not work? Does anyone on the list know if there are patches for qmail-pop3d to support CRAM-MD5 and TLS? I've already reviewed getting STUNNEL going, and while I haven't gotten it working yet, I think I'm close. I don't need step by step instructions, as I've been maintaining a qmail/vpopmail server for several years; but I would appreciate any pointers towards good patches for supporting these features - if they exist. Thanks, -- --- - Nick Bright Network Administrator Terra World Tel 888-332-1616 x 315 Fax 620-332-1201 !DSPAM:47bf53fe310541652013443!
Re: [vchkpw] OT: Which RBLsmtpd lookups are you using?
I find that checking spamcop first, then spamhaus second reduces the level of spamhaus hits to a level that they didn't complain about. They banned me once before I switched the order I check in. --- - Nick Bright Network Administrator Terra World Tel 888-332-1616 x 315 Fax 620-332-1201 Rainer Duffner wrote: ISP Lists schrieb: My thanks to everyone who contributed! I'm on zen.spamhaus.org now! Noticed at least some increase in stopped connections at smtpd! A good thing, in my review. I'll research FPs for downside. Thanks! Spamhaus blocks everyone who has too many requests. They want you to sign up for their commercial service... I use spamcop, sorbs and a local BL. I have whitelisted all of my country's dynamic IPs, though, so I can block all other dyn-IPs via SORBS. cheers, Rainer !DSPAM:47bf5529310541172215792!
Re: [vchkpw] qmail high performance
WOW your iowait state is WAY too high. Seems to me like you probably need to make some hard drive changes. What is your current drive configuration? Please be as specific as possible. If it helps, I'll describe my configuration: I'm using three RAID arrays. Two are RAID1 and one is RAID10, with one RAID1 and the RAID10 on an LSI MegaRAID SATA 300-X8 (six drives, 160GB SATA-II). The other RAID1 is a pair of 15,000 RPM Ultra 320 SCSI drives using linux software RAID1. The SATA RAID1 contains / The SATA RAID10 contains /usr/local/vpopmail/domains The SCSI RAID1 contains /tmp and some other working directories Here are my load numbers at the random moment I went and copied them. This can fluctuate anywhere from a little more heavily used than this, to 95% idle (for reference it's a dual 2Ghz Xeon): top - 12:49:26 up 138 days, 3:59, 1 user, load average: 2.31, 2.78, 2.30 Tasks: 238 total, 2 running, 233 sleeping, 0 stopped, 3 zombie Cpu0: 23.6% us, 15.9% sy, 0.0% ni, 58.0% id, 2.1% wa, 0.4% hi, 0.0% si Cpu1: 34.4% us, 10.5% sy, 0.0% ni, 54.2% id, 1.0% wa, 0.0% hi, 0.0% si Cpu2: 25.4% us, 10.9% sy, 0.0% ni, 62.4% id, 1.4% wa, 0.0% hi, 0.0% si Cpu3: 17.3% us, 11.9% sy, 0.0% ni, 68.4% id, 2.3% wa, 0.0% hi, 0.0% si Mem: 2074860k total, 2043580k used,31280k free, 254412k buffers Swap: 4194296k total,38020k used, 4156276k free, 887628k cached --- - Nick Bright Network Administrator Terra World Tel 888-332-1616 x 315 Fax 620-332-1201 João Luiz - Terra wrote: Hi Nick. Thank you. When concurrent POP3 is low, the loadavg of my server is low too. My i/o is very high. Is normal? If any user to connect in POP3, Can he to start a attack to up my I/O? CPU states: cpuusernice systemirq softirq iowaitidle total 10,8%0,0%1,0% 0,0% 0,2% 84,8%2,9% cpu00 25,1%0,0%0,5% 0,0% 0,1% 74,0%0,0% cpu01 12,1%0,0%0,9% 0,0% 0,3% 86,4%0,0% cpu024,3%0,0%1,7% 0,0% 0,1% 87,8%5,7% cpu031,5%0,0%0,7% 0,0% 0,3% 91,2%5,9% Regards, Joao - Original Message - From: Nick Bright [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Monday, October 08, 2007 5:07 PM Subject: Re: [vchkpw] qmail high performance João Luiz - Terra wrote: Hi Rick, In SMTP Totals: Max Allow 14.2 kSMTP (1422.7%) Average Allow 8345.0 SMTP (834.5%) Current Allow 8694.0 SMTP (869.4%) Max Deny 11.4 kSMTP (1140.6%) Average Deny 6337.0 SMTP (633.7%) Current Deny 5181.0 SMTP (518.1%) What is Deny? Deny is rejected SMTP sessions, usually due to an RBL rejection but this can also be due to mailbox full or user not existing if you are using the CHKUSER patch. Is Deny high? That doesn't strike me as overly high, over the last 24 hours I've had: Max Allow 73.7 kSMTP (147.4%) Average Allow 36.5 kSMTP (73.0%) Current Allow 42.3 kSMTP (84.6%) Max Deny 54.2 kSMTP (108.4%) Average Deny 21.5 kSMTP (43.0%) Current Deny 30.4 kSMTP (60.9%) I wouldn't worry about the denies because they don't cause significant load - as long as you're rejecting their connections, you don't have the deal with the load of processing their mail. Do you want see others logs of qmailmrtg? Thank you Joao - Original Message - From: Rick Macdougall [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Sunday, October 07, 2007 10:11 AM Subject: Re: [vchkpw] qmail high performance Hi, João Luiz - Terra wrote: Hi Tren, Sorry. My english is not good :). My server is dual xeon 2.4 with 2 Gb RAM and HD SCSI 73 Gb. I have problems with delivery delay when my server is with many connections POP3 and SMTP. I use isoqlog to analyze my email traffic, but I don´t have stats of POP3 and connections with my SMTP (RBL, no delivery, ...). Exists any software to analyze POP3 and SMTP log? qmailmrtg7 is a graphing tool for qmail/pop3/dnscache etc. You can find it at http://www.inter7.com When my server is slow, I have: SMTP concurrent: 40 - 50 POP3 concurrent: 20 - 30 Load Average: 30 - 40 Are you running SA and Clam on the same machine ? Also, are you running the update_tmprsadh nightly (if your not it has to generate a new key for every encrypted connection). I have many SMTP connections with not existing recipient. If that message is in the smtpd log, that's fine. You may also want to look at decreasing your timeoutsmtpd, put 180 or something similar in /var/qmail/control/timeoutsmtpd to change the default of 7200 (this will stop the spam zombie who hang around just using up a connection slot). My server was very good. Between last monday and last friday it is very slow. How can I identify a possible attack? Hope the above helps. Regards, Rick Esta mensagem foi verificada pelo E-mail Protegido Terra. Scan engine: McAfee VirusScan / Atualizado em 05/10/2007 / Versão: 5.1.00/5135 Proteja o seu e-mail Terra: http://mail.terra.com.br
Re: [vchkpw] qmail high performance
I had the same problems under high load on a similarly configured machine (2.0Ghz instead of 2.4Ghz, but other than that about the same). When I installed the external big todo patches it helped A LOT, but I still have some delay in delivery. However it is much more acceptable as messages can be delayed one to two minutes, instead of fifteen to twenty minutes. Usually things go through fairly instantly. The single best performance enhancer you could do would be the external todo patch, from my point of view. I also found that the chkuser patch also helped a LOT, I highly recommend using that patch as well. For reference, I'm not using Bill's toaster, but rather my own custom brew. Another load reducing method is to use a much faster anti-spam product, but you will most likely have to pay for that. I suggest MPPd (messagepartners.com) I've been using it for several years with the Cloudmark plugin and it is much more effective than spamassassin, with hundreds of times lower load on the system. --- - Nick Bright Network Administrator Terra World Tel 888-332-1616 x 315 Fax 620-332-1201 João Luiz - Terra wrote: Hi Tren, Sorry. My english is not good :). My server is dual xeon 2.4 with 2 Gb RAM and HD SCSI 73 Gb. I have problems with delivery delay when my server is with many connections POP3 and SMTP. I use isoqlog to analyze my email traffic, but I don´t have stats of POP3 and connections with my SMTP (RBL, no delivery, ...). Exists any software to analyze POP3 and SMTP log? When my server is slow, I have: SMTP concurrent: 40 - 50 POP3 concurrent: 20 - 30 Load Average: 30 - 40 I have many SMTP connections with not existing recipient. My server was very good. Between last monday and last friday it is very slow. How can I identify a possible attack? Thank you Joao - Original Message - From: Tren Blackburn [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Saturday, October 06, 2007 8:02 PM Subject: RE: [vchkpw] qmail high performance Hi Joao; From: João Luiz - Terra [mailto:[EMAIL PROTECTED] Sent: Saturday, October 06, 2007 3:22 PM To: vchkpw@inter7.com Subject: [vchkpw] qmail high performance Hello, I am working with qmail toaster by http://www.shupp.org/toaster/. Is it the better performance instalation? My server is very slowly :( You'll need to give something specific here. Bill Shupps Toaster is widely popular. I use it myself and have no issues with performance. What are the specifications of the hardware you've implemented it on. What specifically is performing slow? Is there anything else on this server? Approximately how many mailboxes are housed on this server? How many deliveries per second/minute/hour/day (whatever is easiest to convey) and do you have any idea what your peak concurrent deliveries are? You need to provide as much information as possible before asking such a general question. Regards, Tren Esta mensagem foi verificada pelo E-mail Protegido Terra. Scan engine: McAfee VirusScan / Atualizado em 05/10/2007 / Versão: 5.1.00/5135 Proteja o seu e-mail Terra: http://mail.terra.com.br/ begin:vcard fn:Nick Bright n:Bright;Nick org:Terra World Communications, LLC adr:Suite #11;;200 ARCO Place;Independence;KS;67301;USA email;internet:[EMAIL PROTECTED] title:Network Administrator tel;work:888-332-1616 tel;fax:620-332-1201 x-mozilla-html:FALSE url:http://home.terraworld.net version:2.1 end:vcard
Re: [vchkpw] qmail high performance
João Luiz - Terra wrote: Hi Rick, In SMTP Totals: Max Allow 14.2 kSMTP (1422.7%) Average Allow 8345.0 SMTP (834.5%) Current Allow 8694.0 SMTP (869.4%) Max Deny 11.4 kSMTP (1140.6%) Average Deny 6337.0 SMTP (633.7%) Current Deny 5181.0 SMTP (518.1%) What is Deny? Deny is rejected SMTP sessions, usually due to an RBL rejection but this can also be due to mailbox full or user not existing if you are using the CHKUSER patch. Is Deny high? That doesn't strike me as overly high, over the last 24 hours I've had: Max Allow 73.7 kSMTP (147.4%) Average Allow 36.5 kSMTP (73.0%) Current Allow 42.3 kSMTP (84.6%) Max Deny 54.2 kSMTP (108.4%) Average Deny 21.5 kSMTP (43.0%) Current Deny 30.4 kSMTP (60.9%) I wouldn't worry about the denies because they don't cause significant load - as long as you're rejecting their connections, you don't have the deal with the load of processing their mail. Do you want see others logs of qmailmrtg? Thank you Joao - Original Message - From: Rick Macdougall [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Sunday, October 07, 2007 10:11 AM Subject: Re: [vchkpw] qmail high performance Hi, João Luiz - Terra wrote: Hi Tren, Sorry. My english is not good :). My server is dual xeon 2.4 with 2 Gb RAM and HD SCSI 73 Gb. I have problems with delivery delay when my server is with many connections POP3 and SMTP. I use isoqlog to analyze my email traffic, but I don´t have stats of POP3 and connections with my SMTP (RBL, no delivery, ...). Exists any software to analyze POP3 and SMTP log? qmailmrtg7 is a graphing tool for qmail/pop3/dnscache etc. You can find it at http://www.inter7.com When my server is slow, I have: SMTP concurrent: 40 - 50 POP3 concurrent: 20 - 30 Load Average: 30 - 40 Are you running SA and Clam on the same machine ? Also, are you running the update_tmprsadh nightly (if your not it has to generate a new key for every encrypted connection). I have many SMTP connections with not existing recipient. If that message is in the smtpd log, that's fine. You may also want to look at decreasing your timeoutsmtpd, put 180 or something similar in /var/qmail/control/timeoutsmtpd to change the default of 7200 (this will stop the spam zombie who hang around just using up a connection slot). My server was very good. Between last monday and last friday it is very slow. How can I identify a possible attack? Hope the above helps. Regards, Rick Esta mensagem foi verificada pelo E-mail Protegido Terra. Scan engine: McAfee VirusScan / Atualizado em 05/10/2007 / Versão: 5.1.00/5135 Proteja o seu e-mail Terra: http://mail.terra.com.br/ begin:vcard fn:Nick Bright n:Bright;Nick org:Terra World Communications, LLC adr:Suite #11;;200 ARCO Place;Independence;KS;67301;USA email;internet:[EMAIL PROTECTED] title:Network Administrator tel;work:888-332-1616 tel;fax:620-332-1201 x-mozilla-html:FALSE url:http://home.terraworld.net version:2.1 end:vcard
[vchkpw] Grey Listing / RBL Update
I read in the Inter7 Spring 07 newsletter about Windows Grey Listing and a tasty RBL update. I'm not sure if this is the right place to post about it, but I would like to try these technologies on my mail server, but I wasn't able to find any downloads for the packages on the Inter7 website. Any idea when they will be available? http://www.inter7.com/?page=news is the page I found these references on. -- --- - Nick Bright Terra World, Inc 888-332-1616 x 315
[vchkpw] Adjusting the default .qmail-default
I would like to adjust the default options that are placed in the .qmail-default file when a domain is created, or when a modification is made to a domian through qmailadmin, such that my customizations are preserved. Currently if any changes are made, I loose my pipe to spamc that I run from .qmail-default, also if a user gets a custom .qmail file, they don't get spam-scanned. Basically, I'd just like to know where this is stored at and how to adjust it if it's not just a simple file. Thanks in advance. -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616
Re: [vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences
Well, It looks like I was having a dumbass attack. The table name in my database was wrong, once I fixed that, the error message went away (as it was table doesn't exist. It still appears to be not pulling the username correctly though, and I would like to know how to properly adjust that. It is also not creating the prefrences entry if it doesn't exist, which I belive it should. Again, any assistance is greatly appreciated. On Wed, 2004-08-18 at 14:30, Nick Bright wrote: Greetings, I'm using vpopmail 5.4.5 on WhiteBox EL 3.0, and I'm trying to set up per-user prefrences with spamassassin (spamc called from .qmail). I don't care if it works with SQL or just puts a user_prefs file in each users' Maildir. My spamd is running with the following options: SPAMDOPTIONS=--daemonize --local --nouser-config --sql-config --create-prefs --username=vpopmail --vpopmail --socketpath=/var/run/spamd.socket --max-children=64 and my .qmail-default file contains: | /usr/bin/spamc -U /var/run/spamd.socket | /usr/local/vpopmail/bin/vdelivermail '' bounce-no-mailbox As far as I can tell, this should tell spamd to get the username from vpopmail and query the information out of the database, creating the prefrences if they don't exist already. When I send a test message I get this error in my maillog: Aug 18 14:09:47 node0 spamd[32368]: SQL Error: select preference, value from user_prefs where username = 'vpopmail' or username = 'GLOBAL' or username = '@GLOBAL' order by username asc Table 'spamassassin.user_prefs' doesn't exist so, it appears to me, that it isn't getting the proper username for some reason. I also tried the same SPAMDOPTIONS without the --username=vpopmail option, and it still came up with a username of vpopmail (since that is the user that calls spamc, I belive). How can I make spamc read the appropriate username and pass it to spamd, or how can I make spamd read this from vpopmail? I have also tried this configuration, which I thought should have created/used a file in the users' Maildir: SPAMDOPTIONS=--daemonize --local --create-prefs --username=vpopmail --vpopmail --socketpath=/var/run/spamd.socket --max-children=64 Again, I tried this one with and without the --username=vpopmail, they both showed it being run as the vpopmail user in the log file. I don't care if it works via a file in the maildir, or via SQL, but I would really like to get user prefrences working, any advice that anyone can give would be very much appreciated. Thanks. -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616
Re: [vchkpw] vpopmail 5.4.5 + spamassassin 2.64 sql user prefrences
On Wed, 2004-08-18 at 14:37, Nicholas Harring wrote: Nick Bright wrote: and my .qmail-default file contains: | /usr/bin/spamc -U /var/run/spamd.socket | /usr/local/vpopmail/bin/vdelivermail '' bounce-no-mailbox As far as I can tell, this should tell spamd to get the username from vpopmail and query the information out of the database, creating the prefrences if they don't exist already. When I send a test message I get this error in my maillog: Aug 18 14:09:47 node0 spamd[32368]: SQL Error: select preference, value from user_prefs where username = 'vpopmail' or username = 'GLOBAL' or username = '@GLOBAL' order by username asc Table 'spamassassin.user_prefs' doesn't exist so, it appears to me, that it isn't getting the proper username for some reason. I also tried the same SPAMDOPTIONS without the --username=vpopmail option, and it still came up with a username of vpopmail (since that is the user that calls spamc, I belive). I use: preline /usr/bin/spamc -s 1000 -u [EMAIL PROTECTED] Ok, I added your -u [EMAIL PROTECTED] to my spamc line, and I get the following log entries when sending a message: Aug 18 14:35:09 node0 spamd[32486]: processing message [EMAIL PROTECTED] for [EMAIL PROTECTED]:0. Aug 18 14:35:09 node0 spamd[32486]: identified spam (1001.0/5.0) for [EMAIL PROTECTED]:0 in 0.1 seconds, 2678 bytes. So it appears to be getting the address properly (yay!), however, it didn't create a prefs entry in the database. If it's as simple as it doesn't make it automatically, and just uses the default if it's not there is fine, I just don't know and couldn't really tell from the documentation. My table is set up as such: ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | username | varchar(100) | | MUL | || | preference | varchar(30) | | | || | value | varchar(100) | | | || | prefid | int(11) | | PRI | NULL| auto_increment | ++--+--+-+-++ Does that cause a problem? It's the table description I got from the documentation at http://old.spamassassin.org/full/2.6x/dist/sql/README, but I had to remove the word default because it wouldn't create the table with that on there. Maybe that's the problem? Perhaps at this point, I need to take my question to the spamassassin list? Thanks for your time. Works like a charm for me. Hope that helps, Nick Harring Webley Systems -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616
[vchkpw] vdelivermail traversing all maildirs on server before delivering mail
I'm setting up a new server with vpopmail 5.4.4 (should be the latest stable?), and everything was working as it should until I got to the point of load testing. I added 10,000 accounts (not quite as many as I have on the production server, which runs vpopmail 5.2.1) to test.com on the server with this script: #!/bin/bash # Script to create some email accounts on the test server @test.com for i in `seq 1 1`; do /usr/local/vpopmail/bin/vadduser -n [EMAIL PROTECTED] done which completes in fairly short order (took about 2 minutes) with no errors. Looking at the domain in vqadmin and through mysql directly show all the users, and everything looks fine. However, when I then send a mail to any user (doesn't matter which) qmail-local kicks off the delivery process and it takes a LONG time and there is LOTS of disk access. By using the lsof command i was able to see what files vdelivermail had open, and it was pretty clear that it was traversing EVERY maildir on the domain (only one domain right now - I don't know if it would traverse other domains as well) before delivering the mail to the correct Maildir (which it will do eventually). While not documented as not right, it clearly isn't supposed to do that (as it would take forever for the server to get anything done). Is this a known issue? Possibly my compile-time options for vpopmail? Did I do something wrong, or is this a bug? Any comments/suggestions are welcome. -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616
Re: [vchkpw] vdelivermail traversing all maildirs on server before delivering mail
On Tue, 2004-06-29 at 19:20, Tom Collins wrote: On Jun 29, 2004, at 5:09 PM, Nick Bright wrote: I will try this, but could you elaborate on why that is/would cause this? Is this 'by design' for a setup with domain limits turned on? It's a poor design that requires vdelivermail to traverse the entire domain to determine whether it's over quota or not. Ah. I see, thanks Tom. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/ -- - Nick Bright Terraworld, Inc http://home.terraworld.net | 888-332-1616