Grant a privilege to zabbix user for "SHWO SLAVE STATUS"


If you can capture SQL Error Message, then you might see the message as below.

2017-01-01 01:01:01 zabbix[zabbix] @ localhost [] ERROR 1227: Access denied; you need (at least one of) the SUPER, REPLICATION CLIENT privilege(s) for this operation : SHOW SLAVE STATUS


You can check the privileges as below.

SELECT USER, HOST, SUPER_PRIV, REPL_CLIENT_PRIV 

FROM mysql.user

WHERE USER = 'zabbix';


Then you need to update the privileges.

Method #1. GRANT. (Recommendation)

GRANT REPLICATION CLIENT ON *.* TO 'zabbix'@'localhost';

GRANT REPLICATION CLIENT ON *.* TO 'zabbix'@'127.0.0.1';


Method #2. UPDATE.

UPDATE mysql.user

SET

  REPL_CLIENT_PRIV = 'Y'

WHERE USER = 'zabbix';



Now, check the privileges again.

SELECT USER, HOST, SUPER_PRIV, REPL_CLIENT_PRIV 

FROM mysql.user

WHERE USER = 'zabbix';


That's it.

저작자표시 비영리

HESPERANGE 산책로.


Hesper Park 에서 Alzette를 따라 걷다보면 마음의 평화를 얻을 수 있다.











저작자표시 비영리

How to change MariaDB error log from syslog to separated log file


On my.cnf, you can see the message like this.

# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.


Therefore, if you want to see MariaDB error Log, then you need to check syslog.

For e.g.

$ cat /var/log/syslog | grep "mysql"

$ cat /var/log/syslog | grep "mariadb"


You can change the configuration to edit "/etc/mysql/conf.d/mysqld_safe_syslog.cnf".

$ sudo vi /etc/mysql/conf.d/mysqld_safe_syslog.cnf


[mysqld_safe]

skip_log_error

#syslog


Afterward, input the error log file on my.cnf.

$ vi /etc/mysql/my.cnf

log_error = /var/log/mysql/error.log


Restart MariaDB.


Reference.

https://mariadb.com/kb/en/mariadb/error-log/


저작자표시 비영리

It's not possible to delete snapshot of virtualbox  

Result Code:  E_OUTOFMEMORY (0x8007000E)


Because it's too big.


Delete snapshot files in the snapshot folder manually.

Release and remove from Virtual Box Disk Manager.


Reference.

How To Troubleshoot VirutalBox Out of Storage

https://www.nextofwindows.com/virtualbox-unable-to-merge-not-enough-free-storage-space

저작자표시 비영리

How to fix unused shared library of user defined function error.

e.g. libmy_json_udf_path.so (json user function)


Error Messages on errorlog file.

[ERROR] Can't open shared library 'libmy_json_udf_path.so' (errno: 0, cannot open shared object file: No such file or directory)


Check mysql.func table.

select * from mysql.func;



Delete data on mysql.func and mysql.install_jsonudfs.

delete from mysql.func

where dl = 'libmy_json_udf_path.so';


DROP PROCEDURE IF EXISTS mysql.install_jsonudfs;


Restart MySQL(MariaDB).

저작자표시 비영리

+ Recent posts

티스토리툴바