Lasso 8.5 and FileMaker 17

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

Lasso 8.5 and FileMaker 17

James Sheffer
Am I barking up a wrong tree or does anyone know if Lasso 8.5 can connect to FileMaker 17?

I’ve tried both FileMaker connector and ODBC connector.  I opened both ports 591 and 5003 in the firewall and then tried moving the FM client machine to the DMZ but cannot see any databases.

Thanks!



James Sheffer
[hidden email]
www.higherpowered.com
469-256-0268






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

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
|

Re: Lasso 8.5 and FileMaker 17

maxwellk2
Hi James,

Which install of FileMaker 17 are you trying to connect to, Server or Pro Advanced?

I don't have an install of Lasso 8.5, but I can confirm Lasso 8.6 does work with FileMaker *Server* 17. If you're trying to connect to Pro Advanced I would suggest installing FileMaker Server and using the "Lasso Connector for FileMaker SA", which requires port 80 to be open on the FileMaker Server and XML enabled via the command line, documented here by 360works.com:

        http://docs.360works.com/index.php/Enable_XML_FileMaker_17

Connecting Lasso to FileMaker Server via ODBC is possible, but it's been a while since I've gotten it to work, all I remember is that it requires port 2399 to be open. Jono got it working with some interesting performance results, and I don't think there's much difference between the Lasso 8 and 9 configurations:

        http://www.lassosoft.com/Connecting-Lasso-and-FileMaker-via-ODBC
        http://www.lassosoft.com/Accessing-FileMaker-PHP-vs-Lasso-9

If you really want to connect to FileMaker 17 Pro Advanced it might be possible via ODBC, more can be found here:

        https://support.filemaker.com/s/answerview?language=en_US&anum=13612

Side note, port 591 is no longer used by FileMaker and port 5003 is for FileMaker server/client connections, neither of these are used by Lasso, here's a complete list:

        https://support.filemaker.com/s/answerview?language=en_US&anum=000026067

Hope that helps, I'm interested in what you're able to get working.

-Max


> On Jan 14, 2019, at 1:53 PM, James Sheffer <[hidden email]> wrote:
>
> Am I barking up a wrong tree or does anyone know if Lasso 8.5 can connect to FileMaker 17?
>
> I’ve tried both FileMaker connector and ODBC connector.  I opened both ports 591 and 5003 in the firewall and then tried moving the FM client machine to the DMZ but cannot see any databases.
>
> Thanks!
>
>
>
> James Sheffer
> [hidden email]
> www.higherpowered.com
> 469-256-0268
>
>
>
>
>
>
> #############################################################
>
> 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
|

Re: Lasso 8.5 and FileMaker 17

John May-2
In reply to this post by James Sheffer
Be sure to enable xml via the command line:

        fmsadmin set cwpconfig enablexml=true

Crappy they buried it like that.

        - John


On 1/14/19 4:53 PM, James Sheffer wrote:

> Am I barking up a wrong tree or does anyone know if Lasso 8.5 can
> connect to FileMaker 17?
>
> I’ve tried both FileMaker connector and ODBC connector.  I opened
> both ports 591 and 5003 in the firewall and then tried moving the FM
> client machine to the DMZ but cannot see any databases.
>
> Thanks!
>
>
>
> James Sheffer [hidden email] www.higherpowered.com
> 469-256-0268
>
>
--

-------------------------------------------------------------------
John May : President                   http://www.pointinspace.com/
Point In Space Internet Solutions         800.664.8610 919.338.8198

         Professional FileMaker Pro, MySQL, PHP & Lasso Hosting
           on shared, virtual and hardware dedicated servers


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

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
|

Server FastCGI Timeouts

Bill Yung
We’re getting a lot of this error:

A Failure: -1712 Timeout while reading FastCGI data

This is happening when trying to export a CSV file. The code works about 25% of the time.

Any ideas about how to troubleshoot?


Bill Yung
Boss of Me
IP Tech Devices
Rancho Santa Fe, CA
(859) 240-1024




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

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
|

Re: Server FastCGI Timeouts

Steffan A. Cline
There is a timeout that can be adjusted in Apache and IIS for that.

Before you go down that road, output the CSV to the browser first to ensure there are no Lasso errors coming up. Next make sure you log any errors to console and ensure there’s nothing else strange going on.

Thanks,
Steffan Cline
[hidden email]
602-793-0014

> On Jan 17, 2019, at 10:48 AM, Bill Yung <[hidden email]> wrote:
>
> We’re getting a lot of this error:
>
> A Failure: -1712 Timeout while reading FastCGI data
>
> This is happening when trying to export a CSV file. The code works about 25% of the time.
>
> Any ideas about how to troubleshoot?
>
>
> Bill Yung
> Boss of Me
> IP Tech Devices
> Rancho Santa Fe, CA
> (859) 240-1024
>
>
>
>
> #############################################################
>
> 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
|

Re: Server FastCGI Timeouts

Bill Yung
The data looks clean when it outputs.

I have been recently converted an old project from lasso 8 to lasso 9. Had a lot of trouble with Spitfire and went to Apache almost right away. Running on CentOS 7.

I can see the logs are clear in the Lux interface. One thing that troubles me is there is no timestamp on the logs. Can you tell me how to view logs via console. I’m more of a Linux person.

Bill Yung
Boss of Me
IP Tech Devices
Rancho Santa Fe, CA
(859) 240-1024



> On Jan 17, 2019, at 12:51 PM, Steffan Cline <[hidden email]> wrote:
>
> There is a timeout that can be adjusted in Apache and IIS for that.
>
> Before you go down that road, output the CSV to the browser first to ensure there are no Lasso errors coming up. Next make sure you log any errors to console and ensure there’s nothing else strange going on.
>
> Thanks,
> Steffan Cline
> [hidden email]
> 602-793-0014
>
>> On Jan 17, 2019, at 10:48 AM, Bill Yung <[hidden email]> wrote:
>>
>> We’re getting a lot of this error:
>>
>> A Failure: -1712 Timeout while reading FastCGI data
>>
>> This is happening when trying to export a CSV file. The code works about 25% of the time.
>>
>> Any ideas about how to troubleshoot?
>>
>>
>> Bill Yung
>> Boss of Me
>> IP Tech Devices
>> Rancho Santa Fe, CA
>> (859) 240-1024
>>
>>
>>
>>
>> #############################################################
>>
>> 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]>


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

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
|

Re: Server FastCGI Timeouts

Bill Yung
Found a nice article here:

http://www.stevepiercy.com/articles/mining-the-lasso-error-stack-for-meaning/ <http://www.stevepiercy.com/articles/mining-the-lasso-error-stack-for-meaning/>

Seems like I can just tail the log files.

Bill Yung
Boss of Me
IP Tech Devices
Rancho Santa Fe, CA
(859) 240-1024



> On Jan 17, 2019, at 1:21 PM, Bill Yung <[hidden email]> wrote:
>
> The data looks clean when it outputs.
>
> I have been recently converted an old project from lasso 8 to lasso 9. Had a lot of trouble with Spitfire and went to Apache almost right away. Running on CentOS 7.
>
> I can see the logs are clear in the Lux interface. One thing that troubles me is there is no timestamp on the logs. Can you tell me how to view logs via console. I’m more of a Linux person.
>
> Bill Yung
> Boss of Me
> IP Tech Devices
> Rancho Santa Fe, CA
> (859) 240-1024
>
>
>
>> On Jan 17, 2019, at 12:51 PM, Steffan Cline <[hidden email]> wrote:
>>
>> There is a timeout that can be adjusted in Apache and IIS for that.
>>
>> Before you go down that road, output the CSV to the browser first to ensure there are no Lasso errors coming up. Next make sure you log any errors to console and ensure there’s nothing else strange going on.
>>
>> Thanks,
>> Steffan Cline
>> [hidden email]
>> 602-793-0014
>>
>>> On Jan 17, 2019, at 10:48 AM, Bill Yung <[hidden email]> wrote:
>>>
>>> We’re getting a lot of this error:
>>>
>>> A Failure: -1712 Timeout while reading FastCGI data
>>>
>>> This is happening when trying to export a CSV file. The code works about 25% of the time.
>>>
>>> Any ideas about how to troubleshoot?
>>>
>>>
>>> Bill Yung
>>> Boss of Me
>>> IP Tech Devices
>>> Rancho Santa Fe, CA
>>> (859) 240-1024
>>>
>>>
>>>
>>>
>>> #############################################################
>>>
>>> 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]>
>
>
> #############################################################
>
> 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
|

Re: Server FastCGI Timeouts

Ke Carlton-3
In reply to this post by Bill Yung
With Lasso 9 you can use web_response->sendchunk to acknowledge the
request.

In terms of logs; you can do something like: tail -f
/var/instances/the-instance-name/lasso.out.txt







On Fri, Jan 18, 2019 at 7:21 AM Bill Yung <[hidden email]> wrote:

> The data looks clean when it outputs.
>
> I have been recently converted an old project from lasso 8 to lasso 9. Had
> a lot of trouble with Spitfire and went to Apache almost right away.
> Running on CentOS 7.
>
> I can see the logs are clear in the Lux interface. One thing that troubles
> me is there is no timestamp on the logs. Can you tell me how to view logs
> via console. I’m more of a Linux person.
>
> Bill Yung
> Boss of Me
> IP Tech Devices
> Rancho Santa Fe, CA
> (859) 240-1024
>
>
>
> > On Jan 17, 2019, at 12:51 PM, Steffan Cline <[hidden email]> wrote:
> >
> > There is a timeout that can be adjusted in Apache and IIS for that.
> >
> > Before you go down that road, output the CSV to the browser first to
> ensure there are no Lasso errors coming up. Next make sure you log any
> errors to console and ensure there’s nothing else strange going on.
> >
> > Thanks,
> > Steffan Cline
> > [hidden email]
> > 602-793-0014
> >
> >> On Jan 17, 2019, at 10:48 AM, Bill Yung <[hidden email]> wrote:
> >>
> >> We’re getting a lot of this error:
> >>
> >> A Failure: -1712 Timeout while reading FastCGI data
> >>
> >> This is happening when trying to export a CSV file. The code works
> about 25% of the time.
> >>
> >> Any ideas about how to troubleshoot?
> >>
> >>
> >> Bill Yung
> >> Boss of Me
> >> IP Tech Devices
> >> Rancho Santa Fe, CA
> >> (859) 240-1024
> >>
> >>
> >>
> >>
> >> #############################################################
> >>
> >> 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]>
>
>
> #############################################################
>
> 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
|

Re: Server FastCGI Timeouts

Bill Yung
Very helpful, Ke. Thank you. I am now using

web_response->sendFile

The file is not large, only 10k. I think the timeout was related to the mysql DB bogging down on the backend. I am interested in knowing more about sendChunk vs. sendFile.

Bill Yung
Boss of Me
IP Tech Devices
Rancho Santa Fe, CA
(859) 240-1024



> On Jan 17, 2019, at 3:33 PM, Ke Carlton <[hidden email]> wrote:
>
> With Lasso 9 you can use web_response->sendchunk to acknowledge the
> request.
>
> In terms of logs; you can do something like: tail -f
> /var/instances/the-instance-name/lasso.out.txt
>
>
>
>
>
>
>
> On Fri, Jan 18, 2019 at 7:21 AM Bill Yung <[hidden email]> wrote:
>
>> The data looks clean when it outputs.
>>
>> I have been recently converted an old project from lasso 8 to lasso 9. Had
>> a lot of trouble with Spitfire and went to Apache almost right away.
>> Running on CentOS 7.
>>
>> I can see the logs are clear in the Lux interface. One thing that troubles
>> me is there is no timestamp on the logs. Can you tell me how to view logs
>> via console. I’m more of a Linux person.
>>
>> Bill Yung
>> Boss of Me
>> IP Tech Devices
>> Rancho Santa Fe, CA
>> (859) 240-1024
>>
>>
>>
>>> On Jan 17, 2019, at 12:51 PM, Steffan Cline <[hidden email]> wrote:
>>>
>>> There is a timeout that can be adjusted in Apache and IIS for that.
>>>
>>> Before you go down that road, output the CSV to the browser first to
>> ensure there are no Lasso errors coming up. Next make sure you log any
>> errors to console and ensure there’s nothing else strange going on.
>>>
>>> Thanks,
>>> Steffan Cline
>>> [hidden email]
>>> 602-793-0014
>>>
>>>> On Jan 17, 2019, at 10:48 AM, Bill Yung <[hidden email]> wrote:
>>>>
>>>> We’re getting a lot of this error:
>>>>
>>>> A Failure: -1712 Timeout while reading FastCGI data
>>>>
>>>> This is happening when trying to export a CSV file. The code works
>> about 25% of the time.
>>>>
>>>> Any ideas about how to troubleshoot?
>>>>
>>>>
>>>> Bill Yung
>>>> Boss of Me
>>>> IP Tech Devices
>>>> Rancho Santa Fe, CA
>>>> (859) 240-1024
>>>>
>>>>
>>>>
>>>>
>>>> #############################################################
>>>>
>>>> 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]>
>>
>>
>> #############################################################
>>
>> 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]>


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

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
|

Re: Server FastCGI Timeouts

Ke Carlton-3
Sure; it's in the documentation here:
http://lassoguide.com/operations/requests-responses.html?highlight=sendchunk#web_response-%3Esendchunk


On Fri, Jan 18, 2019 at 9:40 AM Bill Yung <[hidden email]> wrote:

> Very helpful, Ke. Thank you. I am now using
>
> web_response->sendFile
>
> The file is not large, only 10k. I think the timeout was related to the
> mysql DB bogging down on the backend. I am interested in knowing more about
> sendChunk vs. sendFile.
>
> Bill Yung
> Boss of Me
> IP Tech Devices
> Rancho Santa Fe, CA
> (859) 240-1024
>
>
>
> > On Jan 17, 2019, at 3:33 PM, Ke Carlton <[hidden email]> wrote:
> >
> > With Lasso 9 you can use web_response->sendchunk to acknowledge the
> > request.
> >
> > In terms of logs; you can do something like: tail -f
> > /var/instances/the-instance-name/lasso.out.txt
> >
> >
> >
> >
> >
> >
> >
> > On Fri, Jan 18, 2019 at 7:21 AM Bill Yung <[hidden email]>
> wrote:
> >
> >> The data looks clean when it outputs.
> >>
> >> I have been recently converted an old project from lasso 8 to lasso 9.
> Had
> >> a lot of trouble with Spitfire and went to Apache almost right away.
> >> Running on CentOS 7.
> >>
> >> I can see the logs are clear in the Lux interface. One thing that
> troubles
> >> me is there is no timestamp on the logs. Can you tell me how to view
> logs
> >> via console. I’m more of a Linux person.
> >>
> >> Bill Yung
> >> Boss of Me
> >> IP Tech Devices
> >> Rancho Santa Fe, CA
> >> (859) 240-1024
> >>
> >>
> >>
> >>> On Jan 17, 2019, at 12:51 PM, Steffan Cline <[hidden email]> wrote:
> >>>
> >>> There is a timeout that can be adjusted in Apache and IIS for that.
> >>>
> >>> Before you go down that road, output the CSV to the browser first to
> >> ensure there are no Lasso errors coming up. Next make sure you log any
> >> errors to console and ensure there’s nothing else strange going on.
> >>>
> >>> Thanks,
> >>> Steffan Cline
> >>> [hidden email]
> >>> 602-793-0014
> >>>
> >>>> On Jan 17, 2019, at 10:48 AM, Bill Yung <[hidden email]>
> wrote:
> >>>>
> >>>> We’re getting a lot of this error:
> >>>>
> >>>> A Failure: -1712 Timeout while reading FastCGI data
> >>>>
> >>>> This is happening when trying to export a CSV file. The code works
> >> about 25% of the time.
> >>>>
> >>>> Any ideas about how to troubleshoot?
> >>>>
> >>>>
> >>>> Bill Yung
> >>>> Boss of Me
> >>>> IP Tech Devices
> >>>> Rancho Santa Fe, CA
> >>>> (859) 240-1024
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> #############################################################
> >>>>
> >>>> 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]>
> >>
> >>
> >> #############################################################
> >>
> >> 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]>
>
>
> #############################################################
>
> 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
|

Re: Server FastCGI Timeouts

Ke Carlton-3
The concept is to send an empty chunk so Apache knows that something is
happening with request and then you progressively send chunk of your file.

If your DB request is slow or returning too many rows; then break it down
into a 1000 row chunks and send those incrementally with ->sendchunk.



On Tue, Jan 22, 2019 at 10:20 AM Ke Carlton <[hidden email]> wrote:

> Sure; it's in the documentation here:
> http://lassoguide.com/operations/requests-responses.html?highlight=sendchunk#web_response-%3Esendchunk
>
>
> On Fri, Jan 18, 2019 at 9:40 AM Bill Yung <[hidden email]> wrote:
>
>> Very helpful, Ke. Thank you. I am now using
>>
>> web_response->sendFile
>>
>> The file is not large, only 10k. I think the timeout was related to the
>> mysql DB bogging down on the backend. I am interested in knowing more about
>> sendChunk vs. sendFile.
>>
>> Bill Yung
>> Boss of Me
>> IP Tech Devices
>> Rancho Santa Fe, CA
>> (859) 240-1024
>>
>>
>>
>> > On Jan 17, 2019, at 3:33 PM, Ke Carlton <[hidden email]> wrote:
>> >
>> > With Lasso 9 you can use web_response->sendchunk to acknowledge the
>> > request.
>> >
>> > In terms of logs; you can do something like: tail -f
>> > /var/instances/the-instance-name/lasso.out.txt
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > On Fri, Jan 18, 2019 at 7:21 AM Bill Yung <[hidden email]>
>> wrote:
>> >
>> >> The data looks clean when it outputs.
>> >>
>> >> I have been recently converted an old project from lasso 8 to lasso 9.
>> Had
>> >> a lot of trouble with Spitfire and went to Apache almost right away.
>> >> Running on CentOS 7.
>> >>
>> >> I can see the logs are clear in the Lux interface. One thing that
>> troubles
>> >> me is there is no timestamp on the logs. Can you tell me how to view
>> logs
>> >> via console. I’m more of a Linux person.
>> >>
>> >> Bill Yung
>> >> Boss of Me
>> >> IP Tech Devices
>> >> Rancho Santa Fe, CA
>> >> (859) 240-1024
>> >>
>> >>
>> >>
>> >>> On Jan 17, 2019, at 12:51 PM, Steffan Cline <[hidden email]>
>> wrote:
>> >>>
>> >>> There is a timeout that can be adjusted in Apache and IIS for that.
>> >>>
>> >>> Before you go down that road, output the CSV to the browser first to
>> >> ensure there are no Lasso errors coming up. Next make sure you log any
>> >> errors to console and ensure there’s nothing else strange going on.
>> >>>
>> >>> Thanks,
>> >>> Steffan Cline
>> >>> [hidden email]
>> >>> 602-793-0014
>> >>>
>> >>>> On Jan 17, 2019, at 10:48 AM, Bill Yung <[hidden email]>
>> wrote:
>> >>>>
>> >>>> We’re getting a lot of this error:
>> >>>>
>> >>>> A Failure: -1712 Timeout while reading FastCGI data
>> >>>>
>> >>>> This is happening when trying to export a CSV file. The code works
>> >> about 25% of the time.
>> >>>>
>> >>>> Any ideas about how to troubleshoot?
>> >>>>
>> >>>>
>> >>>> Bill Yung
>> >>>> Boss of Me
>> >>>> IP Tech Devices
>> >>>> Rancho Santa Fe, CA
>> >>>> (859) 240-1024
>> >>>>
>> >>>>
>> >>>>
>> >>>>
>> >>>> #############################################################
>> >>>>
>> >>>> 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]>
>> >>
>> >>
>> >> #############################################################
>> >>
>> >> 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]>
>>
>>
>> #############################################################
>>
>> 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
|

Re: Server FastCGI Timeouts

Bill Yung
Good info, Thanks for that.

It seems I’m getting these timeouts on other pages that are not related to sending a file.

It isn’t that the queries return large amounts of data. It’s almost as if the request gets lost and the DB (MariaDB) never sees it.

Bill Yung
Boss of Me
IP Tech Devices
Rancho Santa Fe, CA


> On Jan 21, 2019, at 4:23 PM, Ke Carlton <[hidden email]> wrote:
>
> The concept is to send an empty chunk so Apache knows that something is
> happening with request and then you progressively send chunk of your file.
>
> If your DB request is slow or returning too many rows; then break it down
> into a 1000 row chunks and send those incrementally with ->sendchunk.
>
>
>
> On Tue, Jan 22, 2019 at 10:20 AM Ke Carlton <[hidden email]> wrote:
>
>> Sure; it's in the documentation here:
>> http://lassoguide.com/operations/requests-responses.html?highlight=sendchunk#web_response-%3Esendchunk
>>
>>
>> On Fri, Jan 18, 2019 at 9:40 AM Bill Yung <[hidden email]> wrote:
>>
>>> Very helpful, Ke. Thank you. I am now using
>>>
>>> web_response->sendFile
>>>
>>> The file is not large, only 10k. I think the timeout was related to the
>>> mysql DB bogging down on the backend. I am interested in knowing more about
>>> sendChunk vs. sendFile.
>>>
>>> Bill Yung
>>> Boss of Me
>>> IP Tech Devices
>>> Rancho Santa Fe, CA
>>> (859) 240-1024
>>>
>>>
>>>
>>>> On Jan 17, 2019, at 3:33 PM, Ke Carlton <[hidden email]> wrote:
>>>>
>>>> With Lasso 9 you can use web_response->sendchunk to acknowledge the
>>>> request.
>>>>
>>>> In terms of logs; you can do something like: tail -f
>>>> /var/instances/the-instance-name/lasso.out.txt
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Fri, Jan 18, 2019 at 7:21 AM Bill Yung <[hidden email]>
>>> wrote:
>>>>
>>>>> The data looks clean when it outputs.
>>>>>
>>>>> I have been recently converted an old project from lasso 8 to lasso 9.
>>> Had
>>>>> a lot of trouble with Spitfire and went to Apache almost right away.
>>>>> Running on CentOS 7.
>>>>>
>>>>> I can see the logs are clear in the Lux interface. One thing that
>>> troubles
>>>>> me is there is no timestamp on the logs. Can you tell me how to view
>>> logs
>>>>> via console. I’m more of a Linux person.
>>>>>
>>>>> Bill Yung
>>>>> Boss of Me
>>>>> IP Tech Devices
>>>>> Rancho Santa Fe, CA
>>>>> (859) 240-1024
>>>>>
>>>>>
>>>>>
>>>>>> On Jan 17, 2019, at 12:51 PM, Steffan Cline <[hidden email]>
>>> wrote:
>>>>>>
>>>>>> There is a timeout that can be adjusted in Apache and IIS for that.
>>>>>>
>>>>>> Before you go down that road, output the CSV to the browser first to
>>>>> ensure there are no Lasso errors coming up. Next make sure you log any
>>>>> errors to console and ensure there’s nothing else strange going on.
>>>>>>
>>>>>> Thanks,
>>>>>> Steffan Cline
>>>>>> [hidden email]
>>>>>> 602-793-0014
>>>>>>
>>>>>>> On Jan 17, 2019, at 10:48 AM, Bill Yung <[hidden email]>
>>> wrote:
>>>>>>>
>>>>>>> We’re getting a lot of this error:
>>>>>>>
>>>>>>> A Failure: -1712 Timeout while reading FastCGI data
>>>>>>>
>>>>>>> This is happening when trying to export a CSV file. The code works
>>>>> about 25% of the time.
>>>>>>>
>>>>>>> Any ideas about how to troubleshoot?
>>>>>>>
>>>>>>>
>>>>>>> Bill Yung
>>>>>>> Boss of Me
>>>>>>> IP Tech Devices
>>>>>>> Rancho Santa Fe, CA
>>>>>>> (859) 240-1024
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> #############################################################
>>>>>>>
>>>>>>> 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]>
>>>>>
>>>>>
>>>>> #############################################################
>>>>>
>>>>> 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]>
>>>
>>>
>>> #############################################################
>>>
>>> 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]>


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

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]>