Whilst I do not fully accept your reason for saying you will not provide further support in this problem (especially for CB Subs an ecrypted and paid for plug in) because of small small core code changes (to overcome some restrictive or missing functionality) within Community Builder, I do unterstand the difficulty in providing such support.
Therefore I have set-up a new sandbox site (at
www.sri-connect.com/sandbox) that has an un-hacked version of Community Builder and have tried setting up the Paypal Payment Gateway, the problem persists. I have tried it multiple times using multiple pem files downloaded paypal and certificate.keys generated with openssl, all failed. Even switching from saying encrypted form to plain text form fails. Whenever there is a valid reference to a pem file in any of the certificate/key fields I get a 500 Internal Server error. I can only assume that something in the saving/loading of the enryption certificate/key fields is causing the error.
The full server and site configuration details are:
Server: VPS server with 2GB ram and 128GB storage with a Intel Xeon CPU X5550 @ 2.67GHz (hosted by eukhost.com)
OS: CENTOS 5.5
MYSQL Version: 5.1.48
PHP Version: 5.2.9
Web Server: Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e-fips-rhel5
Joomla! Version: Joomla! 1.5.15 Stable
Community Builder v.1.2.3 (installed v.1.2.2 and tested but problem persisted then upgrade to v.1.2.3)
CB Subs: 1.0.3
You have persistantly said that you consider this a memory problem but as you can see below I should have more than sufficient memory.
The steps I have taken to try and resolve this include:
Check on Access to pem directory
Location of pem files /home/sricon/securessl (I have tried moving the files into the site but the problem persists
open_basedir in Apache httpd.conf includes /home/sricon
No open_basedir set in php.ini
securessl has file permissions 755 and the pem file 644 have chmod directory and pem file to 777 but still problem.
Check on Memory
Rmemlimit in httpd.conf: 411988992 (392M)
php_memory_limit: 128M (have tried 256M but the problem persists)
php_info shows the memory is allocated and I have run a memory testing script which shows that it is available
Check on openssl and cURL
Version of OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008 (tried upgrade to OpenSSL 0.9.8o but problem persists)
openssl is showing in green in the Paypal Payment Gateway.
Check on error reporting
Have confirmed with hosting company that error reporting should be fine so not sure why error log entries for the 500 errors are not being created
php.ini error_reporting: E_ALL & ~E_NOTICE
php.ini error_log: sricphp_error_log
php.ini log_errors_max_len: 1024 (have tried tihis at 2048 but no error log entries added)
Have tried with php.ini display_errors on and it still doesn't work but rather than the 500 Internal Server Error a blank page is just shown.
Have tried turning System Reporting to Maximum in Joomla configuration but again just a blank page is shown.
Despite repeated testing and raising of the 500 error I have only once had an error_log message corresponding to a 500 error (perhaps this will help). The message was:
[07-Sep-2010 17:02:29] PHP Fatal error: Call to undefined function openssl_pkey_get_private() in /home/sricon/public_html/sandbox/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/cbpaidsubscriptions.gui.php on line 0
This occured when the following 500 entry was shown in the raw apache logs:
82.13.89.130 - ecoadmin [07/Sep/2010:17:02:28 +0100] "GET /sandbox/administrator/index2.php?option=com_comprofiler&task=editPlugin&cid=500&action=editrow&table=gatewaysbrowser&tid=1&cbprevstate=b3B0aW9uPWNvbV9jb21wcm9maWxlciZ0YXNrPWVkaXRQbHVnaW4mcGx1Z2luaWQ9NTAwJmFjdGlvbj1zaG93dGFibGUmdGFibGU9Z2F0ZXdheXM= HTTP/1.1" 500 - "www.sri-connect.com/sandbox/administrator/index2.php?option=com_comprofiler&task=editPlugin&cid=500&action=editrow&table=gatewaysbrowser&tid=1&cbprevstate=b3B0aW9uPWNvbV9jb21wcm9maWxlciZ0YXNrPWVkaXRQbHVnaW4mcGx1Z2luaWQ9NTAwJmFjdGlvbj1zaG93dGFibGUmdGFibGU9Z2F0ZXdheXM=" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; OfficeLiveConnector.1.5; OfficeLivePatch.1.3)"
As you can see I am not just leaving it to someone else to solve this problem but I am running out of things to try. Any help or suggestions for how to resolve this problem will be gratefully received.
I have searched extensively in the forum and found no solution but I did note that in several places it is suggested that the encrypted form is not needed (although I would prefer to have it). So have tried with a plain text form and nothing in the encryption fields. This does allow the Paypal Payment Gateway to be saved but when I test making a payment on Paypal Sandbox there is a "communication error" between CB Subs and IPN on Paypal Sandbox. This is very frustrating but as it is a different problem I will raise it in a separate post.
Don't think I'm just being negative about CB Subs. The access control and integration parts have been excellent in allowing me to meet some very demanding client requirements for who can see and edit what on the site. The site has 35 CB Subs plans, 50+ CB tabs, 250+ CB fields and multiple components and modules all sucessfully configured and controlled via CB Subs. I perhaps should have tried testing payment gateways earlier but the client was unsure which he wanted to use and I thought that would be the easy and more standard part!