Problem: cannot create database

[jmo]

Hello,

Installed tryton-server, modules and client and cannot initialize the database:

/usr/bin/trytond-admin -c /etc/tryton/trytond.conf -u res -d tryton
Traceback (most recent call last):
  File "/usr/bin/trytond-admin", line 21, in <module>
    admin.run(options)
  File "/usr/local/lib/python2.7/dist-packages/trytond/admin.py", line 23, in run
    with Transaction().start(db_name, 0):
  File "/usr/local/lib/python2.7/dist-packages/trytond/transaction.py", line 87, in start
    database = Database(database_name).connect()
  File "/usr/local/lib/python2.7/dist-packages/trytond/backend/postgresql/database.py", line 93, in connect
    minconn, maxconn, self.dsn(self.name))
  File "/usr/lib/python2.7/dist-packages/psycopg2/pool.py", line 156, in __init__
    self, minconn, maxconn, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/psycopg2/pool.py", line 58, in __init__
    self._connect()
  File "/usr/lib/python2.7/dist-packages/psycopg2/pool.py", line 62, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
psycopg2.OperationalError: FATAL:  Peer authentication failed for user "tryton"

Also, "Create" database button on client does not result in any further action.

Do I need to add database host(localhost) on the .conf here or some other step I am missing?:
# PostgreSQL via Unix domain sockets
# (e.g. PostgreSQL database running on the same machine (localhost))
uri = postgresql://tryton:tryton@/

Any help is greatly appreciated.

[Sergi Almacellas Abellana]

You have configured the server to use the tryton database user with a tryton password, but this credentials are not valid, so you must ensure those credintials are valid on the Postgresql server.

>Any help is greatly appreciated.

Hope it helps!

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.

[Axel Braun]

Schöne Grüße
Axel Braun
--
Written from cell phone - excuses for typos

Looks like the user tryton is not authorised in the database.
Is a role for user tryton created?
Is the authentication method in /var/lib/pgsql/data/pg_hba.conf correct?
Cheers
Axel

[jmo]

Axel and Sergi: thanks for both your replies - please see what I have found.
First, looked for roles:
 
\du
                             List of roles
 Role name |                   Attributes                   | Member of
-----------+------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication | {}
 tryton    | Create DB                                      | {}

 Then, check for pg_hba.conf, but cannot find it in /var/lib:

ls
apt        dpkg             libreoffice  postgresql      systemd      vim
cloud      emacsen-common   logrotate    python          tryton       xml-core
container  initramfs-tools  man-db       python-support  ucf
dbus       initscripts      misc         sgml-base       update-rc.d
dhcp       insserv          pam          sudo            urandom

I am checking out Tryton project as user/beginner, so explain like I'm 5 if you need to.
Regardless, I'm committed to figure it out so any additional guidance is greatly appreciated.

[Karla Stenger]

Path of configuration files vary slightly between linux distributions. ​Check somewhere similar to this path /etc/postgresql/9.3/main/pg_hba.conf​ ​(notice the postgres version number in the path in this case)​.

However before modifying that file ​I would check the password of the tryton role (as different from tryton linux user), you can log into psql shell with tryton role (psql -U tryton) and use \password command to ensure your password is the one you set in the tryton config file.

​Good luck,

Karla

ls
apt        dpkg             libreoffice  postgresql      systemd      vim
cloud      emacsen-common   logrotate    python          tryton       xml-core
container  initramfs-tools  man-db       python-support  ucf
dbus       initscripts      misc         sgml-base       update-rc.d
dhcp       insserv          pam          sudo            urandom

I am checking out Tryton project as user/beginner, so explain like I'm 5 if you need to.
Regardless, I'm committed to figure it out so any additional guidance is greatly appreciated.

--
You received this message because you are subscribed to the Google Groups "tryton" group.
To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/6fc83cf6-7487-4a4c-8998-e7f443f0d8cf%40googlegroups.com.

--

-------------------------
Karla  Mª  Stenger  Sábat
karla....@gmail.com

[jmo]

Thanks for the details Karla, I was able to find the pg_hba.conf according to your directions.  The only diffference was I have v9.4.

I did not find the tryton role named in this conf file, although the user was made when I followed the install docs.

Also, I got another peer authentification error when trying to check the password, so I used Axel's direction on Tryton user FAQ postgres check: 

https://groups.google.com/forum/#!searchin/tryton/peer$20authentication|sort:relevance/tryton/8oYwr42xrYo/JXlNzi64qjAJ

As a beginner, maybe I am missing something basic.

May I post my trytond.conf and ha_pba.conf here as Jesús Martín suggests in the above thread for the more experienced to take a look?

[Karla Stenger]

​You don't need to ask for permission to post your current configuration.
However, be clear on your question, because for what you said I don't understand if you still have a problem to solve.​

Cheers,

Karla.

--
You received this message because you are subscribed to the Google Groups "tryton" group.

To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/c43c1d8b-e21b-4c37-9743-4cc8737e48d8%40googlegroups.com.