Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-27796

Cannot use special characters in the database password

XMLWordPrintable

      Even after a successful test connection using config.bat file, JIRA is unable to connect database using password with special character. That error was confirmed using SQL 2008 and Mysql 5.5
      As an example, use fz2/Gf%uX!FK;99= as password

      Step by Step to reproduce:

      1. Create new database
      2. Grant access to a new user using fz2/Gf%uX!FK;99= as user password
      3. Configure JIRA and test connection using config.bat file
      4. Try so startup JIRA with startup.bat

      I tried to use parent encoding and quotes, didn’t work too.

      The following error appear in the atlassian-jira.log

      2013-06-03 14:50:17,043 main ERROR      [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:jtds:sqlserver://nywcl1150db01:7001/JIRAPREVIEW1;autoCommit=false', driverClassName='net.sourceforge.jtds.jdbc.Driver', username='jirapreview1', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=20, minSize=20, initialSize=null, maxIdle=20, maxWait=30000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery=null, minEvictableTimeMillis=null, timeBetweenEvictionRunsMillis=null, poolPreparedStatements=null, testOnBorrow=null, testOnReturn=null, testWhileIdle=null, maxOpenPreparedStatements=null, numTestsPerEvictionRun=null, removeAbandonedTimeout=300, validationQueryTimeout=null, defaultCatalog=null}}
java.lang.RuntimeException: javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
	at org.weakref.jmx.MBeanExporter.export(MBeanExporter.java:45)
	at org.apache.commons.dbcp.ManagedBasicDataSource.exportMBean(ManagedBasicDataSource.java:70)
	at org.apache.commons.dbcp.ManagedBasicDataSource.<init>(ManagedBasicDataSource.java:61)
	at org.apache.commons.dbcp.ManagedBasicDataSourceFactory.createDataSource(ManagedBasicDataSourceFactory.java:278)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.createDataSource(DBCPConnectionFactory.java:190)
	at org.ofbiz.core.entity.transaction.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:91)
	at org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:69)
       ....
Caused by: javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
	at com.sun.jmx.mbeanserver.Repository.addMBean(Repository.java:453)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObject(DefaultMBeanServerInterceptor.java:1484)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(DefaultMBeanServerInterceptor.java:963)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:917)
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:312)
	at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:482)
	at org.weakref.jmx.MBeanExporter.export(MBeanExporter.java:39)
	... 140 more

      Workaround

      Use a password without special characters (limit the password to using _ or . with alphanumeric characters only).

            ohernandez@atlassian.com Oswaldo Hernandez (Inactive)
            pvieira Paulo Vieira
            Votes:
            7 Vote for this issue
            Watchers:
            25 Start watching this issue

              Created:
              Updated:
              Resolved: