Re: [RDD] Alternative MySQL port?
On Sunday 05 May 2013 11:04:12 am Cowboy wrote: > In this case, the command would be > ssh -L 3306:localhost:5526 destination I probably should have added that something like ssh -L port:localhost:port localhost does work, but can get confusing. -- Cowboy http://cowboy.cwf1.com "My weight is perfect for my height -- which varies" ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Alternative MySQL port?
On Monday 29 April 2013 12:52:20 pm Wayne Merricks wrote: > Its possible to use ssh tunnels to achieve this if I've understood the > docs correctly. Rivendell would then in theory connect to localhost on > 3306 and the ssh tunnel would forward through to the other server. > I do this for my imap servers all the time, which is why if you check the headers, my e-mail or posts always originate in Akron, Ohio, no matter where in the world ( literally ) I really am. There are some caveats, though. The connecting TTY needs to stay up, else the tunnel collapse without some additional ssh tricks. Although the connection looks local, it's not. It is across the network, though the daemon will never see it. In this case, the command would be ssh -L 3306:localhost:5526 destination where destination is the machine name of the mysql server machine. ( or IP ) The authorized user then supplies the password, and the forward is established. Or, you pre-set the auth keys in the appropriate files. The connection then looks local from both ends of the tunnel. -- Cowboy http://cowboy.cwf1.com "My weight is perfect for my height -- which varies" ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Alternative MySQL port?
Hi, Its possible to use ssh tunnels to achieve this if I've understood the docs correctly. Rivendell would then in theory connect to localhost on 3306 and the ssh tunnel would forward through to the other server. No idea what the performance impact would be but heres a link that seems easy to understand: http://www.howtogeek.com/howto/ubuntu/access-your-mysql-server-remotely-over-ssh/ On 29/04/13 16:33, Fred Gleason wrote: > On Apr 25, 2013, at 15:42 56, Andy Brown wrote: > >> subject pretty much says it all. I need to connect to MySSQL running on >> an alternative port. I tried in /etc/rd.conf by using the colon, but >> this didn't connect. Is there a way of doing this? > Not at present. > > Cheers! > > > |-| > | Frederick F. Gleason, Jr. | Chief Developer | > | | Paravel Systems | > |-| > | A room without books is like a body without a soul.| > | -- Cicero | > |-| > > ___ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Alternative MySQL port?
On 04/29/2013 08:33 AM, Fred Gleason wrote: > On Apr 25, 2013, at 15:42 56, Andy Brown wrote: > >> subject pretty much says it all. I need to connect to MySSQL running on >> an alternative port. I tried in /etc/rd.conf by using the colon, but >> this didn't connect. Is there a way of doing this? > > Not at present. Through iptables? Something like: iptables -t nat -A PREROUTING -p tcp --dport 3306 \ -j REDIRECT --to-port 5526 ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Alternative MySQL port?
On Apr 25, 2013, at 15:42 56, Andy Brown wrote: > subject pretty much says it all. I need to connect to MySSQL running on > an alternative port. I tried in /etc/rd.conf by using the colon, but > this didn't connect. Is there a way of doing this? Not at present. Cheers! |-| | Frederick F. Gleason, Jr. | Chief Developer | | | Paravel Systems | |-| | A room without books is like a body without a soul.| | -- Cicero | |-| ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Alternative MySQL port?
Aha, good thinking. I'll try that this evening. Thanks for the suggestion. Andy On 26/04/13 08:41, MICHAEL SMITH wrote: > I can't remember if this works (but I have seen it somewhere on the net)... > > Try in rd.conf: > Hostname=192.168.55.1 > Port=5026 > > > > > > From: Andy Brown > To: rivendell-dev@lists.rivendellaudio.org > Sent: Thursday, 25 April 2013, 20:42 > Subject: [RDD] Alternative MySQL port? > > > Hi all, > > subject pretty much says it all. I need to connect to MySSQL running on > an alternative port. I tried in /etc/rd.conf by using the colon, but > this didn't connect. Is there a way of doing this? > > [mySQL] > Hostname=192.168.55.1:5026 > Loginname=rduser > Password=letmein > Database=Rivendell > Driver=QMYSQL3 > > Regards, > > > > ___ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev > -- Andy e: andy @ thebmwz3.co.uk w: http://www.thebmwz3.co.uk g: https://github.com/andyb2000/ ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Alternative MySQL port?
I can't remember if this works (but I have seen it somewhere on the net)... Try in rd.conf: Hostname=192.168.55.1 Port=5026 From: Andy Brown To: rivendell-dev@lists.rivendellaudio.org Sent: Thursday, 25 April 2013, 20:42 Subject: [RDD] Alternative MySQL port? Hi all, subject pretty much says it all. I need to connect to MySSQL running on an alternative port. I tried in /etc/rd.conf by using the colon, but this didn't connect. Is there a way of doing this? [mySQL] Hostname=192.168.55.1:5026 Loginname=rduser Password=letmein Database=Rivendell Driver=QMYSQL3 Regards, -- Andy e: andy @ thebmwz3.co.uk e: andy @ broadcast-tech.co.uk w: http://www.thebmwz3.co.uk w: http://www.broadcast-tech.co.uk ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
[RDD] Alternative MySQL port?
Hi all, subject pretty much says it all. I need to connect to MySSQL running on an alternative port. I tried in /etc/rd.conf by using the colon, but this didn't connect. Is there a way of doing this? [mySQL] Hostname=192.168.55.1:5026 Loginname=rduser Password=letmein Database=Rivendell Driver=QMYSQL3 Regards, -- Andy e: andy @ thebmwz3.co.uk e: andy @ broadcast-tech.co.uk w: http://www.thebmwz3.co.uk w: http://www.broadcast-tech.co.uk ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
