topic Re: Expedition OS Settings Log_bin Flag in Expedition Discussions

Expedition OS Settings Log_bin Flag

Gene_Barden — Thu, 17 Jan 2019 18:55:32 GMT

I have upgraded Expedition and am now getting an error under OS Settings stating 'Verify that the Log_bin flag in MariaDB is set to off". Where is the MariaDB located to edit?

Re: Expedition OS Settings Log_bin Flag

dgildelaig — Fri, 18 Jan 2019 11:18:43 GMT

You should be able to set it into

/etc/mysql/my.conf

#auto_increment_offset  = 1
skip-log_bin                    = /var/log/mysql/mariadb-bin
skip-log_bin_index              = /var/log/mysql/mariadb-bin.index

Defining the skip-log_bin will set the login to OFF.

The above is an example I am running in my instance

Re: Expedition OS Settings Log_bin Flag

Gene_Barden — Fri, 18 Jan 2019 13:38:38 GMT

Thanks fro the information. I have applied the above configuration but it still shows the same error message.

Re: Expedition OS Settings Log_bin Flag

dgildelaig — Mon, 21 Jan 2019 08:43:34 GMT

If I can guess, I would say you missed restarting the mysql service.

sudo service mysql restart

Re: Expedition OS Settings Log_bin Flag

Retired Member — Sun, 17 Feb 2019 23:53:00 GMT

Worked great. Thanks!

Re: Expedition OS Settings Log_bin Flag

jlieberman — Sun, 22 Dec 2019 03:49:00 GMT

I have applied the above config and restarted mysql but still see

Verify that the Log_bin flag in MariaDB is set to off

For me the answer was that the conf file that needs editing is called /etc/mysql/my.cnf

now all green!!