Summary:ASTERISK-20756: Asterisk sippeers.sql columns place error cause peer to be without codecs when setting disallow=all under MySQL
Reporter:Andre Luis (andrel)Labels:
Date Opened:2012-11-29 11:30:47.000-0600Date Closed:2012-12-07 18:33:45.000-0600
Versions:11.0.1 Frequency of
Environment:Ubuntu 12.04.01 LTS 386 Asterisk 11.0.1 LTS compiled from source Dahdi 2.6.1 Libipri 1.4.13Attachments:( 0) sippeers.patch
Description: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.

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 .
Comments:By: Andre Luis (andrel) 2012-11-29 11:35:09.878-0600

Patch for sippeers.sql