MySQL GUI Config Not Working

[virtuallysafe]

Hi Davilla and Amet.

Love your work. I'm a long time XBMC / Kodi user and have been using a MySQL DB for many years. Having just purchased MrMC I am having issues configuring the MySQL connection though the new GUI. My standard advancedsettings.xml working config (from a number of cross platform hosts) is as follows:

Code: Select all

    <videodatabase>
        <type>mysql</type>
        <host>Kodi-Database</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>Kodi_Video</name>
    </videodatabase> 

    <musicdatabase>
        <type>mysql</type>
        <host>Kodi-Database</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>Kodi_Music</name>
    </musicdatabase>
 

When enabling this through the GUI, I get a KAI Toast dialog stating 'Couldn't open database". My MySQL server has the following databases:

Code: Select all

    kodi_music54
    kodi_music55
    kodi_music56
    kodi_video93
    kodi_video94
    kodi_video96
    kodi_video97
    kodi_video99

I have tried changing the server dns name to an IP address (which does resolve), changed the case of the database names.

Any suggestions? Is there a way to get more verbose logs off the ATV4?

As always, appreciate the help.

[amet]

Hi,

Have you tried entering database names lowercase? If database doesn't exist it would create it.... As a test, see what happens on server if you put some random DB name

Unfortunately no easy way to get logs, we are looking into options

[virtuallysafe]

Hi Amet.

Yep, had already tried the differing case.

Additional troubleshooting steps:

Tried new (non exiting) video and music db names in the setting GUI, enabled:
No new databases created
"Couldn't open database" error

Killed application

Configured settings again (Server = 192.168.30.20, Username = xbmc, Password = xbmc)
Enabled config again
application hung (symptom, 'Working...' Spinner frozen)
No new databases created

Killed application

FYI, mysql permissions are as follows:

Code: Select all

mysql> SELECT host,user from mysql.user;
+-----------+------+
| host      | user |
+-----------+------+
| %         | xbmc |
| localhost | root |
+-----------+------+
2 rows in set (0.03 sec)

[virtuallysafe]

Further to the above, my MySQL version is 5.5.35.

[amet]

Hm,

its been reported working by others, let's see why it's not working for you.

Check if user "xbmc" is allowed to connect from any ip(or specifically the one ATV is on)

Edit: I see permissions now...

[virtuallysafe]

Check if user "xbmc" is allowed to connect from any ip(or specifically the one ATV is on)

Thanks Amet, to confirm I can ping the ATV address from the SQL Server IP address. So likely no network issues in the way...