• Home
  • Get help
  • Ask a question
Last post 18 min ago
Posts last week 89
Average response time last week 30 min
All time posts 67734
All time tickets 10466
All time avg. posts per day 21

Helpdesk is open from Monday through Friday CET

Please create an (free) account to post any question in the support area.
Please check the development versions area. Look at the changelog, maybe your specific problem has been resolved already!
All tickets are private and they cannot be viewed by anyone. We have made public only a few tickets that we found helpful, after removing private information from them.

#8134 – jDonation URL with 523,772 Duplicates

Posted in ‘sh404SEF’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Tuesday, 07 September 2021 21:12 UTC
gs_john

Hello,

I'm having an issue with a single URL, not sure how it's happening, could it be hackers?

The biggest issue is when trying to process a donation with Joomdonation it redirects to the https://xxxx.org/jdonation which is a 500 error.  So, I went to delte that URL but since there are so many duplicates, it's not allowing me to delete it.

Kind regards,

John

 
Tuesday, 07 September 2021 21:23 UTC
gs_john

Hello,

I logged into myPHPAdmin to see if I could Identify the duplicates, and a bbunch of them are formatted in this way:

index.php?option=com_jdonation&lang=en"_AND_GTID_SUBSET(CONCAT(0x716a6b7871,(SELECT_HEX((CASE_WHEN_(EXISTS(SELECT_8_FROM_user_usrnm))_THEN_1_ELSE_0_END))),0x71626a7171),6415)--_RcCj=

 

Kind regards,

John

 
Tuesday, 07 September 2021 21:55 UTC
gs_john

Hello,

Do you know how I could delete all of these jdonation duplicates via myPHPadmin?

Kind regards,

John

 
Wednesday, 08 September 2021 07:44 UTC
wb_weeblr

Hi

index.php?option=com_jdonation&lang=en"_AND_GTID_SUBSET(CONCAT(0x716a6b7871,(SELECT_HEX((CASE_WHEN_(EXISTS(SELECT_8_FROM_user_usrnm))_THEN_1_ELSE_0_END))),0x71626a7171),6415)--_RcCj=

This indicates that indeed some random bots tried to use a vulnerability in the jDonation extension. None of these attacks worked of course but because you most likely have enabled the "301 redirect from non-sef to SEF" feature under the "Advanced" section of sh404SEF configuration, each of these URLs were recorded (as duplicates).

So the first thing to do is to set "301 redirect from non-sef to SEF" and "301 redirect from Joomla SEF to sh404SEF" to No under the Advanced tab of sh404SEF configuration.

As for deleting these, I'd suggest to just select that URL from the SEF URL manager and click the Delete with dupl. button which is meant exactly for that. If your server fails at some point in the process of deleting so many duplicates, just reload the page and do it again, until there's no duplicates left.

Best regards

Yannick Gaultier

weeblr.com / @weeblr

 

 
Wednesday, 08 September 2021 12:53 UTC
gs_john

Hi Yannick,

If I switch the "301 Redirect from Joomla SEF to Sh404sef" to no with that make it so the attacks can go though?

Is there a way to protect from this occurance?

Kind regards,

John

 
Wednesday, 08 September 2021 13:02 UTC
wb_weeblr

Hi

If I switch the "301 Redirect from Joomla SEF to Sh404sef" to no with that make it so the attacks can go though?

There is no relationship between this and that. Redirecting is not a securioty feature, it just has nothing to do with it. Except that you are filling up your database because you're telling sh404SEF to build a SEF URL for each and every requests that does not already exist and start with index.php.

Is there a way to protect from this occurance?

There is no need for protection. All these are failed attacks. All sites have them, they are just random bots throwing random requests at web server. You likely have attacks directed at WordPress websites in the mix. They are not a threat unless you have out of dates extensions or Joomla for instance.

Best regards

Yannick Gaultier

weeblr.com / @weeblr

 

 
Saturday, 09 October 2021 05:34 UTC
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.