INSTALLING MEDIA PILOT 2.1

 

 

Revised 1 August 2008

 

INSTALLING MEDIA PILOT 2.1 Before you start Begin the Installation Additional Components INSTALL PHP 5.2.x CONFIGURING PHP on IIS6 / WINDOWS 2003 SERVER INSTALL Zend Optimizer 3.3 MS SQL Server Creating the MediaPilot Database Creating the Data Source (DSN) Configuring the Product License Configuring PHP.INI for UNICODE Windows Media Services (optional) Web Server Permissions Clip Storage MediaPilot Service Run MediaPilot Logging In

 

Before you start

 

 

Before Installing you should have configured the Windows Server 2000/2003 with IIS (Internet Information Server). By default IIS is not installed on the Server. It can be added by using Windows Components on the Control Panel. The default location for the web site is C:\Inetpub\wwwroot. If you want this site to be located on a different partition or drive, move it before installing MediaPilot or any further components.

MediaPilot requires MS SQL Server. If you do not have a licensed copy of SQL Server installed you may install the included MS SQL Server Express (free) Edition. Note that this edition has some limitations over the full version and is not recommended for medium to large installations.

If MS SQL Server is not yet installed select IGNORE when Data Source Configuration errors are displayed during installation. If this is the case, you will have to manually configure the MediaPilot Data Source after installing SQL Server.

Note that MediaPilot requires .NET Framework 3.0 and MSXML 6.0. Both of these components should already be installed on your Windows Server. If they are not, the MediaPilot installer will install them for you.

Be sure that your Windows Server has the latest Service Packs and updates applied before installation of MediaPilot.

The installation Process, including a new Windows Server installation, should take about 2 hours.

 

 

Begin the Installation

 

 

Run the Setup file (MediaPilotSetup.exe). This will install all the necessary components on your Server.

Additional Components

 

 

If not already installed on your Server, the following included components must also be installed.

Open Windows Explorer and navigate to C:\Program Files\MediaPilot\Installs

 

 

INSTALL PHP 5.2.x

 

 

Internet Information Server (IIS) should be installed and configured on the server before installing PHP.

Locate and run php-5.2.6-win32-installer.msi. Install PHP into C:\PHP

Ensure that PHP is installed with the GD2 and Multi-Byte String Extensions (selected during installation process). This should appear as extension=php_gd2.dll and extension=php_mbstring.dll in the php.ini file.

Note that MediaPilot requires PHP 5.2.5 or higher and is not supported on earlier versions or releases.

 

 

CONFIGURING PHP on IIS6 / WINDOWS 2003 SERVER

 

 

When inspecting the file C:\PHP\PHP.INI the following entries should exist:

extension_dir = "C:\php\ext"

upload_tmp_dir = "C:\php\upload"

session.save_path = "C:\php\session"

It is likely that these settings point to a different folder, so change them to the paths shown. Ensure that the paths exist (C:\php\upload & C:\php\session). If they do not exist, create them now.

Copy all files from C:\Program Files\MediaPilot\Installs\php_ext into the new C:\php\ext folder.

Add the following entry to the php.ini file: extension=MediaPHP.dll

To check that PHP has been correctly installed into IIS open IIS Manager:

• Expand the local computer in the left pane
• Click on "Web Service Extensions" in the left pane

 

 

If "PHP ISAPI Extension" is not listed:

• In the right pane, click the blue underlined text, "Add a new Web service extension..."
• Enter "PHP ISAPI Extension" as the "Extension name"
• Click the "Add..." button and browse to the php5isapi.dll file in your PHP install folder
• Check the "Set extension status to Allowed" checkbox and click "OK"

Right-click on "Web Sites", goto Properties -> Home Directory and change the "Execute permissions" dropdown to "Scripts only".

Check that the .php extension has been added to IIS correctly:

• Expand the local computer in the left pane
• Right-click on "Web Sites" in the left pane, then click "Properties" in the menu that pops up
• Flip to the "Home Directory" tab
• Click "Configuration"
• Flip to the "Mappings" tab

Check if the ".php" extension has been added and is pointing to "C:\PHP\php5isapi.dll". If not:

• Click "Add..."
• Enter the full path to php5isapi.dll in the "Executable" textbox (Browse... to find it more easily if you need to)
• Enter ".php" in the "Extension" textbox
• Select radial button "Limit to", enter "GET,POST,HEAD"
• Click "OK" all the way out

Failing to correctly configure the .php extension in IIS will lead to 404 errors in your browser.

For more information on setting up PHP on Windows Server 2003 see http://www.peterguy.com/php/install_IIS6.html

 

INSTALL Zend Optimizer 3.3

 

 

Internet Information Server (IIS) and PHP should be installed and configured on the server before installing Zend.

