This is an automated notification sent by LCG Savannah.
It relates to:
task #7327, project CDS Invenio
==============================================================================
LATEST MODIFICATIONS of task #7327:
==============================================================================
Update of task #7327 (project cdsware):
Category: None => MiscUtil
Percent Complete: 0% => 20%
_______________________________________________________
Follow-up Comment #1:
I have changed cmtACTIONHISTORY table definiton, so the traceback is no
more.
May require to adapt code looking SQL, see also
(http://cdsware.cern.ch/lists/project-cdsware-users/archive/msg01129.shtml).
And, of course, ideally the IPv6 clients should not all be represented as
NULL, which blurs "people who have read this page have also read" and other
stats.
==============================================================================
OVERVIEW of task #7327:
==============================================================================
URL:
<http://savannah.cern.ch/task/?7327>
Summary: Invenio to be IPV6 ready
Project: CDS Invenio
Submitted by: skaplun
Submitted on: 2008-07-07 09:04
Should Start On: 2008-07-07 00:00
Should be Finished on: 2008-07-07 00:00
Category: MiscUtil
Priority: 4
Status: None
Privacy: Public
Percent Complete: 20%
Assigned to: None
Open/Closed: Open
Discussion Lock: Any
Effort: 0.00
_______________________________________________________
In many places of Invenio IP addresses are supposed to be IPV4. This is
broken when using IPV6 Invenio on a IPV6-ready machine.
e.g.:
[...]
File "/usr/lib64/python2.5/site-packages/invenio/webcomment_webinterface.py",
line 285, in add
client_ip_address=client_ip_address)
File "/usr/lib64/python2.5/site-packages/invenio/webcomment.py", line 860,
in perform_request_add_comment_or_remark
client_ip_address=client_ip_address)
File "/usr/lib64/python2.5/site-packages/invenio/webcomment.py", line 596,
in query_add_comment_or_remark
run_sql(query2%params2)
File "/usr/lib64/python2.5/site-packages/invenio/dbquery.py", line 233, in
run_sql
rc = cur.execute(sql, param)
File "/usr/lib64/python2.5/site-packages/MySQLdb/cursors.py", line 166, in
execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.5/site-packages/MySQLdb/connections.py", line 35,
in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1048, "Column 'client_host' cannot be null")
where client_ip_address is filled by invenio.urlutils.get_client_ip_address,
which on an IPV6 machine would return e.g. "::1" for localhost.
On the oter side the MySQL query in this example fails because the MySQL
function inet_aton is used, which expect IPV4 only strings.
_______________________________________________________
Follow-up Comments:
-------------------------------------------------------
Date: 2008-07-08 08:25 By: Tibor Simko <simko>
I have changed cmtACTIONHISTORY table definiton, so the traceback is no
more.
May require to adapt code looking SQL, see also
(http://cdsware.cern.ch/lists/project-cdsware-users/archive/msg01129.shtml).
And, of course, ideally the IPv6 clients should not all be represented as
NULL, which blurs "people who have read this page have also read" and other
stats.
_______________________________________________________
Carbon-Copy List:
CC Address | Comment
------------------------------------+-----------------------------
1576 | -COM-
2195 | -SUB-
==============================================================================
This item URL is:
<http://savannah.cern.ch/task/?7327>
_______________________________________________
Message sent via/by LCG Savannah
http://savannah.cern.ch/
