+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59)
+---- Thread: XBMC/mySQL Not Creating Databases (/showthread.php?tid=136499)
XBMC/mySQL Not Creating Databases - longsh0t - 2012-07-19
A little bit of info on my environment:
Movies and TV Shows in an UnRaid server. Sources in XBMC added as SMB (SMB://mediaserver1/movies, SMB://showserver1/tvshows)
mySQL running in a VM with Windows 7 64-bit. Firewall completely turned off for testing.
XBMC running on Windows 7 64-bit.
I followed the steps in the following wiki to sync up my XBMC installs.
http://wiki.xbmc.org/index.php?title=HOW-TO:Sync_multiple_libraries
I had a question regarding this as I can't seem to get it working. At what point will XBMC create the mySQL databases? As far as I can tell a new database never gets created in mySQL. If I'm reading correctly, XBMC should create a database in the following directory on the VM I'm using for mySQL.
C:\ProgramData\MySQL\MySQL Server 5.5\data
The only databases I see are "mySQL", "test", "performance_schema" and "information_schema" when I run SHOW DATABASES; in the mySQL command prompt. I see nothing related to XBMC.
RE: XBMC/mySQL Not Creating Databases - GavinCampbell - 2012-07-20
Did you modify the advancedsettings.xml file to point to the mysql server?
Check the logs. Maybe its having problems connecting.
XBMC/mySQL Not Creating Databases - jazzyjeff - 2012-07-20
How is your advanced settings laid out?
Do you have the line in the XML file with name? <name>******<\name>
If you do have this line in the videos and music section in the advanced settings remove it. It is not necessary any more since the update of xbmc 11.
Hope this helps.
RE: XBMC/mySQL Not Creating Databases - FranWilder - 2012-09-27
Have you been able to resolve this?
I have the same problem. I am running mysql on linux and my advancesettings.xml looks like this:
Code:
<advancedsettings>
<useddsfanart>true</useddsfanart>
<cputempcommand>cputemp</cputempcommand>
<gputempcommand>gputemp</gputempcommand>
<samba>
<clienttimeout>30</clienttimeout>
</samba>
<network>
<disableipv6>true</disableipv6>
</network>
<videodatabase>
<type>mysql</type>
<host>10.0.0.1<host>
<port>3306</port>
<user>xbmc</user>
<pass>password</pass>
</videodatabase>
</advancedsettings>RE: XBMC/mySQL Not Creating Databases - FranWilder - 2012-09-27
My bad.
I just saw that I missed a "/" in the "</host>" tag.