Solved mysql reading problem
#23
Probably shouldn't resurrect an old post like this one, but it's the only one Google turns up.

I finally upgraded to 13.2, and got the dreaded:

Code:
ERROR: SQL: Undefined MySQL error: Code (1419)

There's a really easy way to fix this without granting SUPER privileges. I read into the SUPER privilege and it allows for things like killing mysql threads to accounts other than your own, as well as modifying global settings in mysql. This really shouldn't be enabled on a user account, especially since I also use mysql for mythtv and I don't want them to be able to trash each other's databases.

I'm using mariadb, I tried going to mysql and it made no difference (despite what the bugtracker says.)

That error is telling you binary logging is enabled on the server. It is generally used for replication, so on most XBMC installs you don't need it.

Anyway, a quicker way is to check the status. In the mysql client check this parameter (you'll need to be root most likely):
Code:
mysql> show global variables like 'log_bin_trust_function_creators';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF   |
+---------------------------------+-------+
1 row in set (0.00 sec)

As you can see it's set to off.

BEFORE running xbmc, go to the mysql backend and set it with the client:

Code:
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
Query OK, 0 rows affected (0.00 sec)

Then check it:
Code:
mysql> show global variables like 'log_bin_trust_function_creators';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | ON    |
+---------------------------------+-------+
1 row in set (0.00 sec)

Make sure the incomplete tables are dropped, then run XBMC and let it do its upgrade. When it's done, set it back the way it was:

Code:
mysql> SET GLOBAL log_bin_trust_function_creators = 0;
Query OK, 0 rows affected (0.00 sec)

Hopefully this will help someone else.
Reply


Messages In This Thread
mysql reading problem - by Edwinus - 2014-02-15, 01:25
RE: mysql reading problem - by Kib - 2014-02-15, 10:58
RE: mysql reading problem - by Edwinus - 2014-02-15, 12:20
RE: mysql reading problem - by Edwinus - 2014-02-16, 23:34
RE: mysql reading problem - by nickr - 2014-02-16, 23:39
RE: mysql reading problem - by Edwinus - 2014-02-17, 06:06
RE: mysql reading problem - by nickr - 2014-02-17, 07:25
RE: mysql reading problem - by Kib - 2014-02-17, 12:44
RE: mysql reading problem - by Edwinus - 2014-02-18, 01:18
RE: mysql reading problem - by nickr - 2014-02-18, 02:51
RE: mysql reading problem - by Edwinus - 2014-02-18, 12:09
RE: mysql reading problem - by nickr - 2014-02-18, 21:07
RE: mysql reading problem - by Edwinus - 2014-02-18, 21:31
RE: mysql reading problem - by nickr - 2014-02-18, 21:41
Re: mysql reading problem - by Milhouse - 2014-02-19, 12:58
RE: mysql reading problem - by Edwinus - 2014-02-19, 13:27
RE: mysql reading problem - by Milhouse - 2014-02-19, 14:14
RE: mysql reading problem - by Edwinus - 2014-02-19, 18:53
RE: mysql reading problem - by Milhouse - 2014-02-19, 19:12
RE: mysql reading problem - by Edwinus - 2014-02-20, 00:01
RE: mysql reading problem - by Milhouse - 2014-02-20, 00:30
RE: mysql reading problem - by Edwinus - 2014-02-20, 19:21
RE: mysql reading problem - by danomac - 2015-03-18, 03:57
RE: mysql reading problem - by unrequited - 2017-12-01, 08:21
RE: mysql reading problem - by fizze - 2016-07-15, 19:31
RE: mysql reading problem - by bigwang - 2017-01-19, 07:19
RE: mysql reading problem - by danomac - 2017-01-19, 08:11
RE: mysql reading problem - by killbilly - 2020-01-16, 05:26
RE: mysql reading problem - by killbilly - 2020-01-17, 04:10
RE: mysql reading problem - by black_eagle - 2020-01-17, 21:26
RE: mysql reading problem - by pkscout - 2020-01-18, 00:21


Logout Mark Read Team Forum Stats Members Help
mysql reading problem0
This forum uses Lukasz Tkacz MyBB addons.