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:
Security Tip (1996)
Mac Programs (1998)
Search Engine bots (2002)
Document Contains No Data! (1997)
listfiles, moving files (1998)
US Postal Service API (2007)
Help with update to 2.11 (1998)
selecting multiple found items (1997)
[WebDNA] Mac OS Intel version? (2008)
Snake Bites (1997)
[/application] error? (1997)
pop up menu's (1998)
autosensing lanague selection (1997)
WebCatalog for Postcards ? (1997)
Errata: WCS Newbie question (1997)
Document Contains No Data msg (1997)
Multiple Newcarts (1996)
RE: is sku a REQUIRED field on NT (1997)
Classified (1999)
Help name our technology! I found it (1997)