Kodi Community Forum

Full Version: 2019 Sony Bravia XG85 - Cannot add Media Library
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi

Have a weird issue with Kodi (both Leia and Krypton).

I've done some fresh installs, and firstly when i upload my Advancedsettings.xml, and reboot the app, its not picking up my content on my SQL server (both my Fire Box and the Mac are seeing the media on the SQL server).

Whats weirder is when i manually add the folder (on a SMB Share) it will not scan the folder. I noticed that when i set the Content Type (movies) and click ok, if i go back into set content, it hasn't retained the setting and is set to None.

any ideas?

Thanks
To receive meaningful assistance you will need to provide a full debug log.

The instructions are here... debug log (wiki)

If you are using the Basic Method, then ensure the following is applied...
1.Enable debugging in Settings>System Settings>Logging,
2.Restart Kodi
3.Replicate the problem.
4.Upload the log to Kodi Paste Site manually or use the Kodi Logfile Uploader. (wiki) With either method post the link to the log back here.

If you are using the Advanced Method ensure you have correctly created and applied the advancedsettings.xml file (wiki)

In both instances, you should see the word DEBUG throughout the log.

Note: Full logs only. No partial or redacted logs
Do NOT post your logs directly into the forum. Use the Kodi Paste Site. Post the link to your pasted log in the forum
Hi

Log file is here:
https://paste.kodi.tv/raxiwagexi.kodi

Thanks
Looks like a permission problem:

Code:
13:40:57.979 T:18446744072873146736   ERROR: Unable to open database: MyVideos107 [1045](Access denied for user 'xbmc'@'192.168.1.2' (using password: YES))

Check your set-up on the MySQL server for that user, that it has correct access priv's both for the username and for the connection source itself (192.168.1.2 in this case).

One or other (or both) would seem to be incorrect.
Thats the thing though. Line 70 shows that my SQL DB is at 192.168.1.4 (all my other devices are able to access this DB using the same XML file that i just pushed to the devices). however Kodi is trying to access 192.168.1.2 (which is the Sony Bravias IP address)
I think you're misreading it. The error is saying that the user (xbmc) coming from 192.168.1.2 (the Bravia) doesn't have permission to access the database. That's what the 'xbmc'@'192.168.1.2' means.

If other devices are using the same file, then that says to me that your user is OK, but the available clients it can access from is not. The second step for setting up privs is

Code:
GRANT ALL ON *.* TO 'kodi';


or in your case 'xbmc' which is most likely not done correctly in this case. The the wiki MySQL (wiki) pages for details on how to set things up in detail.