-->-----Original Message-----
-->From: Alec Smith [mailto:alec@stripped] On Behalf Of Alec
-->Smith
-->Sent: Friday, June 06, 2003 11:24 AM
-->To: mysql@stripped
-->Subject: Lost connection to MySQL server during query
-->
-->Hi -
-->
-->[Perhaps not exactly the right list, but perl@stripped 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/mysql?unsub=1
