Filr error: Data truncation Data too long for column clientAddr

  • 7016768
  • 14-Aug-2015
  • 14-Aug-2015

Environment

Novell Filr 1.1 Mobile App
MobileIron

Situation

Some users cannot login with the Filr app via MobileIron.

Error seen in Filr: /var/opt/novell/tomcat-filr/logs/appserver.log

SQL Error: 1406, SQLState: 22001
Data truncation: Data too long for column 'clientAddr' at row 1
Authentication failure for [USERNAME]
org.springframework.dao.DataIntegrityViolationException: could not insert: [org.kablink.teaming.domain.LoginAudit]; SQL [insert into SS_LoginAudit (zoneId, loginTime, userId, authenticator, clientAddr) values (?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [org.kablink.teaming.domain.LoginAudit]



The clientAddr field is expecting an IPv4 address.  When logging in with MobileIron it's trying to write IP & Port into the field which is too many characters.

Resolution

Increase the size of the clientAddr field:

1) Stop all Filr appliances, this ensures nothing is writing to the database

2) Backup Filr database, either a file copy or using a tool such as http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html

3) Make database change with a tool such as phpMyAdmin (https://www.phpmyadmin.net/) or MySQL Workbench (http://dev.mysql.com/downloads/workbench/)

These instructions are for phpMyAdmin, but the same logic can be applied to the other tools:

a) Start phpMyAdmin to administer the MySQL database and login as root
b) Click on the Filr database, so all tables are opened on the right side off the screen
c) Locate table 'SS_LoginAudit' and select 'Structure'
d) Locate 'clientAddr' and select 'Change'
e) Increase the 'Lenght/Value' to '21' and hit Save
f) Logout of phpMyAdmin

4) Restart Filr appliances

Feedback service temporarily unavailable. For content questions or problems, please contact Support.