[mythtv-users] DB restore

Mon Feb 2 22:00:23 UTC 2015

On Mon, Feb 2, 2015 at 4:51 PM, Hika van den Hoven <hikavdh at gmail.com>
wrote:

> Hoi Daryl,
>
> Monday, February 2, 2015, 10:36:47 PM, you wrote:
>
> > On Mon, Feb 2, 2015 at 4:32 PM, Phil Bridges <gravityhammer at gmail.com>
> > wrote:
>
> >> Try:
> >>
> >> sudo mysql -u mythtv -p mythconverg   (assuming your database has a
> >> "mythtv" user")
> >>
> >> On Mon, Feb 2, 2015 at 4:25 PM, Daryl McDonald <darylangela at gmail.com>
> >> wrote:
> >>
> >>>
> >>>
> >>> On Mon, Feb 2, 2015 at 3:59 PM, Daryl McDonald <darylangela at gmail.com>
> >>> wrote:
> >>>
> >>>> On Feb 2, 2015 2:45 PM, "Michael T. Dean" <mtdean at thirdcontact.com>
> >>>> wrote:
> >>>> >
> >>>> > On 02/02/2015 11:41 AM, Daryl McDonald wrote:
> >>>> >
> >>>> >> On Mon, Feb 2, 2015 at 9:30 AM, Michael T. Dean wrote:
> >>>> >>
> >>>> >>> On 02/02/2015 09:22 AM, Daryl McDonald wrote:
> >>>> >>>
> >>>> >>>> Greetings Mythizens, I woke up this morning to that Green Terra
> >>>> setup
> >>>> >>>> screen, evidently I need to restore my database.
> >>>> >>>>
> >>>> >>> Are you sure?  There should never be a case where you wake up to
> >>>> find your
> >>>> >>> database gone.  Why do you think you need to restore the database?
> >>>> >>
> >>>> >>
> >>>> >> I use Steppes, and when I woke the box was still on, so I opened
> Myth
> >>>> FE to
> >>>> >> see what it was recording, and was shocked to find the Terra theme
> >>>> "select
> >>>> >> country and Language screen" as I navigated through screens in a
> >>>> panic I
> >>>> >> saw one offering to update my database as it was 5000 versions
> >>>> outdated,
> >>>> >> hence my assumption. Is there any info I can post or paste to help
> >>>> diagnose
> >>>> >> what is going on here?
> >>>> >
> >>>> >
> >>>> > This will happen if MythTV can't find your database.  It won't find
> >>>> your database if there's a problem with your config.xml or, for
> example, if
> >>>> you change around host names and/or IP addresses.  You haven't
> described
> >>>> your configuration at all (number of hosts, host names, which are
> dedicated
> >>>> backends or frontends and which are combined backend/frontend systems,
> >>>> location of mythconverg database, ...), so there are many reasons this
> >>>> could occur, but from the logs you posted, I see:
> >>>> >
> >>>> > Feb  2 11:23:17 daryl-A780L3C mythbackend: mythbackend[2483]: N
> >>>> thread_unknown mythdirs.cpp:68 (InitializeMythDirs) Using
> configuration
> >>>> directory = /home/mythtv/.mythtv
> >>>> > ...
> >>>> > Feb  2 11:23:17 daryl-A780L3C mythbackend: mythbackend[2483]: N
> >>>> CoreContext mythcontext.cpp:504 (LoadDatabaseSettings) Empty
> LocalHostName.
> >>>> > Feb  2 11:23:17 daryl-A780L3C mythbackend: mythbackend[2483]: I
> >>>> CoreContext mythcontext.cpp:512 (LoadDatabaseSettings) Using localhost
> >>>> value of daryl-A780L3C
> >>>> >
> >>>> > and then a bunch of messages that show that mythbackend is
> connecting
> >>>> to an empty database on the local host.  Is the host name
> "daryl-A780L3C"
> >>>> really the one you want to use and the one you have been using for
> MythTV?
> >>>> Are you sure your ~mythtv/.mythtv/config.xml specifies the proper
> location
> >>>> and connection information for your MySQL database?
> >>>> >
> >>>> > Mike
> >>>> >
> >>>> > _______________________________________________
> >>>> > mythtv-users mailing list
> >>>> > mythtv-users at mythtv.org
> >>>> > http://lists.mythtv.org/mailman/listinfo/mythtv-users
> >>>> > http://wiki.mythtv.org/Mailing_List_etiquette
> >>>> > MythTV Forums: https://forum.mythtv.org
> >>>>
> >>>> I use a combined fe be only, yes "daryl-A780L3C" is the host name I
> have
> >>>> been using, I thought about using a different one a while back but
> staying
> >>>> with this one was simpler. I just checked the myth box,which is a
> Ubuntu
> >>>> desktop also and the chromium browser I had left open with gmail had
> closed
> >>>> and I was unable to relaunch it, just a few pulses then nothing. I' m
> going
> >>>> to look into the config files now.
> >>>>
> >>>
> >>> Thanks Eric, but I'm still confused:
> >>>
> >>> daryl at daryl-A780L3C:~$ mysql -u user mythconverg
> >>> ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using
> >>> password: NO)
> >>> daryl at daryl-A780L3C:~$ sudo mysql -u user mythconverg
> >>> [sudo] password for daryl:
> >>> ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using
> >>> password: NO)
> >>> daryl at daryl-A780L3C:~$ sudo mysql mythconverg
> >>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> >>> password: NO)
> >>> daryl at daryl-A780L3C:~$
> >>>
> >>>
> >>> _______________________________________________
> >>> mythtv-users mailing list
> >>> mythtv-users at mythtv.org
> >>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> >>> http://wiki.mythtv.org/Mailing_List_etiquette
> >>> MythTV Forums: https://forum.mythtv.org
> >>>
> >>>
> >>
> >> _______________________________________________
> >> mythtv-users mailing list
> >> mythtv-users at mythtv.org
> >> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> >> http://wiki.mythtv.org/Mailing_List_etiquette
> >> MythTV Forums: https://forum.mythtv.org
> >>
> >> Thanks Phill, this looks familiar, as to how I've accessed this before,
> > but not this time:
>
> >   daryl at daryl-A780L3C:~$ sudo mysql -u mythtv -p mythconverg
> > Enter password:
> > ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
> > password: YES)
> > daryl at daryl-A780L3C:~$
>
> Just type your database password between -p and mythconverg!
>
> Tot mails,
>   Hika                            mailto:hikavdh at gmail.com
>
> "Zonder hoop kun je niet leven
> Zonder leven is er geen hoop
> Het eeuwige dilemma
> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>
> De lerende Mens
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>

Same error with the password in the command:
 ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
password: YES)
daryl at daryl-A780L3C:~$

something is really messed up here I can't even get to the setup screen,
beyond the language/country screen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150202/4a574346/attachment.html>