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

[FEATURE] Add mysql 8.4 compatibility #1309

Closed
thelittlefireman opened this issue Jun 26, 2024 · 0 comments
Closed

[FEATURE] Add mysql 8.4 compatibility #1309

thelittlefireman opened this issue Jun 26, 2024 · 0 comments
Assignees
Labels
enhancement New feature or request

Comments

@thelittlefireman
Copy link
Contributor

What's needed and why?

Backup configuration is not working with mysql 8.4
Mysql has removed the --default-authentication-plugin has been removed in mysql 8.4 and rename to --mysql-native-password=ON` but backup configuration is still not working even with that's option.

Failed to dump the database: mysqldump: Got error: 1045: "Plugin caching_sha2_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching_sha2_password.so: No such file or directory" when trying to connect

my mysql docker configuration is as follows (latest mysql 8.4)

  bw-db:
    image: mysql:latest
    container_name: bw-db
    user: "1024:101"
    environment:
      - MYSQL_ROOT_PASSWORD=XXXXXX
      - MYSQL_DATABASE=db
      - MYSQL_USER=bunkerweb
      - MYSQL_PASSWORD=XXXXX
    command: --mysql-native-password=ON
    expose:
      - 3306
    volumes:
      - "./nginx/db:/var/lib/mysql"
    networks:
      - bw-universe

This is happening since bunker web 1.5.4
It's just the dump command which get an issue, every other actions on database are working.

[2024-06-25 17:35:34 +0000] [CUSTOM-CERT] [176] [ℹ️ ] - ✅ Database connection established
[2024-06-25 17:35:34 +0000] [LETS-ENCRYPT.NEW] [187] [ℹ️ ] - ✅ Database connection established


Follow [https://discord.com/channels/854285298476646421/1255218557474836601](https://discord.com/channels/854285298476646421/1255218557474836601)

### Implementations ideas (optional)

_No response_

### Code of Conduct

- [X] I agree to follow this project's Code of Conduct
@thelittlefireman thelittlefireman added the enhancement New feature or request label Jun 26, 2024
@TheophileDiot TheophileDiot self-assigned this Jun 26, 2024
TheophileDiot added a commit that referenced this issue Jun 26, 2024
By adding this dependency we fix the ```
Failed to dump the database: mysqldump: Got error: 1045: "Plugin caching_sha2_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching_sha2_password.so: No such file or directory" when trying to connect```
Error when using a mysql database
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants