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

Igor Cicimov icicimov at gmail.com
Tue Nov 20 04:41:44 UTC 2012


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


More information about the mythtv-users mailing list