Run server on windows 10 for tryton

Support System Administrator
1

I want run server tryton 5.4 on windows 10 and I launch it with command and I ve this error :slight_smile:

C:\appli\tryton\05_04\bin>python trytond-admin -c ..\..\conf\trytond-sapmanage.conf -d dbsapmanage --all
C:\appli\tryton\05_04\trytond\__init__.py:15: UserWarning: Timezone must be set to UTC instead of Amér. du Sud occid.
  warnings.warn('Timezone must be set to UTC instead of %s' % time.tzname[0])
Traceback (most recent call last):
  File "trytond-admin", line 21, in <module>
    admin.run(options)
  File "C:\appli\tryton\05_04\trytond\admin.py", line 25, in run
    database = Database(db_name)
  File "C:\appli\tryton\05_04\trytond\backend\postgresql\database.py", line 168, in __new__
    cursor_factory=LoggingCursor)
  File "C:\appli\python36\lib\site-packages\psycopg2\pool.py", line 161, in __init__
    self, minconn, maxconn, *args, **kwargs)
  File "C:\appli\python36\lib\site-packages\psycopg2\pool.py", line 58, in __init__
    self._connect()
  File "C:\appli\python36\lib\site-packages\psycopg2\pool.py", line 62, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
  File "C:\appli\python36\lib\site-packages\psycopg2\__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError

My file conf is :slight_smile:

# /etc/tryton/trytond.conf - Configuration file for Tryton Server (trytond)
#
# This file contains the most common settings for trytond (Defaults
# are commented).
# For more information read
# /usr/share/doc/trytond-<version>/

[database]
# Database related settings
# PostgreSQL via TCP/IP
# (e.g. connecting to a PostgreSQL database running on a remote machine or
# by means of md5 authentication. Needs PostgreSQL to be configured to accept
# those connections (pg_hba.conf).)
uri = postgresql://sapmanage:sapmanage@localhost:5434/

# The path to the directory where the Tryton Server stores files.
# The server must have write permissions to this directory.
# (Internal default: /var/lib/trytond)
path = c:/appli/tryton/05_00/bin

# Shall available databases be listed in the client?
list = True

# The number of retries of the Tryton Server when there are errors
# in a request to the database
retry = 5

# The primary language, that is used to store entries in translatable
# fields into the database.
#language = en_US
language = fr_FR

[session]
#super_pwd = jkUbZGvFNeugk
super_pwd = admin
timeout = 259200

[web]
# Path for the web-frontend
listen = *:8001
2

The error is cut and not all the traceback is included but as it’s related to PostgreSQL probably the problem is that your database credentials are not propertly set or the user does not have access to the tryton database.

3

I check and I say you.

4
  • Did you created a postgresql user sapmanage with the password?
  • can you directly login into postgresql with that username and password (using psql or pgadmin)?

Should fr_FR not be just fr? Since version 5.0 (correct me if I’m wrong) the translations has been changed in this way.

5

My version of psql was not the right one, I am on windows and I use the command cygwin which uses the command psql for postgres 9.6 or I use the version postgres 11, therefore I copied the command psql version 11 in cygwin executables. And it worked.

6

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.