Locate and run ZendOptimizer-3.3.3-Windows-i386.exe

The installer should detect your installation of IIS (Internet Information Server). If it does not, you may not have IIS installed and configured on the Server. Go to Windows Components and install IIS first.

The installer will ask for the location of PHP.INI. If you installed PHP into C:\PHP then enter this as the path.

The installer will ask for the location of the web server root. Generally this is C:\Inetpub\wwwroot\

 

 

MS SQL Server

 

 

Install MS SQL Server Express if required. Note that for large sites, it is suggested that full MS SQL Server be deployed on a different Server to the Web Server.

Open Windows Explorer and navigate to C:\Program Files\MediaPilot\Installs\SQL Express

Install MS SQL Server Express (SQLEXPR32.exe)

Be sure to select all Client Connectivity Components during installation of MS SQL Server.

Select Mixed Mode Authentication and enter a password for the "sa" account.

Install SQL Server Management Console (SQLServer2005_SSMSEE.msi)

 

 

Creating the MediaPilot Database

 

 

Open the MS SQL Server Management Studio

Once connected to the Database Server, expand the Databases tree, right-click on Databases and select New Database.

Enter the Database Name of "mediapilot". Depending on your requirements configure the new database, otherwise click OK.

 

 

If this is a new MediaPilot installation:

Locate the file C:\Program Files\MediaPilot\MediaPilot.sql and execute it in MS SQL. This script should execute without error and will create the entire MediaPilot database schema, including users.

Note that a new SQL Server login will be created called "mediapilot" with the password of "123456".

If this login is changed in MS SQL, it must also be changed on the web site. Locate the file

C:\inetpub\wwwroot\mediapilot\dsn.inc and open it using NotePad. Edit the fields as required.

If you are upgrading from a previous version of MediaPilot:

Locate the file C:\Program Files\MediaPilot\MediaPilot.sql and execute it in MS SQL.

 

 

Creating the Data Source (DSN)

 

 

The install process will have already created a DSN entry for you. To check this, navigate to Control Panel, Administrative Tools, Data Sources (ODBC).

To manually create the DSN open the System DSN tab in the ODBC Data Source Administrator and click Add.

Locate SQL Native Client from the Drivers list and click Finish.

Enter the new SQL Server Data Source Name as "mediapilot". Then select the Server from the drop-down list.

The new DSN must use SQL Server authentication (not Integrated Windows authentication). Enter the Login ID of "mediapilot" and the password of "123456", then click Next.

If configured correctly (by running CreateDatabase.sql) the default database should already display "mediapilot" and you can click Next, then Finish.

Before leaving the DSN set-up, click the Test Data Source button to confirm connectivity to the database.

Click OK to close the Data Source Administrator window.

 

 

 

 

 

 

Configuring the Product License

 

 

If you attempt to connect to the MediaPilot website now you will likely get the following error message: Warning: No License for this Product (MediaPilot).

You must manually obtain a License File from Magna Systems and configure PHP to direct it to the MediaPilot license file.

Navigate to your PHP installation (usually C:\PHP) and find the file PHP.INI.

Open PHP.INI using Notepad and locate the [Zend] section near the bottom of the file. If you cannot find this section then you have not correctly installed Zend Optimizer.

Locate the setting zend_optimizer.license_path and set the value so it points to your web server path, e.g.

zend_optimizer.license_path="c:\InetPub\wwwroot\mediapilot"

If this setting cannot be found, add it to the end of the file.

Configuring PHP.INI for UNICODE

 

 

Check that the following section exists in the php.ini file.

[mbstring]

extension=php_mbstring.dll

mbstring.language = Neutral              ; Set default language to Neutral(UTF-8) (default)

mbstring.internal_encoding = UTF-8       ; Set default internal encoding to UTF-8

mbstring.encoding_translation = On       ;  HTTP input encoding translation is enabled

mbstring.http_input = auto               ; Set HTTP input character set dectection to auto

mbstring.http_output = UTF-8                    ; Set HTTP output encoding to UTF-8

mbstring.detect_order = auto                    ; Set default character encoding detection order to auto

mbstring.substitute_character = none            ; Do not print invalid characters

mbstring.func_overload     = 7                  ; All non-multibyte-safe functions are overloaded with the mbstring alternatives

default_charset      = UTF-8                    ; Default character set for auto content type header

 

 

*** IMPORTANT: RESTART THE SERVER NOW even if you have restarted Web Services.

Windows Media Services (optional)

 

 

You may optionally enable Windows Media Services to provide streaming media to your users. This is strongly recommended when dealing with Windows Media files (WMV).

Windows Media Services is a standard part of Windows 2003 Server and can be found under Control Panel / Administrative Services.

