SSL Connections to MySQL

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

SSL Connections to MySQL

Daniel Logue
Hi list,

Does anyone know how to configure LP8.6 to connect to MySQL over SSL?

Thanks,
Daniel

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SSL Connections to MySQL

Ke Carlton-3
Not directly via SSL — but using a VPN would have a similar effect.

On Wed, Dec 21, 2016 at 12:26 PM Daniel Logue <[hidden email]> wrote:

> Hi list,
>
> Does anyone know how to configure LP8.6 to connect to MySQL over SSL?
>
> Thanks,
> Daniel
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SSL Connections to MySQL

Johan Solve
You can set up an SSL tunnel on your web server and connect through that.

Essentially ssh -NC2f -L 3306:remotehost:3306 user@remotehost

Point Lasso’s MySQL host setting to 127.0.0.1 and it will be tunneled to
remotehost.
If 3306 is not available on the local host use any other port for the first
part and tell Lasso to connect on that port instead.


Keep it alive with a script like this (requires SSH shared key so password
is not needed)

#! /bin/bash

while [ 1 ]; do
   ssh -NC2 -L 3306:remotehost:3306 user@remotehost

 sleep 5
done

On 21 December 2016 at 01:57, Ke Carlton <[hidden email]> wrote:

> Not directly via SSL — but using a VPN would have a similar effect.
>
> On Wed, Dec 21, 2016 at 12:26 PM Daniel Logue <[hidden email]> wrote:
>
> > Hi list,
> >
> > Does anyone know how to configure LP8.6 to connect to MySQL over SSL?
> >
> > Thanks,
> > Daniel
> >
> > #############################################################
> >
> > This message is sent to you because you are subscribed to
> >   the mailing list Lasso [hidden email]
> > Official list archives available at http://www.lassotalk.com
> > To unsubscribe, E-mail to: <[hidden email]>
> > Send administrative queries to  <[hidden email]>
> >
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SSL Connections to MySQL

Johan Solve
Er, I mean SSH tunnel...

On 21 December 2016 at 08:30, Johan Solve <[hidden email]> wrote:

> You can set up an SSL tunnel on your web server and connect through that.
>
> Essentially ssh -NC2f -L 3306:remotehost:3306 user@remotehost
>
> Point Lasso’s MySQL host setting to 127.0.0.1 and it will be tunneled to
> remotehost.
> If 3306 is not available on the local host use any other port for the
> first part and tell Lasso to connect on that port instead.
>
>
> Keep it alive with a script like this (requires SSH shared key so password
> is not needed)
>
> #! /bin/bash
>
> while [ 1 ]; do
>    ssh -NC2 -L 3306:remotehost:3306 user@remotehost
>
>  sleep 5
> done
>
> On 21 December 2016 at 01:57, Ke Carlton <[hidden email]> wrote:
>
>> Not directly via SSL — but using a VPN would have a similar effect.
>>
>> On Wed, Dec 21, 2016 at 12:26 PM Daniel Logue <[hidden email]> wrote:
>>
>> > Hi list,
>> >
>> > Does anyone know how to configure LP8.6 to connect to MySQL over SSL?
>> >
>> > Thanks,
>> > Daniel
>> >
>> > #############################################################
>> >
>> > This message is sent to you because you are subscribed to
>> >   the mailing list Lasso [hidden email]
>> > Official list archives available at http://www.lassotalk.com
>> > To unsubscribe, E-mail to: <[hidden email]>
>> > Send administrative queries to  <[hidden email]>
>> >
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>>   the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
>
>
> --
> Mvh
> Johan Sölve
> ____________________________________
> Montania System AB
> Halmstad   Stockholm
> http://www.montania.se
>
> Johan Sölve
> Mobil +46 709-51 55 70
> [hidden email]
>
> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 <035-13%2068%2000> |  Fax +46 35-136801
> <035-13%2068%2001>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SSL Connections to MySQL

Johan Solve
Duh, I now see that the question was about MySQL over SSL, not SSH. Double
freudian slip.

On 21 December 2016 at 08:47, Johan Solve <[hidden email]> wrote:

> Er, I mean SSH tunnel...
>
> On 21 December 2016 at 08:30, Johan Solve <[hidden email]> wrote:
>
>> You can set up an SSL tunnel on your web server and connect through that.
>>
>> Essentially ssh -NC2f -L 3306:remotehost:3306 user@remotehost
>>
>> Point Lasso’s MySQL host setting to 127.0.0.1 and it will be tunneled to
>> remotehost.
>> If 3306 is not available on the local host use any other port for the
>> first part and tell Lasso to connect on that port instead.
>>
>>
>> Keep it alive with a script like this (requires SSH shared key so
>> password is not needed)
>>
>> #! /bin/bash
>>
>> while [ 1 ]; do
>>    ssh -NC2 -L 3306:remotehost:3306 user@remotehost
>>
>>  sleep 5
>> done
>>
>> On 21 December 2016 at 01:57, Ke Carlton <[hidden email]> wrote:
>>
>>> Not directly via SSL — but using a VPN would have a similar effect.
>>>
>>> On Wed, Dec 21, 2016 at 12:26 PM Daniel Logue <[hidden email]> wrote:
>>>
>>> > Hi list,
>>> >
>>> > Does anyone know how to configure LP8.6 to connect to MySQL over SSL?
>>> >
>>> > Thanks,
>>> > Daniel
>>> >
>>> > #############################################################
>>> >
>>> > This message is sent to you because you are subscribed to
>>> >   the mailing list Lasso [hidden email]
>>> > Official list archives available at http://www.lassotalk.com
>>> > To unsubscribe, E-mail to: <[hidden email]>
>>> > Send administrative queries to  <[hidden email]>
>>> >
>>>
>>> #############################################################
>>>
>>> This message is sent to you because you are subscribed to
>>>   the mailing list Lasso [hidden email]
>>> Official list archives available at http://www.lassotalk.com
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>>
>>
>>
>>
>> --
>> Mvh
>> Johan Sölve
>> ____________________________________
>> Montania System AB
>> Halmstad   Stockholm
>> http://www.montania.se
>>
>> Johan Sölve
>> Mobil +46 709-51 55 70
>> [hidden email]
>>
>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>> Telefon +46 35-136800 <035-13%2068%2000> |  Fax +46 35-136801
>> <035-13%2068%2001>
>>
>
>
>
> --
> Mvh
> Johan Sölve
> ____________________________________
> Montania System AB
> Halmstad   Stockholm
> http://www.montania.se
>
> Johan Sölve
> Mobil +46 709-51 55 70
> [hidden email]
>
> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> Telefon +46 35-136800 <035-13%2068%2000> |  Fax +46 35-136801
> <035-13%2068%2001>
>



--
Mvh
Johan Sölve
____________________________________
Montania System AB
Halmstad   Stockholm
http://www.montania.se

Johan Sölve
Mobil +46 709-51 55 70
[hidden email]

Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
Telefon +46 35-136800 |  Fax +46 35-136801

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Loading...