[mythtv-users] frontend client can not find backend server
bam at snoopy.apana.org.au
Sat Apr 3 06:02:11 EST 2004
>>>>> "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
(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
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"
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
Please, when reporting a problem, tell us the *symptoms* first, as
your diagnostics appear to be wrong and indicate things that seem to
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>
More information about the mythtv-users