odd result after migrating postgresql database off-tower

[Stuart Cracraft]

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'

[James Martin]

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.

--
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+unsubscribe@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/a2f3bf79-670d-411c-97a2-63828767ea56%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Stuart Cracraft]

Exactly my plan. Thanks!

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.
To unsubscribe from this group and all its topics, send an email to ansible-proje...@googlegroups.com.
To post to this group, send email to ansible...@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.