>From: Jarod Wilson <[EMAIL PROTECTED]>
>Reply-To: Discussion about mythtv <mythtv-users@mythtv.org>
>To: Discussion about mythtv <mythtv-users@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
_______________________________________________ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
