On Friday, November 4, 2016 at 6:42:56 PM UTC-7, Karla Stenger wrote:
>
>
>
> 2016-11-04 20:58 GMT-03:00 jmo <sjay...@gmail.com <javascript:>>:
>
>>
>> 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 <sjay...@gmail.com>:
>>> >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
> karla....@gmail.com <javascript:>
>
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?
--
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.
