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

Igor Cicimov icicimov at gmail.com
Tue Nov 20 08:13:26 UTC 2012


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.
> _______________________________________________
> 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/20121120/4cf5ca8c/attachment.html>


More information about the mythtv-users mailing list