|
sdlkfj8 软件情况:winxp sp2 CPU4 3.0G RAM:256MB(虚拟机内安装)
1:jdk-1_5_0_08-windows-i586-p.exe
2:mysql-5.0.22-win32.zip
3:atlassian-jira-enterprise-3.6.4-standalone.zip
4: mysqldriver.jar(查看readme得知版本是MySQL Connector/J 3.1.7 (formerly MM.MySQL))
步骤:
1 安装jdk
2 安装mysql
2.1 建立数据库 create database jiradb;
2.2 增加用户并赋予权限:GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX on jiradb.* TO 'jirauser'@'localhost' IDENTIFIED BY '111111';
3 copy d:\tools\jira3.6.4 to C:\JIRA3.6.4\
4 修改C:\JIRA3.6.4\atlassian-jira\WEB-INF\classes\entityengine.xml
<datasource name="defaultDS" field-type-name="hsql"
修改为:
<datasource name="defaultDS" field-type-name="mysql"
5 修改C:\JIRA3.6.4\conf\server.xml
username="sa"
password=""
driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb{catalina.home}/database/jiradb"
修改为:
username="jirauser"
password="111111"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/jiradb?autoReconnect=true&useUnicode=true&characterEncoding=UTF8"
6 copy D:\002-QA工具集\mysqldriver.jar to C:\JIRA3.6.4\ common\lib,并改名为:mysql-connector-java-3.1.7
(复制jdbc驱动,不知改名步骤是否多余)
7 执行C:\JIRA3.6.4\bin\startup.bat 启动jira,启动是有找不到表的报错信息,内容如下,
8 打开ie,在地址栏输入 http://localhost:8080 jira安装页面显示正常,但输入信息点下一步则报找不到表的错误。
不知道是mysql的驱动问题还是建jirauser的权限问题或者其他,请帮忙分析一下,附件是驱动文件和报错文件。
2007-06-22 17:15:04,281 WARN [core.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database
2007-06-22 17:15:04,296 WARN [core.entity.jdbc.DatabaseUtil] Entity "ChangeGroup" has no table in the database
2007-06-22 17:15:04,312 WARN [core.entity.jdbc.DatabaseUtil] Entity "ChangeItem" has no table in the database
2007-06-22 17:15:04,328 WARN [core.entity.jdbc.DatabaseUtil] Entity "ColumnLayout" has no table in the database
2007-06-22 17:15:04,328 WARN [core.entity.jdbc.DatabaseUtil] Entity "ColumnLayoutItem" has no table in the database
2007-06-22 17:15:04,343 WARN [core.entity.jdbc.DatabaseUtil] Entity "Component" has no table in the database
2007-06-22 17:15:04,359 WARN [core.entity.jdbc.DatabaseUtil] Entity "ConfigurationContext" has no table in the database
2007-06-22 17:15:04,390 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomField" has no table in the database
2007-06-22 17:15:04,406 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomFieldOption" has no table in the database
2007-06-22 17:15:04,421 WARN [core.entity.jdbc.DatabaseUtil] Entity "CustomFieldValue" has no table in the database
2007-06-22 17:15:04,468 WARN [core.entity.jdbc.DatabaseUtil] Entity "EventType" has no table in the database
2007-06-22 17:15:04,484 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldConfigScheme" has no table in the database
2007-06-22 17:15:04,500 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldConfigSchemeIssueType" has no table in the database
2007-06-22 17:15:04,515 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldConfiguration" has no table in the database
2007-06-22 17:15:04,531 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayout" has no table in the database
2007-06-22 17:15:04,546 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutItem" has no table in the database
2007-06-22 17:15:04,578 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutScheme" has no table in the database
2007-06-22 17:15:04,609 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutSchemeAssociation" has no table in the database
2007-06-22 17:15:04,640 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldLayoutSchemeEntity" has no table in the database
2007-06-22 17:15:04,656 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldScreen" has no table in the database
2007-06-22 17:15:04,671 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldScreenLayoutItem" has no table in the database
2007-06-22 17:15:04,703 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldScreenScheme" has no table in the database
2007-06-22 17:15:04,750 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldScreenSchemeItem" has no table in the database
2007-06-22 17:15:04,781 WARN [core.entity.jdbc.DatabaseUtil] Entity "FieldScreenTab" has no table in the database
2007-06-22 17:15:04,812 WARN [core.entity.jdbc.DatabaseUtil] Entity "FileAttachment" has no table in the database
2007-06-22 17:15:04,843 WARN [core.entity.jdbc.DatabaseUtil] Entity "FilterSubscription" has no table in the database
2007-06-22 17:15:04,875 WARN [core.entity.jdbc.DatabaseUtil] Entity "GenericConfiguration" has no table in the database
2007-06-22 17:15:04,906 WARN [core.entity.jdbc.DatabaseUtil] Entity "Issue" has no table in the database
2007-06-22 17:15:04,953 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueLink" has no table in the database
2007-06-22 17:15:05,000 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueLinkType" has no table in the database
2007-06-22 17:15:05,093 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueSecurityScheme" has no table in the database
2007-06-22 17:15:05,125 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueType" has no table in the database
2007-06-22 17:15:05,140 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueTypeScreenScheme" has no table in the database
2007-06-22 17:15:05,171 WARN [core.entity.jdbc.DatabaseUtil] Entity "IssueTypeScreenSchemeEntity" has no table in the database
2007-06-22 17:15:05,203 WARN [core.entity.jdbc.DatabaseUtil] Entity "ListenerConfig" has no table in the database
2007-06-22 17:15:05,218 WARN [core.entity.jdbc.DatabaseUtil] Entity "MailServer" has no table in the database
2007-06-22 17:15:05,265 WARN [core.entity.jdbc.DatabaseUtil] Entity "NodeAssociation" has no table in the database
2007-06-22 17:15:05,281 WARN [core.entity.jdbc.DatabaseUtil] Entity "Notification" has no table in the database
2007-06-22 17:15:05,312 WARN [core.entity.jdbc.DatabaseUtil] Entity "NotificationInstance" has no table in the database
2007-06-22 17:15:05,328 WARN [core.entity.jdbc.DatabaseUtil] Entity "NotificationScheme" has no table in the database
2007-06-22 17:15:05,562 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSCurrentStep" has no table in the database
2007-06-22 17:15:05,578 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSCurrentStepPrev" has no table in the database
2007-06-22 17:15:05,625 WARN [core.entity.jdbc.DatabaseUtil] Entity "OSGroup" has no table in the database
|
|