Installed frappe, erpnext using frappe-docker as per its instructions in dev mode
Everythingwas fine and coudl access the site
Went going thorugh the tutorial - create a new app and new site.
Create the library management app to understand teh frappe framework
Was able to login initially when it was created but once I restarted today got this error:
pymysql.err.OperationalError
pymysql.err.OperationalError: (1045, “Access denied for user ‘_ad03fa1a016ca1c4’@‘172.19.0.3’ (using password: YES)”)
Traceback (most recent call last)
init_request(request)
frappe.local.http_request = frappe.auth.HTTPRequest()
self.set_session()
frappe.local.login_manager = LoginManager()
self.make_session(resume=True)
full_name=self.full_name, user_type=self.user_type)
self.resume()
data = self.get_session_record()
-
File “/workspace/development/frappe-bench/apps/frappe/frappe/sessions.py”, line 273 , in
get_session_record
r = self.get_session_data()
-
File “/workspace/development/frappe-bench/apps/frappe/frappe/sessions.py”, line 289 , in
get_session_data
data = self.get_session_data_from_db()
-
File “/workspace/development/frappe-bench/apps/frappe/frappe/sessions.py”, line 311 , in
get_session_data_from_db
self.device = frappe.db.sql(‘SELECT device
FROM tabSessions
WHERE sid
=%s’, self.sid)
-
File “/workspace/development/frappe-bench/apps/frappe/frappe/database/database.py”, line 122 , in
sql
self.connect()
-
File “/workspace/development/frappe-bench/apps/frappe/frappe/database/database.py”, line 75 , in
connect
self._conn = self.get_connection()
-
File “/workspace/development/frappe-bench/apps/frappe/frappe/database/mariadb/database.py”, line 90 , in
get_connection
local_infile = frappe.conf.local_infile)
-
File “/workspace/development/frappe-bench/env/lib/python3.7/site-packages/pymysql/init.py”, line 94 , in
Connect
return Connection(*args, **kwargs)
-
File “/workspace/development/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 325 , in
__init__
self.connect()
-
File “/workspace/development/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 599 , in
connect
self._request_authentication()
-
File “/workspace/development/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 861 , in
_request_authentication
auth_packet = self._read_packet()
-
File “/workspace/development/frappe-bench/env/lib/python3.7/site-packages/pymysql/connections.py”, line 684 , in
_read_packet
Tried some solutions posted:
site_config looks fine with a user, password and DB (I guess it sis encrypted)
$ bench --site library.test mariadb
ERROR 1045 (28000): Access denied for user ‘_ad03fa1a016ca1c4’@‘172.19.0.3’ (using password: YES)
$mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/run/mysqld/mysqld.sock’ (2)
Not sure why the system tries to conect to 172.19.0.3
Did some reading - but the file above does not exist ‘/run/mysqld/mysqld.sock’ (2)’ at the path
Does anyone know the solution?
Installing a site creates a DB. Is it created incorrectly? Did not try anything fancy. Just followed the tutorial of frappe.