[Asterisk-Users] Can not get realtime static voicemail.conf to work

[Matt Gibson]

did you edit extconfig and put a line similar to

voicemail.conf -> realtime,mysql,database

then delete voicemail.conf from your asterisk configs directory and try 
again.

matt


Matt wrote:

>Here is what happens on startup:
>Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime:
>Static SQL: SELECT category, var_name, var_val, cat_metric FROM
>settings WHERE filename='voicemail.conf' and commented=0 ORDER BY
>filename, cat_metric desc, var_metric asc, category, var_name,
>var_val, id
>Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime:
>Everything is fine.
>Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime: Found 13 rows.
>Sep 15 13:23:51 DEBUG[28130] app_voicemail.c: VM Review Option disabled globally
>Sep 15 13:23:51 DEBUG[28130] app_voicemail.c: VM Operator break
>disabled globally
>Sep 15 13:23:51 DEBUG[28130] app_voicemail.c: VM CID Info before msg
>disabled globally
>Sep 15 13:23:51 DEBUG[28130] app_voicemail.c: Send Voicemail msg
>disabled globally
>Sep 15 13:23:51 DEBUG[28130] app_voicemail.c: ENVELOPE before msg
>enabled globally
>Sep 15 13:23:51 DEBUG[28130] app_voicemail.c: Duration info before msg
>enabled globally
>Sep 15 13:23:51 DEBUG[28130] app_voicemail.c: We are not going to skip
>to the next msg after save/delete
>
>
>But that's not what I have defined in my voicemail database:
>
>mysql->asterisk_vm->settings
>+----+------------+------------+-----------+----------------+----------+------------------+-----------------------------+
>| id | cat_metric | var_metric | commented | filename       | category
>| var_name         | var_val                     |
>+----+------------+------------+-----------+----------------+----------+------------------+-----------------------------+
>|  1 |          0 |          0 |         0 | voicemail.conf | default 
>| format           | wav|gsm                     |
>|  2 |          0 |          0 |         0 | voicemail.conf | default 
>| attach           | yes                         |
>|  3 |          0 |          0 |         0 | voicemail.conf | default 
>| pbxskip          | yes                         |
>|  4 |          0 |          0 |         0 | voicemail.conf | default 
>| serveremail      | vm at voip.xxxxxx.net       |
>|  5 |          0 |          0 |         0 | voicemail.conf | default 
>| fromstring       | xxxxxx Digital Voicemail |
>|  6 |          0 |          0 |         0 | voicemail.conf | default 
>| maxmessage       | 180                         |
>|  7 |          0 |          0 |         0 | voicemail.conf | default 
>| minmessage       | 5                           |
>|  8 |          0 |          0 |         0 | voicemail.conf | default 
>| maxsilence       | 5                           |
>|  9 |          0 |          0 |         0 | voicemail.conf | default 
>| silencethreshold | 128                         |
>| 10 |          0 |          0 |         0 | voicemail.conf | default 
>| skipms           | 3000                        |
>| 11 |          0 |          0 |         0 | voicemail.conf | default 
>| review           | yes                         |
>| 12 |          0 |          0 |         0 | voicemail.conf | default 
>| operator         | no                          |
>| 13 |          0 |          0 |         0 | voicemail.conf | default 
>| emailbody        | You have a new voicemail!   |
>+----+------------+------------+-----------+----------------+----------+------------------+-----------------------------+
>
>
>Any ideas?
>_______________________________________________
>--Bandwidth and Colocation sponsored by Easynews.com --
>
>Asterisk-Users mailing list
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>  
>