The ROVCTD config file is maintained by the ROVCTD tech. It is part of the labview GUI on both the WesternFlyer and RachelCarson. The file is on the Rovctd computer in the C:\CtdGui dir, and named CTDCoeff.ini

*** THE FILE NAME AND PATH ARE CRITICAL !!!! ******

There is a perl program on those computers running as a service that monitors that file every 10 seconds for changes.  If a change occurs, the service grabs the file and writes it to an mssql database.

The database server is currently either Glacierwind (wfly) or Alaskanwind (ptlo).

The database name and table name archiving the cfg file is either DOCR_CTD_Config or VNTA_CTD_Config

The perl script reads the filename to be monitored from table CfgFileMonitorService on the corresponding database. The perl script can actually monitor and archive any/many text files simply by adding them to the CfgFileMonitorServiceTable.

(Legacy note: The perl script **used to ** test the file name internally and if it matched CTDCoeff.ini then it would reformat it and ftp it to an hpux workstation for use at sea. that feature has been disabled. )

 The perl script is in CVS repository on moonjelly in  iag/projects/CoreData

For a complete from-scratch install of the service on the rovctd computer, you will need to:

PRELIMINARIES

The rovctd computer should be named wf-rctd.wf.mbari.org or rc-rctd.rc.mbari.org

The Western Flyer it is has static IP 134.89.20.47 and default user is WF\docricketts

 The Rachel Carson it has statuc IP 134.89.. and default user is RC\ventana

 Almost all of the commands below need to be in "Run As Administrator" mode.

 Make sure that IS has installed the cpu as static IP and with the WF\docricketts or RC\ventana account is given local administrator rights.

INSTALL PERL

Go to http://www.ActiveState.com and download Active Perl free community edition.. (Language>Active Per, and look for the Windows x86 MSI download, click it and download to your desktop.)

Find the windows explorer icon, right-click it and "Run as Administrator"  Navigate to the downloaded msi installer file (probably on desktop or in ~/Downloads) and run it.  Accept all defaults

Open a command window and type perl -v and verify you have a working installation

INSTALL EXTRA PACKAGES

Next find the cmd.exe console icon, r-click and run as administrator.  Then at the prompt, type ppm to run the perl package manager.  It will pop-up the ppm GUI window take about 20 seconds to sync its cfg to the perl repository.

Select View > AllPackages

Then check each of the following packages - if its insalled just skip, else check the little icon to the left of each package to 'mark it for installation'

• Log-Log4Perl
• Log-Dispatch
• Win32Daemon
• String-CRC32
• DBD-ADO

Following are also needed but were already included in most recent (2013) install

• Getopt-Long
• DBI
• Time-Local

When ready, hit the "install selected packages" icon in upper-right of the gui

PREPARE DIRECTORIES AND FILES

Again using the explorer 'run as administrator'....

Create directory C:\Program Files\CfgFileMonitor

Right-click the directory and set perfison for full control to WF\Users or at least WF\DocRicketts etc... This will allow the service to write its log file to the directory

Add perl script  RovCtdCfgFileMonitor.pl  to the directory.

 If its not already there - create a directory C:\Program Files\CTDGUI and put the current CtdCoeff.ini file in it.

INSTALL AND INITIALIZE THE SERVICE

Open a command window again in 'run as administrator' mode.

cd to C:\Program Files\CfgFileMonitor

type:  perl RovCtdCfgFileMonitor.pl -install

it may complain about a type in the dbo package - that is safe to ignore. Your looking for a "service installed" message.  Fix any problems, missing packages or file permissions etc. as needed. But as of 2013 Win7 x86 the above was successful...

SET SERVICE RUN-AS AND AUTOSTART

Now go to ComputerManagement console and navigate to Services Panel.

Highlight the CfgFileMonitor service and r-click, select the LogOn Credentials and chnge from whatever (Local System?) to WF\DocRicketts and Apply

Start the service, and also set to Autostart

In an explorer window, look at the log file in C:\Program Files\CfgFileMonitor directory to see that the service started and is able to connect to database (every 10 seconds by default)

You can touch the CtdCoeff.ini file to and monitor the log file to see that it is detected and pushed to the database.

FINALLY

Reboot the rctd computer and then retest to verify the service restarts itself correctly etc. 

OTHER HINTS

The service most secure if allowed to use windows integrated security as WF\docricketts or RC\ventana  For debug/testing you can modifiy the perl script to use SQLServer managed authentication as expddbo

To remove the service... type perl CfgFileMonitor.pl -remove

Monitor the log periodically, at least annually to keep the log file from getting too big.

REPLICATION TO SHORE

Cfg file data are pulled to shore by sql server jobs run on solstice. The jobs run a XOJO program that pull data to tables in the on-shore expd database.