I am evaluating various bug tracking systems for my organization, and I believe that mantis may be the way to go. For better or worse, SQL Server is the database that we have at work that I can use.
On the features list, it says SQL Server is supported. In the forums, however, I see lots of people asking how to get SQL Server to work. Not sure if it was officially added after those posts. So, I guess my question is this: does the latest version of mantis work out of the box with SQL Server?
If YES: What is the format for the $g_hostname variable? It says "connection string", but I don't know how I should format that. Are there any samples for mssql? I've only found references to obdc_mssql strings.
If NO: What are the steps to support SQL Server? Is there a list of steps? I've heard of people fixing the queries and the like. Have any of them ever posted a summary anywhere?
thanks, David
Is MS SQL Server supported?
Moderators: Developer, Contributor
Mantis works fine with MS SQL out of the box. You should not need to do any tuning to queries. The trick is setting up the data required during installation. I did a couple of installations before. I think you need to specify the SERVER NAME\INSTANCE in the host name.
I would suggest you go to the IRC channel and check with paulr. He uses Mantis on MS SQL and he may remember the exact settings. Once you get it working, please reply here so that I include it in the docos. I should have done it last time.
I would suggest you go to the IRC channel and check with paulr. He uses Mantis on MS SQL and he may remember the exact settings. Once you get it working, please reply here so that I include it in the docos. I should have done it last time.
Hi
I´ve just installed Mantis in SQL Server 2000, and the trick is to create te database and one admin user and one normal user, then install mantis.
Works fine for, except for attachments, i wanted to upload them to the database, and it as problems converting the attachments. in Sql Server the field is created as image, instead of mysql longblob, even changing to binary doesn´t work for me.
I´m importing to filesystem now.
best regards
I´ve just installed Mantis in SQL Server 2000, and the trick is to create te database and one admin user and one normal user, then install mantis.
Works fine for, except for attachments, i wanted to upload them to the database, and it as problems converting the attachments. in Sql Server the field is created as image, instead of mysql longblob, even changing to binary doesn´t work for me.
I´m importing to filesystem now.
best regards
Nuno Ferreira da Costa
Is MS SQL Server supported?
Hooray! This was really easy. I'm using SQL Server 2005. Mantis is version 1.0.6. Running Apache 2.2.3 on Win XP Pro.
A few notes:
-- Right now, my web & db server are the same. Will need to separate before going to production. I just used my machine name for the db server.
-- I created a user called "mantis" for the database user. Until the database existed, however, I couldn't assign it any privileges (I wasn't going to give it system-wide access).
-- I used the sa user for the admin user.
-- The install program created the database, but the checks failed.
-- I assigned the mantis user to the database and gave it some privileges.
-- Hit the retry button on the install script, and all my tests passed.
-- System seems to work just fine, but haven't put it thru the paces yet. Was able to add an attachment to a sample item, but when I download it, it is corrupted.
Will prob use file attachments anyhow, so no biggie.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Here are my install notes:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Moved all uncompressed mantis files to C:\Apache\htdocs\tracker
SQL Server - Security - Logins - new
user: mantis
pass: *****
load http://isdm23.[domain].org/tracker/admin/install.php
type: SQL Server
hostname: isdm23
database user: mantis
database pass: *****
database name: bugtracker
admin: sa
admin pwd: ******
Print SQL: No
-- got a bunch of errors cuz mantis lacks permissions (I couldn't assign
it permissions on a database that doesn't exist!)
-- went back to mantis user > properties > user mapping > checked mantis db
-- went to bugtracker db > security > users > mantis > properties > general >
added roles db_accessadmin, db_datareader, db_datawriter, db_owner
-- hit retry button on web page, everything worked!
A few notes:
-- Right now, my web & db server are the same. Will need to separate before going to production. I just used my machine name for the db server.
-- I created a user called "mantis" for the database user. Until the database existed, however, I couldn't assign it any privileges (I wasn't going to give it system-wide access).
-- I used the sa user for the admin user.
-- The install program created the database, but the checks failed.
-- I assigned the mantis user to the database and gave it some privileges.
-- Hit the retry button on the install script, and all my tests passed.
-- System seems to work just fine, but haven't put it thru the paces yet. Was able to add an attachment to a sample item, but when I download it, it is corrupted.
Will prob use file attachments anyhow, so no biggie. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Here are my install notes:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Moved all uncompressed mantis files to C:\Apache\htdocs\tracker
SQL Server - Security - Logins - new
user: mantis
pass: *****
load http://isdm23.[domain].org/tracker/admin/install.php
type: SQL Server
hostname: isdm23
database user: mantis
database pass: *****
database name: bugtracker
admin: sa
admin pwd: ******
Print SQL: No
-- got a bunch of errors cuz mantis lacks permissions (I couldn't assign
it permissions on a database that doesn't exist!)
-- went back to mantis user > properties > user mapping > checked mantis db
-- went to bugtracker db > security > users > mantis > properties > general >
added roles db_accessadmin, db_datareader, db_datawriter, db_owner
-- hit retry button on web page, everything worked!
How are you importing to filesystem?costanm wrote:Hi
I´ve just installed Mantis in SQL Server 2000, and the trick is to create te database and one admin user and one normal user, then install mantis.
Works fine for, except for attachments, i wanted to upload them to the database, and it as problems converting the attachments. in Sql Server the field is created as image, instead of mysql longblob, even changing to binary doesn´t work for me.
I´m importing to filesystem now.
best regards
What are the settings and config options we have to use.
Thanks