odd result after migrating postgresql database off-tower

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’

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.

Exactly my plan. Thanks!