From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.60) (envelope-from <gentoo-user+bounces-52475-garchives=archives.gentoo.org@gentoo.org>) id 1GVZDn-00000o-8b for garchives@archives.gentoo.org; Thu, 05 Oct 2006 19:49:31 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.8/8.13.6) with SMTP id k95Jli6Y004348; Thu, 5 Oct 2006 19:47:44 GMT Received: from bullet.espersunited.com (adsl-70-234-122-249.dsl.tul2ok.sbcglobal.net [70.234.122.249]) by robin.gentoo.org (8.13.8/8.13.6) with ESMTP id k95JdZBY027339 for <gentoo-user@lists.gentoo.org>; Thu, 5 Oct 2006 19:39:35 GMT Received: from camille.espersunited.com (camille.espersunited.com [70.234.122.250]) by bullet.espersunited.com (8.13.7/8.13.4) with ESMTP id k95JdYpq010184 for <gentoo-user@lists.gentoo.org>; Thu, 5 Oct 2006 14:39:34 -0500 Subject: Re: [gentoo-user] OT - mythbackend not binding to port. Why? From: Michael Sullivan <michael@espersunited.com> To: gentoo-user@lists.gentoo.org In-Reply-To: <1160075413.20584.4.camel@camille.gateway.2wire.net> References: <1160075413.20584.4.camel@camille.gateway.2wire.net> Content-Type: text/plain Date: Thu, 05 Oct 2006 14:39:33 -0500 Message-Id: <1160077173.13630.3.camel@camille.gateway.2wire.net> Precedence: bulk List-Post: <mailto:gentoo-user@lists.gentoo.org> List-Help: <mailto:gentoo-user+help@gentoo.org> List-Unsubscribe: <mailto:gentoo-user+unsubscribe@gentoo.org> List-Subscribe: <mailto:gentoo-user+subscribe@gentoo.org> List-Id: Gentoo Linux mail <gentoo-user.gentoo.org> X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org Mime-Version: 1.0 X-Mailer: Evolution 2.6.2 Content-Transfer-Encoding: 7bit X-Archives-Salt: 1fb456a7-9761-459e-8eea-2406dc2cf57c X-Archives-Hash: dde1c4ca7e80acd4ca4998067b432cd9 On Thu, 2006-10-05 at 14:10 -0500, Michael Sullivan wrote: > My mythbackend is screwing up. I called /usr/bin/mythbackend directly > so that I could see what exactly the problem is. It gave me this: > > camille ~ # mythbackend > 2006-10-05 14:08:36.085 Using runtime prefix = /usr > 2006-10-05 14:08:36.120 New DB connection, total: 1 > 2006-10-05 14:08:36.127 Connected to database 'mythconverg' at host: > localhost > 2006-10-05 14:08:36.139 Current Schema Version: 1123 > Running as a slave backend. > 2006-10-05 14:08:36.153 New DB connection, total: 2 > 2006-10-05 14:08:36.154 Connected to database 'mythconverg' at host: > localhost > 2006-10-05 14:08:36.156 mythbackend: MythBackend started as a slave > backend > 2006-10-05 14:08:36.173 New DB connection, total: 3 > 2006-10-05 14:08:36.174 Connected to database 'mythconverg' at host: > localhost > 2006-10-05 14:08:36.241 mythbackend version: 0.19.20060121-2 > www.mythtv.org > 2006-10-05 14:08:36.241 Enabled verbose msgs: important general > 2006-10-05 14:08:36.242 AutoExpire: Found 1 recorders w/max rate of 72 > MiB/min > 2006-10-05 14:08:36.244 AutoExpire: Required Free Space: 1.1 GB w/freq: > 10 min > QServerSocket: failed to bind or listen to the socket > 2006-10-05 14:08:36.247 Failed to bind port 6543. Exiting. > > > I tried it with and without the firewall running and I got the same > results. Why can't it bind to the port? > I think I might have discovered one reason why mythbackend was screwing up. I rebooted my machine and tried mythbackend again after rebooting: camille ~ # mythbackend 2006-10-05 14:36:41.431 Using runtime prefix = /usr 2006-10-05 14:36:41.573 New DB connection, total: 1 2006-10-05 14:36:41.574 Unable to connect to database! 2006-10-05 14:36:41.574 Driver error was [1/2002]: QMYSQL3: Unable to connect Database error was: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) QSqlQuery::exec: database not open QSqlQuery::exec: database not open 2006-10-05 14:36:41.633 DB Error (KickDatabase): Query was: SELECT NULL; No error type from QSqlError? Strange... 2006-10-05 14:36:41.688 Failed to init MythContext, exiting. So I tried mysql: camille ~ # /etc/init.d/mysql start * ... * Starting mysql (/etc/mysql/my.cnf) * MySQL NOT started (0) [ !! ] I looked for logs: camille ~ # ls /var/log/mysql camille ~ # camille ~ # cat /var/log/messages | grep 'mysql' Jun 16 08:43:44 camille groupadd[27649]: new group: name=mysql, gid=60 Jun 16 08:43:44 camille useradd[27713]: new user: name=mysql, uid=60, gid=60, home=/dev/null, shell=/bin/false Jun 18 17:01:18 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Jun 18 17:08:13 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Jun 19 16:15:21 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Jun 20 14:23:09 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Jun 25 20:29:49 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Jul 10 13:52:29 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Jul 20 11:26:56 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Jul 27 08:55:43 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Aug 3 17:50:25 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Aug 8 19:07:39 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Aug 26 21:36:41 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Sep 8 23:02:08 camille usermod[24305]: delete `mythtv' from group `mysql' Sep 8 23:02:09 camille usermod[24305]: delete `mythtv' from shadow group `mysql' Sep 15 17:46:20 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" Oct 2 13:13:00 camille rc-scripts: Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" camille ~ # I can't find any logs as to why mysql won't start. I can't make sense of the /etc/init.d/mysql script. Can anyone give me a hint as to why mysql is not starting? -- gentoo-user@gentoo.org mailing list