Re: 8.6 to FMS via SSL [SOLVED]
- 1 Messages
- Collapse All
- Expand All
- Subscribe
Apr 30
Maxwell Klein Re: 8.6 to FMS via SSL [SOLVED]
Apr 30, 2014; 18:57
Maxwell Klein
Re: 8.6 to FMS via SSL [SOLVED]
Hot dam, thanks Ke (and Johan). I=92ve now got a Lasso 8.6 FileMaker connector working via localhost on port 8080 that=92s tunneling to the remote Mac FileMaker 12 Server=92s port 80.
Thanks again,
Max
On Apr 30, 2014, at 3:30 PM, Ke Carlton <ke@zeroloop.com> wrote:
> Flavour of linux doesn't really matter for this:
>
> http://www.brandonchecketts.com/archives/creating-a-permanent-ssh-tunnel-between-linux-servers
>
>
>
> On 1 May 2014 04:41, Maxwell Klein <lists@maxkdev.com> wrote:
>
>> Hi Johan,
>>
>> A local reverse proxy is an interesting idea, I=92ve set one up only once
>> before.
>>
>> For the SSH connection, how exactly do you have that set up? I=92ve
>> established SSH connections from a Mac to Linux for ODBC to MySQL. Used to
>> do it via Terminal, but then found this handy app:
>>
>> https://itunes.apple.com/us/app/ssh-tunnel/id734418810?mt=12
>>
>> But I=92ve not setup an SSH connection from Linux to a Mac. What does the
>> SSH command look like and is there anything I need to do on the FMS side?
>> And how do you make sure it=92s always open?
>>
>> Thanks,
>> Max
>>
>>
>>
>> On Apr 29, 2014, at 11:18 PM, Johan Solve <johan.solve@gmail.com> wrote:
>>
>>> An SSH tunnel might be easier to setup and keep up than VPN. We use that
>>> for FMS connections over WAN in a few cases, works excellent.
>>> A local reverse proxy might also be workable, although I haven't tried
>>> that.
>>>
>>>
>>> 2014-04-27 22:40 GMT+02:00 Steve Piercy - Web Site Builder <
>>> Web@stevepiercy.com>:
>>>
>>>> Instead of the FM connector, have you tried the ODBC connector?
>>>>
>>>> --steve
>>>>
>>>>
>>>> On 4/27/14 at 1:10 PM, lists@maxkdev.com (Maxwell Klein) pronounced:
>>>>
>>>>> Yep, construct the manual URL often for monitoring systems to ensure
>>>> certain
>>>>> databases are open, and always with HTTPS - works fine there and
>>>> manually in
>>>>> browsers, just not via Lasso 8.6 connector.
>>>>>
>>>>> May just put in a call to LassoSoft support on Monday and see if they
>>>> have any
>>>>> suggestions.
>>>>>
>>>>> Thanks,
>>>>> Max
>>>>>
>>>>> On Apr 27, 2014, at 11:04 AM, Steve Piercy - Web Site Builder
>>>> <Web@StevePiercy.com>
>>>>> wrote:
>>>>>
>>>>>> Make sure that the FMS server accepts connections over 443, or
>>>> whatever port is
>>>>> configured on that server to accept HTTPS. Do so by manually
>>>> constructing the
>>>>> request URL from XML query string that you get from action_param and
>> the
>>>> host. In
>>>>> other words, bypass Lasso and go directly to the FMS.
>>>>>>
>>>>>> --steve
>>>>>>
>>>>>>
>>>>>> On 4/27/14 at 1:18 AM, lists@maxkdev.com (Maxwell Klein) pronounced:
>>>>>>
>>>>>>> No luck. Got -Host working with -port=80 just fine, but switching to
>>>> -port=443
>>>>> gives:
>>>>>>>
>>>>>>> Error_Msg: Error while performing FileMaker database -search action.
>>>> Find
>>>>> criteria are empty.
>>>>>>> Error_Code: 400
>>>>>>>
>>>>>>> No amount of tweaking the inline params seemed to make a difference.
>>>>>>>
>>>>>>> Will try the ODBC connector next, but switching to Lasso 9 could be
>>>> in the cards
>>>>> as well.
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Max
>>>>>>>
>>>>>>>
>>>>>>> On Apr 26, 2014, at 2:30 PM, Steve Piercy - Web Site Builder
>>>>> <Web@StevePiercy.com> wrote:
>>>>>>>
>>>>>>>> Have you tried either using -host=array(connection stuff with
>>>> -port=443) in
>>>>> your
>>>>>>> inline?
>>>>>>>>
>>>>>>>> Instead of the Lasso's FMS connector, have you tried ODBC as the
>>>> connector?
>>>>>>>>
>>>>>>>> --steve
>>>>>>>>
>>>>>>>>
>>>>>>>> On 4/26/14 at 1:39 PM, lists@maxkdev.com (Maxwell Klein)
>> pronounced:
>>>>>>>>
>>>>>>>>> Lasso 8.6 on CentOS 6 (virtualized)
>>>>>>>>> FileMaker 12 on Mac OS X 10.8
>>>>>>>>> Need to setup a Lasso 8.6 connector to FileMaker Server over a
>>>> WAN. I know
>>>>> this isn=92t ideal and take a performance hit, but the two LANs are just
>>>> one hop
>>>>> from
>>>>>>> each
>>>>>>>>> other. There=92s minimal risk with the one hop but ideally want the
>>>> WAN
>>>>> connection
>>>>>>> to
>>>>>>>>> be secure.
>>>>>>>>> I=92ve tested this a couple of times with no luck, but wanted to
>>>> confirm that
>>>>>>> Lasso
>>>>>>>>> 8.6 *cannot* talk to FileMaker Server via HTTPS/SSL on port 443.
>>>> There was a
>>>>>>> Lasso
>>>>>>>>> 9.2.6 release that added "Filemaker datasource SSL support. It now
>>>> checks for
>>>>>>> port
>>>>>>>>> 443 and will do https in that case.=94 Is there a way to add this
>>>> functionality
>>>>> to 8.6?
>>>>>>>>> If HTTPS/SSL isn=92t possible, should I be looking into OpenVPN or
>>>> something
>>>>> else
>>>>>>> to
>>>>>>>>> run on the CentOS machine? The Mac FileMaker Server is already
>>>> running an L2TP
>>>>>>> VPN.
>>>>>>>>> Much appreciated,
>>>>>>>>> Max
>>>>>>>>> #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com
>>>
>>>>>>>>
>>>>>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>>>>> Steve Piercy Web Site Builder Soquel, CA
>>>>>>>> <web@StevePiercy.com> <http://www.StevePiercy.com/
>>>
>>>>>>>>
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>>>>
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>>>
>>>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>>> Steve Piercy Web Site Builder Soquel, CA
>>>>>> <web@StevePiercy.com> <http://www.StevePiercy.com/>
>>>>>>
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>>
>>>>> #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>> Official list archives available at http://www.lassotalk.com
>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>
>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>> Steve Piercy Web Site Builder Soquel, CA
>>>> <web@StevePiercy.com> <http://www.StevePiercy.com/>
>>>>
>>>> #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>> Official list archives available at http://www.lassotalk.com
>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>
>>>
>>>
>>>
>>> --
>>> Mvh
>>> Johan S=F6lve
>>> ____________________________________
>>> Montania System AB
>>> Halmstad Stockholm
>>> http://www.montania.se
>>>
>>> Johan S=F6lve
>>> Mobil +46 709-51 55 70
>>> johan@montania.se
>>>
>>> Kristinebergsv=E4gen 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 Lasso@lists.lassosoft.com
>>> Official list archives available at http://www.lassotalk.com
>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso Lasso@lists.lassosoft.com
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list Lasso Lasso@lists.lassosoft.com
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
> Send administrative queries to <Lasso-request@lists.lassosoft.com>
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Thanks again,
Max
On Apr 30, 2014, at 3:30 PM, Ke Carlton <ke@zeroloop.com> wrote:
> Flavour of linux doesn't really matter for this:
>
> http://www.brandonchecketts.com/archives/creating-a-permanent-ssh-tunnel-between-linux-servers
>
>
>
> On 1 May 2014 04:41, Maxwell Klein <lists@maxkdev.com> wrote:
>
>> Hi Johan,
>>
>> A local reverse proxy is an interesting idea, I=92ve set one up only once
>> before.
>>
>> For the SSH connection, how exactly do you have that set up? I=92ve
>> established SSH connections from a Mac to Linux for ODBC to MySQL. Used to
>> do it via Terminal, but then found this handy app:
>>
>> https://itunes.apple.com/us/app/ssh-tunnel/id734418810?mt=12
>>
>> But I=92ve not setup an SSH connection from Linux to a Mac. What does the
>> SSH command look like and is there anything I need to do on the FMS side?
>> And how do you make sure it=92s always open?
>>
>> Thanks,
>> Max
>>
>>
>>
>> On Apr 29, 2014, at 11:18 PM, Johan Solve <johan.solve@gmail.com> wrote:
>>
>>> An SSH tunnel might be easier to setup and keep up than VPN. We use that
>>> for FMS connections over WAN in a few cases, works excellent.
>>> A local reverse proxy might also be workable, although I haven't tried
>>> that.
>>>
>>>
>>> 2014-04-27 22:40 GMT+02:00 Steve Piercy - Web Site Builder <
>>> Web@stevepiercy.com>:
>>>
>>>> Instead of the FM connector, have you tried the ODBC connector?
>>>>
>>>> --steve
>>>>
>>>>
>>>> On 4/27/14 at 1:10 PM, lists@maxkdev.com (Maxwell Klein) pronounced:
>>>>
>>>>> Yep, construct the manual URL often for monitoring systems to ensure
>>>> certain
>>>>> databases are open, and always with HTTPS - works fine there and
>>>> manually in
>>>>> browsers, just not via Lasso 8.6 connector.
>>>>>
>>>>> May just put in a call to LassoSoft support on Monday and see if they
>>>> have any
>>>>> suggestions.
>>>>>
>>>>> Thanks,
>>>>> Max
>>>>>
>>>>> On Apr 27, 2014, at 11:04 AM, Steve Piercy - Web Site Builder
>>>> <Web@StevePiercy.com>
>>>>> wrote:
>>>>>
>>>>>> Make sure that the FMS server accepts connections over 443, or
>>>> whatever port is
>>>>> configured on that server to accept HTTPS. Do so by manually
>>>> constructing the
>>>>> request URL from XML query string that you get from action_param and
>> the
>>>> host. In
>>>>> other words, bypass Lasso and go directly to the FMS.
>>>>>>
>>>>>> --steve
>>>>>>
>>>>>>
>>>>>> On 4/27/14 at 1:18 AM, lists@maxkdev.com (Maxwell Klein) pronounced:
>>>>>>
>>>>>>> No luck. Got -Host working with -port=80 just fine, but switching to
>>>> -port=443
>>>>> gives:
>>>>>>>
>>>>>>> Error_Msg: Error while performing FileMaker database -search action.
>>>> Find
>>>>> criteria are empty.
>>>>>>> Error_Code: 400
>>>>>>>
>>>>>>> No amount of tweaking the inline params seemed to make a difference.
>>>>>>>
>>>>>>> Will try the ODBC connector next, but switching to Lasso 9 could be
>>>> in the cards
>>>>> as well.
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Max
>>>>>>>
>>>>>>>
>>>>>>> On Apr 26, 2014, at 2:30 PM, Steve Piercy - Web Site Builder
>>>>> <Web@StevePiercy.com> wrote:
>>>>>>>
>>>>>>>> Have you tried either using -host=array(connection stuff with
>>>> -port=443) in
>>>>> your
>>>>>>> inline?
>>>>>>>>
>>>>>>>> Instead of the Lasso's FMS connector, have you tried ODBC as the
>>>> connector?
>>>>>>>>
>>>>>>>> --steve
>>>>>>>>
>>>>>>>>
>>>>>>>> On 4/26/14 at 1:39 PM, lists@maxkdev.com (Maxwell Klein)
>> pronounced:
>>>>>>>>
>>>>>>>>> Lasso 8.6 on CentOS 6 (virtualized)
>>>>>>>>> FileMaker 12 on Mac OS X 10.8
>>>>>>>>> Need to setup a Lasso 8.6 connector to FileMaker Server over a
>>>> WAN. I know
>>>>> this isn=92t ideal and take a performance hit, but the two LANs are just
>>>> one hop
>>>>> from
>>>>>>> each
>>>>>>>>> other. There=92s minimal risk with the one hop but ideally want the
>>>> WAN
>>>>> connection
>>>>>>> to
>>>>>>>>> be secure.
>>>>>>>>> I=92ve tested this a couple of times with no luck, but wanted to
>>>> confirm that
>>>>>>> Lasso
>>>>>>>>> 8.6 *cannot* talk to FileMaker Server via HTTPS/SSL on port 443.
>>>> There was a
>>>>>>> Lasso
>>>>>>>>> 9.2.6 release that added "Filemaker datasource SSL support. It now
>>>> checks for
>>>>>>> port
>>>>>>>>> 443 and will do https in that case.=94 Is there a way to add this
>>>> functionality
>>>>> to 8.6?
>>>>>>>>> If HTTPS/SSL isn=92t possible, should I be looking into OpenVPN or
>>>> something
>>>>> else
>>>>>>> to
>>>>>>>>> run on the CentOS machine? The Mac FileMaker Server is already
>>>> running an L2TP
>>>>>>> VPN.
>>>>>>>>> Much appreciated,
>>>>>>>>> Max
>>>>>>>>> #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com
>>>
>>>>>>>>
>>>>>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>>>>> Steve Piercy Web Site Builder Soquel, CA
>>>>>>>> <web@StevePiercy.com> <http://www.StevePiercy.com/
>>>
>>>>>>>>
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>>>>
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>>>
>>>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>>> Steve Piercy Web Site Builder Soquel, CA
>>>>>> <web@StevePiercy.com> <http://www.StevePiercy.com/>
>>>>>>
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>>
>>>>> #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>>> Official list archives available at http://www.lassotalk.com
>>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>
>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>> Steve Piercy Web Site Builder Soquel, CA
>>>> <web@StevePiercy.com> <http://www.StevePiercy.com/>
>>>>
>>>> #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso Lasso@lists.lassosoft.com
>>>> Official list archives available at http://www.lassotalk.com
>>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>>>
>>>
>>>
>>>
>>> --
>>> Mvh
>>> Johan S=F6lve
>>> ____________________________________
>>> Montania System AB
>>> Halmstad Stockholm
>>> http://www.montania.se
>>>
>>> Johan S=F6lve
>>> Mobil +46 709-51 55 70
>>> johan@montania.se
>>>
>>> Kristinebergsv=E4gen 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 Lasso@lists.lassosoft.com
>>> Official list archives available at http://www.lassotalk.com
>>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso Lasso@lists.lassosoft.com
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>> Send administrative queries to <Lasso-request@lists.lassosoft.com>
>>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list Lasso Lasso@lists.lassosoft.com
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
> Send administrative queries to <Lasso-request@lists.lassosoft.com>
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Search
Thread Keywords
No keywords defined. Log in to define appropriate keywords
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!