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:
How to verify email address (1997)
setting taxable to true (1997)
Searching an Email database (1997)
[delete] problem (1997)
off topic - dna snipets (1997)
Has anyone accessed an LDAP server via Typhoon Pro? (2000)
No spaces allowed in text variable names ... ? (2002)
OK, here goes... (1997)
[showif] / [hideif] (1997)
Not really WebCat (1997)
Separate SSL Server (1997)
[WebDNA] Ubuntu and WebDNA (2019)
PROBLEM (1997)
Help name our technology! I found it (1997)
Multiple prices (1997)
Stinkin' [Referrer] (1998)
PCS Customer submissions ? (1997)
SKU lookup (1997)
faxing orders (2000)
[blank] (2005)