Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

IPv6: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'lastIpAddress' #3

Closed
saper opened this issue May 30, 2019 · 0 comments · Fixed by #4

Comments

@saper
Copy link

@saper saper commented May 30, 2019

This exception happens when connecting with an IPv6 address:

2019.05.30 14:23:19 com.reucon.openfire.plugins.userstatus.Defaul
tPersistenceManager - Unable to update user status for xxxxx@saper.info/telefon
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'lastIpAddress' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3

Quick fix for MySQL was:

alter table userStatus modify column lastIpAddress char(40);
alter table userStatusHistory modify column lastIpAddress char(40);
@akrherz akrherz closed this in #4 May 31, 2019
akrherz added a commit that referenced this issue May 31, 2019
* #3 increase size of lastipaddress to support ipv6

* #3 increase size of lastipaddress to support ipv6

* #3 added upgrade scripts

* #3 fix types for some sqls

* #3 ffix postgresql upgrade script

* #3 update changelog and readme
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
1 participant
You can’t perform that action at this time.