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

[Hika van den Hoven]

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.

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