geoffreychen831 / aabkoala Goto Github PK

environment:
  MYSQL_ROOT_PASSWORD: root
  MYSQL_DATABASE: dockerTest
  MYSQL_USER: client3
  MYSQL_PASSWORD: AA-koala123456

already specified initial database, but the docker does not create the specified database if volume mapping is set.

django.db.utils.OperationalError: (1045, 'Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory')

Receive this error when I run the manage.py, the extra package should be added to Development Environment

This occurs when I run 'python manage.py runserver'
According to this post on StackOverFlow (https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded), this is because the newer version of mysql is using a new encryption method called caching_sha2_password, which is not supported by django yet. Therefore the solution is to set the password encryption to the old method by this line of code

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<my-password>';

In our case, replace 'localhost' with '%'.

Although I don't understand why this is not an issue on Yunning's end.

The folder under the path AABKoala/apps/graphs/pycache/ should be added to .gitignore right?