https://bugzilla.wikimedia.org/show_bug.cgi?id=37971
Web browser: ---
Bug #: 37971
Summary: No results on CheckUser query from 127.0.0.1 on
PostgreSQL
Product: MediaWiki extensions
Version: master
Platform: All
OS/Version: All
Status: NEW
Keywords: postgresql
Severity: normal
Priority: Unprioritized
Component: CheckUser
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected], [email protected]
Blocks: 384
Classification: Unclassified
Mobile Platform: ---
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)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
