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 »

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: 3787
Joined: 26 Oct 2015, 16:59
Location: Dubai/Novi Sad

Re: MySQL Setup - App freezes

Post by amet »

lets see the debuglog please
micha2k6
Posts: 3
Joined: 29 Feb 2016, 18:34

Re: MySQL Setup - App freezes

Post by micha2k6 »

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: 3787
Joined: 26 Oct 2015, 16:59
Location: Dubai/Novi Sad

Re: MySQL Setup - App freezes

Post by amet »

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

Re: MySQL Setup - App freezes

Post by micha2k6 »

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: 3787
Joined: 26 Oct 2015, 16:59
Location: Dubai/Novi Sad

Re: MySQL Setup - App freezes

Post by amet »

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