Matt
2005-Sep-15 10:42 UTC
[Asterisk-Users] Can not get realtime static voicemail.conf to work
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@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?
Matt Gibson
2005-Sep-15 12:28 UTC
[Asterisk-Users] Can not get realtime static voicemail.conf to work
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@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@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 > >