Re: [asterisk-users] Voicemail ODBC Storage

2014-10-26 Thread Anthony Messina
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:

Re: [asterisk-users] Voicemail ODBC Storage

2014-10-25 Thread Matthew Jordan
On Sat, Oct 25, 2014 at 4:09 PM, Dan Journo 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 envelop

[asterisk-users] Voicemail ODBC Storage

2014-10-25 Thread Dan Journo
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 -- _ -- Bandwi

Re: [asterisk-users] Voicemail ODBC storage table schema

2009-07-17 Thread Hoggins!
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 sc

Re: [asterisk-users] Voicemail ODBC storage table schema

2009-07-17 Thread Tilghman Lesher
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

[asterisk-users] Voicemail ODBC storage table schema

2009-07-17 Thread Hoggins!
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 cann

Re: [asterisk-users] voicemail odbc storage

2008-04-15 Thread Jared Smith
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

[asterisk-users] voicemail odbc storage

2008-04-15 Thread nhadie ramos
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

[Asterisk-Users] Voicemail ODBC storage and realtime

2005-11-18 Thread Edwin Horton
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

[Asterisk-Users] voicemail ODBC storage question

2005-07-27 Thread Timur V. Elzhov
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 choo