nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot connect MySQL database to Confluence

Anthony_1uci4g

Hi,

we have to follow all instruction so setup MySQL database for Confluence but t didn't work for us. We always get the message: "Your database needs to use InnoDB as the default storage engine." Our my.cnf and my.ini. has been edited in /root/my.cnf and /root/my.ini and /etc/my.cnf as:

[mysqld]
character-set-server=utf8
collation-server=utf8_bin
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB
transaction-isolation=READ-COMMITTED
binlog_format=row

after all we don't have any luck, we still get the message "Your database needs to use InnoDB as the default storage engine."

we also heave find my.cnf in following paths but we didn't edited all of them:

/etc/my.cnf
/usr/share/mysql-test/suite/ndb_team/my.cnf
/usr/share/mysql-test/suite/ndb/my.cnf
/usr/share/mysql-test/suite/ndb_big/my.cnf
/usr/share/mysql-test/suite/rpl_ndb/my.cnf
/usr/share/mysql-test/suite/federated/my.cnf
/usr/share/mysql-test/suite/ndb_rpl/my.cnf
/usr/share/mysql-test/suite/rpl/extension/bhs/my.cnf
/usr/share/mysql-test/suite/rpl/my.cnf
/usr/share/mysql-test/suite/ndb_binlog/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/ndb_team/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/ndb/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/ndb_big/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/rpl_ndb/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/federated/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/ndb_rpl/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/rpl/extension/bhs/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/rpl/my.cnf
/home/virtfs/testserver/usr/share/mysql-test/suite/ndb_binlog/my.cnf
/home/virtfs/testserver/etc/my.cnf

We really need help ASAP, Thank you.

Accepted answers

Alexis Robert

Hello @Anthony,

after you made the change to your configuration file, did you properly reload/restart the MySQL service ?

Also, can you specify what version of MySQL you're using ?

--Alexis

All comments

Alexis Robert

Hello @Anthony,

after you made the change to your configuration file, did you properly reload/restart the MySQL service ?

Also, can you specify what version of MySQL you're using ?

--Alexis

Anthony_1uci4g

Hi Alexis,

thank you for prompt response.

Yes we did restart the MySQL in few ways:

Following commands DID NOT work:

1. # /etc/init.d/mysqld stop: No such file or directory

2. # /etc/init.d/mysql stop: No such file or directory

3. # service mysqld stop
Redirecting to /bin/systemctl start mysql.service
Failed to start mysqld.service: Unit not found.

Following commands DID work:

4. # service mysql stop
Redirecting to /bin/systemctl start mysql.service

5. service mysql status (was Active: inactive (dead))

6. # service mysql start
Redirecting to /bin/systemctl start mysql.service

7. # service mysql status (was Active: active (running))

MySQL version 14.14 Distrib 5.6.39, for Linux (x86_64) using EditLine wrapper

Error screenshot

Alexis Robert

Hi @Anthony,

can you connect to your database isntance, select your Confluence database and execute this query:

<span>SHOW</span> <span>TABLE</span> <span>STATUS</span><span>;</span>

Just to make sure that your instance is indeed using INNODB.

Thanks,

--Alexis

Anthony_1uci4g

mysql> use confluence;
Database changed
mysql> SHOW TABLE STATUS;
Empty set (0.00 sec)

that's all we get.

Anthony_1uci4g

Hi,

I was followed @Alexis Robert advice "uninstalling and reinstalling completely MySQL with the same MySQL version 5.6.39 " after that everything was great. Our InnoDB has changed to default-storage-engine=INNODB.

Thank you @Alexis Robert for your help

Alexis Robert

Good to hear @Anthony !

Please mark my answer as accepted so that other people can find this and fix similar issues

--Alexis

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-server