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

[Dmitry Furmanov]

Ok, you use the MS SQL. It's problem of FreeTDS implementation details.

1. Did you install FreeTDS or other ODBC driver to MS SQL(Sybase)
connecting?

2. Did you configure unixODBC to use freeTDS driver (etc\odbc.ini,
etc\odbcinst.ini)?

3. APPLY the patch that I tell you before
( http://bugs.digium.com/view.php?id=7451 )

4. Rebuild and reinstall the Asterisk

Then asterisk will be be able to react on the ODBC configuration 
parameters "pooled" and "poolsize".

Regards,
Dmitry V.Furmanov


> 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.
> 
> _______________________________________________
> --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