#130 openemm doesn't accept logins from IPv6-hosts

OpenEMM
closed-accepted
nobody
3
2013-01-26
2012-09-10
No

there's a problem with one sql-table saving the ip-address

ERROR [http-8080-1] org.agnitas - execute: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO login_track_tbl (ip_address, login_status, username) VALUES (?,?,?)]; Data truncation: Data too long for column 'ip_address' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'ip_address' at row 1

Discussion

  • Martin Aschoff

    Martin Aschoff - 2012-09-25

    Field ip_address is of type varchar(20) is not sufficient for IPv6 addresses, indeed - thnaks for the hint! Fix could be:

    #>mysql -u root -p
    mysql> use openemm
    mysql> ALTER TABLE login_track_tbl MODIFY ip_address varchar(40) default NULL;
    mysql> quit

     
  • Martin Aschoff

    Martin Aschoff - 2012-09-25
    • priority: 5 --> 3
    • status: open --> open-accepted
     
  • Martin Aschoff

    Martin Aschoff - 2013-01-26
    • status: open-accepted --> closed-accepted
     
  • Martin Aschoff

    Martin Aschoff - 2013-01-26

    Fixed with OpenEMM 2013

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks