External Connection Pandora Server

[manu]

Like it

Up

0

Down

Drop it

::

I don’t understand what you meant, do you mean if you can connect to the mysql from a remote location? If so, sure you can.
In the pandora_server.conf just define the IP of the MySQL you want to connect to

[mafelipe]

Like it

Up

0

Down

Drop it

::

I want to know if pandora can use an encrypted mysql connection, so no clear password is sent via internet…

[daniels]

Like it

Up

0

Down

Drop it

::

Hi Mafelipe,

I think this is an issue for mysql/tcp connection, not for pandora….

Anyway, vpn is a good way (as you already known) but you can do this by ssh tunnel too. As far as I know, there isn’t a specific way to treat this inside pandora…

[mafelipe]

Like it

Up

0

Down

Drop it

::

Hi, Im trying with ssh tunnles, and, this is only a comment, shouldnt be better to take out the mysql port to the config file? The problem now is that if the tunnels stops the data servers dies. I also have tried autossh, but no way. I still working on this….

[manu]

Like it

Up

0

Down

Drop it

::

Yeah, it would be useful to put a small option in the pandora_server.conf to allow to change mysql port.
Nowadays the port is set in the code (grep -R “3306” *) so if you want to change it you would need to change it in the code (binary, libraries…)

Obviously if the tunnels dies there is no way to reach the MySQL, in this scenario, as Daniels said, VPN is very likely the best option you can do, ssh-tunneling is also a good approach but it’s not as good as it should be for this matters.

Another shot you can try is just to allow the FW (if there were any) to be able to reach the MySQL remotely and for a certain IP (pandora_server machine)