[mythtv-users] Proper way/user to run mythconverg_restore.pl when restoring old database on clean install

[Ian Evans]

On Thu, Sep 28, 2017 at 5:44 PM, Hika van den Hoven <hikavdh at gmail.com>
wrote:

> Hoi Ian,
>
> Thursday, September 28, 2017, 11:14:36 PM, you wrote:
>
> > On Thu, Sep 28, 2017 at 5:04 PM, Hika van den Hoven <hikavdh at gmail.com
> >wrote:
>
> > Hoi Mark,
> >
>
> >  Thursday, September 28, 2017, 10:54:55 PM, you wrote:
> >
>  >>
>  >>
>  >>
>  >> On 29 September 2017 5:03:03 am Ian Evans <dheianevans at gmail.com>
> wrote:
>  >>
>  >>> Doing the clean install method after upgrading my system to 16.04.
>   >>>
>   >>> I ran the following command line to install the old database:
>   >>>
>   >>> sudo -u mythtv /usr/share/mythtv/mythconverg_restore.pl --verbose
>   >>> --drop_database --create_database  --directory /home/mythtv
> --filename
>   >>> mythconverg-1317-20170928112702.sql.gz
>   >>>
>   >>> It fails with an unable to connect to database and this environment:
>   >>>
>   >>> Configuring environment:
>   >>>   -    username: mythtv
>   >>>   -        HOME: /home/ian
>   >>>   - MYTHCONFDIR: /home/ian/.mythtv
>   >>>
>   >>> Parsing configuration files:
>   >>>   - checking: /home/ian/.mythtv/config.xml
>   >>>   - checking: /usr/local/share/mythtv/mysql.txt
>   >>>   - checking: /usr/share/mythtv/mysql.txt
>   >>>   - checking: /usr/local/etc/mythtv/mysql.txt
>   >>>   - checking: /etc/mythtv/mysql.txt
>   >>>   - checking: /home/ian/.mythtv/mysql.txt
>   >>>   - checking: mysql.txt
>   >>>   - checking: /home/ian/.mythtv/mysql.txt
>   >>>   - checking: /home/ian/.mythtv/backuprc
>   >>>
>   >>> Doing a 'locate config.xml' it's only at these locations:
>   >>>
>   >>> /etc/mythtv/config.xml
>   >>> /home/mythtv/.mythtv/config.xml
>   >>> /usr/share/doc/mythtv-backend/contrib/config_files/config.xml
>   >>> /usr/share/mythtv/config.xml
>   >>>
>   >>> How do I get the command line to ignore /home/ian and
> /home/ian/.mythtv?
>   >>>
>   >>> Thanks!
>   >>>
>   >>>
>   >>>
>  >>
>  >>
>  >> Set MYTHCONFDIR before you run your command line to the config file
> you want.
>  >>
>  >> export MYTHCONFDIR=xxxxxxxxxx
>  >>  echo $MYTHCONFDIR
>  >>
> >
> >  Yes, that should work, if the ian user has r/w access there, which
> >  shouldn't as it is inside the mythtv home-directory.
> >
>
>
>
>
>
> > Went to run mythtv-setup from a terminal on the local system (that
> > is not using ssh) and after sudo -i -u mythtv. Have various X
> > errors. Clicked on Mythbackend Setup in the Xubuntu applications
> > menu and it offered to add the root user to the mythtv group and then
> ran.
>
> You changed user in a terminal, but X is initialized as the original
> user, so when trying to run an X program you probably end up in a kind
> of mixed environment of the two users. I guess the mythtv group had
> the missing rights in the other environment.
> When you want to run an X program as a different user you better
> log-out and then log-in as the needed user. Or start a second X
> session as the other user. If your window manager does support that.
>
> Thanks for your help. Database update happened, but now I'm debugging why
mythbackend is crashing just after login, why mythfrontend isn't starting
automatically, etc.

My first clean install with with a Mythbuntu ISO back in 2011 with in-place
upgrades. Went so smoothly and I was recording shows within about 30
minutes. This installing Xubuntu, then myth has not been as smooth. :-(

Guess I'll be posting more shortly.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170928/89cd0496/attachment.html>