Categories
View Replies (7)

Resolved Problem " SSL certificate problem: certificate has expired "

  1. jcsl
    jcsl
  2. RO CSVI
  3. Monday, 04 October 2021
  4.  Subscribe via email
All of a sudden I get the following error both using a cron to run the stock update or using the backend... Please advice. Note that to make sure we have re-installed SSL on furnishopcy.com. If the ssl problem is with the remote site we are trying to retrieve the xml feed from ... is there a way to bypass issue ( i.e ignore ssl certificate )?

#
#<?php die('Forbidden.'); ?>
#Date: 2021-10-04 02:00:02 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: date time line_nr action comment
2021-10-04 02:00:02 0 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs
2021-10-04 02:00:02 0 [DEBUG] Retrieving file https://www.b2bmarkt.gr/feeds?key=37300cidNmOrlBxWEF6zc19TifYblHtuyZW5mUl5C&act=1001&lang=1
2021-10-04 02:00:02 0 [DEBUG] Check if remote file exists
2021-10-04 02:00:02 0 [DEBUG] URL:https://www.b2bmarkt.gr/feeds?key=37300cidNmOrlBxWEF6zc19TifYblHtuyZW5mUl5C&act=1001&lang=1
2021-10-04 02:00:02 0 [DEBUG] Opening socket to ssl://http://www.b2bmarkt.gr at port 443
2021-10-04 02:00:02 0 [DEBUG] HTTP response:HTTP/1.1 200 OK

2021-10-04 02:00:02 0 [DEBUG] Create temporary filefeeds_key_37300cidNmOrlBxWEF6zc19TifYblHtuyZW5mUl5C&act_1001&lang_1
2021-10-04 02:00:02 0 [DEBUG] Retrieve file from remote location
2021-10-04 02:00:02 0 [DEBUG] SSL certificate problem: certificate has expired
2021-10-04 02:00:02 0 [QUERY] TRUNCATE TABLE `tfsar_csvi_processed`
0
Accepted Answer
jcsl
jcsl
Accepted Answer Pending Moderation
We finally managed to find the solution ... Just letting you know ... maybe others have same issue.

Reply from hosting company

I was able to resolve the issue by downloading and copying the cacert.pem file located in public_html/libraries/src/Http/Transport from Joomla! 3.10.2 installation as proposed in the Joomla! forum post below:

https://forum.joomla.org/viewtopic.php?f=706&t=989024
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (7)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Thank you for posting your solution. You are not running an updated Joomla version?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Let me explain :D

  1. Go to templates and click on the Template name to edit the template details. On the second tab called Source, I think you have the option Load from URL and add the bottom is the button Test URL. If you do not have the Load from URL there, you can select it and paste the above URL in the Load from URL field and then click the Test button. You do not need to save the template for that. This should use the same code as used in the import and that is why I think it should give you the same error. You still get the same error on import right?
  2. I am doing my own hosting now because I have had too many problems :(
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
jcsl
jcsl
Accepted Answer Pending Moderation
Ronald... can you please explain the below ?

1. What do you mean by "click the Test button on the Source page of the template. "
2. I have been thinking of leaving Siteground as well. Can I ask to which Hosting did you go ? Do they offer cloud hosting ?
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I do not have much faith in Siteground support as per my own experience, there is a reason I left them :) Their SSL checks for the certificate is not the correct check. To be clear, it is not RO CSVI that is generating this error, the error comes from PHP cURL on the server. Our support does not include server support on how to maintain a webserver to be honest. There isn´t anything codewise we can change to fix this. It is only your server that has this issue. I guess you get the same error when you click the Test button on the Source page of the template. Did you try that?

What you can test is to run the command from SSH shell 


curl -o customer.xml "https://www.b2bmarkt.gr/feeds?key=37300cidNmOrlBxWEF6zc19TifYblHtuyZW5mUl5C&act=1001&lang=1"
and see if that works. If that works, then the issue is in the PHP setup.

If you have the option try a webhost other than Siteground to see if you have the same problem.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
jcsl
jcsl
Accepted Answer Pending Moderation
I checked both the http://www.furnishopcy.com and https://www.b2bmarkt.gr/ ssl certificates and both seem to be valid ( not expired ). I have also contacted the hosting team and their answer is " the SSL issue you're experiencing is application related which is out of our scope of support" ( Please see there full answer below )

https://www.sslshopper.com/ssl-checker.html?hostname=furnishopcy.com

https://www.sslshopper.com/ssl-checker.html?hostname=c5761.sgvps.net

Please can you advice?

Answer from Hosting Provider:

Hello Prodromos,

The Root SSL certificate on the server and your website are valid and have already been changed to ISRG Root X1.

You can verify it using a third-party tool like SSL shopper:

https://www.sslshopper.com/ssl-checker.html?hostname=c5761.sgvps.net
https://www.sslshopper.com/ssl-checker.html?hostname=furnishopcy.com

This can be seen also when you access the website or the server address via the browser:

https://imgur.com/a/davuTQf
https://imgur.com/a/uFeuro6

I confirm the issue here is not with the server as the new root certificate is installed on the latter as I explained and the website and Site Tools are working fine over secure HTTPS (SSL) connection from my end.

This means that the SSL issue you're experiencing is application related which is out of our scope of support. You will need to contact a professional web developer and even if you are the developer of the website, getting a second opinion for another perspective on the matter can only be beneficial to the problem's resolution. We are always doing our best to assist with everything we can, however, we are not specialized in web development and assistance with application-related issues/inquiries falls beyond the scope of our support and out of the area of our expertise.

Should you have any other questions or concerns, please feel free to contact us from your SiteGround Client Area > Help Menu > Contact Us.

Sincerely,
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The certificate issue not a problem with RO CSVI, rather something that bothers RO CSVI. This also means something is wrong with a server setup somewhere. If Let's Encrypt is used this may be the problem as explained in the article Let's Encrypt's Root Certificate is expiring!.

There is unfortunately nothing we can do as we do not manage the servers being used. You can check with your hosting provider to see if their certificate chain is up-to-date. You can run a test via SSH by using the command 
openssl s_client -connect http://www.b2bmarkt.gr:443
. I am guessing the certificate chain on the server is outdated but that is something for the hosting provider to check.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!