Re: db access problem after switching to SSL
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37339
interpreted = N
texte = >Christopher Feyrer wrote: >> >> Hi there folks. >> >> Interesting problem here. WebCat 4 on a UNIX box. Just making it SSL >> before we launch. Weird things are afoot. >> >> A database, we shall call it foo.db, is queried within an [orderfile] >> order summary to provide additional information. When the summary >> appears before the order is placed, this code executes properly and >> displays the order summary with the supplementary database. >> >> On the final page of the order, (which comes off of an SSLized alias >> to the same directory), the queries are IGNORED by webcat, producing >> a summary without any information from foo.db. >> >> I took out my search string and put it in unbracketed to see if the >> search terms themselves would produce an error; nothing. >> >> The weirdest part is that the foo.db query works fine on the >>non-secure page. >> >> Any idea why this might be happening? >> > >SSL is only in effect at the web server level; WebCatalog has nothing >to do with it. There is something else going on with the page. If you >do everything non-SSL, does it work (just take out the https from the >link between pages)? What I am thinking about is that after you do a >purchase, the cart is moved from ShoppingCarts to Orders so your search >is failing. > >Show us the code (only the WebCat parts, that is)! > >JohnAfter removing the secure https: links, the search executes successfully.The code in question is nested in an [orderfile][lineitems], where it takes elements from the cart and passed variables from within the cart to execute a search on a supplementary database:[search db=gcpersonalize.db&]&eqmerchantiddatarq=[interpret][texta]-[quantity][/interpret]&eqsequencedatarq=[textc]&eqcartnumberdatarq=[cart]] [founditems] To: [tofield] From: [fromfield] Greeting: [greetingfield] [/founditems] [/search]etc etc. This executes for every lineitem in the cart.The odd thing is, on the ssl page the context is completely IGNORED...no errors or anything. And on the non-ssl page? Everything pops right into place.Again, I tried taking the above search and running it through de-webcatting it (taking the [ out in [search and the ] at the end of the context) to see if I had a syntax error. I didn't.Again, any ideas would be great.CJF-- ------------------------------------------------------------------------ Christopher Feyrer http://www.foodspot.com System Administrator chris@foodspot.com PGP 6.x key available. ------------------------------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>Christopher Feyrer wrote: >> >> Hi there folks. >> >> Interesting problem here. WebCat 4 on a UNIX box. Just making it SSL >> before we launch. Weird things are afoot. >> >> A database, we shall call it foo.db, is queried within an [orderfile] >> order summary to provide additional information. When the summary >> appears before the order is placed, this code executes properly and >> displays the order summary with the supplementary database. >> >> On the final page of the order, (which comes off of an SSLized alias >> to the same directory), the queries are IGNORED by webcat, producing >> a summary without any information from foo.db. >> >> I took out my search string and put it in unbracketed to see if the >> search terms themselves would produce an error; nothing. >> >> The weirdest part is that the foo.db query works fine on the >>non-secure page. >> >> Any idea why this might be happening? >> > >SSL is only in effect at the web server level; WebCatalog has nothing >to do with it. There is something else going on with the page. If you >do everything non-SSL, does it work (just take out the https from the >link between pages)? What I am thinking about is that after you do a >purchase, the cart is moved from ShoppingCarts to Orders so your search >is failing. > >Show us the code (only the WebCat parts, that is)! > >JohnAfter removing the secure https: links, the search executes successfully.The code in question is nested in an [orderfile][lineitems], where it takes elements from the cart and passed variables from within the cart to execute a search on a supplementary database:[search db=gcpersonalize.db&]&eqmerchantiddatarq=[interpret][texta]-[quantity][/interpret]&eqsequencedatarq=[textc]&eqcartnumberdatarq=[cart]] [founditems] To: [tofield] From: [fromfield] Greeting: [greetingfield] [/founditems] [/search]etc etc. This executes for every lineitem in the cart.The odd thing is, on the ssl page the context is completely IGNORED...no errors or anything. And on the non-ssl page? Everything pops right into place.Again, I tried taking the above search and running it through de-webcatting it (taking the [ out in [search and the ] at the end of the context) to see if I had a syntax error. I didn't.Again, any ideas would be great.CJF-- ------------------------------------------------------------------------ Christopher Feyrer http://www.foodspot.com System Administrator chris@foodspot.com PGP 6.x key available. ------------------------------------------------------------------------------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Christopher Feyrer
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Nav. 4 probs with cart - Serious problem (1997)
Help! WebCat2 bug (1997)
WebCat2b15MacPlugin - [protect] (1997)
[WebDNA] Yet another call for hosts... (2009)
Review comparison by PC Magazine: Open for On-lineBusiness (1997)
Mac Lockup Problems (1998)
Fedora Core 6 (2007)
auto-stripping of spaces (1997)
[sendmail] v. [writefile] (2000)
[OT] Internet Access (2003)
Authenticating users without dialog box (1997)
Tiger / WebDNA (2005)
Does not begin with.... (2003)
[OT] Bad Cookie / Internet Option / Internet Explorer (2004)
executing via commandline (2003)
dynamic giffing. (2000)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Error Messges (1997)
sendmail for email (was Netforms) (1998)
when is date system date or order date? (1997)