Kodi Community Forum

Hi All,

I am currently using XBMC 12.0 running on Ubuntu 12.04 with MYSQL 5.5. The problem i am having is that after following this --> http://wiki.xbmc.org/index.php?title=HOW..._libraries

the library no longer scrapes files, it just runs for less than a second and then stops. So basically the database isnt being created and also the content isnt scanning to the library.

please see my advancedsettings.xml and sources.xml below. any hape would be greatly appreciated.

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.2.3</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.2.3</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>

<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>


<sources>
<programs>
<default pathversion="1"></default>
</programs>
<video>
<default pathversion="1"></default>
<source>
<name>TV Shows</name>
<path pathversion="1">smb://XBMC/Agatha/TV Shows/</path>
<path pathversion="1">smb://XBMC/Elenore/TV Shows/</path>
</source>
<source>
<name>Videos</name>
<path pathversion="1">smb://XBMC/Agatha/Videos/</path>
<path pathversion="1">smb://XBMC/Bertha/videos/</path>
<path pathversion="1">smb://XBMC/Charlene/Video/</path>
<path pathversion="1">smb://XBMC/Elenore/Videos/</path>
</source>
</video>
<music>
<default pathversion="1"></default>
</music>
<pictures>
<default pathversion="1"></default>
</pictures>
<files>
<default pathversion="1"></default>
</files>
</sources>

Debug log (wiki) needed of when it attempts to update the library.

from XBMC or mysql?

XBMC

Hi Ned Scott,

thanks in advance for your help with this, from looking at the log i can see that there is a permission problem with xbmc.local not having permission to the mysql database, however i wouldnt have a clue how to resolve this. any help would be greatly appreciated.

http://xbmclogs.com/show.php?id=2023

Thanks again!

Solved!

The user that was created with mysql 'xbmc' didnt have the correct permissions to access mysql.

i installed phpmyadmin and followed the instructions on the video link below to grant access.

http://www.youtube.com/watch?v=U6PPouAnnpY

it is now working perfectly!!!

thanks Ned Scott for all of your help anyways!