<div dir="ltr">Daryl<div>I hope you ran the full upgrade script and not just the database upgrade script.</div></div><div class="gmail_extra"> <div class="gmail_quote">On Tue, Nov 29, 2016 at 12:23 PM, Daryl Rose <<a href="mailto:darylrose@outlook.com" target="_blank">darylrose@outlook.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div dir="ltr"> <div id="m_-2097587459255495914divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif" dir="ltr"> Once again I posted and then figured out how to resolve the issue. I was able to successfully to upgrade the schema and that resolved both of my issues. At this moment, it looks like my migration was successfully. Thank you to everyone who helped me get this completed successfully. Daryl <div style="color:rgb(0,0,0)"> <hr style="display:inline-block;width:98%"> <div id="m_-2097587459255495914divRplyFwdMsg" dir="ltr">From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> <<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>> on behalf of Daryl Rose <<a href="mailto:darylrose@outlook.com" target="_blank">darylrose@outlook.com</a>> Sent: Tuesday, November 29, 2016 9:53 AM<div><div class="h5"> To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Migrating to a physical</div></div> <div> </div> </div><div><div class="h5"> <div> <div id="m_-2097587459255495914divtagdefaultwrapper" dir="ltr" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif"> Hello again, After I posted this message, I realized what might be the cause of at least one of my errors. I didn't realize that v2.6 was just released and installed that version on the physical server, while the original server is still v2.5. I'm sure that will resolve the schema error, but will it also resolve the repository issue? Can I upgrade the old server and migrate the database over as Paul posted previously? Does the server name have to be the correct name? To do the migration, I renamed the original server to "<server name>-old", and renamed the physical server to the actual name of the server, had DNS change to reflect the name changes, then installed Spacewalk on the physical server. I can rename everything again and preform the upgrade on the original server, but if I can upgrade it without the name change that would be preferred. Or, I can rename the server without updating DNS. Does the upgrade query DNS to verify that it can fully resolve the name? I could try and force it to read the /etc/host file? Thoughts? Thank you. Daryl <div style="color:rgb(0,0,0)"> <hr style="display:inline-block;width:98%"> <div id="m_-2097587459255495914divRplyFwdMsg" dir="ltr">From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> <<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>> on behalf of Daryl Rose <<a href="mailto:darylrose@outlook.com" target="_blank">darylrose@outlook.com</a>> Sent: Tuesday, November 29, 2016 9:28 AM To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Migrating to a physical <div> </div> </div> <div> <div id="m_-2097587459255495914divtagdefaultwrapper" dir="ltr" style="font-size:12pt;color:#000000;font-family:Calibri,Arial,Helvetica,sans-serif"> Hello All, I finally had the opportunity to migrate from my virtual environment to the physical environment. Thank you to Paul Robert Marino for providing these steps to migrating over the database. For the most part, things went well, however, I see one error that I'm not sure about, and I can't see any of my repositories. The error that I see is on the login screen: A schema upgrade is required. Please upgrade your schema at your earliest convenience to receive latest bug fixes and avoid potential problems. <div>How do do I upgrade the schema? Is this a database message?</div> <div> </div> <div>I also get this error whenever I click on a repository:</div> <div> </div> <div> <div>Internal Server Error</div> <div>The server experienced a problem which prevented your request from being filled out. It may not be possible to execute this action at this time.</div> <div> </div> <div>Please help us correct this problem by contacting us with details of how you received this message.</div> <div> </div> Any thoughts on these issues?</div> <div> </div> <div>Thank you.</div> <div> </div> <div>Daryl</div> <div style="color:rgb(0,0,0)"> <hr style="display:inline-block;width:98%"> <div id="m_-2097587459255495914divRplyFwdMsg" dir="ltr">From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> <<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>> on behalf of Paul Robert Marino <<a href="mailto:prmarino1@gmail.com" target="_blank">prmarino1@gmail.com</a>> Sent: Tuesday, November 15, 2016 3:29 PM To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Migrating to a physical <div> </div> </div> <div> <div dir="ltr">this is an interesting thread. <div>some notes the initial plan looks good.</div> <div>however I usually use C names instead of A records in the DNS.</div> <div>this means you can easily change which host the the record is pointing to.</div> <div>next I would consider moving the database to a separate box or cluster, this will give a nice performance boost over running every thing on the same box.</div> <div> </div> <div>As to your followup question about the archiving I think you may have already figured this out but the archive command in the PostgreSQL's config is for the database journal.</div> <div> </div> <div>Also on a side note there is a quicker way to migrate a PostgreSQL database.</div> <div>step 1</div> <div>while the box is running do a recursive scp from the original box to the new one of the PostgreSQL's data directory, by default its in /var/lib/pgsql on Red Hat based distributions.</div> <div>step 2</div> <div>shut down PostgreSQL on the source server.</div> <div>step 3</div> <div>use rsync -a --delete -c -I of the source server to the destination server. Note the -c and -I flags are very important in this case.</div> <div>step 4</div> <div>start PostgreSQL on the destination server, and optionally the source server too.</div> <div> </div> <div>By the way this is the method pgpool uses to restore a failed slave if you have 3 or more servers in a cluster using a second running slave as the source. the one difference is it uses rsync for both step 1 and 3, but I always use SCP because it is faster for the initial copy.</div> <div> </div> <div> </div> <div> </div> </div> <div class="gmail_extra"> <div class="gmail_quote">On Tue, Nov 15, 2016 at 10:45 AM, test-yle <<a href="mailto:test-yle@quanticdream.com" target="_blank">test-yle@quanticdream.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div bgcolor="white" lang="FR"> <div class="m_-2097587459255495914m_4691099594876420550WordSection1"> Hello, I use a crontab with a scrip to clean a archive. I list a task with spacecmd schedule_list | grep “” And spacecmd schedule_cancel number “id” I kill a archive . The Script: #!/bin/sh fich="/srv/scripts/Clean-Tache-Spwalk/liste.txt" spacecmd schedule_list | grep "Show differences between profiled config files and deployed config files" > $fich spacecmd schedule_list | grep "Deploy config files to system" >> $fich spacecmd schedule_list | grep "Run an arbitrary script" >> $fich ligne=`wc -l $fich | awk -F " " '{print $1}'` x=0 echo "The number of line is $ligne" echo "x=$x" while [ "$x" -le "$ligne" ]; do # echo "1------- $x" id=`cat $fich | awk 'NR=='$x' {print $1}'` echo "ID $id Delete" spacecmd schedule_cancel $id x=$(($x + 1)) echo "-------------$x" done <div> <div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm"> De : <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> [mailto:<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>] De la part de Ree, Jan-Albert van Envoyé : mardi 15 novembre 2016 15:32 À : <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Objet : Re: [Spacewalk-list] Migrating to a physical </div> </div> <div> <div class="m_-2097587459255495914h5"> Ah yes, that can be an issue indeed, we only have a small installation with around 80 clients Cleaning up archived actions can be done from the GUI : Schedule > Archived Actions > Select All > Delete Actions I had roughly 50K archived actions there, in your case it might be a lot more. -- Jan-Albert Jan-Albert van Ree | Linux System Administrator | MARIN Support Group MARIN | T <a href="tel:%2B31%20317%2049%2035%2048" value="+31317493548" target="_blank">+31 317 49 35 48</a> | <a href="mailto:J.A.v.Ree@marin.nl" target="_blank">J.A.v.Ree@marin.nl</a> | <a href="http://www.marin.nl" target="_blank"> www.marin.nl</a> <a href="https://www.linkedin.com/company/marin" target="_blank"><img border="0" width="16" height="16" id="m_-2097587459255495914m_4691099594876420550_x0000_i1025" alt="LinkedIn" style="width:0.1666in;height:0.1666in" src="cid:image001.png@01D23F5E.B6E173F0"></a> <a href="http://www.youtube.com/marinmultimedia" target="_blank"><img border="0" width="16" height="16" id="m_-2097587459255495914m_4691099594876420550_x0000_i1026" alt="YouTube" style="width:0.1666in;height:0.1666in" src="cid:image002.png@01D23F5E.B6E173F0"></a> <a href="https://twitter.com/MARIN_nieuws" target="_blank"><img border="0" width="16" height="16" id="m_-2097587459255495914m_4691099594876420550_x0000_i1027" alt="Twitter" style="width:0.1666in;height:0.1666in" src="cid:image003.png@01D23F5E.B6E173F0"></a> <a href="https://www.facebook.com/marin.wageningen" target="_blank"><img border="0" width="16" height="16" id="m_-2097587459255495914m_4691099594876420550_x0000_i1028" alt="Facebook" style="width:0.1666in;height:0.1666in" src="cid:image004.png@01D23F5E.B6E173F0"></a> MARIN news: <a href="http://www.marin.nl/web/News/News-items/Operational-performance-of-wind-assisted-ships-1.htm" target="_blank"> Operational performance of wind assisted ships</a> <div> <div class="MsoNormal" align="center" style="text-align:center"> <hr size="2" width="98%" align="center"> </div> <div id="m_-2097587459255495914m_4691099594876420550divRplyFwdMsg"> From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> <<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>> on behalf of Daryl Rose <<a href="mailto:darylrose@outlook.com" target="_blank">darylrose@outlook.com</a>> Sent: Tuesday, November 15, 2016 14:07 To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Migrating to a physical <div> </div> </div> <div> <div id="m_-2097587459255495914m_4691099594876420550divtagdefaultwrapper"> Jan-Albert, Thank you for the feedback. I considered going the direction that you went, but that really won't work for me. The steps that I outlined are high level. I left out things like shutting down SW, and changing DNS entry. (The IP address has to change going from VM world to physical world). I also have a proxy server in the mix, so that means that firewall rules have to be changed. Not looking forward to that either. Networking isn't to receptive about changing firewall rules. :-( <snip> <blockquote style="margin-left:30.0pt;margin-right:0cm"> And you might want to clean up archived actions to make database backup / restore a bit quicker </blockquote> </snip> <div> </div> <div> I'm not really sure how to do this. I did a little research and I found this example: </div> <blockquote style="margin-left:30.0pt;margin-right:0cm"> <div> <ul type="disc"> <li class="MsoNormal" style="color:black">archive_cleanup_command = 'pg_archivecleanup /mnt/server/archivedir %r'</li></ul> </div> </blockquote> I don't really think that this is what I need, or is it? <div> </div> <div> Thank you, and thank you for the feedback. </div> <div> </div> <div> Daryl </div> <div> </div> <div> <div> <div class="MsoNormal" align="center" style="text-align:center"> <hr size="2" width="98%" align="center"> </div> </div> <div> <div> <div id="m_-2097587459255495914m_4691099594876420550divRplyFwdMsg"> From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> <<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>> on behalf of Ree, Jan-Albert van <<a href="mailto:J.A.v.Ree@marin.nl" target="_blank">J.A.v.Ree@marin.nl</a>> Sent: Tuesday, November 15, 2016 1:50 AM To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] Migrating to a physical <div> </div> </div> <div> We did something similar earlier this year. However to prevent issues and allow for testing we did things a bit different : - We installed a new server on which we created all the content we needed (we used a new FQDN so we didn't have to do anything to allow for 2 servers in the same network) - Then I wrote a migration script which installed the new certificate package and re-registered the machine to the new SW server This allowed for more control as we did migration per server group and we would never be left with unmanaged machines in the event the migration went wrong. Your plan to me looks solid otherwise, although before step 1 I'd shut down the spacewalk services to make sure nothing in the database gets changed. And you might want to clean up archived actions to make database backup / restore a bit quicker Good luck -- Jan-Albert Jan-Albert van Ree | Linux System Administrator | MARIN Support Group MARIN | T <a href="tel:%2B31%20317%2049%2035%2048" value="+31317493548" target="_blank">+31 317 49 35 48</a> | <a href="mailto:J.A.v.Ree@marin.nl" target="_blank">J.A.v.Ree@marin.nl</a> | <a href="http://www.marin.nl" target="_blank"> www.marin.nl</a> <a href="https://www.linkedin.com/company/marin" target="_blank"><img border="0" width="16" height="16" id="m_-2097587459255495914m_4691099594876420550_x0000_i1031" alt="LinkedIn" style="width:0.1666in;height:0.1666in" src="cid:image001.png@01D23F5E.B6E173F0"></a> <a href="http://www.youtube.com/marinmultimedia" target="_blank"><img border="0" width="16" height="16" id="m_-2097587459255495914m_4691099594876420550_x0000_i1032" alt="YouTube" style="width:0.1666in;height:0.1666in" src="cid:image002.png@01D23F5E.B6E173F0"></a> <a href="https://twitter.com/MARIN_nieuws" target="_blank"><img border="0" width="16" height="16" id="m_-2097587459255495914m_4691099594876420550_x0000_i1033" alt="Twitter" style="width:0.1666in;height:0.1666in" src="cid:image003.png@01D23F5E.B6E173F0"></a> <a href="https://www.facebook.com/marin.wageningen" target="_blank"><img border="0" width="16" height="16" id="m_-2097587459255495914m_4691099594876420550_x0000_i1034" alt="Facebook" style="width:0.1666in;height:0.1666in" src="cid:image004.png@01D23F5E.B6E173F0"></a> MARIN news: <a href="http://www.marin.nl/web/News/News-items/Winaars-Speurspel-open-dag.htm" target="_blank"> Winaars Speurspel open dag</a> <div> <div class="MsoNormal" align="center" style="text-align:center"> <hr size="2" width="98%" align="center"> </div> <div id="m_-2097587459255495914m_4691099594876420550divRplyFwdMsg"> From: <a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a> <<a href="mailto:spacewalk-list-bounces@redhat.com" target="_blank">spacewalk-list-bounces@redhat.com</a>> on behalf of Daryl Rose <<a href="mailto:darylrose@outlook.com" target="_blank">darylrose@outlook.com</a>> Sent: Monday, November 14, 2016 20:29 To: <a href="mailto:spacewalk-list@redhat.com" target="_blank">spacewalk-list@redhat.com</a> Subject: [Spacewalk-list] Migrating to a physical <div> </div> </div> <div> <div id="m_-2097587459255495914m_4691099594876420550divtagdefaultwrapper"> I'm migrating my SW environment from a VM to a physical. I have the physical built, but before I move forward, I need to make sure that I'll have my steps down. Please review my steps, and let me know if I missed anything. <ol start="1" type="1"> <li class="MsoNormal" style="color:black">Rename current SW to temporary name.</li><li class="MsoNormal" style="color:black">Rename physical from temporary name to actual FQDN. </li><li class="MsoNormal" style="color:black">Install latest version of SW (current installation was recently upgraded to 2.5).</li><li class="MsoNormal" style="color:black">rsync following directories: </li></ol> <ol start="4" type="1"> <ul type="circle"> <li class="MsoNormal" style="color:black">/etc/jabberd</li><li class="MsoNormal" style="color:black">/etc/rhn</li><li class="MsoNormal" style="color:black">/etc/sysconfig/rhn</li><li class="MsoNormal" style="color:black">/root/ssl</li><li class="MsoNormal" style="color:black">/var/www/html/pub</li><li class="MsoNormal" style="color:black">/var/satellite</li></ul> </ol> <ol start="5" type="1"> <li class="MsoNormal" style="color:black">Backup Postgres DB from VM</li><li class="MsoNormal" style="color:black">Restore Postgres DB to physical</li></ol> <div> One additional comment, I am using signed cert, so I need to make sure that names and certificates are all correct, so I don't end up having issues with my current connections. </div> <div> </div> <div> If I'm missing something, or I have something wrong, please let me know. </div> <div> </div> <div> Thank you. </div> <div> </div> <div> Daryl </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" rel="noreferrer" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </blockquote> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div></div></div> </div> </div> _______________________________________________ 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" rel="noreferrer" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a> </blockquote></div> </div>