Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

Odoo no longer working cannot access admin - Server Error

error server500

6 ตอบกลับ

24699 มุมมอง

Afzol Ali

Hi guys, Im new on here,

My Odoo install has been working fine for over 4 months now. Last night I tried to install the Notes/collabrotive module and did google calander sync.

When I tried to log back into the Odoo admin the Error message comes up on the browser:

"Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application."

I started and stopped and restarted the Odoo server and database, still cannot access the Odoo

Please assist, any help will be useful. Im not great with servers, or databases, so anything related to that would appreciate steps to follow.

Thanks

Below is part of the Error log I got:

2015-02-21 03:30:35,152 6592 INFO odoo_demo openerp.modules.loading: loading 1 modules...
2015-02-21 03:30:35,454 6592 INFO odoo_demo openerp.modules.loading: 1 modules loaded in 0.30s, 0 queries
2015-02-21 03:30:36,116 6592 INFO odoo_demo openerp.modules.loading: loading 108 modules...
2015-02-21 03:30:37,337 6592 INFO odoo_demo openerp.modules.module: module document: creating or updating database tables
2015-02-21 03:30:37,562 6592 INFO odoo_demo openerp.modules.loading: loading document/security/document_security.xml
2015-02-21 03:30:38,075 6592 INFO odoo_demo openerp.modules.loading: loading document/document_view.xml
2015-02-21 03:30:38,514 6592 INFO odoo_demo openerp.modules.loading: loading document/document_data.xml
2015-02-21 03:30:38,548 6592 INFO odoo_demo openerp.modules.loading: loading document/wizard/document_configuration_view.xml
2015-02-21 03:30:38,609 6592 INFO odoo_demo openerp.modules.loading: loading document/security/ir.model.access.csv
2015-02-21 03:30:38,981 6592 INFO odoo_demo openerp.modules.loading: loading document/report/document_report_view.xml
2015-02-21 03:30:39,289 6592 INFO odoo_demo openerp.modules.loading: loading document/views/document.xml
2015-02-21 03:30:39,443 6592 INFO odoo_demo openerp.modules.loading: loading document/document_demo.xml
2015-02-21 03:30:39,459 6592 INFO odoo_demo werkzeug: 151.227.23.228 - - [21/Feb/2015 03:30:39] "POST /longpolling/poll HTTP/1.1" 500 -
2015-02-21 03:30:39,487 6592 ERROR odoo_demo werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/share/pyshared/werkzeug/serving.py", line 159, in run_wsgi
execute(app)
File "/usr/share/pyshared/werkzeug/serving.py", line 146, in execute
application_iter = app(environ, start_response)
File "/opt/odoo/odoo/openerp/service/server.py", line 281, in app
return self.app(e, s)
File "/opt/odoo/odoo/openerp/service/wsgi_server.py", line 216, in application
return application_unproxied(environ, start_response)
File "/opt/odoo/odoo/openerp/service/wsgi_server.py", line 202, in application_unproxied
result = handler(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1236, in __call__
return self.dispatch(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1210, in __call__
return self.app(environ, start_wrapped)
File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo/openerp/http.py", line 1368, in dispatch
ir_http = request.registry['ir.http']
File "/opt/odoo/odoo/openerp/http.py", line 330, in registry
return openerp.modules.registry.RegistryManager.get(self.db) if self.db else None
File "/opt/odoo/odoo/openerp/modules/registry.py", line 310, in get
update_module)
File "/opt/odoo/odoo/openerp/modules/registry.py", line 341, in new
openerp.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/odoo/odoo/openerp/modules/loading.py", line 354, in load_modules
force, status, report, loaded_modules, update_module)
File "/opt/odoo/odoo/openerp/modules/loading.py", line 263, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/opt/odoo/odoo/openerp/modules/loading.py", line 185, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='demo')
File "/opt/odoo/odoo/openerp/modules/loading.py", line 118, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/opt/odoo/odoo/openerp/tools/convert.py", line 901, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/opt/odoo/odoo/openerp/tools/convert.py", line 987, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/opt/odoo/odoo/openerp/tools/convert.py", line 853, in parse
self._tags[rec.tag](self.cr, rec, n, mode=mode)
File "/opt/odoo/odoo/openerp/tools/convert.py", line 763, in _tag_record
id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
File "/opt/odoo/odoo/openerp/api.py", line 237, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/addons/base/ir/ir_model.py", line 1066, in _update
res_id = model_obj.create(cr, uid, values, context=context)
File "/opt/odoo/odoo/openerp/api.py", line 237, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/addons/mail/res_users.py", line 75, in create
raise openerp.exceptions.RedirectWarning(msg, action_id, _('Go to the configuration panel'))
ParseError: "You cannot create a new user from here.
To create new user please go to configuration panel.
76
Go to the configuration panel" while parsing /opt/odoo/odoo/openerp/addons/document/document_demo.xml:4, near
<record id="base.user_demo" model="res.users">
<field eval="[(4, ref('base.group_document_user'))]" name="groups_id"/>
</record>

Yenthe Van Ginneken (Mainframe Monkey)

Hi Afzol! I was wondering if you could give me some more insight in this since we had this problem on an Odoo a while ago too. I see this is referring to demo files (document_demo.xml:4).. Did you know how this happend and how/when this showed up? I fixes this by commenting out the demo files that caused the errors but I would like to know why and how this has happend. I hope you can provide me with some more details/insight :)

Martin Temmink

คำตอบที่ดีที่สุด

you can do severall things.

1. stop odoo server
2. login with ssh on your system as odoo user
3. issue the database update command on de commandline. for instructions follow this link: Database run full update command.

then logout as odoo user, and restart your server

if the above doesn't work you have to mannually move the contents in the addons directory. And restart your server.
this will restart odoo without any modules. You should be able to login.
Then stop the server and move one module at the time back to the addons directory. start the server and if succesfully. repeat the procedure for the rest of the modules.

if you find this information has helped you, please give me a thumb up vote!

Omar Alejandro Linares Escobar

Please, can you help me?

I'm having similar issue after installing Muk Theme module, now I cannot access to the specific DB where I activate it.

More info in the following link:

https://www.odoo.com/es/forum/ayuda-1/odoo-database-access-issue-following-installation-of-muk-module-249748

Taylor Stanley Marketing Pte Ltd

I can't comment on the specifics of the error that you have encountered. However, I had a similar experience where my Odoo server failed after I made some mistakes during the installation of a customised module. After the failed installation and further wrong moves on the Odoo server, I decided to cut loss and recovered the database instances using postgres directly.

I install pgadmin III to attempt to connect to the postgres server. You will need to enable access to pgadmin by editing the pg_hba.conf file found in /etc/postgresl/9.3/main directory with an entry like

host all all 0.0.0.0/0 md5

Please note that the above allows access from anywhere in the internet.

You will need to use a command like:

sudo kill -HUP main_postgres_pid_number (for the postgres server to re-read the revised setting)

You can connect to the postgres server with a postgres user id like odoo (assuming that the odoo user is the one that was used to create the postgres database instance).

You may have to alter the odoo user password in order to use pgadmin using a statement like this:

# login to postgres user in ssh

sudo su postgres

# go into psql

psql

$ALTER ROLE odoo with PASSWORD 'Newpassword';

Once your odoo ID has a password, you will be able to connect to the postgres server using pgadmin.

You can use the pgadmin program to do a database backup of the database instances that you need.

After the backup is done, you can go to a fresh installation of odoo-server to restore the database instance. Restoration consists of creating a database instance with the same name as that of the backup database using postgres odoo ID:

$CREATE DATABASE databasename;

Restore the backup file using pg_dump

#pg_dump -d databasename < backupdatabase.sql

If there are no errors, you should be able to see the restored database in your odoo-server.

I may have missed out some steps along the way. But that generally is how I managed to restore a database instance from a corrupted odoo-server to a working odoo-server.

Afzol Ali

ผู้เขียน

Thanks guys,

I actually figured out that the main problem was within the documents module, and another module. It was trying to create an incorrect database user !!

To diagnose the problem I got extra help from a developer who fixed the problem. And found not only was it trying to create a new user, but also the Notes Module was clashing and was in pending install mode with another install.

Exactly what the solution to this problem was I will update here again with instructions as I am sure there are other Odoo users who will come across this similar bug. Martin instructions are easy to follow and will be trying it thanks, and Y3 That talent is beyond me at present as I am not great with databases, can perform terminal comands but need step by step guide, sorry on that a bit new to postgres.

Great help guys really appreciate it.

Yenthe Van Ginneken (Mainframe Monkey)

Saitam

Same problem here. few month ago everything worked fine, now going to the server IP results in error

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
?"Your country might be blocked by our hosting provider" error when I create new website error	0 พ.ย. 25	592
Payment Page Return Error with Razorpay on Mobile Devices error	0 ก.ย. 25	1251
Error after installing "purchase" app in Odoo version 18 error	1 ธ.ค. 24	6963
error schema for TourStep Error error	0 พ.ย. 24	2642
Can't modify manifest version of custom module [Odoo.sh] error	2 ก.ค. 24	5364

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!