RE: [vchkpw] Sporadic mail auth failures

2005-08-22 Thread David Erickson
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

 -Original Message-
 From: David Erickson [mailto:[EMAIL PROTECTED]
 Sent: Sunday, August 21, 2005 12:32 PM
 To: vchkpw@inter7.com
 Subject: RE: [vchkpw] Sporadic mail auth failures
 
 Yes, max connections are set to 100, and it reported the max ever used was
 9.. (since I restarted it early this morning).. but ive had problems since
 then so that leads me to believe connections isn't the problem.
 
 -David
 
  -Original Message-
  From: Roman Volf [mailto:[EMAIL PROTECTED]
  Sent: Sunday, August 21, 2005 12:28 PM
  To: vchkpw@inter7.com
  Subject: 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: vchkpw@inter7.com
  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: vchkpw@inter7.com
  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: vchkpw@inter7.com
  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]
 
  --
  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
 
 
 --
 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
 
+-++
| Variable_name   | Value  |
+-++
| back_log| 50 |
| basedir | /usr/local/mysql/  |
| binlog_cache_size   | 32768  |
| bulk_insert_buffer_size | 8388608|
| character_set_client| latin1 |
| character_set_connection| latin1

Re: [vchkpw] Sporadic mail auth failures

2005-08-22 Thread Roman Volf

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] Sporadic mail auth failures

2005-08-22 Thread David Erickson
Ya we are using the courier-authlib I believe for authing... I think our
qmail is just running the normal emerged version.

 -Original Message-
 From: Wouter van der Schagt [mailto:[EMAIL PROTECTED]
 Sent: Monday, August 22, 2005 8:03 AM
 To: vchkpw@inter7.com
 Subject: Re: [vchkpw] Sporadic mail auth failures
 
 Perhaps the problem isn't related to vpopmail. What daemon are you using?
 qmail i assume ? did you apply any patches concerning qmail-pop3d ? I had
 a conflict once with the logging patch for example. Causing disconnections
 all the time.
 
 - Original Message -
 From: David Erickson [EMAIL PROTECTED]
 To: vchkpw@inter7.com
 Sent: Monday, August 22, 2005 3:58 PM
 Subject: RE: [vchkpw] Sporadic mail auth failures
 
 
  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
 
   -Original Message-
   From: David Erickson [mailto:[EMAIL PROTECTED]
   Sent: Sunday, August 21, 2005 12:32 PM
   To: vchkpw@inter7.com
   Subject: RE: [vchkpw] Sporadic mail auth failures
  
   Yes, max connections are set to 100, and it reported the max ever used
 was
   9.. (since I restarted it early this morning).. but ive had problems
 since
   then so that leads me to believe connections isn't the problem.
  
   -David
  
-Original Message-
From: Roman Volf [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 21, 2005 12:28 PM
To: vchkpw@inter7.com
Subject: 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: vchkpw@inter7.com
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: vchkpw@inter7.com
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: vchkpw@inter7.com
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

[vchkpw] Sporadic mail auth failures

2005-08-21 Thread David Erickson
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



Re: [vchkpw] Sporadic mail auth failures

2005-08-21 Thread Rick Macdougall

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



Re: [vchkpw] Sporadic mail auth failures

2005-08-21 Thread Roman Volf

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

2005-08-21 Thread Roman Volf

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

2005-08-21 Thread David Erickson
Great suggestions but that doesn't seem to the be problem.. I restarted
mysql earlier today, and continued to have problems afterward.  And I just
checked max_used_Conns and it is 7, and my actual limit is 100.  Any other
ideas?  

-David

 -Original Message-
 From: Roman Volf [mailto:[EMAIL PROTECTED]
 Sent: Sunday, August 21, 2005 10:44 AM
 To: [EMAIL PROTECTED]
 Subject: 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]
 
 --
 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
 



Re: [vchkpw] Sporadic mail auth failures

2005-08-21 Thread Jason S
On 8/21/05, David Erickson [EMAIL PROTECTED] wrote:
 Great suggestions but that doesn't seem to the be problem.. I restarted
 mysql earlier today, and continued to have problems afterward.  And I just
 checked max_used_Conns and it is 7, and my actual limit is 100.  Any other
 ideas?
 
 -David
 
  -Original Message-
  From: Roman Volf [mailto:[EMAIL PROTECTED]
  Sent: Sunday, August 21, 2005 10:44 AM
  To: [EMAIL PROTECTED]
  Subject: 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]
 
  --
  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
 
 
 

Maybe you can try turning on mysqld logging in my.cnf and see if
anything strange pops up there?

[mysqld]
log=/path/to/your/logfile

Don't do like me and forget to turn logging back off when you're done :)
-- 

Jason
[EMAIL PROTECTED]


Re: [vchkpw] Sporadic mail auth failures

2005-08-21 Thread Wouter van der Schagt
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





Re: [vchkpw] Sporadic mail auth failures

2005-08-21 Thread Wouter van der Schagt
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]



RE: [vchkpw] Sporadic mail auth failures

2005-08-21 Thread David Erickson
Yes, max connections are set to 100, and it reported the max ever used was
9.. (since I restarted it early this morning).. but ive had problems since
then so that leads me to believe connections isn't the problem.

-David

 -Original Message-
 From: Roman Volf [mailto:[EMAIL PROTECTED]
 Sent: Sunday, August 21, 2005 12:28 PM
 To: [EMAIL PROTECTED]
 Subject: 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]
 
 --
 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
 



RE: [vchkpw] Sporadic mail auth failures

2005-08-21 Thread David Erickson
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
 



Re: [vchkpw] Sporadic mail auth failures

2005-08-21 Thread Roman Volf

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]