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:
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
--
_
--
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
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
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
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
_
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
*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
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
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
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
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:
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
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?
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]
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
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,
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
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
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
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
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
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
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
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
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
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
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
28 matches
Mail list logo