[mythtv-users] sql connection question

Stephen Worthington stephen_agent at jsw.gen.nz
Sun Jan 12 12:14:21 UTC 2020


On Sun, 12 Jan 2020 10:51:09 +0000, you wrote:

>with recent mariadb upgrades i've been seeing this appear in the logs reasonably often. i think it's just a change of default logging level with the more recent versions.
>While i do have my Primary FE dropping frames for 20-30secs periodically i cant see how that is a sql issue. mythtv appears to work correctly other than that and uses the typical mythconverg & mythtv user.
>
>while it's clear the connection closed normally from the sql side, what in mythtv could cause it to attempt connection as unconnected/unauthenticated? Have I not configured something correctly?
>The IP is my laptop running mythBE&FE, rolled a new sql server for testing (seeing the same entries on my main mariadb server) so 100% sure it's mythtv causing this.
>
>2020-01-12 10:28:25 433 [Warning] Aborted connection 433 to db: 'unconnected' user: 'unauthenticated' host: '192.168.1.63' (This connection closed normally without authentication)

How often is this happening?  If it is happening reasonably often or
you can provoke it to happen, you could run Wireshark and capture the
SQL port traffic and see exactly what is happening.


More information about the mythtv-users mailing list