Kodi Community Forum
SQL database connection issue with vpn - Printable Version

+- 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: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: SQL database connection issue with vpn (/showthread.php?tid=309069)



SQL database connection issue with vpn - Ravalyn - 2017-03-08

I've had a lot of success setting up SQL for my local Kodi machines. All was well until I started using a VPN on some of the machines. I've noticed that if I'm connected to the VPN, then launch Kodi, the system hangs at the splash screen. I'm assuming it is having trouble connecting to the IP address of my local MySQL server. If I remove the SQL connection from advancedsettings.XML. I can boot into Kodi and use the VPN connection. Anyone else experience this issue and is there a good solution for it?


RE: SQL database connection issue with vpn - TRaSH - 2017-03-08

A VPN should interfere with a local connection,
So something isn't setup right

Verstuurd vanaf mijn GT-I9505 met Tapatalk


RE: SQL database connection issue with vpn - nickr - 2017-03-08

Nor is a VPN necessary for Kodi.


RE: SQL database connection issue with vpn - Ravalyn - 2017-03-08

I understand that a VPN isn't necessary. Using Kodi to look at still photos isn't necessary, but it's still useful. Using a VPN would be useful, I would simply like to figure out how to make it less cumbersome while using an SQL database. Can I set the host IP to my ddns address that points to my SQL server?


RE: SQL database connection issue with vpn - Prof Yaffle - 2017-03-08

Leaving aside whether a VPN is necessary...

This is a combination of local network settings and VPN configuration. It sounds like all traffic is being routed into the VPN tunnel, which is why you can see no local devices - including any local sources, by the way. You need split tunneling to keep LAN traffic local, or you need the VPN to act from your egress point (i.e. your router/modem) instead of per-client.

If you want to route out of your network and back in again... ugh. Apart from port forwarding fun, you're likely to get latency issues, I would expect.


RE: SQL database connection issue with vpn - jjulien31 - 2018-08-02

Same issue, any resolve? wondering if there was an easy way to make advanced settingsĀ  file an easy toggle on/off