[mythtv-users] connecting to database failing

Sun Feb 18 19:12:36 UTC 2024

On Sun, Feb 18, 2024 at 1:51 PM Jay Harbeston <jharbestonus at gmail.com>
wrote:

>
>
> > On Feb 18, 2024, at 11:26 AM, James Abernathy <jfabernathy at gmail.com>
> wrote:
> >
> > I'm trying to do something to avoid completely rebuilding a PC with
> mythtv.
> >
> > I have a remote production backend that is working.  I have a PC running
> LMDE 6 that was a mythtv frontend to that backend.  I'm about to move that
> PC to another location outside my home network.  I want to create a new
> local backend on this PC along with its local frontend.
> >
> > This is v34 so I used the new Web App to set up the local backend.  I
> have it working and I have XMLTV configured and the EPG is updated with
> mythfilldatabase and I can run optimize and backup on the mythconverg
> database.
> >
> > So everything seems to be working except the mythfrontend on this PC.
>
> So does the frontend show the screen that times out, and complains about
> not being able to start, and then has the 4 buttons at the bottom with one
> that lets your search for backends?
>
> If so, let it search, and then select the backend… audit should fix itself?
>
> If not you may have to edit theconfig file landfill it in…or maybe
> permissions on config.xml aren’t readable by the user trying to run the
> frontend..
>
>
> Regards!
>
>
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.

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.

my config.xml in the mythtv home directory is
<Configuration>
  <Database>
    <PingHost>1</PingHost>
    <Host>localhost</Host>
    <UserName>mythtv</UserName>
    <Password>6sUFd5O8</Password>
    <DatabaseName>mythconverg</DatabaseName>
    <Port>3306</Port>
  </Database>
  <WakeOnLAN>
    <Enabled>0</Enabled>
    <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
    <SQLConnectRetry>5</SQLConnectRetry>
    <Command>echo 'WOLsqlServerCommand not set'</Command>
  </WakeOnLAN>
  <UPnP>
    <UDN>
      <MediaServer>e909ec1e-cf39-4d31-b9c8-b6418865dfba</MediaServer>

<MasterMediaServer>3963fbcc-6fc9-4bf8-8571-e4fe241b5b20</MasterMediaServer>
    </UDN>
  </UPnP>
</Configuration>

The part in red is the addition not in the /etc/mythtv version of config.xml

Also I have noticed that mythutil has issues logging in.
jim at den-pc:~$ mythutil --scanvideos
2024-02-18 14:10:46.034110 C  mythutil version: fixes/34
[v34.0+fixes.20240218.93a3026e-0ubuntu0] www.mythtv.org
2024-02-18 14:10:46.034116 C  Qt version: compile: 5.15.8, runtime: 5.15.8
2024-02-18 14:10:46.034136 I  LMDE 6 (faye) (x86_64)
2024-02-18 14:10:46.034138 N  Enabled verbose msgs:  general
2024-02-18 14:10:46.034143 N  Setting Log Level to LOG_INFO
2024-02-18 14:10:46.044896 I  Setup Interrupt handler
2024-02-18 14:10:46.044899 I  Setup Terminated handler
2024-02-18 14:10:46.044901 I  Setup Segmentation fault handler
2024-02-18 14:10:46.044903 I  Setup Aborted handler
2024-02-18 14:10:46.044905 I  Setup Floating point exception handler
2024-02-18 14:10:46.044907 I  Setup Illegal instruction handler
2024-02-18 14:10:46.044908 I  Setup Bus error handler
2024-02-18 14:10:46.044917 I  Setup Real-time signal 0 handler
2024-02-18 14:10:46.044919 I  Setup Hangup handler
2024-02-18 14:10:46.044967 I  Added logging to the console
2024-02-18 14:10:46.044983 N  Using runtime prefix = /usr
2024-02-18 14:10:46.044984 N  Using configuration directory =
/home/jim/.mythtv
2024-02-18 14:10:46.045089 I  Assumed character encoding: en_US.UTF-8
2024-02-18 14:10:46.045303 I  Empty LocalHostName. This is typical.
2024-02-18 14:10:46.045310 I  Using a profile name of: 'den-pc' (Usually
the same as this host's name.)
2024-02-18 14:10:46.045412 I  DefaultUPnP() - UPNP Search up to 2 secs
2024-02-18 14:10:46.528130 I  DefaultUPnP() - UPNP Search up to 1 secs
2024-02-18 14:10:46.879524 I  DefaultUPnP() - UPNP Search up to 1 secs
2024-02-18 14:10:48.046161 I  Start up testing connections. DB
192.168.0.101, BE , attempt 0, status dbAwake, Delay: 2000
2024-02-18 14:10:49.047899 I  Start up testing connections. DB
192.168.0.101, BE , attempt 1, status dbAwake, Delay: 2000
2024-02-18 14:10:54.054136 I  Start up testing connections. DB
192.168.0.101, BE , attempt 2, status dbAwake, Delay: 2000
2024-02-18 14:10:59.061115 I  Start up testing connections. DB
192.168.0.101, BE , attempt 3, status dbAwake, Delay: 2000
2024-02-18 14:11:04.068670 I  Start up testing connections. DB
192.168.0.101, BE , attempt 4, status dbAwake, Delay: 2000
2024-02-18 14:11:09.075300 I  Start up testing connections. DB
192.168.0.101, BE , attempt 5, status dbAwake, Delay: 2000
2024-02-18 14:11:14.081584 I  Start up testing connections. DB
192.168.0.101, BE , attempt 6, status dbAwake, Delay: 2000
2024-02-18 14:11:19.088265 I  Start up testing connections. DB
192.168.0.101, BE , attempt 7, status dbAwake, Delay: 2000
2024-02-18 14:11:24.094714 I  Start up testing connections. DB
192.168.0.101, BE , attempt 8, status dbAwake, Delay: 2000
2024-02-18 14:11:29.100907 I  Start up testing connections. DB
192.168.0.101, BE , attempt 9, status dbAwake, Delay: 2000
2024-02-18 14:11:34.107139 I  Start up testing connections. DB
192.168.0.101, BE , attempt 10, status dbAwake, Delay: 2000
2024-02-18 14:11:39.113309 I  Start up failure. host 192.168.0.101, status
dbAwakeFail

Cannot login to database

Would you like to configure the database connection now? [no]

Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20240218/7bf37c12/attachment.htm>