Testlink with MSSQL

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Testlink with MSSQL

Postby winsorc » Thu Oct 18, 2012 8:57 pm

MS SQL Support

I'm trying to do a fresh install of TestLink on Windows Server 2008 R2 using IIS and MS SQL.

I tried following this http://www.teamst.org/forum/viewtopic.php?f=1&t=6952, however I'm stuck on the install page telling me:
Checking MSSQL Database Failed! MSSQL Database cannot be used.

I have another PHP Page I've written hosted by this webserver that can return results from my SQL Server 2008 Instance.

I go to the phpinfo() page from the IIS PHP Manager settings and I see that sqlsrv is enabled.

Any ideas why TestLink think's its not when it is?

I know this is an open source project but does TestLink support MS SQL And do they plan to support it in the future, I don't really want to run MySQL because we are a MSSQL shop around my office. At the same time I don't want to run something that is unsupported.
winsorc
TestLink user
 
Posts: 2
Joined: Thu Oct 18, 2012 8:32 pm

Re: Testlink with MSSQL

Postby fman » Fri Oct 19, 2012 6:00 am

1. we support MSSQL
2. if you do some searches in the forum you are going to find a COMPLETE explanation done by users that use it with success
3. Please follow the advide you received on the mail confirming you user, same advice that is present on each branch of forum on 'READ BEFORE POST' or something like that.

some info on MSSQL
viewtopic.php?f=25&t=6970

if you search IIS
viewtopic.php?f=1&t=6952&hilit=IIS

if you search MSSQL in forum
viewtopic.php?f=1&t=7002&hilit=MSSQL
fman
Member of TestLink Community
 
Posts: 3059
Joined: Tue Nov 15, 2005 7:19 am

Re: Testlink with MSSQL

Postby winsorc » Fri Oct 19, 2012 3:45 pm

I did search and followed the COMPLETE instructions, however it didn't work with a fresh version testlink 1.9.4.

I did get it working by upgrading to PHP 5.3 from the web platform installer instead of version 5.2 which was what was recommended in step 3 from the complete instructions. I did this because I saw in the install manual for 1.9.4 that there is now php 5.3 support.

If you'd like I'll list out my install instructions once I get finished and I'm able to reproduce them.

fman wrote:1. we support MSSQL
2. if you do some searches in the forum you are going to find a COMPLETE explanation done by users that use it with success
3. Please follow the advide you received on the mail confirming you user, same advice that is present on each branch of forum on 'READ BEFORE POST' or something like that.

some info on MSSQL
viewtopic.php?f=25&t=6970

if you search IIS
viewtopic.php?f=1&t=6952&hilit=IIS

if you search MSSQL in forum
viewtopic.php?f=1&t=7002&hilit=MSSQL
winsorc
TestLink user
 
Posts: 2
Joined: Thu Oct 18, 2012 8:32 pm

Re: Testlink with MSSQL

Postby fman » Fri Oct 19, 2012 8:25 pm

Just now I've reviewed your first post and Oops! I've found you already have followed instructions posted here (apologize for my quick answer).
I've installed without issues 1.9.4 using XAMPP ( I do not like IIS) and MSSQL 2008 express, without any special steps.
It would be great if you provide a document that will be useful for others.
fman
Member of TestLink Community
 
Posts: 3059
Joined: Tue Nov 15, 2005 7:19 am

Re: Testlink with MSSQL

Postby abrjib0 » Fri Feb 15, 2013 1:06 am

Hi Guys,

As many of our friends did, I have also searched within Testlink Forum and in Google to find any concrete steps or instructions to install TestLink with MSSQL. Could anyone please provide an instruction to install the latest Testlink 1.9.5 using a MSSQL DB? We also plan to use LDAP and JIRA with testlink. Any support in this matter is highly appreciated.
New to TL and finding it GREAT! :-)
abrjib0
TestLink user
 
Posts: 8
Joined: Thu Jan 31, 2013 7:42 pm

Re: Testlink with MSSQL

Postby fman » Fri Feb 15, 2013 10:28 am

You have to follow indication scattered on different post regarding MSSQL PHP Drivers, after this is OK; installing on MSSQL is done same way that for other DBMS type
You have apply after installation available fixes (from our mantis site)
fman
Member of TestLink Community
 
Posts: 3059
Joined: Tue Nov 15, 2005 7:19 am

Re: Testlink with MSSQL

Postby abrjib0 » Tue Feb 19, 2013 2:25 am

Thanks fman
I lost most of my hairs and decided to install it with MySQL. :-) Used BitNami stack. Version 1.9.5. working great.. Many thanks for the wonderful product. I have used various Open source products and expensive licensed products in the past. It has almost every feature that an expensive Test Management tool could offer. Great job guys..
New to TL and finding it GREAT! :-)
abrjib0
TestLink user
 
Posts: 8
Joined: Thu Jan 31, 2013 7:42 pm

Re: Testlink with MSSQL

Postby jack090 » Wed Feb 27, 2013 6:33 pm

Not to revive a thread that "doesn't" need a solution right now, but I will say that I plan on making a new guide using 1.9.5 when I get a little time this next month. I'll post it again if anyone is in need of it. (I'm still using 1.9.3).
jack090
Advanced user
 
Posts: 39
Joined: Tue Dec 21, 2010 4:16 pm

Re: Testlink with MSSQL

Postby TSSUSER » Tue Aug 27, 2013 5:29 pm

I try to install TESTLINK 197 using the following configuration:

WINDOW 7 (64Bits)
APACHE 2.4
PHP 5.4
MS SQL 2008

I get the following message: "mssqlnative extension not installed"

I put the extentions "php_sqlsrv_54_ts.dll" and "php_pdo_sqlsrv_54_ts.dll" in the \EXT
folder, the file phi.ini was modified in order to use these extensions.

Please help me.
TSSUSER
TestLink user
 
Posts: 1
Joined: Mon Sep 10, 2012 6:06 pm


Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 2 guests

cron