[mythtv-users] mythfilldatgabase failure

Fri Mar 17 18:38:30 UTC 2023

On Fri, Mar 17, 2023 at 2:25 PM Daryl McDonald <darylangela at gmail.com>
wrote:

>
> On Fri, Mar 17, 2023 at 1:27 PM Hika van den Hoven <hikavdh at gmail.com>
> wrote:
>
>> Hoi Daryl,
>>
>> Friday, March 17, 2023, 6:06:26 PM, you wrote:
>>
>>
>>
>>
>> > On Fri, Mar 17, 2023 at 12:35 PM Daryl McDonald <darylangela at gmail.com>
>> wrote:
>>
>>
>>
>>
>> > On Fri, Mar 17, 2023 at 12:15 PM Mike Perkins
>> > <mikep at randomtraveller.org.uk> wrote:
>>
>> > On 17/03/2023 15:56, Daryl McDonald wrote:
>>  >> On Fri, Mar 17, 2023 at 11:32 AM Bill Meek <keemllib at gmail.com>
>> wrote:
>>  >>
>>  >>>
>>  >>> On Friday 17 March 2023 10:06:05 AM (-05:00), Daryl McDonald wrote:
>>  >>>
>>  >>> ...
>>  >>> snip
>>  >>> ...
>>  >>>
>>  >>>   > >>>
>>  >>>   > >>> and the mythfilldatabase still failed. do I need to continue
>> in the
>>  >>>   > >>> wiki, I assumed the rest would come with the database
>> restore?
>>  >>> Daryl
>>  >>>   > >>>
>>  >>>   > >>>
>>  >>>   > >>> I'd rerun mythfilldatabase -v xmltv and see if there are any
>> clues.
>>  >>>   > >>>
>>  >>>   > >>> The mythconverg DB may be OK (because of lines like: Found 37
>>  >>> channels
>>  >>>   > >>> for source 1 which use grabber),
>>  >>>   > >>> but did you restore the SQLIte DB. The default would
>>  >>>   > >>> be: ~mythtv/.xmltv/SchedulesDirect.DB.
>>  >>>   > >>>
>>  >>>   > >>> --
>>  >>>   > >>> Bill
>>  >>>   > >>> I used "mythconverg_restore.pl" so, no I didn't restore the
>> SQLite
>>  >>> DB.
>>  >>>   > >>> Sorry, I'm not clear on what you mean by the default would
>>  >>>   > >>> be: ~mythtv/.xmltv/SchedulesDirect.DB.
>>  >>>   > >>
>>  >>>   > >>
>>  >>>   > I'm not sure where to go from here:
>>  >>>   >
>>  >>>   > Your Schedules Direct account has the following lineups
>> configured:
>>  >>>   > Lineup ID            Description
>>  >>>   >
>> ======================================================================
>>  >>>   > CAN-OTA-N9A7C3       Local Over the Air Broadcast (Antenna
>> N9A7C3)
>>  >>>   > Specify a Schedules Direct account lineup management action
>>  >>>   > 0: Exit lineup management
>>  >>>   > 1: Add an additional lineup to your account
>>  >>>   > 2: Delete an existing lineup from your account
>>  >>>   > 3: Display your password hash
>>  >>>   > 4: Delete any password hash stored in the database
>>  >>>   > 5: Initialize/update the local database
>>  >>>   > 6: Manage database lineup channel selection
>>  >>>   > Select one: [0,1,2,3,4,5,6 (default=0)] 5
>>  >>>   >
>>  >>>   > Enter your database[/home/mythtv/.xmltv/SchedulesDirect.DB]:
>>  >>>   > Initializing database /home/mythtv/.xmltv/SchedulesDirect.DB
>>  >>>   > Unable to create settings table in database
>>  >>>   > /home/mythtv/.xmltv/SchedulesDirect.DB: attempt to write a
>> readonly
>>  >>> database
>>  >>>   > $
>>  >>>   > And if I try to proceed:
>>  >>>   >
>>  >>>   >  $ tv_grab_zz_sdjson_sqlite --configure --config-file
>>  >>>   > $HOME/.mythtv/antenna.xmltv
>>  >>>   > Failed to write to /home/mythtv/.mythtv/antenna.xmltv.TMP at
>>  >>>   > /usr/local/share/perl/5.34.0/XMLTV/Configure.pm line 187.
>>  >>>   > $
>>  >>>   >
>>  >>>   > I'm open to suggestions.   TIA  Daryl
>>  >>>
>>  >>>
>>  >>> It appears that you're running the above as  user mythtv - that's
>> good.
>>  >>>
>>  >>> But the permissions on the files and/or directories are preventing
>> it from
>>  >>> working.
>>  >>>
>>  >>> I assumed you meant to copy the mythtv user files/directories from
>> the old
>>  >>> host to the new one.
>>  >>>
>>  >> That was my initial attempt, but when mythfilldatabase failed again I
>> went
>>  >> back to the wiki
>>  >>
>>  >>> If mythfilldatabase and the grabber were working there, I don't
>> believe
>>  >>> there's a need to start
>>  >>> configuring it from scratch like the above.
>>  >>>
>>  >>> Check permissions with this:
>>  >>>
>>  >>>       ls -ld ~mythtv/.mythtv/*.xmltv ~mythtv/.xmltv
>>  >>
>>  >>
>>  >>   daryl at trieli:~$  ls -ld ~mythtv/.mythtv/*.xmltv ~mythtv/.xmltv
>>  >> ls: cannot access '/home/mythtv/.mythtv/*.xmltv': No such file or
>> directory
>>  >> drwxrwxr-x 3 gdm lxd 4096 Mar 17 10:24  /home/mythtv/.xmltv
>>  >> but :
>>  >> daryl at trieli:~$ ls -al /home/mythtv
>>  >> total 24
>>  >> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 .
>>  >> drwxr-xr-x 5 root   root   4096 Mar 17 10:48 ..
>>  >> -rw-r--r-- 1 gdm    lxd     143 Mar 17 10:22 antenna.xmltv
>>  >> drwxr-xr-x 8 gdm    lxd    4096 Mar 17 10:25 .mythtv
>>  >> drwx------ 2 gdm    lxd    4096 Mar 17 10:25 .smolt
>>  >> drwxrwxr-x 3 gdm    lxd    4096 Mar 17 10:24 .xmltv
>>  >> And:
>>  >> daryl at trieli:~$ ls -ld /home/mythtv
>>  >> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
>>  >> daryl at trieli:~$
>>  >>
>>  >>>
>>  >>> ~mythtv/.xmltv/SchedulesDirect.DB
>>  >>> Everything should be owner:group mythtv:mythtv.
>>  >>>
>>  >>
>>  >> So it looks like I'm messed up here
>>  >>
>> >  Yup. When you copy it passes the *numeric* value of userid and
>> > groupid. On your new system, this is
>> >  likely different because, when the OS is installed, the system
>> > users may be created in a random order.
>> >
>> >  This is why, when I do something like that, I create the "mythtv"
>> > group and user /before/ I install
>> >  any mythtv components.
>> >
>> >  It's too late for you, but next time:
>> >
>> >  #groupadd -g 1006 mythtv
>> >  #useradd -u 1006 -g 1006 -m -s /bin/bash mythtv
>> >
>> >  I choose 1006 for those values. Yours may differ if you have other
>> users. Syetem users start at 1,
>> >  'proper' users start at 1000, which is usually allocated to the user
>> you had to create when you
>> >  installed the system. -m says create the user's directory under
>> > /home, which means that it should
>> >  not get trashed if you get problems. System users go somewhere
>> > under /var.  -s says use bash as the
>> >  shell.
>> >
>> >  Oh, if you need to, don't forget:
>> >
>> >  #passwd mythtv
>> >
>> >  To fix *your* problem, go to /home and enter, as root (or via sudo):
>> >
>> >  chown -R mythtv:mythtv mythtv
>> >
>> >  --
>> >
>> >  Mike Perkins
>>
>>
>>
>> > When I copied  from the working system they copied with mythtv or
>> > root ownership, so I chown'd them like the working system. I make the
>> changes
>>
>>
>>
>> > Now it errors in a different way:
>>
>>
>> >  $ mythfilldatabase2023-03-17 13:04:45.552310 C  mythfilldatabase
>> > version: fixes/32 [v32.0+fixes.20220325.f69ce764b7-0ubuntu1]
>> www.mythtv.org
>> > 2023-03-17 13:04:45.552320 C  Qt version: compile: 5.15.2, runtime:
>> 5.15.3
>> > 2023-03-17 13:04:45.552352 I  Ubuntu 22.04.2 LTS (x86_64)
>> > 2023-03-17 13:04:45.552354 N  Enabled verbose msgs:  general
>> > 2023-03-17 13:04:45.552361 N  Setting Log Level to LOG_INFO
>> > 2023-03-17 13:04:45.562915 I  Added logging to the console
>> > 2023-03-17 13:04:45.563082 I  Setup Interrupt handler
>> > 2023-03-17 13:04:45.563087 I  Setup Terminated handler
>> > 2023-03-17 13:04:45.563091 I  Setup Segmentation fault handler
>> > 2023-03-17 13:04:45.563094 I  Setup Aborted handler
>> > 2023-03-17 13:04:45.563097 I  Setup Bus error handler
>> > 2023-03-17 13:04:45.563100 I  Setup Floating point exception handler
>> > 2023-03-17 13:04:45.563129 I  Setup Illegal instruction handler
>> > 2023-03-17 13:04:45.563147 I  Setup Real-time signal 0 handler
>> > 2023-03-17 13:04:45.563151 I  Setup Hangup handler
>> > 2023-03-17 13:04:45.563246 N  Using runtime prefix = /usr
>> > 2023-03-17 13:04:45.563248 N  Using configuration directory =
>> /home/mythtv/.mythtv
>> > 2023-03-17 13:04:45.563276 I  Assumed character encoding: en_CA.UTF-8
>> > 2023-03-17 13:04:45.563457 E  Error parsing:
>> > /home/mythtv/.mythtv/config.xml at line: 1  column: 1
>> > 2023-03-17 13:04:45.563459 E  Error Msg: unexpected end of file
>> > 2023-03-17 13:04:45.563493 E  DBHostName is not set in config.xml
>> > 2023-03-17 13:04:45.563501 E  DBHostName is not set in config.xml
>> > 2023-03-17 13:04:45.563513 I  Empty LocalHostName. This is typical.
>> > 2023-03-17 13:04:45.563516 I  Using a profile name of: 'trieli'
>> > (Usually the same as this host's name.)
>> > 2023-03-17 13:04:45.563558 I  Start up testing connections. DB
>> > localhost, BE , attempt 0, status dbAwake, Delay: 2000
>> > 2023-03-17 13:04:46.578019 E  [DBManager0] Unable to connect to
>> database!
>> > 2023-03-17 13:04:46.578051 E  Driver error was [1/1045]:
>> > QMYSQL: Unable to connect
>> > Database error was:
>> > Access denied for user 'mythtv'@'localhost' (using password: YES)
>>
>> > 2023-03-17 13:04:47.578495 I  Start up failure. host localhost, status
>> dbStartedFail
>> > 2023-03-17 13:04:47.578526 I  UPNP Search 2 secs
>> > 2023-03-17 13:04:47.578774 E  Error parsing:
>> > /home/mythtv/.mythtv/config.xml at line: 1  column: 1
>> > 2023-03-17 13:04:47.578779 E  Error Msg: unexpected end of file
>> > 2023-03-17 13:04:47.985447 I  UPNP Search 1 secs
>> > 2023-03-17 13:04:48.330362 I  UPNP Search 1 secs
>> > 2023-03-17 13:04:49.752160 I  Found 1 UPnP backends
>> > 2023-03-17 13:04:50.256477 E  SOAPClient::SendSOAPRequest: request
>> > failed: http://192.168.0.183:6544/Myth
>> > 2023-03-17 13:04:50.256591 E  MythXMLClient::GetConnectionInfo
>> > Failed - (32002) unexpected end of file
>>
>> > Cannot login to database
>>
>> > Would you like to configure the database connection now? [no]
>>
>> /home/mythtv/.mythtv/config.xml is not properly setup. It's a text
>> file so you can open it in a text editor. It should contain info on
>> how to access the database.
>> You can compare it to the one on your old system.
>> Probably the hostname has changed. If you have copied it from the old
>> system change it here to the new hostname and also if they are not the
>> same as on the old system change the username and password to those
>> you have set for the new database.
>>
>>
>> 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
>>
>
>  OK, where do I find the new system password?  "/etc/mythtv/config.xml was
> an empty file on the new system so I cp'd from the old and now:
> 2023-03-17 14:20:49.656660 I  Start up testing connections. DB localhost,
> BE , attempt 10, status dbStarted, Delay: 2000
> 2023-03-17 14:20:49.657860 E  [DBManager10] Unable to connect to database!
> 2023-03-17 14:20:49.657875 E  Driver error was [1/1045]:
> QMYSQL: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'localhost' (using password: YES)
> This repeats five times at the end of the run
>
>> _______________________________________________
>>
>
I found the new password , edited the config.xml file, now FE connects to
BE but mythfilldatabase still fails:

2023-03-17 14:34:52.387726 E  XMLTV grabber returned error code 1
2023-03-17 14:34:52.887191 E  Malformed XML file, missing </tv> element, at
line 1, Premature end of document.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230317/6465069b/attachment.htm>