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

[RR]

Hi Dmitry

Thanks for that. Yes, I had done all of that and have a working Asterisk <-> MS SQL setup where I have a view for the voicemail.conf settings in my database + I have a separate table called 'voicemessages' to store my voicemails. What I wanted to know was that if I have got this far with Release 1.2.9.1, do I need any more patches OR bug fixes that I need to apply to 1.2.9.1 to avoid the FreeTDS issue? What about the settings mentioned in Issue: 5756 by 'kryptolus' to have 
pooled => yes
poolsize => 10 (or whatever)

to your res_odbc.conf ? Do I need this? 

Also, is this stable? The usage of ODBC storage to store voicemails? Are you running this in production?

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 7:50 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] performance & reliabulity of asterisk voicemail using odbc storage


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.