2013-01-13, 00:32
Hi All,
First time post here so I'll try and give all the info for someone to help me out hopefully.
Windows 7 32bit PC with Frodo RC3 installed.
unRaid Server with Mysql 5.0.67 installed.
XBMC was working fine, but now I need to setup sharing info via DB, I followed the instructions from the Wiki:
http://wiki.xbmc.org/index.php?title=HOW..._libraries
advancedsettings.xml file is as below and has been put in C:\Users\MyUser\AppData\Roaming\XBMC\userdata\
The user xbmc has full rights to do ANYTHING it wants within mysql and can do it from ANY location (localhost, any IP, %).
Port 3306 is allowed in and out from and to any source / destination on my Win 7 PC, I have no other firewalls or restrictions on the unRaid server.
I have tested the xbmc mysql user by creating tables etc from my Win 7 PC using MySQL Workbench and it can do what it needs to: http://www.mysql.com/products/workbench/
I have tried this without doing Export / Import and also with doing it.
I have completely removed XBMC and started from scratch.
No matter what I do this happens:
First time open, 2 DBs (MyVideos75 & MyMusic32) are created but No tables / contents are created.
pre_crash_xbmc_debug.log: http://xbmclogs.com/show.php?id=27725
If I leave this and restart XBMC it crashes when starting up
post_crash_xbmc_debug.log: http://xbmclogs.com/show.php?id=27727
At this point it also created an error file called "xbmc_crashlog-12.0-RC3 Git_20130102-7a6cb7f-20130112-222423" (not sure how to get this onto the forum if needed?)
To get back into xbmc I have to DROP the databases that it created and then it just repeats the above issue.
I would really appreciate any help with this. If I have missed any info that would be useful please let me know. Also be good to know if anyone has got it to work on same as my setup.
First time post here so I'll try and give all the info for someone to help me out hopefully.
Windows 7 32bit PC with Frodo RC3 installed.
unRaid Server with Mysql 5.0.67 installed.
XBMC was working fine, but now I need to setup sharing info via DB, I followed the instructions from the Wiki:
http://wiki.xbmc.org/index.php?title=HOW..._libraries
advancedsettings.xml file is as below and has been put in C:\Users\MyUser\AppData\Roaming\XBMC\userdata\
Quote:<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.120</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.120</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
</advancedsettings>
The user xbmc has full rights to do ANYTHING it wants within mysql and can do it from ANY location (localhost, any IP, %).
Port 3306 is allowed in and out from and to any source / destination on my Win 7 PC, I have no other firewalls or restrictions on the unRaid server.
I have tested the xbmc mysql user by creating tables etc from my Win 7 PC using MySQL Workbench and it can do what it needs to: http://www.mysql.com/products/workbench/
I have tried this without doing Export / Import and also with doing it.
I have completely removed XBMC and started from scratch.
No matter what I do this happens:
First time open, 2 DBs (MyVideos75 & MyMusic32) are created but No tables / contents are created.
pre_crash_xbmc_debug.log: http://xbmclogs.com/show.php?id=27725
If I leave this and restart XBMC it crashes when starting up
post_crash_xbmc_debug.log: http://xbmclogs.com/show.php?id=27727
At this point it also created an error file called "xbmc_crashlog-12.0-RC3 Git_20130102-7a6cb7f-20130112-222423" (not sure how to get this onto the forum if needed?)
To get back into xbmc I have to DROP the databases that it created and then it just repeats the above issue.
I would really appreciate any help with this. If I have missed any info that would be useful please let me know. Also be good to know if anyone has got it to work on same as my setup.