Re: [gentoo-user] OT - mythbackend not binding to port. Why? [SOLVED]

[Michael Sullivan]

On Thu, 2006-10-05 at 14:39 -0500, Michael Sullivan wrote:
> 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?
>

The mysql problem was because I forgot to update my bind-address in
my.cnf.  Myth is working now...

-- 
gentoo-user@g.o mailing list