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
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.