RE: Need help with decryption from C#
I've done encryption before, and have been able to successfully send the encrypted data to third parties for decryption; but I've never been on the other side of the transfer, and the initialization vector has me especially confused. Using CF's Decrypt(encrypted_string, key[, algorithm, encoding, IVorSalt, iterations]) You should be able to do something like this... Note, this is off the top of my head for TripleDES and I've not tested it in the slightest. The only thing that really concerns me though is the chr(0) in the middle of the StringBuffer append sequence. You may have to experiment with how you build that ByteArray. sb = createObject(java, java.lang.StringBuffer); sb.append(chr(27)); sb.append(chr(9)); sb.append(chr(45)); sb.append(chr(27)); sb.append(chr(0)); sb.append(chr(72)); sb.append(chr(171)); sb.append(chr(54)); IVector = sb.toString().getBytes(); // convert the StringBuffer to a ByteArray outputString = Decrypt(inputString, Hash(Key, MD5), DESEDE, Base64, IVector); Paul ~| 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:357033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Check an email domain
Just to be clear, CFX_ValidEmail is my tag. It was written in Delphi 7 and interfaces to CF through the C++ interface. All of the CFX tags I built are 32-bit only and unlikely to ever get an upgrade. They were all written at the time of CF4 and have had bug fixes and maintenance for them since that time but I'd recommend finding alternatives these days. To that end, I've been moving over the more popular of my CFX tags to have CF/Java replacements and although I haven't got around to doing CFX_ValidEmail, it would be relatively easy to replicate now in CF8 or above. To replace CFX_ValidEmail, I'd look at performing an MX lookup on the domain and then if you need to do an SMTP check, you'd have to implement a short SMTP client that pretends to be sending an e-mail to the relevant server and validates the inbound e-mail address against the mailboxes it looks after. In my POPCFC client on RIA forge, there's a socket class that makes sending and receiving data over protocols like SMTP easy so it wouldn't take more than a couple of hours to rig something up to replace CFX_ValidEmail totally in a pure CF/Java way. Paul ~| 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:356922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What would you call high traffic for CF8 standard?
Just to round this off. It seems I've solved the issue today. Thankfully. It turns out one of the ATS vendors has been posting jobs en-masse repeatedly at a rate of a few thousand per minute. There are only 4,500 jobs but they're repeatedly posting the same jobs over and over and over again all the time. The import routine is based on a web service and accepts job postings and queue's them for processing at a later time. The queue processing then occurs every 9 minutes and it processes posts at a time either inserting or updating existing jobs in the system. The queue processor makes use of cflock to ensure only one processor can run at once and it then runs until all jobs are imported. If another instance is run via the scheduled task, it fails due to the cflock which is in place. It turns out that the volume of posts the import process was processing meant it was pretty much running constantly. I've temporarily paused the import routines and stopped accepting posts to see what the performance difference is on the server. It's quite dramatic. Where I was seeing 1.2 million queries every 5 minutes I'm now seeing 250,000 queries in 5 minutes. The CPU processor load has reduced significantly and the page count which includes the cfc based web service has returned to much more sensible levels. I've raised a ticket with the relevant vendor to ensure that they only post new and updated jobs as per the original specification rather than sending everything all the time. Hopefully they will resolve the issue shortly. Thanks for all the assistance and offers of help both on and off list. Paul ~| 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:355936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What would you call high traffic for CF8 standard?
I've been looking at the memory usage over the last 24 hours and spotted an optimisation that may benefit the server. The MaxPermSize was set to 384MB and the Eden space was set to 256MB. Looking at the memory usage, the MaxPermSize was nowhere near its limit and the Eden space was so I've swapped these two values around. I also took a closer look at the data source settings. There's not a lot to tweak in there but I figured I'd take a look. Up until now, the Timeout and Interval for connections were set to the defaults of 20m and 7m respectively. These are now set at 5m and 2m respectively which should time out and release abandoned connections much more quickly freeing up much needed resources. Currently the server has just over 3,800 active sessions and is averaging around 200 pages per second and 1600 queries per second and is running fine. I'll be watching it all afternoon I think. Being a job site, aside from the search, are the other CF pages really dynamic? You could maybe do things like dump all the job descriptions and corporate jargon pages to html a couple times a day and serve those instead. Yes, it's an application for corporate career sites which includes a full role based CMS. When you log in as a user, the nature of the pages can be subject to change and the navigation is definitely subject to change. For this reason alone, the entire site is CF. There are no static pages. In fact, even the style sheets are CF driven. In order to improve performance and bandwidth usage, the system has a style sheet compiler which takes a file with @import directives, loads every file and concatenates them then shrinks them down as small as it can be and serves it all in one file. The CF intelligently uses client side caching for the style sheets so more often than not returns a short HTTP 304 rather than serving the style sheet at all. It makes for very quick, bandwidth efficient sites :D If you have that many page hits, ask yourself how many unique users you have in a given time frame. Do you really need sessions in the job section? Again the answer is yes. If you're an internal job seeker, you're logged in and the search performs differently dependent on your designated role. For instance you can see jobs that are marked as display internally only. Depending on the variables in the session those could be eating memory up unnecessarily. The session scope is used sparingly. Around 5 vars are used in total per session. Overall I would say you are just close to the physical limits of the server during peak times. A similar 64 bit machine would most likely not have issue with that type of load. Maybe time for an upgrade. I think so too. Paul ~| 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:355920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What would you call high traffic for CF8 standard?
After looking through the logs (and there are a lot of logs) when the server crashes, the first thing to start appearing is cfquery timing out. The DB however is fully responsive to other clients when this happens, so the issue is CF data source related rather than the DB directly. This all happens when there is a surge in traffic and I've identified the source of this surge as twitter users. It seems there are a few Government run careers services on Twitter with significant numbers of followers that have been tweeting links to jobs and the job search function on the sites I'm having issues with. Within 30 minutes of a tweet by those accounts, I've got a surge in traffic that swells to the point that CF gives up. It's a good idea but I don't think the change DB time out is saving you much. These DB connections are very tiny in terms of resources - probably around 24k or so. No data is associated with a connection - and a site as busy as yours will drop fe of the connections from the pool anyway. If it does drop connections regularly it has to build new ones which takes more time than pulling one from the pool since it has to authenticate. I figure that by reducing the time to clean up old unused connections and increasing the clean up rate, it should at least give CF more capacity to open connections when there is a surge in traffic. I'm not expecting a huge difference, just a smoother performance curve with this sort of change. Having said all that I really don't think this change will be noticeable or measurable :) This may be the case. At the moment stability is much better since I made the data source and JVM changes this morning although traffic is a bit quieter today (Monday is our busiest day). Having said that, looking at the stats right now, I've got over 4000 active sessions on the server at the moment so it's not that quiet! Paul ~| 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:355923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What would you call high traffic for CF8 standard?
Locks and blocks can occur and have no overall impact on general DB server performance - but still bring down your site because they prevent other queries from completing. I'd bet my left eye that's what's happening. Here's what I would do snip On this server, I've done all what you've suggested many, many times, I'm going blind looking at SQL profiler these days! LOL The sites already make extensive use of NOLOCK hints especially around the job search functions. The link below shows a typical example of what I see from the profiler, occasionally one of the queries may whip by with a duration of 16ms instead of 0ms as you can see also, as everything is using prepared statements, it makes life difficult in actually determining anything useful from the profiler. http://www.newmediadevelopment.net/user/temp/Trace-screen.gif Pretty much every query that goes through looks like that and is equally as quick. I just don't see the DB slow down. Pretty much every query that goes through is from the view job page. Most of the queries listed have a CF cache time of 5 minutes but there are so many job views of so many jobs that they still dominate the profiler... Paul ~| 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:355927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What would you call high traffic for CF8 standard?
Hi Byron, Here's a simple one to show you real time what is executing on the server. What version of SQL Server is that for? Paul ~| 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:355928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What would you call high traffic for CF8 standard?
That should work on 2005 and above as best I know. Not sure about 2000. Not SQL 2000 then :-( Also, I noticed in the trace, some of the queries look a bit sequential, based on the parameters. Maybe like you are looping over a result set and doing queries for each record in that first result set. If so, that could be a huge improvement point. Yeah, they look it don't they. They aren't though. When jobs are imported they're given an ID which is sequential I also keep a copy of the ATS vendor's job ID, the ATS vendor from whence it came and the recruiters reference in the system too so each job can be identified clearly. Because the jobs tend to be imported in bulk every few hours, jobs that are posted at the same time end up being tweeted, facebooked and generally pimped out all over the Internet at the same time too. This means that when people visit from those sources, they look at jobs from the same batch so the queries look pseudo-sequential when they are in fact totally random. Paul ~| 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:355932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What would you call high traffic for CF8 standard?
Yeah... again I would say you are getting all you can out of this setup. I'm not finding a lot to criticize :) -Mark Thanks. It just crashed again. Albeit the reliability is much improved over what it was by reducing the time for cleaning up connections and switching the memory allocations around as I've noted previously. This time though, the profiler was running through the crash. I've now got 20 million trace rows to trawl through to see if it really is a DB issue or not... Paul ~| 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:355933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What would you call high traffic for CF8 standard?
I'm currently experiencing stability issues with CF 8 standard due to what I think is high traffic loads on the sites its running. There are 6 sites on this particular instance of CF8 and collectively they're averaging at around 750 pages per second which result in around 6000 SQL queries per second (that's queries, not transactions) when measured over a peak 24 hour period. At peak times (just before and just after lunchtime) then I can see as many as 1250-1500 pages per second and 10,000 to 12500 SQL queries per second. It's at these peak times that CF starts to queue requests and then restart. Clearly this is not desirable but I haven't got any numbers to compare it with to see if I'm hitting CF's limits on the hardware available to it or whether I can or should be tweaking the CF code and JVM some more. For comparison, a normal 24 hour period is characterised by an average of around 200 pages per second with around 1500 queries per second and CF has no problem with that. The sites in question are job sites so there's a lot of searching going on using K2 and SQL to merge aspects of the jobs with geo-location data such as distance from a postal/zip code. As you can see from the numbers there's an average ratio of 8 queries to 1 page request which I believe for the site is pretty lean. Do any of these numbers look out there. Is anyone else running these numbers (or higher) on a CF standard install? Hardware wise it's running on a DELL PowerEdge 2650 with 4GB RAM and Dual Xeon processors running@3.33GHz. Thanks Paul ~| 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:355902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: What would you call high traffic for CF8 standard?
I assume this is 32bit given the amount of RAM. If by 750 pages per
second
(bursts up to 1250-1500) you mean ColdFusion templates executing (and I
assume you do) then you are getting quite a bit out of the server I'd
say
and making good use of your xeon 3.3's :) Your options for tweaking
are
going to be fairly limited - perhaps some tuning with how GC operates
or
changes to the simultaneous request number - and of course caching
(queries
or structs or whatever you are using repetitiously). But all in all
that's
pretty good for page executions per second. Note - page executions are
not
the same thing as http requests... 750 http requests could well be
quite
modest. Most http requests are NOT for cf pages but for css, images, js
etc.
Also I would add that it is often the performance of the database
that
determines the capacity of the web server. It sounds like you are doing
ok
with that as well.
Mark Kruger - CFG
Mark,
Yes, it's 32-bit and yes, that's 750 - 1500 CF pages per second. Typically a
request hits the following CF templates.
* application.cfc
* header.cfm
* mainpage.cfm
* footer.cfm
The page speed warning level is set to 5 seconds so I can see what's holding
things up quite easily. The job search is the thing that regularly triggers
the limit... However, it's not too bad given the amount of searches going on
and typically they complete in 5 seconds or slightly less. E.g.
processing template: pathtosite\www\jobsearch.cfm, completed in 5 seconds,
exceeding the 5 second warning limit
In terms of HTTP hits per second, then I'd have to double check but HTTP
hits per second will be much, much higher.
The DB is MSSQL Server, *all* queries are effectively prepared statements
and use CFQUERYPARAM everywhere. The sites make extensive use of
CachedWithin and most queries have execution times of 0 according to the
SQL profiler.
The server has the following Config settings:
Simultaneous Template requests: 50
JVM Heap Size : 1088MB
JVM arguments:
-server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=384m -Xmn256m
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib
-XX:+UseConcMarkSweepGC -XX:+UseParNewGC
Caching: 8200 templates (more than enough)
Trusted Cache is on
Save Class files is enabled
Max. Cached queries: 750
Sessions:
J2EE sessions are enabled and have a max. timeout of 30 minutes
Paul
~|
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:355909
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFPOP and multipart bounce messages
Anyone got any ideas for me? http://popcfc.riaforge.org Check out the functions with RAW in their names, it bypasses CFPOP in those functions and should handle bounce messages for you. Paul ~| 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:354908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hack - Further Information
What should we do to allow CFChart to function without opening a security hole? What we do is this. 1. Duplicate the CFIDE directory in full. 2. In the duplicate, remove the administration folders altogether. 3. In all but the CFAdmin site itself on the server (which should really not be accessible over the web), map the CFIDE to the version that no longer contains the admin folder. This stops no end of possible security threats before they can start and if this had been implemented on your server would probably have stopped the hack from being successful. Paul ~| 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:354287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hack - Further Information
Pete, That approach may work in some cases, but there are cases where /CFIDE/administrator/index.cfm may still resolve even if there is no folder there (or no virtual directory). You're going to have to explain how /CFIDE/administrator/index.cfm could resolve when the CFIDE mapping is pointing to a directory that is a duplicate CFIDE with *all* the administrator folders removed. I must be missing something here but how can it resolve when there is definitely no file or folder and the mappings in CF and the web server all point at the duplicate? Has CF got some special code that I should know about that breaks the rules as to how web servers work? I've been working with CF since 4.0 and never seen it serve a page that does not exist... Paul ~| 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:354290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Hack - Further Information
That approach may work in some cases, but there are cases where /CFIDE/administrator/index.cfm may still resolve even if there is no folder there (or no virtual directory). You're going to have to explain how /CFIDE/administrator/index.cfm could resolve when the CFIDE mapping is pointing to a directory that is a duplicate CFIDE with *all* the administrator folders removed. I must be missing something here but how can it resolve when there is definitely no file or folder and the mappings in CF and the web server all point at the duplicate? Has CF got some special code that I should know about that breaks the rules as to how web servers work? I've been working with CF since 4.0 and never seen it serve a page that does not exist... First, I strongly recommend you actually try to get the URL and see what happens. I did before I posted asking for clarification. I got a 404. OK, now that you've done that: CF serves all sorts of pages that don't exist. You may read up in this very thread about CFCHART, which relies on a URL pattern that doesn't exist. CF relies on servlet mappings, which may or may not correspond with actual URLs. Typically, they do, but there are some specific URL mappings that are created by default when you install CF, and one of them is /CFIDE/Administrator/index.cfm. Another is /CFIDE/Main/ide.cfm - this is another file that doesn't even exist by default. I understand that under special circumstances like CFChart it serves pages that don't exist. But in the scenario I outlined where CFIDE mappings have been re-pointed to a folder that does not carry the administrator folders and the web server provides a Virtual directory to the very same duplicated CFIDE folder, I fail to see how it would ever serve the content from the administrator and adminapi folders... So, you need to specifically configure your web server to reject these patterns. The CF 9 Lockdown Guide (which I believe Pete wrote in part, if not in full) describes how to do this for IIS and Apache. That's fair enough and I do lock down our servers extensively. Hopefully following what is best practice along the way and the lockdown guides for different versions of CF are part of that process for me. Paul ~| 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:354293 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Verity Collections Stalling
Paul: Thanks for the response. I may end up implementing something like this if all else fails but I'd prefer to find the actual cause of the problem to prevent this from happening in the first place instead of responding after the fact. Any ideas what could be causing the collections to stall? Seriously, that solution is what I came up with after spending more time than I'd like to admit to looking at Verity. In the end, I came to the conclusion that the version of Verity baked in to CF simply isn't up to the job of heavy load search queries when it's handling multiple catalogs. I ended up writing the exception handler so that I wasn't caught out with a downed search service simply because Verity lost the plot. By doing what I've done, I haven't had to manually manage the collections in around 5 years. Even the full removal of catalogs and their subsequent rebuild is automated if it escalates to that. One of the weirdest things that Verity does is get its catalogs mixed up... Sometimes you can search against one catalog and verity returns results from a completely different one. Not clever. All our servers are CF8 at the moment and I'm running CF 10 on the dev laptops at the moment with CF8 in staging. As soon as I can get the staging server and production servers over to CF10, I'll dump Verity for Solr in a heartbeat. All my search code and catalog management is wrapped up in a set of objects so I can swap out the low level verity.cfc for a solr.cfc that has the same functions with Solr specific implementations and all the rest will just work. Can't wait. Paul ~| 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:352257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Verity Collections Stalling
I actually have an exception handler to deal with this very problem... It's pretty specific to our system but you'll get the idea... cfcatch !--- Refer to the K2 Client Programming pdf for error codes --- !--- -1705 means the collection is offline - we only see this error when we are re-indexing the entire catalog. --- !--- -2 means a generic fail - Only restarting the Search Service fixes this error. --- cfif cfcatch.Detail DOES NOT CONTAIN (-1705) AND cfcatch.Detail DOES NOT CONTAIN (-2) cfset fireEvent(CheckCatalogIntegrity, Struct(catalogName=variables.instance.catalog,criteria=arguments.criteria,se archType=arguments.searchType), true) cfset mailArguments(Integrity check, arguments, variables.instance, cfcatch) cfelseif cfcatch.Detail CONTAINS (-2) or cfcatch.Detail CONTAINS cannot make connection to server at: k2://localhost:9921 cfset fireEvent(restartSearchService, Struct(catalogName=variables.instance.catalog), true) cfset mailArguments(Search Service Failed. Restart requested., arguments, variables.instance, cfcatch) /cfif cfset q = QueryNew(none) /cfcatch The fireEvent function launches threads so the CheckCatalogIntegrity and restartSearchService functions are launched without slowing the user experience down and we get some nice debug when the problem occurs which isn't too often thankfully. CheckCatalogIntegrity does that by carrying out another search using the same search terms. If it fails for a second time, the catalog is automatically rebuilt. restartSearchService runs a custom batch file to restart the CF search service. In addition to that info, the Verity K2 Client Programming Guide may come in helpful for any other error codes you may come across... http://newmediadev.typepad.com/files/verity-k2-client-programming-guide.pdf HTH Paul -Original Message- From: Mosh Teitelbaum [mailto:mosh.teitelb...@evoch.com] Sent: Monday, August 20, 2012 9:55 PM To: cf-talk Subject: Verity Collections Stalling All: I'm maintaining a client's CF server (CF Standard 8 on Win2k3) and have been running into a weird problem that I can't figure out. The website has a number of Verity collections defined, all of which are used from a single search interface. The search itself works fine but, every now and then (seemingly randomly), a collection (which one also seems random) will seem to stall for lack of a better word. This causes any searches against that particular collection to fail with the following error: There was a problem executing the cfSearch tag with the following collections. Collection (status code): teachers (-1705) brThe error occurred on line 28. The code on line 28 is simply the cfsearch tag being used to perform the search. The only thing that seems to get around this issue is to delete the collection, recreate it, and reindex it. This gets it working again until it once again stalls. A few times, the CF Administrator wouldn't allow me to delete a collection until I had restarted the CF service first but, usually, this isn't required. Any ideas what could be causing this or even where I could begin looking to diagnose the problem? I'm never made aware of the problem until someone tries to run a search against a stalled collection so I only get error information for the error after the fact. But none of the logs seems to show anything that would cause this either. Thanks in advance. -- Mosh Teitelbaum evoch, LLC http://www.evoch.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:352240 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Making a website mobile friendly
What's the best way to handle making a website mobile friendly? Well that's a loaded question and the answer is, it depends... Technically, you can simply provide a CSS style sheet for handheld devices which can re-format the layout of the site and turn off elements of the page that aren't particularly suited to mobile devices or alternatively you can create a standalone site. Either way, this will depend entirely on your requirements and I've done both in the past. As examples, my own hobby site simply uses a handheld style sheet to deliver a slightly different layout for the site to make it a bit more flexible for mobiles. http://www.retro-kit.co.uk/. This approach retains most if not all of the main sites content and functionality. One of our clients sites however uses a fully optimised for mobile mini-site that driven from the same CMS and is automatically redirected to if the visitors user agent matches those defined as being handheld. The sites are served on two different sub-domains being http://www.krispykremejobs.co.uk/ and http://m.krispykremejobs.co.uk/ the latter of which is redirected to when the former is visited by a mobile. The mobile version of the site uses a much reduced set of features but enables the core functions to remain and has been quite successful in its approach. The two sites Krispy Kreme sites use a simple cookie to remember the users choice if they end up on the mobile site but would prefer to be on the full site by clicking on the View full site link in the footer. Likewise in the footer of the main site, the mobile link sets the same cookie to indicate the preference for the mobile domain. If no cookie exists the user is directed using the rule set as indicated above. This allows users with advanced smart phones capable of accessing the full site but usually identified as handheld to choose to receive the full site or vice-versa. Paul ~| 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:351969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Installing CF10 on IIS7.5 Win7 64-bit
Iâm having real trouble getting CF10 Developer Edition installed and Iâve no idea why. I get to the point where I have to choose which websites to install CF into and I choose All sites at which point, the installer pops up and says... âCannot configure IIS connector. Enable the required options ASP.NET, ISAPI Extensions and ISAPI Filter in IIS under Windows Features and try again.â The thing is, I checked and these components are already installed and running in IIS and the error log isnât much help as it states: 86 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors Not a lot to go on so if anyone can shed any light on why Iâm not getting very far that would be a great help... I should add that this is my brand new system so itâs a full fresh installation of Win 7 Pro and IIS 7.5... Paul ~| 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:351559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Installing CF10 on IIS7.5 Win7 64-bit - SOLVED
That did it :D It's now installing quite happily. Thanks very much Paul -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, June 13, 2012 1:50 PM To: cf-talk Subject: re: Installing CF10 on IIS7.5 Win7 64-bit I had that happen, too. Go through Control Panel and install CGI and re-try it: * Control Panel * Turn Windows features on or off * Internet Information Services * World Wide Web Services * Application Development Features * check CGI and hit OK - Jason From: Paul Vernon paul.ver...@web-architect.co.uk Sent: Wednesday, June 13, 2012 8:37 AM To: cf-talk cf-talk@houseoffusion.com Subject: Installing CF10 on IIS7.5 Win7 64-bit Iâm having real trouble getting CF10 Developer Edition installed and Iâve no idea why. I get to the point where I have to choose which websites to install CF into and I choose All sites at which point, the installer pops up and says... âCannot configure IIS connector. Enable the required options ASP.NET, ISAPI Extensions and ISAPI Filter in IIS under Windows Features and try again.â The thing is, I checked and these components are already installed and running in IIS and the error log isnât much help as it states: 86 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors Not a lot to go on so if anyone can shed any light on why Iâm not getting very far that would be a great help... I should add that this is my brand new system so itâs a full fresh installation of Win 7 Pro and IIS 7.5... Paul ~| 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:351562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Email Addresses with Subdomain causes CFMAIL to fail?
Unless I'm mistaken, there's a space in the users e-mail address where there shouldn't be one. Paul -Original Message- From: Jeffrey Battershall [mailto:jbattersh...@gmail.com] Sent: Friday, June 24, 2011 6:13 PM To: cf-talk Subject: Email Addresses with Subdomain causes CFMAIL to fail? Hi, This is a new one for me: user has an email address like tlk...@subdomain.domain.net and CFMAIL ls throwing an exception The value of the attribute to, which is currently tlk572@subdomain.domain .net, is invalid. Anyone run into this before? Jeff ~| 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:345641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Alternatives to CFFM?
I think you might be right, David, except that there is no right click menu on that popup. That's the problem. I tried doing that about 8 weeks ago when I first encountered the problem. Mike, *LEFT* click on the error, press CTRL + A to select all, CTRL+C to copy and then open your editor and paste in the error message. Simples ;-) Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336393 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Alternatives to CFFM?
At no point do the instructions I gave use a context menu. They do however work for me when debugging errors that appear in javascript alert boxes... Paul -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Thursday, August 19, 2010 1:55 PM To: cf-talk Subject: Re: Alternatives to CFFM? From the looks of the screeners that ISN'T a pop-up, it's a javascript alert. There is no context menu. On Thu, Aug 19, 2010 at 8:40 AM, Paul Vernon paul.ver...@web-architect.co.uk wrote: I think you might be right, David, except that there is no right click menu on that popup. That's the problem. I tried doing that about 8 weeks ago when I first encountered the problem. Mike, *LEFT* click on the error, press CTRL + A to select all, CTRL+C to copy and then open your editor and paste in the error message. Simples ;-) Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Alternatives to CFFM?
Sorry, I simply haven't had time for my open source projects and that includes any kind of support on my open source projects. Going to cf-talk is the right thing of course. #1 - the screenshot posted is a javascript alert, not really a popup, so you can't right or left click on it and select anything. Rick, just FYI, I can and do get the data out of those alert boxes on a regular basis. I posted instructions on how to do this earlier ;-) #2 - the contents of the alert show your CMS login, which means the upload script isn't authenticated, as someone else suggested earlier. Regardless of the fact that you are logged in and normal CFMs are executing fine, you can't argue with the fact that the upload script isn't authenticated. I can tell you why - it's because the flash app that's sending the files doesn't send the same cookies that your browser sends directly. I don't know why and I haven't found the time to figure it out. So the flash uploader basically doesn't work. The reason for this is that the flash uploader has its own HTTP client built in that is not the browser. Cookies saved by one HTTP client are generally stored in a different place to another HTTP client and as such, the flash and browser cookies are distinct. Unless you pass in the relevant cookies into the flash when you initialise it and force those cookie values to be used by the flash HTTP client when the upload is triggered it will never work where authentication is required as is the case in this instance. Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: best 301 method
If providing a 410 status code, what should I put in the statustext? Gone should just about cover it! Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: www.cbo.gov down. CF to blame?
I have some friends piling on Coldfusion because the www.cbo.gov website is down. Drudge linked to it I guess and crashed the site and they are blaming CF. The error is HTTP Error 503. The service is unavailable. Isn't this an IIS issue? How would you respond to well the cbo.gov, it's running on coldfusion. so no big shock there I've had this happen once. It wasn't CF in our case, it was IIS application pools in IIS becoming unresponsive after the configured fail count within a set period... For us it was 5 unresponsive pool pings in 5 minutes. IIS shuts down the pool and doesn't restart it to protect the other application pools. If you have significant load IIS can and will fail in this way... In your case, whether it is CF or not would only be answered by checking out the logs on the servers involved... Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335825 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: ColdFusion heapsize and Win 2008 datacenter
On a normal 32 bit windows server the max heapsize for ColdFusion is limited to 1 gig. This limit does not exist on 64 bit servers. Does this limit exist on 32 bit windows 2008 dataserver edition machines? I've been told that there is no ram limit for this version of windows but does that apply to ColdFusion? The limit applies to the JVM. If you're on 32-bit Windows then you're on a 32-bit JVM therefore the 1Gb limit applies as I understand it. Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Checking Existence of Verity Collections
I use these two functions... cffunction name=catalogExists access=public returntype=boolean output=false hint=Checks to see if a catalog exists by attemtping to perform a search. cfreturn CatalogStats().recordcount GT 0 /cffunction cffunction name=catalogStats access=public returntype=query output=false hint=Returns all the catalog statistics cfset var q = cflock name=#variables.instance.searchHash# type=readonly timeout=20 cfcollection action=list name=q /cflock cfquery name=q dbtype=query SELECT * FROM q WHERE name = cfqueryparam value=#variables.instance.catalog# cfsqltype=cf_sql_varchar maxlength=100 /cfquery cfreturn q /cffunction Paul -Original Message- From: Robert Nurse [mailto:rnu...@gmail.com] Sent: Thursday, May 20, 2010 2:09 PM To: cf-talk Subject: Checking Existence of Verity Collections Hi All, Is there a way to programmatically determine if a Verity collection exists? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333840 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: scraping meta tags
What's the best way to accomplish this? In particular, how do we scrape the meta tags using CF8? Here's how I'd approach it. 1. Write a spider using CFHTTP at its core. 2. Write a parser that can parse cfhttp.filecontent looking for the meta tags you're interested in 3. Create a loop that uses cfthread to call your spider and parses the response using the parser say 10 times per loop. (More if you have Enterprise). 4. Stick the parsed data in the DB and loop round to the next load from the list. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfpop and GMail
http://mail.google.com/support/bin/answer.py?answer=86378 Under Other Issues... How do I download mail to multiple POP clients? To access your messages with multiple POP clients, use recent mode in every client to make sure that all messages are made available, rather than only to the first client to access new mail. Recent mode fetches the last 30 days of mail, regardless of whether it's been sent to another POP client already. To enable Recent mode, replace 'usern...@gmail.com' in the Username field of your POP client settings with 'recent:usern...@gmail.com' and ensure that the Leave messages on server option in your POP client is enabled. Paul -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, February 16, 2010 3:02 PM To: cf-talk Subject: cfpop and GMail Has anyone noticed that, within the past month or so, behavior with cfpop and GMail has changed? It used to be that, if you had GMail set to Enable POP for all mail (even mail that's already been downloaded), every call to cfpop action=getall would return *all* messages in the In box. Now, it seems, calls to cfpop action=getall only return *new* messages in the In box. (You can fake it by re-selecting Enable POP for all mail which will, one time only, make it so that cfpop action=getall fetches all messages in the In box.) Anyone else seeing this? Anyone know of a workaround? -- John Bliss IT Professional @jbliss (t) / http://www.brandiandjohn.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330772 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfpop and GMail
It's yet another example of the flawed POP implementation that Google has invented... It bears no resemblance to the POP RFC documentation whatsoever! Paul -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, February 16, 2010 3:14 PM To: cf-talk Subject: Re: cfpop and GMail To enable Recent mode, replace 'usern...@gmail.com' in the Username field of your POP client settings with 'recent:usern...@gmail.comrecent%3ausern...@gmail.com ' Solved! Paul, the next time you're in Houston, I owe you a beer! :-) On Tue, Feb 16, 2010 at 9:08 AM, Paul Vernon paul.ver...@web-architect.co.uk wrote: http://mail.google.com/support/bin/answer.py?answer=86378 Under Other Issues... How do I download mail to multiple POP clients? To access your messages with multiple POP clients, use recent mode in every client to make sure that all messages are made available, rather than only to the first client to access new mail. Recent mode fetches the last 30 days of mail, regardless of whether it's been sent to another POP client already. To enable Recent mode, replace 'usern...@gmail.com' in the Username field of your POP client settings with 'recent:usern...@gmail.comrecent%3ausern...@gmail.com' and ensure that the Leave messages on server option in your POP client is enabled. Paul -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Tuesday, February 16, 2010 3:02 PM To: cf-talk Subject: cfpop and GMail Has anyone noticed that, within the past month or so, behavior with cfpop and GMail has changed? It used to be that, if you had GMail set to Enable POP for all mail (even mail that's already been downloaded), every call to cfpop action=getall would return *all* messages in the In box. Now, it seems, calls to cfpop action=getall only return *new* messages in the In box. (You can fake it by re-selecting Enable POP for all mail which will, one time only, make it so that cfpop action=getall fetches all messages in the In box.) Anyone else seeing this? Anyone know of a workaround? -- John Bliss IT Professional @jbliss (t) / http://www.brandiandjohn.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330777 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Debugging Out of Memory errors, SeeFusion Memory / Active requests graph
and have reduced the troubles a great deal. However, there still seems to be an underlying problem that is causing CF to crash out with multiple instances of the error: unable to create new native thread The specific sequence of files included or processed is: [xxx] java.lang.OutOfMemoryError: unable to create new native thread Classic. I found that these errors are due to Eden memory being set way to small for the application. http://blog.newmediadevelopment.net/2009/10/tracking-down-out-of-memory-erro rs-in-coldfusion-standard.html In the blog entry, I state forcing the Eden to 128Mb using -Xmn128m. We ended up setting it to -Xmn192m and since then we haven't had a single out of memory issue and the server hasnt had a CF restart or reboot in 60 days. We handle a similar load to what you've described in your full post but depending on your application YMMV. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The start of a pure CF - CFX_POP3 replacement :-)
So I've finally started a CFX_POP3 replacement project and I'm open sourcing the thing too :-) http://popcfc.riaforge.org/ At the moment it has functions that can extend the POP functionality in CFPOP to match that of CFX_POP3 and I've added some extra functions too. There are features that are missing from POPCFC that are in CFX_POP3 such as the SPAM filtering Bayesian analysis functions but the main POP processing functions that are missing from CFPOP are in there such as... - hasMail() returns a Boolean if the mailbox has mail. - getMessageCount() returns the number of mails in the mailbox. - getUIDList() returns an array of UID values for the messages in the mailbox. - getMessagesAfterUID() returns all messages (up to maxrows) that have been received since the message specified by the UID passed in. Performance wise, these functions are as fast or faster than CFX_POP3. You can use the CFC as follows: !--- normal usage --- cfset popAccount = createObject(component, pop).init(myserver, myusername, mypassword) cfif popAccount.hasMail() cfset messages = popAccount.getMessages() cfdump var=#messages# /cfif - OR - !--- SSL usage --- cfset popAccount = createObject(component, pop).init(myserver, myusername, mypassword) cfset popAccount.setProperty(UseSSL, true) cfif popAccount.hasMail() cfset messages = popAccount.getMessages() cfdump var=#messages# /cfif Hope you like it! If anyone finds any problems with it, be sure to let me know :-) Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfpop - do not want to retrieve duplicate emails
We need to be able to POP emails from a Yahoo! Mail account without deleting the emails and without retrieving the same email twice. If I set the action attribute to Delete in the cfpop tag, it deletes the email from the Yahoo account. Is there a way to only pop unique emails without deleting them from the mail box? Keep a copy of the UID's you have downloaded locally, compare against the UID's on the server and only do a GETALL on the ones you haven't seen before and then store those UID's too. This process will get progressively slower as more and more e-mails are left on the server though. CFX_POP3 has a GETUIDLIST function which just retrieves the UID's of the mails on the server and makes the process lightening fast but it only works on 32-bit CF installations on Windows so it's life is limited now. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Consuming a webservice fails in CF but not in Eclipse WPT
Hi Paul My guess is a namespace issue on the type EmployeeBean In one message it is referenced from namespace imp1, in another message it's referenced from xsd, so I'm guessing that if you correct whichever is incorrect it will work fine (probably the xsd:EmployeeBean needs changing to imp1:EmployeeBean) - this is just a guess but it does seem to indicate that it's looking for EmployeeBean type in namespace xsd which == http://www.w3.org/2001/XMLSchem when it would be in the namespace of urn:TBEWebAPI == imp1 After much head scratching, that is what I figured, unfortunately, I have no control over the wsdl as it is generated by Taleo on their servers so unless they fix their wsdl generation it would appear that I'm screwed if I want use CF to consume the web service :-( To verify this, since I originally posted I downloaded the wsdl file and replaced all xsd:EmployeeBean occurrences with impl:EmployeeBean and tried to use WSDL2Java on the local copy. I made progress but then got the error that the FlexRollingEntityBean was referenced but not defined. This was the same issue so I replaced all xsd:FlexRollingEntityBean with impl:FlexRollingEntityBean and re-ran the WSDL2Java tool again, this time it generated a null exception. What vexes me most is that the wsdl works in Eclipse WPT so these issues I'm seeing seem to be related to the way in which CF is built to consume web services but their example WSDL file on the Taleo web site can be consumed by CF without a problem. Comparing the example to the actual wsdl generated by their servers however shows several differences so it does seem to add weight to the idea that it's the generation of the wsdl file that is faulty in some way and Eclipse WPT is just less sensitive to the faults. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327990 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Consuming a webservice fails in CF but not in Eclipse WPT
I just figured out that Eclipse WPT does not validate wsdl documents when it consumes them whereas CF does. You can force Eclipse WPT to validate a local copy of a wsdl file and when I do that on the Taleo API wsdl file it fails with multiple errors. So my problem with consuming the Taleo API webservice is down to Taleo rather than CF although it would be nice if you could turn off the validation routines but as I understand it, it's the underlying wsdl2java.jar functions that are at work when we consume web services so I don't think that turning off the validation is a realistic option. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Format word text pasted
How would you go about formatting text pasted from a word document into a coldfusion web form? This is what I do. But it requires some jar files to work to the best of its capabilities. 1. Install the jTidy jars. And register cfx_markdown as a java CFX tag. 2. Check to see if the posted data is HTML or not. 3. If the posted data is *not* HTML, use some RegEx and cfx_markdown to create some HTML from the posted data. 4. Clean out junk HTML markup that a Word formatted submission would include. 5. Parse the HTML with jTidy to make the HTML valid. 6. Run some funky functions to create ordered and unordered lists where appropriate. 7. Re-parse the HTML using jTidy again to ensure that the HTML is still valid. 8. Fix the appearance of ampersands though out the text. 9. Return valid, cleanly formatted HTML. Also should you format the data before it is inputed into the database or would you format the data when it is displayed? On the Store the formatted markup rather than the pasted junk as you only need to parse it once. If you store it as posted and re-parse every time you pull it out, you're putting extra load on the server. If you're paranoid about maybe the parser getting things wrong, store the posted and fixed content together and when you introduce improvements to your Word parsing algorithms, you can re-parse the old content too. I have source code for this but it's quite a chunk of code and is spread around a few CFC's I could probably put all the functions into a file for you to give you some inspiration and you might be able to re-factor them for your purposes as it's really not an easy thing to do and get right. One day I may just make a Word Cleaner CFC that does this all in one place :-). Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Consuming a webservice fails in CF but not in Eclipse WPT
I'm looking at integrating with Taleo at the moment and I'm having problems
consuming their web service.
The wsdl file is located here:
https://tbe.taleo.net/NA1/ats/services/rpcrouter?wsdl
The error I get is:
Cannot generate stub objects for web service invocation. Name:
https://tbe.taleo.net/NA6/ats/services/rpcrouter?wsdl. WSDL:
https://tbe.taleo.net/NA6/ats/services/rpcrouter?wsdl. java.io.IOException:
Type {http://www.w3.org/2001/XMLSchema}EmployeeBean is referenced but not
defined.
If I try to use wsdl2java to consume the service at the command line I get the
same error.
However, if I use the web platform tools in Eclipse to consume and manually use
the service, everything works just great.
I'm running CF8.01 standard and if anyone can shed any light as to why that
service can't be consumed by CF I'd very much appreciate it.
Paul
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327968
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Verity mixing up catalogs
I've got a really strange issue happening at random on one of our servers with verity. To paraphrase the situation, we have two catalog defined per site and they are named sitename_site and sitename_jobs. The catalog ending in _site has an alphanumeric key and the catalog ending in _jobs uses a numeric key. What we're seeing is that after a while, queries to the _jobs catalog starts returning data from the _site catalog and throwing data type errors because we're expecting a numeric key and we're getting an alpha-numeric key. The only way we can resolve the problem appears to be to delete and re-create the _jobs catalog but ideally I'd like to get to the bottom of why Verity is getting the catalogs mixed up in the first place. Any ideas or hints of where I should be looking would be much appreciated. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Randomize Query results?
Also brainstorming for other alternatives. It's a simple round robin load balancer. I'd rather not have the first unit just by database index order selected all the time. This is what I did... VacancyID is a primary key... cfset theVacancyID = q.VacancyID[RandRange(1, q.recordcount)] cfquery name=queryresult dbtype=query SELECT VacancyID, lots of other columns FROM q WHERE VacancyID = cfqueryparam value=#theVacancyID# cfsqltype=cf_sql_integer /cfquery cfreturn queryresult ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion Server keeps falling down!
I'd check the JVM settings for memory allocation and compare them against your old server if you can. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion Server keeps falling down!
There's all sorts of memory settings and I recently had out of memory issues that were related to the Eden space which were solved by increasing the value of -Xmn to 128m. There's a great article on tuning and memory usage here: http://www.adobe.com/devnet/coldfusion/articles/coldfusion_performance_01.ht ml Paul -Original Message- From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] Sent: Monday, October 12, 2009 8:47 PM To: cf-talk Subject: Re: ColdFusion Server keeps falling down! Old server has gone, what figures should we be looking at? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Applications and constant connection
Our company is looking for a solution to a problem we are sure is very common - We have various documents stored within our application on our internet server - our employees connect to the application to access these documents - the problem is... sometimes our employees are at client sites that do not have internet connection and therefore cannot access these documents, which makes it very hard to conduct our business sometimes we would appreciate your thoughts on any possible solutions! Whilst this is completely off topic. Have you considered giving your off-site employees 3G based mobile internet? I simply plug in my phone and use it as a 3G modem when needed giving full mobile broadband goodness. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326623 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multi-part mime messages with cfpop
Anyone had to do that before and found something that works really well in ColdFusion, or I am missing something about CFPOP? If you're on a Windows 32-bit OS you can use CFX_POP3 that I wrote. There is no 64-bit version but if you are on a 32-bit system it should do the trick. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: HoF invaded
Each and every .cfm file that is on a site that is mapped to iis was affected. If a .cfm was in a non-mapped directory then it was not touched. This says to me that the hole is in iis. I suspect you have a query vulnerable to SQL injection. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need help pinpointing an aggressive memory leak
I've got a problem on a production server that has been running since April.
The problem has been ongoing for the last 6 days or so and everything I've
tried doesn't seem to do anything to alleviate the problem.
The server is a Win2003R2 server running a fully patched CF8.01 install. Until
4 days ago, the server was running under JVM 1.6.0_10. Having read through the
change logs for the more recent JVM's there are several memory leaks that have
been fixed in the JVM itself so we upgraded it to JVM 1.6.0_16-b01.
The error I'm seeing in the hotspot JVM error log is:
# A fatal error has been detected by the Java Runtime Environment:
#
# java.lang.OutOfMemoryError: requested 5242880 bytes for GrET in
C:\BUILD_AREA\jdk6_16\hotspot\src\share\vm\utilities\growableArray.cpp. Out of
swap space?
I hooked up JConsole to the production server and watch the system through
several crashes using the following info
-Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.port=9500
-Dcom.sun.management.jmxremote.authenticate=false
-Dcom.sun.management.jmxremote.ssl=false
The only thing that climbs is memory usage.
Memory Pool CMS Old Gen just keep on climbing until about 1.2Gb is used, the
server then runs at this for an hour or two (sometimes less) before restarting
the jrun service.
Average Par Eden memory usage is @ 35 Mb
Average Par Survivor memory usage is @ 6Mb
Average Code Cache memory usage is @ 10Mb
Average CMS Perm Gen is @ 47Mb
Active threads sits at around 90 - 110
Loaded classes sits at around 9 to 10,000
Nothing spikes, there are no hints as to what is happening other that the
aggressive memory leak causing the Out of Memory errors.
I've also tinkered with the JVM arguments and this is what they're set to at
the moment.
-server -Dsun.io.useCanonCaches=false
-XX:MaxPermSize=384m
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib
-XX:+UseParNewGC
-XX:+CMSParallelRemarkEnabled
-XX:+UseConcMarkSweepGC
-XX:+HeapDumpOnOutOfMemoryError
Unfortunately the HeapDumpOnOutOfMemoryError directive seems not to work :-( as
I wanted to examine the dump with JHat but there are no dump files on the
server and we've had 6 JVM crashes today.
The server is hosting 3 sites all of which are running the same code, two are
very light traffic, the third is a medium heavy traffic site with around 20,000
visitors a day averaging out at around 700 sessions in existence at any given
time.
I've been looking through the server logs, the SVN logs etc to see if anything
significant has changed over the last week and as far as I can tell, nothing
has.
The leak certainly appears to be request driven as at low traffic times between
1am and 6am, the site stay up just fine.
The architecture of the platform running on the server is a predominantly
singleton based object hierarchy using a custom object factory to handle the
generation of objects in the system most of the objects provide functions to
interface with the DB and aren't creating lots of objects themselves.
I've also looked at SeeFusion and FusionReactor trials to see if they can help
me but neither of them seem to be able to tell me how much memory each request
is using etc, they both seem to be too general for my needs.
If anyone has any idea as to what I can do to chase this down I'd very much
appreciate it.
TIA
Paul
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326272
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOLVED: RE: Need help pinpointing an aggressive memory leak
Well in the end it was a rookie mistake... DOH!
One of the most heavily used queries in the system was set up to be cached
for 10 minutes at a time. The only problem was that one of the parameters I
was passing into the query was a date/time of Now().
Changing the parameter being passed in from Now() to
CreateDate(Year(Now()),Month(Now()),Day(Now())) has solved the memory leak
completely.
Phew!
Paul
-Original Message-
From: Paul Vernon
Sent: Monday, September 14, 2009 6:55 PM
To: cf-talk
Subject: Need help pinpointing an aggressive memory leak
I've got a problem on a production server that has been running since
April. The problem has been ongoing for the last 6 days or so and
everything I've tried doesn't seem to do anything to alleviate the
problem.
The server is a Win2003R2 server running a fully patched CF8.01
install. Until 4 days ago, the server was running under JVM 1.6.0_10.
Having read through the change logs for the more recent JVM's there are
several memory leaks that have been fixed in the JVM itself so we
upgraded it to JVM 1.6.0_16-b01.
The error I'm seeing in the hotspot JVM error log is:
# A fatal error has been detected by the Java Runtime Environment:
#
# java.lang.OutOfMemoryError: requested 5242880 bytes for GrET in
C:\BUILD_AREA\jdk6_16\hotspot\src\share\vm\utilities\growableArray.cpp.
Out of swap space?
I hooked up JConsole to the production server and watch the system
through several crashes using the following info
-Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.port=9500
-Dcom.sun.management.jmxremote.authenticate=false
-Dcom.sun.management.jmxremote.ssl=false
The only thing that climbs is memory usage.
Memory Pool CMS Old Gen just keep on climbing until about 1.2Gb is
used, the server then runs at this for an hour or two (sometimes less)
before restarting the jrun service.
Average Par Eden memory usage is @ 35 Mb
Average Par Survivor memory usage is @ 6Mb
Average Code Cache memory usage is @ 10Mb
Average CMS Perm Gen is @ 47Mb
Active threads sits at around 90 - 110
Loaded classes sits at around 9 to 10,000
Nothing spikes, there are no hints as to what is happening other that
the aggressive memory leak causing the Out of Memory errors.
I've also tinkered with the JVM arguments and this is what they're set
to at the moment.
-server -Dsun.io.useCanonCaches=false
-XX:MaxPermSize=384m
-Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.libPath={application.home}/../lib
-XX:+UseParNewGC
-XX:+CMSParallelRemarkEnabled
-XX:+UseConcMarkSweepGC
-XX:+HeapDumpOnOutOfMemoryError
Unfortunately the HeapDumpOnOutOfMemoryError directive seems not to
work :-( as I wanted to examine the dump with JHat but there are no
dump files on the server and we've had 6 JVM crashes today.
The server is hosting 3 sites all of which are running the same code,
two are very light traffic, the third is a medium heavy traffic site
with around 20,000 visitors a day averaging out at around 700 sessions
in existence at any given time.
I've been looking through the server logs, the SVN logs etc to see if
anything significant has changed over the last week and as far as I can
tell, nothing has.
The leak certainly appears to be request driven as at low traffic times
between 1am and 6am, the site stay up just fine.
The architecture of the platform running on the server is a
predominantly singleton based object hierarchy using a custom object
factory to handle the generation of objects in the system most of the
objects provide functions to interface with the DB and aren't creating
lots of objects themselves.
I've also looked at SeeFusion and FusionReactor trials to see if they
can help me but neither of them seem to be able to tell me how much
memory each request is using etc, they both seem to be too general for
my needs.
If anyone has any idea as to what I can do to chase this down I'd very
much appreciate it.
TIA
Paul
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326285
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: better DIFFERENCE
Does anyone know of a tool (SQL or CFML) similar to SQL's DIFFERENCE ( http://msdn.microsoft.com/en-us/library/ms188753.aspx) but with significantly higher fidelity. When strings get up around 15 characters, DIFFERENCE will return 4 (closest possible match) for exact matches and also for some matches where it's difficult for me to even see the similarities. I need something that'll return, say, 100 for exact matches, 50 for half matches, etc. I actually use a combination of SQL DIFFERENCE and a Levenshtein distance between the original strings rather than just SQL DIFFERENCE which works on the Soundex of the original strings. It does mean you have to code it in CF rather than in rely on the DB entirely but for me the results are worth it. http://www.cflib.org/index.cfm?event=page.udfbyidudfid=1067 Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to lock down CFIDE in IIS7
I am looking for a good reference on locking down CFIDE on IIS7. I checked google, didn't see much on this topic... As a lot of CF functionality requires the CFIDE folder, this is what I do. 1. Create a duplicate of the CFIDE folder (in fact I have many for historical reasons)... e.g. D:\serverwide\CFIDE\MX\CFIDE\ D:\serverwide\CFIDE\MX7\CFIDE\ D:\serverwide\CFIDE\MX8\CFIDE\ 2. Remove the administrator folder from the duplicate entirely and any other folders you don't require for your site implementations. 3. Ensure that your CFIDE folder is fully up to date with patches. (e.g. the FCK connector patches). 4. Map the virtual directory for CFIDE to the relevant duplicated CFIDE folder. 5. The actual CFIDE folder can then be mapped to *ONLY* your admin site in IIS using a virtual folder and you can either protect the admin site with SSL and username/password authentication or make it accessible to localhost only. 6. Whenever you apply a CF updater or hotfix, remember to duplicate the files from the real CFIDE into your duplicate CFIDE for the specific version of CF ensuring you don't re-create the admin folders or others you've removed for your implementation. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Twitter hashtag RegEx help
Ok, so I thought I'd cracked this and I have to some extent but not completely. The well known hashtag RegEx I see in most Twitter examples is a variant of this ##([a-z0-9\-_]+) The problem with this is that if you run it over a string that contains HTML entities, it will recognise those HTML entities as hashtags too... E.g. #mytrendingtopic is a valid hashtag but this isn#39;t. #mytrendingtopic *and* #39 are recognised as hashtags... Now, my latest crack at this is a bit more complex and looks like this: ##(([a-z_\-]+[0-9_\-]*[a-z0-9_\-]+)|([0-9_\-]+[a-z_\-]+[a-z0-9_\-]+)) Which picks out: 1. All hashtags starting with alpha and containing 0 or more numbers with _ an - at any position 2. All hashtags starting with numbers and containing 1 or more alpha with _ an - at any position This RegEx works well but it's still not quite right. The problem with this though in that if the film 2001 or 2010 we're hashtags e.g. #2001 or #2010 then they would get missed by the RegEx. All other hashtags are recognised just fine and HTML entities are ignored so for the most part it's better than the original RegEx as widely used. I've been working on a fix for this problem and been looking at using lookahead and lookbehind but it seems CF doesn't support all the features I need, i.e. no negative lookbehind. So if anyone can improve on my current RegEx so I can pick out #mytrendingtopic but not #39 from the above example, I'd appreciate it very, very much... Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325319 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Twitter hashtag RegEx help
You could look for hash tags without an in front of it. something like this: (?:[^]|^)##([a-z0-9_\-]+) ~Mahcsig That was close, due to the needs of the code, I had to modify it a bit but you definitely put me on the right track. In the end, I arrived at this ([^]|^)##([a-z0-9_\-]+) as I needed the first group to return too because the RegEx was matching the preceding character whether that was a space, comma or whatever so I needed it so I could reference it in the replace. ReReplaceNoCase(arguments.tweet, ([^]|^)##([a-z0-9_\-]+), \1a href=http://twitter.com/search?q=%23\2;##\2/a, ALL) Thanks... Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session issues - In words of one syllable please :-)
sorry to resurrect an old thread, but I think I have something to add to it... the same issue has manifested itself on one of my sites about 2 days ago all of a sudden. my error handler started flooding my inbox with Session is invalid error reports at a rate of about 80-110 a day. There were a couple of things that I did that sorted this out completely. 1. Double checked the server was using J2EE sessions. 2. Set the maximum timeouts to the same values as the default timeouts in the CF Admin. 3. Set the session-timeout in the web.xml file to a little more than the settings in CF Admin (I added 5 mins). 4. (This is the bit I was missing). Set the setClientCookies var in the application cfc/cfm to false. Because I was missing the last piece, the CFID and CFTOKEN cookies were being issued as well as JSESSIONID. This was causing clients to hold onto the CFID/CFTOKEN combination (sent to the client) when the JSESSIONID (held in server memory) had long since expired. CF was trying its best to reconcile both the CFID/CFTOKEN combination with a valid J2EE session and was failing as the J2EE session no longer existed and was null... hence the error Session is invalid null HTH Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session issues - In words of one syllable please :-)
I also forgot to mention... If you access session information using the SessionFactory then you can cause this issue to occur too. But I think your specific issue is the same as mine was. Paul ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325169 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Session issues - In words of one syllable please :-)
Can someone explain why the Session is invalid null occurs? We have a site on a dedicated server running CF 8 (8,0,1,195765) Standard edition. It gets around 11,000 users a day and for the most part is issue free. I've searched HoF etc., I've read the tech notes and I've subsequently altered the session-timeout value in the web.xml config file so the timeout is larger than the session timeout in the CF admin settings. Altering the session-timeout value has *definitely reduced* this error occurring but it hasn't fixed the problem and my gut instinct is that by altering the session-timeout value I'm just hiding the problem rather than dealing with it. Prior to altering the value, the error was happening around 60 or 70 times a day, altering the value has reduced this error to a couple of times a day. I suspect increasing the session-timeout value to an even larger number will eradicate the problem but because I donât understand the mechanics of why it's happening in the first place, this solution just doesn't feel right. Also, J2EE sessions are enabled and I see the jsessionid in the headers of requests but I still see CFID and CFTOKEN values too. I may have got this wrong but I thought that the jsessionid negated the need for CFID and CFTOKEN? Any explanations as to exactly how the session cookies work and why the session null error happens in the first place are gratefully received! Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Session issues - In words of one syllable please :-)
First, why it happens. When using J2EE sessions, the session is handled by the J2EE server (JRun in your case). JRun has an internal setting for the duration of sessions; that's controlled in the XML file. Now, CF also has its own timeouts, which control how long to keep using the same JRun session; if CF's session timeout is longer than JRun's, CF is looking for a dead JRun session and you get the invalid session error. Make sure the MAXIMUM CF session timeout setting is less than the JRun setting. This is what I don't understand... I have the CF Admin settings set to 20 mins for the session life. The JSEE sessions were set at 30 mins and I saw lots of errors. I've now increased the time to 35 minutes and although the errors are reduced in number, they still happen... As you have stated the issue, the errors should not have happened in the first place with our setup and increasing the J2EE session timeout by a further 5 minutes seems like an odd way to reduce the errors we've seen but, nevertheless, that is what it has done. I'm thinking this may be a timing issue on multi-CPU deployments. I remember back in the day looking at task manager stats where the System Idle time would read close to 48 hours when the server was re-booted 24 hours previously because the clock was accounting for the idle time on both processors... I wonder if the JRun session timeout process is looking at a ticker in the system that is effectively halving/quartering etc. the entered value in relation to the number of processors in the system and causing these timing anomalies? The idea (in my mind at least) has merit. Second, the JSESSION cookie is the only one used for J2EE sessions. The CFID and CFTOKEN cookies are used for client variables; you can prevent them from being set for new users with the setClientCookies setting in your application tag/cfc (set it to false). That sorts out that bit. Thanks! Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Session issues - In words of one syllable please :-)
http://www.bennadel.com/blog/1535-ColdFusion-SESSION-Is-Always-Created- Even-If-OnSessionStart-Fails.htm http://www.bennadel.com/blog/1536-ColdFusion-Session-Management-And- Asynchronous-Page-Requests.htm I have had mysterious SESSION issues and I think I finally figured it out!-- Hi Ben, I tend to read your blog a lot it seems to rank highly for the more obscure issues that I encounter when debugging stuff in CF. As far as I can tell though, I'm not having session start issues, rather session timeout issues in relation to J2EE sessions and the error gets thrown on the cfapplication tag in the old application.cfm files and the This.SessionManagement line in the application.cfc files. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to decode e-mail subject ?
This:B?W1ZpZGVyZXNlbmR0IGZyYSBXUyBTdXBwb3J0XSBQYXlFeCDDuG5za2VyIGRl?= =?utf-8?B?ZyBnb2QgcMOlc2tl?= Is not UTF8 encoding, this is some sort of Outlook crap UTF-8 Encoding is not an encryption schema, it's a file formatting encoding. It usually renders exactly as plain text. =] Actually, it isn't Outlook crap it is standards compliant RFC Quoted-printable content and the utf-8 info is telling you that the quoted printable text once decoded will be in the utf-8 encoding and should be treated as such. It is done in this way so it can be sent to mail systems that still have to support 7-bit encoding mechanisms. You'll need to look at finding a Quoted-Printable decoder for CF. I have one built into my CFX tags but they are written in Delphi so not really much help for you at the moment. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321425 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to decode e-mail subject ?
This:B?W1ZpZGVyZXNlbmR0IGZyYSBXUyBTdXBwb3J0XSBQYXlFeCDDuG5za2VyIGRl?= =?utf-8?B?ZyBnb2QgcMOlc2tl?= I missed something... It's not quoted printable, it's binary encoded. Q for quoted-printable and B for binary. You need to look for =?B? Or =?Q? At the beginning of the string. If its =?B? Then take everything between =?B? and ?= and base64 decode it. W1ZpZGVyZXNlbmR0IGZyYSBXUyBTdXBwb3J0XSBQYXlFeCDDuG5za2VyIGRl decodes as [Videresendt fra WS Support] PayEx ønsker de ZyBnb2QgcMOlc2tl decodes as g god påske To handle all eventualities, you will still need a quoted-printable decoder to handle subjects that start with =?Q? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFML to clean up Word HTML
I searched riaforge.org and cflib.org for CFML to clean up Word HTML without affecting the way the HTML appears in modern browsers but could not find anything. Anyone ever written/used something like this? I use CFX_Markdown and SmartType to great effect. http://sebduggan.com/projects/cfxmarkdown Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC or UDF to rewrite the title tag of a document?
Actually you can go back and modify the content of the buffer... 1. In onRequestStart, set up a cfparam cfparam name=Request.HTMLPageTitle value= 2. Use this in the onRequestEnd function. Obviously you'll need to var the code where appropriate... cfif Request.HTMLPageTitle NEQ cfset currentBuffer = REReplaceNoCase(getPageContext().getOut().getBuffer().toString(), title[^\]*/title, ) cfhtmlhead text=title#request.HTMLPageTitle#/title cfcontent reset=truecfoutputcurrentbuffer/cfoutput /cfif 3. Create your changeTitle function and add the following code into it... cfset Request.HTMLPageTitle = arguments.HTMLPageTitle That should do it... Yours Paul Vernon http://www.newmediadevelopment.net t: 0871 425 4260 m: +44 (0)7887 952591 f: 0871 425 4261 e: mailto:paul.ver...@newmediadevelopment.net The information contained in this e-mail and any attachment is intended only for the named addressee(s). If you are not the named addressee(s), please notify the sender immediately and do not disclose, copy or distribute the contents to any other person other than the intended addressee(s). Andy Matthews wrote: To clarify, what I'm looking for is the ability to override the title tag before the rendered HTML is sent to the browser. That is not going to happen with a simple function, neither UDF or Component, in a normal flow of processing. CFML process sequentially from start to finish and can not go back and change output already put into the buffer for delivery to the web server and ultimately the client's browser. To do something like this you will either have to manually capture the output and then modify it as desired or intercept the output before delivery to the web server. The latter can be done with the OnRequest method of an Applicaiton.CFC or manipulating the underlining Java 'page' object. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Barclays ePDQ MPI Integration
I've never used BarclayCard to do this but have used many, many others... Do you have any URL's to documentation, or a specific problem you need to test for? I can certainly take a look for you... Paul Just Bumping and hopefully someone will have dealt with this... Heya Folks, Has anyone out there had any success in connecting via XML to BarclayCards ePDQ MPI? Having some troubles and would like some help . .. example code would be tremendous... Thank you in advance Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Odd Stack track in the runtime logs
I had a 503 error this morning that was out of the ordinary so I have gone through the logs to find the stack traces below. At the time the server had the error, it's a low load point in time and defrag starts at 03:30 before backups at 04:00. Overall, the server has a record of @1hr40mins downtime over 476 days so as you can imagine, it's not an everyday occurrence that I see things like this. CF 8 Std was installed in Sept/Oct 07 and looking through the SVN commit logs, although things some code has changed in the last few days I can't see anything that looks significant or relevant to the error that I'm seeing. It feels like a JVM/CF issue but I'm not sure where to check beyond the runtime logs. There are no logs in the runtime bin folder and the std CF logs show nothing. Server is W2k3 Std with 3Gb RAM. JVM is the Java6 that shipped with CF8. Min JVM heap size is set to 512Mb. Max 1024Mb. Being a production server, I'm waiting for the next allotted maintenance period to update to 8.0.1. If anyone can shed any light on these traces I'd appreciate it very much as Google etc return nada. (Paths have been changed to protect the innocent!) 25/04 03:18:00 error ERROR: unknown command 0 java.io.IOException: ERROR: unknown command 0 at jrun.servlet.jrpp.ProxyEndpoint.parseHeaders(ProxyEndpoint.java:943) at jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyEndpoint.java:297) at jrun.servlet.jrpp.JRunProxyService.swapRunnable(JRunProxyService.java:143) at jrunx.scheduler.ThreadPool$DownstreamMetrics.swapRunnable(ThreadPool.java:292) at jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunnable(ThreadPool.java:410) at jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRunnable(ThreadPool.java:252) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:76) 25/04 03:18:20 error Error while reading header VARIABLES.OBJECTFACTORY java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at java.io.BufferedInputStream.fill(BufferedInputStream.java:218) at java.io.BufferedInputStream.read1(BufferedInputStream.java:258) at java.io.BufferedInputStream.read(BufferedInputStream.java:317) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:581) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:573) at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpoint.java:591) at jrun.servlet.jrpp.ProxyEndpoint.readString(ProxyEndpoint.java:620) at jrun.servlet.jrpp.ProxyEndpoint.getHeader(ProxyEndpoint.java:762) at javax.servlet.http.HttpServletRequestWrapper.getHeader(HttpServletRequestWrapper.java:124) at javax.servlet.http.HttpServletRequestWrapper.getHeader(HttpServletRequestWrapper.java:124) at coldfusion.thread.HttpServletRequestWrapper.getHeader(HttpServletRequestWrapper.java:295) at coldfusion.runtime.CgiScope.resolve(CgiScope.java:216) at coldfusion.runtime.CgiScope.containsName(CgiScope.java:296) at coldfusion.runtime.CgiScope.search(CgiScope.java:329) at coldfusion.runtime.NeoPageContext.searchScopes(NeoPageContext.java:684) at coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:1642) at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1601) at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:1589) at cfbase2ecfc1483368667$funcFIREEVENT.runFunction(X:\mywwwroot\_cfc\net\newmediadev\base.cfc:542) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2460) at cfspider2ecfc443474148$funcINIT.runFunction(X:\mywwwroot\_cfc\net\newmediadev\util\spider.cfc:65) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at
CFFTP CF8.01 timeout and connection property bug/issues
Hi All, It's been a long time since I've had to use CFFTP (CF5) so I may well be missing something but I seem to have come across a couple of things one of which, I consider to be a bug. Firstly, the bug. I need to download a large (600Mb) file, if I set the timeout value to something like 5 seconds for my connection then the tag times out after 5 seconds rather than after 5 seconds of inactivity. There is a major difference here. If I set the timeout to 30 seconds, I get about 45Mb down before the tag times out. If I set the timeout to 300 seconds, I get about 450Mb down before the tag times out. If I set the timeout to something silly, say 12 seconds, the tag just hangs (I assume until the timeout is reached). (I know why this is). If I set the timeout to something more reasonable, say 900 seconds, the tag does not return until the 900 seconds are up and I get the file :-). CFFTP is hanging until timeout because of the config of the FTP server (something I cannot change as it's a 3rd party server). I've double checked the connection with standard FTP clients and they too hang at the end until their timeout is reached. The difference between CFFTP and other FTP clients is that other FTP clients can have timeouts of say 5 seconds and only timeout after the entire file has been downloaded. Ideally this is what CFFTP should do and I'd consider it to be a bug if it did otherwise which it does. Secondly, the annoying problem. The server I'm connecting to requires a PASV connection from where I am. Ideally, I would like set this on the first connection and have CF track this in the connection structure that is created. It isn't. Every CFFTP call I make, I have to set passive=Yes. Until I dumped out the connection structure, I couldn't figure out why I wasn't even able to list a set of directories after the initial connection as I'd assumed that passive being an attribute of the connection would be carried through in the connection struct. This is not so. Annoying, fixable but shouldn't be there. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303963 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: URLs being appended to query string
http://www.client.com/somePage.cfm?someParam=http://www.zlotow.biz/radi omari ana2/rawi/ayutuqi/ You aren't alone. We're seeing exactly the same and have been for a couple of months. Not sure what the purpose of it is. It could be F***wits trying to inject URLs into site content I guess to increase their back-links to game the Search Engines. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Transposed Dates - Second Request
With regards to the issue you describe, it certainly looks like a time zone issue that should be able to be sorted using a time zone offset being applied to the dates. Storing all dates relative to GMT is probably best. Having said all that, I would be concerned that you may have a more serious underlying date/time issue that you will need to test given that you are having time zone issues, it's worth testing this second scenario too... The SQL server in the US is most likely to have its date format as mm/dd/ and the CF server in Guernsey is most likely to have the date format of dd/mm/. The DB drivers can resolve this issue for dates over the 12th of the month 13/12/2008 and 12/13/2008 can only be one date but for dates up to the 12th of the month there can be issues... e.g. 07/12/2008 and 12/07/2008 could be two completely different dates or the same date depending on where you are in the world. To get around this second issue, you can either set your locales to the same *OR* do some sort of conversion before you send to the database or format the date in an unambiguous way e.g. dd/mmm/. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (BUMP) Possible to send smtp auth info in CF 4.5?
I've set up the new mail server in the CF Admin, but there's no place in 4.5 to add authentication, so I thought I'd do it in the tag. Is it possible? Yes, Use the pattern Username:[EMAIL PROTECTED] in the admin area where you put in your server name normally or do the same in the server attribute of the cfmail tag. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DNS solutions
You might like to look at http://www.everydns.net/ It's not free but it's close. They offer primary and secondary services with 4 geographically diverse DNS servers. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 Wins 2008 Jolt Awards!
http://www.drdobbs.com/blog/portal/archives/2008/03/jolt_award_winn.htm l --- Ben Oh, the marketing! Superb! Congrats to all at Adobe for the hard work :-) Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300666 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strange Error from SQL
Anyone seen an error like this before? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Unhandled token type: Unknown token: 0x30 The error occurred on line 154. It has been coming up on my server lately. It is usually followed by a few null null errors. Some times the token changes, but not often. I've also seen token: 0x0c Google had nothing on this. As far as I can tell this is a driver bug. In that the SQL Server response is unrecognised by the driver and the error is thrown. http://support.microsoft.com/kb/827969 What SQL drivers are you using? MS or the CF in built ones? Are they the latest, greatest versions? Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300340 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC protect from SQL Injection?
I know it's a bit late to join in on the conversation but, here goes... Firstly, to answer the original question, my experience is that type checking in functions kills a lot but not all injection attacks but cfqueryparam catches the more intricate injection attacks where the input is a string however I do believe that even cfqueryparam is not perfect. Where possible, if you can use a RegEx to validate the string based input data so that they fit the exact format you are wanting and couple it with type checking and cfqueryparam, you *should* be impervious but YMMV. The key here is look for good input rather than bad input. It's easier to define what is acceptable than second guess someone that is determined and skilled enough to invent an new form of injection just for you! The real issues with SQL injection these days fall under the banner term of blind sql injection (http://www.google.co.uk/search?q=blind+SQL+injection) and are particularly fun to play with. IMO, with automated tools like SQLiX being freely available that scan for easy SQL injection targets, it doesn't make sense to do anything but secure your code to the best of your ability with a good knowledge of your chosen language and make best use of the features it provides. Other things to do if you can is to check your logs. I see multiple SQL injection attempts every day on our servers. The clever ones try to cloak themselves to... e.g. including sp_password in a query instantly tells SQL Server not to log this query for security reasons. If that injection attempt is done via a post mechanism, it won't show up in the web server logs either... Fun! Here are a few links to the highlights of what Google turned up when looking into SQL Injection attacks and prevention thereof. http://www.nextgenss.com/papers/advanced_sql_injection.pdf http://www.nextgenss.com/papers/more_advanced_sql_injection.pdf http://www.webappsec.org/projects/articles/091007.shtml http://www.imperva.com/resources/adc/blind_sql_server_injection.html There are some other good articles on the rest of imperva's site but registration is required for most. http://www.imperva.com/resources/whitepapers.html Some SQL injection examples can be found here: http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/ Other slightly dark-side of the net links include: http://sla.ckers.org/forum/list.php?16 http://ha.ckers.org/ Amongst other things, this article documents detecting stored procedures and possible injections that will work in some cases. I don't see why some of these may work with CFQueryparam too... http://www.blackhat.com/presentations/bh-usa-04/bh-us-04-hotchkies/bh-us-04- hotchkies.pdf For those that are interested, I also found a nice XSS cheat sheet. http://ha.ckers.org/xss.html Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Source Fource Super Friends
-Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Friday, February 22, 2008 2:53 PM To: CF-Talk Subject: OT: MS Source Fource Super Friends Come on Adobe, we need action figures too! :) http://msdn.microsoft.com/events/hero/ Do you think they got Lego's or Lucasfilm's permission to use that look and those blah the fource slogans? Also, it says they are a fearsome four and then shows seven distinct characters including ones that look like Karate Kid and Mr Miagi... All topped off with a 60's Batman narrative... How many rip-offs can MS do on one page... Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Having a problem with XML auto-escaping HTML (even CDATA)
cfsavecontent variable=myXML ?xml version=1.0 encoding=UTF-8? car price$4,000/price adbody!CDATA[[Wow bWhat a deal!/b ulliblah/li/ulJust Wow!]]/adbody /car /cfsavecontent cfquery... INSERT INTO someTable(blah) VALUES(cfqueryparam cfsqltype=cf_sql_varchar value=#myXML#) /cfquery Shouldn't that be ![CDATA[ instead of !CDATA[[ ?? Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOLVED - Maintain client connections - not working in CF8 / SQL 2000
Also, the server is a production server that had an in situ upgrade from CF6 for CF8. It didn't do this until CF6 was installed... I assume you mean 8, in which case a lot 'under the hood' changed. Have you tried deleting and readding the DSN ? Tom, thanks for suggesting this. I've had a mad couple of weeks looking at this and a 5am finish this morning and I still hadn't tried the most obvious of actions. Suffice to say, it appears that the upgrade didn't go as smoothly as I thought it did, and having addressed the busiest DB DSN's, connection pooling now appears to be working as the event logs have settled down to only a few connections per minute (I still have some DSN's to re-create) rather than several per second. Thanks again Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Maintain client connections - not working in CF8 / SQL 2000
-Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, February 11, 2008 1:49 PM To: CF-Talk Subject: Re: Maintain client connections - not working in CF8 / SQL 2000 On Monday 11 Feb 2008, Paul Vernon wrote: notifications for the CF db user accounts. The rate is at least 1 successful DB connection every second... Nice busy site :-) Connection pooling will obviously slow things down, but I wouldn't expect it to kill the database, unless lots of your queries are long running... Quite a few busy sites in fact :-) This particular server hosts careers sites for a couple of major high street names in the UK :-). None of the queries are long running, I run SQL profiler on a regular basis to help with that and the majority of queries run in under 20ms. Also, the server is a production server that had an in situ upgrade from CF6 for CF8. It didn't do this until CF6 was installed... I assume you mean 8, in which case a lot 'under the hood' changed. Have you tried deleting and readding the DSN ? I did mean 8 and no, that didn't occur to me. I guess that would be a DOH! on my part. I'll give it a go with one of the busier sites and see what happens... Cheers Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Maintain client connections - not working in CF8 / SQL 2000
the SQL server is being made. It doesn't matter if I turn the setting on or off, the behaviour is the same which is a real bind as it's pushing the SQL server right up to its memory limit within 24 hours of a service restart. If opening and closing a connection causes a memory leak, your SQL server has bigger problems... Thanks for that. To be clear. The CF is opening a connection for every query that is being run. It looks distinctly like a JDBC issue but I have no idea why it should be ignoring the connection pooling settings. The event viewer is filling up with thousands of success audits and connection notifications for the CF db user accounts. The rate is at least 1 successful DB connection every second... Also, the server is a production server that had an in situ upgrade from CF6 for CF8. It didn't do this until CF6 was installed... Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Maintain client connections - not working in CF8 / SQL 2000
Guys, I have a really weird problem where the connection pooling doesn't seem to be working on our CF servers. For every query, a brand new connection to the SQL server is being made. It doesn't matter if I turn the setting on or off, the behaviour is the same which is a real bind as it's pushing the SQL server right up to its memory limit within 24 hours of a service restart. The CF install is completely standard and I'm using the standard JDBC drivers that ship with CF. All hotfixes are applied. I really need some pointers on this one as restarting SQL every 24 hours is turning into a real chore... TIA Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion Authority, Purchase Volumes
So I seriously don't understand why anyone would use debit cards or cash if credit is an option. The other point here is security and protection... It is just so much more secure to use a Credit card than a debit card or cash... Callbacks just don't happen unless you have a credit card or a special visa backed debit card which is a rare thing... Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298086 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: My latest Coldfusion Project for your Review
http://nobosh.com/ Please do not hesitate to contact me to discuss the site further. I look forward to everyone's review and the opportunity to discuss the future of the project. You have a typo. Is see Please Regiser here when I click on comments... Other than that, nice site, nice concept. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Duplicates in Arrays or Lists
Anyone have a function that runs that will remove duplicates from a list or array. My list will have over 15k items so I need it to run as fast as possible. If you are on a Windows box with CF, there is a free tag on our site which converts string lists into true linked lists and spits them back out de-duped but it is a CFX tag so you'd need to be able to install it on your server... It typically out-performs CF lists and array functions. The test results shown are for CF5. CFMX and upwards are still slower than CFX_dedupe but not by so much :-) http://store.newmediadevelopment.net/cfx_tag.cfm?ProductID=4 Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Email Verification Tool
Any thoughts or suggestions? http://store.newmediadevelopment.net/cfx_tag.cfm?ProductID=12 CFX_ValidEmail to validate an already gathered list of e-mail addresses without having to send them. Performs regex, MX and SMTP checks. Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Adobe go wish not working??
So I found a really minor (but annoying) bug in cfimage today... cfimage action=writeToBrowser source=#mypic# format=jpg alt=my alt text Generates img src=/CFFileServlet/_cf_image/_cfimg-5676754676200696121.jpg ALT=my alt text / Looks fine except for one thing. The tag is written using XHTML markup and as such, ALT should be alt to generate valid XHTML. Not a huge problem you'll agree but it's annoying when the client wants a standards compliant site... So I went off to http://www.adobe.com/go/wish/ and dutifully filled in the bug report only to be faced with a 404 error on submission... Any ideas if the go wish url I have is correct? Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFHTTP and Caching
However what can I use in Coldfusion to cache this CFHTTP request (every 2 hours)so that it does not request the RSS feed every time a user loads our webpage? Any ideas if this is possible ? We do this all the time, here are a couple of possibilities... Save the RSS feed to the DB or the application scope or somewhere reasonably persistent with a date of last retrieval associated with it. Then when x hours have elapsed get the data again. For the most part, you'll be using the DB or application scope to access the RSS feed... Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294760 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 MS-SQL Virtual Memory usage
Has anyone else noticed that SQL Server seems to be using significantly more virtual memory when CF8 connects to it as opposed to CF7 and CF6.1? We upgraded from 6.1 to 8 and the VM usage for SQL has tripled with no significant change in usage. One thing I have noticed however is that the logins to the DB seem to be more frequent leading me to believe Maintain DB connections isn't doing what it should as it is definitely checked. All this is backed up by the SQL server logs that have leapt from 3 or 4 Mb day to 60 to 80 Mb day detailing hundreds of successful logins. Is anyone else seeing similar issues? Paul ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF admin SQL connection strings
When CF connects to an MS SQL server, as part of the connection it sets the language and date format as follows: set language us_english set dateformat mdy Can I override these values in the Connection String and if so, how? I've been Googling for hours and found a few things to try but I've had no success. I want to set the defaults to British for the language and dmy for the dateformat but the profiler is still showing the details as above. An approximation of the connection string I've been testing with is as follows... jdbc:sqlserver://localhost:1433;databaseName=;user=;password=;La nguage=British;dateformat=dmy; I've tried Current Language as well to set the language but nothing seems to be having an effect. Is there something totally obvious that I'm getting completely wrong? This is the first time I've played with connection strings and it's not going too well... :( Paul ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Joystick/controller
I was wondering if anyone has any idea how to go about writing a program in ColdFusion that will enable a user to use a joystick to control an object on screen (for example pushing up on the joystick would move up an item in a list). I don't know if it is possible with ColdFusion (I think you can do it in .net). Thanks. ColdFusion being a server side scripting language I'd say that this is pretty much out of the question. The fact that you can do this in .net doesn't mean much as .net covers so much stuff. If you mean it can be done using Silverlight (a .net technology) then the equivalent technology you'd be looking at for an non-MS solution would be Flash. Other than that, what's javascript like at handing input from devices other than a mouse or keyboard? I have no idea but it strikes me that it may be able to do what you want. Paul ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Version Controll with IIS
I know many of you are running SubVersion for your version control on your Apache based servers, and to be honest I think its about time I got up and running with some proper source control, the number of Projects I have 'on the go' is growing and I need to tidy up my management a little bit before it start getting out of hand. You can run SVN as a service on its own rather than run it through a web server if you want. That's what we do because we only run Apache on the developers laptops. We run IIS on the server we use as the SVN repository because it doubles as the staging/testing before setting code live. Paul ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293073 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Weird CF8 web service wsdl generation issue and a leftfield fix
Having upgraded to CF8 pretty much as soon as it came out, I believe I've just run across a really obscure issue when consuming web services. We have a hr-xml based webservice that had been running fine for months on CFMX6.1. When we upgraded to CF8, everything remained fine and the service continued to work with those servers that used it. As it happens, those servers although not ours are also ColdFusion 6, 7 an 8. The issue arose when the CF servers that consume the service had their webservice caches cleared and slowly but surely, all the servers posting data to this service began to fail one by one. Obviously the guys that were looking at their servers posting debugged as much as they could at their end of things but no progress was made. I was testing the webservice using eclipse and everything was fine there too. Everything looked fine. Then I coded up a simple test to invoke the service and started to get the file not found issues which pointed to a case sensitivity issue. In the CFC, the cfcomponent declaration was as follows: cfcomponent name=hrxml displayname=hrxml output=false The filename is hrxml.cfc Depending on the url used to invoke the service, CF8 was generating different portType tags http:///svc/Hrxml.cfc?wsdl made the wsdl generate wsdl:portType name=hrxml http:///svc/hrxml.cfc?wsdl made the wsdl generate wsdl:portType name=HRXML http:///svc/HRXML.cfc?wsdl made the wsdl generate wsdl:portType name=Hrxml This seemingly random case generation ended up generating the file not found errors at the point of consumption stating that hrxml.java or HRXML.java or Hrxml.java could not be found. I double checked that all references to hrxml in the CFC were lower case which they were but it still didn't work. So, doing something totally leftfield, I removed the displayname attribute from the cfcomponent tag and up to now, it seems to be working reliably again but it was a pig of an issue to debug... Paul ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: changing style sheets
Is there a way to allow the user to change the style sheet of a page using a link on the page? There are plenty of ways to do this. http://www.the-eyesite.org/ does this with several stylesheets by keeping the stylesheet in the session and then populating the header accordingly. Paul ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Submit button is adding more documents! Help!
Wow, old code... Before I even attempt to answer the question. What version of ColdFusion are you running this on? The reasons I ask are as follows: ParameterExists has been deprecated since version 4/4.5 or thereabouts. - use isDefined or even better, StructKeyExists instead. Code like this: cfif #endnum# GT #count#cfset endnum = #count#/cfif Can and should be written like this cfif endnum GT count cfset endnum = count /cfif and cfset count=#count#+1 Should read at least as cfset count = count + 1 and if you have CF8 you could use the new ++ operator :-) Now onto answering your question... It appears the critical part of your code is missing from your post. I cannot see the cfquery that actually retrieves the documents from the database cfquery name=getDocs ... Without seeing that (which is most likely where the logic error is), it's almost impossible to answer this question. Yours Paul ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292127 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFML engine compatibility - a possible solution?
I've just started a bit of a spat on the BD list about CFML syntax compatibility and consistency... for instance how there are at least 3 different implementations of CFTHREAD (CF7 POC, CF8 and BD7). Anyway as I was replying it occured to me that life and support for developing CFML based code that ran safely and reliably on all CFML engines would be much easier if we had the equivalent of compiler directives for CFML engines... Comments welcome :-) Paul ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFML engine compatibility - a possible solution?
Anyway as I was replying it occured to me that life and support for developing CFML based code that ran safely and reliably on all CFML engines would be much easier if we had the equivalent of compiler directives for CFML engines... It would be easier to standardize all the CFML engines to behave the same way than it would be to standardize them all to behave differently (that is, recognize compiler directives). But that is the point I originally raised on the BD list... At the moment I'm getting a hiding for it! For me though looking at other languages that are in a similar position, compiler directives seem to work very well indeed... Delphi and FreePascal for instance are both basically object pascal and with judicious use of compiler directives the same source code can compile on both platforms. Seeing as CF for the most part is now compiled (to a point), it makes sense that compiler directives would work given the already fractured state of the development of the CFML language itself. Paul ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DEATH to HOMESITE
F*cking HomeSite+ wiped out my file on the server (AGAIN). I do a file write, it hangs, and I have to kill HomeSite. When I start homesite again, guess what, the file is gone from the server. Source control, Source control, Source control or to put it more concisely, SVN, SVN, SVN! There are some great Subversion plugins for CFEclipse :-) Subclipse is the one I believe most of the CFEclipse users use... Paul ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Web Service Help
cfinvoke webservice = http://www.devcallnow.com/WebService/OneCallNow.asmx?wsdl; method = LOGIN returnvariable = Token cfinvokeargument name=service value=1/ cfinvokeargument name=groupkey value=11/ cfinvokeargument name=pin value=/ /cfinvoke Not sure why you posted twice with different subjects but the issue may well be case Sensitivity. Should it be Login? Also, it seems that the Login function may require the LoginToken even though it might well be optional... Seems odd that LoginToken is even specified as an argument to the Login function. Paul ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web Service Help
I tried it with all case and I tried with the token being an argument as well. Still nothing. If I run the following code as is, I get a huge Java object being returned that seems to indicate that I have got incorrect details in the login post but I don't get a method not found error. You code as it was does generate the method not found error. cftry cfinvoke webservice =http://www.devcallnow.com/WebService/OneCallNow.asmx?wsdl; method=Login returnvariable=Token cfinvokeargument name=Service value=1/ cfinvokeargument name=GroupKey value=11/ cfinvokeargument name=PIN value=/ cfinvokeargument name=LoginToken value=/ /cfinvoke cfdump var=#Token# cfcatch cfdump var=#cfcatch# /cfcatch /cftry Paul ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: File disappears after cffile rename
cflock name=#CreateUUID()# type=exclusive timeout=30 throwontimeout=no cfset PAGE_clean_SERVERFILE = replace(cffile.SERVERFILE, , _, all) cffile action=RENAME source=cffile.SERVERFILE# destination=#PAGE_clean_SERVERFILE# /cflock Firstly, the CFLOCK as you have it is pointless. Using a CreateUUID() function to name a lock simply creates a lock that is uniquely named and offers no protection to the code running inside. Your mileage may vary if you call the lock name fileUpload or if you need more granularity, #cffile.serverfile#. Next, I'm not sure if the code you've entered is a copy paste or a retype (I'm assuming a re-type) because you have an error in the cffile tag call. Source should have a # before the cffile. Thirdly, it would help if we could see your CFFILE action=upload call that actually uploads the file to your server so we can determine what the filename is going to be, eg as you uploaded it or, uniquely renamed by CF as part of the upload process. Paul ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web Service Help
Following up from my previous response, if I change the cfdump in my example code to this cfdump var=#Token.getValue()# I get the response LoginFailedInvalidGroupOrPin So I guess it is working fine here... CF8 Developer on Vista w/Apache. Paul ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291440 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web Service Help
16:36:48.048 - java.lang.StringIndexOutOfBoundsException - in C:\CFusionMX7\wwwroot\Saul\a.cfm : line 29 String index out of range: 0 --- - -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Thursday, October 18, 2007 1:35 PM To: CF-Talk Subject: RE: Web Service Help Following up from my previous response, if I change the cfdump in my example code to this cfdump var=#Token.getValue()# I get the response LoginFailedInvalidGroupOrPin So I guess it is working fine here... CF8 Developer on Vista w/Apache. Paul ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Web Service HELL - SOLVED
Just to follow up on this, it seems that the webservice David was trying to consume using wsdl doesn't fit into the wsdl way of doing things in that it attempts to set one of the invoking arguments and pass that back as well as a complex object. To get around this, I've told him to invoke the service using cfhttp instead of cfinvoke and parse the resulting XML to get the data he needs... cfsavecontent variable=xmlrequestsoap:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/; soap:Body Login xmlns=https://www.onecallnow.com/WebService/; Service1/Service GroupKey111/GroupKey Pin/Pin LoginToken/LoginToken /Login /soap:Body /soap:Envelope /cfsavecontent cfhttp method=post url=http://www.devcallnow.com/WebService/OneCallNow.asmx; cfhttpparam type=xml value=#xmlrequest# /cfhttp cfset SOAPXML = XMLParse(cfhttp.Filecontent.toString()) cfset response = XMLParse(toString(SOAPXML[soap:Envelope][soap:Body][XmlChildren][1])) cfdump var=#response# cfoutput#response.LoginResponse.LoginToken#/cfoutput Paul ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291513 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IsXML returning false for data that XMLParse will accept
If I am not mistaken the XMLParse function takes a string and converts it into an XML Object therefore I believe that if you use the XMLParse function on your string and then do the isXML it will pass muster. That somewhat negates the point of IsXML as I understand it. If you notice you are running the XMLParse function first in your older code but have left it out in your newer code. Yes, that's because in CFMX 6.1 the only way I can tell if the string is XML is to parse it. The whole point of IsXML as I read the docs is so that I don't have the overhead of actually having to parse the string to tell whether or not it is valid XML therefore reducing the overheads in the code. At the point where my code is running, I only need to know whether the string is Valid XML or not so I can store choose to store it in the DB or not. IsXML is supposed to be a lightweight way of doing this but it seems to be inconsistent with the results of XMLParse. Paul ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DNS not specific to ColdFusion
Simple question hard to Google. Where does one configure ones systems so that users do not have to provide the sub-domain in their urls? I.E myDomain.com rather then www.myDomain.com. You set up an A-record in your DNS server so that it points to the IP address of your site. Then, if you are using host headers on your web server, you set up the relevant host-header to respond to that domain name by either serving a page or redirecting it to www.yourdomain.com. Paul ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291355 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
