[mythtv-users] Setting up a new backend from scratch

Harry%20Devine lifter89 at comcast.net
Wed Nov 21 04:12:47 UTC 2012



----- Original Message -----
From: "Igor Cicimov" <icicimov at gmail.com> 
To: "Discussion about MythTV" <mythtv-users at mythtv.org> 
Sent: Tuesday, November 20, 2012 3:13:26 AM 
Subject: Re: [mythtv-users] Setting up a new backend from scratch 



On 20/11/2012 6:21 PM, "Nick Rout" < nick.rout at gmail.com > wrote: 
> 
> 
> 
> On Tue, Nov 20, 2012 at 5:41 PM, Igor Cicimov < icicimov at gmail.com > wrote: 
>> 
>> 
>> On Tue, Nov 20, 2012 at 2:10 PM, Harry%20Devine < lifter89 at comcast.net > wrote: 
>>> 
>>> 
>>> 
>>> ________________________________ 
>>> From: "Bill Meek" < keemllib at gmail.com > 
>>> To: mythtv-users at mythtv.org 
>>> Sent: Monday, November 19, 2012 6:32:50 PM 
>>> 
>>> Subject: Re: [mythtv-users] Setting up a new backend from scratch 
>>> 
>>> On 11/19/2012 05:09 PM, Harry Devine wrote: 
>>> ... 
>>> > Yep, it's running, and I can login using my username & password. 
>>> 
>>> Just in case, "my username" sounds like it could be "harry", 
>>> you must test using "mythtv". But I suspect you know that. 
>>> 
>>> And, like Nick suggested, that mythtv its password exists in ALL 
>>> copies of config.xml and mysql.txt. locate -b '\mysql.txt' '\config.xml' 
>>> 
>>> Next step: mythtv-setup --logpath /tmp and exit. 
>>> 
>>> Then pastebinit /tmp/mythtv-setup.20121119231914.6749.log (or whatever 
>>> file was created. Post the link returned by pastebinit here. If you 
>>> don't have it, sudo apt-get install pastebinit (I've become a bit fan 
>>> of it.) 
>>> 
>>> -- 
>>> Bill 
>>> 
>>> 
>>> 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)". 
>>> 
>>> BTW, here's the pastebinit URL that you requested: http://paste.ubuntu.com/1371704 
>>> 
>>> Thanks, 
>>> Harry 
>>> 
>>> _______________________________________________ 
>>> mythtv-users mailing list 
>>> mythtv-users at mythtv.org 
>>> http://www.mythtv.org/mailman/listinfo/mythtv-users 
>>> 
>>> _______________________________________________ 
>>> mythtv-users mailing list 
>>> mythtv-users at mythtv.org 
>>> http://www.mythtv.org/mailman/listinfo/mythtv-users 
>>> 
>> 
>> Log in as root/admin in mysql and grant all to mythtv user on the mythconverg database: 
>> 
>> $ mysql -u root -p <root_password> 
>> mysql> grant all on mythconverg.* to 'mythtv'@'localhost' identified by 'mythconverg'; 
>> mysql> flush privileges; 
>> mysql> quit 
>> 
>> $ mysql -u mythtv -p mythconverg 
>> 
>> to check if it works now. If not, you have something else messed up. Hope you know your mysql admin password ... 
>> 
>> This error in your pastebin: 
>> 
>> "Can't connect to MySQL server on '192.168.1.106' (111)" 
>> 
>> 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: 
>> bind = 127.0.0.1 # this might be localhost too 
>> to 
>> bind = 192.168.1.106 
>> or if you want to listen to any interface you have configured on the box to 
>> bind = 0.0.0.0 
>> 
>> 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: 
>> 
>> $ mysql -u root -p <root_password> 
>> mysql> grant all on mythconverg.* to 'mythtv'@'192.168.1.106' identified by 'mythconverg'; 
>> mysql> grant all on mythconverg.* to 'mythtv'@'IP_frontend_1' identified by 'mythconverg'; 
>> mysql> grant all on mythconverg.* to 'mythtv'@'IP_frontend_2' identified by 'mythconverg 
>> mysql> flush privileges; 
>> mysql> quit 
>> 
>> and test from the local box and remote frontends: 
>> 
>> $ mysql -h 192.168.1.106 -u mythtv -p mythconverg 
>> 
>> 
> 
> I really wish people wouldn't advise to go outside the package management and configuration of the particular distro. 
> 
> 
> Nick, I agree but since he already tried the preferred way twice and it didnt work for him maybe this one will. 




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. 




Harry 




> _______________________________________________ 
> mythtv-users mailing list 
> mythtv-users at mythtv.org 
> http://www.mythtv.org/mailman/listinfo/mythtv-users 
> 

_______________________________________________ 
mythtv-users mailing list 
mythtv-users at mythtv.org 
http://www.mythtv.org/mailman/listinfo/mythtv-users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121121/4e701641/attachment.html>


More information about the mythtv-users mailing list