Database not working

linuxguns · January 9, 2024, 10:08am

I have install tryton using docker and docker compose. I am not able to login http://localhost:8000 using admin as user name and password. Its asking for Database which not shows on login page. Need help thanks

pokoli · January 9, 2024, 10:44am

Did you create and initialize a database?

ced · January 9, 2024, 11:28am

When you run the “Setup the database”, it should request you to setup the password for admin user.

dalers · January 9, 2024, 2:45pm

Perhaps my tutorial will help Install Tryton using Docker on Ubuntu – Dale Scott

linuxguns · January 9, 2024, 4:30pm

yes i need help. I have followed your tutorial but same problem. I do not get option to input databse name on login page at http://localhost:8000/

linuxguns · January 9, 2024, 4:35pm

i just install trytond-admin but what is config file not getting this point

linuxguns · January 9, 2024, 4:49pm

Please check attached. terminal not ask me setup any password for admin user.

ced · January 9, 2024, 4:59pm

I do not see that you run:

$ docker run --link tryton-postgres:postgres -e DB_PASSWORD=mysecretpassword -it tryton/tryton trytond-admin -d tryton --all

PS: please do not use screenshots for text, but copy/paste so it can be searched and read by blind people.

linuxguns · January 9, 2024, 6:10pm

After run this commands this is what i see:

root@cli:~# docker run --link tryton-postgres:postgres -e DB_PASSWORD=Securep@swd -it tryton/tryton trytond-admin -d tryton --all
1 140227640512576 [2024-01-09 18:09:47,873] ERROR trytond.backend.postgresql.database connection to "tryton" failed
Traceback (most recent call last):
  File "/usr/local/lib/python3.11/dist-packages/trytond/backend/postgresql/database.py", line 226, in __new__
    inst._connpool = ThreadedConnectionPool(
                     ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 161, in __init__
    AbstractConnectionPool.__init__(
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 59, in __init__
    self._connect()
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 63, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.OperationalError: could not translate host name "swd@172.17.0.2" to address: Name or service not known

Traceback (most recent call last):
  File "/usr/local/bin/trytond-admin", line 31, in <module>
    admin.run(options)
  File "/usr/local/lib/python3.11/dist-packages/trytond/admin.py", line 30, in run
    database = backend.Database(db_name)
               ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/dist-packages/trytond/backend/postgresql/database.py", line 226, in __new__
    inst._connpool = ThreadedConnectionPool(
                     ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 161, in __init__
    AbstractConnectionPool.__init__(
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 59, in __init__
    self._connect()
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 63, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.OperationalError: could not translate host name "swd@172.17.0.2" to address: Name or service not known

ced · January 9, 2024, 6:17pm

As you put an @ in the DB_PASSWORD, the construction of the URI is failing. Retry without @ in the password until Using '@' in DB_PASSWORD fails to connect (#8) · Issues · Tryton / Tryton Docker · GitLab is solved.

linuxguns · January 9, 2024, 8:16pm

changed DB password

docker run --link tryton-postgres:postgres -e DB_PASSWORD=Securep786wd -it tryton/tryton trytond-admin -d tryton --all

but same error:

root@cli:~# docker run --link tryton-postgres:postgres -e DB_PASSWORD=Securep786wd -it tryton/tryton trytond-admin -d tryton --all
1 139896292298816 [2024-01-09 20:15:02,723] ERROR trytond.backend.postgresql.database connection to "tryton" failed
Traceback (most recent call last):
  File "/usr/local/lib/python3.11/dist-packages/trytond/backend/postgresql/database.py", line 226, in __new__
    inst._connpool = ThreadedConnectionPool(
                     ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 161, in __init__
    AbstractConnectionPool.__init__(
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 59, in __init__
    self._connect()
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 63, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  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 at "172.17.0.2", port 5432 failed: FATAL:  database "tryton" does not exist

Traceback (most recent call last):
  File "/usr/local/bin/trytond-admin", line 31, in <module>
    admin.run(options)
  File "/usr/local/lib/python3.11/dist-packages/trytond/admin.py", line 30, in run
    database = backend.Database(db_name)
               ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/dist-packages/trytond/backend/postgresql/database.py", line 226, in __new__
    inst._connpool = ThreadedConnectionPool(
                     ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 161, in __init__
    AbstractConnectionPool.__init__(
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 59, in __init__
    self._connect()
  File "/usr/lib/python3/dist-packages/psycopg2/pool.py", line 63, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  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 at "172.17.0.2", port 5432 failed: FATAL:  database "tryton" does not exist

ced · January 9, 2024, 8:34pm

You must change the database name to pgdb because it is was you set in previous command so it should be:

docker run --link tryton-postgres:postgres -e DB_PASSWORD=Securep786wd -it tryton/tryton trytond-admin -d pgdb --all

ced · January 9, 2024, 8:36pm

For smooth experience, you must follow the command of Docker like exactly.

linuxguns · January 10, 2024, 7:25pm

thanks its work after follow the command exactly

ced · January 10, 2024, 7:34pm

For the record, I worked on a simple ready to docker compose file: Provide a simple compose file (!22) · Merge requests · Tryton / Tryton Docker · GitLab

linuxguns · January 10, 2024, 9:09pm

After i click Logout it shows this error:

SyntaxError: Failed to execute ‘open’ on ‘XMLHttpRequest’: Invalid URL

REPORT BUG