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:
[protect] is protecting too much!!! (2000)
[SHOWIF AND/OR] (1997)
WebCatalog2 Feature Feedback (1996)
WebCat2: Master Counter snippet (1997)
WebCatalog can't find database (1997)
Template Cache problem, bombing WebSTAR problem (2000)
Re:2nd WebCatalog2 Feature Request (1996)
Unable to open the demo file (1998)
How to verify email address (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
Banners and sort of random display (1997)
available times? (2003)
virtual domain service (1997)
webmerch and serials - almost there (1997)
More on the email templates (1997)
WCS Newbie question (1997)
OT: Research Friendly Data Interface (2002)
Email...Thanks (1997)
encryption madness (2003)
limitation found on group searching (1997)