Exactly my plan. Thanks! > On Nov 15, 2016, at 10:38 AM, James Martin <james.s.mar...@gmail.com> 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 <smcracr...@gmail.com > <mailto:smcracr...@gmail.com>> 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 ansible-project+unsubscr...@googlegroups.com > <mailto:ansible-project+unsubscr...@googlegroups.com>. > To post to this group, send email to ansible-project@googlegroups.com > <mailto:ansible-project@googlegroups.com>. > 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 > ansible-project+unsubscr...@googlegroups.com > <mailto:ansible-project+unsubscr...@googlegroups.com>. > To post to this group, send email to ansible-project@googlegroups.com > <mailto:ansible-project@googlegroups.com>. > 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 ansible-project+unsubscr...@googlegroups.com. To post to this group, send email to ansible-project@googlegroups.com. 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.
