View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0006957mantisbtdb mssqlpublic2006-04-19 11:202014-05-16 15:00
Reporterlanwin Assigned Tovboctor  
PrioritynormalSeverityblockReproducibilityN/A
Status closedResolutionfixed 
Product Version1.0.1 
Fixed in Version1.1.0a1 
Summary0006957: installtion fails - administrator have no rights on db
Description

Installion fails, administrator have no rights on db. Because i have used 'SA' (Admin) User.

Additional Information

vb123 gives me a changed install.php (http://mantis.pastebin.com/666808). With this and same settings, the installtion succeed.

TagsNo tags attached.

Relationships

parent of 0007030 closedvboctor Port: installtion fails - administrator have no rights on db 
related to 0006958 closedgrangeway installtion fails with various undefined errors if php version is too old 

Activities

lanwin

lanwin

2006-04-20 03:38

reporter   ~0012633

Last edited: 2006-04-20 03:38

Ive get the same error with version 1.0.2 .

"BAD Does administrative user have access to the database? ( )"
lanwin

lanwin

2006-04-20 04:00

reporter   ~0012634

I have found the bug on Line 354:

<option value="ado_mssql">Microsoft SQL Server ADO (experimental)</option>

ado_mssql isnt correct

<option value="mssql">Microsoft SQL Server ADO (experimental)</option>

is correct
vboctor

vboctor

2006-04-20 06:07

manager   ~0012635

I haven't yet committed a fix to CVS. I would like to make some further investigations first.
lanwin

lanwin

2006-04-20 06:28

reporter   ~0012638

I'm ready to test if you want!
vboctor

vboctor

2006-04-20 09:55

manager   ~0012643

/mantisbt/admin/install.php -> 1.28

or can be retrieved from the following link:
http://mantis.pastebin.com/pastebin.php?dl=671277
vboctor

vboctor

2006-04-20 09:58

manager   ~0012644

This was tested by myself on PHP 4.4.2 and my lanwin on PHP 5.1.2.
grangeway

grangeway

2014-05-16 15:00

reporter   ~0040423

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