CFTOKEN CFID cookies with long gibberish prefix... CF11?

2015-04-06 Thread Gaulin, Mark

Hi
We have one CF web server running CF11 and noticed that the CFTOKEN and CFID 
cookies on that server have a long (51 char) string of random looking 
characters before the actual CFID or CFOTKEN numeric value.

Ex: CFTOKEN = Z3epk1hxi861r0je68dw9xjrpf2oqa1vm0ygobljizhhw2d5gjh-22151980

Within CF, the COOKIE.CFTOKEN value looks normal... 22151980 from my example 
above. So, it looks like CF is adding the prefix when it sets the cookie and 
strips it off when parsing cookies for apps to use.  We see the same prefix 
each time.  (No other cookies have this prefix; we tried setting a CFTOKEN 
cookie value manually in code and the new value ends up with the prefix.)

The problem if that we use domain cookies (for cross-server session management 
and user tracking) so these funky values are being presented to other web 
servers that are not running CF11 (all the rest of CF10), and they are getting 
confused by it.

I didn't see anything like this mentioned in CF11 docs. I really need to 
disable it in the short term to keep things running smoothly until we have CF11 
everywhere.

Is this new behavior?  Is it documented anywhere? Can I turn it off?

(We are aware of the GUID session management cookie; for the time being we need 
to continue to use CFTOKEN  CFID.)

Help!

Thanks
Mark


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360386
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Enable Request Debugging Output not working

2015-04-05 Thread Mark Spence

I have added 127.0.0.1 as a ip to serve debug output to, and I have also
removed all ips to have debug info served to all ips.  Neither results in
output.

On Sun, Apr 5, 2015 at 4:59 AM, Russ Michaels r...@michaels.me.uk wrote:


 Do you have any ip restrictions set for the debug output?


 On Sun, Apr 5, 2015 at 3:49 AM, Mark Spence markpence...@gmail.com
 wrote:


 For some reason, suddenly debug output has stopped working on my
 development machine.  I'm not sure why.  I have tried turning it off and
 on, restarting the server, restarting the box.  Nothing has helped.  Google
 has failed me.  Running on windows 8.1 and IIS.




 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360377
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Enable Request Debugging Output not working

2015-04-04 Thread Mark Spence

For some reason, suddenly debug output has stopped working on my
development machine.  I'm not sure why.  I have tried turning it off and
on, restarting the server, restarting the box.  Nothing has helped.  Google
has failed me.  Running on windows 8.1 and IIS.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360375
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Handling invalid recipient in mailing list

2015-04-02 Thread Mark A Kruger

Dave,

A) What is the error. Fixing the error will keep your loop going.
B) Using a try/catch INSIDE the loop will allow you to keep it going - with
the caveat that you will miss whatever email throws the error so you might
want to log that inside the catch.

-Mark


-Original Message-
From: Dave Long [mailto:d...@northgoods.com] 
Sent: Thursday, April 02, 2015 5:12 PM
To: cf-talk
Subject: Handling invalid recipient in mailing list


I am trying to send a mass mailing to a somewhat carelessly created list of
contacts using e-mail addresses which were not verified at the time of
entry. Whenever the cfloop tag comes to an erroneous recipient, it quits and
throws an error. Is there anything I can do to the code to make it keep
going?

Here's the code:

CFLOOP list=#Form.SelectedRecipients# index=Recipient
CFMAIL
from=#Form.Sender#
to=#Recipient#
subject=#Form.Subject#
type=HTML

htmlheadlink rel=stylesheet
href=http://www.northgoods.com/global.css; type=text/css //headbody
bgcolor=black
table width=800 align=center
TR
TD align=center colspan=2
table width=800 align=center border=4 cellpadding=10
bgcolor=blacktrtd
strongfont face=Arial size=+1 color=##FF6600
#Form.Message#
/font/strong
/td/tr/table
table align=center
trth colspan=2strongfont face=Arial size=-1
color=##FF6600If you would like to be removed frombrour mailing list,
please click here:/font/strongbr
a
href=http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#;
title=UNSUBSCRIBEfont face=Arial size=-1
color=whitestrongUNSUBSCRIBE/strong/font/abr
font face=Arial size=-1 color=##FF6600You will receive one last
message from us to confirm your removal from our
list./font/strong/th/tr
/TABLE/body/html
/CFMAIL
/CFLOOP




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360352
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: considering two options for changing hosting

2015-03-31 Thread Mark A Kruger

Ow! That hurt.

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Tuesday, March 31, 2015 3:37 PM
To: cf-talk
Subject: Re: considering two options for changing hosting


Mark,

there is a very good reason I do not tell people there is a workaround to
get MSAccess working on 64bit, and no you definitely should not encourage
such things, you are a bad bad man and I am giving you a virtual slap right
now..


On Tue, Mar 31, 2015 at 9:06 PM, Mark A Kruger mkru...@cfwebtools.com
wrote:


 Russ,

 You can make access Run on 64bit - it's just not very easy :)  I know I
 know
 I should NOT be encouraging such things (ha).



http://www.coldfusionmuse.com/index.cfm/2010/12/31/Access.on.64bit.ColdFusio
 n

 -Mark

 -Original Message-
 From: Russ Michaels [mailto:r...@michaels.me.uk]
 Sent: Tuesday, March 31, 2015 1:52 PM
 To: cf-talk
 Subject: Re: considering two options for changing hosting


 MSAccess does not work since windows server 2008 as the jet drivers do not
 exist for 64bit OS, so your host must be running 2003 still on 32bit.
 So the days of running MSAccess have already gone years ago, you are just
 running on a legacy windows 2003 system, which reaches EOL this July.

 If you want to know why CF has so many issues on shared hosting, then read
 this


http://www.michaels.me.uk/post.cfm/why-coldfusion-railo-are-not-suited-to-sh
 ared-hosting



 On Tue, Mar 31, 2015 at 6:31 PM, Stephens, Larry V steph...@iu.edu
 wrote:

 
  I echo everything said below except I am on shared hosting. I've had
some
  issues with slow response and failure to connect and, at least twice,
 they
  volunteered to move me to a different host to solve the problem. I'm
  running multiple sites with them.
 
  There have been times when I'm pretty sure they didn't read all my
 support
  request and gave a kneejerk response, but we worked through that. If I
 was
  starting any new sites they would go there.
 
  I'm pretty sure the days of running Access are limited. I still have a
  couple of sites, too, and they don't work real well. The connections
keep
  dying and have to be restarted by the support staff. I'm converting them
 to
  MSSQL.
 
 
  Larry V. Stephens
 
 
  I made the switch to Hostek (https://cp.hostek.com/aff.php?aff=931) a
 few
  years back and I have been very happy with the decision. I just went
  through a server upgrade over the weekend in which we ran into an issue
  with a couple of old sites that are still running on MS Access. Their
  support staff were very diligent and were able to work out the issue for
  me. I have not worked with their shared hosting, but their VPS service
 has
  been top notch.
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360337
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: considering two options for changing hosting

2015-03-31 Thread Mark A Kruger

PS. I agree his host is probably using 32bit.

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Tuesday, March 31, 2015 1:52 PM
To: cf-talk
Subject: Re: considering two options for changing hosting


MSAccess does not work since windows server 2008 as the jet drivers do not
exist for 64bit OS, so your host must be running 2003 still on 32bit.
So the days of running MSAccess have already gone years ago, you are just
running on a legacy windows 2003 system, which reaches EOL this July.

If you want to know why CF has so many issues on shared hosting, then read
this
http://www.michaels.me.uk/post.cfm/why-coldfusion-railo-are-not-suited-to-sh
ared-hosting



On Tue, Mar 31, 2015 at 6:31 PM, Stephens, Larry V steph...@iu.edu wrote:


 I echo everything said below except I am on shared hosting. I've had some
 issues with slow response and failure to connect and, at least twice, they
 volunteered to move me to a different host to solve the problem. I'm
 running multiple sites with them.

 There have been times when I'm pretty sure they didn't read all my support
 request and gave a kneejerk response, but we worked through that. If I was
 starting any new sites they would go there.

 I'm pretty sure the days of running Access are limited. I still have a
 couple of sites, too, and they don't work real well. The connections keep
 dying and have to be restarted by the support staff. I'm converting them
to
 MSSQL.


 Larry V. Stephens


 I made the switch to Hostek (https://cp.hostek.com/aff.php?aff=931) a few
 years back and I have been very happy with the decision. I just went
 through a server upgrade over the weekend in which we ran into an issue
 with a couple of old sites that are still running on MS Access. Their
 support staff were very diligent and were able to work out the issue for
 me. I have not worked with their shared hosting, but their VPS service has
 been top notch.

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360334
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: SOLR config in CF10

2015-03-26 Thread Mark A Kruger

Les,

Are you running an external Solr instance? Check the CF admin settings under
Solr Host Name. It might give you a host or IP for an external server.

-mark


-Original Message-
From: Les Irvin [mailto:les.cft...@gmail.com] 
Sent: Thursday, March 26, 2015 2:46 PM
To: cf-talk
Subject: SOLR config in CF10


The Adobe docs say that in order to configure SOLR (as in upping the memory
available to it) in CF10 one needs to edit the solr.lax file. Problem is, I
don't have a solr.lax file anywhere on the server. Does anyone know the
name/location of the actual file to do configurations?
Thanks in advance,
Les




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360305
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


considering two options for changing hosting

2015-03-26 Thread Mark Spence

I am currently using Newtek/Crystaltek for a client site and have a couple
of issues with them I am able to resolve.  The site has been with them for
several years.

1.  Lately the Wordpress portion of the site has become slow and I can't
figure out why.  It's not the db and it is not the plug-ins.  It's a simple
site with not many posts or widgets and it should be faster.  The CF
portion of the site is fast.

2.  They don't support http compression.  This is more a minor annoyance,
but it is something I want.

So I am looking at the Hostek Personal Plus for $7.99 CF shared hosting.
Has anyone used both hosts and can compare the two?  Will I see a
performance difference?


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360306
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Line breaks being lost in textarea form field

2015-03-08 Thread Mark Spence

I don't know if this specifically a CF question so sorry if it is
considered OT.

I have an admin section of the site that lets the owner add and edit
items/products.  I am having an issue with the description field where the
newline/enter key input is being lost when editing an entry.

To give more detail, we have a product description saved in the db like so:

This is product description1.

This is paragraph 2.

This is paragraph 3

I am using the tag ParagraphFormat2.cfm from cflib and the output is
working fine on the product page.

However, when the owner goes to edit the item, and the description is
pulled from the db, it appears like this:

This is product description1.This is paragraph 2.This is paragraph 3

After saving the item the text now appers on the product page without any
paragraph breaks as a single paragraph.

So if the owner wants to make any edits to the item they have to reformat
the description re-adding the paragraph breaks.

I tried adding htmleditformat() with no luck.

Here is the tag:

tdtextarea name=productDescription rows=10
cols=39#htmleditformat(attributes.itemForm.productDescription)#/textarea/td

Any ideas?  I would really appreciate it.  Thank you.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360225
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


trying to shorten long string

2015-03-06 Thread Mark Spence

I have a long product description I am trying to truncate.  I could just
truncate it, but I don't want to break off sentences.  Here is the solution
I came up with but it does not seem to have any effect.

Any ideas?

cfset variables.description = qry_productsGet.productdescription
cfif len(variables.description) gt 200
cfloop condition=i eq false
cfset variables.description =
listDeleteAt(variables.description,listLen(variables.description, .),
.)
cfif len(variables.description) lte 200
cfset i = true
/cfif
/cfloop
/cfif


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360222
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Embedding files in a PDF

2015-02-25 Thread Mark A Kruger

Yes but he's talking about arbitrary files I think - supporting documents. I
think the first step is to identify what document types you wish to support.
If you can specify only PDF's and images for example, you could make this
work with CF natively. If you have to do (for example) word doc conversions,
then you will need to use a 3rd party jar file or tool to do the conversion
to PDF and then merge the results. Doable, but a lot trickier :)

-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Wednesday, February 25, 2015 8:34 AM
To: cf-talk
Subject: Re: Embedding files in a PDF


Hi Kevin,

The CF8 documentation seems to indicate that PDF merging is supported with
cfpdf.

http://help.adobe.com/livedocs/coldfusion/8/htmldocs/help.html?content=Tags_
p-q_02.html

From the docs:

*Merge PDF documents into an output PDF file*
cfpdf*required*
action = merge
*one of the following:*
directory = *directory of PDF files to merge*
source = *comma-separated list of PDF source files|absolute or
relative pathname **to a PDF file*|*PDF document
variable*|*cfdocument variable*
cfpdfparam ...
*required if directory is specified:*
order = name|time
*one of the following if cfpdfparam ... is specified:*
name = *PDF document variable name*
destination = *PDF output file pathname**optional*
ascending = yes|no
keepBookmark = yes|no
overwrite = yes|no
pages = *pages to merge in PDF source file*
password = *PDF source file password*
stopOnError = yes|no*one of the following:*
destination = *PDF output file pathname*
name = *PDF document variable name*




On Wed, Feb 25, 2015 at 6:07 AM, Kevin Parker tras...@internode.on.net
wrote:


 Be grateful for a little advice or confirmation please.



 Putting together a little award nomination system. User submits the
 nomination via a web form and attaches any supporting documents to the
 nomination. I then need to produce a PDF of the nomination which in itself
 is not an issue e.g. cfdocument. However, I was looking for a way to embed
 the submitted documents in the PDF version of the nomination. While
 embedding other (types of) files is supported in Acrobat there appears to
 be
 no way to do this via CF be it cfdocument or even cfpdf (platform is CF8)
-
 is my summation correct.



 Thank you





 ++

 Kevin Parker



 ++





 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360152
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: ColdFusion_10_WWEJ_win64.exe error

2015-02-25 Thread Mark A Kruger

Sorry this one!
http://www.coldfusionmuse.com/index.cfm/2010/2/24/CF8-Install-Windows-2003-64bit

-mark


-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Wednesday, February 25, 2015 3:15 PM
To: cf-talk
Subject: Re: ColdFusion_10_WWEJ_win64.exe error


Do you know where that's located?

On Wed, Feb 25, 2015 at 4:13 PM, Russ Michaels r...@michaels.me.uk wrote:


 Try running as administrator.
 Take a look at the installer log for more info.


 On Wed, Feb 25, 2015 at 19:44 PM, John M Bliss bliss.j...@gmail.com
 wrote:


 That's why I:

 ;-)

 I'm constantly posting dumb questions here.  :-)
 On Feb 25, 2015 2:42 PM, Russ Michaels r...@michaels.me.uk
 javascript:;
 wrote:

 
  Hey everyone does something dumb occasionally 😊
 
 
  On Wed, Feb 25, 2015 at 19:38 PM, John M Bliss bliss.j...@gmail.com
 javascript:;
  wrote:
 
 
  No.
 
  Come on, Russ, you've known me for, like, a decade on here!  ;-)
  On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk
 javascript:;
  javascript:;
  wrote:
 
  
   Not trying to install it on a 32bit os are you?
  
  
   On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com
 javascript:;
  javascript:;
   wrote:
  
  
   Reinstalling ACF10 64 bit from physical media from Adobe and getting
 this
   when I run the installer:
  
   Fatal Application Error
   This Application has Unexpectedly Quit
   Invocation of this Java Application has caused an
   InvocationTargetException. This application will now exit. (LAX)
  
   Anyone else seen this? Fix?
  
   --
   John Bliss - http://www.linkedin.com/in/jbliss
  
  
  
  
  
 
 
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360162
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: ColdFusion_10_WWEJ_win64.exe error

2015-02-25 Thread Mark A Kruger

John,

I have had (on occasion) to edit the LAX jvm config file to get an install to 
work on certain OS platforms.  Here's a blog post that might give you some 
clues - at least with regard to where everything is at :)

http://www.coldfusionmuse.com/index.cfm/2010/8/18/win2k3.64bit.install

-Mark



-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Wednesday, February 25, 2015 3:15 PM
To: cf-talk
Subject: Re: ColdFusion_10_WWEJ_win64.exe error


Do you know where that's located?

On Wed, Feb 25, 2015 at 4:13 PM, Russ Michaels r...@michaels.me.uk wrote:


 Try running as administrator.
 Take a look at the installer log for more info.


 On Wed, Feb 25, 2015 at 19:44 PM, John M Bliss bliss.j...@gmail.com
 wrote:


 That's why I:

 ;-)

 I'm constantly posting dumb questions here.  :-)
 On Feb 25, 2015 2:42 PM, Russ Michaels r...@michaels.me.uk
 javascript:;
 wrote:

 
  Hey everyone does something dumb occasionally 😊
 
 
  On Wed, Feb 25, 2015 at 19:38 PM, John M Bliss bliss.j...@gmail.com
 javascript:;
  wrote:
 
 
  No.
 
  Come on, Russ, you've known me for, like, a decade on here!  ;-)
  On Feb 25, 2015 2:36 PM, Russ Michaels r...@michaels.me.uk
 javascript:;
  javascript:;
  wrote:
 
  
   Not trying to install it on a 32bit os are you?
  
  
   On Wed, Feb 25, 2015 at 19:32 PM, John M Bliss bliss.j...@gmail.com
 javascript:;
  javascript:;
   wrote:
  
  
   Reinstalling ACF10 64 bit from physical media from Adobe and getting
 this
   when I run the installer:
  
   Fatal Application Error
   This Application has Unexpectedly Quit
   Invocation of this Java Application has caused an
   InvocationTargetException. This application will now exit. (LAX)
  
   Anyone else seen this? Fix?
  
   --
   John Bliss - http://www.linkedin.com/in/jbliss
  
  
  
  
  
 
 
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360161
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-18 Thread Mark Spence

Miguel,

Thanks for the article.  It was a little  confusing as it seemed to
reference onMissingTemplate as the setting in administrator rather than
the function in Application.cfc.  And that is what I am trying to invoke,
the function in Apllication.cfc.  Is that no longer possible?  I seem to be
in a bit of a conundrum here.  My local dev machine is windows 8 which
requires the higher versions of IIS and CF, while the production site is
CF9.

To give a better idea of where I am at, I have this in the web.config:
httpErrors errorMode=Detailed existingResponse=PassThrough

And now I get a blank page from the 404 pages.  I assume that either CF is
not returning anything or IIS is discarding the response.

Here is what I have in the onMissingTemplate function:

cffunction name=onMissingTemplate returnType=boolean
  cfargument type=string name=targetPage required=true/
  cfheader statusCode=200 statusText=OKhello
  !---
  cfobject component=cfcs.404 name=handle_404 /

  cfset variables.temp = handle_404.handle_404(requested_template =
arguments.targetPage)
   ---
  cfreturn True /
/cffunction

This is a try based upon the article but I think it is in vain and would
only apply to a specified missing template handler page.

I'm not sure what to try at this point.  I could be off by one little
setting, or what I want to do is just not possible, which is just to have
the missing pages handled by invoking Application.cfc's onMissingTemplate
function like the live server does.  I don't want to do back to Apache
after putting to much time into this, especially since the live server is
IIS.

