During jira installation with wizard on my own sql server database getting error as Null pointer exc

[Venkatesh_Tottempudi]

During Jira installation with wizard on my own SQL server database getting error as Null pointer exception.

Please check with priority basis.

Will i get direct contact details for support as we need to do setup in production setup

http://localhost:8080/secure/SetupMode.jspa

[mlassau_atlassian · Accepted solution]

The important thing to note is that com.sun.jndi.ldap.connect.pool is not a VM argument.

However, some of the settings are according to Oracle JVM docs:

http://docs.oracle.com/javase/jndi/tutorial/ldap/connect/config.html

You may be able to set one of these to a value that precludes pooling from being allowed for your connections?
In particular I am thinking:

• com.sun.jndi.ldap.connect.pool.authentication
  A list of space-separated authentication types of connections that may be pooled
• or com.sun.jndi.ldap.connect.pool.protocol
  A list of space-separated protocol types of connections that may be pooled.

[M]

Hi Mark, thanks a lot for the help. I'll give those properties a go and report back here!

[M]

Okay, it turns out that this does work! It does seem a bit of a "hack", but I'll take it! Here is the output from netstat:

[root@jira01 ~]# netstat -ap | grep ldap
tcp        0      0 ::ffff:172.24.102.15:42130  ::ffff:146.195.128.254:ldap TIME_WAIT   -
tcp        0      0 ::ffff:172.24.102.15:42129  ::ffff:146.195.128.254:ldap TIME_WAIT   -

(Previously, I had a bunch of ESTABLISHED connections with PIDs at the end.)

For anyone else reading this, I added the following to setenv.sh:

JAVA_OPTS="${JAVA_OPTS} -Dcom.sun.jndi.ldap.connect.pool.protocol=DIGEST-MD5"

It would be nice if there was a more official way to turn off LDAP connection pooling in JIRA/Crowd. Should I raise a ticket with Atlassian support for this?

Thanks again!

-Muel

[mlassau_atlassian]

Currently JIRA does not provide any way to turn off LDAP conneciton pooling.

According to the Crowd documentation this is available in the Crowd server:

https://confluence.atlassian.com/display/CROWD/Configuring+the+LDAP+Connection+Pool

So in theory you should be able to connect JIRA to Crowd and Crowd to LDAP and turn off the pooling in the Crowd server. However, reading the Oracle docs and the Crowd source code, I am not sure if this will actually work ... please test first if you want to try this.

[mlassau_atlassian]

Currently there is no