Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and 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

    • Introduced in Version:
      5
    • Support reference count:
      1
    • Regular Expression:
      Error\srendering\sWebPanel\s.viewissue/detailsblock\.vm.
    • Symptom Severity:
      Severity 3 - Minor

      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

              • Assignee:
                Unassigned
                Reporter:
                klfoong Kah Loun Foong
              • Votes:
                3 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: