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:
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
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
illa
> *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 m
_
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 "Leng
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 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 18
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
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://
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 wrote:
> On Monday 21 June 2010 01:16:30 Andraž 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 wrote:
> > On Sunday 20 June 2010 13:15:11 Andraž wrote:
> > > If I use MySQL with the same fields it's working fine. I thin
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 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.
>
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
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 wrote:
> On Saturday 19 June 2010 08:35:47 Zeeshan Zakaria wrote:
> > On 2010-06-19 9:10 AM, "Andraž" wrote:
> >
> > Ok, this issue I res
On Saturday 19 June 2010 08:35:47 Zeeshan Zakaria wrote:
> On 2010-06-19 9:10 AM, "Andraž" 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 Prepar
Asterisk make it. It is in app_voicemail, I'm using voicemail ODBC.
On Sat, Jun 19, 2010 at 3:35 PM, Zeeshan Zakaria 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 automatic
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ž" wrote:
Ok, this issue I resolved, I just changed
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,ma
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]
[Ju
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
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
use
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
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
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
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,
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
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 Provide
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
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
28 matches
Mail list logo