[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: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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170928/00537b9f/attachment.html>