I could only assume you are referring to this 2 year old script I wrote: 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]> 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: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]. > 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/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. > -- 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/CAF%3D2pTbZoU87VFD4LvMi8z_s0sU7BFW4mG9-iPutOgcJfkDoVQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
