SQL Server 2016 and Mantis 2.14

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
LucVd
Posts: 3
Joined: 07 May 2018, 08:46

SQL Server 2016 and Mantis 2.14

Post by LucVd »

I have been looking around, and came accross some positive experiences with SQL server and Mantis in the past
We are planning an upgrade from 1.2.19 to 2.14 , and in order to align with standards we are planning to migrate to SQL Server.
Are there recent experiences with this challenge somebody wants to share.

I already struggle with choosing the appropriate $g_db_type : sqlsrv or pdo-sqlsrv

These options throw errors that bring me to this note:
https://www.mantisbt.org/bugs/view.php?id=15437#c40520
LucVd
Posts: 3
Joined: 07 May 2018, 08:46

Re: SQL Server 2016 and Mantis 2.14

Post by LucVd »

Investing a couple of days, I managed to convert a MantisBT 1.2.19 installation on xampp to the version 2.14 on IIS.
It's up and running in this configuration:

-Windows 10 Server
-Microsoft IIS
-PHP 7.2
-SQL Server 2016 Database

The trick was installing the products: "PHP 7.2.2 (x64)" and the "Microsoft Drivers 5.2 (x64) for PHP v7.2 for SQL Server in IIS"
with Microsoft Platform Installer and...

1. configuring: $g_db_type = 'mssqlnative'
in: c:\inetpub\wwwroot\mantisbt\config\config_inc.php

2. adding the right extension to c:\Program Files\PHP\v7.2\php.ini:
extension=php_ldap.dll
extension=php_fileinfo.dll

so far... so good :D
I will need to test all functionality (especially some add-ons)
Meanwhile i regret :cry: the Agile extension from gadiv is not compatible with MantisBT 2.x
Starbuck
Posts: 219
Joined: 14 Feb 2006, 02:53
Location: USA
Contact:

Re: SQL Server 2016 and Mantis 2.14

Post by Starbuck »

It's a new world with this stuff.
You're running Mantis over Windows accessing SQL Server over Windows.
At some point I'm sure we'll see questions about the other combinations:
  • Mantis over Linux accessing SQL Server over Linux
  • Mantis over Linux accessing SQL Server over Windows
  • Mantis over Windows accessing SQL Server over Linux
If you want Mantis to work differently, use or create a plugin. Visit the Plugins forums.
Ask developers to create a plugin that you need - and motivate them to help you!
rasheeda
Posts: 1
Joined: 11 Dec 2018, 14:45

Re: SQL Server 2016 and Mantis 2.14

Post by rasheeda »

Hi Lucvd,

Could you please share the database script for MS SQL server or tools used. Thanks in advance.
Post Reply