Thanks for any help you can offer.

On Wed, Feb 18, 2015 at 6:10 AM, Fernandez, Miguel 
miguel.fernan...@kyfb.com wrote:


 I'm not sure if this has already been mentioned but Adobe just posted a
 blog article about custom error handling with ColdFusion and IIS.  Once you
 get over how it was written they do give you three different scenarios for
 configuring your error handling.  It's nice to finally get confirmation
 from them on how it works.

 http://blogs.coldfusion.com/post.cfm/onmissingtemplate

 -Original Message-
 From: Mark Spence [mailto:markpence...@gmail.com]
 Sent: Wednesday, February 18, 2015 12:07 AM
 To: cf-talk
 Subject: Re: CF 404 handler non being invoked on IIS


 I'm trying to make do with using a custom 404 handler in IIS but the
 requested template variable in CF resolves to to 404 handler rather than
 the url of the requested page.  This is getting complicated as this is only
 a work around for local development and I don't want to change to much and
 break the live site.

 Does anyone have any other pointers on how I can get this working like the
 live site?

 I can't believe that it is this problematic to get CF to be passed the 404
 error and invoke the onmissingtemplate.  What changed so drastically in iis
 8 and cf11 that something so basic is so broken?

 On Fri, Feb 13, 2015 at 4:24 PM, Matt Robertson websitema...@gmail.com
 wrote:

 
  sorry for my lack of attention on this.  If you are in fact using IIS
  Rewrite then that clouds the picture a little.  However if I can pull
  myself together and write something up you should be able to do all of
  your
  404 handling in your ... 404 handler.  I don't use IIS rewrites for
  much and instead rely on CF wherever possible.  Will try and find some
  time this long weekend (holiday here in the USA).
 
  On Thu, Feb 12, 2015 at 5:31 AM, Mark Spence markpence...@gmail.com
  wrote:
 
  
   After playing with it a bit more I added this:
   httpErrors existingResponse=PassThrough/
  
   Now I just get a blank page.
  
   Am I successfully passing it through to cf?  Hard to tell.  I was
   hoping
  to
   have made a bit of progress.
  
   On Mon, Feb 9, 2015 at 6:38 PM, Matt Robertson
   websitema...@gmail.com
   wrote:
  
   

 Mark,
   
those two threads aren't exactly a linear set of to do steps.
I'll try
   to
put that together tomorrow when I am in front of a desktop.
   
   
   
 --
 --m@Robertson--
 Janitor, The Robertson Team
 mysecretbase.com

   
   
--
--m@Robertson--
Janitor, The Robertson Team
mysecretbase.com
   
   
   
  
  
 
 



 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360133
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-18 Thread Mark Spence

Sorry for the misunderstanding, but he 404 is for pages the are ses product
pages.  So I need the content to be returned to the user.  An example would
be thus:

http://www.mysite.com/productpages/category/product-103/index.cfm

I am pulling productpages to see that it is a product page and 103 to
get the product id.  All I need is for CF to catch the 404 error, invoke
the onmissingtemplate in Application.cfc, and everything works.  This is
what is happening on the live site with IIS and CF9.

The problem with using IIS's custom error page for 404 is that the
requested template variable is the 404 page itself, which doesn't work with
my code.  I am hoping that there is something I can configure in CF and IIS
rather than rewriting everything just for the development server.

The code I posted in my last response was just to show that it seems that
Application.cfc is not being invoked, the response is being discarded, or
something else is going on.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360135
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-18 Thread Mark Spence

GOT IT!

It was a setting under IIS:

Under Handler Mappings, double-click on the handler for .cfm. Then
click the Request Restrictions... button. It should open to the
mappings tab. The Invoke handler only if request is mapped to: checkbox
should NOT be checked.

On Wed, Feb 18, 2015 at 2:12 PM, Mark Spence markpence...@gmail.com wrote:

 Sorry for the misunderstanding, but he 404 is for pages the are ses
 product pages.  So I need the content to be returned to the user.  An
 example would be thus:

 http://www.mysite.com/productpages/category/product-103/index.cfm

 I am pulling productpages to see that it is a product page and 103 to
 get the product id.  All I need is for CF to catch the 404 error, invoke
 the onmissingtemplate in Application.cfc, and everything works.  This is
 what is happening on the live site with IIS and CF9.

 The problem with using IIS's custom error page for 404 is that the
 requested template variable is the 404 page itself, which doesn't work with
 my code.  I am hoping that there is something I can configure in CF and IIS
 rather than rewriting everything just for the development server.

 The code I posted in my last response was just to show that it seems that
 Application.cfc is not being invoked, the response is being discarded, or
 something else is going on.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360136
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-17 Thread Mark Spence

I'm trying to make do with using a custom 404 handler in IIS but the
requested template variable in CF resolves to to 404 handler rather than
the url of the requested page.  This is getting complicated as this is only
a work around for local development and I don't want to change to much and
break the live site.

Does anyone have any other pointers on how I can get this working like the
live site?

I can't believe that it is this problematic to get CF to be passed the 404
error and invoke the onmissingtemplate.  What changed so drastically in iis
8 and cf11 that something so basic is so broken?

On Fri, Feb 13, 2015 at 4:24 PM, Matt Robertson websitema...@gmail.com
wrote:


 sorry for my lack of attention on this.  If you are in fact using IIS
 Rewrite then that clouds the picture a little.  However if I can pull
 myself together and write something up you should be able to do all of your
 404 handling in your ... 404 handler.  I don't use IIS rewrites for much
 and instead rely on CF wherever possible.  Will try and find some time this
 long weekend (holiday here in the USA).

 On Thu, Feb 12, 2015 at 5:31 AM, Mark Spence markpence...@gmail.com
 wrote:

 
  After playing with it a bit more I added this:
  httpErrors existingResponse=PassThrough/
 
  Now I just get a blank page.
 
  Am I successfully passing it through to cf?  Hard to tell.  I was hoping
 to
  have made a bit of progress.
 
  On Mon, Feb 9, 2015 at 6:38 PM, Matt Robertson websitema...@gmail.com
  wrote:
 
  
   
Mark,
  
   those two threads aren't exactly a linear set of to do steps.  I'll try
  to
   put that together tomorrow when I am in front of a desktop.
  
  
  
--
--m@Robertson--
Janitor, The Robertson Team
mysecretbase.com
   
  
  
   --
   --m@Robertson--
   Janitor, The Robertson Team
   mysecretbase.com
  
  
  
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360130
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


coldfusion 9 developer edition with verity download

2015-02-16 Thread Mark Spence

Anyone know where I can safely download coldfusion 9?  I would like it for
development purposes as the live site uses a verity product search that I
need to work on.

Thanks.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360122
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-12 Thread Mark Spence

After playing with it a bit more I added this:
httpErrors existingResponse=PassThrough/

Now I just get a blank page.

Am I successfully passing it through to cf?  Hard to tell.  I was hoping to
have made a bit of progress.

On Mon, Feb 9, 2015 at 6:38 PM, Matt Robertson websitema...@gmail.com
wrote:


 
  Mark,

 those two threads aren't exactly a linear set of to do steps.  I'll try to
 put that together tomorrow when I am in front of a desktop.



  --
  --m@Robertson--
  Janitor, The Robertson Team
  mysecretbase.com
 


 --
 --m@Robertson--
 Janitor, The Robertson Team
 mysecretbase.com


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360114
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-11 Thread Mark Spence

Thank you, I would appreciate that.

On Mon, Feb 9, 2015 at 6:38 PM, Matt Robertson websitema...@gmail.com
wrote:


 
  Mark,

 those two threads aren't exactly a linear set of to do steps.  I'll try to
 put that together tomorrow when I am in front of a desktop.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360102
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-11 Thread Mark Spence

Have you tried a very simple rule to test of that is working ok ?

The url rewrite is just pointing to serve the site from a subdirectory.  It
is working ok because the home page is being served correctly.  Thanks,

On Mon, Feb 9, 2015 at 3:09 PM, Russ Michaels r...@michaels.me.uk wrote:


 I deal with many sites that have non existent pages which use URL REWRITE
 to redirect them.
 The usual reason is that the url rewrite rules are not working, or even
 that the url rewrite module is not installed.
 Have you tried a very simple rule to test of that is working ok ?






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360103
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-09 Thread Mark Spence

Matt,
Thank you for the link.  I am working through the first step below:

*Step 1:*
Configure a Missing Template Handler in CF Administrator. Mine is global to
the server and kept in the ColdFusion webroot - which is separate from the
IIS web root and whose default location is c:\ColdFusion9\wwwroot. This
global template is 404handler.cfm and contains the following simple code,
which you can expand upon:

h1404/h1pPage Not Found/pcfheader
statuscode=404
statustext=Not Found

At this point, visit your web site and execute a bad ColdFusion url:
*http://[domain]/bogus.cfm*. You will see both the IIS remote error
screen/banner followed by your ColdFusion error screen. Check the header
and it is a 404. This next step will solve the dual display problem.


When I visit the bogus page, I still just get the standard detailed iis 404
page, without the cf page that I created.  I have tried it both with and
without the Enable HTTP status codes.  I can't figure out what I am doing
wrong.  This is on a windows 8 machine.  Any ideas?  Thank you for the help.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360096
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CF 404 handler non being invoked on IIS

2015-02-08 Thread Mark Spence

This is working on the live hosted site, but on my local install of iis and
cf it isn't.

I have ses urls like this:

http://mysitedotcom/item-section/item-name-1034/index.cfm

The directories item-section and item-name-1034 do not exist, so it
should invoke the Application.cfc onMissingTemplate function, which is set
up to serve the proper dynamic page.

However on my local setup, I am getting this iis error:

HTTP Error 404.0 - Not Found
Detailed Error Information:
 Module   IIS Web Core Notification   MapRequestHandler Handler
cfmHandler Error
Code   0x80070002
Requested URL
http://mysitedotcom:80/site_mysubsite_com/items/item-name-1034/index.cfm
Physical
Path   C:\wwwroot\site_mysite_com\item-section\item-name-1034\index.cfm Logon
Method   Anonymous Logon User   Anonymous
It's like CF is not even getting to see the missing template error before
IIS steps in.  I tried setting Application.cfc as the error page for 404
errors but no dice.  How can I make CF take priority and handle the 404
error?

Thank you.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360088
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: problem getting coldfusion and iis running together

2015-02-08 Thread Mark Spence

Under the top level of IIS manager, under ISAPI and CGI restrictions,
there was what I thought to be the proper entry.

I went to the website in question and removed the inherited entry and added
an explicit entry for
   C:\ColdFusion11\config\wsconfig\1\isapi_redirect.dllbut it still does
not work.

Sorry to be so much trouble.  I just would like to get this to work.

On Sun, Feb 8, 2015 at 2:27 AM, Russ Michaels r...@michaels.me.uk wrote:


 You need to make sure that the handler path on your site giving the error
 is added to cgi restrictions and set to allow.


 On Sat, Feb 7, 2015 at 23:04 PM, Mark Spence markpence...@gmail.com
 wrote:


 Thank you for the reply.  I googled the error code and found this thread:

 http://forums.iis.net/t/1150673.aspx?Am+getting+the+error+0x800704ec+in+webpage+while+calling+the+perl+script

 I looked in the ISAPI and CGI restrictions and there is an entry under
 tomcat_Default Web Site with the path pointing to
C:\ColdFusion11\config\wsconfig\1\isapi_redirect.dll

 Any ideas?

 Thank you.
 Detailed Error Information:
  Module   IsapiModule Notification   ExecuteRequestHandler Handler
mod_rewrite Error Code   0x800704ec
 Requested URL   http://127.0.0.1:80/jakarta/isapi_redirect.dll Physical
 Path
C:\ColdFusion11\config\wsconfig\1\isapi_redirect.dll Logon Method
Anonymous Logon User   Anonymous




 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360085
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: problem getting coldfusion and iis running together

2015-02-08 Thread Mark Spence

Hello, Russ.

I tried the web server configuration tool.  After doing so I got an error
about a duplicate configuration pointing me to the web config file.  I
removed the entry and it seems to work now.

I want to say I REALLY appreciate all your help.  Thank you so much.
Cheers.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360087
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 404 handler non being invoked on IIS

2015-02-08 Thread Mark Spence

I have added the following for a custom error page:
Execute a url on this site
/404.cfm

I still get the standard iis 404 error page.  I have restarted the server.
Is there something else I need to do?  Thanks.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360090
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


problem getting coldfusion and iis running together

2015-02-07 Thread Mark Spence

Sorry, this is both a IIS and ColdFusion question, so I wasn't sure where
to ask.  Hopefully someone here can help me.  I am just getting started
with CF and am helping someone with a site so please bear with me.  I am
trying to get my local dev environment set up.


I had IIS and ColdFusion running ok.  I imported some rules from a
.htaccess file and it seemed to work ok, the pages from the subdirectory
were being served based upon host name.  However, once I did so, I started
getting this error when trying to access the Coldfusion Administrator
located at:

http://127.0.0.1/CFIDE/administrator/index.cfm


I got this error:
HTTP Error 404.2 - Not FoundThe page you are requesting cannot be served
because of the ISAPI and CGI Restriction list settings on the Web server.

I thought it might be because of the rules imported so I disabled them all
but no dice.  I also went to the settings for the ISAPI and CGI
Restrictions and clicked on Edit Feature Settings and clicked Allow
unspecified CGI modules and Allow unspecified ISAPI modules.

After doing so, the error changed to:
HTTP Error 500.0 - Internal Server ErrorThere is a problem with the
resource you are looking for, so it cannot be displayed.

I am not sure what else to try.

Thank you for any help.


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360081
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: problem getting coldfusion and iis running together

2015-02-07 Thread Mark Spence

Thank you for the reply.  I googled the error code and found this thread:
http://forums.iis.net/t/1150673.aspx?Am+getting+the+error+0x800704ec+in+webpage+while+calling+the+perl+script

I looked in the ISAPI and CGI restrictions and there is an entry under
tomcat_Default Web Site with the path pointing to
   C:\ColdFusion11\config\wsconfig\1\isapi_redirect.dll

Any ideas?

Thank you.
Detailed Error Information:
 Module   IsapiModule Notification   ExecuteRequestHandler Handler
   mod_rewrite Error Code   0x800704ec
Requested URL   http://127.0.0.1:80/jakarta/isapi_redirect.dll Physical Path
   C:\ColdFusion11\config\wsconfig\1\isapi_redirect.dll Logon Method
   Anonymous Logon User   Anonymous


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360083
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: GC overhead limit exceeded

2014-12-08 Thread Mark A Kruger

Dan,

I was just reading this post by CF Gurur Mike B. It has some cf10 specific
tips that might be applicable to you since your problem is OOM.

http://www.cfwhisperer.com/post.cfm/coldfusion-10-enhanced-performance-setti
ngs

-mark



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Don [mailto:danfar...@hotmail.com] 
Sent: Saturday, December 06, 2014 4:12 PM
To: cf-talk
Subject: Re: GC overhead limit exceeded


I guess this application ran fine under previous Coldfusion incarnations. It
was only after the upgrade to CF 11 that the problems started.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359769
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: GC overhead limit exceeded

2014-12-08 Thread Mark A Kruger

MSSQL express has some limitations as to size (of the DB) and connection
limits. If I have time I'll look for a matrix - but such things could
definitely result in degraded performance. I'm at a loss to say how they
would contribute to a memory leak however.

-Original Message-
From: Don [mailto:danfar...@hotmail.com] 
Sent: Monday, December 08, 2014 1:12 PM
To: cf-talk
Subject: Re: GC overhead limit exceeded


Dan,

I was just reading this post by CF Gurur Mike B. It has some cf10 specific
tips that might be applicable to you since your problem is OOM.

http://www.cfwhisperer.com/post.cfm/coldfusion-10-enhanced-performance-sett
i
ngs

-mark

Cheers Mark. We are also looking at the database ( MS SQL Express ) which is
being used by several sites on that same machine. There is a memory leak
somewhere in the technology path. I'm pretty sure MS SQL Express is not
meant to be used this way... someone correct me if I am wrong.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359771
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: how to diagnose a potential bottleneck

2014-12-02 Thread Mark A Kruger

This does not necessarily mean anything Don.  It could simply mean migration
from eden to persistent memory where GC recovers in due course. It's the
overall pattern of GC recovery that means the most when talking about gross
numbers. You should see a saw tooth pattern over time with steep drops as
memory is recovered on the heap. Problems arise when the drop does not level
off (it recovers less and less memory each time - i.e. a memory leak) or
when the top side of the heap is too lean (i.e. the heap is too small for
it's overall usage pattern). But keying in on a big dump of objects into
perm heap isn't necessarily going to give you information that you can use.



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Don [mailto:danfar...@hotmail.com] 
Sent: Tuesday, December 02, 2014 9:36 AM
To: cf-talk
Subject: Re: how to diagnose a potential bottleneck


Doesnt seem anyone noticed my reply so I'll post this again...

I noticed a sharp drop in JVM memory during this process ( it all happened
in 
about one minute )

Say from the average JVM Freememory of : 255 Megs
Dropping to around : 30 Megs

Any thoughts or ideas? It did come back up to normal levels, but the rate of
the drop has me concerned. 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359740
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Java certificate issue

2014-11-26 Thread Mark A Kruger

Donnie,

That's the wrong log location. You need to look in the standard out log. In
a typical install (non multiserver) it would be in
/coldfusion9/runtime/logs/  look for cfusion-out.log



-Mark

-Original Message-
From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] 
Sent: Wednesday, November 26, 2014 10:16 AM
To: cf-talk
Subject: Re: Java certificate issue


Look at your log files for what the actual error on startup might be.
C:\ColdFusion9\logs\

I would care to guess to look in the server.log file

John Blayter
m: 303.325.1979
http://www.blayter.com/john/

On Wed, Nov 26, 2014 at 8:37 AM, Donnie Carvajal 
donnie.carva...@transformyx.com wrote:



Thanks John,

I already checked there and none of the logs were updated.  I did find a
post that suggested copying msvcr100.dll from the new jre to
[ColdFusionHome]\runtime\bin.  That seemed to do the trick.

Donnie Carvajal 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359716
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Java certificate issue

2014-11-25 Thread Mark A Kruger

It certainly could be a failed intermediate certificate. See this post from
yesterday Donnie. Lots of certs changes in the wild right now.

http://www.coldfusionmuse.com/index.cfm/2014/11/24/coldfusion-tsl-ssl3-JVM-1
-7




Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] 
Sent: Tuesday, November 25, 2014 12:00 PM
To: cf-talk
Subject: Java certificate issue


Hi,

I just started receiving the following error for a java API that we are
using to connect to Netsuite.

javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find
valid certification path to requested target

Our server is Windows 2003 SErvice Pack 2 (Version 5.2).  ColdFusion is
9.0.0.251028 and Java is 1.6.0_14.

