Mailing List Archive: Database Requirements for mythtv

Database Requirements for mythtv

Mar 31, 2003, 10:09 AM

Post #1 of 5 (1831 views)

Hi all,
Recently, I've upgrade to myth 0.8. Everything works fine on a single
machine. I've also setup a remote machine that's able to connect to the
server (mythbackend), watch live tv, watch recorded programs, etc. For
the life of me, I can't get the program guide to work. It fails saying
I don't have any channels defined in the database. I know that I do
because while watching live tv I get program info on the show I'm
watching. I think I'm connected to the database on the server machine
and thus have all this info available.
Another thing that freaks me is that if I stop mysql on the frontend
box, mythfrontend doesn't start up at all. Mythfrontend complains about
not being able to connect to the DB. So here are my questions.

1. Do I have to run mysql on the frontend as well as the server?

2. Do I need xmltv on the frontend?

Thanks,

Calvin

Re: Database Requirements for mythtv [ In reply to ]

dert at pobox

Mar 31, 2003, 10:27 AM

Post #2 of 5 (1787 views)

Permalink

#if Calvin Harrigan /* Mar 31, 12:09 */
> 1. Do I have to run mysql on the frontend as well as the server?

No. Turn off MySQL on the frontend and debug the problem from there.
It sounds like the frontend isn't pointing at the right MySQL server.
Check the contents of mysql.txt.

> 2. Do I need xmltv on the frontend?
#endif /* calvinharrigan@earthlink.net */

No.

RE: Database Requirements for mythtv [ In reply to ]

jcaputo1 at comcast

Mar 31, 2003, 10:27 AM

Post #3 of 5 (1793 views)

Permalink

Edit /usr/local/share/mythtv/mysql.txt on your frontend machine to point to
the backend's IP address.

> -----Original Message-----
> From: mythtv-users-bounces@snowman.net
> [mailto:mythtv-users-bounces@snowman.net]On Behalf Of Calvin Harrigan
> Sent: Monday, March 31, 2003 12:10 PM
> To: mythtv-users@snowman.net
> Subject: [mythtv-users] Database Requirements for mythtv
>
>
>
> Hi all,
> Recently, I've upgrade to myth 0.8. Everything works fine
> on a single
> machine. I've also setup a remote machine that's able to connect to the
> server (mythbackend), watch live tv, watch recorded programs, etc. For
> the life of me, I can't get the program guide to work. It fails saying
> I don't have any channels defined in the database. I know that I do
> because while watching live tv I get program info on the show I'm
> watching. I think I'm connected to the database on the server machine
> and thus have all this info available.
> Another thing that freaks me is that if I stop mysql on the frontend
> box, mythfrontend doesn't start up at all. Mythfrontend complains about
> not being able to connect to the DB. So here are my questions.
>
> 1. Do I have to run mysql on the frontend as well as the server?
>
> 2. Do I need xmltv on the frontend?
>
>
> Thanks,
>
> Calvin
>
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

RE: Database Requirements for mythtv [ In reply to ]

calvinharrigan at earthlink

Mar 31, 2003, 10:55 AM

Post #4 of 5 (1791 views)

Permalink

On Mon, 2003-03-31 at 12:27, Joseph A. Caputo wrote:
> Edit /usr/local/share/mythtv/mysql.txt on your frontend machine to point to
> the backend's IP address.
>
>
<snip>

The mysql.txt file was set correctly. I am able to get to the server
database because I can see the shows that are recorded on it. It's just
that when I shutdown myqsl on the frontend it says:

couldn't open db
Mutex destroy failure: Device or resource busy

Found the problem while messing with it for more information, I had to
delete the ~/.mythtv directory, seems like the code is still looking for
this directory.

Thanks anyway.

Calvin

RE: Database Requirements for mythtv [ In reply to ]

jcaputo1 at comcast

Mar 31, 2003, 11:09 AM

Post #5 of 5 (1795 views)

Permalink

Actually then, it sounds like your mysql.txt was *not* set correctly... or,
more specifically, it was picking up an incorrectly set mysql.txt from
~/.mythtv/mysql.txt

Being able to see a list of recorded show just means that you're talking to
the backend, not to the correct database (I think).

Anyway, glad to hear you've solved the problem. Good luck with your system!

-Joe C.

> -----Original Message-----
> From: mythtv-users-bounces@snowman.net
> [mailto:mythtv-users-bounces@snowman.net]On Behalf Of Calvin Harrigan
> Sent: Monday, March 31, 2003 12:55 PM
> To: Discussion about mythtv
> Subject: RE: [mythtv-users] Database Requirements for mythtv
>
>
> On Mon, 2003-03-31 at 12:27, Joseph A. Caputo wrote:
> > Edit /usr/local/share/mythtv/mysql.txt on your frontend machine
> to point to
> > the backend's IP address.
> >
> >
> <snip>
>
> The mysql.txt file was set correctly. I am able to get to the server
> database because I can see the shows that are recorded on it. It's just
> that when I shutdown myqsl on the frontend it says:
>
> couldn't open db
> Mutex destroy failure: Device or resource busy
>
> Found the problem while messing with it for more information, I had to
> delete the ~/.mythtv directory, seems like the code is still looking for
> this directory.
>
> Thanks anyway.
>
>
> Calvin
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users