CheckUser Installation
I am trying to install CheckUser without command line access. After I am done with PHPMyAdmin thet next part is confusing I have no idea what it is talking about. Can someone tell me what I am so pose to do once I am done adding cu_changes.sql and cu_log.sql
Are you at the point "Configuration" (and no longer in the section "Basic")?
Yes I can't seem to understand what the configuration section is saying.
The only thing in that section you're likely to be interested in is how to adjust how long CU data is kept.
I tried skipping the config step but I got an error message after trying to assign the CheckUser flag to a user. Is the CheckUser data need to be configured?
After I select check user and hit Save User Groups I get this:
Fatal error: Class 'RequestContext' not found in H:\www\mediawiki\extensions\CheckUser\CheckUser.hooks.php on line 25
The trunk version of the extension is not compatible with whatever version of MediaWiki you're using. You'll need to install an older version.
Right now I am running 1.16 and can not upgrade, I tried the older one, current one and newer one. none of them work for me, I was able to get all the way to the permissions screen with the current one but when I selected CheckUser it gave me an error message on the next screen:
Fatal error: Class 'RequestContext' not found in H:\www\mediawiki\extensions\CheckUser\CheckUser.hooks.php on line 25
My wiki needs the CheckUser extension badly, so is there anything else I can do? If not I am thinking of installing 1.18.1 on a different server and just start over again (I would hate to do that as my wiki has gone so far) even if I did that I still wouldn't have shell access. Any ideas or suggestions to help me install the CheckUser extension?
Are you using the CheckUser version for MediaWiki 1.16? Newer versions likely use things not found in 1.16, like a particular class here.
No, I want to run CheckUser on Media Wiki 16.0 but I am having troubles downloading it without command access and if I can't download it on MediaWiki 16.0 I am going to have to start a new wiki (with ver. 18.1.0) I have read the instructions on how to install it without command access and everything works until I try to assign the flag to a user when I click save user groups I get a new white page with this error message:
Fatal error: Class 'RequestContext' not found in H:\www\mediawiki\extensions\CheckUser\CheckUser.hooks.php on line 25
... and yes I have tried all the versions of CheckUser with my wiki.
Did you make sure your download was complete?
yes, the download was complete.
Hhm... try using an earlier version of CU, and make sure the PHP version you use is the latest you can use.
I have already done all that
hhm... can we see your CheckUser.hooks.php?
Do you want me to copy/paste the code as a message? Because if so, then that is fine
Yes. Put it between <source lang="php"> and </source>.
class CheckUserHooks { /** * Hook function for RecentChange_save * Saves user data into the cu_changes table */ public static function updateCheckUserData( RecentChange $rc ) { global $wgRequest; // Extract params extract( $rc->mAttribs ); // Get IP $ip = wfGetIP(); // Get XFF header $xff = $wgRequest->getHeader( 'X-Forwarded-For' ); list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff ); // Get agent $agent = $wgRequest->getHeader( 'User-Agent' ); // Store the log action text for log events // $rc_comment should just be the log_comment // BC: check if log_type and log_action exists // If not, then $rc_comment is the actiontext and comment if ( isset( $rc_log_type ) && $rc_type == RC_LOG ) { $target = Title::makeTitle( $rc_namespace, $rc_title ); $context = RequestContext::newExtraneousContext( $target ); $formatter = LogFormatter::newFromRow( $rc->mAttribs ); $formatter->setContext( $context ); $actionText = $formatter->getPlainActionText(); } else { $actionText = ''; } $dbw = wfGetDB( DB_MASTER ); $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' ); $rcRow = array( 'cuc_id' => $cuc_id, 'cuc_namespace' => $rc_namespace, 'cuc_title' => $rc_title, 'cuc_minor' => $rc_minor, 'cuc_user' => $rc_user, 'cuc_user_text' => $rc_user_text, 'cuc_actiontext' => $actionText, 'cuc_comment' => $rc_comment, 'cuc_this_oldid' => $rc_this_oldid, 'cuc_last_oldid' => $rc_last_oldid, 'cuc_type' => $rc_type, 'cuc_timestamp' => $rc_timestamp, 'cuc_ip' => IP::sanitizeIP( $ip ), 'cuc_ip_hex' => $ip ? IP::toHex( $ip ) : null, 'cuc_xff' => !$isSquidOnly ? $xff : '', 'cuc_xff_hex' => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null, 'cuc_agent' => $agent ); # On PG, MW unsets cur_id due to schema incompatibilites. So it may not be set! if ( isset( $rc_cur_id ) ) { $rcRow['cuc_page_id'] = $rc_cur_id; } $dbw->insert( 'cu_changes', $rcRow, __METHOD__ ); return true; } /** * Hook function to store password reset * Saves user data into the cu_changes table */ public static function updateCUPasswordResetData( User $user, $ip, $account ) { global $wgRequest; // Get XFF header $xff = $wgRequest->getHeader( 'X-Forwarded-For' ); list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff ); // Get agent $agent = $wgRequest->getHeader( 'User-Agent' ); $dbw = wfGetDB( DB_MASTER ); $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' ); $rcRow = array( 'cuc_id' => $cuc_id, 'cuc_namespace' => NS_USER, 'cuc_title' => '', 'cuc_minor' => 0, 'cuc_user' => $user->getId(), 'cuc_user_text' => $user->getName(), 'cuc_actiontext' => wfMsgForContent( 'checkuser-reset-action', $account->getName() ), 'cuc_comment' => '', 'cuc_this_oldid' => 0, 'cuc_last_oldid' => 0, 'cuc_type' => RC_LOG, 'cuc_timestamp' => $dbw->timestamp( wfTimestampNow() ), 'cuc_ip' => IP::sanitizeIP( $ip ), 'cuc_ip_hex' => $ip ? IP::toHex( $ip ) : null, 'cuc_xff' => !$isSquidOnly ? $xff : '', 'cuc_xff_hex' => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null, 'cuc_agent' => $agent ); $dbw->insert( 'cu_changes', $rcRow, __METHOD__ ); return true; } /** * Hook function to store email data * Saves user data into the cu_changes table */ public static function updateCUEmailData( $to, $from, $subject, $text ) { global $wgSecretKey, $wgRequest; if ( !$wgSecretKey || $from->name == $to->name ) { return true; } $userFrom = User::newFromName( $from->name ); $userTo = User::newFromName( $to->name ); $hash = md5( $userTo->getEmail() . $userTo->getId() . $wgSecretKey ); // Get IP $ip = wfGetIP(); // Get XFF header $xff = $wgRequest->getHeader( 'X-Forwarded-For' ); list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff ); // Get agent $agent = $wgRequest->getHeader( 'User-Agent' ); $dbw = wfGetDB( DB_MASTER ); $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' ); $rcRow = array( 'cuc_id' => $cuc_id, 'cuc_namespace' => NS_USER, 'cuc_title' => '', 'cuc_minor' => 0, 'cuc_user' => $userFrom->getId(), 'cuc_user_text' => $userFrom->getName(), 'cuc_actiontext' => wfMsgForContent( 'checkuser-email-action', $hash ), 'cuc_comment' => '', 'cuc_this_oldid' => 0, 'cuc_last_oldid' => 0, 'cuc_type' => RC_LOG, 'cuc_timestamp' => $dbw->timestamp( wfTimestampNow() ), 'cuc_ip' => IP::sanitizeIP( $ip ), 'cuc_ip_hex' => $ip ? IP::toHex( $ip ) : null, 'cuc_xff' => !$isSquidOnly ? $xff : '', 'cuc_xff_hex' => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null, 'cuc_agent' => $agent ); $dbw->insert( 'cu_changes', $rcRow, __METHOD__ ); return true; } /** * Hook function to store autocreation data from the auth plugin * Saves user data into the cu_changes table * * @param $user User * * @return true */ public static function onAuthPluginAutoCreate( User $user ) { return self::logUserAccountCreation( $user, 'checkuser-autocreate-action' ); } /** * Hook function to store registration data * Saves user data into the cu_changes table * * @param $user User * @param $byEmail bool * @return bool */ public static function onAddNewAccount( User $user, $byEmail ) { return self::logUserAccountCreation( $user, 'checkuser-create-action' ); } /** * @param $user User * @param $actiontext string * @return bool */ protected static function logUserAccountCreation( User $user, $actiontext ) { global $wgRequest; // Get IP $ip = wfGetIP(); // Get XFF header $xff = $wgRequest->getHeader( 'X-Forwarded-For' ); list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff ); // Get agent $agent = $wgRequest->getHeader( 'User-Agent' ); $dbw = wfGetDB( DB_MASTER ); $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' ); $rcRow = array( 'cuc_id' => $cuc_id, 'cuc_page_id' => 0, 'cuc_namespace' => NS_USER, 'cuc_title' => '', 'cuc_minor' => 0, 'cuc_user' => $user->getId(), 'cuc_user_text' => $user->getName(), 'cuc_actiontext' => wfMsgForContent( $actiontext ), 'cuc_comment' => '', 'cuc_this_oldid' => 0, 'cuc_last_oldid' => 0, 'cuc_type' => RC_LOG, 'cuc_timestamp' => $dbw->timestamp( wfTimestampNow() ), 'cuc_ip' => IP::sanitizeIP( $ip ), 'cuc_ip_hex' => $ip ? IP::toHex( $ip ) : null, 'cuc_xff' => !$isSquidOnly ? $xff : '', 'cuc_xff_hex' => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null, 'cuc_agent' => $agent ); $dbw->insert( 'cu_changes', $rcRow, __METHOD__ ); return true; } /** * Handler for non-standard (edit/log) entries that need IP data * * @param $context IContextSource * @param $data Array * @return bool */ protected static function onLoggableUserIPData( IContextSource $context, array $data ) { $user = $context->getUser(); $request = $context->getRequest(); // Get IP address $ip = $request->getIP(); // Get XFF header $xff = $request->getHeader( 'X-Forwarded-For' ); list( $xff_ip, $isSquidOnly ) = self::getClientIPfromXFF( $xff ); // Get agent $agent = $request->getHeader( 'User-Agent' ); $dbw = wfGetDB( DB_MASTER ); $cuc_id = $dbw->nextSequenceValue( 'cu_changes_cu_id_seq' ); $rcRow = array( 'cuc_id' => $cuc_id, 'cuc_page_id' => $data['pageid'], // may be 0 'cuc_namespace' => $data['namespace'], 'cuc_title' => $data['title'], // may be '' 'cuc_minor' => 0, 'cuc_user' => $user->getId(), 'cuc_user_text' => $user->getName(), 'cuc_actiontext' => $data['action'], 'cuc_comment' => $data['comment'], 'cuc_this_oldid' => 0, 'cuc_last_oldid' => 0, 'cuc_type' => RC_LOG, 'cuc_timestamp' => $dbw->timestamp( $data['timestamp'] ), 'cuc_ip' => IP::sanitizeIP( $ip ), 'cuc_ip_hex' => $ip ? IP::toHex( $ip ) : null, 'cuc_xff' => !$isSquidOnly ? $xff : '', 'cuc_xff_hex' => ( $xff_ip && !$isSquidOnly ) ? IP::toHex( $xff_ip ) : null, 'cuc_agent' => $agent ); $dbw->insert( 'cu_changes', $rcRow, __METHOD__ ); return true; } /** * Hook function to prune data from the cu_changes table */ public static function maybePruneIPData() { global $wgCUDMaxAge; # Every 100th edit, prune the checkuser changes table. if ( 0 == mt_rand( 0, 99 ) ) { $dbw = wfGetDB( DB_MASTER ); $encCutoff = $dbw->addQuotes( $dbw->timestamp( time() - $wgCUDMaxAge ) ); $dbw->delete( 'cu_changes', array( "cuc_timestamp < $encCutoff" ), __METHOD__ ); } return true; } /** * Locates the client IP within a given XFF string * @param string $xff * @return array( string, bool ) */ public static function getClientIPfromXFF( $xff ) { global $wgSquidServers, $wgSquidServersNoPurge; if ( !$xff ) { return array( null, false ); } // Avoid annoyingly long xff hacks $xff = trim( substr( $xff, 0, 255 ) ); $client = null; $isSquidOnly = true; $trusted = true; // Check each IP, assuming they are separated by commas $ips = explode( ',', $xff ); foreach ( $ips as $ip ) { $ip = trim( $ip ); // If it is a valid IP, not a hash or such if ( IP::isIPAddress( $ip ) ) { # The first IP should be the client. # Start only from the first public IP. if ( is_null( $client ) ) { if ( IP::isPublic( $ip ) ) { $client = $ip; } } elseif ( !in_array( $ip, $wgSquidServers ) && !in_array( $ip, $wgSquidServersNoPurge ) ) { $isSquidOnly = false; break; } } } return array( $client, $isSquidOnly ); } public static function checkUserSchemaUpdates( DatabaseUpdater $updater ) { $base = dirname( __FILE__ ); $updater->addExtensionUpdate( array( 'CheckUserHooks::checkUserCreateTables' ) ); if ( $updater->getDB()->getType() == 'mysql' ) { $updater->addExtensionUpdate( array( 'addIndex', 'cu_changes', 'cuc_ip_hex_time', "$base/archives/patch-cu_changes_indexes.sql", true ) ); $updater->addExtensionUpdate( array( 'addIndex', 'cu_changes', 'cuc_user_ip_time', "$base/archives/patch-cu_changes_indexes2.sql", true ) ); } return true; } public static function checkUserCreateTables( $updater ) { $base = dirname( __FILE__ ); $db = $updater->getDB(); if ( $db->tableExists( 'cu_changes' ) ) { $updater->output( "...cu_changes table already exists.\n" ); } else { require_once "$base/install.inc"; create_cu_changes( $db ); } if ( $db->tableExists( 'cu_log' ) ) { $updater->output( "...cu_log table already exists.\n" ); } else { require_once "$base/install.inc"; create_cu_log( $db ); } } /** * Tell the parser test engine to create a stub cu_changes table, * or temporary pages won't save correctly during the test run. */ public static function checkUserParserTestTables( &$tables ) { $tables[] = 'cu_changes'; return true; } /** * Add a link to Special:CheckUser on Special:Contributions/<username> for * privileged users. * @param $id Integer: user ID * @param $nt Title: user page title * @param $links Array: tool links * @return true */ public static function loadCheckUserLink( $id, $nt, &$links ) { global $wgUser; if ( $wgUser->isAllowed( 'checkuser' ) ) { $links[] = $wgUser->getSkin()->makeKnownLinkObj( SpecialPage::getTitleFor( 'CheckUser' ), wfMsgHtml( 'checkuser-contribs' ), 'user=' . urlencode( $nt->getText() ) ); } return true; } /** * Retroactively autoblocks the last IP used by the user (if it is a user) * blocked by this Block. * * @param Block $block * @param Array &$blockIds */ public static function doRetroactiveAutoblock( Block $block, array &$blockIds ) { $dbr = wfGetDB( DB_SLAVE ); $user = User::newFromName( (string)$block->getTarget(), false ); if ( !$user->getId() ) { return array(); // user in an IP? } $options = array( 'ORDER BY' => 'cuc_timestamp DESC' ); $options['LIMIT'] = 1; // just the last IP used $res = $dbr->select( 'cu_changes', array( 'cuc_ip' ), array( 'cuc_user' => $user->getId() ), __METHOD__ , $options ); # Iterate through IPs used (this is just one or zero for now) foreach ( $res as $row ) { if ( $row->cuc_ip ) { $id = $block->doAutoblock( $row->cuc_ip ); if ( $id ) $blockIds[] = $id; } } return false; // autoblock handled } }
Indeed, I cannot find anything in a "RequestContext" class for my version of CU, using MW 1.18.0. I might suggest (I'd defer to a developer's opinion) that you replace:
if ( isset( $rc_log_type ) && $rc_type == RC_LOG ) { $target = Title::makeTitle( $rc_namespace, $rc_title ); $context = RequestContext::newExtraneousContext( $target ); $formatter = LogFormatter::newFromRow( $rc->mAttribs ); $formatter->setContext( $context ); $actionText = $formatter->getPlainActionText();
with
if ( isset( $rc_log_type ) && $rc_type == RC_LOG ) { $target = Title::makeTitle( $rc_namespace, $rc_title ); $actionText = LogPage::actionText( $rc_log_type, $rc_log_action, $target, null, LogPage::extractParams( $rc_params ) );
when importing: cu_chanfes.sql and cu_log.sql on phpmyadmin should the code language be binary,utf8 or some other code language?
The default works fine for me. I don't know much about that one.
now I am getting this error:
Parse error: syntax error, unexpected T_PUBLIC in H:\www\wikipedia\extensions\CheckUser\CheckUser.hooks.php on line 63
It looks like your version of this file is missing some things; did you download using Subversion?
Yes
Then, if you're using MediaWiki 1.18.0, you'll have to use Special:ExtensionDistributor/CheckUser to download a 1.18-appropriate version. The version you downloaded is likely a late version with things not implemented yet in 1.18.
