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:
browser info.txt and SSL (1997)
Re:quit command on NT (1997)
Re:E-Mailer (WebCatb15acgiMac) (1997)
Date Range works (1997)
WebMerchant - WorldPay (2004)
RequiredFields template (1997)
Paths, relative paths, webstar server setup and security (Mac) (1997)
Running 2 two WebCatalog.acgi's (1996)
Understanding texta (1997)
Emailer setup (1997)
test (2000)
Shipcost lookup? (1997)
Search context not finding recent entries (1998)
[ModDate] & [ModTime] ? (1997)
Help name our technology! I found it (1997)
Problems w/ heavy use of cart header fields? (1998)
checksum for credit cards? (1997)
[WebDNA] port from mime headers? (2017)
Um. silly question perhaps...but I don't know, so I'm askin'.. (2001)
FEA REQ: One .hdr, multiple .db's (2003)