View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0009742 | mantisbt | db mssql | public | 2008-10-24 07:13 | 2015-03-15 19:58 |
Reporter | neethuv | Assigned To | dregad | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Target Version | 1.3.0-beta.2 | Fixed in Version | 1.3.0-beta.2 | ||
Summary | 0009742: Unable to install Mantis 1.1.2 with MS SQL | ||||
Description | I have to install manis with SQL server 2005 express. I have downloaded mantis 1.1.2. Downloded wamp server supporting PHP 5.2.6 . config_inc.php file was modified as But I am getting the error Please provide the necessary steps that need to be done to install mantis. Whether mantis will work fine with MS SQL. | ||||
Tags | No tags attached. | ||||
Attached Files | config_inc.php (2,608 bytes)
<?php # Mantis - a php based bugtracking system # Copyright (C) 2000 - 2002 Kenzaburo Ito - kenito@300baud.org # Copyright (C) 2002 - 2007 Mantis Team - mantisbt-dev@lists.sourceforge.net # Mantis is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 2 of the License, or # (at your option) any later version. # # Mantis is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with Mantis. If not, see <http://www.gnu.org/licenses/>. # -------------------------------------------------------- # $Id: config_inc.php.sample,v 1.19.2.2 2007-10-25 17:13:42 giallu Exp $ # -------------------------------------------------------- # This sample file contains the essential files that you MUST # configure to your specific settings. You may override settings # from config_defaults_inc.php by assigning new values in this file # Rename this file to config_inc.php after configuration. ########################################################################### # CONFIGURATION VARIABLES ########################################################################### # In general the value OFF means the feature is disabled and ON means the # feature is enabled. Any other cases will have an explanation. # Look in http://www.mantisbt.org/manual or config_defaults_inc.php for more # detailed comments. # --- database variables --------- # set these values to match your setup $g_hostname = "Driver={SQL Server};SERVER=C114USS;DATABASE=test1;UID=mantis;PWD=mantis;"; $g_db_username = "mantis"; $g_db_password = "mantis"; $g_database_name = "test1"; $g_db_type = "odbc_mssql"; # --- email variables ------------- $g_administrator_email = 'administrator@example.com'; $g_webmaster_email = 'webmaster@example.com'; # the "From: " field in emails $g_from_email = 'noreply@example.com'; # the return address for bounced mail $g_return_path_email = 'admin@example.com'; # --- file upload settings -------- # This is the master setting to disable *all* file uploading functionality # # The default value is ON but you must make sure file uploading is enabled # in PHP as well. You may need to add "file_uploads = TRUE" to your php.ini. $g_allow_file_upload = ON; ?> | ||||
You need to install and enable the mssql extensions for PHP before you can use Mantis with an MSSQL database. You'll need to look at the PHP documentation and the documentation for your WAMP stack to figure out how to do this. |
|
Getting the following Attached error (Bad Does the Adminstrator have access to the database) The user created in the SQl server has sys admin privilege. i have enabled the php extension for ms sql in the php.ini file TCP/IP connections on port 1433 is enabled. Set the following settings in php.ini file also checked the ms sql connectivitiy <?php if (function_exists('mssql_connect')) ?> This is also working fine. But still unable to install mantis. The error that is displayed seems to be not the actual error. The actual error cannot be identified. |
|
please provide the necessary steps by which i can install mantis with MS SQL |
|
Marking as Suspended MSSQL support is currently known broken. We are going to be replacing the DB Layer in Mantis to fix this properly after the next release. I'd strongly advise using MYSQL for now. The new DB layer already contains the appropriate fixes for MS SQL Support. |
|
MSSQL support is currently known broken. We are going to be replacing the DB Layer in Mantis to fix this properly after the next release. I'd strongly advise using MYSQL for now. The new DB layer already contains the appropriate fixes for MS SQL Support. |
|
MantisBT currently supports Mysql and has support for other database engines. The support for other databases is known to be problematic. Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer. If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org In the meantime, I'd advise running Mantis with Mysql Only to avoid issues. Thanks |
|
Despite the fact that I am not actually able to test whether the problem is truly resolved since I don't have access to a MSSQL server setup, I'm marking this issue as fixed in 1.3.x on the grounds that the recent updates in ADOdb (which contain many improvements in the MSSQL driver) are likely to address it. Should the problem persist (using a nightly build or a version > 1.3.0-beta.1), feel free to reopen this issue or to create a new one. |
|