Testlink installtion with MS-SQL
Moderators: Amaradana, TurboPT, TL Developers
Testlink installtion with MS-SQL
Hi,
Can anybody point me to installation guide of Testlink on MS-SQL
Thanks in advance for your time and effort
Regards
Crisraj
Can anybody point me to installation guide of Testlink on MS-SQL
Thanks in advance for your time and effort
Regards
Crisraj
Re: Testlink installtion with MS-SQL
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
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
Re: Testlink installtion with MS-SQL
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.
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.
Re: Testlink installtion with MS-SQL
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
btw, i m trying to install on sql server 2005
Re: Testlink installtion with MS-SQL
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:
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.
Do you know if the server is in 'Mixed-mode' authentication?
Microsoft says:
Check their info here.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.
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.
Re: Testlink installtion with MS-SQL
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.
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.
Re: Testlink installtion with MS-SQL
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
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
Re: Testlink installtion with MS-SQL
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?
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?
Re: Testlink installtion with MS-SQL
@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.
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.
Re: Testlink installtion with MS-SQL
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
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
-
- TestLink user
- Posts: 1
- Joined: Mon Jul 02, 2012 10:02 pm
Re: Testlink installtion with MS-SQL
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
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
Re: Testlink installtion with MS-SQL
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.
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.
Re: Testlink installtion with MS-SQL
Disregard my post above. Use this forum post: http://www.teamst.org/forum/viewtopic.php?f=1&t=6952