Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

cannot test database

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?




0 votes



4 answers

Permanent link
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.

1 vote


Permanent link
 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 votes


Permanent link

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 votes


Permanent link
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

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,125

Question asked: Sep 18 '13, 9:03 a.m.

Question was seen: 5,507 times

Last updated: Sep 25 '13, 7:05 a.m.

Confirmation Cancel Confirm