51Testing软件测试论坛

标题: jira安装后联不上数据库 [打印本页]

作者: ppzhang 时间: 2007-6-22 18:07
标题: jira安装后联不上数据库
sdlkfj8 软件情况：winxp sp2 CPU

4 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

作者: b47617 时间: 2007-6-22 20:21
这个网站会帮助你的，www.czsm.com.cn 。
你在上面找找。

作者: ppzhang 时间: 2007-6-25 09:20
标题: 多谢楼上,我同时也在方外发布此帖.
sdlkfj2

作者: dongchanglin 时间: 2007-8-7 14:02
不知道你装的是什么版本，jira在安装完后，第一次访问时，会让你初始化一些东东，就包括数据库的这些表，如果你修改数据库配置在初始化之后，那恐怕就会出这个问题。

作者: mercuryzhang 时间: 2007-9-11 11:50
对不起，错误的习惯。谢谢楼主的提醒

作者: mercuryzhang 时间: 2007-9-11 15:24
我启动的时候也是这样的，但是输入一些信息后就可以了。
有两点：第一设tomcat的环境变量，
还有：&后面加上amp;

作者: 晓诺 时间: 2007-9-12 23:32
多谢分享

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)