[asterisk-bugs] [JIRA] (ASTERISK-28398) Column order of contrib realtime MySQL config for sippeers causes issues with NAT

[Kevin Harwell (JIRA)]

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

Kevin Harwell updated ASTERISK-28398:
-------------------------------------

    Status: Open  (was: Triage)

> Column order of contrib realtime MySQL config for sippeers causes issues with NAT
> ---------------------------------------------------------------------------------
>
>                 Key: ASTERISK-28398
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28398
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Channels/chan_sip/General
>    Affects Versions: 16.3.0
>            Reporter: Bart Bergman
>            Severity: Minor
>              Labels: sip
>
> In the create table SQL definition for the sippeers table there are some issues with the column order.
> The columns are read into config in the order they appear in the database.
> `host` before `ipaddr` causes peers to subscribe with their local IP when behind NAT and a `sip reload` is issued.
> `permit` and `deny` might also cause issues (not confirmed)



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