-->-----Original Message----- -->From: Alec Smith [mailto:[EMAIL PROTECTED] On Behalf Of Alec -->Smith -->Sent: Friday, June 06, 2003 11:24 AM -->To: [EMAIL PROTECTED] -->Subject: Lost connection to MySQL server during query --> -->Hi - --> -->[Perhaps not exactly the right list, but [EMAIL PROTECTED] doesn't -->seem to be too active, so I'm hoping someone here might be able to offer -->some insight.] --> -->I'm getting the below error when trying to connect to a MySQL 4.0.12 -->server on RedHat 9 using a Perl script: --> -->DBI connect('mailers:192.168.50.201','admin',...) -->failed: Lost connection to MySQL server during query at ./dialer line 24 -->Can't call method "prepare" on an undefined value at ./dialer line 28. --> -->The client machines are RH9 also, using the 3.23.56 libraries and clients -->shipped with RedHat. Perl on RH9 is 5.8.0. --> -->Any ideas where to start?
Does your script run for a long time? Look for a variable in my.cnf called wait_timeout it might be set pretty low. Do a $DBI->ping in your loop to test your connection and reconnect if not connected -OR- set wait_timeout really high. --> -->Thanks, -->Alec --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
