Mysqldump: Couldn't execute 'show events'

Support
1

NethServer Version: 7.9
Module: Automysqlbackup

Since a few days, I receive error mails.

Subject: ERRORS REPORTED: MySQL Backup error Log for MY-NethServer - 2022-02-22_03h01m

Content:
mysqldump: Couldn't execute 'show events': Cannot proceed, because event scheduler is disabled (1577)

Parallel to this comes another mail.
Subject: MySQL Backup Log for MY-NethServer - 2022-02-22_03h01m
Content: normal status messages about the successful execution of automysql

What has happened here?

Best regards, Marko

2

I think it’s just a warning. Which mariadb versions do you use?

Here are instructions how to enable the event scheduler:

https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html

1 Like
3

I use…

[root@MDOL-NethServer rh]# pwd
/opt/rh
[root@MDOL-NethServer rh]# ll
total 0
dr-xr-xr-x 3 root root  59 Jan 15 20:16 rh-mariadb103
dr-xr-xr-x 3 root root  59 Jan 16 15:35 rh-mariadb105
dr-xr-xr-x 6 root root 128 Jan 15 18:48 rh-php73
4

strangely enough I can log in with mysql and mysql103 but not with mysql105

# mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 219
Server version: 5.5.68-MariaDB MariaDB Server

# mysql103

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9351
Server version: 10.3.28-MariaDB MariaDB Server

# mysql105

-bash: mysql105: command not found

5

That’s not an issue. AFAIK nethserver-mariadb105 doesn’t provide the mysql105 alias like previous mariadb10 packages.

2 Likes
6

Hi Markuz,
what is the correct alis for mysql105 monitor access ?

7

Hi Simone,

welcome to NethServer Community.

There are no aliases configured for rh-mariadb105. AFAIK rh-mysql105 is used by Nextcloud and provides socket connections only.

Here is an example of using mysql105 and the Nextcloud-mysql socket:

/opt/rh/rh-mariadb105/root/bin/mysql --socket=/var/run/rh-mariadb105-mariadb/nextcloud-mysql.sock

For preconfigured alias and network ports I recommend to install the Community package nethserver-mariadb103.

3 Likes