Mailing List Archive

John Klimek wrote:
> My frontend box is an xbox running debian, but I don't think that matters.
>
> I've compiled and installed MythTV v0.8.
>
> When I go to run "mythfrontend", I get two lines that I can't read (x-box
> text on the tv is pretty bad), but then I get a line clearly saying
> "couldn't open db".
>
> Isn't the database on my backend server? What is causing this error?

I assume that you can connect to the database from the
backend machine. Make sure that the ~/.mythtv/mysql.txt
file is correct on the x-box. Most likely, your mysql
server is not listening for network connections. Edit
your /etc/mysql/my.cnf file to comment out the line
"skip-networking" (uncomment if you don't not want to
unsupress not having un-skip-network). Then restart the
mysql server and check to see that it is listening:

$ netstat -a | grep mysql
tcp 0 0 *:mysql *:* LISTEN

From the x-box, you can verify that it will accept connections.

$ mysql -u mythtv -pmythtv -hyourhost mythconverg

If this works and the fields in the mysql.txt file match,
you should be golden.

-- bjm

> I assume that you can connect to the database from the
> backend machine. Make sure that the ~/.mythtv/mysql.txt
> file is correct on the x-box.

I don't have a ~/.mythtv directory. I do however have a
/etc/mythtv/mysql.txt file though.

> Most likely, your mysql
> server is not listening for network connections. Edit
> your /etc/mysql/my.cnf file to comment out the line
> "skip-networking" (uncomment if you don't not want to
> unsupress not having un-skip-network). Then restart the
> mysql server and check to see that it is listening:

On my backend (Mandrake 0.91), it doesn't have a /etc/mysql directory at
all...

> $ netstat -a | grep mysql
> tcp 0 0 *:mysql *:* LISTEN
>

Using that command DOES give me those results.

> From the x-box, you can verify that it will accept connections.
> $ mysql -u mythtv -pmythtv -hyourhost mythconverg

My X-Box doesn't seem to have the MySQL monitor (eg. the command 'mysql' is
not found).

> If this works and the fields in the mysql.txt file match,
> you should be golden.

Is the DBPasswd encrypted in the mysql.txt file?

John Klimek wrote:
>
>>I assume that you can connect to the database from the
>>backend machine. Make sure that the ~/.mythtv/mysql.txt
>>file is correct on the x-box.
>
>
> I don't have a ~/.mythtv directory. I do however have a
> /etc/mythtv/mysql.txt file though.

That would be the one then. However, it might get overwritten
if you reinstall so you may want to consider creating a
.mythtv dir.

>>Most likely, your mysql
>>server is not listening for network connections. Edit
>>your /etc/mysql/my.cnf file to comment out the line
>>"skip-networking" (uncomment if you don't not want to
>>unsupress not having un-skip-network). Then restart the
>>mysql server and check to see that it is listening:
>
>
> On my backend (Mandrake 0.91), it doesn't have a /etc/mysql directory at
> all...

See, I knew you were going to say that ;-). You may want to
locate my.cnf for future reference but if it is listening
then this isn't and issue right now.

>>$ netstat -a | grep mysql
>>tcp 0 0 *:mysql *:* LISTEN
>>
>
>
> Using that command DOES give me those results.
>
>
>> From the x-box, you can verify that it will accept connections.
>>$ mysql -u mythtv -pmythtv -hyourhost mythconverg
>
>
> My X-Box doesn't seem to have the MySQL monitor (eg. the command 'mysql' is
> not found).

Problem. You need to install the mysql-client software.
I'm a Debian user so don't rake me for not knowing your
package name ;-).

>
>>If this works and the fields in the mysql.txt file match,
>>you should be golden.
>
>
> Is the DBPasswd encrypted in the mysql.txt file?

Nope. Plain text. Just like the mysql.txt file that works
on the master backend.

The file on the master may have the hostname 'localhost'.
Make sure that you use the real hostname in the mysql.txt
on the xbox. Also, you may need to grant access for mythtv
over the network.

$ mysql -u root mysql
mysql> GRANT ALL ON mythconverg.* TO mythtv@'%' IDENTIFIED BY "mythtv";
mysql> flush privileges;

-- bjm

Phew!

Ok, I almost have everything setup!

The only problem I have now is that I don't have an actual keyboard plugged
into my xbox.

Once I run the setup program to configure the xbox frontend, it WORKS, but I
can't do anything.

How can I use my X-Box dvd remote to control the menus inside of MythTV?

I'm almost there! Thanks for helping me so far!

>How can I use my X-Box dvd remote to control the menus inside of
MythTV?

Ed's Debian comes with a kernel module that does just what you want. To
enable it you have to disable the xpad module....

Rmmod xpad
Modprobe usb-xboxir

The default driver doesn't work too well, heaps of doubled up keys being
sent. I have a patched kernel module that a mate and I put together
that works a lot better. Mail me if you are interested.

Cheers
Peter