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:

[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 -- _ --

Re: [asterisk-users] Voicemail ODBC Storage

2014-10-25 Thread Matthew Jordan
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

[asterisk-users] voicemail odbc Length is .....

2011-04-11 Thread vip killa
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

Re: [asterisk-users] voicemail odbc Length is .....

2011-04-11 Thread Steven Howes
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

Re: [asterisk-users] voicemail odbc Length is .....

2011-04-11 Thread vip killa
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

Re: [asterisk-users] voicemail odbc Length is .....

2011-04-11 Thread Danny Nicholas
_ 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

Re: [asterisk-users] voicemail odbc Length is .....

2011-04-11 Thread 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

Re: [asterisk-users] Voicemail ODBC

2010-06-21 Thread Andraž
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

Re: [asterisk-users] Voicemail ODBC

2010-06-21 Thread Tilghman Lesher
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

Re: [asterisk-users] Voicemail ODBC

2010-06-21 Thread Andraž
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

Re: [asterisk-users] Voicemail ODBC

2010-06-20 Thread Tilghman Lesher
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:

Re: [asterisk-users] Voicemail ODBC

2010-06-20 Thread Andraž
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

Re: [asterisk-users] Voicemail ODBC

2010-06-20 Thread Tilghman Lesher
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?

[asterisk-users] Voicemail ODBC

2010-06-19 Thread Andraž
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]

[asterisk-users] Voicemail ODBC

2010-06-19 Thread Andraž
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

Re: [asterisk-users] Voicemail ODBC

2010-06-19 Thread Zeeshan Zakaria
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,

Re: [asterisk-users] Voicemail ODBC

2010-06-19 Thread Andraž
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

[asterisk-users] voicemail /odbc problem

2010-01-07 Thread Alex Sharaz
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

Re: [asterisk-users] voicemail /odbc problem

2010-01-07 Thread Tilghman Lesher
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

[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 cannot

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 to an

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 schema should

[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

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 bug or feature?

2008-04-12 Thread Sergey Chernyavskiy
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

[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

[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 choosen