[asterisk-bugs] [JIRA] (ASTERISK-28133) Realtime iaxfriends table 'port' definition causing issues

[George Joseph (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-28133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

George Joseph updated ASTERISK-28133:
-------------------------------------

    Status: Open  (was: Triage)

> Realtime iaxfriends table 'port' definition causing issues
> ----------------------------------------------------------
>
>                 Key: ASTERISK-28133
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28133
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>          Components: Resources/General
>    Affects Versions: 16.0.0
>            Reporter: xrobau
>            Severity: Trivial
>
> Using the database definition as supplied with Asterisk 16, the iaxfriends table is created with port as an int.  However, various queries are updating that with an empty string ('') which causes an error on newer MySQL versions
> {code}
> [Oct 26 05:43:10] WARNING[50802]: res_config_mysql.c:636 update_mysql: MySQL RealTime: Failed to update database: Incorrect integer value: '' for column 'port' at row 1
>     -- Registered IAX2 '12345678' (AUTHENTICATED) at 99.99.99.99:4569
> {code}
> This should either be inserted as an integer, or as a NULL, but not as an empty string.  This, historically, wasn't an issue with MySQL until version 5.6 or so, but now it is much stricter about data being given to it, and (legitimately) complains.
> The hack workaround is to change the definition of the port col to a char, but the correct fix would be to insert valid data.



--
This message was sent by Atlassian JIRA
(v6.2#6252)