Mediawiki and greensql
If you want to use the green sql firewall with mediawiki, you'll need a small patch that disables the SQL comments in every query:
diff -up ./includes/db/Database.php.orig ./includes/db/Database.php --- ./includes/db/Database.php.orig 2011-01-15 20:31:07.000000000 +0100 +++ ./includes/db/Database.php 2011-01-15 20:31:48.000000000 +0100 @@ -473,19 +473,19 @@ abstract class DatabaseBase { # Add a comment for easy SHOW PROCESSLIST interpretation #if ( $fname ) { - global $wgUser; - if ( is_object( $wgUser ) && !($wgUser instanceof StubObject) ) { - $userName = $wgUser->getName(); - if ( mb_strlen( $userName ) > 15 ) { - $userName = mb_substr( $userName, 0, 15 ) . '...'; - } - $userName = str_replace( '/', '', $userName ); - } else { - $userName = ''; - } - $commentedSql = preg_replace('/\s/', " /* $fname $userName */ ", $sql, 1); + # global $wgUser; + # if ( is_object( $wgUser ) && !($wgUser instanceof StubObject) ) { + # $userName = $wgUser->getName(); + # if ( mb_strlen( $userName ) > 15 ) { + # $userName = mb_substr( $userName, 0, 15 ) . '...'; + # } + # $userName = str_replace( '/', '', $userName ); + # } else { + # $userName = ''; + # } + # # $commentedSql = preg_replace('/\s/', " /* $fname $userName */ ", $sql, 1); #} else { - # $commentedSql = $sql; + $commentedSql = $sql; #} # If DBO_TRX is set, start a transaction