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

Nick Rout nick.rout at gmail.com
Tue Nov 20 07:21:28 UTC 2012


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121120/2a713ff9/attachment.html>


More information about the mythtv-users mailing list