[mythtv-users] Is network required for single frontend/backend machine?

[Johnny Russ]

>
> I edited my /etc/mythtv/mysql.txt file to show the proper server address as
> shown...
>
> user=mythtv
> password=C1RFOKlE
> database=mythconverg
> server=127.0.0.1
>
> I then entered these settings into the "live session configuration" window.
>
> At this point I am given the option of testing the connection, which always
> fails.
>
> Now I will study the rest of your letter and try to make sense of it. I am
> afraid that this is just too deep for me. So many names and passwords. And
> then the need to access databases and setup files. I don't understand why,
> if these steps are needed, why doesn't the setup process prompt me for these
> steps instead of assuming I am smart enough  figure out what I need to do?
>
> Thank all of you for your help. I really do appreciate it. But I feel
> guilty for tackling a subject that I obviously am not up to dealing with and
> then having to depend on you guys to bail me out.
>
>
MythTV keeps all of the settings and information about all of your
recordings in a mysql database. Mysql has a root user that can create other
mysql users and change settings, etc. I am not sure but I think you are
having the same problem I had on another machine. When you set up mythtv
originally you used the ip address of the machine instead of 'localhost' or
'127.0.0.1'. By default mysql is setup to only allow connections from
localhost. So when you used the machines ip address the connection appears
to come from the network and is rejected. This means that the setup program
wasn't able to create the mysql user named 'mythtv', and it wasn't able to
create the database (named mythconverg) that stores all of the mythtv
settings. So when you try to fire up mythtv it tries to connect to the
database with the info from /etc/mythtv/mysql.txt, however that mysql user
and database were never actually created and the connection is rejected. I
don't really know anything about mysql other than what I have had to do with
mythtv. So I may be wrong about all of this, but it is what the best guess I
had after digging around when I had this problem.

You can test things out by logging into mysql from the command line like
this:

mysql -u mythtv -p mythconverg

I think the password should be the one stored in /etc/mythtv/mysql.txt. If
this doesn't work, then you have the wrong password or the user and database
never got created (as I explained above). You can try running 'sudo
dpkg-reconfigure mythtv-database' to setup the database again. This will
prompt you for some info. Use the following, mysql address:  'localhost',
mysql administrator account: root, password: <leave blank> (this is the
default unless you changed it), I believe this will setup your mythtv user
in mysql and create the mythconverg database. After it is done you can try
logging in from the command line again and see if that works. If you can get
things right, so that you can log in from the command line then mythtv
should have no problem connecting.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20081102/8805935a/attachment.htm