2016-11-07 16:14 GMT-03:00 jmo <sjaym...@gmail.com>:
> 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>:
>>
>>>
>>> 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_hb
>> a.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/ms
>>> gid/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
>>
>
> 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 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
> <https://groups.google.com/d/msgid/tryton/c43c1d8b-e21b-4c37-9743-4cc8737e48d8%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
-------------------------
Karla Mª Stenger Sábat
karla.sten...@gmail.com
--
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/CAF9qxNrSReJhoVZV1UhkFL6C-kB8uiGwDFNxegPddCSzArDPdw%40mail.gmail.com.