This system has been working for years and all of a sudden we are seeing
this error.

Any ideas of what could be causing the issue?

Donnie Carvajal 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359710
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Java certificate issue

2014-11-25 Thread Mark A Kruger

There's a -7 at the end of that link as in JVM-1-7 .. sorry about the
wrap.  (saying that makes me want to beat box for some reason).

-Original Message-
From: Mark A Kruger [mailto:mkru...@cfwebtools.com] 
Sent: Tuesday, November 25, 2014 12:04 PM
To: cf-talk
Subject: RE: Java certificate issue


It certainly could be a failed intermediate certificate. See this post from
yesterday Donnie. Lots of certs changes in the wild right now.

http://www.coldfusionmuse.com/index.cfm/2014/11/24/coldfusion-tsl-ssl3-JVM-1
-7




Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] 
Sent: Tuesday, November 25, 2014 12:00 PM
To: cf-talk
Subject: Java certificate issue


Hi,

I just started receiving the following error for a java API that we are
using to connect to Netsuite.

javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find
valid certification path to requested target

Our server is Windows 2003 SErvice Pack 2 (Version 5.2).  ColdFusion is
9.0.0.251028 and Java is 1.6.0_14.

This system has been working for years and all of a sudden we are seeing
this error.

Any ideas of what could be causing the issue?

Donnie Carvajal 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359711
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: JDBC drivers for old FoxPro DBF files.

2014-11-22 Thread Mark A Kruger

Arden,

You may be able to bridge to an ODBC DSN. The issue is typically 64bit vs 32
bit but it can usually be overcome - at least on Win2008r2.  We've done this
with Access and MS text drivers but never with fox pro - still, the process
should be about the same I think. 

-Mark

-Original Message-
From: Arden Weiss [mailto:ardenwe...@verizon.net] 
Sent: Friday, November 21, 2014 6:59 PM
To: cf-talk
Subject: JDBC drivers for old FoxPro DBF files.


Need advice on what database drivers work well with CF10 and the old FoxPro
for DOS DBF files. Back in the CF

Client has app that has been running flawlessy since 2000 or so using CF5
and the ODBC drivers that came with the product to process credit card
transactions via authorize.net -- back in the CF6 days, I failed to find a
JDBC driver that played nicely with the DBF files -- hope that has changed.

Recently flaws in the SSL3 security (POODLE) caused authnet to drop support
for SSL3 and hence broke the application -- we now will be using CF10 with
Java 1.7 and TSL1.2 to solve that problem, but we need solid support for DBF
file update until the whole system gets rewritten/changed.

Any/all advice requested. 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359704
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


FW: CF9.02 administrator hack

2014-11-12 Thread Mark A Kruger

Tom,

My one questions is you say that view source is identical from a hacked and
non hacked  server - that seems odd. There are a number of hacks that could
produce results that manipulate your files by adding content. 

This one uses the missing file handler:
http://www.coldfusionmuse.com/index.cfm/2013/12/5/attack.vector.missing.temp
late.handler

and can alter files.

This one that uses the (bad) practice of moving files to a URL accessible
folder before checking them - or relying JUST on the file extension. 
http://www.coldfusionmuse.com/index.cfm/2009/9/18/script.insertion.attack.ve
ctor

Either one of these is capable of producing an iframe or adding content to
files etc. Of course there are others - bad news I know. Sometimes the best
solution in these cases (the one that gives you the most reassurance and
least amount of time spent) is to reinstall on a pristine server - from a
repo if you have it. 

-Mark

P.S. let CFWT know if you need formal help on this.

Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Tom McNeer [mailto:tmcn...@gmail.com] 
Sent: Wednesday, November 12, 2014 10:40 AM
To: cf-talk
Subject: CF9.02 administrator hack


Hi,

I've just discovered that one of my servers, running 9.02, has been hacked.
I'm not sure of the update level, because the hack is visible in the
administrator and prevents its use.

It's not the old h.cfm hack. I haven't been able to find any references to
what I'm seeing, but I hope someone else knows what's up.

I have not seen any obvious problems caused in the sites delivered from the
server. It became evident when I tried to log in to the admin today to
check on something.

The immediate symptoms are that an ad appears in an iframe below the CF
Admin login inputs; the username input label has been restyled and appears
to have a link behind it.

A recurring popup says The page at b1.zcxbtm.com says: WARNING, Your Java
version is outdated, have security risks, Please update now.

Naturally, none of this is visible in View Source. No reference to other
files and scripts. The View Source is identical to one on a non-hacked
server.

The CF Admin is not publicly accessible - at least not normally. I can see
that a site was added and used temporarily which had a virtual directory
pointing to the admin, most likely one created by running the config tool.
That site is dead now, but it could easily have been a vector at one time.

The CF service _is_ running under the System account. I know this is bad
practice, but I didn't set up the server.

Any suggestions for troubleshooting this would be greatly appreciated. And
I'll certainly be happy provide any other details I can.

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359622
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: FW: CF9.02 administrator hack

2014-11-12 Thread Mark A Kruger

Claude,

The idea that there's no visible indication in the view source makes me
consider that as well - but why would it just appear on a login page for the
cfadmin? Perhaps it looks for specific form field names and throws up the
java out of date message to prey on fears of folks logging in to various
things... 

-Mark


-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Wednesday, November 12, 2014 1:40 PM
To: cf-talk
Subject: Re: FW: CF9.02 administrator hack


 There's no reason that content can't be injected at
serve time.

In this case, there would be a difference in the files delivered to the
visitor.
IMO the hack is in the browser, not on the server.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359628
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Distributive Mode

2014-10-17 Thread Mark A Kruger

Dave - he likes it the way it is let it go! (with my apologies to Elsa)
:D



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Friday, October 17, 2014 1:43 PM
To: cf-talk
Subject: Re: Distributive Mode


 For better security...piece of mind, I prefer to have my web servers
physically separated from my
 database servers and distributed mode lets me do this.

Again, so does using a reverse proxy. There is no additional security
provided by distributed mode that isn't provided by a reverse proxy.
The goal of both is to separate your application server (CF) from your
public-facing web server. This prevents any exploit of the
public-facing web server from allowing attackers to inject application
server code.

A reverse proxy is arguably a more secure approach than distributed
mode, since you can use different platforms for your public-facing web
server and your internal web+application server.

 I finally did find a good article

https://wikidocs.adobe.com/wiki/display/coldfusionen/WebSocket+Enhancements
that describes exactly
 what I need to do within CF11. I will give this a go and see if I have
success. Thanks for the help and
 advice.

That's not what web sockets are for, actually.
http://en.wikipedia.org/wiki/WebSocket

But you're welcome, and good luck with your CF endeavors!

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business
(SDVOSB) on GSA Schedule, and provides the highest caliber vendor-
authorized instruction at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359484
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFHTTP Raw Request

2014-10-14 Thread Mark A Kruger

Donnie,

you will need a sniffer on the server to see any HTTP request from CF.  If
you are doing local development (where cf is installed on your laptop or
desktop) then that's where your proxy/sniffer needs to live. CFHTTP is
technically not a browser request - just a straight HTTP request using
tcp.  I use wireshark for this - fiddler is more of a browser plugin - or at
least, it proxys it's data to a browser. I suspect it could work for
cfhttp request -just not positive as I've never tried it. Steve's suggestion
is a good one and fiddler (or Charles) is a great addition to your toolkit
but it may not work in this specific instance. Sorry to redirect your
efforts :)

-Mark


Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] 
Sent: Tuesday, October 14, 2014 11:53 AM
To: cf-talk
Subject: Re: CFHTTP Raw Request


I think I may be confused.  I need to see the raw headers that CFHTTP is
creating.  I installed Fiddler on the development and ran it. When I call
the CF page that includes the CFHTTP, I am not seeing any new requests in
Fiddler.  I'm not sure how a browser would show me CFHTTP headers that are
created.  Am I missing something?

Thanks,

Donnie Carvajal

 It's just a program that when run will sit between the browser and the 
 world outside the computer (internet, intranet, etc).  It displays 
 what is going in and out.
 
 It's an easy install and adds piece to IE/Chrome/Firefox as well as 
 installing the App.  You just run it and use your web browser.  If you 
 are working with HTTPS/SSL/TLS then there is a way to set it up to 
 track that data as well (Technically a man in the middle, but you are 
 doing it to yourself so it's ok).
 
 Steve
 -Original Message-
 From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com] 
 Sent: Tuesday, October 14, 2014 11:21 AM
 To: cf-talk
 Subject: Re: CFHTTP Raw Request
 
 
 Hi Steve,
 
 Thanks for the suggestion.  I've never used Fiddler before.  Are there 
 any special configurations to watch a cfhttp request?
 
 Thanks,
 
 Donnie Carvajal



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359466
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CFHTTP Raw Request

2014-10-14 Thread Mark A Kruger

Ah... so you would have to use the proxy/port attributes of the cfhttp tag.
I see how that would work. On the plugin install it sets that up for you
with the browser. Good to know.

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, October 14, 2014 12:11 PM
To: cf-talk
Subject: Re: CFHTTP Raw Request


 you will need a sniffer on the server to see any HTTP request from CF.  If
 you are doing local development (where cf is installed on your laptop or
 desktop) then that's where your proxy/sniffer needs to live. CFHTTP is
 technically not a browser request - just a straight HTTP request using
 tcp.  I use wireshark for this - fiddler is more of a browser plugin - or
at
 least, it proxys it's data to a browser. I suspect it could work for
 cfhttp request -just not positive as I've never tried it. Steve's
suggestion
 is a good one and fiddler (or Charles) is a great addition to your toolkit
 but it may not work in this specific instance. Sorry to redirect your
 efforts :)

Fiddler is more than a browser plugin. It's a proxy server, and can in
fact capture all outbound HTTP requests from your machine, regardless
of what they come from. I prefer Fiddler to Wireshark for this because
it's purely focused on HTTP/HTTPS and a lot easier to read.

However, you have to configure clients to use it as a proxy. With CF,
you can do this at the JVM level, or you can change your CFHTTP code
to use a specific proxy server.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business
(SDVOSB) on GSA Schedule, and provides the highest caliber vendor-
authorized instruction at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359468
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Avoiding a boat load of queries inserting multiple records - Better Way?

2014-10-10 Thread Gaulin, Mark

My experience with MS SQL Server is that you have to do multiple inserts using 
a series of UNION statements...

Insert into tablename(field1, field2, field3, field4 ...) 
select value1, value2, value3, value4 ...
union all select value1, value2, value3, value4 ...
union all select value1, value2, value3, value4 ...
union all select value1, value2, value3, value4 ...

Thanks
Mark

-Original Message-
From: DURETTE, STEVEN J [mailto:sd1...@att.com] 
Sent: Friday, October 10, 2014 8:19 AM
To: cf-talk
Subject: RE: Avoiding a boat load of queries inserting multiple records - 
Better Way?


Actually I believe the syntax is:
Insert into tablename(field1, field2, field3, field4 ...) Values
(value1, value2, value3, value4 ...),
(value1, value2, value3, value4 ...),
(value1, value2, value3, value4 ...);

Steve

-Original Message-
From: Mike K [mailto:afpwebwo...@gmail.com]
Sent: Friday, October 10, 2014 1:51 AM
To: cf-talk
Subject: Re: Avoiding a boat load of queries inserting multiple records - 
Better Way?


You do know that Microsoft changed the insert syntax as from SQLServer 2008
dont you?now you can insert multiple records in one go like this:

INSERT into Tablename (field1, field2, field3, field4 ) Values
( value1, value2, value3, value4 ... ;
value1, value2, value3, value4  ;
value1, value2, value3, value4 
)

IF you uave one of those fields as an index field (some databases call them
autonumber fields) you dont have to know what the current index value of
record 1 is when you insert record 2 .Or (i havent tried this buti
reckon it ought to work)  if say field1 was your index field,  you could
user the value Ident_Current('Tablename ')  as the value of field1 in the
subsequent records.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


On Fri, Oct 10, 2014 at 11:51 AM, Les Mizzell lesm...@bellsouth.net wrote:


   Not knowing much about your overall process, I'll try to stick to some
   generic ideas. Let's assume you don't need this stuff dumped into the
   database the very second it gets sent to you.








~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359445
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CF11 changes to Application.cfc - no mappings defined?

2014-10-08 Thread Gaulin, Mark

Hi Folks
Our single CF11 test server just highlighted a freaky difference between CF10 
and CF11 that has us all puzzled.  (We are running CF11 with the latest service 
pack.)

It appears that the CF mappings defined in CFIDE (such as /cfc - root dir 
for all of our CFC's) are not defined inside the block of code at the top of 
Application.cfc (outside of any method in Application.cfc).  This means we 
can't instantiate CFC's under the /cfc directory in that top script block area.

We know we can create CFC's in onApplicationStart(), but we currently use a CFC 
to set the Application's this.name and this.setDomainCookies, etc. 
variables, and I think those can only be changed right at the top of 
Application.cfc.

Is this a bug or something?  Why would globally-defined mappings not be 
available at the top of Application.cfc? (BTW, the per-Application 
this.mappings are also ignored in that top script block, so that's not a help 
either.)

Thanks
Mark

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359414
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF11 changes to Application.cfc - no mappings defined?

2014-10-08 Thread Gaulin, Mark

Hi Dean
Yes, we defined mappings in the CF Admin.  These mappings all work outside of 
the top script block, but not in it.

Here's a sketch of what currently works on CF10:

cfcomponent name=MyApplication output=false
cfscript
// All of these settings can be done by the configureAppSettings() call 
below...
//  this.name = App;
//  this.clientManagement = true;
//  this.sessionManagement = true;
//  this.setClientCookies = false;
//  this.applicationTimeout = createTimeSpan(2, 0, 0, 0);
//  this.setDomainCookies = true;

createObject(component, 
cfc.ApplicationSettings).configureAppSettings(app=this);

public void function onApplicationStart() {
this.applicationManager.onApplicationStart();
}

public void function onRequestStart() {
application.applicationManager.onRequestStart();
}
/cfscript
/cfcomponent


-Original Message-
From: Dean Lawrence [mailto:dean...@gmail.com] 
Sent: Wednesday, October 08, 2014 2:13 PM
To: cf-talk
Subject: Re: CF11 changes to Application.cfc - no mappings defined?


Mark,

When you say global mappings, are you saying that you created a mapping in the 
ColdFusion admin? Also, can you maybe share some of your Application.cfc code 
for us to get a better idea as to what you are trying to accomplish?

On Wed, Oct 8, 2014 at 1:58 PM, Gaulin, Mark mark.gau...@ihs.com wrote:


 Hi Folks
 Our single CF11 test server just highlighted a freaky difference 
 between
 CF10 and CF11 that has us all puzzled.  (We are running CF11 with the 
 latest service pack.)

 It appears that the CF mappings defined in CFIDE (such as /cfc - 
 root dir for all of our CFC's) are not defined inside the block of 
 code at the top of Application.cfc (outside of any method in 
 Application.cfc).  This means we can't instantiate CFC's under the 
 /cfc directory in that top script block area.

 We know we can create CFC's in onApplicationStart(), but we currently 
 use a CFC to set the Application's this.name and 
 this.setDomainCookies, etc. variables, and I think those can only be 
 changed right at the top of Application.cfc.

 Is this a bug or something?  Why would globally-defined mappings not 
 be available at the top of Application.cfc? (BTW, the per-Application 
 this.mappings are also ignored in that top script block, so that's 
 not a help either.)

 Thanks
 Mark

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359418
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF11 changes to Application.cfc - no mappings defined?

2014-10-08 Thread Gaulin, Mark

Hi Cameron
We can successfully use the /cfc mapping outside of the top script block, so I 
don't think it is reserved in that way.  We also observed that expandPath() 
behaves differently in the top script block vs in a Application.cfc method. (It 
expands the mappings paths properly in the method, but doesn't know any 
mappings in the top script block.)

Pretty weird...

Thanks
Mark

-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com] 
Sent: Wednesday, October 08, 2014 2:33 PM
To: cf-talk
Subject: Re: CF11 changes to Application.cfc - no mappings defined?


On Wed, Oct 8, 2014 at 1:58 PM, Gaulin, Mark mark.gau...@ihs.com wrote:

 It appears that the CF mappings defined in CFIDE (such as /cfc - 
 root dir for all of our CFC's) are not defined inside the block of 
 code at the top of Application.cfc


I would also test this with a global mapping not called cfc. That word may be 
reserved in CF11. I have no idea if it is, but it would be super easy for you 
to test.

-Cameron

--
Cameron Childress
--
p:   678.637.5072
im: cameroncf
facebook http://www.facebook.com/cameroncf | twitter 
http://twitter.com/cameronc | google+ 
https://profiles.google.com/u/0/117829379451708140985




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359419
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: CF11 changes to Application.cfc - no mappings defined?

2014-10-08 Thread Gaulin, Mark

Yup, I tried setting this.mappings as you suggest and it didn't change 
anything.  

We are getting the strong feeling that no mappings are applied, even the ones 
configured in CF Admin, until after the top script block has completed.  That 
explains all of the behavior that we see.  

Hmm.. this looks like a relevant bug: 
https://bugbase.adobe.com/index.cfm?event=bugid=3783403
It is marked fixed but it sounds like it isn't released yet 

Thanks
Mark

-Original Message-
From: Dean Lawrence [mailto:dean...@gmail.com] 
Sent: Wednesday, October 08, 2014 3:12 PM
To: cf-talk
Subject: Re: CF11 changes to Application.cfc - no mappings defined?


Hmm, that is odd. It may very well be a bug. I don't know for sure if the 
location of where you define the application properties is restricted to the 
top of your Application.cfc or not, but here are two things to try.

Placing the calling of your configuration cfc inside your
onApplicationStart() method:

cfcomponent name=MyApplication output=false
cfscript

public void function onApplicationStart() {
tcreateObject(component, 
cfc.ApplicationSettings).configureAppSettings(app=this);
this.applicationManager.onApplicationStart();
}

public void function onRequestStart() {
application.applicationManager.onRequestStart();
}
/cfscript
/cfcomponent

Or add an additional mapping above the call to the config cfc.

cfcomponent name=MyApplication output=false
cfscript

   THIS.mappings[/cfc]=path-to-cfc-folder;
   createObject(component,
cfc.ApplicationSettings).configureAppSettings(app=this);

   public void function onApplicationStart() {
this.applicationManager.onApplicationStart();
}

public void function onRequestStart() {
application.applicationManager.onRequestStart();
}
/cfscript
/cfcomponent



On Wed, Oct 8, 2014 at 2:39 PM, Gaulin, Mark mark.gau...@ihs.com wrote:


 Hi Dean
 Yes, we defined mappings in the CF Admin.  These mappings all work 
 outside of the top script block, but not in it.

 Here's a sketch of what currently works on CF10:

 cfcomponent name=MyApplication output=false
 cfscript
 // All of these settings can be done by the 
 configureAppSettings() call below...
 //  this.name = App;
 //  this.clientManagement = true;
 //  this.sessionManagement = true;
 //  this.setClientCookies = false;
 //  this.applicationTimeout = createTimeSpan(2, 0, 0, 0);
 //  this.setDomainCookies = true;

 createObject(component,
 cfc.ApplicationSettings).configureAppSettings(app=this);

 public void function onApplicationStart() {
 this.applicationManager.onApplicationStart();
 }

 public void function onRequestStart() {
 application.applicationManager.onRequestStart();
 }
 /cfscript
 /cfcomponent


 -Original Message-
 From: Dean Lawrence [mailto:dean...@gmail.com]
 Sent: Wednesday, October 08, 2014 2:13 PM
 To: cf-talk
 Subject: Re: CF11 changes to Application.cfc - no mappings defined?


 Mark,

 When you say global mappings, are you saying that you created a 
 mapping in the ColdFusion admin? Also, can you maybe share some of 
 your Application.cfc code for us to get a better idea as to what you 
 are trying to accomplish?

 On Wed, Oct 8, 2014 at 1:58 PM, Gaulin, Mark mark.gau...@ihs.com wrote:

 
  Hi Folks
  Our single CF11 test server just highlighted a freaky difference 
  between
  CF10 and CF11 that has us all puzzled.  (We are running CF11 with 
  the latest service pack.)
 
  It appears that the CF mappings defined in CFIDE (such as /cfc - 
  root dir for all of our CFC's) are not defined inside the block of 
  code at the top of Application.cfc (outside of any method in 
  Application.cfc).  This means we can't instantiate CFC's under the 
  /cfc directory in that top script block area.
 
  We know we can create CFC's in onApplicationStart(), but we 
  currently use a CFC to set the Application's this.name and 
  this.setDomainCookies, etc. variables, and I think those can only 
  be changed right at the top of Application.cfc.
 
  Is this a bug or something?  Why would globally-defined mappings not 
  be available at the top of Application.cfc? (BTW, the 
  per-Application this.mappings are also ignored in that top script 
  block, so that's not a help either.)
 
  Thanks
  Mark
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359422
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


(ot) Coldfusion leads for cash

2014-10-07 Thread Mark A Kruger

Folks, this is a little off topic but I'll try it here anyway and hope that
Michael doesn't slap me down.

 

CFWT has a new program for developers offering cash bonuses (10 month
residual) for help with locating new customers. It's generous and easy to
do. Check out this post on my blog.

 

http://www.coldfusionmuse.com/index.cfm/2014/10/7/coldfusion-referrals-for-c
ash

 

Again, I apologize if someone has a huge problem with this self interested
post :)  I promise to do extra CF community service in penance. 

 

-Mark

Mark Kruger - CFG

CF Webtools

 http://www.cfwebtools.com www.cfwebtools.com
 http://www.coldfusionmuse.com www.coldfusionmuse.com
O: 402.932.3318
E:  mailto:mkru...@cfwebtools.com mkru...@cfwebtools.com
Skype: markakruger

 




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359409
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: OT, but stil...

2014-09-04 Thread Mark A Kruger

Claude,

There is literally nothing (not a single thing) that is off limits on the
client side. You cannot trust or believe the browser is in any way shape or
form a secure environment and you must assume that things like cookies can
and will be hacked and experimented with. This is why it is important that
variables be tied to temporary entities on the client side (like expiring
session cookies) as you mention below. Beyond that your conclusions are
correct and scary - but the alternative is probably to close up shop and
move to a cabin in Montana :)

-Mark


-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Wednesday, September 03, 2014 10:29 PM
To: cf-talk
Subject: Re: OT, but stil...


 They don't call it Malware for nothing

Ok, but if a malware does mal to a moron client side, in a pinch, this is
not our problem, but if it can get pass words so easily, it can also do mal
to any server any time.
I just got one tonite that allows itself to define cookies under MY domain!
If it can store cookies, it can also read cookies, including session
cookies!
With the session Id, it does not even need the password.

I'd like to detect all pieces of javascript code defined in a document and
check if they are mine.
I was thinking of document.getElementsByTagName, but I'm not even sure all
parasit code will actually have a SCRIPT tag.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359230
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: OT, but stil...

2014-09-04 Thread Mark A Kruger

Yeah... I'd do it myself if I could get good wireless :D

-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Thursday, September 04, 2014 10:46 AM
To: cf-talk
Subject: Re: OT, but stil...


 close up shop and move to a cabin in Montana

That's the best suggestion I got on that matter ;-)




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359234
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: OT, but stil...

2014-09-03 Thread Mark A Kruger

Claude,

I think that perfectnavigator is a adware (some would say malware) that runs
on browser execution - so it becomes a part of the client side page request
against your will as it were.

I think your idea is excellent though - a way to trap client side errors and
tease them out and correct them. Nicely done.

-Mark


-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Tuesday, September 02, 2014 9:27 PM
To: cf-talk
Subject: OT, but stil...


This is not really CF related, but since this list is mainly read by Web
developers, I thought it could be interesting  anyway.

First, let me say that my system logs CF executions error in a database with
many details that help a lot to clean my code.
However it does not trap Javascript errors on client side, and with so many
types of browsers, in many versions and each one with parameters that the
user can de-activate without even knowing what the parameter is intended to,
the developper can never be sure his code will run correctly in any
circumstance.

Now, thanks to window.onerror, I just developped a Javascript error tracker
able to ajax some information to my server, including the url where the
error occured, the line number, stack, etc. and there it is: I even get
errors in code which is not mine!
It seems that some code which is not in my server runs somewhere in the
client browser and cause errors I can trap!

Some examples
Stack : TypeError: Argument or incorrect procedure at _watcherReady (Unknown
script code:5:13)
User agent : Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; ASU2JS;
rv:11.0) like Gecko
... there is no string like watcherReady anywhere in my code.

Template :
https://in2.perfectnavigator.com/injectScripts/index.php?id=Pj8sNyM
Message : Script error.
User agent : Mozilla/5.0 (Windows NT 6.2; WOW64; rv:31.0) Gecko/20100101
Firefox/31.0
How come this code at in2.perfectnavigator.com (which is not on my server)
can be executed from one of my pages, or at least the error event reported
to one of my pages ?

How about this one from Madagascar?
Template : http://www.youradexchange.com/script/java.php?option=rotateur
Message : Script error.
User agent : Mozilla/5.0 (Windows NT 6.0; rv:31.0) Gecko/20100101
Firefox/31.0
IP = 197.149.47.173 pays = Madagascar

Template : http://www.myDomain.com/ line : 418
Message : 'JSON' is undefined
User agent : Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0;
chromeframe/32.0.1700.107; GTB7.5; .NET CLR 1.1.4322; .NET CLR 2.0.50727;
.NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.3)
This one is in my code, but there is no Javascript at line 418 and JSON is
never used anywhere.


Ah! This one is in my code, very handy to know where to look at when there
is a problem on a Mac and you don't have a Mac.
Template :
http://www.myDomain.org/commun/customTags/textEditor/popupresize.js ligne :
72
Message : TypeError: 'undefined' is not a function (evaluating
'Number(frameObject.width)')
User agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4)
AppleWebKit/537.78.2 (KHTML, like Gecko) Version/7.0.6 Safari/537.78.2





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359225
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: code suddenly stops working for no apparent reason

2014-09-02 Thread Mark A Kruger

I would echo what Bobby said :)   

(cfbrickwall)

-Original Message-
From: Bobby [mailto:bo...@acoderslife.com] 
Sent: Tuesday, September 02, 2014 6:52 AM
To: cf-talk
Subject: Re: code suddenly stops working for no apparent reason


It isn¹t being explicitly passed, it is being explicitly referenced. The
template assumes it was passed in as part of the attributes
collection/scope (as per argumentcollection=#attributes#²). The error is
telling you that it is not in the attributes scope. The error is not wrong
so, like Phillip suggested, step back until you find where you think it is
being set and figure out why it isn¹t. Nothing you¹ve said or pasted will
let anywhere here give you much more info than that.


On 8/30/14, 3:44 PM, Phillip Vector vec...@mostdeadlygame.com wrote:


Apparently, it isn't. Go back further.


On Sat, Aug 30, 2014 at 12:08 PM, Matthew Smith chedders...@gmail.com
wrote:


 But it is being explicitly passed. That's where I'm lost.

  On Aug 30, 2014, at 12:44, Phillip Vector vec...@mostdeadlygame.com
 wrote:
 
 
  The reason is apparent.
 
  Element USERID is undefined in ATTRIBUTES.
 
  Trace the attribute back and figure out where it was set and see why
it
  isn't being set.
 
 
  On Sat, Aug 30, 2014 at 11:31 AM, Matthew Smith
chedders...@gmail.com
  wrote:
 
 
   cfcase value=createUser
   cfinvoke
  component=cfcs.qry-todatabase
  method=qry_peopleCreateNewUser
 argumentcollection=#attributes#
  returnvariable=qry_peopleCreateNewUser
   cfif qry_peopleCreateNewUser.returnKey eq -1
 cfset XFA.badLogin = #fusebox.thisCircuit#.go
 cfmodule fuseaction=#XFA.badLogin#
  error=badPassword
  emailaddress = #attributes.emailAddress#
  cfid=#cfid# cftoken=#session.cftoken#
  template=#fusebox.rootpath##modself#
 cfelse
 cfmodule
  fuseaction=#fusebox.thisCircuit#.startSession
  userid=#qry_peopleCreateNewUser.returnKey#
  template=#fusebox.rootpath##modself#
  cfid=#cfid# cftoken=#session.cftoken#
   /cfif
   /cfcase
   cfcase value=startSession
   cflock
  scope=SESSION
  timeout=10
  type=EXCLUSIVE
 cfset session.loggedIn = 1
 cfset variables.tmp = structdelete(session, billinginfo)
   /cflock
   cfset client.userID = attributes.userID
   cfset XFA.defaultReturnFuseaction = #fusebox.homeCircuit#.home
   cfif
 listFirst(evaluate(client.#fusebox.thiscircuit#returnFuseaction),
  .) eq SECUREOrderApp
 cfobject component=cfcs.qry-todatabase name=qry /
 cfset qry_orderInfoBufferCreate = qry.qry_orderInfoBufferEdit(
  cfuserid=#session.CFID#0#session.CFTOKEN#) /
 cfset qry_cartAssignPersonKey = qry.qry_cartAssignPersonKey(
  cfuserid=#session.CFID#0#session.CFTOKEN#, app_user_id =
  #CLIENT.USERID#) /
   /cfif
   cfinclude template=url_thisCircuit_returnFuseAction.cfm
   /cfcase
 
 
  getting this error even though explicitly passed...
 
  Element USERID is undefined in ATTRIBUTES.  The error occurred in
 
 
 
*D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/authenticati
on/fbx_Switch.cfm:
  line 91*
  *Called from*
 
 
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30
_CF50.cfm:
  line 273
  *Called from*
 
 
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30
_CF50.cfm:
  line 33
  *Called from*
 
 
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/fbx_fusebox30
_CF50.cfm:
  line 1
  *Called from*
  
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/index.cfm:
  line 9
  *Called from*
 
 
D:/Inetpub/redhotkitties/site_theartoflovingcatsanddogs_com/Application.c
fc:
  line 62
 
  89 : cfset variables.tmp = structdelete(session, billinginfo)
  90 :   /cflock*91 :   cfset client.userID = attributes.userID*
  92 :   cfset XFA.defaultReturnFuseaction =
 #fusebox.homeCircuit#.home
  93 :   cfif
  listFirst(evaluate(client.#fusebox.thiscircuit#returnFuseaction),
  .) eq SECUREOrderApp
 
 

 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359222
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Insite Help on CF Hanging?

2014-07-23 Thread Mark A Kruger

Client purge is removing client vars that are too old. If you have client
variables set to default they will be stored in the registery (win) or a big
XML file. The purge process removes them. To fix this:

A) Verify that you need client vars. If you don't adjust your application
settings accordingly.
B) if you DO need them I recommend that you
1) store them in a DB
2) do not set global variables unless you are using them (hitcount
and last access) because this results in additional DB connection updates.

As for you memory - at Idle a well tuned CF Server might indeed use half a
gig or more. On a 64 bit installation half a gig is pretty close to the
minimum required. Moreover I recommend that you set your min/max heap sizes
to the same value so what would see (even at idle) is a large and fairly
static memory footbpring - particallary if you are looking at the commit
size in task manager.

-Mark


Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Wednesday, July 23, 2014 8:52 AM
To: cf-talk
Subject: Insite Help on CF Hanging?


Had a site go down in the early morning hours the last two days - 
Coldfusion hangs -  requiring a restart to get it back up again.

Running CF 10 on Windows Server 2008 R2

1. No major errors in the log files.
2. Log files are set to relatively small size limits
3. Something seems to be eating a LOT of memory. Even at idle, CFServer 
is using almost half a gig memory
4. What's is Client Purge and why could this possibly hang CF ( this 
appears to have run approximately around the time of the outage) - and 
why now after over a year with zero outages?

That's about all I've got so far. Still researching
Any other things I should be looking at/for?

TIA




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358989
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Insite Help on CF Hanging?

2014-07-23 Thread Mark A Kruger

Tia,

FYI - storing client vars in the registry and locking up during the purge is
a fairly common trouble spot. I would not be surprised if that is your
problem. It can show up after a while too - because the client vars
persist for 30 days, so you can suddenly see problems 30 days after an
increase in traffic as the system tries to remove a boatload of client vars.

-Mark


-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Wednesday, July 23, 2014 8:52 AM
To: cf-talk
Subject: Insite Help on CF Hanging?


Had a site go down in the early morning hours the last two days - 
Coldfusion hangs -  requiring a restart to get it back up again.

Running CF 10 on Windows Server 2008 R2

1. No major errors in the log files.
2. Log files are set to relatively small size limits
3. Something seems to be eating a LOT of memory. Even at idle, CFServer 
is using almost half a gig memory
4. What's is Client Purge and why could this possibly hang CF ( this 
appears to have run approximately around the time of the outage) - and 
why now after over a year with zero outages?

That's about all I've got so far. Still researching
Any other things I should be looking at/for?

TIA




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358990
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-22 Thread Mark A Kruger

I hope the art of loving cats and dogs is painting or crafts or something
:D

-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Tuesday, July 22, 2014 8:49 AM
To: cf-talk
Subject: Re: Having trouble with cfcI have removed all references to
site_theartoflovingcatsanddogs_com and deleted the template cache. No luck.
Any help?


 maybe he's a bot?

If he is, sure he didn't programed it himself.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358958
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: element undefined

2014-07-20 Thread Mark A Kruger

Matthew,

Where did you add it? It won't work in the general body of the cfc. It will
need to be in onRequest() or onRequestStart() 

-Original Message-
From: Matthew Smith [mailto:chedders...@gmail.com] 
Sent: Sunday, July 20, 2014 1:46 PM
To: cf-talk
Subject: Re: element undefined


here is what I have added:

here is Application.cfc.  I have added a cfset without success.  Please
help.

cfcomponent
output=false
hint=I define the application and event handlers.
cfset THIS.Name = fatcate-juice /
cfset this.applicationTimeout = createTimeSpan( 0, 0, 20, 0 ) /
cfset this.sessionManagement = true /
cfset this.clientmanagement = true /
cfset this.SetClientCookies = true /
cfset this.sessionTimeout = createTimeSpan( 0, 0, 30, 0 ) /
cfset this.enablerobustexception=yes
cfset request.path = replace(cgi.PATH_TRANSLATED, mid(cgi.SCRIPT_NAME,
2, (len(cgi.SCRIPT_NAME)-1)), )
Cfset request.cfcpath = cfcs.
cfset request.currentsitename = fatcate-juice.com
cfif cgi.REMOTE_ADDR contains 192.168.1
  cfset variables.requested_url = cgi.REDIRECT_URL
  cfelse
  cfset variables.requested_url =  cgi.path_info
/cfif
cffunction
name=onRequestStart
 access=public
returntype=boolean
output=false
 hint=I execute when a request needs to be initialized.
  !--- Define arguments. ---

  cfargument
name=template
 type=string
required=true
hint=I am the template that the user requested./
  cfparam name=variables.currentsitename default=fatcate-juice.com




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358928
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Moving part of my hosting business - thoughts about my plan please ...

2014-06-03 Thread Mark A Kruger

We use CentOS extensively here at CFWT and have many customers using it as
well. Very solid. 

-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: Tuesday, June 03, 2014 10:29 AM
To: cf-talk
Subject: Re: Moving part of my hosting business - thoughts about my plan
please ...




 I like RHEL/CentOS because they are pretty stable and they don't do
 bleeding
 edge, main bug/security fixes, you have to upgrade to the next major
 release to upgrade major versions of many packages.


Yeah what Pete said,

I have been on Centos and RedHat for years. It is very stable but the
package manager seems to be a few versions behind the latest release of
software packages. This is mostly for security and stability reasons, i.e.
they err on the side of caution. Which is fine and dandy with me.

There are a multitude of hosting CF's out there what will automate a lot
of, if not most, admin chores. But the downside of these are of course
security concerns. The most infamous of which is Kloxo:

http://en.wikipedia.org/wiki/Kloxo#Security_issues

So caveat emptor and do your research first.

G!

*Gerald Anthony Guido*
Nullius in verba http://en.wikipedia.org/wiki/Nullius_in_verba
-- Horace

Twitter https://twitter.com/CozmoTrouble
Facebook https://www.facebook.com/gerald.guido.9


On Tue, Jun 3, 2014 at 10:26 AM, Pete Freitag p...@foundeo.com wrote:


 On Fri, Mar 28, 2014 at 5:21 AM, Mike K afpwebwo...@gmail.com wrote:

  Are there any other 'gotchas' moving from windows to linux?
 

 I did a presentation on Linux for CF users at cf.Objective() this year, my
 slides are here: http://slides.com/petefreitag/cf-on-linux#/

 Is there any benefit of one flavour of Linux over another?
 

 Yes, if you pick an obscure distribution intended for hardcore linux users
 (for example Gentoo linux) you will have a hard time as a newbie. Pick one
 that is commonly used such as Redhat Enterprise Linux / CentOS or Ubuntu.
I
 like RHEL/CentOS because they are pretty stable and they don't do bleeding
 edge, main bug/security fixes, you have to upgrade to the next major
 release to upgrade major versions of many packages. This has downsides
too,
 for example RHEL/CentOS 6.x will only support Apache 2.2.x if you want
 Apache 2.4 you have to install it manually or wait for RHEL7.

 --
 Pete Freitag - Adobe Community Professional
 http://foundeo.com/ - ColdFusion Consulting  Products
 http://hackmycf.com - Is your ColdFusion Server Secure?
 http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10
 minutes


 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358709
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: max heap

2014-04-03 Thread Mark A Kruger

1.8 is possible on a linux 32bit server... on a windows 32 bit is closer to
1.4 - a lot depends on the overall settings you choose.

As for 64bit the upper limit is purley theoretical and you will likely never
reach it - probably more than a petabyte.  In practice we have some 12gig
heaps running successfully - and more is possible.  It's just that you tend
to start running more instances or servers rather than continuing to up the
heap size.

-mark


-Original Message-
From: John M Bliss [mailto:bliss.j...@gmail.com] 
Sent: Thursday, April 03, 2014 5:50 AM
To: cf-talk
Subject: Re: max heap


Thanks. Are others seeing this (On 32 bit, I have never been able to set
it much more than 1 GB)?


On Thu, Apr 3, 2014 at 6:42 AM, Russ Michaels r...@michaels.me.uk wrote:


 I have never got close to 1.8 on a 32bit OS, but then you also have to
 consider the memory usage in addition to the heap size.
 CF itself uses a bunch of memory as it is a java app, then there are the
 perm gen sizes and what not, so your max heap size will depend on other
 settings.
 I have never been able to set it much more than 1GB.

 on 64bit you can use all the available memory but 64bit also uses about
 twice as much to begin with


 On Thu, Apr 3, 2014 at 11:04 AM, John M Bliss bliss.j...@gmail.com
 wrote:

 
  Sorry. Was referring to maximum POSSIBLE. i.e. 32 bit OS have a cap of
 1.8
  GB, right...?
  http://helpx.adobe.com/coldfusion/kb/maximum-jvm-heap-size-greater.html
 
 
  On Wed, Apr 2, 2014 at 11:47 PM, Wil Genovese jugg...@trunkful.com
  wrote:
 
  
   There is no such reference. Each server/application(s) has it's own
 needs
   that must be evaluated on a case by case basis. The only general rule
 of
   thumb that can be applied is that 64bit systems tend to need more JVM
  heap
   than a 32bit system and that isn't even set in stone. It still depends
 on
   the web application(s) needs.
  
   Regards,
  
   Wil Genovese
   Sr. Web Application Developer/
   Systems Administrator
   CF Webtools
   www.cfwebtools.com
  
   wilg...@trunkful.com
   www.trunkful.com
  
  
  
   On Apr 2, 2014, at 9:14 PM, John M Bliss bliss.j...@gmail.com wrote:
  
   
Hi. Does anyone know of a simple-ish reference showing:
   
ACF version
ACF standard v enterprise (if that matters)
OS (Windows v Linux)
OS version (if that matters)
OS 32 bit v 64 bit
   
...and correlated max heap size?
   
--
John Bliss - http://www.linkedin.com/in/jbliss
   
   
   
  
  
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358295
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: max heap

2014-04-03 Thread Mark A Kruger

Dave,

I worked with that 3GB switch to try to get up to 2g heap but was never able
to do it successfully - get a large heap I mean. Never tried it was jrocket
though.

-Mark



-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Thursday, April 03, 2014 9:08 AM
To: cf-talk
Subject: Re: max heap


 1.8 is possible on a linux 32bit server... on a windows 32 bit is closer
to
 1.4 - a lot depends on the overall settings you choose.

 As for 64bit the upper limit is purley theoretical and you will likely
never
 reach it - probably more than a petabyte.  In practice we have some 12gig
 heaps running successfully - and more is possible.  It's just that you
tend
 to start running more instances or servers rather than continuing to up
the
 heap size.

Actually, it is possible to exceed that on 32-bit Windows Server 2003
with a switch at system startup.

https://blogs.oracle.com/jrockit/entry/how_to_get_almost_3_gb_heap_on_window
s

That said, I've never bothered to do this, and am not sure it would be
a great idea anyway.

As for max heap size in general, I don't think there's anything
CF-specific about it. CF will use whatever is available if it needs to
use it, but heap size is completely controlled by the JVM.

Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358297
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Jrun Restarts Itself Every Few Minutes - CF 8

2014-02-06 Thread Mark A Kruger

Look in the runtime/bin directory for any hotspot errors.  Hsxx.log
usually. If you find any they should give you a clue where to look.

-Original Message-
From: E Cohen [mailto:eron_co...@yahoo.com] 
Sent: Thursday, February 06, 2014 9:12 AM
To: cf-talk
Subject: Jrun Restarts Itself Every Few Minutes - CF 8


Hello All,

I am having a problem with one of my ColdFusion 8 production servers.  JRUN
seems to be the issue--it is restarting itself every few minutes and I don't
know why.  This is the error I find in the Windows Server 2008 R2
Application error log:

Faulting application name: jrun.exe, version: 4.0.7.43137, time stamp:
0x47d937de
Faulting module name: MSVCR100.dll, version: 10.0.30319.1, time stamp:
0x4ba220dc
Exception code: 0xc417
Fault offset: 0x0007038c
Faulting process id: 0x14e8
Faulting application start time: 0x01cf234798a16348
Faulting application path: C:\ColdFusion8\runtime\bin\jrun.exe
Faulting module path: C:\Windows\system32\MSVCR100.dll
Report Id: 28eeef4c-8f3b-11e3-95a9-80ee73328ead

I have tried uninstalling and re-installing ColdFusion but the problem
continues.  Can anyone give me any other ideas of where to look or how to
troubleshoot this? 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357597
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Jrun Restarts Itself Every Few Minutes - CF 8

2014-02-06 Thread Mark A Kruger

Eron,

Ok, next step will be to ask about your JVM arguments and your hardware. Is
this a VM? Are there I/o errors?  What version of Java are you running? Is
it 64bit cf8 ent or 32 bit cf8 ent or 32 bit standard CF 8 is long in
the tooth and it's worth remembering it was out well before 08r2. If you are
running 32bit on the 08r2 platform it's not a common config.

-Mark


-Original Message-
From: E Cohen [mailto:eron_co...@yahoo.com] 
Sent: Thursday, February 06, 2014 9:36 AM
To: cf-talk
Subject: Re: Jrun Restarts Itself Every Few Minutes - CF 8


Thanks Mark.  I have checked in the runtime\bin directory and there aren't
any log files in there of any sort.  I also checked the log files in
runtime\logs and there isn't anything very interesting there either aside
from the frequent errors in coldfusion-out and coldfusion-event logs that
states   There is no web application configured to service your request
but I think that's an effect of jrun crashing, not the cause.

I'd really appreciate any other ideas anyone may have!  This is a huge
problem for me right now.

Look in the runtime/bin directory for any hotspot errors.  Hsxx.log
usually. If you find any they should give you a clue where to look.

Hello All,

I am having a problem with one of my ColdFusion 8 production servers.  JRUN
seems to be the issue--it is restarting itself every few minutes and I
don't
know why.  This is the error I find in the Windows Server 2008 R2
Application error log:

Faulting application name: jrun.exe, version: 4.0.7.43137, time stamp:
0x47d937de
Faulting module name: MSVCR100.dll, version: 10.0.30319.1, time stamp:
0x4ba220dc
Exception code: 0xc417
Fault offset: 0x0007038c
Faulting process id: 0x14e8
Faulting application start time: 0x01cf234798a16348
Faulting application path: C:\ColdFusion8\runtime\bin\jrun.exe
Faulting module path: C:\Windows\system32\MSVCR100.dll
Report Id: 28eeef4c-8f3b-11e3-95a9-80ee73328ead

I have tried uninstalling and re-installing ColdFusion but the problem
continues.  Can anyone give me any other ideas of where to look or how to
troubleshoot this? 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357600
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Jrun Restarts Itself Every Few Minutes - CF 8

2014-02-06 Thread Mark A Kruger

Awesome!  Usually when you have an abend on a jar file you get an
hs_err_ file generated somewhere. 

-Original Message-
From: E Cohen [mailto:eron_co...@yahoo.com] 
Sent: Thursday, February 06, 2014 12:24 PM
To: cf-talk
Subject: Re: Jrun Restarts Itself Every Few Minutes - CF 8


PROBLEM SOLVED

It turns out that CFX_OPENIMAGE had been chocking on a corrupted file--and
every time it was asked to process that file the server would
crashnice...

THANKS AGAIN 

 Mark-
 
 Thanks again for trying to help.  The server has been running for 
 quite a while without problems.  It is just a regular standalone 
 server with the default JVM.  Interestingly, I just uninstalled and 
 reinstalled as a multiserver and the same crash still happens.  The 
 Coldfusion version is CF 8 Enterprise.  I am starting to wonder if it 
 isn't some windows update that could have caused this.
 
 As I just reinstalled Coldfusion (a couple of times) this morning, I 
 don't think there is anything special about my jvm.config file or java 
 installation - the startup arguments look like this at the moment:
 
 java.args=-server -Xmx512m -Dsun.io.useCanonCaches=false 
 -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch -Dcoldfusion.
 rootDir={application.home}/../ -Djava.security.policy={application.
 home}/../lib/coldfusion.policy -Djava.security.auth.
 policy={application.home}/../lib/neo_jaas.policy -Dcoldfusion.
 classPath={application.home}/../lib/updates,{application.home}/../lib,
 {application.home}/../gateway/lib/,{application.home}/..
 /wwwroot/WEB-INF/cfform/jars -Dcoldfusion.libPath={application.home}/..
 /lib
 
 I have 3 versions of MSVCR100.dll on my computer, but none of them are 
 inside the ColdFusion directory (one is in the clam antivirus folder, 
 on in the windows/system32 folder and the other in the 
 windows/SYSWOW64 -- file sizes and dates are a little different on all 
 three )
 
 What sort of I/O errors would I look for?
 
 Thanks again!
 
 Eron,
 
 Ok, next step will be to ask about your JVM arguments and your 
 hardware. Is
 this a VM? Are there I/o errors?  What version of Java are you 
 running? Is
 it 64bit cf8 ent or 32 bit cf8 ent or 32 bit standard CF 8 is 
 long in
 the tooth and it's worth remembering it was out well before 08r2. If 
 you are
 running 32bit on the 08r2 platform it's not a common config.
 
 -Mark
 
 
 Thanks Mark.  I have checked in the runtime\bin directory and there 
 aren't
 any log files in there of any sort.  I also checked the log files in
 runtime\logs and there isn't anything very interesting there either 
 aside
 from the frequent errors in coldfusion-out and coldfusion-event logs 
 that
 states   There is no web application configured to service your 
 request
 but I think that's an effect of jrun crashing, not the cause.
 
 I'd really appreciate any other ideas anyone may have!  This is a 
 huge
 problem for me right now.
 
 Look in the runtime/bin directory for any hotspot errors.  Hsxx.
 log
 usually. If you find any they should give you a clue where to look.
 
 Hello All,
 
 I am having a problem with one of my ColdFusion 8 production servers.  
 JRUN
 seems to be the issue--it is restarting itself every few minutes and 
 I
 don't 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357606
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Hosting... Again

2014-01-13 Thread Mark A Kruger

Edge Web hosting should be on your list. They are exceptionally good as
well.

-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com] 
Sent: Friday, January 10, 2014 7:22 AM
To: cf-talk
Subject: Hosting... Again


Hi All,

I've got a lot of large CF sites I have to move because my host is not up to
what we've grown to be.  Love the guy and been with him for years, but now I
have to go.

I've asked this before (in October), but now that I'm no longer in denial
I'm looking for CF hosting recommendations again.  I have the previous
recommendations which I'm listing below.

If anyone has comments about any of the hosts below, or better
recommendations, please provide your feedback.  I'm about to move a boatload
of serous sites. 

So far, I've gotten recommendations for:
Hostek
Viviotech
CrystalTech
http://www.kickassvps.com/
Please let me know if you have additional recommendations or feedback on
these hosts.

Thanks,
Robert



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357403
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Simple SQL Query sometimes really Slow?

2013-12-05 Thread Mark A Kruger

Brooke,

Couple of points of inquiry.

1) 50k records can be a little OR a lot. How much actual data is returned.
Is a lot of textual? Management studio might look really fast but the
problem could be a lot of character data buffering to the web server.

2) have you looked at the activity monitor? Filter by your connection and
watch for blocks or waits - taking note of the process blocking.

3) Indexing might be ok but maybe not. Take a look at the execution plan
in Management Studio - it can tell you what the most expensive operations of
the query are.

4) Double check parallelism on the server. This can bite you under certain
conditions and will result in what look like randomly slow queries with no
seeming blocks. See my blog post about it:
http://www.coldfusionmuse.com/index.cfm/2011/11/18/cf.mssql.parallelism

Hope this helps a little. Good luck!

-mark




-Original Message-
From: Brook Davies [mailto:cft...@logiforms.com] 
Sent: Thursday, December 05, 2013 11:26 AM
To: cf-talk
Subject: Simple SQL Query sometimes really Slow?


This may not be the right place to post this (man, CF-TALK has changed a lot
in the last 5 or so years ;)).

 

I have a simple SQL query that is showing up as running slow. When I run it
via the Management Studio it is sometimes fast 0.1 seconds and sometimes,
seemingly randomly slow 1.5 minutes!). Other queries on other tables are
executing normally. This table only has 50k records and even a simple query
is sometimes really slow.

 

The query that runs slow is as simple as

 

select commitDate,id from databaseChangeLog 

where usr_id = 62622 and form_id = 312468 

and commitDate  '2013-12-04 11:00:05.0'

 

But is just as slow without the date part. The table has a clustered index
on the primary key (id) and a non-clustered index on usr_id,form_id and
commitDate. The index doesn't seem to make any difference.

 

My guess is the table is locked. My question is:

 

How can I determine if it is locked? What would be locking it. I checked all
my code and there are no CFTRANSACTIONS or ISOLATED READS or anything like
that. There are some inserts and the table has 2 TEXT columns which are
being updated at times with fairly large values. But the only queries
reported as slow are these simple SELECTS. The query execution plan uses the
non-clustered index on (usr_id,form_id and commitDate).

 

I'm just at a loss as to why this specific query is sometimes so slow..
where to look?

 

Brook






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357290
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: isValid - numeric vs. float

2013-12-04 Thread Mark A Kruger

Scott,

Ok.. this is simple but remember that val( ) actually returns a number if
the first part of the string IS a number, and a zero if it is not:

Val(343,200) returns 343
Val(ABC123) returns 0.00

So if you know you are dealing numbers above zero you can use this as a
quick and easy Boolean function. As in

If(val(23,320,2300.00))
{
..then whatever code you need to strip commas and further manage the
variable.
)

Just a thought :)



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Scott Brady [mailto:dsbr...@gmail.com] 
Sent: Wednesday, December 04, 2013 8:34 AM
To: cf-talk
Subject: Re: isValid - numeric vs. float


Well, in our case, this started out as a way for us to determine if the
variable we're dealing with is a number that we'd need to strip the commas
from. Due to the nature of our code, we only want to strip out the commas
if it's a number.  For us, the bug actually works in our favor, because
that's really the only way to determine if it was a number.  (Our other
alternative was to do an lsPareNumber() inside a try/catch block, which may
be the way we have to go if Adobe fixes the bug.

Scott


On Wed, Dec 4, 2013 at 8:27 AM, Jon Clausen
jon_clau...@silowebworks.comwrote:


 Agreed.  I would recommend stripping the commas out before you validate
 the number.   They do strange things with calculations.  For instance,
  numberFormat() converts “1,000” to 41274, as does JavaCast(“int”,”1,000)
 or JavaCast(“float”,”1,000).  I actually think it’s kind of incorrect
that
 the default behavior for numberFormat(1000) returns 1,000 as it can mess
up
 your calculations, but it’s been the default for so long, it would
probably
 break backward compatibility for a bunch of apps.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357272
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Problem with data formatting in CFINSERT

2013-11-05 Thread Mark A Kruger

Ben,

Moving from MS Access to MS SQL is one of the easiest options for migration
I'm afraid. 

FYI you CAN get Access running on 08r2 with CF 64bit. It just takes some
work.

-Mark

-Original Message-
From: Ben [mailto:b...@webworldinc.com] 
Sent: Tuesday, November 05, 2013 9:07 AM
To: cf-talk
Subject: Re: Problem with data formatting in CFINSERT


Hi Russ

For those of us who have been out of the loop for a while, can you suggest
easy to implement alternatives to 32 bit MS access? I did a conversion of a
DB to SQL server some years back and that was painful. 

Ben

 On Nov 5, 2013, at 7:52 AM, Russ Michaels r...@michaels.me.uk wrote:
 
 
 well someone has to say it...
 but why the frack are you still using MSACCESS when there are so many
 better/free alternatives?
 you know the Jet driver (which is what you use to connect to MSACCESS) is
 no longer supported by Microsoft and ha snot been for years and only runs
 in 32 bit, and as such does not work on modern 64bit OS (without lots of
 hacking to get it to run in 32bit mode), which is Windows Server 2008
 onwards, there is no 32 bit windows any more.
 
 
 
 On Tue, Nov 5, 2013 at 2:44 PM,  wrote:
 
 
 I have robot updaters and inserters too (made all the more robotic with
 the
 help of cfdbinfo figuring out the field types),
 
 This is what I do, but using my own CFX_ODBCinfo I developped years
before
 cfdbinfo was available,
 and I'm still using it because cfdbinfo doesn't work for Access
databases.
 
 Debugging is miserable with a layer of
 code in the middle and straightforward without.
 
 Right, I think I'm going to improve my CF_INSERT tag by generating the
SQL
 code in the tag.
 
 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357039
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Hosting

2013-10-21 Thread Mark A Kruger

Robert,

Enterprise level meaning?  If you are going to host multiple dedicated
servers I suggest you speak with EdgeWeb Hosting. They do a fabulous job and
provide superlative management services. 

-Mark

-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com] 
Sent: Monday, October 21, 2013 8:04 AM
To: cf-talk
Subject: Hosting


I know this has been asked 100 times before, but it looks like I need a new
cf hosts that can host enterprise level sites.  Any recommendations?

I've have gone to the archives but the HOF site is down. 


Robert Harrison 
Director of Interactive Services

Austin  Williams
Advertising I Branding I Digital I Direct  
125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788
T 631.231.6600 X 119   F 631.434.7022   
http://www.austin-williams.com

Blog:  http://www.austin-williams.com/blog
Twitter:  http://www.twitter.com/austin_



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356953
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: HttpOnly session cookie setting ignored in CF10

2013-10-03 Thread Mark A Kruger

Tom,

Can you pass the cookie into your SWF from the calling page using flash vars
and JS?

-mark

-Original Message-
From: Tom McNeer [mailto:tmcn...@gmail.com] 
Sent: Thursday, October 03, 2013 10:05 AM
To: cf-talk
Subject: HttpOnly session cookie setting ignored in CF10


Hi,

I have a client application which uses a Flex front end. It runs on CF9,
but I have recently updated my dev server to CF10.

Part of the application allows files to be uploaded to the server. A
problem has existed for a long time that would cause an error when posting
a file upload to a CF routine because the session information, which is
normally passed correctly on data requests, is not passed on an upload.

The traditional workaround has been to include the jsessionid as a URL
param when calling the CF page. And this works fine for me on the live CF9
site.

But the same routine is failing on my dev server.

