<br><br><div class="gmail_quote">On Tue, Nov 20, 2012 at 5:41 PM, Igor Cicimov <span dir="ltr"><<a href="mailto:icicimov@gmail.com" target="_blank">icicimov@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br><div class="gmail_extra"><div><div class="h5"><div class="gmail_quote">On Tue, Nov 20, 2012 at 2:10 PM, Harry%20Devine <span dir="ltr"><<a href="mailto:lifter89@comcast.net" target="_blank">lifter89@comcast.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style="font-size:12pt;font-family:Arial"><br><br><hr><b>From: </b>"Bill Meek" <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>><br>
<b>To: </b><a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br><b>Sent: </b>Monday, November 19, 2012 6:32:50 PM<div><br><b>Subject: </b>Re: [mythtv-users] Setting up a new backend from scratch<br>
<br></div><div>On 11/19/2012 05:09 PM, Harry Devine wrote:<br>...<br>> Yep, it's running, and I can login using my username & password.<br><br>Just in case, "my username" sounds like it could be "harry",<br>
you must test using "mythtv". But I suspect you know that.<br><br>And, like Nick suggested, that mythtv its password exists in ALL<br>copies 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>-- <br>Bill<br><br><br></div>Yeah, my username was not mythtv. So I cleared out all of the mysql.txt and config.xml files (I think all of them), ran "sudo dpkg-reconfigure mythtv-common" as Nick suggested, let the mythtv user get a new password generated, and ran mythtv-setup again. Same result. When I try to log in using "mysql -u mythtv -p mythconverg", I get "ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)".<br>
<br>BTW, here's the pastebinit URL that you requested: <a href="http://paste.ubuntu.com/1371704" target="_blank">http://paste.ubuntu.com/1371704</a><br><br>Thanks,<br>Harry<div><br>_______________________________________________<br>
mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br><a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</div></div></div><br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br></div></div>Log in as root/admin in mysql and grant all to mythtv user on the mythconverg database:<br><br>$ mysql -u root -p <root_password><br>mysql> grant all on mythconverg.* to 'mythtv'@'localhost' identified by 'mythconverg';<br>
mysql> flush privileges;<br>mysql> quit<div class="im"><br>$ mysql -u mythtv -p mythconverg<br><br></div>to check if it works now. If not, you have something else messed up. Hope you know your mysql admin password ...<br>
<br>This error in your pastebin:<br>
<br>"Can't connect to MySQL server on '192.168.1.106' (111)"<br><br> indicates the database is not listening on your host IP but on localhost interface only (127.0.0.1). Edit your /etc/my.cnf file and change the bind address under [mysqld] section which in your case should look like:<br>
bind = 127.0.0.1 # this might be localhost too<br>to<br>bind = 192.168.1.106<br>or 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 the local host and EVERY other client that is going to connect to this backend database:<br>
<br>$ mysql -u root -p <root_password><br>mysql> grant all on mythconverg.* to 'mythtv'@'192.168.1.106' identified by 'mythconverg';<br>mysql> grant all on mythconverg.* to 'mythtv'@'IP_frontend_1' identified by 'mythconverg';<br>
mysql> grant all on mythconverg.* to 'mythtv'@'IP_frontend_2' identified by 'mythconverg';<br>mysql> flush privileges;<br>mysql> quit<br><br>and test from the local box and remote frontends:<br>
<br>$ mysql -h 192.168.1.106 -u mythtv -p mythconverg<br><br><br></div></blockquote><div><br>I really wish people wouldn't advise to go outside the package management and configuration of the particular distro.<br><br>
</div></div>