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

Mike Perkins mikep at randomtraveller.org.uk
Wed Nov 21 10:52:01 UTC 2012


On 21/11/12 04:12, Harry%20Devine wrote:
> ----- 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:
>>>> 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.)
>>>>
>>>> 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
>>>>
>>>
>>> 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.
>
What password were you using in your tests? If you followed the above 
instructions *exactly* then the password you have set would be 'mythconverg'.
(Without the quotes of course.)

-- 

Mike Perkins



More information about the mythtv-users mailing list