Testlink installtion with MS-SQL

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
crisraj
TestLink user
Posts: 4
Joined: Tue Feb 16, 2010 3:27 pm

Testlink installtion with MS-SQL

Post by crisraj »

Hi,

Can anybody point me to installation guide of Testlink on MS-SQL

Thanks in advance for your time and effort

Regards
Crisraj
abbey4u
TestLink user
Posts: 8
Joined: Fri Jan 07, 2011 11:22 am

Re: Testlink installtion with MS-SQL

Post by abbey4u »

I am also finding it hard to install. I am getting Warning!: Your PHP installation don't have the mssql extension mssql- without it is IMPOSSIBLE to use Testlink.Failed!
However if i check my php.info file i am getting sqlsrv support enabled confirming that the extension is installed correctly. I am not sure how to proceed

sqlsrv

sqlsrv support enabled

Directive Local Value Master Value
sqlsrv.LogSeverity 0 0
sqlsrv.LogSubsystems 0 0
sqlsrv.WarningsReturnAsErrors On On
TurboPT
Member of TestLink Community
Posts: 343
Joined: Sun Dec 10, 2006 4:51 am

Re: Testlink installtion with MS-SQL

Post by TurboPT »

Which MS-SQL version?

Anyway, I do NOT have MSSQL configured, but there is a bit more [copying some DLL's] that may need to be done, according to PHP.

Also, check the various logs, including the server's, for any potential error messages that might offer some clues.
abbey4u
TestLink user
Posts: 8
Joined: Fri Jan 07, 2011 11:22 am

Re: Testlink installtion with MS-SQL

Post by abbey4u »

I got this working. I had to install php 5.2 which has php_mssql.dll. The problem with the new dll prvided by microsoft is php ini would make an entry as "sqlsvr" whereas the old dll makes an entry as "MSSql" which is what php recognize. However i am now stuck at next step, when i put my db credentials etc and move to next step, i am getting internal server error. Not sure what can be the problem. looks like some issue with installation code.

btw, i m trying to install on sql server 2005
TurboPT
Member of TestLink Community
Posts: 343
Joined: Sun Dec 10, 2006 4:51 am

Re: Testlink installtion with MS-SQL

Post by TurboPT »

Is that a 'regular' sql server 2005 version? [or the express edition]

Do you know if the server is in 'Mixed-mode' authentication?
Microsoft says:
You cannot use a SQL Server Standard security login account after a Typical installation of SQL Server 2000 [or 2005] until you change the authentication mode to Mixed.
Check their info here.

For those that might have the express edition:
The change is not as easily done with the express version [as no Management Studio is provided, that's why I asked], but the difference would involve modifying a registry key value, and restarting the server. The info for this, if needed, can be found here. In that article, note that part of the key's path [just after the Microsoft SQL Server portion] may differ slightly, depending on the express version, so it might be easier to search for the LoginMode sub-key name from the top-level HKEY_LOCAL_MACHINE hive.
abbey4u
TestLink user
Posts: 8
Joined: Fri Jan 07, 2011 11:22 am

Re: Testlink installtion with MS-SQL

Post by abbey4u »

Thanks TurboPT for all the suggestion. I am using SQL server 2005 enterprise edition. and it has Mixed Mode enabled. Let me explain the whole scenario once again.

Environment: SQL Server 2005 Enterprise Edition running on windows server 2003.
Apache
Problem 1:
Initially, I had Php 5.3 and whenever i tried to install, i was getting " Warning!: Your PHP installation don't have the mssql extension mssql- without it is IMPOSSIBLE to use Testlink.Failed!"
I tried installing mssql driver for php; http://www.microsoft.com/sqlserver/2005 ... river.aspx, but the dll which comes with it was php_sqlsrv_52_nts_vc6.dll. I also tried with other dll which came in the package but everytime i was getting the same error as mentioned above.
Solution 1:
The solution was to install php 5.2.17 which has php_mssql.dll. Now the above error dissapeared and testlink was able to recognise the mssql extension. Obviously i had to enable the dll on php.ini file

Problem 2
Now i am getting an internal server error, I tried both on apache and IIS 7. I don't know where and how to debug. As mentioned above, the sql server is enterprise version and has mixed mode enabled.
Solution 2
As a workaround, i installed on mysql which created the custom_db.config file. Then i ran
C:\inetpub\wwwroot\testlink\install\sql\mysql\
a. testlink_create_tables.sql
b. testlink_create_default_data.sql

Both these created the desired db and put default data into it. After that, i ran,

c) C:\inetpub\wwwroot\testlink\install\sql\alter_tables\1.9.1\mssql\DB.1.4\step1\db_schema_update.sql
d) C:\inetpub\wwwroot\testlink\install\sql\alter_tables\1.9.1\mssql\DB.1.4\stepZ\z_final_step.sql

