[mythtv-users] Stumped: MySQL and accessing the BE from a separate FE

[Joe Ripley]

On Fri, Aug 21, 2009 at 4:00 PM, leifontheroad<leifontheroad at hotmail.com> wrote:

> Good idea - here it is (I masked the password data):
>
> mysql> select User,Host,Password from user where User like '%myth%';
> +--------+----------------------+-------------------------------------------+
> | User   | Host                 | Password
> |
> +--------+----------------------+-------------------------------------------+
> | mythtv | localhost            | *abunchofstuff|
> | mythtv | %                    | *abunchofstuff|
> | mythtv | 192.168.50.%         | *abunchofstuff|
> | mythtv | desktop.local | *abunchofstuff|
> | mythtv | %.local              | *abunchofstuff|
> +--------+----------------------+-------------------------------------------+
> 5 rows in set (0.04 sec)
>
> mysql> select User,Host,Db from db where User like '%myth%';
> +--------+----------------------+-------------+
> | User   | Host                 | Db          |
> +--------+----------------------+-------------+
> | mythtv | %                    | mythconverg |
> | mythtv | %.local              | mythconverg |
> | mythtv | 192.168.5.%         | mythconverg |
> | mythtv | desktop.local | mythconverg |
> | mythtv | localhost            | mythconverg |
> +--------+----------------------+-------------+
> 5 rows in set (0.00 sec)
> In reading the MySQL docs, it should evaluate each line until it finds a
> match. So it should get to the mythtv/%,which should be evaluated and
> accepted. Perhaps as a test I should remove everything but the mythtv/%
> line? Since this is a system table, I'm a little squeamish about doing that
> with my knowledge of SQL, so any tips on a recommended way to do that would
> be appreciated...

Looks good to me... I guess we should try enabling error logging:

Put something like this in your [mysqld] section of my.cnf on the SQL server:

log-error=/var/lib/mysql/mysqld.log

Or use the command-line option.  More detail here:
http://dev.mysql.com/doc/refman/5.1/en/error-log.html

-- 
Joe Ripley
vitaminjoe at gmail.com