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)
--------------------------
**Version**: master
**Severity**: normal