Exactly my plan. Thanks! > On Nov 15, 2016, at 10:38 AM, James Martin <[email protected]> wrote: > > I could only assume you are referring to this 2 year old script I wrote: > https://github.com/jsmartin/ansible-tower-db-migrator > <https://github.com/jsmartin/ansible-tower-db-migrator>. That was created > long before Ansibe Tower had a proper backup restore mechanism. I suggest > you contact Ansible support and use the official method. > > On Tue, Nov 15, 2016 at 1:13 PM, Stuart Cracraft <[email protected] > <mailto:[email protected]>> wrote: > > Getting a bizarre result after migrating postgresql database off-tower using > jsmartin's script. > > The gui no longer logs in. > > Shows username where admin/password are entered but then it goes to > "Working..." > > After a very long pause, it reverts to a blanks screen with > Tower/Projects/Inventories/Job Templates/Jobs across the top but nothing in > the client area. > > None of the controls in the bar across the top work. > > supervisorctl status > > awx-callback-receiver RUNNING pid 5214, uptime 0:04:28 > > awx-celeryd RUNNING pid 5204, uptime 0:04:29 > > awx-fact-cache-receiver RUNNING pid 5172, uptime 0:04:31 > > awx-socketio-service RUNNING pid 5171, uptime 0:04:31 > > awx-task-system RUNNING pid 5189, uptime 0:04:30 > > > > ansible-tower-service status > > Showing Tower Status > > * apache2 is running > > redis-server is running > > > is running > > > > Redis log looks ok: > > tail -10 /var/log/redis/redis-server.log > > [1647] 15 Nov 18:04:09.012 * 10 changes in 300 seconds. Saving... > > [1647] 15 Nov 18:04:09.013 * Background saving started by pid 6290 > > [6290] 15 Nov 18:04:09.016 * DB saved on disk > > [6290] 15 Nov 18:04:09.016 * RDB: 4 MB of memory used by copy-on-write > > [1647] 15 Nov 18:04:09.113 * Background saving terminated with success > > [1647] 15 Nov 18:09:10.063 * 10 changes in 300 seconds. Saving... > > [1647] 15 Nov 18:09:10.064 * Background saving started by pid 7096 > > [7096] 15 Nov 18:09:10.066 * DB saved on disk > > [7096] 15 Nov 18:09:10.066 * RDB: 4 MB of memory used by copy-on-write > > > [1647] 15 Nov 18:09:10.164 * Background saving terminated with success > > > > Able to connect to port 5432 on the remote server which shows: > > netstat -plunt | grep 5432 > > tcp 0 0 0.0.0.0 <http://0.0.0.0/>:5432 0.0.0.0:* > LISTEN 43939/postgres > > > tcp6 0 0 :::5432 :::* LISTEN > 43939/postgres > > > > Apache error log doesn't show anything: > > tail -10 /var/log/apache2/error.log > > [Tue Nov 15 18:00:40.895081 2016] [core:warn] [pid 2303:tid 140370545932160] > AH00045: child process 2311 still did not exit, sending a SIGTERM > > [Tue Nov 15 18:00:42.897368 2016] [core:error] [pid 2303:tid 140370545932160] > AH00046: child process 2310 still did not exit, sending a SIGKILL > > [Tue Nov 15 18:00:42.898396 2016] [core:error] [pid 2303:tid 140370545932160] > AH00046: child process 2311 still did not exit, sending a SIGKILL > > [Tue Nov 15 18:00:43.899660 2016] [mpm_event:notice] [pid 2303:tid > 140370545932160] AH00491: caught SIGTERM, shutting down > > [Tue Nov 15 18:00:47.629592 2016] [ssl:warn] [pid 5605:tid 140170835982208] > AH01906: RSA server certificate is a CA certificate (BasicConstraints: CA == > TRUE !?) > > [Tue Nov 15 18:00:47.629645 2016] [ssl:warn] [pid 5605:tid 140170835982208] > AH01909: RSA certificate configured for localhost:443 does NOT include an ID > which matches the server name > > [Tue Nov 15 18:00:47.637504 2016] [ssl:warn] [pid 5606:tid 140170835982208] > AH01906: RSA server certificate is a CA certificate (BasicConstraints: CA == > TRUE !?) > > [Tue Nov 15 18:00:47.637522 2016] [ssl:warn] [pid 5606:tid 140170835982208] > AH01909: RSA certificate configured for localhost:443 does NOT include an ID > which matches the server name > > [Tue Nov 15 18:00:47.639120 2016] [mpm_event:notice] [pid 5606:tid > 140170835982208] AH00489: Apache/2.4.7 (Ubuntu) OpenSSL/1.0.1f mod_wsgi/3.4 > Python/2.7.6 configured -- resuming normal operations > > > [Tue Nov 15 18:00:47.639148 2016] [core:notice] [pid 5606:tid > 140170835982208] AH00094: Command line: '/usr/sbin/apache2' > > > > > > > > -- > You received this message because you are subscribed to the Google Groups > "Ansible Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/a2f3bf79-670d-411c-97a2-63828767ea56%40googlegroups.com > > <https://groups.google.com/d/msgid/ansible-project/a2f3bf79-670d-411c-97a2-63828767ea56%40googlegroups.com?utm_medium=email&utm_source=footer>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > > -- > You received this message because you are subscribed to a topic in the Google > Groups "Ansible Project" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/ansible-project/1p2ajTg94R8/unsubscribe > <https://groups.google.com/d/topic/ansible-project/1p2ajTg94R8/unsubscribe>. > To unsubscribe from this group and all its topics, send an email to > [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/CAF%3D2pTbZoU87VFD4LvMi8z_s0sU7BFW4mG9-iPutOgcJfkDoVQ%40mail.gmail.com > > <https://groups.google.com/d/msgid/ansible-project/CAF%3D2pTbZoU87VFD4LvMi8z_s0sU7BFW4mG9-iPutOgcJfkDoVQ%40mail.gmail.com?utm_medium=email&utm_source=footer>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>.
-- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/3E321040-E7DC-40A1-BE05-C5A638ABEE9A%40me.com. For more options, visit https://groups.google.com/d/optout.
