| 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-0600 | Date Closed: | 2012-12-07 18:33:45.000-0600 |
| Priority: | Minor | Regression? | |
| Status: | Closed/Complete | Components: | Contrib/General |
| Versions: | 11.0.1 | Frequency of Occurrence | Constant |
| Related Issues: | |||
| Environment: | Ubuntu 12.04.01 LTS 386 Asterisk 11.0.1 LTS compiled from source Dahdi 2.6.1 Libipri 1.4.13 | Attachments: | ( 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. 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 . | ||
| Comments: | By: Andre Luis (andrel) 2012-11-29 11:35:09.878-0600 Patch for sippeers.sql | ||