[mythtv-users] DB restore

Mon Feb 2 22:43:32 UTC 2015

Hoi Daryl,

Monday, February 2, 2015, 11:00:23 PM, you wrote:

> 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

Try user mythtv at 127.0.0.1 or with your machines ip-number, or hostname

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