[asterisk-bugs] [JIRA] (ASTERISK-20771) Asterisk sippeers.sql columns place error cause peer to be without codecs when setting disallow=all under MySQL

[Rusty Newton (JIRA)]

Rusty Newton created ASTERISK-20771:
---------------------------------------

             Summary: Asterisk sippeers.sql columns place error cause peer to be without codecs when setting disallow=all under MySQL
                 Key: ASTERISK-20771
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-20771
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Contrib/General
    Affects Versions: 11.0.1
         Environment: Ubuntu 12.04.01 LTS 386
Asterisk 11.0.1 LTS compiled from source
Dahdi 2.6.1
Libipri 1.4.13
            Reporter: Andre Luis
            Severity: Minor


Creating the sippeers table from the sippeers.sql found in
asterisk-11.0.1/contrib/realtime/mysql/ source folder, and
set the parameter "disallow" to "all" will make peers with this configuration to be without codecs, therefore not being able to place calls.

Explanation:
The "disallow" parameter comes after the "allow" parameter in file
sippeers.sql as showed below:
...
      `allow` varchar(40) DEFAULT NULL,
      `disallow` varchar(40) DEFAULT NULL,
...

Peers set with disallow=all won't be able to place calls.

How to fix:
Put the "disallow" column before "allow" as showed below
in file sippeers.sql

...
      `disallow` varchar(40) DEFAULT NULL,
      `allow` varchar(40) DEFAULT NULL,
...

This way will work as supposed to be just like sip.conf .

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira