View Issue Details

IDProjectCategoryView StatusLast Update
0010131mantisbtdb mssqlpublic2014-05-16 15:00
Reporterflyn Assigned Tograngeway  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
PlatformLinuxOSFedoraOS Version10
Product Version1.1.4 
Summary0010131: MS-SQL backend driver broken
Description

We have a mantis installation that uses MS-SQL as its backend database. We have
found that this component has an error that keeps it from working.

Configuring the MS-SQL backend will fail when executed from the web-based admin
tool. The following error is logged to Apache's log:

...call to undefined function mssql_get_last_message () in
/usr/share/mantis/core/adodb/drivers/adodb-mssql.inc.php...

Steps To Reproduce

Install mantis and configure to use the MS-SQL backend.

Additional Information

As a temporary work around, I modified
/usr/share/mantis/core/adodb/drivers/adodb-mssql.inc.php to use the static
string "unknown" instead of calling undefined function mssql_get_last_message
(). This was done in two places within the source file. Once this was done, the
MS-SQL backend operated as expected.

See also https://bugzilla.redhat.com/show_bug.cgi?id=484428.

TagsNo tags attached.

Activities

giallu

giallu

2009-02-14 16:23

reporter   ~0020844

Paul, feel free to ping me if you need any assistance from the Fedora side of things

thE_iNviNciblE

thE_iNviNciblE

2009-06-03 10:02

reporter   ~0022040

Please fix it ASAP :-)

its a long time assigned...

grangeway

grangeway

2009-06-28 14:25

reporter   ~0022304

Hello the_invincible, flyn, giallu.

This looks like an issue with your setup.

I'd be inclined to try running the following script:

<?php
var_dump(function_exists('mssql_connect'));
var_dump(function_exists('mssql_get_last_message'));
?>

If this returns, false/false - then it looks like you haven't got mssql setup correctly in php. I can probably give some advice on how to compile php with freetds to do this. Alternatively, i'm sure giallu can give advice on what packages in fedora are required.

If this returns true/false and you are running a fedora package, please raise a bug with fedora on this - I've confirmed with a member of the php development team that this function should exist fine.

I'd be interested to know what's going on here if you could feedback.

Paul

giallu

giallu

2009-06-28 16:54

reporter   ~0022305

for the records, "yum install php-mssql" on my Fedora 11 wants to install:

php-mssql x86_64 5.2.9-2.fc11 fedora 42 k
Installing for dependencies:
freetds x86_64 0.82-5.fc11 fedora 1.0 M
unixODBC x86_64 2.2.14-2.fc11 fedora 477 k

so it should be enough to get it running

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040370

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
Paul