It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×6,115
×864

question asked: Sep 18 '13, 9:03 a.m.
question was seen: 5,347 times
last updated: Sep 25 '13, 7:05 a.m.

Related questions

cannot test database

0
Derk Rembold (16●3●5) | asked Sep 18 '13, 9:03 a.m.
Hi,

currently I am trying to configure the JTS database during the jazz team server custom setup step #3. Unfortunately it fails during the database testing with

The server was unable to connect to the database because the database connection syntax is invalid. Verify the syntax in your teamserver.properties file. See the Jazz Team Server log for more information.

The database vendor I use is DB2 and the jdbc location is //xxxx.boeblingen.de.xxx.com:48560/jts:user=rembold;password={password}; (I tried to use JTS instead of jts and left out ;)

When looking into the teamserver.properties files, I can see that there still exists derby entries, and no db2 entries. Not sure why this file is not updated correctly.

Any idea how this can be resolved?




4 answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Derk Rembold (16●3●5) | answered Sep 25 '13, 7:05 a.m.
ok, we found the problem. The problem was due to the afs system and its overlayed authorization system which is installed on our servers. db2 did not accept the passwords I typed in. They were ok for afs, but not for db2. So we have to explicitly take out the db2inst1 user from the afs authorization system, and then it worked.
0
permanent link
Eric Jodet (6.3k●5●111●120) | answered Sep 18 '13, 9:35 a.m.
JAZZ DEVELOPER
 Hello,
ensure you update the correct teamserver.properties,
for jts : <server_install_dir>/server/conf/jts/

Also ensure you comment out ootb Derby entries.

See https://jazz.net/help-dev/clm/topic/com.ibm.jazz.install.doc/topics/t_manually_update_config_db2.html

Thanks,
Eric.
0
permanent link
Kot T. (1.5k●1●13●19) | answered Sep 18 '13, 2:43 p.m.
JAZZ DEVELOPER

Hi Derk,

The connection string you have seems correct. Generally, it should automatically update the teamserver.properties with the info that you enter in the jts/setup wizard.

As a work-around, I agreed with Eric's answer above to try to manually update teamserver.properties for JTS and see if it allows you to test connection.

0
permanent link
Karl Weinert (2.0k●5●27●36) | answered Sep 20 '13, 8:44 a.m.
JAZZ DEVELOPER
Hi Derik,

The teamserver.properties file won't be updated until the test succeeds.
One thing I notice is you are using a non-default port number. (48560)
If that is the correct port is it possible that a firewall is blocking access to that port?
I believe you can tellnet to that port to test
telnet servername 48560

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.