[mythtv-users] Orphaned files

[Craig Huff]

On Wed, 30 May 2007 22:38:28 -0500, Mitch Gore wrote:
> 
> Hi,
> 
> I am running mythtv .21 from ATrpm's bleeding and am trying to fix any
> orphaned files I have.  When i run myth.find_orphans.pl i get this error:
> 
> [root at mythtv contrib]# perl myth.find_orphans.pl
> DBI connect('database=mythconverg:host=mythtv','mythtv',...) failed: Host
> 'mythtv' is not allowed to connect to this MySQL server at
> myth.find_orphans.pl line 99
> Cannot connect to database mythconverg on host mythtv:
> 
> and if i log into sql it works just fine.
> 
> [root at mythtv contrib]# mysql -u mythtv -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 31 to server version: 5.0.27
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql>
> 
> so whats the problem?
> 
> Thanks,
> Mitchell


Mitchell,

Sounds like you're using a FC setup along the lines of Jarrod Wilson's HOWTO and 
set a password for the mythtv user in MySQL.

If so, you'll probably find that the perl script assumes no password and so all the 
mysql invocations fail.  You'll have to either drop the password (set it to nothing) or 
do as I did in another script and edit all the mysql invocations.  The existing pattern 
would be:
     mysql -u mythtv <some command string>
The modified pattern would be:
    mysql -u mythtv -p<password or parameter containing it> <some command string>
CAUTION! There can be NO spaces between the "-p" and the password value!

In practice, I don't have any concerns about the mysql password in this situation 
(mythtv isn't my idea of a high security risk), so I just hard-coded in the password, 
although it might have been simpler in the long run to change the password in MySQL to 
eliminate it altogether.

If that doesn't work, another possibility (speculation here) is that mythtv hasn't been
defined as an "authorized user" of the mythconverg database.  I don't have the resources
here to investigate how that would be rectified, but if it needs to be done and **I** did it, 
I got the information from Jarrod's fine HOWTO. ;-)

If the first solution doesn't solve the problem, check his HOWTO for the steps to set up 
the MySQL database and the mythtv user account in MySQL.

See: http://wilsonet.com/mythtv/fcmyth.php

Good Luck!


Craig Huff



       
____________________________________________________________________________________Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469