Mailing List Archive

mythfilldatgabase failure
Does this make any sense to anyone?:
2023-03-15 18:33:00.556565 E tv_grab_zz_sdjson_sqlite --capabilities
failed or we timed out waiting. You may need to upgrade your xmltv grabber
2023-03-15 18:33:00.556591 E Grabbing XMLTV data using tv_2023-03-15
18:33:00.556565 E tv_grab_zz_sdjson_sqlite --capabilities failed or we
timed out waiting. You may need to upgrade your xmltv grabber
2023-03-15 18:33:00.556591 E Grabbing XMLTV data using
tv_grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
latest version of XMLTV.
2023-03-15 18:33:00.769496 I Updating source #8 (intenna) with grabber
tv_grab_zz_sdjson_sqlite
2023-03-15 18:33:00.770462 I Found 36 channels for source 8 which use
grabber
2023-03-15 18:33:00.807395 E tv_grab_zz_sdjson_sqlite --capabilities
failed or we timed out waiting. You may need to upgrade your xmltv grabber
2023-03-15 18:33:00.807459 E Grabbing XMLTV data using
tv_grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
latest version of XMLTV.
grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
latest version of XMLTV.

I've just installed mythtv on a clean install of Ubuntu 22.04, restored the
database, and carried forward some needed files. ACPI shutdown is working,
this seems to be the final piece of the puzzle. TIA Daryl
Re: mythfilldatgabase failure [ In reply to ]
On Wednesday 15 March 2023 05:40:41 PM (-05:00), Daryl McDonald wrote:


Does this make any sense to anyone?:
2023-03-15 18:33:00.556565 E tv_grab_zz_sdjson_sqlite --capabilities
failed or we timed out waiting. You may need to upgrade your xmltv grabber
2023-03-15 18:33:00.556591 E Grabbing XMLTV data using tv_2023-03-15
18:33:00.556565 E tv_grab_zz_sdjson_sqlite --capabilities failed or we
timed out waiting. You may need to upgrade your xmltv grabber
2023-03-15 18:33:00.556591 E Grabbing XMLTV data using
tv_grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
latest version of XMLTV.
2023-03-15 18:33:00.769496 I Updating source #8 (intenna) with grabber
tv_grab_zz_sdjson_sqlite
2023-03-15 18:33:00.770462 I Found 36 channels for source 8 which use
grabber
2023-03-15 18:33:00.807395 E tv_grab_zz_sdjson_sqlite --capabilities
failed or we timed out waiting. You may need to upgrade your xmltv grabber
2023-03-15 18:33:00.807459 E Grabbing XMLTV data using
tv_grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
latest version of XMLTV.

grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
latest version of XMLTV.


I've just installed mythtv on a clean install of Ubuntu 22.04, restored the
database, and carried forward some needed files. ACPI shutdown is working,
this seems to be the final piece of the puzzle. TIA Daryl


Is the tv_grab_sdjson_sqlite grabber installed?


If I run the above from the command line I get:


$ tv_grab_zz_sdjson_sqlite --capabilities
baseline
manualconfig
preferredmethod
lineups
apiconfig


--
Bill
Re: mythfilldatgabase failure [ In reply to ]
Looks like the issue:
daryl@trieli:~$ tv_grab_zz_sdjson_sqlite --capabilities
Command 'tv_grab_zz_sdjson_sqlite' not found, but can be installed with:
sudo apt install xmltv-util
daryl@trieli:~$ sudo apt install -y xmltv-util

but after installing the xmltv-util we're still not quite there:

