MWI Issue with Polycom on 2.8.0.4

dannyej257
Posts: 1
Member Since:
2010-12-23

I have been having an issue with MWI using Polycom phones on 2.8.0.4 and the issue was resolved by changing the default device options for each extension under the mailbox value. The default config shows that ext#@device which causes severe delay on the MWI for both new messages and once they are deleted.

The only resolution I found is to remove the @device portion of the value and then everything works perfectly!

I'm still researching a way to make it provision the extensions properly because right now I'm manually fixing about 30 devices and that's about 29 too many! Automation FTW.

Can anyone contribute on how to resolve this permanently and for future extensions?



jchawk
Posts: 1
Member Since:
2011-11-26
Thank you this worked for me!

I have Polycom 501 phones and I've been pulling my hair out over this issue. Your solution worked perfectly for me.

If you have a bunch of handsets to change I believe you could edit the configuration directly in order to make mass changes.

These settings appear to be located in - /etc/asterisk/sip_additional.conf



SkykingOH
Posts: 9681
Member Since:
2007-12-17
You can't edit the

You can't edit the sip_additional.conf it gets overwritten every time you submit changes.

Download the FreePBX bulk extension tool version 2.6 (that is the version that trixbox put their name on), export the extensions make the changes in the spreadsheet, change the action column to 'edit' then upload the modified csv.

The even easier way is to use the mysql command line tool. I don't know the syntax off the top of my head but it's a one line change to the SIP table in the asterisk DB. It will be something like update sip set [keyword] = replace(voicemail,'@device','@user');

Remember this is a guess off the top of my head.

I am not sure why you would have to make this change. Do you have pollmailboxes set to yes?

Here is a quick dump of the MySQL tool listing the DB's, tables and the SIP table:


[root@skyPBXhome /]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 177596 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> describe sip.columns;
ERROR 1146 (42S02): Table 'sip.columns' doesn't exist
mysql> describe sip;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id      | varchar(20)  |      | PRI | -1      |       |
| keyword | varchar(30)  |      | PRI |         |       |
| data    | varchar(255) |      |     |         |       |
| flags   | int(1)       |      |     | 0       |       |
+---------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql>
mysql> exit
Bye
[root@skyPBXhome /]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 177597 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+------------------------------+
| Tables_in_asterisk           |
+------------------------------+
| admin                        |
| ampusers                     |
| announcement                 |
| backup                       |
| broadcast_callees            |
| broadcast_campaign_groups    |
| broadcast_campaigns          |
| broadcast_groups             |
| broadcast_log                |
| broadcast_settings           |
| callback                     |
| cidlookup                    |
| cidlookup_incoming           |
| cronmanager                  |
| custom_destinations          |
| custom_extensions            |
| customcontexts_contexts      |
| customcontexts_contexts_list |
| customcontexts_includes      |
| customcontexts_includes_list |
| customcontexts_module        |
| dahdi                        |
| daynight                     |
| devices                      |
| directory_details            |
| directory_entries            |
| directorypro_details         |
| directorypro_entries         |
| disa                         |
| endpoint                     |
| endpoint_man_mac             |
| endpoint_manufacturer        |
| endpoint_model               |
| endpoint_timezone            |
| endpointman_brand_list       |
| endpointman_custom_configs   |
| endpointman_global_vars      |
| endpointman_mac_list         |
| endpointman_model_list       |
| endpointman_oui_list         |
| endpointman_product_list     |
| endpointman_template_list    |
| endpointman_time_zones       |
| extensions                   |
| fax_details                  |
| fax_incoming                 |
| fax_store                    |
| fax_users                    |
| featurecodes                 |
| findmefollow                 |
| freepbx_log                  |
| freepbx_settings             |
| globals                      |
| hotelwakeup                  |
| iax                          |
| iaxsettings                  |
| incoming                     |
| inventorydb                  |
| ivr                          |
| ivr_dests                    |
| language_incoming            |
| languages                    |
| manager                      |
| meetme                       |
| miscapps                     |
| miscdests                    |
| module_xml                   |
| modules                      |
| notifications                |
| outbound_route_patterns      |
| outbound_route_sequence      |
| outbound_route_trunks        |
| outbound_routes              |
| outboundnotification_config  |
| outboundnotification_groups  |
| outroutemsg                  |
| paging_autoanswer            |
| paging_config                |
| paging_groups                |
| parkinglot                   |
| phpagiconf                   |
| pinset_usage                 |
| pinsets                      |
| queueprio                    |
| queues_config                |
| queues_details               |
| recordings                   |
| ringgroups                   |
| setcid                       |
| sip                          |
| sipsettings                  |
| timeconditions               |
| timegroups_details           |
| timegroups_groups            |
| trunk_dialpatterns           |
| trunks                       |
| users                        |
| vmblast                      |
| vmblast_groups               |
| webcallback                  |
| zap                          |
| zapchandids                  |
+------------------------------+
102 rows in set (0.01 sec)

mysql> describe sip;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id      | varchar(20)  |      | PRI | -1      |       |
| keyword | varchar(30)  |      | PRI |         |       |
| data    | varchar(255) |      |     |         |       |
| flags   | int(1)       |      |     | 0       |       |
+---------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql>
mysql>
--

Scott

aka "Skyking"



Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.