On Sunday 27 February 2005 08:07, sean darcy wrote:
> I've used atrpms to install. mysql.txt appears twice:
>> locate mysql.txt
> /.mythtv/mysql.txt
> /home/mythtv/.mythtv/mysql.txt
I have 3 of them. The two locations you mentioned at /root/.mythtv/mysql.txt.
> .mythtv under the root directory look fishy. Is this where it should be?
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.
> 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.
> googling shows a file /etc/mythtv/mysql.txt, which I don't have.
That's only w/mdz Debian packages, I believe.
--
Jarod Wilson
jarod at wilsonet.com
Got a question? Read this first...
http://catb.org/~esr/faqs/smart-questions.html
MythTV, Fedora Core & ATrpms documentation:
http://wilsonet.com/mythtv/
MythTV Searchable Mailing List Archive
http://www.gossamer-threads.com/lists/mythtv/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20050227/5f5f5179/attachment.pgp