run config.sh , but cannot configure database

I wonder what I have missed , so need your help here:

installed jira software on centos7, run config.sh to setup database

  1. cannot use mssql as it always set as H2
  2. giving a dbconfig.xml to have the configuration, jira still not working due to database issue

2 answers

0 vote

Sorry, what does "cannot use mssql" mean?  What is it doing that stops you using another database?

actually, I was trying to config database thru config.sh , and I did see the options for databases, but cannot make the selection.  

Right,  I cannot use MSSQL because my entry not taken

some info from log:

2017-12-28 10:13:16,199 JIRA-Bootstrap INFO      [c.a.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.

2017-12-28 10:13:16,221 JIRA-Bootstrap INFO      [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is not yet configured. Enqueuing Database Checklist Launcher on post-database-configured-but-pre-database-activated queue

2017-12-28 10:13:16,222 JIRA-Bootstrap INFO      [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is not yet configured. Enqueuing Post database-configuration launchers on post-database-activated queue

I'm sorry - "cannot make the selection" does not tell us what is wrong.

The log doesn't matter, it's the output from starting Jira after config.sh has been run, where we already know you've got a selection that isn't right.

0 vote

Hi Quan,

When you run config.sh what error do you get when you try to set the MySQL database?  If you can provide a screenshot that would be helpful. 

If you're not getting an error do you see anything in your logs around the time you set the database?  Also, you state JIRA is not working due to the database issue.  What do the logs say when you start JIRA?

Cheers,

Branden

not sure I get it right, here is the last part of the log:


2017-12-28 10:13:11,779 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml
2017-12-28 10:13:11,807 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml
2017-12-28 10:13:11,809 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml
2017-12-28 10:13:12,409 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml
2017-12-28 10:13:12,420 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger]

___ Starting the JIRA Plugin System _________________

2017-12-28 10:13:12,420 JIRA-Bootstrap INFO [c.a.plugin.manager.DefaultPluginManager] Plugin system earlyStartup begun
2017-12-28 10:13:14,375 JIRA-Bootstrap INFO [c.a.plugin.loaders.ScanningPluginLoader] No plugins found to be deployed
2017-12-28 10:13:14,683 JIRA-Bootstrap INFO [c.a.plugin.util.WaitUntil] Plugins that have yet to be enabled: (27): [tac.jira core.languages.da_DK, tac.jira core.languages.et_EE, tac.jira core.languages.pl_PL, tac.jira core.languages.sk_SK, tac.jira core.languages.sv_SE, com.atlassian.plugins.issue-status-plugin, tac.jira core.languages.no_NO, com.atlassian.soy.soy-template-plugin, com.atlassian.jira.jira-less-integration, tac.jira core.languages.cs_CZ, tac.jira core.languages.hu_HU, tac.jira core.languages.pt_BR, com.atlassian.jira.jira-languages.en_UK, tac.jira core.languages.ko_KR, tac.jira core.languages.is_IS, com.atlassian.jira.jira-languages.en_US, tac.jira core.languages.ru_RU, tac.jira core.languages.de_DE, tac.jira core.languages.es_ES, com.atlassian.plugins.less-transformer-plugin, com.atlassian.plugin.jslibs, tac.jira core.languages.fr_FR, tac.jira core.languages.ja_JP, com.atlassian.plugins.jquery, tac.jira core.languages.ro_RO, tac.jira core.languages.zh_CN, com.atlassian.auiplugin], 300 seconds remaining
2017-12-28 10:13:14,755 ThreadPoolAsyncTaskExecutor::Thread 5 WARN [c.a.p.s.scanner.util.ProductFilterUtil] Couldn't detect product, will use ProductFilter.ALL
28-Dec-2017 10:13:15.949 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler [http-nio-8100]
28-Dec-2017 10:13:15.957 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
28-Dec-2017 10:13:15.963 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 7429 ms
2017-12-28 10:13:16,114 JIRA-Bootstrap INFO [c.a.plugin.manager.DefaultPluginManager] Plugin system earlyStartup ended
2017-12-28 10:13:16,175 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml
2017-12-28 10:13:16,184 JIRA-Bootstrap INFO [c.a.j.instrumentation.external.DatabaseExternalGauges] Installing DBCP monitoring instruments: DatabaseExternalGauges.JiraDbcpInstruments[instruments=[DBCP_MAX, DBCP_ACTIVE, DBCP_IDLE],objectName=com.atlassian.jira:name=BasicDataSource]
2017-12-28 10:13:16,199 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2017-12-28 10:13:16,199 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully.
2017-12-28 10:13:16,221 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is not yet configured. Enqueuing Database Checklist Launcher on post-database-configured-but-pre-database-activated queue
2017-12-28 10:13:16,222 JIRA-Bootstrap INFO [c.a.j.config.database.DatabaseConfigurationManagerImpl] The database is not yet configured. Enqueuing Post database-configuration launchers on post-database-activated queue
2017-12-28 10:13:16,239 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 180 MiB. Committed: 483 MiB. Max: 741 MiB
Non-heap memory : Used: 64 MiB. Committed: 66 MiB. Max: 1264 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 244 MiB. Committed: 549 MiB. Max: 2005 MiB
---------------------------------------------------------------------------------

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,184 views 13 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot