Aftre restore Login Problam

Galaxy_Lab · March 25, 2024, 6:15pm

i installed My custom App in new bench , and i get beckup from the old bench and restored to new bench , aftre this Opration while im tring to login with old password , even new login password is not working , if any one have experince this issue , i need help to solve, Thanks to All ,

17:41:05 system | redis_cache.1 started (pid=2898)
17:41:05 system | redis_queue.1 started (pid=2902)
17:41:05 redis_queue.1 | 2911:C 25 Mar 2024 17:41:05.453 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
17:41:05 redis_queue.1 | 2911:C 25 Mar 2024 17:41:05.453 # Redis version=6.0.16, bits=64, commit=00000000, modified=0, pid=2911, just started
17:41:05 redis_queue.1 | 2911:C 25 Mar 2024 17:41:05.453 # Configuration loaded
17:41:05 redis_cache.1 | 2912:C 25 Mar 2024 17:41:05.454 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
17:41:05 redis_cache.1 | 2912:C 25 Mar 2024 17:41:05.454 # Redis version=6.0.16, bits=64, commit=00000000, modified=0, pid=2912, just started
17:41:05 redis_cache.1 | 2912:C 25 Mar 2024 17:41:05.454 # Configuration loaded
17:41:05 redis_cache.1 | 2912:M 25 Mar 2024 17:41:05.456 * Running mode=standalone, port=13003.
17:41:05 system | web.1 started (pid=2903)
17:41:05 redis_queue.1 | 2911:M 25 Mar 2024 17:41:05.456 * Running mode=standalone, port=11003.
17:41:05 redis_queue.1 | 2911:M 25 Mar 2024 17:41:05.456 # Server initialized
17:41:05 system | watch.1 started (pid=2908)
17:41:05 redis_cache.1 | 2912:M 25 Mar 2024 17:41:05.456 # Server initialized
17:41:05 redis_queue.1 | 2911:M 25 Mar 2024 17:41:05.456 * Ready to accept connections
17:41:05 system | socketio.1 started (pid=2906)
17:41:05 system | schedule.1 started (pid=2907)
17:41:05 system | worker.1 started (pid=2914)
17:41:05 redis_cache.1 | 2912:M 25 Mar 2024 17:41:05.458 * Ready to accept connections
17:41:06 socketio.1 | Realtime service listening on: 9003
17:41:06 watch.1 |
17:41:07 watch.1 | yarn run v1.22.21
17:41:07 watch.1 | $ node esbuild --watch --live-reload
17:41:07 web.1 | WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.
17:41:07 web.1 | * Running on all addresses (0.0.0.0)
17:41:07 web.1 | * Running on http://127.0.0.1:8003
17:41:07 web.1 | * Running on http://86.38.217.149:8003
17:41:07 web.1 | Press CTRL+C to quit
17:41:07 web.1 | * Restarting with stat
17:41:08 web.1 | * Debugger is active!
17:41:08 web.1 | * Debugger PIN: 781-599-052
17:41:28 watch.1 | Watching for changes…
17:41:55 web.1 | 127.0.0.1 - - [25/Mar/2024 17:41:55] “GET / HTTP/1.1” 200 -
17:41:56 web.1 | 127.0.0.1 - - [25/Mar/2024 17:41:56] “GET /assets/frappe/dist/css/website.bundle.JTH2NVIC.css HTTP/1.1” 200 -
17:42:03 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:03] “GET /assets/frappe/dist/css/login.bundle.RDEVPKND.css HTTP/1.1” 200 -
17:42:03 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:03] “GET /assets/frappe/dist/js/frappe-web.bundle.HSVFQVVL.js HTTP/1.1” 200 -
17:42:03 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:03] “GET /website_script.js HTTP/1.1” 200 -
17:42:03 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:03] “GET /assets/frappe/images/frappe-framework-logo.svg HTTP/1.1” 200 -
17:42:16 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:16] “GET /assets/frappe/css/fonts/inter/InterVariable.woff2 HTTP/1.1” 200 -
17:42:16 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:16] “GET / HTTP/1.1” 200 -
17:42:44 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:44] “GET / HTTP/1.1” 200 -
17:42:47 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:47] “GET /website_script.js HTTP/1.1” 200 -
17:42:48 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:48] “GET /assets/frappe/images/frappe-favicon.svg HTTP/1.1” 200 -
17:42:48 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:48] “GET /assets/frappe/dist/js/file_uploader.bundle.REGIG6HK.js HTTP/1.1” 200 -
17:42:59 web.1 | Traceback (most recent call last):
17:42:59 web.1 | File “apps/frappe/frappe/app.py”, line 95, in application
17:42:59 web.1 | init_request(request)
17:42:59 web.1 | File “apps/frappe/frappe/app.py”, line 191, in init_request
17:42:59 web.1 | frappe.local.http_request = HTTPRequest()
17:42:59 web.1 | File “apps/frappe/frappe/auth.py”, line 42, in init
17:42:59 web.1 | self.set_session()
17:42:59 web.1 | File “apps/frappe/frappe/auth.py”, line 76, in set_session
17:42:59 web.1 | frappe.local.login_manager = LoginManager()
17:42:59 web.1 | File “apps/frappe/frappe/auth.py”, line 114, in init
17:42:59 web.1 | self.run_trigger(“on_session_creation”)
17:42:59 web.1 | File “apps/frappe/frappe/auth.py”, line 301, in run_trigger
17:42:59 web.1 | frappe.call(frappe.get_attr(method), login_manager=self)
17:42:59 web.1 | File “apps/frappe/frappe/init.py”, line 1798, in call
17:42:59 web.1 | return fn(*args, **newargs)
17:42:59 web.1 | File “apps/frappe/frappe/core/doctype/activity_log/feed.py”, line 14, in login_feed
17:42:59 web.1 | add_authentication_log(subject, login_manager.user)
17:42:59 web.1 | File “apps/frappe/frappe/core/doctype/activity_log/activity_log.py”, line 73, in add_authentication_log
17:42:59 web.1 | frappe.get_doc(
17:42:59 web.1 | File “apps/frappe/frappe/model/document.py”, line 307, in insert
17:42:59 web.1 | self.run_method(“after_insert”)
17:42:59 web.1 | File “apps/frappe/frappe/model/document.py”, line 967, in run_method
17:42:59 web.1 | run_webhooks(self, method)
17:42:59 web.1 | File “apps/frappe/frappe/integrations/doctype/webhook/init.py”, line 44, in run_webhooks
17:42:59 web.1 | webhooks = frappe.cache.get_value(“webhooks”, get_all_webhooks)
17:42:59 web.1 | File “apps/frappe/frappe/utils/redis_wrapper.py”, line 100, in get_value
17:42:59 web.1 | val = generator()
17:42:59 web.1 | File “apps/frappe/frappe/integrations/doctype/webhook/init.py”, line 19, in get_all_webhooks
17:42:59 web.1 | webhooks_list = frappe.get_all(
17:42:59 web.1 | File “apps/frappe/frappe/init.py”, line 2087, in get_all
17:42:59 web.1 | return get_list(doctype, *args, **kwargs)
17:42:59 web.1 | File “apps/frappe/frappe/init.py”, line 2062, in get_list
17:42:59 web.1 | return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
17:42:59 web.1 | File “apps/frappe/frappe/model/db_query.py”, line 190, in execute
17:42:59 web.1 | result = self.build_and_run()
17:42:59 web.1 | File “apps/frappe/frappe/model/db_query.py”, line 231, in build_and_run
17:42:59 web.1 | return frappe.db.sql(
17:42:59 web.1 | File “apps/frappe/frappe/database/database.py”, line 224, in sql
17:42:59 web.1 | self._cursor.execute(query, values)
17:42:59 web.1 | File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute
17:42:59 web.1 | result = self._query(query)
17:42:59 web.1 | File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query
17:42:59 web.1 | conn.query(q)
17:42:59 web.1 | File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 558, in query
17:42:59 web.1 | self._affected_rows = self._read_query_result(unbuffered=unbuffered)
17:42:59 web.1 | File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 822, in _read_query_result
17:42:59 web.1 | result.read()
17:42:59 web.1 | File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1200, in read
17:42:59 web.1 | first_packet = self.connection._read_packet()
17:42:59 web.1 | File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 772, in _read_packet
17:42:59 web.1 | packet.raise_for_error()
17:42:59 web.1 | File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
17:42:59 web.1 | err.raise_mysql_exception(self._data)
17:42:59 web.1 | File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
17:42:59 web.1 | raise errorclass(errno, errval)
17:42:59 web.1 | pymysql.err.OperationalError: (1054, “Unknown column ‘background_jobs_queue’ in ‘field list’”)
17:42:59 web.1 |
17:42:59 web.1 | 127.0.0.1 - - [25/Mar/2024 17:42:59] “POST /login HTTP/1.1” 500 -
18:06:55 web.1 | 127.0.0.1 - - [25/Mar/2024 18:06:55] “GET / HTTP/1.1” 200 -
18:06:56 web.1 | 127.0.0.1 - - [25/Mar/2024 18:06:56] “GET /website_script.js HTTP/1.1” 200 -
18:07:08 web.1 | Traceback (most recent call last):
18:07:08 web.1 | File “apps/frappe/frappe/app.py”, line 95, in application
18:07:08 web.1 | init_request(request)
18:07:08 web.1 | File “apps/frappe/frappe/app.py”, line 191, in init_request
18:07:08 web.1 | frappe.local.http_request = HTTPRequest()
18:07:08 web.1 | File “apps/frappe/frappe/auth.py”, line 42, in init
18:07:08 web.1 | self.set_session()
18:07:08 web.1 | File “apps/frappe/frappe/auth.py”, line 76, in set_session
18:07:08 web.1 | frappe.local.login_manager = LoginManager()
18:07:08 web.1 | File “apps/frappe/frappe/auth.py”, line 114, in init
18:07:08 web.1 | self.run_trigger(“on_session_creation”)
18:07:08 web.1 | File “apps/frappe/frappe/auth.py”, line 301, in run_trigger
18:07:08 web.1 | frappe.call(frappe.get_attr(method), login_manager=self)
18:07:08 web.1 | File “apps/frappe/frappe/init.py”, line 1798, in call
18:07:08 web.1 | return fn(*args, **newargs)
18:07:08 web.1 | File “apps/frappe/frappe/core/doctype/activity_log/feed.py”, line 14, in login_feed
18:07:08 web.1 | add_authentication_log(subject, login_manager.user)
18:07:08 web.1 | File “apps/frappe/frappe/core/doctype/activity_log/activity_log.py”, line 73, in add_authentication_log
18:07:08 web.1 | frappe.get_doc(
18:07:08 web.1 | File “apps/frappe/frappe/model/document.py”, line 307, in insert
18:07:08 web.1 | self.run_method(“after_insert”)
18:07:08 web.1 | File “apps/frappe/frappe/model/document.py”, line 967, in run_method
18:07:08 web.1 | run_webhooks(self, method)
18:07:08 web.1 | File “apps/frappe/frappe/integrations/doctype/webhook/init.py”, line 44, in run_webhooks
18:07:08 web.1 | webhooks = frappe.cache.get_value(“webhooks”, get_all_webhooks)
18:07:08 web.1 | File “apps/frappe/frappe/utils/redis_wrapper.py”, line 100, in get_value
18:07:08 web.1 | val = generator()
18:07:08 web.1 | File “apps/frappe/frappe/integrations/doctype/webhook/init.py”, line 19, in get_all_webhooks
18:07:08 web.1 | webhooks_list = frappe.get_all(
18:07:08 web.1 | File “apps/frappe/frappe/init.py”, line 2087, in get_all
18:07:08 web.1 | return get_list(doctype, *args, **kwargs)
18:07:08 web.1 | File “apps/frappe/frappe/init.py”, line 2062, in get_list
18:07:08 web.1 | return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
18:07:08 web.1 | File “apps/frappe/frappe/model/db_query.py”, line 190, in execute
18:07:08 web.1 | result = self.build_and_run()
18:07:08 web.1 | File “apps/frappe/frappe/model/db_query.py”, line 231, in build_and_run
18:07:08 web.1 | return frappe.db.sql(
18:07:08 web.1 | File “apps/frappe/frappe/database/database.py”, line 224, in sql
18:07:08 web.1 | self._cursor.execute(query, values)
18:07:08 web.1 | File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute
18:07:08 web.1 | result = self._query(query)
18:07:08 web.1 | File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query
18:07:08 web.1 | conn.query(q)
18:07:08 web.1 | File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 558, in query
18:07:08 web.1 | self._affected_rows = self._read_query_result(unbuffered=unbuffered)
18:07:08 web.1 | File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 822, in _read_query_result
18:07:08 web.1 | result.read()
18:07:08 web.1 | File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1200, in read
18:07:08 web.1 | first_packet = self.connection._read_packet()
18:07:08 web.1 | File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 772, in _read_packet
18:07:08 web.1 | packet.raise_for_error()
18:07:08 web.1 | File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
18:07:08 web.1 | err.raise_mysql_exception(self._data)
18:07:08 web.1 | File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
18:07:08 web.1 | raise errorclass(errno, errval)
18:07:08 web.1 | pymysql.err.OperationalError: (1054, “Unknown column ‘background_jobs_queue’ in ‘field list’”)
18:07:08 web.1 |
18:07:08 web.1 | 127.0.0.1 - - [25/Mar

Galaxy_Lab · March 25, 2024, 7:30pm

Traceback (most recent call last):
File “apps/frappe/frappe/www/app.py”, line 27, in get_context
boot = frappe.sessions.get()
File “apps/frappe/frappe/sessions.py”, line 137, in get
bootinfo = get_bootinfo()
File “apps/frappe/frappe/boot.py”, line 39, in get_bootinfo
get_user(bootinfo)
File “apps/frappe/frappe/boot.py”, line 273, in get_user
bootinfo.user = frappe.get_user().load_user()
File “apps/frappe/frappe/utils/user.py”, line 213, in load_user
d = frappe.db.get_value(
File “apps/frappe/frappe/database/database.py”, line 509, in get_value
result = self.get_values(
File “apps/frappe/frappe/database/database.py”, line 613, in get_values
out = self._get_values_from_table(
File “apps/frappe/frappe/database/database.py”, line 886, in _get_values_from_table
return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck)
File “apps/frappe/frappe/query_builder/utils.py”, line 84, in execute_query
result = frappe.db.sql(query, params, *args, **kwargs) # nosemgrep
File “apps/frappe/frappe/database/database.py”, line 224, in sql
self._cursor.execute(query, values)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 153, in execute
result = self._query(query)
File “env/lib/python3.10/site-packages/pymysql/cursors.py”, line 322, in _query
conn.query(q)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 558, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 822, in _read_query_result
result.read()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 1200, in read
first_packet = self.connection._read_packet()
File “env/lib/python3.10/site-packages/pymysql/connections.py”, line 772, in _read_packet
packet.raise_for_error()
File “env/lib/python3.10/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File “env/lib/python3.10/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1054, “Unknown column ‘default_workspace’ in ‘field list’”)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “apps/frappe/frappe/website/serve.py”, line 20, in get_response
response = renderer_instance.render()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 84, in render
html = self.get_html()
File “apps/frappe/frappe/website/utils.py”, line 521, in cache_html_decorator
html = func(*args, **kwargs)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 95, in get_html
self.update_context()
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 163, in update_context
data = self.run_pymodule_method(“get_context”)
File “apps/frappe/frappe/website/page_renderers/template_page.py”, line 223, in run_pymodule_method
return method(self.context)
File “apps/frappe/frappe/www/app.py”, line 29, in get_context
raise frappe.SessionBootFailed from e
frappe.exceptions.SessionBootFailed

Mohammadali · March 26, 2024, 5:02am

Hi @Galaxy_Lab

You can change the Administrator password using this command.

bench --site [sitename] set-admin-password [password]

Thank you!

Galaxy_Lab · March 26, 2024, 9:53am

Thanks for Answer i tried this , but nothing Happned

Mohammadali · March 26, 2024, 10:47am

Hi @Galaxy_Lab

Create a new site and log in. After successfully logging. Restore the data and log in with the user ID and password of the site you back up from. I hope it will work

Thank You!

Galaxy_Lab · March 26, 2024, 7:49pm

Dear i also tried this one ,
i install my app in new repositry , working with out restore, aftre restore , it will not work ,

peterg · April 2, 2024, 7:53am

It looks like your database hasn’t been migrated properly after the restore. Bench can be a bit inconsistent about how/when it runs migrations after its own commands

If you run a migration manually, does that fix it?

bench --site SITE_NAME migrate

Galaxy_Lab · April 2, 2024, 9:12pm

i was solved 3 day before thanks for your time

pm23 · May 28, 2024, 11:47am

Is there any way which will never give this kind of ambiguity ??
I have faced this issue many times after restore why it happens? What to do then it will never come ?

everytime migrate is not good option.