Wikimedia Bugzilla is closed!

When asked for username IP addresses or edits CheckUser might return entries for 127.0.0.1 (for internally generated entries via FauxRequest etc.).

When asked for users on 127.0.0.1 no results are shown, however. 

select * from cu_changes where cuc_ip_hex = '7F000001';

returns no results

It seems like 127.0.0.1 entries are stored like this:


# select * from cu_changes where cuc_ip_hex='0' 
;
-[ RECORD 1 ]--+--------------------------------
cuc_id         | 68
cuc_namespace  | 90
cuc_title      | Dyskusja_użytkownika:Saper/test
cuc_user       | 1
cuc_user_text  | Saper
cuc_actiontext | 
cuc_comment    | Nowy wątek – test
cuc_minor      | 1
cuc_page_id    | 1717
cuc_this_oldid | 63082
cuc_last_oldid | 0
cuc_type       | 1
cuc_timestamp  | 2012-05-07 23:21:58+02
cuc_ip         | 127.0.0.1/32
cuc_ip_hex     | 0
cuc_xff        | 
cuc_xff_hex    | 
cuc_agent      | 

and have cuc_ip_hex stored as zero instead of 7F0001

For MySQL 127.0.0.1 entries are correct:

        cuc_id: 22
 cuc_namespace: 4
     cuc_title: Książki/Moja_książka
      cuc_user: 1
 cuc_user_text: Saper
cuc_actiontext: 
   cuc_comment: Utworzył nową stronę „{{zapisane_książki}}  == Moja książka == === test === :[[Strona główna]]  [[Kategoria:Książki|Książki/Moja książka]]”
     cuc_minor: 0
   cuc_page_id: 8
cuc_this_oldid: 15
cuc_last_oldid: 0
      cuc_type: 1
 cuc_timestamp: 20120301052308
        cuc_ip: 127.0.0.1
    cuc_ip_hex: 7F000001
       cuc_xff: 
   cuc_xff_hex: NULL
     cuc_agent: 
4 rows in set (0.00 sec)