[mythtv-users] No MythTV backend after update of Linux Mint Debian Edition

[Thomas Mashos]

On Sat, Jul 13, 2013 at 3:46 AM, Enno Middelberg
<enno.middelberg at gmail.com>wrote:

> Hello, and apologies for the delayed reply.
>
> Both /etc/mythtv/config.xml and /home/enno/.mythtv/config.xml have the
> same user/password combination, which is mythtv/mythtv.
>
>
> The data base still exists at /var/lib/mysql - it must be possible to
> tell the backend where it is!
>
>
> Cheers,
>
> Enno
>
>
>
> 2013/7/12 Thomas Mashos <thomas at mashos.com>:
> > On Thu, Jul 11, 2013 at 3:00 PM, Mike Perkins <
> mikep at randomtraveller.org.uk>
> > wrote:
> >>
> >> On 11/07/13 18:48, Thomas Mashos wrote:
> >>>
> >>> On Thu, Jul 11, 2013 at 10:42 AM, Enno Middelberg
> >>> <enno.middelberg at gmail.com
> >>>>
> >>>> wrote:
> >>>
> >>>
> >>>> Hello,
> >>>>
> >>>>
> >>>> 2013/7/10 Jon Heizer <jheizer at gmail.com>:
> >>>>>>>
> >>>>>>> $ mysql -u root mythconverg
> >>>>>>> mysql> grant all on mythconverg.* to mythtv@"%" identified by
> >>>>
> >>>> "mythtv";
> >>>>>>>
> >>>>>>> mysql> flush privileges;
> >>>>>>
> >>>>>>
> >>>>>> I tried this, but didn't go anywhere:
> >>>>
> >>>>
> >>>> Ok, so I have tried this now:
> >>>>
> >>>> mysql -u root -p mythconverg
> >>>> Enter password:
> >>>> Reading table information for completion of table and column names
> >>>> You can turn off this feature to get a quicker startup with -A
> >>>>
> >>>> Welcome to the MySQL monitor.  Commands end with ; or \g.
> >>>> Your MySQL connection id is 121
> >>>> Server version: 5.5.28-1 (Debian)
> >>>>
> >>>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights
> >>>> reserved.
> >>>>
> >>>> Oracle is a registered trademark of Oracle Corporation and/or its
> >>>> affiliates. Other names may be trademarks of their respective
> >>>> owners.
> >>>>
> >>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> >>>> statement.
> >>>>
> >>>> mysql> grant all on mythconverg.* to mythtv@"%" identified by
> "mythtv";
> >>>> Query OK, 0 rows affected (0.00 sec)
> >>>>
> >>>> mysql> flush privileges;
> >>>> Query OK, 0 rows affected (0.00 sec)
> >>>>
> >>>> mysql> quit
> >>>>
> >>>>
> >>>> sudo /etc/init.d/mysql restart
> >>>> [sudo] password for enno:
> >>>> [ ok ] Stopping MySQL database server: mysqld.
> >>>> [ ok ] Starting MySQL database server: mysqld ..
> >>>> [info] Checking for tables which need an upgrade, are corrupt or were
> >>>> not closed cleanly..
> >>>>
> >>>> sudo /etc/init.d/mythtv-backend restart
> >>>> Restarting MythTV server: mythbackend No /usr/bin/mythbackend found
> >>>> running; none killed.
> >>>> .
> >>>> .
> >>>>
> >>>> Cannot login to database
> >>>>
> >>>> Would you like to configure the database connection now? [no]
> >>>> [console is not interactive, using default 'no']
> >>>>
> >>>>
> >>>>
> >>>> So this looks pretty much like what I had started with. What can I do
> >>>> to get this going?
> >>>>
> >>>
> >>>
> >>> Might want to set the password for the mythtv user in the database,
> then
> >>> fix it in config.xml
> >>>
> >> That's what the "grant all" operation does. It sets the password for the
> >> mythtv user to "mythtv".
> >>
> >> Now I recall that ubuntu, like debian, likes to think up some new
> password
> >> combination when you install mythtv. Perhaps that's what happened here.
> >>
> >> --
> >>
> >> Mike Perkins
> >>
> >> _______________________________________________
> >> mythtv-users mailing list
> >> mythtv-users at mythtv.org
> >> http://www.mythtv.org/mailman/listinfo/mythtv-users
> >
> >
> > You're right, I didn't look up the password change syntax as I thought I
> > remembered it correctly. Whoops.
> >
> > The password is only set on install for the mythtv user, shouldn't be
> reset.
> > And even then, he manually reset the password on it (which IMO is the
> wrong
> > way to do it on ubuntu/debian). Perhaps he should check
> > /home/mythtv/.mythtv/config.xml and see if the right password exists
> there.
> >
> > Thanks,
> >
> > Thomas Mashos
> >
> >
> >
> > _______________________________________________
> > 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
>


That was not a typo. I'd assume that the user that runs the backend is the
'mythtv' user.  Please check the settings for the mythtv user, which is at
/home/mythtv/.mythtv/config.xml

If those credentials are the same. Are you able to login to mysql at the
command line using those credentials with something like

mysql -u mythtv -p mythconverg

Thanks,

Thomas Mashos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130713/d28b3756/attachment.html>