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] > <javascript:>>: > >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: 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.
