TvOS: No MySQL connection anymore

[RealUser]

First: Thank you for your great work!
Synology streams via NFS perfectly.
The MySQL-Setup to my Synology-MariaDB (existing Kodi-DB) worked too.

My problem: Yesterday i installed the the apple tvos update. Since then, my MySQL-Connection doesn't work anymore. From my other Devices it still works. Is it a known problem with the latest tvos-version? I reinstalled MrMC with no success.

Where can i find a log-error or something?

Thank you!

[RealUser]

I found a strange solution:
Restart your MySQL-Server!

[amet]

So is it not working for you? I don't understand last post.

There is no issue known with MySQL on latest version 1.1.0 in App Store.

Check username/password as its case sensitive... How are you entering user/pass? Using remote or using iOS/android remote app?

[RealUser]

Seems that the established mysql-connection to my mariaDB (Synology) hangs sometimes.
The only solution is to restart the mysql-service on the synology.

This happened to me a few times with ver. 1.1.0.

I think it only happens if mrmc is started and atv4 is in sleepmode and my NAS(mysql) is in sleepmode too.
I have to prevent waking up atv4 before NAS.
If i wake up NAS first, everything is ok.
If i close mrmc an start it again then i waits till NAS(mysql) is ready.

I'll test this behavior with 1.2.0.

Thanks

[RealUser]

Problem still exists with ver. 1.2.0

LOG:
http://pastebin.com/1KYLQk6z

Under "setup/services" mysql is activated - but no sql-connection possible. even if i reboot the device.

Only solution: restart mysql-service at synology.

[davilla]

do you have woa enabled in MrMC ?

[RealUser]

yes

if i close mrmc via apple-app-switcher and restart mrmc, than it waits till synology mysql-service is ready.
this problem occurs only, if mrmc is already opened and not used.

[RealUser]

1) yesterday i watched a movie (everything ok)
2) atv4 went in sleepmode
3) synology went in sleepmode too
4) today i woke up atv4 and closed mrmc via apple-app-switcher
5) start mrmc
5) no mysql connection anymore:


error:
http://pastebin.com/0Z4sbk4u

after restarting mysql-service at synology:
http://pastebin.com/eJdrYE8N

[amet]

Code: Select all

xbmc_video79 [1129](Host '192.168.0.131' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts')

see if you can fixit by doing -> http://dev.mysql.com/doc/refman/5.7/en/ ... -host.html

[RealUser]

i'll test it. thanks.

perhaps you can increase the time mrmc waits for a db-connection at start?

i'm not sure, but i think there was an param in openelec in seconds for this.