<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">From: Mitch Gore <mitchell.gore@gmail.com><br>To: Craig Huff <huffcs@yahoo.com><br>Sent: Tuesday, June 12, 2007 12:57:23 PM<br>Subject: Re: Orphaned files<br><br><div>Could someone please explain how i would go about doing this? Yes, i did set the box up with Jarod's guide. </div>
<div> </div>
<div>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?</div>
<div> </div>
<div>Thanks,<br>Mitchell<br><br> </div>
<div><span class="gmail_quote">On 5/31/07, <b class="gmail_sendername">Craig Huff</b> <<a rel="nofollow" target="_blank" href="mailto:huffcs@yahoo.com">huffcs@yahoo.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">On Wed, 30 May 2007 22:38:28 -0500, Mitch Gore wrote:<br>><br>> Hi,<br>><br>> I am running mythtv .21 from ATrpm's bleeding and am trying to fix any
<br>> orphaned files I have. When i run myth.find_orphans.pl i get this error:<br>><br>> [root@mythtv contrib]# perl myth.find_orphans.pl<br>> DBI connect('database=mythconverg:host=mythtv','mythtv',...) failed: Host
<br>> 'mythtv' is not allowed to connect to this MySQL server at<br>> myth.find_orphans.pl line 99<br>> Cannot connect to database mythconverg on host mythtv:<br>><br>> and if i log into sql it works just fine.
<br>><br>> [root@mythtv contrib]# mysql -u mythtv -p<br>> Enter password:<br>> Welcome to the MySQL monitor. Commands end with ; or \g.<br>> Your MySQL connection id is 31 to server version: 5.0.27<br>>
<br>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>><br>> mysql><br>><br>> so whats the problem?<br>><br>> Thanks,<br>> Mitchell<br><br><br>Mitchell,<br>
<br>Sounds like you're using a FC setup along the lines of Jarrod Wilson's HOWTO and<br>set a password for the mythtv user in MySQL.<br><br>If so, you'll probably find that the perl script assumes no password and so all the
<br>mysql invocations fail. You'll have to either drop the password (set it to nothing) or<br>do as I did in another script and edit all the mysql invocations. The existing pattern<br>would be:<br> mysql -u mythtv <some command string>
<br>The modified pattern would be:<br> mysql -u mythtv -p<password or parameter containing it> <some command string><br>CAUTION! There can be NO spaces between the "-p" and the password value!<br><br>
In practice, I don't have any concerns about the mysql password in this situation<br>(mythtv isn't my idea of a high security risk), so I just hard-coded in the password,<br>although it might have been simpler in the long run to change the password in MySQL to
<br>eliminate it altogether.<br><br>If that doesn't work, another possibility (speculation here) is that mythtv hasn't been<br>defined as an "authorized user" of the mythconverg database. I don't have the resources
<br>here to investigate how that would be rectified, but if it needs to be done and **I** did it,<br>I got the information from Jarrod's fine HOWTO. ;-)<br><br>If the first solution doesn't solve the problem, check his HOWTO for the steps to set up
<br>the MySQL database and the mythtv user account in MySQL.<br><br>See: <a rel="nofollow" target="_blank" href="http://wilsonet.com/mythtv/fcmyth.php">http://wilsonet.com/mythtv/fcmyth.php</a><br><br>Good Luck!<br><br><br>Craig Huff<br><br></blockquote></div></div><br>Mitchell,<br><br>Sorry I didn't get back to you sooner. I've been busy ;-)<br><br>In the future, you should make sure you at least cc: the list. Others may get back to you<br>sooner and they may have an answer that any one person doesn't know (yet!).<br><br>Since you will find mysql invocations all over the place in mythtv related perl scripts, rather<br>than fix one and have to fix all the others, too, you might be better served to log in to mysql<br>and remove the password for the mysql "user" mythtv. I don't know how to do that off the <br>top of my head, but you should be able to discern the process from reading the section of<br>Jarrod's guide dealing with setting up the mysql
database.<br><br>Mind you, this is not the same as clearing the *nix login password for the mythtv user! It can<br>be confusing, but there are two different systems with logins for a user named mythtv, based<br>on Jarrod's guide -- one is a linux login and the other is a mysql login. Anyone who knows <br>the mysql login name and password can login to mysql as mythtv, not just the linux mythtv login.<br><br>I don't know that it would be a security risk to leave the mysql login without a password, but <br>others on the list may differ with that.<br><br>Others feel free to let me know when I'm all wet!<br><br>Hope you've already fixed the problem or this helps you get there.<br><br>Craig.</div></div><br>
<hr size=1>Be a better Globetrotter. <a href="http://us.rd.yahoo.com/evt=48254/*http://answers.yahoo.com/dir/_ylc=X3oDMTI5MGx2aThyBF9TAzIxMTU1MDAzNTIEX3MDMzk2NTQ1MTAzBHNlYwNCQUJwaWxsYXJfTklfMzYwBHNsawNQcm9kdWN0X3F1ZXN0aW9uX3BhZ2U-?link=list&sid=396545469">Get better travel answers </a>from someone who knows.<br>Yahoo! Answers - Check it out.
</body></html>