Community resources
Community resources
- Community
- Products
- Jira Software
- Questions
- fault in jira installation
fault in jira installation
hello all .
i reconfigure Jira.war on tomcat 7.0.34 ....
see the following pic .....
the steps i done :
1- this is my directory
http://www.4shared.com/download/vHZ1Uujm/Directory.jpg<br< a="">>
2- esure the edit-webapp/WEB-INF/classes/entityengine.xml contain the transaction-factory class="org.ofbiz.core.entity.transaction.JNDIFactory">
<user-transaction-jndi jndi-server-name="default" jndi-name="java:comp/env/UserTransaction"/> <transaction-manager-jndi jndi-server-name="default" jndi-name="java:comp/env/UserTransaction"/></transaction-factory>---------------------- the entityengine.xml file------------------------
<?xml version="1.0" encoding="UTF-8" ?>
<!--
This file configures the OFBiz Entity Engine which JIRA uses to store persist data in a datasource.
For detailed configuration help see:
http://www.atlassian.com/software/jira/docs/latest/entityengine.html
Or our server specific setup guides (these take you through the setup process for each server):
http://www.atlassian.com/software/jira/docs/latest/servers/
Normally, you will only need to edit the 'field-type-name' attribute of the <datasource> tag, near the bottom of this
file.
Less commonly, you may wish to change then JNDI lookup paths for:
- the Transaction Manager (<transaction-factory> element)
- Database connection (<jndi-jdbc> element).
If you not using the 12 preconfigured DBs, you may also need to add your own field type definition
-->
<entity-config>
<resource-loader name="maincp" class="org.ofbiz.core.config.ClasspathLoader"/>
<!-- TRANSACTION FACTORY - This configures how JIRA finds the application server's transaction management.
The default ('java:comp/env/UserTransaction') is correct for Tomcat 5.5. For details on configuring for other
application servers - see:
http://www.atlassian.com/software/jira/docs/latest/entityengine.html#transactionfactory
-->
<transaction-factory class="org.ofbiz.core.entity.transaction.JNDIFactory">
<user-transaction-jndi jndi-server-name="default" jndi-name="java:comp/env/UserTransaction"/>
<transaction-manager-jndi jndi-server-name="default" jndi-name="java:comp/env/UserTransaction"/>
</transaction-factory>
<delegator name="default" entity-model-reader="main" entity-group-reader="main">
<group-map group-name="default" datasource-name="defaultDS"/>
</delegator>
<entity-model-reader name="main">
<resource loader="maincp" location="entitydefs/entitymodel.xml"/>
</entity-model-reader>
<entity-group-reader name="main" loader="maincp" location="entitydefs/entitygroup.xml"/>
<field-type name="cloudscape" loader="maincp" location="entitydefs/fieldtype-cloudscape.xml"/>
<field-type name="firebird" loader="maincp" location="entitydefs/fieldtype-firebird.xml"/>
<field-type name="hsql" loader="maincp" location="entitydefs/fieldtype-hsql18.xml"/>
<field-type name="mckoidb" loader="maincp" location="entitydefs/fieldtype-mckoidb.xml"/>
<field-type name="mysql" loader="maincp" location="entitydefs/fieldtype-mysql.xml"/>
<field-type name="mssql" loader="maincp" location="entitydefs/fieldtype-mssql.xml"/>
<!--
This field type is deprecated, and should ONLY be used with Oracle 8i.
If you are using Oracle 9i or 10g please use Oracle 10g JDBC drivers and the 'oracle10g' field type, which is specified below
-->
<field-type name="oracle" loader="maincp" location="entitydefs/fieldtype-oracle.xml"/>
<!--
Please use this field type for Oracle 9i and 10g. Please ensure that you are using Oracle 10g JDBC drivers which are compatible with Oracle 9i.
The 10g JDBC drivers can be downloaded from here: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
-->
<field-type name="oracle10g" loader="maincp" location="entitydefs/fieldtype-oracle10g.xml"/>
<field-type name="postgres" loader="maincp" location="entitydefs/fieldtype-postgres.xml"/>
<field-type name="postgres72" loader="maincp" location="entitydefs/fieldtype-postgres72.xml"/> <!-- use for postgres 7.2 and above -->
<field-type name="sapdb" loader="maincp" location="entitydefs/fieldtype-sapdb.xml"/>
<field-type name="sybase" loader="maincp" location="entitydefs/fieldtype-sybase.xml"/>
<field-type name="db2" loader="maincp" location="entitydefs/fieldtype-db2.xml"/>
<!--
JRA-4202: FrontBase has 'type' and 'position' as reserved words so make the following changes the entitymodel.xml
<field name="type" type="short-varchar"/> to <field name="type" col-name="TYPE_" type="short-varchar"/>
<field name="type" type="long-varchar"/> to <field name="type" col-name="TYPE_" type="long-varchar"/>
<field name="position" type="integer"/> to <field name="position" col-name="POSITION_" type="integer"/>
-->
<field-type name="frontbase" loader="maincp" location="entitydefs/fieldtype-frontbase.xml"/>
<!--
DATASOURCE
You should no longer define a datasource in this file, the database is now configured through the UI at setup time.
The only time you would want to configure it here is when you migrate from an older version and need to point the
new installation at an existing db. This is considered a legacy method and will not work if dbconfig.xml exists
in the home directory.
-->
</entity-config>
3- at edit-webapp/WEB-INF/classes/jira-application.properties set the jira.home =D://apache-tomcat-7.0.34//JiraApp
4- Build the JiraApp.
then the following error show atthe tomcat consol
http://www.4shared.com/download/7KYuajHq/consol.png
it needs detrmine the MySql Database so ...
5- create mysql database called jiradb by
CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;
Username:root Password:123456
6- copy Mysql Driver to D:\apache-tomcat-7.0.34\JiraApp\webapp\WEB-INF\lib
7- add tomcat lib from http://www.atlassian.com/software/jira/downloads/binary/jira-jars-tomcat-distribution-6.2-m04-tomcat-7x.zip
8- ensure the jars file in Tomcat's lib directory.is not in the webapp/jira/WEB-INF/lib
8- add the dbconfig.xml to D:\apache-tomcat-7.0.34\JiraApp
whereit contain the following :
----------------------------------------- dbconfig.xml
<?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://dbserver:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB</url><driver-class>com.mysql.jdbc.Driver</driver-class><username>root</username>
<password>123456</password>
<pool-size>20</pool-size>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis><time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
</jdbc-datasource>
</jira-database-config>
-------------------------------------------------------------
REBUILD AND BUT THE WAR FILE AT tomcat webapp and named it test.war .
Start tomcat .
the following error show to me at tomcat consol
http://www.4shared.com/download/s9pYBvyx/Unable_to_start_Jira.jpg<br< a="">>and the following at the home page of Jira
http://www.4shared.com/download/WCqkfz-r/Unable_to_start_Jira2.jpg
4 answers
hy nic i return engigeentity to the ORG.Copy but i get the following
2013-12-28 15:10:35,189 localhost-startStop-1 INFO [atlassian.jira.startup.JiraHomeStartupCheck] The jira.home directory 'D:\apache-tomcat-7.0.34\JiraApp' is validated and locked for exclusive use by this instance.
2013-12-28 15:10:35,225 localhost-startStop-1 INFO [jira.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from D:\apache-tomcat-7.0.34\JiraApp\dbconfig.xml
2013-12-28 15:10:35,323 localhost-startStop-1 INFO [atlassian.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2013-12-28 15:10:35,323 localhost-startStop-1 INFO [atlassian.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2013-12-28 15:10:35,453 localhost-startStop-1 INFO [jira.config.database.DatabaseConfigurationManagerImpl] Now running Database Checklist Launcher
2013-12-28 15:10:41,052 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Product Name is MySQL
2013-12-28 15:10:41,052 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Product Version is 5.5.27
2013-12-28 15:10:41,052 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Driver Name is MySQL-AB JDBC Driver
2013-12-28 15:10:41,053 localhost-startStop-1 INFO [core.entity.jdbc.DatabaseUtil] Database Driver Version is mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
2013-12-28 15:10:42,769 localhost-startStop-1 WARN [core.entity.transaction.JNDIFactory] NamingException while finding UserTransaction named java:comp/env/UserTransaction in JNDI.
javax.naming.NameNotFoundException: Name [UserTransaction] is not bound in this Context. Unable to find [UserTransaction].
at org.apache.naming.NamingContext.lookup(NamingContext.java:820)
at org.apache.naming.NamingContext.lookup(NamingContext.java:154)
at org.apache.naming.NamingContext.lookup(NamingContext.java:831)
at org.apache.naming.NamingContext.lookup(NamingContext.java:154)
at org.apache.naming.NamingContext.lookup(NamingContext.java:831)
at org.apache.naming.NamingContext.lookup(NamingContext.java:168)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:158)
at javax.naming.InitialContext.lookup(InitialContext.java:411)
at org.ofbiz.core.entity.transaction.JNDIFactory.getUserTransaction(JNDIFactory.java:113)
at org.ofbiz.core.entity.TransactionFactory.getUserTransaction(TransactionFactory.java:93)
at org.ofbiz.core.entity.TransactionUtil.getStatus(TransactionUtil.java:81)
at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:412)
at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:515)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1070)
at org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:630)
at org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:131)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:804)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:789)
at org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:766)
This is caused my mistakes in your jira.xml or ROOT.xml.
See https://confluence.atlassian.com/display/JIRA042/Installing+JIRA+on+Tomcat+6.0#InstallingJIRAonTomcat60-5ConfigureTomcatand look for the "resource name" instructions
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Er, that's absolutely clear on where the error is - you've messed up the entityengine.xml file.
Correct that and try again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
From the screenshot, I do agree with Nic on the JIRA is not able to talk to your database properly and it hints where the entitiesengine.xml and dbconfig.xml could not be parse correctly.
So first off, I think you should check on the permission given to the two files, make sure the application user is able to read the content of the files.
Second, if you still bumped into the same error, you might need to check the open tag and close tag where all the entries are properly closed.
This should be the items that I could think of based on my experience.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can post the text of an error here, it saves time (screenshots of plain text are slow, clunky and often don't help much because we only get a fraction of it)
The errors you are getting are probably happening because Jira is not able to talk to your database correctly. Check the logs above the error for database related errors.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
this link gos to log file of Jira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can't read it, it won't download, and my security software really doesn't like that site.
Please use a simple pastebin or post the errors here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<edit - this was posted when there was a chunk of log in a comment>
I'm afraid that does not tell us anything new. Your Jira installation cannot get a connection to your database.
Either your database is not set up correctly, your network is not set up to provide or allow the connection, or you have not got the right settings in the Jira database configuration.
Can you connect to the database with the MySQL command line from the Jira machine, with the same settings you are using for Jira? The command line errors you get from trying this are probably going to be smaller, quicker to get to and a lot more informative as you're not going through all the layers that Jira needs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Was this helpful?
Thanks!
Community showcase
Atlassian Community Events
- FAQ
- Community Guidelines
- About
- Privacy policy
- Notice at Collection
- Terms of use
- © 2024 Atlassian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.