[mythtv-users] where does mysql.txt go?

[sean darcy]

>From: Jarod Wilson <jarod at wilsonet.com>
>Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
>To: Discussion about mythtv <mythtv-users at mythtv.org>
>Subject: Re: [mythtv-users] where does mysql.txt go?
>Date: Sun, 27 Feb 2005 10:53:35 -0800
>
>On Sunday 27 February 2005 08:07, sean darcy wrote:
.............................................
>Yes and no. Under an ATrpms install, mythbackend starts as root, and it 
starts
>early enough in the boot process that root's "home" is still 
/, so
>mythbackend looks for a config file in /.mythtv/mysql.txt. That one bit 
me in
>the butt for a little while when I was trying to figure out why my slave
>backends kept trying to connect to localhost at boot time, but would 
connect
>fine if I started the backend w/a 'service mythbackend start' after the
>system was up -- I manually edited the /root/.mythtv/mysql.txt file with 
the
>master backend's IP, but needed to make the same change in 
/.mythtv/mysql.txt
>to get it to work at boot. These files are automatically created if they
>don't exist, and auto-populated with localhost.
>

Aha. Very interesting.

> > Also the root file has:
> >
> > cat mysql.txt
> > DBHostName=localhost
> > DBUserName=mythtv
> > DBPassword=mythtv
> > DBName=mythconverg
> > DBType=QMYSQL3
> >
> > while the one in the home directory has:
> >
> > cat mysql.txt
> > DBHostName      127.0.0.1
>
>localhost and 127.0.0.1 are almost the same... I think if you have
>"localhost", the local socket (/var/lib/mysql/mysql.sock) gets 
used, if you
>have 127.0.0.1, a tcp/ip connection is used. I believe 
"localhost" is
>preferred.
>

I wasn't clear. That is the only entry in the home directory.  Shouldn't it 
also have DBUser, etc? I've gone ahead and copied the root file to the home 
directory.

thanks for the quick reply.

sean