daryl@trieli:~$ sudo su mythtv
$ mythfilldatabase
2023-03-16 07:19:48.143231 C mythfilldatabase version: fixes/32
[v32.0+fixes.20220325.f69ce764b7-0ubuntu1] www.mythtv.org
2023-03-16 07:19:48.143241 C Qt version: compile: 5.15.2, runtime: 5.15.3
2023-03-16 07:19:48.143273 I Ubuntu 22.04.2 LTS (x86_64)
2023-03-16 07:19:48.143275 N Enabled verbose msgs: general
2023-03-16 07:19:48.143282 N Setting Log Level to LOG_INFO
2023-03-16 07:19:48.153821 I Added logging to the console
2023-03-16 07:19:48.153973 I Setup Interrupt handler
2023-03-16 07:19:48.153982 I Setup Terminated handler
2023-03-16 07:19:48.153986 I Setup Segmentation fault handler
2023-03-16 07:19:48.153989 I Setup Aborted handler
2023-03-16 07:19:48.153991 I Setup Bus error handler
2023-03-16 07:19:48.153995 I Setup Floating point exception handler
2023-03-16 07:19:48.153998 I Setup Illegal instruction handler
2023-03-16 07:19:48.154016 I Setup Real-time signal 0 handler
2023-03-16 07:19:48.154019 I Setup Hangup handler
2023-03-16 07:19:48.154104 N Using runtime prefix = /usr
2023-03-16 07:19:48.154106 N Using configuration directory =
/home/mythtv/.mythtv
2023-03-16 07:19:48.154132 I Assumed character encoding: en_CA.UTF-8
2023-03-16 07:19:48.154381 I Empty LocalHostName. This is typical.
2023-03-16 07:19:48.154384 I Using a profile name of: 'trieli' (Usually
the same as this host's name.)
2023-03-16 07:19:48.154415 I Start up testing connections. DB localhost,
BE , attempt 0, status dbAwake, Delay: 2000
2023-03-16 07:19:49.192982 N Setting QT default locale to en_CA
2023-03-16 07:19:49.192999 I Current locale en_CA
2023-03-16 07:19:49.193080 N Reading locale defaults from
/usr/share/mythtv//locales/en_ca.xml
2023-03-16 07:19:49.245071 I PowerDBus: Added UPower.Device
'/org/freedesktop/UPower/devices/keyboard_hidpp_battery_0'
2023-03-16 07:19:49.245705 I Power: On AC power
2023-03-16 07:19:49.248229 I PowerDBus: Added UPower.Device
'/org/freedesktop/UPower/devices/mouse_hidpp_battery_1'
2023-03-16 07:19:49.293742 I Power: Supported actions:
Suspend,Restart,Shutdown
2023-03-16 07:19:49.295612 I Loading en_ca translation for module
mythfrontend
2023-03-16 07:19:49.298571 I Current MythTV Schema Version (DBSchemaVer):
1376
2023-03-16 07:19:49.304452 I MythCoreContext::ConnectCommandSocket():
Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2023-03-16 07:19:49.310106 I MythCoreContext::CheckProtoVersion(): Using
protocol version 91 BuzzOff
2023-03-16 07:19:49.310593 I Opening blocking connection to master backend
2023-03-16 07:19:49.611505 I Updating source #1 (antenna) with grabber
tv_grab_zz_sdjson_sqlite
2023-03-16 07:19:49.612353 I Found 37 channels for source 1 which use
grabber
2023-03-16 07:19:49.613030 I Starting process manager
2023-03-16 07:19:49.613228 I Starting IO manager (read)
2023-03-16 07:19:49.613255 I Starting process signal handler
2023-03-16 07:19:49.618288 I Starting IO manager (write)
2023-03-16 07:19:50.415621 I Grabber has capabilities: baseline
manualconfig preferredmethod lineups apiconfig
2023-03-16 07:19:51.267150 I Grabber prefers method: allatonce
2023-03-16 07:19:51.268351 I XMLTV config file is:
/home/mythtv/.mythtv/antenna.xmltv
2023-03-16 07:19:52.120150 E XMLTV grabber returned error code 1
2023-03-16 07:19:52.770885 E Malformed XML file, missing </tv> element, at
line 1, Premature end of document.
2023-03-16 07:19:53.034614 I Updating source #8 (intenna) with grabber
tv_grab_zz_sdjson_sqlite
2023-03-16 07:19:53.035398 I Found 36 channels for source 8 which use
grabber
2023-03-16 07:19:53.872718 I Grabber has capabilities: baseline
manualconfig preferredmethod lineups apiconfig
2023-03-16 07:19:54.674329 I Grabber prefers method: allatonce
2023-03-16 07:19:54.675297 I XMLTV config file is:
/home/mythtv/.mythtv/intenna.xmltv
2023-03-16 07:19:55.478235 E XMLTV grabber returned error code 1
2023-03-16 07:19:55.977897 E Malformed XML file, missing </tv> element, at
line 1, Premature end of document.
2023-03-16 07:19:56.079645 E Failed to fetch some program info
2023-03-16 07:19:56.079702 I Adjusting program database end times.
2023-03-16 07:19:56.080286 I 0 replacements made
2023-03-16 07:19:56.080289 I Marking generic episodes.
2023-03-16 07:19:56.359440 I Found 0
2023-03-16 07:19:56.359447 I Extending non-unique programids with multiple
parts.
2023-03-16 07:19:56.518298 I Found 0
2023-03-16 07:19:56.518304 I Fixing missing original airdates.
2023-03-16 07:19:57.027359 I Found 0 with programids
2023-03-16 07:19:57.028199 I Found 0 without programids
2023-03-16 07:19:57.028203 I Marking repeats.
2023-03-16 07:19:57.056135 I Found 0
2023-03-16 07:19:57.056142 I Unmarking new episode rebroadcast repeats.
2023-03-16 07:19:57.233117 I Found 0
2023-03-16 07:19:58.067377 I Marking episode first showings.
2023-03-16 07:19:59.402563 I Found 43413
2023-03-16 07:19:59.402570 I Marking episode last showings.
2023-03-16 07:20:00.743345 I Found 43331
2023-03-16 07:20:00.755586 I
===============================================================
| Attempting to contact the master backend for rescheduling. |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted. |
===============================================================
2023-03-16 07:20:00.756650 N mythfilldatabase run complete.
2023-03-16 07:20:00.756726 I PowerDBus: Closing interfaces
2023-03-16 07:20:00.758004 I Waiting for threads to exit.
2023-03-16 07:20:00.758029 I Exiting
$

so I did the following from the wiki:
sudo apt update
sudo apt install git make xmltv perl-doc
# Note: xmltv gets the required perl modules

mkdir -p build
cd build
git clone https://github.com/XMLTV/xmltv.git
cd xmltv
perl Makefile.PL
make
make test
sudo make install

and the mythfilldatabase still failed. do I need to continue in the wiki, I
assumed the rest would come with the database restore? Daryl

On Thu, Mar 16, 2023 at 12:16?AM Bill Meek <keemllib@gmail.com> wrote:

> On Wednesday 15 March 2023 05:40:41 PM (-05:00), Daryl McDonald wrote:
>
> Does this make any sense to anyone?:
> 2023-03-15 18:33:00.556565 E tv_grab_zz_sdjson_sqlite --capabilities
> failed or we timed out waiting. You may need to upgrade your xmltv grabber
> 2023-03-15 18:33:00.556591 E Grabbing XMLTV data using tv_2023-03-15
> 18:33:00.556565 E tv_grab_zz_sdjson_sqlite --capabilities failed or we
> timed out waiting. You may need to upgrade your xmltv grabber
> 2023-03-15 18:33:00.556591 E Grabbing XMLTV data using
> tv_grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
> latest version of XMLTV.
> 2023-03-15 18:33:00.769496 I Updating source #8 (intenna) with grabber
> tv_grab_zz_sdjson_sqlite
> 2023-03-15 18:33:00.770462 I Found 36 channels for source 8 which use
> grabber
> 2023-03-15 18:33:00.807395 E tv_grab_zz_sdjson_sqlite --capabilities
> failed or we timed out waiting. You may need to upgrade your xmltv grabber
> 2023-03-15 18:33:00.807459 E Grabbing XMLTV data using
> tv_grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
> latest version of XMLTV.
> grab_zz_sdjson_sqlite is not supported. You may need to upgrade to the
> latest version of XMLTV.
>
> I've just installed mythtv on a clean install of Ubuntu 22.04, restored
> the database, and carried forward some needed files. ACPI shutdown is
> working, this seems to be the final piece of the puzzle. TIA Daryl
>
>
> Is the tv_grab_sdjson_sqlite grabber installed?
>
> If I run the above from the command line I get:
>
> $ tv_grab_zz_sdjson_sqlite --capabilities
> baseline
> manualconfig
> preferredmethod
> lineups
> apiconfig
>
> --
> Bill
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
Re: mythfilldatgabase failure [ In reply to ]
> Malformed XML file, missing </tv> element, at line 1, Premature end of
> document.
>

I think that means that tv_grab_zz_sdjson_sqlite failed to fetch any data.

have you run tv_grab_zz_sdjson_sqlite -configure ?
Re: mythfilldatgabase failure [ In reply to ]
On Thursday 16 March 2023 06:36:37 AM (-05:00), Daryl McDonald wrote:


Looks like the issue:
daryl@trieli:~$ tv_grab_zz_sdjson_sqlite --capabilities
Command 'tv_grab_zz_sdjson_sqlite' not found, but can be installed with:
sudo apt install xmltv-util
daryl@trieli:~$ sudo apt install -y xmltv-util


but after installing the xmltv-util we're still not quite there:



daryl@trieli:~$ sudo su mythtv
$ mythfilldatabase
2023-03-16 07:19:48.143231 C mythfilldatabase version: fixes/32
[v32.0+fixes.20220325.f69ce764b7-0ubuntu1] www.mythtv.org
2023-03-16 07:19:48.143241 C Qt version: compile: 5.15.2, runtime: 5.15.3
2023-03-16 07:19:48.143273 I Ubuntu 22.04.2 LTS (x86_64)
2023-03-16 07:19:48.143275 N Enabled verbose msgs: general
2023-03-16 07:19:48.143282 N Setting Log Level to LOG_INFO
2023-03-16 07:19:48.153821 I Added logging to the console
2023-03-16 07:19:48.153973 I Setup Interrupt handler
2023-03-16 07:19:48.153982 I Setup Terminated handler
2023-03-16 07:19:48.153986 I Setup Segmentation fault handler
2023-03-16 07:19:48.153989 I Setup Aborted handler
2023-03-16 07:19:48.153991 I Setup Bus error handler
2023-03-16 07:19:48.153995 I Setup Floating point exception handler
2023-03-16 07:19:48.153998 I Setup Illegal instruction handler
2023-03-16 07:19:48.154016 I Setup Real-time signal 0 handler
2023-03-16 07:19:48.154019 I Setup Hangup handler
2023-03-16 07:19:48.154104 N Using runtime prefix = /usr
2023-03-16 07:19:48.154106 N Using configuration directory =
/home/mythtv/.mythtv
2023-03-16 07:19:48.154132 I Assumed character encoding: en_CA.UTF-8
2023-03-16 07:19:48.154381 I Empty LocalHostName. This is typical.
2023-03-16 07:19:48.154384 I Using a profile name of: 'trieli' (Usually
the same as this host's name.)
2023-03-16 07:19:48.154415 I Start up testing connections. DB localhost,
BE , attempt 0, status dbAwake, Delay: 2000
2023-03-16 07:19:49.192982 N Setting QT default locale to en_CA
2023-03-16 07:19:49.192999 I Current locale en_CA
2023-03-16 07:19:49.193080 N Reading locale defaults from
/usr/share/mythtv//locales/en_ca.xml
2023-03-16 07:19:49.245071 I PowerDBus: Added UPower.Device
'/org/freedesktop/UPower/devices/keyboard_hidpp_battery_0'
2023-03-16 07:19:49.245705 I Power: On AC power
2023-03-16 07:19:49.248229 I PowerDBus: Added UPower.Device
'/org/freedesktop/UPower/devices/mouse_hidpp_battery_1'
2023-03-16 07:19:49.293742 I Power: Supported actions:
Suspend,Restart,Shutdown
2023-03-16 07:19:49.295612 I Loading en_ca translation for module
mythfrontend
2023-03-16 07:19:49.298571 I Current MythTV Schema Version (DBSchemaVer):
1376
2023-03-16 07:19:49.304452 I MythCoreContext::ConnectCommandSocket():
Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2023-03-16 07:19:49.310106 I MythCoreContext::CheckProtoVersion(): Using
protocol version 91 BuzzOff
2023-03-16 07:19:49.310593 I Opening blocking connection to master backend
2023-03-16 07:19:49.611505 I Updating source #1 (antenna) with grabber
tv_grab_zz_sdjson_sqlite
2023-03-16 07:19:49.612353 I Found 37 channels for source 1 which use
grabber
2023-03-16 07:19:49.613030 I Starting process manager
2023-03-16 07:19:49.613228 I Starting IO manager (read)
2023-03-16 07:19:49.613255 I Starting process signal handler
2023-03-16 07:19:49.618288 I Starting IO manager (write)
2023-03-16 07:19:50.415621 I Grabber has capabilities: baseline
manualconfig preferredmethod lineups apiconfig
2023-03-16 07:19:51.267150 I Grabber prefers method: allatonce
2023-03-16 07:19:51.268351 I XMLTV config file is:
/home/mythtv/.mythtv/antenna.xmltv
2023-03-16 07:19:52.120150 E XMLTV grabber returned error code 1
2023-03-16 07:19:52.770885 E Malformed XML file, missing </tv> element, at
line 1, Premature end of document.
2023-03-16 07:19:53.034614 I Updating source #8 (intenna) with grabber
tv_grab_zz_sdjson_sqlite
2023-03-16 07:19:53.035398 I Found 36 channels for source 8 which use
grabber
2023-03-16 07:19:53.872718 I Grabber has capabilities: baseline
manualconfig preferredmethod lineups apiconfig
2023-03-16 07:19:54.674329 I Grabber prefers method: allatonce
2023-03-16 07:19:54.675297 I XMLTV config file is:
/home/mythtv/.mythtv/intenna.xmltv
2023-03-16 07:19:55.478235 E XMLTV grabber returned error code 1
2023-03-16 07:19:55.977897 E Malformed XML file, missing </tv> element, at
line 1, Premature end of document.
2023-03-16 07:19:56.079645 E Failed to fetch some program info
2023-03-16 07:19:56.079702 I Adjusting program database end times.
2023-03-16 07:19:56.080286 I 0 replacements made
2023-03-16 07:19:56.080289 I Marking generic episodes.
2023-03-16 07:19:56.359440 I Found 0
2023-03-16 07:19:56.359447 I Extending non-unique programids with multiple
parts.
2023-03-16 07:19:56.518298 I Found 0
2023-03-16 07:19:56.518304 I Fixing missing original airdates.
2023-03-16 07:19:57.027359 I Found 0 with programids
2023-03-16 07:19:57.028199 I Found 0 without programids
2023-03-16 07:19:57.028203 I Marking repeats.
2023-03-16 07:19:57.056135 I Found 0
2023-03-16 07:19:57.056142 I Unmarking new episode rebroadcast repeats.
2023-03-16 07:19:57.233117 I Found 0
2023-03-16 07:19:58.067377 I Marking episode first showings.
2023-03-16 07:19:59.402563 I Found 43413
2023-03-16 07:19:59.402570 I Marking episode last showings.
2023-03-16 07:20:00.743345 I Found 43331
2023-03-16 07:20:00.755586 I
===============================================================
| Attempting to contact the master backend for rescheduling. |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted. |
===============================================================
2023-03-16 07:20:00.756650 N mythfilldatabase run complete.
2023-03-16 07:20:00.756726 I PowerDBus: Closing interfaces
2023-03-16 07:20:00.758004 I Waiting for threads to exit.
2023-03-16 07:20:00.758029 I Exiting
$



so I did the following from the wiki:
sudo apt update
sudo apt install git make xmltv perl-doc
# Note: xmltv gets the required perl modules

mkdir -p build
cd build
git clone https://github.com/XMLTV/xmltv.git
cd xmltv
perl Makefile.PL
make
make test
sudo make install



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
Re: mythfilldatgabase failure [ In reply to ]
On Thu, Mar 16, 2023 at 10:50?AM Bill Meek <keemllib@gmail.com> wrote:

> On Thursday 16 March 2023 06:36:37 AM (-05:00), Daryl McDonald wrote:
>
> Looks like the issue:
> daryl@trieli:~$ tv_grab_zz_sdjson_sqlite --capabilities
> Command 'tv_grab_zz_sdjson_sqlite' not found, but can be installed with:
> sudo apt install xmltv-util
> daryl@trieli:~$ sudo apt install -y xmltv-util
>
> but after installing the xmltv-util we're still not quite there:
>
> daryl@trieli:~$ sudo su mythtv
> $ mythfilldatabase
> 2023-03-16 07:19:48.143231 C mythfilldatabase version: fixes/32
> [v32.0+fixes.20220325.f69ce764b7-0ubuntu1] www.mythtv.org
> 2023-03-16 07:19:48.143241 C Qt version: compile: 5.15.2, runtime: 5.15.3
> 2023-03-16 07:19:48.143273 I Ubuntu 22.04.2 LTS (x86_64)
> 2023-03-16 07:19:48.143275 N Enabled verbose msgs: general
> 2023-03-16 07:19:48.143282 N Setting Log Level to LOG_INFO
> 2023-03-16 07:19:48.153821 I Added logging to the console
> 2023-03-16 07:19:48.153973 I Setup Interrupt handler
> 2023-03-16 07:19:48.153982 I Setup Terminated handler
> 2023-03-16 07:19:48.153986 I Setup Segmentation fault handler
> 2023-03-16 07:19:48.153989 I Setup Aborted handler
> 2023-03-16 07:19:48.153991 I Setup Bus error handler
> 2023-03-16 07:19:48.153995 I Setup Floating point exception handler
> 2023-03-16 07:19:48.153998 I Setup Illegal instruction handler
> 2023-03-16 07:19:48.154016 I Setup Real-time signal 0 handler
> 2023-03-16 07:19:48.154019 I Setup Hangup handler
> 2023-03-16 07:19:48.154104 N Using runtime prefix = /usr
> 2023-03-16 07:19:48.154106 N Using configuration directory =
> /home/mythtv/.mythtv
> 2023-03-16 07:19:48.154132 I Assumed character encoding: en_CA.UTF-8
> 2023-03-16 07:19:48.154381 I Empty LocalHostName. This is typical.
> 2023-03-16 07:19:48.154384 I Using a profile name of: 'trieli' (Usually
> the same as this host's name.)
> 2023-03-16 07:19:48.154415 I Start up testing connections. DB localhost,
> BE , attempt 0, status dbAwake, Delay: 2000
> 2023-03-16 07:19:49.192982 N Setting QT default locale to en_CA
> 2023-03-16 07:19:49.192999 I Current locale en_CA
> 2023-03-16 07:19:49.193080 N Reading locale defaults from
> /usr/share/mythtv//locales/en_ca.xml
> 2023-03-16 07:19:49.245071 I PowerDBus: Added UPower.Device
> '/org/freedesktop/UPower/devices/keyboard_hidpp_battery_0'
> 2023-03-16 07:19:49.245705 I Power: On AC power
> 2023-03-16 07:19:49.248229 I PowerDBus: Added UPower.Device
> '/org/freedesktop/UPower/devices/mouse_hidpp_battery_1'
> 2023-03-16 07:19:49.293742 I Power: Supported actions:
> Suspend,Restart,Shutdown
> 2023-03-16 07:19:49.295612 I Loading en_ca translation for module
> mythfrontend
> 2023-03-16 07:19:49.298571 I Current MythTV Schema Version (DBSchemaVer):
> 1376
> 2023-03-16 07:19:49.304452 I MythCoreContext::ConnectCommandSocket():
> Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
> 2023-03-16 07:19:49.310106 I MythCoreContext::CheckProtoVersion(): Using
> protocol version 91 BuzzOff
> 2023-03-16 07:19:49.310593 I Opening blocking connection to master backend
> 2023-03-16 07:19:49.611505 I Updating source #1 (antenna) with grabber
> tv_grab_zz_sdjson_sqlite
> 2023-03-16 07:19:49.612353 I Found 37 channels for source 1 which use
> grabber
> 2023-03-16 07:19:49.613030 I Starting process manager
> 2023-03-16 07:19:49.613228 I Starting IO manager (read)
> 2023-03-16 07:19:49.613255 I Starting process signal handler
> 2023-03-16 07:19:49.618288 I Starting IO manager (write)
> 2023-03-16 07:19:50.415621 I Grabber has capabilities: baseline
> manualconfig preferredmethod lineups apiconfig
> 2023-03-16 07:19:51.267150 I Grabber prefers method: allatonce
> 2023-03-16 07:19:51.268351 I XMLTV config file is:
> /home/mythtv/.mythtv/antenna.xmltv
> 2023-03-16 07:19:52.120150 E XMLTV grabber returned error code 1
> 2023-03-16 07:19:52.770885 E Malformed XML file, missing </tv> element,
> at line 1, Premature end of document.
> 2023-03-16 07:19:53.034614 I Updating source #8 (intenna) with grabber
> tv_grab_zz_sdjson_sqlite
> 2023-03-16 07:19:53.035398 I Found 36 channels for source 8 which use
> grabber
> 2023-03-16 07:19:53.872718 I Grabber has capabilities: baseline
> manualconfig preferredmethod lineups apiconfig
> 2023-03-16 07:19:54.674329 I Grabber prefers method: allatonce
> 2023-03-16 07:19:54.675297 I XMLTV config file is:
> /home/mythtv/.mythtv/intenna.xmltv
> 2023-03-16 07:19:55.478235 E XMLTV grabber returned error code 1
> 2023-03-16 07:19:55.977897 E Malformed XML file, missing </tv> element,
> at line 1, Premature end of document.
> 2023-03-16 07:19:56.079645 E Failed to fetch some program info
> 2023-03-16 07:19:56.079702 I Adjusting program database end times.
> 2023-03-16 07:19:56.080286 I 0 replacements made
> 2023-03-16 07:19:56.080289 I Marking generic episodes.
> 2023-03-16 07:19:56.359440 I Found 0
> 2023-03-16 07:19:56.359447 I Extending non-unique programids with
> multiple parts.
> 2023-03-16 07:19:56.518298 I Found 0
> 2023-03-16 07:19:56.518304 I Fixing missing original airdates.
> 2023-03-16 07:19:57.027359 I Found 0 with programids
> 2023-03-16 07:19:57.028199 I Found 0 without programids
> 2023-03-16 07:19:57.028203 I Marking repeats.
> 2023-03-16 07:19:57.056135 I Found 0
> 2023-03-16 07:19:57.056142 I Unmarking new episode rebroadcast repeats.
> 2023-03-16 07:19:57.233117 I Found 0
> 2023-03-16 07:19:58.067377 I Marking episode first showings.
> 2023-03-16 07:19:59.402563 I Found 43413
> 2023-03-16 07:19:59.402570 I Marking episode last showings.
> 2023-03-16 07:20:00.743345 I Found 43331
> 2023-03-16 07:20:00.755586 I
> ===============================================================
> | Attempting to contact the master backend for rescheduling. |
> | If the master is not running, rescheduling will happen when |
> | the master backend is restarted. |
> ===============================================================
> 2023-03-16 07:20:00.756650 N mythfilldatabase run complete.
> 2023-03-16 07:20:00.756726 I PowerDBus: Closing interfaces
> 2023-03-16 07:20:00.758004 I Waiting for threads to exit.
> 2023-03-16 07:20:00.758029 I Exiting
> $
>
> so I did the following from the wiki:
> sudo apt update
> sudo apt install git make xmltv perl-doc
> # Note: xmltv gets the required perl modules
>
> mkdir -p build
> cd build
> git clone https://github.com/XMLTV/xmltv.git
> cd xmltv
> perl Makefile.PL
> make
> make test
> sudo make install
>
> 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.
Re: mythfilldatgabase failure [ In reply to ]
~ is homedir; if no user is provided, it is 'the current logged in user'
~user is homedir of user
~mythtv is mythtv's homedir wherever that may be, and this path is
expandable as such:
echo ~mythtv

The .xmltv directory inside mythtv user's homedir should then contain a
sqlite database file named SchedulesDirect.DB.

Mike


On Thu, Mar 16, 2023 at 10:59?AM Daryl McDonald <darylangela@gmail.com>
wrote:

>
>
> On Thu, Mar 16, 2023 at 10:50?AM Bill Meek <keemllib@gmail.com> wrote:
>
>> On Thursday 16 March 2023 06:36:37 AM (-05:00), Daryl McDonald wrote:
>>
>> Looks like the issue:
>> daryl@trieli:~$ tv_grab_zz_sdjson_sqlite --capabilities
>> Command 'tv_grab_zz_sdjson_sqlite' not found, but can be installed with:
>> sudo apt install xmltv-util
>> daryl@trieli:~$ sudo apt install -y xmltv-util
>>
>> but after installing the xmltv-util we're still not quite there:
>>
>> daryl@trieli:~$ sudo su mythtv
>> $ mythfilldatabase
>> 2023-03-16 07:19:48.143231 C mythfilldatabase version: fixes/32
>> [v32.0+fixes.20220325.f69ce764b7-0ubuntu1] www.mythtv.org
>> 2023-03-16 07:19:48.143241 C Qt version: compile: 5.15.2, runtime: 5.15.3
>> 2023-03-16 07:19:48.143273 I Ubuntu 22.04.2 LTS (x86_64)
>> 2023-03-16 07:19:48.143275 N Enabled verbose msgs: general
>> 2023-03-16 07:19:48.143282 N Setting Log Level to LOG_INFO
>> 2023-03-16 07:19:48.153821 I Added logging to the console
>> 2023-03-16 07:19:48.153973 I Setup Interrupt handler
>> 2023-03-16 07:19:48.153982 I Setup Terminated handler
>> 2023-03-16 07:19:48.153986 I Setup Segmentation fault handler
>> 2023-03-16 07:19:48.153989 I Setup Aborted handler
>> 2023-03-16 07:19:48.153991 I Setup Bus error handler
>> 2023-03-16 07:19:48.153995 I Setup Floating point exception handler
>> 2023-03-16 07:19:48.153998 I Setup Illegal instruction handler
>> 2023-03-16 07:19:48.154016 I Setup Real-time signal 0 handler
>> 2023-03-16 07:19:48.154019 I Setup Hangup handler
>> 2023-03-16 07:19:48.154104 N Using runtime prefix = /usr
>> 2023-03-16 07:19:48.154106 N Using configuration directory =
>> /home/mythtv/.mythtv
>> 2023-03-16 07:19:48.154132 I Assumed character encoding: en_CA.UTF-8
>> 2023-03-16 07:19:48.154381 I Empty LocalHostName. This is typical.
>> 2023-03-16 07:19:48.154384 I Using a profile name of: 'trieli' (Usually
>> the same as this host's name.)
>> 2023-03-16 07:19:48.154415 I Start up testing connections. DB localhost,
>> BE , attempt 0, status dbAwake, Delay: 2000
>> 2023-03-16 07:19:49.192982 N Setting QT default locale to en_CA
>> 2023-03-16 07:19:49.192999 I Current locale en_CA
>> 2023-03-16 07:19:49.193080 N Reading locale defaults from
>> /usr/share/mythtv//locales/en_ca.xml
>> 2023-03-16 07:19:49.245071 I PowerDBus: Added UPower.Device
>> '/org/freedesktop/UPower/devices/keyboard_hidpp_battery_0'
>> 2023-03-16 07:19:49.245705 I Power: On AC power
>> 2023-03-16 07:19:49.248229 I PowerDBus: Added UPower.Device
>> '/org/freedesktop/UPower/devices/mouse_hidpp_battery_1'
>> 2023-03-16 07:19:49.293742 I Power: Supported actions:
>> Suspend,Restart,Shutdown
>> 2023-03-16 07:19:49.295612 I Loading en_ca translation for module
>> mythfrontend
>> 2023-03-16 07:19:49.298571 I Current MythTV Schema Version
>> (DBSchemaVer): 1376
>> 2023-03-16 07:19:49.304452 I MythCoreContext::ConnectCommandSocket():
>> Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
>> 2023-03-16 07:19:49.310106 I MythCoreContext::CheckProtoVersion(): Using
>> protocol version 91 BuzzOff
>> 2023-03-16 07:19:49.310593 I Opening blocking connection to master
>> backend
>> 2023-03-16 07:19:49.611505 I Updating source #1 (antenna) with grabber
>> tv_grab_zz_sdjson_sqlite
>> 2023-03-16 07:19:49.612353 I Found 37 channels for source 1 which use
>> grabber
>> 2023-03-16 07:19:49.613030 I Starting process manager
>> 2023-03-16 07:19:49.613228 I Starting IO manager (read)
>> 2023-03-16 07:19:49.613255 I Starting process signal handler
>> 2023-03-16 07:19:49.618288 I Starting IO manager (write)
>> 2023-03-16 07:19:50.415621 I Grabber has capabilities: baseline
>> manualconfig preferredmethod lineups apiconfig
>> 2023-03-16 07:19:51.267150 I Grabber prefers method: allatonce
>> 2023-03-16 07:19:51.268351 I XMLTV config file is:
>> /home/mythtv/.mythtv/antenna.xmltv
>> 2023-03-16 07:19:52.120150 E XMLTV grabber returned error code 1
>> 2023-03-16 07:19:52.770885 E Malformed XML file, missing </tv> element,
>> at line 1, Premature end of document.
>> 2023-03-16 07:19:53.034614 I Updating source #8 (intenna) with grabber
>> tv_grab_zz_sdjson_sqlite
>> 2023-03-16 07:19:53.035398 I Found 36 channels for source 8 which use
>> grabber
>> 2023-03-16 07:19:53.872718 I Grabber has capabilities: baseline
>> manualconfig preferredmethod lineups apiconfig
>> 2023-03-16 07:19:54.674329 I Grabber prefers method: allatonce
>> 2023-03-16 07:19:54.675297 I XMLTV config file is:
>> /home/mythtv/.mythtv/intenna.xmltv
>> 2023-03-16 07:19:55.478235 E XMLTV grabber returned error code 1
>> 2023-03-16 07:19:55.977897 E Malformed XML file, missing </tv> element,
>> at line 1, Premature end of document.
>> 2023-03-16 07:19:56.079645 E Failed to fetch some program info
>> 2023-03-16 07:19:56.079702 I Adjusting program database end times.
>> 2023-03-16 07:19:56.080286 I 0 replacements made
>> 2023-03-16 07:19:56.080289 I Marking generic episodes.
>> 2023-03-16 07:19:56.359440 I Found 0
>> 2023-03-16 07:19:56.359447 I Extending non-unique programids with
>> multiple parts.
>> 2023-03-16 07:19:56.518298 I Found 0
>> 2023-03-16 07:19:56.518304 I Fixing missing original airdates.
>> 2023-03-16 07:19:57.027359 I Found 0 with programids
>> 2023-03-16 07:19:57.028199 I Found 0 without programids
>> 2023-03-16 07:19:57.028203 I Marking repeats.
>> 2023-03-16 07:19:57.056135 I Found 0
>> 2023-03-16 07:19:57.056142 I Unmarking new episode rebroadcast repeats.
>> 2023-03-16 07:19:57.233117 I Found 0
>> 2023-03-16 07:19:58.067377 I Marking episode first showings.
>> 2023-03-16 07:19:59.402563 I Found 43413
>> 2023-03-16 07:19:59.402570 I Marking episode last showings.
>> 2023-03-16 07:20:00.743345 I Found 43331
>> 2023-03-16 07:20:00.755586 I
>> ===============================================================
>> | Attempting to contact the master backend for rescheduling. |
>> | If the master is not running, rescheduling will happen when |
>> | the master backend is restarted. |
>> ===============================================================
>> 2023-03-16 07:20:00.756650 N mythfilldatabase run complete.
>> 2023-03-16 07:20:00.756726 I PowerDBus: Closing interfaces
>> 2023-03-16 07:20:00.758004 I Waiting for threads to exit.
>> 2023-03-16 07:20:00.758029 I Exiting
>> $
>>
>> so I did the following from the wiki:
>> sudo apt update
>> sudo apt install git make xmltv perl-doc
>> # Note: xmltv gets the required perl modules
>>
>> mkdir -p build
>> cd build
>> git clone https://github.com/XMLTV/xmltv.git
>> cd xmltv
>> perl Makefile.PL
>> make
>> make test
>> sudo make install
>>
>> 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.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
Re: mythfilldatgabase failure [ In reply to ]
On Thu, Mar 16, 2023 at 1:21?PM Mike Hodson <mystica@gmail.com> wrote:

> ~ is homedir; if no user is provided, it is 'the current logged in user'
> ~user is homedir of user
> ~mythtv is mythtv's homedir wherever that may be, and this path is
> expandable as such:
> echo ~mythtv
>
> The .xmltv directory inside mythtv user's homedir should then contain a
> sqlite database file named SchedulesDirect.DB.
>
> Mike
>
>
> On Thu, Mar 16, 2023 at 10:59?AM Daryl McDonald <darylangela@gmail.com>
> wrote:
>
>>
>>
>> On Thu, Mar 16, 2023 at 10:50?AM Bill Meek <keemllib@gmail.com> wrote:
>>
>>> On Thursday 16 March 2023 06:36:37 AM (-05:00), Daryl McDonald wrote:
>>>
>>> Looks like the issue:
>>> daryl@trieli:~$ tv_grab_zz_sdjson_sqlite --capabilities
>>> Command 'tv_grab_zz_sdjson_sqlite' not found, but can be installed with:
>>> sudo apt install xmltv-util
>>> daryl@trieli:~$ sudo apt install -y xmltv-util
>>>
>>> but after installing the xmltv-util we're still not quite there:
>>>
>>> daryl@trieli:~$ sudo su mythtv
>>> $ mythfilldatabase
>>> 2023-03-16 07:19:48.143231 C mythfilldatabase version: fixes/32
>>> [v32.0+fixes.20220325.f69ce764b7-0ubuntu1] www.mythtv.org
>>> 2023-03-16 07:19:48.143241 C Qt version: compile: 5.15.2, runtime:
>>> 5.15.3
>>> 2023-03-16 07:19:48.143273 I Ubuntu 22.04.2 LTS (x86_64)
>>> 2023-03-16 07:19:48.143275 N Enabled verbose msgs: general
>>> 2023-03-16 07:19:48.143282 N Setting Log Level to LOG_INFO
>>> 2023-03-16 07:19:48.153821 I Added logging to the console
>>> 2023-03-16 07:19:48.153973 I Setup Interrupt handler
>>> 2023-03-16 07:19:48.153982 I Setup Terminated handler
>>> 2023-03-16 07:19:48.153986 I Setup Segmentation fault handler
>>> 2023-03-16 07:19:48.153989 I Setup Aborted handler
>>> 2023-03-16 07:19:48.153991 I Setup Bus error handler
>>> 2023-03-16 07:19:48.153995 I Setup Floating point exception handler
>>> 2023-03-16 07:19:48.153998 I Setup Illegal instruction handler
>>> 2023-03-16 07:19:48.154016 I Setup Real-time signal 0 handler
>>> 2023-03-16 07:19:48.154019 I Setup Hangup handler
>>> 2023-03-16 07:19:48.154104 N Using runtime prefix = /usr
>>> 2023-03-16 07:19:48.154106 N Using configuration directory =
>>> /home/mythtv/.mythtv
>>> 2023-03-16 07:19:48.154132 I Assumed character encoding: en_CA.UTF-8
>>> 2023-03-16 07:19:48.154381 I Empty LocalHostName. This is typical.
>>> 2023-03-16 07:19:48.154384 I Using a profile name of: 'trieli' (Usually
>>> the same as this host's name.)
>>> 2023-03-16 07:19:48.154415 I Start up testing connections. DB
>>> localhost, BE , attempt 0, status dbAwake, Delay: 2000
>>> 2023-03-16 07:19:49.192982 N Setting QT default locale to en_CA
>>> 2023-03-16 07:19:49.192999 I Current locale en_CA
>>> 2023-03-16 07:19:49.193080 N Reading locale defaults from
>>> /usr/share/mythtv//locales/en_ca.xml
>>> 2023-03-16 07:19:49.245071 I PowerDBus: Added UPower.Device
>>> '/org/freedesktop/UPower/devices/keyboard_hidpp_battery_0'
>>> 2023-03-16 07:19:49.245705 I Power: On AC power
>>> 2023-03-16 07:19:49.248229 I PowerDBus: Added UPower.Device
>>> '/org/freedesktop/UPower/devices/mouse_hidpp_battery_1'
>>> 2023-03-16 07:19:49.293742 I Power: Supported actions:
>>> Suspend,Restart,Shutdown
>>> 2023-03-16 07:19:49.295612 I Loading en_ca translation for module
>>> mythfrontend
>>> 2023-03-16 07:19:49.298571 I Current MythTV Schema Version
>>> (DBSchemaVer): 1376
>>> 2023-03-16 07:19:49.304452 I MythCoreContext::ConnectCommandSocket():
>>> Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
>>> 2023-03-16 07:19:49.310106 I MythCoreContext::CheckProtoVersion():
>>> Using protocol version 91 BuzzOff
>>> 2023-03-16 07:19:49.310593 I Opening blocking connection to master
>>> backend
>>> 2023-03-16 07:19:49.611505 I Updating source #1 (antenna) with grabber
>>> tv_grab_zz_sdjson_sqlite
>>> 2023-03-16 07:19:49.612353 I Found 37 channels for source 1 which use
>>> grabber
>>> 2023-03-16 07:19:49.613030 I Starting process manager
>>> 2023-03-16 07:19:49.613228 I Starting IO manager (read)
>>> 2023-03-16 07:19:49.613255 I Starting process signal handler
>>> 2023-03-16 07:19:49.618288 I Starting IO manager (write)
>>> 2023-03-16 07:19:50.415621 I Grabber has capabilities: baseline
>>> manualconfig preferredmethod lineups apiconfig
>>> 2023-03-16 07:19:51.267150 I Grabber prefers method: allatonce
>>> 2023-03-16 07:19:51.268351 I XMLTV config file is:
>>> /home/mythtv/.mythtv/antenna.xmltv
>>> 2023-03-16 07:19:52.120150 E XMLTV grabber returned error code 1
>>> 2023-03-16 07:19:52.770885 E Malformed XML file, missing </tv> element,
>>> at line 1, Premature end of document.
>>> 2023-03-16 07:19:53.034614 I Updating source #8 (intenna) with grabber
>>> tv_grab_zz_sdjson_sqlite
>>> 2023-03-16 07:19:53.035398 I Found 36 channels for source 8 which use
>>> grabber
>>> 2023-03-16 07:19:53.872718 I Grabber has capabilities: baseline
>>> manualconfig preferredmethod lineups apiconfig
>>> 2023-03-16 07:19:54.674329 I Grabber prefers method: allatonce
>>> 2023-03-16 07:19:54.675297 I XMLTV config file is:
>>> /home/mythtv/.mythtv/intenna.xmltv
>>> 2023-03-16 07:19:55.478235 E XMLTV grabber returned error code 1
>>> 2023-03-16 07:19:55.977897 E Malformed XML file, missing </tv> element,
>>> at line 1, Premature end of document.
>>> 2023-03-16 07:19:56.079645 E Failed to fetch some program info
>>> 2023-03-16 07:19:56.079702 I Adjusting program database end times.
>>> 2023-03-16 07:19:56.080286 I 0 replacements made
>>> 2023-03-16 07:19:56.080289 I Marking generic episodes.
>>> 2023-03-16 07:19:56.359440 I Found 0
>>> 2023-03-16 07:19:56.359447 I Extending non-unique programids with
>>> multiple parts.
>>> 2023-03-16 07:19:56.518298 I Found 0
>>> 2023-03-16 07:19:56.518304 I Fixing missing original airdates.
>>> 2023-03-16 07:19:57.027359 I Found 0 with programids
>>> 2023-03-16 07:19:57.028199 I Found 0 without programids
>>> 2023-03-16 07:19:57.028203 I Marking repeats.
>>> 2023-03-16 07:19:57.056135 I Found 0
>>> 2023-03-16 07:19:57.056142 I Unmarking new episode rebroadcast repeats.
>>> 2023-03-16 07:19:57.233117 I Found 0
>>> 2023-03-16 07:19:58.067377 I Marking episode first showings.
>>> 2023-03-16 07:19:59.402563 I Found 43413
>>> 2023-03-16 07:19:59.402570 I Marking episode last showings.
>>> 2023-03-16 07:20:00.743345 I Found 43331
>>> 2023-03-16 07:20:00.755586 I
>>> ===============================================================
>>> | Attempting to contact the master backend for rescheduling. |
>>> | If the master is not running, rescheduling will happen when |
>>> | the master backend is restarted. |
>>> ===============================================================
>>> 2023-03-16 07:20:00.756650 N mythfilldatabase run complete.
>>> 2023-03-16 07:20:00.756726 I PowerDBus: Closing interfaces
>>> 2023-03-16 07:20:00.758004 I Waiting for threads to exit.
>>> 2023-03-16 07:20:00.758029 I Exiting
>>> $
>>>
>>> so I did the following from the wiki:
>>> sudo apt update
>>> sudo apt install git make xmltv perl-doc
>>> # Note: xmltv gets the required perl modules
>>>
>>> mkdir -p build
>>> cd build
>>> git clone https://github.com/XMLTV/xmltv.git
>>> cd xmltv
>>> perl Makefile.PL
>>> make
>>> make test
>>> sudo make install
>>>
>>> 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
Re: mythfilldatgabase failure [ In reply to ]
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.
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
~mythtv/.xmltv/SchedulesDirect.DB
Everything should be owner:group mythtv:mythtv.

--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 11:32?AM Bill Meek <keemllib@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@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@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@trieli:~$ ls -ld /home/mythtv
drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
daryl@trieli:~$

>
> ~mythtv/.xmltv/SchedulesDirect.DB
> Everything should be owner:group mythtv:mythtv.
>
> --
> Bill
>

So it looks like I'm messed up here

> _
>
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 10:57?AM Daryl McDonald <darylangela@gmail.com>
wrote:

>
>
> On Fri, Mar 17, 2023 at 11:32?AM Bill Meek <keemllib@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@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@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@trieli:~$ ls -ld /home/mythtv
> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
> daryl@trieli:~$
>
>>
>> ~mythtv/.xmltv/SchedulesDirect.DB
>> Everything should be owner:group mythtv:mythtv.
>>
>> --
>> Bill
>>
>
> So it looks like I'm messed up here
>
>> _
>>
>
> Yeah - looks like your UID and GID numbers changed between machines. The
old mythtv:mythtv is now gdm:lxd

chown -R mythtv:mythtv /home/mythtv

should fix it.
Re: mythfilldatgabase failure [ In reply to ]
Hoi Daryl,

Friday, March 17, 2023, 4:56:03 PM, you wrote:




> On Fri, Mar 17, 2023 at 11:32?AM Bill Meek <keemllib@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@trieli:~$  ls -ld ~mythtv/.mythtv/*.xmltv ~mythtv/.xmltvls:
> 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@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@trieli:~$ ls -ld /home/mythtv
> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
> daryl@trieli:~$ 

>
> ~mythtv/.xmltv/SchedulesDirect.DB
> Everything should be owner:group mythtv:mythtv.
>
> --
> Bill




> So it looks like I'm messed up here 
> _
>

goto the mythtv homedirectory and type there:
sudo chown -R mythtv.mythtv *

This will change ownership for all files, directories, subdirectories,
etc. under that home directory

It is a dangerous command so make very sure you are in the right
directory


Tot mails,
Hika mailto:hikavdh@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@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: mythfilldatgabase failure [ In reply to ]
On 17/03/2023 15:56, Daryl McDonald wrote:
> On Fri, Mar 17, 2023 at 11:32?AM Bill Meek <keemllib@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@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@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@trieli:~$ ls -ld /home/mythtv
> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
> daryl@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


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 12:15?PM Mike Perkins <mikep@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@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@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@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@trieli:~$ ls -ld /home/mythtv
> > drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
> > daryl@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
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 12:35?PM Daryl McDonald <darylangela@gmail.com>
wrote:

>
>
> On Fri, Mar 17, 2023 at 12:15?PM Mike Perkins <
> mikep@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@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@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@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@trieli:~$ ls -ld /home/mythtv
>> > drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
>> > daryl@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:

$ mythfilldatabase
2023-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]
Re: mythfilldatgabase failure [ In reply to ]
On Friday 17 March 2023 12:06:26 PM (-05:00), Daryl McDonald wrote:

...

> 2023-03-17 13:04:45.563457 E Error parsing:
> /home/mythtv/.mythtv/config.xml at line: 1 column: 1


The contents of that file are bad. Or, if it was a symbolic link to
/etc/mythtv/config.xml, it's missing or bad See what it looked
like on the old host.

Also note that if your recordings were moved to the new machine,
then they will all have the wrong user. Same for their directories.
--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: mythfilldatgabase failure [ In reply to ]
Hoi Daryl,

Friday, March 17, 2023, 6:06:26 PM, you wrote:




> On Fri, Mar 17, 2023 at 12:35?PM Daryl McDonald <darylangela@gmail.com> wrote:




> On Fri, Mar 17, 2023 at 12:15?PM Mike Perkins
> <mikep@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@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@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@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@trieli:~$ ls -ld /home/mythtv
>> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
>> daryl@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@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@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 1:27?PM Hika van den Hoven <hikavdh@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@gmail.com>
> wrote:
>
>
>
>
> > On Fri, Mar 17, 2023 at 12:15?PM Mike Perkins
> > <mikep@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@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
> >>> Daryl
> >>> > >>>
> >>> > >>>
> >>> > >>> I'd rerun mythfilldatabase -v xmltv and see if there are any
> clues.
> >>> 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@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@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@trieli:~$ ls -ld /home/mythtv
> >> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
> >> daryl@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@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

> _______________________________________________
>
>
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 2:25?PM Daryl McDonald <darylangela@gmail.com>
wrote:

>
> On Fri, Mar 17, 2023 at 1:27?PM Hika van den Hoven <hikavdh@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@gmail.com>
>> wrote:
>>
>>
>>
>>
>> > On Fri, Mar 17, 2023 at 12:15?PM Mike Perkins
>> > <mikep@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@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@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@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@trieli:~$ ls -ld /home/mythtv
>> >> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
>> >> daryl@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@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.
Re: mythfilldatgabase failure [ In reply to ]
On Friday 17 March 2023 01:38:30 PM (-05:00), Daryl McDonald wrote:


...


> 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 element, at

> line 1, Premature end of document.



Run mythfilldatabase as you normally do, but add xmltv logging, like this:


mythfilldatabase -v xmltv


Look in the output for a line that contains this:


Grabber Command: nice

Cut and paste everything after nice up to --output ... . It should look
something like this (I added the --debug switch):


tv_grab_zz_sdjson_sqlite --config-file $HOME/.mythtv/antenna.xmltv
--debug


Look for clues in the output for why it's failing or paste the command and
output
here.

--
Bill
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 3:25?PM Bill Meek <keemllib@gmail.com> wrote:

> On Friday 17 March 2023 01:38:30 PM (-05:00), Daryl McDonald wrote:
>
> ...
>
> > 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 element, at
> > line 1, Premature end of document.
>
> Run mythfilldatabase as you normally do, but add xmltv logging, like this:
>
> mythfilldatabase -v xmltv
>
> Look in the output for a line that contains this:
>
> Grabber Command: nice
>
> Cut and paste everything after nice up to --output ... . It should look
> something like this (I added the --debug switch):
>
> tv_grab_zz_sdjson_sqlite --config-file $HOME/.mythtv/antenna.xmltv
> --debug
>
> Look for clues in the output for why it's failing or paste the command and
> output
> here.
>
> --
> Bill
>

daryl@trieli:~$ sudo su mythtv
[sudo] password for daryl:
$ mythfilldatabase -v xmltv
2023-03-17 15:33:25.649466 C mythfilldatabase version: fixes/32
[v32.0+fixes.20220325.f69ce764b7-0ubuntu1] www.mythtv.org
2023-03-17 15:33:25.649475 C Qt version: compile: 5.15.2, runtime: 5.15.3
2023-03-17 15:33:25.649506 I Ubuntu 22.04.2 LTS (x86_64)
2023-03-17 15:33:25.649508 N Enabled verbose msgs: general xmltv
2023-03-17 15:33:25.649515 N Setting Log Level to LOG_INFO
2023-03-17 15:33:25.660052 I Added logging to the console
2023-03-17 15:33:25.660190 I Setup Interrupt handler
2023-03-17 15:33:25.660195 I Setup Terminated handler
2023-03-17 15:33:25.660198 I Setup Segmentation fault handler
2023-03-17 15:33:25.660201 I Setup Aborted handler
2023-03-17 15:33:25.660204 I Setup Bus error handler
2023-03-17 15:33:25.660207 I Setup Floating point exception handler
2023-03-17 15:33:25.660210 I Setup Illegal instruction handler
2023-03-17 15:33:25.660230 I Setup Real-time signal 0 handler
2023-03-17 15:33:25.660233 I Setup Hangup handler
2023-03-17 15:33:25.660317 N Using runtime prefix = /usr
2023-03-17 15:33:25.660323 N Using configuration directory =
/home/mythtv/.mythtv
2023-03-17 15:33:25.660372 I Assumed character encoding: en_CA.UTF-8
2023-03-17 15:33:25.660610 I Empty LocalHostName. This is typical.
2023-03-17 15:33:25.660613 I Using a profile name of: 'trieli' (Usually
the same as this host's name.)
2023-03-17 15:33:25.660642 I Start up testing connections. DB localhost,
BE , attempt 0, status dbAwake, Delay: 2000
2023-03-17 15:33:26.690544 N Setting QT default locale to en_CA
2023-03-17 15:33:26.690561 I Current locale en_CA
2023-03-17 15:33:26.690646 N Reading locale defaults from
/usr/share/mythtv//locales/en_ca.xml
2023-03-17 15:33:26.723836 I PowerDBus: Added UPower.Device
'/org/freedesktop/UPower/devices/mouse_hidpp_battery_0'
2023-03-17 15:33:26.724256 I Power: On AC power
2023-03-17 15:33:26.725601 I PowerDBus: Added UPower.Device
'/org/freedesktop/UPower/devices/keyboard_hidpp_battery_1'
2023-03-17 15:33:26.768380 I Power: Supported actions:
Suspend,Restart,Shutdown
2023-03-17 15:33:26.770421 I Loading en_ca translation for module
mythfrontend
2023-03-17 15:33:26.772099 I Current MythTV Schema Version (DBSchemaVer):
1376
2023-03-17 15:33:26.774482 I MythCoreContext::ConnectCommandSocket():
Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
2023-03-17 15:33:26.776992 I MythCoreContext::CheckProtoVersion(): Using
protocol version 91 BuzzOff
2023-03-17 15:33:26.777389 I Opening blocking connection to master backend
2023-03-17 15:33:26.876847 I Updating source #1 (antenna) with grabber
tv_grab_zz_sdjson_sqlite
2023-03-17 15:33:26.877618 I Found 37 channels for source 1 which use
grabber
2023-03-17 15:33:26.878443 I Starting process manager
2023-03-17 15:33:26.878494 I Starting process signal handler
2023-03-17 15:33:26.878557 I Starting IO manager (read)
2023-03-17 15:33:26.884096 I Starting IO manager (write)
2023-03-17 15:33:27.679991 I Grabber has capabilities: baseline
manualconfig preferredmethod lineups apiconfig
2023-03-17 15:33:28.531378 I Grabber prefers method: allatonce
2023-03-17 15:33:28.531953 I XMLTV config file is:
/home/mythtv/.mythtv/antenna.xmltv
2023-03-17 15:33:28.533620 I Grabber Command: nice
tv_grab_zz_sdjson_sqlite --config-file '/home/mythtv/.mythtv/antenna.xmltv'
--output /tmp/mythpNSTyE
2023-03-17 15:33:28.533621 I ----------------- Start of XMLTV output
-----------------
2023-03-17 15:33:29.382863 I Opening the local database
2023-03-17 15:33:29.382881 I Initializing database
/home/mythtv/.xmltv/SchedulesDirect.DB
2023-03-17 15:33:29.382891 I Unable to create settings table in database
/home/mythtv/.xmltv/SchedulesDirect.DB: attempt to write a readonly database
2023-03-17 15:33:29.382895 I ------------------ End of XMLTV output
------------------
2023-03-17 15:33:29.383980 E XMLTV grabber returned error code 1
2023-03-17 15:33:29.884095 E Malformed XML file, missing </tv> element, at
line 1, Premature end of document.
2023-03-17 15:33:30.076491 I Updating source #8 (intenna) with grabber
tv_grab_zz_sdjson_sqlite
2023-03-17 15:33:30.077125 I Found 36 channels for source 8 which use
grabber
2023-03-17 15:33:30.885997 I Grabber has capabilities: baseline
manualconfig preferredmethod lineups apiconfig
2023-03-17 15:33:31.687538 I Grabber prefers method: allatonce
2023-03-17 15:33:31.688283 I XMLTV config file is:
/home/mythtv/.mythtv/intenna.xmltv
2023-03-17 15:33:31.690434 I Grabber Command: nice
tv_grab_zz_sdjson_sqlite --config-file '/home/mythtv/.mythtv/intenna.xmltv'
--output /tmp/mythc9gBeb
2023-03-17 15:33:31.690436 I ----------------- Start of XMLTV output
-----------------
2023-03-17 15:33:32.539384 I Opening the local database
2023-03-17 15:33:32.539389 I Initializing database
/home/mythtv/.xmltv/SchedulesDirect.DB
2023-03-17 15:33:32.539391 I Unable to create settings table in database
/home/mythtv/.xmltv/SchedulesDirect.DB: attempt to write a readonly database
2023-03-17 15:33:32.539393 I ------------------ End of XMLTV output
------------------
2023-03-17 15:33:32.541407 E XMLTV grabber returned error code 1
2023-03-17 15:33:33.040759 E Malformed XML file, missing </tv> element, at
line 1, Premature end of document.
2023-03-17 15:33:33.197196 E Failed to fetch some program info
2023-03-17 15:33:33.197244 I Adjusting program database end times.
2023-03-17 15:33:33.197694 I 0 replacements made
2023-03-17 15:33:33.197698 I Marking generic episodes.
2023-03-17 15:33:33.461044 I Found 0
2023-03-17 15:33:33.461051 I Extending non-unique programids with multiple
parts.
2023-03-17 15:33:33.615826 I Found 0
2023-03-17 15:33:33.615833 I Fixing missing original airdates.
2023-03-17 15:33:34.085830 I Found 0 with programids
2023-03-17 15:33:34.086598 I Found 0 without programids
2023-03-17 15:33:34.086600 I Marking repeats.
2023-03-17 15:33:34.109614 I Found 0
2023-03-17 15:33:34.109617 I Unmarking new episode rebroadcast repeats.
2023-03-17 15:33:34.286679 I Found 0
2023-03-17 15:33:35.083879 I Marking episode first showings.
2023-03-17 15:33:36.342699 I Found 40781
2023-03-17 15:33:36.342704 I Marking episode last showings.
2023-03-17 15:33:37.598923 I Found 40711
2023-03-17 15:33:37.609953 I
===============================================================
| Attempting to contact the master backend for rescheduling. |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted. |
===============================================================
2023-03-17 15:33:37.610860 N mythfilldatabase run complete.
2023-03-17 15:33:37.610918 I PowerDBus: Closing interfaces
2023-03-17 15:33:37.611645 I Waiting for threads to exit.
2023-03-17 15:33:37.612036 I Exiting
$

_
>
Re: mythfilldatgabase failure [ In reply to ]
On Friday 17 March 2023 02:34:53 PM (-05:00), Daryl McDonald wrote:

> On Fri, Mar 17, 2023 at 3:25?PM Bill Meek wrote:
>
> > On Friday 17 March 2023 01:38:30 PM (-05:00), Daryl McDonald wrote:
> >
> > ...
> >
> > > 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 element, at
> > > line 1, Premature end of document.
> >
> > Run mythfilldatabase as you normally do, but add xmltv logging, like this:
> >
> > mythfilldatabase -v xmltv
> >
> > Look in the output for a line that contains this:
> >
> > Grabber Command: nice
> >
> > Cut and paste everything after nice up to --output ... . It should look
> > something like this (I added the --debug switch):
> >
> > tv_grab_zz_sdjson_sqlite --config-file $HOME/.mythtv/antenna.xmltv
> > --debug
> >
> > Look for clues in the output for why it's failing or paste the command and
> > output
> > here.
> >
> > --
> > Bill
> >
>
> daryl@trieli:~$ sudo su mythtv
> [sudo] password for daryl:
> $ mythfilldatabase -v xmltv

...

> 2023-03-17 15:33:28.533620 I Grabber Command: nice
> tv_grab_zz_sdjson_sqlite --config-file '/home/mythtv/.mythtv/antenna.xmltv'
> --output /tmp/mythpNSTyE

...

OK, but you have to run Grabber Command manually:

tv_grab_zz_sdjson_sqlite --config-file '/home/mythtv/.mythtv/intenna.xmltv' --debug

Looking for a reason for the failure there.

--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 3:51?PM Bill Meek <keemllib@gmail.com> wrote:

>
>
>
> On Friday 17 March 2023 02:34:53 PM (-05:00), Daryl McDonald wrote:
>
> > On Fri, Mar 17, 2023 at 3:25?PM Bill Meek wrote:
> >
> > > On Friday 17 March 2023 01:38:30 PM (-05:00), Daryl McDonald wrote:
> > >
> > > ...
> > >
> > > > 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 element, at
> > > > line 1, Premature end of document.
> > >
> > > Run mythfilldatabase as you normally do, but add xmltv logging, like
> this:
> > >
> > > mythfilldatabase -v xmltv
> > >
> > > Look in the output for a line that contains this:
> > >
> > > Grabber Command: nice
> > >
> > > Cut and paste everything after nice up to --output ... . It should look
> > > something like this (I added the --debug switch):
> > >
> > > tv_grab_zz_sdjson_sqlite --config-file $HOME/.mythtv/antenna.xmltv
> > > --debug
> > >
> > > Look for clues in the output for why it's failing or paste the command
> and
> > > output
> > > here.
> > >
> > > --
> > > Bill
> > >
> >
> > daryl@trieli:~$ sudo su mythtv
> > [sudo] password for daryl:
> > $ mythfilldatabase -v xmltv
>
> ...
>
> > 2023-03-17 15:33:28.533620 I Grabber Command: nice
> > tv_grab_zz_sdjson_sqlite --config-file
> '/home/mythtv/.mythtv/antenna.xmltv'
> > --output /tmp/mythpNSTyE
>
> ...
>
> OK, but you have to run Grabber Command manually:
>
> tv_grab_zz_sdjson_sqlite --config-file
> '/home/mythtv/.mythtv/intenna.xmltv' --debug
>
> Looking for a reason for the failure there.
>
> --
> Bill
>

daryl@trieli:~$ tv_grab_zz_sdjson_sqlite --config-file
'/home/mythtv/.mythtv/intenna.xmltv' --debug
DEBUG: Returning from SchedulesDirect::Debug with:
DEBUG: $VAR1 = 1;
Opening the local database
Obtaining authentication token for Schedules Direct
DEBUG: Entering SchedulesDirect::obtainToken with args:
DEBUG: $VAR1 = "darylangela";
DEBUG: $VAR2 = undef;
DEBUG: $VAR3 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";
DEBUG: $VAR4 = undef;
DEBUG: Entering SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetError
DEBUG: Entering SchedulesDirect::Username with args:
DEBUG: $VAR1 = "darylangela";
DEBUG: Entering SchedulesDirect::_resetSession
DEBUG: Entering SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetSession
DEBUG: Returning from SchedulesDirect::Username with:
DEBUG: $VAR1 = "darylangela";
DEBUG: Entering SchedulesDirect::PasswordHash with args:
DEBUG: $VAR1 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";
DEBUG: Entering SchedulesDirect::_resetSession
DEBUG: Entering SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetSession
DEBUG: Returning from SchedulesDirect::PasswordHash with:
DEBUG: $VAR1 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";
DEBUG: Entering SchedulesDirect::_resetSession
DEBUG: Entering SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetSession
DEBUG: HTTP request:
DEBUG: $VAR1 = bless( {
DEBUG: "_headers" => bless( {}, 'HTTP::Headers' ),
DEBUG: "_uri" => bless( do{\(my $o = "
https://json.schedulesdirect.org/20141201/token")}, 'URI::https' ),
DEBUG: "_method" => "POST",
DEBUG: "_content" =>
"{\"username\":\"darylangela\",\"password\":\"92ed9f927cf1162628e1e1a92221672e1d63aa70\"}"
DEBUG: }, 'HTTP::Request' );
DEBUG: HTTP response:
DEBUG: $VAR1 = bless( {
DEBUG: "_headers" => bless( {
DEBUG: "server" => "nginx/1.18.0
(Ubuntu)",
DEBUG: "client-ssl-version" =>
"TLSv1_2",
DEBUG: "client-ssl-cipher" =>
"ECDHE-RSA-AES128-GCM-SHA256",
DEBUG: "client-peer" => "
52.5.17.38:443",
DEBUG: "x-xss-protection" => "1;
mode=block",
DEBUG: "::std_case" => {
DEBUG:
"x-content-type-options" => "X-Content-Type-Options",
DEBUG:
"client-ssl-socket-class" => "Client-SSL-Socket-Class",
DEBUG:
"x-xss-protection" => "X-XSS-Protection",
DEBUG:
"client-peer" => "Client-Peer",
DEBUG:
"client-ssl-cipher" => "Client-SSL-Cipher",
DEBUG:
"client-ssl-version" => "Client-SSL-Version",
DEBUG:
"client-ssl-cert-issuer" => "Client-SSL-Cert-Issuer",
DEBUG:
"client-transfer-encoding" => "Client-Transfer-Encoding",
DEBUG:
"client-ssl-cert-subject" => "Client-SSL-Cert-Subject",
DEBUG:
"schedulesdirect-serverid" => "Schedulesdirect-Serverid",
DEBUG:
"x-frame-options" => "X-Frame-Options",
DEBUG:
"client-response-num" => "Client-Response-Num",
DEBUG:
"client-date" => "Client-Date"
DEBUG: },
DEBUG: "content-type" =>
"application/json;charset=UTF-8",
DEBUG: "client-ssl-socket-class"
DEBUG: "x-content-type-options"
DEBUG: "date" => "Fri, 17 Mar
2023 19:55:08 GMT",
DEBUG: "client-response-num" => 1,
DEBUG: "client-date" => "Fri, 17
Mar 2023 19:55:08 GMT",
DEBUG: "schedulesdirect-serverid"
DEBUG: "x-frame-options" =>
"SAMEORIGIN",
DEBUG: "client-transfer-encoding"
DEBUG:
"chunked"
DEBUG:
],
DEBUG: "client-ssl-cert-subject"
DEBUG: "client-ssl-cert-issuer"
DEBUG: "content-encoding" =>
"gzip",
DEBUG: "vary" =>
"Accept-Encoding",
DEBUG: "connection" =>
"keep-alive"
DEBUG: }, 'HTTP::Headers' ),
DEBUG: "_request" => bless( {
DEBUG: "_uri_canonical" => bless(
do{\(my $o = "https://json.schedulesdirect.org/20141201/token")},
'URI::https' ),
DEBUG: "_headers" => bless( {
DEBUG:
"user-agent" => "tv_grab_zz_sdjson_sqlite",
DEBUG:
"pragma" => "no-cache",
DEBUG:
"accept-encoding" => "gzip, x-gzip, deflate, x-bzip2, bzip2",
DEBUG:
"accept" => "application/json",
DEBUG:
"content-type" => "application/json",
DEBUG:
"::std_case" => {
DEBUG:
"if-ssl-cert-subject" => "If-SSL-Cert-Subject"
DEBUG:
},
DEBUG:
"cache-control" => "no-cache"
DEBUG: },
'HTTP::Headers' ),
DEBUG: "_uri" =>
$VAR1->{"_request"}{"_uri_canonical"},
DEBUG: "_method" => "POST",
DEBUG: "_content" =>
"{\"username\":\"darylangela\",\"password\":\"92ed9f927cf1162628e1e1a92221672e1d63aa70\"}",
DEBUG: "_protocol" => undef
DEBUG: }, 'HTTP::Request' ),
DEBUG: "_content" =>
"\37\213\b\0\0\0\0\0\0\3\35\312\275\n\0021\20\4\340w\331\372N\222=C~j\e\261\260\261\262\333\$s\"r\36\\\202\26\342\273\273\330\f3|\363\241\262VP2\3-hMn\332\351|\242\201\32\266\27\266\343A7\e\273\267\32\2737\262J\225\216~_\360\27\236F3\215\326_lL\316%\23\256\372\350\353\3Oe/\22\312\234\243c\211\271\202Q\2623\2149\370\300\f\361\364\375\1\\\351j\222\200\0\0\0",
DEBUG: "_msg" => "OK",
DEBUG: "_protocol" => "HTTP/1.1",
DEBUG: "_rc" => 200
DEBUG: }, 'HTTP::Response' );
DEBUG: HTTP decoded response content:
DEBUG: $VAR1 =
"{\"code\":0,\"message\":\"OK\",\"serverID\":\"20141201.web\",\"datetime\":\"2023-03-17T19:55:08Z\",\"token\":\"7aa8cfb952a9bde2ecb502ef87822ea7\"}";
DEBUG: Entering SchedulesDirect::Token with args:
DEBUG: Returning from SchedulesDirect::Token with:
DEBUG: $VAR1 = "7aa8cfb952a9bde2ecb502ef87822ea7 1679082907.72004";
DEBUG: Returning from SchedulesDirect::obtainToken with:
DEBUG: $VAR1 = "7aa8cfb952a9bde2ecb502ef87822ea7 1679082907.72004";
Unexpected error when executing statement (replace into settings (tag,
value) values (?, ?)): attempt to write a readonly database
daryl@trieli:~$

_______________________________________________
>
>
Re: mythfilldatgabase failure [ In reply to ]
On Friday 17 March 2023 02:56:41 PM (-05:00), Daryl McDonald wrote:


...


> Unexpected error when executing statement (replace into settings (tag,

> value) values (?, ?)): attempt to write a readonly database

> daryl@trieli:~$



Are you sure /home/mythtv/.xmltv/SchedulesDirect.DB is readable/writable
by user and group mythtv? AND make sure:/home/mythtv/.xmltv is
readable/writable/searchable
too.


ls -ld /home/mythtv/.xmltv/SchedulesDirect.DB /home/mythtv/.xmltv

--
Bill
Re: mythfilldatgabase failure [ In reply to ]
On Fri, Mar 17, 2023 at 4:22?PM Bill Meek <keemllib@gmail.com> wrote:

> On Friday 17 March 2023 02:56:41 PM (-05:00), Daryl McDonald wrote:
>
> ...
>
> > Unexpected error when executing statement (replace into settings (tag,
> > value) values (?, ?)): attempt to write a readonly database
> > daryl@trieli:~$
>
> Are you sure /home/mythtv/.xmltv/SchedulesDirect.DB is readable/writable
> by user and group mythtv? AND make sure:/home/mythtv/.xmltv is
> readable/writable/searchable
> too.
>
> ls -ld /home/mythtv/.xmltv/SchedulesDirect.DB /home/mythtv/.xmltv
>
> --
> Bill
>

daryl@trieli:~$ ls -ld /home/mythtv/.xmltv/SchedulesDirect.DB
/home/mythtv/.xmltv
drwxrwxr-x 3 gdm lxd 4096 Mar 17 15:55 /home/mythtv/.xmltv
-rw-r--r-- 1 mythtv mythtv 98304 Mar 16 20:40
/home/mythtv/.xmltv/SchedulesDirect.DB
daryl@trieli:~$ sudo chmod +x /home/mythtv/.xmltv/SchedulesDirect.DB
/home/mythtv/.xmltv
[sudo] password for daryl:
daryl@trieli:~$ ls -ld /home/mythtv/.xmltv/SchedulesDirect.DB
/home/mythtv/.xmltv
drwxrwxr-x 3 gdm lxd 4096 Mar 17 15:55 /home/mythtv/.xmltv
-rwxr-xr-x 1 mythtv mythtv 98304 Mar 16 20:40
/home/mythtv/.xmltv/SchedulesDirect.DB
daryl@trieli:~$ ls -dl /home/mythtv/.xmltv
drwxrwxr-x 3 gdm lxd 4096 Mar 17 15:55 /home/mythtv/.xmltv
daryl@trieli:~$

> _______________________________________________
>
And it still returns error code 1

1 2  View All