The problem appears to be that the session cookies are being set as
HttpOnly, and can't be accessed by the Flex call (just as they would fail
on an ajax call).

However, I am not able to get CF to send the cookies as HttpOnly=false. I
have unchecked both the Secure and HttpOnly options in the CF Admin. And my
Application.cfc contains this.sessioncookie.httponly=false.

Yet despite this, and restarting the CF service just from fun, when I
access the dev site and examine the cookie content (in multiple browsers),
the cookies (jsession, CFID and CFTOKEN) are all set as httpOnly=true.

Does anyone have any thoughts on this?

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356869
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: HttpOnly session cookie setting ignored in CF10

2013-10-03 Thread Mark A Kruger

Tom,

Ah.. got it. Because there's it's not accepting it as a URL var it craps
out.

-Mark


-Original Message-
From: Tom McNeer [mailto:tmcn...@gmail.com] 
Sent: Thursday, October 03, 2013 11:24 AM
To: cf-talk
Subject: Re: HttpOnly session cookie setting ignored in CF10


Mark,

Thanks for the reply.

Yes, that's the technique I've been using. The jsessionid is passed via
FlashVars to the SWF. And the jsessionid is then passed from the SWF as a
URL variable in the upload call.

This is what's working on the live CF9 site. But on my CF10 dev server, I'm
getting a 302 redirect, which is what occurred in CF9 before I learned to
pass the jsessionid with the request.

It's not the lack of the session information that's the problem (I don't
think). It's that regardless of my server and application settings, the
session cookies are set as HttpOnly, and thus the variable in the request
from the SWF is not recognized.

At least, that's my current theory.


On Thu, Oct 3, 2013 at 11:46 AM, Mark A Kruger
mkru...@cfwebtools.comwrote:


 Tom,

 Can you pass the cookie into your SWF from the calling page using flash
 vars
 and JS?

 -mark

 -Original Message-
 From: Tom McNeer [mailto:tmcn...@gmail.com]
 Sent: Thursday, October 03, 2013 10:05 AM
 To: cf-talk
 Subject: HttpOnly session cookie setting ignored in CF10


 Hi,

 I have a client application which uses a Flex front end. It runs on CF9,
 but I have recently updated my dev server to CF10.

 Part of the application allows files to be uploaded to the server. A
 problem has existed for a long time that would cause an error when posting
 a file upload to a CF routine because the session information, which is
 normally passed correctly on data requests, is not passed on an upload.

 The traditional workaround has been to include the jsessionid as a URL
 param when calling the CF page. And this works fine for me on the live CF9
 site.

 But the same routine is failing on my dev server.

 The problem appears to be that the session cookies are being set as
 HttpOnly, and can't be accessed by the Flex call (just as they would fail
 on an ajax call).

 However, I am not able to get CF to send the cookies as HttpOnly=false. I
 have unchecked both the Secure and HttpOnly options in the CF Admin. And
my
 Application.cfc contains this.sessioncookie.httponly=false.

 Yet despite this, and restarting the CF service just from fun, when I
 access the dev site and examine the cookie content (in multiple browsers),
 the cookies (jsession, CFID and CFTOKEN) are all set as httpOnly=true.

 Does anyone have any thoughts on this?

 --
 Thanks,

 Tom

 Tom McNeer
 MediumCool
 http://www.mediumcool.com
 1735 Johnson Road NE
 Atlanta, GA 30306
 404.589.0560




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356871
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Application.cfm/c

2013-09-25 Thread Mark A Kruger

Your admins might be referring to the idea that some OTHER application.cfm/c
is being called when none is in the root of the site. These are issues that
can generally be resolved but they have to be understood. I'd get more info.

-Original Message-
From: Byron Mann [mailto:byronos...@gmail.com] 
Sent: Tuesday, September 24, 2013 10:39 PM
To: cf-talk
Subject: Application.cfm/c


Trying to wrap my head around any implications around not using an
application file.

Our admins are telling me that we run into issues with customers on our
shared platform not having one. (they didn't specify the issues in the
email).

I can see how non-unique application names might be an issue, but I'm
failing to see any pitfalls to not having one. If anything I would say it
would improve performance, since you could not use application, session and
client scope, thus using less memory utilization.

Looking for any experience where this may have been an issue before I talk
to them tomorrow.

Byron Mann
Lead Engineer  Architect
HostMySite.com




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356835
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: move database with Java

2013-09-17 Thread Mark A Kruger

Hmm... I think I would download a manager for mysql written in java (I seem
to recall one on sourceforge) and just tell your boss - look, I'm using
Java!

-Mark


-Original Message-
From: morchella [mailto:morchella.delici...@gmail.com] 
Sent: Tuesday, September 17, 2013 8:14 AM
To: cf-talk
Subject: move database with Java


Hey Guys, i know this is not necessarily a cf question.
i know next to nothing about java, other then creating a scheduled job to
copy a table.

now my employer has tasked me with moving or backing up a MySQL DB from one
server to another.

to me this sounds crazy. but i am not supposed to use cf, or built in
MySqlEnterprise tools.

Have any of you guys done this with java before?
are there any links/examples you could suggest.

i don't think it can be done quickly, as in from midnight to 5am kinda
thing.
any help would be Massively appreciated!

Thank you!
~m




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Good jvm ram settings for 64 bit ColdFusion

2013-09-03 Thread Mark A Kruger

Michael,

This is out of my head so forgive me if I am off on a factual point or two -
but you will get the gist of it.

In 32 bit addressing each memory address takes up 4 bytes (4 x 8  bits)
but a 64 bit address space is wider (as in 8 x 8 bits).  So for example, if
you store an integer - say 14 - on a 32 bit system, it will take 4 bytes to
do it (   1110).  Of course you might think
h... it could actually store that in a single byte - but being that
draconian with storage would only slow the computer down. It needs lots of
address spaces of uniform size. Think of a post office with dozens of
P.O. Boxes - little cubbies where mail is placed. It would not make sense
for them to resize each box for the volume of mail. They just accept the
fact that some boxes have 1 letter and others may have 12 or 13.

In a 64bit address space however the address spaces are wider (by another 32
bits). So that 14 is going to look like    
   1110 internally. The advantage of 64bit is
NOT in speed of addressability. They are generally faster because they are
new gen systems with faster FSB, shorter electron paths, better L2/3 caches
etc.  The advantage is in total addressability. The 32 bit system is limited
to 2 to the 32nd power (4.2 billion add addresses) whereas 64 bit systems
have 2 to the 64th power addresses.  The width means exponentially more
addresses available as PO boxes for bits of things that need storing. When
I say exponential I mean something like 16 exabytes of possible addressable
space.  

So the good news is that a 64 bit system can utilize an unlimited amount of
memory (unlimited in any practical sense at this point in our computer
evolution). The bad news is, it takes more room to store equivalent data. 

-Mark



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] 
Sent: Tuesday, September 03, 2013 7:19 AM
To: cf-talk
Subject: Re: Good jvm ram settings for 64 bit ColdFusion


Mark,

To start, the assignment of 6 gig to maxheap and 2 gig to maxperm is
working perfectly.
I'll expose my ignorance here and ask about that 80%. Is there some
inefficiency in jvm ram assignment in 64 bit in comparison to 32 bit? Is
there more overhead in ram assignment? Just wondering what's up with the
difference.

Thanks


On Mon, Sep 2, 2013 at 2:13 PM, Mark A Kruger mkru...@cfwebtools.comwrote:


 Michael,

 Rule of thumb is 80% for equivelancy. In other words, a 1.8 gig 64bit is
 equal to a 1gig 32 bit. Heap. Or you can just multiply times 2 (which is
 usually what I do). So a 6 gig heap is roughly 3 or more times the size of
 your 32bit 1 gig heap. If your server is dedicated to CF I think your 6
gig
 heap is great. Takes most of the physical memory for CF and leaves 2gs for
 the OS, monitoring etc.

 -Mark
 -Original Message-
 From: Michael Dinowitz [mailto:mdino...@houseoffusion.com]
 Sent: Monday, September 02, 2013 12:18 PM
 To: cf-talk
 Subject: Good jvm ram settings for 64 bit ColdFusion


 Does anyone have any suggestions for good workable ram settings on a 64
bit
 CF10 install on a box with 8 gig of ram? I understand I can use more than
 the standard 1 gig but has there been any work on the best settings?
 Otherwise I'm thinking to start with 6 gig maxheap and 4 gig maxperm.




 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356696
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Good jvm ram settings for 64 bit ColdFusion

2013-09-03 Thread Mark A Kruger

Thanks Pete - good info. I'll file that away :) so each address is 64bits
even if the storage is only 32bits. Weird but I think I got it.

I think 2 gigs for the OS is fine - at least on a windows box dedicated to
CF the OS doesn't need much more than that typically even with some backup
agents etc. I agree with you on the permsize though 

-mark

-Original Message-
From: Pete Freitag [mailto:p...@foundeo.com] 
Sent: Tuesday, September 03, 2013 11:41 AM
To: cf-talk
Subject: Re: Good jvm ram settings for 64 bit ColdFusion


On Tue, Sep 3, 2013 at 9:08 AM, Mark A Kruger mkru...@cfwebtools.comwrote:

 In 32 bit addressing each memory address takes up 4 bytes (4 x 8  bits)
 but a 64 bit address space is wider (as in 8 x 8 bits).  So for example,
if
 you store an integer - say 14 - on a 32 bit system, it will take 4 bytes
to
 do it (   1110).


That is correct about the addressing being larger on 64 bit, but it still
uses 32 bits to store an int (in Java at least, this may differ if you are
doing c/c++, etc), but it's address is twice as big. So what accounts for
the extra heap usage is that when you have an object reference (or a
pointer) to another object or primitive within an object instead of taking
32 bits per reference it takes 64 bits.

Also Michael - 2gb perm size seams rather large generally speaking (unless
you have tons of cfm/cfc files). Further if your server has 8GB of ram, and
you are setting 6GB max heap and 2GB max perm size then you are not leaving
any room for the OS to operate when things get full.

The perm size does not usually change much once the application is fully
loaded and all possible logic routes have executed at least once (unless
you have some sort of dynamic cfml generating going on) so you should be
able to see how much you are actually using at runtime by running this
code: http://www.petefreitag.com/item/821.cfm

--
Pete Freitag - Adobe Community Professional
http://foundeo.com/ - ColdFusion Consulting  Products
http://hackmycf.com - Is your ColdFusion Server Secure?
http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10
minutes




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356700
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: database driven mail server

2013-09-02 Thread Mark A Kruger

Claude,

I was thinking that @mail (or atmail?) has MySQL based logs - but I could be
mistaken. The data is definitely stored in mysql however. There may be a
plugin for Zimbra that handles logs via ODBC. 

2 cents - make sure you tell your users that the information they are
looking for is heavily dependent on the downstream servers and largely out
of your control :) I'm sure you have.

-Mark



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Claude Schnéegans schneeg...@internetique.com
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?=
=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Monday, September 02, 2013 8:34 AM
To: cf-talk
Subject: database driven mail server


Hi,

I'm presently using MailEnable on my server. It's a good program, but I need
to build a system
to follow up messages.
My customers (associations) send messages to their members and some messages
do not go through for many reasons.
They need to have confirmations and reasons of failures.
The problem with Mail Enable is that the logs are a real mess and very
complicated to parse.
I would need a program that generates more comprehensive logs in a database
I could read more easily.

Any suggestion? Thanks.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356684
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Good jvm ram settings for 64 bit ColdFusion

2013-09-02 Thread Mark A Kruger

Michael,

Rule of thumb is 80% for equivelancy. In other words, a 1.8 gig 64bit is
equal to a 1gig 32 bit. Heap. Or you can just multiply times 2 (which is
usually what I do). So a 6 gig heap is roughly 3 or more times the size of
your 32bit 1 gig heap. If your server is dedicated to CF I think your 6 gig
heap is great. Takes most of the physical memory for CF and leaves 2gs for
the OS, monitoring etc.

-Mark
-Original Message-
From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] 
Sent: Monday, September 02, 2013 12:18 PM
To: cf-talk
Subject: Good jvm ram settings for 64 bit ColdFusion


Does anyone have any suggestions for good workable ram settings on a 64 bit
CF10 install on a box with 8 gig of ram? I understand I can use more than
the standard 1 gig but has there been any work on the best settings?
Otherwise I'm thinking to start with 6 gig maxheap and 4 gig maxperm.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356691
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: database driven mail server

2013-09-02 Thread Mark A Kruger

Matt,

That's pretty nifty.  I use a number of the API features of smarter mail
integrated into my company management/hours/tasks system.  It's definitely a
great platform and worth a look.

-mark

-Original Message-
From: Money Pit [mailto:websitema...@gmail.com] 
Sent: Monday, September 02, 2013 5:53 PM
To: cf-talk
Subject: Re: database driven mail server


I rolled my own solution with CF coupled to Smartermail's support of
Plus-addressing.  If you aren't familar with it, its pretty powerful.

Lets say my email is u...@domain.com.  I send mail with CF as usual and set
CFMAIL's FailTo parameter to 'failedmail+1...@domain.com',  where 1234 is
the primary key ID number for the user record.

So bounces come back and plus addressing puts every failure into
failedm...@domain.com.  I use CFPOP with GETHEADERSONLY (!) to read that
mailbox periodically and parse thru returned emails, figuring out what
happened from the headers and doing stuff accordingly.  Sound like what
you're after?  A quick snippet to illustrate the maintenance process (which
I cfschedule):

cfpop
server=#servername#
username=#failUser#
password=#failPwd#
action=GETHEADERONLY
name=GetHeaders

cfloop
query=getHeaders
!---
this header identifies the email
---
cfset variables.emailID=getHeaders.UID
!---
this pulls out the user ID from the return address.  Note if the email
itself is stored in a db then this next step is unnecessary
and so is plus addressing as you could just log the user id
with the email record
---
cfset variables.usrID=listLast(listFirst(getHeaders.to,@),+)
!---
run tests here, as detailed as you like. For example
I keep track of failure counts and scrub emails from my list
if they reach three strikes.
---
cfif findNoCase(fail,getHeaders.subject,1) blah /cfif
cfif findNoCase(error,getHeaders.subject,1) woof /cfif
!---
do more clever stuff here as needed.
Then delete the failed email from the inbox and continue.
---
cfpop
server=#servername#
username=#failUser#
password=#failPwd#
action=DELETE
uid=#variables.emailID#
/cfloop


-- 
--m@Robertson--
Janitor, The Robertson Team
mysecretbase.com




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356693
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: cflocation and long urls

2013-08-27 Thread Mark A Kruger

Ray,
I agree but that restriction is pretty common for very very old browsers
(like IE 5 or maybe 6) but I haven't seen it be a problem recently. .NET
pages in particular can generate famously long URLs. My guess is that it
get's mangled by the redirect somehow - or that some intermediate engine
(like dotdefender) changes it or precludes it in some fashion. On one of the
other lists I read about dotdefender stopping a request that had redirected
more than 1 time for example.

-Mark

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: Tuesday, August 27, 2013 5:00 PM
To: cf-talk
Subject: Re: cflocation and long urls


There is a max size for URLs. Some browsers may be more strict about it.


On Tue, Aug 27, 2013 at 4:23 PM, Rob Voyle robvo...@voyle.com wrote:


 Hi folks

 I have a long encrypted url stored in a database:

 the cgi.query_string is something like

 YJShGG8kxBWgJKOlo2z4oTM8jEanxnGNBzw+QBQw8JBtuiQ8Oyn6tc6qmbd+E7W
 vcbfncSF/pq2ttDOdegKnxA==

 It works fine if i manually copy the total url from the database to the
 browser,

  however if I use
 cflocation url=#database.weblink#

 I get a not found error in firefox IE Chrome whereas Safari it works fine

 Any ideas or work arounds?

 Thanks

 Rob
 Robert J. Voyle, Psy.D.
 Director, Clergy Leadership Institute
 For Coaching and Training in Appreciative Inquiry
 Author: Restoring Hope: Appreciative Strategies
 to Resolve Grief and Resentment
 http://www.appreciativeway.com/
 503-647-2378 or 503-647-2382



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356569
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Do you use Hostek and Gmail for your mail?

2013-08-21 Thread Mark A Kruger

Here's the bug.

https://bugbase.adobe.com/index.cfm?event=bugid=3369472

I'm going to blog this as well.

-Mark


-Original Message-
From: Eric Roberts [mailto:ow...@threeravensconsulting.com] 
Sent: Wednesday, August 21, 2013 9:10 AM
To: cf-talk
Subject: RE: Do you use Hostek and Gmail for your mail?


I haven't tried to send email from my site...But I am using hostek as my
host and google apps mail for my email.

Eric

-Original Message-
From: Andrew Scott [mailto:andr...@andyscott.id.au] 
Sent: Wednesday, August 21, 2013 5:50 AM
To: cf-talk
Subject: Do you use Hostek and Gmail for your mail?


I am reaching out to everyone who is using hostek for their hosting, and
using gmail for your mail, your mail may not be being sent.

There appears to be an issue on their servers at the moment, where mail
being sent just stops, well for me at least. Also it is possible that some
people are seeing your mail without you knowing about it.

For example, I have 3 other customers of Hostek who have sent email from
their hosted website on hostek, sitting in my sent folders. I wont go into
the implications this has from a security point of view, with details
sitting in my gmail account about someone else's intended email. But it is a
known bug in ColdFusion that seems to not be that well known, at least
nothing can be found via a google search any way.


Regards,
Andrew Scott
WebSite: http://www.andyscott.id.au/
Google+:  http://plus.google.com/113032480415921517411






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356528
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Do you use Hostek and Gmail for your mail?

2013-08-21 Thread Mark A Kruger

Ok.. I blogged this issue for posterity. Now let's vote this bug up :)

http://bit.ly/16x4ilg

-Mark



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356534
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Using IN() within a cfquery statement

2013-08-19 Thread Mark A Kruger

Dave is allowed one weak answer per year... he's waited til August so I say
we give him a break :)

-Mark

-Original Message-
From: DURETTE, STEVEN J [mailto:sd1...@att.com] 
Sent: Monday, August 19, 2013 8:46 AM
To: cf-talk
Subject: RE: Using IN() within a cfquery statement


Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the
better way?

Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate
type list=yes separator=, /)

Steve

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Monday, August 19, 2013 9:42 AM
To: cf-talk
Subject: Re: Using IN() within a cfquery statement


 I have a select name=stuff multiple in a form filled with results from a
query.
 I get the form field value: stuff=selection1,selection5,selection12.

 How do I then build a cfquery using the stuff variable in the IN()
statement?

Use the quotedValueList function to wrap single quotes around them.

