Error connecting to database Unknown system variable 'default_storage_engine' : Mysql

[Deleted user]

Hi I am trying to configure Mysql database in JIRA facing connection issue. Below are the details

my.cnf:

--------

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

default-storage-engine=INNODB

max_allowed_packet=256M

innodb_log_file_size=256M

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

-----------------------------------------------------------------------------------------------------------------------------------
Mysql version: 5.1.73

JIRA  version: 7.3.2

Below is log file error

http-nio-8090-exec-20 ERROR anonymous 903x201x1 kq783f 10.1.16.114 /secure/SetupDatabase!connectionCheck.jspa [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:

java.sql.SQLException: Unknown system variable 'default_storage_engine'

    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)

    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)

    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)

    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)

    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)

    at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1540)

    at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2595)

    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1468)

    at com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5059)

    at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3255)

    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2297)

    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)

    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)

    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

    ... 3 filtered

    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

    at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)

    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)

    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)

    at java.sql.DriverManager.getConnection(DriverManager.java:664)

    at java.sql.DriverManager.getConnection(DriverManager.java:247)

    at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.getTestDatabaseConnection(DefaultAtlassianBootstrapManager.java:347)

    at com.atlassian.jira.config.database.JdbcDatasource.getConnection(JdbcDatasource.java:211)

    at com.atlassian.jira.config.database.DatabaseConfig.testConnection(DatabaseConfig.java:87)

    at com.atlassian.jira.web.action.setup.SetupDatabase.testConnection(SetupDatabase.java:225)

    at com.atlassian.jira.web.action.setup.SetupDatabase.doValidation(SetupDatabase.java:189)

    at com.atlassian.jira.web.action.setup.SetupDatabase.doConnectionCheck(SetupDatabase.java:121)

    ... 3 filtered

    at java.lang.reflect.Method.invoke(Method.java:498)

    at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70)

    at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56)

    ... 2 filtered

    at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)

    ... 7 filtered

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

    ... 49 filtered

    at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:80)

    ... 1 filtered

    at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:78)

    ... 28 filtered

    at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)

    ... 27 filtered

    at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)

    ... 28 filtered

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

    at java.lang.Thread.run(Thread.java:745)

[Nancy Tomaselli]

I have the same error, even when replacing - by _ in my.cnf

[Gaston Valente]

Hi,

Are you using MySQL 5.7?

Check: https://jira.atlassian.com/browse/JRA-40198

[Deleted user]

Mysql version: 5.1.73

[Gaston Valente]

Ok, are you using Atlassian configuration tool yo setup the dbconfig.xml?

Can you post the dbconfig.xml file?

[Deleted user]

This is first time I am installing Jira, I am trying in setup wizard.

[Nic Brough -Adaptavist-]

Have a closer look at how you have used - and _ in your posted mysql.cnf