And finally i changed the custom_db.config to point to my new db in sqlserver and it worked correctly. This way i got testlink working.

Problem 3
While running solution 2 above,

c) C:\inetpub\wwwroot\testlink\install\sql\alter_tables\1.9.1\mssql\DB.1.4\step1\db_schema_update.sql gives an error. This is at running the two sql statement
in db_schema_update.sql
ALTER TABLE /*prefix*/req_versions ADD revision INTEGER NOT NULL DEFAULT '1';
ALTER TABLE /*prefix*/req_versions ADD log_message TEXT NULL DEFAULT NULL;
Solution 3These steps are not required and should be skipped.

Note I am surprised that even i am installing 1.9.2 manually, i had to run schema upgrade, i think it should have been part of below two statement
a. testlink_create_tables.sql
b. testlink_create_default_data.sql

Finally, I however still want to run a full install through the automatic install process and not the workaround in solution 2.
spastine
TestLink user
Posts: 1
Joined: Thu Jul 21, 2011 9:01 pm

Re: Testlink installtion with MS-SQL

Post by spastine »

Estimados:

Yo instale Testlink 1.9.1 con MSSQL pero no puedo ingresar datos por la aplicacion, al validar el LOG me rotorna un error

mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]: Query failed - in C:\Program Files\Apache Group\Apache2\htdocs\testlink-1.9.1\third_party\adodb\drivers\adodb-mssql.inc.php - Line 775

Quien me puede ayudar.

Saludos
claveesh
TestLink user
Posts: 2
Joined: Thu Aug 11, 2011 6:08 am

Re: Testlink installtion with MS-SQL

Post by claveesh »

Hi there
I have still problem with "Warning!: Your PHP installation don't have the mssql extension mssql- without it is IMPOSSIBLE to use Testlink.Failed!"

Env: Windows Server 2008 RC2
PHP 5.2.7 on IIS7.5
Testlink: 1.9.3
Database: SQL Server 2005

I copied ntwdblib.dll file to WIndows/System32 folder
in php.ini file extension is allowed
file php_mssql.dll exists in ext/ folder
still does not work

where is the problem?
TurboPT
Member of TestLink Community
Posts: 343
Joined: Sun Dec 10, 2006 4:51 am

Re: Testlink installtion with MS-SQL

Post by TurboPT »

@claveesh
You might have already do so, but not mentioned in your post...did you restart the web server?

Those changes are not be applied until restart.
claveesh
TestLink user
Posts: 2
Joined: Thu Aug 11, 2011 6:08 am

Re: Testlink installtion with MS-SQL

Post by claveesh »

of course
I did it and still does not work

Secound case.
I installed PHP 5.3.6
I downloaded driver php_pdo_sqlsrv_53_nts_vc9.dll

no result
abudhiraja
TestLink user
Posts: 1
Joined: Mon Jul 02, 2012 10:02 pm

Re: Testlink installtion with MS-SQL

Post by abudhiraja »

Hi,
i am trying to install test link 1.9.3 with mssql
but i am getting an warning: Checking PHP DB extensions Warning!: Your PHP installation don't have the mssql extension mssql- without it is IMPOSSIBLE to use Testlink.Failed!

i am using php 5.3.14 and apache 2.2.14. php and apache are configured correctly.
SQL server 2005 is not getting configured with php.
i am not getting sqlserver information while running test.php page.

The reason that i think behind it wrong selection of SQL driver.
can anybody let me know which driver of SQL should i use for php 5.3.14?

i have tried with php_sqlsrv_53_ts_vc6.dll and php_sqlsrv_53_ts.dll and update the php.ini file with dll extension... but of no use :(

Any kind of help is appericiated..
Thanks in Advance for your time and support :)


Anu
jack090
Advanced user
Posts: 39
Joined: Tue Dec 21, 2010 4:16 pm

Re: Testlink installtion with MS-SQL

Post by jack090 »

In my experience w/ IIS and Testlink + MSSQL I had to use the cgi version. Use: http://blog.nettraptor.net/?p=64

Also if you need all the right php drivers and correct php.ini file setup send me a PM and i'll send a copy of my php folder.
jack090
Advanced user
Posts: 39
Joined: Tue Dec 21, 2010 4:16 pm

Re: Testlink installtion with MS-SQL

Post by jack090 »

Disregard my post above. Use this forum post: http://www.teamst.org/forum/viewtopic.php?f=1&t=6952
Post Reply