[SOLVED] odoo 11 Mageia 7 don't work

This forum is dedicated to basic help and support :

Ask here your questions about basic installation and usage of Mageia. For example you may post here all your questions about getting Mageia isos and installing it, configuring your printer, using your word processor etc.

Try to ask your questions in the right sub-forum with as much details as you can gather. the more precise the question will be, the more likely you are to get a useful answer

[SOLVED] odoo 11 Mageia 7 don't work

Postby bitit » Sep 9th, '19, 18:29

service odoo status
it work

but in nmap locallhost
i haven't the door open and http://www.localhost:8069 give me error

Enrico
Last edited by bitit on Sep 16th, '19, 20:04, edited 1 time in total.
bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01

Re: odoo 11 Mageia 7 don't work

Postby doktor5000 » Sep 10th, '19, 14:42

Hi there, as in your earlier posts on odoo you're missing basic context information, like how you installed odoo in the first place.
Apart from that, as those are questions about odoo, best ask odoo support about that: https://www.odoo.com/help
At least add the full output of
Code: Select all
service odoo status
service odoo-server status
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 17630
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany

Re: odoo 11 Mageia 7 don't work

Postby bitit » Sep 10th, '19, 17:18

Code: Select all
 service odoo-server status
Cannot find odoo-server service
Usage: service -[Rfshv] SERVICE ARGUMENTS
   -f|--full-restart:   Do a fullrestart of the service.
   -R|--full-restart-all:   Do a fullrestart of all running services.
   -s|--status-all:   Print a status of all services.
   --ignore-dependencies:  Do not start required systemd services
   --skip-redirect:   Do not redirect to systemd
   -d|--debug:      Launch with debug.
   -h|--help:      This help.
