[mythtv-users] optimize_mythdb.pl - "unable to locate mysql.txt"

[Jose Bernardo Silva]

Found the problem. Michael, you were right.
First I had to edit /usr/share/perl/5.8.8/MythTV.pm to add some debug
output ('print STDERR "Trying $file.\n";' after line 148), and saw
that it was trying out three files - /usr/share/mythtv/mysql.txt,
/etc/mythtv/mysql.txt, and ~/.mythtv/mysql.txt. The first is a link to
the second, the second one has 660 permissions so probably couldn't be
read, and only the third one is complete - but had one extraneous
'DBHostName=' entry as the first line, and that confused MythTV.pm,
which wouldn't find the second (correct) entry.
As I was assuming it was checking first /etc/mythtv/mysql.txt, I only
did a fast 'cat' of ~/.mythtv/mysql.txt, and missed the dupe
'DBHostName=' entry.
Now that is fixed, it's time for me to try to get a secondary backend working...

On Dec 1, 2007 7:10 PM, Jose Bernardo Silva <jose.bandos at gmail.com> wrote:
> On Dec 1, 2007 6:42 PM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>
> > So, if the config file is there, it doesn't properly specify a
> > DBHostName , so you need to fix it.
> >
>
> These are the contents of mysql.txt:
>
> DBHostName=192.168.1.149
> DBUserName=mythtv
> DBName=mythconverg
> DBPassword=********
>
> As you can see, DBHostName is specified there, so the problem is
> probably elsewhere.
>
> >
> > I'm sure Chris would love a patch from someone who knows the UPnP
> > autodiscovery stuff well enough to implement it for the Perl
> > bindings...  (hint, hint :)
>
> I wish I could help here...
>