Re: [vchkpw] Spotty behavior authenticating: MySQL server has gone away
Dallas L. Engelken wrote: -Original Message- From: ISP Lists [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 10:21 AM To: vchkpw@inter7.com Subject: Re: [vchkpw] Spotty behavior authenticating: MySQL server has gone away Something peculiar happened to mysql during a reboot and now vpopmail authdaemond is having trouble completing authentications /var/log/maillog says: Aug 24 08:36:15 hostname authdaemond: vmysql: sql error[3]: MySQL server has gone away This problem is spotty though. I have several successful authentications before this error occurs. I then have to restart mysqld before I can get any other authentications to succeed. I am still able to use the mysql client to connect to the server for an interactive session. What seems strange to me is that there are only two mysql daemons running: root 23923 0.0 0.1 5060 1108 pts/0S09:13 0:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --pid-file=/var/run/mysqld/mysqld.pid mysql23956 0.0 0.5 38620 5656 pts/0Sl 09:13 0:00 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/var/lib --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking Every other instance of mysql 3.23.x I've ever run has about 10 child threads running, so this seems strange to see only one child thread. I have not updated any packages on this box recently. None at all, I swear. Suggestions to investigate? Googling on the MySQL server has gone away is a wild goose chase. Hrm, rebooting the box seems to have helped. Still same number of mysql daemons, but they're answering now... Damned strange. dmesg on reboot didn't show any ext3 errors being fixed - I was wondering if this was a disk thing. Thoughts still welcome and appreciated on this. Well.. just for reference (cause it took me a while to figure this one out)... if your box is running with multiple name servers configured for resolution, and the primary stops responding, you will see this same issue. What happens is the slight delay added to the auth sequence as the mysql fails to the secondary resolver causes the vpopmail to fail the connection. To be more specific this will occur: 1: primary name server fails 2: When authentication to DB it takes a longer time due to system having to fail to secondary resolver. 3: vpopmail's auth to db starts failing due to timeouts (mysql takes to long to respond, but does respond), vpopmail tries harder to connect to db, connection count sky rockets (I saw upwards of 1400 connections) and in turn the connections do not close properly. 4: db locks up hard. 5: once you quiet down vpopmail (easiest way was to disable incoming access sadly), test messages show that an occasional message wil lgo through, but the rest receive the MySQL server has gone away message. 6. Trying to auth to db, albeit slightly slower than normal, responds and allows auth. Once in runs perfectly. 7. You realize that its primary dns server is off for whatever reason, start it, and voila no problem. Now admittedly, previously I've seen the same thing but for other reasons, this was just the more obscure annoying one. Yes I realize that a local dns server make a lot of sense for this situation, but if the named on that box stops, and it has your other name servers as secondary, WHEN are you gonna realize that? Most people would not add that to their monitoring. LOTS of fun. -Greg
Re: [vchkpw] Persistent Mysql Connections for auth?
Ken Jones wrote: David Erickson wrote: Is there any way to get vpopmail to either use a connection pool or persistent connections to mysql for authorization? Only if there is a way to get separate invocations of a process to use a connection pool. Each email delivery or authentication uses a new process. So why not create a vpopmail daemon process that maintains the connection(s) to the db, and feed the vchkpw auths through that daemon. Have them stand in line per se against through that one, that way you the system doesn't fail on load, it just slows. I've got no problem defining a connection pool of 1k+ strictly to vpopmail, just so long as it handles it just fine once it hits that number. -Greg
Re: [vchkpw] quotawarn question
Tom Collins wrote: On Mar 23, 2005, at 1:10 PM, Juan Enciso Condeña wrote: But also I have noticed that this file not delete as soon as the quota has diminished, which brings like consequence that when it is arrived again at the quota limit, no alert quota is sent again. Is it a bug or what should I do? It's not a bug. Only one warning is sent every 24 hours. The file needs to stay there so that a user who's close to their quota doesn't get repeated warnings every time the delete mail and have more arrive. actually considering it NEVER removes the quotawarn from the user, I would personally consider it a bug. And a rather annoying one considering I have to go manually remove it else they get the warning even after emptying their box. -Greg
Re: [vchkpw] quotawarn question
Tom Collins wrote: On Mar 24, 2005, at 8:47 AM, Greg Swift wrote: It's not a bug. Only one warning is sent every 24 hours. The file needs to stay there so that a user who's close to their quota doesn't get repeated warnings every time the delete mail and have more arrive. actually considering it NEVER removes the quotawarn from the user, I would personally consider it a bug. And a rather annoying one considering I have to go manually remove it else they get the warning even after emptying their box. The quotawarn file is a 0-byte file stored in the user's directory and is only used to determine the last time an actual warning was sent. I'm not sure I understand why that is a problem. If the file is over 24 hours old, removing it will have no effect on the behavior of vdelivermail. If it's less than 24 hours old, the user will get another warning the next time their box goes over 90% full. If you wanted to, you could add a cron job on your system to find quotawarn files older than 24 hours and delete them, but I don't think there's a need to do so. Welll.. then it is buggy, because even if their mailbox is not at quota, guess what? they still get the message! This bug was reported to the list months ago (back around sept/oct). If it actually worked the way you are specifying, I wouldn't be complaining, but the has been a repeatable occurance, and the fix is to delete the quoatawarn file. -Greg -Greg
RE: [vchkpw] Logging only with the account name
i'm not as experienced as some of the guys on here, but vpopmail should accept just the login for your primary domain (since you have only one this shouldnt be a problem). -greg -Original Message- From: Mário Gamito [mailto:[EMAIL PROTECTED] Sent: Fri 9/17/2004 5:40 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Logging only with the account name Hi, I have this mail server with webmail - IMP - that authenticates users through IMAP, in this case, courier-imap. courier imap in turn gets the authentication credentials from vpopmail. *I only have one domain*. Now, this mailserver belongs to a costumer of mine that is a f* pain in the ass. Yesterday, he rang me to ask if it would be possible to login in the webmail using only the account name, dropping the domain part, i. e., for instance, logging only with foo, instead of [EMAIL PROTECTED]. The webmail is correctly configured. My question is: is it possible to configure vpopmail to accept only foo for the login instead of [EMAIL PROTECTED] ? Remember i only have one domain in the mail server. Any help would be appreciated. Warm Regards, Mário Gamito winmail.dat
RE: [vchkpw] Aliases vs. Forwards
Is it possible to do this with remote and local delivery off the same address? -Greg -Original Message- From: Jacob S. [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 0:05 To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Aliases vs. Forwards On Wed, 01 Sep 2004 22:54:51 -0600 Fred Colclough [EMAIL PROTECTED] wrote: Here's a 'newbie' question: I just deployed a new mail svr running qmail with vpopmail, mysql, qmailadmin. My 'old' server was running qmail, but with vmailmgr instead. I 'used' to be able to create aliases that would forward to MULTIPLE users, for example: [EMAIL PROTECTED] ... was forwarded to: [EMAIL PROTECTED], [EMAIL PROTECTED], etc. How can I re-create that same functionality w/ vpopmail? The Forwards in vpopmail appear to allow only ONE acc't to forward to. After creating a forward, go to the page that lists all forwards for that domain. Find the forward that you want to have multiple recipients and click the 'modify' icon. You should now see a page with an option to 'add forward' - this will add a recipient to the current forward. HTH, Jacob -- GnuPG Key: 1024D/16377135 Random .signature #55: Given enough time and money, eventually Microsoft will re-invent UNIX.