SELECT ...
FROM ...
WHERE STUFF IN (#quotedValueList(form.stuff)#)

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356486
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: 1900/01/01

2013-08-09 Thread Mark A Kruger

I think it is the first date possible for the smalldatetime data type. I'm
guessing you are populating with a default value - as in Dave's suggestion
(putting in a time with no date would default to the earliest date maybe).

-Original Message-
From: Torrent Girl [mailto:moniqueb...@gmail.com] 
Sent: Thursday, August 08, 2013 10:13 PM
To: cf-talk
Subject: 1900/01/01


Anyone know why 1900/01/01 would show up in a column when a record is
updated? 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356425
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Timeouts connecting to database from my local installation

2013-08-07 Thread Mark A Kruger

Brook,

Here's a blog post that should help.

http://www.coldfusionmuse.com/index.cfm/2011/11/3/host.files.are.fun



-Original Message-
From: Torrent Girl [mailto:moniqueb...@gmail.com] 
Sent: Tuesday, August 06, 2013 9:22 PM
To: cf-talk
Subject: Re: Timeouts connecting to database from my local installation


Make sure it's not resolution issues... sometimes inconsistent DNS or the
use of VPN's can cause issues with connecting. Use a hosts entry or an IP
address to eliminate DNS as an issue.

I have constant timeouts when trying to connect my local CF installation
and
the DEV database.

Is there anything I can do in the code and/or admin to maximize my
connection?

I am sorry Mark. How do I do this?

Use a hosts entry or an IP address to eliminate DNS as an issue. 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356419
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: JSON Encoding bug (again...)

2013-08-06 Thread Mark A Kruger

Dave,

The code testval = '.0006' makes me think a string instead of a number.
Javacast might force a type on the string eh? 

Brooke - are you looking for a number or a string?

-Mark

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Monday, August 05, 2013 7:52 PM
To: cf-talk
Subject: Re: JSON Encoding bug (again...)


 I have had to do so many hacks to get serializeJSON() to play nice. I add
a
 ~ to all yes/no strings so I don't get back true/false values, I have a
 series of regular expressions that quote values in the resulting JSON that
 don't get quoted and break on the client side. And now I have this issue:

 cfset x = {testval='.0006'}
 cfdump var=#serializeJSON(x)#

 Which outputs:

 {TESTVAL:6.0E-4}

 WTF?

  I am using CF 9,0,1,274733
 Update Level /C:/ColdFusion9/lib/updates/hf901-4.jar

 Anybody know of a workaround for this? The source data is in a query which
 gets serialized after being converted to an array of structs. It would be
 too slow to check each field for values like this and modify them to
return
 to the client. I need another Idea. Anyone?

This isn't really a problem with JSON serialization, but with CF being
typeless, and CF's tendency to autoconvert numbers into scientific
notation. You can work around this by using precisionEvaluate(), the
BigDecimal version of the Evaluate function:

cfset x = {testval=precisionEvaluate(.0006)}
cfdump var=#serializeJSON(x)#

Note that this will add a leading zero.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356393
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Coldfusion in distributed mode with multiple subnets on host

2013-08-06 Thread Mark A Kruger

Brad,

Awesome!

-Original Message-
From: brad f [mailto:b...@ciswired.com] 
Sent: Monday, August 05, 2013 9:59 PM
To: cf-talk
Subject: Re: Coldfusion in distributed mode with multiple subnets on host


Thanks for all the replies.. Changing the order of the nics was all I had to
do.  



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356394
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: JSON Encoding bug (again...)

2013-08-06 Thread Mark A Kruger

Yeah... got it.

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Tuesday, August 06, 2013 10:28 AM
To: cf-talk
Subject: Re: JSON Encoding bug (again...)


 The code testval = '.0006' makes me think a string instead of a number.
 Javacast might force a type on the string eh?

That might work, but the problem is that CF will continually
reevaluate values every time they're used - as you'd expect in a
typeless language. All you can do is force CF to treat a variable as a
specific type for the current operation. Here we have two operations:
in the first, we can tell CF to treat the struct value as a string,
but in the second that's kind of hard to do.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356401
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Timeouts connecting to database from my local installation

2013-08-06 Thread Mark A Kruger

Make sure it's not resolution issues... sometimes inconsistent DNS or the
use of VPN's can cause issues with connecting. Use a hosts entry or an IP
address to eliminate DNS as an issue.

-Original Message-
From: Torrent Girl [mailto:moniqueb...@gmail.com] 
Sent: Tuesday, August 06, 2013 12:28 PM
To: cf-talk
Subject: Timeouts connecting to database from my local installation


I have constant timeouts when trying to connect my local CF installation and
the DEV database.

Is there anything I can do in the code and/or admin to maximize my
connection?




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356404
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Element undefined in SESSION scope

2013-08-06 Thread Mark A Kruger

Make sure that cgi.http_referer exists before you try to set it. This is a
var created by the web server NOT cf ... so it may or may not reliably
exist. Also make sure this code is AFTER your cfapplication tag. 

On your own system try hitting the page after a cf restart. You may be
trying to access the session before you have established a session. The
reason it works on local is because during coding you established a session
at some previous point.

That's all I got :)

-Mark


Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: funand learning [mailto:funandlrnn...@gmail.com] 
Sent: Tuesday, August 06, 2013 3:08 PM
To: cf-talk
Subject: Re: Element undefined in SESSION scope


I am just setting up a variable to capture cgi.http_referer.

cfset session.referer = cgi.http_referer. Initially, the variable was set
up as
input type=hidden name=referer value=#CGI.http_referer#

This variable is defined on a form, which submits to itself. I want to
capture the initial cgi.http_referer value when the user first lands on the
form and save it to database upon successful submission, hence was using
hidden value. Recent security scanning has identified the input form
variable for XSS, and hence I am changing it to a session value.


On Tue, Aug 6, 2013 at 3:01 PM, Alan Rother alan.rot...@gmail.com wrote:


 Can we see some sample code?


 On Tue, Aug 6, 2013 at 12:43 PM, fun and learning
 funandlrnn...@gmail.comwrote:

 
  All -
 
  I am converting a form variable to a session variable.I enabled session
  management in application.cfm in cfapplication tag. The change works
fine
  only on my system, but when others try it, they get
 
  'Element undefined in SESSION'.
 
  What could be the possible reason?
 
  Thanks.
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356408
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


FW: Element undefined in SESSION scope

2013-08-06 Thread Mark A Kruger

Trying a resend.

Make sure that cgi.http_referer exists before you try to set it. This is a
var created by the web server NOT cf ... so it may or may not reliably
exist. Also make sure this code is AFTER your cfapplication tag. 

On your own system try hitting the page after a cf restart. You may be
trying to access the session before you have established a session. The
reason it works on local is because during coding you established a session
at some previous point.

That's all I got :)

-Mark



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356410
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Coldfusion in distributed mode with multiple subnets on host

2013-08-05 Thread Mark A Kruger

This was my suggestion too - although I sometimes add static routes to the
route table as well to dictate where traffic goes. It sounds like you are
multi-homing which might NOT be strictly necessary. Consider teaming so you
don't have to fiddle with precedence order etc.

-mark


-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Monday, August 05, 2013 8:23 AM
To: cf-talk
Subject: Re: Coldfusion in distributed mode with multiple subnets on host


on your network interfaces page you can change the order in which the
interfaces are used, which may solve your issue.

open network and sharing centre
press ALT
choose advanced - advanced settings
move the connection to the top that you wish to take precedence

Also how are you referencing the database servers from CF using IP or
machine name ?



On Mon, Aug 5, 2013 at 1:45 PM, brad f b...@ciswired.com wrote:


 I am running coldfusion 9 in distributed mode(web server and CF on
 different servers). I have three web servers and three coldfusion servers
 running in a clustered environment. The problem is that I can never get
the
 cluster setup or the web servers to see the cluster unless I disable the
 database NIC on the coldfusion boxes. Our environment is divided into
three
 tiers. Web tier, Application tier and Database tier with the web servers
 not being able to see the database tier... so the web servers do not have
a
 database NIC and it seems coldfusion is always listening on the .111
subnet
 (database).

 This also causes a problem when coldfusion is restarted on one of the app
 servers because it always rejoins the cluster using it's .111 address and
 then the web servers do not pass traffic to those coldfusion servers until
 I shut down the database NIC and then restart the coldfusion services.. It
 then registers on the App tier subnet which the web servers can see.

 Any ideas on how to make coldfusion only listen on the App tier ip address
 and not the database tier ip address? Thanks.

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356374
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Efflare and ImageCR

2013-08-01 Thread Mark A Kruger

Eric,

Yes it can run on 64bit - at least we are definitely using it on a 64bit CF8
instance... Did you guys see my comment below?

-Mark

Chad,

I have it running as 64bit on Windows 08r2, CF 8 64bit, Java 1.6.0_32 using
the cfx jar file (as apposed to the dll). I know I have archived the
installer somewhere. Let me know if you can't get it going and I'll see if
I
can help you out.

-Mark

-Original Message-
From: Eric Roberts [mailto:ow...@threeravensconsulting.com] 
Sent: Wednesday, July 31, 2013 5:20 PM
To: cf-talk
Subject: RE: Efflare and ImageCR


It doesn't work on the 64 bit platform.  If you look through the
archives(look between July and November 2010...probably closer to November,
but I don't recall exactly when hehehe, I posted a custom tag I developed to
replace CFXImage, with the help of some of the folks on this list, based off
of some work Ben Nadel did with the font and image classes in Java...


Eric
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Wednesday, July 31, 2013 9:50 AM
To: cf-talk
Subject: Re: Efflare and ImageCR


It's been many years since I've gotten any kind of response out of them. It
was a great tag at the time, but long since dead in my experience.

On Wed, Jul 31, 2013 at 10:47 AM, Chad Gray cg...@careyweb.com wrote:


 Anyone know how to get a hold of the developers of ImageCR?  It is an 
 image processing CFX extension writing for CF.

 Their website is a parked and expired.

 Thanks,
 Chad

 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356363
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Efflare and ImageCR

2013-07-31 Thread Mark A Kruger

We do have it running on a 64bit box here. Let me check with that team (if
that is your issue and Matt has not been able to resolve it for you).

-Mark


-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com] 
Sent: Wednesday, July 31, 2013 10:04 AM
To: cf-talk
Subject: RE: Efflare and ImageCR


I tried that, but it's installer must have installed supporting DLL's or
something.

Of course this is on a 64 bit box, maybe I need to put it in the Program
Files (x86).

I will keep poking at it.

Thanks,
Chad

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, July 31, 2013 10:58 AM
To: cf-talk
Subject: Re: Efflare and ImageCR


 I need to upgrade a server and I cannot find an installer for imageCR3.

I don't think I've ever used ImageCR, but if you have it installed on your
existing server, and it's just a CFX DLL, you shouldn't really need an
installer. Copy the DLL to the new server, then register it within the CF
Administrator.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,
and provides the highest caliber vendor-authorized instruction at our
training centers, online, or onsite.





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356356
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Efflare and ImageCR

2013-07-31 Thread Mark A Kruger

Chad,

I have it running as 64bit on Windows 08r2, CF 8 64bit, Java 1.6.0_32 using
the cfx jar file (as apposed to the dll). I know I have archived the
installer somewhere. Let me know if you can't get it going and I'll see if I
can help you out.

-Mark



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: Mark A Kruger [mailto:mkru...@cfwebtools.com] 
Sent: Wednesday, July 31, 2013 11:37 AM
To: cf-talk
Subject: RE: Efflare and ImageCR


We do have it running on a 64bit box here. Let me check with that team (if
that is your issue and Matt has not been able to resolve it for you).

-Mark


-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com] 
Sent: Wednesday, July 31, 2013 10:04 AM
To: cf-talk
Subject: RE: Efflare and ImageCR


I tried that, but it's installer must have installed supporting DLL's or
something.

Of course this is on a 64 bit box, maybe I need to put it in the Program
Files (x86).

I will keep poking at it.

Thanks,
Chad

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: Wednesday, July 31, 2013 10:58 AM
To: cf-talk
Subject: Re: Efflare and ImageCR


 I need to upgrade a server and I cannot find an installer for imageCR3.

I don't think I've ever used ImageCR, but if you have it installed on your
existing server, and it's just a CFX DLL, you shouldn't really need an
installer. Copy the DLL to the new server, then register it within the CF
Administrator.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule,
and provides the highest caliber vendor-authorized instruction at our
training centers, online, or onsite.







~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356357
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: issue with cfhttp and client certificates

2013-07-26 Thread Mark A Kruger

Russ,

Would changing the sys property for unsafe renegotiation allow the JVM to
proceed if this was this issue?

-Mark

(I'm thinking of this arg -Dsun.security.ssl.allowUnsafeRenegotiation=true )

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Thursday, July 25, 2013 6:25 PM
To: cf-talk
Subject: Re: issue with cfhttp and client certificates


it should be noted that the minimum requirement for certs now is 2048bit,
it is not even possible to generate a cert with less than this with most
CSA's, so perhaps this is the issue, maybe 1024 is not even supported by
java now.


On Thu, Jul 25, 2013 at 11:52 PM, Jeff Garza j...@garzasixpack.com wrote:


 The .pfx is a RSA 1024 bit key.  Nothing out of the usual.  And this exact
 key worked just fine in a default install of CF9.
 --
 Jeff

  Original Message 
  From: Jon Clausen jon_clau...@silowebworks.com
  Sent: Thursday, July 25, 2013 3:29 PM
  To: cf-talk cf-talk@houseoffusion.com
  Subject: Re: issue with cfhttp and client certificates
 
  Long shot, but what is the key length on the encryption?  Could it be an
 issue with the encryption capabilities currently set on the new JVM for
 CF10?
 
  Explanation: http://www.petefreitag.com/item/803.cfm
 
 
  On Jul 25, 2013, at 4:44 PM, Jeff Garza j...@garzasixpack.com wrote:
 
  
   Mark,
  
   On the CF9 Server we're at Java version 1.6.0_17  and the arguments
 from
   the CFAdmin look like the following: -server
 -Dsun.io.useCanonCaches=false
   -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch
   -Dcoldfusion.rootDir={application.home}/../
   -Dcoldfusion.libPath={application.home}/../lib
   -Dcoldfusion.spooltimeout=120.
  
   On the CF10 server it's at Java version 1.7.0_15  and the args are:
   -server -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch
   -Dcoldfusion.home={application.home}
   -Dcoldfusion.rootDir={application.home}
   -Dcoldfusion.libPath={application.home}/lib
   -Dorg.apache.coyote.USE_CUSTOM_STATUS_MSG_IN_HEADER=true
   -Dcoldfusion.jsafe.defaultalgo=FIPS186Random
   -Dcoldfusion.spooltimeout=120
  
   Though, based on the error, I don't think this is a handshake issue.
 It
   looks like an issue where the JVM can't even open the certificate file
 to
   pass the public key on to the server.  Which is why this is so strange
 that
   CF9 with the older JVM would be able to do it, but the new one can't.
   --Jeff
  
    Original Message 
   From: Mark A Kruger mkru...@cfwebtools.com
   Sent: Thursday, July 25, 2013 1:25 PM
   To: cf-talk cf-talk@houseoffusion.com
   Subject: RE: issue with cfhttp and client certificates
  
   Jeff,
  
   What JVM version are you using on CF9 and what do the args look like?
   Sometimes it's a matter of the handshake and levels of TLS/SSL - the
   error
   may be not specific enough to tell. You can enable logging to get a
 grip
   on
   it though. That would tell you more.
  
   -Mark
  
  
   -Original Message-
   From: Jeff Garza [mailto:j...@garzasixpack.com]
   Sent: Thursday, July 25, 2013 12:25 PM
   To: cf-talk
   Subject: issue with cfhttp and client certificates
  
  
   Ok, so here's the issue.  A process that was working just fine on CF9
 is
  
   now broken on CF10.  We have a service that we call that requires us
 to
   submit a client certificate to the server.  In CF9, this worked just
   fine.
   Use the clientcert and clientcertpass attributes of CFHTTP and you're
   good
   to go.  It reads the .pfx file fine and everything runs...  This is
 not a
  
   cacerts issue as you do not have to have the key in the keystore to
 use
   it.
   Forward to CF10, the exact same code and certificates now gives the
   error:
  
   Error while trying to get the SSL client certificate:
   java.security.UnrecoverableKeyException: Could not decrypt key: Could
 not
  
   decode key from BER. (Invalid encoding: expected tag not there. ).
   It's like it's unable to open the .pfx certificate file.
   I know this is a long shot since there are not many folks out there
 using
  
   client certs, but has anyone else run across this issue?
   Thanks,
   Jeff Garza
  
  
 
 

 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356326
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: issue with cfhttp and client certificates

2013-07-26 Thread Mark A Kruger

Well, I've hinted at it as a possible solution a couple times but I lack
confidence (ha).  Jeff - give it a shot. It's easy and you never know.

-Mark

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Friday, July 26, 2013 9:18 AM
To: cf-talk
Subject: Re: issue with cfhttp and client certificates


sorry no idea never tried, you would have to try it and see :-)


On Fri, Jul 26, 2013 at 3:16 PM, Mark A Kruger
mkru...@cfwebtools.comwrote:


 Russ,

 Would changing the sys property for unsafe renegotiation allow the JVM to
 proceed if this was this issue?

 -Mark

 (I'm thinking of this arg -Dsun.security.ssl.allowUnsafeRenegotiation=true
 )

 -Original Message-
 From: Russ Michaels [mailto:r...@michaels.me.uk]
 Sent: Thursday, July 25, 2013 6:25 PM
 To: cf-talk
 Subject: Re: issue with cfhttp and client certificates


 it should be noted that the minimum requirement for certs now is 2048bit,
 it is not even possible to generate a cert with less than this with most
 CSA's, so perhaps this is the issue, maybe 1024 is not even supported by
 java now.


 On Thu, Jul 25, 2013 at 11:52 PM, Jeff Garza j...@garzasixpack.com
 wrote:

 
  The .pfx is a RSA 1024 bit key.  Nothing out of the usual.  And this
 exact
  key worked just fine in a default install of CF9.
  --
  Jeff
 
   Original Message 
   From: Jon Clausen jon_clau...@silowebworks.com
   Sent: Thursday, July 25, 2013 3:29 PM
   To: cf-talk cf-talk@houseoffusion.com
   Subject: Re: issue with cfhttp and client certificates
  
   Long shot, but what is the key length on the encryption?  Could it be
 an
  issue with the encryption capabilities currently set on the new JVM for
  CF10?
  
   Explanation: http://www.petefreitag.com/item/803.cfm
  
  
   On Jul 25, 2013, at 4:44 PM, Jeff Garza j...@garzasixpack.com
 wrote:
  
   
Mark,
   
On the CF9 Server we're at Java version 1.6.0_17  and the arguments
  from
the CFAdmin look like the following: -server
  -Dsun.io.useCanonCaches=false
-XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib
-Dcoldfusion.spooltimeout=120.
   
On the CF10 server it's at Java version 1.7.0_15  and the args are:
-server -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch
-Dcoldfusion.home={application.home}
-Dcoldfusion.rootDir={application.home}
-Dcoldfusion.libPath={application.home}/lib
-Dorg.apache.coyote.USE_CUSTOM_STATUS_MSG_IN_HEADER=true
-Dcoldfusion.jsafe.defaultalgo=FIPS186Random
-Dcoldfusion.spooltimeout=120
   
