VoIP Mailing List Archives

[pronek at gmail.com]

Hi,


I have some issue with voice mail with ODBC on asterisk 11.7 box. I may not understand database functionality on asterisk fully. The most suspected area is func_odbc. I already googled but not luck. Your guide is warmly welcomed

Error messages when I make call and leave message.


-- <SIP/1ffa9-00000007> Playing 'auth-thankyou.g722' (language 'en')
[2014-05-28 14:55:13] DEBUG[12260][C-00000006]: app_voicemail.c:3824 last_message_index: Directory '/var/spool/asterisk/voicemail/default/701/INBOX' has no messages and therefore no index was retrieved.
  == Parsing '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found
[2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4086 insert_data_cb: SQL Direct Execute failed!
[2014-05-28 14:55:13] WARNING[12260][C-00000006]: res_odbc.c:608 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]...
[2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4086 insert_data_cb: SQL Direct Execute failed!
[2014-05-28 14:55:13] WARNING[12260][C-00000006]: app_voicemail.c:4202 store_file: SQL Execute error!
[INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag,msg_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)]

  == Parsing '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found
  == Parsing '/var/spool/asterisk/voicemail/default/701/INBOX/msg0000.txt': Found
    -- Auto fallthrough, channel 'SIP/1ffa9-00000007' status is 'NOANSWER'


Dialplan Configuration

[internal]

exten => 701,1,Dial(SIP/ffbb,17,tT)
        same => n,VoiceMail(${EXTEN}@default,u)

exten => 702,1,Dial(SIP/xlite-1,17,tT)
        same => n,VoiceMail(${EXTEN}@default,u)

exten => 703,1,Dial(SIP/ffa9,17,tT)
        same => n,VoiceMail(${EXTEN}@default,u)



Voicemail Configuration

[general]

format=wav49|wav

attach=yes

maxmsg=999

maxsecs=600!

minsecs= 3

skipms=3000

maxlogins=3

odbcstorage=asterisk

odbctable=voicemessages

emailbody=Dear ${VM_NAME}:\n\n\tjust wanted to let you know you were just ${IF($["${VM_CIDNUM}" = "${ORIG_VM_CIDNUM}"]?left:forwarded)} a ${VM_DUR} long message (number ${VM_MSGNUM})\nin mailbox ${VM_MAILBOX} from ${VM_CALLERID}, on ${VM_DATE},\n${IF($["${VM_CIDNUM}" = "${ORIG_VM_CIDNUM}"]?so:(originally sent by ${ORIG_VM_CALLERID} on ${ORIG_VM_DATE})\nso)} you might want to check it when you get a chance.  Thanks!\n\n\t\t\t\t--Asterisk\n
emaildateformat=%A, %B %d, %Y at %r
pagerdateformat=%A, %B %d, %Y at %r
tz=me                   ; Timezone from zonemessages below. Irrelevant if envelope=no.

eastern=America/New_York|'vm-received' Q 'digits/at' IMp
central=America/Chicago|'vm-received' Q 'digits/at' IMp
central24=America/Chicago|'vm-received' q 'digits/at' H N 'hours'
military=Zulu|'vm-received' q 'digits/at' H N 'hours' 'phonetic/z_p'
european=Europe/Copenhagen|'vm-received' a d b 'digits/at' HMi
me=Asia/Dubai|'vm-received' Q 'digit/at' H N 'hours'

[default]

;1234 => 4242,Example Mailbox,root@localhost
701 => -7012,User One,pronekker@gmail.com (pronekker@gmail.com)
702 => -7023,Soft Phone,sp@localhost
703 => -7034,Pro Nek,pronek@gmail.com (pronek@gmail.com)






res_odbc Configuration


[asterisk]
enabled => yes
dsn => asterisk-connector
username => thet
password => MyPassword
pooling => 1
limit => 5
pre-connect => yes


func_odbc Configuration


[SQL]
dsn=mysql1,asterisk
readsql=${ARG1}

; ODBC_ANTIGF - A blacklist.
[ANTIGF]
dsn=mysql1,mysql2   ; Use mysql1 as the primary handle, but fall back to mysql2
                    ; if mysql1 is down.  Supports up to 5 comma-separated
                    ; DSNs.  "dsn" may also be specified as "readhandle" and
                    ; "writehandle", if it is important to separate reads and
                    ; writes to different databases.
readsql=SELECT COUNT(*) FROM exgirlfriends WHERE callerid='${SQL_ESC(${ARG1})}'
syntax=<callerid>
synopsis=Check if a specified callerid is contained in the ex-gf database

; ODBC_PRESENCE - Retrieve and update presence
[PRESENCE]
dsn=mysql1
readsql=SELECT location FROM presence WHERE id='${SQL_ESC(${ARG1})}'
writesql=UPDATE presence SET location='${SQL_ESC(${VAL1})}' WHERE id='${SQL_ESC(${ARG1})}'


voicemail show command


abox*CLI> voicemail show users
You must specify a specific context to show users from realtime!
Usage: voicemail show users [for <context>]
       Lists all mailboxes currently set up
abox*CLI>




extconfig Configuration file


voicemail =>mysql,asterisk,voicemessages


I create table voicemessages in mysql exactly as description in Definitive Guide 4th edition book.

[rnewton at digium.com]

On Thu, May 29, 2014 at 3:33 AM, ProNek <pronek@gmail.com> wrote:

[pronek at gmail.com]

Hi Rusty,


Noted with thanks.


Regards,

Thet Tun



On Thu, May 29, 2014 at 5:09 PM, Rusty Newton <rnewton@digium.com (rnewton@digium.com)> wrote: