Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Doesn't seem to support mysql/mysql-operator #280

Open
FanKang2021 opened this issue Nov 12, 2024 · 2 comments
Open

Doesn't seem to support mysql/mysql-operator #280

FanKang2021 opened this issue Nov 12, 2024 · 2 comments

Comments

@FanKang2021
Copy link

I inserted the plugin into the mysql/community-server image, but it failed to initialize:

2024-11-11T06:45:56.168676Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-11-11T06:45:56.169035Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2024-11-11T06:45:56.169103Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2024-11-11T06:45:56.169288Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose_auth_socket=FORCE_PLUS_PERMANENT'.
2024-11-11T06:45:56.169311Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose_group_replication_recovery_use_ssl=1'.
2024-11-11T06:45:56.170112Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2024-11-11T06:45:56.170197Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2024-11-11T06:45:56.170350Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-11-11T06:45:56.171610Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.

My configuration is as follows:

[mysqld]
plugin-load=AUDIT=libaudit_plugin.so
audit_json_file=on
@FanKang2021
Copy link
Author

My version is 8.0.36.

@FanKang2021
Copy link
Author

2024-11-14T03:06:36.542402Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose_auth_socket=FORCE_PLUS_PERMANENT'.
2024-11-14T03:06:36.542476Z 0 [Warning] [MY-000067] [Server] unknown variable 'loose_group_replication_recovery_use_ssl=1'.
2024-11-14T03:06:36.568948Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2024-11-14T03:06:36.569047Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5
2024-11-14T03:06:36.569694Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2024-11-14T03:06:36.570158Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.36' socket: '/var/run/mysqld/mysql.sock' port: 3306 MySQL Community Server - GPL.
2024-11-14T03:06:36.570238Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2024-11-14T03:06:36.581998Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-11-14T03:06:36.582283Z 8 [Note] [MY-010926] [Server] Access denied for user 'localroot'@'localhost' (using password: NO)
2024-11-14T03:06:40.633697Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-11-14T03:06:40.633888Z 9 [Note] [MY-010926] [Server] Access denied for user 'localroot'@'localhost' (using password: NO)
2024-11-14T03:06:40.979164Z 10 [Note] [MY-010926] [Server] Access denied for user 'mysqlhealthchecker'@'localhost' (using password: NO)
2024-11-14T03:06:45.968604Z 11 [Note] [MY-010926] [Server] Access denied for user 'mysqlhealthchecker'@'localhost' (using password: NO)

when i configuration my.cnf after,it's not work still:
plugin-load=AUDIT=libaudit_plugin.so
default_authentication_plugin=caching_sha2_password

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant