The CopyStorm/Director Job Editor supports the creation and editing of jobs and tasks. Its capabilities are a subset of the primary stand-along — for more information see the documentation.
The web-based Job Editor differs from the stand-alone Job Editor in the following ways:
It cannot be used to start or stop tasks.
It cannot launch the CopyStorm or CopyStorm/Medic GUI.
The CopyStorm/Director web tool includes a dashboard suitable for interactive job monitoring.
All active jobs are listed in the top half of the dialog, along with the status of the most recent run.
When a job is running, the bottom half of the dialog displays the log file generated by the job as it is running.
When the job completes the log file viewer disappears.
Above the job list are a handful of parameters controlling the display characteristics of the page, including:
How often the CopyStorm/Director database is polled.
How many running tasks are displayed per row.
How many rows and columns are displayed for a log file.
In addition, the hyperlinks in the job list will open an editor for the selected job. This editor is web-based and contains a subset of the functionality of the Java-based editor.
The CopyStorm/Director Job Searcher searches for jobs defined in the CopyStorm/Director database.
If your organization is not managing 100s of CopyStorm backups, the only control you may need is the “Search for Jobs” button.
The top portion of the page contains parameters limiting the jobs returned when the “Search for Jobs” button is clicked. You can find descriptions for these parameters on the page.
The bottom part of the page contains jobs found in the most recent search.
In addition, the hyperlinks in the job list will open an editor for the selected job. This editor is web-based and contains a subset of the functionality of the Java-based editor.
The CopyStorm/Director GUI is distributed in two formats — a stand-alone Java application and a web browser application. In most situations either (or both) applications can be used to edit or view the CopyStorm/Director database and the choice of which to use is up to your organization.
The stand-alone Java application has a few more capabilities than the web browser application, most of which are related to its ability to stop and start local processes.
The primary advantage of the web application is that it can run anywhere on your network. In addition it has a dynamic dashboard suitable for near real-time monitoring of CopyStorm backups.
Setting up the web browser application is slightly more complex than the “unzip and go” approach of the Java application.
Note that the following instructions apply to Tomcat versions up to but NOT including Tomcat 10. Tomcat 8 and Tomcat 9 will work fine.
Due to the fact that the Tomcat service is not running as a SQL Server User with privileges to connect to the database, steps need to be taken to configure Director when using SQL Server as the backing data source.
Create a user by going to Start => Settings => Accounts => Family & other users => Add someone else to this PC (click on “I don’t have this person’s sign-in information”) => Add a user without a Microsoft account
Once this user is created (for example, SqlServerTomcat), change the Account Type to Administrator
Right click on the Tomcat service in the Windows Services window and select Properties from the drop-down menu. On the Log On tab of this view, click the This Account radio button, and enter the account name that was just created (precede this name with a ‘/’) and enter the password you used when creating the user.
The CopyStorm/Director web application uses a datasource with the resource name “jdbc/CopyStormDirector”.
The entry should look like the following example from our test servers:
The CopyStorm/Director web application is packaged in a file located at:
[CopyStorm/Director install directory]/war/CopyStormDirector.war
There are several ways to deploy the war file. Your Apache/Tomcat administrator will know how to deploy it using your organizations standards.
Open the URL and you should see a screen like:
In SQL Server Management Studio, expand the Security => Logins folders and right click on the Logins folder and choose New Login. Enter the name of the user just created and make sure the Windows Authentication radio button is checked.
On the same dialog, switch to the User Mapping page and click the SQL Server database holding the Director data, and then give the user the db_owner role.
If your \Windows\system32 folder does not have the sqljdbc_auth.dll file then it is going to need to be downloaded and placed into that folder. The following link can be used to download sqljdbc_6.0.8112.200_enu.tar.gz
Upon expanding this gzip/tar file, one will find the DLL In the enu/auth/x64 folder.
Database
Driver Jar File
Oracle
ojdbc8.jar
SQL Server
sqljdbc42.jar
PostgreSQL
<Resource name="jdbc/CopyStormDirector"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
validationQuery="SELECT 1"
testOnBorrow="true"
username="root"
password="supesecretpassword"
url="jdbc:postgresql://localhost/copystormjob"
driverClassName="org.postgresql.Driver"
/>postgresql-42.4.0.jar
MySQL
mysql-jdbc-7.0.0.jre8.jar
The CopyStorm/Director Global Parameters page is used to specify the locations for CopyStorm/Director configuration data. The web-based editor’s capabilities are a subset of the primary stand-alone . For more information see the stand-alone .
