<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style></style></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1>The question is why it’s using the default options when I am running postgresql. At one point I switched from oracle to postgresql and I am not sure if something got missed in a table or something, but all my upgrades prior to 2.4 all worked properly, and populated the rhn.conf file with the proper spacewalk postgresql information. When I did the upgrade from 2.3 to 2.4, that is when it stopped populating the rhn.conf correctly, and used the default configuration. Now as I have done the 2.4 to 2.5 upgrade, I have run into the same problem again. I would love to know why it’s not using the spacewalk postgresql settings and choosing the defaults.<o:p></o:p><o:p> </o:p><o:p> </o:p>Steve<o:p></o:p><o:p> </o:p>From: kraskoshnyy@gmail.com [mailto:kraskoshnyy@gmail.com] On Behalf Of Konstantin Raskoshnyi Sent: Friday, June 10, 2016 1:59 PM To: Steve Kent <skent@noblesystems.com>; spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Failed schema upgrade to 2.5<o:p></o:p><o:p> </o:p><div>Default credentials should be these ones <o:p></o:p><div><o:p> </o:p></div><div>db_backend = postgresql db_user = rhnuser db_password = rhnpw db_name = rhnschema<o:p></o:p></div><div><o:p> </o:p></div><div>I updated from 2.3 to 2.4 a couple weeks ago, everything was fine<o:p></o:p></div></div><div><o:p> </o:p><div>On Fri, Jun 10, 2016 at 10:34 AM, Steve Kent <<a href="mailto:skent@noblesystems.com" target="_blank">skent@noblesystems.com</a>> wrote:<o:p></o:p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'>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:<a href="mailto:skent@noblesystems.com">skent@noblesystems.com</a>] Sent: Friday, June 10, 2016 8:19 AM To: Jan Dobes <<a href="mailto:jdobes@redhat.com">jdobes@redhat.com</a>>; <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Subject: RE: [Spacewalk-list] Failed schema upgrade to 2.5 Thanks. I will give it a shot. Steve -----Original Message----- From: Jan Dobes [mailto:<a href="mailto:jdobes@redhat.com">jdobes@redhat.com</a>] Sent: Friday, June 10, 2016 8:06 AM To: Steve Kent <<a href="mailto:skent@noblesystems.com">skent@noblesystems.com</a>>; <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> 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:<a href="mailto:jdobes@redhat.com">jdobes@redhat.com</a>] > Sent: Thursday, June 09, 2016 1:37 PM > To: Steve Kent <<a href="mailto:skent@noblesystems.com">skent@noblesystems.com</a>>; <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> > 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)<a href="mailto:skent@noblesystems.com">skent@noblesystems.com</a> <mailto:<a href="mailto:skent@noblesystems.com">skent@noblesystems.com</a>> >> (w)<a href="http://www.noblesystems.com" target="_blank">www.noblesystems.com</a> <<a href="http://www.noblesystems.com/" target="_blank">http://www.noblesystems.com/</a>> >> >> >> >> _______________________________________________ >> Spacewalk-list mailing list >> <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> >> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p></blockquote></div><o:p> </o:p></div></div></body></html>