+- 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: Linux (https://forum.kodi.tv/forumdisplay.php?fid=52)
+---- Thread: Problem accessing databases remotely (/showthread.php?tid=192612)
Problem accessing databases remotely - justinstreet - 2014-04-19
I am having a problem accessing my xbmc libraries remotely. I have a mysql database running on a linux mint machine which works well with other clients that are on my network. Connecting to the databases remotely (on an android phone) seems to work fine (i can browse my movies and tv shows and all the art loads) but when I try to play something I get an error stating that the file is no longer available and asks me if I want to remove it from the library.
I have all my paths as NAT IP addresses rather than host names and everything is running gotham beta 3. i use no authentication for my samba shares and the mysql user is granted all permissions for *.*.
Error log from Android phone
anyone have theirs working remotely? thanks...
RE: Problem accessing databases remotely - Milhouse - 2014-04-19
Code:
10:35:41 T:2032154824 INFO: FileSmb->Open: Unable to open file : 'smb://192.168.2.15/Movies/Lone%20Survivor%20(2013)/Lone%20Survivor%20(2013).mkv'
unix_err:'6e' error : 'Connection timed out'Nothing to do with MySQL, fix your SMB server/connection.
A quick Google on that error turns up this thread, not sure if it's relevant or not, probably not as you're using IP address - is your server awake?
RE: Problem accessing databases remotely - justinstreet - 2014-04-19
I figured it wasn't mysql because I can login to mysql remotely and it has no problem displaying my libraries in xbmc. The main machine is always awake.
I can be connected to my wifi on my Android and access those libraries like it's any local client computer but if I disconnect the wifi and use my 4g connection it throws the error. Maybe because the IP address of the phone isn't on the 192.168.2.XXX subnet at that point? I dunno...
Re: Problem accessing databases remotely - nickr - 2014-04-19
You got it. Get some sort of SSH tunnelling or vpn set up. Do not expose smb to the internet at large. Just don't.
RE: Problem accessing databases remotely - Milhouse - 2014-04-19
If you're doing this over the internet you definitely won't be able to access a 192.168.x.x address directly, and as nickr suggests, exposing smb to the internet is a bad idea.
Re: Problem accessing databases remotely - nickr - 2014-04-19
In fact you must have MySQL exposed to the internet which is also a bad bad idea.
RE: Problem accessing databases remotely - justinstreet - 2014-04-20
setup an openvpn server. works like a champ and was able to stop forwarding a bunch of ports on the router in the process. thanks.