jira配置连接数据库时报错“此Mysql实例没有适当配置。”
在下拉框中记得选择 MySQL5.6的版本,就这么个问题,让我找了三天的方法。
官方帮助文档中说:
Windows: Open a command prompt and run config.bat
in the bin
sub-directory of the Jira installation directory.
就是在安装路径的bin目录下按住shift右击运行cmd命令,输入config.bat,可以直接调用界面进行配置。
另外注意一下的是:dbconfig.xml文件中的url后面的路径一定要是 &? ,这个整体代表了&,否则会不识别。
<?xml version="1.0" encoding="UTF-8"?> <jira-database-config> <name>defaultDS</name> <delegator-name>default</delegator-name> <database-type>mysql</database-type> <jdbc-datasource> <url>jdbc:mysql://address=(protocol=tcp)(host=localhost)(port=3306)/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=default_storage_engine=InnoDB</url> <driver-class>com.mysql.jdbc.Driver</driver-class> <username>jira</username> <password>jira</password> <pool-min-size>20</pool-min-size> <pool-max-size>20</pool-max-size> <pool-max-wait>30000</pool-max-wait> <validation-query>select 1</validation-query> <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis> <time-between-eviction-runs-millis>30000</time-between-eviction-runs-millis> <pool-max-idle>20</pool-max-idle> <pool-remove-abandoned>true</pool-remove-abandoned> <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout> <pool-test-on-borrow>false</pool-test-on-borrow> <pool-test-while-idle>true</pool-test-while-idle> <validation-query-timeout>3</validation-query-timeout> </jdbc-datasource> </jira-database-config>