<html><head/><body><html><head></head><body><br><br><div class="gmail_quote">Mike Perkins <mikep@randomtraveller.org.uk> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre style="white-space: pre-wrap; word-wrap:break-word; font-family: sans-serif; margin-top: 0px">On 21/11/12 13:27, Harry Devine wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">On 11/21/2012 5:52 AM, Mike Perkins wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;">On 21/11/12 04:12, Harry%20Devine wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;">----- Original Message ----- From: "Igor Cicimov" <icicimov@gmail.com> To:<br />"Discussion about MythTV" <mythtv-users@mythtv.org> Sent: Tuesday, November<br />20, 2012 3:13:26 AM Subject: Re: [mythtv-users] Setting up a new backend from<br />scratch<br />On 20/11/2012 6:21 PM, "Nick Rout" < nick.rout@gmail.com > wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex
0.8ex; border-left: 1px solid #fcaf3e; padding-left: 1ex;">On Tue, Nov 20, 2012 at 5:41 PM, Igor Cicimov < icicimov@gmail.com ><br />wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #e9b96e; padding-left: 1ex;">On Tue, Nov 20, 2012 at 2:10 PM, Harry%20Devine < lifter89@comcast.net ><br />wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;">Subject: Re: [mythtv-users] Setting up a new backend from scratch<br />On 11/19/2012 05:09 PM, Harry Devine wrote: ...<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;">Yep, it's running, and I can login using my username & password.</blockquote><br />Just in case, "my username" sounds like it could be "harry", you must<br />test using "mythtv". But I suspect you know that.<br /><br />And, like Nick suggested, that mythtv its password
exists in ALL copies<br />of config.xml and mysql.txt. locate -b '\mysql.txt' '\config.xml'<br /><br />Next step: mythtv-setup --logpath /tmp and exit.<br /><br />Then pastebinit /tmp/mythtv-setup.20121119231914.6749.log (or whatever<br />file was created. Post the link returned by pastebinit here. If you<br />don't have it, sudo apt-get install pastebinit (I've become a bit fan<br />of it.)<br /><br />Yeah, my username was not mythtv. So I cleared out all of the mysql.txt<br />and config.xml files (I think all of them), ran "sudo dpkg-reconfigure<br />mythtv-common" as Nick suggested, let the mythtv user get a new<br />password generated, and ran mythtv-setup again. Same result. When I try<br />to log in using "mysql -u mythtv -p mythconverg", I get "ERROR 1045<br />(28000): Access denied for user 'mythtv'@'localhost' (using password:<br />YES)".<br /><br />BTW, here's the pastebinit URL that you requested:<br /><a
href="http://paste.ubuntu.com/1371704">http://paste.ubuntu.com/1371704</a></blockquote><br /><br />Log in as root/admin in mysql and grant all to mythtv user on the<br />mythconverg database:<br /><br />$ mysql -u root -p <root_password><br /></blockquote></blockquote></blockquote>mysql> grant all on mythconverg.* to 'mythtv'@'localhost' identified by<br />'mythconverg';<br />mysql> flush privileges;<br />mysql> quit<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #fcaf3e; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #e9b96e; padding-left: 1ex;">$ mysql -u mythtv -p mythconverg<br /><br />to check if it works now. If not, you have something else messed up. Hope<br />you know your mysql admin password ...<br /><br />This error in your
pastebin:<br /><br />"Can't connect to MySQL server on '<a href="http://192.168.1.106">192.168.1.106</a>' (111)"<br /><br />indicates the database is not listening on your host IP but on localhost<br />interface only (<a href="http://127.0.0.1">127.0.0.1</a>). Edit your /etc/my.cnf file and change the<br />bind address under [mysqld] section which in your case should look like:<br />bind = <a href="http://127.0.0.1">127.0.0.1</a> # this might be localhost too to bind = <a href="http://192.168.1.106">192.168.1.106</a> or<br />if you want to listen to any interface you have configured on the box to<br />bind = 0.0.0.0<br /><br />Then you need to execute the above mysql steps again for mythtv user for<br />the local host and EVERY other client that is going to connect to this<br />backend database:<br /><br />$ mysql -u root -p <root_password><br /></blockquote></blockquote></blockquote>mysql> grant all on mythconverg.* to 'mythtv'@'<a
href="http://192.168.1.106">192.168.1.106</a>' identified by<br />'mythconverg';<br />mysql> grant all on mythconverg.* to 'mythtv'@'IP_frontend_1' identified by<br />'mythconverg';<br />mysql> grant all on mythconverg.* to 'mythtv'@'IP_frontend_2' identified by<br />'mythconverg'<br />mysql> flush privileges;<br />mysql> quit<br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #fcaf3e; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #e9b96e; padding-left: 1ex;">and test from the local box and remote frontends:<br /><br />$ mysql -h <a href="http://192.168.1.106">192.168.1.106</a> -u mythtv -p mythconverg</blockquote><br /><br />I really wish people wouldn't advise to go outside the package management<br />and configuration of the particular
distro.<br /><br />Nick, I agree but since he already tried the preferred way twice and it<br />didnt work for him maybe this one will.</blockquote><br />Sorry, but I've tried everything that you guys have suggested, and I still<br />can't connect. When I try to log in from the command line using "mysql -u<br />mythtv -p mythconverg", I get the "access denied for user<br />'mythtv'@'<a href="http://192.168.1.106">192.168.1.106</a>' error.</blockquote><br />What password were you using in your tests? If you followed the above<br />instructions *exactly* then the password you have set would be 'mythconverg'.<br />(Without the quotes of course.)</blockquote><br />OK, that worked. I did look at the mysql.txt files that I found and changed the<br />passwords to mythconverg and was able to connect. I can't run mythtv-setup<br />until I get home (I was SSH'd into my box from work). How did the password get<br />set to 'mythconverg' by doing those steps? I had used Nick's suggestion
of<br />doing "sudo dpkg-reconfigure mythtv-common" and set a password there, so why<br />wasn't that password being used? Does that reconfigure NOT set the mythtv<br />password into the database?</blockquote><br />That's what the "identified by" clause does. You probably ought to have set that <br />value to the password you got when you reconfigured. It doesn't really matter, <br />so long as everything ends up consistent.<br /></pre></blockquote></div><br>
Thanks everyone for the help. I didn't realize that the identified clause was setting the password, and that wrapped me around the axle a bit. I went ahead and gave the user a better password and just successfully ran mythtv-setup.<br>
<br>
Harry<br>
<br>
-- <br>
Sent from my Android phone with K-9 Mail. Please excuse my brevity.</body></html></body></html>