Uwe Kiewel wrote: > Paul J Stevens schrieb: >> if you report problems, please describe you setup: os, cpu, >> mysql/postgres versions, dbmail version, etc. > >> In this case 'fedora 8 install' doesn't tell me anything since I don't >> use fedora. > > mysql-libs-5.0.45-6.fc8 > dbmail-2.2.8-1.fc8 > 4 GB of RAM > AMD Athlon(tm) 64 X2 Dual Core Processor 5600+ > > >> Uwe Kiewel wrote: >>> Apr 12 17:36:02 vm-host dbmail/imap4d[15580]: Error:[sql] >>> dbmysql.c,db_connect(+172): mysql_real_connect failed: Lost connection >>> to MySQL server at 'reading final connect information', system error: 104 >> This message comes straight from the mysql client library. Dbmail is >> just the messenger.
A quick lookup reveaved that this exact message means: Connection reset by peer; the mysql-server in this case. > >>> But, mysqld does not report any problems... >> Could be a network error, or resource depletion. The first would not be >> detected by the mysql server, the second would generate a message in the >> mysql error log. > > I think I can close out the network, because it is a local host > connection. So, MySQL and dbmail runs on the same host. That's too easy. There is a problem. And it's in your mysql setup. Something is causing those mysql connection errors. Also, the hostname in your logs suggests you are running on a vmware image. That is /relevant/ information. Especially if dbmail is not in the same image as mysql. > >>> Apr 12 17:36:02 vm-host dbmail/imap4d[15580]: Error:[serverchild] >>> serverchild.c,PerformChildTask(+298): could not connect to database >> Again, same thing: network problem or max_connections depleted. > > > I checked it: > > mysql> show variables like '%connect%'; > +--------------------------+-------------------+ > | Variable_name | Value | > +--------------------------+-------------------+ > | character_set_connection | latin1 | > | collation_connection | latin1_swedish_ci | > | connect_timeout | 5 | > | init_connect | | > | max_connect_errors | 10 | > | max_connections | 100 | > | max_user_connections | 0 | > +--------------------------+-------------------+ all very standard. But combining errno 104 with http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html leads connect_timeout as a possible cullprit. Increase that value to something significantly larger, like 60. > But, how can I check the current connection count? mysqladmin processlist -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
