Configure MDID3 on Windows 2003

Database

Create a blank database to be used with MDID3 (you need to create a new blank database even if you are upgrading from MDID2):

• Using MySQL:

 mysql -u root
 CREATE DATABASE rooibos CHARACTER SET utf8;
 GRANT ALL PRIVILEGES ON rooibos.* TO rooibos@localhost
   IDENTIFIED BY 'rooibos';
 UPDATE mysql.user SET Select_priv='Y',Insert_priv='Y',
   Update_priv='Y',Delete_priv='Y',Create_priv='Y',
   Drop_priv='Y',Index_priv='Y',Alter_priv='Y'
   WHERE Host='localhost' AND User='rooibos';
 FLUSH PRIVILEGES;
 \q

• Using Microsoft SQL Server:
• Create a new database and user account
• Make the user account owner of the new database
• If you want to run unit tests using SQL Server, give the account the dbcreator server role.

Configuration File

• Copy the template settings file:

 c:
 cd \mdid\rooibos
 copy settings_local.template.py settings_local.py

• Edit the file with notepad or your preferred text editor and customize paths, database settings, etc.:

 notepad settings_local.py

Set up database

 python manage.py syncdb --noinput
 python manage.py createcachetable cache

Configure IIS

• In Server Manager>Roles, add the “Web Server (IIS)” role
• Under Role Services, select “ISAPI Extensions” and “ISAPI Filters”

• Open Administrative Tools>Computer Management>System Tools>Local Users and Groups>Users
• Select Action>New User…
• User name: MDID
• Password: xxx
• User must change password at next logon: unchecked
• User cannot change password: checked
• Password never expires: checked
• Create

• Open Control Panel>Add or Remove Programs
• Select Add/Remove Windows Components
• Check Application Server
• Click Next>

• Open Administrative Tools>Computer Management>Services and Applications>Internet Information Services (IIS) Manager>Application Pools
• Select Action>New>Application Pool…
• Name: MDID
• OK

• Expand Web Sites
• Select Default Web Site
• Select Action>Properties
• Select Home Directory tab
• Application Pool: MDID
• Click Configuration…
• Click Insert…
• Executable: C:\mdid\PyISAPIe\PyISAPIe.dll
• Uncheck Verify that file exists
• OK
• OK
• OK

• Select Action>New>Virtual Directory…
• Alias: static
• Path: C:\mdid\rooibos\static

• Open Administrative Tools>Computer Management>Services and Applications>Internet Information Services (IIS) Manager>Web Service Extensions
• Click Add a new Web service extension…
• Extension name: PyISAPIe
• Click Add…
• Path to file: C:\mdid\PyISAPIe\PyISAPIe.dll
• OK
• Check Set extension status to Allowed
• OK

Change administrator password

Remember to change the administrator password in your installation! By default an admin account is created, you must change the password for that account immediately after the installation. You can do so in Management>Administration>Users.

Schedule full-text indexing

• Grant user permission
• Open Administrative Tools>Local Security Policy
• Select Local Policies>User Rights Assignment
• Double-click Log on as a batch job
• Add MDID user

• Add Scheduled Task
• Select Control Panel>Scheduled Tasks>Add Scheduled Task
• Click Next>
• Click Browse…
• File name: C:\Python25\python.exe
• Click Open
• Name: MDID Full-Text Index
• Select Daily
• Click Next>
• Click Next>
• User name: MDID
• Password: xxx
• Click Next>
• Check Open advanced properties
• Click Finish
• Run: C:\Python25\python.exe C:\mdid\rooibos\manage.py solr index
• Select Schedule tab
• Start time: 12:05 AM
• Click Advanced…
• Check Repeat task
• Every: 5 minutes
• Until Time: 11:55 PM
• Click OK
• Click OK
• Password: xxx
• Click OK

Running

Several background services need to run at all times, unfortunately not all of them have an easy way to install them as a Windows service at this time.

These can be installed in the Task Scheduler to run on startup.

For now, please open a command prompt for each of the following commands:

• Solr full-text index:

 C:
 cd \mdid\solr
 "\Program Files\Java\jre6\bin\java.exe" -jar start.jar

• OpenOffice

 "c:\program files (x86)\openoffice.org 3\program\soffice" -headless -nofirststartwizard -accept=socket,host=localhost,port=8100;urp;

• MDID 3 workers

 C:
 cd \mdid\rooibos
 workers.bat