From owner-freebsd-database@FreeBSD.ORG Sun Jun 3 21:00:54 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id C28B516A468 for ; Sun, 3 Jun 2007 21:00:54 +0000 (UTC) (envelope-from gurdiga@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by mx1.freebsd.org (Postfix) with ESMTP id 5ECE813C448 for ; Sun, 3 Jun 2007 21:00:54 +0000 (UTC) (envelope-from gurdiga@gmail.com) Received: by ug-out-1314.google.com with SMTP id u2so694019uge for ; Sun, 03 Jun 2007 14:00:53 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=XtDj3i9LFnt0J2RE22swjSud52JazI5esQ3tiKs80Xw+uXDhqg7mQl7VvNdKfGADNEbzV98CaZkWcSEUAZveOEA08WLcpPAsZ2v9KLa93EmGl0iWUcogLc91orLL5b568DbQO+w3w27ufhmLat43EFKyBMRn142nLXG75+rOooA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=R0tZiq69+PpxCcBpMbgZ/gj530YhhW7MD0MJ9zfmEh7HdPsAMk3Qkn+YZG7izosQEWWvX7yRiQzVZ1f0IkUgTxREM59oH7RzJPQTgk5fHCd14G9lQxi1zsaA3NbLlw+uf+PJE2NaNUDfric26ORf9FGNorjo1ecVFBemC6caNwo= Received: by 10.78.137.7 with SMTP id k7mr1785531hud.1180902731901; Sun, 03 Jun 2007 13:32:11 -0700 (PDT) Received: by 10.78.194.12 with HTTP; Sun, 3 Jun 2007 13:32:11 -0700 (PDT) Message-ID: Date: Sun, 3 Jun 2007 23:32:11 +0300 From: "Vlad GURDIGA" To: freebsd-database@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: MySQL drops connections X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 03 Jun 2007 21:00:54 -0000 Hello, Several days ago I started to get a strange error from mysql51 server: ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication information', system error: 32 This is what I get when I try to connect using mysql command line console or PHP. I've tried reinstalling the mysql server and client, recreating databases with mysql_install_db but nothing changed. The mysql51-server and client does not compile in current version (ports tree is up to date) so I had to install pre-built packages. The kernel and the world is rebuilt yesterday from updated source tree. Here is my system's info: # pkg_info | grep mysql mysql-client-5.1.16 Multithreaded SQL database (client) mysql-server-5.1.16 Multithreaded SQL database (server) php5-mysql-5.2.2 The mysql shared extension for php >uname -a FreeBSD kpax 7.0-CURRENT FreeBSD 7.0-CURRENT #2: Sat Jun 2 20:00:40 EEST 2007 root@kpax:/usr/obj/usr/src/sys/GENERIC i386 What should I try? From owner-freebsd-database@FreeBSD.ORG Mon Jun 4 08:40:43 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 80B8816A41F for ; Mon, 4 Jun 2007 08:40:43 +0000 (UTC) (envelope-from gleban@mail.ru) Received: from mx28.mail.ru (mx28.mail.ru [194.67.23.67]) by mx1.freebsd.org (Postfix) with ESMTP id 3D3DB13C483 for ; Mon, 4 Jun 2007 08:40:43 +0000 (UTC) (envelope-from gleban@mail.ru) Received: from f10.mail.ru (f87.mail.ru [194.67.57.187]) by mx28.mail.ru (mPOP.Fallback_MX) with ESMTP id 41C1E8B505 for ; Mon, 4 Jun 2007 10:54:01 +0400 (MSD) Received: from mail by f10.mail.ru with local id 1Hv6Rz-000Phm-00; Mon, 04 Jun 2007 10:53:59 +0400 Received: from [80.255.64.44] by koi.mail.ru with HTTP; Mon, 04 Jun 2007 09:53:59 +0300 From: gleb bezFamilii To: Vlad GURDIGA Mime-Version: 1.0 X-Mailer: mPOP Web-Mail 2.19 X-Originating-IP: unknown, 172.20.7.10 via proxy [80.255.64.44] Date: Mon, 04 Jun 2007 09:53:59 +0300 In-Reply-To: References: Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 8bit Message-Id: Cc: freebsd-database@freebsd.org Subject: Re: MySQL drops connections X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: gleb bezFamilii List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 04 Jun 2007 08:40:43 -0000 Hello. There are lots of possible reasons. Have a look here: http://dev.mysql.com/doc/refman/5.1/en/gone-away.html