Error in connecting to DB

Hello all,

I use frappe docker and add apps into it and test it and build locally in my machine. It worked fine and today I added LMS into the apps and created new site lms.localhost. While the LMS works, all the other apps started throwing error.

06:27:38 web.1      | 192.168.65.1 - - [25/Jul/2024 06:27:38] "GET / HTTP/1.1" 500 -
06:27:38 web.1      | Traceback (most recent call last):
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/app.py", line 99, in application
06:27:38 web.1      |     init_request(request)
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/app.py", line 195, in init_request
06:27:38 web.1      |     frappe.local.http_request = HTTPRequest()
06:27:38 web.1      |                                 ^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/auth.py", line 42, in __init__
06:27:38 web.1      |     self.set_session()
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/auth.py", line 76, in set_session
06:27:38 web.1      |     frappe.local.login_manager = LoginManager()
06:27:38 web.1      |                                  ^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/auth.py", line 118, in __init__
06:27:38 web.1      |     self.make_session(resume=True)
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/auth.py", line 206, in make_session
06:27:38 web.1      |     frappe.local.session_obj = Session(
06:27:38 web.1      |                                ^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/sessions.py", line 212, in __init__
06:27:38 web.1      |     self.resume()
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/sessions.py", line 296, in resume
06:27:38 web.1      |     self.validate_user()
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/sessions.py", line 220, in validate_user
06:27:38 web.1      |     if not frappe.get_cached_value("User", self.user, "enabled"):
06:27:38 web.1      |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/__init__.py", line 1310, in get_cached_value
06:27:38 web.1      |     doc = get_cached_doc(doctype, name)
06:27:38 web.1      |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/__init__.py", line 1253, in get_cached_doc
06:27:38 web.1      |     doc = get_doc(*args, **kwargs)
06:27:38 web.1      |           ^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/__init__.py", line 1379, in get_doc
06:27:38 web.1      |     doc = frappe.model.document.get_doc(*args, **kwargs)
06:27:38 web.1      |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/model/document.py", line 85, in get_doc
06:27:38 web.1      |     controller = get_controller(doctype)
06:27:38 web.1      |                  ^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/model/base_document.py", line 67, in get_controller
06:27:38 web.1      |     return import_controller(doctype)
06:27:38 web.1      |            ^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/model/base_document.py", line 82, in import_controller
06:27:38 web.1      |     doctype_info = frappe.db.get_value("DocType", doctype, fieldname="*")
06:27:38 web.1      |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/database/database.py", line 524, in get_value
06:27:38 web.1      |     result = self.get_values(
06:27:38 web.1      |              ^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/database/database.py", line 628, in get_values
06:27:38 web.1      |     out = self._get_values_from_table(
06:27:38 web.1      |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/database/database.py", line 901, in _get_values_from_table
06:27:38 web.1      |     return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
06:27:38 web.1      |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/query_builder/utils.py", line 84, in execute_query
06:27:38 web.1      |     result = frappe.db.sql(query, params, *args, **kwargs)  # nosemgrep
06:27:38 web.1      |              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/database/database.py", line 213, in sql
06:27:38 web.1      |     self.connect()
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/database/database.py", line 118, in connect
06:27:38 web.1      |     self._conn: "MariadbConnection" | "PostgresConnection" = self.get_connection()
06:27:38 web.1      |                                                              ^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 107, in get_connection
06:27:38 web.1      |     conn = self._get_connection()
06:27:38 web.1      |            ^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 113, in _get_connection
06:27:38 web.1      |     return self.create_connection()
06:27:38 web.1      |            ^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/apps/frappe/frappe/database/mariadb/database.py", line 116, in create_connection
06:27:38 web.1      |     return pymysql.connect(**self.get_connection_settings())
06:27:38 web.1      |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 361, in __init__
06:27:38 web.1      |     self.connect()
06:27:38 web.1      |   File "/workspace/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 669, in connect
06:27:38 web.1      |     self._request_authentication()
06:27:38 web.1      |   File "/workspace/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 957, in _request_authentication
06:27:38 web.1      |     auth_packet = self._read_packet()
06:27:38 web.1      |                   ^^^^^^^^^^^^^^^^^^^
06:27:38 web.1      |   File "/workspace/frappe-bench/env/lib/python3.11/site-packages/pymysql/connections.py", line 775, in _read_packet
06:27:38 web.1      |     packet.raise_for_error()
06:27:38 web.1      |   File "/workspace/frappe-bench/env/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in raise_for_error
06:27:38 web.1      |     err.raise_mysql_exception(self._data)
06:27:38 web.1      |   File "/workspace/frappe-bench/env/lib/python3.11/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
06:27:38 web.1      |     raise errorclass(errno, errval)
06:27:38 web.1      | pymysql.err.OperationalError: (1045, "Access denied for user '_b3f93b5ab3965632'@'172.23.0.3' (using password: YES)")
06:27:38 web.1      |

This is the error I am encountering and I didn’t make any changes to the site-config.json file or any other configs. Can anyone tell me what’s the issue and how I can resolve it?