Though, based on the error, I don't think this is a handshake issue.
  It
looks like an issue where the JVM can't even open the certificate
 file
  to
pass the public key on to the server.  Which is why this is so
 strange
  that
CF9 with the older JVM would be able to do it, but the new one
can't.
--Jeff
   
 Original Message 
From: Mark A Kruger mkru...@cfwebtools.com
Sent: Thursday, July 25, 2013 1:25 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: RE: issue with cfhttp and client certificates
   
Jeff,
   
What JVM version are you using on CF9 and what do the args look
 like?
Sometimes it's a matter of the handshake and levels of TLS/SSL -
the
error
may be not specific enough to tell. You can enable logging to get a
  grip
on
it though. That would tell you more.
   
-Mark
   
   
-Original Message-
From: Jeff Garza [mailto:j...@garzasixpack.com]
Sent: Thursday, July 25, 2013 12:25 PM
To: cf-talk
Subject: issue with cfhttp and client certificates
   
   
Ok, so here's the issue.  A process that was working just fine on
 CF9
  is
   
now broken on CF10.  We have a service that we call that requires
us
  to
submit a client certificate to the server.  In CF9, this worked
just
fine.
Use the clientcert and clientcertpass attributes of CFHTTP and
 you're
good
to go.  It reads the .pfx file fine and everything runs...  This is
  not a
   
cacerts issue as you do not have to have the key in the keystore to
  use
it.
Forward to CF10, the exact same code and certificates now gives the
error:
   
Error while trying to get the SSL client certificate:
java.security.UnrecoverableKeyException: Could not decrypt key:
 Could
  not
   
decode key from BER. (Invalid encoding: expected tag not there. ).
It's like it's unable to open the .pfx certificate file.
I know this is a long shot since there are not many folks out there
  using
   
client certs, but has anyone else run across this issue?
Thanks,
Jeff Garza
   
   
  
  
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive

RE: cfthread execution slowdown

2013-07-26 Thread Mark A Kruger

Is this apache or IIS?

-Original Message-
From: Money Pit [mailto:websitema...@gmail.com] 
Sent: Friday, July 26, 2013 11:41 AM
To: cf-talk
Subject: cfthread execution slowdown


I need another set of eyeballs on this.  I can't see what I'm doing wrong.

I'm building many thousands of static pages.  I turned to cfthread to speed
things up.  Each thread can output one page or more than one depending on
info retrieved.  I use an array to manage the number of threads in use at
any one time.

It works great, but I am seeing CF slow down - in fixed stages - throughout
the life of the process.  Take a look at this image taken from
FusionReactor to see what I mean:

http://205.210.189.205/images/screenshot081.jpg

Its not a curve but rather three distinct stages of output.  Stage 1 is
about 2900 pages per minute, Stage 2 is around 2400 and Stage 3 - where the
routine stabilizes - is about 1200.

On a second server building differently-composed pages, I see exactly the
same thing.

CF isn't bogging down from load... its flat out not working as hard.  Its
as if it decided it didn't want to work as hard, so it eases off.  Never
seen anything like it.

Here's the code in a nutshell.  Can anyone see something I am doing that is
causing this work slowdown?

cfset variables.threadArray=arrayNew(1)
cfset variables.threadCount=4
cfquery
name=getData
datasource=#variables.dsn#
[sql goes here]
/cfquery
cfset variables.loopCounter=0
cfloop
condition=variables.loopCounter LT getData.recordCount
cfset variables.threadsLive=arrayLen(variables.threadArray)
cfif variables.threadsLive lt variables.threadCount
cfset variables.loopCounter=variables.loopCounter+1
cfset variables.thisThreadID=createUUID()
cfset
temp=arrayAppend(variables.threadArray,variables.thisThreadID)
cfthread
name=#variables.thisThreadID#
action=run
!---
cfhttp pulls local CF pages and stores as html,
queries determine if child pages need building etc.
---
cfset
temp=arrayDeleteAt(variables.threadArray,arrayFindNoCase(variables.threadArr
ay,variables.thisThreadID))
/cfthread
!---
may or may not do a cfthread join if I want to retrieve
variables from inside of the thread
---
/cfif
/cfloop


-- 
--m@Robertson--
Janitor, The Robertson Team
mysecretbase.com




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356334
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: issue with cfhttp and client certificates

2013-07-25 Thread Mark A Kruger

Jeff,

What JVM version are you using on CF9 and what do the args look like?
Sometimes it's a matter of the handshake and levels of TLS/SSL - the error
may be not specific enough to tell. You can enable logging to get a grip on
it though. That would tell you more.

-Mark


-Original Message-
From: Jeff Garza [mailto:j...@garzasixpack.com] 
Sent: Thursday, July 25, 2013 12:25 PM
To: cf-talk
Subject: issue with cfhttp and client certificates


Ok, so here's the issue.  A process that was working just fine on CF9 is 
now broken on CF10.  We have a service that we call that requires us to 
submit a client certificate to the server.  In CF9, this worked just fine.  
Use the clientcert and clientcertpass attributes of CFHTTP and you're good 
to go.  It reads the .pfx file fine and everything runs...  This is not a 
cacerts issue as you do not have to have the key in the keystore to use 
it.
Forward to CF10, the exact same code and certificates now gives the error: 

Error while trying to get the SSL client certificate: 
java.security.UnrecoverableKeyException: Could not decrypt key: Could not 
decode key from BER. (Invalid encoding: expected tag not there. ).  
It's like it's unable to open the .pfx certificate file.
I know this is a long shot since there are not many folks out there using 
client certs, but has anyone else run across this issue?
Thanks,
Jeff Garza






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356317
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: issue with cfhttp and client certificates

2013-07-25 Thread Mark A Kruger

Weird. I would trial and error a few things. Check the keystore on CF9 with
the list function and compare with CF10 ... see if anythings missing that
missed your docs :)   Try removing the jsafe setting below.  Make sure your
CF install has access to the folder containing the certs and can read them.
Not sure I have anything to add.

-Mark


-Original Message-
From: Jeff Garza [mailto:j...@garzasixpack.com] 
Sent: Thursday, July 25, 2013 3:45 PM
To: cf-talk
Subject: RE: issue with cfhttp and client certificates


Mark,

On the CF9 Server we're at Java version 1.6.0_17  and the arguments from 
the CFAdmin look like the following: -server -Dsun.io.useCanonCaches=false 
-XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch 
-Dcoldfusion.rootDir={application.home}/../ 
-Dcoldfusion.libPath={application.home}/../lib 
-Dcoldfusion.spooltimeout=120.

On the CF10 server it's at Java version 1.7.0_15  and the args are: 
-server -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch 
-Dcoldfusion.home={application.home} 
-Dcoldfusion.rootDir={application.home} 
-Dcoldfusion.libPath={application.home}/lib 
-Dorg.apache.coyote.USE_CUSTOM_STATUS_MSG_IN_HEADER=true 
-Dcoldfusion.jsafe.defaultalgo=FIPS186Random 
-Dcoldfusion.spooltimeout=120

Though, based on the error, I don't think this is a handshake issue.  It 
looks like an issue where the JVM can't even open the certificate file to 
pass the public key on to the server.  Which is why this is so strange that 
CF9 with the older JVM would be able to do it, but the new one can't.
--Jeff

 Original Message 
 From: Mark A Kruger mkru...@cfwebtools.com
 Sent: Thursday, July 25, 2013 1:25 PM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: RE: issue with cfhttp and client certificates
 
 Jeff,
 
 What JVM version are you using on CF9 and what do the args look like?
 Sometimes it's a matter of the handshake and levels of TLS/SSL - the 
error
 may be not specific enough to tell. You can enable logging to get a grip 
on
 it though. That would tell you more.
 
 -Mark
 
 
 -Original Message-
 From: Jeff Garza [mailto:j...@garzasixpack.com] 
 Sent: Thursday, July 25, 2013 12:25 PM
 To: cf-talk
 Subject: issue with cfhttp and client certificates
 
 
 Ok, so here's the issue.  A process that was working just fine on CF9 is 

 now broken on CF10.  We have a service that we call that requires us to 
 submit a client certificate to the server.  In CF9, this worked just 
fine.  
 Use the clientcert and clientcertpass attributes of CFHTTP and you're 
good 
 to go.  It reads the .pfx file fine and everything runs...  This is not a 

 cacerts issue as you do not have to have the key in the keystore to use 
 it.
 Forward to CF10, the exact same code and certificates now gives the 
error: 
 
 Error while trying to get the SSL client certificate: 
 java.security.UnrecoverableKeyException: Could not decrypt key: Could not 

 decode key from BER. (Invalid encoding: expected tag not there. ).  
 It's like it's unable to open the .pfx certificate file.
 I know this is a long shot since there are not many folks out there using 

 client certs, but has anyone else run across this issue?
 Thanks,
 Jeff Garza
 
 
 
 
 
 
 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356319
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Client wants CMS that functions similar to Joomla, for example

2013-07-24 Thread Mark A Kruger

Rick,

Allow me to second this excellent comment. CMS is just the next level for
an active content based or content critical website. Both expense and
development tend to go up rather than down or level off. 

-Mark



Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
O: 402.932.3318
E: mkru...@cfwebtools.com
Skype: markakruger



-Original Message-
From: David Phelan [mailto:dphe...@emerginghealthit.com] 
Sent: Wednesday, July 24, 2013 9:36 AM
To: cf-talk
Subject: RE: Client wants CMS that functions similar to Joomla, for example


Rick,

As a developer who has recently become involved with CMS environments, let
me assure you that the introduction of a CMS by no means indicates that a
developer is no longer required.  I actually work full time supporting a
number of web sites that all run from a CF based CMS and recently started
supporting one that runs in WordPress.  Even with our licensed CF CMS
specifically developed for the healthcare industry, the functionality OOTB
does not always meet the requirements of the end users and I find myself
quite busy reworking, rewriting or introducing functionality so as to meet
the requirements of the users and content managers.

The point of a CMS is to get the tedious job of content updates out of the
hands of developers and into the hands of those who know what they want to
change.  I am quite happy developing or enhancing functionality for the site
rather than making the endless, often minor, content changes that the client
wants.

David Phelan  
Web Developer   
IT Security  Web Technologies
  
Emerging Health
Montefiore Information Technology
3 Odell Plaza, Yonkers, NY 10701
914-457-6465 Office
862-234-9109 Cell
dphe...@emerginghealthit.com
www.emerginghealthit.com
www.montefiore.org



-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com] 
Sent: Tuesday, July 23, 2013 4:26 PM
To: cf-talk
Subject: SOT: Client wants CMS that functions similar to Joomla, for example


Hi, guys...

Just need some recommendations from some of you who have been down this road
before.

I have a client that is asking for what amounts to absolute control over
their site through a CMS. Among a few others they metioned, Joomla was
brought up.

I'm checking them out myself, but wanted to cut to the chase based on
experience from those who have used CMS's that provide control such as
Joomla.

What have you tried? What turned out to work well? What bombed?
I've always rolled my own, and never used a ready-made CMS, so I have zero
experience with them.

(Joomla seems like it replaces me as a designer/developer, at first glance.
If a client has a CMS that allows them to do everything that I do for them
now, including selecting themes for pages they add to the site themselves
(designer), manage data through Joomla functionality (developer), I wonder
if I would end up as a Joomla Installer  Maintenance person for the
client. ???)

Thoughts? Suggestions?

Thanks for any feedback!

Rick






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356301
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Hack Attempt on our database last night

2013-07-23 Thread Mark A Kruger

I'll vote for that as well. Because it has several levels of detection it's
very reliable.

-mark


-Original Message-
From: Justin Scott [mailto:leviat...@darktech.org] 
Sent: Tuesday, July 23, 2013 8:15 AM
To: cf-talk
Subject: Re: Hack Attempt on our database last night


 cfformprotect will help you with stuff like this

I'll second that... it's become a standard for me to implement on
public-facing forms to prevent automated submissions.


-Justin



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356285
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Hack Attempt on our database last night

2013-07-22 Thread Mark A Kruger

According to the stack overflow comments 0x313032 ...etc is the calling
card of Havij, an automated injection tool.  The commentor said somewhat
of a necro - which I have no idea what that means... he's either
disparaging a race of intergalactic conquerors or misspelling macro.

-Original Message-
From: Byron Mann [mailto:byronos...@gmail.com] 
Sent: Monday, July 22, 2013 11:49 AM
To: cf-talk
Subject: RE: Hack Attempt on our database last night


That makes sense to me, looks more like an attempt to see if an injection
would work.

Byron Mann
Lead Engineer  Architect
HostMySite.com
On Jul 22, 2013 12:46 PM, Mark A Kruger mkru...@cfwebtools.com wrote:


 Justin (et al)

 When I unpack this I get

 99.99 /*!3000 union all select   0x313032...   etc */ --

 Doesn't the /* */ force the whole string into a comment? Hard to see how
 that would succeed.

 -Mark



 -Original Message-
 From: Justin Scott [mailto:leviat...@darktech.org]
 Sent: Monday, July 22, 2013 11:19 AM
 To: cf-talk
 Subject: Re: Hack Attempt on our database last night


 In this particular case it's not generating SQL but just filling in
 space to match the number of columns with the original query.
 Basically once it executes without an error it allows the attacker to
 see how many columns the original query is selecting.  It's part of an
 automated attack tool.

 -Justin

 On Mon, Jul 22, 2013 at 5:08 AM, Russ Michaels r...@michaels.me.uk
 wrote:
 
  You can run cast function on the hex string to see the actual sql it
  generates, which I thought was required anyway so not sure that query
 would
  even execute otherwise.
 
  Russ Michaels
  www.michaels.me.uk
  cfmldeveloper.com
  cflive.net
  cfsearch.com
  On 22 Jul 2013 04:45, Justin Scott leviat...@darktech.org wrote:
 
 
  There was some discussion about a very similar injection on Stack
  Overflow which may be useful:
 
 
 


http://stackoverflow.com/questions/4600954/site-has-been-hacked-via-sql-inje
 ction
 
 
  -Justin
 
 
 
  On Sun, Jul 21, 2013 at 1:33 PM, Dave  Hatz daveh...@hatzventures.org
  wrote:
  
   We had someone trying to hack our system last night and I would like
 to
  know what he was trying to get.  Seems one of our new Junior
programmers
  didn't use CFQUERYPARAM and allowed this param into the query string.
   Needless to say, I will be having a nice long chat with him when he
 gets
  into the office tomorrow.
  
   How do I decode what this is?  Is there a tool or site that will
 convert
  this for me?
  
   99.9 /*!3union all select
 


0x31303235343830303536,0x31303235343830303536,0x31303235343830303536,0x31303


235343830303536,0x31303235343830303536,0x31303235343830303536,0x313032353438


30303536,0x31303235343830303536,0x31303235343830303536,0x3130323534383030353


6,0x31303235343830303536,0x31303235343830303536,0x31303235343830303536,0x313


03235343830303536,0x31303235343830303536,0x31303235343830303536,0x3130323534


3830303536,0x31303235343830303536,0x31303235343830303536,0x31303235343830303


536,0x31303235343830303536,0x31303235343830303536,0x31303235343830303536,0x3
 1303235343830303536,0x31303235343830303536,0x31303235343830303536*/--
  
  
 
 
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356270
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Hack Attempt on our database last night

2013-07-22 Thread Mark A Kruger

Justin (et al)

When I unpack this I get

99.99 /*!3000 union all select   0x313032...   etc */ --

Doesn't the /* */ force the whole string into a comment? Hard to see how
that would succeed.

-Mark



-Original Message-
From: Justin Scott [mailto:leviat...@darktech.org] 
Sent: Monday, July 22, 2013 11:19 AM
To: cf-talk
Subject: Re: Hack Attempt on our database last night


In this particular case it's not generating SQL but just filling in
space to match the number of columns with the original query.
Basically once it executes without an error it allows the attacker to
see how many columns the original query is selecting.  It's part of an
automated attack tool.

-Justin

On Mon, Jul 22, 2013 at 5:08 AM, Russ Michaels r...@michaels.me.uk wrote:

 You can run cast function on the hex string to see the actual sql it
 generates, which I thought was required anyway so not sure that query
would
 even execute otherwise.

 Russ Michaels
 www.michaels.me.uk
 cfmldeveloper.com
 cflive.net
 cfsearch.com
 On 22 Jul 2013 04:45, Justin Scott leviat...@darktech.org wrote:


 There was some discussion about a very similar injection on Stack
 Overflow which may be useful:



http://stackoverflow.com/questions/4600954/site-has-been-hacked-via-sql-inje
ction


 -Justin



 On Sun, Jul 21, 2013 at 1:33 PM, Dave  Hatz daveh...@hatzventures.org
 wrote:
 
  We had someone trying to hack our system last night and I would like to
 know what he was trying to get.  Seems one of our new Junior programmers
 didn't use CFQUERYPARAM and allowed this param into the query string.
  Needless to say, I will be having a nice long chat with him when he gets
 into the office tomorrow.
 
  How do I decode what this is?  Is there a tool or site that will
convert
 this for me?
 
  99.9 /*!3union all select

0x31303235343830303536,0x31303235343830303536,0x31303235343830303536,0x31303
235343830303536,0x31303235343830303536,0x31303235343830303536,0x313032353438
30303536,0x31303235343830303536,0x31303235343830303536,0x3130323534383030353
6,0x31303235343830303536,0x31303235343830303536,0x31303235343830303536,0x313
03235343830303536,0x31303235343830303536,0x31303235343830303536,0x3130323534
3830303536,0x31303235343830303536,0x31303235343830303536,0x31303235343830303
536,0x31303235343830303536,0x31303235343830303536,0x31303235343830303536,0x3
1303235343830303536,0x31303235343830303536,0x31303235343830303536*/--
 
 



 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356268
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


RE: Hack Attempt on our database last night

2013-07-22 Thread Mark A Kruger

Ah that is devilishly clever.

-Original Message-
From: Pete Freitag [mailto:p...@foundeo.com] 
Sent: Monday, July 22, 2013 2:23 PM
To: cf-talk
Subject: Re: Hack Attempt on our database last night


On Mon, Jul 22, 2013 at 12:45 PM, Mark A Kruger
mkru...@cfwebtools.comwrote:

 Doesn't the /* */ force the whole string into a comment? Hard to see how
 that would succeed.


It is a MySQL version specific comment so if MySQL version is greater than
version 3.0 in this case it would execute, all other DB engines would treat
as a comment.


--
Pete Freitag - Adobe Community Professional
http://foundeo.com/ - ColdFusion Consulting  Products
http://hackmycf.com - Is your ColdFusion Server Secure?
http://www.youtube.com/watch?v=ubESB87vl5U - FuseGuard your CFML in 10
minutes




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356275
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


  1   2   3   4   5   6   7   8   9   10   >