Skip to Content
Menu
This question has been flagged
4 Replies
2300 Views

Hello odoo friends, I have a problem deploying a test in odoo。

The version of odoo  is 17.

This is the error in log.


Running as user 'root' is a security risk.2024-01-03 16:28:37,712 32414 INFO ? odoo: Odoo version 17.0+e-20231224 2024-01-03 16:28:37,712 32414 INFO ? odoo: addons paths: ['/usr/lib/python3/dist-packages/odoo/addons', '/root/.local/share/Odoo/addons/17.0'] 2024-01-03 16:28:37,713 32414 INFO ? odoo: database: default@default:default 2024-01-03 16:28:38,321 32414 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf Exception in thread odoo.service.httpd:Traceback (most recent call last): File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner self.run() File "/usr/lib/python3.10/threading.py", line 953, in run2024-01-03 16:28:39,737 32414 INFO ? odoo.sql_db: Connection to the database failed Exception in thread odoo.service.cron.cron0:Traceback (most recent call last): self._target(*self._args, **self._kwargs) File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 505, in http_thread File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner self.httpd = ThreadedWSGIServerReloadable(self.interface, self.port, self.app) File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 170, in __init__ self.run() File "/usr/lib/python3.10/threading.py", line 953, in run super(ThreadedWSGIServerReloadable, self).__init__(host, port, app, File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 688, in __init__ self._target(*self._args, **self._kwargs) File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 497, in target super().__init__(server_address, handler) # type: ignore File "/usr/lib/python3.10/socketserver.py", line 452, in __init__2024-01-03 16:28:39,748 32414 INFO ? odoo.sql_db: Connection to the database failed Exception in thread odoo.service.cron.cron1:Traceback (most recent call last): File "/usr/lib/python3.10/threading.py", line 1016, in _bootstrap_inner self.server_bind() File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 186, in server_bind self.run() File "/usr/lib/python3.10/threading.py", line 953, in run super(ThreadedWSGIServerReloadable, self).server_bind() self.cron_thread(i) File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 455, in cron_thread File "/usr/lib/python3.10/http/server.py", line 137, in server_bind socketserver.TCPServer.server_bind(self) File "/usr/lib/python3.10/socketserver.py", line 466, in server_bind with conn.cursor() as cr: File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 752, in cursor self._target(*self._args, **self._kwargs) File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 497, in target self.socket.bind(self.server_address)OSError: [Errno 98] Address already in use return Cursor(self.__pool, self.__dbname, self.__dsn) File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 267, in __init__ self.cron_thread(i) File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 455, in cron_thread with conn.cursor() as cr: File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 752, in cursor self._cnx = pool.borrow(dsn) File "", line 2, in borrow return Cursor(self.__pool, self.__dbname, self.__dsn) File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 267, in __init__ self._cnx = pool.borrow(dsn) File "", line 2, in borrow File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 87, in locked return func(inst, *args, **kwargs) File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 681, in borrow File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 87, in locked result = psycopg2.connect( File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 122, in connect return func(inst, *args, **kwargs) File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 681, in borrow conn = _connect(dsn, connection_factory=connection_factory, **kwasync)psycopg2.OperationalError: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist result = psycopg2.connect( File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync)psycopg2.OperationalError: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist

Avatar
Discard
Best Answer

Hi 

Check this forum 


Regards

Avatar
Discard
Best Answer

What are some common causes and solutions for this error?

Avatar
Discard

Test access to https://2player.co/ OK

Best Answer

Hi,
Create a postgres user and set the credentials inside the odoo configuration file:  How To Create Database User For Odoo Instance

Thanks

Avatar
Discard
Author Best Answer

thank you ,i will try it ...

Avatar
Discard