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

[Harry Devine]

On 11/21/2012 5:52 AM, Mike Perkins wrote:
> 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.)
>
OK, that worked.  I did look at the mysql.txt files that I found and 
changed the passwords to mythconverg and was able to connect.  I can't 
run mythtv-setup until I get home (I was SSH'd into my box from work).  
How did the password get set to 'mythconverg' by doing those steps?  I 
had used Nick's suggestion of doing "sudo dpkg-reconfigure 
mythtv-common" and set a password there, so why wasn't that password 
being used?  Does that reconfigure NOT set the mythtv password into the 
database?

Thanks,
Harry