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

Thu Nov 22 02:43:21 UTC 2012

Sent from my iPad

On 2012-11-20, at 11:12 PM, Harry%20Devine <lifter89 at comcast.net> wrote:

> 
> 
> 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:
> >>>
> >>>
> >>>
> >>> ________________________________
> >>> 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.
> 
> 
> 
> 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.
> 
> 
> 
> Harry
> 

The should no space between the -p and the mysql password. There must be a space after the -u user bit. And it is clearly confusing to use the generic name of the *database* as the password. 

Use mysql -u mythtv -pmythtv  (or -pmythconverg) if that is actually the password.  But you did not confirm that you can get in using 'mysql -u root -pyourrootpassword'  it is implied that you can but lets be sure.  

Delete ALL config.xml files but the one in your myth user's home folder. Symlink all others to there to avoid stupid errors. Set the bind address to 0.0.0.0 to start (that's wide open: fix later, this is for debugging). 

Geoff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121121/adae06e4/attachment.html>