[root@localhost ~]# nmap localhost
Starting Nmap 7.70 ( https://nmap.org ) at 2019-09-10 17:11 CEST
Nmap scan report for localhost (127.0.0.1)
Host is up (0.000024s latency).
Not shown: 994 closed ports
PORT     STATE SERVICE
21/tcp   open  ftp
22/tcp   open  ssh
80/tcp   open  http
139/tcp  open  netbios-ssn
445/tcp  open  microsoft-ds
5432/tcp open  postgresql

Nmap done: 1 IP address (1 host up) scanned in 1.74 seconds
[root@localhost ~]# service odoo-server status
Cannot find odoo-server service
Usage: service -[Rfshv] SERVICE ARGUMENTS
   -f|--full-restart:   Do a fullrestart of the service.
   -R|--full-restart-all:   Do a fullrestart of all running services.
   -s|--status-all:   Print a status of all services.
   --ignore-dependencies:  Do not start required systemd services
   --skip-redirect:   Do not redirect to systemd
   -d|--debug:      Launch with debug.
   -h|--help:      This help.
[root@localhost ~]# service odoo status
Redirecting to /bin/systemctl status odoo.service
● odoo.service - Odoo Open Source ERP and CRM
   Loaded: loaded (/usr/lib/systemd/system/odoo.service; enabled; vendor preset>
   Active: active (running) since Tue 2019-09-10 17:07:21 CEST; 5min ago
     Docs: https://www.odoo.com/page/docs
 Main PID: 1577 (odoo)
   Memory: 93.7M
   CGroup: /system.slice/odoo.service
           └─1577 /usr/bin/python3 -s /usr/bin/odoo --config=/etc/odoo/odoo.con>

set 10 17:07:21 localhost systemd[1]: Started Odoo Open Source ERP and CRM.
[root@localhost ~]# service odoo-server start
Cannot find odoo-server service
Usage: service -[Rfshv] SERVICE ARGUMENTS
   -f|--full-restart:   Do a fullrestart of the service.
   -R|--full-restart-all:   Do a fullrestart of all running services.
   -s|--status-all:   Print a status of all services.
   --ignore-dependencies:  Do not start required systemd services
   --skip-redirect:   Do not redirect to systemd
   -d|--debug:      Launch with debug.
   -h|--help:      This help.


this is output
bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01

Re: odoo 11 Mageia 7 don't work

Postby doktor5000 » Sep 11th, '19, 03:42

Check in /etc/odoo/odoo.conf what is configured as logfile and see if that logfile contains any hints, and also check if it's configured to listen at port 8069.
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 17630
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany

Re: odoo 11 Mageia 7 don't work

Postby bitit » Sep 14th, '19, 11:47

odoo.conf
Code: Select all
[options]
; This is the password that allows database operations:
; admin_passwd = admin
db_host = False
db_port = False
db_user = odoo
db_password = False
addons_path = /usr/lib/python3.7/site-packages/odoo/addons
log_handler = ["[':INFO']"]
log_level = info
xmlrpc_port = 8069


odoo.log

Code: Select all
2019-09-13 18:26:00,598 8282 INFO ? odoo: Odoo version 11.0-20190112
2019-09-13 18:26:00,599 8282 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-13 18:26:00,599 8282 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-13 18:26:00,605 8282 INFO ? odoo: database: odoo@default:default
2019-09-13 18:26:00,709 8282 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-13 18:26:01,681 8282 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-13 18:48:00,790 8282 INFO ? odoo.service.server: Initiating shutdown
2019-09-13 18:48:00,791 8282 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2019-09-13 18:48:02,987 3621 INFO ? odoo: Odoo version 11.0-20190112
2019-09-13 18:48:02,987 3621 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-13 18:48:02,988 3621 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-13 18:48:02,988 3621 INFO ? odoo: database: odoo@default:default
2019-09-13 18:48:03,016 3621 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-13 18:48:03,446 3621 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-13 18:48:30,233 3621 INFO ? odoo.service.server: Initiating shutdown
2019-09-13 18:48:30,234 3621 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2019-09-13 18:49:50,561 2171 INFO ? odoo: Odoo version 11.0-20190112
2019-09-13 18:49:50,569 2171 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-13 18:49:50,570 2171 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-13 18:49:50,571 2171 INFO ? odoo: database: odoo@default:default
2019-09-13 18:49:50,734 2171 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-13 18:49:51,538 2171 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-13 19:07:31,968 2171 INFO ? odoo.service.server: Initiating shutdown
2019-09-13 19:07:31,968 2171 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2019-09-13 19:08:57,865 1381 INFO ? odoo: Odoo version 11.0-20190112
2019-09-13 19:08:57,874 1381 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-13 19:08:57,874 1381 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-13 19:08:57,874 1381 INFO ? odoo: database: odoo@default:default
2019-09-13 19:08:57,988 1381 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-13 19:08:58,833 1381 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-13 19:14:03,674 1381 INFO ? odoo.service.server: Initiating shutdown
2019-09-13 19:14:03,674 1381 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2019-09-13 19:14:10,892 8537 INFO ? odoo: Odoo version 11.0-20190112
2019-09-13 19:14:10,893 8537 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-13 19:14:10,893 8537 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-13 19:14:10,893 8537 INFO ? odoo: database: odoo@default:default
2019-09-13 19:14:10,922 8537 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-13 19:14:11,357 8537 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-13 19:25:16,882 8537 INFO ? odoo.service.server: Initiating shutdown
2019-09-13 19:25:16,882 8537 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2019-09-14 07:54:47,285 1352 INFO ? odoo: Odoo version 11.0-20190112
2019-09-14 07:54:47,293 1352 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-14 07:54:47,294 1352 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-14 07:54:47,296 1352 INFO ? odoo: database: odoo@default:default
2019-09-14 07:54:47,478 1352 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-14 07:54:49,144 1352 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-14 09:30:34,174 1352 INFO ? odoo.service.server: Initiating shutdown
2019-09-14 09:30:34,175 1352 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2019-09-14 09:30:39,178 18560 INFO ? odoo: Odoo version 11.0-20190112
2019-09-14 09:30:39,179 18560 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-14 09:30:39,179 18560 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-14 09:30:39,180 18560 INFO ? odoo: database: odoo@default:default
2019-09-14 09:30:39,208 18560 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-14 09:30:39,634 18560 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.


This is the file
Enrico
bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01

Re: odoo 11 Mageia 7 don't work

Postby bitit » Sep 14th, '19, 11:52

I have try to install also odoo10 instead odoo11 but i have the same problem
Enrico
bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01

Re: odoo 11 Mageia 7 don't work

Postby doktor5000 » Sep 15th, '19, 03:55

2019-09-13 18:26:00,598 8282 INFO ? odoo: Odoo version 11.0-20190112
2019-09-13 18:26:00,599 8282 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-13 18:26:00,599 8282 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-13 18:26:00,605 8282 INFO ? odoo: database: odoo@default:default
2019-09-13 18:26:00,709 8282 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-13 18:26:01,681 8282 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-13 18:48:00,790 8282 INFO ? odoo.service.server: Initiating shutdown


It's not visible from the logs what's triggering the shutdown of the service, but it seems to happen often.

Do you know what happened during that time, and what you did within that ~20 minute timespan ?
But later in the log it happens more often. You'd have to ask upstream about that.
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 17630
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany

Re: odoo 11 Mageia 7 don't work

Postby bitit » Sep 15th, '19, 12:14

no i haven't do nothing , i have work in another pc ;

is a fresh installation, i have only this in the log.

Enrico
Attachments
Schermata del 2019-09-15 11-59-35.png
Schermata del 2019-09-15 11-59-35.png (46.65 KiB) Viewed 2680 times
bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01

Re: odoo 11 Mageia 7 don't work

Postby bitit » Sep 15th, '19, 12:21

ok, i have check other time i have new log
Code: Select all
2019-09-14 14:52:36,192 1377 INFO ? odoo: Odoo version 11.0-20190112
2019-09-14 14:52:36,202 1377 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-14 14:52:36,202 1377 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-14 14:52:36,203 1377 INFO ? odoo: database: odoo@default:default
2019-09-14 14:52:36,315 1377 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-14 14:52:37,176 1377 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-14 15:14:17,242 1377 INFO ? odoo.http: HTTP Configuring static files
2019-09-14 15:14:17,271 1377 INFO ? odoo.sql_db: Connection to the database failed
2019-09-14 15:14:17,276 1377 INFO ? werkzeug: 127.0.0.1 - - [14/Sep/2019 15:14:17] "GET / HTTP/1.1" 500 -
2019-09-14 15:14:17,323 1377 ERROR ? werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python3.7/site-packages/werkzeug/serving.py", line 302, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python3.7/site-packages/werkzeug/serving.py", line 290, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/service/server.py", line 260, in app
    return self.app(e, s)
  File "/usr/lib/python3.7/site-packages/odoo/service/wsgi_server.py", line 166, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/service/wsgi_server.py", line 154, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1319, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1293, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python3.7/site-packages/werkzeug/middleware/shared_data.py", line 227, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1456, in dispatch
    self.setup_db(httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1388, in setup_db
    httprequest.session.db = db_monodb(httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1540, in db_monodb
    dbs = db_list(True, httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1507, in db_list
    dbs = odoo.service.db.list_dbs(force)
  File "/usr/lib/python3.7/site-packages/odoo/service/db.py", line 369, in list_dbs
    with closing(db.cursor()) as cr:
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 634, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 178, in __init__
    self._cnx = pool.borrow(dsn)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 517, in _locked
    return fun(self, *args, **kwargs)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 585, in borrow
    **connection_info)
  File "/usr/lib64/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  role "odoo" does not exist
2019-09-14 15:14:17,569 1377 INFO ? odoo.sql_db: Connection to the database failed
2019-09-14 15:14:17,580 1377 INFO ? werkzeug: 127.0.0.1 - - [14/Sep/2019 15:14:17] "GET /favicon.ico HTTP/1.1" 500 -
2019-09-14 15:14:17,601 1377 ERROR ? werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python3.7/site-packages/werkzeug/serving.py", line 302, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python3.7/site-packages/werkzeug/serving.py", line 290, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/service/server.py", line 260, in app
    return self.app(e, s)
  File "/usr/lib/python3.7/site-packages/odoo/service/wsgi_server.py", line 166, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/service/wsgi_server.py", line 154, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1319, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1293, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python3.7/site-packages/werkzeug/middleware/shared_data.py", line 227, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1456, in dispatch
    self.setup_db(httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1388, in setup_db
    httprequest.session.db = db_monodb(httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1540, in db_monodb
    dbs = db_list(True, httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1507, in db_list
    dbs = odoo.service.db.list_dbs(force)
  File "/usr/lib/python3.7/site-packages/odoo/service/db.py", line 369, in list_dbs
    with closing(db.cursor()) as cr:
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 634, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 178, in __init__
    self._cnx = pool.borrow(dsn)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 517, in _locked
    return fun(self, *args, **kwargs)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 585, in borrow
    **connection_info)
  File "/usr/lib64/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  role "odoo" does not exist
2019-09-14 15:15:12,264 1377 INFO ? odoo.service.server: Initiating shutdown
2019-09-14 15:15:12,264 1377 INFO ? odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2019-09-15 09:52:11,328 1375 INFO ? odoo: Odoo version 11.0-20190112
2019-09-15 09:52:11,347 1375 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-15 09:52:11,348 1375 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-15 09:52:11,348 1375 INFO ? odoo: database: odoo@default:default
2019-09-15 09:52:11,573 1375 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-15 09:52:15,695 1375 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-15 09:57:14,884 1370 INFO ? odoo: Odoo version 11.0-20190112
2019-09-15 09:57:14,897 1370 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-09-15 09:57:14,897 1370 INFO ? odoo: addons paths: ['/var/lib/odoo/addons/11.0', '/usr/lib/python3.7/site-packages/odoo/addons']
2019-09-15 09:57:14,898 1370 INFO ? odoo: database: odoo@default:default
2019-09-15 09:57:15,015 1370 INFO ? odoo.service.server: HTTP service (werkzeug) running on localhost:8069
2019-09-15 09:57:16,074 1370 INFO ? odoo.addons.base.ir.ir_actions_report: You need Wkhtmltopdf to print a pdf version of the reports.
2019-09-15 09:58:45,962 1370 INFO ? odoo.http: HTTP Configuring static files
2019-09-15 09:58:46,006 1370 INFO ? odoo.sql_db: Connection to the database failed
2019-09-15 09:58:46,014 1370 INFO ? werkzeug: 127.0.0.1 - - [15/Sep/2019 09:58:46] "GET / HTTP/1.1" 500 -
2019-09-15 09:58:46,058 1370 ERROR ? werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python3.7/site-packages/werkzeug/serving.py", line 302, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python3.7/site-packages/werkzeug/serving.py", line 290, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/service/server.py", line 260, in app
    return self.app(e, s)
  File "/usr/lib/python3.7/site-packages/odoo/service/wsgi_server.py", line 166, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/service/wsgi_server.py", line 154, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1319, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1293, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python3.7/site-packages/werkzeug/middleware/shared_data.py", line 227, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1456, in dispatch
    self.setup_db(httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1388, in setup_db
    httprequest.session.db = db_monodb(httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1540, in db_monodb
    dbs = db_list(True, httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1507, in db_list
    dbs = odoo.service.db.list_dbs(force)
  File "/usr/lib/python3.7/site-packages/odoo/service/db.py", line 369, in list_dbs
    with closing(db.cursor()) as cr:
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 634, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 178, in __init__
    self._cnx = pool.borrow(dsn)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 517, in _locked
    return fun(self, *args, **kwargs)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 585, in borrow
    **connection_info)
  File "/usr/lib64/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  role "odoo" does not exist
2019-09-15 09:58:46,481 1370 INFO ? odoo.sql_db: Connection to the database failed
2019-09-15 09:58:46,489 1370 INFO ? werkzeug: 127.0.0.1 - - [15/Sep/2019 09:58:46] "GET /favicon.ico HTTP/1.1" 500 -
2019-09-15 09:58:46,516 1370 ERROR ? werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/lib/python3.7/site-packages/werkzeug/serving.py", line 302, in run_wsgi
    execute(self.server.app)
  File "/usr/lib/python3.7/site-packages/werkzeug/serving.py", line 290, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/service/server.py", line 260, in app
    return self.app(e, s)
  File "/usr/lib/python3.7/site-packages/odoo/service/wsgi_server.py", line 166, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/service/wsgi_server.py", line 154, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1319, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1293, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/lib/python3.7/site-packages/werkzeug/middleware/shared_data.py", line 227, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1456, in dispatch
    self.setup_db(httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1388, in setup_db
    httprequest.session.db = db_monodb(httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1540, in db_monodb
    dbs = db_list(True, httprequest)
  File "/usr/lib/python3.7/site-packages/odoo/http.py", line 1507, in db_list
    dbs = odoo.service.db.list_dbs(force)
  File "/usr/lib/python3.7/site-packages/odoo/service/db.py", line 369, in list_dbs
    with closing(db.cursor()) as cr:
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 634, in cursor
    return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 178, in __init__
    self._cnx = pool.borrow(dsn)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 517, in _locked
    return fun(self, *args, **kwargs)
  File "/usr/lib/python3.7/site-packages/odoo/sql_db.py", line 585, in borrow
    **connection_info)
  File "/usr/lib64/python3.7/site-packages/psycopg2/__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  role "odoo" does not exist
bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01

Re: odoo 11 Mageia 7 don't work

Postby doktor5000 » Sep 15th, '19, 22:35

Several times the same error from the PostgreSQL DB: there's a role missing, maybe no dedicated DB user "odoo" has been created yet ?
bitit wrote:psycopg2.OperationalError: FATAL: role "odoo" does not exist

See the two later replies in http://odooexchanges.com/135/fatal-role ... -not-exist
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 17630
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany

Re: odoo 11 Mageia 7 don't work

Postby bitit » Sep 16th, '19, 20:03

Yes sorry , seem that the problem has been the db.

Have installed package postgres sql connection ;
crate a db user with privilege to creating db and it work

Solved
Thank you
bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01


Return to Basic support

Who is online

Users browsing this forum: No registered users and 1 guest

cron