Login at Kodi Home

koajx89 · 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:

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:
43:54 T:3038738176  NOTICE: Running database version Addons15

43:54 T:3038738176   DEBUG: Initialize, updating databases...

43:54 T:3038738176  NOTICE: Running database version ViewModes4

43:54 T:3038738176  NOTICE: Running database version Textures13

43:54 T:3038738176   ERROR: Unable to open database: MyMusic32 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic31 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic30 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic29 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic28 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic27 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic26 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic25 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic24 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic23 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic22 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic21 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic20 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic19 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic18 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic17 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic16 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic15 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic14 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic13 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic12 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic11 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic10 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic9 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic8 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic7 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic6 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic5 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic4 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic3 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic2 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic1 [2003](Can't connect to MySQL server on '192.168.1.13' (101))

43:54 T:3038738176   ERROR: Unable to open database: MyMusic [2003](Can't connect to MySQL server on '192.168.1.13' (101))

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 Sad

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 Wink

And BTW Thanks for everything Blush

**Prof Yaffle** · (This post was last modified: 2014-02-19, 20:12 by Prof Yaffle.)

Falling firmly into the "suggestions" camp versus the "someone who actually knows" one...

Your Synology is alive and well as XBMC starts, yes? It's come out of sleep and is ready to face the day?

All client network connections are alive when things get going as well?

You've got a lot of interesting "Connection timed out" messages in there as well, I wonder if they're related.

I'd perhaps try it without the path substitution initially as well, just to lock it down to one thing at a time.

EDIT

Oh, and I also have to ask about IP addresses... your client has a path through to 192.168.1.13, doesn't it? Subnets right, no routers between, same LAN segment, etc.?

koajx89 · 2014-02-19, 20:48

Yes my synology is alive at the same time as when my XBMC starts.

I'd perhaps try it without the path substitution initially as well, (im Not quiet following this or misunderstanding)

Yea they are on the same Network segment only different is that Xbmc connects via Wifi (Should not be any difference i think )

Synology : 192.168.1.13
Xbmc : 192.168.1.12 (Wireless)

sorry if im a total retard here Smile

prae5 · 2014-02-19, 20:52

Given your logs, it really looks like it can't talk to your has - its unable to connect to mysql and similar issue with samba.

Make sure you can ping / connect outside of xbmc.

**Prof Yaffle** · (This post was last modified: 2014-02-19, 21:01 by Prof Yaffle.)

I also noticed this in your advancedsettings.xml - on line 73 of your debug log:

Code:
&gt;&#x0A;

In your snippet above, this appears as:

Code:
<pass>Mypassword</pass>>

Note the extra ">"... so clean that up, just in case - there's a spare newline in there somewhere as well.

My comment about trying it without path substitution was your thumbnail sharing;

Code:
<pathsubstitution>

     <substitute>

      <from>special://masterprofile/Thumbnails/</from>

      <to>smb://admin:Mypassword@diskstation/video/Film/art/</to>

     </substitute>

</pathsubstitution>

If you do have connectivity problems, that won't be helping.

koajx89 · 2014-02-19, 21:24

prae5 : I can connect to my server just fine from othersources etc my Win8 , Iphone (DS App)
It also makes the Folders for the Thumbnails on my share, but after a restart it doesent scan anything into it,

The same happen doe my 2 DB's so strange Undecided

Prof Yaffle: I have corrected the </pass>

And i have excluded the Pathsubstition but that dient work either..

I could try to install XBMC on my win8 machine and just try it out there just to exclude that its not a connection issue ?

ill get back to you unless you have other things i can try ?

**Prof Yaffle** · 2014-02-19, 21:47

Sounds like an XBMCBuntu-specific problem, though - do you know how to switch to a terminal and test from there? Can you map to a share through SMB or NFS/CIFS, can you ping your NAS, can you ssh/telnet to it?

Might be easier to restart into whatever window manager XBMCbuntu comes with - I think it gives the choice of logging into XBMC or into a desktop. That will allow you to browse through SMB more easily.

Do you have any permissions on your Synology shares that might be screwing things up?

jznine · 2014-02-20, 02:28

Are you running DSM 5.0 Beta on your Synology? If so, check http://forum.xbmc.org/showthread.php?tid=184363

koajx89 · 2014-02-20, 20:12

jznine Thanks for the surgestion but atm im running DSM 4.2...

But just for info, i came home from work and thought i would like to try the same advancedsettings.xml on a freshly installed xbmc frodo 12.2 on my win 8 machine <- same version as my XBMCbuntu
i just put in a few movies just to test and after i choose the scrapper. and it started to scan the content i went to myPHPadmin and already saw that there was coming data in my DB

so what im going todo is make a freshly install of my xbmcbuntu (Proberly this weekend Tongue

) and see how it goes from there...

I will come back if i still have issues after the weekend.

but for now thank you all for your help and suggestions :-) i wont mark this solved jet