Mantis: 1.1.6
Database:
- Domain SQL Server (not local)
- Operating System: Microsoft Windows Server 2003 R2
- Microsoft SQL Server 2005 (not Express)
- Default Named Instance (./SQLSERVER)
- TCP/IP Enabled to Default Port (1433)
- Named Pipes Enabled
- Domain Web Server (local for Mantis Install)
- Operating System: Microsoft Windows Server 2003 SP2
- IIS 6.0
Having spent DAYS trying to get PHP and Mantisbt to work correctly, and having read ALOT of forums posts on various problems encountered by others, and numerous solutions, I am still stuck. I'm hoping this post will help collate many solution posts, and hopefully get me an answer as to what I've done wrong to prevent mantisbt from installing.
Error Message:
When installing, I get this error message:
Installing:BAD
database is not supported by PHP. Check that it has been compiled into your server.
So I was asked by my new boss to install mantisbt (last week) as he's used it before and believes it would be useful. I had/have no idea what mantisbt is, my only concern is installing it. It needs to be installed onto our web server, and it needs to create/connect to a database on our SQL Server (2 separate machines).
The first thing I downloaded was the latest stable release:http://www.mantisbt.org/download.php.
From there I read an administration guide, and found an installation guide:http://manual.mantisbt.org/manual.installation.php
In the guide it explained that I needed PHP to be running on our web sever...
So I downloaded a PHP package which I believe to be the latest, from http://www.php.net/downloads.php. I placed all the PHP files on the webserver in the directory "C:\PHP".
I then loosely followed a PHP installation guide found at http://uk.php.net/manual/en/install.windows.php.
I ensured that mssql extension was uncommented, the extension directory was correctly set, the NT security was disabled, and a host of settings that probably have no effect on installing Mantis (such as setting and Upload directory, etc).
I left the php.ini file in my install directory, and having read a couple posts, there is now a copy of it in the Windows directory.
I then set environment variables PHPRC=C:\PHP and ensured C:\PHP was added to my %PATH% variable.
At this stage I decided to test to see if PHP was running (I may have skipped some PHP steps here, but if you follow the manual ""loosely"" you'll be at the same stage as me).
I created a php file to run phpinfo(). I browsed this file from my own laptop (not either of the servers). I got alot of PHP results, and I was confident that PHP was running ok.
I had by this stage extracted the mantisbt files onto the webserver "C:\Inetpub\wwwroot\mantisbt" and was able to navigate to http://ourwebserver/mantisbt/admin/install.php without a problem.
I select "Microsoft SQL Server (experimental)" from the list, I've tried a large number of hostnames including:
- OURSQLSRVR,1433
- OURSQLSRVR
- OURSQLSRVR.ourdomain
- OURSQLSRVR\SQLSERVER
- 192.168.#.# masked the IP on here... just in case
- 192.168.#.#,1433
- 192.168.#.#:1433
- the list goes on...
I have downloaded the latest version of ntwdblib.dll as advised in a number of forum posts, and I've placed it in C:\PHP; C:\PHP\ext; ;C:\win\system32; so I know for sure it can be found anywhere!
Every single time I get exactly the same error message. I've spent way more time on this that I should have done, and I don't know of a single application in this world that deserves so much time for the sake of installing.
So, I'm very annoyed at this whole thing, I am offering virtual cookies and love to the first person that tells me WTF I need to do to make this work?
