1. No user installed addons are supported, python or otherwise.
2. No, they really are not supported.
3. They are not coming back
4. Read from 1. again

Any mention of illegal streaming sites, addons or any pirated material will not be tolerated. This is not democracy and any offenders will be banned and posts deleted immediately without warning.

Other than that, we hope you enjoy MrMC so far and we welcome any input and feedback you might have.

Team MrMC.

MySQL Setup - App freezes

Support for any MySQL database connection issues
Post Reply
micha2k6
Posts: 3
Joined: 29 Feb 2016, 18:34

MySQL Setup - App freezes

Post by micha2k6 » 29 Feb 2016, 19:13

Hi toghether,

I'm having an issue setting up the MySQL connection on my MRMC Apps. I enter all the connection info and activate the connection the app Shows the 'working' with the moving circlet but after a few seconds it just freezes, nothing happens anymore. If I check the MySQL server I don't see any active connection.
I tried it on my iPhone 6S and my new ATV4 - both with the same issues.

My Setup:
TurnKey MySQL Appliance (running on my home esx-sever)
2 small PCs running OpenElec 6.0.2 (Kodi 15.2) - both running fine with the DB
iPhone 6S and ATV4 with MRMC

Settings:
Server: 10.8.4.25
Port: 3306
User: xbmc
Password: xbmc
Video database: MyVideos93
Music database: MyMusic52

Databases have been created with the same user by the OpenElec installations.

Anyone with some ideas for troubleshooting?

Thanks,
Michael

User avatar
amet
Team MrMC
Posts: 1933
Joined: 26 Oct 2015, 16:59

Re: MySQL Setup - App freezes

Post by amet » 29 Feb 2016, 19:17

lets see the debuglog please

micha2k6
Posts: 3
Joined: 29 Feb 2016, 18:34

Re: MySQL Setup - App freezes

Post by micha2k6 » 29 Feb 2016, 19:34

I'm sorry to ask, but how can I access the debugging log? Do I have to pull it with iTunes from my iPhone for example?

User avatar
amet
Team MrMC
Posts: 1933
Joined: 26 Oct 2015, 16:59

Re: MySQL Setup - App freezes

Post by amet » 29 Feb 2016, 19:36


micha2k6
Posts: 3
Joined: 29 Feb 2016, 18:34

Re: MySQL Setup - App freezes

Post by micha2k6 » 29 Feb 2016, 19:48

Got the log an also found the issue:

20:41:34 T:6148583424 ERROR: Unable to create new database
20:41:34 T:6148583424 ERROR: Unable to open database: MyVideos9393 [1044](Access denied for user 'xbmc'@'%' to database 'MyVideos9393')

I entered the full name of the database like MyVideos93, but the App want's the name MyVideos.
As it's running database version 93 (Kodi 15.x) it will automatically add the 93 to the end - same for the music database.

Next to it my xbmc user only has pemissions on the explicit databases and not on the full server it could not create a new database.

Thanks for pointing me in the correct direction,
Michael

User avatar
amet
Team MrMC
Posts: 1933
Joined: 26 Oct 2015, 16:59

Re: MySQL Setup - App freezes

Post by amet » 29 Feb 2016, 19:49

just call your database "MyVideos" and it will connect to the existing MyVideos93

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest