Hi Atif. Sorry for not replying earlier, but hadn't had access to the computer for the whole night.
I asume you do have 'Keep alive' and 'Chunked encoding' enabled in the 'Advanced' section of Cherokee-Admin, right? Regards Atif Ghaffar wrote: > Sorry for replying directly to your email address instead of replying > to the list. > I was assuming that the default reply-to is set to the list address. > > > ---------- Forwarded message ---------- > From: *Atif Ghaffar* <[email protected] > <mailto:[email protected]>> > Date: Fri, Oct 9, 2009 at 5:33 AM > Subject: Re: [Cherokee] DBSlayer. Persistent connections. Still cannot > get them persisting. > To: Taher Shihadeh <[email protected] <mailto:[email protected]>> > > > > > I have this setup. > > application server -> cherokee-dbslayer -> dbserver > I run the following code on the application server > > #!/usr/bin/perl > use LWP::Simple; > while(true){ > > getprint("http://dbslayer:3307/dbslayer/ecmsdb/select%20*%20from%20user%20where%20user_id%3D1306399%20limit%201";); > } > > 1. I see the output of the script continously (expected behaviour) > 2. I see the logs on the cherokee server (expected behaviour) > 3. I dont see the persistent connection on the mysql server (not > expected). > > What did I miss here? > > If I do a script like this > > #!/usr/bin/perl > # 1. connect to database. > # 2. do a select > # 3. sleep for a long time > then I do see the connection open from this script. > > thanks for help. > I have many more questions but one at a time :-) > > best regards > -- > Atif > > > On Thu, Oct 8, 2009 at 8:09 PM, Atif Ghaffar <[email protected] > <mailto:[email protected]>> wrote: > > > > On Thu, Oct 8, 2009 at 7:51 PM, Atif Ghaffar > <[email protected] <mailto:[email protected]>> wrote: > > > > On Thu, Oct 8, 2009 at 7:42 PM, Taher Shihadeh > <[email protected] <mailto:[email protected]>> wrote: > > Hello. > > Yes. You probably want to read [1] to have some things in > mind ;-) > > > [1] > http://www.cherokee-project.com/doc/modules_handlers_dbslayer.html > > > Thanks Taher. > > > I tried on a devserver where a perl script constantly hit the > dbslayer with a query. > I see the output but I do not see this connections persisting on > the dbserver. > > > Can you please elaborate on how to use the chunked encoding etc to > get the persistence. > thanks > -- [email protected] http://unixwars.com/ _______________________________________________ Cherokee mailing list [email protected] http://lists.octality.com/listinfo/cherokee
