Skip to main content
Best answer

Connecting Zapier to Ubuntu Apache Mysql server - SSL errors using Godaddy SSL Certificate

  • September 8, 2023
  • 4 replies
  • 110 views

Andrew Reid

Hello,

I’m trying to Connect Zapier to my Mysql database hosted on an Ubuntu server with a LAMP stack. My SSL certificate is from Godaddy. It looks like I have all the right files - SSL Client Certificate, SSL Private Key, SSL CA Bundle - but I am still getting certificate errors. My URL is https://hopedata.ca and I’ve done the Qualys labs test and I get a B overall rating. Any ideas what I could be missing? As far as I could tell, the SSL Client Certificate and SSL CA Bundle came from Godaddy, and the SSL Private Key came from my server - it is the apache2ssl.key file. These are the three files as they are listed in my default.conf file
SSLEngine on
    SSLCertificateFile /etc/apache2/SSL/cert/ce531f28030cd4fe.crt
    SSLCertificateKeyFile /etc/apache2/SSL/private/apache2ssl.key
    SSLCertificateChainFile /etc/apache2/SSL/cert/gd_bundle-g2-g1.crt
Any help would be appreciated

Best answer by sento.groupBest answer by sento.group

Hello,

I had a very similar problem.

While I'm not certain this will be helpful for you, I can share how I addressed the issue.I only filled out the 'SSL Private Key' field and left the 'SSL Client Certificate' and 'SSL CA Bundle' fields empty.

I obtained my SSL certificate from Zero SSL.The configuration likely depends on the certificate authority.

https://app.zerossl.com/

View original
Did this topic help you find an answer to your question?

4 replies

  • New
  • 1 reply
  • Answer
  • September 11, 2023

Hello,

I had a very similar problem.

While I'm not certain this will be helpful for you, I can share how I addressed the issue.I only filled out the 'SSL Private Key' field and left the 'SSL Client Certificate' and 'SSL CA Bundle' fields empty.

I obtained my SSL certificate from Zero SSL.The configuration likely depends on the certificate authority.

https://app.zerossl.com/


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6360 replies
  • September 11, 2023

Hi there @sento.group,

Thank you for sharing your solution on this issue. Additionally, it looks like the screenshot you’ve shared didn’t come through. Could you please resend them again so that @Andrew Reid can take a look?

Thanks!


Andrew Reid
  • Author
  • Beginner
  • 1 reply
  • September 11, 2023

Thank you very much, @sento.group. Your solution worked!


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7427 replies
  • September 12, 2023

YAY! 😁🎉 That’s great news, @Andrew Reid. Really appreciate you popping back in here to confirm that the solution @sento.group suggested worked! 

Seems like you’re all set for now but please do reach back out in Community if you need help with anything else Zap-related. The Community is always here and happy to assist! 🤗