Das deutschsprachige Odoo / OpenERP Forum - Das Suchen hat ein Ende

Internal Server Error / Oddo 10 in Docker / DRINGEND!

Alles rund um Fehlfunktionen und Fehlermeldungen Eurer odoo Systeme!
Hallo Community,

Entschuldigt, dass ich ein neues Thema erstellt habe, aber ich konnte bei allen vorherigen Themen keine Lösung für mich finden. Ich habe Odoo 10 auf einem Synology NAS als Docker Container erstellt und einen zusätzlichen Ordner gemountet, wo ich zusätzliche Apps hinterlegt habe. Nachdem ich gestern einige Apps im Odoo installiert habe komme ich heute nicht mehr ins Odoo rein.

Fehlermeldung: 500 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.

Mein Docker Report zeigt folgenden Report - vorab ich ein paar Infos: Odoo wurde aus offiziellen Rep erstellt mit Postgres 9.4. Ports 8069 sowie 5432 sind offen in der Firewall. Rechte in der Konsole mit -cR ... wurden ebenfalls gesetzt, doch leider immer noch kein Zugriff. Restart der DB sowie Odoo nützt leider auch nichts.

Wer kann mir helfen, diesen BUG zu beheben? Vielen Dank im Voraus! :)


07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1306, in __call__
stdout
07:36:58
return self.dispatch(environ, start_response)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1280, in __call__
stdout
07:36:58
return self.app(environ, start_wrapped)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 588, in __call__
stdout
07:36:58
return self.app(environ, start_response)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1436, in dispatch
stdout
07:36:58
self.setup_db(httprequest)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1366, in setup_db
stdout
07:36:58
httprequest.session.db = db_monodb(httprequest)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1514, in db_monodb
stdout
07:36:58
dbs = db_list(True, httprequest)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1488, in db_list
stdout
07:36:58
dbs = odoo.service.db.list_dbs(force)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/service/db.py", line 325, in list_dbs
stdout
07:36:58
with closing(db.cursor()) as cr:
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 622, in cursor
stdout
07:36:58
return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 164, in __init__
stdout
07:36:58
self._cnx = pool.borrow(dsn)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 505, in _locked
stdout
07:36:58
return fun(self, *args, **kwargs)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 573, in borrow
stdout
07:36:58
**connection_info)
stdout
07:36:58
File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect
stdout
07:36:58
conn = _connect(dsn, connection_factory=connection_factory, async=async)
stdout
07:36:58
OperationalError: could not connect to server: Connection refused
stdout
07:36:58
Is the server running on host "172.17.0.3" and accepting
stdout
07:36:58
TCP/IP connections on port 5432?
stdout
07:37:45
2017-07-01 07:37:45,642 1 [1;32m[1;49mINFO[0m ? odoo.addons.bus.models.bus: Bus.loop listen imbus on db postgres
stdout
07:37:45
2017-07-01 07:37:45,642 1 [1;32m[1;49mINFO[0m ? odoo.sql_db: Connection to the database failed
stdout
07:37:45
2017-07-01 07:37:45,643 1 [1;31m[1;49mERROR[0m ? odoo.addons.bus.models.bus: Bus.loop error, sleep and retry
stdout
07:37:45
Traceback (most recent call last):
stdout
07:37:45
File "/usr/lib/python2.7/dist-packages/odoo/addons/bus/models/bus.py", line 170, in run
stdout
07:37:45
self.loop()
stdout
07:37:45
File "/usr/lib/python2.7/dist-packages/odoo/addons/bus/models/bus.py", line 148, in loop
stdout
07:37:45
with odoo.sql_db.db_connect('postgres').cursor() as cr:
stdout
07:37:45
File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 622, in cursor
stdout
07:37:45
return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
stdout
07:37:45
File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 164, in __init__
stdout
07:37:45
self._cnx = pool.borrow(dsn)
stdout
07:37:45
File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 505, in _locked
stdout
07:37:45
return fun(self, *args, **kwargs)
stdout
07:37:45
File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 573, in borrow
stdout
07:37:45
**connection_info)
stdout
07:37:45
File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect
stdout
07:37:45
conn = _connect(dsn, connection_factory=connection_factory, async=async)
stdout
07:37:45
OperationalError: could not connect to server: Connection refused
stdout
07:37:45
Is the server running on host "172.17.0.3" and accepting
stdout
07:37:45
TCP/IP connections on port 5432?
Verweigert auch die Admin-Oberfläche des NAS den Dienst - oder ist NUR Odoo betroffen.

Beste Grüße
Peter A. Gebhardt hat geschrieben:
1. Jul 2017, 15:41
Verweigert auch die Admin-Oberfläche des NAS den Dienst - oder ist NUR Odoo betroffen.

Beste Grüße
Nur Odoo ist davon betroffen - rest funktioniert eineandfrei ...
Sieht so aus, als ob der Postgres Container fehlen würde.
equitania hat geschrieben:
3. Jul 2017, 14:14
Sieht so aus, als ob der Postgres Container fehlen würde.
Der ist aber vorhanden mit 'db'. Und komischerweise kann ich mich jetzt auf einmal wieder einloggen ... Kann ich was gegen diesen Bug machen? Ist echt unberechenbar ... :-(
Der "500 - Error" kommt (meist) vom Webserver und/oder einem Überlauf im 'tmpfs' bzw. "too many processes".

Das erklärt auch, warum nach Neustart des NAS der Fehler (fürs erste!) weg ist.

Beste Grüße
Peter A. Gebhardt hat geschrieben:
3. Jul 2017, 21:55
Der "500 - Error" kommt (meist) vom Webserver und/oder einem Überlauf im 'tmpfs' bzw. "too many processes".

Das erklärt auch, warum nach Neustart des NAS der Fehler (fürs erste!) weg ist.

Beste Grüße
Und was kann ich dagegen tun? Läuft schon wieder nicht ... :evil:
Ich kenne die Synology Implementierung des Linux dort nicht. Habe hier nur ZYXEL 325v2 & 540 - beide OHNE Odoo.

Vermutlich sollte es aber so etwas wie .log Dateien für den Webserver (Apache/nginx?) geben.

Ebenso auch für python und postgres.

Diese bitte mal durchforsten.

Auch könnte helfen, sich parallel über PuTTY (oder Terminal mit SSH) direkt auf der Synology einzuloggen, nachdem neu gestartet wurde und da z.B. sich die Prozesse mit 'top' bzw. 'htop' anzeigen zu lassen.

Beste Grüße
Hallo,

ich habe das gleiche Problem, nur bei mir kommt in der LOG


Password does not match for user "myodoo"


ich bin nach Anleitung von der Docker Seite und von MyODOO vorgegangen.

Habe es auf einer Synology und alternativ auf einem Ubuntu System probiert selbes Ergebnis.

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.


Zuerst läuft alles einwandfrei in Docker hoch.

MyODOO
2017-10-02 07:14:36,287 9 INFO ? odoo.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069

Postgres
LOG: database system is ready to accept connections


Beim Aufruf der Seite kommt dann oben erwähnter Fehler Internal Server Error

Nach einem Neustart beider Prozesse

kommt bei myodoo10-public

Running odoo...
2017-10-02 07:16:39,663 9 INFO ? odoo: Odoo version 10.0
2017-10-02 07:16:39,663 9 INFO ? odoo: Using configuration file at /opt/odoo/etc/odoo.conf
2017-10-02 07:16:39,663 9 INFO ? odoo: addons paths: ['/opt/odoo/data/addons/10.0', u'/opt/odoo/odoo-server/addons', '/opt/odoo/odoo-server/odoo/addons']
2017-10-02 07:16:39,663 9 INFO ? odoo: database: myodoo@db:default
2017-10-02 07:16:39,667 9 INFO ? odoo.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
2017-10-02 07:17:06,603 9 INFO ? odoo.addons.bus.models.bus: Bus.loop listen imbus on db postgres
2017-10-02 07:17:06,607 9 INFO ? odoo.sql_db: Connection to the database failed
2017-10-02 07:17:06,608 9 ERROR ? odoo.addons.bus.models.bus: Bus.loop error, sleep and retry
Traceback (most recent call last):
File "/opt/odoo/odoo-server/addons/bus/models/bus.py", line 170, in run
self.loop()
File "/opt/odoo/odoo-server/addons/bus/models/bus.py", line 148, in loop
with odoo.sql_db.db_connect('postgres').cursor() as cr:
File "/opt/odoo/odoo-server/odoo/sql_db.py", line 635, in cursor
return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
File "/opt/odoo/odoo-server/odoo/sql_db.py", line 177, in __init__
self._cnx = pool.borrow(dsn)
File "/opt/odoo/odoo-server/odoo/sql_db.py", line 518, in _locked
return fun(self, *args, **kwargs)
File "/opt/odoo/odoo-server/odoo/sql_db.py", line 586, in borrow
**connection_info)
File "/usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
OperationalError: FATAL: password authentication failed for user "myodoo"
2017-10-02T07:17:06.623499964Z
2017-10-02 07:17:07,185 9 INFO ? odoo.addons.report.models.report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2017-10-02 07:17:07,588 9 INFO ? odoo.http: HTTP Configuring static files
2017-10-02 07:17:07,591 9 INFO ? odoo.sql_db: Connection to the database failed
2017-10-02 07:17:07,593 9 INFO ? werkzeug: 172.17.0.1 - - [02/Oct/2017 07:17:07] "GET / HTTP/1.1" 500 -
2017-10-02 07:17:07,599 9 ERROR ? werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 193, in run_wsgi
execute(self.server.app)
File "/usr/local/lib/python2.7/dist-packages/werkzeug/serving.py", line 181, in execute
application_iter = app(environ, start_response)
File "/opt/odoo/odoo-server/odoo/service/server.py", line 249, in app
return self.app(e, s)
File "/opt/odoo/odoo-server/odoo/service/wsgi_server.py", line 186, in application
return application_unproxied(environ, start_response)
File "/opt/odoo/odoo-server/odoo/service/wsgi_server.py", line 172, in application_unproxied
result = handler(environ, start_response)
File "/opt/odoo/odoo-server/odoo/http.py", line 1308, in __call__
return self.dispatch(environ, start_response)
File "/opt/odoo/odoo-server/odoo/http.py", line 1282, in __call__
return self.app(environ, start_wrapped)
File "/usr/local/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 599, in __call__
return self.app(environ, start_response)
File "/opt/odoo/odoo-server/odoo/http.py", line 1446, in dispatch
self.setup_db(httprequest)
File "/opt/odoo/odoo-server/odoo/http.py", line 1368, in setup_db
httprequest.session.db = db_monodb(httprequest)
File "/opt/odoo/odoo-server/odoo/http.py", line 1530, in db_monodb
dbs = db_list(True, httprequest)
File "/opt/odoo/odoo-server/odoo/http.py", line 1498, in db_list
dbs = odoo.service.db.list_dbs(force)
File "/opt/odoo/odoo-server/odoo/service/db.py", line 333, in list_dbs
with closing(db.cursor()) as cr:
File "/opt/odoo/odoo-server/odoo/sql_db.py", line 635, in cursor
return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
File "/opt/odoo/odoo-server/odoo/sql_db.py", line 177, in __init__
self._cnx = pool.borrow(dsn)
File "/opt/odoo/odoo-server/odoo/sql_db.py", line 518, in _locked
return fun(self, *args, **kwargs)
File "/opt/odoo/odoo-server/odoo/sql_db.py", line 586, in borrow
**connection_info)
File "/usr/local/lib/python2.7/dist-packages/psycopg2/__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
OperationalError: FATAL: password authentication failed for user "myodoo"
IP & PORTS
You can access this container using the following IP address and port:

DOCKER PORT ACCESS URL
8069/tcp localhost:8069
8072/tcp localhost:8072


Und unter Postgres

PostgreSQL init process complete; ready for start up.
2017-10-02T07:14:37.131469932Z
LOG: database system was shut down at 2017-10-02 07:14:36 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2017-10-02 07:16:56 UTC
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
FATAL: password authentication failed for user "myodoo"
DETAIL: Role "myodoo" does not exist.
Connection matched pg_hba.conf line 95: "host all all all md5"
FATAL: password authentication failed for user "myodoo"
DETAIL: Role "myodoo" does not exist.
Connection matched pg_hba.conf line 95: "host all all all md5"
FATAL: password authentication failed for user "myodoo"
DETAIL: Role "myodoo" does not exist.
Connection matched pg_hba.conf line 95: "host all all all md5"
FATAL: password authentication failed for user "myodoo"
DETAIL: Role "myodoo" does not exist.
Connection matched pg_hba.conf line 95: "host all all all md5"
FATAL: password authentication failed for user "myodoo"
DETAIL: Role "myodoo" does not exist.
Connection matched pg_hba.conf line 95: "host all all all md5"
IP & PORTS
You can access this container using the following IP address and port:

DOCKER PORT ACCESS URL
5432/tcp localhost:<not set>

Kann jemand helfen?
So, die Version 171001 läuft, fast!

bei der Installation irgendeiner beliebigen App kommt

Traceback (most recent call last):
File "/opt/odoo/odoo-server/odoo/http.py", line 640, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo/odoo-server/odoo/http.py", line 677, in dispatch
result = self._call_function(**self.params)
File "/opt/odoo/odoo-server/odoo/http.py", line 333, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/odoo/odoo-server/odoo/service/model.py", line 101, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/odoo/odoo-server/odoo/http.py", line 326, in checked_call
result = self.endpoint(*a, **kw)
File "/opt/odoo/odoo-server/odoo/http.py", line 935, in __call__
return self.method(*args, **kw)
File "/opt/odoo/odoo-server/odoo/http.py", line 506, in response_wrap
response = f(*args, **kw)
File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 889, in call_button
action = self._call_kw(model, method, args, {})
File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 877, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/opt/odoo/odoo-server/odoo/api.py", line 689, in call_kw
return call_kw_multi(method, model, args, kwargs)
File "/opt/odoo/odoo-server/odoo/api.py", line 680, in call_kw_multi
result = method(recs, *args, **kwargs)
File "/opt/odoo/odoo-server/odoo/addons/base/module/module.py", line 410, in button_immediate_install
return self._button_immediate_function(type(self).button_install)
File "/opt/odoo/odoo-server/odoo/addons/base/module/module.py", line 484, in _button_immediate_function
modules.registry.Registry.new(self._cr.dbname, update_module=True)
File "/opt/odoo/odoo-server/odoo/modules/registry.py", line 82, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 339, in load_modules
loaded_modules, update_module)
File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 237, 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-server/odoo/modules/loading.py", line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 95, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 845, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 915, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 799, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 697, in _tag_record
f_val = _eval_xml(self, field, self.env)
File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 144, in _eval_xml
with file_open(node.get('file'), 'rb') as f:
File "/opt/odoo/odoo-server/odoo/tools/misc.py", line 195, in file_open
return _fileopen(name, mode=mode, basedir=rtp, pathinfo=pathinfo, basename=basename)
File "/opt/odoo/odoo-server/odoo/tools/misc.py", line 251, in _fileopen
raise IOError('File not found: %s' % basename)
ParseError: "File not found: payment_buckaroo/static/src/img/buckaroo_icon.png" while parsing /opt/odoo/odoo-server/addons/payment/data/payment_acquirer_data.xml:21, near
<record id="payment_acquirer_buckaroo" model="payment.acquirer">
<field name="name">Buckaroo</field>
<field name="image" type="base64" file="payment_buckaroo/static/src/img/buckaroo_icon.png"/>
<field name="view_template_id" ref="default_acquirer_button"/>
<field name="module_id" ref="base.module_payment_buckaroo"/>
<field name="description" type="html">
<p>
A payment gateway to accept online payments via credit cards.
</p>
<ul>
<li><i class="fa fa-check"/>eCommerce</li>
</ul>
</field>
</record>



Dabei ist es egal wo ich den Container erstelle, ob hier oder dort oder irgendwo es kommt immer ein Server Error,

was mache ich falsch oder liegt es an den Images. Hat niemand das gleiche Problem? :-((

Wer ist online?

Insgesamt ist 1 Besucher online :: 0 sichtbare Mitglieder, 0 unsichtbare Mitglieder und 1 Gast (basierend auf den aktiven Besuchern der letzten 5 Minuten)
Der Besucherrekord liegt bei 25 Besuchern, die am 9. Jul 2018, 18:41 gleichzeitig online waren.

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast