[vchkpw] simscan quesiton: error
Hi, Since there is no official list for simscan and this was the list where few simscan questions were asked and answered, I am taking the liberty of asking it here. I have simscan-1.0 which i installed by, ./configure make make install-strip In my smtpd/run file I have, export QMAILQUEUE=/var/qmail/bin/simscan But when I try to send a message I get, 451 mail server temporarily rejected message (#4.3.0) I tried to increase softlimit but still the same error. Can someone tell what is wrong? With warm regards, -Payal
Re: [vchkpw] chkuser 2.0 - doc typos
Of course, there are a lot of typos and errors (all docs have been written in few days and, first of all, I'm not english motherlanguage), so thanks anyone for warning me: write directly to [EMAIL PROTECTED] Ciao, Tonino At 23/09/2004 23/09/2004 -0600, you wrote: Tonix cambia questo who's sending to who a who's sending to whom Ciao, Remo - Original Message - From: tonix (Antonio Nati) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 23, 2004 4:16 PM Subject: [vchkpw] chkuser 2.0 chkuser 2.0 has been released. New version is available on: http://www.interazioni.it/opensource/chkuser. These are the most evident changes: - new design, a lot more easy to install and update - extended logging - flexible and powerful tarpitting - quota checking - Makefile working with every vpopmail database (cdb, MySQL, LDAP, Postgres, etc.) - a lot of chkuser settings added - change of name, from chkusr to chkuser. 2.0 has been tested and put in production for more than one month, than other people has tested it before this public release (thanks to Juergen Kendzorra, Remo Mattei, Bill Shupp, Machiel Kuitert). As usual, test it deeply before putting on production system. Tonino [EMAIL PROTECTED]Interazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED] [EMAIL PROTECTED]Interazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED]
[vchkpw] Quota
Hello all, I am currently using a qmail/vpopmail setup and the vqadmin control panel. I would like to know a bit more about how the quota system works. I currently set the 'quota size' to 50,000,000 bytes. How can I limit the domain's quota to X bytes rather than limiting a user's disk as I would prefer to have our customers set up a large number of mail boxes but not letting the domain go over a given size. -- Regards, Ed.
Re: [vchkpw] Courier-Imap with Vpopmail help
I noticed that you set the following: AUTHMODULES=authvchkpw Did you also set what is listed below: Edit /usr/lib/courier-imap/etc/authdaemonrc Change authmodulelist=... to authmodulelist=authvchkpw Edit /usr/lib/courier-imap/etc/imapd Change 'IMAPDSTART=NO' to 'IMAPDSTART=YES' Edit /usr/lib/courier-imap/etc/imapd-ssl Change 'IMAPDSSLSTART=NO' to 'IMAPDSSLSTART=YES' Hey all, I've just moved to qmail with vpopmail and i'm following this doc http://www.qmailrocks.org/ Now i'm tring to get courier-imap working correctly, when i try pop3 access i login fine, however imap is a different story kristine:~# telnet localhost 143 Trying 127.0.0.1... Connected to localhost.localdomain. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP ready. Copyright 1998-2004 Double Precision, Inc. See COPYING for distribution information. a login [EMAIL PROTECTED] kilo22 a NO Login failed. This is in /var/log/mysql/mysql.log This is the table return mysql select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd from wtfhax_com where pw_name = tristram; +--++++++--+-+ | pw_name | pw_passwd | pw_uid | pw_gid | pw_gecos | pw_dir | pw_shell | pw_clear_passwd | +--++++++--+-+ | tristram | $1$CNMfwBu0$2JeNEmXhQPH8kTUCOMBii. | 0 | 8 | Tristram+Cheer | /home/vpopmail/domains/wtfhax.com/tristram | NOQUOTA | realpass | +--++++++--+-+ 1 row in set (0.00 sec) I've changed my /etc/courier/imapd file to AUTHMODULES=authvchkpw I run a debian system and i'm pulling my hair out, what am i doing wrong Is anyone able to help?
Re: [vchkpw] Quota
On Sep 24, 2004, at 6:02 AM, Edward Neville wrote: How can I limit the domain's quota to X bytes rather than limiting a user's disk as I would prefer to have our customers set up a large number of mail boxes but not letting the domain go over a given size. Vpopmail has domain quotas, but they're broken. Even if/when they do work, they add a lot of load since vdelivermail has to calculate the domain's disk usage every time a message is delivered. I didn't write the original implementation, I don't use them myself, and I'm not particularly interested in finding the problem and fixing it. -- 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/
Re: [vchkpw] Patch for problems with valiases and PostgreSQL/MySQL
It should apply to 5.4.7 or 5.4.6. It might even work for any 5.4.x release. On Sep 23, 2004, at 10:20 PM, Remo Mattei wrote: so should I apply this to the 5.4.7 then? Remo - Original Message - From: Tom Collins To: vpopmail list Sent: Thursday, September 23, 2004 10:37 PM Subject: [vchkpw] Patch for problems with valiases and PostgreSQL/MySQL If you're using the valias table with PostgreSQL or MySQL, please take a look at the following patch: http://sourceforge.net/tracker/index.php? func=detailaid=1033801group_id=85937atid=577800 It should make valiases actually work for PostgreSQL (they didn't before now). Also, the old code didn't work if you had Maildir delivery lines in the valias table. If you fall into either of those categories, please try the patch and let me know whether it works for you. -- 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/ -- 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/
Re: [vchkpw] Patch for problems with valiases and PostgreSQL/MySQL
Tom Collins wrote: If you're using the valias table with PostgreSQL or MySQL, please take a look at the following patch: Possibly you would be the man to answer this question for me? http://www.mail-archive.com/[EMAIL PROTECTED]/msg19410.html I've read all the posts in the archive afterching on valias, a lot of posts, and I think my assumptions are correct. I would like to know if there are any limitations I should be aware of. Thanks, DAve http://sourceforge.net/tracker/index.php? func=detailaid=1033801group_id=85937atid=577800 It should make valiases actually work for PostgreSQL (they didn't before now). Also, the old code didn't work if you had Maildir delivery lines in the valias table. If you fall into either of those categories, please try the patch and let me know whether it works for you. -- 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/ -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] simscan quesiton: error
On Friday 24 September 2004 01:16 am, Payal Rathod wrote: Hi, Since there is no official list for simscan and this was the list where few simscan questions were asked and answered, I am taking the liberty of asking it here. I have simscan-1.0 which i installed by, ./configure make make install-strip In my smtpd/run file I have, export QMAILQUEUE=/var/qmail/bin/simscan But when I try to send a message I get, 451 mail server temporarily rejected message (#4.3.0) I tried to increase softlimit but still the same error. Can someone tell what is wrong? If you are not running qmail-smtpd as root you may need to change the ownership of simscan to match qmail-smtpd. Ken Jones
Re: [vchkpw] chkuser 2.0
On Thursday 23 September 2004 05:16 pm, tonix (Antonio Nati) wrote: chkuser 2.0 has been released. New version is available on: http://www.interazioni.it/opensource/chkuser. These are the most evident changes: - new design, a lot more easy to install and update - extended logging - flexible and powerful tarpitting - quota checking - Makefile working with every vpopmail database (cdb, MySQL, LDAP, Postgres, etc.) - a lot of chkuser settings added - change of name, from chkusr to chkuser. 2.0 has been tested and put in production for more than one month, than other people has tested it before this public release (thanks to Juergen Kendzorra, Remo Mattei, Bill Shupp, Machiel Kuitert). As usual, test it deeply before putting on production system. Excellent work! I can't wait to try it out. Nice going! Ken Jones
Re: [vchkpw] simscan quesiton: error
On Fri, Sep 24, 2004 at 09:41:09AM -0500, Ken Jones wrote: If you are not running qmail-smtpd as root you may need to change the ownership of simscan to match qmail-smtpd. I run qmail-smtpd as qmaild and now I have, # ls -l simscan -rwxr-xr-x 1 qmaild nofiles 6136 Sep 24 11:25 simscan Still the same problem. I am running Mandrake 10.0 With warm regards, -Payal
RE: [vchkpw] what appears to be mysql errors inside.... and other questions
-Original Message- From: Dave Goodrich [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 4:25 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] what appears to be mysql errors inside and other questions Grimes, David wrote: Hello all, New user/abuser here... 1. Last night, due to a problem with a corporate mail server, my mail server got flooded with ~20k emails. It tried like heck to chew through them but the poor little machine just wasn't havin' it. My setup is a gentoo box running vpopmail, qmail, qmail-scanner, spamassassin, -prot, and courier-et al. with the latest packages as of yesterday. I have two questions 1. Outside of better hardware what are some things I should do to the software config to better equip it for things? Switches, etc... What do you have now for hardware? [DG] Athlon 1700 512 60gig ide drive What version of SA are you running? [DG] SA is 2.6.3 What extra rules are your running in SA? [DG] I used the out of the box rule set. Since reading your message I've removed the RBL and razor checks/usage. How many messages do you normally handle a day? [DG] this machine sees ~25k messages a day I have found that when getting blasted to the extent that it becomes a hardware issue, turning off SA until you can get the queue cleared helps quite a bit. [DG] I eventually did that but for about 4-5 hours my load avg was 400-500 I've got the screen shots to prove it ;) Eventually I blackholed my mx record which allowed my box to catch up on already delievered mail and then removed qmail scanner and let everything through un processed. If you are doing Razor lookups in SA, stop. I've not found Razor to make a difference in spam caught compared to to the network and system resources it consumes. If you are doing RBL lookups in SA, stop. RBL lookups are considerably faster with qmail and saves you having to process a message that you later would dump when it gets to SA anyway. Example; I move 40k to 50k inbound messages a day, 65k+ of those I dropped at the smtp level via qmail. If I had used RBL lookups in SA I would have over doubled my SA load. Number two, this message appeared quite often last night. What exactly is it telling me? It has been my experience, someone/anyone correct me if I am wrong, but you A) need to upgrade to 5.4.6 as there were changes to the SQL code or B) your MySQL connection was timing out. It seemed to me that those errors went away here when I gave MySQL more resources. Of course, YMMV, and I could be just a nut ;^) DAve [DG] thanks for the input! David I realize this email is vague and poorly worded so any comments, questions, and suggestions to further the discussion would be greatly appreciated. Thanks DG @4000415240cb09be3594 delivery 3013: success: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmys ql:_sql_error[3]:_No_Database_Selected/could_not_create_limits_table_CREATE_ TABLE_limits_(_domain_CHAR(64)_PRIMARY_KEY,___maxpopaccounts___I NT(10)_NOT_NULL_DEFAULT_-1,___maxaliases___INT(10)_NOT_NULL_ DEFAULT_-1,___maxforwards__INT(10)_NOT_NULL_DEFAULT_-1,_ __maxautorespondersINT(10)_NOT_NULL_DEFAULT_-1,___maxmailinglist s__INT(10)_NOT_NULL_DEFAULT_-1,___diskquotaINT(1 2)_NOT_NULL_DEFAULT_0,___maxmsgcount__INT(12)_NOT_NULL_DEFAU LT_0,___defaultquota_INT(12)_NOT_NULL_DEFAULT_0,___defau ltmaxmsgcount___INT(12)_NOT_NULL_DEFAULT_0,___disable_pop___ ___TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_imap_TINYINT(1)_ NOT_NULL_DEFAULT_0,___disable_dialup___TINYINT(1)_NOT_NULL_DEFAU LT_0,___disable_passwordchanging_TINYINT(1)_NOT_NULL_DEFAULT_0,___di sable_webmail__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_relay___ _TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_smtp_TINYI NT(1)_NOT_NULL_DEFAULT_0,___perm_account_TINYINT(2)_NOT_NULL _DEFAULT_0,___perm_alias___TINYINT(2)_NOT_NULL_DEFAULT_0,___ perm_forward_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_autor esponder___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_maillist___ _TINYINT(4)_NOT_NULL_DEFAULT_0,___perm_quota___TINYINT(2)_NO T_NULL_DEFAULT_0,___perm_defaultquotaTINYINT(2)_NOT_NULL_DEFAULT _0_)/vmysql:_sql_error[p]:_No_Database_Selected/user_does_not_exist,_but_wil l_deliver_to_/var/vpopmail/domains/thegrimesfamily.net/test//did_0+0+1/ -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] The low-down on the valias feature
Tom Collins wrote: On Sep 24, 2004, at 7:25 AM, Dave Goodrich wrote: I've read all the posts in the archive afterching on valias, a lot of posts, and I think my assumptions are correct. I would like to know if there are any limitations I should be aware of. --enable-valias configures vpopmail to store .qmail-alias files in a table. It does not affect the .qmail files in POP/IMAP user directories. Currently, it can only properly handle email forwarding or calling a single program. In the initial design, there wasn't a method to ensure the processing order of alias entries. So, any .qmail-alias file in which the execution order is important (like spam scanning), will not work with valiases. This answers my most pressing question, thank you. It should be a simple fix -- add an auto-incrementing sequence column to the table and sort the results by it. Entries will always be returned in the order they were added. The only problem is we need an easy way to update existing valias tables to add the column. Yes, but if there are no current multi line entries in existing valias tables, then could not all rows be altered to have the column with a value of 1? More complex .qmail files will be difficult to edit/manage if stored in the valias table. Yes, I had thought so as well, which is why I asked. With command line tools this really could be nothing more than add, view, delete an entry. You can store aliases, forwards and autoresponders in the valias table. ezmlm mailing lists need to stay in .qmail files so ezmlm-make can modify them whenever the list's settings are changed. .qmail-default remains as a .qmail file so qmail-local can find it and pass the message on to vdelivermail. This is the one I couldn't find a hint of in the archives! I can use both valias and .qmail files within the same domain? (ezmlm and my spam script are the biggest concerns) Provided I can have both, which hold precedence? If there is a .qmail-user file, and a user entry in valias, which is run and which is not? Thank you, DAve -- 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/ -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] simscan quesiton: error
Check the permissions on the working dir too. Bas At 17:25 9/24/2004, you wrote: On Fri, Sep 24, 2004 at 09:41:09AM -0500, Ken Jones wrote: If you are not running qmail-smtpd as root you may need to change the ownership of simscan to match qmail-smtpd. I run qmail-smtpd as qmaild and now I have, # ls -l simscan -rwxr-xr-x 1 qmaild nofiles 6136 Sep 24 11:25 simscan Still the same problem. I am running Mandrake 10.0 With warm regards, -Payal
RE: [vchkpw] Quota
-Original Message- From: Tom Collins [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 15:02 To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Quota Vpopmail has domain quotas, but they're broken. Even if/when they do work, they add a lot of load since vdelivermail has to calculate the domain's disk usage every time a message is delivered. I didn't write the original implementation, I don't use them myself, and I'm not particularly interested in finding the problem and fixing it. Ok! I have a large number of domains to administer (6000 ish). I Just stumbled upon the high disk usage that one domain had through having many accounts of 50meg mailboxes. Would a quota filesystem be a big overhead? If not, can you suggest a implementation for locking a domain to a quota? If you have any questions or queries please let me know. -- Regards, Ed.
[vchkpw] Vpopmail Randomly Ignoring Quotas?
Greetings, I've run into a strange situation with vpopmail 1.0.6, where it seems to be ingnoring virtual domain quota limits for some mailboxes. For example, in one case, I found in a user's Maildir the normal 'maildirsize' file with the expect 1000S figure in it, yet this user's box is over 700 megs (yes megabytes) in size(!). Vqadmin is showing limits on individual users when I look at them. Must .qmailadmin-limits have the default quota for a given domain for individual user limits to work, or are these settings independent? TIA, --Duncan
Re: [vchkpw] simscan quesiton: error
Bastiaan van der Put wrote: # ls -l simscan -rwxr-xr-x 1 qmaild nofiles 6136 Sep 24 11:25 simscan chmod --reference /var/qmail/bin/qmail-queue \ /var/qmail/bin/simscan /var/qmail/simscan chown --reference /var/qmail/bin/qmail-queue \ /var/qmail/bin/simscan /var/qmail/simscan -- +---+ | Kiril Todorov + System::Network Administrator | +---+ | /* waiting... dreaming... wishing... */ | +---+
Re: [vchkpw] simscan quesiton: error
On Fri, Sep 24, 2004 at 07:01:20PM +0300, Kiril Todorov wrote: chmod --reference /var/qmail/bin/qmail-queue \ /var/qmail/bin/simscan /var/qmail/simscan chown --reference /var/qmail/bin/qmail-queue \ /var/qmail/bin/simscan /var/qmail/simscan Why do I need to have permission of qmail-queue? # ls -l qmail-queue -rws--x--x 1 qmailq qmail 15912 Sep 24 11:38 qmail-queue I believe that simscan appear at smtp level i.e. before the mail hits the queue. -Payal
RE: [vchkpw] Quota
Am Fr, den 24.09.2004 schrieb Edward Neville um 17:34: -Original Message- From: Tom Collins [mailto:[EMAIL PROTECTED] Sent: 24 September 2004 15:02 To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Quota Vpopmail has domain quotas, but they're broken. Even if/when they do work, they add a lot of load since vdelivermail has to calculate the domain's disk usage every time a message is delivered. I didn't write the original implementation, I don't use them myself, and I'm not particularly interested in finding the problem and fixing it. Ok! I have a large number of domains to administer (6000 ish). I Just stumbled upon the high disk usage that one domain had through having many accounts of 50meg mailboxes. Hehe. I've now created a little script: [EMAIL PROTECTED] cat /root/bin/top50.sh #!/bin/sh /root/bin/space.sh |sort -u|xargs du -d 0|sort -n -r |head -n 50 where space.sh contains: #!/bin/sh for i in `~vpopmail/bin/vdominfo -n | egrep -v ^$` do ~vpopmail/bin/vuserinfo -d -D $i done That should at least match the topX accounts. I don't know how well it scales, though. Would a quota filesystem be a big overhead? If not, can you suggest a implementation for locking a domain to a quota? OS Quotas is the only way to go, I'm told. If you have any questions or queries please let me know. I think you must create am OS-group and add the new domain with -g GID_of_the_new_group. Then you can use group-quotas to limit the disk-usage of the files of this particular group. I still have to try this myself- the problem is, there's no GUI to do that, vqadmin doesn't handle GIDs. Rainer -- === ~ Rainer Duffner - [EMAIL PROTECTED] ~ ~ Freising - Munich - Germany ~ ~Unix - Linux - BSD - OpenSource - Security ~ ~ http://www.ultra-secure.de/~rainer/pubkey.pgp ~ ===
[vchkpw] hashing of domain directories
Doesnt vpopmail by default start putting domains into a hashed structure after 100 or so domains? My usernames are hashing, but my domains under /home/cust/vpopmail/domains are all being put into that directory, vadddomain is not branching out into other dirs. Any idea what that could be? Brian -- Brian Feeny, CCIE #8036, CISSP e: [EMAIL PROTECTED] Network Engineer p: 318.213.4709 ShreveNet Inc. f: 318.221.6612 PGP.sig Description: This is a digitally signed message part
[vchkpw] .dir-control format
Can someone post the .dir-control format (the format of the file, and what each value represents)? also if you have a hosed .dir-control structure, how can you rebuild it, so that the .dir-control files are correct? if a .dir-control got deleted, how would that be fixed? Brian -- Brian Feeny, CCIE #8036, CISSP e: [EMAIL PROTECTED] Network Engineer p: 318.213.4709 ShreveNet Inc. f: 318.221.6612 PGP.sig Description: This is a digitally signed message part
[vchkpw] simscan
when i am set the qmailqueue to simscan 451 unable to exec qq (#4.3.0) Itamar Reis Peixoto Analista Consultor TreyNet Consultoria - Uberlândia Tel : + 55 34 3231 0598 Cel: +55 38 9107 1250 http://www.treynet.com.br
[vchkpw] suggestions on this error
success: name:___remo/passwd:_$1$z8tkqJaK$OpE5RB0s9JXXZ/eQYeuTu./clear_passwd:_spoleto/uid:0/gid:0/flags:__0/gecos:_remo/limits:_No_user_limits_set./dir:___/home/vpopmail/domains/rm2.it/remo/quota:_NOQUOTA/usage:_NOQUOTA/account_created:_Sun_Sep_19_15:35:28_2004/last_auth:_Never_logged_in/did_0+0+1/ Hello guys can any suggest me what happen here? the user will not get mail. Thanks, Remo
Re: [vchkpw] .dir-control format
Brian Feeny wrote: Can someone post the .dir-control format (the format of the file, and what each value represents)? This is a close as I have gotten, though I have not updated any further, it seems to be working fine. http://www.mail-archive.com/[EMAIL PROTECTED]/msg19052.html You might want to read all the thread for context. Once I get some other work done I intend to get back to it and write up all I have discovered. also if you have a hosed .dir-control structure, how can you rebuild it, so that the .dir-control files are correct? If you use sql, your dir-control is in there, not in files. I have a perl script that will repair your sql table, for those domains that have an accurate .dir-control file. I did as I converted my domains into MySQL. if a .dir-control got deleted, how would that be fixed? In your earlier post you said you used MySQL, if so you do not need a .dir control file, and vpopmail will not create one. All dir-control info will be in a sql table dir_control. DAve Brian -- Brian Feeny, CCIE #8036, CISSPe: [EMAIL PROTECTED] Network Engineer p: 318.213.4709 ShreveNet Inc. f: 318.221.6612 -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
[vchkpw] Tuning mysql for vpopmail
Hello friends. I have installed vpopmail-5.2.1 + mysql-4.013 running on HP-UX alpha server. It has 1GB of memory with 2 proccesors. I am having problem with mysql at the hours peak. This show me the qmail-send log 2004-09-24 17:32:06.263335500 delivery 96079: failure: vmysql:_sql_error[3]:_Lost_connection_to_My SQL_server_during_query/Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ I have high concurrency (log qmail-send): @40004154ae4c2cd0fbfc status: local 10/100 remote 150/255 My mysql setup is for default ( I haven't /etc/my.cnf created !!!) Somebody have a configuration of mysql for high concurrency and that work with vpopmail? Is possible limit vpopmail for don't use more of 100 connections? Because it reboot my mysql daemon Should I think use postgresql instead of mysql? Thanks for your suggestions Juan
Re: [vchkpw] Tuning mysql for vpopmail
Juan Enciso Condeña wrote: Hello friends. I have installed vpopmail-5.2.1 + mysql-4.013 running on HP-UX alpha server. It has 1GB of memory with 2 proccesors. I am having problem with mysql at the hours peak. This show me the qmail-send log 2004-09-24 17:32:06.263335500 delivery 96079: failure: vmysql:_sql_error[3]:_Lost_connection_to_My SQL_server_during_query/Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ Hi, I use the my-large.cnf (copied to /etc/my.cnf) and I add the following line under the [mysqld] group set-variable = max_connections=500 Works for me (On quite a few servers). Regards, Rick
Re: [vchkpw] .dir-control format
Dave, First thanks alot for posting that link, I appreciate it. I am not in fact using Mysql, perhaps you confused me with someone else. I do plane on moving to a mysql setup, but I need to do so with as little downtime as possible. It seems like there are many different steps, like putting .dir-control in mysql, then putting the vpasswd's in mysql...isn't there something else that is usually put in mysql, like maildir quota files? Brian On Sep 24, 2004, at 3:44 PM, Dave Goodrich wrote: Brian Feeny wrote: Can someone post the .dir-control format (the format of the file, and what each value represents)? This is a close as I have gotten, though I have not updated any further, it seems to be working fine. http://www.mail-archive.com/[EMAIL PROTECTED]/msg19052.html You might want to read all the thread for context. Once I get some other work done I intend to get back to it and write up all I have discovered. also if you have a hosed .dir-control structure, how can you rebuild it, so that the .dir-control files are correct? If you use sql, your dir-control is in there, not in files. I have a perl script that will repair your sql table, for those domains that have an accurate .dir-control file. I did as I converted my domains into MySQL. if a .dir-control got deleted, how would that be fixed? In your earlier post you said you used MySQL, if so you do not need a .dir control file, and vpopmail will not create one. All dir-control info will be in a sql table dir_control. DAve Brian -- -- -- Brian Feeny, CCIE #8036, CISSPe: [EMAIL PROTECTED] Network Engineer p: 318.213.4709 ShreveNet Inc. f: 318.221.6612 -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! PGP.sig Description: This is a digitally signed message part
[vchkpw] How are you all using maildrop with qmailadmin etc?
We use maildrop so that we can do some fancy mail routing for our customers. For all of our domains we put a .qmail-default file that references a .mailfilter file. I know alot of you seem to use maildrop, but if you do, how do you have it play nice with qmailadmin? qmailadmin wants to clobber .qmail-default file when the domain admin changes catchall values for example. I wanted it so that if they selected normal (rather than catchall bounce or catchall delete, or catchall forward), then it puts my .qmail-default in place. How is this accomplished? Brian - Brian Feeny, CCIE #8036, CISSP Network Engineer ShreveNet Inc. PGP.sig Description: This is a digitally signed message part
Re: [vchkpw] Tuning mysql for vpopmail
On Friday 24 September 2004 06:48 pm, Juan Enciso Condeña wrote: Hello friends. I have installed vpopmail-5.2.1 + mysql-4.013 running on HP-UX alpha server. It has 1GB of memory with 2 proccesors. Definitly upgrade to Tom's latest release. The 5.2.1 release is good but the new release is much better. I am having problem with mysql at the hours peak. This show me the qmail-send log 2004-09-24 17:32:06.263335500 delivery 96079: failure: vmysql:_sql_error[3]:_Lost_connection_to_My SQL_server_during_query/Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/ The Lost connection message is from mysql. I have high concurrency (log qmail-send): @40004154ae4c2cd0fbfc status: local 10/100 remote 150/255 My mysql setup is for default ( I haven't /etc/my.cnf created !!!) You are either using more mysql connections than the default or your mysql server is over loaded. Somebody have a configuration of mysql for high concurrency and that work with vpopmail? I agree with Rick, use the large configuration file. Unless you are running a mysql cluster I recommend commenting out the log bin line. You might want to use InnoDB tables, which I think are the newer ones, then uncomment all the inno_d lines. Is possible limit vpopmail for don't use more of 100 connections? I think the default max connections are 100. So just give more to mysql, like Rick suggests. Because it reboot my mysql daemon I'm not surprised. Hopefully the max_connections are your problem and everything will run smooth. If mysql is still lagging you will need to consider a cluster of servers and distributed mysql. Should I think use postgresql instead of mysql? First, fix the max connections. mysql should do fine. I wonder is there any documentation on how to setup email/mysql/nfs in a cluster? I would be willing to contribute text. Ken Jones
[vchkpw] Do hooks exist for vpopmail or its lib?
Does vpopmail have any hooks available so that when someone adds a domain or removes a domain, I can fire off an external script? qmailadmin had some hooks and they are nice, but I need to take some actions whenever a domain is added. I am going to have techs adding domains via vqadmin. Since I didn't know of any hooks, I have cron just looking in each domains directory (every 15 min) and if it doesn't see the files I want to be there, then it adds them. But I would rather have a mechinism that worked more like a trigger/hook. Brian - Brian Feeny, CCIE #8036, CISSP Network Engineer ShreveNet Inc. PGP.sig Description: This is a digitally signed message part
