Re: [vchkpw] vpopmail + chkuser 2.0
Jimmy Stewpot wrote: Hello, I have an issue where I am using chkuser 2.0 and vpopmail. The problem is that with my vpopmail setup I have the alias' stored in the mysql database. When I send an email to the email account it works. However when I send an email to the alias it fails with a chkuser error. Is there any way around that from within chkuser or vpopmail. Is there any way to migrate the valias' from mysql to .qmail files so that chkuser works if there is no answer for the above? Regards, Jimmy. chkuser 2.0 should be using valias to check the aliases, not mysql. If it does, but its still not working, you may be using Vpopmail 5.4.9 which has a bug in valias that doesn't check .qmail files. Upgrade to Vpopmail 5.4.10. Or don't use chkuser and use the validrctptto patch located at http://qmail.jms1.net/patches/validrcptto.cdb.shtml which is significantly faster than chkuser 2.0. -- Roman Volf Keystreams Internet Solutions [EMAIL PROTECTED]
Re: [vchkpw] Sporadic mail auth failures
Rick Macdougall wrote: David Erickson wrote: Hi we've been battling a very strange problem with our server for awhile now. Periodically when a user tries to send mail (using smtp auth), or check his/her pop3 box, we get auth failures. What happens is youll have to auth 3-4 times before it'll actually go through (even though you are entering the same credentials every time). It is very frustrating. Upon examining the logs here is what we are getting: Aug 21 10:08:04 mail authdaemond: vmysql: sql error[3]: Lost connection to MySQL server during query Now I know the username/pw work to connect to the database because it does eventually auth. The mysql server is on the same machine as well. Anybody have any ideas what this could be indicative of? Mysql server 4.1.8 Vpopmail 5.4.10 Hi, It happens occasionally when you don't allow enough connections to your MySQL server. Try increasing the connections in the my.cnf (and look at increasing some of the buffers etc as well). Regards, Rick You can check this by doing: [EMAIL PROTECTED] ~]$ mysqladmin -u root -p extended-status|grep connections Enter password: | Max_used_connections | 25 | Then compare that number to the number specified in my.cnf. -- Roman Volf Keystreams Internet Solutions [EMAIL PROTECTED]
Re: [vchkpw] Sporadic mail auth failures
Roman Volf wrote: Rick Macdougall wrote: Hi, It happens occasionally when you don't allow enough connections to your MySQL server. Try increasing the connections in the my.cnf (and look at increasing some of the buffers etc as well). Regards, Rick You can check this by doing: [EMAIL PROTECTED] ~]$ mysqladmin -u root -p extended-status|grep connections Enter password: | Max_used_connections | 25 | Then compare that number to the number specified in my.cnf. Or, to check the current setting for max_connections, do: [EMAIL PROTECTED] ~]$ mysqladmin -u root -p variables|grep connections Enter password: | max_connections | 100 -- Roman Volf Keystreams Internet Solutions [EMAIL PROTECTED]
Re: [vchkpw] Sporadic mail auth failures
David Erickson wrote: Ok I repaired the database files, (just said clients were using them or they weren't closed properly, so I shutdown mysql and ran it with -r anyway). Also increased the authdaemonrc processes from 5 to 10. Time to let it run for awhile and see what happens. Also the db is local so shouldn't encounter network latency. -David -Original Message- From: Wouter van der Schagt [mailto:[EMAIL PROTECTED] Sent: Sunday, August 21, 2005 12:24 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Sporadic mail auth failures Another time i had this problem was when the database to be authenticated against wasn't the localhost. If the network was clogged up (long ping replies can check this), i would have such failures. - Original Message - From: "Jason S" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 21, 2005 7:51 PM Subject: Re: [vchkpw] Sporadic mail auth failures On 8/21/05, Wouter van der Schagt <[EMAIL PROTECTED]> wrote: I had this problem when my database was corrupt. You can check this with cd /var/lib/mysql/vpopmail myisamchk *.MYI if any is corrupt, just add -r - Original Message - From: "David Erickson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 21, 2005 6:34 PM Subject: [vchkpw] Sporadic mail auth failures Hi we've been battling a very strange problem with our server for awhile now. Periodically when a user tries to send mail (using smtp auth), or check his/her pop3 box, we get auth failures. What happens is youll have to auth 3-4 times before it'll actually go through (even though you are entering the same credentials every time). It is very frustrating. Upon examining the logs here is what we are getting: Aug 21 10:08:04 mail authdaemond: vmysql: sql error[3]: Lost connection to MySQL server during query Now I know the username/pw work to connect to the database because it does eventually auth. The mysql server is on the same machine as well. Anybody have any ideas what this could be indicative of? Mysql server 4.1.8 Vpopmail 5.4.10 Thanks, David I don't use authdaemon, but I saw something on google in the authdaemonrc file about not having enough authdaemon child processes causing intermittent auth failures...something to check -- Jason [EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date: 8/19/2005 Did you check the max_connections? -- Roman Volf Keystreams Internet Solutions [EMAIL PROTECTED]
Re: [vchkpw] Sporadic mail auth failures
David Erickson wrote: And so after having no problems all yesterday afternoon, what is the first thing that system does this morning when I login? Fail to auth, twice. Someone ahead of me failed then I failed. Checked connections, 14/100. 10 Authdaemon processes running... no mysql errors reported... sigh. Any other ideas? :) It boggles me because this is server is hardly even used. I'm going to attach the printout of my status and vars from mysql, if anyone sees anything wrong with whats in there please let me know. Thanks -David Have you checked/enabled the mysql logs so you can see if there is an actual mysql connection when you connect to POP3? That would help you figure out if its a mysql issue or a vpopmail issue. -- Roman Volf Keystreams Internet Solutions [EMAIL PROTECTED]
Re: [vchkpw] Delete all incoming mail for a user or domain
Sergio Rosa wrote: Shane, thanks. the .qmail should be placed in the user Maildir? or where? thakns, srosa You can create a ~vpopmail/domains/domain.com/.qmail-user file with the # information, and you won't even need a valid user/Maildir. -- Roman Volf Keystreams Internet Solutions [EMAIL PROTECTED]