Several day to day housekeeping tasks are performed on the server using either tools implemented by the CatDV Server Control Panel or native operating system commands. To perform these tasks you will need to be logged on to the machine running CatDV Server.
Control Panel Tools
The Tools menu has the following commands:
Perform Housekeeping – once you have been using the system for a while and deleting many individual clips (as opposed to entire catalogs) it is possible that the database may end up containing some dangling unreferenced data. The housekeeping command should be run occasionally to clean up and reduce the size of the database to make it more efficient. You can also configure the server to perform housekeeping automatically when the server starts up. Note that this command can take a long time to complete.
Empty Recycle Bin – normally when clips are deleted they are moved to the recycle in, and are deleted from there automatically after 14 days or when the bin gets too large. You can manually empty it if required using this command.
Copy Archive Status – there is nothing stopping you importing the same media file more than once resulting in multiple independent clips referring to the same asset, so if you are using the CatDV Archiving Option this command will copy the archive status from any clips that have been archived to other clips with the same media path.
Export Database – dump the entire catdv database to a backup file. This should be done from time to time to supplement your regular backup strategy and also before you update the server or if you need to move the database to another machine.
Import Database – this will import a database dump file created by the Export command and restore the catdv database to that point. Warning: this will replace the entire catdv database as it currently stands and should only be used to restore the entire database after a crash or when moving the database to another machine.
Starting and stopping the CatDV Server
If configured as described above, under Mac OS X and Windows both MySQL and the CatDV Server should start automatically when the server machine is restarted and stop when the machine shuts down. However, during initial set up, for troubleshooting, and when running under Linux or Unix, you may need to start the server manually:
Starting the CatDV Server the first time
- Use the CatDV Control Panel as described above
- Alternatively, under Mac OS X, either restart your computer, or open a Terminal window (Applications > Utilities > Terminal) and type:
sudo /Library/StartupItems/CatDVServer/CatDVServer start
entering your administrator password when requested.
- Under Windows, bring up Start Menu > Control Panel > Administrative Tools > Services and start the CatDV Server service
Running the CatDV Server manually (MacOS X and Linux)
If some problem is stopping the server from starting normally, to aid diagnosis you can run the server from a command prompt so you can see any error messages which may be displayed:
- Launch a terminal window and change directory to the CatDV Server, eg. cd /usr/local/catdvServer , or cd C:Program FilesSquare BoxCatDV Server.
- Under Mac OS X or Unix type the following to start the server running: ./launchServer. If it launches without error you should then see a message similar to the following:
Creating RMI Registry on port 1099 … (various Java system settings displayed for diagnostic purposes) … Catalogs: 0 Clips: 0 Thumbnails: 0 SourceMedias: 0 ImportSources: 0 Max ID: 1 DB Schema: 1.03 Running: MyMacName.local
You are now ready to go and can now start the CatDV client application (from any machine on your local network) and connect to the server from the client application “Server” menu by entering the hostname or IP address of the server machine.
- Leave the server program running and minimise or hide the terminal window. You can stop the server by opening this window and pressing Ctrl-C and can monitor any error messages by viewing the contents of the window.
Stopping the CatDV server
Details of how to shut down the CatDV server depend on how you started it:
- If you are using the CatDV Control Panel you can stop the server from there
- If you are logged on from a CatDV Pro client, you can shut down the server remotely from the Server Admin Panel under the “Server” menu
- If you started it manually from a terminal shell, press Ctrl-C
- If you started with the NT service, bring up Start Menu > Control Panel > Administrative Tools > Services and stop the CatDV Server service (Windows)
- If you started it with a Mac OS X startup item, type
- sudo /Library/StartupItems/CatDVServer/CatDVServer stop
Stopping the MySQL server
In the unlikely event you need to shut down the MySQL server software you can do so. This similarly depends on how you launched it:
- Press the MySQL Stop button in the CatDV Server Control Panel
- Type “/usr/local/mysql/bin/mysqladmin shutdown” (Mac OS X or Linux)
- Type “sudo /Library/StartupItems/MySQL/MySQL stop” (Mac OS X startup item) (or use the MySQL System Preferences item if you installed it)
- Use the Windows “Services” control panel (or type “mysqladmin –u root –psecret shutdown” from a DOS prompt)