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

Some functions in JIRA break when using password, for the db user, with semicolon (;) when connecting to database

    XMLWordPrintable

Details

    Description

      Steps to reproduce

      1. Setup JIRA to connect with MySQL server with the user 'test' and password 'test;'
      2. JIRA still can start up and working but there are a lot of the following errors in the log:
        2012-03-02 00:13:03,466 http-8500-1 ERROR kahloun.foong 12x327x1 2q9p44 127.0.0.1 /browse/TST-1 [NoModule] Error getting datasource via DBCP: JdbcDatasourceInfo{uri='jdbc:mysql://localhost:3306/jiradb5?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB', driverClassName='com.mysql.jdbc.Driver', username='test', password='********', isolationLevel='null', connectionProperties=null, connectionPoolInfo=ConnectionPoolInfo{maxSize=15, minSize=2, maxWait=60000, sleepTime=300000, lifeTime=600000, deadLockMaxWait=600000, deadLockRetryWait=10000, validationQuery='select 1', minEvictableTimeMillis=null, timeBetweenEvictionRunsMillis=null}}
        org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'test'@'localhost' (using password: YES))
        
      3. There are some other issue like 'Create Issue' AJAX not working and the 'View Issue Screen' break with the following error:
        Error rendering WebPanel (viewissue/detailsblock.vm): org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getHtml' in class com.atlassian.jira.web.component.IssueConstantWebComponent threw exception com.google.common.collect.ComputationException: java.lang.NullPointerException at viewissue/detailsblock.vm[line 62, column 45]
        

      The password with semicolon works with JIRA 4.4.4

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              klfoong Foong (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: