Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!

Ogłoszenie

Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.

Strony: 1

 

#1  2020-01-01 19:56:52

  mimoto - Użytkownik

mimoto
Użytkownik
Zarejestrowany: 2016-09-20

Port 80 zajęty.

Witam.
Po wykonaniu upgrade z v 9 do 10 pojawiły się pewne problemy. Jeden wynika z innego, i muszę zacząć od końca.  (Apache, Pgadmin, Odoo)
Na początek apache.

systemctl status apache2.service


Kod:

apache2.service - The Apache HTTP Server
   Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Wed 2020-01-01 19:44:52 CET; 8min ago
     Docs: https://httpd.apache.org/docs/2.4/
  Process: 14411 ExecStart=/usr/sbin/apachectl start (code=exited, status=1/FAILURE)

Jan 01 19:44:52 main systemd[1]: Starting The Apache HTTP Server...
Jan 01 19:44:52 main apachectl[14411]: (98)Address already in use: AH00072: make_sock: could not bind to address 0.0.0.0:80
Jan 01 19:44:52 main apachectl[14411]: no listening sockets available, shutting down
Jan 01 19:44:52 main apachectl[14411]: AH00015: Unable to open logs
Jan 01 19:44:52 main apachectl[14411]: Action 'start' failed.
Jan 01 19:44:52 main apachectl[14411]: The Apache error log may have more information.
Jan 01 19:44:52 main systemd[1]: apache2.service: Control process exited, code=exited, status=1/FAILURE
Jan 01 19:44:52 main systemd[1]: apache2.service: Failed with result 'exit-code'.
Jan 01 19:44:52 main systemd[1]: Failed to start The Apache HTTP Server.

Wynika że jest problem z portem 80.

netstat -antp | grep 80


Kod:

tcp        0      0 0.0.0.0:8069            0.0.0.0:*               LISTEN      919/python3
tcp        1      0 192.168.8.106:35634     99.81.213.165:80        CLOSE_WAIT  1842/Plex Tuner Ser
tcp6       0      0 :::80                   :::*                    LISTEN      1194/nginx: master

Używając

Kod:

kill -9

mogę zakończyć te procesy, wówczas apache ruszy. Ale po restarcie wszystko wraca do poprzedniego stanu.

Pozdrawiam.

Offline

 

#2  2020-01-01 20:29:13

  Bodzio - Ojciec Założyciel

Bodzio
Ojciec Założyciel
Skąd: Gorlice
Zarejestrowany: 2004-04-17
Serwis

Re: Port 80 zajęty.

nginx Ci zajmuje port. Jak nie używasz to wyłącz lub odinstaluj. Lub przełącz nginxa na inny port.

Debian jest lepszy niż wszystkie klony
Linux register users: #359018
http://www.freebsd.org/gifs/powerlogo.gif
Beskid Niski

Offline

 

#3  2020-01-01 20:30:32

  Jacekalex - Podobno człowiek...;)

Jacekalex
Podobno człowiek...;)
Skąd: /dev/random
Zarejestrowany: 2008-01-07

Re: Port 80 zajęty.

Jak masz Nginxa na porcie 80 odpalonego, to po co tam pchasz Apacha?

Kiedy dwa serwery WWW walczą o dostęp do jednego portu, to zazwyczaj któryś wygrywa a któryś przegrywa.
Nginx to lżejszy serwer WWW  i stara radziecka technologia wojskowa, więc z Indianerami od Apacha wygrywa, nie ma tu nic dziwnego.

Odpal Apacha na innym porcie (zazwyczaj 8080) a Nginxa zostaw na 80 i 443 jako reverse-proxy zabezpieczające Apacha.
I wtedy wszystko powinno śmigać dosyć grzecznie i w miarę bezpiecznie.

Z resztą Apache tu jest potrzebny jak wól do karety, Odoo ma wbudowany wląsny serwer http, a zarówno Apacha jak i Nginxa podłączasz do Oddo jaklo reverse proxy.

https://linuxize.com/post/configure-odoo-with-nginx … everse-proxy/
https://www.wirasoenaryo.com/2015/11/how-to-use-apa … roxy-on-odoo/

W dziale reverse-proxy Nginx zjada Apacha na podwieczorek. xD

Ostatnio edytowany przez Jacekalex (2020-01-01 20:37:04)

W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem  para bellum  ;)       |       Pozdrawiam :)

Offline

 

#4  2020-01-01 20:56:57

  mimoto - Użytkownik

mimoto
Użytkownik
Zarejestrowany: 2016-09-20

Re: Port 80 zajęty.

Generalnie mam problem z odpaleniem odoo po aktualizacji.
To jest głowny problem.
Usługo startuje, ale przeglądarka odrzuca połączenie.

service odoo status

Kod:

odoo.service - Odoo Open Source ERP and CRM
   Loaded: loaded (/lib/systemd/system/odoo.service; enabled; vendor preset: enabled)
   Active: active (running) since Wed 2020-01-01 17:01:32 CET; 3h 53min ago
 Main PID: 919 (odoo)
    Tasks: 4 (limit: 4572)
   Memory: 74.9M
   CGroup: /system.slice/odoo.service
           └─919 /usr/bin/python3 /usr/bin/odoo --config /etc/odoo/odoo.conf --logfile /var/log/odoo/odoo-server.log

Wyszukiwarka pokazuje

Kod:

Internal Server Error

Szukając rozwiązania wyszło że chodzi o zablokowany jakiś port.

Offline

 

#5  2020-01-01 21:14:42

  Jacekalex - Podobno człowiek...;)

Jacekalex
Podobno człowiek...;)
Skąd: /dev/random
Zarejestrowany: 2008-01-07

Re: Port 80 zajęty.

Pewnie dlatego, że Odoo i jego reverse proxy czy to Apache czy Nginx trzeba do tej roboty skonfigurować.
A potem miej logi i patrzaj w logi, żeby wiedzieć, co się faktycznie dzieje z Odoo i z serwerem WWW, który robi za rev-proxy.

Ostatnio edytowany przez Jacekalex (2020-01-01 21:15:05)

W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem  para bellum  ;)       |       Pozdrawiam :)

Offline

 

#6  2020-01-01 21:23:19

  mimoto - Użytkownik

mimoto
Użytkownik
Zarejestrowany: 2016-09-20

Re: Port 80 zajęty.

Generalnie miałem poprzednio wersję odoo 11, która została odinstalowana. Łącznie z purge.
Log odoo 13


Kod:

2019-12-30 19:27:16,894 15925 WARNING ? odoo.addons.base.models.ir_cron: Skipping database aa as its base version is not 13.0.1.3. 
2019-12-30 19:27:21,084 15925 INFO ? odoo.service.server: Initiating shutdown 
2019-12-30 19:27:21,084 15925 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown. 
2019-12-30 19:27:21,969 16529 INFO ? odoo: Odoo version 13.0-20191230 
2019-12-30 19:27:21,969 16529 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf 
2019-12-30 19:27:21,971 16529 INFO ? odoo: addons paths: ['/usr/lib/python3/dist-packages/odoo/addons', '/var/lib/odoo/.local/share/Odoo/addons/13.0'] 
2019-12-30 19:27:21,971 16529 INFO ? odoo: database: odoo@default:default 
2019-12-30 19:27:22,091 16529 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf 
2019-12-30 19:27:22,192 16529 INFO ? odoo.service.server: HTTP service (werkzeug) running on main.imers.ddns.net:8069 
2019-12-30 19:32:30,003 16529 INFO ? odoo.service.server: Initiating shutdown 
2019-12-30 19:32:30,003 16529 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown. 
2019-12-30 19:36:17,723 927 INFO ? odoo: Odoo version 13.0-20191230 
2019-12-30 19:36:17,733 927 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf 
2019-12-30 19:36:17,733 927 INFO ? odoo: addons paths: ['/usr/lib/python3/dist-packages/odoo/addons', '/var/lib/odoo/.local/share/Odoo/addons/13.0'] 
2019-12-30 19:36:17,733 927 INFO ? odoo: database: odoo@default:default 
2019-12-30 19:36:19,805 927 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf 
2019-12-30 19:36:21,607 927 INFO ? odoo.service.server: HTTP service (werkzeug) running on main.imers.ddns.net:8069 
2019-12-30 19:39:33,675 927 INFO ? odoo.service.server: Initiating shutdown 
2019-12-30 19:39:33,675 927 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown. 
2019-12-30 20:32:53,184 6205 INFO ? odoo: Odoo version 13.0-20191230 
2019-12-30 20:32:53,184 6205 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf 
2019-12-30 20:32:53,184 6205 INFO ? odoo: addons paths: ['/usr/lib/python3/dist-packages/odoo/addons', '/var/lib/odoo/.local/share/Odoo/addons/13.0'] 
2019-12-30 20:32:53,184 6205 INFO ? odoo: database: odoo@default:default 
2019-12-30 20:32:53,297 6205 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf 
2019-12-30 20:32:53,401 6205 INFO ? odoo.service.server: HTTP service (werkzeug) running on main.imers.ddns.net:8069 
2019-12-30 20:32:56,581 6205 INFO ? odoo.http: HTTP Configuring static files 
2019-12-30 20:32:56,780 6205 INFO aa odoo.modules.loading: loading 1 modules... 
2019-12-30 20:32:56,817 6205 INFO aa odoo.modules.loading: 1 modules loaded in 0.04s, 0 queries 
2019-12-30 20:32:56,824 6205 WARNING aa odoo.modules.graph: module website_quote: not installable, skipped 
2019-12-30 20:32:56,840 6205 WARNING aa odoo.modules.graph: module mrp_repair: not installable, skipped 
2019-12-30 20:32:56,845 6205 WARNING aa odoo.modules.graph: module auto_backup: not installable, skipped 
2019-12-30 20:32:56,852 6205 WARNING aa odoo.modules.graph: module web_planner: not installable, skipped 
2019-12-30 20:32:56,865 6205 WARNING aa odoo.modules.graph: module sale_order_dates: not installable, skipped 
2019-12-30 20:32:56,884 6205 WARNING aa odoo.modules.graph: module account_invoicing: not installable, skipped 
2019-12-30 20:32:56,890 6205 WARNING aa odoo.modules.graph: module web_settings_dashboard: not installable, skipped 
2019-12-30 20:32:56,894 6205 WARNING aa odoo.modules.graph: module base_vat_autocomplete: not installable, skipped 
2019-12-30 20:32:56,940 6205 WARNING aa odoo.modules.graph: module decimal_precision: not installable, skipped 
2019-12-30 20:32:56,952 6205 WARNING aa odoo.modules.graph: module auth_crypt: not installable, skipped 
2019-12-30 20:32:56,964 6205 ERROR aa odoo.modules.graph: module stock_landed_costs: Unmet dependencies: stock_account, purchase_stock 
2019-12-30 20:32:56,964 6205 ERROR aa odoo.modules.graph: module website_theme_install: Unmet dependencies: website 
2019-12-30 20:32:56,964 6205 ERROR aa odoo.modules.graph: module procurement_jit: Unmet dependencies: sale_stock 
2019-12-30 20:32:56,964 6205 ERROR aa odoo.modules.graph: module l10n_pl: Unmet dependencies: account, base_iban, base_vat 
2019-12-30 20:32:56,965 6205 ERROR aa odoo.modules.graph: module account: Unmet dependencies: product, analytic, digest 
2019-12-30 20:32:56,965 6205 ERROR aa odoo.modules.graph: module sale_stock: Unmet dependencies: sale, stock_account 
2019-12-30 20:32:56,965 6205 ERROR aa odoo.modules.graph: module website_mail: Unmet dependencies: website 
2019-12-30 20:32:56,965 6205 ERROR aa odoo.modules.graph: module sale: Unmet dependencies: payment, utm 
2019-12-30 20:32:56,965 6205 ERROR aa odoo.modules.graph: module sms: Unmet dependencies: phone_validation 
2019-12-30 20:32:56,965 6205 ERROR aa odoo.modules.graph: module analytic: Unmet dependencies: uom 
2019-12-30 20:32:56,965 6205 ERROR aa odoo.modules.graph: module payment_transfer: Unmet dependencies: payment 
2019-12-30 20:32:56,965 6205 ERROR aa odoo.modules.graph: module stock_account: Unmet dependencies: stock, account 
2019-12-30 20:32:56,966 6205 ERROR aa odoo.modules.graph: module purchase: Unmet dependencies: account 
2019-12-30 20:32:56,966 6205 ERROR aa odoo.modules.graph: module website_rating: Unmet dependencies: website_mail 
2019-12-30 20:32:56,966 6205 ERROR aa odoo.modules.graph: module hr_org_chart: Unmet dependencies: hr 
2019-12-30 20:32:56,966 6205 ERROR aa odoo.modules.graph: module account_bank_statement_import: Unmet dependencies: account 
2019-12-30 20:32:56,966 6205 ERROR aa odoo.modules.graph: module delivery: Unmet dependencies: sale_stock, sale_management 
2019-12-30 20:32:56,966 6205 ERROR aa odoo.modules.graph: module mrp: Unmet dependencies: product, stock 
2019-12-30 20:32:56,966 6205 ERROR aa odoo.modules.graph: module purchase_mrp: Unmet dependencies: mrp, purchase_stock 
2019-12-30 20:32:56,967 6205 ERROR aa odoo.modules.graph: module payment: Unmet dependencies: account 
2019-12-30 20:32:56,967 6205 ERROR aa odoo.modules.graph: module website_livechat: Unmet dependencies: website 
2019-12-30 20:32:56,967 6205 ERROR aa odoo.modules.graph: module calendar_sms: Unmet dependencies: sms 
2019-12-30 20:32:56,967 6205 ERROR aa odoo.modules.graph: module sale_mrp: Unmet dependencies: mrp, sale_stock 
2019-12-30 20:32:56,967 6205 ERROR aa odoo.modules.graph: module base_vat: Unmet dependencies: account 
2019-12-30 20:32:56,967 6205 ERROR aa odoo.modules.graph: module stock: Unmet dependencies: product 
2019-12-30 20:32:56,967 6205 ERROR aa odoo.modules.graph: module base_iban: Unmet dependencies: account 
2019-12-30 20:32:56,967 6205 ERROR aa odoo.modules.graph: module product: Unmet dependencies: uom 
2019-12-30 20:32:56,968 6205 ERROR aa odoo.modules.graph: module hr: Unmet dependencies: mail_bot 
2019-12-30 20:32:56,968 6205 ERROR aa odoo.modules.graph: module sale_management: Unmet dependencies: sale, digest 
2019-12-30 20:32:56,968 6205 ERROR aa odoo.modules.graph: module website: Unmet dependencies: social_media 
2019-12-30 20:32:56,968 6205 INFO aa odoo.modules.loading: loading 30 modules... 
2019-12-30 20:32:57,692 6205 INFO aa odoo.modules.loading: 30 modules loaded in 0.72s, 0 queries 
2019-12-30 20:32:58,032 6205 INFO aa odoo.modules.loading: Modules loaded. 
2019-12-30 20:32:58,076 6205 INFO aa odoo.addons.base.models.ir_http: Generating routing map for key None 
2019-12-30 20:32:58,272 6205 ERROR aa odoo.sql_db: bad query: SELECT "res_users"."id" as "id","res_users"."partner_id" as "partner_id","res_users"."login" as "login","res_users"."signature" as "signature","res_users"."active" as "active","res_users"."action_id" as "action_id","res_users"."share" as "share","res_users"."company_id" as "company_id","res_users"."alias_id" as "alias_id","res_users"."notification_type" as "notification_type","res_users"."out_of_office_message" as "out_of_office_message","res_users"."sale_team_id" as "sale_team_id","res_users"."livechat_username" as "livechat_username","res_users"."create_uid" as "create_uid","res_users"."create_date" as "create_date","res_users"."write_uid" as "write_uid","res_users"."write_date" as "write_date" FROM "res_users" WHERE "res_users".id IN (1)
ERROR: BŁĄD:  kolumna res_users.out_of_office_message nie istnieje
LINE 1: ...users"."notification_type" as "notification_type","res_users...
                                                             ^
 
2019-12-30 20:32:58,281 6205 INFO aa werkzeug: 192.168.8.136 - - [30/Dec/2019 20:32:58] "GET /web/login HTTP/1.1" 500 - 16 0.368 1.327
2019-12-30 20:32:58,338 6205 ERROR aa werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 270, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 258, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 439, in app
    return self.app(e, s)
  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 142, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
    result = odoo.http.root(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1281, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1251, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 766, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1450, in dispatch
    result = ir_http._dispatch()
  File "/usr/lib/python3/dist-packages/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch
    return super(Http, cls)._dispatch()
  File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch
    return super(IrHttp, cls)._dispatch()
  File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 516, in _dispatch
    result = super(IrHttp, cls)._dispatch()
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 233, in _dispatch
    return cls._handle_exception(e)
  File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 607, in _handle_exception
    return super(IrHttp, cls)._handle_exception(exception)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 201, in _handle_exception
    return request._handle_exception(exception)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 744, in _handle_exception
    return super(HttpRequest, self)._handle_exception(exception)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 309, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 14, in reraise
    raise value
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 229, in _dispatch
    result = request.dispatch()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 803, in dispatch
    r = self._call_function(**self.params)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 345, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 93, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 341, in checked_call
    result.flatten()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1230, in flatten
    self.response.append(self.render())
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1223, in render
    return env["ir.ui.view"].render_template(self.template, self.qcontext)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1154, in render_template
    return self.browse(self.get_view_id(template)).render(values, engine)
  File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_ui_view.py", line 27, in render
    return super(IrUiView, self).render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1159, in render
    qcontext = dict() if minimal_qcontext else self._prepare_qcontext()
  File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_ui_view.py", line 13, in _prepare_qcontext
    qcontext = super(IrUiView, self)._prepare_qcontext()
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 1172, in _prepare_qcontext
    res_company=self.env.company.sudo(),
  File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 24, in __get__
    value = self.fget(obj)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 560, in company
    return self.user.company_id
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 2228, in __get__
    return super().__get__(records, owner)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 985, in __get__
    recs._fetch_field(self)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2930, in _fetch_field
    self._read(fnames)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/res_users.py", line 378, in _read
    super(Users, self)._read(fields)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 3001, in _read
    cr.execute(query_str, params)
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 163, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 240, in execute
    res = self._obj.execute(query, params)
psycopg2.ProgrammingError: BŁĄD:  kolumna res_users.out_of_office_message nie istnieje
LINE 1: ...users"."notification_type" as "notification_type","res_users...
                                                             ^ - - -
2019-12-30 20:32:58,563 6205 ERROR aa odoo.sql_db: bad query: SELECT "res_lang"."id" as "id","res_lang"."name" as "name","res_lang"."code" as "code","res_lang"."iso_code" as "iso_code","res_lang"."url_code" as "url_code","res_lang"."active" as "active","res_lang"."direction" as "direction","res_lang"."date_format" as "date_format","res_lang"."time_format" as "time_format","res_lang"."week_start" as "week_start","res_lang"."grouping" as "grouping","res_lang"."decimal_point" as "decimal_point","res_lang"."thousands_sep" as "thousands_sep","res_lang"."create_uid" as "create_uid","res_lang"."create_date" as "create_date","res_lang"."write_uid" as "write_uid","res_lang"."write_date" as "write_date" FROM "res_lang" WHERE "res_lang".id IN (48, 77, 2, 3, 4, 5, 6, 45, 7, 8, 9, 10, 11, 12, 13, 15, 14, 1, 16, 17, 18, 19, 23, 20, 21, 22, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 46, 47, 50, 49, 51, 52, 53, 54, 55, 56, 71, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 72, 78, 73, 74, 75, 76)
ERROR: BŁĄD:  kolumna res_lang.url_code nie istnieje
LINE 1: ...de" as "code","res_lang"."iso_code" as "iso_code","res_lang"...
                                                             ^
 
2019-12-30 20:32:58,639 6205 INFO aa werkzeug: 192.168.8.136 - - [30/Dec/2019 20:32:58] "GET /favicon.ico HTTP/1.1" 500 - 8 0.063 0.088
2019-12-30 20:32:58,648 6205 ERROR aa werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 270, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 258, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 439, in app
    return self.app(e, s)
  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 142, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 117, in application_unproxied
    result = odoo.http.root(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1281, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1251, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 766, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1450, in dispatch
    result = ir_http._dispatch()
  File "/usr/lib/python3/dist-packages/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch
    return super(Http, cls)._dispatch()
  File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch
    return super(IrHttp, cls)._dispatch()
  File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 467, in _dispatch
    cls._add_dispatch_parameters(func)
  File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 394, in _add_dispatch_parameters
    available_langs = Lang.get_available()
  File "</usr/local/lib/python3.7/dist-packages/decorator.py:decorator-gen-76>", line 2, in get_available
    
  File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 90, in lookup
    value = d[key] = self.method(*args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/res_lang.py", line 207, in get_available
    return sorted([(lang.code, lang.url_code, lang.name) for lang in langs], key=itemgetter(2))
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/res_lang.py", line 207, in <listcomp>
    return sorted([(lang.code, lang.url_code, lang.name) for lang in langs], key=itemgetter(2))
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 985, in __get__
    recs._fetch_field(self)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2930, in _fetch_field
    self._read(fnames)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 3001, in _read
    cr.execute(query_str, params)
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 163, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 240, in execute
    res = self._obj.execute(query, params)
psycopg2.ProgrammingError: BŁĄD:  kolumna res_lang.url_code nie istnieje
LINE 1: ...de" as "code","res_lang"."iso_code" as "iso_code","res_lang"...
                                                             ^ - - -
2019-12-30 20:33:16,658 6205 ERROR aa odoo.sql_db: bad query: SELECT "res_users"."id" as "id","res_users"."partner_id" as "partner_id","res_users"."login" as "login","res_users"."signature" as "signature","res_users"."active" as "active","res_users"."action_id" as "action_id","res_users"."share" as "share","res_users"."company_id" as "company_id","res_users"."alias_id" as "alias_id","res_users"."notification_type" as "notification_type","res_users"."out_of_office_message" as "out_of_office_message","res_users"."sale_team_id" as "sale_team_id","res_users"."livechat_username" as "livechat_username","res_users"."create_uid" as "create_uid","res_users"."create_date" as "create_date","res_users"."write_uid" as "write_uid","res_users"."write_date" as "write_date" FROM "res_users" WHERE "res_users".id IN (1)
ERROR: BŁĄD:  kolumna res_users.out_of_office_message nie istnieje
LINE 1: ...users"."notification_type" as "notification_type","res_users...

Offline

 

#7  2020-01-01 21:32:57

  Jacekalex - Podobno człowiek...;)

Jacekalex
Podobno człowiek...;)
Skąd: /dev/random
Zarejestrowany: 2008-01-07

Re: Port 80 zajęty.

Mazz tam pół metra błędów Pythona, nieistniejęące tabele w bazie danych, itp.

Trudno, żeby taki bajzel działal, trzeba to wszystko zreperować.

I ustalić dokładnie, z czym łączy się przegladarka, bo podobno na porcie 80 masz jakiś serwer WWW Apache czy może Nginx.
Ten serwer WWW też trzeba skonfigurować do pracy z Odoo, nikt za Ciebie tego nie zrobi.
Każdy serwer WWW też ma logi.

W demokracji każdy naród ma taką władzę, na jaką zasługuje ;)
Si vis pacem  para bellum  ;)       |       Pozdrawiam :)

Offline

 

#8  2020-01-01 21:35:24

  mimoto - Użytkownik

mimoto
Użytkownik
Zarejestrowany: 2016-09-20

Re: Port 80 zajęty.

Ale to wszystko działało przed aktualizacją debiana. Wersja 10 debiana wymaga odoo 13. Nie jest problem baza danych odoo, tam nic nie było ważnego, potrzebuję to po prostu uruchomić. Lub zainstalować od nowa, aby ruszyło.

Ostatnio edytowany przez mimoto (2020-01-01 21:35:43)

Offline

 

 

Strony: 1

Stopka forum

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson
To nie jest tylko forum, to nasza mała ojczyzna ;-)