Hello!
I want to test Tryton if it fits my needs, so i want to set up a testserver. But i have a problem to start trytond with a postgresql. The topic is simmilar to https://discuss.tryton.org/t/cannot-connect-to-postgressql-db/574.
As you see below i have made a posgresql database with utf8 named trytondatabase and the owner trytonuser.
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
----------------+------------+-----------+---------+-------+-----------------------
postgres | postgres | SQL_ASCII | C | C |
template0 | postgres | SQL_ASCII | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | C | C |
trytondatabase | trytonuser | UTF8 | C | C |
(4 rows)
Output from
sudo netstat -anpt | grep LISTEN
is
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 701/postgres
(i only show the posgresql).
When try the first run with
trytond-admin -c /home/testserver/.config/tryton/5.0/trytond.conf -d trytondatabase --all
(also tried
trytond-admin -c /home/testserver/.config/tryton/5.0/trytond.conf --all
because the database is defined the the trytond.conf file, neither that works)
with this
[database]
uri = postgresql://trytonuser:testpassword@localhost:5432/
path = /var/lib/tryton
list = True
language = en
trytond.conf file, Tryton asks me to set up an e-mail adress und a password. So far, so good. But when i try to login on the Tryton Client, see below
i get an error:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/tryton/gui/main.py", line 276, in do_activate
common.Login()
File "/usr/lib/python3/dist-packages/tryton/common/common.py", line 1012, in __init__
func(parameters)
File "/usr/lib/python3/dist-packages/tryton/rpc.py", line 88, in login
result = connection.common.db.login(username, parameters, language)
File "/usr/lib/python3.7/xmlrpc/client.py", line 1112, in __call__
return self.__send(self.__name, args)
File "/usr/lib/python3/dist-packages/tryton/jsonrpc.py", line 285, in __request
raise Fault(*response['error'])
tryton.jsonrpc.Fault: <Fault 'Database "trytondatabase.sqlite" doesn\'t exist!': 'Traceback (most recent call last):\n File "/trytond/wsgi.py", line 73, in dispatch_request\n return endpoint(request, **request.view_args)\n File "/trytond/protocols/dispatcher.py", line 46, in rpc\n request, database_name, *request.rpc_params)\n File "/trytond/protocols/dispatcher.py", line 53, in login\n Database(database_name).connect()\n File "/trytond/backend/sqlite/database.py", line 265, in connect\n raise IOError(\'Database "%s" doesn\\\'t exist!\' % db_filename)\nOSError: Database "trytondatabase.sqlite" doesn\'t exist!\n'>
But i do not use sqlite? What i am doing wrong?
Many thanks for help!
Greetings
name1234
btw: i sign in before with an other name, but it seems that outlook . com does not like Tryton . org (spaces because i am a new user) . I also looked at the spams, no register mail there, just for information!