[mythtv-users] Orphaned files

Craig Huff huffcs at yahoo.com
Thu Jun 14 03:32:30 UTC 2007


----- Original Message ----
From: Mitch Gore <mitchell.gore at gmail.com>
To: Craig Huff <huffcs at yahoo.com>
Sent: Tuesday, June 12, 2007 12:57:23 PM
Subject: Re: Orphaned files

Could someone please explain how i would go about doing this?  Yes, i did set the box up with Jarod's guide.  

 

I think i would rather edit the orphan script than start manually editing settings in mythconverg/mysql.  How can i do a replace with 'vi' to get this done quickly?

 

Thanks,
Mitchell

 

On 5/31/07, Craig Huff <huffcs at yahoo.com> wrote:
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




Mitchell,

Sorry I didn't get back to you sooner.  I've been busy ;-)

In the future, you should make sure you at least cc: the list.  Others may get back to you
sooner and they may have an answer that any one person doesn't know (yet!).

Since you will find mysql invocations all over the place in mythtv related perl scripts, rather
than fix one and have to fix all the others, too, you might be better served to log in to mysql
and remove the password for the mysql "user" mythtv.  I don't know how to do that off the 
top of my head, but you should be able to discern the process from reading the section of
Jarrod's guide dealing with setting up the mysql database.

Mind you, this is not the same as clearing the *nix login password for the mythtv user!  It can
be confusing, but there are two different systems with logins for a user named mythtv, based
on Jarrod's guide -- one is a linux login and the other is a mysql login.  Anyone who knows 
the mysql login name and password can login to mysql as mythtv, not just the linux mythtv login.

I don't know that it would be a security risk to leave the mysql login without a password, but 
others on the list may differ with that.

Others feel free to let me know when I'm all wet!

Hope you've already fixed the problem or this helps you get there.

Craig.



       
____________________________________________________________________________________
Choose the right car based on your needs.  Check out Yahoo! Autos new Car Finder tool.
http://autos.yahoo.com/carfinder/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070613/3ff8331b/attachment-0001.htm 


More information about the mythtv-users mailing list