Fix for harvester to work with IPv6 addresses

[hydra]

Hi list

I have found a bug which results in an error message " value too long for type character varying(15)" when trying to access the PKP harvester using an IPv6 address. The reason for this behavior lies in the "sessions" table which stores the IP address of each client in the column "ip_address". This column is of type varchar(15), which is not suitable for IPv6 addresses, which can consist of up to 39 characters.

Resolution:

Change the value in dbscripts/xml/harvester2_schema.xml before generating the database:

Code: Select all

        <table name="sessions">
                <field name="ip_address" type="C2" size="39">
                        <NOTNULL/>
                </field>
        </table>


Is there a possibilty for me to submit this bugfix to the code repository or maybe a ticketing system?

Best regards
Christian

[asmecher]

Hi Christian,

Thanks! I've submitted this bug to Bugzilla at http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=3602. FYI for next time, you should be able to submit entries there yourself (or, if you're not sure whether you're dealing with a bug or a support question, the forum here is good too).

Regards,
Alec Smecher
Public Knowledge Project Team