<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, Feb 18, 2024 at 4:28 PM James Linder <<a href="mailto:jam@tigger.ws">jam@tigger.ws</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"><br>
<br>
> On Feb 19, 2024, at 03:51, James Abernathy <<a href="mailto:jfabernathy@gmail.com" target="_blank">jfabernathy@gmail.com</a>> wrote:<br>
> <br>
> <br>
> <br>
> On Sun, Feb 18, 2024 at 2:34 PM Jay Harbeston <<a href="mailto:jharbestonus@gmail.com" target="_blank">jharbestonus@gmail.com</a>> wrote:<br>
>> <br>
>> Yes, I see the four buttons and can search. It has a pop up that says it can't connect to the database. If I hit escape, I can see my production backend and the new local one. If I select the new local one, it eventually times out and says it can't login to the database.<br>
>> <br>
>> The /etc/mythtv/config.xml is not the same as the /home/mythtv/.mythtv/config.xml. I thought they used to be one file with a link at the other location.<br>
>> <br>
>> my config.xml in the mythtv home directory is<br>
>> <Configuration><br>
>> <Database><br>
>> <PingHost>1</PingHost><br>
>> <Host>localhost</Host><br>
>> <UserName>mythtv</UserName><br>
>> <Password>6sUFd5O8</Password><br>
>> <DatabaseName>mythconverg</DatabaseName><br>
>> <Port>3306</Port><br>
>> </Database><br>
>> <WakeOnLAN><br>
>> <Enabled>0</Enabled><br>
>> <SQLReconnectWaitTime>0</SQLReconnectWaitTime><br>
>> <SQLConnectRetry>5</SQLConnectRetry><br>
>> <Command>echo 'WOLsqlServerCommand not set'</Command><br>
>> </WakeOnLAN><br>
>> <UPnP><br>
>> <UDN><br>
>> <MediaServer>e909ec1e-cf39-4d31-b9c8-b6418865dfba</MediaServer><br>
>> <MasterMediaServer>3963fbcc-6fc9-4bf8-8571-e4fe241b5b20</MasterMediaServer><br>
>> </UDN><br>
>> </UPnP><br>
>> </Configuration><br>
>> <br>
>> The part in red is the addition not in the /etc/mythtv version of config.xml<br>
>> <br>
>> Also I have noticed that mythutil has issues logging in.<br>
>> jim@den-pc:~$ mythutil --scanvideos<br>
>> 2024-02-18 14:10:46.034110 C mythutil version: fixes/34 [v34.0+fixes.20240218.93a3026e-0ubuntu0] <a href="http://www.mythtv.org" rel="noreferrer" target="_blank">www.mythtv.org</a><br>
>> 2024-02-18 14:10:46.034116 C Qt version: compile: 5.15.8, runtime: 5.15.8<br>
>> 2024-02-18 14:10:46.034136 I LMDE 6 (faye) (x86_64)<br>
>> 2024-02-18 14:10:46.034138 N Enabled verbose msgs: general<br>
>> 2024-02-18 14:10:46.034143 N Setting Log Level to LOG_INFO<br>
>> 2024-02-18 14:10:46.044896 I Setup Interrupt handler<br>
>> 2024-02-18 14:10:46.044899 I Setup Terminated handler<br>
>> 2024-02-18 14:10:46.044901 I Setup Segmentation fault handler<br>
>> 2024-02-18 14:10:46.044903 I Setup Aborted handler<br>
>> 2024-02-18 14:10:46.044905 I Setup Floating point exception handler<br>
>> 2024-02-18 14:10:46.044907 I Setup Illegal instruction handler<br>
>> 2024-02-18 14:10:46.044908 I Setup Bus error handler<br>
>> 2024-02-18 14:10:46.044917 I Setup Real-time signal 0 handler<br>
>> 2024-02-18 14:10:46.044919 I Setup Hangup handler<br>
>> 2024-02-18 14:10:46.044967 I Added logging to the console<br>
>> 2024-02-18 14:10:46.044983 N Using runtime prefix = /usr<br>
>> 2024-02-18 14:10:46.044984 N Using configuration directory = /home/jim/.mythtv<br>
>> 2024-02-18 14:10:46.045089 I Assumed character encoding: en_US.UTF-8<br>
>> 2024-02-18 14:10:46.045303 I Empty LocalHostName. This is typical.<br>
>> 2024-02-18 14:10:46.045310 I Using a profile name of: 'den-pc' (Usually the same as this host's name.)<br>
>> 2024-02-18 14:10:46.045412 I DefaultUPnP() - UPNP Search up to 2 secs<br>
>> 2024-02-18 14:10:46.528130 I DefaultUPnP() - UPNP Search up to 1 secs<br>
>> 2024-02-18 14:10:46.879524 I DefaultUPnP() - UPNP Search up to 1 secs<br>
>> 2024-02-18 14:10:48.046161 I Start up testing connections. DB 192.168.0.101, BE , attempt 0, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:10:49.047899 I Start up testing connections. DB 192.168.0.101, BE , attempt 1, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:10:54.054136 I Start up testing connections. DB 192.168.0.101, BE , attempt 2, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:10:59.061115 I Start up testing connections. DB 192.168.0.101, BE , attempt 3, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:11:04.068670 I Start up testing connections. DB 192.168.0.101, BE , attempt 4, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:11:09.075300 I Start up testing connections. DB 192.168.0.101, BE , attempt 5, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:11:14.081584 I Start up testing connections. DB 192.168.0.101, BE , attempt 6, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:11:19.088265 I Start up testing connections. DB 192.168.0.101, BE , attempt 7, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:11:24.094714 I Start up testing connections. DB 192.168.0.101, BE , attempt 8, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:11:29.100907 I Start up testing connections. DB 192.168.0.101, BE , attempt 9, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:11:34.107139 I Start up testing connections. DB 192.168.0.101, BE , attempt 10, status dbAwake, Delay: 2000<br>
>> 2024-02-18 14:11:39.113309 I Start up failure. host 192.168.0.101, status dbAwakeFail<br>
> <br>
> Is there a .mythtv/config.xml in the directory for user Jim? If so, it needs to be the same as the config in mythtv/.mythtv/config.xml. <br>
> <br>
> I defer to the true experts of mythtv, but I would imagine the config.xml in /etc is what is getting used by the backend. Sounds like Jim is using a diff version. The webfrontend backend setup for database will let you know for sure which one is getting used. <br>
> <br>
> If it is the /etc version, just link your Jim user config.xml to the /etc/ one. If not, copy the config.xml from mythtv to etc… and then link the Jim as well as mythtv user to the /etc one.<br>
> <br>
> Also add the user Jim to the mythtv group if not there already, and make sure /etc/mythtv is owned by mythtv.mythtv<br>
> <br>
> Regards!<br>
> <br>
> <br>
> I'll never understand the need for all the different config.xml files but I just copied /etc/mythtv/config.xml to /home/jim/.mythtv/config.xml and it's now working. I had previously just deleted the "jim" version in hope it would be created by the mythfrontend scan and setup process. I was wrong.<br>
> <br>
<br>
Jim I always take step 1<br>
on the frontend machine (localhost)<br>
$ mysql -u mythtv -pmythtv mythconverg # use -h to make sure localhost or 192.168.x.y (whatever)<br>
<br>
If it connects then issue is mythtv, if not mysql<br>
<br>
I’m vaugely curious, why, in your situation, you’d not use mythtv as password. Like thee, I have no concern that, as the Ozzies say, my wife will go troppo.<br>
<a href="https://www.abc.net.au/news/2018-05-15/going-troppo-what-evidence-is-there/9747436" rel="noreferrer" target="_blank">https://www.abc.net.au/news/2018-05-15/going-troppo-what-evidence-is-there/9747436</a> <br>
James<br>
<br></blockquote><div><br></div><div>I knew it wasn't the mariadb-server stuff as I could run sudo mysql -u root -p and login with a normal password.</div><div><br></div><div>I ended up with the setup I had because that's what the default setup does when using the Web App. Same as using on an Ubuntu system with the ppa's</div><div><br></div><div>It appears that the setup for Debian now using the Web App is very similar to Ubuntu. i.e. random password.</div><div><br></div><div>For me this is just a setup issue. Once I move this PC to my RV for a 2 month trip the PC will be a backend mostly and my FireTVs will be the frontends.</div><div><br></div><div>You can't go out camping in the wild without your portable Mythtv. :-)<br></div><div><br></div><div>Jim A</div><div><br></div></div></div>