[mythtv-users] frontend client can not find backend server

[Brian May]

>>>>> "daryl" == daryl faulds <nannyseeker2003 at yahoo.com> writes:

    daryl> My question relates to step 13 "Setup mysql databases" and
    daryl> the implementation in mythtv.

    daryl> The setup doc: /usr/share/doc/mythtv-0.14/database/mc.sql
    daryl> has two SQL commands that create a database named
    daryl> "mythconverg" and grant user rights to a user
    daryl> "mythtv at localhost":

    daryl> $ cat mc.sql create database mythconverg; grant all on
    daryl> mythconverg.* to mythtv at localhost identified by "mythtv";

This just says: grant the mysql user "mythtv at localhost" full access to
the "mythconverg" database with the "mythtv" password. This is
correct.

(Hmmm... although... is hard coding the "mythtv" password like this
really a good idea?)

MythTV is also configured with these details, so it can ask mysql "Hi,
I am mythtv, my password is mythtv, can I please have access?"

    daryl> Going through the setup screens in mythtv fills the
    daryl> mythconverg database "settings" table with numerous rows
    daryl> containing "localhost.localdomain" which is not exactly the
    daryl> user set up by /usr/share/doc/mythtv-0.14/database/mc.sql

The "localhost.localdomain" just says that these settings apply to the
computer with the hostname "localhost.localdomain", in case you have
multiple computers using the one database. This is normal. It has
nothing to do with the above.

The only possible question mark is why "localhost.localdomain"
appeared, it would suggest you haven't setup the hostname of your
computer correctly (might be an issue if you want to access the one
database from multiple computers).

    daryl> This seems to me that it should fail when run in MySQL.

I am not sure what you mean when you say "when run in MySQL".

The fact myth was able to add this tables to the database seems to
indicate that everything is working, and mythtv can talk to your mysql
database.

    daryl> Also my setup created a database "mysql" with a table
    daryl> "user" where host/user/password information is stored.
    daryl> This table has rows with host/user combinations
    daryl> "localhost/root" "localhost/<nothing>" "localhost/mythtv"
    daryl> as well as "localhost.localdomain/root"
    daryl> "localhost.localdomain/<nothing>"
    daryl> "localhost.localdomain/mythtv".

mysql uses a table called mysql internally for authentication
users. You normally never need to worry about it. In any case, it
would appear to be working.

    daryl> It seems to me that when mythtv obtains host user
    daryl> information from this table it might fail.

    daryl> How are the successful mythtv users getting around these?
    daryl> It seems to me that using "localhost.localdomain" in mc.sql
    daryl> should be the way to go. Also, it seems that the redundant
    daryl> entries in db=mysql table=user might cause mythtv to fail
    daryl> for some users and work for others depending how the rows
    daryl> are stored. What should the db=mysql table=user look like
    daryl> in its simplest form?

I think you might be getting mysql authentication confused with the
mechanism mythtv uses to store settings for multiple computers on the
one database. I doubt either of these issues are related to your
problem.

Please, when reporting a problem, tell us the *symptoms* first, as
your diagnostics appear to be wrong and indicate things that seem to
be working.

Based on your subject line: "frontend client can not find backend
server", I can't help, because I don't know what your were trying to
do at the time.  Is the frontend on the same computer as the backend?
What error did you get?

I hope this helps clarify without causing further confusion.

disclaimer: I am not a mythtv developer; The above matches my
understanding of MythTV.
-- 
Brian May <bam at snoopy.apana.org.au>