<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Arial; font-size: 12pt; color: #000000'><br><br><hr id="zwchr"><b>From: </b>"Igor Cicimov" <icicimov@gmail.com><br><b>To: </b>"Discussion about MythTV" <mythtv-users@mythtv.org><br><b>Sent: </b>Tuesday, November 20, 2012 3:13:26 AM<br><b>Subject: </b>Re: [mythtv-users] Setting up a new backend from scratch<br><br><p dir="ltr">On 20/11/2012 6:21 PM, "Nick Rout" <<a href="mailto:nick.rout@gmail.com" target="_blank">nick.rout@gmail.com</a>> wrote:<br>
><br>
><br>
><br>
> On Tue, Nov 20, 2012 at 5:41 PM, Igor Cicimov <<a href="mailto:icicimov@gmail.com" target="_blank">icicimov@gmail.com</a>> wrote:<br>
>><br>
>><br>
>> On Tue, Nov 20, 2012 at 2:10 PM, Harry%20Devine <<a href="mailto:lifter89@comcast.net" target="_blank">lifter89@comcast.net</a>> wrote:<br>
>>><br>
>>><br>
>>><br>
>>> ________________________________<br>
>>> From: "Bill Meek" <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>><br>
>>> To: <a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
>>> Sent: Monday, November 19, 2012 6:32:50 PM<br>
>>><br>
>>> Subject: Re: [mythtv-users] Setting up a new backend from scratch<br>
>>><br>
>>> 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>
>>> 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<br>
>>><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>
>>> _______________________________________________<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>
>><br>
>> 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<br>
>><br>
>> $ mysql -u mythtv -p mythconverg<br>
>><br>
>> 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>
><br>
> I really wish people wouldn't advise to go outside the package management and configuration of the particular distro.<br>
><br>
><br>
> Nick, I agree but since he already tried the preferred way twice and it didnt work for him maybe this one will.</p><p dir="ltr"><br></p><p dir="ltr">Sorry, but I've tried everything that you guys have suggested, and I still can't connect. When I try to log in from the command line using "mysql -u mythtv -p mythconverg", I get the "access denied for user 'mythtv'@'192.168.1.106' error.</p><p dir="ltr"><br></p><p dir="ltr">Harry</p><p dir="ltr"><br></p><p dir="ltr">> _______________________________________________<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>
</p>
<br>_______________________________________________<br>mythtv-users mailing list<br>mythtv-users@mythtv.org<br>http://www.mythtv.org/mailman/listinfo/mythtv-users<br></div></body></html>