[mythtv-users] Anyway to have mythbackend and mysql server on different machines?

[Listbox]

Thanks folks!
I grepped for "/mysql.txt" in the sources, and came up with:
./contrib/optimize_mythdb.pl:    my @mysql =
('/usr/local/share/mythtv/mysql.txt',
./contrib/optimize_mythdb.pl:                 '/usr/share/mythtv/mysql.txt',
./contrib/optimize_mythdb.pl:                 '/etc/mythtv/mysql.txt',
./contrib/optimize_mythdb.pl:
'/usr/local/etc/mythtv/mysql.txt',
./contrib/optimize_mythdb.pl:
"$ENV{HOME}/.mythtv/mysql.txt", 

The path that was correct for me was "/usr/share/mythtv/"
I created that file to point to my mysql server, and I was golden!

By the way, the docs in the mythtv 20 source directory are inconsistent with
my installation, there is no /usr/local/share/mythtv directory. 
I installed from the ATRmpms repository, I have no idea if that makes a
difference.

Listbox

-----Original Message-----
From: Rich West [mailto:Rich.West at wesmo.com] 
Sent: Monday, December 18, 2006 10:55 AM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Anyway to have mythbackend and mysql server on
different machines?

Kevin Kuphal wrote:
> Listbox wrote:
>   
>> Hi,
>> I'd like to have mythbackend use a remote mysql server, instead of 
>> using a local socket file.
>> I've discovered that setting ~/.mythtv/mysql.txt only works for the 
>> frontend. If mysql is not running on the same machine, then 
>> mythbackend fails when it looks for the "socket file", and refuses to 
>> start.
>>  
>> Is there an equivalent to "mysql.txt" for mythbackend, or any other 
>> way to specify a remote mysql server?
>>     
> Can't you just run mythtv-setup on that system and change the database 
> parameters?
Just make sure that the local mysql server is down when you run mythsetup,
and it will prompt you for the new (correct) database paramters.

-Rich
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users