I have followed all the instructions in tl-bts-howto.pdf and added the UTF setting also as suggested by a forum user by I am still unable to get JIRA working with my install. The BT is on a remore MS SQL server.
my settings are:
/Set the bug tracking system Interface to JIRA 3.1.1
/** The DB host to use when connecting to the JIRA db */
define('BUG_TRACK_DB_HOST', 'remotehost.company.com');
/** The name of the database that contains the jira tables */
define('BUG_TRACK_DB_NAME', 'jiraname');
/** The DB type being used by jira */
define('BUG_TRACK_DB_USER', 'jirauser');
/** charset of the database that contains the Bugzilla tables */
define('BUG_TRACK_DB_CHARSET', 'utf8');
/** The DB password to use for connecting to the jira db */
define('BUG_TRACK_DB_PASS', 'jirauserpass');
/** link of the web server for jira */
// define('BUG_TRACK_HREF', "http://localhost:8080/secure/Dashboard.jspa");
define('BUG_TRACK_HREF', "http://remotesite.companyname.com:8080/ ... board.jspa");
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'SQL Server');
/** link to the bugtracking system, for entering new bugs */
define('BUG_TRACK_ENTER_BUG_HREF',"http://remotesite.companyname.com:8080/ ... fault.jspa");
?>
When I try and open TL I am getting the error below.
Fatal error: require_once() [function.require]: Failed opening required 'ADODB_sql server.class.php' (include_path='.;C:\xampp\php\pear\;.;C:\xampp\htdocs\testlink\lib\functions\') in C:\xampp\htdocs\testlink\lib\functions\common.php on line 113
Can anyone hlep me on this as its my 4th attempt now and I am about to just park this up and hence the tool without integration with JIRA.
Thanks.
JIRA and TL18.2
Moderators: Amaradana, TurboPT, TL Developers
okay got passed this error by modifying
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'SQL Server');
to
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'MSServer');
But now the Bug link is not displaying anywhere to launch JIRA?
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'SQL Server');
to
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'MSServer');
But now the Bug link is not displaying anywhere to launch JIRA?
Hi,
There is no need to lose hope, I can try helping you again.
You have to have a DB User for your JIRA DB then check the connectivity using script ...
<?php
mssql_connect("JIRASERVER IP HERE", "USERNAME", "PASSWORD") or die("unable to connect");
echo "Connected to MSSQL<br />";
?>
Save this file to C:\xampp\htdocs\testlink and access it using a browser. Once you see that you can connect to the JIRA DB then provide these user credentials in C:\xampp\htdocs\testlink\cfg\jira.cfg.php like
//Set the bug tracking system Interface to JIRA 3.1.1
/** The DB host to use when connecting to the JIRA db */
define('BUG_TRACK_DB_HOST', 'JIRA SERVER IP');
/** The name of the database that contains the jira tables */
define('BUG_TRACK_DB_NAME', 'JIRA_DB_NAME');
/** The DB type being used by jira */
define('BUG_TRACK_DB_USER', 'JIRA_DB_USER');
/** The DB password to use for connecting to the jira db */
define('BUG_TRACK_DB_PASS', 'JIRA_DB_PASSWORD');
//define('BUG_TRACK_DB_CHARSET',"windows-1250");
// define('BUG_TRACK_DB_CHARSET',"gb2312");
define('BUG_TRACK_DB_CHARSET',"UTF-8");
/** link of the web server for jira */
// define('BUG_TRACK_HREF', "http://localhost:8080/secure/Dashboard.jspa");
define('BUG_TRACK_HREF', "http://www.YOURLINKTOACCESSTHE JIRA PAGE");
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'mssql');
/** link to the bugtracking system, for entering new bugs */
define('BUG_TRACK_ENTER_BUG_HREF',"http://www.YOURLINKTOACCESSTHE JIRA PAGE/login.jsp");
Save file then check your custom_config.php to see if the above things are already added there. Then restart every thing and check if JIRA Bug icon is shown on EXECUTE TEST pages.
If it still does not work then write me back with some more details or send your custom_config.php and jira.cfg.php at baloch9@gmail.com. I will try to help you if I could.
Good Luck.
Farooq Khan
There is no need to lose hope, I can try helping you again.
You have to have a DB User for your JIRA DB then check the connectivity using script ...
<?php
mssql_connect("JIRASERVER IP HERE", "USERNAME", "PASSWORD") or die("unable to connect");
echo "Connected to MSSQL<br />";
?>
Save this file to C:\xampp\htdocs\testlink and access it using a browser. Once you see that you can connect to the JIRA DB then provide these user credentials in C:\xampp\htdocs\testlink\cfg\jira.cfg.php like
//Set the bug tracking system Interface to JIRA 3.1.1
/** The DB host to use when connecting to the JIRA db */
define('BUG_TRACK_DB_HOST', 'JIRA SERVER IP');
/** The name of the database that contains the jira tables */
define('BUG_TRACK_DB_NAME', 'JIRA_DB_NAME');
/** The DB type being used by jira */
define('BUG_TRACK_DB_USER', 'JIRA_DB_USER');
/** The DB password to use for connecting to the jira db */
define('BUG_TRACK_DB_PASS', 'JIRA_DB_PASSWORD');
//define('BUG_TRACK_DB_CHARSET',"windows-1250");
// define('BUG_TRACK_DB_CHARSET',"gb2312");
define('BUG_TRACK_DB_CHARSET',"UTF-8");
/** link of the web server for jira */
// define('BUG_TRACK_HREF', "http://localhost:8080/secure/Dashboard.jspa");
define('BUG_TRACK_HREF', "http://www.YOURLINKTOACCESSTHE JIRA PAGE");
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'mssql');
/** link to the bugtracking system, for entering new bugs */
define('BUG_TRACK_ENTER_BUG_HREF',"http://www.YOURLINKTOACCESSTHE JIRA PAGE/login.jsp");
Save file then check your custom_config.php to see if the above things are already added there. Then restart every thing and check if JIRA Bug icon is shown on EXECUTE TEST pages.
If it still does not work then write me back with some more details or send your custom_config.php and jira.cfg.php at baloch9@gmail.com. I will try to help you if I could.
Good Luck.
Farooq Khan
Thank you so much for your offer. I really appreciate it.
I tried that php test and it failed tpo connect so I am waiting on ICT to confirm the connection credentials again for me.
Just to clear something up in my mind, the database I am connecting to is MSSQL, does mysql_connect work for this db or do I need to establish and ODBC? If so what is required?
I tried that php test and it failed tpo connect so I am waiting on ICT to confirm the connection credentials again for me.
Just to clear something up in my mind, the database I am connecting to is MSSQL, does mysql_connect work for this db or do I need to establish and ODBC? If so what is required?
-
tester2010
- TestLink user
- Posts: 2
- Joined: Wed Mar 24, 2010 10:45 am
you need to check your jiradb settings. As in mssql there is always schema association with the database. You have to create a serever login role as mentaioned in the below script
USE [master];
GO
CREATE LOGIN [<loginrole name>] WITH
PASSWORD = <pwd>,
CHECK_EXPIRATION = OFF,
CHECK_POLICY = ON,
DEFAULT_DATABASE = [master],
DEFAULT_LANGUAGE = [us_english];
GO
USE [JiraDB];
GO
CREATE USER [<username>] FOR LOGIN [<loginrole name>] WITH DEFAULT_SCHEMA=[jiraschema];
GO
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [<username>];
GO
EXEC sp_addrolemember N'db_owner', N'<username>';
GO
GRANT CONNECT SQL TO [loginrole name>];
GO
And
/Set the bug tracking system Interface to JIRA 3.1.1
/** The DB host to use when connecting to the JIRA db */
define('BUG_TRACK_DB_HOST', 'remotehost.company.com');
/** The name of the database that contains the jira tables */
define('BUG_TRACK_DB_NAME', 'jiraname');
/** The DB type being used by jira */
define('BUG_TRACK_DB_USER', '<loginrole name>');
/** charset of the database that contains the Bugzilla tables */
define('BUG_TRACK_DB_CHARSET', 'utf8');
/** The DB password to use for connecting to the jira db */
define('BUG_TRACK_DB_PASS', 'jirauserpass');
/** link of the web server for jira */
// define('BUG_TRACK_HREF', "http://localhost:8080/secure/Dashboard.jspa");
define('BUG_TRACK_HREF', "http://remotesite.companyname.com:8080/ ... board.jspa");
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'mssql');
/** link to the bugtracking system, for entering new bugs */
define('BUG_TRACK_ENTER_BUG_HREF',"http://remotesite.companyname.com:8080/ ... fault.jspa");
USE [master];
GO
CREATE LOGIN [<loginrole name>] WITH
PASSWORD = <pwd>,
CHECK_EXPIRATION = OFF,
CHECK_POLICY = ON,
DEFAULT_DATABASE = [master],
DEFAULT_LANGUAGE = [us_english];
GO
USE [JiraDB];
GO
CREATE USER [<username>] FOR LOGIN [<loginrole name>] WITH DEFAULT_SCHEMA=[jiraschema];
GO
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [<username>];
GO
EXEC sp_addrolemember N'db_owner', N'<username>';
GO
GRANT CONNECT SQL TO [loginrole name>];
GO
And
/Set the bug tracking system Interface to JIRA 3.1.1
/** The DB host to use when connecting to the JIRA db */
define('BUG_TRACK_DB_HOST', 'remotehost.company.com');
/** The name of the database that contains the jira tables */
define('BUG_TRACK_DB_NAME', 'jiraname');
/** The DB type being used by jira */
define('BUG_TRACK_DB_USER', '<loginrole name>');
/** charset of the database that contains the Bugzilla tables */
define('BUG_TRACK_DB_CHARSET', 'utf8');
/** The DB password to use for connecting to the jira db */
define('BUG_TRACK_DB_PASS', 'jirauserpass');
/** link of the web server for jira */
// define('BUG_TRACK_HREF', "http://localhost:8080/secure/Dashboard.jspa");
define('BUG_TRACK_HREF', "http://remotesite.companyname.com:8080/ ... board.jspa");
/** The DB type to use for connecting to the bugtracking db */
define('BUG_TRACK_DB_TYPE', 'mssql');
/** link to the bugtracking system, for entering new bugs */
define('BUG_TRACK_ENTER_BUG_HREF',"http://remotesite.companyname.com:8080/ ... fault.jspa");