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

Cannot connect to mysql DB #70

Closed
asdftd opened this issue Nov 26, 2022 · 2 comments
Closed

Cannot connect to mysql DB #70

asdftd opened this issue Nov 26, 2022 · 2 comments
Labels
wontfix This will not be worked on

Comments

@asdftd
Copy link

asdftd commented Nov 26, 2022

Hello,

while trying to start seafile-server:8.0.8 I am not able to connect to my mysql DB.
waiting for mysql server to be ready: %s (1045, "Access denied for user 'root'@'172.17.0.3' (using password: NO)") waiting for mysql server to be ready: %s (1045, "Access denied for user 'root'@'172.17.0.3' (using password: NO)") waiting for mysql server to be ready: %s (1045, "Access denied for user 'root'@'172.17.0.3' (using password: NO)")

Remote connections are possible to the db (tested it already). Mysql is running with Ver 8.0.30 and the new caching_sha2_password plugin is enabled.

If I revert back to the mysql_native_password auth I get:

waiting for mysql server to be ready: %s (2059, "Authentication plugin 'b'caching_sha2_password'' not configured")

Any ideas?

EDIT:
I am running it via docker run -p 127.0.0.1:8000:80 -d --rm -e HTTPS=true -e DB_HOST=XXXXXX -e DB_ROOT_PASSWD=XXXXXX -v seafile_new:/shared --name seafile_server ggogel/seafile-server:8.0.8

@asdftd
Copy link
Author

asdftd commented Nov 26, 2022

I had a look myself:
8.0.8 currently includes

root@7fc997cdf4b0:/# apt-cache policy python3-pymysql                                                                                                              
python3-pymysql:                                                                                                                                                   
  Installed: 0.8.0-1                                                                                                                                               
  Candidate: 0.8.0-1                                                                                                                                               
  Version table:                                                                                                                                                   
 *** 0.8.0-1 100                                                                                                                                                   
        100 /var/lib/dpkg/status

and 9.0.9 includes:

root@8f337df01d2a:/# apt-cache policy python3-pymysql
python3-pymysql:
  Installed: 0.9.3-2ubuntu3
  Candidate: 0.9.3-2ubuntu3
  Version table:
 *** 0.9.3-2ubuntu3 100
        100 /var/lib/dpkg/status

and the new caching_sha2_password auth method got introduced in v0.9 (https://salsa.debian.org/openstack-team/python/python-pymysql/-/blob/debian/zed/CHANGELOG.md), so I guess that's the root cause

@ggogel
Copy link
Owner

ggogel commented Nov 29, 2022

Hello, the official end of support of Seafile 8 Community Edition was almost one year ago. The images for version 8.0.8 are not maintained since over a year.

@ggogel ggogel closed this as completed Nov 29, 2022
@ggogel ggogel added the wontfix This will not be worked on label Nov 29, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
wontfix This will not be worked on
Projects
None yet
Development

No branches or pull requests

2 participants