I'd like to upload a file to the CFMX server, then run a MSSQL DTS on that file
to insert/scrub it.
The file upload should be no problem, but how do I run a DTS from CF?
Also, after the file is uploaded, can anybody suggest how to make the file
available to the MSSQL server (which is on a
(CFMX 6.1 / Linux)
I set up a scheduled task (in the CF admin) to hit Google. It will run the task
if I hit the run now icon (next to the task in the CF admin, and the
execution gets logged in the scheduler.log, as expected.
However, it does not run automatically, and there are no entries in
Are you sure cron is set up to run?
As a matter of fact, I'm not; so I'll go figure that out.
Thanks,
Jamie
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting
The more I know about having a farm of servers, the more worried I get
about them:
Farm Cons:
* No way to sync the global scopes (Application, Server)
* No CFCs in session scope (Has this changed in CFMX7? Guess I can
look it up.)
* Only native way to do session sharing is to
Is it possible to share sessions without clustering?
(I'd like to be able to know that when I'm hitting Server A, that the
application I'm seeing is coming from Server A. This is for hardware
load-balancing and fail-over reasons.)
Here's a real world example: Sometimes, I need to reload
by CFMX cluster you are speaking of SOFTWARE based clustering in JRun, not a
load balancer correct? Try this code below, it will tell you what instance
you are on. I use this. Its a real PITA though to make sure you are on
instance foo or goo.
cfobject action=create type=java
I actually have session sharing off now, using sticky sessions. Yeah, it was
pretty kewl when I had it enabled. The issue we had was with the charting
engine and we had one app where the developer stored CFCs in the session
scope. The charting engine will not work with session sharing on and
Anyway, say I've got CFMX clustered--one instance on Machine
A and another on Machine B:
If something hoses up CF on Machine B (an endless loop, for
instance), I don't want Machine A's cluster to keep trying to
serve up my CF app from Machine B.
If this is a JRun cluster, it should stop
Is it possible to share sessions without clustering?
(I'd like to be able to know that when I'm hitting Server A, that the
application I'm seeing is coming from Server A. This is for hardware
load-balancing and fail-over reasons.)
Thanks,
Jamie
Thanks for the reply, Nathan.
Let's say that I've considered those options (and I actually have), but decided
to try J2EE session sharing.
The session sharing part works great, however, I *think* I don't want the
application sharing bit, but maybe someone can talk me out of my reservations
Let me know if I'm getting it. ;)
Yes, and thanks a ton for sticking with this thread...
I think the problem boils down to your HW LB device being smart enough.
I am guessing you have layer 4 monitoring on your servers, aka, If I
can ping it, it's alive. That's not usually good enough. Use
Ok, I see, I think I get it. :D
You've got A and B. A is the primary and it is offloading some
processing to B through your JRun cluster. In this case, you don't need
a hardware load balancer, as your site is on one real server.
Right now, server B doesn't have/need/use an HTTP server. Run a
After a lot of struggling, I've got CFMX 6.1 clustered across two
machines, and it is sharing J2EE sessions. That much is great, and is
exactly what I hoped it would be.
The only problem, is it's somewhat *more* than I was hoping for:
I wasn't expecting anything more than *sessions* to
Thanks (once again) Dave.
Our Apache admin is out for the day, so I'm trying to interpret your
instructions myself (but am having a tough time following them).
-The way I've dealt with this in the past is to set up each CFMX instance
-with its own web server (either the JRun web server or a
Try registering the JRun Admin server of the remote machine also, and
*hopefully* you should be able to now stop/start the remote servers.
It turned out to be that I needed some additional entries in my /etc/hosts file.
Thanks,
Jamie
After a lot of struggling, I've got CFMX 6.1 clustered across two machines, and
it is sharing J2EE sessions. That much is great, and is exactly what I hoped it
would be.
The only problem, is it's somewhat *more* than I was hoping for:
I wasn't expecting anything more than *sessions* to be
Say I've got a structure of structures:
variables.transportation.boat.aluminum.jon
What's the correct way to test for the the definition of, say, the jon var,
if I'm also unsure of the presence of the containing struct(s)?
Thanks,
Jamie
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
The ideal solution would be transparent to the application and
wouldn't put any undue restrictions on schema.
Which datatypes do you intend to use? CLOB / text or just small
varchar fields and integers? Stored procedures / DB side
= As usual, the system operating normally isn't half as interesting
= as the system failing :-) Could you describe acceptable and
= unacceptable consequences of failures?
=
= For instance, if one database goes down, is it acceptable to have:
= - a few seconds dataloss?
Yes, a few seconds is
You should consider a setup where your website connects to a
master DB and performs any queries it needs to do there. That DB
is replicated to another DB on another machine using a
replication daemon. Replication takes place every (few) second(s)
by the replication daemon.
From the
What's the recommended way to do bulletproof DB clustering?
We do a lot of (sometimes large) surveys, and the primary reason I want to do
DB clustering is for automatic failover (in the event of one DB server's
meltdown).
On the last big survey I did, I created CF code that did the failover
So is your question How can I cluster mySQL?
You want to focus on the replication end between multiple nodes. I'm
not sure what mySQLs capabilities are. Have a failover system, not a
load balanced system. (i.e. no need for the Radware... save those
ports for your webservers)
-Adam
Thanks for
[EMAIL PROTECTED] wrote:
Also this is just one option: The solution doesn't have to involve
MySQL at all; I just want the cheapest, most perfect solution (of
course ;).
In order to help you with that, we need a more elaborate list of
criteria. For instance, against which events
Well then, I recommend Oracle 10g. But if price is an option msSQL can
cluster nicely as well. Almost all enterprise dbs have some sort of
hot and cold replication / backups. The major difference between the
two, does it require a manual procedure to switch to the failover? The
cheapest easiest
Well as far as I'm aware it's been this way since the release of
ColdFusion MX and I'd be surprised if they changed it in 7 -- I think
it was actually intentional... the reason being that if you were to
use cfinclude or cfmodule inside of a function created with the
cffunction tag, the relative
The value of GetBaseTemplatePath() should exhibit the behavior you're
saying you're getting from GetCurrentTemplatePath() when called from
within Application.cfm...
Yes, and the base template is the one that you see in the URL, correct?
However... getCurrentTemplatePath() will provide varried
[my last post had some stuff stripped out of it (by the HoF posting mechanism?)
trying again]
-The value of GetBaseTemplatePath() should exhibit the behavior you're
-saying you're getting from GetCurrentTemplatePath() when called from
-within Application.cfm...
Yes, and the base template is the
-Yes, my reading of the docs agree that if you call
-getCurrentTemplatePath() inside Application.cfm, it should return the
-path of that Application.cfm file.
Okay, S. Isaac seems to suggest that it misbehaves when: An external template
calls a cfscript-defined UDF that, in turn, calls
The documentation claims that GetCurrentTemplatePath() returns The absolute
path of the page that contains the call to this function, as a string.
This is probably true of most callers, but it's not true when Application.cfm
is the calling page. The returned path varies, depending upon which
29 matches
Mail list logo
