[Asterisk-Users] performance & reliabulity of asterisk voicemail using odbc storage

[Dmitry Furmanov]

Oh! I'm sorry.  :*)

You are right - it's about freeTDS problem. Just for case of the MS SQL 
storage usage.

You need to configure the Asterisk and unixODBC. Read, please next 
listed articles:
http://www.asteriskguru.com/tutorials/realtime_pgsql.html  (it's for 
Postgre SQL. You need use driver of your selected DB service appropriate 
ODBC driver)

STORAGE SIDE CONFIGURATION
Configuration of the table (my case - MS SQL):
/* Voicemail storage creating*/
CREATE TABLE asterisk.dbo.voicemessages
(
  id int IDENTITY NOT NULL,

  msgnum bigint DEFAULT NULL,
  dir varchar(80) DEFAULT NULL,
  context varchar(80) DEFAULT NULL,
  macrocontext varchar(80) DEFAULT NULL,
  callerid varchar(40) DEFAULT NULL,
  origtime varchar(40) DEFAULT NULL,
  duration varchar(20) DEFAULT NULL,
  mailboxuser varchar(80) DEFAULT NULL,
  mailboxcontext varchar(80) DEFAULT NULL,
  recording image DEFAULT NULL,
PRIMARY KEY (id, dir)
);

/*And grant all access to this table to your asterisk ODBC user (must be 
previously created)
In my case it's "asterisk" */

GRANT ALL ON asterisk.dbo.voicemessages TO asterisk;
Syntax:
GRANT ALL ON <DB name>.dbo.<table name> TO asterisk;
<DB name>, <table name> can be configured on the Asterisk-server side

read "doc\README.odbcstorage" file from Asterisk source for details of 
the Voicemail configuration.
And don't forget uncomment the lines:

CFLAGS+=-DUSE_ODBC_STORAGE
CFLAGS+=-DEXTENDED_ODBC_STORAGE
inside apps\Makefile  of the Asterisk sources before rebuild and 
reinstall the asterisk with voicemail DB storage support.

Regards,
Dmitry V.Furmanov.



> Hi Dmitry,
> 
> Thanks so much for replying, I had a read of the bug descriptions you pointed to but unfortunately am not a programmer so have a bit of a struggle following the entire discussion. I actually AM using 1.2.9.1. So does that mean that I should be OK and do not need any patches as this release has all of them, or does it mean that I still need to apply some patch that's in issue: 5756? Also, I do not know how to apply patches, can you help? 
> 
> These bug reports also seem to mention issues that you seem to have with FreeTDS and those issues are resolved by configuring connection pooling. Is this what this particular patch fixed?
> 
> Thanks,
> \R
> 
> -----Original Message-----
> From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Dmitry Furmanov
> Sent: Monday, July 03, 2006 6:15 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] performance & reliabulity of asterisk voicemail using odbc storage
> 
> Hi, RR:
> 
> Asterisk 1.2.1 with listed in
> http://bugs.digium.com/bug_view_page.php?bug_id=5756
> patch have some problems with voicemail storage, but that problems already fixed in the more newer version.
> I'll advice you to try using 1.2.9.1 version with the same patch that I'd applied to it (see http://bugs.digium.com/view.php?id=7451 )
> 
> I guess that other voicemail DB storage configuration is known for you.
> 
> Regards,
> Dmitry V.Furmanov
> 
> 
>> Hello all,
>>
>> Newbie here, been searching the net to follow the development and 
>> feedback on the 1.2 release feature with using an odbc storage for 
>> storing the voicemail messages etc.? Have many people 
>> implemented/tried this? Any feedback? Is this better than using a 
>> clustered file system such as GFS or PVFS etc? I was going to 
>> implement the storage using GFS but if I can do it reliably with 
>> storing them in a database then maybe it's better? I don't know much 
>> about storage or databases so not sure if storing in a clustered 
>> database which is connected to a SAN via high-performance HBAs is better than using a clustered file system.
>>
>> Any comments about all of this vis-à-vis reliability of the 
>> implementation of odbc storage feature in asterisk + comments about DB 
>> storage better/worse than a clustered file-system would be greatly appreciated.
>>
>> Thank you all,
>> \R
>>
>>
>>
>>
>> _______________________________________________
>> --Bandwidth and Colocation provided by Easynews.com --
>>
>> Asterisk-Users mailing list
>> To UNSUBSCRIBE or update options visit:
>>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> Asterisk-Users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> Asterisk-Users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users