Open Windows Media Services and expand the tree so that the Publishing Points are displayed. By default you should have 1 On Demand point and 1 Broadcast Point, both should be Denying New Connections at this stage.

Right-click on the <Default> On-Demand point and select "Allow New Connections".

Select the <Default> On-Demand point and open the "Source" tab. Change the "Content Source" to the "Clips" folder of the MediaPilot website, e.g. D:\wwwroot\mediapilot\clips. If your clips are located on a networks drive, enter the full URI path instead.

When running the MediaPilot Service, be sure to enable MMS Streaming Services.

If you are storing clips on a different server to the web server see the following link on setting up WMS as a Proxy Cache:

http://www.microsoft.com/windows/windowsmedia/howto/articles/cache_proxy.aspx#cacheproxyserver

 

 

Web Server Permissions

 

 

Ensure that these basic permissions have been set using IIS Manager:

1. Open IIS Manager and expand the Web Sites/Default Web Site tree.
2. Right-click on mediapilot and select Properties.
3. Ensure that Read, Log Visits and Index this Resource are checked. All others should be unchecked in the group.
4. Ensure that Execute Permissions is set to Scripts Only.

If these settings are not correct you will receive a HTTP 403 error when accessing any web content.

Full Create/Read/Write/Delete permissions are required for the default IIS User Account on the following mediapilot folders. Alternatively you can assign FULL Control to the "Users" group.

 

 

Assign these folders using Windows explorer (Properties / Security)

• c:\php\upload
• c:\php\session

 

 

Assign these folders using IIS Manager (Permissions)

• wwwroot/mediapilot/thumbs
• wwwroot/mediapilot/thumbs/bin
• wwwroot/mediapilot/public

Generally you can assign FULL CONTROL to the Internet Guest Account (or Users group) for each of these folders.

Note that if you change the base folder for thumbnails in MediaPilot, you must assign similar rights to it.

To check that PHP has been installed correctly, open your web browser and navigate to http://localhost/mediapilot/info.php in the address bar. If you receive a session_start() warning when viewing info.php it indicates that the necessary permissions have not been set on the c:\php\session folder or that the folder does not exist. See the SESSION section in info.php to check the path settings.

 

 

Clip Storage

 

 

MediaPilot does not create Proxy Clips but expects clips to be stored in the defined base clip folder. The default folder is:

wwwroot/mediapilot/clips

Clips are expected to carry the same base name as the DIVA object, e.g. If the DIVA object is "ABCDEF" then the clip is expected to be "ABCDEF.WMV" in wwwroot/mediapilot/clips.

The clips folder can be a virtual web folder pointing to a different volume or drive.

 

 

MediaPilot Service

 

 

The MediaPilot Service has been installed on your web server and can be found from the Start button, All Programs, MediaPilot.

If it has not been set up, enter the Network address of your DIVA Manager PC and then click on the ADO Server box.

Note that the MediaPilot service can be run without a DIVA connection if required.

Configure the Data Link Properties using the same details as used for the DSN. Ensure that the Allow Saving Password option is checked and select "mediapilot" from the Initial catalogue.

Enter your License details EXACTLY as provided to you.

Check the options required. The default settings should be sufficient for initial usage.

Click Start.

If you have successfully connected to DIVA Manager, MediaPilot will begin synchronising all archived objects.

 

Run MediaPilot

 

 

Open your web browser and navigate to http://localhost/mediapilot in the address bar.

You may receive an error message this stage if the configuration has not been completed successfully.

If you receive "Database Connection Failed to mediapilot with UserID mediapilot" - Check the SQL Server Login settings in dsn.inc and in the Database Server.

If you receive a 404 (File Not Found) error it can possibly mean that the web server has not been configured with index.php as the default document. To fix this navigate to Control Panel, Administrative Tools, Internet Information Services (IIS) Manager.

Expand the IIS tree and locate "mediapilot" under Default Web Site. Right-click on "mediapilot" and select Properties. Open the Documents tab and ensure that Enable Default Content Page is checked and that "index.php" is the only entry in the list.

With any issues resolved you should see MediaPilot appear in your web browser. Any conditions that remain outstanding will be checked by the site and reported before login is permitted.

If you have not yet run the MediaPilot service, your web browser will report that a License Name could not be found and that the Release Version is invalid. Run the MediaPilot Service to correct this problem.

 

 

 

 

Logging In

 

 

Log into MediaPilot using the default Administration Account. The User ID is "admin" and the Password is "admin".

By default you will not be able to see any Media Objects in MediaPilot. This is because your account has no access to any DIVA Categories. To modify your access, open the Admin menu and select User Groups.

Only 1 Group initially exists. Select all the required DIVA Categories and click Update.