[mythtv-users] Remote Frontend Not Starting

[Phill Wiggin]

On 7/25/06, Mike Harrison <trapperofspam at yahoo.com> wrote:
> I am trying to run a remote frontend on Ubuntu 5.10. When I enter the
> "mythfrontend" command in the terminal window it just outputs one line
> stating that it is opening a new DB connection and then it just sits there.
> None of the myth screens come up. I thought it might not have the correct
> information for reaching the backend so I tried looking for files to adjust
> settings. I located /etc/mythtv/mysql.txt. I changed the entries for
> DBHostName and DBPassword to match my settings. Still no luck. Are there
> other settings that I can try to adjust? BTW, the remote frontend has full
> internet capabilites and can ping the backend.

First thought: make sure you can connect to mysql directly from the
frontend box.

mysql -h <backendIPorHostname> -u mythtv -p

If not, make sure your backend machine's mysql config file (my.cnf)
has the 'skip-networking' uncommented.

change:
# security:
# using "localhost" in connects uses sockets by default
# skip-networking

to:
# security:
# using "localhost" in connects uses sockets by default
skip-networking

Then restart mysql.

Secondly, make sure qt has mysql support built in.

--Phill W.