CRM icon indicating copy to clipboard operation
CRM copied to clipboard

SQL Injection vulnerability in ChurchCRM 4.4.5 via /churchcrm/WhyCameEditor.php

Open tuando243 opened this issue 2 years ago • 2 comments

SQL Injection vulnerability in ChurchCRM 4.4.5 via /churchcrm/WhyCameEditor.php.

Step to exploit:

  1. Login as admin.

  2. Redirect to profile page and click on Edit "Why Came" Notes. 1

  3. Submit "Why Came" notes and capture request in Burp Suite. 2

  4. Save request to churchcrm.txt file and run sqlmap for injecting the PersonID parameter: sqlmap -r churchcrm.txt -p PersonID 3 4

tuando243 avatar May 17 '22 16:05 tuando243

Isn't admin allowed to make arbitrary SQL queries using QuerySQL.php?

PavelBlinnikov avatar May 17 '22 21:05 PavelBlinnikov

Isn't admin allowed to make arbitrary SQL queries using QuerySQL.php?

Correct. However, we should be sanitising input appropriately on forms etc. Personally, I'm not a huge fan of the QuerySQL.php but it has made some support cases a lot easier - especially when not all admins are comfortable with phpMyAdmin or CLI MySQL tools.

@tuando243 - thanks for the report. I've categorised it as a security bug, but as it requires authenticated access it has limited risk to most setups (except our demo system!).

MrClever avatar May 17 '22 23:05 MrClever

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

github-actions[bot] avatar Oct 30 '23 02:10 github-actions[bot]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

github-actions[bot] avatar Dec 02 '23 02:12 github-actions[bot]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

github-actions[bot] avatar Jan 04 '24 02:01 github-actions[bot]

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

github-actions[bot] avatar Feb 04 '24 02:02 github-actions[bot]

This issue was closed because it has been stalled for 15 days with no activity.

github-actions[bot] avatar Feb 20 '24 01:02 github-actions[bot]