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 <[email protected]> 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:[email protected]] > Sent: Friday, June 10, 2016 8:19 AM > To: Jan Dobes <[email protected]>; [email protected] > Subject: RE: [Spacewalk-list] Failed schema upgrade to 2.5 > > Thanks. I will give it a shot. > > Steve > > -----Original Message----- > From: Jan Dobes [mailto:[email protected]] > Sent: Friday, June 10, 2016 8:06 AM > To: Steve Kent <[email protected]>; [email protected] > 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:[email protected]] > > Sent: Thursday, June 09, 2016 1:37 PM > > To: Steve Kent <[email protected]>; [email protected] > > 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)[email protected] <mailto:[email protected]> > >> (w)www.noblesystems.com <http://www.noblesystems.com/> > >> > >> > >> > >> _______________________________________________ > >> Spacewalk-list mailing list > >> [email protected] > >> https://www.redhat.com/mailman/listinfo/spacewalk-list > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
