[Spacewalk-list] Failed schema upgrade to 2.5

[Konstantin Raskoshnyi]

Default credentials should be these ones

db_backend = postgresql
db_user = rhnuser
db_password = rhnpw
db_name = rhnschema

I updated from 2.3 to 2.4 a couple weeks ago, everything was fine

On Fri, Jun 10, 2016 at 10:34 AM, Steve Kent <skent at noblesystems.com> wrote:

> I restored my database, tried it, and everything worked great.
>
> Now I am back to the same issue I had from upgrading 2.3 to 2.4.
>
> I go ahead and run "spacewalk-setup" and it fails. It fails because the
> rhn.conf file is not properly created for the database settings.
>
> I am expecting to have this in my rhn.conf file:
> db_backend = postgresql
> db_user = spaceuser
> db_password = spacepw
> db_name = spaceschema
>
> Instead I get:
> db_backend = postgresql
> db_user = rhnuser
> db_password = rhnpw
> db_name = rhnschema
>
> I am not sure why it's not picking up the proper spacewalk setup. Last
> time I went ahead and modified the spacewalk-setup file to overwrite the
> rhn.conf file after it was created. I would love to know what I am missing
> or what's not configured correctly that is causing that issue. It never
> happened on my upgrades prior to 2.4.
>
> Steve
>
> -----Original Message-----
> From: Steve Kent [mailto:skent at noblesystems.com]
> Sent: Friday, June 10, 2016 8:19 AM
> To: Jan Dobes <jdobes at redhat.com>; spacewalk-list at redhat.com
> Subject: RE: [Spacewalk-list] Failed schema upgrade to 2.5
>
> Thanks. I will give it a shot.
>
> Steve
>
> -----Original Message-----
> From: Jan Dobes [mailto:jdobes at redhat.com]
> Sent: Friday, June 10, 2016 8:06 AM
> To: Steve Kent <skent at noblesystems.com>; spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] Failed schema upgrade to 2.5
>
> The upgrade should be fixed now in spacewalk-schema-2.5.23-1.
>
> Regards,
> --
> Jan Dobes
> Satellite Engineering, Red Hat
>
> On 9.6.2016 19:41 Steve Kent wrote:
> > Thanks for the update!
> >
> > Steve
> >
> > -----Original Message-----
> > From: Jan Dobes [mailto:jdobes at redhat.com]
> > Sent: Thursday, June 09, 2016 1:37 PM
> > To: Steve Kent <skent at noblesystems.com>; spacewalk-list at redhat.com
> > Subject: Re: [Spacewalk-list] Failed schema upgrade to 2.5
> >
> > We know about it. It's bug in upgrades scripts which occurs when there
> > are multiple organization on Spacewalk. We will try to release fixed
> > spacewalk-schema package as soon as possible. Sorry for inconvenience.
> >
> > Regards,
> > --
> > Jan Dobes
> > Satellite Engineering, Red Hat
> >
> > On 9.6.2016 18:47 Steve Kent wrote:
> >> I attempted to upgrade from 2.4 to 2.5 and ran into this issue:
> >>
> >> clear_log_id
> >>
> >> --------------
> >>
> >> (1 row)
> >>
> >> psql:/var/log/spacewalk/schema-upgrade/20160609-124047-script.sql:4470:
> >> ERROR:  more than one row returned by a subquery used as an
> >> expression
> >>
> >> Here is the sql statement:
> >>
> >> SELECT logging.clear_log_id();
> >>
> >> DELETE FROM rhnOrgExtGroupMapping
> >>
> >>     WHERE server_group_id = (
> >>
> >>       SELECT id
> >>
> >>         FROM rhnServerGroup
> >>
> >>         WHERE group_type = (
> >>
> >>           SELECT id
> >>
> >>             FROM rhnServerGroupType
> >>
> >>             WHERE label = 'provisioning_entitled'
> >>
> >>         )
> >>
> >>     );
> >>
> >> spaceschema=# select * from rhnOrgExtGroupMapping;
> >>
> >> id | ext_group_id | server_group_id | created | modified
> >>
> >> ----+--------------+-----------------+---------+----------
> >>
> >> (0 rows)
> >>
> >> spaceschema=#
> >>
> >>
> >>
> >> Thanks,
> >>
> >> *Steve Kent*
> >> /Director, Platform R&D/
> >> *Noble Systems Corporation*
> >> (o) 1.404.851.1331 x1305
> >> (e)skent at noblesystems.com <mailto:skent at noblesystems.com>
> >> (w)www.noblesystems.com <http://www.noblesystems.com/>
> >>
> >>
> >>
> >> _______________________________________________
> >> Spacewalk-list mailing list
> >> Spacewalk-list at redhat.com
> >> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160610/a26b8fa4/attachment.htm>