Hi, we're using myodbc2.50.36 with W2k and W98 to connect to our mysql-server (Linux Kernel 2.2.18 - MySQL Version 3.23.38) in the internet. When we send or receive larger amounts of data (we're using Visual Foxpro 7.0 as frontend) we get the "aborted connections"-Message in the mysql errorlog very often. In my.cnf the wait_timeout is set to 1800 seconds but the connection is aborted much earlier.
Here's a piece of the most recent logfile: 020215 16:22:22 Aborted connection 22987 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:25:27 Aborted connection 22991 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:26:02 Aborted connection 22999 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error writing communication packets) 020215 16:28:58 Aborted connection 23574 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:32:38 Aborted connection 24381 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:34:41 Aborted connection 24877 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:34:53 Aborted connection 24970 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error reading communication packets) 020215 16:43:23 Aborted connection 25296 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got an error writing communication packets) 020215 16:48:47 Aborted connection 22968 to db: 'dummy' user: 'dummyusr' host: `my.server.com' (Got timeout reading communication packets) Does anybody know what to do to stop this aborted connections? It's nearly impossible to send or receive larger amounts of data when manipulating tables using ODBC. Greetings from Germany Lutz Maibach --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
