Jump to content

RAIC & Scripts...


This topic is 7178 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Has anyone tried running a "-script" tag on a FMP RAIC server system that has multipe machines serving the DB that the script is from.

If a set of DB's is hosted on a machine running FMP Server, and 5 other machines are clients to that server, which are then "sharing" those same DBs with an Apache server running WSC does the actual "running" of the script take place on the 5 'client' machines or on the Server? Or Both?

The big question is would it be possible to access _other_ data (not another script) in the same DB that a script was being run from IF it were on a different one of these clients?


Link to comment
Share on other sites

The script will run on first available machine. And then what? When next visitor get allocated to the same machine with anything, the last result from script will be gone...

I still did not found the need for scripts. What so marvelous will script achieve and HTML page not?

Link to comment
Share on other sites

I've got a scheduled script that pulls email from a POP account into a DB, and then I need to access portions of that email (subject for example) via the web.

So the web user does not need to actually "RUN" the script, just access the data AFTER the script has finished.

It doesn't mater if the web user gets the "latest" data from these emails, as long as their request isn't stopping the script from downloading the messages. (mail is downloaded every 10 mins or so, and takes aprox 15-20 seconds)

So I was thinking that a RAIC might solve my problem if while the script was executing (ie getting the email) the web requests were handled by other machines all serving data from the same DB hosted by FM Server.

The big questions is, will these web requests still be able to access the data? Or will they have to wait for the script to finish (or worse interupt it) even though the script is actually being executed by a client machine that is also sharing the DB?


Link to comment
Share on other sites

My best guess is that machine which will respond first will get the job.

Otherwise, it should work. Usually the script is cancelled by request only when it is in PAUSE stage. Otherwise the machine will be busy and connector will call another Unlimited to work.

IMHO, best will be to let standard FM to update the files on server, not Unlimited serving web.

The records added to server will be immediately available to the clients. By adding I mean when FM server will create record, populate it with data and update the indexes if they are any.

Link to comment
Share on other sites

That's excellent Anatoli!

I hadn't thought of using a "standard" FMP to do the 'script' work...

That way there would be NO opportunity for a web request to be hindered in any way!!

And I've got an 'extra' standard copy of FMP 5 that came with Developer!

That saves me about $999 for that 'extra' copy of Unlimited!

I'll give that a try, and let you know how it works out (my FMP Server is supposed to arrive tomorrow).


Link to comment
Share on other sites

This topic is 7178 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By cmbhatt
      I would like to install FM Pro 5 and FM pro unlimmited on 1 box. However, I want to only use the FM pro Unlimited for the web companant. Is this possible? If it isn't why wouldn't it, since only thing is being used is the FM Pro unlimited web componant.
    • By victorkhugo
      I'm trying to modify a web page. Everytime I look at it live, I'm seeing the old page. I've done the Misc. Script command to Flush Cache, but nothing happens.
      Is there something more radical I can do to flush the cache?
    • By kdd
      I'm new to the group and have a quick question...
      I'm setting up an online database for teachers to enter homework assignments for their students.
      Is it possible to set up an input field that shows simple paragraph formatting (line breaks and paragraph returns)? I am only able to get a solid body of text. And could this be done while copying and pasting from a word document?
      Any suggestions?
    • By jepar
      Hi Folks!
      There seems to have been confusions on this forum about FMPro Unlimited and FMPro Server!
      1. FMPro Server
      a) Can be accessed with FMPro only
      : Cannot act as HTML server
      c) Run only as an NT Service
      2. FMPro Unlimitted
      a) Can be accessed with FMPro
      : Can distribute web pages
      c) Does not run as an NT Service by default
      *** If you want to serve web pages, you need FMPro Unlimited (or FMPro)!
      1. If NT reboots, you have to log-in and restart your database.
      2. You're then faced with the dilemma:
      a) if you lock the server, others can't access it
      if you don't lock it, your network is left wide open
      *** You want FMPro Unlimited to run as a service! It will restart itself after a reboot AND will not interfere with other users or administrator who need to logon to the server (or the workstation).
      *** This will work with NT Server or Workstation: you can use NT Workstation to run FMPro Server or Unlimited since nobody will use the file or print services, therefore you are complying with the license agreement.
      1. We use FMPro Server on NT Server A and FMPro Unlimitted on NT Server B.
      2. Database files are on Server A.
      3. FMPro Unlimited on Server B connects to FMPro Server on Server A to access the database files.
      4. Users can access Server A with their FMPro or Server B with their browser.
      5. All database accesses are password-protected.
      Here is my 3 step solution to have FMPro Unlimited on Server B running as a service (could be more fancy but this is simple):

      1. Download, install and configure SRVANY:
      a) Download the code form http://vbwire.com/advanced/howto/srvany.zip
      Unzip and drop the SRVANY.EXE and INSTSRV.EXE files in C:WINNTSYSTEM32
      c) Run this at the command prompt:
      >c:winntsystem32instsrv.exe "Filemaker Pro Unlimited" c:winntsystem32srvany.exe
      d) Then run (at the command prompt):
      e) Create a key called "Parameters" under:
      HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesFilemaker Pro Unlimited
      f) Create a value called "Application" under:
      HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesFilemaker Pro UnlimitedParameters
      of type REG_SZ and enter the string:
      C:Program FilesFilemakerFilemaker Pro 5FileMaker Pro.exe
      g) Create a value called "AppParameters" under:
      HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesFilemaker Pro UnlimitedParameters
      of type REG_SZ and enter the string:
      C:Program FilesFilemakerFilemaker Pro 5Startup.FP5
      h) Launch the "Services" control panel, double-click on the "Filemaker Pro Unlimited" service, select "Log on: This Account" and enter the user name and password of your network administrator.
      *** Or create a filemaker pro user with admin rights and password set not to expire.

      2. Create a "Startup.FP5" with an autorun script.
      a) Create a new database with no fields under:
      C:Program FilesFilemakerFilemaker Pro 5Startup.FP5
      Create a script called "Startup" that will open each database that your server will need.
      *** For example, to open FILE.FP5 from Server A, you will get:
      Open["File.fp5 (*)"]
      c) Under "File/Access Privileges/Password" just enter the SAME password that has access to all the files that you want to open and click on "Done".
      d) Under "Edit/Preferences/Document", click on "Try default password" and enter the same password, then click on the first "Perform Script" and select the "Startup" script you've created.

      3. Step 3? There is no sept 3! Just wait until NT reboots: it should not take very long
      Or just start the Filemaker Pro Unlimited Service under the Services control panel and log out.
      Go get a coffea. Go have a walk outside and enjoy the sun. You've just saved yourself a lot of grief!
    • By Randy Abulon
      Has anyone tried the connector on Windows 2000 and had some success with it? The company I work for just got FMPro5 Unlimited, but we mostly a Win2K shop; including the intranet server... How do I make it work?
  • Who Viewed the Topic

    2 members have viewed this topic:
    Ocean West  comment 
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.