[cfaussie] Hosting Facility Opportunity, equipment and premises for sale.
Hello, I hope this is not too far off list guidelines. Due to ill health (Motor Neurone Disease) Kym Kovan, founder term list member and internet/ICT pioneer in Australia (early Bulletin Board supplier and founder of one of the earliest speciality internet hosting companies and ColdFusion/cfml stalwart) is selling the properties that have housed our boutique datacentre and offices for the last 15 years and also all of the equipment contained within (routers, servers, etc., including the 3 tower servers that made up the world's first ColdFusion cluster, we have only just turned them off). Located in Hurlstone Park (Inner West of Sydney) within 100 metres of the railway station (15-20 minutes to the CBD) and in a small but vibrant local community with a Post Office and Cafes and shops seconds away. The main property has a dedicated server room with Fibre connected via Telstra, fully networked office and dual air-conditioners, facilities include 30KVA UPS and 3-phase power. This could be your business's ideal location. Its will be a sad day when we finally leave but her retirement and enjoyment of what time remains for her is more important than hanging on in these properties. We hope that some of you may be interested in this opportunity to own a fantastic setup for an Internet/ICT business with the hard work done. If you are interested in the purchase of such a valuable kick start or upgrade for your business please get in touch with our agents or just wish to offer your best wishes for a successful sale and a happy and prolonged retirement for Kym in greener and quieter pastures on the Mid North Coast we would love to hear from you and can supply further details and pictures of our boutique datacentre. http://www.onthehouse.com.au/buy/property/51566485?PageNr=1 -- *Fiona J Austen *| *CEO* */mort bay communications pty ltd /* /Bespoke Hosting and Internet Systems Specialists/ *website :* mbcomms.net.au http://mbcomms.net.au *e-mail :* t...@mbcomms.net.au mailto:t...@mbcomms.net.au *phone :* +61.2 9559 2629 www.mbcomms.net.au http://mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
[cfaussie] Phil Gray
Hello everyone, particularly Sydneysiders and old hands at this cfml game. I have to report that Phil Gray has just passed away after a long battle with cancer. He was a founding member of the Sydney CFUG and always turned up at meetings even though he lived in the Blue Mountains, a couple of hours away. He was a great mentor to me and a gentle man, he will be missed by many. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] [ANN SYD] Tonight: Open Source CMSs powered by cfml
On 31/01/2012 10:12, Barry Beattie wrote: so, Kym, how did it go? For us not in Sydney, you've whet our appetites. What were the CMS's and what's the conclusion? On Tue, Jan 31, 2012 at 9:04 AM, Mark Mandel mark.man...@gmail.com mailto:mark.man...@gmail.com wrote: Sounds like a great session for CFMeetup! :) URL here: http://www.cfmlug.org/content.cfm/Presentations/FOSS+cfml+CMSs Main conclusion: One hour is not enuf time to even get close to describing them. I had got 8 CMSs running and am only going to bother to fix one of the dead ones, as that is CFWheels based so in the interesting category. I glossed over them all, you really need two hours for that sort of presentation. I am happy to add to the presentation as it is on the website, fill in gaps, etc., so if anyone wants to add anything I will be happy to give them a login so they can add bits. The cflmug site is in a CMS so its not hard! :-) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Attribute validation error for tag cfoutput
When I see these sorts of issues I restart CF and they magically vanish :-) On 31/01/2012 15:00, Scott Thornton wrote: G'day, A strange problem just cropped up in one of my live systems ( CF 9 ). This page works on a CFMX6.1 server ( against a different database ). The page works when I run it locally ( cf 9 against the same datbase ) When I look at the debug output for the page, I can see that the query BBERA_OK works, but does not return any rows which is fine Essentially the code reads cfquery name=BBERA_OK datasource=#DSN# select a bunch of stuff from a lot of tables /cfquery cfoutput query=BBERA_OK ( on line 111 ) do stuff /cfoutput -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] [ANN SYD] Tonight: Open Source CMSs powered by cfml
On 30/01/2012 10:57, Brett Payne-Rhodes wrote: Hi Chris, Any chance this might be recorded and/or streamed? the gist of it will be on the web. (It's there now but it might get changed as the day goes on :-) I broke one of them yesterday and it won't come back) The count is down to 8 working and 4 dead... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] [ANN SYD] Tonight: Open Source CMSs powered by cfml
On 30/01/2012 13:39, Brett Payne-Rhodes wrote: Thanks Kym, Can you tell us the URL? not yet, no-one would turn up tonight! :-) No, or course they will, they don't want to miss my line of patter. Who else can turn a one hour presentation into two hours of chat! In reality the web pages are a general chat about all of them, how and why I chose them and the individual CMSs are roughly described. I will be playing with them a lot more and filling in the detail for each one, and getting the dead ones going if they are worth it. URL tomorrow... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CF9 SQL Server on Amazon Web Servers
Hi Steven, you don't mention what OS you are running but in general with 64bit machines it is good to double the old 32 bit recommendations as a first pass in server tuning. For 2008 R2 the OS takes a gig or more with its trick memory free space caching and its a good starting point with CF to set Max Perm at 512MB and Max Heap at 2048MB so you need at least 3GB allocated to your VM. As soon as the sites get busy you will have to up those numbers. If you have CF Enterprise then turn _off_ the server memory monitoring as it won't let you go above 2GB Heap and you will want to. It will force a GC when you don't want one. Our busy ordinary servers run with 5GB RAM, 3GB Max Heap and with the OS free space caching they run with about 100MB of real free memory space, and run fast... With a stored proc running for 300 seconds I would also be looking at how the DB server is configured, that is a lonnng proc. HTH Kym K On 27/01/2012 10:21 PM, Stephen M wrote: We recently moved one of our CF projects to Amazon Web Servers and have started to get the 500 internal server error. This happens regularly when we run a stored proc with does a lot of DB processing. It often takes more than 300 seconds. I've set all the CF timeouts to 300 secs so why don't I at least get a CF exception that I can handle? This app previously ran on CF7 and it never produced the 500 error. If it timed out then we got a CF timeout that I could handle with code. But that was a local pair of VM servers. We also get this problem on our UAT environment which is local (a pair of VM servers in our building), so I shouldn't be blaming Amazon. This is a fairly new CF install. I had originally left the JVM heap and Garbage collection settings at default. Do they typically require modifications when installing on 64 bit systems? I've just changed the UAT server to JVM heap min max of 1024MB but it hasn't helped. I have set production at 512 and 768. There's not a lot of CF processing going on. It just displays the query result in a table. And we rarely have more than 3 or 4 users at a time. But these errors are occuring when I know that I am the only user. So there's one stored proc being called and CF is just sitting there waiting. Often the error will occur, then I hit refresh and bang, the query result displays perfectly. Hmmm, that final cfloop to display the table is pretty big but it hasn't been a problem in the past. I have looked at all those JVM heap and GC settings in the past for an app that does have lots of users and does a lot of CF processing and it certainly helped but I really don't think that CF is the problem here. There just aren't that many users and not a lot of processing. Anyway, we're running out of ideas, I'll listen to anything to do with 500 internal server error regards, Stephen -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] ColdFusion Hosting Solutions in AU
On 24/01/2012 14:40, Dale Fraser wrote: I wonder how many Australian companies even still have their servers in Australia. Global Switch, Sydney -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Unused Files
Hi Dale, how dynamic is the site? A modified sitemap tool might work for most of that if things are fairly static. Walk through the site building a huge map of all links and then see what you have that is not on the list. On 21/12/2011 9:34 PM, Dale Fraser wrote: I’m looking for something that I can run that will tell me the following, I appreciate its getting harder down the list, but covering any of these points would be good 1.Unused cfm / cfc 2.Unused assets images etc 3.Methods Not called in cfc 4.Variables not used within methods The reason is we have a big legacy application that we are looking to move into the cloud, and I’d ideally only like to move things that are being used. Regards Dale Fraser -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Session Sharing on Cloud Cluster
Hi Dale, what's the code like? One option is to not use the session scope and go to client vars. No issue then... :-) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Session Sharing on Cloud Cluster
On 20/12/2011 11:10, Dale Fraser wrote: Yeah, I considered that too, I'll have to search the code base and see how widely we use them or do the client session trick. Copy to client scope to session in OnRequestStart and back in OnRequestEnd, serialized as needed... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] RIP Steve Jobs
http://www.apple.com/ -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: installing CF7 on Win7 with IIS 7.5
Picking up on one part of Andrew's post On 18/08/2011 10:36, Andrew Scott wrote in part: As for the Admin being accessible, I could argue that one still needs to apply the normal security measures on that anyway, especially if you require the Ajax and new UI features of the likes of cfGrid etc. We have a dedicated website on each server which had very restricted access so that the full CFIDE admin area is well protected. We make a copy of the CFIDE folder that has just the essential parts to make ajax and scripting, etc., work (IE at the minimum take out the /administrator/ folder) and then make that available as a /CFIDE virtual directory for each site. Then all of the exotic CF tags work and there is a much lesser security risk. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: CFBuilder2 and Version Control
On 15/07/2011 17:30, Rawdyn wrote: Thanks everyone, great info. ... I'm pretty happy working from a command line so I might look into GIT a bit more. I understood it wasn't brilliant in a Windows environment (based on what I have been told only) so I'll re-investigate that. We moved from Subversion to Mercurial as we are a Windows shop and git was fairly pathetic with its GUI tools (that was a while back though). Both work well with Eclipse but we prefer to use TortoiseHg for our version control GUI rather than work from within Eclipse. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Pop up text
On 16/05/2011 11:19, Brian Knott wrote: Guys just a quick HTML / CSS question. I want to have some text pop up when I roll over some words. I can create a div and turn the display on/off with the onMouseOver function. The issue is that I want to have some HTML with an unordered list. Presently the pop up text is moving all the other text down when it appears. I want the new pop up text to display over the top of the current page. It’s just like a more info box hat should pop up on the screen. Anyone seems some good examples of this. if you are using jQuery then Impromptu is very good as a dialog box-style thing: http://trentrichardson.com/Impromptu/index.php if that is over the top then maybe along the lines of ImagePreview: http://james.padolsey.com/demos/imgPreview/full/ we use both with great success -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Passing attributescollection into cfimport tag libraries
On 22/03/2011 13:33, Steve Onnis wrote: Is there a way to pass a collection into a cfimport tag library tag item? For example cfimport taglib=”lib” prefix=”utils” / utils:foo attributescollection=”#someStruct#” / I have tried this but it doesn’t seem to work its singular and without the quotes: attributecollection=#someStruct# In testing that I just found out that it is super fussy about quotes and hashes. attributecollection=#someStruct# fails and attributecollection=someStruct fails that is weird... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Passing attributescollection into cfimport tag libraries
On 22/03/2011 14:36, Glen Dunlop wrote: I actually use quotes and it works for me. which is what you would expect. I admit to being surprised when it errored but it did. I'm a bit old-fashionedy and like to do this when building structures as I find it more readable and maintainable: cfset theGalleries = application[Site_#thesubSiteID#].Galleries / so I expected the #blah# to work for the attributes but it definitely errored. and I just tried it again. Dependent on context maybe? One to watch out for... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Extending Application.cfc
On 16/03/2011 09:57, Gavin Beau Baumanis wrote: So I thought I would ask for the normal use-cases that an Application.cfc gets extended - in the hope I might be able to recall why we did it in the first place. (Of course I'll document on our internal Wiki - once I know!!) A good example might be an admin area of a site that needs some extra security bits on top of whatever functionality you have in App.cfc. You extend the app cfc and drop your extra code in. In olden times you might have used an include file for the common code. Of course you can also bump into the horrors of extending into different folders and have to use proxies, etc but that is another story :-) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Extending Application.cfc
On 16/03/2011 10:27, Gavin Beau Baumanis wrote: But I know we did it for some reason. I just can't remember what it was! At this point I could make a comment about comments, but I won't :-) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Windows 7 CFEclipse / CFBuilder maxed out TCP connections
Hi Barry, Win7 on its own has a partial limit of 16K connections but is normally limited by memory rather than limit. There is this limit we bumped into trying to get some 2008 R2 servers talking to a NAS with NFS: http://support.microsoft.com/kb/977517 Just 16 connections per IP! Not quite the same thing but it makes me think that the limit might be on the NFS side of things, not Win7 per se or Eclipse... HTH Kym On 16/03/2011 14:18, BarryC wrote: Hi, I have my files on a mapped network drive (NFS in my case), I'm running windows 7 enterprise and am having problems with CFEclipse hanging (CFBuilder does exactly the same thing) when opening lots of files ( 10) or refreshing folders. If I look at the resource monitor, I can see the TCP connections have maxed out to 200, and I see stuck cfeclipse threads which are waiting for TCP recponses. I'm only assuming it's 200 max TCP connections because I haven't seen it go higher (and that's the number where eclipse hangs). ... Are there any known issues with Windows 7 / eclipse to do with network connections? I've had a decent look around and I can't find anything that has worked or been helpful. Regards Barry -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Anyone able to troubleshoot CF9 / Win2008 / IIS7 for some pocket money?
I would surmise that you have some sort of feedback loop happening. A recursive tag that lost the plot maybe? Have you tried looking at memory usage as the code normally runs? Kym K On 23/02/2011 10:57, Taco Fleur wrote: Hello Carl, thanks for that. I've been looking in the logs around the time of the cf server becoming unresponsive and found the following. Today the server became unresponsive around 2011-02-23 07:03:00 am In the C:\ColdFusion9\runtime\logs\coldfusion-event.log I found 23/02 07:28:24 error ROOT CAUSE: java.lang.OutOfMemoryError: Java heap space /But note, this is 20 minutes after the server became unresponsive./ Yesterday the server became unresponsive around 2011-02-22 03:00:00 pm In the C:\ColdFusion9\runtime\logs\coldfusion-event.log I found the following entries (hundreds of them one after the other) 22/02 15:20:56 error [1]java.lang.InterruptedException /Again, 20 minutes after it became unresponsive./ Also note that I have 8gig of memory, 4 is reserved for MS SQL and the rest is available. What's next? Thanks in advance.. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Anyone able to troubleshoot CF9 / Win2008 / IIS7 for some pocket money?
On 23/02/2011 11:12, Taco Fleur wrote: You would think that, but let's not forget that this has all been running for more than several months without changes on a Windows 2003/IIS6/CF8 machine. and CF9 is subtly different. I think a look at memory usage is in order as if it is running out of heap 20 minutes after it stops there is something going on. Watch the memory tracking in the server monitor in CF admin and maybe you can get a clue. An infinite loop I can debug, but this is out of my league. I can relate :-) Kym K On Wed, Feb 23, 2011 at 10:03 AM, Kym Kovan dev-li...@mbcomms.net.au mailto:dev-li...@mbcomms.net.au wrote: I would surmise that you have some sort of feedback loop happening. A recursive tag that lost the plot maybe? Have you tried looking at memory usage as the code normally runs? Kym K On 23/02/2011 10:57, Taco Fleur wrote: Hello Carl, thanks for that. I've been looking in the logs around the time of the cf server becoming unresponsive and found the following. Today the server became unresponsive around 2011-02-23 07:03:00 am In the C:\ColdFusion9\runtime\logs\coldfusion-event.log I found 23/02 07:28:24 error ROOT CAUSE: java.lang.OutOfMemoryError: Java heap space /But note, this is 20 minutes after the server became unresponsive./ Yesterday the server became unresponsive around 2011-02-22 03:00:00 pm In the C:\ColdFusion9\runtime\logs\coldfusion-event.log I found the following entries (hundreds of them one after the other) 22/02 15:20:56 error [1]java.lang.InterruptedException /Again, 20 minutes after it became unresponsive./ Also note that I have 8gig of memory, 4 is reserved for MS SQL and the rest is available. What's next? Thanks in advance.. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Anyone able to troubleshoot CF9 / Win2008 / IIS7 for some pocket money?
On 23/02/2011 12:31, Taco Fleur wrote: Thanks for that. Is this to set the minimum to 512 and max to 1024? If so, I actually started out with that and changed it back to 128 / 512 Just enabled server monitoring and server became unresponsive :-) Let's see if the log tells me anything. This is a 64 bit box isn't it? Double those numbers. we use 1024min and 2048max, or higher depending on server role. Sorry I should have checked the original post properly, 64bit machines use twice as much ram funnily enuf. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] IIS7 CF9 CFLOCATION problems?
On 21/02/2011 11:46, www.clickfind.com.au wrote: Does anyone have CF9 running on IIS7 Windows 2008 64bit? yes. I'm having major weird problems. I have to admit a bit of I've never tried this but does OnRequestEnd fire when you do a cflocation type redirect? It looks as though it's got to do with cflocation/redirecting. After a redirect it seems to just execute the application.cfc and not the calling template The error occurred in C:\inetpub\wwwroot\production\au_com_clickfind \Application.cfc: line 760 Called from C:\inetpub\wwwroot\production\au_com_clickfind \Application.cfc: line 758 Called from C:\inetpub\wwwroot\production\au_com_clickfind \Application.cfc: line 721 Called from C:\inetpub\wwwroot\production\au_com_clickfind \Application.cfc: line 711 The above lines are where the onRequestEnd method is located. My templates set a header file which is then included in the onRequestend of application.cfc, but that's not set as the calling template does not seem to be executed. However. If I dump the CGI variables I see the CF_TEMPLATE_PATHC:\inetpub\wwwroot\production\au_com_clickfind\sign- in.cfm Any help, insight, ideas appreciated... PS. is there a new list now that is used as this one seems to have died down a bit! tongue in cheek We are all still here, we are just so good that we don't need to chat much :-) /tongue in cheek -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] IIS7 Verify if file exists | Don't want to log files in CF application.log
On 20/02/2011 21:43, www.clickfind.com.au wrote: I am using a custom CF 404 handler to do some stuff to make the URL look nice. I know there are better ways to do it, for now that is not an option. The problem is that CF logs a 404 in the application.log which it has never done before. I'm guessing it has something to do with the option Verify if file exists that used to be present in IIS6, I can't find it anymore. it changed its name. its still in the mappings bit but is now Request Permissions or some such. You can select File Only and then it does much the same as before. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Brisbane Data Centres
On 14/01/2011 12:31, Chris Velevitch wrote: From the point of disaster planning and recovery, where in Brisbane are all the data centres and did any of them get effected? They are scattered and on high ground and only one was affected, the old AAPT Riverside DC near the river which they are in the process of closing anyway. Most of the main DCs went to diesel just in case as power loss was the main concern. I have been following the chat on AUSNOG, the List for the network operators of the 'net in this part of the world. A few issues with cables going dead but alternate routes handling it, etc. No major outages at all. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Brisbane Data Centres
On 14/01/2011 13:12, Chris Velevitch wrote: What about corporates who have/had data centres in the Brisbane CBD, how did they fair? I have no knowledge. I have only been checking from an Internet perspective. SunCorp and folk like that are up on the ridge in the CBD so presumably won't be worried. The small businesses in some of those industrial areas are a whole different mess... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CF9 Administrator Schedule Tasks
On 5/01/2011 3:38 PM, rai...@ozemail.com.au wrote: Hi I am starting to use the schedule task feature in cf9 however I find it is still a little limited in functionality The frequency options are limited to daily, weekly, monthly There is no provision for activities to be scheduled... When you think about you have to allow for every time/date combination under the sun, there are just too many options. One example we bump into regularly is scheduling backup tasks that run say every 1st Sunday, 2nd Sunday, etc. What about the 5th Sunday? They pop up every so often and I haven't seen a tool yet that handles that. So have a task script that runs every day or even more often than that and put time/date decoding logic in that to run the actual task you want done, directly, as a cfthread or an http call, whatever is appropriate. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Microsoft SQL server CPU very high, close to 100% a lot of the time
On 25/11/2010 12:59, Pat wrote: Good clarifications Kai. Always nice to cut through some of the marketing spin. Carl, swapping out your JDBC drivers would be a fairly small amount of effort to see if it gives you any performance improvements. Are we drifting off-track? The OP complaint was 100% CPU, network performance has only a minor effect here. I'd say the two we don't have a problem replies out vote the single VMs are no good reply so try the more CPU route first. If the host is grunty then build a new VM with more than a single vCPU and install SQL2008 on that and see what you get. (It depends on your OS licensing but we find it convenient to keep 1, 2, and 4 vCPU templates sitting there so you can get a new machine up in a few minutes then throw your applications on.) If the host is not very grunty then assess what you have got, just the one VM maybe?, etc. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Microsoft SQL server CPU very high, close to 100% a lot of the time
On 24/11/2010 09:53, Kai Koenig wrote: What Steve says is def. contributing to it. Another thing I'd look into before moving it away from VMWare though would be the VMWare setup itself, e.g. assigned memory, giving it more CPU power etc. How's your disk IO looking on that VM? We use SQL2008 on win2008 R2 on VMs with no issues at all. 500 or 600 transactions per sec on a single server. Definitely set the vCPU count to 2 or more and scads of RAM, ie dedicate a third or a half of your host to the DB server. Our rule-of-thumb is 3 big-end DB servers per host or 20 CF9 servers :-) These are dual quad core hosts so give your SQL server the equivalent of two or more cores but the critical thing is 2 or more vCPUs so SQL can split its threads more efficiently as if it thinks it has only one CPU it changes mode internally. Check your writing rate, if there is a lot then the temp db and the transaction log are getting written to a _lot_, we see several MBps on peaks and then things like your network speed into the SAN infrastructure start affecting things. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CFObjective
On 15/11/2010 08:47, Barry Beattie wrote: not only casual, but people take pride in dragging out their oldest product T-shirt (eg: Allaire CF) and wearing it with pride. I think Darren Tracey (Suncorp, CF.O organising committee member) has an excellent collection of such T-shirts. It'll be interesting to see what he drags out from mothballing... ... and interesting to see if anyone can beat him with something rarer... Hmm, is it a rule that you to wear it? I have some seriously vintage stuff, but I can't fit in them anymore :-( (they are from the days when the give-away Tee shirts actually had sizes smaller than the L which seems the minimum these days :-) ) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] OT: a couple of questions for my travel there in coming weeks
On 9/11/2010 09:03, charlie arehart wrote: Thanks everyone for all the great ideas. Those are really awesome. I’ll weigh them and look forward to hearing more from those who proposed having more to share. See you in a couple of weeks. :-) Someone mentioned Strahan. Here's one more to combine a bit of nature and some interesting engineering and that is the West Coast Wilderness Railway that runs from Strahan to Queenstown. Something there to keep anyone interested. 42° 9'37.91S 145°19'36.21E http://www.westcoastwildernessrailway.com.au/ -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Sessions problem with IE8
On 25/10/2010 15:41, KNOTT, Brian wrote: That would be great. Thanks Kym and the reply was mainly unprintable about Microsoft :-) Its all to do with click-jacking and the IE8 security now does not allow X-site stuff on almost anything so legit frameset stuff is no longer. Apparently the clubsonline stuff does not use sessions very much so they worked around it until they had time to fix. Guess who just got volunteered to sort it out! :-) http://blogs.msdn.com/b/ieinternals/archive/2010/03/30/combating-clickjacking-with-x-frame-options.aspx and http://blogs.msdn.com/b/ie/archive/2009/01/27/ie8-security-part-vii-clickjacking-defenses.aspx -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Sessions problem with IE8
On 26/10/2010 12:47, KNOTT, Brian wrote: Found a way to fix this. If I pass the CFID and CFTOKEN on the URL then it is able to keep the session variables. form name=testform action=page2.cfm?CFID=#CFIF#CFTOKEN=#CFTOKEN# method=post I did think these parameters where pass on the URL anyway, but not from inside this framset. Good timing! I was about to post to the List the way top handle it, which I should have remembered yesterday, oh well. This is what URLSessionFormat() is for. Wrap your form post url in it and problem solved -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Sessions problem with IE8
Hi Brian, you wrote: Guys, Got a session issue with IE 8 but only when its inside a frame set. The customer wants to put the site in a vanity URL. Its just a frame at 100% from there site. With IE8 it does not seem to retain session variables from page to page. I can set some session variables on the first page and then then use a form to move to the second page. On the second page the session variables no longer exist. Outside the frameset the site works fine. The site also work fine in firefox , in both the framed and unframed site. It must be a set up in IE8, maybe too secure or something. Try this url as its the exact same frameset idea: http://www.australiancrawlswimmingclub.org.au/ we have hundreds of these little template sites, all work fine. So if your IE8 does not work look at that end. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Sessions problem with IE8
On 25/10/2010 14:07, KNOTT, Brian wrote: Is there a way around this? There must be as it doesn't happen on the clubsonline sites. I will check with their developers and see what they did. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: FW: [coldfusion-howto] [cfaussie] CFExchange and CF9
Hi Claude, Is there are firewall or anything in the way? If you can send emails from CF that just means the port 25 is connecting. the Exchange stuff works on different ports, IMAP, etc... On 20/10/2010 18:20, rai...@ozemail.com.au wrote: Hi, I am resending this post in the hope of receiving some assistance / advise on a dilemma that I am still yet to find a solution. I have started working with the Microsoft exchange integration with CF9 however I receive the following error message Exchange service is not available on 192.168.0.1. cfexchangeConnection action=open username=myusername password=mypassword/ server=192.168.0.1 connection=testconn1 MS exchange is running on 192.168.0.1 and works as I am able to send emails from within cf successfully with 192.168.0.1 setup in cf admin as the ip address for the exchange server. Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:info%40SAMARIS.net mailto:i...@trackingcentral.om.au mailto:info%40TrackingCentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] JSON/REST
On 15/09/2010 08:55, KNOTT, Brian wrote: Hi Guys, Been asked if I can create expose part of a web site through the JSON/REST technology instead on XML. Has anyone done this with CF, is it even possible. JSON and REST are two separate things, JSON being commonly used to pass data to clients like browsers, CF does that well. REST is a way of talking to servers using simple HTTP commands so CF does that as well! :-) Google on: REST with coldfusion cfml -rest of lots of good hits... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Coldfusion FCK Editor
On 12/08/2010 12:26, Steve Onnis wrote: Does anyone now if you can configure the built FCK Editor to do image uploading? I cant seem to get the browse server button to enable Steve Adding to what Mike just wrote its turned off by default as it is a security risk, there was a patch came out a while back. The actual flag is in the browser code section in the fckeditor install area. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Odd date behaviour - CF9/SQLServer2005
On 9/06/2010 14:02, Mike Kear wrote: If i set a variable which is a date object using the createdate() function, it reads the date properly. If I use that same function to set a setter in a bean, it doesnt. Here's the specifics: cfset testdate = createdate(2010,06,10) pDay: #day(testdate)#br / Month:#month(testdate)#br / Year: #year(testdate)#/p This code shows year='2010', month='6', day='10' But if i have a bean with a date value in it, and set the date value like this: cfset PosBean.setTransDate( createdate(2010,06,10) ) / pDay: #day( posbean.getTransDate() )#br / Month:#month( posbean.getTransDate() )#br / Year: #year( posbean.getTransDate() )#/p This code shows year='2010', month=10', day='6' So the next bit to check is the typing of the attributes going onto the CFC/bean and return type, etc... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Odd date behaviour - CF9/SQLServer2005
On 8/06/2010 15:16, Mike Kear wrote:
@Dale, I've just done a complete 180degree on that. Yes i think it is
coldfusion that's doing it. I did a few more inserts and looked at the
debugging.
Then when i look at the variables in the insert statement, when i use
the CFQUERYPARAM type=cf_sql_date its inserting {ts '2010-10-05 00:00:00'}
So you are saying that if you create a date object with create(Date)
properly with defined year. month and day you are getting the wrong ts?
oo, that's scary.
--
Yours,
Kym Kovan
mbcomms.net.au
--
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Coldfusion 9 and Windows server 2008 64bit
On 27/05/2010 13:22, BarryC wrote: Hi, After some more testing, thread dumps and operating system process monitoring, we have found that there seems to be a performance issue with files when accessed via NFS. The slow part is when file attributes are being requested for a file on the NFS (this was also shown in the thread dumps with the getBooleanAttributes() function coming up a lot). We have a client with a setup of a NAS (running FreeNas which is FreeBSD) with lots of files behind a few servers and so I took a peek into their CF logs and can see nothing like you are talking about below. The files are mainly just being served up or saved by these servers so it is not quite the same as code files. It makes me wonder if the permissions aspect is the important one. You say NFS, do you mean that literally, not NTFS via samba (SMB) or something? I might ask them if they mind us running some tests at the weekend when its quiet for them and see what we get. Kym K We have done a couple of tests with rather interesting results (we set up a specific test that loops over some directories and looks at the files in those directories, it does a fileExists(..) on each file in those directories); 1. test local file access time. 2. test file access time via share mounted via NFS path e.g. \\server \path\sharedfiles\ 3. test file access time via an iSCSI mounted drive (still over the network, but the operating system sees it as a lettered drive e.g. d: \sharedfiles\ The local file access time was very fast, for the 20 folders it did it in between 16ms and 50ms The FMS access time was very slow, about 3 seconds for the same 20 folders (I'd expect some delay over the network, but this seems rather a lot). The iSCSI mount was surprisingly fast at about 130ms (indicating that network latency time isn't really the issue?) We're a bit stumped, and the systems guys have had a look at options at the NFS end and there doesn't really seem to be much configuration they can do there. Kai, you mentioned that you run some of your servers with an NFS share, but have no problems, how is your share implemented, do you run it on Linux with the windows servers connecting to that? Regards Barry. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Coldfusion 9 and Windows server 2008 64bit
On 28/05/2010 06:59, BarryC wrote: Yes, that's correct Charlie. Kym, the NFS is a proper NFS. and I've been googling and it seems in a lot of contexts NFS on 2008 is faster than most linux versions. It used to run like a dog and MS brought a new stack in 2008 that goes like a train. So NFS per se should not be an issue. If you could run a simple test, it would be handy I'll see what I can do. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Coldfusion 9 and Windows server 2008 64bit
On 28/05/2010 11:38, BarryC wrote: Did those references you found say anything about the specific version of windows server 2008, or just in general? There is 2008 R2 for example, but we are on the standard 2008 - not sure if there would be any difference there? The changes came in with straight 2008. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: JB-HI Moving to dotnet
On 26/05/2010 17:04, Chris Velevitch wrote: On Wed, May 26, 2010 at 16:58, Dale Fraserd...@fraser.id.au wrote: Where was CEBit? Sydney. And I never got there even though I wanted to, too busy :-( The fact that we are busy tells me that CF is alive and well in Oz, or our segment of it at least but I also am aware that our segment is not everything. Fiona and I got a bit of a surprise at WebDU, very few people had heard of us, very few indeed. It made me realise that you can be going like a train and being very good at what you do but if you don't make a noise occasionally then you fade from people's awareness and a new generation comes along who have never heard of you. You can be the county's most senior cfml developers and hosting firm but it counts for nought if no-one has heard of you. That is why I am suddenly making a lot of noise rather than the once-a-month-or-so squeak that I usually make. We are even considering having our own website! Shock Horror! We've never done that properly before :-) So stand by for more noise, cfml is going to be heard again! -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: JB-HI Moving to dotnet
On 26/05/2010 18:21, nomadic fish wrote: hey Kym, it sounds like you're having the same problem CF is. been around forever, in use all over the place, but invisible to everyone who isn't actually being paid to look at it. Yes well I certainly have been around for ever and we are certainly going to start to make noise to raise our visibility and cfml at the same time. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: JB-HI Moving to dotnet
On 26/05/2010 15:14, Mark Mandel wrote: What are other companies out there doing? I.e. have people had experience with MS knocking on their door? Or any other platform? Anyone know first hand? (I'm still waiting for the PHP evangelists to come knocking). I've missed all the fun as I was busy this morning, installing yet another SQL2008 server to handle yet more clients and a couple more VMs to put them on. Not showing off, just simple fact. We are a CF-only hosting company and yes, we are not cheap as hosting in Oz is not cheap, that's _all_ hosting not just CF hosting. Like Steve said it costs 2K a month to have a rack in a decent datacentre, we pay well into 5 figures a month for hosting costs but for that sort of money you get a degree of reliability that you don't get elsewhere. Its the old, old story, you get what you pay for. We don't have 400 sites on one web server or 200 databases on a DB server, that's what happens when you pay $5 a month for your hosting. And if the power wobbles, we keep going. I got two phone calls yesterday relevant to this conversation, one from a prospective client who was fed up with the poor service at their existing hosting company, its in Brisbane and owned by a Victorian company if you know the one I mean. They are coming to us at twice the price they were paying before to get something that actually works (and I'm talking $55pm for a CMS site not thousands for a big business site). The other phone call was from Microsoft! They did come knocking at our door, metaphorically speaking! Wanted to know if we were happy, etc. We are a CF shop but we are also a Windows shop, we own quite a few Win2008 Datacentre licenses and SQL2008 ditto, we do spend serious (by small business standards) money with them even if we compete with their web technology. And talking of evangelising we have decided to put our CMS into the public domain and really start promoting cfml as a language and note the use of cfml there not Coldfusion. I think that is important now, it is in the public domain at the application platform level, it is not just Adobe any more and we need to start making noises. Here in Sydney the last Coldfusion User Group meeting was a long time ago, we now have an Adobe Platform User Group and Chris does a grand job but apart from me jumping up and down and mentioning cfml at every opportunity in the audience there has been no CF content in ages, its all Flex and Flash, etc. The Adobe Way. I have been thinking seriously about having a cfml user group, not directly connected to Adobe to see if we can attract a new crew of developers. Is that a viable idea? -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CF Mail problem
On 17/05/2010 16:30, Scott Thornton wrote: Hi, Nothing unusual on logs I am, since last week. The spool checking stooped last Friday at 4:45pm then nothing... Are they going out now? Have you dragged them all back into the spool folder to give them another go? If they are still not going out in the sense that they are just sitting there in the spool folder then you are going to have to kick the server. If they go back to the undelivr folder then CF's mail engine is running and you are going to have to check the emails in more detail. There is a cfc out there that talks to the factory and restarts to mail engine but we have found it to be a tad unreliable when we have tried it so we just pick a quiet moment and restart CF, much more reliable :-) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Coldfusion 9 and Windows server 2008 64bit
On 18/05/2010 09:40, BarryC wrote: Hi Kym or Kai, or anyone with a successfully working CF9 64bit install... What is the JRE version that is actually on the server? the one we are using is 1.6.0_14 Same here. Also, some info, the kind of things showing in the thread dumps a lot are native methods like these: At a quick glance that looks like a failed search for a file with a funny opr two in the middle, do you have server monitoring turned on? java.lang.Thread.State: RUNNABLE at java.io.WinNTFileSystem.getBooleanAttributes(Native Method) at java.io.File.exists(File.java:733) at coldfusion.runtime.RuntimeServiceImpl $1.run(RuntimeServiceImpl.java:904) at java.security.AccessController.doPrivileged(Native Method) at coldfusion.runtime.RuntimeServiceImpl.checkFileExists(RuntimeServiceImpl.java: 900) at coldfusion.runtime.RuntimeServiceImpl.getRealPath(RuntimeServiceImpl.java: 952) at coldfusion.filter.FusionContext.getRealPath(FusionContext.java: 758) at coldfusion.util.Utils.expandPath(Utils.java:434) at coldfusion.runtime.CFPage.ExpandPath(CFPage.java:3028) java.lang.Thread.State: RUNNABLE at java.io.WinNTFileSystem.getBooleanAttributes(Native Method) at java.io.File.isDirectory(File.java:754) at coldfusion.runtime.CFPage.DirectoryExists(CFPage.java:2959) java.lang.Thread.State: RUNNABLE at java.io.WinNTFileSystem.getLastModifiedTime(Native Method) at java.io.File.lastModified(File.java:826) at coldfusion.compiler.NeoTranslator.getLastModifiedTime(NeoTranslator.java: 940) at coldfusion.runtime.TemplateClassLoader.getLastModifiedTime(TemplateClassLoader.java: 297) at coldfusion.runtime.TemplateProxy.getRuntimeComponentMetadata(TemplateProxy.java: 1751) at coldfusion.runtime.TemplateProxy.getRuntimeMetadata(TemplateProxy.java: 1616) Barry. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Re: Coldfusion 9 and Windows server 2008 64bit
On 18/05/2010 10:35, BarryC wrote: I have ensured logging is not on, I'm not 100% sure if it was on or off, but my subsequent tests are all the same response times. What do you mean by a file with a funny or two in the middle? I was looking at this one, and misread it :-) at coldfusion.filter.FusionContext.getRealPath(FusionContext.java: 758) Certainly that trace is a check to get the attributes of a file so it should be calling native methods, a fair chunk of that stack is at the java and OS level. What is the concern, that native methods were being called at all or what? -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CF Mail problem
On 18/05/2010 11:03, Scott Thornton wrote: My thoughts exactly, I'd love to see it separate. It is quasi separate, here is the tool: http://www.cflib.org/udf/cfMailFactory AFAICT CF is using JavaMail under the hood to actually send the emails and there is a scheduled thread in CF that scans the spool folder and hands the mails to javamail to send. If javamail doesn't like the email then it hands it back and the thread puts it in the undelivr folder. So there isn't a separate service per se just a internally scheduled thread. -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CF Mail problem
On 18/05/2010 11:51, Steve Onnis wrote: So the scheduled thread terminates and that's why sending mail stops? I assume so. Maybe the javamail engine sends back bad stuff and breaks the thread (unlikely as javamail is rock solid) or it stops for some other reason internal to CF... -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Coldfusion 9 and Windows server 2008 64bit
On 17/05/2010 11:00, BarryC wrote: Hi, Does anyone on here run coldfusion 9 on windows server 2008, 64 bit? Yes, heavily. We are running in to some performance issues which seem to be at an OS level and I'm wondering if anyone else has used this configuration with success. No issues whatsoever once we got used to the style of Win2008 R2, it's a very nailed-down OS. A cluster of servers running at 5 - 8 concurrent continuously with SQL2008 backend, also 64bit. The servers run at minimal CPU usage, the restrictions are memory ones rather than grunt. We also have a couple of web-only asset servers spitting out all of the graphics, etc., with a NAS behind them and they do put in the occasional pause waiting for things so your running of a NAS might be the issue. We run full CF code on every server with a sync tool to keep everything in order. and the speed of response. (All of the above is VMware Virtual Machines running off a SAN so there is network latency for the disks, just a different sort) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Total server ram for high load websites
On 15/04/2010 08:29, Barry Chesterman wrote: I have seen 8BG recommended a couple of times around the net, what sort of load do you experience off your server Kai, and do you find that your 8GB is mostly utilised, or could you get away with say 5 or 6GB of ram? We at mbcomms have just moved a client to a virtual environment with a bunch of CF9 servers running on 4GB RAM each. JVM set to take 3GB and 1GB left for the OS, etc. Seems to be OK but a tad more memory for both might be a good thing, we are still fine tuning. We might wind a couple up to 6 GB and give CF 4GB and compare those with the 3GB ones. Got to love a virtual environment, just wind the hardware up and down as needed :-) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Total server ram for high load websites
Forgot to mention this is all on 2008 R2 x64 with CF9 Enterprise 64bit On 15/04/2010 11:54, Kym Kovan wrote: On 15/04/2010 08:29, Barry Chesterman wrote: I have seen 8BG recommended a couple of times around the net, what sort of load do you experience off your server Kai, and do you find that your 8GB is mostly utilised, or could you get away with say 5 or 6GB of ram? We at mbcomms have just moved a client to a virtual environment with a bunch of CF9 servers running on 4GB RAM each. JVM set to take 3GB and 1GB left for the OS, etc. Seems to be OK but a tad more memory for both might be a good thing, we are still fine tuning. We might wind a couple up to 6 GB and give CF 4GB and compare those with the 3GB ones. Got to love a virtual environment, just wind the hardware up and down as needed :-) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] First foray into ajax
On 23/03/2010 12:05, Scott Thornton wrote: Hello, I have been very lazy and not delved into any ajax stuff, mostly because I don't have the time, and we have tried to keep the application I work on as simple as possible. However, I was wondering if it was possible to perform the following asynchronously without a page submit: User enters a date Submit is pressed the /program /checks to see if the date exists in the database If the record exists, continue, otherwise, display a message to the user... If so, can anyone direct me to a resource to help me figure this out that combines the ajax functionality with CF calls to a database? I use cfmx6.1 If you just want to do ajax stuff without heavy javascript User Interfaces stuff then ajaxCFC is for you: http://ajaxcfc.riaforge.org/ There is an example of almost exactly what you are truing to do. If you are into javascript then you can try jquery or extjs, or wrap extjs in ColdExt -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Coldfusion XML, adding an XML node from another XML document object
On 4/03/2010 07:17, BarryC wrote: Hi, I've hunted around for a solution to this but haven't found a simple or clean one (maybe there isn't one) but maybe someone here has some suggestions. I have two XML objects and I want to take an XML node from one and insert it into the other Ben Nadel has some nice tools: http://www.bennadel.com/blog/1532-Copy-Import-XML-Nodes-Into-A-ColdFusion-XML-Document.htm we grabbed a bunch of his XML tools and other stuff we found and put them in a XML utility CFC, it gets used lots :-) -- Yours, Kym Kovan mbcomms.net.au -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: Backing up MySQL Databases
Steve Onnis wrote: Looking for more of a ui based thing like SQL server does it...to be honest I cant be bothered mucking around coding up backup routines In that case Navicat is your friend. Scheduled backups and everything. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Change Mail Spool Directory
Steve Onnis wrote: Now this is what i am thinking. What if you could point the mail spool folder to somewhere on a network path and have a number of cf servers pointing to the same mail spool location. Would all these servers process the mail? Would there be locking conflicts between the servers trying to get the mail to send out? I think it would be horrible as AFAIK CF reads the folder, builds a struct of emails to send and then hands that to javaMail under the hood. You would get all the servers trying to send all of the mail, then some would find mail files missing and get very confused. What if you could assign one server to process mail and the other servers deposit into that server? Now that is an idea. A bit like using iMS's cf_mail tag to flick the email to somewhere else to worry about and then get on withg doing CF stuff. Any thoughts? I just took a peek in the admin API and there is a mail.cfc there, might be worth taking a look -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: set file created date with ColdFusion
AJ Mercer wrote: see attached screenshot I would like to set the highlighted property AFAIK You cannot change the created date, it would make that date meaningless. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Virtual ANZ Friday beer o'clock... - Connect room link
Kai Koenig wrote: Uuuuhh, interesting. I wonder if Charlie might be interested to carry the US torch on our Saturday here :) I am not sure what time zone Charlie is in but I am in Vancouver, BC at the moment so starting time for me is 9pm Thursday if I have done my sums right. I'm hopping on the plane back to Oz the next morning so I don't know how long I will hang but there will be one from the Pacific Northwest fleetingly at least :-) -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: String concatenation - what's happening here?
Chris Velevitch wrote: Are you sure the problem is not with the method? The way I see it, the method, whilst correctly determining the path, is doing something else before returning the path. Agreed Chris. Dump it Mike, Dump it :-) -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: String concatenation - what's happening here?
Hi Mike, Your first option should work if they really are strings, I've done that one often enuf myself. Evaluate is just doing the same job and I've never seen toString being used lke that before :-) if cfset temporaryfile = #gettemporarydirabs()#\#theImage.getName()# / does not work try putting each function call into their own simple variable and then concatenate them. cfset string1 = gettemporarydirabs() / cfset string2 = theImage.getName() / cfset temporaryfile = #string1#\#string2# / HTH Kym K Mike Kear wrote: i'm trying to concatenate two values - an absolute directory and a filename into an absolute file reference for CFFILE to manipulate. But i'm getting an error. I've tried every combination and permutation I can think of but still havent hit the correct one . can anyone see what i'm obviously too close to now to see? The two values (which DO return strings - i've checked) are : #gettemporarydirabs()# and #theImage.getName()# The error is: The value E:\Sites\Customers\Customername\wwwroot\cms\images\userfiles\Temporary cannot be converted to a number. That value is what is returned from the first function gettemporarydirabs() . The line that causes the error is: cfset temporaryfile = tostring(#gettemporarydirabs()#\#theImage.getName()#) / I've also tried the following: cfset temporaryfile = #gettemporarydirabs()#\#theImage.getName()# / cfset temporaryfile = evaluate(#gettemporarydirabs()#\#theImage.getName()#) / cfset temporaryfile = tostring(#gettemporarydirabs()# \ #theImage.getName()#) / and a few other combinations, but all give the same result. What am I missing here? (I just KNOW its going to end up being one of those 'slap the forehead' moments!) -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: String concatenation - what's happening here?
Mike Kear wrote: Thanks a lot Kym, I can see the logic in what you're suggesting. I figured to myself, 'yes as always, Kym shows good sense'.So I tried it. Gave the same infuriating outcome - the line cfset string1 = gettemporarydirabs() / gives the following error: E:\Sites\Customers\customername\wwwroot\cms\images\userfiles\Temporary cannot be converted to a number. So also does cfset string1 = #gettemporarydirabs()# / (i thought perhaps the double quotes might tell CF that it's working with strings not numbers) Good try but obviously not. Have you tried dumping gettemporarydirabs()? It strikes me that you are getting something dodgy back as what you are doing is so simple even I can handle it. As an aside a style rule we have here is that all paths have to have a trailing (back)slash then you know exactly where you stand, if it has a slash its a path, if it doesn't its a file. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFMAIL headers
Steve Onnis wrote: What I am wanting to do, as a default thing for ALL mail generated by CFMAIL for any domain or application WITHOUT having to use CFMAILPARAM is to add another entry into the mail file like... / type: text/plain; charset=UTF-8 server: MAILSERVER:25 from: st...@somedomain.com to: st...@someotherdomain.com subject: this is a mail file X-Mailer: ColdFusion 8 Application Server X-Date: 2009-12-12 / Currently there is no way of getting the dateCreated value for a file, only lastModified and I want to know the original datetime the mail item was created. I am creating a little app to process mail that is being pushed into the undelivered folder for coldfusion server which is why I want to look at doing this. If it is possible, it would be handy to add other properties also such as the domain name used when the cfmail tag was called so I can track down the original creator of emails. What are you doing for the Return-Path: you must be creating that on the fly each time? You can put identifiers in there if you have control over it. EG straight from the Sydney Swans newsletter rcvd this week (from one of our own servers) Return-Path: bounce-11-1752-9129-9766...@ronbarassi.rto.mbcomms.net.au There is enuf data in there to relate back to the sender, when, etc. You could do something similar. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFMAIL headers
Steve Onnis wrote: No no no I DON'T want to do it using CFMAILPARAM I want to do it automatically Which means you want to use an attribute of the cfmail tag with some form of formatted date/time? The attribute failto is what I was talking about, code the bounce path to include something that can be deciphered to a date/time, there is nothing else in there attribute-wise that you can add stuff like this in. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: html editor
Drew wrote: Anyone have any recommendations for a browser based WYSIWYG HTML editor? Preferably no active x/java plug ins etc etc. 1. TinyMCE (add the CFFM filemanager to make it even better) 2. FCKEditor We have both in our CMS, folk can select which they want and most go for TinyMCE -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Dates / Times
Hi Andrew, this is already worked out but here is an alternative CF answer which makes me ask was '2 mins 50 secs' an actual time? because: cfset addTime = 0.00208101851852 / cfset thisTime = CreateTime(0,0,0)+addTime / cfoutput thisTime: #thisTime#br formatted: #TimeFormat(thisTime, HH:mm:ss)# /cfoutput gives me 2:59. The nice thing about CF is that it is like Excel in that everything internally time-wise is a decimal day and you can do straight sums on times if you feel so inclined. Andrew wrote: Hi, I've got an excel spreadsheet which I am parsing with cfHSSF (http:// cfhssf.riaforge.org/) In it are a few time fields (elapsed times, like 2 mins, 50 seconds) which are returned as something like this: 0.00208101851852 Is there an easy way to convert that to minutes and seconds in CF? -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: How do you handle previews?
Mike Kear wrote: A question for those who have CMS systems How do you folks handle previews?The preview function in my CMS is less than perfect and I'd like to do it better. ... Another method i've seen is having the CMS working entirely from a preview table, which is a duplicate of the 'live' table. Changes are written into the preview table and previews are assembled from that. When changes are committed to the live site, they are copied across from the preview table. I'm looking for some advice about how the rest of you handle preview functions in applications like CMS systems. How do you handle this? We use two tables but not as described, we have a table that just has content in it and one table of control data. Every time the content for a page is saved in the editor the entire content is saved in the content table so there are umpteen versions of the content. Flags in the control table indicate which version is the live version and which is the currently being edited one so going live with new content is just a matter of flipping flags. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Copying databases between virtual machines
Steve Onnis wrote: i tried both a DTS transfer and tried to attach the db and both didnt work. I am suprised the attach didnt work though. If you had copied the db to the destination VM then I would have thought an Attach should have worked. Are your VMs identical? It could be that Enterprise Manager is confused as to where it is. NMH Kym K *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On Behalf Of *Dale Fraser *Sent:* Wednesday, 26 November 2008 11:57 AM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Re: Copying databases between virtual machines How are you copying exactly? Regards Dale Fraser http://learncf.com http://learncf.com/ http://flexcf.com http://flexcf.com/ *From:* cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] *On Behalf Of *Steve Onnis *Sent:* Wednesday, 26 November 2008 11:50 AM *To:* cfaussie@googlegroups.com *Subject:* [cfaussie] Copying databases between virtual machines Dont know if anyone can help but no harm in asking I have a virtual machine wihich has an mssql2000 database on it. I recently made a copy of it and took it into the datacenter and loaded onto one of my servers. The VM runs fine but now i am trying to copy a database from my local VM to the one in the datanceter but i am getting an error message saying that i cant copy the database because the source and destination are the same database. I am connecting to them both using different IP addresses which i thought would have been enough but its not playing nice. Anyone else come across anything like this? Steve -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Version control + ColdFusion development
Matthew wrote: Hi everyone, Setup: Windows environment, IIS, CF7, Eclipse I'm looking to apply version control to a website I'm working on and would appreciate any recommendations on how best to set everything up in regards to version control + CF coding. Question: I've install Subversion etc and am at the point where I've got a repository setup on a shared server with a fresh copy of the website code as of today in the trunk and I've tagged it as version 1.0. I've then checked it out (should I checkout the tag or the trunk by the way?) and all works perfectly ready to start / edit code. However I'm looking for advice on when to branch / tag? T You have done the hard part, getting the repository up and running and getting your code into it in the trunk and then tagging it as 1.0. You should check out the Trunk, Tags are for going to Production (BTW Tags and Branches are the same difference, it is just a convention that a Tag is Production Ready and a branch is for specific code modules or testing, etc) From that point on I think you missed one of the beauties of SVN, you only ever checkout once into a workstation to create your Working Copy and from that point onwards you just Switch between the trunk/branches as you need, you don't have to checkout again. You start with the trunk checked out into your machine. If you need to work on a subset of the code, like your SQL coding section, then create a branch for that part. (Trap for the unwary if you are using TortoiseSVN - do not create the branch folder in the Repo Browser, just name it in the Create Branch dialog and Tortoise will create it for you) Once you have created the branch you can just switch to it and Tortoise will do all of the folder/file swapping needed to make your working copy the Branch not the Trunk. Work on the Branch and test, etc., in CFEclipse in the same project space, the code you will be looking at *will* be the branches code. If you need to do another discrete task the Switch back to the Trunk, wait for all the shuffling to finish, and then create a new branch and Switch to that. As coding in a branch is completed you can Merge it back into the Truck. When something is ready for Production then Tag it and do an Export from the Tag and deploy to your production boxes by your preferred method (or you can put a SVN client like Tortoise on your Production boxes and Checkout rather than Export (note this method can cause major upheavals when discussed on Lists like this one, there are very strong opinions either way)) -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: SQL INJECTION
Claude Raiola wrote: We have just had an SQL injection attack. Given we have several hundred cold fusion pages and the sql database as several hundred tables has anyone found a reliable solution where why script can be placed in the application.cfm page that will prevent code being appended to queries as a viable alternative to having to edit every query across the 100's of pages use the appropriate cfqueryparam . You *have* to use cfqueryparam , no choice. But it takes time to patch up legacy sites, etc so drop the function found here http://www.cfwebstore.com/index.cfm?fuseaction=page.downloaddownloadID=18 into your application.cfm and that will take some of the stress away. There has been much chatter on various Lists about this and Mary Joe is keeping the latest version of the function ready for her own clients and the rest of us, most appreciated. Another assist of you have the access it to remove permissions for the System tables in the database, sys_objects and the like, so the script cannot read them to do its nasty work. We surfed to our favourite surf watching site yesterday and got a warning from Chrome (dodgy site warning) The site had been infected :-( Do a Google on: chkadw.com and see how many hits there are and most of them are right there in the Title of the, obviously CMS-driven, website! -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Version control + ColdFusion development
Matthew wrote: Hi Kym Thanks very much for such a detailed response. So just to be 100% sure of what you're saying: 1. You should only ever one version of the code on your dev machine i.e. if you're working on one branch (Branch A) but need to swap to another branch (Branch B) than you should check in Branch A and checkout Branch B i.e. Branch B overrides Branch A in your working copy. This makes sense because you wouldn't want to have more than one project checked out at anyone time. Would you recommend checking in daily work to the branch, trunk or both? No you have still missed it. Maybe it is a terminology thing as SVN is quite specific in its own little way. Import is the filling of a repository CheckOut is getting from the Repository to a Working Copy on your machine. You only ever to it once to create your Working Copy. To save your work you Commit to the Repository To refresh from the repository you Update from the repository. In your example if you are working on Branch A you Commit to the Branch and Switch, not Checkout, to Branch B. The big thing about Version Control, in any form, is housekeeping. You have to be really strict with yourself to keep tabs on what you are doing and where. When you initially Checked out you would normally do that from the Trunk as that is The Base of All Things :-) If you Switch to a Branch then you have to remember that. If you do a Commit at the end of the working day it will be to the Branch you are working in. When you start in the morning you are still in that Branch. Finish the job, Commit, Switch back to Trunk. 2. Once you've completed a branch, check it back in, No, Commit it. If it is needed Merge it back into the Trunk. copy it to a tag Normally just Tag from the Trunk or Branch, depending on what you just did above, SVN does not do copies as we think of folder/file structures. Tagging just hangs a label off the Repository at a certain Revision, it does not do a copy or anything meaningful with the folders/files as they don't actually exist in any physical sense. (i.e. latest version ready for production), and perhaps delete the Branch to clean things up. If you wish to, no need really (again it is only a label on a certain revision) and it helps with Housekeeping if you can see your paper trail of Branches. Then export the tagged version for Production via SVN or FTP or whatever you prefer. Yes. So essentially the production server could have Subversion installed and it's working copy is the code which is live. Yes. So all you are doing is checking out a tagged version from shared server to production server when you upgrade to new version. Makes sense! There are arguments about security in having a SVN client on a production box but it does make a lot of sense in other areas. 3. All I've got to work out now is how to override my dev working copy in Eclipse because so far I've only worked out how to checkout a version into a new project... I'll keep playing around. You have done the first-and-only Checkout, from here on in you do Switches or Updates. I guess the other option is to try Tortoise as per your switching suggestion. It is not an option, it is the only way to do it. If you Checked out the Trunk then just Switch. It is super-easy, just select the Branch you want in the Switch dialog box, use the ... button to bring up the Repo Browser if you are not sure of the branch. We have either SubClipse of SubVersive installed in our Eclipse IDEs so (CF)Eclipse is SVN aware but we use Tortoise to Commit as it has better logging of what you are doing and when doing graphic work and not using Eclipse you are still in the flow. If you rename files in Eclipse with one of those SVN clients installed then the needed work behind the scenes in the .svn folders is done for you, very handy. Thanks a million again! No problems. I remember our learning curve and the help we got from the Lists, its nice to put back these days :-) -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF8 Ent on windows 64Bit
Steve Onnis wrote: I would just load it up, run a heap of queries and create a heap of emails and stuff and see how you go. Currently I have a gig allocated to the jvm and it always uses between 900 mb and 1200 mb. Right now its sitting on 1100 mb. Seriously, test the crap out of it before you implement it. I am running virtual hosting from it so you might go better if its just a single app you are running on it. Its not a Garbage Collection thing is it? Does 64bit run differently from that point of view? I am thinking of the persistent variables, apparent leak thingy: http://www.coldfusionmuse.com/index.cfm/2008/2/12/leaky.heap.jvm that Mark Kruger wrote about. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Filtering out folders.
Joris de Beer wrote: I'm using cfdirectory to recursively list the contents of a folder structure. Unfortunately there are a lot of .svn folders in there and they are also getting returned. Anyone have a tip for filtering out folders? Currently I'm thinking of doing a query of queries to remove them from the result set. Check for the Hidden attribute which is H We have this sort of thing everywhere: cfif qryThisTemplateDirectory.type eq File and qryThisTemplateDirectory.Attributes does not contain H for .svn and any other junk the OS might throw in. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Quick List question
CyberAngel wrote: Sorry, I tried that too, same result. Now that I am at home, I'll try it here as well. I tried this variation and it worked fine: cfif structKeyExists(URL, docsv) cfset csvdata = Col_1,Col_2,Col_3,Col_4chr(13)chr(10) / cfset csvdata = csvdata 'List Item ##1, List Item ##2, inner List Item ##1, inner List Item ##2, List Item ##4' / cfoutput#csvdata#/cfoutput cfabort cfelse cfhttp url=http://127.0.0.1:8050/index.cfm?docsv=true; name=myCSV firstrowasheaders=Yes/cfhttp cfdump var=#myCSV# /cfif -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: throughput and simultaneous requests
Hi Mark, you wrote: Basically I am on a witchhunt trying to see why some pages are occasionally too slow. Geoff, Your example is exactly what I am trying to do. (In other words, should I touch the CF default settings?) Lucus, in the Performance Monitor there is a chart of simultaneous requests (but I dont know how to log it. The number of simultaneous requests at any one time seems to always be an even number between 0 and eight) If you can tickle the code add the GetMetricData(PERF_MONITOR) function to Application.cfm/c or put it in OnRequestEnd, or both is even better if you can, and grab some of the parameters shown there. You can see how many requests are running at that moment, etc., it has some useful numbers. Store the bits you want incrementally into a application scope struct with a timestamp or some such and dump that to see what is going on. You can also add a getTickCount() to both ends of the page and see how long the page took to process, it amazes me how ofter a slow page has nothing to do with CF but is dependent on the connection (FireBug comes in handy there) Assuming x86-based CPUs and unless you have an old server they have HyperThreaded cores and the OS thinks there are two CPUs where there is actually one with its two internal bits. So the Simultaneous requests number is always an even number as CF farms out threads per CPU. If you have a typical dual-dual Xeon box you have 2 Dual Core HyperThreaded CPUs, really 4 processing cores but the OS will report 8 CPUs. With the processing speed available now the old rule-of-thumb of 5 threads(simultaneous requests) per CPU is long gone 10 or more is OK (assuming good SAS/SCSI drives, lots of RAM, etc). With Simultaneous Requests meaning the number of pages CF is processing at any one moment as soon as the number of requests rise above the number of CPUs there is internal thread switching going on in CF as well as the overall OS task switching so other performance issues creep in. We found on one client's site that it used to suddenly bog for no apparent reason and it was traced to folk doing file uploads into the management system of the site (a glorified CMS thingo). When there is a file upload going on one CPU core gets dedicated to that task and become unavailable to the task switching pool so there could be a performance hit. Its only half an answer but I hope it helps. (IOHAABIHIH, is that a new acronym? I don't think so :-)) -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Streaming audio to the web? anyone done it ?
Mike Kear wrote: I'm working on streaming our radio station signal to the web - has anyone here done it and can spare a few minutes to bring me up to scratch with what all the issues are please? Im not talking about podcasts, but 24/7 streaming - if anyone can spare a few minutes for a phone call from me i'd be most grateful. We streamed 2CH in one of its incarnations, the first RealAudio stream in the southern Hemisphere and about 12 years back IIRC. It was a 10 stream license and the audio input was a tranny radio as they could not justify an ISDN link to us for a digital feed. Worked well tho' and we got email from all over the planet. Does that count :-) -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Streaming audio to the web? anyone done it ?
Mike Kear wrote: @Kym: yes of course it counts! If i can call you tomorrow would that be ok? @Zac: no i havent considered anything yet. I'm just working out what the issues are I have to address. One to worry about is bandwidth. I am sitting here listening to the jazz stream from ABC's DIG site and looking at our monitoring I can see 333Kbps streaming into my workstation, not an insignificant amount in itself, many streams and you have serious bandwidth considerations. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: OT : Logging IIS log files across a network
Steve Onnis wrote: Kym What I am wanting to do it log them to a file server. Currently I am logging locally but my stats server grabs the log files across the network and processes them. Was hoping I could just log it all directly to the stats server. That is exactly what we were wanting to do but could not make it work reliably. I imagine it would depend on a few variables, how many sites involved, how big the log files, what technique the stats server uses to read the files, etc. In our case it was many log files, some of them 100s of Megs in a day, and the permanently open connections bogged the network down. We use DeepMetrix's LiveStats ISP version which has an amazingly good engine to read the log files and we found that we could not get close to its native performance with it reading the logs remotely. We did some peeking and found that it was doing Tail type reads of the log files, maybe a Meg every 5 minutes on the high traffic sites it was very efficient, just a blink and it was done. LiveStats was an excellent product, well designed and did its job perfectly until they improved it and it went backwards and then Microsoft bought the firm and that was that :-( -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: OT : Logging IIS log files across a network
MrBuzzy wrote: Are you sure it's the iuser_? Try changing the start up user on the 'World Wide Web Publishing Service. That is entertaining, but possible. The IUSR_ user pops up all over the place, it's is one of Microsoft's wonder designs. As you cannot get at its password on some versions of the OS using a new user is the only way to make it talk over the network. Exactly the same problem as running CF server on a network-aware user. Its a lot of work to make that change (think directory security settings on each website, etc) and then having got it to work you potentially have the issues I have already mentioned. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: suggestions best practices in consuming webservices? (timeout woes)
Barry Beattie wrote: that's a good point (OK, so I haven't gotten to that far yet) CFThread and getTickCount()? We have a client that uses a webservice for their main engine and the website is just one of several wrappers for it. They actually have two web services, one in Brisbane and the other in Melbourne to give them the best chance of one being reachable with us being in Sydney in the middle. We do a straight cfhttp to the webservice to see if its there and then if it responds start the requests. No cfthread (the site is on MX 6.1) just timeouts and try/catch code. If one fails then try the other and if that fails try the first again and do that up to 5 times and then give up. We find that works fine and find that the main webservice http call misses about once every couple of days and the other usually picks it up. It is always a simple Connection Timeout form the http request. What we have found is that if things are going to fall over big time it happens at both ends at the same time! Twice in the last year there have been overlapping server/database failures at both datacentres which are run by separate companies not related to us (part of the client's too many eggs precautions). Interesting odds. -- Yours, Kym Kovan mbcomms.net.au --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: [OT] .htaccess
Ricardo wrote: Can anyone help me with a .htaccess script. I need to redirect all traffic that is not https://www.domain.com to there. So... http://domain.com http://www.domain.com https://domain.com all need to go to: https://www.domain.com I can get everything to redirect except https://domain.com You will have to do the https ones at the CF level not the webserver as https connections are based on IP addresses not domain names, the domain name in the host headers is encrypted along with everything else, the webserver knows nothing about it. -- Yours, Kym Kovan mbcomms --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: GO QUEENSLAND!
Barry Beattie wrote: Good to see Qld fielded two teams in the Code Wars while Sydney (and Melbourne) could only manage one each... Some of us Sydneysiders are not only not in the code wars but are missing the entire WebDU thing :-( In our case the change of dates clashed with the Dalai Lama activities at the Showgrounds, to which we had committed very early. Peace to you all, except in the code wars :-) -- Yours, Kym Kovan mbcomms --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Coldfusion Daylight saving
Hi Stephen, you wrote: Whenever I request a date in the period 31/3/08 to 7/4/08 it’s out by an hour hence it causes problems with all my reports for that period. E.g. 31/3/08 becomes 30/3/08 at 11pm. Was there a fix for the daylight saving in Australia, I have the latest JVM being 1.4.2_11 . Two questions can be asked from the server end of things:- 1. Does the server run daylight savings at all? Many hosting shops don't, it's +10 here all the time. 2. If it does run daylight savings was the MS patch done? This year MS got caught short and the patch was not a compulsory one so unless the admin deliberately put it in then its not there. -- Yours, Kym Kovan mbcomms --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: [OT] Security, record bot infected machines
Taco Fleur wrote: There is ALWAYS a solution to a problem. But keep 'm coming, the more ideas we get out of it ;-) Here's one: With our CF-base mail server we can do tricks and one has been to log all bad IP addresses for machines that try to send bad emails. Most are easy to detect (not a full domain name in the HELO clause, etc) and we store these and reject in the future on the IP when they connect. The database has over a million records at the moment and is growing steadily and we were concerned as to how to look up on every hit as with umpteen emails a second on a table that size its making the db server work hard. We tried Q of Q and caching, etc but the update rate is so high that cahing is not much use and the best we found is simply storing the lot in an application scope structure, application.bannedIPs[IPaddress], and use StructKeyExists(application.bannedIPs, IPaddress) to see if the incoming IP is good or not. Works well and memory use does not seem to be a problem. So handling a stack of IPs is not as bad as it first appears.. -- Kym Kovan, Technical Support, mort bay communications [EMAIL PROTECTED] +61.2 9559 2629 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Cf admin issue
MrBuzzy wrote: Hi, has anyone experienced this? Perhaps there's a way round it... Yes, we used to see it all of the time until we twigged. I have a couple of cf instances running on the same sever and domain. Each is fronted with iis and are uniquely identified by the sub domain, like: Apples.myplace.com Oranges.myplace.com All of our servers have domain names of the form: servername.mbcomms.net.au Going into more than one at at time CFIDE-wise is a no-no. The problem: say I'm browsing both sites (multiple windows or tabs, whatever) eventually the cf administrators gets funky - settings don't stick, passwords are ignored. The page appears to refresh but doesn't do anything. Our most common one is form variables getting munged, eg open a datasource and seeing the wrong parameters! Oo, nasty, can give a big fright :-) My solution: close all browser windows and then go back to the cf admin page to continue where I left off. We have these URLs set to don't remember anything in the browser as a starter and only one instance at a time and you are OK. Otherwise it is as you say, trash it and start over. I believe the cause is cflogin cookies used in cfadmin, which seem to clash by path or domain but I've never quite worked it out. We certainly think it is domain name related. If we need two CFAdmins open under the same domain we use different browsers, Firefox by default and IE for the second one. Going to servers on different domains, say mbcomms.net.au and imgecommerce.com, causes no problem. Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Using CFEXECUTE to run a batch file
Hello, [EMAIL PROTECTED] wrote: I have a batch file d:\test.bat which I would like to execute to run on the server. My command is as follows cfexecute name=d:\test.bat timeout=10 /cfexecute This will echo the contents of the file test.bat to the screen rather than execute the file. Am I missing something simple You need to get the OS Command.exe to run the batch file so try this cfset batchfilename = work_dir LOGTEST.BAT cfset variousParameters = lots of parameters with spaces between them cfexecute name=D:\winnt\system32\CMD.EXE arguments=/C #batchfilename# #variousParameters#/cfexecute All the best to everyone for the festive season and the New Year. Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: [Ann-Syd] Peter Farland in Sydney
Hi Chris, you wrote: Peter Farland of the Adobe Flex Engineering team will be in Sydney on Wed 23rd and Thu 24th of January and he is willing to present at a meeting. I want to gauge the level of interest in having a meeting in January to hear Peter speak. I think Wed would be the best day to have it, in case folks decide to have an extended Australian Day Long Weekend. I'd be there on a Wed or Thurs :-) Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: debug slow loading pages
Hi Taco, you wrote: Hmm, ok, so you are the first one (besides me) who experienced the slowness... So there must be something going on. Add me to the list. I've been otherwise engaged and only just caught up on this. I got a 5 second page load the first time, nicely recorded in Firebug which I have sent to you off list via a screen grab. The main thing I noticed was the large number of style sheets, 8!, and their sequential loading in Firefox, each one taking half a second or so. No good for a first hit with nothing cached But why so sequential instead of the usual 2-at-a-time? Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CF + Subversion best practices ?
Mark Ireland wrote: Are are any of the people following this thread using subclipse in Eclipse? Yes, we are. We also use TortoiseSVN at the desktop and had been using that for some time before we moved to CFEclipse as our base dev environment. We tried Subversive in Eclipse and had hassles and we also found Subclipse similar to Tortoise so have stuck with that. I don't like the Commit side of things in terms of logging so our normal style is update-before-you-code in subclipse but commit via TSVN so the log history is not lost. Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Full As A Goog
Dale Fraser wrote: Ahh The sound of a pin, You can cut the Sydneysiders out, we are all pretending to have a holiday :-) I long for the days when Peter Tilbrook and Andrew Scott used to entertain us on a Friday afternoon. Ahh, the good old days... Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: OT: Server Recommendation
Hi Dale, you wrote: I'm looking at new production servers, and wanted some opinion on 1. Processor AMD vs Xeon, types of Xeon, ie Quad core, single, multiple CPU options. 2. How much memory (separate App DB servers) Also be interested in thoughts on anything else I should be looking at. The needs for a server are so different depending on its role that it is hard to have a universal machine that has not got some redundancy in kit, ie has a capital cost that is not recoverable. The space it has to go into is also relevant (eg, a 2RU Dell 2950 is cheaper than a 1RU of the same spec but takes up twice the rack space) In the replies so far there has been mention of disk space and RAID arrays. We have found that the current SAS drives are more than big enough in their own right for almost every need to a server with just two drives as RAID 1 gives both enough capacity, speed and reliability. (We use massive storage on a standalone backup machine to give backup security.) For sheer speed on a dedicated box then RAID 10 is the go but how often is that needed? Our flavour-of-the-month is dual quad-core XEON CPUs with 16GB or RAM which we then virtualise to 8 machines as we feel 2GB per machine is about right except for DB servers. I posted to CFWatercooler some time back about the cost of virtual machines v standalone, that is still pretty correct in terms of dollars and I am pleased to see that CF8 still has the same licensing, ie per server not CPU, which makes virtual machines much more cost effective. HTH Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: OT: Server Recommendation
Andrew Scott wrote: But what about downtime? Raid 5 and Raid 10 provide extremely low downtime, and if they drives are hot swappable then there is no downtime at all. It depends on how and what you measure. RAID 1 also gives no downtime of hot-swappable (we consider that to be essential, machines with embedded rives are bad news if one fails). One aspect is the failure rate of the drives, the really high-reliability folk use batches of RAID arrays with drives from different batches in each array so the chance of two drives going down at once are minimised. I have a horror story from the early days of a brand new RAID 5 array losing two drives at once, instant loss of all data.. And to match that a horror story for one of our co-lo clients. Simple/cheap servers, two internal drives in RAID1. Server techo came along and replaced drive under guarantee and as it was rebuilding the drive the OS blue-screened, and the tech hit the reset button just at the moment when the RAID controller was rewriting the drive partition tables. Result: one very unhappy client... Backups are different altogether... Not wrong. Speed generally not an issue, capacity is. Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Server Virus Software
Joel wrote: Afraid off : My server being compromised by a virus Users downloading an infected file Users uploading an infected file And worst of all, bandwidth usage going through the room due to Trojans/backdoors..:) There are two chances of nasties (again in the hosting context): First: an infected/bad file is run on the server. This should never happen except under your control Second: the server is infected due to a deficiency on the OS or an application running on it. A fully patched servers, firewalls and similar protective methods should stop that. From the above it could(will) happen so background scanning by a suitable tool should suffice That means that items one and four above are unlikely. It also means that item 3 will probably happen and possibly item 2 flowing on from that depending on what the application/site is doing so whether that is important is up to your application/business/whatever. You just wait, I am going to write a virus just for OS X platform..:P You mean they don't already exist? :^) Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Server Virus Software
Hi Dale, Dale Fraser wrote: So, No one puts virus software on servers then? The quick answer, for our context at least, is no :-) By virus software I assume you are talking about a virus scanner. By default such a beast will trigger for any file write by the OS. That will stop a web or database server dead in its tracks so you have to put a squillion exceptions in to let the server's normal write functions to work unimpeded (log files, etc). Then you have the dilemma of how to protect against uploaded files if you have such things on your websites. One option is to use a virus scanner that is directory intelligent and let it do its thing for an upload directory only or some such but you still get a performance hit as it is still sitting there doing a first-pass look at everything to see where it is going. The second option is to use an external scanner, ie one on another machine that checks your server. That works well, we use TrendMicro's server product to do it, but has the disadvantage that the scanning is external in every respect and so needs management. HTH Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Large CSV's and server timeouts
Hello, grant wrote: Here's the scenario: we have a csv file that contains 1.5 million rows and is provided by an external vendor. we need to either (a) parse the csv and insert into a DB, or (b) do lookups directly on the csv. Coming in a bit late on this. The fact that there are CFXs that do this has been mentioned, specifically the one to read a CSV into a query and we have tried that one ourselves. We had issues but we were doing non-standard things so we didn't blame the CFX. There is also a CFX that just reads a text file in line-by-line but it had bugs with some text types so we rolled our own. We use it to read log files, which can be massive, and it reads any file that is conventionally line-delimited (CF, LF or both) into a query object that you can then use as you feel fit. If I read your question directly you don't need to put the data in toto into a database, just be able to get stuff out of it. In which case a query object is just the thing. Out tag is going to be put in the public domain once our new website is up along with a few other useful goodies we have put together over the years but I am happy to flick it to you now if you wish. It can read an entire text file or start at a defined point so you can walk thru the file line-by-line if you wish. HTH Kym K PS, Somebody said CF is an interpreted language. It used to be but that was two (almost 3) versions ago. These days it is compiled and so is a lot faster. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFAussie Community Head Count
Pang (about twice a day, I must be getting old) Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: working with dates in CF
Hello Claude, you wrote: hi al I have the following date that I need to specify in my code cfset payment_from_date=10-01-07 however I cannot seem to display it in correct date format using the dateformat function it keeps returning 1-oct-07 when I am using dateformat(payment_date, dd-mmm-yy) Your problem is probably not the display formatting but the actual date itself. Your cfset should be: cfset payment_from_date = CreateDate(year, month, day) then the date is a proper date object in CF and then dateformat will work properly. I look forward to your advice seem to find date display / manipulation a real pain in the butt to get the correct format If you will forgive me I will use this as an excuse for one of my favourite rants, one I can get quite hot under the collar about :-) Almost everyone and his dog treats dates wrongly in CF and often in databases as well. They see a nice date string in Enterprise Manager or Access such as 10-01-07 and think it is a string. It is not, that tool is formatting it nicely for us dumb humans as hiding the fact that it is a a date object. A date in a database should always be a date datatype, not a string. If it is and you always treat dates as proper date objects in CF then you will not have these date format issues. HTH Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Additional coldfusion query result value
Hello, Steve Onnis wrote: Just looking at getting thoughts back before i post it ias a feature rest. The number of times you need to debug a query because it not giving you what you expect, and especially within CFCs, wouldnt it be nice to have an additional value containing the actual query text of the query that was performed. Something like query.sqlStatement or something. It there, if a little indirectly if you are on MX7. There is a parameter called result which you can add to the cfquery tag. With it you can specify the name of a result structure and then the cfquery returns a bunch of results, including the actual SQL statement. For reference: http://www.cfquickdocs.com/?sourceid=cfQDSearch1.02getDoc=cfquery HTH Kym K --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
