SSL and CB User Mgt Hanging again

Hi Kyle,

I have been speaking again with the host support desk since my last update here - but without any change in symptoms. I would like to list below their summary post which includes some comments on the MySQL queries to see if anything there looks unexpected to you or may prompt in your mind something else for me to investigate.

If not, then all I can think of doing is building a mirror site on an alternate host and seeing if this shows any different behavior. Any other suggestions welcome of course.

Here is the Simply Hosting last post:

---
David,

You have made it to my queue which is usually not a good sign!

I do hope all is well with you.

I have been following this and let me give you a status on what we have done. I have personally looked at it and can not explain why with SSL this does not work and without it does. I have had multiple server admins look at this and each of of them can not determine the root cause.

We can certainly work on the code but I would need to start charging you for admin time at that point.

We have optimized the server and MySQL about as far as we can at this point but it has not helped. I will copy a few comments below but I have to ask you to go to the developers at this point. If you have any questions please keep in mind my answer to you may take some time.

---

Some of the MySQL queries that are called with this URL is resource intensive and these queries are not getting executed completely. Please refer the snippet below:

~~~~~~
| 6517 | sagorg_sagj15 | localhost | sagorg_test2 | Query | 13 | Copying to tmp table | SELECT u.*, GROUP_CONCAT( DISTINCT g.title ORDER BY g.title SEPARATOR ', ') AS groupname, ue.approve |
~~~~~~

The following queries in the file "/home/sagorg/public_html/test3/administrator/components/com_comprofiler/controller/controller.users.php", are suspicious.

~~~~~~
SELECT COUNT(DISTINCT u.id)
SELECT u.*, GROUP_CONCAT( DISTINCT g.$grp_name ORDER BY g.$grp_name SEPARATOR ', ') AS groupname, ue.approved, ue.confirmed, ue.cbactivation
SELECT DISTINCT u.*, g.$grp_name AS groupname, ue.approved, ue.confirmed, ue.cbactivation
~~~~~~

These queries are coded for operating upon the "sagorg_test2" database. Further, we have checked the database health and ensured that it is not corrupted.

The issue persists.

Optimizing MySQL queries may be the next option that we can try out. Hence, we request you to contact your developer and get the above mentioned queries optimized.

---

Regards,

Gustave Dahl
Simply Hosting .:. Owner

The queries are optimized further in CB 2.0, but regardless I can't see how SQL has anything to do with SSL failing. There has to be some sort of redirect in place or maybe some HTML onpage is being output with http and a rewrite somewhere is trying to change it to https, but it's getting stuck in a loop.

I've went through user management source 3 times now and can't see any reason for this to happen. Maybe it's a 3rd party extension or plugin that's installed? Try disabling non-core CB plugins 1 by 1 and see if that resolves it.

Thanks Kyle.

The hosting service owner has looked at the issue and I would like to share his latest feedback and attached error screen shots in the hope that it means something significant to you, and that you can answer his particular question.

His message is as follows and refers to the two files I have attached.

---
Simply Hosting, LLC Gustave
16:13 (6 hours ago)

to Heather, david.farmer
====== Please reply above this line ======


David,

I have looked at this on and off but the only thing I am seeing is what has already been reported to you.

Every other page on your site seems okay using https, the page in question works fine in http but hangs on https which you already know so I am not telling you anything new.

When it hangs, there is a MySQL process that just just sits there copying data to the tmp table (See Attached) If I subsequently kill the MySQL process the page finished loading with an error (Also see Attached).

If I run the query on the database as is, it runs just fine.

Do you know which plugin or module is calling this particular query?

Regards,

Gustave Dahl
Simply Hosting .:. Owner

---

Ticket ID: #954406
Department: Gustave
Subject: Applying SSL to site results in a hanging page and 500 error
Status: Answered
Ticket URL: secure.simplyhosting.net/client/viewticket.php?tid=954406&c=aQDJOMYD

---

The first screenshot query is the CB > User Management query. It pulls the users from Joomla, joins them to CB user, and then joins their usergroup map so it can all be output in the list. I can't see anything wrong with the query though and it's working fine with/without SSL in all my local tests. I also can't see what SSL has to do with the query. I suggest disabling non-core CB plugins 1 by 1 and see if that resolves it as perhaps it's a CB plugin that's loading in user management and causing your issues.

Thanks Kyle.

To summarize what I think my next steps could be:
1. Restore a backup of the current test site on a different host, apply SSL, and test if problem persists
2. Backup and then drop the user table on the current test site and then incrementally add test users and then real data to see when the problem reappears (as per hosting service's suggestion)
3. Once more go through and test the disabling of each CB plugin to see if I can find a configuration that does not cause the hanging issue (as per your suggestion)
4. Disable each third party extension one by one to see if I can find one that allows the page not to hang
5. Wait till a release candidate of Community Builder 2.0 is available, back up the site and then test the upgrade to see if this resolves the issue

Any further suggestions or thoughts?

For your first test I suggest creating a clean Joomla + CB install on the same host (sub-domain or sub-folder) then enable SSL and see if User Management is showing the issue still. If not then use CB Juice to import your entire user base and re-test to see if issue still present. If issue resolved then it's guaranteed to be either a Joomla extension or CB plugin causing your problems. If not resolved then you may want to test a new host.