2014-02-19, 19:27
Hi XBMC community,
I have been pulling my hair out the last 2 nights, to get XBMC to write into my DB i get errors from the Debug log which i have searched for but the things i found didn't help. so maybe some can help me with my issue..
I have a user which i have granted Full the access needed on myPHPadmin with the wildcards and everything to write the into the DB's it will create.
My setup:
XBMCbuntu Frodo 12.2 <- i know there is a 12.3
myPHPadmin
(I changed all the passwords to Mypassword in these post so bare with if there is an error in the logs with passwords but i have checked them IRL)
1. I have Advancedsettings.xml which looks like this:
2. When restarting the XBMC client, it creates "DB's" on myPHPadmin called "MyMusic32" and "MyVideos75" Thats also fine for me.
3. but nothing came in the "DB's" so After another restarting there still doesn't come anything in the "DB's" so i thought ill try Debug mode on the XBMC - then after another restart i looked in the xbmc.log file and found something strange as you can see below it says allot of ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.1.13' (101)) and so fourth. which is strange as it could build the "DB's" ??
4. Then i searched for this kind of error's and found this thread but that was not my case i also found some older threads but those wheres something about "nightly" builds..
http://forum.xbmc.org/showthread.php?tid=148936
And here is the full Debug log..
PasteBin
I hope someone has some suggestions ? as i have almost no hair left
And BTW Thanks for everything
I have been pulling my hair out the last 2 nights, to get XBMC to write into my DB i get errors from the Debug log which i have searched for but the things i found didn't help. so maybe some can help me with my issue..
I have a user which i have granted Full the access needed on myPHPadmin with the wildcards and everything to write the into the DB's it will create.
My setup:
XBMCbuntu Frodo 12.2 <- i know there is a 12.3
myPHPadmin
(I changed all the passwords to Mypassword in these post so bare with if there is an error in the logs with passwords but i have checked them IRL)
1. I have Advancedsettings.xml which looks like this:
Code:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.13</host>
<port>3306</port>
<user>xbmc</user>
<pass>Mypassword</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.13</host>
<port>3306</port>
<user>xbmc</user>
<pass>Mypassword</pass>>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails/</from>
<to>smb://admin:Mypassword@diskstation/video/Film/art/</to>
</substitute>
</pathsubstitution>
</advancedsettings>
2. When restarting the XBMC client, it creates "DB's" on myPHPadmin called "MyMusic32" and "MyVideos75" Thats also fine for me.
3. but nothing came in the "DB's" so After another restarting there still doesn't come anything in the "DB's" so i thought ill try Debug mode on the XBMC - then after another restart i looked in the xbmc.log file and found something strange as you can see below it says allot of ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.1.13' (101)) and so fourth. which is strange as it could build the "DB's" ??
Code:
17:43:54 T:3038738176 NOTICE: Running database version Addons15
17:43:54 T:3038738176 DEBUG: Initialize, updating databases...
17:43:54 T:3038738176 NOTICE: Running database version ViewModes4
17:43:54 T:3038738176 NOTICE: Running database version Textures13
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic31 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic30 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic29 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic28 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic27 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic26 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic25 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic24 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic23 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic22 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic21 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic20 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic19 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic18 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic17 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic16 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic15 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic14 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic13 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic12 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic11 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic10 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic9 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic8 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic7 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic6 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic5 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic4 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic3 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic2 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic1 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic [2003](Can't connect to MySQL server on '192.168.1.13' (101))
17:43:54 T:3038738176 ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.1.13' (101))
4. Then i searched for this kind of error's and found this thread but that was not my case i also found some older threads but those wheres something about "nightly" builds..
http://forum.xbmc.org/showthread.php?tid=148936
And here is the full Debug log..
PasteBin
I hope someone has some suggestions ? as i have almost no hair left
And BTW Thanks for everything