[Users] Problems accesing the database

[jplorier at gmail.com]

Hi Eli,

I omitted to post that, but I did use them. It seems that others had
trouble too as the database is owned by postgres after the restore and it's
needed to change the engine user's password when the restore is on a
different host. Thanks to all the ones that posted helpful tips, tomorrow
I'll try those tips and tell the ending.
Regards,
El 12/02/2014 19:38, "Eli Mesika" <emesika at redhat.com> escribió:

>
>
> ----- Original Message -----
> > From: "Juan Pablo Lorier" <jplorier at gmail.com>
> > To: "Yedidyah Bar David" <didi at redhat.com>
> > Cc: "users" <users at ovirt.org>
> > Sent: Wednesday, February 12, 2014 7:55:35 PM
> > Subject: Re: [Users] Problems accesing the database
> >
> > Hi Yedidyah,
> >
> > But If I run engine-setup and then engine-backup restore shuldn't it
> > import the data to the existing db created by engine-setup?
> > That's shown everywhere so I thought it's a valid way to migrate
> > Regards,
>
> Hi
>
> Why aren't you using the --db-user --db-password parameters , its seems
> that you fail to authenticate
>
> >
> > On 12/02/14 15:44, Yedidyah Bar David wrote:
> > > ----- Original Message -----
> > >> From: "Juan Pablo Lorier" <jplorier at gmail.com>
> > >> To: "Sahina Bose" <sabose at redhat.com>
> > >> Cc: "users" <users at ovirt.org>
> > >> Sent: Wednesday, February 12, 2014 7:01:20 PM
> > >> Subject: [Users] Problems accesing the database
> > >>
> > >> Hi Sahina,
> > >>
> > >> Sorry to ping you directly, but you were of great help last time. I'm
> > >> also copying the list.
> > >> In the process of recreating the DC I've decided to migrate the engine
> > >> from a virtualbox vm to a bare metal host and I can't get
> engine-backup
> > >> to restore the engine.
> > >> Both are Centos 6.5 with engine 3.3.3, but in the new box I can't log
> to
> > >> the database with psql -U engine -W
> > >> The error is:
> > >>
> > >> [root at centos-ovirt ~]# engine-backup --mode=restore
> > >> --file=/root/backup_20140212.bkp --log=/root/restore.log
> > >> Restoring...
> > >> FATAL: Can't connect to the database
> > >>
> > >> I've added to pg_hba.conf the lines I found in the web:
> > >>
> > >> host    all    all    md5
> > >>
> > >> and tryied with the conf from the one that works but nothing.
> > >> Any clues?
> > > Unlike engine-setup, engine-backup does nothing for you regarding
> > > creating the database - it's basically the same as creating a database
> > > to be used for a remote-db setup. See e.g. [1] for details, also
> > > 'engine-backup --help'.
> > >
> > > [1] http://www.ovirt.org/OVirt_Engine_Development_Environment#Database
> >
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20140212/3b90595a/attachment-0001.html>