Hi Everyone,
I have a production server of erpnext and now I want to copy this production setup to a testing server for testing changes before implementing in production,
First I installed the application using github documentation GitHub - frappe/bench: CLI to manage Multi-tenant deployments for Frappe apps and try to create same site to avoid database connectivity error. I tried later, copy the frappe directory from production to testing server on same username on same path and import the database in mariadb. But I am getting below error.
OperationalError: (1045, “Access denied for user ‘erpnext’@‘localhost’ (using password: YES)”)
I tried to change erpnext database password as it was in production mysql.user table but no success. I also check conf.py file but in this no database and password detail is given.
Complete error file is attached.
I have some other question:-
1. We need to change from mandatory to unmandatory option of purchase reciept no. in purchase return section. How can I do this.
2. How could I create a report for expiry item in next 30 days.
Thanks in advance.
Regards
Amit Bondwal
I am not able to attach file so complete error is given below:–
_mysql_exceptions.OperationalError
OperationalError: (1045, “Access denied for user ‘erpnext’@‘localhost’ (using password: YES)”)
Traceback (most recent call last)
File “/home/azureuser/erpnext/apps/frappe/frappe/middlewares.py”, line 15, in call
return super(StaticDataMiddleware, self).call(environ, start_response)
File “/home/azureuser/erpnext/env/lib/python2.7/site-packages/werkzeug/wsgi.py”, line 588, in call
return self.app(environ, start_response)
File “/home/azureuser/erpnext/env/lib/python2.7/site-packages/werkzeug/wsgi.py”, line 588, in call
return self.app(environ, start_response)
File “/home/azureuser/erpnext/env/lib/python2.7/site-packages/werkzeug/local.py”, line 224, in application
return ClosingIterator(app(environ, start_response), self.cleanup)
File “/home/azureuser/erpnext/env/lib/python2.7/site-packages/werkzeug/wrappers.py”, line 286, in application
return f(*args[:-2] + (request,))(*args[-2:])
File “/home/azureuser/erpnext/apps/frappe/frappe/app.py”, line 73, in application
response = frappe.website.render.render(“message”)
File “/home/azureuser/erpnext/apps/frappe/frappe/website/render.py”, line 44, in render
data = render_page(path)
File “/home/azureuser/erpnext/apps/frappe/frappe/website/render.py”, line 99, in render_page
return build(path)
File “/home/azureuser/erpnext/apps/frappe/frappe/website/render.py”, line 108, in build
return build_method(path)
File “/home/azureuser/erpnext/apps/frappe/frappe/website/render.py”, line 121, in build_page
context = get_context(path)
File “/home/azureuser/erpnext/apps/frappe/frappe/website/context.py”, line 30, in get_context
context = get_sitemap_options(path)
File “/home/azureuser/erpnext/apps/frappe/frappe/website/sitemap.py”, line 17, in get_sitemap_options
sitemap_options = build_sitemap_options(path)
File “/home/azureuser/erpnext/apps/frappe/frappe/website/sitemap.py”, line 24, in build_sitemap_options
sitemap_options = frappe._dict(frappe.get_doc(“Website Route”, path).as_dict())
File “/home/azureuser/erpnext/apps/frappe/frappe/init.py”, line 337, in get_doc
return frappe.model.document.get_doc(arg1, arg2)
File “/home/azureuser/erpnext/apps/frappe/frappe/model/document.py”, line 24, in get_doc
controller = get_controller(doctype)
File “/home/azureuser/erpnext/apps/frappe/frappe/model/document.py”, line 34, in get_controller
module = load_doctype_module(doctype)
File “/home/azureuser/erpnext/apps/frappe/frappe/modules/init.py”, line 49, in load_doctype_module
module = get_doctype_module(doctype)
File “/home/azureuser/erpnext/apps/frappe/frappe/modules/init.py”, line 45, in get_doctype_module
return frappe.db.get_value(‘DocType’, doctype, ‘module’) or “core”
File “/home/azureuser/erpnext/apps/frappe/frappe/database.py”, line 300, in get_value
ret = self.get_values(doctype, filters, fieldname, ignore, as_dict, debug)
File “/home/azureuser/erpnext/apps/frappe/frappe/database.py”, line 317, in get_values
return self.get_values_from_table(fields, filters, doctype, as_dict, debug, order_by, update)
File “/home/azureuser/erpnext/apps/frappe/frappe/database.py”, line 390, in get_values_from_table
conditions, order_by), filters, as_dict=as_dict, debug=debug, update=update)
File “/home/azureuser/erpnext/apps/frappe/frappe/database.py”, line 76, in sql
self.connect()
File “/home/azureuser/erpnext/apps/frappe/frappe/database.py”, line 47, in connect
Display the sourcecode for this frameOpen an interactive python shell in this frameuse_unicode=True, charset=‘utf8’)
File “/home/azureuser/erpnext/env/lib/python2.7/site-packages/MySQLdb/init.py”, line 81, in Connect
return Connection(*args, **kwargs)
File “/home/azureuser/erpnext/env/lib/python2.7/site-packages/MySQLdb/connections.py”, line 193, in init
super(Connection, self).init(*args, **kwargs2)
OperationalError: (1045, “Access denied for user ‘erpnext’@‘localhost’ (using password: YES)”)
The debugger caught an exception in your WSGI application. You can now look at the traceback which led to the error.
To switch between the interactive traceback and the plaintext one, you can click on the “Traceback” headline. From the text traceback you can also create a paste of it. For code execution mouse-over the frame you want to debug and click on the console icon on the right side.
You can execute arbitrary Python code in the stack frames and there are some extra helpers available for introspection:
dump() shows all variables in the frame
dump(obj) dumps all that’s known about the object
–
You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/f8e4698c-c4f6-4ef1-b857-433cbf5ff41a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.