Page 2 of 2

Re: iOS MySQL connection problem with iPAD

Posted: 13 Jan 2016, 04:16
by amet

Code: Select all

20:13:53 T:6147436544   ERROR: Unable to open database: MyMusic52 [1045](Access denied for user 'kodi'@'DiskStation' (using password: YES))
there is definitely an issue with your setup, you have access denied error which usually means that you have only allowed connection with kodi user from specific IP.

see here for more info http://kodi.wiki/view/MySQL/Setting_up_MySQL

Re: iOS MySQL connection problem with iPAD

Posted: 13 Jan 2016, 10:35
by luckynd
I've sent you screenshots of the MySQL config for iPad and iPhone.
You will see (as I said since the start :-)) that the config is the same.
From what I see in the log:< 'kodi' @ 'DiskStation' >, MrMC is using the server name (or BD alias name, I don't know to what it correspond) instead of the IP (that I've used). So it resolve a (network/DB) name instead of using the IP.
I tried to change it to DiskStationServ, but it is still continuing to use the old name.
Do you have any idea?

Thanks

Re: iOS MySQL connection problem with iPAD

Posted: 13 Jan 2016, 10:52
by amet
it resolves to some IP address that doesn't match with your config :)

Code: Select all

 GRANT ALL ON *.* TO 'kodi';
is the one that allows all IP addresses to connect, if iPad IP address is not allowed to connect then not much it can be done from app side :D

Re: iOS MySQL connection problem with iPAD

Posted: 13 Jan 2016, 11:03
by luckynd
OK, normally I've configured the grant for Kodi with all grant (I've followed the Kodi post). But I will re-check it once I will be back to my home...

Re: iOS MySQL connection problem with iPAD

Posted: 13 Jan 2016, 19:48
by luckynd
"Flush hosts" on MariaDB has solved the problem :-)

EDIT: obviously ;-)