Installing Mantis On Iisj
Mar 27, 2013 Hello, I've desperately tried to install MantisBT using following setup: IIS 7 (with SQL native driver for PHP 3.0) PHP 5.4.12 SQL Server 2008 Express. Hello, I've desperately tried to install MantisBT using following setup: IIS 7 (with SQL native driver for PHP 3.0) PHP 5.4.12 SQL Server 2008 Express.
Installing Mantis On Windows
As part of the MantisBT development team I can tell you that although there is code support for MS SQL Server, there are many issues with it. The cause of the problem is that none of the developers - or contributing users - are running an SQL Server installation and we're not aware of any free setups which we can use to the SQL Server. Long story short: it probably doesn't work out of the box, but you might force it into running by patching it. If you do, please contribute those changes back, as there are many users which reported problems with SQL Server.
One of the first tasks in my new job was to install bug-reporting software for in-house development. I have used Mantis Bug Tracker (before and found it easy-to-use and not overloaded with unnecessary features. To use Mantis Bug Tracker, PHP needs to be installed first. Since the servers are Windows servers, PHP must be configured with IIS. My installation notes are listed below. Install PHP. Download PHP - 5.2.5-Win32.zip (binaries - NOT installer) - provided.
Extract zipped PHP and save to C: php. Rename php.ini-dist to php.ini (This file is in the root folder.). Add C: php to the Path variable. (Optional). In the PHP folder, locate the files php5ts.dll and phpmssql.dll and place them in the C: windows folder so they can be accessed.
Configure PHP.ini. To configure mail on PHP, locate the line 'SMTP' and add the SMTP mail host and port. The following must be done so that PHP will work with IIS. To get PHP to work as a CGI for IIS, change:; cgi.forceredirect = 1 to: cgi.forceredirect = 0. To set up PHP to work with MS SQL, uncomment the following line under extensions: extension=phpmssql.dll Configure IIS and PHP to work together This assumes that IIS is already installed on the web server.
First, create a new folder on the web server to store the PHP web files. Click Start - Settings - Control Panel. Double-click Administrative Tools. Double-click Internet Services Manager. On the Tree tab on the left, click the plus sign beside your computer's name. Under the 'Development' node under 'Web Sites', right click on 'Development' and create a new Virtual Directory for the PHP websites named PHPWeb. Browse to the new folder created at the beginning of this section.
Choose read/write/access options that you wish to include (can be changed later) and 'Finish' to create. This closes the wizard too. Right click on 'Development' and view Properties. Choose the Home Directory tab, then choose Configuration (near the bottom) 8. Click Add, then Browse. Navigate to C: PHP php-cgi.exe, and select this. Add in.php as the extension, and tick Check that file exists.
Now click OK on all subsequent windows, and exit Internet Services Manager. Right click on the new directory PHPWeb.
Click the 'Documents' tab. Add index.php to the list of default content pages. Configure PHP and MSSQL 1. Download a new copy of ntwdblib.dll - provided. (The one packaged with PHP5 is out of date, so it won't work if it's not replaced.) 2. Copy the file into the c: php (root) folder.
Also place a copy of the file in c: windows system32 MS SQL Database server The 'mixed' SQL access should be selected; it is by default on the SQL server. Nothing needs changed. New users can be set up for accessing Mantis Bug Tracker. Create a new user for Mantis. Installing Mantis 1.
Download a copy of Mantis. Mantis 1.1.0 is what was used for this installation. Unzip this and put it into the new folder that was previously created for storing the PHP pages on the web server. If the database for Mantis has not been set up, you will be prompted to type in password/usernames/host for the database to install the 'bugtracker' database that Mantis uses.
Type in the database host. If MSSQL is configured correctly and the password and username is correct, the database creation for Mantis will be successful.