||WARNING: The code or configuration described here poses a major security risk.
Site administrators: You are advised against using it until this security issue is resolved.
Problem: Vulnerable to SQL injection attacks, because it passes user input directly into SQL commands. This may lead to user accounts being hijacked, wiki content being compromised, private data being leaked, malware being injected, and the entire wiki content being erased, among other things.
Solution: make proper use of MediaWiki's database class instead of concatenating raw sql
Release status: stable
|Implementation||Special page, Database|
|Description||Allows SQL queries through a special page in the wiki, without opening phpMyAdmin etc.|
|Latest version||2008-01-31 (2008-01-31)|
|MediaWiki||1.12 and above|
Translate the Asksql extension if it is available at translatewiki.net
|Check usage and version matrix; code metrics|
Asksql extension allows you to do SQL queries through Special:Asksql in the wiki, without opening phpMyAdmin etc.
Warning: Dangerous if not configured properly!
Installation[edit | edit source]
- Download and extract the tarball in your
extensions/folder. It should generate a new folder called
Asksqldirectly inside your
- Add the following code at the bottom of your LocalSettings.php:
require_once "$IP/extensions/Asksql/Asksql.php"; $wgGroupPermissions['bureaucrat']['asksql'] = true;
- Done! Navigate to "Special:Version" on your wiki to verify that the extension is successfully installed.