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