7 a.m.
On Tue, May 8, 2018 at 7:11 AM, Anastasiya Ruzhanskaya <
anastasiya.ruzhanskaya(a)frtk.ru> wrote:
scl enable rh-postgresql95 'psql -U postgres'
This should be :
scl enable rh-postgresql95 bash
psql: FATAL: Peer authentication failed for user
"postgres"
I am not sure why it is trying to execute the command while enabling.
2018-05-07 12:22 GMT-04:00 Martin Sivak <msivak(a)redhat.com>:
> Hi,
>
> that sure looks like postgresql SCL packages. Software collections are
> installed into /opt and need to be enabled using the `scl enable
> <collection name>` command to allow their usage.
>
> Best regards
>
> Martin Sivak
>
> On Mon, May 7, 2018 at 2:21 PM, Anastasiya Ruzhanskaya
> <anastasiya.ruzhanskaya(a)frtk.ru> wrote:
> > rpm -qa |grep postgres
> > rh-postgresql95-postgresql-libs-9.5.9-1.el7.x86_64
> > postgresql-libs-9.2.23-3.el7_4.x86_64
> > rh-postgresql95-runtime-2.2-2.el7.x86_64
> > rh-postgresql95-postgresql-9.5.9-1.el7.x86_64
> > postgresql-jdbc-9.2.1002-5.el7.noarch
> > postgresql-contrib-9.2.23-3.el7_4.x86_64
> > rh-postgresql95-postgresql-server-9.5.9-1.el7.x86_64
> > postgresql-9.2.23-3.el7_4.x86_64
> > rh-postgresql95-postgresql-contrib-9.5.9-1.el7.x86_64
> > collectd-postgresql-5.8.0-2.el7.x86_64
> > postgresql-server-9.2.23-3.el7_4.x86_64
> > [skotti@localhost ~]$ psql -U postgres
> > psql: FATAL: Peer authentication failed for user "postgres"
> >
> > But I actually installed it manually, still no succeed. But ovirt
> engine is
> > working.
> >
> > 2018-05-07 5:22 GMT-04:00 Eli Mesika <emesika(a)redhat.com>:
> >>
> >>
> >>
> >> On Mon, May 7, 2018 at 11:40 AM, Anastasiya Ruzhanskaya
> >> <anastasiya.ruzhanskaya(a)frtk.ru> wrote:
> >>>
> >>> If the engine user is not accessible directly, why then in this
> command
> >>> you use it?:
> >>>
> >>> psql -U engine engine -c "UPDATE vdc_options set option_value =
> 'false'
> >>> WHERE option_name =
> >>> 'SSLEnabled';"
> >>>
> >>> I am not really good in managing databases, I also didn't have
> postgresql
> >>> installed after finishing oVirt engine installation and even managing
> to
> >>> deploy everything. Does it mean that no database was created at all?
> I have
> >>> chosen automatic and local creation in all fields related to database
> while
> >>> installing oVirt engine.
> >>
> >>
> >> Can you paste the output of the following command
> >>
> >> rpm -qa |grep postgres
> >>
> >>
> >>
> >>>
> >>>
> >>>
> >>> 2018-05-07 11:00 GMT+03:00 Martin Sivak <msivak(a)redhat.com>:
> >>>>
> >>>> Hi,
> >>>>
> >>>> I think what you are looking for is mostly this:
> >>>> https://github.com/oVirt/vdsm/blob/master/lib/vdsm/api/vdsm-api.yml
> >>>>
> >>>> The best way to see what the traffic is is to disable SSL. The
> >>>> postgres database is installed and accessible using the postgres
user
> >>>> (the engine user is not allowed to access it directly).
> >>>>
> >>>> You might also be interested in the vdsm fake project we use as
node
> >>>> simulator. Its readme will tell you exactly how to do this:
> >>>> https://github.com/oVirt/ovirt-vdsmfake
> >>>>
> >>>> I wrote an article some time ago that explained how to setup a
> >>>> development environment without real hosts:
> >>>>
> >>>> https://www.ovirt.org/blog/2016/11/testing-ovirt-changes-wit
> hout-cluster/
> >>>>
> >>>> Might I ask what you goal is?
> >>>>
> >>>> Best regards
> >>>>
> >>>> --
> >>>> Martin Sivak
> >>>> SLA / oVirt
> >>>>
> >>>> On Sun, May 6, 2018 at 6:26 AM, Anastasiya Ruzhanskaya
> >>>> <anastasiya.ruzhanskaya(a)frtk.ru> wrote:
> >>>> > Hello everyone!
> >>>> > Currently I want to determine what information is included in
> messages
> >>>> > passing from oVirt engine to VDSM on ovirt-node.
> >>>> >
> >>>> > I made up a really simple configuration with one VM
representing
> >>>> > engine,
> >>>> > another - node, a managed to successfully launch a single VM
on
> this
> >>>> > node.
> >>>> > However, I have chosen to configure everything automatically.
> >>>> > Currently
> >>>> > traffic is encrypted with default certificates.
> >>>> > So, there are three options for me and no one of them really
works.
> >>>> >
> >>>> > 1) Find the format of messages ( what the fields are, session
id
> for
> >>>> > example) in docs, but I didn't manage to find it;
> >>>> > 2) Use wireshark to decrypt the traffic and the apply maybe a
json
> >>>> > -dissector to the decrypted data. I have tried many solutions
(
> thanks
> >>>> > god I
> >>>> > have rsa private and public keys but there is another session
key
> >>>> > which is
> >>>> > generated every time engine starts to communicate with vdsm,
which
> I
> >>>> > cannot
> >>>> > get with the help of sslkeylog file or ld_preload technology.
> >>>> > Maybe someone knows the exact methodology how to do this
correctly?
> >>>> >
> >>>> > 3) Turn off ssl in oVirt. It is simple to do that for vdsm, but
for
> >>>> > engine,
> >>>> > according to answers on oVirt site, I should do 2 requests to
the
> >>>> > database.
> >>>> > I was really surprised that psql was not installed by oVirt on
my
> >>>> > system.
> >>>> > How did it then created a default database? ( I have chosen to
> create
> >>>> > all
> >>>> > locally and with default configurations).
> >>>> > I mean these two commands :
> >>>> >
> >>>> > https://www.ovirt.org/develop/developer-guide/vdsm/connectin
> g-development-vdsm-to-engine/
> >>>> > . I have a following error there :
> >>>> > psql: FATAL: Peer authentication failed for user
"engine"
> >>>> >
> >>>> > Could you please guide my what method is the best and how
should I
> >>>> > correct
> >>>> > my faults there?
> >>>> >
> >>>> >
> >>>> > _______________________________________________
> >>>> > Devel mailing list
> >>>> > Devel(a)ovirt.org
> >>>> > http://lists.ovirt.org/mailman/listinfo/devel
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> Devel mailing list
> >>> Devel(a)ovirt.org
> >>> http://lists.ovirt.org/mailman/listinfo/devel
> >>
> >>
> >
>