CMS Portal SSL Error

ajperezcrespo wrote on Sunday, July 27, 2014:

Ok so I have gone through each step on the Wiki and setup Wordpress and using git-openemr. I am using a self-signed SSL.
When I click on CMS Portal I get “curl_exec failed: SSL certificate problem: self signed certificate”
I am using Stock Ubuntu 13.10.

Thanks

blankev wrote on Sunday, July 27, 2014:

I have a problem downloading the Ninja files from:

http://www.sunsetsystems.com/download/portal/

the Ninja files open in Firefox, but don’t want to download or should I donwload the text files and import the gibberish into my Wordpress to be portal?

Can’t help you with curl_exec failure… but may be you can help me?

blankev wrote on Sunday, July 27, 2014:

Reading Rod’s documentation again, I read this:

OpenEMR Requirements

Support for the CMS portal is built in to OpenEMR as of release 4.1.3. You may need to make sure PHP cURL support is included; in Ubuntu and Debian installation of the php5-curl package does this. The other important requirement is network access to the WordPress site, which will usually be via the Internet.

Will this be the missing part: php5-curl?

blankev wrote on Sunday, July 27, 2014:

To continue my story:

I followed these intructions:

To download a sample Ninja form with Firefox, right-click the name and select “Save Link As…”.
To import the saved form into WordPress you need to be logged in as an administrator. From your dashboard select Forms -> Import/Export and go from there.

RESULTING for me in: No files selected. Downloads the Demogr… ninja form Copy Link as suggested.

Need to rename files or what?

It seems Ninja file extension does something I don’t understand.

This is what I get on my local machine, and this does not want to be imported:

a:4:{s:2:“id”;N;s:4:“data”;a:23:{s:10:“form_title”;s:12:“Demographics”;s:10:“show_title”;s:1:“0”;s:9:“save_subs”;s:1:“1”;s:9:“logged_in”;s:1:“1”;s:11:“append_page”;s:0:"";s:4:“ajax”;s:1:“0”;s:12:“landing_page”;s:0:"";s:14:“clear_complete”;s:1:“1”;s:13:“hide_complete”;s:1:“1”;s:11:“success_msg”;s:69:“Your form has been successfully submitted.";s:10:“email_from”;s:22:"your.email@example.com”;s:10:“email_type”;s:4:“html”;s:12:“user_subject”;s:0:"";s:14:“user_email_msg”;s:0:"";s:17:“user_email_fields”;s:1:“0”;s:12:“admin_mailto”;s:0:"";s:13:“admin_subject”;s:0:"";s:15:“admin_email_msg”;s

etc…

Correction: Although Import/Export puts a remark no files selected the file IS imported in the Ninja Form as suggested by Rod… this is time for a coffee break… Sorry to have bothered you with the questions.

The Internet is full of miracles without me noticing.

blankev wrote on Sunday, July 27, 2014:

Got the files and uploaded them into Wordpress Ninja Forms. If you know what to expect it takes no more than a few Clicks…

Learning is a continuous effort.

With all failures, “one unexpected succes”, compensates for the anger build-up of stupidity.

Still strange that Wordpress puts something on the top of the page like “upload successful” and after the Browse Import field something like "Unsuccessful to locate the file. Should I complain in Wordpress "Fora or should I lick my wound and continue with the set-up of the CMS Portal?

sunsetsystems wrote on Monday, July 28, 2014:

The cURL functions by default don’t like self-signed certificates. There’s probably a way around that, but you can get a commercial certificate for around $11/year and your patients will be more impressed if you do. See namecheap.com for example.

Rod
http://www.sunsetsystems.com/

sunsetsystems wrote on Monday, July 28, 2014:

Dunno about the “no files selected” message. What you’re supposed to do is browse for and select the file, and then do the upload. So it’s a 2-step process.

Rod
http://www.sunsetsystems.com/

lowhoh wrote on Sunday, December 28, 2014:

Hello~ I used commecial certificate SSL such as Comodo
But same error has happened.

curl_exec failed: SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:func(144):reason(134)

So I want to bypass using this code ‘curl_setopt
($ch, CURLOPT_SSL_VERIFYPEER, false);’

I can’t not find ‘curl_exec():’ Where is curl code?
There isn’t in 'list_requests.php ’

sunsetsystems wrote on Sunday, December 28, 2014:

The cURL code is in interface/cmsportal/portal.inc.php. Also you might try https access with a browser to get more info about the certificate problem.

Rod
http://www.sunsetsystems.com/

visolveemr wrote on Monday, December 29, 2014:

The error code “reason(134)” signifies that the client ( curl in our case ) doesn’t trust the Certificate Authority. Updating the CA bundle might fix the above issue.

  • Curl uses system CA bundle - We can update the CA bundle using any of the below steps:
    i) curl http://curl.haxx.se/ca/cacert.pem -o /etc/pki/tls/certs/ca-bundle.crt

    ii) run “rpm -qf /etc/pki/tls/certs/ca-bundle.crt” to find out which package is responsible for CA bundle and update the package.
    > rpm -qf /etc/pki/tls/certs/ca-bundle.crt
    ca-certificates-2014.1.98-65.1.el6.noarch

OpenEMR Customization/Support Team,
ViSolve Inc
services@visolve.com
Demo’s @ ViSolve Demo Library

lowhoh wrote on Monday, December 29, 2014:

Thank you for your reply.
I am not programmer.
so, I am afraid I can’t understand exactly your guide.
How can I do for your process ? could you explain the step of process?
I tried to find ca-bundle.crt in openemr directory, but I can’t
Does it doing at open-erm on my server

error screen

[********@uws64-145 ~]$ curl http://curl.haxx.se/ca/cacert.pem -o /etc/pki/tls/certs/cd-bundle.crt
Warning: Failed to create the file /etc/pki/tls/certs/cd-bundle.crt
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
2 245k 2 5584 0 0 3495 0 0:01:12 0:00:01 0:01:11 3495
curl: (23) Failed writing body

lowhoh wrote on Tuesday, December 30, 2014:

Thank you very much~

visolveemr wrote on Tuesday, December 30, 2014:

Hello

Have you tried the commands as root user? If not try as an root user or with sudo.

Thanks
OpenEMR Customization/Support Team,
ViSolve Inc
services@visolve.com
Demo’s @ ViSolve Demo Library