2016-11-04 20:58 GMT-03:00 jmo <[email protected]>: > > On Friday, November 4, 2016 at 2:39:19 PM UTC-7, Axel Braun wrote: >> >> >> Schöne Grüße >> Axel Braun >> -- >> Written from cell phone - excuses for typos >> >> Am 4. November 2016 20:34:00 MEZ, schrieb jmo <[email protected]>: >> >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. >> >> 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 >> >> > 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: >
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 > <https://groups.google.com/d/msgid/tryton/6fc83cf6-7487-4a4c-8998-e7f443f0d8cf%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- ------------------------- Karla Mª Stenger Sábat [email protected] -- 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/CAF9qxNrRF52vAS060pwLxi9%3D8H0UAhjkxsF1vqG925kYqX9YOg%40mail.gmail.com.
