Re: [asterisk-users] Voicemail ODBC Storage
On Saturday, October 25, 2014 09:09:57 PM Dan Journo wrote: Is there any reason why ODBC voicemail storage requires varchar for most fields? For example, is there anything stopping me using a BIGINT or similar for origtime or INT for duration? It may cause you trouble when using PostgreSQL: https://issues.asterisk.org/jira/browse/ASTERISK-24441 -A -- Anthony - https://messinet.com/ - https://messinet.com/~amessina/gallery 8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E signature.asc Description: This is a digitally signed message part. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Voicemail ODBC Storage
Hi, Is there any reason why ODBC voicemail storage requires varchar for most fields? For example, is there anything stopping me using a BIGINT or similar for origtime or INT for duration? Kind regards, Dan -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC Storage
On Sat, Oct 25, 2014 at 4:09 PM, Dan Journo d...@keshercommunications.com wrote: Hi, Is there any reason why ODBC voicemail storage requires varchar for most fields? For example, is there anything stopping me using a BIGINT or similar for origtime or INT for duration? Yes. app_voicemail uses a message envelope file to hold the metadata regarding the voice mail. When the ODBC retrieve function pulls the database records, it writes that data out to a temporary message envelope file for playback/manipulation by other functions. This process does not examine the column types, but instead simply looks at the column names and writes the data values out to the file using the types that it expects each column name to have. So, changing those types will not work out well for you. -- Matthew Jordan Digium, Inc. | Engineering Manager 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at: http://digium.com http://asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] voicemail odbc Length is .....
I'm using voicemail ODBC with Asterisk 1.6.2.17.2. Why do I see Length is 186545 or something similar but a different number in Asterisk CLI everytime someone leaves a message? -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] voicemail odbc Length is .....
On 11 Apr 2011, at 15:28, vip killa wrote: I'm using voicemail ODBC with Asterisk 1.6.2.17.2. Why do I see Length is 186545 or something similar but a different number in Asterisk CLI everytime someone leaves a message? Because not all messages are the same length. I'd guess it's length in bytes?.. S -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] voicemail odbc Length is .....
indeed but why in console and the info is so limited, it doesn't say which message or anything...strange On Mon, Apr 11, 2011 at 10:31 AM, Steven Howes steve-li...@geekinter.netwrote: On 11 Apr 2011, at 15:28, vip killa wrote: I'm using voicemail ODBC with Asterisk 1.6.2.17.2. Why do I see Length is 186545 or something similar but a different number in Asterisk CLI everytime someone leaves a message? Because not all messages are the same length. I'd guess it's length in bytes?.. S -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] voicemail odbc Length is .....
_ From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of vip killa Sent: Monday, April 11, 2011 9:44 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] voicemail odbc Length is . indeed but why in console and the info is so limited, it doesn't say which message or anything...strange On Mon, Apr 11, 2011 at 10:31 AM, Steven Howes steve-li...@geekinter.net wrote: On 11 Apr 2011, at 15:28, vip killa wrote: I'm using voicemail ODBC with Asterisk 1.6.2.17.2. Why do I see Length is 186545 or something similar but a different number in Asterisk CLI everytime someone leaves a message? Because not all messages are the same length. I'd guess it's length in bytes?.. S [Danny Nicholas] WAG - you've got a high debug level on somewhere. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] voicemail odbc Length is .....
Apologies you were correct, i had debug on... Sorry... On Mon, Apr 11, 2011 at 10:45 AM, Danny Nicholas da...@debsinc.com wrote: -- *From:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *vip killa *Sent:* Monday, April 11, 2011 9:44 AM *To:* Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] voicemail odbc Length is . indeed but why in console and the info is so limited, it doesn't say which message or anything...strange On Mon, Apr 11, 2011 at 10:31 AM, Steven Howes steve-li...@geekinter.net wrote: On 11 Apr 2011, at 15:28, vip killa wrote: I'm using voicemail ODBC with Asterisk 1.6.2.17.2. Why do I see Length is 186545 or something similar but a different number in Asterisk CLI everytime someone leaves a message? Because not all messages are the same length. I'd guess it's length in bytes?.. S *[Danny Nicholas]* *WAG – you’ve got a high debug level on somewhere.* -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC
Yes, with isql it's working fine, I can see the database and all fields. On Sun, Jun 20, 2010 at 9:11 PM, Tilghman Lesher tles...@digium.com wrote: On Sunday 20 June 2010 13:15:11 Andraž wrote: If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers. Could also be that you're specifying the database name incorrectly. Are you able to see the tables when using the 'isql' command line tool? -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC
On Monday 21 June 2010 01:16:30 Andraž wrote: Yes, with isql it's working fine, I can see the database and all fields. On Sun, Jun 20, 2010 at 9:11 PM, Tilghman Lesher tles...@digium.com wrote: On Sunday 20 June 2010 13:15:11 Andraž wrote: If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers. Could also be that you're specifying the database name incorrectly. Are you able to see the tables when using the 'isql' command line tool? Did you remember to turn on pooling? TDS databases only support a single query per connection, thus connections may not be shared. Let's see your res_odbc.conf. Also, what version of Asterisk are you using? -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC
Now it's workin fine. It was problem with drivers, because it doesn't support all kind of fields. I just changed from varblog to picture data type and now it's working fine. Tnx for help. On Mon, Jun 21, 2010 at 2:08 PM, Tilghman Lesher tles...@digium.com wrote: On Monday 21 June 2010 01:16:30 Andraž wrote: Yes, with isql it's working fine, I can see the database and all fields. On Sun, Jun 20, 2010 at 9:11 PM, Tilghman Lesher tles...@digium.com wrote: On Sunday 20 June 2010 13:15:11 Andraž wrote: If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers. Could also be that you're specifying the database name incorrectly. Are you able to see the tables when using the 'isql' command line tool? Did you remember to turn on pooling? TDS databases only support a single query per connection, thus connections may not be shared. Let's see your res_odbc.conf. Also, what version of Asterisk are you using? -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC
On Saturday 19 June 2010 08:35:47 Zeeshan Zakaria wrote: On 2010-06-19 9:10 AM, Andraž atle...@gmail.com wrote: Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I receive different error, I can't insert into database. [Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT INTO pbx_VoiceMail (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailb oxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)] [Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: Connecting sqlserver [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] Seems to me that the SQL statement is not complete and asterisk is complaining about it. Do you prepare this statement in your dialplan or asterisk makes it automatically? What, specifically, do you think is not complete about this prepare statement? The only error that I can guess at is that the table pbx_VoiceMail does not have all of the columns listed in the statement. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC
If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers. On Sun, Jun 20, 2010 at 7:13 PM, Tilghman Lesher tles...@digium.com wrote: On Saturday 19 June 2010 08:35:47 Zeeshan Zakaria wrote: On 2010-06-19 9:10 AM, Andraž atle...@gmail.com wrote: Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I receive different error, I can't insert into database. [Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT INTO pbx_VoiceMail (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailb oxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)] [Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: Connecting sqlserver [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] Seems to me that the SQL statement is not complete and asterisk is complaining about it. Do you prepare this statement in your dialplan or asterisk makes it automatically? What, specifically, do you think is not complete about this prepare statement? The only error that I can guess at is that the table pbx_VoiceMail does not have all of the columns listed in the statement. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC
On Sunday 20 June 2010 13:15:11 Andraž wrote: If I use MySQL with the same fields it's working fine. I think that is something wrong with FreeTDS drivers. Could also be that you're specifying the database name incorrectly. Are you able to see the tables when using the 'isql' command line tool? -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Voicemail ODBC
I have Asterisk 1.4.32 and I would like save all VoiceMail to MSSQL 2008 database. I configured ODBC, but I receive this errors. [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: Connecting sqlserver [Jun 18 14:00:37] NOTICE[19914] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] [Jun 18 14:00:37] WARNING[19914] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk/voicemail/default/390/INBOX'] [Jun 18 14:00:37] WARNING[19914] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 18 14:00:37] WARNING[19914] res_odbc.c: Unable to deallocate database handle? 0 errno=0 [unixODBC][Driver Manager]Function sequence error I have configured in voicemail.conf [general] format=wav49 odbcstorage=sqlserver odbctable=pbx_VoiceMail odbc.ini [kupalaodbc] Description = ODBC connection Driver = ms-sql Servername = ms-sql UID = TestDatabaseDemo database= TestDatabaseDemo Port= 1364 odbcinst.ini [ms-sql] Description = TDS connection Driver = /usr/lib/odbc/libtdsodbc.so Setup = /usr/lib/odbc/libtdsS.so UsageCount = 1 FileUsage = 1 freetds.conf [ms-sql] host = 192.168.1.10 port = 1364 tds version = 8.0 dump file = /var/log/freetds.log I reloaded module and restarted asterisk also, but with no success. What can be wrong? Regards Andraž -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Voicemail ODBC
Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I receive different error, I can't insert into database. [Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT INTO pbx_VoiceMail (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)] [Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: Connecting sqlserver [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC
Seems to me that the SQL statement is not complete and asterisk is complaining about it. Do you prepare this statement in your dialplan or asterisk makes it automatically? Zeeshan A Zakaria -- www.ilovetovoip.com On 2010-06-19 9:10 AM, Andraž atle...@gmail.com wrote: Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I receive different error, I can't insert into database. [Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT INTO pbx_VoiceMail (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)] [Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: Connecting sqlserver [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC
Asterisk make it. It is in app_voicemail, I'm using voicemail ODBC. On Sat, Jun 19, 2010 at 3:35 PM, Zeeshan Zakaria zisha...@gmail.com wrote: Seems to me that the SQL statement is not complete and asterisk is complaining about it. Do you prepare this statement in your dialplan or asterisk makes it automatically? Zeeshan A Zakaria -- www.ilovetovoip.com On 2010-06-19 9:10 AM, Andraž atle...@gmail.com wrote: Ok, this issue I resolved, I just changed the TDS version to 7.0. But now I receive different error, I can't insert into database. [Jun 19 14:30:25] WARNING[6212] app_voicemail.c: SQL Prepare failed![INSERT INTO pbx_VoiceMail (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext) VALUES (?,?, ? , ?,?,?,?,?,?,?)] [Jun 19 14:30:25] WARNING[6212] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: Connecting sqlserver [Jun 19 14:30:25] NOTICE[6212] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] voicemail /odbc problem
Hi, I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Back end database DB2 Database name voiceml Tables created on server AST_CDR AST_CONFIG VOICEMESSAGES I've checked the unix ODBC side of things and I can connect to the DB2 database o.k. I've set up cdr_odbc.conf [global] dsn=voiceml username=usernme password=password loguniqueid=yes dispositionstring=yes table=ast_cdr ;cdr is default table name usegmtime=yes ; set to yes to log in GMT res_odbc.conf odbcstorage = voiceml [voiceml] enabled = yes dsn = voiceml username = userid password = password pre-connect = yes in extconfig.conf I've got [settings] ; voicemail = odbc,voiceml musiconhold.conf = odbc,voiceml,ast_config I've set up an IAX2 test user called [odbc_test_user] type=friend secret=supersecret context=odbc_vm_test host=dynamic qualify=yes disallow=all allow=ulaw allow=gsm and a context of [odbc_vm_test] exten = 100,1,Voicemail(88...@default);leave a message exten = 200,1,VoicemailMain(88...@default) ; retrieve a mail message When I connect from my MAC using zoiper and call extension 100 I can leave a voicemail message. Looking in /var/log/asterisk/full I get [Jan 7 21:58:34] DEBUG[7257] pbx.c: Launching 'VoiceMail' [Jan 7 21:58:34] VERBOSE[7257] logger.c: -- Executing [...@odbc_vm_test:1] VoiceMail(IAX2/odbc_test_use r-8660, 88...@default) in new stack [Jan 7 21:58:34] DEBUG[7257] chan_iax2.c: Answering IAX2 call [Jan 7 21:58:34] DEBUG[7257] devicestate.c: Notification of state change to be queued on device/channel IAX2 /odbc_test_user [Jan 7 21:58:34] DEBUG[7204] chan_iax2.c: Checking device state for device odbc_test_user [Jan 7 21:58:34] DEBUG[7204] chan_iax2.c: iax2_devicestate: Found peer. What's device state of odbc_test_use r? addr=57011606, defaddr=0 maxms=2000, lastms=41 [Jan 7 21:58:34] DEBUG[7204] devicestate.c: Changing state for IAX2/ odbc_test_user - state 2 (In use) [Jan 7 21:58:34] DEBUG[7257] app_voicemail.c: Before find_user [Jan 7 21:58:34] DEBUG[7230] app_queue.c: Device 'IAX2/ odbc_test_user' changed to state '2' (In use) but we don't care because they're not a member of any queue. [Jan 7 21:58:34] VERBOSE[7257] logger.c: -- IAX2/ odbc_test_user-8660 Playing 'vm-intro' (language 'en' ) [Jan 7 21:58:34] DEBUG[7234] chan_iax2.c: Ooh, voice format changed to 4 [Jan 7 21:58:40] DEBUG[7257] app.c: Locked path '/var/spool/asterisk/ voicemail/default/8/INBOX' [Jan 7 21:58:40] DEBUG[7257] app.c: Unlocked path '/var/spool/ asterisk/voicemail/default/8/INBOX' [Jan 7 21:58:40] VERBOSE[7257] logger.c: -- IAX2/ odbc_test_user-8660 Playing 'beep' (language 'en') [Jan 7 21:58:40] VERBOSE[7257] logger.c: -- Recording the message [Jan 7 21:58:40] DEBUG[7257] app.c: play_and_record: None, /var/ spool/asterisk/voicemail/default/8/tmp /Ob6NSJ, 'wav49' [Jan 7 21:58:40] DEBUG[7257] app.c: Recording Formats: sfmts=wav49 [Jan 7 21:58:40] VERBOSE[7257] logger.c: -- x=0, open writing: / var/spool/asterisk/voicemail/default/88 888/tmp/Ob6NSJ format: wav49, 0x1c1bd0f8 [Jan 7 21:58:40] DEBUG[7240] chan_iax2.c: Peer odbc_test_user: got pong, lastms 41, historicms 41, maxms 200 0 [Jan 7 21:59:12] VERBOSE[7257] logger.c: -- User hung up [Jan 7 21:59:12] DEBUG[7257] app.c: Locked path '/var/spool/asterisk/ voicemail/default/8/INBOX' [Jan 7 21:59:12] DEBUG[7257] app.c: Unlocked path '/var/spool/ asterisk/voicemail/default/8/INBOX' user-8660' 2/odbc_test_user-8660' [Jan 7 21:59:12] DEBUG[7257] channel.c: Soft-Hanging up channel 'IAX2/ odbc_test_user-8660' [Jan 7 21:59:12] DEBUG[7257] channel.c: Hanging up channel 'IAX2/ odbc_test_user-8660' [Jan 7 21:59:12] DEBUG[7257] chan_iax2.c: We're hanging up IAX2/ odbc_test_user-8660 now... [Jan 7 21:59:12] DEBUG[7257] chan_iax2.c: Really destroying IAX2/ odbc_test_user-8660 now... [Jan 7 21:59:12] VERBOSE[7257] logger.c: -- Hungup 'IAX2/ odbc_test_user-8660' /odbc_test_user I can call the asterisk server an listen to the voicemail message but there's nothing in the database voicemessages table. I've enabled unixODBC logging and although I can see log entries accessing the AST_CONFIG and AST_CDR tables, there's nothing accessing the voicemessages table. Any idea where I can look next? TIA Alex Checked by Hu-fw-yhman ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] voicemail /odbc problem
On Thursday 07 January 2010 16:20:38 Alex Sharaz wrote: I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Voicemail is kind of tricky. While it does use realtime for the storage of user mailbox settings, it does not use realtime for the storage of messages themselves. To do this, you'll need to run 'make menuselect' in the build directory, then, in the Voicemail Options section, enable ODBC_STORAGE, then recompile and reinstall (only the app_voicemail.so and app_directory.so modules). You'll also need to configure the odbc storage mechanism in voicemail.conf, specifically odbcstorage and odbctable. I agree that this is somewhat non-intuitive, so we may change this in the future to make it configurable at runtime, rather than an option at buildtime. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com www.asterisk.org ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Voicemail ODBC storage table schema
Hello, Upgraded from 1.6.1.0 to 1.6.1.1 and my voicemail setup does not work anymore. I use ODBC storage for voicemail. Comes out that the voicemessages table schema should have changed, because the log says Asterisk needed to store data to an additional field called flag. Any new message cannot be saved. The thing is that I'd like to know where I can find an updated schema for the generic voicemail storage table. Apparently, only the flag field has appeared, but I can't find out what is the type of the field. Here are the fields it's trying to update : [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailboxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)] I had to roll back to 1.6.1.0 in the meantime. Thanks. Hoggins! ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC storage table schema
On Friday 17 July 2009 16:25:13 Hoggins! wrote: Hello, Upgraded from 1.6.1.0 to 1.6.1.1 and my voicemail setup does not work anymore. I use ODBC storage for voicemail. Comes out that the voicemessages table schema should have changed, because the log says Asterisk needed to store data to an additional field called flag. Any new message cannot be saved. The thing is that I'd like to know where I can find an updated schema for the generic voicemail storage table. Apparently, only the flag field has appeared, but I can't find out what is the type of the field. Here are the fields it's trying to update : [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailb oxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)] I had to roll back to 1.6.1.0 in the meantime. Oops. It's now documented in UPGRADE.txt and the table schema is in doc/tex/odbcstorage.tex (which is rendered into the PDF at release). -- Tilghman Teryl with Peter, Cottontail, Midnight, Thumper, Johnny (bunnies) and Harry, BB, George (dogs) ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Voicemail ODBC storage table schema
Thanks, problem solved. Hoggins! Tilghman Lesher a écrit : On Friday 17 July 2009 16:25:13 Hoggins! wrote: Hello, Upgraded from 1.6.1.0 to 1.6.1.1 and my voicemail setup does not work anymore. I use ODBC storage for voicemail. Comes out that the voicemessages table schema should have changed, because the log says Asterisk needed to store data to an additional field called flag. Any new message cannot be saved. The thing is that I'd like to know where I can find an updated schema for the generic voicemail storage table. Apparently, only the flag field has appeared, but I can't find out what is the type of the field. Here are the fields it's trying to update : [INSERT INTO voicemessages (dir,msgnum,recording,context,macrocontext,callerid,origtime,duration,mailb oxuser,mailboxcontext,flag) VALUES (?,?,?,?,?,?,?,?,?,?,?)] I had to roll back to 1.6.1.0 in the meantime. Oops. It's now documented in UPGRADE.txt and the table schema is in doc/tex/odbcstorage.tex (which is rendered into the PDF at release). ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] voicemail odbc storage
Hi, I was able to store voicemail following the tutorial http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage i would just like to inquire how can i create a web interface (will use php) to play the voicemail stored in the database. the field in the database is recording longblob anyone able to retrieve that file and play on an embedded player on a webpage? Thank You Regards Nhadie ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] voicemail odbc storage
On Tue, 2008-04-15 at 16:22 +0800, nhadie ramos wrote: i would just like to inquire how can i create a web interface (will use php) to play the voicemail stored in the database. This really isn't the proper venue for that type of question... but searching Google for PHP BLOB returns a large number of hits, and several of the ones I looked at showed very good instructions on how to get a BLOB from the database via PHP code. the field in the database is recording longblob anyone able to retrieve that file and play on an embedded player on a webpage? I've seen it done many times before. The secret here is to find a good embedded media player and make sure the audio file is in the correct format. -- Jared Smith Community Relations Manager Digium, Inc. ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Voicemail ODBC bug or feature?
Hi All, When the message is sent notification is emailed before it's inserted into the database. So if there's some database problem user gets notification but not the actual voicemail. Is this behavior correct? ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[Asterisk-Users] Voicemail ODBC storage and realtime
Using Asterisk-1.2.0, I have voicemail messages stored in a MySQL database with ODBC. I am using a database to store certain config files, such as sip.conf, via Realtime Static. Since you must define the variable odbcstorage in the voicemail.conf file to allow ODBC storage to work, what do you do if you want to store the voicemail accounts via realtime (not static) and have no voicemail.conf file.l. Do you still use the voicemail.conf file and just define all of the mailboxes via Realtime? I tried this, but for some reason, I could not get asterisk to query the mysql database for the mailbox info. If I defined the mailbox in the voicemail.conf as usual, all was OK Thanks.. ___ --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
[Asterisk-Users] voicemail ODBC storage question
Hello guys. Did anybody use voicemail ODBC storage feature? All voicemessages fields name are clear except for dir, which is assigned to /var/spool/asterisk/voicemail/default/1234/INBOX. Why do we need any directory when we store voicemessages in the database? Noreover, that field is choosen as the KEY or INDEX (marked as MUL in README.odbcsrorage, so I coulnd't say definitely what's that). Why? Much thanks. -- Best regards, Timur Elzhov ___ 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
