51Testing软件测试论坛

 找回密码
 (注-册)加入51Testing

QQ登录

只需一步,快速开始

微信登录,快人一步

手机号码,快捷登录

查看: 4541|回复: 6
打印 上一主题 下一主题

[原创] jira安装后联不上数据库

[复制链接]

该用户从未签到

跳转到指定楼层
1#
发表于 2007-6-22 18:07:12 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
sdlkfj8 软件情况:winxp sp2   CPU4 3.0G RAM:256MB(虚拟机内安装)
1jdk-1_5_0_08-windows-i586-p.exe
2mysql-5.0.22-win32.zip
3atlassian-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

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?(注-册)加入51Testing

x
分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏
回复

使用道具 举报

该用户从未签到

2#
发表于 2007-6-22 20:21:43 | 只看该作者
这个网站会帮助你的,www.czsm.com.cn
你在上面找找。
回复 支持 反对

使用道具 举报

该用户从未签到

3#
 楼主| 发表于 2007-6-25 09:20:54 | 只看该作者

多谢楼上,我同时也在方外发布此帖.

sdlkfj2
回复 支持 反对

使用道具 举报

该用户从未签到

4#
发表于 2007-8-7 14:02:37 | 只看该作者
不知道你装的是什么版本,jira在安装完后,第一次访问时,会让你初始化一些东东,就包括数据库的这些表,如果你修改数据库配置在初始化之后,那恐怕就会出这个问题。
回复 支持 反对

使用道具 举报

该用户从未签到

5#
发表于 2007-9-11 11:50:41 | 只看该作者
对不起,错误的习惯。谢谢楼主的提醒
回复 支持 反对

使用道具 举报

该用户从未签到

6#
发表于 2007-9-11 15:24:22 | 只看该作者
我启动的时候也是这样的,但是输入一些信息后就可以了。
有两点:第一设tomcat的环境变量,
还有:&后面加上amp;
回复 支持 反对

使用道具 举报

该用户从未签到

7#
发表于 2007-9-12 23:32:01 | 只看该作者
多谢分享
回复 支持 反对

使用道具 举报

本版积分规则

关闭

站长推荐上一条 /1 下一条

小黑屋|手机版|Archiver|51Testing软件测试网 ( 沪ICP备05003035号 关于我们

GMT+8, 2024-11-27 21:42 , Processed in 0.080933 second(s), 29 queries .

Powered by Discuz! X3.2

© 2001-2024 Comsenz Inc.

快速回复 返回顶部 返回列表